常量

12114

常量总览

_constant结构

CREATE TABLE `_constant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `constantKey` varchar(255)  DEFAULT NULL,
  `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  `constantValue` text  COMMENT '常量内容; object, array',
  `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表; 软删除未启用;'

_constant 表数据

学部科目

• constantKey：segmentSubject

• constantType：object

{
  "小学": [
    {
      "value": "语文",
      "text": "语文",
      "width": 100
    },
    {
      "value": "数学",
      "text": "数学",
      "width": 100
    },
    {
      "value": "英语",
      "text": "英语",
      "width": 100
    },
    {
      "value": "体育",
      "text": "体育",
      "width": 100
    },
    {
      "value": "美术",
      "text": "美术",
      "width": 100
    },
    {
      "value": "书法",
      "text": "书法",
      "width": 100
    },
    {
      "value": "音乐",
      "text": "音乐",
      "width": 100
    },
    {
      "value": "舞蹈",
      "text": "舞蹈",
      "width": 100
    },
    {
      "value": "科学",
      "text": "科学",
      "width": 100
    },
    {
      "value": "编程",
      "text": "编程",
      "width": 100
    },
    {
      "value": "社团",
      "text": "社团",
      "width": 100
    },
    {
      "value": "心理健康",
      "text": "心理健康",
      "width": 100
    },
    {
      "value": "信息技术",
      "text": "信息技术",
      "width": 100
    },
    {
      "value": "红色文化",
      "text": "红色文化",
      "width": 100
    },
    {
      "value": "劳动实践",
      "text": "劳动实践",
      "width": 100
    },
    {
      "value": "班会",
      "text": "班会",
      "width": 100
    }
  ],
  "初中": [
    {
      "value": "语文",
      "text": "语文",
      "width": 100
    },
    {
      "value": "数学",
      "text": "数学",
      "width": 100
    },
    {
      "value": "英语",
      "text": "英语",
      "width": 100
    },
    {
      "value": "物理",
      "text": "物理",
      "width": 100
    },
    {
      "value": "化学",
      "text": "化学",
      "width": 100
    },
    {
      "value": "生物",
      "text": "生物",
      "width": 100
    },
    {
      "value": "历史",
      "text": "历史",
      "width": 100
    },
    {
      "value": "地理",
      "text": "地理",
      "width": 100
    },
    {
      "value": "政治",
      "text": "政治",
      "width": 100
    },
    {
      "value": "音乐",
      "text": "音乐",
      "width": 100
    },
    {
      "value": "美术",
      "text": "美术",
      "width": 100
    },
    {
      "value": "劳动",
      "text": "劳动",
      "width": 100
    },
    {
      "value": "信息技术",
      "text": "信息技术",
      "width": 100
    },
    {
      "value": "通用技术",
      "text": "通用技术",
      "width": 100
    },
    {
      "value": "体育",
      "text": "体育",
      "width": 100
    },
    {
      "value": "日语",
      "text": "日语",
      "width": 100
    },
    {
      "value": "班会",
      "text": "班会",
      "width": 100
    }
  ],
  "高中": [
    {
      "value": "语文",
      "text": "语文",
      "width": 100
    },
    {
      "value": "数学",
      "text": "数学",
      "width": 100
    },
    {
      "value": "英语",
      "text": "英语",
      "width": 100
    },
    {
      "value": "物理",
      "text": "物理",
      "width": 100
    },
    {
      "value": "化学",
      "text": "化学",
      "width": 100
    },
    {
      "value": "生物",
      "text": "生物",
      "width": 100
    },
    {
      "value": "历史",
      "text": "历史",
      "width": 100
    },
    {
      "value": "地理",
      "text": "地理",
      "width": 100
    },
    {
      "value": "政治",
      "text": "政治",
      "width": 100
    },
    {
      "value": "信息技术",
      "text": "信息技术",
      "width": 100
    },
    {
      "value": "通用技术",
      "text": "通用技术",
      "width": 100
    },
    {
      "value": "艺术",
      "text": "艺术",
      "width": 100
    },
    {
      "value": "体育",
      "text": "体育",
      "width": 100
    },
    {
      "value": "日语",
      "text": "日语",
      "width": 100
    },
    {
      "value": "辅导1",
      "text": "辅导1",
      "width": 100
    },
    {
      "value": "辅导2",
      "text": "辅导2",
      "width": 100
    },
    {
      "value": "辅导3",
      "text": "辅导3",
      "width": 100
    },
    {
      "value": "配班老师",
      "text": "配班老师",
      "width": 100
    },
    {
      "value": "班会",
      "text": "班会",
      "width": 100
    }
  ]
}

可上课时间

• constantKey：enableLessonDay

• constantType：object

[
  {
    "value": "周一",
    "text": "周一"
  },
  {
    "value": "周二",
    "text": "周二"
  },
  {
    "value": "周三",
    "text": "周三"
  },
  {
    "value": "周四",
    "text": "周四"
  },
  {
    "value": "周五",
    "text": "周五"
  },
  {
    "value": "周六",
    "text": "周六"
  },
  {
    "value": "周日",
    "text": "周日"
  }
]

早自习数量配置

• constantKey：morningLesson

• constantType：object

[
  {
    "value": 0,
    "text": "无"
  },
  {
    "value": 1,
    "text": "1节"
  },
  {
    "value": 2,
    "text": "2节"
  },
  {
    "value": 3,
    "text": "3节"
  },
  {
    "value": 4,
    "text": "4节"
  },
  {
    "value": 5,
    "text": "5节"
  }
]

上午节数

• constantKey：amLesson

• constantType：object

[
  {
    "value": 1,
    "text": "1节"
  },
  {
    "value": 2,
    "text": "2节"
  },
  {
    "value": 3,
    "text": "3节"
  },
  {
    "value": 4,
    "text": "4节"
  },
  {
    "value": 5,
    "text": "5节"
  },
  {
    "value": 6,
    "text": "6节"
  }
]

下午节数

• constantKey：pmLesson

• constantType：object

[
  {
    "value": 1,
    "text": "1节"
  },
  {
    "value": 2,
    "text": "2节"
  },
  {
    "value": 3,
    "text": "3节"
  },
  {
    "value": 4,
    "text": "4节"
  },
  {
    "value": 5,
    "text": "5节"
  },
  {
    "value": 6,
    "text": "6节"
  }
]

晚上节数

• constantKey：eveningLesson

• constantType：object

[
  {
    "value": 0,
    "text": "无"
  },
  {
    "value": 1,
    "text": "1节"
  },
  {
    "value": 2,
    "text": "2节"
  },
  {
    "value": 3,
    "text": "3节"
  },
  {
    "value": 4,
    "text": "4节"
  },
  {
    "value": 5,
    "text": "5节"
  }
]

一周上几次课

• constantKey：daytimeLesson

• constantType：object

[
  {
    "value": 0,
    "text": "无"
  },
  {
    "value": 1,
    "text": "1节"
  },
  {
    "value": 2,
    "text": "2节"
  },
  {
    "value": 3,
    "text": "3节"
  },
  {
    "value": 4,
    "text": "4节"
  },
  {
    "value": 5,
    "text": "5节"
  },
  {
    "value": 6,
    "text": "6节"
  },
  {
    "value": 7,
    "text": "7节"
  },
  {
    "value": 8,
    "text": "8节"
  },
  {
    "value": 9,
    "text": "9节"
  },
  {
    "value": 10,
    "text": "10节"
  },
  {
    "value": 11,
    "text": "11节"
  },
  {
    "value": 12,
    "text": "12节"
  },
  {
    "value": 13,
    "text": "13节"
  },
  {
    "value": 14,
    "text": "14节"
  },
  {
    "value": 15,
    "text": "15节"
  },
  {
    "value": 16,
    "text": "16节"
  },
  {
    "value": 17,
    "text": "17节"
  },
  {
    "value": 18,
    "text": "18节"
  }
]

连续次数

• constantKey：consecutive

• constantType：object

[
  {
    "value": 0,
    "text": "无"
  },
  {
    "value": 1,
    "text": "1次"
  },
  {
    "value": 2,
    "text": "2次"
  },
  {
    "value": 3,
    "text": "3次"
  },
  {
    "value": 4,
    "text": "4次"
  },
  {
    "value": 5,
    "text": "5次"
  },
  {
    "value": 6,
    "text": "6次"
  },
  {
    "value": 7,
    "text": "7次"
  }
]

年级

• constantKey：level

• constantType：object

[
  {
    "value": "01",
    "text": "一年级",
    "segment": "小学"
  },
  {
    "value": "02",
    "text": "二年级",
    "segment": "小学"
  },
  {
    "value": "03",
    "text": "三年级",
    "segment": "小学"
  },
  {
    "value": "04",
    "text": "四年级",
    "segment": "小学"
  },
  {
    "value": "05",
    "text": "五年级",
    "segment": "小学"
  },
  {
    "value": "06",
    "text": "六年级",
    "segment": "小学"
  },
  {
    "value": "07",
    "text": "七年级",
    "segment": "初中"
  },
  {
    "value": "08",
    "text": "八年级",
    "segment": "初中"
  },
  {
    "value": "09",
    "text": "九年级",
    "segment": "初中"
  },
  {
    "value": "10",
    "text": "高一",
    "segment": "高中"
  },
  {
    "value": "11",
    "text": "高二",
    "segment": "高中"
  },
  {
    "value": "12",
    "text": "高三",
    "segment": "高中"
  }
]

当前学期

• constantKey：currentSemester

• constantType：object

{
  "semester": "春季",
  "year": 2024
}

null

• constantKey：weekday

• constantType：array

[
  {
    "text": "周一",
    "value": "01"
  },
  {
    "text": "周二",
    "value": "02"
  },
  {
    "text": "周三",
    "value": "03"
  },
  {
    "text": "周四",
    "value": "04"
  },
  {
    "text": "周五",
    "value": "05"
  },
  {
    "text": "周六",
    "value": "06"
  },
  {
    "text": "周日",
    "value": "07"
  },
  {
    "text": "+周一",
    "value": "11"
  },
  {
    "text": "+周二",
    "value": "12"
  },
  {
    "text": "+周三",
    "value": "13"
  },
  {
    "text": "+周四",
    "value": "14"
  },
  {
    "text": "+周五",
    "value": "15"
  },
  {
    "text": "+周六",
    "value": "16"
  },
  {
    "text": "+周日",
    "value": "17"
  }
]

科目组排除规则

• constantKey：subjectGroupExclude

• constantType：object

[
  {
    "level": [
      "01",
      "02",
      "03",
      "04",
      "05",
      "06"
    ],
    "subject": [
      "语文"
    ],
    "weekday": "01",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "语文"
    ],
    "weekday": "01",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "语文"
    ],
    "weekday": "11",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "语文"
    ],
    "weekday": "01",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "01",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "02",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "03",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "04",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "05",
    "section": [
      "第1节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "06",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "07",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "01",
      "02",
      "03",
      "04",
      "05",
      "06"
    ],
    "subject": [
      "数学"
    ],
    "weekday": "02",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "数学"
    ],
    "weekday": "02",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "数学"
    ],
    "weekday": "12",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "数学"
    ],
    "weekday": "02",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "英语"
    ],
    "weekday": "03",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "英语"
    ],
    "weekday": "13",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "历史",
      "地理",
      "政治"
    ],
    "weekday": "04",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "历史",
      "地理",
      "政治"
    ],
    "weekday": "14",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "物理",
      "化学",
      "生物"
    ],
    "weekday": "04",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "物理",
      "化学",
      "生物"
    ],
    "weekday": "14",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "03",
      "04",
      "05",
      "06"
    ],
    "subject": [
      "英语"
    ],
    "weekday": "03",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "历史",
      "地理",
      "政治"
    ],
    "weekday": "03",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "英语"
    ],
    "weekday": "04",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "物理",
      "化学",
      "生物"
    ],
    "weekday": "05",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  }
]

科目指定节次

• constantKey：subjectAllow

• constantType：object

[]

课时排除

• constantKey：sectionExclude

• constantType：object

[
  {
    "type": "subject",
    "section": "第1节",
    "scope": [
      "音乐",
      "体育",
      "美术",
      "劳动实践",
      "信息技术",
      "书法",
      "舞蹈",
      "编程"
    ]
  },
  {
    "type": "teacher",
    "section": "第1节",
    "scope": [
      "EXXXXX",
      "E41000P",
      "E41001K",
      "E41002F",
      "H00002"
    ]
  },
  {
    "type": "subject",
    "section": "第2节",
    "scope": [
      {
        "value": "音乐",
        "text": "音乐",
        "width": 100
      },
      {
        "value": "书法",
        "text": "书法",
        "width": 100
      },
      {
        "value": "美术",
        "text": "美术",
        "width": 100
      },
      {
        "value": "体育",
        "text": "体育",
        "width": 100
      },
      {
        "value": "舞蹈",
        "text": "舞蹈",
        "width": 100
      },
      {
        "value": "科学",
        "text": "科学",
        "width": 100
      },
      {
        "value": "编程",
        "text": "编程",
        "width": 100
      },
      {
        "value": "信息技术",
        "text": "信息技术",
        "width": 100
      },
      {
        "value": "红色文化",
        "text": "红色文化",
        "width": 100
      },
      {
        "value": "劳动实践",
        "text": "劳动实践",
        "width": 100
      }
    ]
  },
  {
    "type": "subject",
    "section": "第3节",
    "scope": [
      {
        "value": "美术",
        "text": "美术",
        "width": 100
      },
      {
        "value": "书法",
        "text": "书法",
        "width": 100
      },
      {
        "value": "音乐",
        "text": "音乐",
        "width": 100
      },
      {
        "value": "舞蹈",
        "text": "舞蹈",
        "width": 100
      },
      {
        "value": "体育",
        "text": "体育",
        "width": 100
      },
      {
        "value": "科学",
        "text": "科学",
        "width": 100
      },
      {
        "value": "编程",
        "text": "编程",
        "width": 100
      },
      {
        "value": "劳动实践",
        "text": "劳动实践",
        "width": 100
      },
      {
        "value": "红色文化",
        "text": "红色文化",
        "width": 100
      }
    ]
  },
  {
    "type": "subject",
    "section": "第4节",
    "scope": [
      {
        "value": "体育",
        "text": "体育",
        "width": 100
      },
      {
        "value": "美术",
        "text": "美术",
        "width": 100
      },
      {
        "value": "书法",
        "text": "书法",
        "width": 100
      },
      {
        "value": "音乐",
        "text": "音乐",
        "width": 100
      },
      {
        "value": "舞蹈",
        "text": "舞蹈",
        "width": 100
      },
      {
        "value": "科学",
        "text": "科学",
        "width": 100
      },
      {
        "value": "编程",
        "text": "编程",
        "width": 100
      },
      {
        "value": "心理健康",
        "text": "心理健康",
        "width": 100
      },
      {
        "value": "红色文化",
        "text": "红色文化",
        "width": 100
      },
      {
        "value": "劳动实践",
        "text": "劳动实践",
        "width": 100
      },
      {
        "value": "信息技术",
        "text": "信息技术",
        "width": 100
      }
    ]
  }
]

工作日排除

• constantKey：weekdayExclude

• constantType：object

[
  {
    "type": "teacher",
    "weekday": "05",
    "scope": [
      "E41231F",
      "E41136T",
      "E41239A",
      "E41191P",
      "E41188B",
      "E41197P",
      "E41187F"
    ]
  },
  {
    "type": "teacher",
    "weekday": "04",
    "scope": [
      "E41251D",
      "E41117B",
      "E41172R",
      "E41166R",
      "E41164A",
      "E41376L",
      "E41165W"
    ]
  },
  {
    "type": "teacher",
    "weekday": "03",
    "scope": [
      "E41179N",
      "E41237G",
      "E41360P",
      "E41219C",
      "E41193F",
      "E41190T"
    ]
  },
  {
    "type": "teacher",
    "weekday": "02",
    "scope": [
      "E41177W",
      "E41221U",
      "E41087J",
      "E41240V",
      "E41186J",
      "E41227W",
      "E41236L"
    ]
  },
  {
    "type": "teacher",
    "weekday": "03",
    "scope": [
      "E41223L",
      "E41154R",
      "E41237G",
      "E41131P",
      "E41119R",
      "E41419Y",
      "E41149N",
      "E41432J",
      "E41159W"
    ]
  },
  {
    "type": "teacher",
    "weekday": "04",
    "scope": [
      "E41209R",
      "E41134C",
      "E41151E",
      "E41225D",
      "E41143N",
      "E41138K"
    ]
  },
  {
    "type": "teacher",
    "weekday": "05",
    "scope": [
      "E41144J",
      "E41215T",
      "E41139F",
      "E41152B",
      "E41118W",
      "E41147W",
      "E41420W"
    ]
  },
  {
    "type": "teacher",
    "weekday": "06",
    "scope": [
      "E41194C",
      "E41399M",
      "E41196U",
      "E41238D",
      "E41157E",
      "E41156J"
    ]
  }
]

统一教师排除

• constantKey：teacherExclude

• constantType：array

[
  {
    "type": "teacher",
    "weekdayList": [
      "05"
    ],
    "sectionList": [
      "第5节"
    ],
    "teacherList": [
      "E41144J",
      "E41146B",
      "E41152B"
    ]
  },
  {
    "weekdayList": [
      "02",
      "03",
      "01",
      "04",
      "05",
      "06",
      "11",
      "12",
      "13",
      "14",
      "15",
      "16"
    ],
    "sectionList": [
      "第2节",
      "第3节",
      "第1节",
      "第4节",
      "第5节",
      "第6节",
      "第7节",
      "第8节"
    ],
    "teacherList": [
      "H00002",
      "H00001",
      "E41433G"
    ],
    "remark": "不排课"
  }
]

统一学科排除

• constantKey：subjectExclude

• constantType：array

[
  {
    "type": "subject",
    "weekdayList": [
      "05"
    ],
    "sectionList": [
      "第5节"
    ],
    "subjectList": [
      "体育",
      "美术"
    ]
  },
  {
    "weekdayList": [
      "01",
      "02",
      "03",
      "04",
      "05",
      "06",
      "07"
    ],
    "sectionList": [
      "第1节"
    ],
    "subjectList": [
      "体育",
      "美术",
      "书法",
      "音乐",
      "舞蹈",
      "编程",
      "信息技术",
      "劳动实践",
      "心理健康",
      "红色文化",
      "社团",
      "科学",
      "通用技术",
      "劳动",
      "艺术",
      "配班老师"
    ]
  }
]

学部列表

• constantKey：segment

• constantType：array

[
  {
    "value": "小学",
    "text": "小学"
  },
  {
    "value": "初中",
    "text": "初中"
  },
  {
    "value": "高中",
    "text": "高中"
  }
]

_constant语句

INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'segmentSubject', 'object', '学部科目', '{
    "小学": [
          {"value": "语文", "text": "语文", "width": 100},
            {"value": "数学", "text": "数学", "width": 100},
            {"value": "英语", "text": "英语", "width": 100},
            {"value": "体育", "text": "体育", "width": 100},
            {"value": "美术", "text": "美术", "width": 100},
            {"value": "书法", "text": "书法", "width": 100},
            {"value": "音乐", "text": "音乐", "width": 100},
            {"value": "舞蹈", "text": "舞蹈", "width": 100},
            {"value": "科学", "text": "科学", "width": 100},
            {"value": "编程", "text": "编程", "width": 100},
            {"value": "社团", "text": "社团", "width": 100},
            {"value": "心理健康", "text": "心理健康", "width": 100},
            {"value": "信息技术", "text": "信息技术", "width": 100},
            {"value": "红色文化", "text": "红色文化", "width": 100},
            {"value": "劳动实践", "text": "劳动实践", "width": 100},
            {"value": "班会", "text": "班会", "width": 100}
    ],
    "初中": [
          {"value": "语文", "text": "语文", "width": 100},
            {"value": "数学", "text": "数学", "width": 100},
            {"value": "英语", "text": "英语", "width": 100},
            {"value": "物理", "text": "物理", "width": 100},
            {"value": "化学", "text": "化学", "width": 100},
            {"value": "生物", "text": "生物", "width": 100},
            {"value": "历史", "text": "历史", "width": 100},
            {"value": "地理", "text": "地理", "width": 100},
            {"value": "政治", "text": "政治", "width": 100},
            {"value": "音乐", "text": "音乐", "width": 100},
            {"value": "美术", "text": "美术", "width": 100},
            {"value": "劳动", "text": "劳动", "width": 100},
            {"value": "信息技术", "text": "信息技术", "width": 100},
            {"value": "通用技术", "text": "通用技术", "width": 100},
            {"value": "体育", "text": "体育", "width": 100},
            {"value": "日语", "text": "日语", "width": 100},
            {"value": "班会", "text": "班会", "width": 100}
    ],
    "高中": [
          {"value": "语文", "text": "语文", "width": 100},
            {"value": "数学", "text": "数学", "width": 100},
            {"value": "英语", "text": "英语", "width": 100},
            {"value": "物理", "text": "物理", "width": 100},
            {"value": "化学", "text": "化学", "width": 100},
            {"value": "生物", "text": "生物", "width": 100},
            {"value": "历史", "text": "历史", "width": 100},
            {"value": "地理", "text": "地理", "width": 100},
            {"value": "政治", "text": "政治", "width": 100},
            {"value": "信息技术", "text": "信息技术", "width": 100},
            {"value": "通用技术", "text": "通用技术", "width": 100},
            {"value": "艺术", "text": "艺术", "width": 100},
            {"value": "体育", "text": "体育", "width": 100},
            {"value": "日语", "text": "日语", "width": 100},
            {"value": "辅导1", "text": "辅导1", "width": 100},
            {"value": "辅导2", "text": "辅导2", "width": 100},
            {"value": "辅导3", "text": "辅导3", "width": 100},
            {"value": "配班老师", "text": "配班老师", "width": 100},
            {"value": "班会", "text": "班会", "width": 100}
    ]
}', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'enableLessonDay', 'object', '可上课时间', '[
    {"value": "周一", "text": "周一"},
    {"value": "周二", "text": "周二"},
    {"value": "周三", "text": "周三"},
    {"value": "周四", "text": "周四"},
    {"value": "周五", "text": "周五"},
    {"value": "周六", "text": "周六"},
    {"value": "周日", "text": "周日"}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'morningLesson', 'object', '早自习数量配置', '[
    {"value": 0, "text": "无"},
    {"value": 1, "text": "1节"},
    {"value": 2, "text": "2节"},
    {"value": 3, "text": "3节"},
    {"value": 4, "text": "4节"},
    {"value": 5, "text": "5节"}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'amLesson', 'object', '上午节数', '[
    {"value": 1, "text": "1节"},
    {"value": 2, "text": "2节"},
    {"value": 3, "text": "3节"},
    {"value": 4, "text": "4节"},
    {"value": 5, "text": "5节"},
    {"value": 6, "text": "6节"}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'pmLesson', 'object', '下午节数', '[
    {"value": 1, "text": "1节"},
    {"value": 2, "text": "2节"},
    {"value": 3, "text": "3节"},
    {"value": 4, "text": "4节"},
    {"value": 5, "text": "5节"},
    {"value": 6, "text": "6节"}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'eveningLesson', 'object', '晚上节数', '[
    {"value": 0, "text": "无"},
    {"value": 1, "text": "1节"},
    {"value": 2, "text": "2节"},
    {"value": 3, "text": "3节"},
    {"value": 4, "text": "4节"},
    {"value": 5, "text": "5节"}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'daytimeLesson', 'object', '一周上几次课', '[
    {"value": 0, "text": "无"},
    {"value": 1, "text": "1节"},
    {"value": 2, "text": "2节"},
    {"value": 3, "text": "3节"},
    {"value": 4, "text": "4节"},
    {"value": 5, "text": "5节"},
    {"value": 6, "text": "6节"},
    {"value": 7, "text": "7节"},
    {"value": 8, "text": "8节"},
    {"value": 9, "text": "9节"},
    {"value": 10, "text": "10节"},
    {"value": 11, "text": "11节"},
    {"value": 12, "text": "12节"},
    {"value": 13, "text": "13节"},
    {"value": 14, "text": "14节"},
    {"value": 15, "text": "15节"},
    {"value": 16, "text": "16节"},
    {"value": 17, "text": "17节"},
    {"value": 18, "text": "18节"}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'consecutive', 'object', '连续次数', '[
    {"value": 0, "text": "无"},
    {"value": 1, "text": "1次"},
    {"value": 2, "text": "2次"},
    {"value": 3, "text": "3次"},
    {"value": 4, "text": "4次"},
    {"value": 5, "text": "5次"},
    {"value": 6, "text": "6次"},
    {"value": 7, "text": "7次"}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'level', 'object', '年级', '[
    {"value":"01","text":"一年级","segment":"小学"},
    {"value":"02","text":"二年级","segment":"小学"},
    {"value":"03","text":"三年级","segment":"小学"},
    {"value": "04","text": "四年级","segment":"小学"},
    {"value": "05","text": "五年级","segment":"小学"},
    {"value": "06","text": "六年级","segment":"小学"},
    {"value": "07","text": "七年级","segment":"初中"},
    {"value": "08","text": "八年级","segment":"初中"},
    {"value": "09","text": "九年级","segment":"初中"},
    {"value": "10","text": "高一","segment":"高中"},
    {"value": "11","text": "高二","segment":"高中"},
    {"value": "12","text": "高三","segment":"高中"}
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'currentSemester', 'object', '当前学期', '{"semester":"春季","year":2024}', 'update', NULL, NULL, '2024-01-27T15:49:02+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'weekday', 'array', NULL, '[{"text":"周一","value":"01"},{"text":"周二","value":"02"},{"text":"周三","value":"03"},{"text":"周四","value":"04"},{"text":"周五","value":"05"},{"text":"周六","value":"06"},{"text":"周日","value":"07"},{"text":"+周一","value":"11"},{"text":"+周二","value":"12"},{"text":"+周三","value":"13"},{"text":"+周四","value":"14"},{"text":"+周五","value":"15"},{"text":"+周六","value":"16"},{"text":"+周日","value":"17"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'subjectGroupExclude', 'object', '科目组排除规则', '[
  {
    "level": [
      "01",
      "02",
      "03",
      "04",
      "05",
      "06"
    ],
    "subject": [
      "语文"
    ],
    "weekday": "01",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "语文"
    ],
    "weekday": "01",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "语文"
    ],
    "weekday": "11",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "语文"
    ],
    "weekday": "01",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "01",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "02",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "03",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "04",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "05",
    "section": [
      "第1节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "06",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "12"
    ],
    "subject": [
      "体育"
    ],
    "weekday": "07",
    "section": [
      "第1节",
      "第7节",
      "第8节"
    ]
  },
  {
    "level": [
      "01",
      "02",
      "03",
      "04",
      "05",
      "06"
    ],
    "subject": [
      "数学"
    ],
    "weekday": "02",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "数学"
    ],
    "weekday": "02",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "数学"
    ],
    "weekday": "12",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "数学"
    ],
    "weekday": "02",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "英语"
    ],
    "weekday": "03",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "英语"
    ],
    "weekday": "13",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "历史",
      "地理",
      "政治"
    ],
    "weekday": "04",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "历史",
      "地理",
      "政治"
    ],
    "weekday": "14",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "物理",
      "化学",
      "生物"
    ],
    "weekday": "04",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "07",
      "08",
      "09"
    ],
    "subject": [
      "物理",
      "化学",
      "生物"
    ],
    "weekday": "14",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "03",
      "04",
      "05",
      "06"
    ],
    "subject": [
      "英语"
    ],
    "weekday": "03",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "历史",
      "地理",
      "政治"
    ],
    "weekday": "03",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "英语"
    ],
    "weekday": "04",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  },
  {
    "level": [
      "10",
      "11",
      "12"
    ],
    "subject": [
      "物理",
      "化学",
      "生物"
    ],
    "weekday": "05",
    "section": [
      "第2节",
      "第3节",
      "第4节"
    ]
  }
]', 'jhUpdate', 'E41428W', '刘珊珊', '2023-08-30T19:26:45+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'subjectAllow', 'object', '科目指定节次', '[]', 'jhUpdate', 'admin', '系统管理员', '2024-02-25T22:34:10+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'sectionExclude', 'object', '课时排除', '[
  {
    "type": "subject",
    "section": "第1节",
    "scope": [
      "音乐",
      "体育",
      "美术",
      "劳动实践",
      "信息技术",
      "书法",
      "舞蹈",
      "编程"
    ]
  },
  {
    "type": "teacher",
    "section": "第1节",
    "scope": [
      "EXXXXX",
      "E41000P",
      "E41001K",
      "E41002F",
      "H00002"
    ]
  },
  {
    "type": "subject",
    "section": "第2节",
    "scope": [
      {
        "value": "音乐",
        "text": "音乐",
        "width": 100
      },
      {
        "value": "书法",
        "text": "书法",
        "width": 100
      },
      {
        "value": "美术",
        "text": "美术",
        "width": 100
      },
      {
        "value": "体育",
        "text": "体育",
        "width": 100
      },
      {
        "value": "舞蹈",
        "text": "舞蹈",
        "width": 100
      },
      {
        "value": "科学",
        "text": "科学",
        "width": 100
      },
      {
        "value": "编程",
        "text": "编程",
        "width": 100
      },
      {
        "value": "信息技术",
        "text": "信息技术",
        "width": 100
      },
      {
        "value": "红色文化",
        "text": "红色文化",
        "width": 100
      },
      {
        "value": "劳动实践",
        "text": "劳动实践",
        "width": 100
      }
    ]
  },
  {
    "type": "subject",
    "section": "第3节",
    "scope": [
      {
        "value": "美术",
        "text": "美术",
        "width": 100
      },
      {
        "value": "书法",
        "text": "书法",
        "width": 100
      },
      {
        "value": "音乐",
        "text": "音乐",
        "width": 100
      },
      {
        "value": "舞蹈",
        "text": "舞蹈",
        "width": 100
      },
      {
        "value": "体育",
        "text": "体育",
        "width": 100
      },
      {
        "value": "科学",
        "text": "科学",
        "width": 100
      },
      {
        "value": "编程",
        "text": "编程",
        "width": 100
      },
      {
        "value": "劳动实践",
        "text": "劳动实践",
        "width": 100
      },
      {
        "value": "红色文化",
        "text": "红色文化",
        "width": 100
      }
    ]
  },
  {
    "type": "subject",
    "section": "第4节",
    "scope": [
      {
        "value": "体育",
        "text": "体育",
        "width": 100
      },
      {
        "value": "美术",
        "text": "美术",
        "width": 100
      },
      {
        "value": "书法",
        "text": "书法",
        "width": 100
      },
      {
        "value": "音乐",
        "text": "音乐",
        "width": 100
      },
      {
        "value": "舞蹈",
        "text": "舞蹈",
        "width": 100
      },
      {
        "value": "科学",
        "text": "科学",
        "width": 100
      },
      {
        "value": "编程",
        "text": "编程",
        "width": 100
      },
      {
        "value": "心理健康",
        "text": "心理健康",
        "width": 100
      },
      {
        "value": "红色文化",
        "text": "红色文化",
        "width": 100
      },
      {
        "value": "劳动实践",
        "text": "劳动实践",
        "width": 100
      },
      {
        "value": "信息技术",
        "text": "信息技术",
        "width": 100
      }
    ]
  }
]', 'jhUpdate', 'E41001K', '郭素琴', '2023-08-07T15:18:03+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'weekdayExclude', 'object', '工作日排除', '[
  {
    "type": "teacher",
    "weekday": "05",
    "scope": [
      "E41231F",
      "E41136T",
      "E41239A",
      "E41191P",
      "E41188B",
      "E41197P",
      "E41187F"
    ]
  },
  {
    "type": "teacher",
    "weekday": "04",
    "scope": [
      "E41251D",
      "E41117B",
      "E41172R",
      "E41166R",
      "E41164A",
      "E41376L",
      "E41165W"
    ]
  },
  {
    "type": "teacher",
    "weekday": "03",
    "scope": [
      "E41179N",
      "E41237G",
      "E41360P",
      "E41219C",
      "E41193F",
      "E41190T"
    ]
  },
  {
    "type": "teacher",
    "weekday": "02",
    "scope": [
      "E41177W",
      "E41221U",
      "E41087J",
      "E41240V",
      "E41186J",
      "E41227W",
      "E41236L"
    ]
  },
  {
    "type": "teacher",
    "weekday": "03",
    "scope": [
      "E41223L",
      "E41154R",
      "E41237G",
      "E41131P",
      "E41119R",
      "E41419Y",
      "E41149N",
      "E41432J",
      "E41159W"
    ]
  },
  {
    "type": "teacher",
    "weekday": "04",
    "scope": [
      "E41209R",
      "E41134C",
      "E41151E",
      "E41225D",
      "E41143N",
      "E41138K"
    ]
  },
  {
    "type": "teacher",
    "weekday": "05",
    "scope": [
      "E41144J",
      "E41215T",
      "E41139F",
      "E41152B",
      "E41118W",
      "E41147W",
      "E41420W"
    ]
  },
  {
    "type": "teacher",
    "weekday": "06",
    "scope": [
      "E41194C",
      "E41399M",
      "E41196U",
      "E41238D",
      "E41157E",
      "E41156J"
    ]
  }
]', 'jhUpdate', 'E41258C', '曾香媛', '2023-08-21T15:14:02+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'teacherExclude', 'array', '统一教师排除', '[
  {
    "type": "teacher",
    "weekdayList": [
      "05"
    ],
    "sectionList": [
      "第5节"
    ],
    "teacherList": [
      "E41144J",
      "E41146B",
      "E41152B"
    ]
  },
  {
    "weekdayList": [
      "02",
      "03",
      "01",
      "04",
      "05",
      "06",
      "11",
      "12",
      "13",
      "14",
      "15",
      "16"
    ],
    "sectionList": [
      "第2节",
      "第3节",
      "第1节",
      "第4节",
      "第5节",
      "第6节",
      "第7节",
      "第8节"
    ],
    "teacherList": [
      "H00002",
      "H00001",
      "E41433G"
    ],
    "remark": "不排课"
  }
]', 'jhUpdate', 'E41075M', '刘艳', '2023-08-25T16:20:50+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'subjectExclude', 'array', '统一学科排除', '[
  {
    "type": "subject",
    "weekdayList": [
      "05"
    ],
    "sectionList": [
      "第5节"
    ],
    "subjectList": [
      "体育",
      "美术"
    ]
  },
  {
    "weekdayList": [
      "01",
      "02",
      "03",
      "04",
      "05",
      "06",
      "07"
    ],
    "sectionList": [
      "第1节"
    ],
    "subjectList": [
      "体育",
      "美术",
      "书法",
      "音乐",
      "舞蹈",
      "编程",
      "信息技术",
      "劳动实践",
      "心理健康",
      "红色文化",
      "社团",
      "科学",
      "通用技术",
      "劳动",
      "艺术",
      "配班老师"
    ]
  }
]', 'jhUpdate', 'E41001K', '郭素琴', '2023-08-23T15:46:34+08:00');
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'segment', 'array', '学部列表', '[{"value":"小学","text":"小学"},{"value": "初中","text": "初中"},{"value": "高中","text": "高中"}]', 'insert', NULL, NULL, NULL);