1179 lines
147 KiB
Plaintext
1179 lines
147 KiB
Plaintext
|
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 ... !
|