联讯物业系统后台
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
928255095
2021-09-07 65763d38cf9b6b8067a293d9c99297efea0de3e3 
 service-front/src/main/java/com/java110/front/smo/assetExport/impl/ExportRoomSMOImpl.java

old mode 100644
new mode 100755

@@ -4,15 +4,15 @@


import com.alibaba.fastjson.JSONObject;


import com.java110.core.component.BaseComponentSMO;


import com.java110.core.context.IPageData;


import com.java110.dto.fee.FeeDto;


import com.java110.entity.component.ComponentValidateResult;


import com.java110.front.smo.assetExport.IExportRoomSMO;


import com.java110.utils.constant.ServiceConstant;


import com.java110.utils.util.Assert;


import com.java110.utils.util.DateUtil;


import org.apache.poi.hssf.usermodel.HSSFWorkbook;


import org.apache.poi.ss.usermodel.Row;


import org.apache.poi.ss.usermodel.Sheet;


import org.apache.poi.ss.usermodel.Workbook;


import org.apache.poi.ss.usermodel.*;


import org.apache.poi.ss.util.CellRangeAddress;


import org.apache.poi.xssf.usermodel.XSSFWorkbook;


import org.slf4j.Logger;


import org.slf4j.LoggerFactory;


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


@@ -47,19 +47,27 @@




        ComponentValidateResult result = this.validateStoreStaffCommunityRelationship(pd, restTemplate);




        JSONObject paramIn = JSONObject.parseObject(pd.getReqData());




        Assert.hasKeyAndValue(JSONObject.parseObject(pd.getReqData()), "communityId", "请求中未包含小区");


        Assert.hasKeyAndValue(paramIn, "objType", "请求中未包含费用对象");




        Workbook workbook = null;  //工作簿


        //工作表


        workbook = new HSSFWorkbook();


        //获取楼信息


        getRooms(pd, result, workbook);


        workbook = new XSSFWorkbook();




        if (FeeDto.PAYER_OBJ_TYPE_ROOM.equals(paramIn.getString("objType"))) {


            //获取楼信息


            getRooms(pd, result, workbook);


        } else {


            getCars(pd, result, workbook);


        }






        ByteArrayOutputStream os = new ByteArrayOutputStream();


        MultiValueMap headers = new HttpHeaders();


        headers.add("content-type", "application/octet-stream;charset=UTF-8");


        headers.add("Content-Disposition", "attachment;filename=" + DateUtil.getyyyyMMddhhmmssDateString() + ".xls");


        headers.add("Content-Disposition", "attachment;filename=feeImport_" + DateUtil.getyyyyMMddhhmmssDateString() + ".xlsx");


        headers.add("Pargam", "no-cache");


        headers.add("Cache-Control", "no-cache");


        //headers.add("Content-Disposition", "attachment; filename=" + outParam.getString("fileName"));


@@ -77,6 +85,51 @@


        }


        // 保存数据


        return new ResponseEntity<Object>(context, headers, HttpStatus.OK);


    }




    /**


     * 查询车辆


     *


     * @param pd


     * @param result


     * @param workbook


     */


    private void getCars(IPageData pd, ComponentValidateResult result, Workbook workbook) {


        Sheet sheet = workbook.createSheet("车位费用信息");


        Row row = sheet.createRow(0);


        Cell cell0 = row.createCell(0);


        cell0.setCellValue("费用名称: 请填写系统中费用类型，如停车费等 ；\n开始时间: " +


                "收费开始时间，格式为YYYY-MM-DD；\n结束时间: 费用结束时间，格式为YYYY-MM-DD； \n收费金额: 本次收取金额 单位元； " +


                "\n注意：所有单元格式为文本");


        CellStyle cs = workbook.createCellStyle();


        cs.setWrapText(true);  //关键


        cell0.setCellStyle(cs);


        row.setHeight((short) (200 * 10));


        row = sheet.createRow(1);


        row.createCell(0).setCellValue("车牌号");


        row.createCell(1).setCellValue("费用名称");


        row.createCell(2).setCellValue("开始时间");


        row.createCell(3).setCellValue("结束时间");


        row.createCell(4).setCellValue("收费金额");




        //查询楼栋信息


        JSONArray cars = this.getExistsCars(pd, result);


        if (cars == null) {


            CellRangeAddress region = new CellRangeAddress(0, 0, 0, 4);


            sheet.addMergedRegion(region);


            return;


        }


        for (int carIndex = 0; carIndex < cars.size(); carIndex++) {


            row = sheet.createRow(carIndex + 2);


            row.createCell(0).setCellValue(cars.getJSONObject(carIndex).getString("carNum"));


            row.createCell(1).setCellValue("");


            row.createCell(2).setCellValue("");


            row.createCell(3).setCellValue("");


            row.createCell(4).setCellValue("");


        }




        CellRangeAddress region = new CellRangeAddress(0, 0, 0, 4);


        sheet.addMergedRegion(region);


    }






