%
function yesno(entry)
if entry = "1" then
yesno = -1
else
yesno = 0
end if
end function
if request("action") = "Cancel" then
response.redirect "menu.asp"
elseif request("action") = "Remove From Order" then
sql = "DELETE FROM tbl_oline WHERE id=" & request("oline_id")
cnn.execute sql
cnn.close
set cnn = nothing
response.redirect "menu.asp"
elseif request("action") = "Add to Order" or request("action") = "Save Changes" then
if request("sauce_none") = "" and request("sauce_bbq") = "" and request("sauce_mild") = "" and _
request("sauce_hot") = "" and request("sauce_death") = "" and request("sauce_habenero") = "" and _
request("sauce_lime") = "" then
msg = "Please choose your sauce before clicking add to order. If you don't want any " & _
"sauces please check the none option."
elseif request("sauce_none") <> "" and (request("sauce_bbq") <> "" or request("sauce_mild") <> "" or _
request("sauce_hot") <> "" or request("sauce_death") <> "" or request("sauce_habenero") <> "" or _
request("sauce_lime") <> "") then
msg = "Please be sure to not choose any other sauce if you have already chosen the 'none' option."
elseif request("e_none") = "" and request("e_scream") = "" and request("e_guac") = "" and _
request("e_cheese") = "" and request("e_rice") = "" and request("e_avo") = "" and _
request("e_tortilla") = "" and request("e_beans_black") = "" and _
request("e_beans_refried") = "" and request("e_beans_whole") = "" and _
request("e_steak") = "" and request("e_wchick") = "" and request("e_dchick") = "" then
msg = "Please choose your extras before clicking add to order. If you don't want any " & _
"extras please check the none option."
elseif request("e_none") <> "" and (request("e_scream") <> "" or request("e_guac") <> "" or _
request("e_cheese") <> "" or request("e_rice") <> "" or request("e_avo") <> "" or _
request("e_tortilla") <> "" or request("e_beans_black") <> "" or _
request("e_beans_refried") <> "" or request("e_beans_whole") <> "" or _
request("e_steak") <> "" or request("e_wchick") <> "" or request("e_dchick") <> "") then
msg = "Please be sure not to choose any other extra if you have already chosen the 'none' option."
elseif request("f_none") = "" and request("white_onions") = "" and request("purple_onions") = "" and _
request("tomatoes") = "" and request("cilantro") = "" and request("pico") = "" and _
request("jalapenos") = "" and request("e_po") = "" and request("lettuce") = "" then
msg = "Please choose your freebies before clicking add to order. If you don't want any " & _
"freebies please check the none option."
elseif request("f_none") <> "" and (request("white_onions") <> "" or request("purple_onions") <> "" or _
request("tomatoes") <> "" or request("cilantro") <> "" or request("pico") <> "" or _
request("jalapenos") <> "" or request("e_po") <> "" or request("lettuce") <> "") then
msg = "Please be sure not to choose any other freebie if you have already chosen the 'none' option."
else
chicken = ""
price = request("price")
' always pay for these (no subtitutions)
if request("e_scream") = "1" then price = price + .75
if request("e_guac") = "1" then price = price + .75
if request("e_avo") = "1" then price = price + 1
if request("e_cheese") = "1" then price = price + .75
if request("e_rice") = "1" then price = price + .75
'if request("e_po") = "1" then price = price + .50
if request("e_beans_black") = "1" or request("e_beans_refried") = "1" or request("e_beans_whole") = "1" then
price = price + .75
end if
if request("e_steak") = "1" or request("e_wchick") = "1" or request("e_dchick") = "1" then
price = price + 1.50
end if
sql = "INSERT INTO tbl_oline (order_id, product_id, qty, price, label, rice, " & _
"cheese, beans_black, beans_refried, beans_whole, chicken, sauce_bbq, sauce_mild, sauce_hot, sauce_death, " & _
"sauce_habenero, sauce_lime, e_scream, e_guac, e_avo, e_cheese, e_rice, e_beans_black, e_beans_refried, e_beans_whole, " & _
"e_steak, e_wchick, e_dchick, e_po, white_onions, purple_onions, pico, jalapenos, tomatoes, cilantro, e_tortilla, lettuce, " & _
"notes_basic, notes_sauce, notes_free, notes_extra) VALUES (" & _
session("order_id") & ", " & _
request("id") & ", " & _
"1, " & _
price & ", " & _
"'', " & _
yesno(request("rice")) & ", " & _
yesno(request("cheese")) & ", " & _
yesno(request("beans_black")) & ", " & _
yesno(request("beans_refried")) & ", " & _
yesno(request("beans_whole")) & ", " & _
"'" & chicken & "', " & _
yesno(request("sauce_bbq")) & ", " & _
yesno(request("sauce_mild")) & ", " & _
yesno(request("sauce_hot")) & ", " & _
yesno(request("sauce_death")) & ", " & _
yesno(request("sauce_habenero")) & ", " & _
yesno(request("sauce_lime")) & ", " & _
yesno(request("e_scream")) & ", " & _
yesno(request("e_guac")) & ", " & _
yesno(request("e_avo")) & ", " & _
yesno(request("e_cheese")) & ", " & _
yesno(request("e_rice")) & ", " & _
yesno(request("e_beans_black")) & ", " & _
yesno(request("e_beans_refried")) & ", " & _
yesno(request("e_beans_whole")) & ", " & _
yesno(request("e_steak")) & ", " & _
yesno(request("e_wchick")) & ", " & _
yesno(request("e_dchick")) & ", " & _
yesno(request("e_po")) & ", " & _
yesno(request("white_onions")) & ", " & _
yesno(request("purple_onions")) & ", " & _
yesno(request("pico")) & ", " & _
yesno(request("jalapenos")) & ", " & _
yesno(request("tomatoes")) & ", " & _
yesno(request("cilantro")) & ", " & _
"'" & request("e_tortilla") & "', " & _
yesno(request("lettuce")) & ", " & _
"'" & replace(request("notes_basic"),"'","''") & "', " & _
"'" & replace(request("notes_sauce"),"'","''") & "', " & _
"'" & replace(request("notes_free"),"'","''") & "', " & _
"'" & replace(request("notes_extra"),"'","''") & "')"
cnn.execute sql
if request("action") = "Save Changes" then
sql = "DELETE FROM tbl_oline WHERE id=" & request("oline_id")
cnn.execute sql
end if
cnn.close
set cnn = nothing
response.redirect "menu.asp"
end if
rice = request("rice")
cheese = request("cheese")
beans_black = request("beans_black")
beans_refried = request("beans_refried")
beans_whole = request("beans_whole")
qty = request("qty")
label = request("label")
chicken = request("chicken")
sauce_bbq = request("sauce_bbq")
sauce_mild = request("sauce_mild")
sauce_hot = request("sauce_hot")
sauce_habenero = request("sauce_habenero")
sauce_death = request("sauce_death")
sauce_lime = request("sauce_lime")
e_scream = request("e_scream")
e_guac = request("e_guac")
e_avo = request("e_avo")
e_cheese = request("e_cheese")
e_rice = request("e_rice")
e_beans_black = request("e_beans_black")
e_beans_refried = request("e_beans_refried")
e_beans_whole = request("e_beans_whole")
e_steak = request("e_steak")
e_wchick = request("e_wchick")
e_dchick = request("e_dchick")
e_po = request("e_po")
e_tortilla = request("e_tortilla")
white_onions = request("white_onions")
purple_onions = request("purple_onions")
tomatoes = request("tomatoes")
pico = request("pico")
jalapenos = request("jalapenos")
cilantro = request("cilantro")
lettuce = request("lettuce")
notes_basic = request("notes_basic")
notes_sauce = request("notes_sauce")
notes_extra = request("notes_extra")
notes_free = request("notes_free")
sauce_none = request("sauce_none")
e_none = request("e_none")
f_none = request("f_none")
end if
pid = request("id")
if request("oline_id") <> "" then
sql = "SELECT * FROM tbl_oline WHERE id=" & request("oline_id")
set rs = server.createobject("adodb.recordset")
rs.open sql, cnn, 1, 3
if not rs.eof then
pid = rs("product_id")
rice = abs(rs("rice"))
cheese = abs(rs("cheese"))
beans_black = abs(rs("beans_black"))
beans_refried = abs(rs("beans_refried"))
beans_whole = abs(rs("beans_whole"))
qty = rs("qty")
label = rs("label")
chicken = rs("chicken")
sauce_bbq = abs(rs("sauce_bbq"))
sauce_mild = abs(rs("sauce_mild"))
sauce_hot = abs(rs("sauce_hot"))
sauce_habenero = abs(rs("sauce_habenero"))
sauce_death = abs(rs("sauce_death"))
sauce_lime = abs(rs("sauce_lime"))
e_scream = abs(rs("e_scream"))
e_guac = abs(rs("e_guac"))
e_avo = abs(rs("e_avo"))
e_cheese = abs(rs("e_cheese"))
e_rice = abs(rs("e_rice"))
e_beans_black = abs(rs("e_beans_black"))
e_beans_refried = abs(rs("e_beans_refried"))
e_beans_whole = abs(rs("e_beans_whole"))
e_steak = abs(rs("e_steak"))
e_wchick = abs(rs("e_wchick"))
e_dchick = abs(rs("e_dchick"))
e_po = abs(rs("e_po"))
e_tortilla = rs("e_tortilla")
white_onions = abs(rs("white_onions"))
purple_onions = abs(rs("purple_onions"))
tomatoes = abs(rs("tomatoes"))
pico = abs(rs("pico"))
jalapenos = abs(rs("jalapenos"))
cilantro = abs(rs("cilantro"))
lettuce = abs(rs("lettuce"))
notes_basic = rs("notes_basic")
notes_sauce = rs("notes_sauce")
notes_extra = rs("notes_extra")
notes_free = rs("notes_free")
if sauce_bbq=0 and sauce_mild=0 and sauce_hot=0 and sauce_habenero=0 _
and sauce_death=0 and sauce_lime=0 then
sauce_none = 1
end if
if e_scream=0 and e_guac=0 and e_avo=0 and e_cheese=0 and e_rice=0 _
and e_beans_black=0 and e_beans_refried=0 and e_beans_whole=0 _
and e_steak=0 and e_wchick=0 and e_dchick=0 and e_tortilla="" then
e_none = 1
end if
if white_onions=0 and purple_onions=0 and tomatoes=0 and pico=0 _
and jalapenos=0 and cilantro=0 and lettuce=0 and e_po=0 then
f_none = 1
end if
end if
rs.close
set rs = nothing
end if
%>
<%
if request("qty") <> "" then qty = request("qty") else qty = "1"
set rs = server.createobject("adodb.recordset")
sql = "SELECT * FROM tbl_product WHERE id=" & pid
rs.open sql, cnn, 1, 3
if msg <> "" then response.write "" & msg & ""
%>