def get_exam_ids(enroll_year, grade_lev):
sql = """
SELECT examId
FROM qam_semester_info
WHERE enrollYear = %d AND gradeLev = %d
ORDER BY gradeId, xq, examType;
""" % (enroll_year, grade_lev)
return list_util.to_a_list(base_dao.select(sql))
def get_where_list(self):
where_list = [self.varied]
if isinstance(self.fixed, list):
where_list += self.fixed
else:
where_list.append(self.fixed)
return str_util.list_to_str(list_util.to_a_list(where_list),
symbol=" AND")
def get_all_distribution(self, item, table_code, subject_id=None):
ids = self.exam.get_subject_distribution_ids(subject_id)
self.set_one_row(item, table_code, STU_CODE, subject_id)
self.cell_where.varied = self.where.get_varied_greater_equal_less_equal()
self.row_value.set(self.cell, ids[0:1])
greater_equal_value = self.row_value.get_values()
self.cell_where.varied = self.where.get_varied_greater_less_equal()
self.row_value.set(self.cell, ids[1:])
greater_value = self.row_value.get_values()
return list_util.to_a_list([greater_equal_value, greater_value])
def get_values(self):
self.first_row = list_util.to_a_list(self.first_row)
result = [self.first_row]
if isinstance(self.first_col[0], list):
result.extend(
list_util.combine_values_by_col(
self.first_col, DataRows.get_values(*self.data_rows)))
else:
for index, data_row in enumerate(
DataRows.get_values(*self.data_rows)):
data_row.insert(0, self.first_col[index])
result.append(data_row)
return result
def get_value(self):
return list_util.to_a_list(
[self.values,
super(AllDistributionValue, self).get_value()])
school_line_table = "qa_school_line"
class_dimen_table = "qa_class_dimen"
class_sum_table = "qa_class_sum"
school_rank_diff_table = [
"qa_school_dimen AS font", "qa_school_dimen AS behind"
]
district_ids = qam_dao.get_all_district_ids()
district_names = qam_dao.get_all_district_names()
school_ids = qam_dao.get_all_school_ids(grade_lev)
school_names = qam_dao.get_all_school_names(grade_lev)
school_class_ids = qam_dao.get_all_school_class_ids(class_sum_table, exam_id,
grade_lev,
sum_rank_five_item)
school_class_names = qam_dao.get_all_school_class_names(
class_sum_table, exam_id, grade_lev, sum_rank_five_item)
district_school_names = list_util.to_a_list([district_names, school_names])
subject_ids = [121, 122, 103, 118, 128]
exam_ids = [
"3f2a81437b944569aacb675a6544b2f3", "7c5315bb7c7a4cdb854d2893bfaebce5",
"661cb10d97ae48c4a7207f1da9f6acdd", "8c4646637f44489c9ba9333e580fe9d0",
"af8535da67de463ea7e5617168157ad4"
]
exam_diff_ids = [
["3f2a81437b944569aacb675a6544b2f3", "7c5315bb7c7a4cdb854d2893bfaebce5"],
["7c5315bb7c7a4cdb854d2893bfaebce5", "661cb10d97ae48c4a7207f1da9f6acdd"],
["661cb10d97ae48c4a7207f1da9f6acdd", "8c4646637f44489c9ba9333e580fe9d0"],
["8c4646637f44489c9ba9333e580fe9d0", "af8535da67de463ea7e5617168157ad4"],
["3f2a81437b944569aacb675a6544b2f3", "af8535da67de463ea7e5617168157ad4"]
]
def get_row_values(self):
return list_util.to_a_list(base_dao.select(self.get_sql()))