@@ -110,6 +163,36 @@




    }




    /**


     * 查询存在的房屋信息


     * room.queryRooms


     *


     * @param pd


     * @param result


     * @return


     */


    private JSONArray getExistsCars(IPageData pd, ComponentValidateResult result) {


        String apiUrl = "";


        ResponseEntity<String> responseEntity = null;


        apiUrl = ServiceConstant.SERVICE_API_URL + "/api/owner.queryOwnerCars?page=1&row=10000&communityId=" + result.getCommunityId();


        responseEntity = this.callCenterService(restTemplate, pd, "", apiUrl, HttpMethod.GET);




        if (responseEntity.getStatusCode() != HttpStatus.OK) { //跳过 保存单元信息


            return null;


        }




        JSONObject savedCarInfoResults = JSONObject.parseObject(responseEntity.getBody());






        if (!savedCarInfoResults.containsKey("data")) {


            return null;


        }






        return savedCarInfoResults.getJSONArray("data");




    }






    private JSONArray getExistsUnit(IPageData pd, ComponentValidateResult result, String floorId) {


        String apiUrl = "";


@@ -127,27 +210,6 @@


        return savedFloorInfoResults;


    }




    private JSONArray getExistsFloor(IPageData pd, ComponentValidateResult result) {


        String apiUrl = "";


        ResponseEntity<String> responseEntity = null;


        apiUrl = ServiceConstant.SERVICE_API_URL + "/api/floor.queryFloors?page=1&row=100&communityId=" + result.getCommunityId();




        responseEntity = this.callCenterService(restTemplate, pd, "", apiUrl, HttpMethod.GET);




        if (responseEntity.getStatusCode() != HttpStatus.OK) { //跳过 保存单元信息


            return null;


        }




        JSONObject savedFloorInfoResult = JSONObject.parseObject(responseEntity.getBody());




        if (!savedFloorInfoResult.containsKey("apiFloorDataVoList")) {


            return null;


        }




        return savedFloorInfoResult.getJSONArray("apiFloorDataVoList");




    }






    /**


     * 获取 房屋信息


@@ -156,8 +218,17 @@


     * @param workbook


     */


    private void getRooms(IPageData pd, ComponentValidateResult componentValidateResult, Workbook workbook) {


        Sheet sheet = workbook.createSheet("房屋信息");


        Sheet sheet = workbook.createSheet("房屋费用信息");


        Row row = sheet.createRow(0);


        Cell cell0 = row.createCell(0);


        cell0.setCellValue("费用名称: 请填写系统中费用类型，如物业费，押金等 ；\n开始时间: " +


                "收费开始时间，格式为YYYY-MM-DD；\n结束时间: 费用结束时间，格式为YYYY-MM-DD； \n收费金额: 本次收取金额 单位元； " +


                "\n注意：所有单元格式为文本");


        CellStyle cs = workbook.createCellStyle();


        cs.setWrapText(true);  //关键


        cell0.setCellStyle(cs);


        row.setHeight((short) (200 * 10));


        row = sheet.createRow(1);


        row.createCell(0).setCellValue("楼栋编号");


        row.createCell(1).setCellValue("单元编号");


        row.createCell(2).setCellValue("房屋编码");


@@ -169,10 +240,12 @@


        //查询楼栋信息


        JSONArray rooms = this.getExistsRoom(pd, componentValidateResult);


        if (rooms == null) {


            CellRangeAddress region = new CellRangeAddress(0, 0, 0, 6);


            sheet.addMergedRegion(region);


            return;


        }


        for (int roomIndex = 0; roomIndex < rooms.size(); roomIndex++) {


            row = sheet.createRow(roomIndex + 1);


            row = sheet.createRow(roomIndex + 2);


            row.createCell(0).setCellValue(rooms.getJSONObject(roomIndex).getString("floorNum"));


            row.createCell(1).setCellValue(rooms.getJSONObject(roomIndex).getString("unitNum"));


            row.createCell(2).setCellValue(rooms.getJSONObject(roomIndex).getString("roomNum"));


@@ -181,40 +254,9 @@


            row.createCell(5).setCellValue("");


            row.createCell(6).setCellValue("");


        }


    }






    /**


     * 获取小区


     *


     * @param workbook


     */


    private void getFloors(IPageData pd, ComponentValidateResult componentValidateResult, Workbook workbook) {


        Sheet sheet = workbook.createSheet("楼栋单元");


        Row row = sheet.createRow(0);


        row.createCell(0).setCellValue("楼栋号");


        row.createCell(1).setCellValue("单元编号");


        row.createCell(2).setCellValue("总层数");


        row.createCell(3).setCellValue("是否有电梯");




        //查询楼栋信息


        JSONArray floors = this.getExistsFloor(pd, componentValidateResult);




        if (floors == null) {


            return;


        }


        for (int floorIndex = 0; floorIndex < floors.size(); floorIndex++) {


            JSONArray units = this.getExistsUnit(pd, componentValidateResult, floors.getJSONObject(floorIndex).getString("floorId"));


            for (int unitIndex = 0; unitIndex < units.size(); unitIndex++) {


                row = sheet.createRow(floorIndex + 1);


                row.createCell(0).setCellValue(floors.getJSONObject(floorIndex).getString("floorNum"));


                row.createCell(1).setCellValue(units.getJSONObject(unitIndex).getString("unitNum"));


                row.createCell(2).setCellValue(units.getJSONObject(unitIndex).getString("layerCount"));


                row.createCell(3).setCellValue("1010".equals(units.getJSONObject(unitIndex).getString("lift")) ? "有" : "无");


            }


        }






        CellRangeAddress region = new CellRangeAddress(0, 0, 0, 6);


        sheet.addMergedRegion(region);


    }




    public RestTemplate getRestTemplate() {