[set page_title]Order manager: View order[/set] [set ui_class]Orders[/set] [set page_banner]View order[/set] [set help_name]order.view[/set] [set icon_name]admin/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] [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]
Order number: [loop-code] Order date: [convert-date][loop-data transactions order_date][/convert-date]
Customer: [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]
Affiliate: [data table=affiliate column=name key="[loop-data transactions affiliate]"]
Company: [loop-data transactions company]
Home phone: [loop-data transactions phone_night]
Work phone: [loop-data transactions phone_day]
Email: [loop-data transactions email]
Payment type: [loop-data transactions payment_method]
Field 1:
Field 2:
Field 3:
Field 4:
[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]
[/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]
[/set]

[if-loop-data transactions username] Bill To: [else] Bill To: [/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] Ship To: [else] Ship To: [/else] [/if-loop-data]
[scratch ship_address]

Status: [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]

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

[set Return] viewnext= vieworder= [/set] [if-loop-data transactions archived] [else] [/else] [/if-loop-data]
[/loop] @_UI_STD_FOOTER_@