def take_contact(bot, telegram, first_name, phone_number): # send_menu text = GREETINS.format(first_name) message_id = bot.send_photo(telegram, WATER_PHOTO, text, reply_markup=menu[1].get('button')) try: del_menu(bot, telegram, users[telegram].get('mess_id')) except Exception as e: print('error', e) message_id = bot.send_message(telegram, NEED_PHONE_NUMBER, reply_markup=contact_menu()) del_menu(bot, telegram, message_id.message_id) # adding user to users check_connect() user = select_user(telegram) if user == []: print(phone_number) if phone_number[0] == '+': phone_number = phone_number[1::] connect_mysql.insert( 'users', **{ 'telegram': telegram, 'name': first_name, 'phone': phone_number }) all_rows = select_list_of_users() report(NEW_USER.format(first_name, phone_number, all_rows)) # adding user to menu user_menu = select_menu(telegram) if user_menu == []: connect_mysql.insert( 'menu', **{ 'telegram': telegram, 'message_id': message_id.message_id, 'text': text.encode('utf-8'), 'index': 1 }) else: update_menu(telegram, message_id.message_id, text, 1)
def insert_menu(telegram): check_connect() connect_mysql.insert('menu', **{'telegram': telegram})
def insert_news(telegram, new): check_connect() connect_mysql.insert('news', **{'telegram': telegram, 'new': new})
def add_sub(**kwargs): check_connect() return connect_mysql.insert('subscription', **kwargs)
def insert_order(**kwargs): check_connect() connect_mysql.insert('orders', **kwargs)
def add_package(**kwargs): check_connect() return connect_mysql.insert('packages', **kwargs)
def add_message_db(telegram, message_id): result = connect_mysql.insert('message', *["telegram", "branch"], **{'telegram': telegram, 'message_id': message_id}) return result
def add_branches_db(telegram, branch): result = connect_mysql.insert('branches', *["telegram", "branch"], **{'telegram': telegram, 'branch': branch}) return result