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<Fz61InoutRecord> list = fzzySync1202Rep.listInoutRecord(deptId, INOUT_TYPE_IN, start, end);
|
|
if (null == list || list.isEmpty()) {
|
log.info("-------------没有获取到粮食入库信息------------------");
|
return;
|
}
|
|
Api1202 apiData;
|
Api1105 api1105;
|
List<Fz61InoutNoticeIn> listInoutNotice;
|
List<Api1202> api1202List;
|
List<Fz61InoutRecordItem> listInoutRecordItem;
|
List<Api1201> api1201List;
|
List<Api1204> api1204List;
|
List<Api1404> 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<Api1208> 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.setGch(apiData.getCch());
|
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);
|
}
|
}
|
}
|
