/
order_detail.html
196 lines (183 loc) · 8.91 KB
/
order_detail.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
[comment]
ui_template: Yes
ui_template_name: standalone
ui_template_layout: LOGOBAR, MENUBAR, UI_CONTENT, MENUBOTTOM, COPYRIGHT
ui_template_description: Page with top logo bar. menu bar and copyright at bottom.
ui_control_element: page_title :
ui_control_element: members_only : 0=No,1=Yes
ui_control_description: page_title : Page title
ui_control_description: members_only : Members only
[/comment]
[set members_only]1[/set]
[set page_title] __COMPANY__ -- Order Detail [/set]
__LOGOBAR__
__MENUBAR__
<!-- BEGIN CONTENT -->
[comment]
+----------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+-------+
| code | varchar(14) | | PRI | | |
| store_id | varchar(9) | | MUL | | |
| order_number | varchar(14) | | MUL | | |
| session | varchar(32) | | | | |
| username | varchar(20) | | | | |
| shipmode | varchar(32) | | | | |
| nitems | varchar(9) | | | | |
| subtotal | varchar(12) | | | | |
| shipping | varchar(12) | | | | |
| handling | varchar(12) | YES | | NULL | |
| salestax | varchar(12) | YES | | NULL | |
| total_cost | varchar(16) | | | | |
| fname | varchar(30) | YES | | NULL | |
| lname | varchar(30) | YES | | NULL | |
| company | varchar(30) | YES | | NULL | |
| address1 | varchar(30) | YES | | NULL | |
| address2 | varchar(30) | YES | | NULL | |
| city | varchar(30) | | | | |
| state | varchar(10) | YES | | NULL | |
| zip | varchar(10) | | | 00000 | |
| country | varchar(10) | | | | |
| phone_day | varchar(20) | YES | | NULL | |
| phone_night | varchar(20) | YES | | NULL | |
| fax | varchar(20) | YES | | NULL | |
| email | varchar(42) | YES | | NULL | |
| b_fname | varchar(30) | YES | | NULL | |
| b_lname | varchar(30) | YES | | NULL | |
| b_company | varchar(30) | YES | | NULL | |
| b_address1 | varchar(30) | YES | | NULL | |
| b_address2 | varchar(30) | YES | | NULL | |
| b_city | varchar(30) | YES | | NULL | |
| b_state | varchar(10) | YES | | NULL | |
| b_zip | varchar(10) | | | 00000 | |
| b_country | varchar(10) | | | | |
| b_phone | varchar(20) | YES | | NULL | |
| order_date | varchar(32) | | | | |
| payment_method | varchar(32) | YES | | NULL | |
| avs | varchar(32) | YES | | NULL | |
| order_id | varchar(32) | YES | | NULL | |
| update_date | timestamp(14) | YES | | NULL | |
| status | varchar(32) | YES | | NULL | |
| parent | varchar(9) | YES | | NULL | |
+----------------+---------------+------+-----+---------+-------+
+--------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+---------------+------+-----+---------+-------+
| code | varchar(14) | | PRI | | |
| store_id | varchar(9) | | MUL | | |
| order_number | varchar(14) | | MUL | | |
| session | varchar(32) | | | | |
| username | varchar(20) | | | | |
| shipmode | varchar(32) | | | | |
| sku | varchar(14) | | | | |
| quantity | varchar(9) | | | | |
| price | varchar(12) | | | | |
| subtotal | varchar(12) | | | | |
| shipping | varchar(12) | YES | | NULL | |
| taxable | char(3) | YES | | NULL | |
| size | varchar(30) | YES | | NULL | |
| color | varchar(30) | YES | | NULL | |
| options | varchar(255) | YES | | NULL | |
| order_date | varchar(32) | | | | |
| update_date | timestamp(14) | YES | | NULL | |
| status | varchar(32) | YES | | NULL | |
| parent | varchar(9) | YES | | NULL | |
+--------------+---------------+------+-----+---------+-------+
[/comment]
[comment]
Do some security checking
[/comment]
[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]
<P> <P>
<TABLE CELLSPACING=0 CELLMARGIN=0 BORDER=1 WIDTH=600>
<TR><TD COLSPAN=4 __HEADERBG__ ALIGN=CENTER>
<FONT SIZE="+2" COLOR="__HEADERTEXT__">Order Detail: [scratch arg]</FONT>
</TD>
</TR></TABLE>
[loop list="[scratch arg]"]
<TABLE WIDTH=600 BORDER=1>
[html-table fr='__TABLEFG__']
<B>ORDER NUMBER [loop-data transactions mv_order_number]
<B>Name [loop-data transactions fname] [loop-data transactions lname]
[if-loop-data transactions company]Company [loop-data transactions company]
[/if-loop-data]<B>Address [loop-data transactions address1][if-loop-data transactions address2]
[loop-data transactions address2][/if-loop-data]
<B>City, State, Zip [loop-data transactions city], [loop-data transactions state] [loop-data transactions zip]
<B>Country [loop-data transactions country]
<B>Payment Method [loop-data transactions payment_method]
<B>Shipping Method [loop-data transactions shipmode]
<B>Daytime Phone [loop-data transactions phone_day]
<B>Evening Phone [loop-data transactions phone_night]
[if-loop-data transactions b_fname]<B>Billing Name [loop-data transactions b_fname] [loop-data transactions b_lname]
[/if-loop-data][if-loop-data transactions b_address1]<B>Billing Address [loop-data transactions b_address1]
[loop-data transactions b_address2]
<B>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]<B>Shipping Country [loop-data transactions b_country][/if-loop-data]
[/html-table]
</TABLE>
<TABLE WIDTH=600 BORDER=1 __TABLEBG__>
[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{<BR><A HREF="$url"><IMG SRC="download.png"></A>};
}
return;
[/perl]
[html-table interpolate=1 td="VALIGN=TOP"]
<B>Quan <B>Item No. <B>Description <B><DIV ALIGN=RIGHT>Price <B><DIV ALIGN=RIGHT>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]]<BR>[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] <DIV ALIGN=RIGHT>[currency][sql-param price][/currency] <DIV ALIGN=RIGHT>[currency][sql-param subtotal][/currency]
[/query]
SUBTOTAL <DIV ALIGN=RIGHT>[currency][loop-data transactions subtotal][/currency]
SALES TAX <DIV ALIGN=RIGHT>[currency][loop-data transactions salestax][/currency]
SHIPPING <DIV ALIGN=RIGHT>[currency][loop-data transactions shipping][/currency][if-loop-data transactions handling]
HANDLING <DIV ALIGN=RIGHT>[currency][loop-data transactions handling][/currency][/if-loop-data]
ORDER TOTAL <DIV ALIGN=RIGHT>[currency][loop-data transactions total_cost][/currency]
[/html-table]
</TABLE>
[/loop]
<BR CLEAR=ALL>
<!-- END CONTENT -->
__MENUBOTTOM__
__COPYRIGHT__
<!-- current page: @@MV_PAGE@@ -->