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 show_total():
pr_session = request.cookies.get('pr_session')
user_id = get_id_from_db(pr_session)
query = "select taker, price from total_price where giver = '%d'" #내가 줘야되는 돈
query2 = "select user_name from pr_user where user_id = '%d'"
query3 = "select giver, price from total_price where taker = '%d'" #내가 받아야되는 돈
table_all = select_all(query % user_id)
get_table = select_one(query2 % user_id)
myname = get_table[0]
pay_list = list()
for table_one in table_all:
name = select_one(query2 % table_one[0])
taker_name = name[0]
pay_dic = {'giver': myname, 'taker':taker_name, 'price': table_one[1]}
pay_list.append(pay_dic)
payed_list = list()
table_all = select_all(query3 % user_id)
for table_one in table_all:
name = select_one(query2 % table_one[0])
giver_name = name[0]
pay_dic = {'giver': giver_name, 'taker': myname, 'price': table_one[1]}
payed_list.append(pay_dic)
return jsonify(results = pay_list, results2 = payed_list)
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 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 room_login():
try:
data=json.loads(request.data)
except ValueError:
return "Input must be json format", 400
get_session = request.cookies.get('pr_session')
user_id = get_id_from_db(get_session)
response = roomin(data, user_id)
room_id = int(data['roomid'])
intoTheRoom(room_id, user_id)
return response
def roomList():
get_session = request.cookies.get('pr_session')
user_id = get_id_from_db(get_session)
query = "select chief_id, room_title, restaurant_id, created, room_id from room as r1, (select e2.location_id as location_id from (select univ_id from pr_user where user_id = '%d') as e1, pr_university as e2 where e1.univ_id = e2.univ_id) as r2 where r1.room_exist = 1 and r1.location_id = r2.location_id order by created desc;"
table_all = select_all(query % user_id)
room_List = list()
for table_one in table_all:
username = get_username_from_db(table_one[0])
rname = get_restaurantname_from_db(table_one[2])
room_dic = { 'user_name':username,'room_title': table_one[1], 'restaurant_name':rname,'created':table_one[3], 'room_id':table_one[4]}
room_List.append(room_dic)
return jsonify(results = room_List)
def create_room():
try:
data=json.loads(request.data)
except ValueError:
return "Input must be json format", 400
room = Room.create_from_request(data)
get_session = request.cookies.get('pr_session')
user_id = get_id_from_db(get_session)
univ_id = get_univ_from_user(user_id)
room.host_id = user_id
room.location_id = get_locationid_from_univ(univ_id)
response = save_room(room)
return response
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 restaurant(rid):
get_session = request.cookies.get('pr_session')
user_id = get_id_from_db(get_session)
query = "select restaurant_name, restaurant_phone, restaurant_location, restaurant_id from pr_restaurant as r1, (select e2.location_id as location_id from (select univ_id from pr_user where user_id = '%d') as e1, pr_university as e2 where e1.univ_id = e2.univ_id) as r2 where r1.location_id = r2.location_id and r1.restaurant_kind = '%d';"
query2 = "select food_name, food_price from pr_food where restaurant_id = '%d'"
table_all = select_all(query % (user_id, rid))
restaurant_List = list()
menu_dic = dict()
for table_one in table_all:
menu_list = list()
menu_table = select_all(query2 % int(table_one[3]))
for mtable_one in menu_table:
menu_dic = {'food_name': mtable_one[0], 'food_price': mtable_one[1]}
menu_list.append(menu_dic)
r_dic = {'phoneNumber': table_one[1], 'location': table_one[2], 'title': table_one[0], 'menulist': menu_list}
restaurant_List.append(r_dic)
return jsonify(results = restaurant_List)
def user_recommend():
get_session = request.cookies.get('pr_session')
user_id = get_id_from_db(get_session)
query = "select chief_id, room_title, restaurant_id, created, room_id from room as r1, (select e2.location_id as location_id from (select univ_id from pr_user where user_id = '%d') as e1, pr_university as e2 where e1.univ_id = e2.univ_id) as r2 where r1.location_id = r2.location_id order by created desc;"
table_all = select_all(query % user_id)
room_List = list()
for table_one in table_all:
username = get_username_from_db(table_one[0])
rname = get_restaurantname_from_db(table_one[2])
room_dic = { 'user_name':username,'room_title': table_one[1], 'restaurant_name':rname,'created':table_one[3], 'room_id':table_one[4]}
room_List.append(room_dic)
myindex = 0
query = "select user_id from pr_user"
userAll = select_all(query)
userList = list()
for index in userAll:
userList.append(index[0])
sets = [set() for _ in range(0, len(userList))]
for index in range(0, len(userList)):
if (userList[index] == user_id):
myindex = index
query = "select food_id from user_orderlist where user_id = '%d'"
temp = select_all(query % userList[index])
orderList = list()
for i in temp:
orderList.append(i[0])
for i in range(0, len(orderList)):
sets[index].add(orderList[i])
datas = []
for i in range(0, len(userList)):
temp = []
for j in range(0, len(userList)):
if (i != j):
a = sets[i]
b = sets[j]
temp.append(len(a & b) / len(a | b))
else:
temp.append(0)
datas.append(temp)
#print(datas)
df_x = pd.DataFrame(datas)
nCluster = len(userList) ** 0.5
kmeans = KMeans(n_clusters=round(nCluster), random_state=0).fit(df_x)
print(kmeans.labels_)
recommands = set()
mine = sets[myindex]
print(myindex)
for index in range(0,len(kmeans.labels_)):
if (kmeans.labels_[myindex] == kmeans.labels_[index]):
recommands = recommands.union(sets[index] - mine)
recommend_list = list(recommands)
print(recommend_list)
list_len = len(recommend_list)
recommend_info = list()
i = 100
print(len(recommend_list))
while i < 120:
if(recommend_list[i] >= 10000):
print(recommend_list[i])
query = "select restaurant_id from pr_food where food_id = '%d'"
get_table = select_one(query % recommend_list[i])
query2 = "select restaurant_name from pr_restaurant where restaurant_id = '%d'"
rname = select_one(query2 % get_table[0])
restaurant_name = rname[0]
query3 = "select food_name from pr_food where food_id = '%d'"
fname = select_one(query3 % recommend_list[i])
food_name = fname[0]
query4 = "select food_price from pr_food where food_id = '%d'"
fprice = select_one(query4 % recommend_list[i])
food_price = fprice[0]
rdic = {'restaurant_name': restaurant_name, 'food_name': food_name, 'food_price': food_price}
recommend_info.append(rdic)
i+=1
return jsonify(results = recommend_info)