2023监理工程师成绩查询时间

本文解答了关于《2023监理工程师成绩查询时间》相关内容，同时关于1、2023监理工程师成绩查询时间,2、2023监理工程师成绩查询时间是几号,3、2023监理工程师成绩查询时间是多少,4、202年监理工程师成绩查询时间,5、21年监理工程师考试成绩查询,的相关问答本篇文章福途教育网小编也整理了进来，希望对您有帮助。

监理工程师成绩查询时间

:param args:

:param kwargs:

:return:

"""

begin_time, end_time = args

if begin_time == None and end_time == None:

begin_time = datetime.date(1991, 1, 1)

end_time = datetime.date.today()

designer_sql = "select id, name, grade, grade_date, add_time from manager_designer where `grade_date` > %s and `grade_date` < %s and grade > 0 ORDER BY `grade` desc;"

with db.conn() as cursor:

cursor.execute(designer_sql, (begin_time, end_time))

designer_result = cursor.fetchall()

with db.conn() as cursor:

supervisor_sql = "select id, name, grade, grade_date, add_time from manager_supervisor where `grade_date` > %s and `grade_date` < %s and grade > 0 ORDER BY `grade` desc;"

cursor.execute(supervisor_sql, (begin_time, end_time))

supervisor_result = cursor.fetchall()

return {

"designer": designer_result,

"supervisor": supervisor_result

}