1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
| INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `create_id`, `update_id`) VALUES (5, '职业个人', '5', 'dict_team', NULL, 'default', 'N', '0', '超级管理员', '2025-05-09 08:55:46', '', NULL, NULL, 0, NULL, NULL);
| INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `create_id`, `update_id`) VALUES (6, '职业团队', '6', 'dict_team', NULL, 'default', 'N', '0', '超级管理员', '2025-05-09 08:55:58', '', NULL, NULL, 0, NULL, NULL);
|
|
| ALTER TABLE tj_ask_medical_history ADD COLUMN medical_history_ids VARCHAR(255) NULL BEFORE medical_history;
| ALTER TABLE tj_ask_medical_history ADD COLUMN medical_history_other TEXT NULL AFTER medical_history;
| ALTER TABLE tj_ask_medical_history MODIFY COLUMN medical_history TEXT;
| ALTER TABLE tj_ask_medical_history ADD COLUMN dwmc TEXT NULL;
| ALTER TABLE tj_ask_medical_history ADD COLUMN ygdw TEXT NULL;
| ALTER TABLE tj_ask_historys ADD COLUMN data_type TINYINT(1) NOT NULL COMMENT '数据类型 1病史信息 2症状信息';
|
| INSERT INTO `sys_config` (`config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `deleted`, `create_id`, `update_id`)
| VALUES ('职业体检类型', 'zhiye_tj_type', '5,6', 'Y', '10001', '2025-05-12 16:14:56', '', NULL, '英文逗号分隔', 0, NULL, NULL);
|
| ALTER TABLE tj_order ADD COLUMN zhiye_jhgln VARCHAR(255) NULL COMMENT '接害工龄年';
| ALTER TABLE tj_order ADD COLUMN zhiye_jhgly VARCHAR(255) NULL COMMENT '接害工龄月';
| ALTER TABLE tj_order ADD COLUMN zhiye_ksjhrq DATETIME NULL COMMENT '开始接害日期';
| ALTER TABLE tj_order ADD COLUMN zhiye_gh VARCHAR(255) NULL COMMENT '工号';
| ALTER TABLE tj_order ADD COLUMN zhiye_cj VARCHAR(255) NULL COMMENT '车间';
| ALTER TABLE tj_order ADD COLUMN zhiye_jl VARCHAR(255) NULL COMMENT '职业结论';
| ALTER TABLE tj_order ADD COLUMN zhiye_jg VARCHAR(255) NULL COMMENT '职业结果';
|
| ALTER TABLE `tj_order`
| ADD COLUMN `zhiye_gz` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业工种' AFTER `zhiye_jg`,
| ADD COLUMN `zhiye_zgln` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业总工龄年' AFTER `zhiye_gz`,
| ADD COLUMN `zhiye_zgly` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '总工龄月' AFTER `zhiye_zgln`,
| ADD COLUMN `zhiye_jhys` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业接害因素' AFTER `zhiye_zgly`,
| ADD COLUMN `zhiye_rzsj` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业入职时间' AFTER `zhiye_jhys`,
| ADD COLUMN `zhiye_scdw` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业所处单位' AFTER `zhiye_rzsj`,
| ADD COLUMN `zhiye_zysksrq` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业史开始日期' AFTER `zhiye_scdw`,
| ADD COLUMN `zhiye_zysjsrq` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业史结束日期' AFTER `zhiye_zysksrq`,
| ADD COLUMN `zhiye_zysszdw` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '职业史所在单位' AFTER `zhiye_zysjsrq`;
|
| # 存储过程修改
| # tj_check_list
| # 增加参数以及最终结果集返回增加条件
| # 在OUT参数前增加：
| IN p_tjCategory VARCHAR(100)
| # 最终返回条件查询
| -- 计算总行数
| select count(tjNumber) into total from ls_check_list WHERE (p_tjCategory IS NULL OR tjCategory = p_tjCategory);
| -- 执行分页查询并返回结果集
| if checkStatus =0 THEN
| select * from ls_check_list WHERE (p_tjCategory IS NULL OR tjCategory = p_tjCategory) ORDER BY finishTime DESC LIMIT page,pageSize;
| ELSE
| select * from ls_check_list WHERE (p_tjCategory IS NULL OR tjCategory = p_tjCategory) ORDER BY shsj DESC LIMIT page,pageSize;
| END if;
|
|
