def __get_all_issues_info(self):
issues_module = IssuesInfoModule.get_all_issues_info()
if issues_module is None:
return None
issues_tables = []
for issues in issues_module:
tmp = {
"issues_id": issues.id,
"keynote_user_name": issues.user_name,
"issues_image": issues.issues_image,
"issues_title": issues.issues_title,
"keynote_chinese_name": issues.chinese_name,
"current": issues.current,
"finish": issues.finish,
"date_time": issues.expect_date_time,
"issues_brief": issues.issues_brief,
"issues_score": issues.issues_score,
"issues_meeting_room": issues.issues_meeting_room,
"issues_evaluate_finish": issues.issues_evaluate_finish,
"voluntary_apply": issues.voluntary_apply
}
issues_tables.append(tmp)
return issues_tables
def __get_all_topic_tables(self):
topics_module = IssuesInfoModule.get_all_issues_info()
if topics_module is None:
return None
topics_tables = []
for topics in topics_module:
tmp = {
"topic_id": topics.id, "name": topics.user_name, "image": topics.issues_image, "title": topics.issues_title,
"current": topics.current, "finish": topics.finish, "time": topics.expect_date_time,
"description": topics.issues_brief
}
topics_tables.append(tmp)
return topics_tables
def __get_all_no_finish_topics(self):
issues_module = IssuesInfoModule.get_all_issues_info()
if issues_module is None:
return None
issues_tables = []
for issues in issues_module:
if issues.finish is False:
tmp = {
"issues_id": issues.id,
"keynote_user_name": issues.user_name,
"issues_image": issues.issues_image,
"issues_brief": issues.issues_brief,
"issues_title": issues.issues_title,
"current_issues": issues.current,
"issues_finish": issues.finish,
"present_time": issues.expect_date_time,
"keynote_chinese_name": issues.chinese_name,
}
issues_tables.append(tmp)
return issues_tables
def __add_topics(self, topic_user, topic_name, topic_brief, topic_date):
rule = self.db.query(IssuesInfoModule).filter(IssuesInfoModule.issues_title == topic_name).first()
if rule is not None:
logging.error("current topics is exit")
return False
serial_number = SerialNumberToolKits()
topic_module = IssuesInfoModule()
topic_module.id = serial_number.get_serial_number_by_string(4)
topic_module.user_name = topic_user
topic_module.issues_title = topic_name
topic_module.issues_brief = topic_brief
topic_module.expect_date_time = topic_date
topic_module.current = False
topic_module.finish = False
topic_module.issues_image = "null"
topic_module.voluntary_apply = True
topic_module.is_system_user = True
user_info = self.db.query(UsersInfoModule).filter(UsersInfoModule.user_name == topic_user).first()
if user_info is not None:
topic_module.chinese_name = user_info.chinese_name
self.db.add(topic_module)
self.db.commit()
return True