Order Summary
start over
<%if session("order_id") <> "" then%>
Customer: <%=session("cust_name")%>
Store: <%=replace(session("store_name"),"Freebirds @ ","")%>
Order #: <%=session("order_id")%>w3
| QTY - DESCRIPTION |
PRICE |
<%
total = 0
set rs = server.createobject("adodb.recordset")
sql = "SELECT tbl_oline.qty, tbl_oline.price, tbl_oline.label, tbl_oline.id, " & _
"tbl_product.name AS product_name, tbl_product.type, " & _
"tbl_product2.name AS product_name2 " & _
"FROM tbl_oline " & _
"LEFT JOIN tbl_product ON tbl_oline.product_id=tbl_product.id " & _
"LEFT JOIN tbl_oline AS tbl_oline2 ON tbl_oline.id=tbl_oline2.seq_id " & _
"LEFT JOIN tbl_product AS tbl_product2 ON tbl_oline2.product_id=tbl_product2.id " & _
"WHERE tbl_oline.order_id=" & session("order_id") & " " & _
"AND tbl_oline.seq_id=-1"
rs.open sql, cnn, 1, 3
do until rs.eof
total = total + (rs("qty") * rs("price"))
page = rs("type")
if rs("product_name") = "Tortillas" then page = "tortilla"
if left(rs("product_name"),5) = "Chips" or left(rs("product_name"),5) = "2 oun" then page = "chips"
product_name = rs("product_name") & ""
if rs("product_name2") & "" <> "" and product_name <> rs("product_name2") & "" then
product_name = replace(product_name,"Tacos","") & " / " & rs("product_name2")
end if
if left(rs("label"),1)="L" then product_name = "Little Monster " & product_name
%>
<%=rs("qty")%> - "><%=product_name%>
<%if rs("label")<>"" then response.write "
(" & rs("label") & ")"%> |
<%=formatcurrency(rs("qty") * rs("price"),2)%> |
<%
rs.movenext
loop
rs.close
set rs = nothing
%>
| Order Total: |
<%=formatcurrency(total,2)%> |
<%if instr(request("script_name"),"menu.asp") > 0 then%>
Please place your drink order at the store when picking up your order.
<%end if%>
<%else%>
Your order summary will appear here once you've started to place your order.
<%end if%>
|
|
|
