2023-01-05 17:31:27,487 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 8552 (E:\work\gz_workspace\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\gzRealNameBackstageManageWeb)
2023-01-05 17:31:27,499 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2023-01-05 17:31:27,500 [main] No active profile set, falling back to default profiles: default
2023-01-05 17:31:35,815 [main] SSHConnectionListener initialized ... !
2023-01-05 17:31:35,818 [main] Filter 'tokenFilter' configured for use
2023-01-05 17:31:38,783 [main] Started SecurityApplication in 12.086 seconds (JVM running for 14.748)
2023-01-05 17:31:45,874 [http-nio-1920-exec-10] 验证码：HH4R用户输入：hh4r
2023-01-05 17:31:46,584 [http-nio-1920-exec-10] ==>  Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2023-01-05 17:31:46,618 [http-nio-1920-exec-10] ==> Parameters: bnsAdmin(String)
2023-01-05 17:31:46,686 [http-nio-1920-exec-10] <==      Total: 1
2023-01-05 17:31:46,696 [http-nio-1920-exec-10] ==>  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
2023-01-05 17:31:46,697 [http-nio-1920-exec-10] ==> Parameters: 249(Long)
2023-01-05 17:31:46,780 [http-nio-1920-exec-10] <==      Total: 148
2023-01-05 17:31:47,258 [taskExecutor-1] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2023-01-05 17:31:47,315 [taskExecutor-1] ==> Parameters: 249(Long), 登陆(String), true(Boolean), null
2023-01-05 17:31:47,401 [taskExecutor-1] <==    Updates: 1
2023-01-05 17:31:58,407 [http-nio-1920-exec-3] ==>  Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-01-05 17:31:58,409 [http-nio-1920-exec-3] ==> Parameters: null
2023-01-05 17:31:58,443 [http-nio-1920-exec-3] <==      Total: 0
2023-01-05 17:31:58,464 [http-nio-1920-exec-3] ==>  Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2023-01-05 17:31:58,464 [http-nio-1920-exec-3] ==> Parameters: 
2023-01-05 17:31:58,500 [http-nio-1920-exec-3] <==      Total: 11
2023-01-05 17:31:58,516 [http-nio-1920-exec-5] ==>  Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-01-05 17:31:58,517 [http-nio-1920-exec-5] ==> Parameters: null
2023-01-05 17:31:58,552 [http-nio-1920-exec-5] <==      Total: 0
2023-01-05 17:31:58,554 [http-nio-1920-exec-5] ==>  Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2023-01-05 17:31:58,554 [http-nio-1920-exec-5] ==> Parameters: 
2023-01-05 17:31:58,630 [http-nio-1920-exec-5] <==      Total: 208
2023-01-05 17:31:58,780 [http-nio-1920-exec-6] ==>  Preparing: select count(1) from (SELECT IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),bwc.stop_date)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),bwc.stop_date)<0,'过期','预警')) as remind FROM bm_worker_certificate bwc LEFT JOIN bm_certificate_type bct ON bct.id = bwc.certificate_id AND bct.is_active = '1' LEFT JOIN bm_worker bw ON bw.ID_NUMBER = bwc.ID_NUMBER AND bw.is_active = '1' LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bw.ID_NUMBER LEFT JOIN sys_dic_detail sdd ON sdd.id = bwr.POST_ID AND sdd.dic_type = 3 LEFT JOIN bm_project bp ON bp.ID = bwr.PROJECT_ID WHERE bwc.is_active = '1' and bwr.ein_status = '1' ) a
2023-01-05 17:31:58,781 [http-nio-1920-exec-6] ==> Parameters: 
2023-01-05 17:31:58,829 [http-nio-1920-exec-6] <==      Total: 1
2023-01-05 17:31:58,830 [http-nio-1920-exec-6] ==>  Preparing: select * from ( select *, IF(oneReviewTime = '无需复审' OR oneReviewTime = '已全部复审', IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),stopDate)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),stopDate)<0,'过期','预警')), IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),oneReviewTime)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),oneReviewTime)<0,'过期','预警'))) as remind from ( SELECT bp.`name` as proName, bw.`NAME`, bw.phone, bwc.ID_NUMBER as idNumber, sdd.`name` as postName, bct.name AS certificateName, bwc.start_date as startDate, bwc.stop_date as stopDate, IF(bwc.one_review_time is null,'无需复审',IF(bwc.one_review_user_id is null,bwc.one_review_time, IF(bwc.two_review_time is null,'已全部复审',IF(bwc.two_review_user_id is null,bwc.two_review_time, IF(bwc.three_review_time is null,'已全部复审',IF(bwc.three_review_user_id is null,bwc.three_review_time,'已全部复审')))))) as oneReviewTime, bwc.certificate_file as certificateFile, bwc.certificate_type_file as certificateTypeFile FROM bm_worker_certificate bwc LEFT JOIN bm_certificate_type bct ON bct.id = bwc.certificate_id AND bct.is_active = '1' LEFT JOIN bm_worker bw ON bw.ID_NUMBER = bwc.ID_NUMBER AND bw.is_active = '1' LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bw.ID_NUMBER LEFT JOIN sys_dic_detail sdd ON sdd.id = bwr.POST_ID AND sdd.dic_type = 3 LEFT JOIN bm_project bp ON bp.ID = bwr.PROJECT_ID WHERE bwc.is_active = '1' and bwr.ein_status = '1' )yyy ) a limit ?, ?
2023-01-05 17:31:58,832 [http-nio-1920-exec-6] ==> Parameters: 0(Integer), 10(Integer)
2023-01-05 17:31:58,873 [http-nio-1920-exec-6] <==      Total: 10
2023-01-05 17:37:28,768 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 20584 (E:\work\gz_workspace\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\gzRealNameBackstageManageWeb)
2023-01-05 17:37:28,771 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2023-01-05 17:37:28,771 [main] No active profile set, falling back to default profiles: default
2023-01-05 17:37:35,009 [main] SSHConnectionListener initialized ... !
2023-01-05 17:37:35,012 [main] Filter 'tokenFilter' configured for use
2023-01-05 17:37:36,848 [main] Started SecurityApplication in 8.618 seconds (JVM running for 9.944)
2023-01-05 17:39:33,381 [http-nio-1920-exec-3] ==>  Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-01-05 17:39:33,401 [http-nio-1920-exec-3] ==> Parameters: null
2023-01-05 17:39:33,455 [http-nio-1920-exec-3] <==      Total: 0
2023-01-05 17:39:33,467 [http-nio-1920-exec-3] ==>  Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2023-01-05 17:39:33,467 [http-nio-1920-exec-3] ==> Parameters: 
2023-01-05 17:39:33,504 [http-nio-1920-exec-3] <==      Total: 11
2023-01-05 17:39:33,515 [http-nio-1920-exec-1] ==>  Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-01-05 17:39:33,516 [http-nio-1920-exec-1] ==> Parameters: null
2023-01-05 17:39:33,550 [http-nio-1920-exec-1] <==      Total: 0
2023-01-05 17:39:33,551 [http-nio-1920-exec-1] ==>  Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2023-01-05 17:39:33,552 [http-nio-1920-exec-1] ==> Parameters: 
2023-01-05 17:39:33,629 [http-nio-1920-exec-1] <==      Total: 208
2023-01-05 17:39:33,725 [http-nio-1920-exec-8] ==>  Preparing: select count(1) from (SELECT IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),bwc.stop_date)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),bwc.stop_date)<0,'过期','预警')) as remind FROM bm_worker_certificate bwc LEFT JOIN bm_certificate_type bct ON bct.id = bwc.certificate_id AND bct.is_active = '1' LEFT JOIN bm_worker bw ON bw.ID_NUMBER = bwc.ID_NUMBER AND bw.is_active = '1' LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bw.ID_NUMBER LEFT JOIN sys_dic_detail sdd ON sdd.id = bwr.POST_ID AND sdd.dic_type = 3 LEFT JOIN bm_project bp ON bp.ID = bwr.PROJECT_ID WHERE bwc.is_active = '1' ) a
2023-01-05 17:39:33,726 [http-nio-1920-exec-8] ==> Parameters: 
2023-01-05 17:39:33,778 [http-nio-1920-exec-8] <==      Total: 1
2023-01-05 17:39:33,779 [http-nio-1920-exec-8] ==>  Preparing: select * from ( select *, IF(oneReviewTime = '无需复审' OR oneReviewTime = '已全部复审', IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),stopDate)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),stopDate)<0,'过期','预警')), IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),oneReviewTime)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),oneReviewTime)<0,'过期','预警'))) as remind from ( SELECT bp.`name` as proName, bw.`NAME`, bw.phone, bwc.ID_NUMBER as idNumber, sdd.`name` as postName, bct.name AS certificateName, bwc.start_date as startDate, bwc.stop_date as stopDate, IF(bwc.one_review_time is null,'无需复审',IF(bwc.one_review_user_id is null,bwc.one_review_time, IF(bwc.two_review_time is null,'已全部复审',IF(bwc.two_review_user_id is null,bwc.two_review_time, IF(bwc.three_review_time is null,'已全部复审',IF(bwc.three_review_user_id is null,bwc.three_review_time,'已全部复审')))))) as oneReviewTime, bwc.certificate_file as certificateFile, bwc.certificate_type_file as certificateTypeFile, if(bwr.ein_status = '1','在职','离职') as onJob FROM bm_worker_certificate bwc LEFT JOIN bm_certificate_type bct ON bct.id = bwc.certificate_id AND bct.is_active = '1' LEFT JOIN bm_worker bw ON bw.ID_NUMBER = bwc.ID_NUMBER AND bw.is_active = '1' LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bw.ID_NUMBER LEFT JOIN sys_dic_detail sdd ON sdd.id = bwr.POST_ID AND sdd.dic_type = 3 LEFT JOIN bm_project bp ON bp.ID = bwr.PROJECT_ID WHERE bwc.is_active = '1' )yyy ) a limit ?, ?
2023-01-05 17:39:33,780 [http-nio-1920-exec-8] ==> Parameters: 0(Integer), 10(Integer)
2023-01-05 17:39:33,841 [http-nio-1920-exec-8] <==      Total: 10
2023-01-05 17:41:17,849 [http-nio-1920-exec-1] ==>  Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-01-05 17:41:17,850 [http-nio-1920-exec-1] ==> Parameters: null
2023-01-05 17:41:17,888 [http-nio-1920-exec-1] <==      Total: 0
2023-01-05 17:41:17,889 [http-nio-1920-exec-1] ==>  Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2023-01-05 17:41:17,889 [http-nio-1920-exec-1] ==> Parameters: 
2023-01-05 17:41:17,934 [http-nio-1920-exec-1] <==      Total: 11
2023-01-05 17:41:17,943 [http-nio-1920-exec-2] ==>  Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-01-05 17:41:17,944 [http-nio-1920-exec-2] ==> Parameters: null
2023-01-05 17:41:17,977 [http-nio-1920-exec-2] <==      Total: 0
2023-01-05 17:41:17,978 [http-nio-1920-exec-2] ==>  Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' ORDER BY `NAME` asc
2023-01-05 17:41:17,978 [http-nio-1920-exec-2] ==> Parameters: 
2023-01-05 17:41:18,053 [http-nio-1920-exec-2] <==      Total: 208
2023-01-05 17:41:18,101 [http-nio-1920-exec-6] ==>  Preparing: select count(1) from (SELECT IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),bwc.stop_date)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),bwc.stop_date)<0,'过期','预警')) as remind FROM bm_worker_certificate bwc LEFT JOIN bm_certificate_type bct ON bct.id = bwc.certificate_id AND bct.is_active = '1' LEFT JOIN bm_worker bw ON bw.ID_NUMBER = bwc.ID_NUMBER AND bw.is_active = '1' LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bw.ID_NUMBER LEFT JOIN sys_dic_detail sdd ON sdd.id = bwr.POST_ID AND sdd.dic_type = 3 LEFT JOIN bm_project bp ON bp.ID = bwr.PROJECT_ID WHERE bwc.is_active = '1' ) a
2023-01-05 17:41:18,102 [http-nio-1920-exec-6] ==> Parameters: 
2023-01-05 17:41:18,146 [http-nio-1920-exec-6] <==      Total: 1
2023-01-05 17:41:18,147 [http-nio-1920-exec-6] ==>  Preparing: select * from ( select *, IF(oneReviewTime = '无需复审' OR oneReviewTime = '已全部复审', IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),stopDate)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),stopDate)<0,'过期','预警')), IF(TIMESTAMPDIFF(MONTH,DATE_FORMAT(NOW(), '%Y-%m-%d'),oneReviewTime)>5,'有效', IF(TIMESTAMPDIFF(DAY,DATE_FORMAT(NOW(), '%Y-%m-%d'),oneReviewTime)<0,'过期','预警'))) as remind from ( SELECT bp.`name` as proName, bw.`NAME`, bw.phone, bwc.ID_NUMBER as idNumber, sdd.`name` as postName, bct.name AS certificateName, bwc.start_date as startDate, bwc.stop_date as stopDate, IF(bwc.one_review_time is null,'无需复审',IF(bwc.one_review_user_id is null,bwc.one_review_time, IF(bwc.two_review_time is null,'已全部复审',IF(bwc.two_review_user_id is null,bwc.two_review_time, IF(bwc.three_review_time is null,'已全部复审',IF(bwc.three_review_user_id is null,bwc.three_review_time,'已全部复审')))))) as oneReviewTime, bwc.certificate_file as certificateFile, bwc.certificate_type_file as certificateTypeFile, if(bwr.ein_status = '1','在职','离职') as onJob FROM bm_worker_certificate bwc LEFT JOIN bm_certificate_type bct ON bct.id = bwc.certificate_id AND bct.is_active = '1' LEFT JOIN bm_worker bw ON bw.ID_NUMBER = bwc.ID_NUMBER AND bw.is_active = '1' LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bw.ID_NUMBER LEFT JOIN sys_dic_detail sdd ON sdd.id = bwr.POST_ID AND sdd.dic_type = 3 LEFT JOIN bm_project bp ON bp.ID = bwr.PROJECT_ID WHERE bwc.is_active = '1' )yyy ) a limit ?, ?
2023-01-05 17:41:18,148 [http-nio-1920-exec-6] ==> Parameters: 0(Integer), 10(Integer)
2023-01-05 17:41:18,189 [http-nio-1920-exec-6] <==      Total: 10