package com.java110.api.importData.adapt;
|
|
import com.alibaba.fastjson.JSONObject;
|
import com.java110.api.importData.DefaultImportDataAdapt;
|
import com.java110.api.importData.IImportDataCleaningAdapt;
|
import com.java110.dto.PropertyWhiteListFlowDto;
|
import com.java110.dto.contract.ContractDto;
|
import com.java110.dto.contract.ContractPartyaDto;
|
import com.java110.dto.system.ComponentValidateResult;
|
import com.java110.intf.fee.IPayFeeBatchV1InnerServiceSMO;
|
import com.java110.intf.store.IContractInnerServiceSMO;
|
import com.java110.intf.store.IContractPartyaInnerServiceSMO;
|
import com.java110.intf.user.IUserInnerServiceSMO;
|
import com.java110.po.contract.ContractPo;
|
import com.java110.utils.util.Assert;
|
import com.java110.utils.util.DateUtil;
|
import com.java110.utils.util.ImportExcelUtils;
|
import com.java110.utils.util.StringUtil;
|
import org.apache.poi.ss.usermodel.Sheet;
|
import org.apache.poi.ss.usermodel.Workbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
@Service("importContractDataCleaning")
|
public class ImportContractDataCleaningAdapt extends DefaultImportDataAdapt implements IImportDataCleaningAdapt {
|
|
|
@Autowired
|
private IPayFeeBatchV1InnerServiceSMO payFeeBatchV1InnerServiceSMOImpl;
|
|
@Autowired
|
private IContractInnerServiceSMO contractInnerServiceSMOImpl;
|
|
@Autowired
|
private IContractPartyaInnerServiceSMO contractPartyaInnerServiceSMOImpl;
|
|
|
@Override
|
public List analysisExcel(Workbook workbook, JSONObject paramIn, ComponentValidateResult result) throws Exception {
|
|
generatorBatch(paramIn);
|
List<ContractPo> whiteLists = new ArrayList<ContractPo>();
|
//获取车辆信息
|
getConctractDtos(workbook, whiteLists);
|
|
for (ContractPo whiteList : whiteLists){
|
whiteList.setCommunityId(paramIn.getString("communityId"));
|
whiteList.setStoreId(paramIn.getString("storeId"));
|
whiteList.setStartUserId(paramIn.getString("userId"));
|
whiteList.setObjType("1111");
|
}
|
return whiteLists;
|
}
|
|
private void getConctractDtos(Workbook workbook, List<ContractPo> whiteLists) {
|
Sheet sheet = null;
|
sheet = ImportExcelUtils.getSheet(workbook, "起草合同模板");
|
List<Object[]> oList = ImportExcelUtils.listFromSheet(sheet);
|
ContractPo contractDto = null;
|
for (int osIndex = 0; osIndex < oList.size(); osIndex++) {
|
Object[] os = oList.get(osIndex);
|
if (osIndex == 0 || osIndex == 1) { // 第一行是 头部信息 直接跳过
|
continue;
|
}
|
if (StringUtil.isNullOrNone(os[0])) {
|
continue;
|
}
|
Assert.hasValue(os[0], (osIndex + 1) + "行收费日期不能为空");
|
|
contractDto = new ContractPo();
|
try{
|
String startTime = excelDoubleToDate(os[14].toString());
|
String endTime = excelDoubleToDate(os[15].toString());
|
String createTime = excelDoubleToDate(os[16].toString());
|
Assert.isDate(startTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "行开始时间格式错误 请填写YYYY-MM-DD 文本格式");
|
Assert.isDate(endTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "行结束时间格式错误 请填写YYYY-MM-DD 文本格式");
|
Assert.isDate(createTime, DateUtil.DATE_FORMATE_STRING_B, (osIndex + 1) + "行签订时间格式错误 请填写YYYY-MM-DD 文本格式");
|
contractDto.setStartTime(startTime);
|
contractDto.setEndTime(endTime);
|
contractDto.setSigningTime(createTime);
|
}catch (Exception e){
|
throw new IllegalArgumentException("请填写"+(osIndex+1)+"行"+oList.get(1)[14].toString()+"/"+oList.get(1)[15].toString()+"/"+oList.get(1)[16].toString());
|
}
|
// 01257101112131415
|
|
try {
|
contractDto.setContractName(os[0].toString());
|
contractDto.setContractCode(os[1].toString());
|
contractDto.setaPartyaId(os[2].toString());
|
contractDto.setbPartyaId(os[5].toString());
|
contractDto.setOperator(os[11].toString());
|
contractDto.setOperatorLink(os[12].toString());
|
contractDto.setAmount(os[13].toString());
|
} catch (Exception e) {
|
throw new IllegalArgumentException("请填写第"+(osIndex+1)+"行完整信息");
|
}
|
contractDto.setaContacts(!StringUtil.isNullOrNone(os[3]) ? os[3].toString() : null);
|
contractDto.setaLink(!StringUtil.isNullOrNone(os[4]) ? os[4].toString() : null);
|
contractDto.setbContacts(!StringUtil.isNullOrNone(os[6]) ? os[6].toString() : null);
|
contractDto.setbLink(!StringUtil.isNullOrNone(os[7]) ? os[7].toString() : null);
|
contractDto.setcPartyaId(!StringUtil.isNullOrNone(os[8]) ? os[8].toString() : null);
|
contractDto.setcContacts(!StringUtil.isNullOrNone(os[9]) ? os[9].toString() : null);
|
contractDto.setcLink(!StringUtil.isNullOrNone(os[10]) ? os[10].toString() : null);
|
contractDto.setContractType(!StringUtil.isNullOrNone(os[17]) ? os[17].toString() : null);
|
contractDto.setStatusCd("0");
|
contractDto.setObjId("-1");
|
whiteLists.add(contractDto);
|
}
|
}
|
}
|
