def select_menu():
get_session = request.cookies.get('room_session')
room_id = get_room_id_from_session(get_session)
pr_session = request.cookies.get('pr_session')
user_id = get_id_from_db(pr_session)
host_id = get_host_id_from_roomid(room_id)
query = "select restaurant_id from room where room_id = '%d'"
restaurant_id = select_one(query % (room_id))
query = "select food_name, food_price from pr_food where restaurant_id = '%d'"
food_table = select_all(query % int(restaurant_id[0]))
food_List = list()
for table_one in food_table:
food_dic = {'food_name': table_one[0], 'food_price': table_one[1]}
food_List.append(food_dic)
uinfo = list()
if host_id == user_id:
info = 0
uinfo.append(info)
else:
query = "select user_name from pr_user where user_id = '%d'"
get_table = select_one(query % user_id)
info = get_table[0]
uinfo.append(info)
return jsonify(results = food_List, results2 = uinfo)
def room_out():
pr_session = request.cookies.get('pr_session')
user_id = get_id_from_db(pr_session)
room_session = request.cookies.get('room_session')
room_id = get_room_id_from_session(room_session)
response = outOfTheRoom(room_id, user_id)
return response
def get_payer():
try:
data = json.loads(request.data)
except ValueError:
return "Input must be json format", 400
if data != None:
room_session = request.cookies.get('room_session')
room_id = get_room_id_from_session(room_session)
response = selectPayer(room_id, data['user_id'])
return response
return -1
def order_menu():
try:
data=json.loads(request.data)
except ValueError:
return "Input must be json format", 400
pr_session = request.cookies.get('pr_session')
user_id = get_id_from_db(pr_session)
room_session = request.cookies.get('room_session')
room_id = get_room_id_from_session(room_session)
save_user_menu(user_id, room_id, data)
return ""
def order_ready():
pr_session = request.cookies.get('pr_session')
user_id = get_id_from_db(pr_session)
#유저 id와 방 id를 가지고 RoomList에서 user_ready를 1로 바꿔주면 땡
room_session = request.cookies.get('room_session')
room_id = get_room_id_from_session(room_session)
query = "select user_ready from room_list where user_present = 1 and room_id = '%d' and user_id = '%d'"
ready = select_one(query % (room_id, user_id))
if ready[0]:
query2 = "update room_list set user_ready = 0 where room_id = '%d' and user_id = '%d' and user_present = 1"
insert(query2 % (room_id, user_id))
else:
query2 = "update room_list set user_ready = 1 where room_id = '%d' and user_id = '%d' and user_present = 1"
insert(query2 % (room_id, user_id))
return jsonify(results = ready[0])
def room_member():
room_session = request.cookies.get('room_session')
room_id = get_room_id_from_session(room_session)
menu_list = list()
query1 = "select user_id from room_list where room_id = '%d' and user_present = 1"
user_table = select_all(query1 % (room_id))
restaurant_id = get_restaurant_id_from_roomid(room_id)
query2 = "select food_name, food_price from user_orderlist where user_id = '%d' and room_id = '%d' order by user_id" #음식 정보 가져오기
query3 = "select user_name from pr_user where user_id = '%d'" #유저이름 가져오기
query4 = "select user_ready from room_list where room_id = '%d' and user_id = '%d' and user_present = 1" #유저 레디 정보 가져오기
ftable_dic = dict()
for utable_one in user_table:
total_price = 0
food_list = list()
food_table = select_all(query2 % (int(utable_one[0]), room_id))
for ftable_one in food_table:
ftable_dic = {'food_name': ftable_one[0], 'food_price': ftable_one[1]}
total_price += int(ftable_one[1])
food_list.append(ftable_dic)
user_name = select_one(query3 % utable_one[0])
ready = select_one(query4 % (room_id, utable_one[0]))
utable_dic = {'user_name': user_name[0], 'user_choice': food_list, 'user_pay': total_price, 'user_ready': ready[0]}
menu_list.append(utable_dic)
uinfo = list()
for table_one in user_table:
query = "select user_name from pr_user where user_id = '%d'"
uname = select_one(query % table_one[0])
p_dic = {'user_name': uname[0], 'user_id': table_one[0]}
uinfo.append(p_dic)
return jsonify(results = menu_list, results2 = uinfo)
def final_decision():
try:
data=json.loads(request.data)
except ValueError:
return "Input must be json format", 400
room_session = request.cookies.get('room_session')
room_id = get_room_id_from_session(room_session)
ready_number=getUserNumber(room_id)
total_num = int(data)
if ready_number == total_num:
payerID = getPayerInfo(room_id)
if payerID is None:
return "결제자 선택이 완료되지 않았습니다", 400
response = CompleteOrder(room_id)
if response is None:
return "이미 최종 선택된 방입니다", 400
response = calculateTotal(room_id)
return response
return "전원 준비되지 않았습니다", 400