[set page_title][L]Order manager[/L]: [L]View order[/L][/set] [set ui_class]Orders[/set] [set page_banner][L]View order[/L][/set] [set help_name]order.view[/set] [set icon_name]icon_orders.gif[/set] @_UI_STD_HEAD_@ [calc] delete $Scratch->{ui_bounce}; return if $CGI->{order}; $CGI->{order} = $CGI->{mv_arg} or $Scratch->{ui_bounce} = '__UI_BASE__/order'; return; [/calc] [if scratch ui_bounce] [bounce page="[scratch ui_bounce]"] [/if] [if scratch ui_message]
[scratch ui_message] [set ui_message][/set]

  [/if] [update values] [perl tables=country]### pre-open database for calcs below[/perl] [loop list="[value-extended order]"] [if-loop-data transactions affiliate] [/if-loop-data] [query st=db sql="select * from orderline where order_number = '[loop-data transactions order_number]'" list=1] [/query]
[L]Order number[/L]: [loop-code] [L]Order date[/L]: [convert-date][loop-data transactions order_date][/convert-date]
[L]Customer[/L]: [if-loop-data transactions username] [loop-data transactions fname] [loop-data transactions lname] [else] [loop-data transactions fname] [loop-data transactions lname] [/else] [/if-loop-data]
[L]Affiliate[/L]: [data table=affiliate column=name key="[loop-data transactions affiliate]"]
[L]Company[/L]: [loop-data transactions company]
[L]Home phone[/L]: [loop-data transactions phone_night]
[L]Work phone[/L]: [loop-data transactions phone_day]
[L]Email[/L]: [loop-data transactions email]
[L]Payment type[/L]: [loop-data transactions payment_method]
[set bill_address] [loop-data transactions b_fname] [loop-data transactions b_lname]
[loop-data transactions b_address1]
[if-loop-data transactions b_address2] [loop-data transactions b_address2]
[/if-loop-data] [loop-data transactions b_city], [loop-data transactions b_state] [loop-data transactions b_zip]
[loop-calc] my $c = q{[loop-data transactions b_country]}; return if '__SHIP_DEFAULT_COUNTRY__' eq $c; my $name = tag_data('country', 'name', $c); return qq{$name ($c)
}; [/loop-calc] [/set] [set ship_address] [loop-data transactions fname] [loop-data transactions lname]
[loop-data transactions address1]
[if-loop-data transactions address2] [loop-data transactions address2]
[/if-loop-data] [loop-data transactions city], [loop-data transactions state] [loop-data transactions zip]
[loop-calc] my $c = q{[loop-data transactions country]}; return if '__SHIP_DEFAULT_COUNTRY__' eq $c; my $name = tag_data('country', 'name', $c); return qq{$name ($c)
}; [/loop-calc] [/set]

[if-loop-data transactions username] [L]Bill To[/L]: [else] [L]Bill To[/L]: [/else] [/if-loop-data]

[if-loop-data transactions b_address1] [scratch bill_address] [else] [scratch ship_address] [/else] [/if-loop-data]
[if-loop-data transactions username] [L]Ship To[/L]: [else] [L]Ship To[/L]: [/else] [/if-loop-data]
[scratch ship_address]

[L]Status[/L]: [page href=__UI_BASE__/order_status form="order=[loop-code]"] [display table=transactions column=status key="[loop-code]" arbitrary=order_view ] [set bill_address][/set] [set ship_address][/set]

[L]Status[/L] [L]Name[/L] [L]SKU[/L] [L]Qty.[/L] [L]Each[/L] [L]Discount[/L] [L]Total[/L]
[calc] $total_weight += ([field field=weight key="[sql-param sku]"] + 0 || 0) * [sql-data orderline quantity]; return; [/calc] [sql-filter loc upper][sql-data orderline status][/sql-filter]
 
[either][sql-data orderline description][or][data table=__ProductFiles_0__ col=description key="[sql-data orderline sku]"][/either] [if-sql-data orderline size]
[L]Size[/L]: [sql-data orderline size] [/if-sql-data] [if-sql-data orderline color]
[L]Color[/L]: [sql-data orderline color] [/if-sql-data] [if-sql-data orderline options]
[L]Options[/L]: [sql-data orderline options] [/if-sql-data]
[sql-data orderline sku] [sql-data orderline quantity] [currency][sql-data orderline price][/currency]  [sql-data orderline discount] [currency][sql-data orderline subtotal][/currency]
[L]Product Total[/L]: [currency][loop-data transactions subtotal][/currency]
[L]Tax[/L]: [currency][loop-data transactions salestax][/currency]
[L]Shipping[/L]: [loop-data transactions shipmode] [currency][loop-data transactions shipping][/currency]
[L]Grand total[/L]: [currency][loop-data transactions total_cost][/currency]
[L]Total weight[/L]: [calc] $total_weight [/calc]
[L]Total volume[/L]: 0
[L]Comments[/L]:
[loop-data transactions comments]

[set [L]Return[/L]] viewnext= vieworder= [/set] [if-loop-data transactions archived] [else] [/else] [/if-loop-data] [if-mm advanced order=d] [/if-mm]
[/loop] @_UI_STD_FOOTER_@