江湖数字化平台
登录

常量

12114

常量总览

_constant结构

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

_constant 表数据

学年列表

  • constantKey：academicYear

  • constantType：array

  1. [
  2.   {
  3.     "value": "2022",
  4.     "text": "2022学年"
  5.   },
  6.   {
  7.     "value": "2023",
  8.     "text": "2023学年"
  9.   },
  10.   {
  11.     "value": "2024",
  12.     "text": "2024学年"
  13.   },
  14.   {
  15.     "value": "2025",
  16.     "text": "2025学年"
  17.   },
  18.   {
  19.     "value": "2026",
  20.     "text": "2026学年"
  21.   },
  22.   {
  23.     "value": "2027",
  24.     "text": "2027学年"
  25.   },
  26.   {
  27.     "value": "2028",
  28.     "text": "2028学年"
  29.   },
  30.   {
  31.     "value": "2029",
  32.     "text": "2029学年"
  33.   },
  34.   {
  35.     "value": "2030",
  36.     "text": "2030学年"
  37.   }
  38. ]

学期列表

  • constantKey：semester

  • constantType：array

  1. [
  2.   {
  3.     "value": "秋季",
  4.     "text": "秋季"
  5.   },
  6.   {
  7.     "value": "春季",
  8.     "text": "春季"
  9.   }
  10. ]

学部列表

  • constantKey：segment

  • constantType：object

  1. [
  2.   {
  3.     "value": "小学",
  4.     "text": "小学"
  5.   },
  6.   {
  7.     "value": "初中",
  8.     "text": "初中"
  9.   },
  10.   {
  11.     "value": "高中",
  12.     "text": "高中"
  13.   }
  14. ]

年级列表

  • constantKey：level

  • constantType：object

  1. [
  2.   {
  3.     "value": "01",
  4.     "text": "一年级",
  5.     "segment": "小学"
  6.   },
  7.   {
  8.     "value": "02",
  9.     "text": "二年级",
  10.     "segment": "小学"
  11.   },
  12.   {
  13.     "value": "03",
  14.     "text": "三年级",
  15.     "segment": "小学"
  16.   },
  17.   {
  18.     "value": "04",
  19.     "text": "四年级",
  20.     "segment": "小学"
  21.   },
  22.   {
  23.     "value": "05",
  24.     "text": "五年级",
  25.     "segment": "小学"
  26.   },
  27.   {
  28.     "value": "06",
  29.     "text": "六年级",
  30.     "segment": "小学"
  31.   },
  32.   {
  33.     "value": "07",
  34.     "text": "七年级",
  35.     "segment": "初中"
  36.   },
  37.   {
  38.     "value": "08",
  39.     "text": "八年级",
  40.     "segment": "初中"
  41.   },
  42.   {
  43.     "value": "09",
  44.     "text": "九年级",
  45.     "segment": "初中"
  46.   },
  47.   {
  48.     "value": "10",
  49.     "text": "高一",
  50.     "segment": "高中"
  51.   },
  52.   {
  53.     "value": "11",
  54.     "text": "高二",
  55.     "segment": "高中"
  56.   },
  57.   {
  58.     "value": "12",
  59.     "text": "高三",
  60.     "segment": "高中"
  61.   }
  62. ]

托管类型

  • constantKey：afterSchoolCareType

  • constantType：object

  1. [
  2.   {
  3.     "value": "日托",
  4.     "text": "日托"
  5.   },
  6.   {
  7.     "value": "周托",
  8.     "text": "周托"
  9.   },
  10.   {
  11.     "value": "半月托",
  12.     "text": "半月托"
  13.   },
  14.   {
  15.     "value": "月托",
  16.     "text": "月托"
  17.   }
  18. ]

新生/老生

  • constantKey：freshmanOrReturning

  • constantType：object

  1. [
  2.   {
  3.     "value": "新生",
  4.     "text": "新生"
  5.   },
  6.   {
  7.     "value": "老生",
  8.     "text": "老生"
  9.   }
  10. ]

