ServerSideScripting/processorder3.cgi at master · pythonschool/ServerSideScripting · GitHub

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
#!/usr/local/bin/python3

importcgi
frompizza_kitchen_helpersimport*

defprocess_form(form_data):
quantity=int(form_data.getvalue("quantity"))
pizzas= []
foreachinrange(quantity):
pizza=form_data.getvalue("pizza{0}".format(each))
size=form_data.getvalue("size{0}".format(each))
num=form_data.getvalue("quantity{0}".format(each))
cost=form_data.getvalue("cost{0}".format(each))
pizzas.append((pizza,size,num,cost))
date=form_data.getvalue("date")
time=form_data.getvalue("time")
customer=form_data.getvalue("customer")
returnquantity, pizzas, cost,date, time, customer

defget_customer_details(db,cursor,customer_id):
sql="select * from customer where customer_id='{0}'".format(customer_id)
cursor.execute(sql)
customer_details=cursor.fetchone()
returncustomer_details

defcreate_confirmation(quantity, pizzas, cost, date, time, customer_details):
confirmation="<p>{0} {1} you are ordering:</p>".format(customer_details[1],customer_details[2])
confirmation+="""
 <table>
 <tr>
 <th>Pizza</th>
 <th>Size</th>
 <th>Quantity</th>
 <th>Cost</th>
 </tr>
 """

foreachinpizzas:
confirmation+="""
 <tr>
 <td>{0}</td>
 <td>{1}</td>
 <td>{2}</td>
 <td>{3}</td>
 </tr>
 """.format(each[0],each[1],each[2],each[3])

confirmation+="""
 <tr>
 <td></td>
 <td></td>
 <th>Total Cost</th>
 <td>{0}</td>
 </tr>
 """.format(cost)

confirmation+="</table>"

confirmation+="""
 <p>
 To be delivered at {0} on {1} to:
 <ul>
 <li>{2}</li>
 <li>{3}</li>
 <li>{4}</li>
 </ul>
 </p>
 """.format(time, date, customer_details[3],customer_details[4],customer_details[5])
returnconfirmation

defget_pizza_id(db,cursor,pizzaname):
sql="select pizza_id from pizza where name='{0}'".format(pizzaname)
cursor.execute(sql)
name=cursor.fetchone()
returnname[0]

defcreate_form(db, cursor, quantity, pizzas, date, time, customer_id):
form="""
 <form method="post" action="processorder4.cgi" />
 <input type="hidden" name="customer" value="{0}"/>
 <input type="hidden" name="date" value="{1}"/>
 <input type="hidden" name="time" value="{2}"/>
 <input type="hidden" name="quantity" value="{3}"/>
 """.format(customer_id,date,time,quantity)

orderitem=0
foreachinpizzas:
form+="""
 <td><input type="hidden" name="pizza{0}" value="{1}" readonly /></td>
 <td><input type="hidden" name="size{0}" value="{2}" readonly /></td>
 <td><input type="hidden" name="quantity{0}" value="{3}" readonly /></td>
 """.format(orderitem, get_pizza_id(db,cursor,each[0]),each[1],each[2])
orderitem+=1

form+="""
 <br/><input type="submit" name="submit" value="Confirm Order"/>
 </form>
 """

returnform

if__name__=="__main__":
try:
html_top("Delivery Confirmation")
form_data=cgi.FieldStorage()
quantity, pizzas, cost,date, time, customer=process_form(form_data)
db,cursor=connect_pizza_database()
customer_details=get_customer_details(db,cursor,customer)
confirmation=create_confirmation(quantity, pizzas, cost, date, time, customer_details)
form=create_form(db, cursor, quantity, pizzas, date, time, customer)
print("<h1>Pizza Kitchen</h1>")
print("<h2>Delivery Confirmation</h2>")
print(confirmation)
print(form)
except:
cgi.print_exception()