from main import *
from aiogram import types
import markups as mark
import config as con
from aiogram.types import InlineKeyboardButton, InlineKeyboardMarkup
from sql import *

@dp.message_handler(commands = ['start'])
async def start(message: types.Message):
    if message.from_user.id == con.ADMIN_ID:
        await bot.send_message(message.from_user.id, 'Привет, создатель 👑 !\n \n🔑Чтобы зайти в меню админа напишите /admin', reply_markup = mark.main)
    else:
        await bot.send_message(message.from_user.id, 'Привет, {0.first_name} !\n \n📌Заходи в каталог и выбирай товары!'.format(message.from_user), reply_markup = mark.main)

@dp.message_handler(text = '📱 Контакты')
async def view_contacts(message: types.Message):
    await bot.delete_message(message.from_user.id, message.message_id)
    await bot.send_message(message.from_user.id, f'📱 Контакты: \n{con.contact}')

@dp.message_handler(text = '💰 Каталог')
async def view_catalog(message: types.Message):
    category = "SELECT category FROM categories"
    cursor.execute(category)
    fetch_categories = cursor.fetchall()
    categories_menu = InlineKeyboardMarkup(row_width=1)
    for i in fetch_categories:
        category_button = InlineKeyboardButton(text = i[0], callback_data = i[0])
        categories_menu.add(category_button)
    await bot.send_message(message.from_user.id, '📌 Выбери необходимую категорию товаров', reply_markup = categories_menu)