async def confirm_location_for_order(message: Message):
if message.location is not None:
psql = PostgreSQL()
psql.insert(
(
'first_name',
'last_name',
'meal_name',
'meal_type',
'phone_number',
'location',
),
(
message.from_user.first_name,
message.from_user.last_name,
order_list[0].split(' ')[1],
order_list[0].split(' ')[0],
order_list[1],
f'{message.location.latitude} {message.location.longitude}'
),
'orders'
)
await BotStates.check_clicked_button.set()
psql.connection.close()
return await bot.send_message(
chat_id = message.from_user.id,
text = 'Ваш заказ успешно сохранен'
)
async def confirm_number_for_feedback(message:Message):
if message.contact is not None:
psql = PostgreSQL()
psql.insert(
(
'author_id',
'author_first_name',
'author_last_name',
'author_phone_number',
'feedback_text',
),
(
feedback_message.from_user.id,
feedback_message.from_user.first_name,
feedback_message.from_user.last_name,
message.contact.phone_number,
feedback_message.text,
),
'feedbacks'
)
psql.connection.close()
await BotStates.feedback_menu.set()
return await bot.send_message(
chat_id=message.from_user.id,
text = '*Ваш отзыв успешно сохранён 😅*',
reply_markup=btns.feedback_buttons()
)
async def confirm_number_for_reservation(message:Message):
if message.contact is not None:
psql = PostgreSQL()
psql.insert(
(
'first_name',
'last_name',
'month_of_reservation',
'day_of_reservation',
'time_of_reservation',
'phone_number',
),
(
message.from_user.first_name,
message.from_user.last_name,
reservation_list[0],
reservation_list[1],
reservation_list[2],
message.contact.phone_number
),
'reservations'
)
psql.connection.close()
await BotStates.show_main_menu_buttons.set()
return await bot.send_message(
chat_id=message.from_user.id,
text = '*Столик успешно забронирован 😅*',
reply_markup=btns.main_buttons()
)
