81 lines
15 KiB
Plaintext
81 lines
15 KiB
Plaintext
|
2024-07-24 15:32:50,670 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 15532 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
|
||
|
|
2024-07-24 15:32:50,679 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
|
||
|
|
2024-07-24 15:32:50,680 [main] No active profile set, falling back to default profiles: default
|
||
|
|
2024-07-24 15:32:54,417 [main] Filter 'tokenFilter' configured for use
|
||
|
|
2024-07-24 15:32:56,691 [main] Started SecurityApplication in 6.455 seconds (JVM running for 7.984)
|
||
|
|
2024-07-24 15:32:56,694 [taskExecutor-1] --------无信号班组有效期消息通知启动------
|
||
|
|
2024-07-24 15:32:56,695 [taskExecutor-3] --------红名单定时器启动------
|
||
|
|
2024-07-24 15:32:56,695 [taskExecutor-2] --------无信号班组有效期消息通知启动------
|
||
|
|
2024-07-24 15:32:56,982 [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-07-24 15:32:56,995 [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-07-24 15:32:57,002 [taskExecutor-3] ==> Parameters:
|
||
|
|
2024-07-24 15:32:57,002 [taskExecutor-2] ==> Parameters:
|
||
|
|
2024-07-24 15:32:57,010 [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-07-24 15:32:57,010 [taskExecutor-1] ==> Parameters:
|
||
|
|
2024-07-24 15:32:57,023 [taskExecutor-3] <== Total: 0
|
||
|
|
2024-07-24 15:32:57,025 [taskExecutor-1] <== Total: 1
|
||
|
|
2024-07-24 15:32:57,025 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
|
||
|
|
2024-07-24 15:32:57,025 [taskExecutor-2] <== Total: 1
|
||
|
|
2024-07-24 15:32:57,026 [taskExecutor-1] --------无信号班组有效期消息通知结束------
|
||
|
|
2024-07-24 15:32:57,026 [taskExecutor-2] --------无信号班组有效期消息通知结束------
|
||
|
|
2024-07-24 15:35:43,659 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 2008 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
|
||
|
|
2024-07-24 15:35:43,663 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
|
||
|
|
2024-07-24 15:35:43,663 [main] No active profile set, falling back to default profiles: default
|
||
|
|
2024-07-24 15:35:46,379 [main] Filter 'tokenFilter' configured for use
|
||
|
|
2024-07-24 15:35:48,525 [main] Started SecurityApplication in 5.359 seconds (JVM running for 6.867)
|
||
|
|
2024-07-24 15:35:48,528 [taskExecutor-3] --------红名单定时器启动------
|
||
|
|
2024-07-24 15:35:48,528 [taskExecutor-1] --------无信号班组有效期消息通知启动------
|
||
|
|
2024-07-24 15:35:48,528 [taskExecutor-2] --------无信号班组有效期消息通知启动------
|
||
|
|
2024-07-24 15:35:48,667 [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-07-24 15:35:48,668 [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-07-24 15:35:48,675 [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-07-24 15:35:48,692 [taskExecutor-3] ==> Parameters:
|
||
|
|
2024-07-24 15:35:48,692 [taskExecutor-1] ==> Parameters:
|
||
|
|
2024-07-24 15:35:48,692 [taskExecutor-2] ==> Parameters:
|
||
|
|
2024-07-24 15:35:48,715 [taskExecutor-3] <== Total: 0
|
||
|
|
2024-07-24 15:35:48,717 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
|
||
|
|
2024-07-24 15:35:48,718 [taskExecutor-2] <== Total: 1
|
||
|
|
2024-07-24 15:35:48,718 [taskExecutor-1] <== Total: 1
|
||
|
|
2024-07-24 15:35:48,718 [taskExecutor-2] --------无信号班组有效期消息通知结束------
|
||
|
|
2024-07-24 15:35:48,718 [taskExecutor-1] --------无信号班组有效期消息通知结束------
|
||
|
|
2024-07-24 15:36:55,221 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 21364 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
|
||
|
|
2024-07-24 15:36:55,224 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
|
||
|
|
2024-07-24 15:36:55,224 [main] No active profile set, falling back to default profiles: default
|
||
|
|
2024-07-24 15:37:00,170 [main] Filter 'tokenFilter' configured for use
|
||
|
|
2024-07-24 15:37:05,715 [main] Started SecurityApplication in 11.379 seconds (JVM running for 13.214)
|
||
|
|
2024-07-24 15:37:05,719 [taskExecutor-1] --------无信号班组有效期消息通知启动------
|
||
|
|
2024-07-24 15:37:05,720 [taskExecutor-3] --------红名单定时器启动------
|
||
|
|
2024-07-24 15:37:05,721 [taskExecutor-2] --------无信号班组有效期消息通知启动------
|
||
|
|
2024-07-24 15:37:06,293 [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-07-24 15:37:06,321 [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-07-24 15:37:06,328 [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-07-24 15:37:06,341 [taskExecutor-3] ==> Parameters:
|
||
|
|
2024-07-24 15:37:06,341 [taskExecutor-2] ==> Parameters:
|
||
|
|
2024-07-24 15:37:06,342 [taskExecutor-1] ==> Parameters:
|
||
|
|
2024-07-24 15:37:06,374 [taskExecutor-3] <== Total: 0
|
||
|
|
2024-07-24 15:37:06,377 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
|
||
|
|
2024-07-24 15:37:06,377 [taskExecutor-2] <== Total: 1
|
||
|
|
2024-07-24 15:37:06,377 [taskExecutor-1] <== Total: 1
|
||
|
|
2024-07-24 15:37:06,378 [taskExecutor-2] --------无信号班组有效期消息通知结束------
|
||
|
|
2024-07-24 15:37:06,378 [taskExecutor-1] --------无信号班组有效期消息通知结束------
|
||
|
|
2024-07-24 17:45:04,853 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 28908 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
|
||
|
|
2024-07-24 17:45:04,867 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
|
||
|
|
2024-07-24 17:45:04,868 [main] No active profile set, falling back to default profiles: default
|
||
|
|
2024-07-24 17:45:10,550 [main] Filter 'tokenFilter' configured for use
|
||
|
|
2024-07-24 17:45:12,838 [main] Started SecurityApplication in 8.674 seconds (JVM running for 10.554)
|
||
|
|
2024-07-24 17:45:12,841 [taskExecutor-3] --------红名单定时器启动------
|
||
|
|
2024-07-24 17:45:12,841 [taskExecutor-1] --------无信号班组有效期消息通知启动------
|
||
|
|
2024-07-24 17:45:12,842 [taskExecutor-2] --------无信号班组有效期消息通知启动------
|
||
|
|
2024-07-24 17:45:12,997 [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-07-24 17:45:13,012 [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-07-24 17:45:13,019 [taskExecutor-3] ==> Parameters:
|
||
|
|
2024-07-24 17:45:13,019 [taskExecutor-1] ==> Parameters:
|
||
|
|
2024-07-24 17:45:13,024 [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-07-24 17:45:13,025 [taskExecutor-2] ==> Parameters:
|
||
|
|
2024-07-24 17:45:13,041 [taskExecutor-3] <== Total: 0
|
||
|
|
2024-07-24 17:45:13,043 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
|
||
|
|
2024-07-24 17:45:13,044 [taskExecutor-2] <== Total: 1
|
||
|
|
2024-07-24 17:45:13,044 [taskExecutor-1] <== Total: 1
|
||
|
|
2024-07-24 17:45:13,044 [taskExecutor-2] --------无信号班组有效期消息通知结束------
|
||
|
|
2024-07-24 17:45:13,044 [taskExecutor-1] --------无信号班组有效期消息通知结束------
|