def tsn_streets(message):
message_menu = menu.all_street("SELECT name FROM street")
tsn_keyboard = types.InlineKeyboardMarkup(row_width=1)
tsn_button = types.InlineKeyboardButton(text="Вернуться в меню ТСН", callback_data="/tsn")
tsn_keyboard.add(tsn_button)
keyboards.main_menu_key(tsn_keyboard)
bot.send_message(message.chat.id, message_menu, reply_markup=tsn_keyboard)
def tsn_requisites(message):
message_menu = menu.get_menu("SELECT text FROM tsn_info WHERE name LIKE 'requisites'")
tsn_keyboard = types.InlineKeyboardMarkup(row_width=1)
tsn_button = types.InlineKeyboardButton(text="Вернуться в меню ТСН", callback_data="/tsn")
tsn_keyboard.add(tsn_button)
keyboards.main_menu_key(tsn_keyboard)
bot.send_message(message.chat.id, message_menu, reply_markup=tsn_keyboard)
def tsn(message):
tsn_keyboard = types.InlineKeyboardMarkup(row_width=1)
userinfo_button = types.InlineKeyboardButton(text="Ваши данные в ТСН", callback_data="/userinfo")
requisites_button = types.InlineKeyboardButton(text="реквизиты ТСН", callback_data="/requisites")
contacts_button = types.InlineKeyboardButton(text="полезные телефоны", callback_data="/contacts")
street_button = types.InlineKeyboardButton(text="список улиц", callback_data="/street")
tsn_keyboard.add(userinfo_button, requisites_button, contacts_button, street_button)
keyboards.main_menu_key(tsn_keyboard)
bot.send_message(message.chat.id, "Выберите раздел\n", reply_markup=tsn_keyboard)
def tsn_userinfo(message, user_info):
if security.check_user_id(user_info):
message_menu = menu.get_user_info("SELECT * from users WHERE telegram_id={};".format(user_info))
tsn_keyboard = types.InlineKeyboardMarkup(row_width=1)
tsn_button = types.InlineKeyboardButton(text="Вернуться в меню ТСН", callback_data="/tsn")
tsn_keyboard.add(tsn_button)
keyboards.main_menu_key(tsn_keyboard)
bot.send_message(message.chat.id, message_menu + str(user_info), reply_markup=tsn_keyboard)
else:
message_menu = menu.get_menu("SELECT text FROM menu_text WHERE name LIKE 'tsn_access_deny'")
tsn_keyboard = types.InlineKeyboardMarkup(row_width=1)
get_id_button = types.InlineKeyboardButton(text="Получить Telegram ID", callback_data="/getid")
tsn_keyboard.add(get_id_button)
keyboards.main_menu_key(tsn_keyboard)
bot.send_message(message.chat.id, message_menu, reply_markup=tsn_keyboard)
def services(message):
services_keyboard = types.InlineKeyboardMarkup(row_width=2)
build_button = types.InlineKeyboardButton(text="Строительство",
callback_data="build")
inside_build_button = types.InlineKeyboardButton(
text="Внутренняя отделка", callback_data="inside_build")
bulk_button = types.InlineKeyboardButton(text="Сыпучие материалы",
callback_data="bulk")
land_button = types.InlineKeyboardButton(text="Ландшафт, геодезия",
callback_data="land")
well_button = types.InlineKeyboardButton(text="Колодцы, скважины",
callback_data="well")
water_button = types.InlineKeyboardButton(text="Вода доставка",
callback_data="water")
warm_button = types.InlineKeyboardButton(text="Отопление",
callback_data="warm")
electric_button = types.InlineKeyboardButton(text="Электрика",
callback_data="electric")
windows_button = types.InlineKeyboardButton(text="Окна, остекление",
callback_data="windows")
tractor_button = types.InlineKeyboardButton(text="Трактор, экскаватор",
callback_data="tractor")
plumbing_button = types.InlineKeyboardButton(text="Сантехника",
callback_data="plumbing")
sewerage_button = types.InlineKeyboardButton(text="Канализация",
callback_data="sewerage")
clean_watter_button = types.InlineKeyboardButton(
text="Очистка воды", callback_data="clean_water")
air_button = types.InlineKeyboardButton(text="Кондиционеры и тд",
callback_data="air")
auto_button = types.InlineKeyboardButton(text="Автосервисы",
callback_data="auto")
services_keyboard.add(build_button, inside_build_button, bulk_button,
tractor_button, well_button, warm_button,
water_button, land_button, electric_button,
plumbing_button, clean_watter_button,
sewerage_button, windows_button, air_button,
auto_button)
keyboards.main_menu_key(services_keyboard)
bot.send_message(message.chat.id,
"Выберите раздел с услугой:\n",
reply_markup=services_keyboard)
def services_build(message, user_info):
if security.check_user_id(user_info):
services_keyboard = types.InlineKeyboardMarkup(row_width=2)
house_button = types.InlineKeyboardButton(text="Дома",
callback_data="build_house")
roof_button = types.InlineKeyboardButton(text="Кровля",
callback_data="build_roof")
facade_button = types.InlineKeyboardButton(
text="Фасадные работы", callback_data="build_facade")
other_button = types.InlineKeyboardButton(text="Разное",
callback_data="build_other")
service_button = types.InlineKeyboardButton(
text="Вернуться в меню услуг", callback_data="/services")
services_keyboard.add(house_button, roof_button, facade_button,
other_button)
services_keyboard.add(service_button)
keyboards.main_menu_key(services_keyboard)
bot.send_message(message.chat.id,
"Выберите подраздел в разделе Строительство:\n",
reply_markup=services_keyboard)
def government_message(message):
government_keyboard = types.InlineKeyboardMarkup(row_width=1)
keyboards.main_menu_key(government_keyboard)
bot.send_message(message.chat.id,
'К сожалению в данный момент раздел в разработке',
reply_markup=government_keyboard)
def default_text(message):
default_keyboard = types.InlineKeyboardMarkup(row_width=1)
keyboards.main_menu_key(default_keyboard)
bot.send_message(message.chat.id,
'К сожалению я не знаю такой команды',
reply_markup=default_keyboard)
def get_id(message, user_info):
get_id_keyboard = types.InlineKeyboardMarkup(row_width=1)
keyboards.main_menu_key(get_id_keyboard)
bot.send_message(message.chat.id,
"Ваш telegram ID: " + str(user_info),
reply_markup=get_id_keyboard)
def get_servises(message, user_info, service_group):
if security.check_user_id(user_info):
con = psycopg2.connect(database=os.environ['DB_NAME'],
user=os.environ['DB_USER'],
password=os.environ['DB_PASS'],
host=os.environ['DB_HOST'],
port=os.environ['DB_PORT'])
services_keyboard = types.InlineKeyboardMarkup(row_width=1)
with con.cursor() as cur:
cur.execute(
" SELECT description, contact, first_tel, second_tel, email, url, vk, instagram, other_contact"
" FROM services WHERE service_group='{}';".format(
service_group))
rows = cur.fetchall()
print(len(rows))
if len(rows) == 0:
service_button = types.InlineKeyboardButton(
text="Вернуться в меню услуг", callback_data="/services")
services_keyboard.add(service_button)
keyboards.main_menu_key(services_keyboard)
bot.send_message(
message.chat.id,
"К сожалению в данном разделе пока нет записей",
reply_markup=services_keyboard)
else:
for row in rows:
bot_message = ""
if row[0]:
bot_message = bot_message + row[0] + "\n\n"
if row[1]:
bot_message = bot_message + "Контактное лицо: " + row[
1] + "\n\n"
if row[2]:
bot_message = bot_message + "Тел: " + row[2] + "\n\n"
if row[3]:
bot_message = bot_message + "Тел: " + row[3] + "\n\n"
if row[4]:
bot_message = bot_message + "email: " + row[4] + "\n\n"
if row[5]:
bot_message = bot_message + "сайт: " + row[5] + "\n\n"
if row[6]:
bot_message = bot_message + "VK:\n" + row[6] + "\n\n"
if row[7]:
bot_message = bot_message + "Instagram:\n" + row[
7] + "\n\n"
if row[8]:
bot_message = bot_message + "Дополнительная информация:\n" + row[
8] + "\n\n"
time.sleep(1)
bot.send_message(message.chat.id, bot_message)
service_button = types.InlineKeyboardButton(
text="Вернуться в меню услуг", callback_data="/services")
services_keyboard.add(service_button)
keyboards.main_menu_key(services_keyboard)
bot.send_message(
message.chat.id,
"Запрос выполнен успешно найдено {} записи(ей)".format(
len(rows)),
reply_markup=services_keyboard)
else:
message_menu = menu.get_menu(
"SELECT text FROM menu_text WHERE name LIKE 'tsn_access_deny'")
services_keyboard = types.InlineKeyboardMarkup(row_width=1)
get_id_button = types.InlineKeyboardButton(text="Получить Telegram ID",
callback_data="/getid")
services_keyboard.add(get_id_button)
keyboards.main_menu_key(services_keyboard)
bot.send_message(message.chat.id,
message_menu,
reply_markup=services_keyboard)