联讯物业系统后台
blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
chengf
2026-01-27 b6184e2ddf3db37a94f7efb3b619bbc64642a292 
 service-api/src/main/java/com/java110/api/importData/adapt/ImportPropertyWhiteListfFlowAdapt.java


@@ -4,10 +4,13 @@


import com.java110.api.importData.DefaultImportDataAdapt;


import com.java110.api.importData.IImportDataCleaningAdapt;


import com.java110.dto.PropertyWhiteListFlowDto;


import com.java110.dto.community.CommunityDto;


import com.java110.dto.importData.ImportRoomFee;


import com.java110.dto.system.ComponentValidateResult;


import com.java110.intf.community.ICommunityInnerServiceSMO;


import com.java110.intf.fee.IPayFeeBatchV1InnerServiceSMO;


import com.java110.intf.user.IUserInnerServiceSMO;


import com.java110.po.meter.MeterWaterPo;


import com.java110.utils.util.Assert;


import com.java110.utils.util.DateUtil;


import com.java110.utils.util.ImportExcelUtils;


@@ -17,10 +20,12 @@


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.stereotype.Service;




import java.text.SimpleDateFormat;


import java.util.ArrayList;


import java.util.Calendar;


import java.util.List;




@Service("importPropertyWhiteListfFlowDataCleaning")


@Service("importPropertyWhiteListFlowDataCleaning")


public class ImportPropertyWhiteListfFlowAdapt extends DefaultImportDataAdapt implements IImportDataCleaningAdapt {






@@ -29,6 +34,9 @@




    @Autowired


    private IUserInnerServiceSMO userInnerServiceSMOImpl;




    @Autowired


    private ICommunityInnerServiceSMO communityInnerServiceSMOImpl;






    @Override


@@ -45,6 +53,26 @@


