水电话费

jialh

1 天以前 dd6687b118561100e1677e88a9c2f5842a54c531

 service-api/src/main/java/com/java110/api/importData/adapt/ImportContractCleaningAdapt.java

@@ -6,6 +6,7 @@
import com.java110.core.factory.GenerateCodeFactory;
import com.java110.dto.contract.*;
import com.java110.dto.importData.ImportOwnerRoomDto;
import com.java110.dto.importData.Vtil;
import com.java110.dto.system.ComponentValidateResult;
import com.java110.utils.util.Assert;
import com.java110.utils.util.DateUtil;
@@ -18,6 +19,7 @@
import java.math.BigDecimal;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Date;
import java.util.List;

@@ -53,7 +55,7 @@
        List<Object[]> oList = ImportExcelUtils.listFromSheet(sheet);
        ImportOwnerRoomDto importOwnerRoomDto = null;
        for (int osIndex = 0; osIndex < oList.size(); osIndex++) {
            if (osIndex < 6) {
            if (osIndex < 5) {
                continue;
            }

@@ -62,21 +64,26 @@
            }

            Object[] os = oList.get(osIndex);
            if (os == null) { // 新增空值判断
                os = new Object[142]; // 空数组则直接创建长度为 142 的数组
            } else if (os.length < 142) {
                os = Arrays.copyOf(os, 142);
            }

            ContractDto contractDto = new ContractDto();
            contractDto.setContractId(GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_contractId));
            contractDto.setPropertyCompany(defaultValue(os[qbl + 1]));
            contractDto.setCommunityName(defaultValue(os[qbl + 2]));
            contractDto.setState(defaultValue(os[qbl + 3]));
            contractDto.setStartTime(defaultValue(os[qbl + 4]));
            contractDto.setEndTime(defaultValue(os[qbl + 5]));
            String now = DateUtil.getFormatTimeStringB(new Date());
            contractDto.setSigningTime(defaultValue(os[qbl + 6]).equals("") ? now : defaultValue(os[qbl + 6]));
            contractDto.setStartTime(Vtil.defaultValueToDate(os[qbl + 4]));
            contractDto.setEndTime(Vtil.defaultValueToDate(os[qbl + 5]));
            contractDto.setSigningTime(Vtil.defaultValueToDate(os[qbl + 6]));
            contractDto.setContractTerm(defaultValue(os[qbl + 7]));
            contractDto.setContractCode(defaultValue(os[qbl + 8]));
            contractDto.setIsArchived(defaultValue(os[qbl + 9]));
            contractDto.setContractType(defaultValue(os[qbl + 11]));
            contractDto.setHasSupplementAgreement(defaultValue(os[qbl + 12]));
            contractDto.setContractReminderDate(defaultValue(os[qbl + 13]));
            contractDto.setContractReminderDate(Vtil.defaultValueToDate(os[qbl + 13]));
            contractDto.setPartyA(defaultValue(os[qbl + 14]));
            contractDto.setPartyB(defaultValue(os[qbl + 1]));
            contractDto.setSignatoryAddress(defaultValue(os[qbl + 15]));
@@ -99,40 +106,47 @@
    }

    private void setCcds(ContractDto contractDto, Object[] os) {
        List<ContractCollectionDetailDto> contractCollectionDetailDtos = new ArrayList<>();
        for (int j = 0; j < 10; j++) {
            try {
                int index = j * 7 + 58;
                if (os[index] == null || os[index].equals("")) {
                    return;
                }
                int index = j * 10 + 53;
//                if (os[index] == null || os[index].equals("")) {
//                    return;
//                }
                ContractCollectionDetailDto ccd = new ContractCollectionDetailDto();
                ccd.setContractId(contractDto.getContractId());
                ccd.setCollectionPeriodStart(defaultValue(os[qbl + index]));
                ccd.setQueryCollectionPeriodEnd(defaultValue(os[qbl + index + 1]));
                ccd.setCollectionAmount(defaultValue(os[qbl + index + 2]));
                ccd.setCollectionDate(defaultValue(os[qbl + index + 3]));
                ccd.setCollectionAmount(defaultValue(os[qbl + index + 4]));
                ccd.setSpecialReduction(defaultValue(os[qbl + index + 5]));
                ccd.setUnpaidMoney(defaultValue(os[qbl + index + 6]));
                contractDto.getContractCollectionDetailDtos().add(ccd);

                ccd.setChargeType(Vtil.defaultValue(os[index]));
                ccd.setInvoiceReceiptNo(Vtil.defaultValue(os[index+1]));
                ccd.setWhiteListArchiveNo(Vtil.defaultValue(os[index+2]));

                ccd.setCollectionPeriodStart(Vtil.defaultValueToDate(os[qbl + index + 3]));
                ccd.setQueryCollectionPeriodEnd(Vtil.defaultValueToDate(os[qbl + index + 4]));
                ccd.setCollectionAmount(defaultValue(os[qbl + index + 5]));
                ccd.setCollectionDate(defaultValue(os[qbl + index + 6]));
                ccd.setCollectionAmount(defaultValue(os[qbl + index + 7]));
                ccd.setSpecialReduction(defaultValue(os[qbl + index + 8]));
                ccd.setUnpaidMoney(defaultValue(os[qbl + index + 9]));
                contractCollectionDetailDtos.add(ccd);
            } catch (Exception e){
                continue;
            }
        }
        contractDto.setContractCollectionDetailDtos(contractCollectionDetailDtos);
    }

    private void setCps(ContractDto contractDto, Object[] os) {
        ContractPaymentStatusDto cps = new ContractPaymentStatusDto();
        cps.setContractId(contractDto.getContractId());
        cps.setPaymentStatus(defaultValue(os[qbl + 49]));
        cps.setReceivableAmount(defaultValue(os[qbl + 50]));
        cps.setReceivedAmount(defaultValue(os[qbl + 51]));
        cps.setUnpaidAmount(defaultValue(os[qbl + 52]));
        cps.setSpecialDiscount(defaultValue(os[qbl + 53]));
        cps.setCollectionProgress(defaultValue(os[qbl + 54]));
        cps.setFinalCollectionDeadline(defaultValue(os[qbl + 55]));
        cps.setCollectionReminderStatus(defaultValue(os[qbl + 56]));
        cps.setRemark(defaultValue(os[qbl + 57]));
        cps.setPaymentStatus(defaultValue(os[qbl + 44]));
        cps.setReceivableAmount(defaultValue(os[qbl + 45]));
        cps.setReceivedAmount(defaultValue(os[qbl + 46]));
        cps.setUnpaidAmount(defaultValue(os[qbl + 47]));
        cps.setSpecialDiscount(defaultValue(os[qbl + 48]));
        cps.setCollectionProgress(defaultValue(os[qbl + 49]));
        cps.setFinalCollectionDeadline(defaultValue(os[qbl + 50]));
        cps.setCollectionReminderStatus(defaultValue(os[qbl + 51]));
        cps.setRemark(defaultValue(os[qbl + 52]));

        contractDto.setContractPaymentStatus(cps);
    }
