def get_schema_of_prj(id_prj):
try:
schema_of_prj = {
"error": "success",
"timestamp": datetime.timestamp(datetime.now()),
"data": dict()
}
project_pms = dbase.get_pms_for_prj(id_prj)
project_devs = dbase.get_devs_for_prj(id_prj)
projects_dict = {
"id": id_prj,
"name": dbase.get_name_project(id_prj),
"pms": list(),
"developers": list()
}
for pm in project_pms:
projects_dict["pms"].append({
"id": pm[0],
"name": dbase.get_name_pm(pm[0]),
"telegram": dbase.get_username_of_tg(dbase.get_pm_tgid(pm[0]))[0],
})
for dev in project_devs:
projects_dict["developers"].append({
"id": dev[0],
"name": dbase.get_name_resource(dev[0]),
"telegram": dbase.get_username_of_tg(dbase.get_dev_tgid(dev[0]))[0]
})
schema_of_prj["data"] = projects_dict
return schema_of_prj
except:
return False
def get_list_prjs():
schema_of_prjs = {
"error": "success",
"timestamp": datetime.timestamp(datetime.now()),
"total": 0,
"offset": 0,
"perPage": 0,
"data": list()
}
list_of_id_prjs = dbase.get_list_of_id_prjs()
for id_prj in list_of_id_prjs:
project_pms = dbase.get_pms_for_prj(id_prj)
project_devs = dbase.get_devs_for_prj(id_prj)
projects_dict = {
"id": id_prj,
"name": dbase.get_name_project(id_prj),
"pms": list(),
"developers": list()
}
for pm in project_pms:
projects_dict["pms"].append({
"id": pm[0],
"name": dbase.get_name_pm(pm[0]),
"telegram": dbase.get_username_of_tg(dbase.get_pm_tgid(pm[0]))[0],
})
for dev in project_devs:
projects_dict["developers"].append({
"id": dev[0],
"name": dbase.get_name_resource(dev[0]),
"telegram": dbase.get_username_of_tg(dbase.get_dev_tgid(dev[0]))[0]
})
schema_of_prjs["data"].append(projects_dict)
return Response(json.dumps(schema_of_prjs, ensure_ascii=False), mimetype='application/json')
def get_list_pms():
schema_of_pms = {
"error": "success",
"timestamp": datetime.timestamp(datetime.now()),
"total": 0,
"offset": 0,
"perPage": 0,
"data": list()
}
list_of_id_pms = dbase.get_list_of_id_pms()
for id_pm in list_of_id_pms:
pm_projects = dbase.get_prjs_for_idpm(id_pm)
projects_list = list()
for prj in pm_projects:
projects_list.append({
"id": prj[0],
"name": dbase.get_name_project(prj[0])
})
dict_for_pm = {
"name": dbase.get_name_pm(id_pm),
"telegram": dbase.get_username_of_tg(dbase.get_pm_tgid(id_pm))[0],
"projects": projects_list
}
schema_of_pms["data"].append(dict_for_pm)
return Response(json.dumps(schema_of_pms, ensure_ascii=False), mimetype='application/json')
def str_for_schedule_pm_message(message, nowdate): id_pm = dbase.get_pm_sqlid(message.chat.id) stroka = '📆' + nowdate stroka += '\n👨🎨: ' + dbase.get_name_pm(id_pm) + '\n' + '📌️' * 8 list_of_pdh = dbase.get_list_of_prj_dev_hours(id_pm, nowdate) for ls in list_of_pdh: stroka += dbase.get_str_for_info(ls[0], ls[1], ls[2]) return stroka
def update_schedule(message, id_prj):
bot.delete_message(message.chat.id, message.message_id)
id_dev = dict_dev[message.chat.id]
tg_id_dev = dbase.get_dev_tgid(id_dev)
id_prj_from = dict_from_prj[message.chat.id]
sendhours = totalhours[message.chat.id]
id_to_pm = dict_to_pm[message.chat.id]
tg_id_to_pm = dbase.get_pm_tgid(id_to_pm)
id_from_pm = dbase.get_pm_sqlid(message.chat.id)
mydate = dict_for_schedule[message.chat.id]
dbase.update_base(message, mydate, int(id_prj), id_dev, id_prj_from, sendhours, id_to_pm)
bot.send_message(message.chat.id, 'Ресурс передан!!',
reply_markup=markup.back_to_main_menu())
bot.send_message(tg_id_dev, 'Ваше расписание на 📆' + mydate + ' сменилось\n'
'ПМ:👨🎨{} сместил ⏳{}ч. Вас с проекта #{} на проект #{}\n'
'Проверьте свое расписание!!!'.format(dbase.get_name_pm(id_from_pm), sendhours, dbase.get_name_project(id_prj_from), dbase.get_name_project(int(id_prj))))
bot.send_message(tg_id_to_pm, "Ваше расписание на {} сменилось\n"
"ПМ:👨🎨{} передал Вам на ⏳{}ч. 👨💻:{} на проект #{}\n"
"Проверьте свое расписание!!!".format(mydate, dbase.get_name_pm(id_from_pm), dbase.get_name_resource(id_dev),
sendhours, dbase.get_name_project(id_prj)))
def update_schedule_for_distribute(message):
# bot.delete_message(message.chat.id, message.message_id)
id_from_pm = dbase.get_pm_sqlid(message.chat.id)
id_dev = dict_distribute_dev[message.chat.id]
tg_id_dev = dbase.get_dev_tgid(id_dev)
id_prj = dict_distribute_prj[message.chat.id]
usehours = dict_distribute_hours[message.chat.id]
usedate = dict_distribute_date[message.chat.id]
dbase.update_base_distribute(message, usedate, id_prj, id_dev, usehours)
bot.send_message(tg_id_dev, "У вас новая задача на 📆{}\n"
"ПМ:👨🎨{} добавил Вам ⏳{}ч. на проект #{}\n"
"Проверьте свое расписание!!!".format(usedate, dbase.get_name_pm(id_from_pm), usehours, dbase.get_name_project(id_prj)))
bot.send_message(message.chat.id, 'Задача поставлена!!!',
reply_markup=markup.back_to_main_menu())
def get_schema_of_pm(id_pm):
try:
schema_of_pm = {
"error": "success",
"timestamp": datetime.timestamp(datetime.now()),
"data": dict()
}
pm_projects = dbase.get_prjs_for_idpm(id_pm)
projects_list = list()
for prj in pm_projects:
projects_list.append({
"id": prj[0],
"name": dbase.get_name_project(prj[0])
})
data = {
"name": dbase.get_name_pm(id_pm),
"telegram": dbase.get_username_of_tg(dbase.get_pm_tgid(id_pm))[0],
"projects": projects_list
}
schema_of_pm["data"] = data
except:
return False
return schema_of_pm