        return whiteLists;


    }






    public String getCommunityId(Object[] os) {


        CommunityDto d = new CommunityDto();


        d.setCommunityCode(defaultValue(os[1]));


        d.setName(defaultValue(os[2]));


        List<CommunityDto> communityDtos = communityInnerServiceSMOImpl.queryCommunitys(d);


        if (communityDtos.isEmpty()) {


            throw new IllegalArgumentException("未查询到小区：" + d.getCommunityCode() + d.getName());


        }


        else if (communityDtos.size() > 1) {


            throw new IllegalArgumentException("查询小区异常:存在多个符合条件的小区：" + d.getCommunityCode() + d.getName());


        }


        return communityDtos.get(0).getCommunityId();


    }






    public String defaultValue(Object o) {


        return o == null ? "" : o.toString();


    }




    private void getPropertyWhiteListFlowDtos(Workbook workbook, List<PropertyWhiteListFlowDto> whiteLists) {


        Sheet sheet = null;


        sheet = ImportExcelUtils.getSheet(workbook, "白单流水  导入新模板");


@@ -52,8 +80,7 @@


        PropertyWhiteListFlowDto white = null;


        for (int osIndex = 0; osIndex < oList.size(); osIndex++) {


            Object[] os = oList.get(osIndex);


            os = removeElement(os, 5);


            if (osIndex == 0) { // 第一行是 头部信息 直接跳过


            if (osIndex == 1) { // 第一行是 头部信息 直接跳过


                continue;


            }


            if (StringUtil.isNullOrNone(os[3])) {


@@ -61,23 +88,25 @@


            }


            Assert.hasValue(os[3], (osIndex + 1) + "行收费日期不能为空");






            white = new PropertyWhiteListFlowDto();


            String chargeTime = excelDoubleToDate(os[3].toString());


            String changeStart = os[11] == null ? null : excelDoubleToDate(os[21].toString());


            String changeEnd = os[12] == null ? null : excelDoubleToDate(os[22].toString());


            String bankDepositDate =  os[16] == null ? null : excelDoubleToDate(os[16].toString());//银行解款日期


            String changeStart = defaultValueToDate(os[11]);


            String changeEnd = defaultValueToDate(os[12]);


            String bankDepositDate =  defaultValueToDate(os[16]);


            String inputTime = null;


            if(os[24] != null){


                inputTime = excelDoubleToDate(os[24].toString().split("\\.")[3]);


                inputTime = defaultValueToDate(os[24]);


            }


            white.setChargeTime(chargeTime);//收费时间


            white.setInvoiceReceiptNo(os[4] == null ? null : os[4].toString());//发票


            white.setInvoiceReceiptNo(defaultValueToDate(os[4]));//发票


            white.setRoomId(os[5] == null ? null : os[5].toString());//房号


            white.setPropertyAddress(os[5] == null ? null : os[5].toString());//业主地址


            white.setDoorRoomNum((os[6] == null ? "" : os[6].toString() + "-") + (os[7] == null ? "" : os[7].toString() + "-") + (os[8] == null ? "" : os[8].toString()) );//门市号


            if (white.getDoorRoomNum().isEmpty()){


                white.setDoorRoomNum(null);


            }


            white.setCommunityId(getCommunityId(os));


            white.setSecondaryFeeTypeCd(os[13] == null ? null : os[13].toString());//收费内容


            white.setChargeAmount(os[14] == null ? null : os[14].toString());//收费金额


            white.setCharger(os[15] == null ? null : os[15].toString());//收费人


@@ -96,7 +125,7 @@


            white.setCategory22(os[31] == null ? null : os[31].toString());//25项收费分类


            white.setRoomNumber(os[9] == null ? null : os[9].toString());


            white.setReceiptYear(os[27] == null ? null : os[27].toString());


            white.setReceiptYearMonth(os[26] == null ? null : os[26].toString());


            white.setReceiptYearMonth(defaultValueToDate(os[26]));


            white.setPendingProblem(os[30] == null ? null : os[30].toString());


//            if (os.length > 23){


//                white.setFrequency(os[23] == null ? null : os[23].toString());


@@ -125,67 +154,86 @@




        return newArray;


    }


//


//    private void getPropertyWhiteListFlowDtosV1(Workbook workbook, List<PropertyWhiteListFlowDto> whiteLists) {


//        Sheet sheet = null;


//        sheet = ImportExcelUtils.getSheet(workbook, "白单流水（归档数据）");


//        List<Object[]> oList = ImportExcelUtils.listFromSheet(sheet);


//        PropertyWhiteListFlowDto white = null;


//        for (int osIndex = 0; osIndex < oList.size(); osIndex++) {


//            Object[] os = oList.get(osIndex);


//            if (osIndex == 0) { // 第一行是 头部信息 直接跳过


//                continue;


//            }


//            if (StringUtil.isNullOrNone(os[0])) {


//                continue;


//            }


//            Assert.hasValue(os[0], (osIndex + 1) + "行收费日期不能为空");


//


//            white = new PropertyWhiteListFlowDto();


//            String chargeTime = excelDoubleToDate(os[0].toString());


//            String changeStart = os[21] == null ? null : excelDoubleToDate(os[21].toString());


//            String changeEnd = os[22] == null ? null : excelDoubleToDate(os[22].toString());


//            String bankDepositDate =  os[8] == null ? null : excelDoubleToDate(os[8].toString());


//            String inputTime = null;


//            if(os[16] != null){


//                inputTime = excelDoubleToDate(os[16].toString().split("\\.")[0]);


//            }


//            white.setChargeTime(chargeTime);


//            white.setInvoiceReceiptNo(os[1] == null ? null : os[1].toString());


//            white.setRoomId(os[2] == null ? null : os[2].toString());


//            white.setPropertyAddress(os[3] == null ? null : os[3].toString());


//            white.setDoorRoomNum(defaultValueToDate(os[4]));


//            white.setSecondaryFeeTypeCd(os[5] == null ? null : os[5].toString());


//            white.setChargeAmount(os[6] == null ? null : os[6].toString());


//            white.setCharger(os[7] == null ? null : os[7].toString());


//            white.setBankDepositDate(bankDepositDate);


//            white.setBankDepositor(os[9] == null ? null : os[9].toString());


//            white.setSplitBankDepositAmount(os[10] == null ? null : os[10].toString());


//            white.setBankDepositAmount(os[11] == null ? null : os[11].toString());


//            white.setCheckAmount(os[12] == null ? null : os[12].toString());


//            white.setWhiteListArchiveNo(os[13] == null ? null : os[13].toString());


//            white.setSheetCount(os[14] == null ? null : os[14].toString());


//            white.setFinancialReceiver(os[15] == null ? null : os[15].toString());


//            white.setInputTime(inputTime);


//            white.setInputPerson(os[17] == null ? null : os[17].toString());


//            white.setOrderNo(os[18] == null ? null : os[18].toString());


//            white.setLicensePlate(os[19] == null ? null : os[19].toString());


//            white.setCategory22(os[20] == null ? null : os[20].toString());


//            if (os.length > 23){


//                white.setFrequency(os[23] == null ? null : os[23].toString());


//            }


//            white.setChargeStart(changeStart);


//            white.setChargeEnd(changeEnd);


//            white.setRow(osIndex + 1);


//            whiteLists.add(white);


//        }


//    }




    private void getPropertyWhiteListFlowDtosV1(Workbook workbook, List<PropertyWhiteListFlowDto> whiteLists) {


        Sheet sheet = null;


        sheet = ImportExcelUtils.getSheet(workbook, "白单流水（归档数据）");


        List<Object[]> oList = ImportExcelUtils.listFromSheet(sheet);


        PropertyWhiteListFlowDto white = null;


        for (int osIndex = 0; osIndex < oList.size(); osIndex++) {


            Object[] os = oList.get(osIndex);


            if (osIndex == 0) { // 第一行是 头部信息 直接跳过


                continue;


            }


            if (StringUtil.isNullOrNone(os[0])) {


                continue;


            }


            Assert.hasValue(os[0], (osIndex + 1) + "行收费日期不能为空");




            white = new PropertyWhiteListFlowDto();


            String chargeTime = excelDoubleToDate(os[0].toString());


            String changeStart = os[21] == null ? null : excelDoubleToDate(os[21].toString());


            String changeEnd = os[22] == null ? null : excelDoubleToDate(os[22].toString());


            String bankDepositDate =  os[8] == null ? null : excelDoubleToDate(os[8].toString());


            String inputTime = null;


            if(os[16] != null){


                inputTime = excelDoubleToDate(os[16].toString().split("\\.")[0]);


            }


            white.setChargeTime(chargeTime);


            white.setInvoiceReceiptNo(os[1] == null ? null : os[1].toString());


            white.setRoomId(os[2] == null ? null : os[2].toString());


            white.setPropertyAddress(os[3] == null ? null : os[3].toString());


            white.setDoorRoomNum(os[4] == null ? null : os[4].toString());


            white.setSecondaryFeeTypeCd(os[5] == null ? null : os[5].toString());


            white.setChargeAmount(os[6] == null ? null : os[6].toString());


            white.setCharger(os[7] == null ? null : os[7].toString());


            white.setBankDepositDate(bankDepositDate);


            white.setBankDepositor(os[9] == null ? null : os[9].toString());


            white.setSplitBankDepositAmount(os[10] == null ? null : os[10].toString());


            white.setBankDepositAmount(os[11] == null ? null : os[11].toString());


            white.setCheckAmount(os[12] == null ? null : os[12].toString());


            white.setWhiteListArchiveNo(os[13] == null ? null : os[13].toString());


            white.setSheetCount(os[14] == null ? null : os[14].toString());


            white.setFinancialReceiver(os[15] == null ? null : os[15].toString());


            white.setInputTime(inputTime);


            white.setInputPerson(os[17] == null ? null : os[17].toString());


            white.setOrderNo(os[18] == null ? null : os[18].toString());


            white.setLicensePlate(os[19] == null ? null : os[19].toString());


            white.setCategory22(os[20] == null ? null : os[20].toString());


            if (os.length > 23){


                white.setFrequency(os[23] == null ? null : os[23].toString());


            }


            white.setChargeStart(changeStart);


            white.setChargeEnd(changeEnd);


            white.setRow(osIndex + 1);


            whiteLists.add(white);


        }


    private String defaultValueToDate(Object o) {


        // 空值直接返回null（原有逻辑）


        if (o == null) {


            return null;


    }




    /**


     * 生成批次号


     *


     * @param reqJson


     */


        try {


            // 尝试将对象转换为数字（兼容Excel日期序列号，如44747）


            double excelDateNum = Double.parseDouble(o.toString());




            // Excel 1900日期系统基准（修正闰日bug，实际基准是1899-12-30）


            Calendar calendar = Calendar.getInstance();


            calendar.set(1899, 11, 30, 0, 0, 0); // 月份从0开始，11代表12月


            calendar.set(Calendar.MILLISECOND, 0);




            // 计算对应的实际日期


            calendar.add(Calendar.DAY_OF_MONTH, (int) excelDateNum);




            // 格式化为yyyy-MM-dd的日期字符串


            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");


            return sdf.format(calendar.getTime());


        } catch (NumberFormatException e) {


            // 非数字类型，执行原有逻辑返回toString()


            return o.toString();


        }


    }


}