@@ -140,10 +154,10 @@
    private void setCms(ContractDto contractDto, Object[] os) {
        ContractManagementShareDto cms = new ContractManagementShareDto();
        cms.setContractId(contractDto.getContractId());
        cms.setManagementRatio(defaultValue(os[qbl + 45]));
        cms.setOurCompanyAmount(defaultValue(os[qbl + 46]));
        cms.setOurCommitteeShare(defaultValue(os[qbl + 47]));
        cms.setOurCompanyReceivable(defaultValue(os[qbl + 48]));
        cms.setManagementRatio(defaultValue(os[qbl + 40]));
        cms.setOurCompanyAmount(defaultValue(os[qbl + 41]));
        cms.setOurCommitteeShare(defaultValue(os[qbl + 42]));
        cms.setOurCompanyReceivable(defaultValue(os[qbl + 43]));

        contractDto.setContractManagementShare(cms);
    }
@@ -156,19 +170,27 @@
        cad.setAnnualAmount(defaultValue(os[qbl + 29]));
        cad.setTotalAmount(defaultValue(os[qbl + 30]));
        cad.setSettlementMethod(defaultValue(os[qbl + 31]));
        cad.setSettlementAmount(defaultValue(os[qbl + 32]));
        cad.setFeeType(defaultValue(os[qbl + 33]));
        cad.setAccountInfo(defaultValue(os[qbl + 34]));
        cad.setMainMeterNo(defaultValue(os[qbl + 35]));
        cad.setSubMeterNo(defaultValue(os[qbl + 36]));
        cad.setLastMonthReading(defaultValue(os[qbl + 37]));
        cad.setCurrentMonthReading(defaultValue(os[qbl + 38]));
        cad.setCurrentPeriodConsumption(defaultValue(os[qbl + 39]));
        cad.setElectricityUnitPrice(defaultValue(os[qbl + 40]));
        cad.setElectricityFee(defaultValue(os[qbl + 41]));
        cad.setDeposit(defaultValue(os[qbl + 42]));
        cad.setSettlementCycle(defaultValue(os[qbl + 43]));
        cad.setPaymentRemark(defaultValue(os[qbl + 44]));

        cad.setAccountInfo(defaultValue(os[qbl + 32]));
        cad.setMainMeterNo(defaultValue(os[qbl + 33]));
        cad.setSubMeterNo(defaultValue(os[qbl + 34]));
        cad.setDeposit(defaultValue(os[qbl + 35]));
        cad.setSettlementCycle(defaultValue(os[qbl + 38]));
        cad.setPaymentRemark(defaultValue(os[qbl + 39]));
//
//        cad.setSettlementAmount(defaultValue(os[qbl + 32]));
//        cad.setFeeType(defaultValue(os[qbl + 33]));
//        cad.setAccountInfo(defaultValue(os[qbl + 34]));
//        cad.setMainMeterNo(defaultValue(os[qbl + 35]));
//        cad.setSubMeterNo(defaultValue(os[qbl + 36]));
//        cad.setLastMonthReading(defaultValue(os[qbl + 37]));
//        cad.setCurrentMonthReading(defaultValue(os[qbl + 38]));
//        cad.setCurrentPeriodConsumption(defaultValue(os[qbl + 39]));
//        cad.setElectricityUnitPrice(defaultValue(os[qbl + 40]));
//        cad.setElectricityFee(defaultValue(os[qbl + 41]));
//        cad.setDeposit(defaultValue(os[qbl + 42]));
//        cad.setSettlementCycle(defaultValue(os[qbl + 43]));
//        cad.setPaymentRemark(defaultValue(os[qbl + 44]));

        contractDto.setContractAmountDetail(cad);
    }