[comment]
ui_template: Yes
ui_template_name: leftonly
ui_template_layout: LEFTONLY_TOP, UI_CONTENT, LEFTONLY_BOTTOM
ui_template_description: Page with top/left areas.
page_title:
description: Page title
page_banner:
description: Page banner
help: Defaults to page title
members_only:
options: 1=Yes,0=No*
widget: radio
description: Members only
component_before:
options: =none, specials=Specials, random=Random items
widget: select
description: Component before content
component_after:
options: =none, specials=Specials, random=Random items
widget: select
description: Component after content
bgcolor:
options: #FFFFFF=White,pink=Pink
widget: select
description: Background color
[/comment]
[set page_title]__COMPANY__ -- Order Detail[/set]
[set page_banner]Order Detail[/set]
__LEFTONLY_TOP__
[if session arg]
[seti arg][data session arg][/seti]
[else]
[bounce href="[area special/violation arg_missing]"]
[/else]
[/if]
[value name=test_user
set="[data
table=transactions
col=username
key='[scratch arg]'
]"
hide=1]
[if value test_user]
[else]
[bounce href="[area special/violation user_missing]&user=[value test_user]&arg=[scratch arg]"]
[/else]
[/if]
[if type=explicit compare=`
return 1 if ! $Session->{username};
return 0 if $Session->{username} eq $Values->{test_user};
return 1;
`]
[bounce href="[area special/user_violation username_no_match]&s=[data session username]&v=[value test_user]"]
[/if]
[loop list="[scratch arg]"]
[html-table fr='bgcolor="#FEEDD2"']
ORDER NUMBER [scratch arg]
Name [loop-data transactions fname] [loop-data transactions lname]
[if-loop-data transactions company]Company [loop-data transactions company]
[/if-loop-data]Address [loop-data transactions address1][if-loop-data transactions address2]
[loop-data transactions address2][/if-loop-data]
City, State, Zip [loop-data transactions city], [loop-data transactions state] [loop-data transactions zip]
Country [loop-data transactions country]
Payment Method [loop-data transactions payment_method]
Shipping Method [loop-data transactions shipmode]
Daytime Phone [loop-data transactions phone_day]
Evening Phone [loop-data transactions phone_night]
[if-loop-data transactions b_fname]Billing Name [loop-data transactions b_fname] [loop-data transactions b_lname]
[/if-loop-data][if-loop-data transactions b_address1]Billing Address [loop-data transactions b_address1]
[loop-data transactions b_address2]
City, State, Zip [loop-data transactions b_city], [loop-data transactions b_state] [loop-data transactions b_zip]
[/if-loop-data][if-loop-data transactions b_country]Shipping Country [loop-data transactions b_country][/if-loop-data]
[/html-table]
[perl products userdb]
sub get_download {
my $sku = shift;
return '' unless tag_data('products', 'download', $sku);
my $loc = tag_data('products', 'dl_location', $sku);
my $save = delete $Scratch->{mv_add_dot_html};
my $url = $Tag->area( { href => "deliver/$loc", arg => $sku } );
$Scratch->{mv_add_dot_html} = $save if $save;
return qq{
};
}
return;
[/perl]
[html-table interpolate=1 td="VALIGN=TOP"]
Quan Item No. Description Price
Extension
[query
list=1
st=db
sql=|
SELECT * FROM orderline
WHERE order_number = '[scratch arg]'
ORDER BY code
|
]
[sql-param quantity] [sql-param sku] [description [sql-param sku]]
[if-sql-data orderline size]SIZE-->[sql-param size][/if-sql-data][if-sql-data orderline color] COLOR-->[sql-param color][/if-sql-data][calc]
return unless
q{[userdb function=check_file_acl mode=expire location="[sql-param sku]"]};
return get_download(q{[sql-param sku]});
[/calc]
[currency][sql-param price][/currency] [currency][sql-param subtotal][/currency]
[/query]
SUBTOTAL [currency][loop-data transactions subtotal][/currency]
SALES TAX [currency][loop-data transactions salestax][/currency]
SHIPPING [currency][loop-data transactions shipping][/currency][if-loop-data transactions handling]
HANDLING [currency][loop-data transactions handling][/currency][/if-loop-data]
ORDER TOTAL [currency][loop-data transactions total_cost][/currency]
[/html-table]
[/loop]
__LEFTONLY_BOTTOM__