缴费项目

  • constantKey：paymentItem

  • constantType：object

  1. [
  2.   {
  3.     "value": "学费",
  4.     "text": "学费"
  5.   },
  6.   {
  7.     "value": "住宿",
  8.     "text": "住宿"
  9.   },
  10.   {
  11.     "value": "伙食",
  12.     "text": "伙食"
  13.   },
  14.   {
  15.     "value": "校服",
  16.     "text": "校服"
  17.   },
  18.   {
  19.     "value": "床上用品",
  20.     "text": "床上用品"
  21.   },
  22.   {
  23.     "value": "保险",
  24.     "text": "保险"
  25.   },
  26.   {
  27.     "value": "家校通",
  28.     "text": "家校通"
  29.   },
  30.   {
  31.     "value": "课本资料",
  32.     "text": "课本资料"
  33.   }
  34. ]

缴费规则配置

  • constantKey：paymentConfig

  • constantType：object

  1. [
  2.   {
  3.     "segment": "小学",
  4.     "afterSchoolCareType": "日托",
  5.     "freshmanOrReturning": "老生",
  6.     "paymentItem": [
  7.       {
  8.         "item": "学费",
  9.         "amount": "5400"
  10.       },
  11.       {
  12.         "item": "住宿",
  13.         "amount": "600"
  14.       },
  15.       {
  16.         "item": "伙食",
  17.         "amount": "2000"
  18.       },
  19.       {
  20.         "item": "保险",
  21.         "amount": "50"
  22.       },
  23.       {
  24.         "item": "家校通",
  25.         "amount": "100"
  26.       }
  27.     ]
  28.   },
  29.   {
  30.     "segment": "小学",
  31.     "afterSchoolCareType": "日托",
  32.     "freshmanOrReturning": "新生",
  33.     "paymentItem": [
  34.       {
  35.         "item": "学费",
  36.         "amount": "5400"
  37.       },
  38.       {
  39.         "item": "住宿",
  40.         "amount": "600"
  41.       },
  42.       {
  43.         "item": "伙食",
  44.         "amount": "2000"
  45.       },
  46.       {
  47.         "item": "校服",
  48.         "amount": "800"
  49.       },
  50.       {
  51.         "item": "床上用品",
  52.         "amount": "600"
  53.       },
  54.       {
  55.         "item": "保险",
  56.         "amount": "50"
  57.       },
  58.       {
  59.         "item": "家校通",
  60.         "amount": "100"
  61.       }
  62.     ]
  63.   },
  64.   {
  65.     "segment": "小学",
  66.     "afterSchoolCareType": "周托",
  67.     "freshmanOrReturning": "老生",
  68.     "paymentItem": [
  69.       {
  70.         "item": "学费",
  71.         "amount": "5400"
  72.       },
  73.       {
  74.         "item": "住宿",
  75.         "amount": "1000"
  76.       },
  77.       {
  78.         "item": "伙食",
  79.         "amount": "2400"
  80.       },
  81.       {
  82.         "item": "保险",
  83.         "amount": "50"
  84.       },
  85.       {
  86.         "item": "家校通",
  87.         "amount": "100"
  88.       }
  89.     ]
  90.   },
  91.   {
  92.     "segment": "小学",
  93.     "afterSchoolCareType": "周托",
  94.     "freshmanOrReturning": "新生",
  95.     "paymentItem": [
  96.       {
  97.         "item": "学费",
  98.         "amount": "5400"
  99.       },
  100.       {
  101.         "item": "住宿",
  102.         "amount": "1000"
  103.       },
  104.       {
  105.         "item": "伙食",
  106.         "amount": "2400"
  107.       },
  108.       {
  109.         "item": "校服",
  110.         "amount": "800"
  111.       },
  112.       {
  113.         "item": "床上用品",
  114.         "amount": "600"
  115.       },
  116.       {
  117.         "item": "保险",
  118.         "amount": "50"
  119.       },
  120.       {
  121.         "item": "家校通",
  122.         "amount": "100"
  123.       }
  124.     ]
  125.   },
  126.   {
  127.     "segment": "小学",
  128.     "afterSchoolCareType": "月托",
  129.     "freshmanOrReturning": "老生",
  130.     "paymentItem": [
  131.       {
  132.         "item": "学费",
  133.         "amount": "6000"
  134.       },
  135.       {
  136.         "item": "住宿",
  137.         "amount": "1200"
  138.       },
  139.       {
  140.         "item": "伙食",
  141.         "amount": "3000"
  142.       },
  143.       {
  144.         "item": "保险",
  145.         "amount": "50"
  146.       },
  147.       {
  148.         "item": "家校通",
  149.         "amount": "100"
  150.       }
  151.     ]
  152.   },
  153.   {
  154.     "segment": "小学",
  155.     "afterSchoolCareType": "月托",
  156.     "freshmanOrReturning": "新生",
  157.     "paymentItem": [
  158.       {
  159.         "item": "学费",
  160.         "amount": "6000"
  161.       },
  162.       {
  163.         "item": "住宿",
  164.         "amount": "1200"
  165.       },
  166.       {
  167.         "item": "伙食",
  168.         "amount": "3000"
  169.       },
  170.       {
  171.         "item": "校服",
  172.         "amount": "800"
  173.       },
  174.       {
  175.         "item": "床上用品",
  176.         "amount": "600"
  177.       },
  178.       {
  179.         "item": "保险",
  180.         "amount": "50"
  181.       },
  182.       {
  183.         "item": "家校通",
  184.         "amount": "100"
  185.       }
  186.     ]
  187.   },
  188.   {
  189.     "segment": "初中",
  190.     "afterSchoolCareType": "半月托",
  191.     "freshmanOrReturning": "老生",
  192.     "paymentItem": [
  193.       {
  194.         "item": "学费",
  195.         "amount": "6400"
  196.       },
  197.       {
  198.         "item": "住宿",
  199.         "amount": "1200"
  200.       },
  201.       {
  202.         "item": "伙食",
  203.         "amount": "3000"
  204.       },
  205.       {
  206.         "item": "保险",
  207.         "amount": "50"
  208.       },
  209.       {
  210.         "item": "家校通",
  211.         "amount": "100"
  212.       }
  213.     ]
  214.   },
  215.   {
  216.     "segment": "初中",
  217.     "afterSchoolCareType": "半月托",
  218.     "freshmanOrReturning": "新生",
  219.     "paymentItem": [
  220.       {
  221.         "item": "学费",
  222.         "amount": "6400"
  223.       },
  224.       {
  225.         "item": "住宿",
  226.         "amount": "1200"
  227.       },
  228.       {
  229.         "item": "伙食",
  230.         "amount": "3000"
  231.       },
  232.       {
  233.         "item": "校服",
  234.         "amount": "800"
  235.       },
  236.       {
  237.         "item": "床上用品",
  238.         "amount": "600"
  239.       },
  240.       {
  241.         "item": "保险",
  242.         "amount": "50"
  243.       },
  244.       {
  245.         "item": "家校通",
  246.         "amount": "100"
  247.       }
  248.     ]
  249.   },
  250.   {
  251.     "segment": "初中",
  252.     "afterSchoolCareType": "月托",
  253.     "freshmanOrReturning": "老生",
  254.     "paymentItem": [
  255.       {
  256.         "item": "学费",
  257.         "amount": "7000"
  258.       },
  259.       {
  260.         "item": "住宿",
  261.         "amount": "1200"
  262.       },
  263.       {
  264.         "item": "伙食",
  265.         "amount": "3400"
  266.       },
  267.       {
  268.         "item": "保险",
  269.         "amount": "50"
  270.       },
  271.       {
  272.         "item": "家校通",
  273.         "amount": "100"
  274.       }
  275.     ]
  276.   },
  277.   {
  278.     "segment": "初中",
  279.     "afterSchoolCareType": "月托",
  280.     "freshmanOrReturning": "新生",
  281.     "paymentItem": [
  282.       {
  283.         "item": "学费",
  284.         "amount": "7000"
  285.       },
  286.       {
  287.         "item": "住宿",
  288.         "amount": "1200"
  289.       },
  290.       {
  291.         "item": "伙食",
  292.         "amount": "3400"
  293.       },
  294.       {
  295.         "item": "校服",
  296.         "amount": "800"
  297.       },
  298.       {
  299.         "item": "床上用品",
  300.         "amount": "600"
  301.       },
  302.       {
  303.         "item": "保险",
  304.         "amount": "50"
  305.       },
  306.       {
  307.         "item": "家校通",
  308.         "amount": "100"
  309.       }
  310.     ]
  311.   },
  312.   {
  313.     "segment": "高中",
  314.     "afterSchoolCareType": "月托",
  315.     "freshmanOrReturning": "老生",
  316.     "paymentItem": [
  317.       {
  318.         "item": "学费",
  319.         "amount": "9000"
  320.       },
  321.       {
  322.         "item": "住宿",
  323.         "amount": "1200"
  324.       },
  325.       {
  326.         "item": "伙食",
  327.         "amount": "3400"
  328.       },
  329.       {
  330.         "item": "保险",
  331.         "amount": "50"
  332.       },
  333.       {
  334.         "item": "家校通",
  335.         "amount": "100"
  336.       },
  337.       {
  338.         "item": "课本资料",
  339.         "amount": "1200"
  340.       }
  341.     ]
  342.   },
  343.   {
  344.     "segment": "高中",
  345.     "afterSchoolCareType": "月托",
  346.     "freshmanOrReturning": "新生",
  347.     "paymentItem": [
  348.       {
  349.         "item": "学费",
  350.         "amount": "9000"
  351.       },
  352.       {
  353.         "item": "住宿",
  354.         "amount": "1200"
  355.       },
  356.       {
  357.         "item": "伙食",
  358.         "amount": "3400"
  359.       },
  360.       {
  361.         "item": "校服",
  362.         "amount": "800"
  363.       },
  364.       {
  365.         "item": "床上用品",
  366.         "amount": "600"
  367.       },
  368.       {
  369.         "item": "保险",
  370.         "amount": "50"
  371.       },
  372.       {
  373.         "item": "家校通",
  374.         "amount": "100"
  375.       },
  376.       {
  377.         "item": "课本资料",
  378.         "amount": "1200"
  379.       }
  380.     ]
  381.   }
  382. ]

