package com.fzzy.async.fzzy61.impl; import com.fzzy.api.Constant; import com.fzzy.api.entity.*; import com.fzzy.api.service.ApiCommonService; import com.fzzy.api.service.ApiTriggerService; import com.fzzy.api.utils.ContextUtil; import com.fzzy.api.view.repository.*; import com.fzzy.async.fzzy61.entity.Fz61InoutNoticeIn; import com.fzzy.async.fzzy61.entity.Fz61InoutRecord; import com.fzzy.async.fzzy61.entity.Fz61InoutRecordItem; import com.fzzy.async.fzzy61.repository.Fzzy61Sync1202Rep; import com.fzzy.async.fzzy61.repository.Fzzy61SyncInoutRecordItemRep; import com.fzzy.async.fzzy61.repository.Fzzy61SyncNoticeInRep; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang.StringUtils; import org.apache.commons.lang.time.DateFormatUtils; import org.apache.commons.lang.time.DateUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Component; import java.util.Date; import java.util.List; /** * 粮食入库信息 */ @Slf4j @Component public class Fzzy61Sync1202 { /** * 入库类型 */ private final static String INOUT_TYPE_IN = "IN"; @Autowired private Fzzy61Sync1202Rep fzzySync1202Rep; @Autowired private Fzzy61SyncInoutRecordItemRep fzzy61SyncInoutRecordItemRep; @Autowired private Fzzy61SyncNoticeInRep fzzySyncNoticeInRep; @Autowired private ApiTriggerService apiTriggerService; @Autowired private Api1201Rep api1201Rep; @Autowired private Api1202Rep api1202Rep; @Autowired private Api1204Rep api1204Rep; @Autowired private Api1208Rep api1208Rep; @Autowired private Api1404Rep api1404Rep; @Autowired private ApiCommonService commonService; @Autowired private ApiLogRep apiLogRep; /** * 粮食入库信息 * * @param deptId * @param start * @param end */ public void syncData(String kqdm, String deptId, Date start, Date end) { log.info("-------------1202接口数据开始同步------------------"); //同步数据,只记录失败的信息 ApiLog apiLog = new ApiLog(); apiLog.setType(ApiLog.TYPE_SYNC); apiLog.setKqdm(deptId); apiLog.setUploadTime(new Date()); apiLog.setInteId(Constant.API_CODE_1202); apiLog.setStatus(99); apiLog.setId(ContextUtil.getUUID()); try { //获取粮食入库记录信息,根据流程完成时间获取 List list = fzzySync1202Rep.listInoutRecord(deptId, INOUT_TYPE_IN, start, end); if (null == list || list.isEmpty()) { log.info("-------------没有获取到粮食入库信息------------------"); return; } Api1202 apiData; Api1105 api1105; List listInoutNotice; List api1202List; List listInoutRecordItem; List api1201List; List api1204List; List api1404List; for (Fz61InoutRecord sysData : list) { if (sysData.getRecordStatus().equals("DEL") || sysData.getRecordStatus().equals("ERROR")) { continue; } if (!sysData.getProgress().equals("RECORD")) { continue; } if (null == sysData.getRecordWeight() || sysData.getRecordWeight() == 0) { sysData.setRecordWeight(sysData.getSettleWeight()); } //判断净重是否大于0,等于0表示不合格,不进行同步上传 if (null == sysData.getRecordWeight() || sysData.getRecordWeight() == 0) { continue; } //获取货位信息 api1105 = commonService.getApi1105Cache(sysData.getDepotId()); if (null == api1105) { continue; } apiData = new Api1202(); apiData.setRkywdh(Constant.INOUT_TYPE_14 + sysData.getId().substring(4)); //货位代码 apiData.setHwdm(api1105.getHwdm()); apiData.setYwlx(Constant.INOUT_TYPE_2); apiData.setYwrq(DateUtils.parseDate(sysData.getId().substring(2, 10), new String[]{"yyyyMMdd"})); apiData.setCyr(sysData.getUserName().trim()); //默认一个随便值 apiData.setLxdh(StringUtils.isEmpty(sysData.getUserContact()) ? "13012345678" : sysData.getUserContact().trim()); if (StringUtils.isEmpty(sysData.getUserId()) || sysData.getUserId().length() != 18) { sysData.setUserId("410183199003187055"); } apiData.setSfzh(sysData.getUserId()); //获取通知单信息,查询合同号和计划明细号 listInoutNotice = fzzySyncNoticeInRep.listInoutNoticeInById(sysData.getNoticeId()); if (null != listInoutNotice && listInoutNotice.size() > 0) { //合同号 if (StringUtils.isNotEmpty(listInoutNotice.get(0).getContractId())) { api1201List = api1201Rep.getDataByBizId(listInoutNotice.get(0).getContractId()); if (null != api1201List && api1201List.size() > 0) { apiData.setHth(api1201List.get(0).getHth()); } } if (StringUtils.isNotEmpty(listInoutNotice.get(0).getPlanId())) { api1404List = api1404Rep.getDataByBizIdAndKqdm(listInoutNotice.get(0).getPlanId(), kqdm); if (null != api1404List && api1404List.size() > 0) { apiData.setJhmxh(api1404List.get(0).getJhmxdh()); if (StringUtils.isEmpty(sysData.getFoodYear())) { sysData.setFoodYear(api1404List.get(0).getShnd()); } } } } //粮权单位归属代码 List dataByHwdm = api1208Rep.findDataByHwdm(apiData.getHwdm()); if (null != dataByHwdm && dataByHwdm.size() > 0) { apiData.setLqgsdwdm(StringUtils.isEmpty(dataByHwdm.get(0).getLqgsdwdm()) ? kqdm.substring(0, 18) : dataByHwdm.get(0).getLqgsdwdm()); } else { apiData.setLqgsdwdm(kqdm.substring(0, 18)); } apiData.setSlr("售粮人"); apiData.setSlrdz("售粮人地址"); apiData.setBz(StringUtils.isEmpty(sysData.getRemarks()) ? "备注" : sysData.getRemarks()); apiData.setXxdz(StringUtils.isEmpty(sysData.getUserAddress()) ? "详细地址" : sysData.getUserAddress()); //运输工具,若为空,则默认给1-汽车 apiData.setYsgj(StringUtils.isEmpty(sysData.getTransType()) ? "1" : sysData.getTransType()); //车船号 apiData.setCch(sysData.getPlateNum().trim()); apiData.setDjsj(sysData.getRegisterTime()); //生成方式 apiData.setScfs(1); if (StringUtils.isNotEmpty(sysData.getRecordStatus()) && sysData.getRecordStatus().equals("ADD")) { apiData.setScfs(2); apiData.setSdblyy("库区停电导致无法按流程进行出库"); } //粮食品种 String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, sysData.getFoodVariety()); apiData.setLspzdm(mappingCode); //粮食性质 mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSXZ, sysData.getFoodType()); apiData.setLsxzdm(mappingCode); apiData.setShnd(StringUtils.isEmpty(sysData.getFoodYear()) ? DateFormatUtils.format(sysData.getRegisterTime(), "yyyy") : sysData.getFoodYear()); //产地代码 mappingCode = commonService.getFoodLocationIdFromCache(sysData.getFoodLocation()); if (StringUtils.isEmpty(mappingCode)) { mappingCode = apiData.getHwdm().substring(2, 8); } apiData.setCddm(mappingCode); //检斤类型,默认0-称重入库 apiData.setJjlx(sysData.getJjlx()); apiData.setBzbdbz(sysData.getDbz() == null ? 25 : sysData.getDbz()); //毛重信息 apiData.setMz(sysData.getFullWeight()); if (null == sysData.getFullWeightTime()) { sysData.setFullWeightTime(DateUtils.addMinutes(sysData.getRegisterTime(), 25)); } if (!sysData.getFullWeightTime().after(sysData.getRegisterTime())) { sysData.setFullWeightTime(DateUtils.addMinutes(sysData.getRegisterTime(), 25)); } apiData.setMzjlsj(sysData.getFullWeightTime()); apiData.setMzjby(sysData.getFullWeightUser()); apiData.setMzjly(sysData.getFullWeightUser()); apiData.setZcy(null == sysData.getHandleUser() ? sysData.getFullWeightUser() : sysData.getHandleUser()); //皮重信息 apiData.setPz(sysData.getEmptyWeight()); if (null == sysData.getEmptyWeightTime()) { sysData.setEmptyWeightTime(DateUtils.addMinutes(sysData.getFullWeightTime(), 60)); } if (!sysData.getEmptyWeightTime().after(sysData.getFullWeightTime())) { sysData.setEmptyWeightTime(DateUtils.addMinutes(sysData.getFullWeightTime(), 60)); } apiData.setPzjlsj(sysData.getEmptyWeightTime()); apiData.setPzjby(sysData.getEmptyWeightUser()); apiData.setPzjly(sysData.getEmptyWeightUser()); //扣重 化验总扣重 apiData.setZjklxj(sysData.getDeCheck()); apiData.setBzw(StringUtils.isEmpty(sysData.getBzw()) ? "9" : sysData.getBzw()); apiData.setBzwkl(0 - sysData.getDePackage()); apiData.setBzbjs(sysData.getBzbjs()); apiData.setCmsj(sysData.getCompleteTime()); //结算单号 if (StringUtils.isNotEmpty(sysData.getSettleId())) { apiData.setRkjsdh(kqdm + sysData.getSettleId()); } if (StringUtils.isNotEmpty(apiData.getHth())) { api1204List = api1204Rep.getDataByHthAndHwdm(apiData.getHth(), apiData.getHwdm()); if (null == api1204List || api1204List.isEmpty()) { api1204List = api1204Rep.getDataByHth(apiData.getHth()); if (null != api1204List && api1204List.size() > 0) { apiData.setRkjsdh(api1204List.get(0).getRkjsdh()); } } else { apiData.setRkjsdh(api1204List.get(0).getRkjsdh()); } } //其它 apiData.setQtkl(0 - sysData.getDeOther()); //值仓 现场扣重 apiData.setXckl(0 - sysData.getDeHandle()); apiData.setJz(sysData.getRecordWeight()); if (!sysData.getCompleteTime().after(sysData.getEmptyWeightTime())) { sysData.setCompleteTime(DateUtils.addMinutes(sysData.getEmptyWeightTime(), 10)); } apiData.setCmsj(sysData.getCompleteTime()); //操作标志及最后更新时间 apiData.setZhgxsj(sysData.getUpdateTime()); //业务id、库区编码、同步时间 apiData.setBizId(sysData.getId()); apiData.setKqdm(kqdm); apiData.setSyncTime(new Date()); apiData.setKlyy("扣量原因"); apiData.setCmqrmgryxm(StringUtils.isEmpty(sysData.getRegisterUser()) ? "登记人" : sysData.getRegisterUser()); apiData.setDjmgryxm(StringUtils.isEmpty(sysData.getRegisterUser()) ? "登记人" : sysData.getRegisterUser()); //01:表示大型汽车号牌,黄底黑字; 02:表示小型汽车号牌,蓝底白字; 03:表示新能源汽车号牌,绿底黑 字; //04:表示农用车车牌号,绿底白字; LS:表示临时虚拟号牌,仅限于售 粮车无固定号牌时使用 apiData.setCchlx("01"); apiData.setLdd("装粮地点"); apiData.setZkj(0.0); apiData.setZlfyzkl(0.0); apiData.setQzsfzkl(0.0); apiData.setQzzzzkl(0.0); apiData.setQzgwcmkl(0.0); apiData.setQzhhkl(0.0); apiData.setQzbwslkl(0.0); apiData.setQzhlmkl(0.0); apiData.setQzsmlkl(0.0); apiData.setQzzjmlkl(0.0); apiData.setQzqtkl(0.0); apiData.setZkhyy("增扣价原因"); apiData.setZxzydw(api1105.getBgdw()); if (sysData.getCompanyId().equals("5329")) { apiData.setLqgsdwdm("91461604MA56D2AM1X"); } api1202List = api1202Rep.getDataById(apiData.getRkywdh()); if (null == api1202List || api1202List.isEmpty()) { apiData.setCzbz(Constant.CZBZ_I); } else { apiData.setCzbz(api1202List.get(0).getCzbz()); } //判断是否为船运 if (StringUtils.isNotEmpty(sysData.getTransType()) && sysData.getTransType().equals("3")) { listInoutRecordItem = fzzy61SyncInoutRecordItemRep.findDataByRecordId(sysData.getId()); if (null == listInoutRecordItem || listInoutRecordItem.isEmpty()) { api1202Rep.save(apiData); continue; } int idNum = Integer.valueOf(sysData.getId().substring(12)) * 100 + 10001; for (Fz61InoutRecordItem fz61InoutRecordItem : listInoutRecordItem) { if ("DEL".equals(fz61InoutRecordItem.getRecordStatus())) { continue; } if (fz61InoutRecordItem.getSettleWeight() <= 0) { continue; } apiData.setRkywdh(Constant.INOUT_TYPE_14 + sysData.getId().substring(4, 10) + String.valueOf(idNum).substring(1)); apiData.setMz(fz61InoutRecordItem.getFullWeight()); apiData.setPz(fz61InoutRecordItem.getEmptyWeight()); apiData.setJz(fz61InoutRecordItem.getSettleWeight()); apiData.setMzjlsj(fz61InoutRecordItem.getFullWeightTime()); apiData.setPzjlsj(fz61InoutRecordItem.getEmptyWeightTime()); apiData.setQtkl(0 - fz61InoutRecordItem.getDe()); api1202List = api1202Rep.getDataById(apiData.getRkywdh()); if (null == api1202List || api1202List.isEmpty()) { apiData.setCzbz(Constant.CZBZ_I); } else { apiData.setCzbz(api1202List.get(0).getCzbz()); } api1202Rep.save(apiData); idNum++; } } else { //保存数据 api1202Rep.save(apiData); } log.info("1202---同步数据:{}", apiData.toString()); } } catch (Exception e) { log.error("---1202数据同步失败----{}", e.toString()); apiLog.setResult("同步失败:" + e.getMessage()); apiLogRep.save(apiLog); } } }