def option_saveOrder(Form, local):
menu_list = []
for key in Form.keys():
if key.startswith('menu_'):
menu_list.append([key[5:], Form.get(key)])
print("menu_list:", menu_list)
if Form.get("payAcc"):
print("account")
payment = "account"
elif Form.get("payCar"):
print("card")
payment = "card"
sqlQuery(
"""INSERT INTO orders(sid, cid, status, did, payment, timestmp)
SELECT M.sid, C.cid, 'waiting', NULL, %s, %s
FROM menues M, customers C
WHERE C.local=%s AND M.menuid=%s;""",
(payment, datetime.datetime.now(), local, menu_list[0][0]))
conn = pg.connect(conn_str)
cur = conn.cursor()
for menu in menu_list:
cur.execute(
"""INSERT INTO basket (order_id, menuid, cnt)
SELECT MAX(O.order_id),%s,%s
FROM orders O""", (menu[0], menu[1]))
cur.close()
conn.commit()
def option_decline(Form, local):
# did = Form.get("did")
order_id = Form.get("order_id")
sqlQuery(
"""BEGIN TRANSACTION;
DELETE FROM orders WHERE order_id = %s;
DELETE FROM basket WHERE order_id = %s;
END TRANSACTION;""", (order_id, order_id))
def delRequest2(info, sid, head):
if sid.startswith("admin"): contacts_name = "contacts"
elif sid.startswith("2009003125"): contacts_name = "grass_corp"
elif sid.startswith("2013004394"): contacts_name = "fire_corp"
elif sid.startswith("2014005004"): contacts_name = "water_corp"
else: contacts_name = None
sql = f"DELETE FROM {contacts_name} WHERE sid=\'{info[0]}\';"
sqlQuery(sql)
print("delete!")
def option_tag(Form, local):
type = search(local)
if Form.get("delete_tag"):
sqlQuery("DELETE FROM store_tags WHERE sid=%s AND name=%s",
(Form.get("sid"), Form.get("tag")))
print("{} 를 삭제하고 싶음".format(Form.get("tag")))
# sqlQuery(sql)
elif Form.get("add_tag"):
sql = "INSERT INTO store_tags (sid, name) VALUES ({}, \'{}\')".format(
Form.get("sid"), Form.get("added_tag"))
sqlQuery(sql)
print(sql)
def option_person(Form, local): # name/pwd change
type = search(local)
sql = "SELECT name, passwd FROM {} WHERE local=\'{}\'".format(type, local)
personInfo = sqlQuery_(sql)
# print("origin:",list(personInfo[0]))
# print("after:",Form.get("name"),Form.get("password"))
if Form.get("save"):
sql = "UPDATE {} SET name=\'{}\', passwd=\'{}\' WHERE local=\'{}\'".format(
type, Form.get("name"), Form.get("password"), local)
sqlQuery(sql)
print("edit")
else:
print("cancel")
def addRequest2(info, sid, head):
if sid.startswith("admin"): contacts_name = "contacts"
elif sid.startswith("2009003125"): contacts_name = "grass_corp"
elif sid.startswith("2013004394"): contacts_name = "fire_corp"
elif sid.startswith("2014005004"): contacts_name = "water_corp"
else: contacts_name = None
print("contacts_name:", contacts_name)
if sid.startswith("admin"):
sql = f"INSERT INTO {contacts_name} VALUES (\'{info[0]}\', \'{info[1]}\', \'{info[2]}\');"
sqlQuery(sql)
print("add!")
else:
sql = f"INSERT INTO {contacts_name} VALUES (\'{info[0]}\', \'{info[1]}\', \'{info[2]}\', \'{info[3]}\');"
sqlQuery(sql)
print("add!")
def saveRequest2(info, sid, head):
if sid.startswith("admin"): contacts_name = "contacts"
elif sid.startswith("2009003125"): contacts_name = "grass_corp"
elif sid.startswith("2013004394"): contacts_name = "fire_corp"
elif sid.startswith("2014005004"): contacts_name = "water_corp"
else: contacts_name = None
print("contacts_name:", contacts_name)
if contacts_name == "contacts":
sql = f"UPDATE {contacts_name} SET {head[0]}=\'{info[0]}\',{head[1]}=\'{info[1]}\',{head[2]}=\'{info[2]}\' WHERE phone=\'{info[1]}\';"
sqlQuery(sql)
print("save!")
elif contacts_name != None:
sql = f"UPDATE {contacts_name} SET {head[0]}=\'{info[0]}\',{head[1]}=\'{info[1]}\',{head[2]}=\'{info[2]}\',{head[3]}=\'{info[3]}\' WHERE phone=\'{info[1]}\';"
sqlQuery(sql)
print("save!")
def option_menu(Form, local): # about store
# TOFIX option_menu으로 함수 이름 바꾸기
type = search(local)
if Form.get("changeName"):
sql = "UPDATE menues SET menu=\'{}\' WHERE menu=\'{}\' AND sid={}".format(
Form.get("after_menu"), Form.get("before_menu"), Form.get("sid"))
sqlQuery(sql)
print(sql)
elif Form.get("delete"):
sql = "DELETE FROM menues WHERE menu=\'{}\' AND sid={}".format(
Form.get("before_menu"), Form.get("sid"))
sqlQuery(sql)
elif Form.get("add"):
sql = "INSERT INTO menues (menu, sid) VALUES (\'{}\', {})".format(
Form.get("added_menu"), Form.get("sid"))
sqlQuery(sql)
def addRequest1(info, sid, head):
# info[0] = info[0]+'\t'
sql = f"INSERT INTO students VALUES (\'{info[0]}\', \'{info[1]}\', \'{info[2]}\', \'{info[3]}\', \'{info[4]}\', \'{info[5]}\', \'{info[6]}\');"
sqlQuery(sql)
print("add!")
def delRequest1(info, sid, head):
sql = f"DELETE FROM students WHERE sid=\'{info[0]}\';"
sqlQuery(sql)
print("delete!")
def saveRequest1(info, sid, head):
sql = f"UPDATE students SET {head[0]}=\'{info[0]}\', {head[1]}=\'{info[1]}\',{head[2]}=\'{info[2]}\',{head[3]}=\'{info[3]}\',{head[4]}={info[4]},{head[5]}=\'{info[5]}\',{head[6]}={info[6]} WHERE sid=\'{info[0]}\';"
print("saverequest1 sid:", info[0])
sqlQuery(sql)
print("save!")
from sql import sqlQuery
import logging
import os,sys,re
curr_path = os.path.dirname(os.path.abspath(__file__))
comm_path = os.path.dirname(curr_path)
if comm_path not in sys.path:
sys.path.append(comm_path)
logger = logging.getLogger(__name__)
logger.setLevel(level = logging.INFO)
handler = logging.FileHandler("{}/log.txt".format(curr_path))
handler.setLevel(logging.INFO)
formatter = logging.Formatter('%(asctime)s - %(name)s - %(levelname)s - %(message)s')
handler.setFormatter(formatter)
logger.addHandler(handler)
sql = sqlQuery('book')
class searchBook(object):
"""docstring for findbook"""
def __init__(self, baseURL, totalPage, savePath, endPage):
self.baseURL = baseURL
self.totalPage = totalPage
self.path = savePath
self.endPage = endPage
def findbook(self): # find book 按分页查找book
session = HTMLSession()
for i in range(self.totalPage, self.endPage, -1):
url = self.baseURL + str(i)
# print (url)
try:
res = session.get(url, timeout = 10)
book = res.html.find('div.book-img-box > a')
def option_updatePayment(Form, local):
q = sqlQuery_("""SELECT payment FROM customers WHERE local=%s""",
(local, ))
payment_list = json.loads(q[0][0])
# account editing
if Form.get("edit_acc"):
origin_accNum = int(Form.get("origin_accNum"))
get_acc_num = int(Form.get("get_acc_num"))
get_acc_bid = int(Form.get("get_acc_bid"))
for payment in payment_list:
if payment['type'] == 'account' and payment['data'][
'acc_num'] == origin_accNum:
payment['data']['acc_num'] = get_acc_num
payment['data']['bid'] = get_acc_bid
tmp = json.dumps(payment_list)
sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""",
(tmp, local))
print("require / account edit ::: ", origin_accNum, get_acc_num,
get_acc_bid)
# card editing
elif Form.get("edit_card"):
origin_card = int(Form.get("origin_card"))
get_card_num = int(Form.get("get_card_num"))
for payment in payment_list:
if payment['type'] == 'card' and payment['data'][
'card_num'] == origin_card:
payment['data']['card_num'] = get_card_num
tmp = json.dumps(payment_list)
sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""",
(tmp, local))
print("require / card edit ::: ", origin_card, get_card_num)
# account added
elif Form.get("add_acc"):
add_acc_num = int(Form.get("add_acc_num"))
add_acc_bid = int(Form.get("add_acc_bid"))
res = {
'type': 'account',
'data': {
'bid': add_acc_bid,
'acc_num': add_acc_num
}
}
payment_list.append(res)
tmp = json.dumps(payment_list)
sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""",
(tmp, local))
print("require / account add ::: ", add_acc_num, add_acc_bid)
# card added
elif Form.get("add_card"):
add_card_num = int(Form.get("add_card_num"))
res = {'type': 'card', 'data': {'card_num': add_card_num}}
payment_list.append(res)
tmp = json.dumps(payment_list)
sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""",
(tmp, local))
elif Form.get("del_acc"):
origin_accNum = int(Form.get("origin_accNum"))
print("::", payment_list)
idx = None
for i, payment in enumerate(payment_list):
if payment['type'] == 'account' and payment['data'][
'acc_num'] == origin_accNum:
idx = i
if idx is not None:
del (payment_list[idx])
else:
raise ValueError('삭제할 계좌 번호가 없음')
tmp = json.dumps(payment_list)
sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""",
(tmp, local))
elif Form.get("del_card"):
origin_card = int(Form.get("origin_card"))
print("origin:", origin_card)
print("payment1:", payment_list)
idx = None
for i, payment in enumerate(payment_list):
if payment['type'] == 'card' and payment['data'][
'card_num'] == origin_card:
idx = i
print("idx:", idx)
if idx is not None:
del (payment_list[idx])
else:
raise ValueError('삭제할 카드 번호가 없음')
print("payment2:", payment_list)
tmp = json.dumps(payment_list)
sqlQuery("""UPDATE customers SET payment=%s WHERE local=%s""",
(tmp, local))
def option_deliveryFin(Form, local):
order_id = Form.get("order_id")
print("order~~id~~~:", order_id)
sqlQuery("""UPDATE orders SET status='completed' WHERE order_id=%s""",
(order_id, ))
def option_accept(Form, local):
did = Form.get("did")
order_id = Form.get("order_id")
sqlQuery(
"""UPDATE orders SET did=%s, status='delivering' WHERE order_id = %s;""",
(did, order_id))