缴费类型

  • constantKey：paymentType

  • constantType：object

  1. [
  2.   {
  3.     "value": "学费",
  4.     "text": "学费"
  5.   }
  6. ]

年级列表

  • constantKey：level

  • constantType：object

  1. [
  2.   {
  3.     "value": "01",
  4.     "text": "一年级",
  5.     "segment": "小学"
  6.   },
  7.   {
  8.     "value": "02",
  9.     "text": "二年级",
  10.     "segment": "小学"
  11.   },
  12.   {
  13.     "value": "03",
  14.     "text": "三年级",
  15.     "segment": "小学"
  16.   },
  17.   {
  18.     "value": "04",
  19.     "text": "四年级",
  20.     "segment": "小学"
  21.   },
  22.   {
  23.     "value": "05",
  24.     "text": "五年级",
  25.     "segment": "小学"
  26.   },
  27.   {
  28.     "value": "06",
  29.     "text": "六年级",
  30.     "segment": "小学"
  31.   },
  32.   {
  33.     "value": "07",
  34.     "text": "七年级",
  35.     "segment": "初中"
  36.   },
  37.   {
  38.     "value": "08",
  39.     "text": "八年级",
  40.     "segment": "初中"
  41.   },
  42.   {
  43.     "value": "09",
  44.     "text": "九年级",
  45.     "segment": "初中"
  46.   },
  47.   {
  48.     "value": "10",
  49.     "text": "高一",
  50.     "segment": "高中"
  51.   },
  52.   {
  53.     "value": "11",
  54.     "text": "高二",
  55.     "segment": "高中"
  56.   },
  57.   {
  58.     "value": "12",
  59.     "text": "高三",
  60.     "segment": "高中"
  61.   }
  62. ]

