package com.fzzy.async.fzzy40.impl;
|
|
import com.fzzy.api.Constant;
|
import com.fzzy.api.entity.Api1105;
|
import com.fzzy.api.entity.Api1310;
|
import com.fzzy.api.entity.ApiLog;
|
import com.fzzy.api.entity.GbCheckItem;
|
import com.fzzy.api.service.ApiCommonService;
|
import com.fzzy.api.service.ApiTriggerService;
|
import com.fzzy.api.utils.ContextUtil;
|
import com.fzzy.api.utils.DateUtil;
|
import com.fzzy.api.view.repository.Api1310Rep;
|
import com.fzzy.api.view.repository.ApiLogRep;
|
import com.fzzy.api.view.repository.GbCheckItemRep;
|
import com.fzzy.async.fzzy40.entity.Fz40CheckItem;
|
import com.fzzy.async.fzzy40.entity.Fz40Quality;
|
import com.fzzy.async.fzzy40.repository.Fzzy40Sync1203Rep;
|
import com.fzzy.async.fzzy40.repository.Fzzy40Sync1208Rep;
|
import com.fzzy.async.fzzy40.repository.Fzzy40Sync1310Rep;
|
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;
|
|
/**
|
* 质检同步
|
*
|
* @author czt
|
* @date 2023-05-14 19:51
|
*/
|
@Slf4j
|
@Component
|
public class Fzzy40Sync1310 {
|
|
@Autowired
|
private Fzzy40Sync1310Rep fzzySync1310Rep;
|
@Autowired
|
private Fzzy40Sync1203Rep fzzySync1203Rep;
|
@Autowired
|
private GbCheckItemRep gbCheckItemRep;
|
@Autowired
|
private ApiCommonService commonService;
|
@Autowired
|
private ApiTriggerService apiTriggerService;
|
@Autowired
|
private Api1310Rep api1310Rep;
|
@Autowired
|
private ApiLogRep apiLogRep;
|
|
/**
|
* 同步并封装保存质检数据
|
*
|
* @param deptId 系统对应库区编码
|
* @param start 起始时间
|
* @param end 截止时间
|
*/
|
public void syncData(String kqdm, String deptId, Date start, Date end) {
|
log.info("-------------1310接口数据开始同步------------------");
|
//同步数据，只记录失败的信息
|
ApiLog apiLog = new ApiLog();
|
apiLog.setType(ApiLog.TYPE_SYNC);
|
apiLog.setKqdm(deptId);
|
apiLog.setUploadTime(new Date());
|
apiLog.setInteId(Constant.API_CODE_1304);
|
apiLog.setStatus(99);
|
apiLog.setId(ContextUtil.getUUID());
|
try {
|
List<Fz40Quality> list = fzzySync1310Rep.findDateByTime(deptId, start, end);
|
if (null == list || list.isEmpty()) {
|
return;
|
}
|
|
Api1310 api1310;
|
Api1105 api1105;
|
List<Fz40CheckItem> fz40CheckItems;
|
List<GbCheckItem> gbCheckList;
|
String jyxm;
|
String jyz;
|
List<Api1310> api1310List;
|
|
for (Fz40Quality fz40Quality : list) {
|
api1105 = commonService.getApi1105Cache(fz40Quality.getDepotId());
|
if (null == api1105) {
|
continue;
|
}
|
api1310 = new Api1310();
|
if (fz40Quality.getId().contains("ZJ_")) {
|
api1310.setZjbgdh(fz40Quality.getType() + fz40Quality.getId().substring(3));
|
} else {
|
api1310.setZjbgdh(fz40Quality.getType() + fz40Quality.getId());
|
}
|
api1310.setHwdm(api1105.getHwdm());
|
api1310.setKqdm(kqdm);
|
//粮食品种
|
String mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSPZ, fz40Quality.getFoodVariety().substring(0, 3));
|
api1310.setLspzdm(mappingCode);
|
|
//粮食等级
|
mappingCode = apiTriggerService.getMappingCode(Constant.TRIGGER_P_LSDJ, fz40Quality.getFoodLevel());
|
api1310.setLsdjdm(mappingCode);
|
api1310.setRkrq(fz40Quality.getStoreDate());
|
api1310.setJylb(fz40Quality.getType());
|
api1310.setJysj(fz40Quality.getTime());
|
api1310.setJydw(StringUtils.isEmpty(fz40Quality.getUnit()) ? "检验单位" : fz40Quality.getUnit());
|
api1310.setJyr(StringUtils.isEmpty(fz40Quality.getUser()) ? "检验人" : fz40Quality.getUser());
|
api1310.setJyyj(fz40Quality.getStandard());
|
if (StringUtils.isEmpty(fz40Quality.getZblb())) {
|
api1310.setZblb("2");
|
} else {
|
api1310.setZblb(fz40Quality.getZblb());
|
}
|
|
//检测项，检测值
|
jyxm = "";
|
jyz = "";
|
fz40CheckItems = fzzySync1203Rep.listInoutCheckItem(fz40Quality.getId(), deptId.substring(0, 4));
|
if (null != fz40CheckItems && fz40CheckItems.size() > 0) {
|
|
for (Fz40CheckItem fz40CheckItem : fz40CheckItems) {
|
if (StringUtils.isEmpty(fz40CheckItem.getValue())) {
|
continue;
|
}
|
gbCheckList = gbCheckItemRep.findByBizCode(fz40CheckItem.getStandardId());
|
if (gbCheckList == null || gbCheckList.isEmpty()) {
|
continue;
|
}
|
jyxm += "," + gbCheckList.get(0).getCode();
|
jyz += "," + fz40CheckItem.getValue();
|
}
|
}
|
if(jyxm.length() > 0){
|
jyxm = jyxm.substring(1);
|
}
|
if(jyz.length() > 0){
|
jyz = jyz.substring(1);
|
}
|
api1310.setJyxm(jyxm);
|
api1310.setJyxmz(jyz);
|
|
api1310.setZbjgpd(fz40Quality.getResult());
|
api1310.setQfrq(fz40Quality.getTime());
|
api1310.setBgcjsj(fz40Quality.getTime());
|
api1310.setShrxm(fz40Quality.getShrxm().contains("、")?fz40Quality.getShrxm().replace('、','|'):fz40Quality.getShrxm());
|
if (null == fz40Quality.getCheckTime()) {
|
fz40Quality.setCheckTime(DateUtils.addDays(fz40Quality.getTime(), -1));
|
}
|
if (!fz40Quality.getCheckTime().before(fz40Quality.getTime())) {
|
fz40Quality.setCheckTime(DateUtils.addDays(fz40Quality.getTime(), -1));
|
}
|
api1310.setSpaqzbsfhg(fz40Quality.getSpaqzbsfhg());
|
api1310.setQysj(fz40Quality.getCheckTime());
|
api1310.setQyqy(fz40Quality.getCheckArea());
|
api1310.setQyrxm(fz40Quality.getCheckUser().contains("、") ? fz40Quality.getCheckUser().replace('、', '|') : fz40Quality.getCheckUser());
|
api1310.setJdrxm(fz40Quality.getCheckUser().contains("、") ? fz40Quality.getCheckUser().replace('、', '|') : fz40Quality.getCheckUser());
|
|
|
api1310.setYpsl(fz40Quality.getYpsl() == null ? 0.0 : fz40Quality.getYpsl());
|
api1310.setDbsl(fz40Quality.getDbsl() == null ? 0.0 : fz40Quality.getDbsl());
|
api1310.setYpdj(StringUtils.isEmpty(fz40Quality.getYpdj()) ? "0" : fz40Quality.getYpdj());
|
api1310.setSfzcccnx(StringUtils.isEmpty(fz40Quality.getNormalYear()) ? "0" : fz40Quality.getNormalYear());
|
api1310.setBz(fz40Quality.getRemark());
|
api1310.setYpbh(fz40Quality.getYpbh());
|
api1310.setQydbh(fz40Quality.getQydbh());
|
api1310.setZhgxsj(new Date());
|
api1310.setBizId(fz40Quality.getId());
|
|
api1310List = api1310Rep.getDataByBizId(api1310.getBizId());
|
if (null == api1310List || api1310List.isEmpty()) {
|
api1310.setCzbz(Constant.CZBZ_I);
|
} else {
|
api1310.setCzbz(api1310List.get(0).getCzbz());
|
api1310.setBglx(api1310List.get(0).getBglx());
|
}
|
|
api1310Rep.save(api1310);
|
}
|
} catch (Exception e) {
|
log.error("---同步失败----{}", e);
|
apiLog.setResult("同步失败：" + e.getMessage());
|
apiLogRep.save(apiLog);
|
}
|
}
|
|
}
|
