2024-03-21 16:31:25,308 [192.168.0.57] [78296981fd154d9189eaa28c0be17bb1] [ylz.rt.segmentThreadPool.executor-23] 请求: { uri: "/api/dynamicReport/getInHospWardDeptSetIncomeList", method: "POST", body: { endDate: "20231130", sysId: "14", zwxm00: "实达系统", ygbh00: "2", wardId: "-1", KSLB00: "0", token: "8639c15ba74b48bdb781fe67e1e328d9", finaProjType: "2", showType: "1", startTime: "00:00:00", endTime: "23:59:59", startDate: "20231101", settleType: "0" }, header: { content-length: "238", referer: http://192.168.199.128/his-zysf/app/, accept-language: "zh-CN,zh;q=0.9", origin: http://192.168.199.128, host: "192.168.199.128:8089", connection: "keep-alive", content-type: "application/x-www-form-urlencoded;charset=UTF-8", dnt: "1", accept-encoding: "gzip, deflate", accept: "application/json, text/plain, */*", user-agent: "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.75 Safari/537.36" } } 响应: { status: 200, body: { payload: { head: { totalCol09: "化验费", totalCol08: "检查费", totalCol19: "麻醉费", totalCol07: "护理费", totalCol18: "输血费", totalCol06: "诊察费", totalCol05: "床位费", totalCol15: "CT费", totalMoney: "合计", totalCol03: "草药费", openBillDept: "开单病区", totalCol02: "成药费", totalCol13: "其他费", totalCol01: "西药费", totalCol11: "手术费", totalCol22: "卫生材料费", totalCol10: "治疗费", totalCol21: "其他医疗" }, data: [ { totalCol09: "1224.00", totalCol08: "25708.00", totalCol19: "83556.00", totalCol07: "39835.00", totalCol18: "0.00", totalCol06: "13194.00", totalCol17: "0.00", totalCol05: "36130.00", totalCol16: "0.00", totalCol15: "9.00", totalMoney: "716317.09", totalCol03: "150.76", totalCol14: "0.00", openBillDept: "外科二区", totalCol02: "10141.19", totalCol13: "5909.00", totalCol01: "180918.05", totalCol11: "441.00", totalCol22: "0.00", totalCol10: "2536.00", totalCol21: "4573.50", totalCol20: "0.00" }, { totalCol09: "5256.00", totalCol08: "103997.00", totalCol19: "101010.00", totalCol07: "69296.00", totalCol18: "0.00", totalCol06: "28314.00", totalCol17: "0.00", totalCol05: "79945.00", totalCol16: "0.00", totalCol15: "135.00", totalMoney: "726456.62", totalCol03: "1428.32", totalCol14: "0.00", openBillDept: "儿科一区", totalCol02: "18044.37", totalCol13: "0.00", totalCol01: "228701.39", totalCol11: "72.00", totalCol22: "0.00", totalCol10: "1434.00", totalCol21: "20927.00", totalCol20: "0.00" }, { totalCol09: "0.00", totalCol08: "52107.50", totalCol19: "42153.00", totalCol07: "39154.00", totalCol18: "0.00", totalCol06: "2682.00", totalCol17: "0.00", totalCol05: "9620.00", totalCol16: "0.00", totalCol15: "0.00", totalMoney: "377134.35", totalCol03: "0.00", totalCol14: "0.00", openBillDept: "重症医学病区", totalCol02: "7598.55", totalCol13: "189.00", totalCol01: "90692.78", totalCol11: "361.00", totalCol22: "0.00", totalCol10: "589.00", totalCol21: "42792.50", totalCol20: "0.00" }, { totalCol09: "324.00", totalCol08: "50997.00", totalCol19: "154172.00", totalCol07: "60054.00", totalCol18: "0.00", totalCol06: "20952.00", totalCol17: "0.00", totalCol05: "61684.00", totalCol16: "0.00", totalCol15: "6156.00", totalMoney: "919147.73", totalCol03: "365.97", totalCol14: "0.00", openBillDept: "内科一区", totalCol02: "49670.01", totalCol13: "90.00", totalCol01: "263627.20", totalCol11: "1600.00", totalCol22: "513.00", totalCol10: "3568.00", totalCol21: "17329.00", totalCol20: "0.00" }, { totalCol09: "612.00", totalCol08: "61281.00", totalCol19: "157447.00", totalCol07: "62575.00", totalCol18: "0.00", totalCol06: "21726.00", totalCol17: "0.00", totalCol05: "63143.00", totalCol16: "0.00", totalCol15: "2385.00", totalMoney: "846624.74", totalCol03: "375.09", totalCol14: "0.00", openBillDept: "内科二区", totalCol02: "47808.78", totalCol13: "1080.00", totalCol01: "230104.03", totalCol11: "2215.00", totalCol22: "447.00", totalCol10: "3719.00", totalCol21: "1381.00", totalCol20: "0.00" }, { totalCol09: "216.00", totalCol08: "36353.00", totalCol19: "131399.00", totalCol07: "55236.00", totalCol18: "0.00", totalCol06: "18666.00", totalCol17: "0.00", totalCol05: "54417.00", totalCol16: "0.00", totalCol15: "0.00", totalMoney: "675852.86", totalCol03: "72.86", totalCol14: "0.00", openBillDept: "内科三区", totalCol02: "9261.27", totalCol13: "3960.00", totalCol01: "211258.05", totalCol11: "598.00", totalCol22: "0.00", totalCol10: "3671.00", totalCol21: "4508.00", totalCol20: "0.00" }, { totalCol09: "828.00", totalCol08: "17025.00", totalCol19: "82040.00", totalCol07: "42440.00", totalCol18: "0.00", totalCol06: "15498.00", totalCol17: "0.00", totalCol05: "43961.00", totalCol16: "0.00", totalCol15: "405.00", totalMoney: "847754.93", totalCol03: "0.00", totalCol14: "0.00", openBillDept: "外科三区", totalCol02: "8713.16", totalCol13: "5436.00", totalCol01: "182255.32", totalCol11: "384.00", totalCol22: "0.00", totalCol10: "2990.00", totalCol21: "12464.50", totalCol20: "0.00" }, { totalCol09: "0.00", totalCol08: "82664.50", totalCol19: "155175.00", totalCol07: "65531.00", totalCol18: "0.00", totalCol06: "21960.00", totalCol17: "0.00", totalCol05: "61633.00", totalCol16: "0.00", totalCol15: "270.00", totalMoney: "803454.18", totalCol03: "0.00", totalCol14: "0.00", openBillDept: "内科五区", totalCol02: "25860.92", totalCol13: "194.00", totalCol01: "264800.42", totalCol11: "172.00", totalCol22: "0.00", totalCol10: "3908.00", totalCol21: "3278.00", totalCol20: "0.00" }, { totalCol09: "72.00", totalCol08: "80.00", totalCol19: "343.00", totalCol07: "354.00", totalCol18: "0.00", totalCol06: "0.00", totalCol17: "0.00", totalCol05: "737.00", totalCol16: "0.00", totalCol15: "0.00", totalMoney: "5249.36", totalCol03: "0.00", totalCol14: "0.00", openBillDept: "住院急诊病区", totalCol02: "538.49", totalCol13: "0.00", totalCol01: "758.53", totalCol11: "0.00", totalCol22: "0.00", totalCol10: "25.00", totalCol21: "0.00", totalCol20: "0.00" }, { totalCol09: "36.00", totalCol08: "26676.00", totalCol19: "71349.00", totalCol07: "35059.00", totalCol18: "810.00", totalCol06: "12042.00", totalCol17: "0.00", totalCol05: "47394.50", totalCol16: "0.00", totalCol15: "0.00", totalMoney: "516949.75", totalCol03: "2093.84", totalCol14: "0.00", openBillDept: "妇产科一区", totalCol02: "11576.36", totalCol13: "5369.00", totalCol01: "76662.31", totalCol11: "1901.00", totalCol22: "0.00", totalCol10: "3284.00", totalCol21: "16347.20", totalCol20: "0.00" }, { totalCol09: "8388.00", totalCol08: "11135.00", totalCol19: "57145.00", totalCol07: "40539.00", totalCol18: "0.00", totalCol06: "16038.00", totalCol17: "0.00", totalCol05: "46050.00", totalCol16: "0.00", totalCol15: "0.00", totalMoney: "751777.78", totalCol03: "0.00", totalCol14: "0.00", openBillDept: "外科一区", totalCol02: "12134.65", totalCol13: "1458.00", totalCol01: "107662.83", totalCol11: "368.00", totalCol22: "0.00", totalCol10: "2408.00", totalCol21: "4620.50", totalCol20: "0.00" }, { totalCol09: "16956.00", totalCol08: "468024.00", totalCol19: "1035789.00", totalCol07: "510073.00", totalCol18: "810.00", totalCol06: "171072.00", totalCol17: "0.00", totalCol05: "504714.50", totalCol16: "0.00", totalCol15: "9360.00", totalMoney: "7186719.39", totalCol03: "4486.84", totalCol14: "0.00", openBillDept: "合计", totalCol02: "201347.75", totalCol13: "23685.00", totalCol01: "1837440.91", totalCol11: "8112.00", totalCol22: "960.00", totalCol10: "28132.00", totalCol21: "128221.20", totalCol20: "0.00" } ] }, title: "ok", status: 200 } } 堆栈信息: {"stack": "{ com.ylz.data.dict.impl.DictQueryServiceImpl.getlistBmTyzdData : { timeSpan:3 } com.ylz.his.login.impl.TokenServiceImpl.getYgbmByToken : { timeSpan:3 , details: { LogEntry: {message: source='com.ylz.his.login.impl.TokenServiceImpl'level='INFO'source='getToken============================token:8639c15ba74b48bdb781fe67e1e328d9====================user:true'} } } com.ylz.his.zysf.queryandstatistreport.impl.DynamicReportResultServiceImpl.inHospWardDeptSetIncomeList : { timeSpan:74275 , details: { JdbcEntry: {sql:'call SP_ZY_BQKSHSXMSR('20231101', '00:00:00', '20231130', '23:59:59', 2, 1, -1, null, null, null, 0, '0')', timeSpan:74259} jdbcCallTrace: {sql:'call SP_ZY_BQKSHSXMSR ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )', timeSpan:74259, key:8, value:1.1936618E7, key:9, value: , key:10, value: } JdbcEntry: {sql:'select BH0000,XMMC00 from BM_FPXM00 ORDER BY BH0000', timeSpan:0} JdbcEntry: {sql:'select decode(B.BMBH00, 999999999, '合计', A.BMMC00) as BMMC00 , nvl(A.BMXZ00, -1) as BMXZSX, XMHJ00 , YPHJ00, SFXM01, SFXM02, SFXM03, SFXM04 , SFXM05, SFXM06, SFXM07, SFXM08, SFXM09 , SFXM10, SFXM11, SFXM12, SFXM13, SFXM14 , SFXM15, SFXM16, SFXM17, SFXM18, SFXM19 , SFXM20, SFXM21, SFXM22, SFXM23, SFXM24 , SFXM25, SFXM26, SFXM27, SFXM28, SFXM29 , SFXM30, SFXM31, SFXM32, SFXM92, SFXM33 , SFXM93, SFXM34, SFXM94, SFXM35, SFXM36 , SFXM37, SFXM38, SFXM39, SFXM40, SFXM41 , SFXM42, SFXM43, SFXM44, SFXM45, SFXM46 , SFXM47, SFXM48, SFXM49, SFXM50, SFXM51 , SFXM52, SFXM53, SFXM54, SFXM55, SFXM56 , SFXM57, SFXM58, SFXM59, SFXM60, SFXM61 , SFXM62, SFXM63, SFXM64, SFXM65, SFXM66 , SFXM67, SFXM68, SFXM69, SFXM70, SFXM71 , SFXM72, SFXM73, SFXM74, SFXM75, SFXM76 , SFXM77, SFXM78, SFXM79, SFXM80, SFXM81 , SFXM82, SFXM83, SFXM84, SFXM85, SFXM86 , SFXM87, SFXM88, SFXM89, SFXM90, SFXM91 , SFXM92, SFXM93, SFXM94, SFXM95, SFXM96 , SFXM97, SFXM98, A.bmbh00 as BHPX00 from BM_BMBM00 A, BM_YYSFTJ B where A.BMBH00(+) = B.BMBH00 and B.ID0000 = '1.1936618E7' order by A.PXXH00, A.BH0000, BMXZSX desc, BHPX00 desc', timeSpan:1} } } com.ylz.his.zysf.bill.apiservice.impl.BillServiceImpl.onApplicationEvent : { timeSpan:3 } com.ylz.his.readcard.impl.ReadCardMainApiImpl.onApplicationEvent : { timeSpan:2 } , details: { LogEntry: {message: source='com.ylz.svc.transaction.lts.filter.LongTermTransactionFilter'level='INFO'source='LongTermTransactionFilter doFilter'} } }" }