班号

  • constantKey：number

  • constantType：array

  1. [
  2.   {
  3.     "value": "00",
  4.     "text": "待分班"
  5.   },
  6.   {
  7.     "value": "01",
  8.     "text": "01班"
  9.   },
  10.   {
  11.     "value": "02",
  12.     "text": "02班"
  13.   },
  14.   {
  15.     "value": "03",
  16.     "text": "03班"
  17.   },
  18.   {
  19.     "value": "04",
  20.     "text": "04班"
  21.   },
  22.   {
  23.     "value": "05",
  24.     "text": "05班"
  25.   },
  26.   {
  27.     "value": "06",
  28.     "text": "06班"
  29.   },
  30.   {
  31.     "value": "07",
  32.     "text": "07班"
  33.   },
  34.   {
  35.     "value": "08",
  36.     "text": "08班"
  37.   },
  38.   {
  39.     "value": "09",
  40.     "text": "09班"
  41.   },
  42.   {
  43.     "value": "10",
  44.     "text": "10班"
  45.   },
  46.   {
  47.     "value": "11",
  48.     "text": "11班"
  49.   },
  50.   {
  51.     "value": "12",
  52.     "text": "12班"
  53.   },
  54.   {
  55.     "value": "13",
  56.     "text": "13班"
  57.   },
  58.   {
  59.     "value": "14",
  60.     "text": "14班"
  61.   },
  62.   {
  63.     "value": "15",
  64.     "text": "15班"
  65.   },
  66.   {
  67.     "value": "16",
  68.     "text": "16班"
  69.   },
  70.   {
  71.     "value": "17",
  72.     "text": "17班"
  73.   },
  74.   {
  75.     "value": "18",
  76.     "text": "18班"
  77.   },
  78.   {
  79.     "value": "19",
  80.     "text": "19班"
  81.   },
  82.   {
  83.     "value": "20",
  84.     "text": "20班"
  85.   }
  86. ]

