Inicio Explorar Axuda
Iniciar sesión
lql
/
fj-dc
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: f88c47f6ea
Ramas Etiquetas
fj-dc
/
logs
/
dc-api-sql.log

dc-api-sql.log 49 KB
Histórico Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485 
  1. 2026-06-29 00:06:13.156 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    2. 

  2. 2026-06-29 00:06:13.159 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    3. 

  3. 2026-06-29 00:06:13.244 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    4. 

  4. 2026-06-29 00:06:13.245 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.insuranceCompanyCountyDetail - ==>  Preparing: SELECT p.AD_CODE AS adCode, distOrg.ORG_NM AS county, COUNT(DISTINCT r.PROJECT_ID) AS insuredTotal, -- 原占比：当前保险公司区县项目 / 全市该保险公司总项目 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp ON rr.PROJECT_ID = pp.ID WHERE rr.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr.DATA_STAT = '0' AND pp.DATA_STAT = '0' AND rr.INSURANCE_COMPANY IS NOT NULL AND pp.AD_CODE LIKE ? || '%' AND rr.INSURANCE_COMPANY = ? ), 0 ) * 100, 1 ), '999.0' )) || '%' AS insuranceRatio, -- 新增覆盖率coverage：当前公司区县量 / 该区县所有保险公司总量 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr2.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr2 INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp2 ON rr2.PROJECT_ID = pp2.ID WHERE rr2.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr2.DATA_STAT = '0' AND pp2.DATA_STAT = '0' AND rr2.INSURANCE_COMPANY IS NOT NULL -- 只限定和外层同一区县，不限制保险公司 AND pp2.AD_CODE = p.AD_CODE ), 0 ) * 100, 1 ), '999.0' )) || '%' AS coverage, ROUND(SUM(r.PREMIUM_AMOUNT), 1) AS premiumSum FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD r JOIN GW_HUIYI.ATT_PROJECT_INSURANCE p ON r.PROJECT_ID = p.ID LEFT JOIN BIS_INSP_ORG distOrg ON p.AD_CODE = distOrg.AD_CODE WHERE 1=1 AND r.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND r.DATA_STAT = '0' AND p.DATA_STAT = '0' AND r.INSURANCE_COMPANY IS NOT NULL AND p.AD_CODE LIKE ? || '%' AND r.INSURANCE_COMPANY = ? GROUP BY p.AD_CODE, distOrg.ORG_NM ORDER BY insuredTotal DESC
    5. 

  5. 2026-06-29 00:06:13.246 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.insuranceCompanyCountyDetail - ==> Parameters: 3501(String), 平安财险福建分公司(String), 3501(String), 平安财险福建分公司(String)
    6. 

  6. 2026-06-29 00:06:13.313 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.insuranceCompanyCountyDetail - <==      Total: 1
    7. 

  7. 2026-06-29 00:06:13.388 DEBUG [container-6] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    8. 

  8. 2026-06-29 00:06:13.388 DEBUG [container-6] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: 512be9c3e6994fb88beb515dc0f1ecee(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:06:13.387(Timestamp), 保险机构-区县详情(String), http://127.0.0.1:8500/att/project/insurance/insuranceCompanyCountyDetail(String), (String), 127.0.0.1(String), (String), {}(String), [AttAnzeUnderwritingDto(id=null, name=null, type=null, loc=null, investment=null, plannedDuration=null, startDate=null, status=null, managementUnit=null, contactPerson=null, adCode=3501, adName=null, centerX=null, centerY=null, gdX=null, gdY=null, intm=null, uptm=null, recordId=null, policyholder=null, policyholderPhone=null, insuranceCompany=平安财险福建分公司, insuranceContactPerson=null, insuranceContactPhone=null, premiumAmount=null, preventionServiceFee=null, insuranceDate=null, preventionServiceUnit=null, serviceUnitContactPerson=null, serviceUnitContactPhone=null, year=null, state=null)](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"66","Content-Type":"application/json"}(String), (String), {"code":0,"data":[{"adCode":"350181000000","county":"福清市","coverage":"100.0%","insuranceRatio":"100.0%","insuredTotal":"1","premiumSum":"168.3"}],"success":true}(String)
    9. 

  9. 2026-06-29 00:07:57.037 DEBUG [qtp1955857288-53] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    10. 

  10. 2026-06-29 00:07:57.037 DEBUG [qtp1955857288-53] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    11. 

  11. 2026-06-29 00:07:57.104 DEBUG [qtp1955857288-53] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    12. 

  12. 2026-06-29 00:07:57.105 DEBUG [qtp1955857288-53] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.insuranceCompanyCountyDetail - ==>  Preparing: SELECT p.AD_CODE AS adCode, distOrg.ORG_NM AS county, COUNT(DISTINCT r.PROJECT_ID) AS insuredTotal, -- 原占比：当前保险公司区县项目 / 全市该保险公司总项目 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp ON rr.PROJECT_ID = pp.ID WHERE rr.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr.DATA_STAT = '0' AND pp.DATA_STAT = '0' AND rr.INSURANCE_COMPANY IS NOT NULL AND pp.AD_CODE LIKE ? || '%' AND rr.INSURANCE_COMPANY = ? ), 0 ) * 100, 1 ), '999.0' )) || '%' AS insuranceRatio, -- 新增覆盖率coverage：当前公司区县量 / 该区县所有保险公司总量 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr2.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr2 INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp2 ON rr2.PROJECT_ID = pp2.ID WHERE rr2.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr2.DATA_STAT = '0' AND pp2.DATA_STAT = '0' AND rr2.INSURANCE_COMPANY IS NOT NULL -- 只限定和外层同一区县，不限制保险公司 AND pp2.AD_CODE = p.AD_CODE ), 0 ) * 100, 1 ), '999.0' )) || '%' AS coverage, ROUND(SUM(r.PREMIUM_AMOUNT), 1) AS premiumSum FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD r JOIN GW_HUIYI.ATT_PROJECT_INSURANCE p ON r.PROJECT_ID = p.ID LEFT JOIN BIS_INSP_ORG distOrg ON p.AD_CODE = distOrg.AD_CODE WHERE 1=1 AND r.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND r.DATA_STAT = '0' AND p.DATA_STAT = '0' AND r.INSURANCE_COMPANY IS NOT NULL AND p.AD_CODE LIKE ? || '%' AND r.INSURANCE_COMPANY = ? GROUP BY p.AD_CODE, distOrg.ORG_NM ORDER BY insuredTotal DESC
    13. 

  13. 2026-06-29 00:07:57.105 DEBUG [qtp1955857288-53] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.insuranceCompanyCountyDetail - ==> Parameters: 3501(String), 平安财险福建分公司(String), 3501(String), 平安财险福建分公司(String)
    14. 

  14. 2026-06-29 00:07:57.177 DEBUG [qtp1955857288-53] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.insuranceCompanyCountyDetail - <==      Total: 1
    15. 

  15. 2026-06-29 00:07:57.246 DEBUG [container-7] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    16. 

  16. 2026-06-29 00:07:57.246 DEBUG [container-7] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: 854dc57cbd7d4d6fa566814468a2c0ae(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:07:57.246(Timestamp), 保险机构-区县详情(String), http://127.0.0.1:8500/att/project/insurance/insuranceCompanyCountyDetail(String), (String), 127.0.0.1(String), (String), {}(String), [AttAnzeUnderwritingDto(id=null, name=null, type=null, loc=null, investment=null, plannedDuration=null, startDate=null, status=null, managementUnit=null, contactPerson=null, adCode=3501, adName=null, centerX=null, centerY=null, gdX=null, gdY=null, intm=null, uptm=null, recordId=null, policyholder=null, policyholderPhone=null, insuranceCompany=平安财险福建分公司, insuranceContactPerson=null, insuranceContactPhone=null, premiumAmount=null, preventionServiceFee=null, insuranceDate=null, preventionServiceUnit=null, serviceUnitContactPerson=null, serviceUnitContactPhone=null, year=null, state=null)](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"66","Content-Type":"application/json"}(String), (String), {"code":0,"data":[{"adCode":"350181000000","county":"福清市","coverage":"50.0%","insuranceRatio":"100.0%","insuredTotal":"1","premiumSum":"168.3"}],"success":true}(String)
    17. 

  17. 2026-06-29 00:11:42.694 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    18. 

  18. 2026-06-29 00:11:42.695 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    19. 

  19. 2026-06-29 00:11:42.780 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    20. 

  20. 2026-06-29 00:11:42.781 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCoveredDetail - ==>  Preparing: SELECT SUBSTR(p.AD_CODE,1,4) AS adCode, CASE SUBSTR(p.AD_CODE,1,4) WHEN '3501' THEN '福州市' WHEN '3502' THEN '厦门市' WHEN '3503' THEN '莆田市' WHEN '3504' THEN '三明市' WHEN '3505' THEN '泉州市' WHEN '3506' THEN '漳州市' WHEN '3507' THEN '南平市' WHEN '3508' THEN '龙岩市' WHEN '3509' THEN '宁德市' END AS city, COUNT(DISTINCT r.PROJECT_ID) AS insuredTotal, -- 占比：当前地市有效工程 / 筛选范围内全部有效工程 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp ON rr.PROJECT_ID = pp.ID WHERE rr.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr.DATA_STAT = '0' AND pp.DATA_STAT = '0' -- 新增：保险机构不为空才计入分母总数 AND rr.INSURANCE_COMPANY IS NOT NULL AND rr.INSURANCE_COMPANY = ? ), 0) * 100, 1), '999.0')) || '%' AS insuranceRatio, ROUND(SUM(r.PREMIUM_AMOUNT),1) AS premiumSum FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD r JOIN GW_HUIYI.ATT_PROJECT_INSURANCE p ON r.PROJECT_ID=p.ID WHERE r.YEAR=TO_CHAR(SYSDATE,'yyyy') AND r.DATA_STAT='0' AND p.DATA_STAT='0' -- 新增：保险机构为空的整条记录直接过滤，不参与计数、保费求和 AND r.INSURANCE_COMPANY IS NOT NULL AND r.INSURANCE_COMPANY = ? GROUP BY SUBSTR(p.AD_CODE,1,4) ORDER BY COUNT(DISTINCT r.PROJECT_ID) DESC
    21. 

  21. 2026-06-29 00:11:42.781 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCoveredDetail - ==> Parameters: 平安财险福建分公司(String), 平安财险福建分公司(String)
    22. 

  22. 2026-06-29 00:11:42.917 DEBUG [qtp1955857288-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCoveredDetail - <==      Total: 3
    23. 

  23. 2026-06-29 00:11:42.988 DEBUG [container-8] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    24. 

  24. 2026-06-29 00:11:42.988 DEBUG [container-8] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: 0c45ba5eb2cc44b58bfbbfc2946f8ada(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:11:42.988(Timestamp), 保险机构-地市分布-页面下方数据(String), http://127.0.0.1:8500/att/project/insurance/cityCoveredDetail(String), (String), 127.0.0.1(String), (String), {}(String), [AttAnzeUnderwritingDto(id=null, name=null, type=null, loc=null, investment=null, plannedDuration=null, startDate=null, status=null, managementUnit=null, contactPerson=null, adCode=null, adName=null, centerX=null, centerY=null, gdX=null, gdY=null, intm=null, uptm=null, recordId=null, policyholder=null, policyholderPhone=null, insuranceCompany=平安财险福建分公司, insuranceContactPerson=null, insuranceContactPhone=null, premiumAmount=null, preventionServiceFee=null, insuranceDate=null, preventionServiceUnit=null, serviceUnitContactPerson=null, serviceUnitContactPhone=null, year=null, state=null)](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"50","Content-Type":"application/json"}(String), (String), {"code":0,"data":[{"adCode":"3506","city":"漳州市","insuranceRatio":"33.3%","insuredTotal":"1","premiumSum":"105.4"},{"adCode":"3501","city":"福州市","insuranceRatio":"33.3%","insuredTotal":"1","premiumSum":"168.3"},{"adCode":"3503","city":"莆田市","insuranceRatio":"33.3%","insuredTotal":"1","premiumSum":"156.8"}],"success":true}(String)
    25. 

  25. 2026-06-29 00:21:44.746 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    26. 

  26. 2026-06-29 00:21:44.770 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    27. 

  27. 2026-06-29 00:21:44.937 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    28. 

  28. 2026-06-29 00:21:45.547 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCoveredDetail - ==>  Preparing: SELECT SUBSTR(p.AD_CODE,1,4) AS adCode, CASE SUBSTR(p.AD_CODE,1,4) WHEN '3501' THEN '福州市' WHEN '3502' THEN '厦门市' WHEN '3503' THEN '莆田市' WHEN '3504' THEN '三明市' WHEN '3505' THEN '泉州市' WHEN '3506' THEN '漳州市' WHEN '3507' THEN '南平市' WHEN '3508' THEN '龙岩市' WHEN '3509' THEN '宁德市' END AS city, COUNT(DISTINCT r.PROJECT_ID) AS insuredTotal, -- 原占比：当前地市该保险公司项目 / 全省该保险公司总项目 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp ON rr.PROJECT_ID = pp.ID WHERE rr.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr.DATA_STAT = '0' AND pp.DATA_STAT = '0' AND rr.INSURANCE_COMPANY IS NOT NULL AND rr.INSURANCE_COMPANY = ? ), 0 ) * 100, 1 ), '999.0' )) || '%' AS insuranceRatio, -- 新增覆盖率 coverage：当前地市该保险公司项目 / 该地全市所有保险公司总项目 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr2.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr2 INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp2 ON rr2.PROJECT_ID = pp2.ID WHERE rr2.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr2.DATA_STAT = '0' AND pp2.DATA_STAT = '0' AND rr2.INSURANCE_COMPANY IS NOT NULL -- 绑定外层当前地市4位编码，不限制保险公司 AND SUBSTR(pp2.AD_CODE,1,4) = SUBSTR(p.AD_CODE,1,4) ), 0 ) * 100, 1 ), '999.0' )) || '%' AS coverage, ROUND(SUM(r.PREMIUM_AMOUNT),1) AS premiumSum FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD r JOIN GW_HUIYI.ATT_PROJECT_INSURANCE p ON r.PROJECT_ID=p.ID WHERE r.YEAR=TO_CHAR(SYSDATE,'yyyy') AND r.DATA_STAT='0' AND p.DATA_STAT='0' AND r.INSURANCE_COMPANY IS NOT NULL AND r.INSURANCE_COMPANY = ? GROUP BY SUBSTR(p.AD_CODE,1,4) ORDER BY COUNT(DISTINCT r.PROJECT_ID) DESC
    29. 

  29. 2026-06-29 00:21:45.547 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCoveredDetail - ==> Parameters: 平安财险福建分公司(String), 平安财险福建分公司(String)
    30. 

  30. 2026-06-29 00:21:45.708 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCoveredDetail - <==      Total: 3
    31. 

  31. 2026-06-29 00:21:46.008 DEBUG [container-2] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    32. 

  32. 2026-06-29 00:21:46.010 DEBUG [container-2] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: 036605d98a934696bd1b28eaaee28507(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:21:46.008(Timestamp), 保险机构-地市分布-页面下方数据(String), http://127.0.0.1:8500/att/project/insurance/cityCoveredDetail(String), (String), 127.0.0.1(String), (String), {}(String), [AttAnzeUnderwritingDto(id=null, name=null, type=null, loc=null, investment=null, plannedDuration=null, startDate=null, status=null, managementUnit=null, contactPerson=null, adCode=null, adName=null, centerX=null, centerY=null, gdX=null, gdY=null, intm=null, uptm=null, recordId=null, policyholder=null, policyholderPhone=null, insuranceCompany=平安财险福建分公司, insuranceContactPerson=null, insuranceContactPhone=null, premiumAmount=null, preventionServiceFee=null, insuranceDate=null, preventionServiceUnit=null, serviceUnitContactPerson=null, serviceUnitContactPhone=null, year=null, state=null)](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"50","Content-Type":"application/json"}(String), (String), {"code":0,"data":[{"adCode":"3501","city":"福州市","coverage":"11.1%","insuranceRatio":"33.3%","insuredTotal":"1","premiumSum":"168.3"},{"adCode":"3506","city":"漳州市","coverage":"14.3%","insuranceRatio":"33.3%","insuredTotal":"1","premiumSum":"105.4"},{"adCode":"3503","city":"莆田市","coverage":"16.7%","insuranceRatio":"33.3%","insuredTotal":"1","premiumSum":"156.8"}],"success":true}(String)
    33. 

  33. 2026-06-29 00:22:01.819 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    34. 

  34. 2026-06-29 00:22:01.820 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    35. 

  35. 2026-06-29 00:22:01.890 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    36. 

  36. 2026-06-29 00:22:01.891 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceCityCoveredDetail - ==>  Preparing: SELECT SUBSTR(p.AD_CODE,1,4) AS adCode, CASE SUBSTR(p.AD_CODE,1,4) WHEN '3501' THEN '福州市' WHEN '3502' THEN '厦门市' WHEN '3503' THEN '莆田市' WHEN '3504' THEN '三明市' WHEN '3505' THEN '泉州市' WHEN '3506' THEN '漳州市' WHEN '3507' THEN '南平市' WHEN '3508' THEN '龙岩市' WHEN '3509' THEN '宁德市' END AS city, COUNT(DISTINCT r.PROJECT_ID) AS insuredTotal, -- 原有占比：当前地市该服务机构项目 / 全省该服务机构总项目 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp ON rr.PROJECT_ID = pp.ID WHERE rr.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr.DATA_STAT = '0' AND pp.DATA_STAT = '0' AND rr.PREVENTION_SERVICE_UNIT IS NOT NULL AND rr.PREVENTION_SERVICE_UNIT = ? ), 0 ) * 100, 1 ), '999.0' )) || '%' AS insuranceRatio, -- 新增覆盖率 coverage：当前地市该机构项目 ÷ 该地全市所有服务机构总项目 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr2.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr2 INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp2 ON rr2.PROJECT_ID = pp2.ID WHERE rr2.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr2.DATA_STAT = '0' AND pp2.DATA_STAT = '0' AND rr2.PREVENTION_SERVICE_UNIT IS NOT NULL -- 匹配外层当前地市4位编码，不限制服务单位 AND SUBSTR(pp2.AD_CODE,1,4) = SUBSTR(p.AD_CODE,1,4) ), 0 ) * 100, 1 ), '999.0' )) || '%' AS coverage, ROUND(SUM(r.PREVENTION_SERVICE_FEE),1) AS premiumSum FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD r JOIN GW_HUIYI.ATT_PROJECT_INSURANCE p ON r.PROJECT_ID=p.ID WHERE r.YEAR=TO_CHAR(SYSDATE,'yyyy') AND r.DATA_STAT='0' AND p.DATA_STAT='0' AND r.PREVENTION_SERVICE_UNIT IS NOT NULL AND r.PREVENTION_SERVICE_UNIT = ? GROUP BY SUBSTR(p.AD_CODE,1,4) ORDER BY COUNT(DISTINCT r.PROJECT_ID) DESC
    37. 

  37. 2026-06-29 00:22:01.892 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceCityCoveredDetail - ==> Parameters: 中检集团(String), 中检集团(String)
    38. 

  38. 2026-06-29 00:22:02.051 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceCityCoveredDetail - <==      Total: 5
    39. 

  39. 2026-06-29 00:22:02.122 DEBUG [container-3] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    40. 

  40. 2026-06-29 00:22:02.122 DEBUG [container-3] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: 0811cfd24e32441ca26d06fdeec591a6(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:22:02.121(Timestamp), 服务机构-地市分布-页面下方数据(String), http://127.0.0.1:8500/att/project/insurance/serviceCityCoveredDetail(String), (String), 127.0.0.1(String), (String), {}(String), [AttAnzeUnderwritingDto(id=null, name=null, type=null, loc=null, investment=null, plannedDuration=null, startDate=null, status=null, managementUnit=null, contactPerson=null, adCode=null, adName=null, centerX=null, centerY=null, gdX=null, gdY=null, intm=null, uptm=null, recordId=null, policyholder=null, policyholderPhone=null, insuranceCompany=null, insuranceContactPerson=null, insuranceContactPhone=null, premiumAmount=null, preventionServiceFee=null, insuranceDate=null, preventionServiceUnit=中检集团, serviceUnitContactPerson=null, serviceUnitContactPhone=null, year=null, state=null)](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"40","Content-Type":"application/json"}(String), (String), {"code":0,"data":[{"adCode":"3501","city":"福州市","coverage":"11.1%","insuranceRatio":"20.0%","insuredTotal":"1","premiumSum":"6.3"},{"adCode":"3502","city":"厦门市","coverage":"14.3%","insuranceRatio":"20.0%","insuredTotal":"1","premiumSum":"3.9"},{"adCode":"3509","city":"宁德市","coverage":"14.3%","insuranceRatio":"20.0%","insuredTotal":"1","premiumSum":"6.4"},{"adCode":"3507","city":"南平市","coverage":"14.3%","insuranceRatio":"20.0%","insuredTotal":"1","premiumSum":"3.2"},{"adCode":"3506","city":"漳州市","coverage":"14.3%","insuranceRatio":"20.0%","insuredTotal":"1","premiumSum":"8.6"}],"success":true}(String)
    41. 

  41. 2026-06-29 00:27:26.296 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    42. 

  42. 2026-06-29 00:27:26.297 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    43. 

  43. 2026-06-29 00:27:26.369 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    44. 

  44. 2026-06-29 00:27:26.370 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceCityCoveredDetail - ==>  Preparing: SELECT SUBSTR(p.AD_CODE,1,4) AS adCode, CASE SUBSTR(p.AD_CODE,1,4) WHEN '3501' THEN '福州市' WHEN '3502' THEN '厦门市' WHEN '3503' THEN '莆田市' WHEN '3504' THEN '三明市' WHEN '3505' THEN '泉州市' WHEN '3506' THEN '漳州市' WHEN '3507' THEN '南平市' WHEN '3508' THEN '龙岩市' WHEN '3509' THEN '宁德市' END AS city, COUNT(DISTINCT r.PROJECT_ID) AS insuredTotal, -- 原有占比：当前地市该服务机构项目 / 全省该服务机构总项目 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp ON rr.PROJECT_ID = pp.ID WHERE rr.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr.DATA_STAT = '0' AND pp.DATA_STAT = '0' AND rr.PREVENTION_SERVICE_UNIT IS NOT NULL AND rr.PREVENTION_SERVICE_UNIT = ? ), 0 ) * 100, 1 ), '999.0' )) || '%' AS insuranceRatio, -- 新增覆盖率 coverage：当前地市该机构项目 ÷ 该地全市所有服务机构总项目 LTRIM(TO_CHAR( ROUND( COUNT(DISTINCT r.PROJECT_ID) / NULLIF( (SELECT COUNT(DISTINCT rr2.PROJECT_ID) FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD rr2 INNER JOIN GW_HUIYI.ATT_PROJECT_INSURANCE pp2 ON rr2.PROJECT_ID = pp2.ID WHERE rr2.YEAR = TO_CHAR(SYSDATE, 'yyyy') AND rr2.DATA_STAT = '0' AND pp2.DATA_STAT = '0' AND rr2.PREVENTION_SERVICE_UNIT IS NOT NULL -- 匹配外层当前地市4位编码，不限制服务单位 AND SUBSTR(pp2.AD_CODE,1,4) = SUBSTR(p.AD_CODE,1,4) ), 0 ) * 100, 1 ), '999.0' )) || '%' AS coverage, ROUND(SUM(r.PREVENTION_SERVICE_FEE),1) AS premiumSum FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD r JOIN GW_HUIYI.ATT_PROJECT_INSURANCE p ON r.PROJECT_ID=p.ID WHERE r.YEAR=TO_CHAR(SYSDATE,'yyyy') AND r.DATA_STAT='0' AND p.DATA_STAT='0' AND r.PREVENTION_SERVICE_UNIT IS NOT NULL AND r.PREVENTION_SERVICE_UNIT = ? GROUP BY SUBSTR(p.AD_CODE,1,4) ORDER BY COUNT(DISTINCT r.PROJECT_ID) DESC
    45. 

  45. 2026-06-29 00:27:26.371 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceCityCoveredDetail - ==> Parameters: 中检集团(String), 中检集团(String)
    46. 

  46. 2026-06-29 00:27:26.440 DEBUG [qtp2010645140-58] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceCityCoveredDetail - <==      Total: 4
    47. 

  47. 2026-06-29 00:27:26.511 DEBUG [container-4] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    48. 

  48. 2026-06-29 00:27:26.512 DEBUG [container-4] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: c2d8bc3e18f14a8a98d7f55517b0736a(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:27:26.51(Timestamp), 服务机构-地市分布-页面下方数据(String), http://127.0.0.1:8500/att/project/insurance/serviceCityCoveredDetail(String), (String), 127.0.0.1(String), (String), {}(String), [AttAnzeUnderwritingDto(id=null, name=null, type=null, loc=null, investment=null, plannedDuration=null, startDate=null, status=null, managementUnit=null, contactPerson=null, adCode=null, adName=null, centerX=null, centerY=null, gdX=null, gdY=null, intm=null, uptm=null, recordId=null, policyholder=null, policyholderPhone=null, insuranceCompany=null, insuranceContactPerson=null, insuranceContactPhone=null, premiumAmount=null, preventionServiceFee=null, insuranceDate=null, preventionServiceUnit=中检集团, serviceUnitContactPerson=null, serviceUnitContactPhone=null, year=null, state=null)](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"40","Content-Type":"application/json"}(String), (String), {"code":0,"data":[{"adCode":"3501","city":"福州市","coverage":"20.0%","insuranceRatio":"40.0%","insuredTotal":"2","premiumSum":"10.2"},{"adCode":"3507","city":"南平市","coverage":"14.3%","insuranceRatio":"20.0%","insuredTotal":"1","premiumSum":"3.2"},{"adCode":"3509","city":"宁德市","coverage":"14.3%","insuranceRatio":"20.0%","insuredTotal":"1","premiumSum":"6.4"},{"adCode":"3506","city":"漳州市","coverage":"14.3%","insuranceRatio":"20.0%","insuredTotal":"1","premiumSum":"8.6"}],"success":true}(String)
    49. 

  49. 2026-06-29 00:38:44.069 DEBUG [qtp2010645140-59] cn.com.goldenwater.dcproj.dao.ErrorDao.insert - ==>  Preparing: insert into GW_SYS_ERROR( ID, INTM, CONTENT, URL ) values ( ?, ?, ?, ? )
    50. 

  50. 2026-06-29 00:38:44.069 DEBUG [qtp2010645140-59] cn.com.goldenwater.dcproj.dao.ErrorDao.insert - ==> Parameters: c899344789c34ab3aafe5d37ae5a64da(String), 2026-06-29 00:38:44.068(Timestamp), throwable msg=Required request body is missing: public cn.com.goldenwater.core.web.BaseResponse<java.util.List<cn.com.goldenwater.dcproj.dto.AttProjectInsuranceRecordViewDto>> cn.com.goldenwater.dcproj.controller.anze.AttProjectInsuranceController.cityCovered(cn.com.goldenwater.dcproj.param.AttAnzeUnderwritingParam)(String), /att/project/insurance/cityCovered(String)
    51. 

  51. 2026-06-29 00:38:52.009 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    52. 

  52. 2026-06-29 00:38:52.010 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    53. 

  53. 2026-06-29 00:38:52.081 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    54. 

  54. 2026-06-29 00:38:52.084 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCovered - ==>  Preparing: SELECT r.INSURANCE_COMPANY AS insuranceCompany, COUNT(DISTINCT r.PROJECT_ID) AS insuredTotal, ROUND(SUM(r.PREMIUM_AMOUNT)/1,2) AS premiumSum, CONCAT(COUNT(DISTINCT CASE WHEN SUBSTR(p.AD_CODE,1,4) IN ('3501','3502','3503','3504','3505','3506','3507','3508','3509') THEN SUBSTR(p.AD_CODE,1,4) END), '/9') AS coveredCityNum FROM GW_HUIYI.ATT_PROJECT_INSURANCE_RECORD r JOIN GW_HUIYI.ATT_PROJECT_INSURANCE p ON r.PROJECT_ID=p.ID WHERE r.YEAR=TO_CHAR(SYSDATE,'yyyy') AND r.DATA_STAT='0' AND p.DATA_STAT='0' GROUP BY r.INSURANCE_COMPANY
    55. 

  55. 2026-06-29 00:38:52.084 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCovered - ==> Parameters: 
    56. 

  56. 2026-06-29 00:38:52.366 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.cityCovered - <==      Total: 24
    57. 

  57. 2026-06-29 00:38:52.436 DEBUG [container-5] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    58. 

  58. 2026-06-29 00:38:52.437 DEBUG [container-5] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: b2e06c6b46344a5b96965fa78e857118(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:38:52.436(Timestamp), 保险机构-地市分布-页面上方数据(String), http://127.0.0.1:8500/att/project/insurance/cityCovered(String), (String), 127.0.0.1(String), (String), {}(String), [AttAnzeUnderwritingDto(id=null, name=null, type=null, loc=null, investment=null, plannedDuration=null, startDate=null, status=null, managementUnit=null, contactPerson=null, adCode=null, adName=null, centerX=null, centerY=null, gdX=null, gdY=null, intm=null, uptm=null, recordId=null, policyholder=null, policyholderPhone=null, insuranceCompany=null, insuranceContactPerson=null, insuranceContactPhone=null, premiumAmount=null, preventionServiceFee=null, insuranceDate=null, preventionServiceUnit=null, serviceUnitContactPerson=null, serviceUnitContactPhone=null, year=null, state=null)](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"2","Content-Type":"application/json"}(String), (String), {"code":0,"data":[{"coveredCityNum":"1/9","insuranceCompany":"12","insuredTotal":"1","premiumSum":"1"},{"coveredCityNum":"2/9","insuranceCompany":"666","insuredTotal":"2","premiumSum":"118.5"},{"coveredCityNum":"4/9","insuranceCompany":"中华联合","insuredTotal":"4","premiumSum":"290.6"},{"coveredCityNum":"3/9","insuranceCompany":"中华联合财产保险股份有限公司福建分公司","insuredTotal":"3","premiumSum":"112.1"},{"coveredCityNum":"1/9","insuranceCompany":"中华联合财险","insuredTotal":"1","premiumSum":"169.5"},{"coveredCityNum":"4/9","insuranceCompany":"中国人寿财产保险股份有限公司福建省分公司","insuredTotal":"4","premiumSum":"204"},{"coveredCityNum":"1/9","insuranceCompany":"中国人民财产保险股份有限公司南平市分公司","insuredTotal":"1","premiumSum":"57"},{"coveredCityNum":"1/9","insuranceCompany":"中国人民财产保险股份有限公司宁德市分公司","insuredTotal":"1","premiumSum":"49.8"},{"coveredCityNum":"1/9","insuranceCompany":"中国人民财产保险股份有限公司福建省分公司","insuredTotal":"1","premiumSum":"74.5"},{"coveredCityNum":"1/9","insuranceCompany":"中国人民财产保险股份有限公司龙岩市分公司","insuredTotal":"1","premiumSum":"33.2"},{"coveredCityNum":"1/9","insuranceCompany":"中国太平洋财产保险股份有限公司厦门分公司","insuredTotal":"1","premiumSum":"15.2"},{"coveredCityNum":"7/9","insuranceCompany":"中国太平洋财产保险股份有限公司福建分公司","insuredTotal":"7","premiumSum":"332.5"},{"coveredCityNum":"1/9","insuranceCompany":"中国平安财产保险股份有限公司厦门分公司","insuredTotal":"1","premiumSum":"18.5"},{"coveredCityNum":"8/9","insuranceCompany":"中国平安财产保险股份有限公司福建分公司","insuredTotal":"8","premiumSum":"419.5"},{"coveredCityNum":"4/9","insuranceCompany":"人保财险","insuredTotal":"4","premiumSum":"266.1"},{"coveredCityNum":"3/9","insuranceCompany":"人保财险福建分公司","insuredTotal":"3","premiumSum":"346.6"},{"coveredCityNum":"5/9","insuranceCompany":"太保财险","insuredTotal":"6","premiumSum":"460.5"},{"coveredCityNum":"2/9","insuranceCompany":"太平洋财险福建分公司","insuredTotal":"2","premiumSum":"224"},{"coveredCityNum":"1/9","insuranceCompany":"平安","insuredTotal":"1","premiumSum":"1"},{"coveredCityNum":"4/9","insuranceCompany":"平安财险","insuredTotal":"4","premiumSum":"384.8"},{"coveredCityNum":"3/9","insuranceCompany":"平安财险福建分公司","insuredTotal":"3","premiumSum":"430.5"},{"coveredCityNum":"4/9","insuranceCompany":"海峡金桥财产保险股份有限公司","insuredTotal":"4","premiumSum":"310.8"},{"coveredCityNum":"2/9","insuranceCompany":"阳光财产保险股份有限公司福建分公司","insuredTotal":"2","premiumSum":"72.3"},{"coveredCityNum":"1/9","insuredTotal":"1","premiumSum":"43.8"}],"success":true}(String)
    59. 

  59. 2026-06-29 00:40:00.899 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    60. 

  60. 2026-06-29 00:40:00.900 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    61. 

  61. 2026-06-29 00:40:00.974 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    62. 

  62. 2026-06-29 00:40:01.139 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceUnitDetail_COUNT - ==>  Preparing: WITH year_total AS (SELECT COUNT(DISTINCT "PROJECT_ID") AS total_proj FROM "ATT_PROJECT_INSURANCE_RECORD" WHERE "YEAR" = TO_CHAR(SYSDATE, 'YYYY') AND "DATA_STAT" = '0'), org_stat AS (SELECT "PREVENTION_SERVICE_UNIT" AS service_unit, COUNT(DISTINCT "PROJECT_ID") AS unit_proj_cnt FROM "ATT_PROJECT_INSURANCE_RECORD" WHERE "YEAR" = TO_CHAR(SYSDATE, 'YYYY') AND "DATA_STAT" = '0' AND "PREVENTION_SERVICE_UNIT" IS NOT NULL GROUP BY "PREVENTION_SERVICE_UNIT") SELECT count(0) FROM org_stat o, year_total t
    63. 

  63. 2026-06-29 00:40:01.139 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceUnitDetail_COUNT - ==> Parameters: 
    64. 

  64. 2026-06-29 00:40:01.272 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceUnitDetail_COUNT - <==      Total: 1
    65. 

  65. 2026-06-29 00:40:01.281 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceUnitDetail - ==>  Preparing: SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( WITH year_total AS ( -- 当年全部工程总数（占比分母，有无服务单位都计入） SELECT COUNT(DISTINCT "PROJECT_ID") AS total_proj FROM "ATT_PROJECT_INSURANCE_RECORD" WHERE "YEAR" = TO_CHAR(SYSDATE, 'YYYY') AND "DATA_STAT" = '0' ), org_stat AS ( SELECT "PREVENTION_SERVICE_UNIT" AS service_unit, COUNT(DISTINCT "PROJECT_ID") AS unit_proj_cnt FROM "ATT_PROJECT_INSURANCE_RECORD" WHERE "YEAR" = TO_CHAR(SYSDATE, 'YYYY') AND "DATA_STAT" = '0' AND "PREVENTION_SERVICE_UNIT" IS NOT NULL GROUP BY "PREVENTION_SERVICE_UNIT" ) SELECT o.service_unit AS preventionServiceUnit, o.unit_proj_cnt AS insuredTotal, LTRIM(TO_CHAR(ROUND(o.unit_proj_cnt / NULLIF(t.total_proj, 0) * 100, 1), '999.0')) || '%' AS insuranceRatio FROM org_stat o, year_total t ORDER BY o.unit_proj_cnt DESC ) TMP_PAGE WHERE ROWNUM <= ?
    66. 

  66. 2026-06-29 00:40:01.284 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceUnitDetail - ==> Parameters: 10(Integer)
    67. 

  67. 2026-06-29 00:40:01.485 DEBUG [qtp2010645140-63] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.serviceUnitDetail - <==      Total: 10
    68. 

  68. 2026-06-29 00:40:01.566 DEBUG [container-6] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    69. 

  69. 2026-06-29 00:40:01.567 DEBUG [container-6] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: c42b97385dde43748f16d8b9b25fa1d1(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:40:01.565(Timestamp), 服务机构-机构服务详情（点击查看地市分布）-页面右侧数据(String), http://127.0.0.1:8500/att/project/insurance/serviceUnitDetail(String), (String), 127.0.0.1(String), (String), {}(String), [1, 10](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"2","Content-Type":"application/json"}(String), (String), {"code":0,"data":{"endRow":10,"firstPage":1,"hasNextPage":true,"hasPreviousPage":false,"isFirstPage":true,"isLastPage":false,"lastPage":3,"list":[{"insuranceRatio":"9.1%","insuredTotal":"6","preventionServiceUnit":"华安检测"},{"insuranceRatio":"9.1%","insuredTotal":"6","preventionServiceUnit":"福建省安全生产科学研究院"},{"insuranceRatio":"7.6%","insuredTotal":"5","preventionServiceUnit":"中检集团"},{"insuranceRatio":"7.6%","insuredTotal":"5","preventionServiceUnit":"福建省雄伟安全技术咨询有限责任公司"},{"insuranceRatio":"6.1%","insuredTotal":"4","preventionServiceUnit":"福建安评"},{"insuranceRatio":"6.1%","insuredTotal":"4","preventionServiceUnit":"闽安咨询"},{"insuranceRatio":"6.1%","insuredTotal":"4","preventionServiceUnit":"福建省安科安全工程师事务所有限公司"},{"insuranceRatio":"4.5%","insuredTotal":"3","preventionServiceUnit":"中检集团康泰安全科技有限公司"},{"insuranceRatio":"4.5%","insuredTotal":"3","preventionServiceUnit":"福建共益安全环保科技有限公司"},{"insuranceRatio":"4.5%","insuredTotal":"3","preventionServiceUnit":"福建中检康泰检测技术有限公司"}],"navigateFirstPage":1,"navigateLastPage":3,"navigatePages":8,"navigatepageNums":[1,2,3],"nextPage":2,"pageNum":1,"pageSize":10,"pages":3,"prePage":0,"size":10,"startRow":1,"total":22},"success":true}(String)
    70. 

  70. 2026-06-29 00:40:14.680 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==>  Preparing: select CALLNUMBER ,DEPART_ID,DEPART_NM, DPNM, DPPOST, IDNM, PLST, SCHOOL, SPECIALTY, IMGURL, GUID, PERS_NAME, SEX, TELNUMB, FAXNUMB, MOBILENUMB, EMAIL, BORN_DATE, ORG_ID, ORG_NM, ADM_DUTY, COLL_TIME, REMARK, PERS_TYPE, PERMISSION, OWNER_SYSTEM, W_UNIT, PLAN_DP_ID, PROVINCE from BIS_INSP_ALL_RLATION_PERS where guid = ?
    71. 

  71. 2026-06-29 00:40:14.680 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - ==> Parameters: 80df1213ad9f493e85a771d6f4b18a17(String)
    72. 

  72. 2026-06-29 00:40:14.750 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.BisInspAllRlationPersDao.get - <==      Total: 1
    73. 

  73. 2026-06-29 00:40:14.753 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.numberServiceRanking_COUNT - ==>  Preparing: SELECT count(0) FROM (SELECT r."PREVENTION_SERVICE_UNIT" AS preventionServiceUnit, COUNT(DISTINCT r."PROJECT_ID") AS insuredTotal FROM "ATT_PROJECT_INSURANCE_RECORD" r WHERE r."YEAR" = TO_CHAR(SYSDATE, 'YYYY') AND r."DATA_STAT" = '0' AND r."PREVENTION_SERVICE_UNIT" IS NOT NULL GROUP BY r."PREVENTION_SERVICE_UNIT") table_count
    74. 

  74. 2026-06-29 00:40:14.753 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.numberServiceRanking_COUNT - ==> Parameters: 
    75. 

  75. 2026-06-29 00:40:14.899 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.numberServiceRanking_COUNT - <==      Total: 1
    76. 

  76. 2026-06-29 00:40:14.900 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.numberServiceRanking - ==>  Preparing: SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( SELECT r."PREVENTION_SERVICE_UNIT" AS preventionServiceUnit, COUNT(DISTINCT r."PROJECT_ID") AS insuredTotal FROM "ATT_PROJECT_INSURANCE_RECORD" r WHERE r."YEAR" = TO_CHAR(SYSDATE, 'YYYY') AND r."DATA_STAT" = '0' AND r."PREVENTION_SERVICE_UNIT" IS NOT NULL GROUP BY r."PREVENTION_SERVICE_UNIT" ORDER BY COUNT(DISTINCT r."PROJECT_ID") DESC ) TMP_PAGE WHERE ROWNUM <= ?
    77. 

  77. 2026-06-29 00:40:14.900 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.numberServiceRanking - ==> Parameters: 10(Integer)
    78. 

  78. 2026-06-29 00:40:15.107 DEBUG [qtp2010645140-62] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.numberServiceRanking - <==      Total: 10
    79. 

  79. 2026-06-29 00:40:15.174 DEBUG [container-7] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    80. 

  80. 2026-06-29 00:40:15.174 DEBUG [container-7] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: 16582913cdf84d858dbc1f4e9f38c6d7(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:40:15.173(Timestamp), 服务机构-各机构服务数量排名-页面左侧数据(String), http://127.0.0.1:8500/att/project/insurance/numberServiceRanking(String), (String), 127.0.0.1(String), (String), {}(String), [1, 10](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"0"}(String), (String), {"code":0,"data":{"endRow":10,"firstPage":1,"hasNextPage":true,"hasPreviousPage":false,"isFirstPage":true,"isLastPage":false,"lastPage":3,"list":[{"insuredTotal":"6","preventionServiceUnit":"华安检测"},{"insuredTotal":"6","preventionServiceUnit":"福建省安全生产科学研究院"},{"insuredTotal":"5","preventionServiceUnit":"福建省雄伟安全技术咨询有限责任公司"},{"insuredTotal":"5","preventionServiceUnit":"中检集团"},{"insuredTotal":"4","preventionServiceUnit":"福建安评"},{"insuredTotal":"4","preventionServiceUnit":"闽安咨询"},{"insuredTotal":"4","preventionServiceUnit":"福建省安科安全工程师事务所有限公司"},{"insuredTotal":"3","preventionServiceUnit":"福建拓普检测技术有限公司"},{"insuredTotal":"3","preventionServiceUnit":"福建中检康泰检测技术有限公司"},{"insuredTotal":"3","preventionServiceUnit":"福建水利安全技术服务有限公司"}],"navigateFirstPage":1,"navigateLastPage":3,"navigatePages":8,"navigatepageNums":[1,2,3],"nextPage":2,"pageNum":1,"pageSize":10,"pages":3,"prePage":0,"size":10,"startRow":1,"total":22},"success":true}(String)
    81. 

  81. 2026-06-29 00:40:33.045 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.handServiceView - ==>  Preparing: WITH rec_all AS ( -- 当年全部投保记录（含有无服务单位） SELECT r."PROJECT_ID", r."PREVENTION_SERVICE_UNIT", SUBSTR(p."AD_CODE",1,4) AS city_code FROM "ATT_PROJECT_INSURANCE_RECORD" r LEFT JOIN "ATT_PROJECT_INSURANCE" p ON r."PROJECT_ID" = p."ID" WHERE r."YEAR" = TO_CHAR(SYSDATE, 'YYYY') AND r."DATA_STAT" = '0' AND p."DATA_STAT" = '0' ), agg_base AS ( SELECT -- 全部当年总工程（分母，空/非空服务单位都算） COUNT(DISTINCT "PROJECT_ID") AS total_all_proj, -- 有服务单位的工程总数 COUNT(DISTINCT CASE WHEN "PREVENTION_SERVICE_UNIT" IS NOT NULL THEN "PROJECT_ID" END) AS service_proj_cnt, -- 去重有效服务机构数量 COUNT(DISTINCT CASE WHEN "PREVENTION_SERVICE_UNIT" IS NOT NULL THEN "PREVENTION_SERVICE_UNIT" END) AS service_org_total, -- 已覆盖地市编码数量 COUNT(DISTINCT CASE WHEN city_code IN ('3501','3502','3503','3504','3505','3506','3507','3508','3509') THEN city_code END) AS covered_city FROM rec_all ) SELECT service_org_total AS serviceCount, service_proj_cnt AS insuredTotal, -- 服务覆盖率 保留1位小数 LTRIM(TO_CHAR(ROUND(service_proj_cnt / NULLIF(total_all_proj, 0) * 100, 1), '999.0')) || '%' AS insuranceRatio, covered_city || '/9' AS coveredCityNum FROM agg_base
    82. 

  82. 2026-06-29 00:40:33.045 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.handServiceView - ==> Parameters: 
    83. 

  83. 2026-06-29 00:40:33.180 DEBUG [qtp2010645140-61] cn.com.goldenwater.dcproj.dao.AttProjectInsuranceDao.handServiceView - <==      Total: 1
    84. 

  84. 2026-06-29 00:40:33.291 DEBUG [container-8] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==>  Preparing: insert into BIS_INSP_LOG( LOG_ID, USER_ID, INTM, CONTENT, PATH, SRC, IP_ADDR, APP_MODEL, PARAMS, REQUEST_BODY, METHOD, HEADER, ORG_ID, RESPONSE_BODY ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    85. 

  85. 2026-06-29 00:40:33.292 DEBUG [container-8] cn.com.goldenwater.dcproj.dao.BisInspLogDao.insert - ==> Parameters: 56c9857c57e94db49af16f85a7536523(String), 80df1213ad9f493e85a771d6f4b18a17(String), 2026-06-29 00:40:33.291(Timestamp), 服务机构-服务机构承保情况-页面上方数据(String), http://127.0.0.1:8500/att/project/insurance/handServiceView(String), (String), 127.0.0.1(String), (String), {}(String), [](String), POST(String), {"Accept":"*/*","User-Agent":"ApiPOST Runtime +https://www.apipost.cn","Connection":"keep-alive","Persid":"80df1213ad9f493e85a771d6f4b18a17","Host":"127.0.0.1:8500","Accept-Encoding":"gzip, deflate, br","accessToken":"e9facb85b16148b5a72c204fbaec7a14","Content-Length":"0"}(String), (String), {"code":0,"data":{"coveredCityNum":"9/9","insuranceRatio":"98.5%","insuredTotal":"65","serviceCount":"22"},"success":true}(String)
    86.