Lianxun_Java.git

			@@ -5,6 +5,7 @@
			import com.java110.api.smo.assetImport.IImportOwnerCarSMO;
			import com.java110.core.context.IPageData;
			import com.java110.core.factory.GenerateCodeFactory;
			import com.java110.core.log.LoggerFactory;
			import com.java110.dto.FloorDto;
			import com.java110.dto.RoomDto;
			import com.java110.dto.UnitDto;
			@@ -15,15 +16,17 @@
			import com.java110.dto.parking.ParkingSpaceDto;
			import com.java110.entity.component.ComponentValidateResult;
			import com.java110.intf.community.*;
			import com.java110.intf.user.*;
			import com.java110.intf.user.IOwnerCarV1InnerServiceSMO;
			import com.java110.intf.user.IOwnerInnerServiceSMO;
			import com.java110.intf.user.IOwnerRoomRelInnerServiceSMO;
			import com.java110.po.car.OwnerCarPo;
			import com.java110.po.parking.ParkingAreaPo;
			import com.java110.po.parking.ParkingSpacePo;
			import com.java110.utils.util.*;
			import com.java110.vo.ResultVo;
			import org.apache.poi.ss.usermodel.Sheet;
			import org.apache.poi.ss.usermodel.Workbook;
			import org.slf4j.Logger;
			import com.java110.core.log.LoggerFactory;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.http.HttpStatus;
			import org.springframework.http.ResponseEntity;
			@@ -67,7 +70,13 @@
			private IParkingAreaInnerServiceSMO parkingAreaInnerServiceSMOImpl;

			@Autowired
			private IParkingAreaV1InnerServiceSMO parkingAreaV1InnerServiceSMOImpl;

			@Autowired
			private IParkingSpaceInnerServiceSMO parkingSpaceInnerServiceSMOImpl;

			@Autowired
			private IParkingSpaceV1InnerServiceSMO parkingSpaceV1InnerServiceSMOImpl;

			@Override
			public ResponseEntity<String> importExcelData(IPageData pd, MultipartFile uploadFile) throws Exception {
			@@ -129,7 +138,13 @@
			importOwnerCar.setOwnerName(os[5].toString());
			//获取车位
			String parkingLot = os[6].toString();
			String[] split = parkingLot.split("-");
			if(!parkingLot.contains("-")){
			throw new IllegalArgumentException((osIndex + 1) +"行车位格式错误格式应为：停车场-车位编号，车位编号可以从1自行编写");
			}
			String[] split = parkingLot.split("-",2);
			if(split.length != 2){
			throw new IllegalArgumentException((osIndex + 1) +"行车位格式错误格式应为：停车场-车位编号，车位编号可以从1自行编写");
			}
			importOwnerCar.setAreaNum(split[0]);
			importOwnerCar.setNum(split[1]);
			SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			@@ -138,6 +153,8 @@
			importOwnerCar.setTypeCd(os[9].toString());
			importOwnerCar.setSpaceSate(os[10].toString());
			ownerCarDtos.add(importOwnerCar);


			}
			}

			@@ -160,11 +177,96 @@
			if (ownerCars.size() < 1) {
			throw new IllegalArgumentException("没有数据需要处理");
			}
			String psId = "";
			String paId = "";

			validateOwnerData(ownerCars, reqJson);
			for (OwnerCarDto ownerCarDto : ownerCars) {
			OwnerCarPo ownerCarPo = BeanConvertUtil.covertBean(ownerCarDto, OwnerCarPo.class);
			//获取房屋名称
			String roomName = ownerCarDto.getRoomName();
			String[] split = roomName.split("-");
			ownerCarPo.setCarTypeCd("1001"); //主车辆
			ParkingAreaDto parkingAreaDto = new ParkingAreaDto();
			parkingAreaDto.setNum(ownerCarDto.getAreaNum());
			parkingAreaDto.setTypeCd(ownerCarDto.getTypeCd());
			//查询停车场
			List<ParkingAreaDto> parkingAreaDtos = parkingAreaInnerServiceSMOImpl.queryParkingAreas(parkingAreaDto);
			//Assert.listOnlyOne(parkingAreaDtos, "查询停车场错误！");
			if (parkingAreaDtos == null \|\| parkingAreaDtos.size() < 1) {
			paId = GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_paId);
			ParkingAreaPo parkingAreaPo = new ParkingAreaPo();
			parkingAreaPo.setCommunityId(reqJson.getString("communityId"));
			parkingAreaPo.setNum(ownerCarDto.getAreaNum());
			parkingAreaPo.setPaId(paId);
			parkingAreaPo.setTypeCd(ownerCarDto.getTypeCd());
			parkingAreaPo.setRemark("导入数据");
			parkingAreaV1InnerServiceSMOImpl.saveParkingArea(parkingAreaPo);
			} else {
			paId = parkingAreaDtos.get(0).getPaId();
			}
			ParkingSpaceDto parkingSpaceDto = new ParkingSpaceDto();
			parkingSpaceDto.setNum(ownerCarDto.getNum());
			parkingSpaceDto.setPaId(paId);
			//查询停车位
			List<ParkingSpaceDto> parkingSpaceDtos = parkingSpaceInnerServiceSMOImpl.queryParkingSpaces(parkingSpaceDto);
			String state = "";
			if (parkingSpaceDtos == null \|\| parkingSpaceDtos.size() < 1) {
			psId = GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_psId);
			ParkingSpacePo parkingSpacePo = new ParkingSpacePo();
			parkingSpacePo.setCommunityId(reqJson.getString("communityId"));
			parkingSpacePo.setNum(ownerCarDto.getNum());
			parkingSpacePo.setPaId(paId);
			parkingSpacePo.setArea("1");
			parkingSpacePo.setParkingType(ParkingSpaceDto.TYPE_CD_COMMON);
			parkingSpacePo.setState(ParkingSpaceDto.STATE_FREE);
			parkingSpacePo.setPsId(psId);
			parkingSpacePo.setRemark("导入数据");
			parkingSpaceV1InnerServiceSMOImpl.saveParkingSpace(parkingSpacePo);
			state = ParkingSpaceDto.STATE_FREE;
			} else {
			psId = parkingSpaceDtos.get(0).getPsId();
			//获取停车位状态(出售 S，出租 H ，空闲 F)
			state = parkingSpaceDtos.get(0).getState();
			}

			if (!StringUtil.isEmpty(state) && !state.equals("F")) {
			throw new IllegalArgumentException(ownerCarDto.getAreaNum() + "停车场-" + ownerCarDto.getNum() + "停车位不是空闲状态！");
			}
			ownerCarPo.setPsId(psId);
			ownerCarPo.setOwnerId(ownerCarDto.getOwnerId());
			ownerCarPo.setUserId("-1");
			ownerCarPo.setCommunityId(reqJson.getString("communityId"));
			ownerCarPo.setCarId(GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_carId));
			ownerCarPo.setMemberId(ownerCarPo.getCarId());
			ownerCarPo.setState("1001"); //1001 正常状态，2002 车位释放欠费状态，3003 车位释放
			ownerCarPo.setLeaseType(ownerCarDto.getSpaceSate());
			ownerCarV1InnerServiceSMOImpl.saveOwnerCar(ownerCarPo);
			ParkingSpacePo parkingSpacePo = new ParkingSpacePo();
			parkingSpacePo.setPsId(psId); //车位id
			parkingSpacePo.setState(ownerCarDto.getSpaceSate());
			parkingSpaceInnerServiceSMOImpl.updateParkingSpace(parkingSpacePo);
			}
			return ResultVo.success();
			}

			private void validateOwnerData(List<OwnerCarDto> ownerCars, JSONObject reqJson) {

			for (OwnerCarDto ownerCarDto : ownerCars) {

			if(!"1001".equals(ownerCarDto.getTypeCd()) && !"2002".equals(ownerCarDto.getTypeCd())){
			throw new IllegalArgumentException(ownerCarDto.getCarNum()+"停车场类型应填写 1001(地上停车场)或者 2002 (地下停车场)");
			}
			if(!"H".equals(ownerCarDto.getSpaceSate()) && !"S".equals(ownerCarDto.getSpaceSate())){
			throw new IllegalArgumentException(ownerCarDto.getCarNum()+"车位状态应填写 S（出售）或者 H （出租）");
			}
			//获取房屋名称
			String roomName = ownerCarDto.getRoomName().trim();
			if(!roomName.contains("-")){
			throw new IllegalArgumentException(ownerCarDto.getCarNum()+"房屋号格式错误格式应为：楼栋-单元-房屋，如果是商铺楼栋-0-商铺编号");
			}
			String[] split = roomName.split("-", 3);
			if(split.length != 3){
			throw new IllegalArgumentException(ownerCarDto.getCarNum()+"房屋号格式错误格式应为：楼栋-单元-房屋，如果是商铺楼栋-0-商铺编号");
			}
			String floorNum = split[0];
			String unitNum = split[1];
			String roomNum = split[2];
			@@ -173,68 +275,35 @@
			floorDto.setFloorNum(floorNum);
			//查询楼栋
			List<FloorDto> floorDtos = floorInnerServiceSMOImpl.queryFloors(floorDto);
			Assert.listOnlyOne(floorDtos, "查询楼栋错误！");
			Assert.listOnlyOne(floorDtos, ownerCarDto.getCarNum() + "查询楼栋错误！");
			UnitDto unitDto = new UnitDto();
			unitDto.setUnitNum(unitNum);
			unitDto.setFloorId(floorDtos.get(0).getFloorId());
			//查询单元
			List<UnitDto> unitDtos = unitInnerServiceSMOImpl.queryUnits(unitDto);
			Assert.listOnlyOne(unitDtos, "查询单元错误！");
			Assert.listOnlyOne(unitDtos, ownerCarDto.getCarNum() + "查询单元错误！");
			RoomDto roomDto = new RoomDto();
			roomDto.setRoomNum(roomNum);
			roomDto.setUnitId(unitDtos.get(0).getUnitId());
			//查询房屋
			List<RoomDto> roomDtos = roomInnerServiceSMOImpl.queryRooms(roomDto);
			Assert.listOnlyOne(roomDtos, "查询房屋错误！");
			Assert.listOnlyOne(roomDtos, ownerCarDto.getCarNum() + "查询房屋错误！");
			OwnerRoomRelDto ownerRoomRelDto = new OwnerRoomRelDto();
			ownerRoomRelDto.setRoomId(roomDtos.get(0).getRoomId());
			//查询业主房屋关系表
			List<OwnerRoomRelDto> ownerRoomRelDtos = ownerRoomRelInnerServiceSMOImpl.queryOwnerRoomRels(ownerRoomRelDto);
			Assert.listOnlyOne(ownerRoomRelDtos, "查询业主房屋信息错误！");
			Assert.listOnlyOne(ownerRoomRelDtos, ownerCarDto.getCarNum() + "查询业主房屋信息错误！");
			OwnerDto ownerDto = new OwnerDto();
			ownerDto.setOwnerId(ownerRoomRelDtos.get(0).getOwnerId());
			ownerDto.setName(ownerCarDto.getOwnerName());
			//查询业主
			List<OwnerDto> ownerDtos = ownerInnerServiceSMOImpl.queryOwners(ownerDto);
			Assert.listOnlyOne(ownerDtos, "查询业主信息错误！");
			if (ownerDtos.get(0).getOwnerTypeCd().equals("1001")) { //业主
			ownerCarPo.setCarTypeCd("1001"); //业主车辆
			} else {
			ownerCarPo.setCarTypeCd("1002"); //成员车辆
			}
			ParkingAreaDto parkingAreaDto = new ParkingAreaDto();
			parkingAreaDto.setNum(ownerCarDto.getAreaNum());
			parkingAreaDto.setTypeCd(ownerCarDto.getTypeCd());
			//查询停车场
			List<ParkingAreaDto> parkingAreaDtos = parkingAreaInnerServiceSMOImpl.queryParkingAreas(parkingAreaDto);
			Assert.listOnlyOne(parkingAreaDtos, "查询停车场错误！");
			ParkingSpaceDto parkingSpaceDto = new ParkingSpaceDto();
			parkingSpaceDto.setNum(ownerCarDto.getNum());
			parkingSpaceDto.setPaId(parkingAreaDtos.get(0).getPaId());
			//查询停车位
			List<ParkingSpaceDto> parkingSpaceDtos = parkingSpaceInnerServiceSMOImpl.queryParkingSpaces(parkingSpaceDto);
			Assert.listOnlyOne(parkingSpaceDtos, "查询停车位错误！");
			//获取停车位状态(出售 S，出租 H ，空闲 F)
			String state = parkingSpaceDtos.get(0).getState();
			if (!StringUtil.isEmpty(state) && !state.equals("F")) {
			throw new IllegalArgumentException(parkingAreaDtos.get(0).getNum() + "停车场-" + parkingSpaceDtos.get(0).getNum() + "停车位不是空闲状态！");
			}
			ownerCarPo.setPsId(parkingSpaceDtos.get(0).getPsId());
			ownerCarPo.setOwnerId(ownerRoomRelDtos.get(0).getOwnerId());
			ownerCarPo.setUserId("-1");
			ownerCarPo.setCommunityId(reqJson.getString("communityId"));
			ownerCarPo.setCarId(GenerateCodeFactory.getGeneratorId(GenerateCodeFactory.CODE_PREFIX_carId));
			ownerCarPo.setMemberId(ownerCarPo.getCarId());
			ownerCarPo.setState("1001"); //1001 正常状态，2002 车位释放欠费状态，3003 车位释放
			ownerCarV1InnerServiceSMOImpl.saveOwnerCar(ownerCarPo);
			ParkingSpacePo parkingSpacePo = new ParkingSpacePo();
			parkingSpacePo.setPsId(parkingSpaceDtos.get(0).getPsId()); //车位id
			parkingSpacePo.setState(ownerCarDto.getSpaceSate());
			parkingSpaceInnerServiceSMOImpl.updateParkingSpace(parkingSpacePo);
			}
			return ResultVo.success();
			Assert.listOnlyOne(ownerDtos, ownerCarDto.getCarNum() + "查询业主信息错误！");
			ownerCarDto.setOwnerId(ownerRoomRelDtos.get(0).getOwnerId());
			}

			}

			//解析Excel日期格式
			public static String excelDoubleToDate(String strDate) {
			if (strDate.length() == 5) {