MedicineStorageService.java 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361
  1. package com.miyzh.service;
  2. import com.fasterxml.jackson.core.JsonProcessingException;
  3. import com.fasterxml.jackson.databind.ObjectMapper;
  4. import com.github.pagehelper.PageHelper;
  5. import com.github.pagehelper.PageInfo;
  6. import com.miyzh.dao.MedicineStorageDao;
  7. import com.miyzh.entity.*;
  8. import com.miyzh.entity.dto.MedicineStorageDto;
  9. import com.miyzh.entity.dto.MedicineStoreDto;
  10. import com.miyzh.utils.RestTemplateUtil;
  11. import lombok.extern.slf4j.Slf4j;
  12. import org.springframework.beans.BeanUtils;
  13. import org.springframework.beans.factory.annotation.Autowired;
  14. import org.springframework.beans.factory.annotation.Value;
  15. import org.springframework.http.HttpHeaders;
  16. import org.springframework.scheduling.annotation.Async;
  17. import org.springframework.stereotype.Service;
  18. import java.util.List;
  19. import java.util.Map;
  20. import java.util.stream.Collectors;
  21. /**
  22. * 入库
  23. */
  24. @Slf4j
  25. @Service
  26. public class MedicineStorageService {
  27. @Autowired
  28. private MedicineStorageDao medicineStorageDao;
  29. @Value ("${postApi.sorageUrl}")
  30. private String url;
  31. @Value("${postApi.pageSize}")
  32. private int pageSize;
  33. @Value("${update.startDate}")
  34. public String startDate;
  35. @Value("${update.endDate}")
  36. public String endDate;
  37. @Value("${update.dateType}")
  38. public String dateType;
  39. @Value("${update.count}")
  40. public Integer count;
  41. private class StorageType {
  42. private static final String PUR = "1"; //采购入库
  43. private static final String OTHER = "2"; //其他
  44. private static final String INBOUND = "3"; //销售退货
  45. private static final String CHI_MED_INBOUND = "4"; // 退溢
  46. }
  47. private static final String MED_PUR = "1"; //西药采购入库
  48. private static final String CHI_MED_PUR = "2"; //中药采购入库
  49. private static final String MED_MED_INBOUND = "3"; //西药销售退回入库
  50. private static final String CHI_MED_INBOUND = "4"; //中药销售退回
  51. private static final String MED_INV = "5"; //西药盘盈入库
  52. private static final String CHI_MED_INV = "6"; //中药盘盈入库
  53. public void uploadMedicine(Clinic clinic, String flag) throws InterruptedException, JsonProcessingException {
  54. PageInfo<MedicineStorageTemp> page = new PageInfo<>();
  55. switch (flag) {
  56. case MED_PUR:
  57. System.out.println(clinic.getStoreCode() + "开始查询西药采购入库记录...");
  58. page = PageHelper.startPage(1, pageSize).doSelectPageInfo(() -> {
  59. medicineStorageDao.listMedicinePurchase(clinic.getClinicId(), startDate, endDate, dateType, count);
  60. });
  61. System.out.println(clinic.getStoreCode() + "开始同步西药采购入库记录, 数量" + page.getTotal());
  62. break;
  63. case CHI_MED_PUR:
  64. System.out.println(clinic.getStoreCode() + "开始查询中药采购入库记录...");
  65. page = PageHelper.startPage(1, pageSize).doSelectPageInfo(() -> {
  66. medicineStorageDao.listChinaMedicinePurchase(clinic.getClinicId(), startDate, endDate, dateType, count);
  67. });
  68. System.out.println(clinic.getStoreCode() + "开始同步中药采购入库记录, 数量" + page.getTotal());
  69. break;
  70. case MED_MED_INBOUND:
  71. System.out.println(clinic.getStoreCode() + "开始查询西药销售退回入库记录...");
  72. page = PageHelper.startPage(1, pageSize).doSelectPageInfo(() -> {
  73. medicineStorageDao.listMedicineOutbound(clinic.getClinicId(), startDate, endDate, dateType, count);
  74. });
  75. System.out.println(clinic.getStoreCode() + "开始同步西药销售退回入库记录, 数量" + page.getTotal());
  76. break;
  77. case CHI_MED_INBOUND:
  78. System.out.println(clinic.getStoreCode() + "开始查询中药销售退回入库记录...");
  79. page = PageHelper.startPage(1, pageSize).doSelectPageInfo(() -> {
  80. medicineStorageDao.listChinaMedicineOutbound(clinic.getClinicId(), startDate, endDate, dateType, count);
  81. });
  82. System.out.println(clinic.getStoreCode() + "开始同步中药销售退回入库记录, 数量" + page.getTotal());
  83. break;
  84. case MED_INV:
  85. System.out.println(clinic.getStoreCode() + "开始查询西药盘盈入库记录...");
  86. page = PageHelper.startPage(1, pageSize).doSelectPageInfo(() -> {
  87. medicineStorageDao.listMedicineInventory(clinic.getClinicId(), startDate, endDate, dateType, count);
  88. });
  89. System.out.println(clinic.getStoreCode() + "开始同步西药盘盈入库记录, 数量" + page.getTotal());
  90. break;
  91. case CHI_MED_INV:
  92. System.out.println(clinic.getStoreCode() + "开始查询中药盘盈入库记录...");
  93. page = PageHelper.startPage(1, pageSize).doSelectPageInfo(() -> {
  94. medicineStorageDao.listChinaMedicineInventory(clinic.getClinicId(), startDate, endDate, dateType, count);
  95. });
  96. System.out.println(clinic.getStoreCode() + "开始同步中药盘盈入库记录, 数量" + page.getTotal());
  97. break;
  98. }
  99. if (page.getTotal() == 0) {
  100. return;
  101. }
  102. for(MedicineStorageTemp medicineStore : page.getList()) {
  103. if(null == medicineStore.getDosageId() || "".equals(medicineStore.getDosageId().trim())) {
  104. medicineStore.setDosageId("999999999");
  105. }
  106. if(null == medicineStore.getDosageName() || "".equals(medicineStore.getDosageName().trim())) {
  107. medicineStore.setDosageName("999999999");
  108. }
  109. if(null == medicineStore.getSpecification() || "".equals(medicineStore.getSpecification().trim())) {
  110. medicineStore.setSpecification("999999999");
  111. }
  112. if(null == medicineStore.getManufacturer() || "".equals(medicineStore.getManufacturer().trim())) {
  113. medicineStore.setManufacturer("999999999");
  114. }
  115. if(null == medicineStore.getPlace() || "".equals(medicineStore.getPlace().trim())) {
  116. medicineStore.setPlace("999999999");
  117. }
  118. if(null == medicineStore.getPack() || "".equals(medicineStore.getPack().trim())) {
  119. medicineStore.setPack("999999999");
  120. }
  121. if(null == medicineStore.getBatchNo() || "".equals(medicineStore.getBatchNo().trim())) {
  122. medicineStore.setBatchNo("0000000000000");
  123. }
  124. if(null == medicineStore.getMedicineDeadline() || "".equals(medicineStore.getMedicineDeadline().trim())) {
  125. medicineStore.setMedicineDeadline("0000000000000");
  126. }
  127. if(null == medicineStore.getBarCode() || "".equals(medicineStore.getBarCode().trim())) {
  128. medicineStore.setBarCode("0000000000000");
  129. }
  130. if(null == medicineStore.getDeliveryCompany() || "".equals(medicineStore.getDeliveryCompany().trim())) {
  131. medicineStore.setDeliveryCompany("999999999");
  132. }
  133. if(null == medicineStore.getItemCode() || "".equals(medicineStore.getItemCode().trim())) {
  134. medicineStore.setItemCode("999999999");
  135. }
  136. if(null == medicineStore.getItemName() || "".equals(medicineStore.getItemName().trim())) {
  137. medicineStore.setItemName("999999999");
  138. }
  139. if(null == medicineStore.getValidity() || "".equals(medicineStore.getValidity().trim())) {
  140. medicineStore.setValidity("0000000000000");
  141. }
  142. if(null == medicineStore.getManufactureTime() || "".equals(medicineStore.getManufactureTime().trim())) {
  143. medicineStore.setManufactureTime("0000-00-00");
  144. }
  145. }
  146. Map<String, List<MedicineStorageTemp>> map = page.getList()
  147. .stream()
  148. .collect(Collectors.groupingBy(MedicineStorageTemp::getStoreStorageCode));
  149. for(Map.Entry<String, List<MedicineStorageTemp>> msMap:map.entrySet()){
  150. MedicineStorageDto medicineStorageDto = new MedicineStorageDto();
  151. medicineStorageDto.setStoreCode(clinic.getStoreCode());
  152. switch (flag) {
  153. case MED_PUR:
  154. case CHI_MED_PUR:
  155. medicineStorageDto.setStorePurchaseType("5");
  156. medicineStorageDto.setStorageType(StorageType.PUR);
  157. break;
  158. case MED_MED_INBOUND:
  159. case CHI_MED_INBOUND:
  160. medicineStorageDto.setStorageType(StorageType.INBOUND);
  161. break;
  162. case MED_INV:
  163. case CHI_MED_INV:
  164. medicineStorageDto.setStorageType(StorageType.CHI_MED_INBOUND);
  165. break;
  166. }
  167. medicineStorageDto.setStorePrecordCode("00000000");
  168. medicineStorageDto.setStorageMan(msMap.getValue().get(0).getStorageMan());
  169. medicineStorageDto.setStorageTime(msMap.getValue().get(0).getStorageTime());
  170. medicineStorageDto.setStoreCode(clinic.getStoreCode());
  171. medicineStorageDto.setStoreStorageCode(msMap.getKey());
  172. List<MedicineStorage> list = msMap.getValue()
  173. .stream()
  174. .map(MedicineStorageTemp::temp2MedSto)
  175. .collect(Collectors.toList());
  176. // 西药部分 耗材西药分别上传 中药不需要处理
  177. if(flag.equals(MED_PUR) || flag.equals(MED_MED_INBOUND) || flag.equals(MED_INV)){
  178. Map<String, List<MedicineStorage>> medMap = list.stream().collect(Collectors.groupingBy(MedicineStorage::getItemType));
  179. for(Map.Entry<String, List<MedicineStorage>> m : medMap.entrySet()) {
  180. if(m.getValue().size() > 0) {
  181. String f = ("1".equals(m.getKey())?"西药":"耗材");
  182. System.out.println(f + "数量" + m.getValue().size());
  183. medicineStorageDto.setMedicineInfos(m.getValue());
  184. this.upload(medicineStorageDto, flag);
  185. }
  186. }
  187. } else {
  188. medicineStorageDto.setMedicineInfos(list);
  189. this.upload(medicineStorageDto, flag);
  190. }
  191. }
  192. if (page.getPages() > 1) {
  193. PageInfo<MedicineStorageTemp> page1 = new PageInfo<>();
  194. for(int i = 2; i <= page.getPages(); i++) {
  195. switch (flag) {
  196. case MED_PUR:
  197. page1 = PageHelper.startPage(i, pageSize).doSelectPageInfo(() -> {
  198. medicineStorageDao.listMedicinePurchase(clinic.getClinicId(), startDate, endDate, dateType, count);
  199. });
  200. break;
  201. case CHI_MED_PUR:
  202. page1 = PageHelper.startPage(i, pageSize).doSelectPageInfo(() -> {
  203. medicineStorageDao.listChinaMedicinePurchase(clinic.getClinicId(), startDate, endDate, dateType, count);
  204. });
  205. break;
  206. case MED_MED_INBOUND:
  207. page1 = PageHelper.startPage(i, pageSize).doSelectPageInfo(() -> {
  208. medicineStorageDao.listMedicineOutbound(clinic.getClinicId(), startDate, endDate, dateType, count);
  209. });
  210. break;
  211. case CHI_MED_INBOUND:
  212. page1 = PageHelper.startPage(i, pageSize).doSelectPageInfo(() -> {
  213. medicineStorageDao.listChinaMedicineOutbound(clinic.getClinicId(), startDate, endDate, dateType, count);
  214. });
  215. break;
  216. case MED_INV:
  217. page1 = PageHelper.startPage(i, pageSize).doSelectPageInfo(() -> {
  218. medicineStorageDao.listMedicineInventory(clinic.getClinicId(), startDate, endDate, dateType, count);
  219. });
  220. break;
  221. case CHI_MED_INV:
  222. page1 = PageHelper.startPage(i, pageSize).doSelectPageInfo(() -> {
  223. medicineStorageDao.listChinaMedicineInventory(clinic.getClinicId(), startDate, endDate, dateType, count);
  224. });
  225. break;
  226. }
  227. for(MedicineStorageTemp medicineStore : page1.getList()) {
  228. if(null == medicineStore.getDosageId() || "".equals(medicineStore.getDosageId().trim())) {
  229. medicineStore.setDosageId("999999999");
  230. }
  231. if(null == medicineStore.getDosageName() || "".equals(medicineStore.getDosageName().trim())) {
  232. medicineStore.setDosageName("999999999");
  233. }
  234. if(null == medicineStore.getSpecification() || "".equals(medicineStore.getSpecification().trim())) {
  235. medicineStore.setSpecification("999999999");
  236. }
  237. if(null == medicineStore.getManufacturer() || "".equals(medicineStore.getManufacturer().trim())) {
  238. medicineStore.setManufacturer("999999999");
  239. }
  240. if(null == medicineStore.getPlace() || "".equals(medicineStore.getPlace().trim())) {
  241. medicineStore.setPlace("999999999");
  242. }
  243. if(null == medicineStore.getPack() || "".equals(medicineStore.getPack().trim())) {
  244. medicineStore.setPack("999999999");
  245. }
  246. if(null == medicineStore.getBatchNo() || "".equals(medicineStore.getBatchNo().trim())) {
  247. medicineStore.setBatchNo("0000000000000");
  248. }
  249. if(null == medicineStore.getMedicineDeadline() || "".equals(medicineStore.getMedicineDeadline().trim())) {
  250. medicineStore.setMedicineDeadline("0000000000000");
  251. }
  252. if(null == medicineStore.getBarCode() || "".equals(medicineStore.getBarCode().trim())) {
  253. medicineStore.setBarCode("0000000000000");
  254. }
  255. if(null == medicineStore.getDeliveryCompany() || "".equals(medicineStore.getDeliveryCompany().trim())) {
  256. medicineStore.setDeliveryCompany("999999999");
  257. }
  258. if(null == medicineStore.getItemCode() || "".equals(medicineStore.getItemCode().trim())) {
  259. medicineStore.setItemCode("999999999");
  260. }
  261. if(null == medicineStore.getItemName() || "".equals(medicineStore.getItemName().trim())) {
  262. medicineStore.setItemName("999999999");
  263. }
  264. if(null == medicineStore.getValidity() || "".equals(medicineStore.getValidity().trim())) {
  265. medicineStore.setValidity("0000000000000");
  266. }
  267. if(null == medicineStore.getManufactureTime() || "".equals(medicineStore.getManufactureTime().trim())) {
  268. medicineStore.setManufactureTime("0000-00-00");
  269. }
  270. }
  271. Map<String, List<MedicineStorageTemp>> map1 = page1.getList()
  272. .stream()
  273. .collect(Collectors.groupingBy(MedicineStorageTemp::getStoreStorageCode));
  274. for(Map.Entry<String, List<MedicineStorageTemp>> msMap:map1.entrySet()){
  275. MedicineStorageDto medicineStorageDto = new MedicineStorageDto();
  276. medicineStorageDto.setStoreCode(clinic.getStoreCode());
  277. switch (flag) {
  278. case MED_PUR:
  279. case CHI_MED_PUR:
  280. medicineStorageDto.setStorePurchaseType("5");
  281. medicineStorageDto.setStorageType(StorageType.PUR);
  282. break;
  283. case MED_MED_INBOUND:
  284. case CHI_MED_INBOUND:
  285. medicineStorageDto.setStorageType(StorageType.INBOUND);
  286. break;
  287. case MED_INV:
  288. case CHI_MED_INV:
  289. medicineStorageDto.setStorageType(StorageType.CHI_MED_INBOUND);
  290. break;
  291. }
  292. medicineStorageDto.setStorePrecordCode("00000000");
  293. medicineStorageDto.setStorageMan(msMap.getValue().get(0).getStorageMan());
  294. medicineStorageDto.setStorageTime(msMap.getValue().get(0).getStorageTime());
  295. medicineStorageDto.setStoreCode(clinic.getStoreCode());
  296. medicineStorageDto.setStoreName(clinic.getStoreName());
  297. medicineStorageDto.setStoreStorageCode(msMap.getKey());
  298. List<MedicineStorage> list = msMap.getValue()
  299. .stream()
  300. .map(MedicineStorageTemp::temp2MedSto)
  301. .collect(Collectors.toList());
  302. if(flag.equals(MED_PUR) || flag.equals(MED_MED_INBOUND) || flag.equals(MED_INV)){
  303. Map<String, List<MedicineStorage>> medMap = list.stream().collect(Collectors.groupingBy(MedicineStorage::getItemType));
  304. for(Map.Entry<String, List<MedicineStorage>> m : medMap.entrySet()) {
  305. if(m.getValue().size() > 0) {
  306. String f = ("1".equals(m.getKey())?"西药":"耗材");
  307. System.out.println(f + "数量" + m.getValue().size());
  308. medicineStorageDto.setMedicineInfos(m.getValue());
  309. this.upload(medicineStorageDto, flag);
  310. }
  311. }
  312. } else {
  313. medicineStorageDto.setMedicineInfos(list);
  314. this.upload(medicineStorageDto, flag);
  315. }
  316. }
  317. }
  318. }
  319. };
  320. public void upload (MedicineStorageDto storageDtoInfo, String flag) throws InterruptedException, JsonProcessingException {
  321. String flagStr = "";
  322. switch (flag) {
  323. case MED_PUR:
  324. flagStr = "西药采购入库";
  325. break;
  326. case CHI_MED_PUR:
  327. flagStr = "中药采购入库";
  328. break;
  329. case MED_MED_INBOUND:
  330. flagStr = "西药销售退回入库";
  331. break;
  332. case CHI_MED_INBOUND:
  333. flagStr = "中药销售退回";
  334. break;
  335. case MED_INV:
  336. flagStr = "西药盘盈入库";
  337. break;
  338. case CHI_MED_INV:
  339. flagStr = "中药盘盈入库";
  340. break;
  341. }
  342. ObjectMapper objectMapper = new ObjectMapper();
  343. String params = objectMapper.writeValueAsString(storageDtoInfo);
  344. BaseResult baseResult = RestTemplateUtil.postHttp(url, params, new HttpHeaders(), new BaseResult());
  345. if (null != baseResult && baseResult.isSuccess()) {
  346. log.info(storageDtoInfo.getStoreCode() + flagStr + baseResult.getMessage() + ",数量" + storageDtoInfo.getMedicineInfos().size());
  347. } else {
  348. log.error(flagStr + "------" + storageDtoInfo.getStoreCode() + "------" + baseResult.getMessage());
  349. }
  350. }
  351. }