def ev_add_user(bot: TeleBot, db: DBHelper, user_id):
try:
admins_id = db.get_general_admin_id()
print(admins_id) #-----------------
info = db.get_user_info(user_id)
msg_txt = f" 🆕 Yangi foydalanuvchi qo`shildi!\n" \
f" <b>Ismi:</b> {info['name']}\n" \
f" <b>Foydalanuvchi nomi:</b> {info['user_name']}\n" \
f" <b>ID:</b> {info['user_id']}\n" \
f" <b>Guruhi:</b> {info['group']}"
for id in admins_id:
bot.send_message(id, msg_txt, parse_mode='HTML')
except:
writer_log(sys.exc_info())
def mk_faculties(db: DBHelper):
try:
items = convert_list(db.get_faculties())
keyboard_markup = ReplyKeyboardMarkup(row_width=1, resize_keyboard=True)
for item in items:
btn = KeyboardButton(text=item)
keyboard_markup.add(btn)
return keyboard_markup
except Exception as e:
print(e)
def mk_directions(db: DBHelper, stage_id, faculty_id):
try:
items = convert_list(db.get_directions(stage_id, faculty_id))
keyboard_markup = ReplyKeyboardMarkup(row_width=1, resize_keyboard=True)
for item in items:
btn = KeyboardButton(text=item)
keyboard_markup.add(btn)
keyboard_markup.add(text_back)
return keyboard_markup
except Exception as e:
print(e)
def get_all_remind_times(db: DBHelper, section_id):
try:
# [[1, 10], [2, 5], [3, 2], [4, 1]]
delta_time = convert_matrix(db.get_delta_times())
re_times = db.get_start_times(section_id)
times_dict = {}
if type(re_times) == list:
for i in range(len(re_times)):
temp_time = re_times[i][1]
temp = []
for dt in delta_time:
tm = datetime.strptime(temp_time, '%H:%M')
delta = timedelta(minutes=dt[1])
ret = tm - delta
ret_time = ret.strftime('%H:%M')
ret_method = dt[0]
temp.append([ret_method, ret_time])
times_dict[re_times[i][0]] = temp
return times_dict
except Exception:
writer_log(sys.exc_info())
def mk_groups(db: DBHelper, direction_id):
try:
items = convert_list(db.get_groups(direction_id))
keyboard_markup = ReplyKeyboardMarkup(row_width=2, resize_keyboard=True)
btns = []
for item in items:
btns.append(KeyboardButton(text=item))
while btns:
if len(btns) > 1:
keyboard_markup.row(btns.pop(0), btns.pop(0))
else:
keyboard_markup.add(btns.pop(0))
keyboard_markup.add(text_back)
return keyboard_markup
except Exception as e:
print(e)
def get_schedule_times(db: DBHelper):
try:
lesson_start_times = db.get_start_times()
print(lesson_start_times) # -----------------------
except Exception:
writer_log(sys.exc_info())
def get_times(db: DBHelper):
try:
methods = convert_list(db.get_methods())
return methods
except Exception:
writer_log(sys.exc_info())