bonus
/
hd_real_name
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
hd_real_name/logs/sys-back.log.sql.2024-12-16.0

1179 lines
147 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

2024-12-16 17:47:07,359 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 31556 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
2024-12-16 17:47:07,365 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2024-12-16 17:47:07,366 [main] No active profile set, falling back to default profiles: default
2024-12-16 17:47:13,945 [main] SSHConnectionListener initialized ... !
2024-12-16 17:47:13,950 [main] Filter 'tokenFilter' configured for use
2024-12-16 17:47:17,079 [main] Started SecurityApplication in 10.385 seconds (JVM running for 12.534)
2024-12-16 17:47:17,084 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2024-12-16 17:47:17,084 [taskExecutor-3] --------红名单定时器启动------
2024-12-16 17:47:17,084 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2024-12-16 17:47:17,504 [taskExecutor-1] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = '1' and bnst.examine_status = '1'
2024-12-16 17:47:17,535 [taskExecutor-1] ==> Parameters:
2024-12-16 17:47:17,611 [taskExecutor-1] <== Total: 1
2024-12-16 17:47:17,614 [taskExecutor-2] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = 1 and bnst.examine_status = '4'
2024-12-16 17:47:17,614 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2024-12-16 17:47:17,614 [taskExecutor-2] ==> Parameters:
2024-12-16 17:47:17,635 [taskExecutor-2] <== Total: 1
2024-12-16 17:47:17,635 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2024-12-16 17:47:17,635 [taskExecutor-3] ==> Preparing: SELECT a.id_number AS `key`, a.pro_id AS `value` FROM ( SELECT bwg.id_number, bwg.pro_id, bwg.org_id, COUNT( id_number ) AS likeData, IFNULL( brs.red_num, '100' ) AS num FROM bm_worker_give bwg LEFT JOIN pm_organization po on po.id = bwg.org_id LEFT JOIN pm_company pc on pc.id = po.COMPANY_ID LEFT JOIN bm_redlist_set brs ON brs.org_id = pc.id WHERE bwg.IS_ACTIVE = '1' GROUP BY bwg.id_number, bwg.pro_id HAVING COUNT( id_number ) >= num ) a LEFT JOIN bm_redlist_worker brw ON brw.ID_NUMBER = a.id_number -- AND brw.pro_id = a.pro_id WHERE brw.ID_NUMBER IS NULL
2024-12-16 17:47:17,636 [taskExecutor-3] ==> Parameters:
2024-12-16 17:47:17,658 [taskExecutor-3] <== Total: 0
2024-12-16 17:47:17,659 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
2024-12-16 17:48:33,073 [SpringContextShutdownHook] SSHConnectionListener destroyed ... !
2024-12-16 17:48:41,147 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 33340 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
2024-12-16 17:48:41,150 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2024-12-16 17:48:41,151 [main] No active profile set, falling back to default profiles: default
2024-12-16 17:48:44,554 [main] SSHConnectionListener initialized ... !
2024-12-16 17:48:44,564 [main] Filter 'tokenFilter' configured for use
2024-12-16 17:48:46,676 [main] Started SecurityApplication in 6.007 seconds (JVM running for 7.784)
2024-12-16 17:48:46,680 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2024-12-16 17:48:46,680 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2024-12-16 17:48:46,681 [taskExecutor-3] --------红名单定时器启动------
2024-12-16 17:48:47,011 [taskExecutor-3] ==> Preparing: SELECT a.id_number AS `key`, a.pro_id AS `value` FROM ( SELECT bwg.id_number, bwg.pro_id, bwg.org_id, COUNT( id_number ) AS likeData, IFNULL( brs.red_num, '100' ) AS num FROM bm_worker_give bwg LEFT JOIN pm_organization po on po.id = bwg.org_id LEFT JOIN pm_company pc on pc.id = po.COMPANY_ID LEFT JOIN bm_redlist_set brs ON brs.org_id = pc.id WHERE bwg.IS_ACTIVE = '1' GROUP BY bwg.id_number, bwg.pro_id HAVING COUNT( id_number ) >= num ) a LEFT JOIN bm_redlist_worker brw ON brw.ID_NUMBER = a.id_number -- AND brw.pro_id = a.pro_id WHERE brw.ID_NUMBER IS NULL
2024-12-16 17:48:47,031 [taskExecutor-3] ==> Parameters:
2024-12-16 17:48:47,090 [taskExecutor-3] <== Total: 0
2024-12-16 17:48:47,092 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
2024-12-16 17:48:47,092 [taskExecutor-1] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = '1' and bnst.examine_status = '1'
2024-12-16 17:48:47,093 [taskExecutor-1] ==> Parameters:
2024-12-16 17:48:47,142 [taskExecutor-1] <== Total: 1
2024-12-16 17:48:47,142 [taskExecutor-2] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = 1 and bnst.examine_status = '4'
2024-12-16 17:48:47,142 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2024-12-16 17:48:47,142 [taskExecutor-2] ==> Parameters:
2024-12-16 17:48:47,186 [taskExecutor-2] <== Total: 1
2024-12-16 17:48:47,187 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2024-12-16 17:49:07,028 [http-nio-1918-exec-7] 验证码：3RTK用户输入：3RTk
2024-12-16 17:49:07,580 [http-nio-1918-exec-7] ==> Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2024-12-16 17:49:07,581 [http-nio-1918-exec-7] ==> Parameters: bnsAdmin(String)
2024-12-16 17:49:07,611 [http-nio-1918-exec-7] <== Total: 1
2024-12-16 17:49:07,618 [http-nio-1918-exec-7] ==> Preparing: select distinct p.* from sys_permission p inner join sys_role_permission rp on p.id = rp.permissionId inner join sys_role_user ru on ru.roleId = rp.roleId where ru.userId = ? and p.is_active = '1' order by p.sort
2024-12-16 17:49:07,619 [http-nio-1918-exec-7] ==> Parameters: 249(Long)
2024-12-16 17:49:07,674 [http-nio-1918-exec-7] <== Total: 156
2024-12-16 17:49:07,749 [http-nio-1918-exec-7] Authenticated user
2024-12-16 17:49:07,778 [taskExecutor-4] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2024-12-16 17:49:07,781 [taskExecutor-4] ==> Parameters: 249(Long), 登陆(String), true(Boolean), null
2024-12-16 17:49:07,839 [taskExecutor-4] <== Updates: 1
2024-12-16 17:49:14,793 [http-nio-1918-exec-3] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:49:14,794 [http-nio-1918-exec-3] ==> Parameters: null
2024-12-16 17:49:14,813 [http-nio-1918-exec-3] <== Total: 0
2024-12-16 17:49:15,062 [http-nio-1918-exec-3] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2024-12-16 17:49:15,062 [http-nio-1918-exec-3] ==> Parameters:
2024-12-16 17:49:15,083 [http-nio-1918-exec-3] <== Total: 19
2024-12-16 17:49:15,173 [http-nio-1918-exec-8] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:49:15,173 [http-nio-1918-exec-8] ==> Parameters: null
2024-12-16 17:49:15,191 [http-nio-1918-exec-8] <== Total: 0
2024-12-16 17:49:15,192 [http-nio-1918-exec-8] ==> Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2024-12-16 17:49:15,193 [http-nio-1918-exec-8] ==> Parameters:
2024-12-16 17:49:15,278 [http-nio-1918-exec-8] <== Total: 302
2024-12-16 17:49:15,381 [http-nio-1918-exec-10] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:49:15,381 [http-nio-1918-exec-10] ==> Parameters: null
2024-12-16 17:49:15,402 [http-nio-1918-exec-10] <== Total: 0
2024-12-16 17:49:15,421 [http-nio-1918-exec-10] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 17:49:15,423 [http-nio-1918-exec-10] ==> Parameters: 0(String)
2024-12-16 17:49:15,464 [http-nio-1918-exec-10] <== Total: 1
2024-12-16 17:49:15,464 [http-nio-1918-exec-10] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:49:15,465 [http-nio-1918-exec-10] ==> Parameters: null
2024-12-16 17:49:15,483 [http-nio-1918-exec-10] <== Total: 0
2024-12-16 17:49:15,484 [http-nio-1918-exec-10] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 17:49:15,486 [http-nio-1918-exec-10] ==> Parameters: 0(String), 0(Integer), 10(Integer)
2024-12-16 17:49:15,545 [http-nio-1918-exec-10] <== Total: 10
2024-12-16 17:49:29,159 [SpringContextShutdownHook] SSHConnectionListener destroyed ... !
2024-12-16 17:49:37,141 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 31864 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
2024-12-16 17:49:37,142 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2024-12-16 17:49:37,143 [main] No active profile set, falling back to default profiles: default
2024-12-16 17:49:40,793 [main] SSHConnectionListener initialized ... !
2024-12-16 17:49:40,798 [main] Filter 'tokenFilter' configured for use
2024-12-16 17:49:43,651 [main] Started SecurityApplication in 7.064 seconds (JVM running for 9.286)
2024-12-16 17:49:43,655 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2024-12-16 17:49:43,655 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2024-12-16 17:49:43,656 [taskExecutor-3] --------红名单定时器启动------
2024-12-16 17:49:44,084 [taskExecutor-3] ==> Preparing: SELECT a.id_number AS `key`, a.pro_id AS `value` FROM ( SELECT bwg.id_number, bwg.pro_id, bwg.org_id, COUNT( id_number ) AS likeData, IFNULL( brs.red_num, '100' ) AS num FROM bm_worker_give bwg LEFT JOIN pm_organization po on po.id = bwg.org_id LEFT JOIN pm_company pc on pc.id = po.COMPANY_ID LEFT JOIN bm_redlist_set brs ON brs.org_id = pc.id WHERE bwg.IS_ACTIVE = '1' GROUP BY bwg.id_number, bwg.pro_id HAVING COUNT( id_number ) >= num ) a LEFT JOIN bm_redlist_worker brw ON brw.ID_NUMBER = a.id_number -- AND brw.pro_id = a.pro_id WHERE brw.ID_NUMBER IS NULL
2024-12-16 17:49:44,114 [taskExecutor-3] ==> Parameters:
2024-12-16 17:49:44,175 [taskExecutor-3] <== Total: 0
2024-12-16 17:49:44,176 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
2024-12-16 17:49:44,176 [taskExecutor-2] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = 1 and bnst.examine_status = '4'
2024-12-16 17:49:44,177 [taskExecutor-2] ==> Parameters:
2024-12-16 17:49:44,208 [taskExecutor-2] <== Total: 1
2024-12-16 17:49:44,209 [taskExecutor-1] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = '1' and bnst.examine_status = '1'
2024-12-16 17:49:44,210 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2024-12-16 17:49:44,210 [taskExecutor-1] ==> Parameters:
2024-12-16 17:49:44,232 [taskExecutor-1] <== Total: 1
2024-12-16 17:49:44,234 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2024-12-16 17:49:49,621 [http-nio-1918-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:49:49,623 [http-nio-1918-exec-1] ==> Parameters: null
2024-12-16 17:49:49,646 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 17:49:49,685 [http-nio-1918-exec-1] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 17:49:49,686 [http-nio-1918-exec-1] ==> Parameters: 0(String)
2024-12-16 17:49:49,743 [http-nio-1918-exec-1] <== Total: 1
2024-12-16 17:49:49,744 [http-nio-1918-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:49:49,745 [http-nio-1918-exec-1] ==> Parameters: null
2024-12-16 17:49:49,767 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 17:49:49,769 [http-nio-1918-exec-1] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 17:49:49,770 [http-nio-1918-exec-1] ==> Parameters: 0(String), 0(Integer), 10(Integer)
2024-12-16 17:49:49,848 [http-nio-1918-exec-1] <== Total: 10
2024-12-16 17:49:54,607 [http-nio-1918-exec-2] 进入preventRepeatSubmit切面
2024-12-16 17:49:54,608 [http-nio-1918-exec-2] 防重复提交的请求地址：/gzrbmw/uploadPayroll/uploadPayrollPersonPush ,请求方式：POST
2024-12-16 17:49:54,610 [http-nio-1918-exec-2] 防重复提交拦截到的类名：UploadPayrollController ,方法：uploadPayrollPersonPush
2024-12-16 17:49:54,673 [http-nio-1918-exec-2] 获取到preventRepeatSubmit的有效期时间3
2024-12-16 17:49:54,694 [http-nio-1918-exec-2] ==> Preparing: SELECT bwpsi.`name`, bwpsi.idCard, bwph.id_number FROM bm_worker_provide_salary_info bwpsi LEFT JOIN bm_worker_push_history bwph ON bwph.pro_id = bwpsi.pro_id and bwph.id_number = bwpsi.idCard and bwph.is_active = '1' left join bm_worker_record bwr on bwr.ID_NUMBER = bwpsi.idCard WHERE bwpsi.submitBatchNo = ? and if((bwr.ein_status = 0 and bwr.is_ein_push = 1), true, bwr.PROJECT_ID != bwpsi.pro_id) GROUP BY bwpsi.idCard
2024-12-16 17:49:54,695 [http-nio-1918-exec-2] ==> Parameters: gspzb22(String)
2024-12-16 17:49:54,793 [http-nio-1918-exec-2] <== Total: 0
2024-12-16 17:49:54,794 [http-nio-1918-exec-2] ==> Preparing: SELECT 'true' AS submitApply, concat( 'SongBianDianProject', IFNULL( p.pro_old_id, p.id ) ) AS projectId, p.NAME AS projectName, concat( 'SongBianDianTeam', bst.id ) AS teamId, bst.NAME AS teamName, '贵州送变电有限责任公司' AS orgName, '9152000021440270X9' AS orgCreditCode, '银行卡' as payRollBankCardType, bwps.*, sdd.NAME AS bank, p.account_name AS accountName, p.open_bank_number AS accountNo, p.bank_name AS bankName, bwp.bankAffiliated, IF ( bwah.EXIT_TIME IS NOT NULL, '否', '是' ) AS whetherOnJob, IF ( bwah.EXIT_TIME IS NOT NULL, IFNULL( CONCAT( 'http://116.63.142.171:1919/gzrnama/', bwah.departureAffirmUrl ), 'http://npm.org/123.jpg' ), '' ) AS departureAffirmUrl FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bwps.idCard LEFT JOIN bm_worker_attend_history bwah ON bwr.ID_NUMBER = bwah.ID_NUMBER and bwr.PROJECT_ID = bwah.PROJECT_ID LEFT JOIN bm_project p ON p.id = bwps.pro_id or p.pro_old_id = bwps.pro_id LEFT JOIN sys_dic_detail sdd ON sdd.id = p.bank_account LEFT JOIN bm_worker_payroll bwp ON bwp.ID_NUMBER = bwps.idCard AND bwp.IS_ACTIVE = 1 LEFT JOIN ( SELECT * FROM ( SELECT bwph.ID_NUMBER, bwph.TEAM_ID FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_push_history bwph ON bwph.ID_NUMBER = bwps.idCard AND bwph.pro_id = bwph.pro_id AND bwph.is_active = 1 WHERE bwps.submitBatchNo = ? ORDER BY bwph.create_time DESC LIMIT 100000000000 ) a GROUP BY a.ID_NUMBER ) a ON a.ID_NUMBER = bwps.idCard LEFT JOIN bm_sub_team bst ON bst.id = bwr.TEAM_ID WHERE bwr.ID_NUMBER IS NOT NULL AND bwps.submitBatchNo IS NOT NULL AND bwps.is_push != 1 AND bwps.submitBatchNo = ? and departureAffirmUrl is null
2024-12-16 17:49:54,795 [http-nio-1918-exec-2] ==> Parameters: gspzb22(String), gspzb22(String)
2024-12-16 17:49:54,885 [http-nio-1918-exec-2] <== Total: 4
2024-12-16 17:49:54,887 [http-nio-1918-exec-2] ==> Preparing: SELECT a.pro_name as proName, concat('SongBianDianProject',SUBSTRING_INDEX( SUBSTRING_INDEX( a.bid_pro_id, ',', b.help_topic_id + 1 ), ',',- 1 )) bidProId, SUBSTRING_INDEX( SUBSTRING_INDEX( a.is_multiple, ',', b.help_topic_id + 1 ), ',',- 1 ) isMultiple FROM bm_project_bid_relation a JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.bid_pro_id ) - LENGTH( REPLACE ( a.bid_pro_id, ',', '' ) ) + 1 ) WHERE a.is_active = 1 and a.bid_pro_id like CONCAT('%',?,'%')
2024-12-16 17:49:54,888 [http-nio-1918-exec-2] ==> Parameters: 10042(String)
2024-12-16 17:49:54,908 [http-nio-1918-exec-2] <== Total: 0
2024-12-16 17:53:15,398 [http-nio-1918-exec-3] 进入preventRepeatSubmit切面
2024-12-16 17:53:15,399 [http-nio-1918-exec-3] 防重复提交的请求地址：/gzrbmw/uploadPayroll/uploadPayrollPersonPush ,请求方式：POST
2024-12-16 17:53:15,399 [http-nio-1918-exec-3] 防重复提交拦截到的类名：UploadPayrollController ,方法：uploadPayrollPersonPush
2024-12-16 17:53:15,400 [http-nio-1918-exec-3] 获取到preventRepeatSubmit的有效期时间3
2024-12-16 17:53:15,434 [http-nio-1918-exec-3] ==> Preparing: SELECT bwpsi.`name`, bwpsi.idCard, bwph.id_number FROM bm_worker_provide_salary_info bwpsi LEFT JOIN bm_worker_push_history bwph ON bwph.pro_id = bwpsi.pro_id and bwph.id_number = bwpsi.idCard and bwph.is_active = '1' left join bm_worker_record bwr on bwr.ID_NUMBER = bwpsi.idCard WHERE bwpsi.submitBatchNo = ? and if((bwr.ein_status = 0 and bwr.is_ein_push = 1), true, bwr.PROJECT_ID != bwpsi.pro_id) GROUP BY bwpsi.idCard
2024-12-16 17:53:15,435 [http-nio-1918-exec-3] ==> Parameters: gspzb22(String)
2024-12-16 17:53:15,537 [http-nio-1918-exec-3] <== Total: 0
2024-12-16 17:53:15,538 [http-nio-1918-exec-3] ==> Preparing: SELECT 'true' AS submitApply, concat( 'SongBianDianProject', IFNULL( p.pro_old_id, p.id ) ) AS projectId, p.NAME AS projectName, concat( 'SongBianDianTeam', bst.id ) AS teamId, bst.NAME AS teamName, '贵州送变电有限责任公司' AS orgName, '9152000021440270X9' AS orgCreditCode, '银行卡' as payRollBankCardType, bwps.*, sdd.NAME AS bank, p.account_name AS accountName, p.open_bank_number AS accountNo, p.bank_name AS bankName, bwp.bankAffiliated, IF ( bwah.EXIT_TIME IS NOT NULL, '否', '是' ) AS whetherOnJob, IF ( bwah.EXIT_TIME IS NOT NULL, IFNULL( CONCAT( 'http://116.63.142.171:1919/gzrnama/', bwah.departureAffirmUrl ), 'http://npm.org/123.jpg' ), '' ) AS departureAffirmUrl FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bwps.idCard LEFT JOIN bm_worker_attend_history bwah ON bwr.ID_NUMBER = bwah.ID_NUMBER and bwr.PROJECT_ID = bwah.PROJECT_ID LEFT JOIN bm_project p ON p.id = bwps.pro_id or p.pro_old_id = bwps.pro_id LEFT JOIN sys_dic_detail sdd ON sdd.id = p.bank_account LEFT JOIN bm_worker_payroll bwp ON bwp.ID_NUMBER = bwps.idCard AND bwp.IS_ACTIVE = 1 LEFT JOIN ( SELECT * FROM ( SELECT bwph.ID_NUMBER, bwph.TEAM_ID FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_push_history bwph ON bwph.ID_NUMBER = bwps.idCard AND bwph.pro_id = bwph.pro_id AND bwph.is_active = 1 WHERE bwps.submitBatchNo = ? ORDER BY bwph.create_time DESC LIMIT 100000000000 ) a GROUP BY a.ID_NUMBER ) a ON a.ID_NUMBER = bwps.idCard LEFT JOIN bm_sub_team bst ON bst.id = bwr.TEAM_ID WHERE bwr.ID_NUMBER IS NOT NULL AND bwps.submitBatchNo IS NOT NULL AND bwps.is_push != 1 AND bwps.submitBatchNo = ? and departureAffirmUrl is null
2024-12-16 17:53:15,539 [http-nio-1918-exec-3] ==> Parameters: gspzb22(String), gspzb22(String)
2024-12-16 17:53:15,613 [http-nio-1918-exec-3] <== Total: 4
2024-12-16 17:53:15,614 [http-nio-1918-exec-3] ==> Preparing: SELECT a.pro_name as proName, concat('SongBianDianProject',SUBSTRING_INDEX( SUBSTRING_INDEX( a.bid_pro_id, ',', b.help_topic_id + 1 ), ',',- 1 )) bidProId, SUBSTRING_INDEX( SUBSTRING_INDEX( a.is_multiple, ',', b.help_topic_id + 1 ), ',',- 1 ) isMultiple FROM bm_project_bid_relation a JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.bid_pro_id ) - LENGTH( REPLACE ( a.bid_pro_id, ',', '' ) ) + 1 ) WHERE a.is_active = 1 and a.bid_pro_id like CONCAT('%',?,'%')
2024-12-16 17:53:15,616 [http-nio-1918-exec-3] ==> Parameters: 10042(String)
2024-12-16 17:53:15,639 [http-nio-1918-exec-3] <== Total: 0
2024-12-16 17:55:24,401 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 17:55:24,403 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 17:55:24(String), gspzb22(String)
2024-12-16 17:55:24,441 [http-nio-1918-exec-2] <== Updates: 4
2024-12-16 17:55:24,441 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 17:55:24,443 [http-nio-1918-exec-2] ==> Parameters: 2(String), gspzb22(String)
2024-12-16 17:55:24,494 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 17:55:24,498 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 17:55:24,501 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 17:55:24(String), gspzb22(String)
2024-12-16 17:55:24,541 [http-nio-1918-exec-2] <== Updates: 4
2024-12-16 17:55:24,545 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 17:55:24,546 [http-nio-1918-exec-2] ==> Parameters: 2(String), gspzb22(String)
2024-12-16 17:55:24,584 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 17:55:24,586 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 17:55:24,587 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 17:55:24(String), gspzb22(String)
2024-12-16 17:55:24,626 [http-nio-1918-exec-2] <== Updates: 4
2024-12-16 17:55:24,627 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 17:55:24,628 [http-nio-1918-exec-2] ==> Parameters: 2(String), gspzb22(String)
2024-12-16 17:55:24,667 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 17:55:24,669 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 17:55:24,669 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 17:55:24(String), gspzb22(String)
2024-12-16 17:55:24,712 [http-nio-1918-exec-2] <== Updates: 4
2024-12-16 17:55:24,713 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 17:55:24,714 [http-nio-1918-exec-2] ==> Parameters: 2(String), gspzb22(String)
2024-12-16 17:55:24,753 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 17:55:24,755 [taskExecutor-4] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2024-12-16 17:55:24,759 [taskExecutor-4] ==> Parameters: 249(Long), 推送工资册(String), true(Boolean), {"submitBatchNo":"gspzb22","uploadType":"0"}(String)
2024-12-16 17:55:24,823 [taskExecutor-4] <== Updates: 1
2024-12-16 17:55:34,186 [http-nio-1918-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:55:34,186 [http-nio-1918-exec-1] ==> Parameters: null
2024-12-16 17:55:34,206 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 17:55:34,207 [http-nio-1918-exec-1] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2024-12-16 17:55:34,207 [http-nio-1918-exec-1] ==> Parameters:
2024-12-16 17:55:34,230 [http-nio-1918-exec-1] <== Total: 19
2024-12-16 17:55:34,239 [http-nio-1918-exec-8] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:55:34,239 [http-nio-1918-exec-8] ==> Parameters: null
2024-12-16 17:55:34,264 [http-nio-1918-exec-8] <== Total: 0
2024-12-16 17:55:34,267 [http-nio-1918-exec-8] ==> Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2024-12-16 17:55:34,267 [http-nio-1918-exec-8] ==> Parameters:
2024-12-16 17:55:34,340 [http-nio-1918-exec-8] <== Total: 302
2024-12-16 17:55:34,553 [http-nio-1918-exec-7] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:55:34,554 [http-nio-1918-exec-7] ==> Parameters: null
2024-12-16 17:55:34,573 [http-nio-1918-exec-7] <== Total: 0
2024-12-16 17:55:34,574 [http-nio-1918-exec-7] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 17:55:34,575 [http-nio-1918-exec-7] ==> Parameters: 0(String)
2024-12-16 17:55:34,622 [http-nio-1918-exec-7] <== Total: 1
2024-12-16 17:55:34,623 [http-nio-1918-exec-7] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 17:55:34,623 [http-nio-1918-exec-7] ==> Parameters: null
2024-12-16 17:55:34,642 [http-nio-1918-exec-7] <== Total: 0
2024-12-16 17:55:34,643 [http-nio-1918-exec-7] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 17:55:34,644 [http-nio-1918-exec-7] ==> Parameters: 0(String), 0(Integer), 10(Integer)
2024-12-16 17:55:34,738 [http-nio-1918-exec-7] <== Total: 10
2024-12-16 17:55:45,455 [http-nio-1918-exec-3] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 17:55:45,456 [http-nio-1918-exec-3] ==> Parameters: 2(String), 2024-12-16 17:55:45(String), gspzb22(String)
2024-12-16 17:55:45,499 [http-nio-1918-exec-3] <== Updates: 4
2024-12-16 17:55:45,500 [http-nio-1918-exec-3] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 17:55:45,500 [http-nio-1918-exec-3] ==> Parameters: 2(String), gspzb22(String)
2024-12-16 17:55:45,538 [http-nio-1918-exec-3] <== Updates: 1
2024-12-16 17:55:45,539 [http-nio-1918-exec-3] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 17:55:45,539 [http-nio-1918-exec-3] ==> Parameters: 2(String), 2024-12-16 17:55:45(String), gspzb22(String)
2024-12-16 17:55:45,584 [http-nio-1918-exec-3] <== Updates: 4
2024-12-16 17:55:45,584 [http-nio-1918-exec-3] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 17:55:45,585 [http-nio-1918-exec-3] ==> Parameters: 2(String), gspzb22(String)
2024-12-16 17:55:45,623 [http-nio-1918-exec-3] <== Updates: 1
2024-12-16 17:55:45,625 [http-nio-1918-exec-3] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 17:55:45,628 [http-nio-1918-exec-3] ==> Parameters: 2(String), 2024-12-16 17:55:45(String), gspzb22(String)
2024-12-16 17:55:45,669 [http-nio-1918-exec-3] <== Updates: 4
2024-12-16 17:55:45,671 [http-nio-1918-exec-3] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 17:55:45,671 [http-nio-1918-exec-3] ==> Parameters: 2(String), gspzb22(String)
2024-12-16 17:55:45,713 [http-nio-1918-exec-3] <== Updates: 1
2024-12-16 17:55:45,715 [http-nio-1918-exec-3] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 17:55:45,716 [http-nio-1918-exec-3] ==> Parameters: 2(String), 2024-12-16 17:55:45(String), gspzb22(String)
2024-12-16 17:55:45,772 [http-nio-1918-exec-3] <== Updates: 4
2024-12-16 17:55:45,774 [http-nio-1918-exec-3] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 17:55:45,774 [http-nio-1918-exec-3] ==> Parameters: 2(String), gspzb22(String)
2024-12-16 17:55:45,816 [http-nio-1918-exec-3] <== Updates: 1
2024-12-16 17:55:45,817 [taskExecutor-5] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2024-12-16 17:55:45,818 [taskExecutor-5] ==> Parameters: 249(Long), 推送工资册(String), true(Boolean), {"submitBatchNo":"gspzb22","uploadType":"0"}(String)
2024-12-16 17:55:45,863 [taskExecutor-5] <== Updates: 1
2024-12-16 17:57:11,125 [http-nio-1918-exec-1] 进入preventRepeatSubmit切面
2024-12-16 17:57:11,125 [http-nio-1918-exec-1] 防重复提交的请求地址：/gzrbmw/uploadPayroll/uploadPayrollPersonPush ,请求方式：POST
2024-12-16 17:57:11,125 [http-nio-1918-exec-1] 防重复提交拦截到的类名：UploadPayrollController ,方法：uploadPayrollPersonPush
2024-12-16 17:57:11,126 [http-nio-1918-exec-1] 获取到preventRepeatSubmit的有效期时间3
2024-12-16 17:57:11,153 [http-nio-1918-exec-1] ==> Preparing: SELECT bwpsi.`name`, bwpsi.idCard, bwph.id_number FROM bm_worker_provide_salary_info bwpsi LEFT JOIN bm_worker_push_history bwph ON bwph.pro_id = bwpsi.pro_id and bwph.id_number = bwpsi.idCard and bwph.is_active = '1' left join bm_worker_record bwr on bwr.ID_NUMBER = bwpsi.idCard WHERE bwpsi.submitBatchNo = ? and if((bwr.ein_status = 0 and bwr.is_ein_push = 1), true, bwr.PROJECT_ID != bwpsi.pro_id) GROUP BY bwpsi.idCard
2024-12-16 17:57:11,153 [http-nio-1918-exec-1] ==> Parameters: gspzb22(String)
2024-12-16 17:57:11,224 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 17:57:11,226 [http-nio-1918-exec-1] ==> Preparing: SELECT 'true' AS submitApply, concat( 'SongBianDianProject', IFNULL( p.pro_old_id, p.id ) ) AS projectId, p.NAME AS projectName, concat( 'SongBianDianTeam', bst.id ) AS teamId, bst.NAME AS teamName, '贵州送变电有限责任公司' AS orgName, '9152000021440270X9' AS orgCreditCode, '银行卡' as payRollBankCardType, bwps.*, sdd.NAME AS bank, p.account_name AS accountName, p.open_bank_number AS accountNo, p.bank_name AS bankName, bwp.bankAffiliated, IF ( bwah.EXIT_TIME IS NOT NULL, '否', '是' ) AS whetherOnJob, IF ( bwah.EXIT_TIME IS NOT NULL, IFNULL( CONCAT( 'http://116.63.142.171:1919/gzrnama/', bwah.departureAffirmUrl ), 'http://npm.org/123.jpg' ), '' ) AS departureAffirmUrl FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bwps.idCard LEFT JOIN bm_worker_attend_history bwah ON bwr.ID_NUMBER = bwah.ID_NUMBER and bwr.PROJECT_ID = bwah.PROJECT_ID LEFT JOIN bm_project p ON p.id = bwps.pro_id or p.pro_old_id = bwps.pro_id LEFT JOIN sys_dic_detail sdd ON sdd.id = p.bank_account LEFT JOIN bm_worker_payroll bwp ON bwp.ID_NUMBER = bwps.idCard AND bwp.IS_ACTIVE = 1 LEFT JOIN ( SELECT * FROM ( SELECT bwph.ID_NUMBER, bwph.TEAM_ID FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_push_history bwph ON bwph.ID_NUMBER = bwps.idCard AND bwph.pro_id = bwph.pro_id AND bwph.is_active = 1 WHERE bwps.submitBatchNo = ? ORDER BY bwph.create_time DESC LIMIT 100000000000 ) a GROUP BY a.ID_NUMBER ) a ON a.ID_NUMBER = bwps.idCard LEFT JOIN bm_sub_team bst ON bst.id = bwr.TEAM_ID WHERE bwr.ID_NUMBER IS NOT NULL AND bwps.submitBatchNo IS NOT NULL AND bwps.is_push != 1 AND bwps.submitBatchNo = ? and departureAffirmUrl is null
2024-12-16 17:57:11,227 [http-nio-1918-exec-1] ==> Parameters: gspzb22(String), gspzb22(String)
2024-12-16 17:57:11,296 [http-nio-1918-exec-1] <== Total: 4
2024-12-16 17:57:11,298 [http-nio-1918-exec-1] ==> Preparing: SELECT a.pro_name as proName, concat('SongBianDianProject',SUBSTRING_INDEX( SUBSTRING_INDEX( a.bid_pro_id, ',', b.help_topic_id + 1 ), ',',- 1 )) bidProId, SUBSTRING_INDEX( SUBSTRING_INDEX( a.is_multiple, ',', b.help_topic_id + 1 ), ',',- 1 ) isMultiple FROM bm_project_bid_relation a JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.bid_pro_id ) - LENGTH( REPLACE ( a.bid_pro_id, ',', '' ) ) + 1 ) WHERE a.is_active = 1 and a.bid_pro_id like CONCAT('%',?,'%')
2024-12-16 17:57:11,299 [http-nio-1918-exec-1] ==> Parameters: 10042(String)
2024-12-16 17:57:11,317 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 17:58:48,163 [SpringContextShutdownHook] SSHConnectionListener destroyed ... !
2024-12-16 17:59:01,591 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 14884 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
2024-12-16 17:59:01,593 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2024-12-16 17:59:01,594 [main] No active profile set, falling back to default profiles: default
2024-12-16 17:59:05,210 [main] SSHConnectionListener initialized ... !
2024-12-16 17:59:05,213 [main] Filter 'tokenFilter' configured for use
2024-12-16 17:59:08,339 [main] Started SecurityApplication in 7.355 seconds (JVM running for 9.571)
2024-12-16 17:59:08,345 [taskExecutor-3] --------红名单定时器启动------
2024-12-16 17:59:08,346 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2024-12-16 17:59:08,348 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2024-12-16 17:59:08,686 [taskExecutor-2] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = 1 and bnst.examine_status = '4'
2024-12-16 17:59:08,718 [taskExecutor-2] ==> Parameters:
2024-12-16 17:59:08,775 [taskExecutor-2] <== Total: 1
2024-12-16 17:59:08,776 [taskExecutor-3] ==> Preparing: SELECT a.id_number AS `key`, a.pro_id AS `value` FROM ( SELECT bwg.id_number, bwg.pro_id, bwg.org_id, COUNT( id_number ) AS likeData, IFNULL( brs.red_num, '100' ) AS num FROM bm_worker_give bwg LEFT JOIN pm_organization po on po.id = bwg.org_id LEFT JOIN pm_company pc on pc.id = po.COMPANY_ID LEFT JOIN bm_redlist_set brs ON brs.org_id = pc.id WHERE bwg.IS_ACTIVE = '1' GROUP BY bwg.id_number, bwg.pro_id HAVING COUNT( id_number ) >= num ) a LEFT JOIN bm_redlist_worker brw ON brw.ID_NUMBER = a.id_number -- AND brw.pro_id = a.pro_id WHERE brw.ID_NUMBER IS NULL
2024-12-16 17:59:08,776 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2024-12-16 17:59:08,776 [taskExecutor-3] ==> Parameters:
2024-12-16 17:59:08,814 [taskExecutor-3] <== Total: 0
2024-12-16 17:59:08,815 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
2024-12-16 17:59:08,815 [taskExecutor-1] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = '1' and bnst.examine_status = '1'
2024-12-16 17:59:08,815 [taskExecutor-1] ==> Parameters:
2024-12-16 17:59:08,850 [taskExecutor-1] <== Total: 1
2024-12-16 17:59:08,850 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2024-12-16 17:59:17,105 [http-nio-1918-exec-1] 进入preventRepeatSubmit切面
2024-12-16 17:59:17,105 [http-nio-1918-exec-1] 防重复提交的请求地址：/gzrbmw/uploadPayroll/uploadPayrollPersonPush ,请求方式：POST
2024-12-16 17:59:17,108 [http-nio-1918-exec-1] 防重复提交拦截到的类名：UploadPayrollController ,方法：uploadPayrollPersonPush
2024-12-16 17:59:17,181 [http-nio-1918-exec-1] 获取到preventRepeatSubmit的有效期时间3
2024-12-16 17:59:17,211 [http-nio-1918-exec-1] ==> Preparing: SELECT bwpsi.`name`, bwpsi.idCard, bwph.id_number FROM bm_worker_provide_salary_info bwpsi LEFT JOIN bm_worker_push_history bwph ON bwph.pro_id = bwpsi.pro_id and bwph.id_number = bwpsi.idCard and bwph.is_active = '1' left join bm_worker_record bwr on bwr.ID_NUMBER = bwpsi.idCard WHERE bwpsi.submitBatchNo = ? and if((bwr.ein_status = 0 and bwr.is_ein_push = 1), true, bwr.PROJECT_ID != bwpsi.pro_id) GROUP BY bwpsi.idCard
2024-12-16 17:59:17,213 [http-nio-1918-exec-1] ==> Parameters: gspzb22(String)
2024-12-16 17:59:17,278 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 17:59:17,280 [http-nio-1918-exec-1] ==> Preparing: SELECT 'true' AS submitApply, concat( 'SongBianDianProject', IFNULL( p.pro_old_id, p.id ) ) AS projectId, p.NAME AS projectName, concat( 'SongBianDianTeam', bst.id ) AS teamId, bst.NAME AS teamName, '贵州送变电有限责任公司' AS orgName, '9152000021440270X9' AS orgCreditCode, '银行卡' as payRollBankCardType, bwps.*, sdd.NAME AS bank, p.account_name AS accountName, p.open_bank_number AS accountNo, p.bank_name AS bankName, bwp.bankAffiliated, IF ( bwah.EXIT_TIME IS NOT NULL, '否', '是' ) AS whetherOnJob, IF ( bwah.EXIT_TIME IS NOT NULL, IFNULL( CONCAT( 'http://116.63.142.171:1919/gzrnama/', bwah.departureAffirmUrl ), 'http://npm.org/123.jpg' ), '' ) AS departureAffirmUrl FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bwps.idCard LEFT JOIN bm_worker_attend_history bwah ON bwr.ID_NUMBER = bwah.ID_NUMBER and bwr.PROJECT_ID = bwah.PROJECT_ID LEFT JOIN bm_project p ON p.id = bwps.pro_id or p.pro_old_id = bwps.pro_id LEFT JOIN sys_dic_detail sdd ON sdd.id = p.bank_account LEFT JOIN bm_worker_payroll bwp ON bwp.ID_NUMBER = bwps.idCard AND bwp.IS_ACTIVE = 1 LEFT JOIN ( SELECT * FROM ( SELECT bwph.ID_NUMBER, bwph.TEAM_ID FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_push_history bwph ON bwph.ID_NUMBER = bwps.idCard AND bwph.pro_id = bwph.pro_id AND bwph.is_active = 1 WHERE bwps.submitBatchNo = ? ORDER BY bwph.create_time DESC LIMIT 100000000000 ) a GROUP BY a.ID_NUMBER ) a ON a.ID_NUMBER = bwps.idCard LEFT JOIN bm_sub_team bst ON bst.id = bwr.TEAM_ID WHERE bwr.ID_NUMBER IS NOT NULL AND bwps.submitBatchNo IS NOT NULL AND bwps.is_push != 1 AND bwps.submitBatchNo = ? and departureAffirmUrl is null
2024-12-16 17:59:17,281 [http-nio-1918-exec-1] ==> Parameters: gspzb22(String), gspzb22(String)
2024-12-16 17:59:17,347 [http-nio-1918-exec-1] <== Total: 4
2024-12-16 17:59:17,349 [http-nio-1918-exec-1] ==> Preparing: SELECT a.pro_name as proName, concat('SongBianDianProject',SUBSTRING_INDEX( SUBSTRING_INDEX( a.bid_pro_id, ',', b.help_topic_id + 1 ), ',',- 1 )) bidProId, SUBSTRING_INDEX( SUBSTRING_INDEX( a.is_multiple, ',', b.help_topic_id + 1 ), ',',- 1 ) isMultiple FROM bm_project_bid_relation a JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.bid_pro_id ) - LENGTH( REPLACE ( a.bid_pro_id, ',', '' ) ) + 1 ) WHERE a.is_active = 1 and a.bid_pro_id like CONCAT('%',?,'%')
2024-12-16 17:59:17,350 [http-nio-1918-exec-1] ==> Parameters: 10042(String)
2024-12-16 17:59:17,369 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 18:03:35,898 [taskExecutor-4] --------考勤自动审核定时器启动------
2024-12-16 18:08:15,488 [SpringContextShutdownHook] SSHConnectionListener destroyed ... !
2024-12-16 20:38:15,581 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 2544 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
2024-12-16 20:38:15,584 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2024-12-16 20:38:15,584 [main] No active profile set, falling back to default profiles: default
2024-12-16 20:38:40,886 [main] SSHConnectionListener create connection failed ... !
2024-12-16 20:38:40,898 [main] Filter 'tokenFilter' configured for use
2024-12-16 20:38:43,392 [main] Started SecurityApplication in 28.402 seconds (JVM running for 30.673)
2024-12-16 20:38:43,395 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2024-12-16 20:38:43,395 [taskExecutor-3] --------红名单定时器启动------
2024-12-16 20:38:43,395 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2024-12-16 20:39:19,566 [SpringContextShutdownHook] SSHConnectionListener disconnect failed ... !
2024-12-16 20:39:24,218 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 24240 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
2024-12-16 20:39:24,221 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2024-12-16 20:39:24,222 [main] No active profile set, falling back to default profiles: default
2024-12-16 20:39:27,541 [main] SSHConnectionListener initialized ... !
2024-12-16 20:39:27,544 [main] Filter 'tokenFilter' configured for use
2024-12-16 20:39:29,722 [main] Started SecurityApplication in 5.977 seconds (JVM running for 7.88)
2024-12-16 20:39:29,726 [taskExecutor-3] --------红名单定时器启动------
2024-12-16 20:39:29,726 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2024-12-16 20:39:29,726 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2024-12-16 20:39:30,038 [taskExecutor-2] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = 1 and bnst.examine_status = '4'
2024-12-16 20:39:30,069 [taskExecutor-2] ==> Parameters:
2024-12-16 20:39:30,142 [taskExecutor-2] <== Total: 1
2024-12-16 20:39:30,144 [taskExecutor-1] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = '1' and bnst.examine_status = '1'
2024-12-16 20:39:30,144 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2024-12-16 20:39:30,145 [taskExecutor-1] ==> Parameters:
2024-12-16 20:39:30,167 [taskExecutor-1] <== Total: 1
2024-12-16 20:39:30,168 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2024-12-16 20:39:30,168 [taskExecutor-3] ==> Preparing: SELECT a.id_number AS `key`, a.pro_id AS `value` FROM ( SELECT bwg.id_number, bwg.pro_id, bwg.org_id, COUNT( id_number ) AS likeData, IFNULL( brs.red_num, '100' ) AS num FROM bm_worker_give bwg LEFT JOIN pm_organization po on po.id = bwg.org_id LEFT JOIN pm_company pc on pc.id = po.COMPANY_ID LEFT JOIN bm_redlist_set brs ON brs.org_id = pc.id WHERE bwg.IS_ACTIVE = '1' GROUP BY bwg.id_number, bwg.pro_id HAVING COUNT( id_number ) >= num ) a LEFT JOIN bm_redlist_worker brw ON brw.ID_NUMBER = a.id_number -- AND brw.pro_id = a.pro_id WHERE brw.ID_NUMBER IS NULL
2024-12-16 20:39:30,168 [taskExecutor-3] ==> Parameters:
2024-12-16 20:39:30,207 [taskExecutor-3] <== Total: 0
2024-12-16 20:39:30,207 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
2024-12-16 20:41:36,310 [http-nio-1918-exec-4] 验证码：BCFM用户输入：BCFM
2024-12-16 20:41:36,603 [http-nio-1918-exec-4] ==> Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2024-12-16 20:41:36,604 [http-nio-1918-exec-4] ==> Parameters: bnsAdmin(String)
2024-12-16 20:41:36,631 [http-nio-1918-exec-4] <== Total: 1
2024-12-16 20:41:36,638 [http-nio-1918-exec-4] ==> Preparing: select distinct p.* from sys_permission p inner join sys_role_permission rp on p.id = rp.permissionId inner join sys_role_user ru on ru.roleId = rp.roleId where ru.userId = ? and p.is_active = '1' order by p.sort
2024-12-16 20:41:36,639 [http-nio-1918-exec-4] ==> Parameters: 249(Long)
2024-12-16 20:41:36,692 [http-nio-1918-exec-4] <== Total: 156
2024-12-16 20:41:36,765 [http-nio-1918-exec-4] Authenticated user
2024-12-16 20:41:36,780 [taskExecutor-4] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2024-12-16 20:41:36,783 [taskExecutor-4] ==> Parameters: 249(Long), 登陆(String), true(Boolean), null
2024-12-16 20:41:36,823 [taskExecutor-4] <== Updates: 1
2024-12-16 20:41:45,475 [http-nio-1918-exec-9] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:41:45,475 [http-nio-1918-exec-9] ==> Parameters: null
2024-12-16 20:41:45,501 [http-nio-1918-exec-9] <== Total: 0
2024-12-16 20:41:45,513 [http-nio-1918-exec-9] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2024-12-16 20:41:45,514 [http-nio-1918-exec-9] ==> Parameters:
2024-12-16 20:41:45,544 [http-nio-1918-exec-9] <== Total: 19
2024-12-16 20:41:45,554 [http-nio-1918-exec-7] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:41:45,555 [http-nio-1918-exec-7] ==> Parameters: null
2024-12-16 20:41:45,574 [http-nio-1918-exec-7] <== Total: 0
2024-12-16 20:41:45,575 [http-nio-1918-exec-7] ==> Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2024-12-16 20:41:45,575 [http-nio-1918-exec-7] ==> Parameters:
2024-12-16 20:41:45,642 [http-nio-1918-exec-7] <== Total: 302
2024-12-16 20:41:45,753 [http-nio-1918-exec-8] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:41:45,753 [http-nio-1918-exec-8] ==> Parameters: null
2024-12-16 20:41:45,777 [http-nio-1918-exec-8] <== Total: 0
2024-12-16 20:41:45,784 [http-nio-1918-exec-8] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 20:41:45,784 [http-nio-1918-exec-8] ==> Parameters: 0(String)
2024-12-16 20:41:45,828 [http-nio-1918-exec-8] <== Total: 1
2024-12-16 20:41:45,830 [http-nio-1918-exec-8] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:41:45,831 [http-nio-1918-exec-8] ==> Parameters: null
2024-12-16 20:41:45,864 [http-nio-1918-exec-8] <== Total: 0
2024-12-16 20:41:45,867 [http-nio-1918-exec-8] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 20:41:45,872 [http-nio-1918-exec-8] ==> Parameters: 0(String), 0(Integer), 10(Integer)
2024-12-16 20:41:45,936 [http-nio-1918-exec-8] <== Total: 10
2024-12-16 20:41:57,533 [http-nio-1918-exec-10] 进入preventRepeatSubmit切面
2024-12-16 20:41:57,533 [http-nio-1918-exec-10] 防重复提交的请求地址：/gzrbmw/uploadPayroll/uploadPayrollPersonPush ,请求方式：POST
2024-12-16 20:41:57,535 [http-nio-1918-exec-10] 防重复提交拦截到的类名：UploadPayrollController ,方法：uploadPayrollPersonPush
2024-12-16 20:41:57,538 [http-nio-1918-exec-10] 获取到preventRepeatSubmit的有效期时间3
2024-12-16 20:41:57,543 [http-nio-1918-exec-10] ==> Preparing: SELECT bwpsi.`name`, bwpsi.idCard, bwph.id_number FROM bm_worker_provide_salary_info bwpsi LEFT JOIN bm_worker_push_history bwph ON bwph.pro_id = bwpsi.pro_id and bwph.id_number = bwpsi.idCard and bwph.is_active = '1' left join bm_worker_record bwr on bwr.ID_NUMBER = bwpsi.idCard WHERE bwpsi.submitBatchNo = ? and if((bwr.ein_status = 0 and bwr.is_ein_push = 1), true, bwr.PROJECT_ID != bwpsi.pro_id) GROUP BY bwpsi.idCard
2024-12-16 20:41:57,544 [http-nio-1918-exec-10] ==> Parameters: gsgyzr77(String)
2024-12-16 20:41:57,614 [http-nio-1918-exec-10] <== Total: 0
2024-12-16 20:41:57,621 [http-nio-1918-exec-10] ==> Preparing: SELECT 'true' AS submitApply, concat( 'SongBianDianProject', IFNULL( p.pro_old_id, p.id ) ) AS projectId, p.NAME AS projectName, concat( 'SongBianDianTeam', bst.id ) AS teamId, bst.NAME AS teamName, '贵州送变电有限责任公司' AS orgName, '9152000021440270X9' AS orgCreditCode, '银行卡' as payRollBankCardType, bwps.*, sdd.NAME AS bank, p.account_name AS accountName, p.open_bank_number AS accountNo, p.bank_name AS bankName, bwp.bankAffiliated, IF ( bwah.EXIT_TIME IS NOT NULL, '否', '是' ) AS whetherOnJob, IF ( bwah.EXIT_TIME IS NOT NULL, IFNULL( CONCAT( 'http://116.63.142.171:1919/gzrnama/', bwah.departureAffirmUrl ), 'http://npm.org/123.jpg' ), '' ) AS departureAffirmUrl FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bwps.idCard LEFT JOIN bm_worker_attend_history bwah ON bwr.ID_NUMBER = bwah.ID_NUMBER and bwr.PROJECT_ID = bwah.PROJECT_ID LEFT JOIN bm_project p ON p.id = bwps.pro_id or p.pro_old_id = bwps.pro_id LEFT JOIN sys_dic_detail sdd ON sdd.id = p.bank_account LEFT JOIN bm_worker_payroll bwp ON bwp.ID_NUMBER = bwps.idCard AND bwp.IS_ACTIVE = 1 LEFT JOIN ( SELECT * FROM ( SELECT bwph.ID_NUMBER, bwph.TEAM_ID FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_push_history bwph ON bwph.ID_NUMBER = bwps.idCard AND bwph.pro_id = bwph.pro_id AND bwph.is_active = 1 WHERE bwps.submitBatchNo = ? ORDER BY bwph.create_time DESC LIMIT 100000000000 ) a GROUP BY a.ID_NUMBER ) a ON a.ID_NUMBER = bwps.idCard LEFT JOIN bm_sub_team bst ON bst.id = bwr.TEAM_ID WHERE bwr.ID_NUMBER IS NOT NULL AND bwps.submitBatchNo IS NOT NULL AND bwps.is_push != 1 AND bwps.submitBatchNo = ?
2024-12-16 20:41:57,627 [http-nio-1918-exec-10] ==> Parameters: gsgyzr77(String), gsgyzr77(String)
2024-12-16 20:41:57,697 [http-nio-1918-exec-10] <== Total: 4
2024-12-16 20:41:57,702 [http-nio-1918-exec-10] ==> Preparing: SELECT a.pro_name as proName, concat('SongBianDianProject',SUBSTRING_INDEX( SUBSTRING_INDEX( a.bid_pro_id, ',', b.help_topic_id + 1 ), ',',- 1 )) bidProId, SUBSTRING_INDEX( SUBSTRING_INDEX( a.is_multiple, ',', b.help_topic_id + 1 ), ',',- 1 ) isMultiple FROM bm_project_bid_relation a JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.bid_pro_id ) - LENGTH( REPLACE ( a.bid_pro_id, ',', '' ) ) + 1 ) WHERE a.is_active = 1 and a.bid_pro_id like CONCAT('%',?,'%')
2024-12-16 20:41:57,703 [http-nio-1918-exec-10] ==> Parameters: 10070(String)
2024-12-16 20:41:57,726 [http-nio-1918-exec-10] <== Total: 0
2024-12-16 20:42:19,077 [http-nio-1918-exec-10] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:42:19,077 [http-nio-1918-exec-10] ==> Parameters: 2(String), 2024-12-16 20:42:19(String), gsgyzr77(String)
2024-12-16 20:42:19,143 [http-nio-1918-exec-10] <== Updates: 4
2024-12-16 20:42:19,143 [http-nio-1918-exec-10] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:42:19,144 [http-nio-1918-exec-10] ==> Parameters: 2(String), gsgyzr77(String)
2024-12-16 20:42:19,191 [http-nio-1918-exec-10] <== Updates: 1
2024-12-16 20:42:19,192 [http-nio-1918-exec-10] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:42:19,193 [http-nio-1918-exec-10] ==> Parameters: 2(String), 2024-12-16 20:42:19(String), gsgyzr77(String)
2024-12-16 20:42:19,237 [http-nio-1918-exec-10] <== Updates: 4
2024-12-16 20:42:19,237 [http-nio-1918-exec-10] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:42:19,239 [http-nio-1918-exec-10] ==> Parameters: 2(String), gsgyzr77(String)
2024-12-16 20:42:19,275 [http-nio-1918-exec-10] <== Updates: 1
2024-12-16 20:42:19,276 [http-nio-1918-exec-10] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:42:19,276 [http-nio-1918-exec-10] ==> Parameters: 2(String), 2024-12-16 20:42:19(String), gsgyzr77(String)
2024-12-16 20:42:19,314 [http-nio-1918-exec-10] <== Updates: 4
2024-12-16 20:42:19,314 [http-nio-1918-exec-10] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:42:19,315 [http-nio-1918-exec-10] ==> Parameters: 2(String), gsgyzr77(String)
2024-12-16 20:42:19,362 [http-nio-1918-exec-10] <== Updates: 1
2024-12-16 20:42:19,363 [http-nio-1918-exec-10] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:42:19,365 [http-nio-1918-exec-10] ==> Parameters: 2(String), 2024-12-16 20:42:19(String), gsgyzr77(String)
2024-12-16 20:42:19,410 [http-nio-1918-exec-10] <== Updates: 4
2024-12-16 20:42:19,411 [http-nio-1918-exec-10] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:42:19,411 [http-nio-1918-exec-10] ==> Parameters: 2(String), gsgyzr77(String)
2024-12-16 20:42:19,453 [http-nio-1918-exec-10] <== Updates: 1
2024-12-16 20:42:19,453 [taskExecutor-5] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2024-12-16 20:42:19,454 [taskExecutor-5] ==> Parameters: 249(Long), 推送工资册(String), true(Boolean), {"submitBatchNo":"gsgyzr77","uploadType":"0"}(String)
2024-12-16 20:42:19,495 [taskExecutor-5] <== Updates: 1
2024-12-16 20:42:32,509 [http-nio-1918-exec-6] 验证码：3AHG用户输入：3AHG
2024-12-16 20:42:32,510 [http-nio-1918-exec-6] ==> Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2024-12-16 20:42:32,510 [http-nio-1918-exec-6] ==> Parameters: bnsAdmin(String)
2024-12-16 20:42:32,543 [http-nio-1918-exec-6] <== Total: 1
2024-12-16 20:42:32,544 [http-nio-1918-exec-6] ==> Preparing: select distinct p.* from sys_permission p inner join sys_role_permission rp on p.id = rp.permissionId inner join sys_role_user ru on ru.roleId = rp.roleId where ru.userId = ? and p.is_active = '1' order by p.sort
2024-12-16 20:42:32,545 [http-nio-1918-exec-6] ==> Parameters: 249(Long)
2024-12-16 20:42:32,608 [http-nio-1918-exec-6] <== Total: 156
2024-12-16 20:42:32,692 [http-nio-1918-exec-6] Authenticated user
2024-12-16 20:42:32,695 [taskExecutor-6] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2024-12-16 20:42:32,695 [taskExecutor-6] ==> Parameters: 249(Long), 登陆(String), true(Boolean), null
2024-12-16 20:42:32,736 [taskExecutor-6] <== Updates: 1
2024-12-16 20:42:39,244 [http-nio-1918-exec-4] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:42:39,245 [http-nio-1918-exec-4] ==> Parameters: null
2024-12-16 20:42:39,286 [http-nio-1918-exec-4] <== Total: 0
2024-12-16 20:42:39,287 [http-nio-1918-exec-4] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2024-12-16 20:42:39,287 [http-nio-1918-exec-4] ==> Parameters:
2024-12-16 20:42:39,313 [http-nio-1918-exec-4] <== Total: 19
2024-12-16 20:42:39,320 [http-nio-1918-exec-7] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:42:39,320 [http-nio-1918-exec-7] ==> Parameters: null
2024-12-16 20:42:39,343 [http-nio-1918-exec-7] <== Total: 0
2024-12-16 20:42:39,344 [http-nio-1918-exec-7] ==> Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2024-12-16 20:42:39,344 [http-nio-1918-exec-7] ==> Parameters:
2024-12-16 20:42:39,439 [http-nio-1918-exec-7] <== Total: 302
2024-12-16 20:42:39,515 [http-nio-1918-exec-9] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:42:39,516 [http-nio-1918-exec-9] ==> Parameters: null
2024-12-16 20:42:39,535 [http-nio-1918-exec-9] <== Total: 0
2024-12-16 20:42:39,536 [http-nio-1918-exec-9] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 20:42:39,536 [http-nio-1918-exec-9] ==> Parameters: 0(String)
2024-12-16 20:42:39,589 [http-nio-1918-exec-9] <== Total: 1
2024-12-16 20:42:39,593 [http-nio-1918-exec-9] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:42:39,595 [http-nio-1918-exec-9] ==> Parameters: null
2024-12-16 20:42:39,624 [http-nio-1918-exec-9] <== Total: 0
2024-12-16 20:42:39,625 [http-nio-1918-exec-9] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 20:42:39,626 [http-nio-1918-exec-9] ==> Parameters: 0(String), 0(Integer), 10(Integer)
2024-12-16 20:42:39,710 [http-nio-1918-exec-9] <== Total: 10
2024-12-16 20:42:42,461 [http-nio-1918-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:42:42,461 [http-nio-1918-exec-1] ==> Parameters: null
2024-12-16 20:42:42,492 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 20:42:42,493 [http-nio-1918-exec-1] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 20:42:42,493 [http-nio-1918-exec-1] ==> Parameters: 0(String)
2024-12-16 20:42:42,534 [http-nio-1918-exec-1] <== Total: 1
2024-12-16 20:42:42,535 [http-nio-1918-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:42:42,535 [http-nio-1918-exec-1] ==> Parameters: null
2024-12-16 20:42:42,553 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 20:42:42,554 [http-nio-1918-exec-1] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 20:42:42,555 [http-nio-1918-exec-1] ==> Parameters: 0(String), 10(Integer), 10(Integer)
2024-12-16 20:42:42,625 [http-nio-1918-exec-1] <== Total: 10
2024-12-16 20:42:46,631 [http-nio-1918-exec-2] 进入preventRepeatSubmit切面
2024-12-16 20:42:46,631 [http-nio-1918-exec-2] 防重复提交的请求地址：/gzrbmw/uploadPayroll/uploadPayrollPersonPush ,请求方式：POST
2024-12-16 20:42:46,631 [http-nio-1918-exec-2] 防重复提交拦截到的类名：UploadPayrollController ,方法：uploadPayrollPersonPush
2024-12-16 20:42:46,631 [http-nio-1918-exec-2] 获取到preventRepeatSubmit的有效期时间3
2024-12-16 20:42:46,632 [http-nio-1918-exec-2] ==> Preparing: SELECT bwpsi.`name`, bwpsi.idCard, bwph.id_number FROM bm_worker_provide_salary_info bwpsi LEFT JOIN bm_worker_push_history bwph ON bwph.pro_id = bwpsi.pro_id and bwph.id_number = bwpsi.idCard and bwph.is_active = '1' left join bm_worker_record bwr on bwr.ID_NUMBER = bwpsi.idCard WHERE bwpsi.submitBatchNo = ? and if((bwr.ein_status = 0 and bwr.is_ein_push = 1), true, bwr.PROJECT_ID != bwpsi.pro_id) GROUP BY bwpsi.idCard
2024-12-16 20:42:46,633 [http-nio-1918-exec-2] ==> Parameters: paepc-61(String)
2024-12-16 20:42:47,064 [http-nio-1918-exec-2] <== Total: 0
2024-12-16 20:42:47,069 [http-nio-1918-exec-2] ==> Preparing: SELECT 'true' AS submitApply, concat( 'SongBianDianProject', IFNULL( p.pro_old_id, p.id ) ) AS projectId, p.NAME AS projectName, concat( 'SongBianDianTeam', bst.id ) AS teamId, bst.NAME AS teamName, '贵州送变电有限责任公司' AS orgName, '9152000021440270X9' AS orgCreditCode, '银行卡' as payRollBankCardType, bwps.*, sdd.NAME AS bank, p.account_name AS accountName, p.open_bank_number AS accountNo, p.bank_name AS bankName, bwp.bankAffiliated, IF ( bwah.EXIT_TIME IS NOT NULL, '否', '是' ) AS whetherOnJob, IF ( bwah.EXIT_TIME IS NOT NULL, IFNULL( CONCAT( 'http://116.63.142.171:1919/gzrnama/', bwah.departureAffirmUrl ), 'http://npm.org/123.jpg' ), '' ) AS departureAffirmUrl FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bwps.idCard LEFT JOIN bm_worker_attend_history bwah ON bwr.ID_NUMBER = bwah.ID_NUMBER and bwr.PROJECT_ID = bwah.PROJECT_ID LEFT JOIN bm_project p ON p.id = bwps.pro_id or p.pro_old_id = bwps.pro_id LEFT JOIN sys_dic_detail sdd ON sdd.id = p.bank_account LEFT JOIN bm_worker_payroll bwp ON bwp.ID_NUMBER = bwps.idCard AND bwp.IS_ACTIVE = 1 LEFT JOIN ( SELECT * FROM ( SELECT bwph.ID_NUMBER, bwph.TEAM_ID FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_push_history bwph ON bwph.ID_NUMBER = bwps.idCard AND bwph.pro_id = bwph.pro_id AND bwph.is_active = 1 WHERE bwps.submitBatchNo = ? ORDER BY bwph.create_time DESC LIMIT 100000000000 ) a GROUP BY a.ID_NUMBER ) a ON a.ID_NUMBER = bwps.idCard LEFT JOIN bm_sub_team bst ON bst.id = bwr.TEAM_ID WHERE bwr.ID_NUMBER IS NOT NULL AND bwps.submitBatchNo IS NOT NULL AND bwps.is_push != 1 AND bwps.submitBatchNo = ?
2024-12-16 20:42:47,071 [http-nio-1918-exec-2] ==> Parameters: paepc-61(String), paepc-61(String)
2024-12-16 20:42:47,475 [http-nio-1918-exec-2] <== Total: 55
2024-12-16 20:42:47,476 [http-nio-1918-exec-2] ==> Preparing: SELECT a.pro_name as proName, concat('SongBianDianProject',SUBSTRING_INDEX( SUBSTRING_INDEX( a.bid_pro_id, ',', b.help_topic_id + 1 ), ',',- 1 )) bidProId, SUBSTRING_INDEX( SUBSTRING_INDEX( a.is_multiple, ',', b.help_topic_id + 1 ), ',',- 1 ) isMultiple FROM bm_project_bid_relation a JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.bid_pro_id ) - LENGTH( REPLACE ( a.bid_pro_id, ',', '' ) ) + 1 ) WHERE a.is_active = 1 and a.bid_pro_id like CONCAT('%',?,'%')
2024-12-16 20:42:47,476 [http-nio-1918-exec-2] ==> Parameters: 10066(String)
2024-12-16 20:42:47,495 [http-nio-1918-exec-2] <== Total: 0
2024-12-16 20:43:08,568 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:08,569 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:08(String), paepc-61(String)
2024-12-16 20:43:08,612 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:08,614 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:08,615 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:08,659 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:08,662 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:08,663 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:08(String), paepc-61(String)
2024-12-16 20:43:08,704 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:08,705 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:08,705 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:08,746 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:08,747 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:08,748 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:08(String), paepc-61(String)
2024-12-16 20:43:08,790 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:08,791 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:08,792 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:08,833 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:08,834 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:08,834 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:08(String), paepc-61(String)
2024-12-16 20:43:08,874 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:08,875 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:08,876 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:08,930 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:08,930 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:08,931 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:08(String), paepc-61(String)
2024-12-16 20:43:08,973 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:08,974 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:08,975 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,015 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,016 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,017 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,059 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,060 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,061 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,104 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,105 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,106 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,146 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,147 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,147 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,187 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,188 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,189 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,229 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,229 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,230 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,269 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,270 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,270 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,312 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,313 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,314 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,355 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,356 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,356 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,396 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,397 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,397 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,439 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,444 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,446 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,490 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,491 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,492 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,531 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,534 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,535 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,580 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,581 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,582 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,629 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,633 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,634 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,672 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,673 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,673 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,725 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,725 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,726 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,772 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,772 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,773 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,811 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,812 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,813 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,852 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,854 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,856 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:09,908 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:09,908 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:09,909 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:09(String), paepc-61(String)
2024-12-16 20:43:09,954 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:09,955 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:09,955 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,023 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,024 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,024 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,069 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,070 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,070 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,117 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,119 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,120 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,169 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,170 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,170 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,209 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,209 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,210 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,251 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,252 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,253 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,297 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,299 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,300 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,363 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,364 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,364 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,407 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,408 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,409 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,448 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,448 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,448 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,496 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,497 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,497 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,536 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,536 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,537 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,575 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,576 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,576 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,615 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,616 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,616 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,672 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,673 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,674 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,712 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,712 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,712 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,750 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,751 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,751 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,793 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,794 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,796 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,837 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,838 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,838 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,884 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,886 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,887 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:10,929 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:10,929 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:10,931 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:10(String), paepc-61(String)
2024-12-16 20:43:10,969 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:10,970 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:10,971 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,011 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,011 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,012 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,058 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,058 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,058 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,098 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,099 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,099 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,140 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,141 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,142 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,182 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,183 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,183 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,224 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,224 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,225 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,266 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,267 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,267 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,310 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,311 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,312 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,351 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,351 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,352 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,393 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,394 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,394 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,439 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,440 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,440 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,486 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,486 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,487 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,534 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,535 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,536 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,579 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,580 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,580 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,618 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,618 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,618 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,658 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,658 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,658 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,701 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,703 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,705 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,751 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,752 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,752 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,802 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,802 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,803 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,841 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,842 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,843 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,880 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,881 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,883 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:11,922 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:11,923 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:11,925 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:11,966 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:11,968 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:11,970 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:11(String), paepc-61(String)
2024-12-16 20:43:12,013 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,016 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,018 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,060 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,060 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,061 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,103 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,103 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,104 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,144 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,145 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,145 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,190 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,192 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,194 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,237 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,237 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,237 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,296 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,297 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,297 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,338 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,339 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,339 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,385 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,386 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,386 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,432 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,432 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,433 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,479 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,479 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,480 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,527 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,527 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,528 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,585 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,586 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,588 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,629 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,629 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,630 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,669 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,670 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,670 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,709 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,710 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,711 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,750 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,751 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,751 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,805 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,806 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,807 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,858 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,858 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,858 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:12,925 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:12,925 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:12,926 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:12(String), paepc-61(String)
2024-12-16 20:43:12,971 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:12,972 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:12,973 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:13,014 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:13,015 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:13,015 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:13(String), paepc-61(String)
2024-12-16 20:43:13,054 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:13,054 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:13,054 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:13,097 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:13,098 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:13,098 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:13(String), paepc-61(String)
2024-12-16 20:43:13,143 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:13,144 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:13,144 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:13,188 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:13,189 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:13,189 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:13(String), paepc-61(String)
2024-12-16 20:43:13,236 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:13,237 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:13,237 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:13,282 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:13,283 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:13,283 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:13(String), paepc-61(String)
2024-12-16 20:43:13,328 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:13,328 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:13,329 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:13,375 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:13,376 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:13,376 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:13(String), paepc-61(String)
2024-12-16 20:43:13,434 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:13,435 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:13,435 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:13,489 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:13,489 [http-nio-1918-exec-2] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:43:13,490 [http-nio-1918-exec-2] ==> Parameters: 2(String), 2024-12-16 20:43:13(String), paepc-61(String)
2024-12-16 20:43:13,536 [http-nio-1918-exec-2] <== Updates: 55
2024-12-16 20:43:13,537 [http-nio-1918-exec-2] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:43:13,537 [http-nio-1918-exec-2] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:43:13,582 [http-nio-1918-exec-2] <== Updates: 1
2024-12-16 20:43:13,586 [taskExecutor-7] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2024-12-16 20:43:13,587 [taskExecutor-7] ==> Parameters: 249(Long), 推送工资册(String), true(Boolean), {"submitBatchNo":"paepc-61","uploadType":"0"}(String)
2024-12-16 20:43:13,627 [taskExecutor-7] <== Updates: 1
2024-12-16 20:43:15,245 [http-nio-1918-exec-4] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:43:15,246 [http-nio-1918-exec-4] ==> Parameters: null
2024-12-16 20:43:15,268 [http-nio-1918-exec-4] <== Total: 0
2024-12-16 20:43:15,268 [http-nio-1918-exec-4] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2024-12-16 20:43:15,269 [http-nio-1918-exec-4] ==> Parameters:
2024-12-16 20:43:15,291 [http-nio-1918-exec-4] <== Total: 19
2024-12-16 20:43:15,300 [http-nio-1918-exec-3] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:43:15,300 [http-nio-1918-exec-3] ==> Parameters: null
2024-12-16 20:43:15,322 [http-nio-1918-exec-3] <== Total: 0
2024-12-16 20:43:15,323 [http-nio-1918-exec-3] ==> Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2024-12-16 20:43:15,323 [http-nio-1918-exec-3] ==> Parameters:
2024-12-16 20:43:15,394 [http-nio-1918-exec-3] <== Total: 302
2024-12-16 20:43:15,457 [http-nio-1918-exec-5] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:43:15,459 [http-nio-1918-exec-5] ==> Parameters: null
2024-12-16 20:43:15,479 [http-nio-1918-exec-5] <== Total: 0
2024-12-16 20:43:15,480 [http-nio-1918-exec-5] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 20:43:15,481 [http-nio-1918-exec-5] ==> Parameters: 0(String)
2024-12-16 20:43:15,534 [http-nio-1918-exec-5] <== Total: 1
2024-12-16 20:43:15,534 [http-nio-1918-exec-5] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:43:15,535 [http-nio-1918-exec-5] ==> Parameters: null
2024-12-16 20:43:15,554 [http-nio-1918-exec-5] <== Total: 0
2024-12-16 20:43:15,554 [http-nio-1918-exec-5] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 20:43:15,555 [http-nio-1918-exec-5] ==> Parameters: 0(String), 0(Integer), 10(Integer)
2024-12-16 20:43:15,613 [http-nio-1918-exec-5] <== Total: 10
2024-12-16 20:43:22,729 [http-nio-1918-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:43:22,730 [http-nio-1918-exec-1] ==> Parameters: null
2024-12-16 20:43:22,749 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 20:43:22,750 [http-nio-1918-exec-1] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 20:43:22,750 [http-nio-1918-exec-1] ==> Parameters: 0(String)
2024-12-16 20:43:22,788 [http-nio-1918-exec-1] <== Total: 1
2024-12-16 20:43:22,789 [http-nio-1918-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:43:22,789 [http-nio-1918-exec-1] ==> Parameters: null
2024-12-16 20:43:22,824 [http-nio-1918-exec-1] <== Total: 0
2024-12-16 20:43:22,824 [http-nio-1918-exec-1] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 20:43:22,825 [http-nio-1918-exec-1] ==> Parameters: 0(String), 10(Integer), 10(Integer)
2024-12-16 20:43:22,888 [http-nio-1918-exec-1] <== Total: 10
2024-12-16 20:43:51,581 [http-nio-1918-exec-9] 进入preventRepeatSubmit切面
2024-12-16 20:43:51,581 [http-nio-1918-exec-9] 防重复提交的请求地址：/gzrbmw/uploadPayroll/uploadPayrollPersonPush ,请求方式：POST
2024-12-16 20:43:51,581 [http-nio-1918-exec-9] 防重复提交拦截到的类名：UploadPayrollController ,方法：uploadPayrollPersonPush
2024-12-16 20:43:51,582 [http-nio-1918-exec-9] 获取到preventRepeatSubmit的有效期时间3
2024-12-16 20:43:51,585 [http-nio-1918-exec-9] ==> Preparing: SELECT bwpsi.`name`, bwpsi.idCard, bwph.id_number FROM bm_worker_provide_salary_info bwpsi LEFT JOIN bm_worker_push_history bwph ON bwph.pro_id = bwpsi.pro_id and bwph.id_number = bwpsi.idCard and bwph.is_active = '1' left join bm_worker_record bwr on bwr.ID_NUMBER = bwpsi.idCard WHERE bwpsi.submitBatchNo = ? and if((bwr.ein_status = 0 and bwr.is_ein_push = 1), true, bwr.PROJECT_ID != bwpsi.pro_id) GROUP BY bwpsi.idCard
2024-12-16 20:43:51,585 [http-nio-1918-exec-9] ==> Parameters: paepc-61(String)
2024-12-16 20:43:52,022 [http-nio-1918-exec-9] <== Total: 0
2024-12-16 20:43:52,023 [http-nio-1918-exec-9] ==> Preparing: SELECT 'true' AS submitApply, concat( 'SongBianDianProject', IFNULL( p.pro_old_id, p.id ) ) AS projectId, p.NAME AS projectName, concat( 'SongBianDianTeam', bst.id ) AS teamId, bst.NAME AS teamName, '贵州送变电有限责任公司' AS orgName, '9152000021440270X9' AS orgCreditCode, '银行卡' as payRollBankCardType, bwps.*, sdd.NAME AS bank, p.account_name AS accountName, p.open_bank_number AS accountNo, p.bank_name AS bankName, bwp.bankAffiliated, IF ( bwah.EXIT_TIME IS NOT NULL, '否', '是' ) AS whetherOnJob, IF ( bwah.EXIT_TIME IS NOT NULL, IFNULL( CONCAT( 'http://116.63.142.171:1919/gzrnama/', bwah.departureAffirmUrl ), 'http://npm.org/123.jpg' ), '' ) AS departureAffirmUrl FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bwps.idCard LEFT JOIN bm_worker_attend_history bwah ON bwr.ID_NUMBER = bwah.ID_NUMBER and bwr.PROJECT_ID = bwah.PROJECT_ID LEFT JOIN bm_project p ON p.id = bwps.pro_id or p.pro_old_id = bwps.pro_id LEFT JOIN sys_dic_detail sdd ON sdd.id = p.bank_account LEFT JOIN bm_worker_payroll bwp ON bwp.ID_NUMBER = bwps.idCard AND bwp.IS_ACTIVE = 1 LEFT JOIN ( SELECT * FROM ( SELECT bwph.ID_NUMBER, bwph.TEAM_ID FROM bm_worker_provide_salary_info bwps LEFT JOIN bm_worker_push_history bwph ON bwph.ID_NUMBER = bwps.idCard AND bwph.pro_id = bwph.pro_id AND bwph.is_active = 1 WHERE bwps.submitBatchNo = ? ORDER BY bwph.create_time DESC LIMIT 100000000000 ) a GROUP BY a.ID_NUMBER ) a ON a.ID_NUMBER = bwps.idCard LEFT JOIN bm_sub_team bst ON bst.id = bwr.TEAM_ID WHERE bwr.ID_NUMBER IS NOT NULL AND bwps.submitBatchNo IS NOT NULL AND bwps.is_push != 1 AND bwps.submitBatchNo = ?
2024-12-16 20:43:52,023 [http-nio-1918-exec-9] ==> Parameters: paepc-61(String), paepc-61(String)
2024-12-16 20:43:52,440 [http-nio-1918-exec-9] <== Total: 55
2024-12-16 20:43:52,442 [http-nio-1918-exec-9] ==> Preparing: SELECT a.pro_name as proName, concat('SongBianDianProject',SUBSTRING_INDEX( SUBSTRING_INDEX( a.bid_pro_id, ',', b.help_topic_id + 1 ), ',',- 1 )) bidProId, SUBSTRING_INDEX( SUBSTRING_INDEX( a.is_multiple, ',', b.help_topic_id + 1 ), ',',- 1 ) isMultiple FROM bm_project_bid_relation a JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.bid_pro_id ) - LENGTH( REPLACE ( a.bid_pro_id, ',', '' ) ) + 1 ) WHERE a.is_active = 1 and a.bid_pro_id like CONCAT('%',?,'%')
2024-12-16 20:43:52,443 [http-nio-1918-exec-9] ==> Parameters: 10066(String)
2024-12-16 20:43:52,463 [http-nio-1918-exec-9] <== Total: 0
2024-12-16 20:44:13,521 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:13,521 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:13(String), paepc-61(String)
2024-12-16 20:44:13,565 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:13,566 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:13,566 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:13,606 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:13,608 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:13,609 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:13(String), paepc-61(String)
2024-12-16 20:44:13,657 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:13,659 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:13,660 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:13,727 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:13,728 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:13,728 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:13(String), paepc-61(String)
2024-12-16 20:44:13,772 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:13,773 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:13,773 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:13,813 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:13,813 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:13,814 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:13(String), paepc-61(String)
2024-12-16 20:44:13,852 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:13,852 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:13,853 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:13,895 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:13,896 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:13,898 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:13(String), paepc-61(String)
2024-12-16 20:44:13,942 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:13,943 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:13,944 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:13,984 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:13,984 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:13,985 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:13(String), paepc-61(String)
2024-12-16 20:44:14,045 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,046 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,046 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,086 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,087 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,087 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,127 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,128 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,128 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,167 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,167 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,167 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,214 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,215 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,217 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,265 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,265 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,265 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,305 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,305 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,305 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,366 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,366 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,367 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,409 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,409 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,410 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,449 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,450 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,450 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,490 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,491 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,491 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,533 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,533 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,534 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,574 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,574 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,575 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,613 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,614 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,615 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,654 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,655 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,655 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,697 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,698 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,698 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,737 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,738 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,738 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,779 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,780 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,780 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,821 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,823 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,824 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,871 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,871 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,872 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:14,910 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:14,911 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:14,911 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:14,961 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:14,961 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:14,962 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:14(String), paepc-61(String)
2024-12-16 20:44:15,008 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,008 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,009 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,080 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,081 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,081 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,125 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,127 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,128 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,179 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,179 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,179 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,218 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,219 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,220 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,258 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,258 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,259 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,297 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,297 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,297 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,335 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,336 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,336 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,375 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,376 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,376 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,414 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,414 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,415 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,455 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,456 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,456 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,499 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,501 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,503 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,544 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,545 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,545 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,585 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,585 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,586 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,622 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,623 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,623 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,673 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,674 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,674 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,720 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,721 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,722 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,762 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,763 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,763 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,807 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,809 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,809 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,849 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,850 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,850 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,892 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,893 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,893 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:15,932 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:15,933 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:15,933 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:15(String), paepc-61(String)
2024-12-16 20:44:15,974 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:15,974 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:15,975 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,017 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,017 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,019 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,057 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,058 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,058 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,098 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,098 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,099 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,143 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,144 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,144 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,187 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,187 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,189 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,230 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,230 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,231 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,287 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,287 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,288 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,330 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,331 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,331 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,374 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,375 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,375 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,421 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,422 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,422 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,467 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,468 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,469 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,510 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,511 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,511 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,547 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,549 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,549 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,609 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,610 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,611 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,649 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,649 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,650 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,686 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,687 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,687 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,725 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,726 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,726 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,762 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,763 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,763 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,802 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,803 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,803 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,842 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,843 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,843 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,904 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,904 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,905 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:16,943 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:16,944 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:16,944 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:16,982 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:16,982 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:16,982 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:16(String), paepc-61(String)
2024-12-16 20:44:17,023 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,023 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,023 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,064 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,064 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,064 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,107 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,107 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,107 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,150 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,151 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,151 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,192 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,193 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,193 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,234 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,235 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,237 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,284 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,285 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,287 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,330 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,331 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,332 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,370 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,371 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,371 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,413 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,414 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,414 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,454 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,456 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,457 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,498 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,501 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,502 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,545 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,547 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,548 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,589 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,590 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,590 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,638 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,640 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,641 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,683 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,683 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,683 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,722 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,723 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,723 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,763 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,763 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,764 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,805 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,806 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,806 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,847 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,847 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,847 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,894 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,895 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,896 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:17,944 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:17,946 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:17,946 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:17(String), paepc-61(String)
2024-12-16 20:44:17,992 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:17,993 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:17,994 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:18,040 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:18,041 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:18,041 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:18(String), paepc-61(String)
2024-12-16 20:44:18,085 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:18,085 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:18,085 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:18,130 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:18,130 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:18,130 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:18(String), paepc-61(String)
2024-12-16 20:44:18,171 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:18,172 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:18,172 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:18,209 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:18,210 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:18,211 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:18(String), paepc-61(String)
2024-12-16 20:44:18,250 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:18,251 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:18,251 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:18,296 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:18,296 [http-nio-1918-exec-9] ==> Preparing: update bm_worker_provide_salary_info set is_push = ?,push_time = ? where submitBatchNo = ?
2024-12-16 20:44:18,296 [http-nio-1918-exec-9] ==> Parameters: 2(String), 2024-12-16 20:44:18(String), paepc-61(String)
2024-12-16 20:44:18,341 [http-nio-1918-exec-9] <== Updates: 55
2024-12-16 20:44:18,341 [http-nio-1918-exec-9] ==> Preparing: update salary_book_upload set is_push = ? where submitBatchNo = ?
2024-12-16 20:44:18,341 [http-nio-1918-exec-9] ==> Parameters: 2(String), paepc-61(String)
2024-12-16 20:44:18,387 [http-nio-1918-exec-9] <== Updates: 1
2024-12-16 20:44:18,389 [taskExecutor-8] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2024-12-16 20:44:18,391 [taskExecutor-8] ==> Parameters: 249(Long), 推送工资册(String), true(Boolean), {"submitBatchNo":"paepc-61","uploadType":"0"}(String)
2024-12-16 20:44:18,436 [taskExecutor-8] <== Updates: 1
2024-12-16 20:44:20,068 [http-nio-1918-exec-7] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:44:20,069 [http-nio-1918-exec-7] ==> Parameters: null
2024-12-16 20:44:20,092 [http-nio-1918-exec-7] <== Total: 0
2024-12-16 20:44:20,094 [http-nio-1918-exec-7] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2024-12-16 20:44:20,095 [http-nio-1918-exec-7] ==> Parameters:
2024-12-16 20:44:20,119 [http-nio-1918-exec-7] <== Total: 19
2024-12-16 20:44:20,131 [http-nio-1918-exec-8] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:44:20,132 [http-nio-1918-exec-8] ==> Parameters: null
2024-12-16 20:44:20,180 [http-nio-1918-exec-8] <== Total: 0
2024-12-16 20:44:20,180 [http-nio-1918-exec-8] ==> Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2024-12-16 20:44:20,180 [http-nio-1918-exec-8] ==> Parameters:
2024-12-16 20:44:20,242 [http-nio-1918-exec-8] <== Total: 302
2024-12-16 20:44:20,301 [http-nio-1918-exec-9] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:44:20,301 [http-nio-1918-exec-9] ==> Parameters: null
2024-12-16 20:44:20,321 [http-nio-1918-exec-9] <== Total: 0
2024-12-16 20:44:20,322 [http-nio-1918-exec-9] ==> Preparing: SELECT COUNT(1) from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ?
2024-12-16 20:44:20,323 [http-nio-1918-exec-9] ==> Parameters: 0(String)
2024-12-16 20:44:20,363 [http-nio-1918-exec-9] <== Total: 1
2024-12-16 20:44:20,364 [http-nio-1918-exec-9] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2024-12-16 20:44:20,364 [http-nio-1918-exec-9] ==> Parameters: null
2024-12-16 20:44:20,386 [http-nio-1918-exec-9] <== Total: 0
2024-12-16 20:44:20,387 [http-nio-1918-exec-9] ==> Preparing: select sbu.id , sbu.name , sbu.creator , sbu.create_time , sbu.people_num , sbu.salary_total , sbu.remark , sbu.is_push, sbu.is_handle, bp.name as proName, pc.org_name as companyName, sbu.submitBatchNo from salary_book_upload sbu left join pm_company pc on pc.ID = sbu.company_id left join bm_project bp on bp.ID = sbu.project_id or bp.pro_old_id = sbu.project_id where sbu.upload_type = ? ORDER BY sbu.create_time DESC limit ?, ?
2024-12-16 20:44:20,387 [http-nio-1918-exec-9] ==> Parameters: 0(String), 0(Integer), 10(Integer)
2024-12-16 20:44:20,457 [http-nio-1918-exec-9] <== Total: 10
2024-12-16 20:44:35,475 [http-nio-1918-exec-3] ==> Preparing: SELECT COUNT(*) FROM bm_worker_provide_salary_info bwp where bwp.submitBatchNo = ?
2024-12-16 20:44:35,476 [http-nio-1918-exec-3] ==> Parameters: gsgyzr77(String)
2024-12-16 20:44:35,498 [http-nio-1918-exec-3] <== Total: 1
2024-12-16 20:44:35,499 [http-nio-1918-exec-3] ==> Preparing: SELECT bwp.`name` personName, bwp.idCard idNumber, bwp.payRollBankCardNum bankNumber, bwp.payRollBankName bankBrank, bwp.payrollBank bankName, bwp.actualAmount payableAmount, bwp.totalPayAmount payinAmount, bwp.garnishedWages, bwp.balanceDate payDate, bwp.payMonth , bwp.isBackPay isReissue, bwp.settlementAmount workDays, bwp.financialMark financeSure, bwp.personalMark personSure, bwp.submitBatchNo submitBatchNo, bwp.extFieldOne bankHandleno FROM bm_worker_provide_salary_info bwp where bwp.submitBatchNo = ? limit ?, ?
2024-12-16 20:44:35,499 [http-nio-1918-exec-3] ==> Parameters: gsgyzr77(String), 0(Integer), 10(Integer)
2024-12-16 20:44:35,521 [http-nio-1918-exec-3] <== Total: 4
2024-12-16 20:54:05,144 [SpringContextShutdownHook] SSHConnectionListener destroyed ... !
Reference in New Issue View Git Blame Copy Permalink