Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import openpyxl
- from datetime import datetime, date, time, timedelta
- import telebot
- import types
- from telebot import types
- import locale
- wb = openpyxl.reader.excel.load_workbook(filename="grafik.xlsx", data_only=True)
- #print(wb.sheetnames) #вывести активный лист экселя, нужно для отладки
- wb.active = 0
- sheet = wb.active
- TOKEN = '1611510367:AAHEshF63oL4hE1r12PshXgwpva3w8jBOA8'
- bot = telebot.TeleBot(TOKEN)
- #tb.send_message(chatid, message)
- bot.send_message(384341050, 'Я запустился и работаю')
- @bot.message_handler(commands=['start', 'help'])
- def command_help(message):
- if message.text == '/start':
- bot.reply_to(message, "ХаудиХо, че как?")
- elif message.text == '/help':
- bot.reply_to(message, "Сломали ? \n По вопросам работоспособности бота писать его создателю - @kpakhotin")
- def na_smene() :
- for i in range(2, 33):
- now = datetime.now()
- locale.setlocale(locale.LC_ALL, "")
- timedelta = now - sheet['A' + str(i)].value
- if timedelta.days == 0:
- return sheet['B' + str(i)].value
- @bot.message_handler(func=lambda message: True)
- def get_text_messages(message):
- if message.text == "/kto_segodnya":
- def na_smene():
- for i in range(2, 33):
- now = datetime.now()
- timedelta = now - sheet['A' + str(i)].value
- if timedelta.days == 0:
- return "\nИз 24\7 сегодня на смене : " + sheet['B' + str(i)].value + "\nВ ночную сегодня : "+ sheet['C' + str(i)].value+'\nДежурный инженер сегодня : ' +sheet['D' + str(i)].value
- # keyboard = types.InlineKeyboardMarkup()
- # key_write1 = types.InlineKeyboardButton(text='Написать 123', url='https://telegram.me/kpakhotin')
- # key_write2 = types.InlineKeyboardButton(text='Написать 456', url='https://telegram.me/kpakhotin')
- # key_write3 = types.InlineKeyboardButton(text='Написать 789', url='https://telegram.me/kpakhotin')
- # keyboard.add(key_write1)
- # keyboard.add(key_write2)
- # keyboard.add(key_write3)
- now = datetime.now()
- locale.setlocale(locale.LC_ALL, "")
- pretty_result = 'Сегодня ' + now.strftime("%d %B (%A)") + na_smene()
- bot.reply_to(message, text=pretty_result)#, reply_markup=keyboard)
- bot.polling(none_stop=True, interval=0)
Advertisement
Add Comment
Please, Sign In to add comment