SiQueryService.java 84 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649
  1. package thyyxxk.webserver.service.medicalinsurance;
  2. import com.alibaba.fastjson.JSONArray;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  5. import lombok.extern.slf4j.Slf4j;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.stereotype.Service;
  8. import thyyxxk.webserver.config.exception.ExceptionEnum;
  9. import thyyxxk.webserver.constants.sidicts.SiFunction;
  10. import thyyxxk.webserver.constants.YesOrNo;
  11. import thyyxxk.webserver.constants.sidicts.*;
  12. import thyyxxk.webserver.dao.his.medicalinsurance.SiQueryDao;
  13. import thyyxxk.webserver.dao.his.medicalinsurance.SiSetlinfoDao;
  14. import thyyxxk.webserver.entity.ResultVo;
  15. import thyyxxk.webserver.entity.dictionary.PureCodeName;
  16. import thyyxxk.webserver.entity.medicalinsurance.inpatient.InHspPsnInfo;
  17. import thyyxxk.webserver.entity.medicalinsurance.outpatient.SpcChrDiseAcct;
  18. import thyyxxk.webserver.entity.medicalinsurance.query.*;
  19. import thyyxxk.webserver.entity.medicalinsurance.setlinfo.SiSetldetail;
  20. import thyyxxk.webserver.entity.medicalinsurance.setlinfo.SiSetlinfo;
  21. import thyyxxk.webserver.entity.medicalinsurance.setlinfo.TimesList;
  22. import thyyxxk.webserver.entity.medicalinsurance.setllist.*;
  23. import thyyxxk.webserver.entity.yibao.ZyActpatient;
  24. import thyyxxk.webserver.service.redislike.RedisLikeService;
  25. import thyyxxk.webserver.service.wxapi.SendWxInfoService;
  26. import thyyxxk.webserver.utils.*;
  27. import java.math.BigDecimal;
  28. import java.time.LocalDate;
  29. import java.util.*;
  30. /**
  31. * @description: 医保查询服务
  32. * @author: DingJie
  33. * @create: 2021-06-23 16:35:23
  34. **/
  35. @Slf4j
  36. @Service
  37. public class SiQueryService {
  38. private final ExecService exec;
  39. private final SiQueryDao dao;
  40. private final SendWxInfoService wxsrvc;
  41. private final SiSetlinfoDao setlinfoDao;
  42. private final RedisLikeService redis;
  43. private static final String RESULT_CODE = "infcode";
  44. private static final String ERROR_MESSAGE = "err_msg";
  45. private static final String OUTPUT = "output";
  46. @Autowired
  47. public SiQueryService(ExecService exec, SiQueryDao dao, SendWxInfoService wxsrvc, SiSetlinfoDao setlinfoDao, RedisLikeService redis) {
  48. this.exec = exec;
  49. this.dao = dao;
  50. this.wxsrvc = wxsrvc;
  51. this.setlinfoDao = setlinfoDao;
  52. this.redis = redis;
  53. }
  54. public ResultVo<SiPatInfo> getSiPatInfo(QryPsnBsInfo qryPsnBsInfo) {
  55. SiPatInfo siPatInfo = dao.selectSiPatInfoForZy(qryPsnBsInfo.getPatNo(), qryPsnBsInfo.getTimes(), qryPsnBsInfo.getLedgerSn());
  56. if (null == siPatInfo) {
  57. siPatInfo = new SiPatInfo();
  58. }
  59. return ResultVoUtil.success(siPatInfo);
  60. }
  61. public ResultVo<String> fetchPsnNo(String socialNo, String admdvs) {
  62. if (StringUtil.isBlank(socialNo)) {
  63. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "患者的身份证不能为空,请补充!");
  64. }
  65. if (StringUtil.isBlank(admdvs)) {
  66. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "患者的参保地区不能为空,请补充!");
  67. }
  68. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.OBTAIN_BASIC_PERSON_INFO, admdvs);
  69. JSONObject data = new JSONObject();
  70. data.put("mdtrt_cert_type", MdtrtCertType.RESIDENT_IDENTITY_CARD.getCode());
  71. data.put("psn_cert_type", "01");
  72. data.put("mdtrt_cert_no", socialNo);
  73. data.put("certno", socialNo);
  74. input.getJSONObject("input").put("data", data);
  75. JSONObject result = exec.executeTrade(input, SiFunction.OBTAIN_BASIC_PERSON_INFO);
  76. log.info("【操作员:{}】,人员基本信息获取:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  77. if (null == result) {
  78. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  79. }
  80. if (null == result.getInteger(RESULT_CODE)) {
  81. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  82. }
  83. if (result.getIntValue(RESULT_CODE) == 0) {
  84. JSONObject output = result.getJSONObject(OUTPUT);
  85. JSONObject baseinfo = output.getJSONObject("baseinfo");
  86. String psnNo = baseinfo.getString("psn_no");
  87. if (StringUtil.notBlank(psnNo)) {
  88. return ResultVoUtil.success(psnNo);
  89. }
  90. }
  91. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "无法查询到患者的医保个人编码。");
  92. }
  93. public ResultVo<PsnBaseInfo> obtainBasicPersonInfo(QryPsnBsInfo qryPsnBsInfo) {
  94. if (null == qryPsnBsInfo.getOnlyQry() && StringUtil.isBlank(qryPsnBsInfo.getMedType())) {
  95. return ResultVoUtil.fail(ExceptionEnum.NULL_POINTER, "请选择患者的医疗类别!");
  96. }
  97. if (StringUtil.isBlank(qryPsnBsInfo.getSocialNo()) && StringUtil.notBlank(qryPsnBsInfo.getPatNo())
  98. && qryPsnBsInfo.getPatNo().length() >= 15) {
  99. qryPsnBsInfo.setSocialNo(qryPsnBsInfo.getPatNo());
  100. }
  101. if (StringUtil.isBlank(qryPsnBsInfo.getSocialNo())) {
  102. QryPsnBsInfo qpbi = dao.selectMzSocialAndName(qryPsnBsInfo.getPatNo());
  103. if (StringUtil.isBlank(qpbi.getSocialNo())) {
  104. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "患者的身份证不能为空,请补充!");
  105. }
  106. if (null == qryPsnBsInfo.getTimes()) {
  107. qryPsnBsInfo.setTimes(qpbi.getTimes());
  108. }
  109. qryPsnBsInfo.setName(qpbi.getName());
  110. qryPsnBsInfo.setSocialNo(qpbi.getSocialNo());
  111. qryPsnBsInfo.setLedgerSn(0);
  112. }
  113. if (null != qryPsnBsInfo.getLedgerSn() && qryPsnBsInfo.getLedgerSn() != 0) {
  114. qryPsnBsInfo.setLedgerSn(dao.selectMaxLedgerSn(qryPsnBsInfo.getPatNo(), qryPsnBsInfo.getTimes()));
  115. }
  116. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.OBTAIN_BASIC_PERSON_INFO, qryPsnBsInfo.getAdmdvs());
  117. JSONObject data = new JSONObject();
  118. if (qryPsnBsInfo.getSocialNo().length() < 15) {
  119. data.put("mdtrt_cert_type", MdtrtCertType.OTHER.getCode());
  120. data.put("psn_cert_type", PsnCertType.RESIDENCE_PERMIT_FOR_HMT.getCode());
  121. } else {
  122. data.put("mdtrt_cert_type", MdtrtCertType.RESIDENT_IDENTITY_CARD.getCode());
  123. data.put("psn_cert_type", "01");
  124. }
  125. data.put("mdtrt_cert_no", qryPsnBsInfo.getSocialNo());
  126. data.put("certno", qryPsnBsInfo.getSocialNo());
  127. if (StringUtil.notBlank(qryPsnBsInfo.getName())) {
  128. data.put("psn_name", qryPsnBsInfo.getName());
  129. }
  130. input.getJSONObject("input").put("data", data);
  131. JSONObject result = exec.executeTrade(input, SiFunction.OBTAIN_BASIC_PERSON_INFO);
  132. log.info("【操作员:{}】,人员基本信息获取:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  133. if (null == result) {
  134. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  135. }
  136. if (null == result.getInteger(RESULT_CODE)) {
  137. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  138. }
  139. if (result.getIntValue(RESULT_CODE) == 0) {
  140. JSONObject output = result.getJSONObject(OUTPUT);
  141. JSONObject baseinfo = output.getJSONObject("baseinfo");
  142. PsnBaseInfo psnBaseinfo = JSONObject.parseObject(baseinfo.toJSONString(), PsnBaseInfo.class);
  143. psnBaseinfo.setPatNo(qryPsnBsInfo.getPatNo());
  144. psnBaseinfo.setTimes(qryPsnBsInfo.getTimes());
  145. psnBaseinfo.setLedgerSn(qryPsnBsInfo.getLedgerSn());
  146. psnBaseinfo.setMedType(qryPsnBsInfo.getMedType());
  147. psnBaseinfo.setGendName(Gend.get(psnBaseinfo.getGend()).getName());
  148. psnBaseinfo.setPsnCertTypeName(PsnCertType.get(psnBaseinfo.getPsnCertType()).getName());
  149. Naty naty = Naty.get(psnBaseinfo.getNaty());
  150. if (null != naty) {
  151. psnBaseinfo.setNatyName(naty.getName());
  152. }
  153. List<IdetInfo> idetInfos = new ArrayList<>();
  154. JSONArray idet = output.getJSONArray("idetinfo");
  155. for (int i = 0; i < idet.size(); i++) {
  156. JSONObject item = idet.getJSONObject(i);
  157. IdetInfo info = JSONObject.parseObject(item.toJSONString(), IdetInfo.class);
  158. PsnIdetType psnIdetType = PsnIdetType.get(info.getPsnIdetType());
  159. if (null != psnIdetType) {
  160. psnBaseinfo.setPsnIdetType(psnIdetType.getCode());
  161. info.setPsnIdetTypeName(psnIdetType.getName());
  162. }
  163. idetInfos.add(info);
  164. }
  165. if (StringUtil.notBlank(psnBaseinfo.getPsnIdetType())) {
  166. dao.updatePsnIdetType(psnBaseinfo.getPsnIdetType(), psnBaseinfo.getPsnNo());
  167. }
  168. psnBaseinfo.setIdetinfo(idetInfos);
  169. if (new Integer(1).equals(qryPsnBsInfo.getNeedSaving())) {
  170. dao.updateZyActpatient(psnBaseinfo);
  171. int saved = dao.selectSiZyInfoCount(qryPsnBsInfo.getPatNo(), qryPsnBsInfo.getTimes(), qryPsnBsInfo.getLedgerSn());
  172. if (saved == 0) {
  173. dao.insertSiZyInfoPsnNo(psnBaseinfo);
  174. } else {
  175. dao.updateSiZyInfoPsnNo(psnBaseinfo);
  176. }
  177. log.info("患者基本信息已更新:{}", psnBaseinfo);
  178. output.put("times", qryPsnBsInfo.getTimes());
  179. }
  180. List<InsuInfo> list = new ArrayList<>();
  181. JSONArray insuinfo = output.getJSONArray("insuinfo");
  182. for (int i = 0; i < insuinfo.size(); i++) {
  183. JSONObject item = insuinfo.getJSONObject(i);
  184. InsuInfo info = JSONObject.parseObject(item.toJSONString(), InsuInfo.class);
  185. Insutype insutype = Insutype.get(info.getInsutype());
  186. if (null != insutype) {
  187. info.setInsutypeName(insutype.getName());
  188. }
  189. PsnType psnType = PsnType.get(info.getPsnType());
  190. if (null != psnType) {
  191. info.setPsnTypeName(psnType.getName());
  192. }
  193. if (null != info.getPsnInsuStas()) {
  194. if (info.getPsnInsuStas().equals(YesOrNo.YES.getCodeStr())) {
  195. info.setPsnInsuStasName("正常参保");
  196. } else {
  197. info.setPsnInsuStasName("暂停参保");
  198. }
  199. }
  200. if (null != info.getCvlservFlag()) {
  201. if (info.getCvlservFlag().equals(YesOrNo.YES.getCodeStr())) {
  202. info.setCvlservFlagName("是");
  203. } else {
  204. info.setCvlservFlagName("否");
  205. }
  206. }
  207. info.setInsuplcAdmdvsName(redis.getRegionName(info.getInsuplcAdmdvs()));
  208. list.add(info);
  209. }
  210. psnBaseinfo.setInsuinfo(list);
  211. return ResultVoUtil.success(psnBaseinfo);
  212. }
  213. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  214. }
  215. public ResultVo<List<MedInsInfo>> obtainMedicalInstitutionInfo(String type, String fuzzyName) {
  216. JSONObject input = exec.makeTradeHeader(SiFunction.OBTAIN_MEDICAL_INSTITUTION_INFO);
  217. JSONObject medinsinfo = new JSONObject();
  218. medinsinfo.put("fixmedins_type", type);
  219. medinsinfo.put("fixmedins_name", fuzzyName);
  220. input.getJSONObject("input").put("medinsinfo", medinsinfo);
  221. JSONObject result = exec.executeTrade(input, SiFunction.OBTAIN_MEDICAL_INSTITUTION_INFO);
  222. log.info("【操作员:{}】,获取定点医药机构信息:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  223. if (null == result) {
  224. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  225. }
  226. if (null == result.getInteger(RESULT_CODE)) {
  227. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  228. }
  229. if (result.getIntValue(RESULT_CODE) == 0) {
  230. JSONArray output = result.getJSONObject(OUTPUT).getJSONArray("medinsinfo");
  231. List<MedInsInfo> list = new ArrayList<>();
  232. for (int i = 0; i < output.size(); i++) {
  233. JSONObject item = output.getJSONObject(i);
  234. MedInsInfo info = JSONObject.parseObject(item.toJSONString(), MedInsInfo.class);
  235. info.setFixmedinsAdmdvs(info.getFixmedinsCode().substring(1, 7));
  236. info.setFixmedinsAdmdvsName(dao.selectRegionName(info.getFixmedinsAdmdvs()));
  237. FixmedinsType fixmedinsType = FixmedinsType.get(info.getFixmedinsType());
  238. if (null != fixmedinsType) {
  239. info.setFixmedinsTypeName(fixmedinsType.getName());
  240. }
  241. HospLv hospLv = HospLv.get(info.getHospLv());
  242. if (null != hospLv) {
  243. info.setHospLvName(hospLv.getName());
  244. }
  245. list.add(info);
  246. }
  247. return ResultVoUtil.success(list);
  248. }
  249. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  250. }
  251. public ResultVo<List<MdtrtInfo>> queryVisitInfo(BscQryPrm q) {
  252. PureCodeName codeName = dao.selectPsnNoByPatNoAndMedType(q.getPatNo(), q.getMedType());
  253. if (null == codeName) {
  254. return ResultVoUtil.fail(ExceptionEnum.NULL_POINTER, "没有找到患者该医疗类别的我院就诊记录。");
  255. }
  256. q.setPsnNo(codeName.getName());
  257. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_VISIT_INFO, codeName.getCode());
  258. String ref = JSONObject.toJSONStringWithDateFormat(q, "yyyy-MM-dd HH:mm:ss");
  259. input.getJSONObject("input").put("data", JSONObject.parseObject(ref));
  260. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_VISIT_INFO);
  261. log.info("【操作员:{}】,查询就诊信息:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  262. if (null == result) {
  263. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  264. }
  265. if (null == result.getInteger(RESULT_CODE)) {
  266. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  267. }
  268. if (result.getIntValue(RESULT_CODE) == 0) {
  269. JSONObject output = result.getJSONObject(OUTPUT);
  270. JSONArray mdts = output.getJSONArray("mdtrtinfo");
  271. List<MdtrtInfo> list = new ArrayList<>();
  272. for (int i = 0; i < mdts.size(); i++) {
  273. JSONObject item = mdts.getJSONObject(i);
  274. MdtrtInfo mdtrtInfo = JSONObject.parseObject(item.toJSONString(), MdtrtInfo.class);
  275. if (null != mdtrtInfo.getInsuOptins()) {
  276. mdtrtInfo.setInsuOptinsName(dao.selectRegionName(mdtrtInfo.getInsuOptins()));
  277. }
  278. SiEnumReflectUtil.mdtrtInfoReflect(mdtrtInfo);
  279. list.add(mdtrtInfo);
  280. }
  281. return ResultVoUtil.success(list);
  282. }
  283. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  284. }
  285. public ResultVo<List<DiseInfo>> queryDiagnosisInfo(BscQryPrm q) {
  286. String admdvs = dao.selectAdmdvsByPsnNo(q.getPsnNo());
  287. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_DIAGNOSIS_INFO, admdvs);
  288. JSONObject data = new JSONObject();
  289. data.put("psn_no", q.getPsnNo());
  290. data.put("mdtrt_id", q.getMdtrtId());
  291. input.getJSONObject("input").put("data", data);
  292. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_DIAGNOSIS_INFO);
  293. log.info("【操作员:{}】,查询诊断信息:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  294. if (null == result) {
  295. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  296. }
  297. if (null == result.getInteger(RESULT_CODE)) {
  298. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  299. }
  300. if (result.getIntValue(RESULT_CODE) == 0) {
  301. JSONObject output = result.getJSONObject(OUTPUT);
  302. List<DiseInfo> list = new ArrayList<>();
  303. JSONArray diseInfos = output.getJSONArray("diseinfo");
  304. for (int i = 0; i < diseInfos.size(); i++) {
  305. JSONObject item = diseInfos.getJSONObject(i);
  306. DiseInfo diseInfo = JSONObject.parseObject(item.toJSONString(), DiseInfo.class);
  307. SiEnumReflectUtil.diseInfoReflect(diseInfo);
  308. list.add(diseInfo);
  309. }
  310. return ResultVoUtil.success(list);
  311. }
  312. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  313. }
  314. public ResultVo<SetlInfo> querySettlementInfo(BscQryPrm q) {
  315. SiPatInfo siPatInfo;
  316. if (null == q.getMdtrtId()) {
  317. if (null == q.getLedgerSn()) {
  318. q.setLedgerSn(0);
  319. }
  320. siPatInfo = dao.selectSiPatInfoForZy(q.getPatNo(), q.getTimes(), q.getLedgerSn());
  321. } else {
  322. siPatInfo = dao.selectSiPatInfoByMdtrtId(q.getMdtrtId());
  323. }
  324. if (null == siPatInfo) {
  325. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "该次就诊尚未结算,无法查询结算信息。");
  326. }
  327. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_SETTLEMENT_INFO, siPatInfo.getInsuplcAdmdvs());
  328. JSONObject data = new JSONObject();
  329. data.put("psn_no", siPatInfo.getPsnNo());
  330. data.put("setl_id", siPatInfo.getSetlId());
  331. data.put("mdtrt_id", siPatInfo.getMdtrtId());
  332. input.getJSONObject("input").put("data", data);
  333. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_SETTLEMENT_INFO);
  334. log.info("【操作员:{}】,查询结算信息:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  335. if (null == result) {
  336. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  337. }
  338. if (null == result.getInteger(RESULT_CODE)) {
  339. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  340. }
  341. if (result.getIntValue(RESULT_CODE) == 0) {
  342. JSONObject output = result.getJSONObject(OUTPUT);
  343. JSONObject obj = output.getJSONObject("setlinfo");
  344. if (null == obj) {
  345. return ResultVoUtil.fail(ExceptionEnum.NULL_POINTER, "没有查询到该次就诊的结算明细。");
  346. }
  347. SetlInfo setlInfo = JSONObject.parseObject(obj.toJSONString(), SetlInfo.class);
  348. ClrType clrType = ClrType.get(setlInfo.getClrType());
  349. if (null != clrType) {
  350. setlInfo.setClrTypeName(clrType.getName());
  351. }
  352. MedType medType = MedType.get(setlInfo.getMedType());
  353. if (null != medType) {
  354. setlInfo.setMedTypeName(medType.getName());
  355. }
  356. Insutype insutype = Insutype.get(setlInfo.getInsutype());
  357. if (null != insutype) {
  358. setlInfo.setInsutypeName(insutype.getName());
  359. }
  360. PsnType psnType = PsnType.get(setlInfo.getPsnType());
  361. if (null != psnType) {
  362. setlInfo.setPsnTypeName(psnType.getName());
  363. }
  364. JSONArray setldetail = output.getJSONArray("setldetail");
  365. if (null != setldetail && setldetail.size() > 0) {
  366. List<SiSetldetail> list = new ArrayList<>();
  367. for (int i = 0; i < setldetail.size(); i++) {
  368. SiSetldetail setldtel = JSONObject.parseObject(setldetail.getJSONObject(i).toJSONString(), SiSetldetail.class);
  369. FundPayType fundPayType = FundPayType.get(setldtel.getFundPayType());
  370. if (null != fundPayType) {
  371. setldtel.setFundPayTypeName(fundPayType.getName());
  372. }
  373. list.add(setldtel);
  374. }
  375. setlInfo.setSetldetail(list);
  376. }
  377. return ResultVoUtil.success(setlInfo);
  378. }
  379. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  380. }
  381. public ResultVo<Map<String, Object>> queryFeeDetails(QryFeeDetl q) {
  382. SiPatInfo psninfo = dao.selectSiPatInfoByMdtrtId(q.getMdtrtId());
  383. if (null == psninfo) {
  384. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "没有找到此患者的医保登记信息。");
  385. }
  386. Map<String, Object> map = new HashMap<>();
  387. map.put("psninfo", psninfo);
  388. if (!q.getType().equals("settled")) {
  389. List<SiSetlFeeDetl> list = dao.selectTempCharge(psninfo.getPatNo(), psninfo.getTimes(), psninfo.getLedgerSn());
  390. if (null == list || list.isEmpty()) {
  391. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "此患者没有已经上传的医保费用。");
  392. }
  393. map.put("feedtle", list);
  394. map.put("analyse", analyseFeedtle(list));
  395. return ResultVoUtil.success(map);
  396. }
  397. List<SiSetlFeeDetl> list = dao.selectFeeDetlList(psninfo.getMdtrtId(), psninfo.getPatNo(), psninfo.getTimes(), psninfo.getLedgerSn());
  398. if (list.size() > 0) {
  399. map.put("feedtle", list);
  400. map.put("analyse", analyseFeedtle(list));
  401. return ResultVoUtil.success(map);
  402. }
  403. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_FEE_DETAILS, psninfo.getInsuplcAdmdvs());
  404. JSONObject data = new JSONObject();
  405. data.put("psn_no", psninfo.getPsnNo());
  406. data.put("setl_id", psninfo.getSetlId());
  407. data.put("mdtrt_id", psninfo.getMdtrtId());
  408. input.getJSONObject("input").put("data", data);
  409. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_FEE_DETAILS);
  410. log.info("【操作员:{}】,【就诊信息查询】查询费用明细:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  411. if (null == result) {
  412. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  413. }
  414. if (null == result.getInteger(RESULT_CODE)) {
  415. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  416. }
  417. if (result.getIntValue(RESULT_CODE) == 0) {
  418. JSONArray output = result.getJSONArray(OUTPUT);
  419. if (null == output || output.size() == 0) {
  420. return ResultVoUtil.fail(ExceptionEnum.NULL_POINTER, "没有查询到费用明细。");
  421. }
  422. for (int i = 0; i < output.size(); i++) {
  423. list.add(JSONObject.parseObject(output.getJSONObject(i).toJSONString(), SiSetlFeeDetl.class));
  424. if (list.size() == 30) {
  425. dao.insertSetlFeeDetlBatch(list);
  426. list.clear();
  427. }
  428. }
  429. if (list.size() > 0) {
  430. dao.insertSetlFeeDetlBatch(list);
  431. }
  432. list = dao.selectFeeDetlList(psninfo.getMdtrtId(), psninfo.getPatNo(), psninfo.getTimes(), psninfo.getLedgerSn());
  433. map.put("feedtle", list);
  434. map.put("analyse", analyseFeedtle(list));
  435. return ResultVoUtil.success(map);
  436. }
  437. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  438. }
  439. private Map<String, String[]> analyseFeedtle(List<SiSetlFeeDetl> fees) {
  440. Map<String, String[]> map = new HashMap<>();
  441. map.put("zhj", new String[]{"合计", "0.00", "0.00", "0.00"});
  442. fees.forEach(itm -> {
  443. if (StringUtil.isBlank(itm.getChrgitmLvName())) {
  444. ChrgitmLv chrgitmLv = ChrgitmLv.get(itm.getChrgitmLv());
  445. if (null == chrgitmLv) {
  446. chrgitmLv = ChrgitmLv.SELF_PAY;
  447. }
  448. itm.setChrgitmLvName(chrgitmLv.getName());
  449. }
  450. String[] all = map.get("zhj");
  451. all[1] = DecimalUtil.add(all[1], itm.getDetItemFeeSumamt());
  452. all[2] = DecimalUtil.add(all[2], itm.getInscpScpAmt());
  453. all[3] = DecimalUtil.add(all[3], DecimalUtil.minus(itm.getDetItemFeeSumamt(), itm.getInscpScpAmt()));
  454. if (map.containsKey(itm.getMedChrgitmType())) {
  455. String[] dtle = map.get(itm.getMedChrgitmType());
  456. dtle[1] = DecimalUtil.add(dtle[1], itm.getDetItemFeeSumamt());
  457. dtle[2] = DecimalUtil.add(dtle[2], itm.getInscpScpAmt());
  458. dtle[3] = DecimalUtil.add(dtle[3], DecimalUtil.minus(itm.getDetItemFeeSumamt(), itm.getInscpScpAmt()));
  459. } else {
  460. String[] dtle = new String[4];
  461. MedChrgitmType type = MedChrgitmType.get(itm.getMedChrgitmType());
  462. if (type == null) {
  463. type = MedChrgitmType.OTH;
  464. itm.setMedChrgitmType(type.getCode());
  465. }
  466. dtle[0] = type.getName();
  467. dtle[1] = itm.getDetItemFeeSumamt();
  468. dtle[2] = itm.getInscpScpAmt();
  469. dtle[3] = DecimalUtil.minus(itm.getDetItemFeeSumamt(), itm.getInscpScpAmt());
  470. map.put(type.getCode(), dtle);
  471. }
  472. });
  473. String total = map.get("zhj")[1];
  474. for (Map.Entry<String, String[]> entry : map.entrySet()) {
  475. if (!entry.getKey().equals("zhj")) {
  476. String percentage = DecimalUtil.percentage(entry.getValue()[1], total);
  477. entry.getValue()[0] = entry.getValue()[0] + "(" + percentage + ")";
  478. }
  479. }
  480. return map;
  481. }
  482. public ResultVo<List<TrtInfo>> checkPersonTreatment(BscQryPrm q) {
  483. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.CHECK_PERSON_TREATMENT,
  484. dao.selectAdmdvs(q.getPatNo(), q.getTimes()));
  485. JSONObject data = new JSONObject();
  486. data.put("psn_no", q.getPsnNo());
  487. data.put("insutype", q.getInsutype());
  488. data.put("fixmedins_code", SiUtil.INSTITUTION_ID);
  489. data.put("med_type", q.getMedType());
  490. data.put("begntime", DateUtil.formatDatetime(q.getBegntime()));
  491. input.getJSONObject("input").put("data", data);
  492. JSONObject result = exec.executeTrade(input, SiFunction.CHECK_PERSON_TREATMENT);
  493. log.info("【操作员:{}】,人员待遇享受检查:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  494. if (null == result) {
  495. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  496. }
  497. if (null == result.getInteger(RESULT_CODE)) {
  498. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  499. }
  500. if (result.getIntValue(RESULT_CODE) == 0) {
  501. List<TrtInfo> list = new ArrayList<>();
  502. JSONObject output = result.getJSONObject(OUTPUT);
  503. JSONArray trtinfo = output.getJSONArray("trtinfo");
  504. for (int i = 0; i < trtinfo.size(); i++) {
  505. JSONObject obj = trtinfo.getJSONObject(i);
  506. TrtInfo item = JSONObject.parseObject(obj.toJSONString(), TrtInfo.class);
  507. TrtChkType trtChkType = TrtChkType.get(item.getTrtChkType());
  508. if (null != trtChkType) {
  509. item.setTrtChkTypeName(trtChkType.getName());
  510. }
  511. FundPayType fundPayType = FundPayType.get(item.getFundPayType());
  512. if (null != fundPayType) {
  513. item.setFundPayTypeName(fundPayType.getName());
  514. }
  515. if (null != item.getTrtEnjymntFlag()) {
  516. if (item.getTrtEnjymntFlag().equals(YesOrNo.YES.getCodeStr())) {
  517. item.setTrtEnjymntFlagName("是");
  518. } else {
  519. item.setTrtEnjymntFlagName("否");
  520. }
  521. }
  522. list.add(item);
  523. }
  524. return ResultVoUtil.success(list);
  525. }
  526. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  527. }
  528. public ResultVo<List<InHspPsnInfo>> queryInHospitalPatientsInfo(BscQryPrm q) {
  529. if (StringUtil.notBlank(q.getPatNo())) {
  530. String psnNo = dao.selectPsnNo(q.getPatNo());
  531. if (null == psnNo) {
  532. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "【住院号/门诊号:" + q.getPatNo() +
  533. "】没有找到此患者在我院的医保在院信息,请核实。");
  534. }
  535. q.setPsnNo(psnNo);
  536. }
  537. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_IN_HOSPITAL_PATIENTS_INFO,
  538. dao.selectAdmdvsByPatNoAndPsnNo(q.getPatNo(), q.getPsnNo()));
  539. JSONObject data = new JSONObject();
  540. data.put("psn_no", q.getPsnNo());
  541. data.put("begntime", DateUtil.formatDatetime(q.getBegntime()));
  542. data.put("endtime", null == q.getEndtime() ? DateUtil.now() : DateUtil.formatDatetime(q.getEndtime()));
  543. input.getJSONObject("input").put("data", data);
  544. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_IN_HOSPITAL_PATIENTS_INFO);
  545. log.info("【操作员:{}】,在院信息查询:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  546. if (null == result) {
  547. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  548. }
  549. if (null == result.getInteger(RESULT_CODE)) {
  550. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  551. }
  552. if (result.getIntValue(RESULT_CODE) == 0) {
  553. JSONObject output = result.getJSONObject(OUTPUT);
  554. JSONArray pts = output.getJSONArray("data");
  555. if (pts.size() == 0) {
  556. return ResultVoUtil.fail(ExceptionEnum.NULL_POINTER, "没有查询到医保在院的患者信息。");
  557. }
  558. List<InHspPsnInfo> list = new ArrayList<>();
  559. for (int i = 0; i < pts.size(); i++) {
  560. JSONObject item = pts.getJSONObject(i);
  561. InHspPsnInfo inHspPsnInfo = JSONObject.parseObject(item.toJSONString(), InHspPsnInfo.class);
  562. SiEnumReflectUtil.inHspPsnInfoReflect(inHspPsnInfo);
  563. list.add(inHspPsnInfo);
  564. }
  565. if (list.size() == 1 && null != q.getTimes()) {
  566. InHspPsnInfo info = list.get(0);
  567. dao.updateInhospInfo(q.getPatNo(), q.getTimes(), q.getLedgerSn(), info.getMdtrtId(), info.getInsutype());
  568. }
  569. return ResultVoUtil.success(list);
  570. }
  571. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  572. }
  573. public ResultVo<List<RefMedin>> queryPersonnelTransferHospitalInfo(BscQryPrm q) {
  574. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_PERSONNEL_TRANSFER_HOSPITAL_INFO,
  575. dao.selectAdmdvsByPatNoAndPsnNo(q.getPatNo(), q.getPsnNo()));
  576. JSONObject data = new JSONObject();
  577. data.put("psn_no", q.getPsnNo());
  578. data.put("begntime", DateUtil.formatDatetime(q.getBegntime()));
  579. data.put("endtime", DateUtil.formatDatetime(q.getEndtime()));
  580. input.getJSONObject("input").put("data", data);
  581. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_PERSONNEL_TRANSFER_HOSPITAL_INFO);
  582. log.info("【操作员:{}】,转院信息查询:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  583. if (null == result) {
  584. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  585. }
  586. if (null == result.getInteger(RESULT_CODE)) {
  587. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  588. }
  589. if (result.getIntValue(RESULT_CODE) == 0) {
  590. JSONObject output = result.getJSONObject(OUTPUT);
  591. JSONArray array = output.getJSONArray("refmedin");
  592. if (null == array || array.size() == 0) {
  593. return ResultVoUtil.fail(ExceptionEnum.NULL_POINTER, "没有查询到符合条件的转院信息。");
  594. }
  595. List<RefMedin> list = new ArrayList<>();
  596. for (int i = 0; i < array.size(); i++) {
  597. JSONObject obj = array.getJSONObject(i);
  598. RefMedin item = JSONObject.parseObject(obj.toJSONString(), RefMedin.class);
  599. Insutype insutype = Insutype.get(item.getInsutype());
  600. if (null != insutype) {
  601. item.setInsutypeName(insutype.getName());
  602. }
  603. DclaSouc dclaSouc = DclaSouc.get(item.getDclaSouc());
  604. if (null != dclaSouc) {
  605. item.setDclaSoucName(dclaSouc.getName());
  606. }
  607. PsnCertType psnCertType = PsnCertType.get(item.getPsnCertType());
  608. if (null != psnCertType) {
  609. item.setPsnCertTypeName(psnCertType.getName());
  610. }
  611. item.setGendName(Gend.get(item.getGend()).getName());
  612. if (null != item.getInsuOptins()) {
  613. item.setInsuOptinsName(dao.selectRegionName(item.getInsuOptins()));
  614. }
  615. if (null != item.getOutFlag()) {
  616. if (item.getOutFlag().equals(YesOrNo.YES.getCodeStr())) {
  617. item.setOutFlagName("是");
  618. } else {
  619. item.setOutFlagName("否");
  620. }
  621. }
  622. if (null != item.getHospAgreReflFlag()) {
  623. if (item.getHospAgreReflFlag().equals(YesOrNo.YES.getCodeStr())) {
  624. item.setHospAgreReflFlagName("是");
  625. } else {
  626. item.setHospAgreReflFlagName("否");
  627. }
  628. }
  629. list.add(item);
  630. }
  631. return ResultVoUtil.success(list);
  632. }
  633. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  634. }
  635. public ResultVo<List<MedUseRcd>> querySpecialChronicDiseasesMedicalRecord(BscQryPrm q) {
  636. if (null == q.getPsnNo()) {
  637. String psnNo = dao.selectPsnNo(q.getPatNo());
  638. if (null == psnNo) {
  639. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "【住院号/门诊号:" + q.getPatNo() +
  640. "】未找到此患者的医保参保信息,请核实。");
  641. }
  642. q.setPsnNo(psnNo);
  643. }
  644. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_SPECIAL_CHRONIC_DISEASES_MEDICAL_RECORD,
  645. dao.selectAdmdvsByPsnNo(q.getPsnNo()));
  646. JSONObject data = new JSONObject();
  647. data.put("psn_no", q.getPsnNo());
  648. data.put("begntime", DateUtil.formatDatetime(q.getBegntime()));
  649. data.put("endtime", DateUtil.formatDatetime(q.getEndtime()));
  650. input.getJSONObject("input").put("data", data);
  651. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_SPECIAL_CHRONIC_DISEASES_MEDICAL_RECORD);
  652. log.info("【操作员:{}】,人员慢特病用药记录查询:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  653. if (null == result) {
  654. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  655. }
  656. if (null == result.getInteger(RESULT_CODE)) {
  657. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  658. }
  659. if (result.getIntValue(RESULT_CODE) == 0) {
  660. JSONObject output = result.getJSONObject(OUTPUT);
  661. JSONArray array = output.getJSONArray("feedetail");
  662. if (null == array || array.size() == 0) {
  663. return ResultVoUtil.fail(ExceptionEnum.NULL_POINTER, "没有查询到此人的慢特病用药记录。");
  664. }
  665. List<MedUseRcd> list = new ArrayList<>();
  666. for (int i = 0; i < array.size(); i++) {
  667. JSONObject obj = array.getJSONObject(i);
  668. MedUseRcd item = JSONObject.parseObject(obj.toJSONString(), MedUseRcd.class);
  669. list.add(item);
  670. }
  671. return ResultVoUtil.success(list);
  672. }
  673. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  674. }
  675. public ResultVo<List<CumInfo>> queryPersonnelCumulativeInfo(BscQryPrm q) {
  676. String admdvs = q.getAdmdvs();
  677. if (StringUtil.isBlank(admdvs)) {
  678. admdvs = dao.selectAdmdvsByPsnNo(q.getPsnNo());
  679. }
  680. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_PERSONNEL_CUMULATIVE_INFO, admdvs);
  681. JSONObject data = new JSONObject();
  682. data.put("psn_no", q.getPsnNo());
  683. data.put("cum_ym", q.getCumYm());
  684. input.getJSONObject("input").put("data", data);
  685. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_PERSONNEL_CUMULATIVE_INFO);
  686. log.info("【操作员:{}】,人员累计信息查询:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  687. if (null == result) {
  688. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  689. }
  690. if (null == result.getInteger(RESULT_CODE)) {
  691. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  692. }
  693. if (result.getIntValue(RESULT_CODE) == 0) {
  694. JSONObject output = result.getJSONObject(OUTPUT);
  695. JSONArray array = output.getJSONArray("cuminfo");
  696. List<CumInfo> list = new ArrayList<>();
  697. for (int i = 0; i < array.size(); i++) {
  698. JSONObject obj = array.getJSONObject(i);
  699. CumInfo item = JSONObject.parseObject(obj.toJSONString(), CumInfo.class);
  700. Insutype insutype = Insutype.get(item.getInsutype());
  701. if (null != insutype) {
  702. item.setInsutypeName(insutype.getName());
  703. }
  704. list.add(item);
  705. }
  706. return ResultVoUtil.success(list);
  707. }
  708. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  709. }
  710. public ResultVo<List<SpcChrDiseAcct>> querySpecialChronicDiseasesAccreditation(BscQryPrm q) {
  711. if (null == q.getPsnNo()) {
  712. String psnNo = dao.selectPsnNo(q.getPatNo());
  713. if (null == psnNo) {
  714. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "【住院号/门诊号:" + q.getPatNo() +
  715. "】未找到此患者的医保参保信息,请核实。");
  716. }
  717. q.setPsnNo(psnNo);
  718. }
  719. if (StringUtil.isBlank(q.getAdmdvs())) {
  720. String admdvs = StringUtil.isBlank(q.getPatNo()) ? dao.selectAdmdvsByPsnNo(q.getPsnNo())
  721. : dao.selectAdmdvsByPatNo(q.getPatNo());
  722. q.setAdmdvs(admdvs);
  723. }
  724. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_SPECIAL_CHRONIC_DISEASES_ACCREDITATION, q.getAdmdvs());
  725. JSONObject data = new JSONObject();
  726. data.put("psn_no", q.getPsnNo());
  727. input.getJSONObject("input").put("data", data);
  728. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_SPECIAL_CHRONIC_DISEASES_ACCREDITATION);
  729. log.info("【操作员:{}】,人员慢特病备案查询:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  730. if (null == result) {
  731. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  732. }
  733. if (null == result.getInteger(RESULT_CODE)) {
  734. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  735. }
  736. if (result.getIntValue(RESULT_CODE) == 0) {
  737. JSONObject output = result.getJSONObject(OUTPUT);
  738. JSONArray details = output.getJSONArray("feedetail");
  739. if (null == details || details.size() == 0) {
  740. return ResultVoUtil.fail(ExceptionEnum.NO_DATA_EXIST, "没有查询到此患者的慢特病备案信息。");
  741. }
  742. List<SpcChrDiseAcct> list = new ArrayList<>();
  743. Date now = new Date();
  744. for (int i = 0; i < details.size(); i++) {
  745. JSONObject detail = details.getJSONObject(i);
  746. SpcChrDiseAcct spcChrDiseAcct = JSONObject.parseObject(detail.toJSONString(), SpcChrDiseAcct.class);
  747. if (null != q.getNeedAllRcd() && 1 == q.getNeedAllRcd()) {
  748. list.add(spcChrDiseAcct);
  749. } else {
  750. if (now.before(spcChrDiseAcct.getEnddate())) {
  751. spcChrDiseAcct.setPatNo(q.getPatNo());
  752. spcChrDiseAcct.setTimes(q.getTimes());
  753. list.add(spcChrDiseAcct);
  754. }
  755. }
  756. }
  757. if (list.size() > 0) {
  758. return ResultVoUtil.success(list);
  759. }
  760. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "此患者没有有效的慢特病备案,或慢特病备案已过期!");
  761. }
  762. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  763. }
  764. public ResultVo<List<PsnFixMedin>> queryPersonnelAssignmentInfo(BscQryPrm q) {
  765. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_PERSONNEL_ASSIGNMENT_INFO, q.getAdmdvs());
  766. JSONObject data = new JSONObject();
  767. data.put("psn_no", q.getPsnNo());
  768. data.put("biz_appy_type", q.getBizAppyType());
  769. input.getJSONObject("input").put("data", data);
  770. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_PERSONNEL_ASSIGNMENT_INFO);
  771. log.info("【操作员:{}】,人员定点信息查询:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  772. if (null == result) {
  773. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  774. }
  775. if (null == result.getInteger(RESULT_CODE)) {
  776. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  777. }
  778. if (result.getIntValue(RESULT_CODE) == 0) {
  779. JSONObject output = result.getJSONObject(OUTPUT);
  780. JSONArray array = output.getJSONArray("psnfixmedin");
  781. if (null == array || array.size() == 0) {
  782. return ResultVoUtil.fail(ExceptionEnum.NULL_POINTER, "没有查询到对应的点定信息。");
  783. }
  784. List<PsnFixMedin> list = new ArrayList<>();
  785. for (int i = 0; i < array.size(); i++) {
  786. JSONObject obj = array.getJSONObject(i);
  787. PsnFixMedin item = JSONObject.parseObject(obj.toJSONString(), PsnFixMedin.class);
  788. Insutype insutype = Insutype.get(item.getInsutype());
  789. if (null != insutype) {
  790. item.setInsutypeName(insutype.getName());
  791. }
  792. list.add(item);
  793. }
  794. return ResultVoUtil.success(list);
  795. }
  796. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, result.getString(ERROR_MESSAGE));
  797. }
  798. public ResultVo<List<TimesList>> fetchSiTimesList(String patNo, Integer type) {
  799. List<TimesList> list = dao.fetchSiTimesList(patNo, type);
  800. if (null == list || list.isEmpty()) {
  801. return ResultVoUtil.fail(ExceptionEnum.NO_DATA_EXIST, "此患者没有有效的结算信息。");
  802. }
  803. return ResultVoUtil.success(list);
  804. }
  805. public ResultVo<String> queryInsuplcAdmdvsByMdtrtId(String mdtrtId) {
  806. return ResultVoUtil.success(dao.selectInsuplcAdmdvsByMdtrtId(mdtrtId));
  807. }
  808. public ResultVo querySiSetlList(SetlIndex index) {
  809. if (null == index.getTimes() && StringUtil.isBlank(index.getLabel())) {
  810. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "结算条目不能为空!");
  811. }
  812. if (StringUtil.notBlank(index.getLabel())) {
  813. String[] arr = index.getLabel().split("_");
  814. index.setSetlId(arr[0]);
  815. index.setTimes(Integer.parseInt(arr[1]));
  816. if (index.getType() == SetlType.INPATIENT.getCode()) {
  817. index.setLedgerSn(Integer.parseInt(arr[2]));
  818. } else {
  819. index.setLedgerSn(0);
  820. }
  821. } else {
  822. index.setLedgerSn(0);
  823. index.setSetlId(dao.selectSetlId(index.getPatNo(), index.getTimes(), index.getLedgerSn()));
  824. }
  825. SiPatInfo siPatInfo = dao.selectSiPatInfo(index.getPatNo(), index.getTimes(), index.getLedgerSn());
  826. if (null == siPatInfo) {
  827. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "没有找到此患者的结算信息!");
  828. }
  829. CuminfoInYear cuminfo = getYearCuminfo(siPatInfo.getPsnNo(), siPatInfo.getInsuplcAdmdvs());
  830. if (cuminfo.getCode() != ExceptionEnum.SUCCESS.getCode()) {
  831. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, cuminfo.getMessage());
  832. }
  833. if (index.getType() == SetlType.INPATIENT.getCode()) {
  834. InptntSetlmtLst lst = dao.selectZySetlinfo(index.getSetlId(), "zy_inactpatient");
  835. if (null == lst) {
  836. lst = dao.selectZySetlinfo(index.getSetlId(), "zy_actpatient");
  837. if (null == lst) {
  838. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "没有找到此患者的结算信息!");
  839. }
  840. }
  841. lst.setInHospdays(DateUtil.daysBetween(lst.getBegntime(), lst.getEndtime()) + 1);
  842. PsnIdetType psnIdetType = PsnIdetType.get(lst.getPsnIdetType());
  843. if (null != psnIdetType) {
  844. lst.setPsnIdetTypeName(psnIdetType.getName());
  845. }
  846. Admdvs admdvs = Admdvs.get(lst.getInsuplcAdmdvs());
  847. if (null == admdvs) {
  848. lst.setInsuplcAdmdvsName(dao.selectRegionName(lst.getInsuplcAdmdvs()));
  849. } else {
  850. lst.setInsuplcAdmdvsName(admdvs.getName());
  851. }
  852. lst.setFixmedinsName(SiUtil.INSTITUTION_NAME);
  853. lst.setGendName(Gend.get(lst.getGend()).getName());
  854. SiEnumReflectUtil.inptntSetlmtLstReflect(lst);
  855. ResultVo<List<SiSetlFeeDetl>> chrgrsvo = getChrgitems(lst.getPsnNo(), lst.getSetlId(), lst.getMdtrtId(), lst.getInsuplcAdmdvs());
  856. if (!chrgrsvo.getCode().equals(ExceptionEnum.SUCCESS.getCode())) {
  857. return chrgrsvo;
  858. }
  859. analyzeZyChrgitm(lst, chrgrsvo.getData());
  860. lst.setYrAdmtimes(cuminfo.getYearAdmtimesZy());
  861. lst.setYrAcmltvExpsClted(cuminfo.getYearPeriodfeeSumamtZy());
  862. lst.setYrMedfeeSumamt(cuminfo.getYearMedfeesumZy());
  863. lst.setYrPayedBegnLine(cuminfo.getYearPayedBegnlineZy());
  864. lst.setYrFundPaySumamt(cuminfo.getYearBaseFundPayAmtZy());
  865. lst.setYrBigAmtFundPay(cuminfo.getYearBigAmtpaysZy());
  866. lst.setYrBigDssInsPay(cuminfo.getYearBigdssFundPayAmtZy());
  867. lst.setYrMafPay(cuminfo.getYearMafPayAmtZy());
  868. lst.setYrPolicySelfPay(cuminfo.getYearPolicySelfPayZy());
  869. lst.setYrPreSelfPay(cuminfo.getYearPreSelfPayZy());
  870. lst.setYrBigDssFee(cuminfo.getYearBigDssLegalFee());
  871. return listPolItemCodePayInfo(lst);
  872. } else {
  873. index.setLedgerSn(0);
  874. OtptntSetlmtLst lst = dao.selectMzSetlifo(index.getPatNo(), index.getTimes());
  875. if (null == lst) {
  876. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "没有找到此患者的结算信息!");
  877. }
  878. Admdvs admdvs = Admdvs.get(lst.getInsuplcAdmdvs());
  879. if (null == admdvs) {
  880. lst.setInsuplcAdmdvsName(dao.selectRegionName(lst.getInsuplcAdmdvs()));
  881. } else {
  882. lst.setInsuplcAdmdvsName(admdvs.getName());
  883. }
  884. SiEnumReflectUtil.outptntSetlmtLstReflect(lst);
  885. List<BrfChrgitm> chrgitms = dao.selectMzBrfChrgitms(index.getPatNo(), index.getTimes());
  886. analyzeMzChrgitm(lst, chrgitms);
  887. lst.setYrAdmtimes(cuminfo.getYearAdmtimesMz());
  888. lst.setYrMedfeeSumamt(cuminfo.getYearMedfeesumMz());
  889. lst.setYrFundPaySumamt(cuminfo.getYearBaseFundPayAmtMz());
  890. lst.setYrBigAmtFundPay(cuminfo.getYearBigAmtpaysMz());
  891. lst.setYrBigDssFundPay(cuminfo.getYearBigdssFundPayAmtMz());
  892. lst.setYrAcctPay(cuminfo.getYearAcctPayMz());
  893. lst.setYrMafPay(cuminfo.getYearMafPayAmtMz());
  894. lst.setFixmedinsName(SiUtil.INSTITUTION_NAME);
  895. return ResultVoUtil.success(lst);
  896. }
  897. }
  898. private ResultVo<InptntSetlmtLst> listPolItemCodePayInfo(InptntSetlmtLst lst) {
  899. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.LIST_POL_ITEM_CODE_PAY_INFO, lst.getInsuplcAdmdvs());
  900. JSONObject data = new JSONObject();
  901. data.put("psn_no", lst.getPsnNo());
  902. data.put("mdtrt_id", lst.getMdtrtId());
  903. data.put("setl_id", lst.getSetlId());
  904. input.getJSONObject("input").put("data", data);
  905. JSONObject result = exec.executeTrade(input, SiFunction.LIST_POL_ITEM_CODE_PAY_INFO);
  906. log.info("【操作员:{}】,政策信息查询:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  907. if (null == result) {
  908. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  909. }
  910. if (null == result.getInteger("code")) {
  911. String message = result.getString("message");
  912. if (null == message) {
  913. message = result.getString(ERROR_MESSAGE);
  914. }
  915. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + message);
  916. }
  917. if (result.getIntValue("code") != 0) {
  918. String message = result.getString("message");
  919. if (null == message) {
  920. message = result.getString(ERROR_MESSAGE);
  921. }
  922. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心出错:" + message);
  923. }
  924. JSONArray array = result.getJSONArray("data");
  925. BigDecimal selfPaySum = new BigDecimal(0);
  926. BigDecimal fundPaySum = new BigDecimal(0);
  927. for (int i = 0; i < array.size(); i++) {
  928. JSONObject itm = array.getJSONObject(i);
  929. BigDecimal selfPayAmt = BigDecimal.valueOf(itm.getDouble("selfPayAmt"));
  930. String selfPayProp = itm.getString("selfPayProp");
  931. BigDecimal fundPayAmt = BigDecimal.valueOf(itm.getDouble("fundPayAmt"));
  932. String fundPayProp = itm.getString("fundPayProp");
  933. BigDecimal polItemPaySum = BigDecimal.valueOf(itm.getDouble("polItemPaySum"));
  934. selfPaySum = selfPaySum.add(selfPayAmt);
  935. fundPaySum = fundPaySum.add(fundPayAmt);
  936. PolItemCode polItemCode = PolItemCode.get(itm.getString("polItemCode"));
  937. if (null == polItemCode) {
  938. String message = String.format("找到了字典缺失的政策项:%s", itm);
  939. log.info(message);
  940. wxsrvc.sendCorpWxMsg("2801", message);
  941. continue;
  942. }
  943. switch (polItemCode) {
  944. case QZF:
  945. lst.setSelfPayPsnAmt(selfPayAmt);
  946. lst.setSelfPayPsnProp(selfPayProp);
  947. lst.setSelfPayFundAmt(fundPayAmt);
  948. lst.setSelfPayFundProp(fundPayProp);
  949. lst.setSelfPaySum(polItemPaySum);
  950. break;
  951. case YLXZF:
  952. lst.setScndPrePayPsnAmt(selfPayAmt);
  953. lst.setScndPrePayPsnProp(selfPayProp);
  954. lst.setScndPrePayFundAmt(fundPayAmt);
  955. lst.setScndPrePayFundProp(fundPayProp);
  956. lst.setScndPrePaySum(polItemPaySum);
  957. break;
  958. case CXEZF:
  959. lst.setOvrlmtSelfPayPsnAmt(selfPayAmt);
  960. lst.setOvrlmtSelfPayPsnProp(selfPayProp);
  961. lst.setOvrlmtSelfPayFundAmt(fundPayAmt);
  962. lst.setOvrlmtSelfPayFundProp(fundPayProp);
  963. lst.setOvrlmtSelfPaySum(polItemPaySum);
  964. break;
  965. case BCYFQFBZ:
  966. lst.setBegnlinePsnAmt(selfPayAmt);
  967. lst.setBegnlinePsnProp(selfPayProp);
  968. lst.setBegnlineFundAmt(fundPayAmt);
  969. lst.setBegnlineFundProp(fundPayProp);
  970. lst.setBegnlineSum(polItemPaySum);
  971. break;
  972. case TCYD:
  973. lst.setFundFrstLvPsnAmt(selfPayAmt);
  974. lst.setFundFrstLvPsnProp(selfPayProp);
  975. lst.setFundFrstLvFundAmt(fundPayAmt);
  976. lst.setFundFrstLvFundProp(fundPayProp);
  977. lst.setFundFrstLvSum(polItemPaySum);
  978. break;
  979. case TCED:
  980. lst.setFundScndLvPsnAmt(selfPayAmt);
  981. lst.setFundScndLvPsnProp(selfPayProp);
  982. lst.setFundScndLvFundAmt(fundPayAmt);
  983. lst.setFundScndLvFundProp(fundPayProp);
  984. lst.setFundScndLvSum(polItemPaySum);
  985. break;
  986. case DEYD:
  987. lst.setBigAmtFrstLvPsnAmt(selfPayAmt);
  988. lst.setBigAmtFrstLvPsnProp(selfPayProp);
  989. lst.setBigAmtFrstLvFundAmt(fundPayAmt);
  990. lst.setBigAmtFrstLvFundProp(fundPayProp);
  991. lst.setBigAmtFrstLvSum(polItemPaySum);
  992. break;
  993. }
  994. }
  995. lst.setAllPsnAmt(selfPaySum);
  996. lst.setAllFundAmt(fundPaySum);
  997. lst.setAllSum(fundPaySum.add(selfPaySum));
  998. return ResultVoUtil.success(lst);
  999. }
  1000. private CuminfoInYear getYearCuminfo(String psnNo, String admdvs) {
  1001. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_PERSONNEL_CUMULATIVE_INFO, admdvs);
  1002. JSONObject data = new JSONObject();
  1003. data.put("psn_no", psnNo);
  1004. data.put("cum_ym", "");
  1005. input.getJSONObject("input").put("data", data);
  1006. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_PERSONNEL_CUMULATIVE_INFO);
  1007. CuminfoInYear cuminfo = new CuminfoInYear();
  1008. if (null == result) {
  1009. cuminfo.setCode(ExceptionEnum.NETWORK_ERROR.getCode());
  1010. cuminfo.setMessage(ExceptionEnum.NETWORK_ERROR.getMessage());
  1011. return cuminfo;
  1012. }
  1013. if (null == result.getInteger(RESULT_CODE)) {
  1014. cuminfo.setCode(ExceptionEnum.LOGICAL_ERROR.getCode());
  1015. cuminfo.setMessage("医保中心报错:" + result.getString("message"));
  1016. return cuminfo;
  1017. }
  1018. if (result.getIntValue(RESULT_CODE) != 0) {
  1019. cuminfo.setCode(ExceptionEnum.NETWORK_ERROR.getCode());
  1020. cuminfo.setMessage("医保中心出错:" + result.getString("message"));
  1021. return cuminfo;
  1022. }
  1023. cuminfo.setCode(ExceptionEnum.SUCCESS.getCode());
  1024. String year = String.valueOf(LocalDate.now().getYear());
  1025. JSONArray cuminfos = result.getJSONObject(OUTPUT).getJSONArray("cuminfo");
  1026. log.info("累计信息:{}", cuminfos);
  1027. for (int i = 0; i < cuminfos.size(); i++) {
  1028. JSONObject itm = cuminfos.getJSONObject(i);
  1029. if (itm.getString("year").equals(year)) {
  1030. switch (itm.getString("cum_type_code")) {
  1031. // 本年住院次数
  1032. case "C0000_BIZ2101":
  1033. case "C0000_BIZ2102":
  1034. case "C0000_BIZ2106":
  1035. case "C0000_BIZ2107":
  1036. case "C0000_BIZ22":
  1037. case "C0000_BIZ52":
  1038. cuminfo.addYearAdmtimesZy(itm.getDoubleValue("cum"));
  1039. break;
  1040. // 本年门诊次数
  1041. case "C0000_BIZ11":
  1042. case "C0000_BIZ13":
  1043. case "C0000_BIZ14":
  1044. case "C0000_BIZ51":
  1045. case "C0000_BIZ9901":
  1046. case "C0000_BIZ9903":
  1047. case "C0000_BIZ9904":
  1048. cuminfo.addYearAdmtimesMz(itm.getDoubleValue("cum"));
  1049. break;
  1050. // 本年度住院分段计算费用累计
  1051. case "S0000_BIZ2101":
  1052. case "S0000_BIZ2102":
  1053. case "S0000_BIZ2106":
  1054. case "S0000_BIZ2107":
  1055. case "S0000_BIZ22":
  1056. case "S0000_BIZ52":
  1057. cuminfo.addYearPeriodFeeSumZy(itm.getDoubleValue("cum"));
  1058. break;
  1059. // 住院医疗费合计
  1060. case "F0000_BIZ2101":
  1061. case "F0000_BIZ2102":
  1062. case "F0000_BIZ2106":
  1063. case "F0000_BIZ2107":
  1064. case "F0000_BIZ22":
  1065. case "F0000_BIZ52":
  1066. cuminfo.addYearFeesumZy(itm.getDoubleValue("cum"));
  1067. break;
  1068. // 门诊医疗费合计
  1069. case "F0000_BIZ11":
  1070. case "F0000_BIZ13":
  1071. case "F0000_BIZ14":
  1072. case "F0000_BIZ51":
  1073. case "F0000_BIZ9901":
  1074. case "F0000_BIZ9903":
  1075. case "F0000_BIZ9904":
  1076. cuminfo.addYearFeesumMz(itm.getDoubleValue("cum"));
  1077. break;
  1078. // 住院已付起付线
  1079. case "Q0000_BIZ2101":
  1080. case "Q0000_BIZ2102":
  1081. case "Q0000_BIZ2106":
  1082. case "Q0000_BIZ2107":
  1083. case "Q0000_BIZ22":
  1084. case "Q0000_BIZ52":
  1085. cuminfo.addYearPayedbegnlineZy(itm.getDoubleValue("cum"));
  1086. break;
  1087. // 住院统筹支付
  1088. case "D310101_BIZ2101":
  1089. case "D310101_BIZ2102":
  1090. case "D310101_BIZ2106":
  1091. case "D310101_BIZ2107":
  1092. case "D310101_BIZ22":
  1093. case "D310101_BIZ52":
  1094. case "D390101_BIZ2101":
  1095. case "D390101_BIZ2102":
  1096. case "D390101_BIZ2106":
  1097. case "D390101_BIZ2107":
  1098. case "D390101_BIZ22":
  1099. case "D390101_BIZ52":
  1100. cuminfo.addYearFundpaysZy(itm.getDoubleValue("cum"));
  1101. break;
  1102. // 门诊统筹支付
  1103. case "D310101_BIZ11":
  1104. case "D310101_BIZ13":
  1105. case "D310101_BIZ14":
  1106. case "D310101_BIZ51":
  1107. case "D310101_BIZ9901":
  1108. case "D310101_BIZ9903":
  1109. case "D310101_BIZ9904":
  1110. case "D390101_BIZ11":
  1111. case "D390101_BIZ13":
  1112. case "D390101_BIZ14":
  1113. case "D390101_BIZ51":
  1114. case "D390101_BIZ9901":
  1115. case "D390101_BIZ9903":
  1116. case "D390101_BIZ9904":
  1117. cuminfo.addYearFundpaysMz(itm.getDoubleValue("cum"));
  1118. break;
  1119. // 政策自费
  1120. case "Z0000_BIZ2101_LAB101":
  1121. case "Z0000_BIZ2102_LAB101":
  1122. case "Z0000_BIZ22_LAB101":
  1123. case "Z0000_BIZ2106_LAB101":
  1124. case "Z0000_BIZ2107_LAB101":
  1125. case "Z0000_BIZ52_LAB101":
  1126. case "Z0000_BIZ2101_LAB103":
  1127. case "Z0000_BIZ2102_LAB103":
  1128. case "Z0000_BIZ22_LAB103":
  1129. case "Z0000_BIZ2106_LAB103":
  1130. case "Z0000_BIZ2107_LAB103":
  1131. case "Z0000_BIZ52_LAB103":
  1132. cuminfo.addYearPolicySelfpayZy(itm.getDoubleValue("cum"));
  1133. break;
  1134. // 政策自付
  1135. case "Z0000_BIZ2101_LAB102":
  1136. case "Z0000_BIZ2102_LAB102":
  1137. case "Z0000_BIZ22_LAB102":
  1138. case "Z0000_BIZ2106_LAB102":
  1139. case "Z0000_BIZ2107_LAB102":
  1140. case "Z0000_BIZ52_LAB102":
  1141. cuminfo.addYearPreSelfpayZy(itm.getDoubleValue("cum"));
  1142. break;
  1143. // 住院大额基金支付
  1144. case "D330101_BIZ2101":
  1145. case "D330101_BIZ2102":
  1146. case "D330101_BIZ2106":
  1147. case "D330101_BIZ2107":
  1148. case "D330101_BIZ22":
  1149. case "D330101_BIZ52":
  1150. cuminfo.addYearBigAmtpaysZy(itm.getDoubleValue("cum"));
  1151. break;
  1152. // 门诊大额基金支付
  1153. case "D330101_BIZ11":
  1154. case "D330101_BIZ13":
  1155. case "D330101_BIZ14":
  1156. case "D330101_BIZ51":
  1157. case "D330101_BIZ9901":
  1158. case "D330101_BIZ9903":
  1159. case "D330101_BIZ9904":
  1160. cuminfo.addYearBigAmtpaysMz(itm.getDoubleValue("cum"));
  1161. break;
  1162. // 住院大病保险支付
  1163. case "D390201_BIZ2101":
  1164. case "D390201_BIZ2102":
  1165. case "D390201_BIZ2106":
  1166. case "D390201_BIZ2107":
  1167. case "D390201_BIZ22":
  1168. case "D390201_BIZ52":
  1169. cuminfo.addYearBigdssInspaysZy(itm.getDoubleValue("cum"));
  1170. break;
  1171. // 门诊大病保险支付
  1172. case "D390201_BIZ11":
  1173. case "D390201_BIZ13":
  1174. case "D390201_BIZ14":
  1175. case "D390201_BIZ51":
  1176. case "D390201_BIZ9901":
  1177. case "D390201_BIZ9903":
  1178. case "D390201_BIZ9904":
  1179. cuminfo.addYearBigdssInspaysMz(itm.getDoubleValue("cum"));
  1180. break;
  1181. // 住院医疗救助支付
  1182. case "D610101_BIZ2101":
  1183. case "D610101_BIZ2102":
  1184. case "D610101_BIZ2106":
  1185. case "D610101_BIZ2107":
  1186. case "D610101_BIZ22":
  1187. case "D610101_BIZ52":
  1188. cuminfo.addYearMafpaysZy(itm.getDoubleValue("cum"));
  1189. break;
  1190. // 门诊医疗救助支付
  1191. case "D610101_BIZ11":
  1192. case "D610101_BIZ13":
  1193. case "D610101_BIZ14":
  1194. case "D610101_BIZ51":
  1195. case "D610101_BIZ9901":
  1196. case "D610101_BIZ9903":
  1197. case "D610101_BIZ9904":
  1198. cuminfo.addYearMafpaysMz(itm.getDoubleValue("cum"));
  1199. break;
  1200. // 门诊个人账户支付
  1201. case "D310201_BIZ11":
  1202. case "D310201_BIZ13":
  1203. case "D310201_BIZ14":
  1204. case "D310201_BIZ51":
  1205. case "D310201_BIZ9901":
  1206. case "D310201_BIZ9903":
  1207. case "D310201_BIZ9904":
  1208. cuminfo.addYearAcctPayMz(itm.getDoubleValue("cum"));
  1209. break;
  1210. // 大病保险合规费用
  1211. case "TS390201":
  1212. cuminfo.addYearBigdssLegalFee(itm.getDoubleValue("cum"));
  1213. break;
  1214. }
  1215. }
  1216. }
  1217. return cuminfo;
  1218. }
  1219. private ResultVo<List<SiSetlFeeDetl>> getChrgitems(String psnNo, String setlId, String mdtrtId, String admdvs) {
  1220. List<SiSetlFeeDetl> list = dao.selectAllSetlFeeDtle(mdtrtId);
  1221. if (list.size() > 0) {
  1222. return ResultVoUtil.success(list);
  1223. }
  1224. JSONObject input = exec.makeTradeHeaderWithInsureArea(SiFunction.QUERY_FEE_DETAILS, admdvs);
  1225. JSONObject data = new JSONObject();
  1226. data.put("psn_no", psnNo);
  1227. data.put("setl_id", setlId);
  1228. data.put("mdtrt_id", mdtrtId);
  1229. input.getJSONObject("input").put("data", data);
  1230. JSONObject result = exec.executeTrade(input, SiFunction.QUERY_FEE_DETAILS);
  1231. log.info("【操作员:{}】,【结算单查询】查询费用明细:\n参数:{},\n结果:{}", TokenUtil.getTokenUserId(), input, result);
  1232. if (null == result) {
  1233. return ResultVoUtil.fail(ExceptionEnum.NETWORK_ERROR);
  1234. }
  1235. if (null == result.getInteger(RESULT_CODE)) {
  1236. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保中心报错:" + result.getString("message"));
  1237. }
  1238. if (0 == result.getInteger(RESULT_CODE)) {
  1239. JSONArray output = result.getJSONArray(OUTPUT);
  1240. if (null == output || output.size() == 0) {
  1241. return ResultVoUtil.fail(ExceptionEnum.NO_DATA_EXIST, "没有查询到费用明细。");
  1242. }
  1243. for (int i = 0; i < output.size(); i++) {
  1244. SiSetlFeeDetl fee = JSONObject.parseObject(output.getJSONObject(i).toJSONString(), SiSetlFeeDetl.class);
  1245. if (StringUtil.isBlank(fee.getSetlId())) {
  1246. fee.setSetlId(setlId);
  1247. }
  1248. list.add(fee);
  1249. if (list.size() == 30) {
  1250. dao.insertSetlFeeDetlBatch(list);
  1251. list.clear();
  1252. }
  1253. }
  1254. if (list.size() > 0) {
  1255. dao.insertSetlFeeDetlBatch(list);
  1256. }
  1257. return ResultVoUtil.success(dao.selectAllSetlFeeDtle(mdtrtId));
  1258. }
  1259. return ResultVoUtil.fail(ExceptionEnum.INTERNAL_SERVER_ERROR, result.getString(ERROR_MESSAGE));
  1260. }
  1261. private void analyzeZyChrgitm(InptntSetlmtLst lst, List<SiSetlFeeDetl> chrgitms) {
  1262. Map<String, BigDecimal> map = new HashMap<>();
  1263. map.put("allfeeSum", new BigDecimal(0));
  1264. map.put("totalFrst", new BigDecimal(0));
  1265. map.put("totalScnd", new BigDecimal(0));
  1266. chrgitms.forEach(itm -> {
  1267. BigDecimal itmfeeSum = new BigDecimal(itm.getDetItemFeeSumamt());
  1268. map.replace("allfeeSum", map.get("allfeeSum").add(itmfeeSum));
  1269. if (itm.getChrgitmLv().equals(ChrgitmLv.FIRST_CLASS.getCode())) {
  1270. map.replace("totalFrst", map.get("totalFrst").add(itmfeeSum));
  1271. } else if (itm.getChrgitmLv().equals(ChrgitmLv.SECOND_CLASS.getCode())) {
  1272. map.replace("totalScnd", map.get("totalScnd").add(itmfeeSum));
  1273. }
  1274. String typeKey = itm.getMedChrgitmType();
  1275. String lvKey = typeKey + "-" + itm.getChrgitmLv();
  1276. if (map.containsKey(typeKey)) {
  1277. map.replace(typeKey, map.get(typeKey).add(itmfeeSum));
  1278. } else {
  1279. map.put(typeKey, itmfeeSum);
  1280. }
  1281. if (map.containsKey(lvKey)) {
  1282. map.replace(lvKey, map.get(lvKey).add(itmfeeSum));
  1283. } else {
  1284. map.put(lvKey, itmfeeSum);
  1285. }
  1286. });
  1287. lst.setAllfeeSum(map.get("allfeeSum"));
  1288. lst.setAllfeeFrst(map.get("totalFrst"));
  1289. lst.setAllfeeScnd(map.get("totalScnd"));
  1290. lst.setWestMedFeeSum(map.get("09"));
  1291. lst.setWestMedFeeFrst(map.get("09-01"));
  1292. lst.setWestMedFeeScnd(map.get("09-02"));
  1293. lst.setHerbalSum(map.get("10"));
  1294. lst.setHerbalFrst(map.get("10-01"));
  1295. lst.setHerbalScnd(map.get("10-02"));
  1296. lst.setChnsPtntSum(map.get("11"));
  1297. lst.setChnsPtntFrst(map.get("11-01"));
  1298. lst.setChnsPtntScnd(map.get("11-02"));
  1299. lst.setClinicSum(map.get("02"));
  1300. lst.setClinicFrst(map.get("02-01"));
  1301. lst.setClinicScnd(map.get("02-02"));
  1302. lst.setTreatSum(map.get("05"));
  1303. lst.setTreatFrst(map.get("05-01"));
  1304. lst.setTreatScnd(map.get("05-02"));
  1305. lst.setSurgerySum(map.get("06"));
  1306. lst.setSurgeryFrst(map.get("06-01"));
  1307. lst.setSurgeryScnd(map.get("06-02"));
  1308. lst.setNursingSum(map.get("07"));
  1309. lst.setNursingFrst(map.get("07-01"));
  1310. lst.setNursingScnd(map.get("07-02"));
  1311. lst.setSntryMtrlsSum(map.get("08"));
  1312. lst.setSntryMtrlsFrst(map.get("08-01"));
  1313. lst.setSntryMtrlsScnd(map.get("08-02"));
  1314. lst.setExamSum(map.get("04"));
  1315. lst.setExamFrst(map.get("04-01"));
  1316. lst.setExamScnd(map.get("04-02"));
  1317. lst.setNrmlTrtmtSum(map.get("12"));
  1318. lst.setNrmlTrtmtFrst(map.get("12-01"));
  1319. lst.setNrmlTrtmtScnd(map.get("12-02"));
  1320. lst.setInspectSum(map.get("03"));
  1321. lst.setInspectFrst(map.get("03-01"));
  1322. lst.setInspectScnd(map.get("03-02"));
  1323. lst.setRegisterSum(map.get("13"));
  1324. lst.setRegisterFrst(map.get("13-01"));
  1325. lst.setRegisterScnd(map.get("13-02"));
  1326. lst.setBedfeeSum(map.get("01"));
  1327. lst.setBedfeeFrst(map.get("01-01"));
  1328. lst.setBedfeeScnd(map.get("01-02"));
  1329. lst.setOthfeeSum(map.get("14"));
  1330. lst.setOthfeeFrst(map.get("14-01"));
  1331. lst.setOthfeeScnd(map.get("14-02"));
  1332. }
  1333. private void analyzeMzChrgitm(OtptntSetlmtLst lst, List<BrfChrgitm> chrgitms) {
  1334. Map<String, BigDecimal> map = new HashMap<>();
  1335. map.put("allfeeSum", BigDecimal.valueOf(0));
  1336. map.put("totalThrd", BigDecimal.valueOf(0));
  1337. map.put("totalScnd", BigDecimal.valueOf(0));
  1338. map.put("othSum", BigDecimal.valueOf(0));
  1339. map.put("othThrd", BigDecimal.valueOf(0));
  1340. map.put("othScnd", BigDecimal.valueOf(0));
  1341. chrgitms.forEach(itm -> {
  1342. map.replace("allfeeSum", map.get("allfeeSum").add(BigDecimal.valueOf(itm.getChargeFee())));
  1343. if (itm.getChrgitmLv().equals(ChrgitmLv.SELF_PAY.getCode())) {
  1344. map.replace("totalThrd", map.get("totalThrd").add(BigDecimal.valueOf(itm.getChargeFee())));
  1345. } else if (itm.getChrgitmLv().equals(ChrgitmLv.SECOND_CLASS.getCode())) {
  1346. map.replace("totalScnd", map.get("totalScnd").add(BigDecimal.valueOf(itm.getChargeFee())));
  1347. }
  1348. String typeKey = itm.getMedChrgitmType();
  1349. if (!typeKey.equals("09") && !typeKey.equals("11")) {
  1350. map.replace("othSum", map.get("othSum").add(BigDecimal.valueOf(itm.getChargeFee())));
  1351. if (itm.getChrgitmLv().equals(ChrgitmLv.SELF_PAY.getCode())) {
  1352. map.replace("othThrd", map.get("othThrd").add(BigDecimal.valueOf(itm.getChargeFee())));
  1353. } else if (itm.getChrgitmLv().equals(ChrgitmLv.SECOND_CLASS.getCode())) {
  1354. map.replace("othScnd", map.get("othScnd").add(BigDecimal.valueOf(itm.getChargeFee())));
  1355. }
  1356. } else {
  1357. String lvKey = typeKey + "-" + itm.getChrgitmLv();
  1358. if (map.containsKey(typeKey)) {
  1359. map.replace(typeKey, map.get(typeKey).add(BigDecimal.valueOf(itm.getChargeFee())));
  1360. } else {
  1361. map.put(typeKey, BigDecimal.valueOf(itm.getChargeFee()));
  1362. }
  1363. if (map.containsKey(lvKey)) {
  1364. map.replace(lvKey, map.get(lvKey).add(BigDecimal.valueOf(itm.getChargeFee())));
  1365. } else {
  1366. map.put(lvKey, BigDecimal.valueOf(itm.getChargeFee()));
  1367. }
  1368. }
  1369. });
  1370. lst.setAllfeeSum(map.get("allfeeSum"));
  1371. lst.setAllfeeThrd(map.get("totalThrd"));
  1372. lst.setAllfeeScnd(map.get("totalScnd"));
  1373. lst.setWestMedFeeSum(map.get("09"));
  1374. lst.setWestMedFeeThrd(map.get("09-03"));
  1375. lst.setWestMedFeeScnd(map.get("09-02"));
  1376. lst.setChnsPtntSum(map.get("11"));
  1377. lst.setChnsPtntThrd(map.get("11-03"));
  1378. lst.setChnsPtntScnd(map.get("11-02"));
  1379. lst.setMedsrvcSum(map.get("othSum"));
  1380. lst.setMedsrvcThrd(map.get("othThrd"));
  1381. lst.setMedsrvcScnd(map.get("othScnd"));
  1382. }
  1383. public ResultVo<List<SiMzMatnDise>> queryMzMatnDises() {
  1384. return ResultVoUtil.success(dao.selectAllMzMatnDises());
  1385. }
  1386. public ResultVo<List<SetlStatisticResult>> selectSetlinfoStatistics(SetlCondition condition) {
  1387. String begntime = condition.getMonth() + "-01 00:00:00.000";
  1388. String endtime = DateUtil.getMonthEndtime(condition.getMonth());
  1389. String insutype = condition.getInsutype();
  1390. if (StringUtil.isBlank(insutype)) {
  1391. insutype = "%%";
  1392. }
  1393. List<BaseSetlStatistics> baseStatistics;
  1394. switch (condition.getAdmdvsType()) {
  1395. case 1:
  1396. baseStatistics = dao.selectBaseSetlStatisticsInProvinceLevel(begntime, endtime, insutype, condition.getSetlType());
  1397. break;
  1398. case 2:
  1399. baseStatistics = dao.selectBaseSetlStatisticsInChangshaCity(begntime, endtime, insutype, condition.getSetlType());
  1400. break;
  1401. case 3:
  1402. baseStatistics = dao.selectBaseSetlStatisticsInProvinceOtherCities(begntime, endtime, insutype, condition.getSetlType());
  1403. break;
  1404. case 4:
  1405. baseStatistics = dao.selectBaseSetlStatisticsOutProvince(begntime, endtime, insutype, condition.getSetlType());
  1406. break;
  1407. case 5:
  1408. baseStatistics = dao.selectBaseSetlStatisticsInChangshaCounty(begntime, endtime, insutype, condition.getSetlType());
  1409. break;
  1410. case 6:
  1411. baseStatistics = dao.selectBaseSetlStatisticsInLiuYangCity(begntime, endtime, insutype, condition.getSetlType());
  1412. break;
  1413. default:
  1414. baseStatistics = dao.selectBaseSetlStatisticsInAllPlaces(begntime, endtime, insutype, condition.getSetlType());
  1415. break;
  1416. }
  1417. if (null == baseStatistics || baseStatistics.isEmpty()) {
  1418. return ResultVoUtil.fail(ExceptionEnum.NO_DATA_EXIST);
  1419. }
  1420. Map<String, String> regionMap = new HashMap<>();
  1421. Map<String, List<BaseSetlStatistics>> admdvsSetldataMap = new HashMap<>();
  1422. List<BaseSetlStatistics> shangChuanJieSuanDan = new ArrayList<>();
  1423. baseStatistics.forEach(itm -> {
  1424. itm.setInsutypeName(Insutype.getName(itm.getInsutype()));
  1425. if (null != itm.getHospPay()) {
  1426. itm.setFundPaySumamt(DecimalUtil.minus(itm.getFundPaySumamt(), itm.getHospPay()));
  1427. }
  1428. String key;
  1429. if (condition.getAdmdvsType() == 5 || condition.getAdmdvsType() == 6) {
  1430. key = itm.getInsuplcAdmdvs();
  1431. } else {
  1432. key = itm.getInsuplcAdmdvs().substring(0, 4) + "00";
  1433. }
  1434. String admdvsName = regionMap.get(key);
  1435. if (null == admdvsName) {
  1436. PureCodeName region = dao.selectAdmdvsNameAndParentName(key);
  1437. if (null == region) {
  1438. region = dao.selectAdmdvsName(key);
  1439. }
  1440. admdvsName = region.getCode() + region.getName();
  1441. regionMap.put(key, admdvsName);
  1442. }
  1443. if (admdvsSetldataMap.containsKey(admdvsName)) {
  1444. admdvsSetldataMap.get(admdvsName).add(itm);
  1445. } else {
  1446. List<BaseSetlStatistics> tempList = new ArrayList<>();
  1447. tempList.add(itm);
  1448. admdvsSetldataMap.put(admdvsName, tempList);
  1449. }
  1450. shangChuanJieSuanDan.add(itm);
  1451. });
  1452. List<SetlStatisticResult> resultList = new ArrayList<>();
  1453. for (Map.Entry<String, List<BaseSetlStatistics>> entry : admdvsSetldataMap.entrySet()) {
  1454. List<BaseSetlStatistics> admdvsSetldataList = entry.getValue();
  1455. SetlStatisticResult resultItem = new SetlStatisticResult();
  1456. resultItem.setAdmdvsName(entry.getKey());
  1457. resultItem.setInsuplcAdmdvs(entry.getValue().get(0).getInsuplcAdmdvs().substring(0, 4) + "00");
  1458. resultItem.setPsnSumamt(admdvsSetldataList.size());
  1459. if (StringUtil.notBlank(condition.getInsutype())) {
  1460. resultItem.setInsutype(condition.getInsutype());
  1461. resultItem.setInsutypeName(Insutype.getName(condition.getInsutype()));
  1462. resultItem.setChildKey(entry.getKey() + "-" + resultItem.getInsutypeName());
  1463. } else {
  1464. resultItem.setInsutypeName("-");
  1465. resultItem.setChildKey(entry.getKey());
  1466. }
  1467. fillSetlStatisticResult(resultList, admdvsSetldataList, resultItem);
  1468. }
  1469. if (StringUtil.isBlank(condition.getInsutype())) {
  1470. for (SetlStatisticResult resultItem : resultList) {
  1471. Map<String, List<BaseSetlStatistics>> insutypeSetldataMap = new HashMap<>();
  1472. String admdvsName = resultItem.getAdmdvsName();
  1473. List<BaseSetlStatistics> admdvsSetldataList = admdvsSetldataMap.get(admdvsName);
  1474. for (BaseSetlStatistics baseSetlStatistics : admdvsSetldataList) {
  1475. if (insutypeSetldataMap.containsKey(baseSetlStatistics.getInsutypeName())) {
  1476. insutypeSetldataMap.get(baseSetlStatistics.getInsutypeName()).add(baseSetlStatistics);
  1477. } else {
  1478. List<BaseSetlStatistics> tmpList = new ArrayList<>();
  1479. tmpList.add(baseSetlStatistics);
  1480. insutypeSetldataMap.put(baseSetlStatistics.getInsutypeName(), tmpList);
  1481. }
  1482. }
  1483. if (insutypeSetldataMap.size() == 1) {
  1484. resultItem.setInsutype(admdvsSetldataList.get(0).getInsutype());
  1485. resultItem.setInsutypeName(admdvsSetldataList.get(0).getInsutypeName());
  1486. continue;
  1487. }
  1488. List<SetlStatisticResult> children = new ArrayList<>();
  1489. for (Map.Entry<String, List<BaseSetlStatistics>> entry : insutypeSetldataMap.entrySet()) {
  1490. List<BaseSetlStatistics> insutypeSetldataList = entry.getValue();
  1491. SetlStatisticResult result = new SetlStatisticResult();
  1492. result.setAdmdvsName(resultItem.getAdmdvsName());
  1493. result.setInsuplcAdmdvs(resultItem.getInsuplcAdmdvs());
  1494. result.setPsnSumamt(insutypeSetldataList.size());
  1495. result.setInsutype(entry.getValue().get(0).getInsutype());
  1496. result.setInsutypeName(entry.getValue().get(0).getInsutypeName());
  1497. result.setChildKey(resultItem.getAdmdvsName() + "-" + result.getInsutypeName());
  1498. result.setIsChildren(true);
  1499. fillSetlStatisticResult(children, insutypeSetldataList, result);
  1500. }
  1501. resultItem.setChildren(children);
  1502. }
  1503. }
  1504. resultList.get(0).setShangChuanJieSuanDan(shangChuanJieSuanDan);
  1505. return ResultVoUtil.success(resultList);
  1506. }
  1507. private void fillSetlStatisticResult(List<SetlStatisticResult> resultList,
  1508. List<BaseSetlStatistics> admdvsSetldataList,
  1509. SetlStatisticResult resultItem) {
  1510. String medfeeSumamt = "0";
  1511. String baseMedFundpaySumamt = "0";
  1512. String bigDssFundpaySumamt = "0";
  1513. String clvFundpaySumamt = "0";
  1514. String othFundpaySumamt = "0";
  1515. String fundpaySumamt = "0";
  1516. for (BaseSetlStatistics itm : admdvsSetldataList) {
  1517. medfeeSumamt = DecimalUtil.add(medfeeSumamt, itm.getMedfeeSumamt());
  1518. baseMedFundpaySumamt = DecimalUtil.add(baseMedFundpaySumamt, itm.getHifpPay());
  1519. bigDssFundpaySumamt = DecimalUtil.add(bigDssFundpaySumamt, itm.getHifmiPay());
  1520. clvFundpaySumamt = DecimalUtil.add(clvFundpaySumamt, itm.getCvlservPay());
  1521. fundpaySumamt = DecimalUtil.add(fundpaySumamt, itm.getFundPaySumamt());
  1522. String othpay = DecimalUtil.minusLink(itm.getFundPaySumamt(), itm.getHifpPay(),
  1523. itm.getHifmiPay(), itm.getCvlservPay());
  1524. othFundpaySumamt = DecimalUtil.add(othFundpaySumamt, othpay);
  1525. }
  1526. resultItem.setMedfeeSumamt(medfeeSumamt);
  1527. resultItem.setBaseMedFundpaySumamt(baseMedFundpaySumamt);
  1528. resultItem.setBigDssFundpaySumamt(bigDssFundpaySumamt);
  1529. resultItem.setClvFundpaySumamt(clvFundpaySumamt);
  1530. resultItem.setOthFundpaySumamt(othFundpaySumamt);
  1531. resultItem.setFundpaySumamt(fundpaySumamt);
  1532. resultList.add(resultItem);
  1533. }
  1534. public ResultVo<List<SiSetlinfo>> selectSetldetailStatistics(SetlCondition condition) {
  1535. String begntime = condition.getMonth() + "-01 00:00:00.000";
  1536. String endtime = DateUtil.getMonthEndtime(condition.getMonth());
  1537. String insuplcAdmdvs;
  1538. if (condition.getAdmdvsType() == 5) {
  1539. insuplcAdmdvs = "430121";
  1540. } else if (condition.getAdmdvsType() == 6) {
  1541. insuplcAdmdvs = "430181";
  1542. } else {
  1543. insuplcAdmdvs = condition.getInsuplcAdmdvs().substring(0, 4) + "%";
  1544. }
  1545. String insutype = condition.getInsutype();
  1546. if (StringUtil.isBlank(insutype)) {
  1547. insutype = "%%";
  1548. }
  1549. QueryWrapper<SiSetlinfo> wrapper = new QueryWrapper<>();
  1550. wrapper.eq("setl_type", condition.getSetlType());
  1551. wrapper.eq("revoked", YesOrNo.NO.getCode());
  1552. wrapper.like("insutype", insutype);
  1553. wrapper.like("insuplc_admdvs", insuplcAdmdvs);
  1554. wrapper.apply("setl_time>='" + begntime + "'");
  1555. wrapper.apply("setl_time<='" + endtime + "'");
  1556. List<SiSetlinfo> list = setlinfoDao.selectList(wrapper);
  1557. list.forEach(item -> {
  1558. item.setInsuplcAdmdvsName(redis.getRegionName(item.getInsuplcAdmdvs()));
  1559. FilterUtil.filterCodeToName(item);
  1560. });
  1561. return ResultVoUtil.success(list);
  1562. }
  1563. public ResultVo<List<ZyActpatient>> weiJieSuanZaiYuanHuanZhe(String patNo,
  1564. String startTime,
  1565. String endTime,
  1566. String name,
  1567. String certno) {
  1568. List<ZyActpatient> actpatients = dao.zaiYuanHuanZheXinXi(patNo, startTime, endTime, StringUtil.isContainChinese(name), certno);
  1569. Map<String, String> insuplcAdmdvs = new HashMap<>();
  1570. for (ZyActpatient actpatient : actpatients) {
  1571. if (StringUtil.isBlank(actpatient.getInsuplcAdmdvsName())) {
  1572. String key = actpatient.getInsuplcAdmdvs().substring(0, 4) + "00";
  1573. if (insuplcAdmdvs.containsKey(key)) {
  1574. actpatient.setInsuplcAdmdvsName(insuplcAdmdvs.get(key));
  1575. } else {
  1576. String insuplcAdmdvsName = dao.selectRegionName(key);
  1577. insuplcAdmdvs.put(key, insuplcAdmdvsName);
  1578. actpatient.setInsuplcAdmdvsName(insuplcAdmdvsName);
  1579. }
  1580. }
  1581. }
  1582. return ResultVoUtil.success(actpatients);
  1583. }
  1584. public ResultVo<String> checkRegisterDate(String patNo, Integer times) {
  1585. Date ledgerAccountDate = dao.selectMaxLedgerAccountDate(patNo, times);
  1586. if (null == ledgerAccountDate) {
  1587. return ResultVoUtil.success();
  1588. }
  1589. Date registerDate = dao.selectRegisterDate(patNo);
  1590. if (null == registerDate) {
  1591. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, "医保登记日期不能为空。");
  1592. }
  1593. Calendar ledgerCalendar = Calendar.getInstance();
  1594. ledgerCalendar.setTime(ledgerAccountDate);
  1595. Calendar registerCalendar = Calendar.getInstance();
  1596. registerCalendar.setTime(registerDate);
  1597. if (registerCalendar.after(ledgerCalendar)) {
  1598. return ResultVoUtil.success();
  1599. }
  1600. return ResultVoUtil.fail(ExceptionEnum.LOGICAL_ERROR, String.format("医保登记日期【%s】不能小于断账日期【%s】,请修改。",
  1601. DateUtil.formatDatetime(registerDate), DateUtil.formatDatetime(ledgerAccountDate)));
  1602. }
  1603. }