2025-06-26 17:04:23,506 [main] Starting RnamaApplication using Java 1.8.0_322 on BNS-BD19 with PID 16588 (E:\work\gz_workspace\smz\gzRealNameAndroidManageApp\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameAndroidManageApp)
2025-06-26 17:04:23,524 [main] Running with Spring Boot v2.5.4, Spring v5.3.9
2025-06-26 17:04:23,524 [main] No active profile set, falling back to default profiles: default
2025-06-26 17:04:27,641 [main] Filter 'tokenFilter' configured for use
2025-06-26 17:04:29,455 [main] Started RnamaApplication in 6.635 seconds (JVM running for 9.288)
2025-06-26 17:09:42,233 [main] Starting RnamaApplication using Java 1.8.0_322 on BNS-BD19 with PID 16312 (E:\work\gz_workspace\smz\gzRealNameAndroidManageApp\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameAndroidManageApp)
2025-06-26 17:09:42,235 [main] Running with Spring Boot v2.5.4, Spring v5.3.9
2025-06-26 17:09:42,235 [main] No active profile set, falling back to default profiles: default
2025-06-26 17:09:46,391 [main] Filter 'tokenFilter' configured for use
2025-06-26 17:09:48,403 [main] Started RnamaApplication in 6.722 seconds (JVM running for 8.777)
2025-06-26 17:15:33,817 [http-nio-1919-exec-5] ==>  Preparing: select su.id,su.username,su.loginname,su.phone, CASE WHEN sr.type like concat('%','3','%') THEN '3' WHEN sr.type like concat('%','4','%') THEN '4' ELSE '' END as type, su.role_id as role,sr.name as roleName,su.org_id as orgId,su.pro_id as proId,su.sub_id as subId, su.post_id as postId,su.face_photo as facePhoto,su.face_feature as faceFeature,su.examine_status as examineStatus from sys_user su left join sys_role sr on su.role_id = sr.id where su.phone = ? and su.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:15:33,844 [http-nio-1919-exec-5] ==> Parameters: 15955147005(String)
2025-06-26 17:15:34,010 [http-nio-1919-exec-5] <==      Total: 0
2025-06-26 17:15:40,364 [http-nio-1919-exec-4] ==>  Preparing: select su.id,su.username,su.loginname,su.phone, CASE WHEN sr.type like concat('%','3','%') THEN '3' WHEN sr.type like concat('%','4','%') THEN '4' ELSE '' END as type, su.role_id as role,sr.name as roleName,su.org_id as orgId,su.pro_id as proId,su.sub_id as subId, su.post_id as postId,su.face_photo as facePhoto,su.face_feature as faceFeature,su.examine_status as examineStatus from sys_user su left join sys_role sr on su.role_id = sr.id where su.phone = ? and su.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:15:40,366 [http-nio-1919-exec-4] ==> Parameters: 15955147005(String)
2025-06-26 17:15:40,368 [http-nio-1919-exec-4] <==      Total: 0
2025-06-26 17:15:53,349 [http-nio-1919-exec-6] ==>  Preparing: select su.id,su.username,su.loginname,su.phone, CASE WHEN sr.type like concat('%','3','%') THEN '3' WHEN sr.type like concat('%','4','%') THEN '4' ELSE '' END as type, su.role_id as role,sr.name as roleName,su.org_id as orgId,su.pro_id as proId,su.sub_id as subId, su.post_id as postId,su.face_photo as facePhoto,su.face_feature as faceFeature,su.examine_status as examineStatus from sys_user su left join sys_role sr on su.role_id = sr.id where su.phone = ? and su.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:15:53,350 [http-nio-1919-exec-6] ==> Parameters: 15955147005(String)
2025-06-26 17:15:53,353 [http-nio-1919-exec-6] <==      Total: 0
2025-06-26 17:16:04,436 [http-nio-1919-exec-9] ==>  Preparing: select su.id,su.username,su.loginname,su.phone, CASE WHEN sr.type like concat('%','3','%') THEN '3' WHEN sr.type like concat('%','4','%') THEN '4' ELSE '' END as type, su.role_id as role,sr.name as roleName,su.org_id as orgId,su.pro_id as proId,su.sub_id as subId, su.post_id as postId,su.face_photo as facePhoto,su.face_feature as faceFeature,su.examine_status as examineStatus from sys_user su left join sys_role sr on su.role_id = sr.id where su.phone = ? and su.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:16:04,437 [http-nio-1919-exec-9] ==> Parameters: 15955147005(String)
2025-06-26 17:16:04,440 [http-nio-1919-exec-9] <==      Total: 0
2025-06-26 17:18:16,903 [http-nio-1919-exec-10] ==>  Preparing: select su.id,su.username,su.loginname,su.phone, CASE WHEN sr.type like concat('%','3','%') THEN '3' WHEN sr.type like concat('%','4','%') THEN '4' ELSE '' END as type, su.role_id as role,sr.name as roleName,su.org_id as orgId,su.pro_id as proId,su.sub_id as subId, su.post_id as postId,su.face_photo as facePhoto,su.face_feature as faceFeature,su.examine_status as examineStatus from sys_user su left join sys_role sr on su.role_id = sr.id where su.phone = ? and su.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:18:16,904 [http-nio-1919-exec-10] ==> Parameters: 15955147009(String)
2025-06-26 17:18:16,910 [http-nio-1919-exec-10] <==      Total: 1
2025-06-26 17:18:44,415 [http-nio-1919-exec-1] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:18:44,416 [http-nio-1919-exec-1] ==> Parameters: 15955147009(String)
2025-06-26 17:18:44,419 [http-nio-1919-exec-1] <==      Total: 1
2025-06-26 17:18:44,419 [http-nio-1919-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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:18:44,420 [http-nio-1919-exec-1] ==> Parameters: 2168(String)
2025-06-26 17:18:44,471 [http-nio-1919-exec-1] <==      Total: 5
2025-06-26 17:18:44,547 [http-nio-1919-exec-1] Authentication failed: password does not match stored value
2025-06-26 17:18:44,628 [http-nio-1919-exec-1] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:18:44,629 [http-nio-1919-exec-1] ==> Parameters: 15955147009(String)
2025-06-26 17:18:44,631 [http-nio-1919-exec-1] <==      Total: 1
2025-06-26 17:18:44,633 [http-nio-1919-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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:18:44,633 [http-nio-1919-exec-1] ==> Parameters: 2168(String)
2025-06-26 17:18:44,637 [http-nio-1919-exec-1] <==      Total: 5
2025-06-26 17:19:59,101 [http-nio-1919-exec-5] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:19:59,117 [http-nio-1919-exec-5] ==> Parameters: 15955147009(String)
2025-06-26 17:19:59,117 [http-nio-1919-exec-5] <==      Total: 1
2025-06-26 17:19:59,117 [http-nio-1919-exec-5] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:19:59,117 [http-nio-1919-exec-5] ==> Parameters: 2168(String)
2025-06-26 17:19:59,124 [http-nio-1919-exec-5] <==      Total: 5
2025-06-26 17:19:59,204 [http-nio-1919-exec-5] Authentication failed: password does not match stored value
2025-06-26 17:19:59,205 [http-nio-1919-exec-5] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:19:59,205 [http-nio-1919-exec-5] ==> Parameters: 15955147009(String)
2025-06-26 17:19:59,208 [http-nio-1919-exec-5] <==      Total: 1
2025-06-26 17:19:59,209 [http-nio-1919-exec-5] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:19:59,209 [http-nio-1919-exec-5] ==> Parameters: 2168(String)
2025-06-26 17:19:59,210 [http-nio-1919-exec-5] <==      Total: 5
2025-06-26 17:20:09,539 [http-nio-1919-exec-4] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:20:09,539 [http-nio-1919-exec-4] ==> Parameters: 15955147009(String)
2025-06-26 17:20:09,554 [http-nio-1919-exec-4] <==      Total: 1
2025-06-26 17:20:09,554 [http-nio-1919-exec-4] ==>  Preparing: SELECT DISTINCT p.* FROM sys_permission p INNER JOIN sys_role_permission rp ON p.id = rp.permissionId INNER JOIN sys_role_user ru ON ru.roleId = rp.roleId WHERE ru.userId = ? and p.is_active = '1' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:20:09,554 [http-nio-1919-exec-4] ==> Parameters: 2168(String)
2025-06-26 17:20:09,554 [http-nio-1919-exec-4] <==      Total: 5
2025-06-26 17:20:09,632 [http-nio-1919-exec-4] Authentication failed: password does not match stored value
2025-06-26 17:20:09,632 [http-nio-1919-exec-4] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:20:09,632 [http-nio-1919-exec-4] ==> Parameters: 15955147009(String)
2025-06-26 17:20:09,632 [http-nio-1919-exec-4] <==      Total: 1
2025-06-26 17:20:09,638 [http-nio-1919-exec-4] ==>  Preparing: SELECT DISTINCT p.* FROM sys_permission p INNER JOIN sys_role_permission rp ON p.id = rp.permissionId INNER JOIN sys_role_user ru ON ru.roleId = rp.roleId WHERE ru.userId = ? and p.is_active = '1' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:20:09,638 [http-nio-1919-exec-4] ==> Parameters: 2168(String)
2025-06-26 17:20:09,638 [http-nio-1919-exec-4] <==      Total: 5
2025-06-26 17:26:51,447 [http-nio-1919-exec-7] ==>  Preparing: select su.id,su.username,su.loginname,su.phone, CASE WHEN sr.type like concat('%','3','%') THEN '3' WHEN sr.type like concat('%','4','%') THEN '4' ELSE '' END as type, su.role_id as role,sr.name as roleName,su.org_id as orgId,su.pro_id as proId,su.sub_id as subId, su.post_id as postId,su.face_photo as facePhoto,su.face_feature as faceFeature,su.examine_status as examineStatus from sys_user su left join sys_role sr on su.role_id = sr.id where su.phone = ? and su.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:26:51,452 [http-nio-1919-exec-7] ==> Parameters: 15955147009(String)
2025-06-26 17:26:51,458 [http-nio-1919-exec-7] <==      Total: 1
2025-06-26 17:27:14,945 [http-nio-1919-exec-8] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:14,945 [http-nio-1919-exec-8] ==> Parameters: 15955147009(String)
2025-06-26 17:27:14,961 [http-nio-1919-exec-8] <==      Total: 1
2025-06-26 17:27:14,961 [http-nio-1919-exec-8] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:14,961 [http-nio-1919-exec-8] ==> Parameters: 2168(String)
2025-06-26 17:27:14,961 [http-nio-1919-exec-8] <==      Total: 5
2025-06-26 17:27:15,071 [http-nio-1919-exec-8] Authenticated user
2025-06-26 17:27:16,226 [http-nio-1919-exec-10] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:16,226 [http-nio-1919-exec-10] ==> Parameters: 15955147009(String)
2025-06-26 17:27:16,226 [http-nio-1919-exec-10] <==      Total: 1
2025-06-26 17:27:16,242 [http-nio-1919-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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:16,242 [http-nio-1919-exec-10] ==> Parameters: 2168(String)
2025-06-26 17:27:16,246 [http-nio-1919-exec-10] <==      Total: 5
2025-06-26 17:27:16,257 [http-nio-1919-exec-10] ==>  Preparing: insert into app_login_audit(USER_ID,DEVICE_ID,DEVICE_MODEL,ANDROID_VERSION,APP_VERSION,LOGIN_DATE,LOGIN_TIME,LOGIN_TYPE) values(?,?,?,?,?,?,?,?)
2025-06-26 17:27:16,257 [http-nio-1919-exec-10] ==> Parameters: 2168(String), e5021e8b99ac49d4bcb2fcde9e13656b(String), Redmi-M2012K11AC(String), 13(String), 25(String), 2025-06-26(String), 2025-06-26 17:27:16(String), 1(String)
2025-06-26 17:27:16,273 [http-nio-1919-exec-10] <==    Updates: 1
2025-06-26 17:27:16,368 [http-nio-1919-exec-1] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:16,368 [http-nio-1919-exec-1] ==> Parameters: 15955147009(String)
2025-06-26 17:27:16,384 [http-nio-1919-exec-1] <==      Total: 1
2025-06-26 17:27:16,384 [http-nio-1919-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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:16,384 [http-nio-1919-exec-1] ==> Parameters: 2168(String)
2025-06-26 17:27:16,384 [http-nio-1919-exec-1] <==      Total: 5
2025-06-26 17:27:16,447 [http-nio-1919-exec-1] ==>  Preparing: select bw.ID_NUMBER as idNumber, bw.NAME as name, bw.SEX as gender,o.name as orgName, sdd.id as postId,sdd.name as postName,bs.id as subId,bs.NAME as subName,bp.id as proId, front.PHOTO_PATH as frontPhoto,back.PHOTO_PATH as backPhoto,aoto.PHOTO_PATH as aotoPhoto, face.PHOTO_PATH as facePhoto,face.FACE_FEATURES as faceFeature,bw.phone as phone, bwr.EIN_TIME as einTime,bw.address,bw.is_twins as isTwins FROM bm_worker bw LEFT JOIN bm_worker_photo front ON front.ID_NUMBER = bw.ID_NUMBER and front.PHOTO_TYPE = 1 LEFT JOIN bm_worker_photo back ON back.ID_NUMBER = bw.ID_NUMBER and back.PHOTO_TYPE = 2 LEFT JOIN bm_worker_photo face ON face.ID_NUMBER = bw.ID_NUMBER and face.PHOTO_TYPE = 3 LEFT JOIN bm_worker_photo aoto ON aoto.ID_NUMBER = bw.ID_NUMBER and aoto.PHOTO_TYPE = 5 LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = bw.ID_NUMBER LEFT JOIN pm_organization o on bwr.ORG_ID = o.id LEFT JOIN bm_subcontractor bs ON bs.ID = bwr.SUB_ID LEFT JOIN bm_project bp ON bp.ID = bwr.PROJECT_ID LEFT JOIN sys_dic_detail sdd on sdd.id = bwr.POST_ID WHERE bw.IS_ACTIVE = '1' AND bwr.IS_ACTIVE = '1' AND bs.IS_ACTIVE = '1' AND bp.IS_ACTIVE = '1' AND bwr.PROJECT_ID = ? and ein_status = '1' and bwr.examine_status = '1' and face.FACE_FEATURES is not null GROUP BY bw.ID_NUMBER ORDER BY bw.ID_NUMBER ASC
2025-06-26 17:27:16,448 [http-nio-1919-exec-1] ==> Parameters: 287(String)
2025-06-26 17:27:16,494 [http-nio-1919-exec-1] <==      Total: 1
2025-06-26 17:27:17,157 [http-nio-1919-exec-2] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:17,157 [http-nio-1919-exec-2] ==> Parameters: 15955147009(String)
2025-06-26 17:27:17,164 [http-nio-1919-exec-2] <==      Total: 1
2025-06-26 17:27:17,164 [http-nio-1919-exec-2] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:17,164 [http-nio-1919-exec-2] ==> Parameters: 2168(String)
2025-06-26 17:27:17,164 [http-nio-1919-exec-2] <==      Total: 5
2025-06-26 17:27:17,240 [http-nio-1919-exec-2] ==>  Preparing: select type as orgType,company_id as companyId from pm_organization where id = ?
2025-06-26 17:27:17,241 [http-nio-1919-exec-2] ==> Parameters: 457(String)
2025-06-26 17:27:17,241 [http-nio-1919-exec-2] <==      Total: 1
2025-06-26 17:27:17,273 [http-nio-1919-exec-2] ==>  Preparing: select p.id,name,ABBREVIATION,org_id as orgId,PRO_TYPE as proType,lon,lat,UPDATE_TIME as updateTime,IS_ACTIVE as isActive from bm_project p where p.id = ? and status = '在建' and is_active = 1
2025-06-26 17:27:17,287 [http-nio-1919-exec-2] ==> Parameters: 287(String)
2025-06-26 17:27:17,289 [http-nio-1919-exec-2] <==      Total: 1
2025-06-26 17:27:17,337 [task-1] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:17,344 [task-1] ==> Parameters: 2168(String), 下载工程数据(String), true(Boolean), {"type":"3","orgId":"457","subId":"-1","id":"287"}(String)
2025-06-26 17:27:17,352 [task-1] <==    Updates: 1
2025-06-26 17:27:17,382 [http-nio-1919-exec-3] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:17,382 [http-nio-1919-exec-3] ==> Parameters: 15955147009(String)
2025-06-26 17:27:17,384 [http-nio-1919-exec-3] <==      Total: 1
2025-06-26 17:27:17,384 [http-nio-1919-exec-3] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:17,384 [http-nio-1919-exec-3] ==> Parameters: 2168(String)
2025-06-26 17:27:17,384 [http-nio-1919-exec-3] <==      Total: 5
2025-06-26 17:27:17,402 [http-nio-1919-exec-3] ==>  Preparing: select id,name,lon,lat,UPDATE_TIME as updateTime,pro_id as proId,order_num as sort,is_active as isActive from bm_work_scene where pro_id = ? and is_active = 1
2025-06-26 17:27:17,402 [http-nio-1919-exec-3] ==> Parameters: 287(String)
2025-06-26 17:27:17,404 [http-nio-1919-exec-3] <==      Total: 0
2025-06-26 17:27:17,406 [task-2] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:17,407 [task-2] ==> Parameters: 2168(String), 下载作业现场信息(String), true(Boolean), {"proId":"287"}(String)
2025-06-26 17:27:17,410 [task-2] <==    Updates: 1
2025-06-26 17:27:17,429 [http-nio-1919-exec-5] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:17,429 [http-nio-1919-exec-5] ==> Parameters: 15955147009(String)
2025-06-26 17:27:17,429 [http-nio-1919-exec-5] <==      Total: 1
2025-06-26 17:27:17,429 [http-nio-1919-exec-5] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:17,429 [http-nio-1919-exec-5] ==> Parameters: 2168(String)
2025-06-26 17:27:17,445 [http-nio-1919-exec-5] <==      Total: 5
2025-06-26 17:27:17,445 [http-nio-1919-exec-5] ==>  Preparing: select id,name,UPDATE_TIME as updateTime,is_active as isActive from pm_organization where is_active = 1
2025-06-26 17:27:17,445 [http-nio-1919-exec-5] ==> Parameters: 
2025-06-26 17:27:17,445 [http-nio-1919-exec-5] <==      Total: 21
2025-06-26 17:27:17,445 [task-3] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:17,458 [task-3] ==> Parameters: 2168(String), 下载组织(String), true(Boolean), null
2025-06-26 17:27:17,461 [task-3] <==    Updates: 1
2025-06-26 17:27:17,556 [http-nio-1919-exec-4] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:17,556 [http-nio-1919-exec-4] ==> Parameters: 15955147009(String)
2025-06-26 17:27:17,560 [http-nio-1919-exec-4] <==      Total: 1
2025-06-26 17:27:17,561 [http-nio-1919-exec-4] ==>  Preparing: SELECT DISTINCT p.* FROM sys_permission p INNER JOIN sys_role_permission rp ON p.id = rp.permissionId INNER JOIN sys_role_user ru ON ru.roleId = rp.roleId WHERE ru.userId = ? and p.is_active = '1' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:17,561 [http-nio-1919-exec-4] ==> Parameters: 2168(String)
2025-06-26 17:27:17,565 [http-nio-1919-exec-4] <==      Total: 5
2025-06-26 17:27:17,569 [http-nio-1919-exec-4] ==>  Preparing: -- select id,sub_name as name,represent,re_contact as reContact,id_number as idNumber, -- UPDATE_TIME as updateTime,is_active as isActive, -- SIGNATURE_URL as signUrl,SEAL_URL as sealUrl, -- ADDRESS -- from bm_subcontractor where is_active = 1 and AUDIT_RESULT = 1 select bs.id,sub_name as name,represent,re_contact as reContact,id_number as idNumber, UPDATE_TIME as updateTime,is_active as isActive, SIGNATURE_URL as signUrl,SEAL_URL as sealUrl, ADDRESS,bspr.proId from bm_subcontractor bs left join ( select sub_id as subId,GROUP_CONCAT(IFNULL(pro_id,'0')) as proId from bm_sub_pro_relation GROUP BY sub_id ) bspr on bspr.subId = bs.id where is_active = 1 and AUDIT_RESULT = 1 and bs.SUB_NAME is not null and proId is not null
2025-06-26 17:27:17,569 [http-nio-1919-exec-4] ==> Parameters: 
2025-06-26 17:27:17,574 [http-nio-1919-exec-4] <==      Total: 3
2025-06-26 17:27:17,576 [task-4] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:17,577 [task-4] ==> Parameters: 2168(String), 下载分包商(String), true(Boolean), null
2025-06-26 17:27:17,578 [task-4] <==    Updates: 1
2025-06-26 17:27:17,625 [http-nio-1919-exec-6] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:17,627 [http-nio-1919-exec-6] ==> Parameters: 15955147009(String)
2025-06-26 17:27:17,630 [http-nio-1919-exec-6] <==      Total: 1
2025-06-26 17:27:17,631 [http-nio-1919-exec-6] ==>  Preparing: SELECT DISTINCT p.* FROM sys_permission p INNER JOIN sys_role_permission rp ON p.id = rp.permissionId INNER JOIN sys_role_user ru ON ru.roleId = rp.roleId WHERE ru.userId = ? and p.is_active = '1' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:17,631 [http-nio-1919-exec-6] ==> Parameters: 2168(String)
2025-06-26 17:27:17,632 [http-nio-1919-exec-6] <==      Total: 5
2025-06-26 17:27:17,640 [http-nio-1919-exec-6] ==>  Preparing: select id,name,sub_id as subId,ein_time as einTime,exit_time as exitTime,UPDATE_TIME as updateTime,is_active as isActive from bm_sub_team where is_active = 1
2025-06-26 17:27:17,640 [http-nio-1919-exec-6] ==> Parameters: 
2025-06-26 17:27:17,640 [http-nio-1919-exec-6] <==      Total: 7
2025-06-26 17:27:17,640 [task-5] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:17,640 [task-5] ==> Parameters: 2168(String), 下载班组(String), true(Boolean), {}(String)
2025-06-26 17:27:17,648 [task-5] <==    Updates: 1
2025-06-26 17:27:17,697 [http-nio-1919-exec-9] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:17,712 [http-nio-1919-exec-9] ==> Parameters: 15955147009(String)
2025-06-26 17:27:17,712 [http-nio-1919-exec-9] <==      Total: 1
2025-06-26 17:27:17,712 [http-nio-1919-exec-9] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:17,712 [http-nio-1919-exec-9] ==> Parameters: 2168(String)
2025-06-26 17:27:17,712 [http-nio-1919-exec-9] <==      Total: 5
2025-06-26 17:27:17,712 [http-nio-1919-exec-9] ==>  Preparing: select sdd.id,sdd.name as type,sdt.name as code,sdd.is_active as isActive from sys_dic_detail sdd left join sys_dic_type sdt on sdt.id = sdd.dic_type where sdd.is_active = 1 and sdt.is_active = 1
2025-06-26 17:27:17,712 [http-nio-1919-exec-9] ==> Parameters: 
2025-06-26 17:27:17,741 [http-nio-1919-exec-9] <==      Total: 283
2025-06-26 17:27:17,741 [task-6] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:17,741 [task-6] ==> Parameters: 2168(String), 下载基础类型(String), true(Boolean), null
2025-06-26 17:27:17,749 [task-6] <==    Updates: 1
2025-06-26 17:27:18,395 [http-nio-1919-exec-7] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:18,396 [http-nio-1919-exec-7] ==> Parameters: 15955147009(String)
2025-06-26 17:27:18,398 [http-nio-1919-exec-7] <==      Total: 1
2025-06-26 17:27:18,404 [http-nio-1919-exec-7] ==>  Preparing: SELECT DISTINCT p.* FROM sys_permission p INNER JOIN sys_role_permission rp ON p.id = rp.permissionId INNER JOIN sys_role_user ru ON ru.roleId = rp.roleId WHERE ru.userId = ? and p.is_active = '1' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:18,404 [http-nio-1919-exec-7] ==> Parameters: 2168(String)
2025-06-26 17:27:18,410 [http-nio-1919-exec-7] <==      Total: 5
2025-06-26 17:27:18,417 [http-nio-1919-exec-7] ==>  Preparing: select type as orgType,company_id as companyId from pm_organization where id = ?
2025-06-26 17:27:18,417 [http-nio-1919-exec-7] ==> Parameters: 457(String)
2025-06-26 17:27:18,421 [http-nio-1919-exec-7] <==      Total: 1
2025-06-26 17:27:18,421 [http-nio-1919-exec-7] ==>  Preparing: select p.id,name,ABBREVIATION,org_id as orgId,PRO_TYPE as proType,lon,lat,UPDATE_TIME as updateTime,IS_ACTIVE as isActive from bm_project p where p.id = ? and status = '在建' and is_active = 1
2025-06-26 17:27:18,424 [http-nio-1919-exec-7] ==> Parameters: 287(String)
2025-06-26 17:27:18,426 [http-nio-1919-exec-7] <==      Total: 1
2025-06-26 17:27:18,428 [task-7] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:18,428 [task-7] ==> Parameters: 2168(String), 下载工程数据(String), true(Boolean), {"type":"3","orgId":"457","subId":"-1","id":"287"}(String)
2025-06-26 17:27:18,429 [task-7] <==    Updates: 1
2025-06-26 17:27:18,445 [http-nio-1919-exec-8] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:18,445 [http-nio-1919-exec-8] ==> Parameters: 15955147009(String)
2025-06-26 17:27:18,445 [http-nio-1919-exec-8] <==      Total: 1
2025-06-26 17:27:18,445 [http-nio-1919-exec-8] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:18,445 [http-nio-1919-exec-8] ==> Parameters: 2168(String)
2025-06-26 17:27:18,461 [http-nio-1919-exec-8] <==      Total: 5
2025-06-26 17:27:18,464 [http-nio-1919-exec-8] ==>  Preparing: select id,name,lon,lat,UPDATE_TIME as updateTime,pro_id as proId,order_num as sort,is_active as isActive from bm_work_scene where pro_id = ? and is_active = 1
2025-06-26 17:27:18,464 [http-nio-1919-exec-8] ==> Parameters: 287(String)
2025-06-26 17:27:18,466 [http-nio-1919-exec-8] <==      Total: 0
2025-06-26 17:27:18,466 [task-8] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:18,466 [task-8] ==> Parameters: 2168(String), 下载作业现场信息(String), true(Boolean), {"proId":"287"}(String)
2025-06-26 17:27:18,466 [task-8] <==    Updates: 1
2025-06-26 17:27:18,523 [http-nio-1919-exec-10] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:18,523 [http-nio-1919-exec-10] ==> Parameters: 15955147009(String)
2025-06-26 17:27:18,523 [http-nio-1919-exec-10] <==      Total: 1
2025-06-26 17:27:18,523 [http-nio-1919-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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:18,523 [http-nio-1919-exec-10] ==> Parameters: 2168(String)
2025-06-26 17:27:18,523 [http-nio-1919-exec-10] <==      Total: 5
2025-06-26 17:27:18,523 [http-nio-1919-exec-10] ==>  Preparing: select id,name,UPDATE_TIME as updateTime,is_active as isActive from pm_organization where is_active = 1
2025-06-26 17:27:18,523 [http-nio-1919-exec-10] ==> Parameters: 
2025-06-26 17:27:18,539 [http-nio-1919-exec-10] <==      Total: 21
2025-06-26 17:27:18,539 [task-1] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:18,539 [task-1] ==> Parameters: 2168(String), 下载组织(String), true(Boolean), null
2025-06-26 17:27:18,539 [task-1] <==    Updates: 1
2025-06-26 17:27:18,632 [http-nio-1919-exec-1] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:18,632 [http-nio-1919-exec-1] ==> Parameters: 15955147009(String)
2025-06-26 17:27:18,632 [http-nio-1919-exec-1] <==      Total: 1
2025-06-26 17:27:18,632 [http-nio-1919-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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:18,648 [http-nio-1919-exec-1] ==> Parameters: 2168(String)
2025-06-26 17:27:18,648 [http-nio-1919-exec-1] <==      Total: 5
2025-06-26 17:27:18,653 [http-nio-1919-exec-1] ==>  Preparing: -- select id,sub_name as name,represent,re_contact as reContact,id_number as idNumber, -- UPDATE_TIME as updateTime,is_active as isActive, -- SIGNATURE_URL as signUrl,SEAL_URL as sealUrl, -- ADDRESS -- from bm_subcontractor where is_active = 1 and AUDIT_RESULT = 1 select bs.id,sub_name as name,represent,re_contact as reContact,id_number as idNumber, UPDATE_TIME as updateTime,is_active as isActive, SIGNATURE_URL as signUrl,SEAL_URL as sealUrl, ADDRESS,bspr.proId from bm_subcontractor bs left join ( select sub_id as subId,GROUP_CONCAT(IFNULL(pro_id,'0')) as proId from bm_sub_pro_relation GROUP BY sub_id ) bspr on bspr.subId = bs.id where is_active = 1 and AUDIT_RESULT = 1 and bs.SUB_NAME is not null and proId is not null
2025-06-26 17:27:18,653 [http-nio-1919-exec-1] ==> Parameters: 
2025-06-26 17:27:18,660 [http-nio-1919-exec-1] <==      Total: 3
2025-06-26 17:27:18,660 [task-2] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:18,660 [task-2] ==> Parameters: 2168(String), 下载分包商(String), true(Boolean), null
2025-06-26 17:27:18,664 [task-2] <==    Updates: 1
2025-06-26 17:27:18,696 [http-nio-1919-exec-2] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:18,696 [http-nio-1919-exec-2] ==> Parameters: 15955147009(String)
2025-06-26 17:27:18,701 [http-nio-1919-exec-2] <==      Total: 1
2025-06-26 17:27:18,701 [http-nio-1919-exec-2] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:18,701 [http-nio-1919-exec-2] ==> Parameters: 2168(String)
2025-06-26 17:27:18,701 [http-nio-1919-exec-2] <==      Total: 5
2025-06-26 17:27:18,701 [http-nio-1919-exec-2] ==>  Preparing: select id,name,sub_id as subId,ein_time as einTime,exit_time as exitTime,UPDATE_TIME as updateTime,is_active as isActive from bm_sub_team where is_active = 1
2025-06-26 17:27:18,701 [http-nio-1919-exec-2] ==> Parameters: 
2025-06-26 17:27:18,715 [http-nio-1919-exec-2] <==      Total: 7
2025-06-26 17:27:18,716 [task-3] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:18,716 [task-3] ==> Parameters: 2168(String), 下载班组(String), true(Boolean), {}(String)
2025-06-26 17:27:18,719 [task-3] <==    Updates: 1
2025-06-26 17:27:18,742 [http-nio-1919-exec-3] ==>  Preparing: select t.id,username,password,phone, CASE WHEN sr.TYPE like concat('%','3','%') THEN '3' WHEN sr.TYPE like concat('%','4','%') THEN '4' ELSE '' END as type,t.post_id as postId, org_id as orgId,role_id as role,sr.name as roleName, pro_id as proId,sub_id as subId, face_photo as facePhoto,face_feature as faceFeature from sys_user t left join sys_role sr on t.role_id = sr.id where t.phone = ? and t.is_active = '1' and (sr.TYPE like concat('%','3','%') or sr.TYPE like concat('%','4','%')) and sr.is_active = 1
2025-06-26 17:27:18,742 [http-nio-1919-exec-3] ==> Parameters: 15955147009(String)
2025-06-26 17:27:18,758 [http-nio-1919-exec-3] <==      Total: 1
2025-06-26 17:27:18,758 [http-nio-1919-exec-3] ==>  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' and p.permission_type = 'APP' and p.parentId != 0 order by p.sort
2025-06-26 17:27:18,758 [http-nio-1919-exec-3] ==> Parameters: 2168(String)
2025-06-26 17:27:18,760 [http-nio-1919-exec-3] <==      Total: 5
2025-06-26 17:27:18,760 [http-nio-1919-exec-3] ==>  Preparing: select sdd.id,sdd.name as type,sdt.name as code,sdd.is_active as isActive from sys_dic_detail sdd left join sys_dic_type sdt on sdt.id = sdd.dic_type where sdd.is_active = 1 and sdt.is_active = 1
2025-06-26 17:27:18,760 [http-nio-1919-exec-3] ==> Parameters: 
2025-06-26 17:27:18,773 [http-nio-1919-exec-3] <==      Total: 283
2025-06-26 17:27:18,773 [task-4] ==>  Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2025-06-26 17:27:18,773 [task-4] ==> Parameters: 2168(String), 下载基础类型(String), true(Boolean), null
2025-06-26 17:27:18,773 [task-4] <==    Updates: 1