当前学年学期

  • constantKey：currentSemester

  • constantType：object

  1. {
  2.   "year": 2023,
  3.   "semester": "秋季"
  4. }

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'academicYear', 'array', '学年列表', '[{"value":"2022","text":"2022学年"},{"value": "2023","text": "2023学年"},{"value":"2024","text":"2024学年"},{"value": "2025","text": "2025学年"},{"value": "2026","text": "2026学年"},{"value": "2027","text": "2027学年"},{"value": "2028","text": "2028学年"},{"value": "2029","text": "2029学年"},{"value": "2030","text": "2030学年"}]', 'insert', NULL, NULL, NULL);
  2. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'semester', 'array', '学期列表', '[{"value":"秋季","text":"秋季"},{"value": "春季","text": "春季"}]', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'segment', 'object', '学部列表', '[{"value":"小学","text":"小学"},{"value": "初中","text": "初中"},{"value": "高中","text": "高中"}]', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'level', 'object', '年级列表', '[
  5.     {"value":"01","text":"一年级","segment":"小学"},
  6.     {"value":"02","text":"二年级","segment":"小学"},
  7.     {"value":"03","text":"三年级","segment":"小学"},
  8.     {"value": "04","text": "四年级","segment":"小学"},
  9.     {"value": "05","text": "五年级","segment":"小学"},
  10.     {"value": "06","text": "六年级","segment":"小学"},
  11.     {"value": "07","text": "七年级","segment":"初中"},
  12.     {"value": "08","text": "八年级","segment":"初中"},
  13.     {"value": "09","text": "九年级","segment":"初中"},
  14.     {"value": "10","text": "高一","segment":"高中"},
  15.     {"value": "11","text": "高二","segment":"高中"},
  16.     {"value": "12","text": "高三","segment":"高中"}
  17. ]', 'insert', NULL, NULL, NULL);
  18. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'afterSchoolCareType', 'object', '托管类型', '[{"value":"日托","text":"日托"},{"value": "周托","text": "周托"},{"value": "半月托","text": "半月托"},{"value": "月托","text": "月托"}]', 'insert', NULL, NULL, NULL);
  19. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'freshmanOrReturning', 'object', '新生/老生', '[{"value":"新生","text":"新生"},{"value": "老生","text": "老生"}]', 'insert', NULL, NULL, NULL);
  20. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'paymentItem', 'object', '缴费项目', '[{"value":"学费","text":"学费"},{"value": "住宿","text": "住宿"},{"value":"伙食","text":"伙食"},{"value": "校服","text": "校服"},{"value":"床上用品","text":"床上用品"},{"value": "保险","text": "保险"},{"value":"家校通","text":"家校通"},{"value": "课本资料","text": "课本资料"}]', 'insert', NULL, NULL, NULL);
  21. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'paymentConfig', 'object', '缴费规则配置', '[
  22.   {
  23.     "segment": "小学",
  24.     "afterSchoolCareType": "日托",
  25.     "freshmanOrReturning": "老生",
  26.     "paymentItem": [
  27.       {
  28.         "item": "学费",
  29.         "amount": "5400"
  30.       },
  31.       {
  32.         "item": "住宿",
  33.         "amount": "600"
  34.       },
  35.       {
  36.         "item": "伙食",
  37.         "amount": "2000"
  38.       },
  39.       {
  40.         "item": "保险",
  41.         "amount": "50"
  42.       },
  43.       {
  44.         "item": "家校通",
  45.         "amount": "100"
  46.       }
  47.     ]
  48.   },
  49.   {
  50.     "segment": "小学",
  51.     "afterSchoolCareType": "日托",
  52.     "freshmanOrReturning": "新生",
  53.     "paymentItem": [
  54.       {
  55.         "item": "学费",
  56.         "amount": "5400"
  57.       },
  58.       {
  59.         "item": "住宿",
  60.         "amount": "600"
  61.       },
  62.       {
  63.         "item": "伙食",
  64.         "amount": "2000"
  65.       },
  66.       {
  67.         "item": "校服",
  68.         "amount": "800"
  69.       },
  70.       {
  71.         "item": "床上用品",
  72.         "amount": "600"
  73.       },
  74.       {
  75.         "item": "保险",
  76.         "amount": "50"
  77.       },
  78.       {
  79.         "item": "家校通",
  80.         "amount": "100"
  81.       }
  82.     ]
  83.   },
  84.   {
  85.     "segment": "小学",
  86.     "afterSchoolCareType": "周托",
  87.     "freshmanOrReturning": "老生",
  88.     "paymentItem": [
  89.       {
  90.         "item": "学费",
  91.         "amount": "5400"
  92.       },
  93.       {
  94.         "item": "住宿",
  95.         "amount": "1000"
  96.       },
  97.       {
  98.         "item": "伙食",
  99.         "amount": "2400"
  100.       },
  101.       {
  102.         "item": "保险",
  103.         "amount": "50"
  104.       },
  105.       {
  106.         "item": "家校通",
  107.         "amount": "100"
  108.       }
  109.     ]
  110.   },
  111.   {
  112.     "segment": "小学",
  113.     "afterSchoolCareType": "周托",
  114.     "freshmanOrReturning": "新生",
  115.     "paymentItem": [
  116.       {
  117.         "item": "学费",
  118.         "amount": "5400"
  119.       },
  120.       {
  121.         "item": "住宿",
  122.         "amount": "1000"
  123.       },
  124.       {
  125.         "item": "伙食",
  126.         "amount": "2400"
  127.       },
  128.       {
  129.         "item": "校服",
  130.         "amount": "800"
  131.       },
  132.       {
  133.         "item": "床上用品",
  134.         "amount": "600"
  135.       },
  136.       {
  137.         "item": "保险",
  138.         "amount": "50"
  139.       },
  140.       {
  141.         "item": "家校通",
  142.         "amount": "100"
  143.       }
  144.     ]
  145.   },
  146.   {
  147.     "segment": "小学",
  148.     "afterSchoolCareType": "月托",
  149.     "freshmanOrReturning": "老生",
  150.     "paymentItem": [
  151.       {
  152.         "item": "学费",
  153.         "amount": "6000"
  154.       },
  155.       {
  156.         "item": "住宿",
  157.         "amount": "1200"
  158.       },
  159.       {
  160.         "item": "伙食",
  161.         "amount": "3000"
  162.       },
  163.       {
  164.         "item": "保险",
  165.         "amount": "50"
  166.       },
  167.       {
  168.         "item": "家校通",
  169.         "amount": "100"
  170.       }
  171.     ]
  172.   },
  173.   {
  174.     "segment": "小学",
  175.     "afterSchoolCareType": "月托",
  176.     "freshmanOrReturning": "新生",
  177.     "paymentItem": [
  178.       {
  179.         "item": "学费",
  180.         "amount": "6000"
  181.       },
  182.       {
  183.         "item": "住宿",
  184.         "amount": "1200"
  185.       },
  186.       {
  187.         "item": "伙食",
  188.         "amount": "3000"
  189.       },
  190.       {
  191.         "item": "校服",
  192.         "amount": "800"
  193.       },
  194.       {
  195.         "item": "床上用品",
  196.         "amount": "600"
  197.       },
  198.       {
  199.         "item": "保险",
  200.         "amount": "50"
  201.       },
  202.       {
  203.         "item": "家校通",
  204.         "amount": "100"
  205.       }
  206.     ]
  207.   },
  208.   {
  209.     "segment": "初中",
  210.     "afterSchoolCareType": "半月托",
  211.     "freshmanOrReturning": "老生",
  212.     "paymentItem": [
  213.       {
  214.         "item": "学费",
  215.         "amount": "6400"
  216.       },
  217.       {
  218.         "item": "住宿",
  219.         "amount": "1200"
  220.       },
  221.       {
  222.         "item": "伙食",
  223.         "amount": "3000"
  224.       },
  225.       {
  226.         "item": "保险",
  227.         "amount": "50"
  228.       },
  229.       {
  230.         "item": "家校通",
  231.         "amount": "100"
  232.       }
  233.     ]
  234.   },
  235.   {
  236.     "segment": "初中",
  237.     "afterSchoolCareType": "半月托",
  238.     "freshmanOrReturning": "新生",
  239.     "paymentItem": [
  240.       {
  241.         "item": "学费",
  242.         "amount": "6400"
  243.       },
  244.       {
  245.         "item": "住宿",
  246.         "amount": "1200"
  247.       },
  248.       {
  249.         "item": "伙食",
  250.         "amount": "3000"
  251.       },
  252.       {
  253.         "item": "校服",
  254.         "amount": "800"
  255.       },
  256.       {
  257.         "item": "床上用品",
  258.         "amount": "600"
  259.       },
  260.       {
  261.         "item": "保险",
  262.         "amount": "50"
  263.       },
  264.       {
  265.         "item": "家校通",
  266.         "amount": "100"
  267.       }
  268.     ]
  269.   },
  270.   {
  271.     "segment": "初中",
  272.     "afterSchoolCareType": "月托",
  273.     "freshmanOrReturning": "老生",
  274.     "paymentItem": [
  275.       {
  276.         "item": "学费",
  277.         "amount": "7000"
  278.       },
  279.       {
  280.         "item": "住宿",
  281.         "amount": "1200"
  282.       },
  283.       {
  284.         "item": "伙食",
  285.         "amount": "3400"
  286.       },
  287.       {
  288.         "item": "保险",
  289.         "amount": "50"
  290.       },
  291.       {
  292.         "item": "家校通",
  293.         "amount": "100"
  294.       }
  295.     ]
  296.   },
  297.   {
  298.     "segment": "初中",
  299.     "afterSchoolCareType": "月托",
  300.     "freshmanOrReturning": "新生",
  301.     "paymentItem": [
  302.       {
  303.         "item": "学费",
  304.         "amount": "7000"
  305.       },
  306.       {
  307.         "item": "住宿",
  308.         "amount": "1200"
  309.       },
  310.       {
  311.         "item": "伙食",
  312.         "amount": "3400"
  313.       },
  314.       {
  315.         "item": "校服",
  316.         "amount": "800"
  317.       },
  318.       {
  319.         "item": "床上用品",
  320.         "amount": "600"
  321.       },
  322.       {
  323.         "item": "保险",
  324.         "amount": "50"
  325.       },
  326.       {
  327.         "item": "家校通",
  328.         "amount": "100"
  329.       }
  330.     ]
  331.   },
  332.   {
  333.     "segment": "高中",
  334.     "afterSchoolCareType": "月托",
  335.     "freshmanOrReturning": "老生",
  336.     "paymentItem": [
  337.       {
  338.         "item": "学费",
  339.         "amount": "9000"
  340.       },
  341.       {
  342.         "item": "住宿",
  343.         "amount": "1200"
  344.       },
  345.       {
  346.         "item": "伙食",
  347.         "amount": "3400"
  348.       },
  349.       {
  350.         "item": "保险",
  351.         "amount": "50"
  352.       },
  353.       {
  354.         "item": "家校通",
  355.         "amount": "100"
  356.       },
  357.       {
  358.         "item": "课本资料",
  359.         "amount": "1200"
  360.       }
  361.     ]
  362.   },
  363.   {
  364.     "segment": "高中",
  365.     "afterSchoolCareType": "月托",
  366.     "freshmanOrReturning": "新生",
  367.     "paymentItem": [
  368.       {
  369.         "item": "学费",
  370.         "amount": "9000"
  371.       },
  372.       {
  373.         "item": "住宿",
  374.         "amount": "1200"
  375.       },
  376.       {
  377.         "item": "伙食",
  378.         "amount": "3400"
  379.       },
  380.       {
  381.         "item": "校服",
  382.         "amount": "800"
  383.       },
  384.       {
  385.         "item": "床上用品",
  386.         "amount": "600"
  387.       },
  388.       {
  389.         "item": "保险",
  390.         "amount": "50"
  391.       },
  392.       {
  393.         "item": "家校通",
  394.         "amount": "100"
  395.       },
  396.       {
  397.         "item": "课本资料",
  398.         "amount": "1200"
  399.       }
  400.     ]
  401.   }
  402. ]', 'insert', NULL, NULL, NULL);
  403. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'paymentType', 'object', '缴费类型', '[{"value":"学费","text":"学费"}]', 'insert', NULL, NULL, NULL);
  404. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'level', 'object', '年级列表', '[
  405.     {"value":"01","text":"一年级","segment":"小学"},
  406.     {"value":"02","text":"二年级","segment":"小学"},
  407.     {"value":"03","text":"三年级","segment":"小学"},
  408.     {"value": "04","text": "四年级","segment":"小学"},
  409.     {"value": "05","text": "五年级","segment":"小学"},
  410.     {"value": "06","text": "六年级","segment":"小学"},
  411.     {"value": "07","text": "七年级","segment":"初中"},
  412.     {"value": "08","text": "八年级","segment":"初中"},
  413.     {"value": "09","text": "九年级","segment":"初中"},
  414.     {"value": "10","text": "高一","segment":"高中"},
  415.     {"value": "11","text": "高二","segment":"高中"},
  416.     {"value": "12","text": "高三","segment":"高中"}
  417. ]', 'insert', NULL, NULL, NULL);
  418. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'number', 'array', '班号', '[{"value":"00","text":"待分班"},{"value":"01","text":"01班"},{"value": "02","text": "02班"},{"value":"03","text":"03班"},{"value": "04","text": "04班"},{"value": "05","text": "05班"},{"value": "06","text": "06班"},{"value": "07","text": "07班"},{"value": "08","text": "08班"},{"value": "09","text": "09班"},{"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班"},{"value": "19","text": "19班"},{"value": "20","text": "20班"}]', 'insert', NULL, NULL, NULL);
  419. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'currentSemester', 'object', '当前学年学期', '{"year":2023,"semester":"秋季"}', 'jhUpdate', 'admin', '系统管理员', '2023-07-25T14:29:30+08:00');