[L]Status[/L] |
[L]SKU[/L] |
[L]Name[/L] |
[L]Qty[/L] |
[L]Unit Price[/L] |
[L]Total[/L] |
[query list=1 table=orderline sql="select * from orderline where order_number = '[loop-code]'" ignore_undefined=1]
[page href="admin/order_status"
form="order=[loop-code]"
]
[display table=orderline
column=status
key="[sql-code]"
type=display
]
[calc]
$total_weight += ([field field=weight key="[sql-param sku]"] + 0 || 0) * [sql-data orderline quantity];
return;
[/calc]
| [sql-param sku] |
[sql-filter 30.][sql-param description][/sql-filter]
[if-sql-param size]
[L]Size[/L]: [sql-param size]
[/if-sql-param]
[if-sql-param color]
[L]Color[/L]: [sql-param color]
[/if-sql-param]
[if-sql-param options]
[L]Options[/L]: [sql-param options]
[/if-sql-param]
[if-sql-param sku eq giftcert]
Gift certificate redemption link
[/if-sql-param]
|
[sql-param quantity] |
[currency][sql-param price][/currency] |
[currency][sql-param subtotal][/currency] |
[if-sql-param separate_address]
|
SHIP TO: [calc]
my $ad = q{[sql-param separate_address]}; $ad =~ s/\s*\n+\s*/ * /g; return $ad;
[/calc]
|
|
[/if-sql-param]
[/query]
 |
 |
[L]Item Total[/L]: |
[currency][loop-data transactions subtotal][/currency] |
[loop-data transactions comments] |
[L]Tax[/L]: |
[currency][loop-data transactions salestax][/currency] |
[L]Total Weight[/L]: |
[calc]$total_weight[/calc] |
[if-loop-data transactions handling > 0]
[L]Handling[/L] |
[currency][loop-data transactions handling][/currency] |
[/if-loop-data]
[L]Shipping[/L] |
[currency][loop-data transactions shipping][/currency] |
[if-loop-data transactions pay_cert_total]
[L]GRAND TOTAL:[/L] |
[currency][loop-data transactions pay_cert_ord_total][/currency] |
[L]Gift Certificate[/L]: |
[currency][loop-data transactions pay_cert_total][/currency] |
[L]CHARGED:[/L] |
[currency][loop-data transactions total_cost][/currency] |
[else]
[L]GRAND TOTAL:[/L] |
[currency][loop-data transactions total_cost][/currency] |
[/else]
[/if-loop-data]