文档
一、数据库SQL
考勤服务数据库
配置表新增请假类型
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, dict_category) VALUES(8, '产假', '48', 'MARK_LEAVE_TYPE', NULL, NULL, 'N', '0', '', '2023-01-31 13:44:42', '', '2023-01-31 13:44:42', '请假类型', 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, dict_category) VALUES(9, '陪产假', '49', 'MARK_LEAVE_TYPE', NULL, NULL, 'N', '0', '', '2023-01-31 13:44:42', '', '2023-01-31 13:44:42', '请假类型', NULL);
update sys_dict_data set status=1 where dict_label='其他假' and dict_type='MARK_LEAVE_TYPE';
审批表新增字段、部分字段去除非空限制
ALTER TABLE att_approval_records ADD approval_start_time varchar(20) NULL COMMENT '审批事件的开始时间';
ALTER TABLE att_approval_records ADD approval_end_time varchar(20) NULL COMMENT '审批事件的结束时间';
ALTER TABLE att_approval_records ADD approval_time_length varchar(10) NULL COMMENT '审批事件的时长(例:1天,2小时)';
ALTER TABLE att_approval_records ADD cancel_reason varchar(200) NULL COMMENT '审批撤销理由';
alter table att_approval_records add column `location_rule_id` int(11) DEFAULT NULL COMMENT '所选位置规则ID';
alter table att_approval_records add column `confirm_leave_date` varchar(5000) DEFAULT NULL COMMENT '确认的请假日期和班次';
alter table att_approval_records add column `audit_pass_time` varchar(16) DEFAULT NULL COMMENT '审核通过时间';
ALTER TABLE att_approval_records MODIFY COLUMN clock_date varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '需补卡的日期';
ALTER TABLE att_approval_records MODIFY COLUMN clock_category int(11) NULL COMMENT '需补卡的打卡种类(1:上班打卡 2:下班打卡)';
ALTER TABLE att_approval_records MODIFY COLUMN discard_type tinyint(2) NULL COMMENT '缺卡类型(1:缺卡;2:未打卡)';
ALTER TABLE att_approval_records MODIFY COLUMN card_replace_time varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' NULL COMMENT '补卡时间';
-- 考勤规则表新增休息时间相关字段
alter table clock_time_rule add column `open_rest` tinyint(2) NOT NULL DEFAULT '0' COMMENT '开启休息时间:0否,1是';
alter table clock_time_rule add column `rest_start` varchar(10) NOT NULL DEFAULT '' COMMENT '休息开始时间';
alter table clock_time_rule add column `rest_end` varchar(10) NOT NULL DEFAULT '' COMMENT '休息结束时间';
alter table clock_time_rule add column `rest_start_extend_day` tinyint(2) NOT NULL DEFAULT '0' COMMENT '休息开始时间是否跨日(0否(默认) 1是)';
alter table clock_time_rule add column `rest_end_extend_day` tinyint(2) NOT NULL DEFAULT '0' COMMENT '休息结束时间是否跨日(0否(默认) 1是)';
更新考勤库配置表请假类型排序
update sys_dict_data set dict_sort = 1, css_class = '#10BE9D', dict_category = 1 where dict_label = '年假';
update sys_dict_data set dict_sort = 2, css_class = '#0088FE', dict_category = 1 where dict_label = '事假';
update sys_dict_data set dict_sort = 3, css_class = '#FB9541', dict_category = 1 where dict_label = '病假';
update sys_dict_data set dict_sort = 4, css_class = '#6955FE', dict_category = 0, status=1 where dict_label = '调休';
update sys_dict_data set dict_sort = 5, css_class = '#FECC55', dict_category = 2 where dict_label = '婚假';
update sys_dict_data set dict_sort = 6, css_class = '#F79DFF', dict_category = 2 where dict_label = '丧假';
update sys_dict_data set dict_sort = 8, css_class = '#F95245', dict_category = 2 where dict_label = '产假';
update sys_dict_data set dict_sort = 9, css_class = '#55E4FE', dict_category = 2 where dict_label = '陪产假';
update sys_dict_data set dict_value = 44, dict_label = '调休' where dict_type = 'NOMAL_CLOCK_MARK' and dict_label = '请假';
字段说明修改
ALTER TABLE attendance_prod0715.att_approval_records MODIFY COLUMN `type` tinyint(2) NOT NULL COMMENT '审批类型(1:补卡 41:事假 42:病假 43:年假 44:调休 45:婚假 46:丧假 48:产假 49:陪产假(后续还有请假))';
ALTER TABLE attendance_prod0715.att_approval_records MODIFY COLUMN status tinyint(2) NOT NULL COMMENT '状态(0:待审批 1:同意(10:已通过-请假成功后撤销待审批,11:已通过-请假成功后撤销被拒绝,12:已通过-请假成功后销假成功) 2:拒绝 3:撤销)';
ALTER TABLE attendance_records MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202204 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202205 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202206 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202207 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202208 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202209 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202210 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202211 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202212 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202301 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202302 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records202303 MODIFY COLUMN mark_type tinyint(2) DEFAULT 0 NOT NULL COMMENT '0待标记, 1休息 2旷工 3补卡 4请假(41事假, 42病假, 43年假, 44调休, 45婚假, 46丧假, 47其他假, 48产假,49陪产假) 5正常外勤';
ALTER TABLE attendance_records MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202204 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202205 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202206 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202207 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202208 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202209 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202210 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202211 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202212 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202301 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202302 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
ALTER TABLE attendance_records202303 MODIFY COLUMN approval_status tinyint(4) DEFAULT 0 NOT NULL COMMENT '审批状态(0:非审批 1:补卡审批 2:请假审批)';
易聘小程序数据库
员工端工作台新增“请假”入口
INSERT INTO workbench_table (`level`, name, url, father_id, status, create_time, update_time, order_num, icon_url, `type`) VALUES(1, '请假', '/pagesAssess/consumer/leave', NULL, 0, '2023-02-16 10:54:46', '2023-02-16 10:57:00', 2, 'https://lkl.lurb.online/recruiter/download/logo/icon14.png', 2);
update workbench_table set order_num=3 where name='合同签署';
update workbench_table set order_num=4 where name='防疫登记';
易聘小程序配置文件新增
# 请假审批通知
templateId_11: o369XqIV8c6Y5G9idsmiUrKrVJsyQfKQURd6sn5t0Os
# 请假审批结果通知
templateId_12: GKQp4_AyfjLW2b9h3Dd0GoDMvoj1uS9RlkE3-qUJ_eM
修改于 2023-03-07 05:47:49