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

317 lines
79 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

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

2025-06-17 13:25:02,915 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 24360 (E:\work\gz_workspace\hd\hd_real_name\target\classes started by admin in E:\work\gz_workspace\hd\hd_real_name)
2025-06-17 13:25:02,915 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2025-06-17 13:25:02,915 [main] No active profile set, falling back to default profiles: default
2025-06-17 13:25:08,731 [main] Filter 'tokenFilter' configured for use
2025-06-17 13:25:12,334 [main] Started SecurityApplication in 10.043 seconds (JVM running for 12.227)
2025-06-17 13:25:12,350 [taskExecutor-3] --------红名单定时器启动------
2025-06-17 13:25:12,350 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2025-06-17 13:25:12,350 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2025-06-17 13:26:48,111 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 14732 (E:\work\gz_workspace\hd\hd_real_name\target\classes started by admin in E:\work\gz_workspace\hd\hd_real_name)
2025-06-17 13:26:48,114 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2025-06-17 13:26:48,114 [main] No active profile set, falling back to default profiles: default
2025-06-17 13:26:51,054 [main] Filter 'tokenFilter' configured for use
2025-06-17 13:26:53,264 [main] Started SecurityApplication in 5.65 seconds (JVM running for 7.367)
2025-06-17 13:26:53,267 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2025-06-17 13:26:53,267 [taskExecutor-3] --------红名单定时器启动------
2025-06-17 13:26:53,267 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2025-06-17 13:26:53,526 [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'
2025-06-17 13:26:53,531 [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'
2025-06-17 13:26:53,536 [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
2025-06-17 13:26:53,558 [taskExecutor-1] ==> Parameters:
2025-06-17 13:26:53,558 [taskExecutor-2] ==> Parameters:
2025-06-17 13:26:53,558 [taskExecutor-3] ==> Parameters:
2025-06-17 13:26:53,677 [taskExecutor-3] <== Total: 0
2025-06-17 13:26:53,684 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
2025-06-17 13:26:53,685 [taskExecutor-2] <== Total: 1
2025-06-17 13:26:53,685 [taskExecutor-1] <== Total: 1
2025-06-17 13:26:53,685 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2025-06-17 13:26:53,685 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2025-06-17 13:28:20,867 [http-nio-19120-exec-1] 验证码：QSN3用户输入：QSn3
2025-06-17 13:28:21,433 [http-nio-19120-exec-1] ==> Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2025-06-17 13:28:21,435 [http-nio-19120-exec-1] ==> Parameters: bnsAdmin(String)
2025-06-17 13:28:21,438 [http-nio-19120-exec-1] <== Total: 1
2025-06-17 13:28:21,454 [http-nio-19120-exec-1] ==> 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
2025-06-17 13:28:21,454 [http-nio-19120-exec-1] ==> Parameters: 249(Long)
2025-06-17 13:28:21,539 [http-nio-19120-exec-1] <== Total: 147
2025-06-17 13:28:21,608 [http-nio-19120-exec-1] Authenticated user
2025-06-17 13:28:21,632 [taskExecutor-4] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-17 13:28:21,632 [taskExecutor-4] ==> Parameters: 249(Long), 登陆(String), true(Boolean), null
2025-06-17 13:28:21,657 [taskExecutor-4] <== Updates: 1
2025-06-17 13:28:25,944 [http-nio-19120-exec-3] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2025-06-17 13:28:25,944 [http-nio-19120-exec-3] ==> Parameters: 1(String)
2025-06-17 13:28:25,944 [http-nio-19120-exec-3] <== Total: 0
2025-06-17 13:28:25,974 [http-nio-19120-exec-3] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2025-06-17 13:28:25,975 [http-nio-19120-exec-3] ==> Parameters:
2025-06-17 13:28:25,977 [http-nio-19120-exec-3] <== Total: 4
2025-06-17 13:28:26,026 [http-nio-19120-exec-6] ==> Preparing: SELECT bp.id AS proId,bp.name AS proName FROM bm_project bp WHERE bp.is_active = '1'
2025-06-17 13:28:26,027 [http-nio-19120-exec-6] ==> Parameters:
2025-06-17 13:28:26,029 [http-nio-19120-exec-6] <== Total: 9
2025-06-17 13:28:26,110 [http-nio-19120-exec-1] ==> Preparing: select count(1) as num from ( SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a. proId ) res
2025-06-17 13:28:26,120 [http-nio-19120-exec-1] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String)
2025-06-17 13:28:26,178 [http-nio-19120-exec-1] <== Total: 1
2025-06-17 13:28:26,181 [http-nio-19120-exec-1] ==> Preparing: SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a.proId limit ?, ?
2025-06-17 13:28:26,184 [http-nio-19120-exec-1] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 0(Integer), 10(Integer)
2025-06-17 13:28:26,193 [http-nio-19120-exec-1] <== Total: 10
2025-06-17 13:28:26,196 [http-nio-19120-exec-1] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:28:26,196 [http-nio-19120-exec-1] ==> Parameters: 286(String), 130921196902024835(String)
2025-06-17 13:28:26,199 [http-nio-19120-exec-1] <== Total: 1
2025-06-17 13:28:26,201 [http-nio-19120-exec-1] ==> Preparing:
2025-06-17 13:28:26,287 [http-nio-19120-exec-1] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:28:26,288 [http-nio-19120-exec-1] ==> Parameters: 130921196902024835(String), 286(String)
2025-06-17 13:28:26,290 [http-nio-19120-exec-1] <== Total: 1
2025-06-17 13:28:42,656 [http-nio-19120-exec-8] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2025-06-17 13:28:42,657 [http-nio-19120-exec-8] ==> Parameters: 1(String)
2025-06-17 13:28:42,659 [http-nio-19120-exec-8] <== Total: 0
2025-06-17 13:28:42,661 [http-nio-19120-exec-8] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2025-06-17 13:28:42,661 [http-nio-19120-exec-8] ==> Parameters:
2025-06-17 13:28:42,663 [http-nio-19120-exec-8] <== Total: 4
2025-06-17 13:28:42,677 [http-nio-19120-exec-9] ==> Preparing: SELECT bp.id AS proId,bp.name AS proName FROM bm_project bp WHERE bp.is_active = '1'
2025-06-17 13:28:42,677 [http-nio-19120-exec-9] ==> Parameters:
2025-06-17 13:28:42,681 [http-nio-19120-exec-9] <== Total: 9
2025-06-17 13:28:42,739 [http-nio-19120-exec-6] ==> Preparing: select count(1) as num from ( SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a. proId ) res
2025-06-17 13:28:42,742 [http-nio-19120-exec-6] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String)
2025-06-17 13:28:42,756 [http-nio-19120-exec-6] <== Total: 1
2025-06-17 13:28:42,759 [http-nio-19120-exec-6] ==> Preparing: SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a.proId limit ?, ?
2025-06-17 13:28:42,763 [http-nio-19120-exec-6] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 0(Integer), 10(Integer)
2025-06-17 13:28:42,774 [http-nio-19120-exec-6] <== Total: 10
2025-06-17 13:28:42,776 [http-nio-19120-exec-6] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:28:42,779 [http-nio-19120-exec-6] ==> Parameters: 286(String), 130921196902024835(String)
2025-06-17 13:28:42,783 [http-nio-19120-exec-6] <== Total: 1
2025-06-17 13:28:42,786 [http-nio-19120-exec-6] ==> Preparing:
2025-06-17 13:28:42,795 [http-nio-19120-exec-6] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:28:42,796 [http-nio-19120-exec-6] ==> Parameters: 130921196902024835(String), 286(String)
2025-06-17 13:28:42,798 [http-nio-19120-exec-6] <== Total: 1
2025-06-17 13:33:52,238 [http-nio-19120-exec-9] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2025-06-17 13:33:52,238 [http-nio-19120-exec-9] ==> Parameters: 1(String)
2025-06-17 13:33:52,240 [http-nio-19120-exec-9] <== Total: 0
2025-06-17 13:33:52,241 [http-nio-19120-exec-9] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2025-06-17 13:33:52,241 [http-nio-19120-exec-9] ==> Parameters:
2025-06-17 13:33:52,243 [http-nio-19120-exec-9] <== Total: 4
2025-06-17 13:33:52,252 [http-nio-19120-exec-5] ==> Preparing: SELECT bp.id AS proId,bp.name AS proName FROM bm_project bp WHERE bp.is_active = '1'
2025-06-17 13:33:52,252 [http-nio-19120-exec-5] ==> Parameters:
2025-06-17 13:33:52,255 [http-nio-19120-exec-5] <== Total: 9
2025-06-17 13:33:52,303 [http-nio-19120-exec-3] ==> Preparing: select count(1) as num from ( SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a. proId ) res
2025-06-17 13:33:52,304 [http-nio-19120-exec-3] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String)
2025-06-17 13:33:52,312 [http-nio-19120-exec-3] <== Total: 1
2025-06-17 13:33:52,313 [http-nio-19120-exec-3] ==> Preparing: SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a.proId limit ?, ?
2025-06-17 13:33:52,316 [http-nio-19120-exec-3] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 0(Integer), 10(Integer)
2025-06-17 13:33:52,324 [http-nio-19120-exec-3] <== Total: 10
2025-06-17 13:33:52,326 [http-nio-19120-exec-3] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:33:52,327 [http-nio-19120-exec-3] ==> Parameters: 286(String), 130921196902024835(String)
2025-06-17 13:33:52,328 [http-nio-19120-exec-3] <== Total: 1
2025-06-17 13:33:52,329 [http-nio-19120-exec-3] ==> Preparing:
2025-06-17 13:33:52,333 [http-nio-19120-exec-3] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:33:52,333 [http-nio-19120-exec-3] ==> Parameters: 130921196902024835(String), 286(String)
2025-06-17 13:33:52,335 [http-nio-19120-exec-3] <== Total: 1
2025-06-17 13:34:05,971 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 23724 (E:\work\gz_workspace\hd\hd_real_name\target\classes started by admin in E:\work\gz_workspace\hd\hd_real_name)
2025-06-17 13:34:05,972 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2025-06-17 13:34:05,973 [main] No active profile set, falling back to default profiles: default
2025-06-17 13:34:09,333 [main] Filter 'tokenFilter' configured for use
2025-06-17 13:34:12,104 [main] Started SecurityApplication in 6.648 seconds (JVM running for 9.765)
2025-06-17 13:34:12,109 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2025-06-17 13:34:12,109 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2025-06-17 13:34:12,109 [taskExecutor-3] --------红名单定时器启动------
2025-06-17 13:34:12,268 [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
2025-06-17 13:34:12,270 [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'
2025-06-17 13:34:12,277 [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'
2025-06-17 13:34:12,291 [taskExecutor-2] ==> Parameters:
2025-06-17 13:34:12,291 [taskExecutor-3] ==> Parameters:
2025-06-17 13:34:12,291 [taskExecutor-1] ==> Parameters:
2025-06-17 13:34:12,314 [taskExecutor-3] <== Total: 0
2025-06-17 13:34:12,315 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
2025-06-17 13:34:12,316 [taskExecutor-2] <== Total: 1
2025-06-17 13:34:12,316 [taskExecutor-1] <== Total: 1
2025-06-17 13:34:12,317 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2025-06-17 13:34:12,317 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2025-06-17 13:34:20,418 [http-nio-19120-exec-6] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2025-06-17 13:34:20,419 [http-nio-19120-exec-6] ==> Parameters: 1(String)
2025-06-17 13:34:20,421 [http-nio-19120-exec-6] <== Total: 0
2025-06-17 13:34:20,435 [http-nio-19120-exec-6] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2025-06-17 13:34:20,436 [http-nio-19120-exec-6] ==> Parameters:
2025-06-17 13:34:20,438 [http-nio-19120-exec-6] <== Total: 4
2025-06-17 13:34:20,491 [http-nio-19120-exec-8] ==> Preparing: SELECT bp.id AS proId,bp.name AS proName FROM bm_project bp WHERE bp.is_active = '1'
2025-06-17 13:34:20,492 [http-nio-19120-exec-8] ==> Parameters:
2025-06-17 13:34:20,495 [http-nio-19120-exec-8] <== Total: 9
2025-06-17 13:34:20,568 [http-nio-19120-exec-9] ==> Preparing: select count(1) as num from ( SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a. proId ) res
2025-06-17 13:34:20,570 [http-nio-19120-exec-9] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String)
2025-06-17 13:34:20,580 [http-nio-19120-exec-9] <== Total: 1
2025-06-17 13:34:20,581 [http-nio-19120-exec-9] ==> Preparing: SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a.proId limit ?, ?
2025-06-17 13:34:20,583 [http-nio-19120-exec-9] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 0(Integer), 10(Integer)
2025-06-17 13:34:20,589 [http-nio-19120-exec-9] <== Total: 10
2025-06-17 13:34:24,586 [http-nio-19120-exec-9] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:34:24,588 [http-nio-19120-exec-9] ==> Parameters: 286(String), 130921196902024835(String)
2025-06-17 13:34:24,592 [http-nio-19120-exec-9] <== Total: 1
2025-06-17 13:34:24,601 [http-nio-19120-exec-9] ==> Preparing:
2025-06-17 13:34:51,669 [http-nio-19120-exec-9] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:34:51,670 [http-nio-19120-exec-9] ==> Parameters: 130921196902024835(String), 286(String)
2025-06-17 13:34:51,672 [http-nio-19120-exec-9] <== Total: 1
2025-06-17 13:34:56,011 [http-nio-19120-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2025-06-17 13:34:56,011 [http-nio-19120-exec-1] ==> Parameters: 1(String)
2025-06-17 13:34:56,013 [http-nio-19120-exec-1] <== Total: 0
2025-06-17 13:34:56,013 [http-nio-19120-exec-1] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2025-06-17 13:34:56,014 [http-nio-19120-exec-1] ==> Parameters:
2025-06-17 13:34:56,015 [http-nio-19120-exec-1] <== Total: 4
2025-06-17 13:34:56,024 [http-nio-19120-exec-8] ==> Preparing: SELECT bp.id AS proId,bp.name AS proName FROM bm_project bp WHERE bp.is_active = '1'
2025-06-17 13:34:56,024 [http-nio-19120-exec-8] ==> Parameters:
2025-06-17 13:34:56,026 [http-nio-19120-exec-8] <== Total: 9
2025-06-17 13:34:56,069 [http-nio-19120-exec-9] ==> Preparing: select count(1) as num from ( SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a. proId ) res
2025-06-17 13:34:56,070 [http-nio-19120-exec-9] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String)
2025-06-17 13:34:56,079 [http-nio-19120-exec-9] <== Total: 1
2025-06-17 13:34:56,080 [http-nio-19120-exec-9] ==> Preparing: SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a.proId limit ?, ?
2025-06-17 13:34:56,082 [http-nio-19120-exec-9] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 0(Integer), 10(Integer)
2025-06-17 13:34:56,090 [http-nio-19120-exec-9] <== Total: 10
2025-06-17 13:35:03,862 [http-nio-19120-exec-9] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:35:03,865 [http-nio-19120-exec-9] ==> Parameters: 286(String), 130921196902024835(String)
2025-06-17 13:35:03,873 [http-nio-19120-exec-9] <== Total: 1
2025-06-17 13:35:08,541 [http-nio-19120-exec-9] ==> Preparing:
2025-06-17 13:35:53,979 [http-nio-19120-exec-9] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:35:53,979 [http-nio-19120-exec-9] ==> Parameters: 130921196902024835(String), 286(String)
2025-06-17 13:35:53,981 [http-nio-19120-exec-9] <== Total: 1
2025-06-17 13:35:57,084 [http-nio-19120-exec-3] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2025-06-17 13:35:57,085 [http-nio-19120-exec-3] ==> Parameters: 1(String)
2025-06-17 13:35:57,087 [http-nio-19120-exec-3] <== Total: 0
2025-06-17 13:35:57,088 [http-nio-19120-exec-3] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2025-06-17 13:35:57,089 [http-nio-19120-exec-3] ==> Parameters:
2025-06-17 13:35:57,091 [http-nio-19120-exec-3] <== Total: 4
2025-06-17 13:35:57,098 [http-nio-19120-exec-5] ==> Preparing: SELECT bp.id AS proId,bp.name AS proName FROM bm_project bp WHERE bp.is_active = '1'
2025-06-17 13:35:57,099 [http-nio-19120-exec-5] ==> Parameters:
2025-06-17 13:35:57,101 [http-nio-19120-exec-5] <== Total: 9
2025-06-17 13:35:57,135 [http-nio-19120-exec-8] ==> Preparing: select count(1) as num from ( SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a. proId ) res
2025-06-17 13:35:57,136 [http-nio-19120-exec-8] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String)
2025-06-17 13:35:57,144 [http-nio-19120-exec-8] <== Total: 1
2025-06-17 13:35:57,145 [http-nio-19120-exec-8] ==> Preparing: SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a.proId limit ?, ?
2025-06-17 13:35:57,147 [http-nio-19120-exec-8] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 0(Integer), 10(Integer)
2025-06-17 13:35:57,155 [http-nio-19120-exec-8] <== Total: 10
2025-06-17 13:36:02,572 [http-nio-19120-exec-8] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:36:02,577 [http-nio-19120-exec-8] ==> Parameters: 286(String), 130921196902024835(String)
2025-06-17 13:36:02,583 [http-nio-19120-exec-8] <== Total: 1
2025-06-17 13:36:19,474 [http-nio-19120-exec-8] ==> Preparing:
2025-06-17 13:37:29,927 [http-nio-19120-exec-8] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:37:29,927 [http-nio-19120-exec-8] ==> Parameters: 130921196902024835(String), 286(String)
2025-06-17 13:37:29,930 [http-nio-19120-exec-8] <== Total: 1
2025-06-17 13:37:42,030 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 22800 (E:\work\gz_workspace\hd\hd_real_name\target\classes started by admin in E:\work\gz_workspace\hd\hd_real_name)
2025-06-17 13:37:42,032 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2025-06-17 13:37:42,033 [main] No active profile set, falling back to default profiles: default
2025-06-17 13:37:45,483 [main] Filter 'tokenFilter' configured for use
2025-06-17 13:37:48,172 [main] Started SecurityApplication in 6.806 seconds (JVM running for 9.191)
2025-06-17 13:37:48,175 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2025-06-17 13:37:48,175 [taskExecutor-3] --------红名单定时器启动------
2025-06-17 13:37:48,176 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2025-06-17 13:37:48,347 [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'
2025-06-17 13:37:48,349 [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
2025-06-17 13:37:48,355 [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'
2025-06-17 13:37:48,376 [taskExecutor-1] ==> Parameters:
2025-06-17 13:37:48,376 [taskExecutor-3] ==> Parameters:
2025-06-17 13:37:48,376 [taskExecutor-2] ==> Parameters:
2025-06-17 13:37:48,411 [taskExecutor-3] <== Total: 0
2025-06-17 13:37:48,414 [taskExecutor-3] --------红名单定时器结束,共推数据0条------
2025-06-17 13:37:48,414 [taskExecutor-2] <== Total: 1
2025-06-17 13:37:48,414 [taskExecutor-1] <== Total: 1
2025-06-17 13:37:48,416 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2025-06-17 13:37:48,416 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2025-06-17 13:38:01,848 [http-nio-19120-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2025-06-17 13:38:01,849 [http-nio-19120-exec-1] ==> Parameters: 1(String)
2025-06-17 13:38:01,850 [http-nio-19120-exec-1] <== Total: 0
2025-06-17 13:38:01,864 [http-nio-19120-exec-1] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2025-06-17 13:38:01,865 [http-nio-19120-exec-1] ==> Parameters:
2025-06-17 13:38:01,866 [http-nio-19120-exec-1] <== Total: 4
2025-06-17 13:38:01,919 [http-nio-19120-exec-8] ==> Preparing: SELECT bp.id AS proId,bp.name AS proName FROM bm_project bp WHERE bp.is_active = '1'
2025-06-17 13:38:01,920 [http-nio-19120-exec-8] ==> Parameters:
2025-06-17 13:38:01,922 [http-nio-19120-exec-8] <== Total: 9
2025-06-17 13:38:01,992 [http-nio-19120-exec-4] ==> Preparing: select count(1) as num from ( SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a. proId ) res
2025-06-17 13:38:01,994 [http-nio-19120-exec-4] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String)
2025-06-17 13:38:02,003 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:02,006 [http-nio-19120-exec-4] ==> Preparing: SELECT a.* FROM ( SELECT b.* FROM ( SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) UNION SELECT DISTINCT if(bwah.`NAME` is null,'',bwah.`NAME`) as name,bwah.ID_NUMBER as idNumber, IF(bwah.EXIT_TIME is NULL, 1,0) as isJob, sdd.`name` as postName,pc.org_name as orgName,bp.name as proName,bp.status, bs.SUB_NAME as subName,bst.`NAME` as teamName,pc.id as orgId,bwah.PROJECT_ID as proId,bwah.EIN_TIME FROM bm_worker_attend_history bwah left join bm_worker bw on bw.id_number = bwah.id_number LEFT JOIN sys_dic_detail sdd ON sdd.id=bwah.POST_ID LEFT JOIN bm_subcontractor bs ON bs.id=bwah.SUB_ID LEFT JOIN bm_sub_team bst ON bst.id=bwah.TEAM_ID left join fc_face_contrast ffc on ffc.ID_NUMBER = bwah.ID_NUMBER AND bwah.PROJECT_ID = ffc.PRO_ID LEFT JOIN bm_project bp ON bp.id=bwah.PROJECT_ID LEFT JOIN pm_company pc ON pc.id=bp.company_id WHERE bwah.IS_ACTIVE='1' and bw.IS_ACTIVE='1' and ffc.CURRENT_DAY BETWEEN ? AND ? and IF(bwah.EXIT_TIME IS NOT NULL AND bwah.EXIT_TIME != '',(LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EIN_TIME,10) >= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) <= ? or LEFT(bwah.EIN_TIME,10) <= ? and LEFT(bwah.EXIT_TIME,10) >=? and LEFT(bwah.EXIT_TIME,10) >= ?),LEFT(bwah.EIN_TIME,10) <= ?) )b ORDER BY b.EIN_TIME DESC )a GROUP BY a.idNumber,a.proId limit ?, ?
2025-06-17 13:38:02,008 [http-nio-19120-exec-4] ==> Parameters: 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 2025-06-17(String), 0(Integer), 10(Integer)
2025-06-17 13:38:02,018 [http-nio-19120-exec-4] <== Total: 10
2025-06-17 13:38:08,943 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:08,944 [http-nio-19120-exec-4] ==> Parameters: 286(String), 130921196902024835(String)
2025-06-17 13:38:08,946 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:08,948 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:08,949 [http-nio-19120-exec-4] ==> Parameters: 286(String), 130921196902024835(String), 2025-06-17(String)
2025-06-17 13:38:08,959 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:08,960 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:08,961 [http-nio-19120-exec-4] ==> Parameters: 130921196902024835(String), 286(String)
2025-06-17 13:38:08,962 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:08,963 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:08,965 [http-nio-19120-exec-4] ==> Parameters: 292(String), 13092119710605486X(String)
2025-06-17 13:38:08,966 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:08,967 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:08,968 [http-nio-19120-exec-4] ==> Parameters: 292(String), 13092119710605486X(String), 2025-06-17(String)
2025-06-17 13:38:08,969 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:08,970 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:08,970 [http-nio-19120-exec-4] ==> Parameters: 13092119710605486X(String), 292(String)
2025-06-17 13:38:08,972 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:08,989 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:08,989 [http-nio-19120-exec-4] ==> Parameters: 292(String), 132235198111141614(String)
2025-06-17 13:38:08,991 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:08,992 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:08,993 [http-nio-19120-exec-4] ==> Parameters: 292(String), 132235198111141614(String), 2025-06-17(String)
2025-06-17 13:38:08,995 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:08,997 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:08,997 [http-nio-19120-exec-4] ==> Parameters: 132235198111141614(String), 292(String)
2025-06-17 13:38:08,999 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,000 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:09,001 [http-nio-19120-exec-4] ==> Parameters: 292(String), 132401196903231691(String)
2025-06-17 13:38:09,003 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,003 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:09,004 [http-nio-19120-exec-4] ==> Parameters: 292(String), 132401196903231691(String), 2025-06-17(String)
2025-06-17 13:38:09,006 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:09,007 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:09,007 [http-nio-19120-exec-4] ==> Parameters: 132401196903231691(String), 292(String)
2025-06-17 13:38:09,008 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,010 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:09,010 [http-nio-19120-exec-4] ==> Parameters: 292(String), 132428196505082213(String)
2025-06-17 13:38:09,011 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,012 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:09,013 [http-nio-19120-exec-4] ==> Parameters: 292(String), 132428196505082213(String), 2025-06-17(String)
2025-06-17 13:38:09,015 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:09,015 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:09,016 [http-nio-19120-exec-4] ==> Parameters: 132428196505082213(String), 292(String)
2025-06-17 13:38:09,017 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,018 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:09,019 [http-nio-19120-exec-4] ==> Parameters: 292(String), 132627197611104315(String)
2025-06-17 13:38:09,020 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,021 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:09,022 [http-nio-19120-exec-4] ==> Parameters: 292(String), 132627197611104315(String), 2025-06-17(String)
2025-06-17 13:38:09,023 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:09,024 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:09,024 [http-nio-19120-exec-4] ==> Parameters: 132627197611104315(String), 292(String)
2025-06-17 13:38:09,025 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,027 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:09,028 [http-nio-19120-exec-4] ==> Parameters: 292(String), 140828196609130015(String)
2025-06-17 13:38:09,029 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,030 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:09,031 [http-nio-19120-exec-4] ==> Parameters: 292(String), 140828196609130015(String), 2025-06-17(String)
2025-06-17 13:38:09,032 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:09,033 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:09,034 [http-nio-19120-exec-4] ==> Parameters: 140828196609130015(String), 292(String)
2025-06-17 13:38:09,035 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,036 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:09,037 [http-nio-19120-exec-4] ==> Parameters: 292(String), 140828197601260012(String)
2025-06-17 13:38:09,039 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,040 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:09,041 [http-nio-19120-exec-4] ==> Parameters: 292(String), 140828197601260012(String), 2025-06-17(String)
2025-06-17 13:38:09,042 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:09,044 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:09,045 [http-nio-19120-exec-4] ==> Parameters: 140828197601260012(String), 292(String)
2025-06-17 13:38:09,046 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,047 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:09,048 [http-nio-19120-exec-4] ==> Parameters: 292(String), 141030199603010015(String)
2025-06-17 13:38:09,050 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,051 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:09,051 [http-nio-19120-exec-4] ==> Parameters: 292(String), 141030199603010015(String), 2025-06-17(String)
2025-06-17 13:38:09,053 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:09,054 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:09,055 [http-nio-19120-exec-4] ==> Parameters: 141030199603010015(String), 292(String)
2025-06-17 13:38:09,056 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,057 [http-nio-19120-exec-4] ==> Preparing: SELECT left(bwah.EIN_TIME,10) AS einTime, left(bwah.EXIT_TIME,10) AS exitTime, bwah.ID_NUMBER AS idNumber FROM bm_worker_attend_history bwah WHERE bwah.PROJECT_ID = ? AND bwah.ID_NUMBER = ? ORDER BY bwah.EIN_TIME asc
2025-06-17 13:38:09,058 [http-nio-19120-exec-4] ==> Parameters: 292(String), 142126197102102918(String)
2025-06-17 13:38:09,061 [http-nio-19120-exec-4] <== Total: 1
2025-06-17 13:38:09,062 [http-nio-19120-exec-4] ==> Preparing: select bwr.ID_NUMBER, ffc.WORK_HOURS as kqCounts, ffc.OVER_HOURS as jbCounts, bwr.PROJECT_ID as proId from bm_worker_record bwr LEFT JOIN fc_face_contrast ffc ON ffc.ID_NUMBER = bwr.ID_NUMBER where ffc.PRO_ID = ? and bwr.ID_NUMBER = ? and ffc.CURRENT_DAY = ? and bwr.IS_ACTIVE = '1' AND bwr.examine_status = '1' AND ffc.AUDIT_STATUS = '1' AND ffc.is_active = '1' order by ffc.ADD_TIME desc limit 1
2025-06-17 13:38:09,063 [http-nio-19120-exec-4] ==> Parameters: 292(String), 142126197102102918(String), 2025-06-17(String)
2025-06-17 13:38:09,065 [http-nio-19120-exec-4] <== Total: 0
2025-06-17 13:38:09,066 [http-nio-19120-exec-4] ==> Preparing: select EIN_TIME as einTime,EXIT_TIME as exitTime from bm_worker_attend_history where ID_NUMBER = ? and PROJECT_ID = ? order by EIN_TIME desc -- limit 1
2025-06-17 13:38:09,066 [http-nio-19120-exec-4] ==> Parameters: 142126197102102918(String), 292(String)
2025-06-17 13:38:09,069 [http-nio-19120-exec-4] <== Total: 1
Reference in New Issue View Git Blame Copy Permalink