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() )