def get_district_subject_std_values(subject_name, table_code):
    wheres = [school_where, exam_where]
    if subject_name == "总分":
        stu_table = table_config.get_stu_sum_table(table_code)
        school_table = table_config.get_school_sum_table(table_code)
    else:
        stu_table = table_config.get_stu_dimen_table(table_code)
        school_table = table_config.get_school_dimen_table(table_code)

        subject_where.set_value(get_subject_id_by_name(subject_name))
        wheres.append(subject_where)

    subject_total = report_config.get_total(subject_name)

    xresult = []
    yresult = []

    school_subject_num_cell = qa.Cell("num_nz", school_table, wheres)
    school_subject_num_row = qa.RowSeriesCell(school_subject_num_cell, school_ids)

    school_subject_avg_cell = qa.Cell("ROUND(avg / %d, 2)" % subject_total, school_table, wheres)
    school_subject_avg_row = qa.RowSeriesCell(school_subject_avg_cell, school_ids)

    stu_subject_sum_cell = qa.Cell("sum", stu_table, wheres)
    stu_subject_sum_row = qa.ColSeriesCell(stu_subject_sum_cell, school_ids)

    for value in stu_subject_sum_row.get_values():
        yresult.append(round(np.std(value, ddof=1), 2))
    xresult = school_subject_avg_row.get_values()[0]
    num = school_subject_num_row.get_values()[0]
    return xresult, yresult, num
def get_district_subject_distribution_values(subject_name, ids, table_code):
    distribution = report_config.get_distribution(subject_name)
    statistics_type = distribution[0]

    greater_where = qa.Where("sum", symbol=">")
    less_equal_where = qa.Where("sum", symbol="<=")

    basic_where = [exam_where]
    if subject_name == "总分":
        dimen_table = table_config.get_stu_sum_table(table_code)
        if statistics_type == report_config.COUNT:
            basic_where.append(qa.Where("count", value=distribution[2]))
    else:
        dimen_table = table_config.get_stu_dimen_table(table_code)
        subject_where.value = get_subject_id_by_name(subject_name)
        basic_where.append(subject_where)

    normal_cell = qa.Cell("COUNT(*)", dimen_table, [[greater_where, less_equal_where]] + basic_where)
    if statistics_type == report_config.ALL:
        greater_equal_where = qa.Where("sum", symbol=">=")
        extra_cell = qa.Cell("COUNT(*)", dimen_table, [[greater_equal_where, less_equal_where]] + basic_where)
        row1 = qa.RowSeriesCell(extra_cell, ids[0:1])
        row2 = qa.RowSeriesCell(normal_cell, ids[1:])
        return qa.DataRows.combine_col_rows(row1, row2)
    else:
        row = qa.RowSeriesCell(normal_cell, ids)
        return row.get_values()
Exemple #3
0
def test2():
    ids = []
    names = []
    start, end, step = [0, 150, 5]
    scopes = range(start, end, step)

    for index, scope in enumerate(scopes[0:-1]):
        ids.append([scope, scopes[index + 1]])
        names.append("(%d, %d]" % (scope, scopes[index + 1]))
    if scopes[-1] < end:
        ids.append([scopes[-1], end])
        names.append("(%d, %d]" % (scopes[-1], end))
    names[0] = "[%d, %d]" % (scopes[0], scopes[1])

    greater_equal_where = qa.Where("sum", symbol=">=")
    greater_where = qa.Where("sum", symbol=">")
    less_equal_where = qa.Where("sum", symbol="<=")

    cell1 = qa.Cell(
        "COUNT(*)", stu_dimen_table,
        [[greater_equal_where, less_equal_where], exam_where, subject_where])
    cell2 = qa.Cell(
        "COUNT(*)", stu_dimen_table,
        [[greater_where, less_equal_where], exam_where, subject_where])
    row1 = qa.RowSeriesCell(cell1, ids[0:1])
    row2 = qa.RowSeriesCell(cell2, ids[1:])
    table = qa.TableRows(["分数段", names], ['个数'], [row1, row2])
    for table_row in table.get_values():
        print(table_row)
def get_district_subject_std_values(subject_name, type_code, table_code):
    wheres = [school_where, exam_where]
    if subject_name == "总分":
        stu_table = table_config.get_stu_sum_table(table_code)
        school_table = table_config.get_school_table(type_code)[1]
    else:
        stu_table = table_config.get_stu_dimen_table(table_code)
        school_table = table_config.get_school_table(type_code)[0]

        subject_where.set_value(get_subject_id_by_name(subject_name))
        wheres.append(subject_where)

    subject_total = report_config.get_total(subject_name)

    xresult = []
    yresult = []

    school_subject_num_cell = qa.Cell("num_nz", school_table, wheres)
    school_subject_num_row = qa.RowSeriesCell(school_subject_num_cell,
                                              school_ids)
    for school_id in school_ids:
        school_where.set_value(school_id)
        school_subject_avg_cell = qa.Cell("avg", school_table, wheres)
        stu_subject_sum_cell = qa.Cell("sum", stu_table, wheres)
        xresult.append(
            round(school_subject_avg_cell.get_value() / subject_total, 2))
        yresult.append(
            round(np.std(stu_subject_sum_cell.get_row_values(), ddof=1), 2))
    num = school_subject_num_row.get_values()[0]
    return xresult, yresult, num
    def __init__(self, exam, gradation, where):
        self.exam = exam
        self.gradation = gradation
        self.where = where

        # self.exam = handler.Exam()
        # self.gradation = handler.Gradation()
        # self.where = handler.Where()

        self.cell_where = qa.CellWhere()
        self.cell_order = qa.CellOrder()

        self.cell = qa.Cell(where_list=self.cell_where)
        self.order_cell = qa.CellWithOrders(where_list=self.cell_where, order=self.cell_order)

        self.row_value = qa.RowSeriesCell()
        self.col_value = qa.ColSeriesCell()
Exemple #6
0
def test3():
    print(school_names)
    subject_total = 150
    xresult = []
    yresult = []
    school_subject_num_cell = qa.Cell(
        "num_nz", "qa_school_dimen", [school_where, exam_where, subject_where])
    school_subject_num_row = qa.RowSeriesCell(school_subject_num_cell,
                                              school_ids)
    for school_id in school_ids:
        school_subject_avg_cell = qa.Cell(
            "avg", "qa_school_dimen",
            [school_where, exam_where, subject_where])
        school_where.value = school_id
        xresult.append(school_subject_avg_cell.get_value() / subject_total)
        stu_subject_sum_cell = qa.Cell(
            "sum", "qa_stu_dimen", [exam_where, school_where, subject_where])
        yresult.append(np.std(stu_subject_sum_cell.get_row_values(), ddof=1))
    print(xresult)
    print(yresult)
    print(school_subject_num_row.get_values()[0])
 def get_value(self):
     return qa.RowSeriesCell(self.get_cell(), self.ids).get_values()
Exemple #8
0
 def get_row_value(cell, ids):
     return qa.RowSeriesCell(cell, ids).get_values()