执行文档

任务描述：生成待确认的考勤记录
JobHandler：syncGenerate
Cron：0 0 9 * * ? 


任务描述：超时未确认，自动审核
JobHandler：timeoutConfirmation
Cron：0 5 0 * * ? 


任务描述：过期更新数据--假期
JobHandler：updateLeaveBalanceAvailableTime
Cron：0 0 0 * * ? 

CREATE TABLE `attendance_confirmation` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `emp_records_id` int NOT NULL COMMENT '员工花名册ID',
  `attendance_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '考勤年月（yyyy/MM）',
  `attendance_start_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '考勤开始时间（yyyy/MM/dd）',
  `attendance_end_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '考勤截止时间（yyyy/MM/dd）',
  `attendance_confirmation_start_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '确认考勤开始时间（yyyy/MM/dd）',
  `attendance_confirmation_end_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '确认考勤截止时间（yyyy/MM/dd）',
  `attendance_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '考勤数据',
  `img_url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '签名图片',
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态（0：未确认，1：已确认，2：超时未确认）',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='考勤确认表';

ALTER TABLE attendance_confirmation ADD proj_id int DEFAULT 0 NOT NULL COMMENT '项目id';
ALTER TABLE attendance_confirmation DROP COLUMN attendance_data;

spring:
  minio:
    url: http://192.172.0.106:37491/
    outer-url: http://183.162.193.78:37491/
    access-key: minioadmin
    secret-key: Sunyard@106!1

## 图片识别
recognition:
  # url: http://192.170.0.134:7020/inventory1
  # url: http://192.170.0.134:7023/inventory2
  url: http://192.170.8.224:5031/inventory2
  userId: user
  verifyCode: 123

INSERT INTO wk_crm_table.wk_admin_menu 
(parent_id,menu_name,realm,realm_url,realm_module,menu_type,sort,status,remarks,project_type,module_type,ddyp_menu_id,icon) VALUES
(1745,'考勤计薪确认','pagesAssess:confirm:confirmList','/pagesAssess/confirm/confirmList','hr',1,5,1,NULL,'1',2,2088,'http://183.162.193.78:37491/ddyp-image/444abdf5-af6d-4afb-8421-44c00c99b56d.png');

1、考勤确认--月度统计--出勤，包含带薪假期
2、考勤确认--月度统计--出勤，假设打卡日期是2023/01/01，只打卡了一次，打卡时间为2023-01-02 08:30:00那就为2023-01-02（星期五）上午，要是18:30:00那就是下午，上午下午以12点为分割，要是一整天，显示打卡日期2023-01-01（星期五）
3、考勤确认--月度统计--迟到/早退，显示的用户实际的打卡时间