说明文档

任务描述：生成待确认的考勤记录
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;
ALTER table attendance_confirmation add column `attendance_pay_rule` varchar(5000) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '考勤计薪规则备份';

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、考勤确认--月度统计--迟到/早退，显示的用户实际的打卡时间

create table syd_hrm_attendance_pay_rule
(
    rule_id               bigint                             not null comment '考勤计薪规则ID'
        primary key,
    proj_id               bigint                             not null comment '项目ID',
    rule_name             varchar(50)                        not null comment '请假/考勤异常名称',
    basic_wage            varchar(50)                        null comment '基本工资',
    basic_wage_type       int                                null comment '基本工资发放类型 1按比例 2按固定金额',
    skill_wage            varchar(50)                        null comment '技能工资',
    skill_wage_type       int                                null comment '技能工资发放类型 1按比例 2按固定金额',
    check_wage            varchar(50)                        null comment '考核工资',
    check_wage_type       int                                null comment '考核工资发放类型 1按比例 2按固定金额',
    post_allowance        varchar(50)                        null comment '岗位津贴',
    post_allowance_type   int                                null comment '岗位津贴发放类型 1按比例 2按固定金额',
    full_attendance_award int                                null comment '全勤奖 1发放 2不发放',
    create_user_id        bigint                             not null comment '创建人ID',
    update_user_id        bigint                             null comment '修改人ID',
    create_time           datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time           datetime default CURRENT_TIMESTAMP not null comment '修改时间'
)
    comment '考勤计薪规则表' collate = utf8mb4_bin;
create unique index syd_hrm_attendance_pay_rule_unique_index
    on syd_hrm_attendance_pay_rule (proj_id, rule_name)
    comment '唯一索引';

create table syd_hrm_subsidy_rule
(
    subsidy_id      bigint                             not null comment '补贴ID'
        primary key,
    rule_id         bigint                             not null comment '考勤计薪规则ID',
    subsidy_name    varchar(50)                        not null comment '补贴名称',
    subsidy_en_name varchar(50)                        not null comment '补贴英文名称',
    half_day        varchar(50)                        not null comment '半天',
    all_day         varchar(50)                        not null comment '全天',
    create_user_id  bigint                             not null comment '创建人ID',
    update_user_id  bigint                             null comment '修改人ID',
    create_time     datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_time     datetime default CURRENT_TIMESTAMP not null comment '修改时间'
)
    comment '补贴发放规则表' collate = utf8mb4_bin;
create unique index syd_hrm_subsidy_rule_unique_index
    on syd_hrm_subsidy_rule (rule_id, subsidy_name)
    comment '唯一索引';

alter table syd_hrm_salary_plan_other
    modify calculate_type int null comment '计薪方式1按件2按次3按小时4按天5按月';
    
alter table syd_hrm_salary_plan_other
    add max_count int null comment '发放次数上限' after provide_condition;
    
alter table syd_hrm_salary_plan_other
    add income_conversion_wage varchar(50) null comment '收入折算单价(含税)' after max_count;
    
update syd_hrm_salary_plan_other set calculate_type = 5 where calculate_type = 6;

update syd_proj_config
set remark = 'uczwgo'
where config_type = 'SUBSIDY_OPTIONS'
  and config_code = '餐补';

update syd_proj_config
set remark = 'bxukol'
where config_type = 'SUBSIDY_OPTIONS'
  and config_code = '交通补贴';

ALTER TABLE wk_crm_table.wk_examine ADD proj_role_ids longtext NULL COMMENT '可见范围（角色）';
ALTER TABLE wk_crm_table.wk_examine CHANGE proj_role_ids proj_role_ids longtext NULL COMMENT '可见范围（角色）' AFTER dept_ids;