package com.java110.community.cmd.room;
|
|
import com.alibaba.fastjson.JSONObject;
|
import com.java110.community.bmo.room.IQueryRoomStatisticsBMO;
|
import com.java110.core.annotation.Java110Cmd;
|
import com.java110.core.context.ICmdDataFlowContext;
|
import com.java110.core.event.cmd.Cmd;
|
import com.java110.core.event.cmd.CmdEvent;
|
import com.java110.doc.annotation.*;
|
import com.java110.dto.floor.FloorDto;
|
import com.java110.dto.room.RoomDto;
|
import com.java110.dto.unit.UnitDto;
|
import com.java110.dto.privilege.BasePrivilegeDto;
|
import com.java110.dto.data.DataPrivilegeStaffDto;
|
import com.java110.dto.owner.OwnerDto;
|
import com.java110.intf.community.*;
|
import com.java110.intf.user.IOwnerInnerServiceSMO;
|
import com.java110.intf.user.IOwnerRoomRelInnerServiceSMO;
|
import com.java110.utils.constant.ResponseConstant;
|
import com.java110.utils.exception.CmdException;
|
import com.java110.utils.exception.SMOException;
|
import com.java110.utils.util.*;
|
import com.java110.vo.api.ApiRoomDataVo;
|
import com.java110.vo.api.ApiRoomVo;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.http.HttpStatus;
|
import org.springframework.http.ResponseEntity;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
import java.util.Map;
|
|
@Java110CmdDoc(title = "查询房屋",
|
description = "查询房屋信息",
|
httpMethod = "get",
|
url = "http://{ip}:{port}/app/room.queryRooms",
|
resource = "communityDoc",
|
author = "吴学文",
|
serviceCode = "room.queryRooms",
|
seq = 16
|
)
|
|
@Java110ParamsDoc(params = {
|
@Java110ParamDoc(name = "page", type = "int", length = 11, remark = "页数"),
|
@Java110ParamDoc(name = "row", type = "int", length = 11, remark = "行数"),
|
@Java110ParamDoc(name = "communityId", length = 30, remark = "小区ID"),
|
@Java110ParamDoc(name = "roomId", length = 30, remark = "房屋ID"),
|
@Java110ParamDoc(name = "floorId", length = 30, remark = "楼栋ID"),
|
@Java110ParamDoc(name = "unitId", length = 30, remark = "单元ID"),
|
})
|
|
@Java110ResponseDoc(
|
params = {
|
@Java110ParamDoc(name = "records", type = "int", length = 11, remark = "总页数"),
|
@Java110ParamDoc(name = "total", type = "int", length = 11, remark = "总数据"),
|
@Java110ParamDoc(name = "rooms", type = "Object", remark = "有效数据"),
|
@Java110ParamDoc(parentNodeName = "rooms", name = "roomName", type = "String", remark = "房屋名称"),
|
@Java110ParamDoc(parentNodeName = "rooms", name = "roomId", type = "String", remark = "房屋编号"),
|
}
|
)
|
|
@Java110ExampleDoc(
|
reqBody = "http://{ip}:{port}/app/room.queryRooms?floorId=&floorName=&unitId=&roomNum=&roomId=&state=§ion=&roomType=1010301&roomSubType=&flag=0&page=1&row=10&communityId=2022081539020475",
|
resBody = "{\"page\":0,\"records\":1,\"rooms\":[{\"apartment\":\"10101\",\"apartmentName\":\"一室一厅\",\"builtUpArea\":\"11.00\",\"endTime\":\"2037-01-01 00:00:00\",\"feeCoefficient\":\"1.00\",\"floorId\":\"732022081690440002\",\"floorNum\":\"D\",\"idCard\":\"\",\"layer\":\"1\",\"link\":\"18909711447\",\"ownerId\":\"772022082070860017\",\"ownerName\":\"张杰\",\"remark\":\"11\",\"roomArea\":\"11.00\",\"roomAttrDto\":[{\"attrId\":\"112022082081600012\",\"listShow\":\"Y\",\"page\":-1,\"records\":0,\"roomId\":\"752022082030880010\",\"row\":0,\"specCd\":\"9035007248\",\"specName\":\"精装修\",\"statusCd\":\"0\",\"total\":0,\"value\":\"20\",\"valueName\":\"20\"}],\"roomId\":\"752022082030880010\",\"roomName\":\"D-1-1001\",\"roomNum\":\"1001\",\"roomRent\":\"0.00\",\"roomSubType\":\"110\",\"roomSubTypeName\":\"住宅\",\"roomType\":\"1010301\",\"section\":\"1\",\"startTime\":\"2022-09-03 18:50:53\",\"state\":\"2001\",\"stateName\":\"已入住\",\"unitId\":\"742022082058950007\",\"unitNum\":\"1\"}],\"rows\":0,\"total\":2}"
|
)
|
@Java110Cmd(serviceCode = "room.queryRooms")
|
public class QueryRoomsCmd extends Cmd {
|
|
@Autowired
|
private IUnitInnerServiceSMO unitInnerServiceSMOImpl;
|
|
@Autowired
|
private IFloorInnerServiceSMO floorInnerServiceSMOImpl;
|
|
@Autowired
|
private IRoomInnerServiceSMO roomInnerServiceSMOImpl;
|
|
@Autowired
|
private IOwnerInnerServiceSMO ownerInnerServiceSMOImpl;
|
|
@Autowired
|
private IOwnerRoomRelInnerServiceSMO ownerRoomRelInnerServiceSMOImpl;
|
|
@Autowired
|
private IDataPrivilegeUnitV1InnerServiceSMO dataPrivilegeUnitV1InnerServiceSMOImpl;
|
|
@Autowired
|
private IMenuInnerServiceSMO menuInnerServiceSMOImpl;
|
|
@Autowired
|
private IQueryRoomStatisticsBMO queryRoomStatisticsBMOImpl;
|
|
protected static final int MAX_ROW = 10000;
|
|
@Override
|
public void validate(CmdEvent event, ICmdDataFlowContext cmdDataFlowContext, JSONObject reqJson) {
|
super.validateProperty(cmdDataFlowContext);
|
Assert.hasKeyAndValue(reqJson, "communityId", "请求中未包含communityId信息");
|
//Assert.jsonObjectHaveKey(reqJson, "floorId", "请求中未包含floorId信息");
|
super.validatePageInfo(reqJson);
|
int row = Integer.parseInt(reqJson.getString("row"));
|
|
|
if (row > MAX_ROW) {
|
throw new SMOException(ResponseConstant.RESULT_CODE_ERROR, "row 数量不能大于50");
|
}
|
//校验小区楼ID和小区是否有对应关系
|
int total = floorInnerServiceSMOImpl.queryFloorsCount(BeanConvertUtil.covertBean(reqJson, FloorDto.class));
|
|
if (!StringUtil.isEmpty(reqJson.getString("floorId")) && total < 1) {
|
throw new IllegalArgumentException("传入小区楼ID不是该小区的楼");
|
}
|
}
|
|
@Override
|
public void doCmd(CmdEvent event, ICmdDataFlowContext cmdDataFlowContext, JSONObject reqJson) throws CmdException {
|
RoomDto roomDto = BeanConvertUtil.covertBean(reqJson, RoomDto.class);
|
|
//todo 员工数据权限
|
String staffId = cmdDataFlowContext.getReqHeaders().get("user-id");
|
DataPrivilegeStaffDto dataPrivilegeStaffDto = new DataPrivilegeStaffDto();
|
dataPrivilegeStaffDto.setStaffId(staffId);
|
String[] unitIds = dataPrivilegeUnitV1InnerServiceSMOImpl.queryDataPrivilegeUnitsByStaff(dataPrivilegeStaffDto);
|
|
//todo 计算房屋ID和单元ID
|
computeRoomIdAndUnitId(reqJson, unitIds, roomDto);
|
|
//todo 计算楼栋单元房屋编号
|
computeFloorUnitRoomNum(reqJson, roomDto);
|
|
//todo 商铺 两个短线方式处理 add by wuxw
|
computeRoomShopFloorUnitRoomNum(reqJson, roomDto);
|
|
//todo 处理状态
|
String roomState = reqJson.getString("roomState");
|
if (!StringUtil.isEmpty(roomState)) {
|
roomDto.setStates(roomState.split(","));
|
}
|
|
ApiRoomVo apiRoomVo = new ApiRoomVo();
|
|
//员工是否 有权限查询
|
if (unitIds != null && unitIds.length > 0) {
|
roomDto.setUnitIds(unitIds);
|
}
|
//查询总记录数
|
int total = roomInnerServiceSMOImpl.queryRoomsCount(roomDto);
|
apiRoomVo.setTotal(total);
|
List<RoomDto> roomDtoList = null;
|
if (total > 0) {
|
roomDtoList = roomInnerServiceSMOImpl.queryRooms(roomDto);
|
refreshRoomOwners(reqJson.getString("loginUserId"), reqJson.getString("communityId"), roomDtoList);
|
// todo 查询房屋统计数据
|
roomDtoList = queryRoomStatisticsBMOImpl.query(roomDtoList);
|
} else {
|
roomDtoList = new ArrayList<>();
|
}
|
apiRoomVo.setRooms(BeanConvertUtil.covertBeanList(roomDtoList, ApiRoomDataVo.class));
|
int row = reqJson.getInteger("row");
|
apiRoomVo.setRecords((int) Math.ceil((double) total / (double) row));
|
|
ResponseEntity<String> responseEntity = new ResponseEntity<String>(JSONObject.toJSONString(apiRoomVo), HttpStatus.OK);
|
cmdDataFlowContext.setResponseEntity(responseEntity);
|
}
|
|
/**
|
* 商铺 两个短线方式处理
|
*
|
* @param reqJson
|
* @param roomDto
|
*/
|
private static void computeRoomShopFloorUnitRoomNum(JSONObject reqJson, RoomDto roomDto) {
|
//todo 不是商铺返回
|
if (!reqJson.containsKey("roomType") || !RoomDto.ROOM_TYPE_SHOPS.equals(reqJson.getString("roomType"))) {
|
return;
|
}
|
if (!reqJson.containsKey("roomNum") || StringUtil.isEmpty(reqJson.getString("roomNum"))) {
|
roomDto.setUnitNum("");
|
roomDto.setFloorNum("");
|
roomDto.setRoomNum("");
|
return;
|
}
|
String[] roomNums = reqJson.getString("roomNum").split("-", 2);
|
if (roomNums != null && roomNums.length == 2) {
|
roomDto.setFloorNum(roomNums[0]);
|
roomDto.setUnitNum("0");
|
roomDto.setRoomNum(roomNums[1]);
|
} else {
|
roomDto.setRoomNum(reqJson.getString("roomNum"));
|
}
|
}
|
|
/**
|
* 计算 楼栋单元房屋编号
|
*
|
* @param reqJson
|
* @param roomDto
|
*/
|
private static void computeFloorUnitRoomNum(JSONObject reqJson, RoomDto roomDto) {
|
|
//todo 未包含flag 标识
|
if (!reqJson.containsKey("flag") || !"1".equals(reqJson.getString("flag"))) {
|
return;
|
}
|
if (!reqJson.containsKey("roomNum") || StringUtil.isEmpty(reqJson.getString("roomNum"))) {
|
roomDto.setUnitNum("");
|
roomDto.setFloorNum("");
|
roomDto.setRoomNum("");
|
return;
|
}
|
String[] roomNums = reqJson.getString("roomNum").split("-", 3);
|
if (roomNums != null && roomNums.length == 3) {
|
roomDto.setFloorNum(roomNums[0]);
|
roomDto.setUnitNum(roomNums[1]);
|
roomDto.setRoomNum(roomNums[2]);
|
return;
|
}
|
roomDto.setRoomNum(reqJson.getString("roomNum"));
|
}
|
|
/**
|
* 计算房屋和单元ID
|
*
|
* @param reqJson
|
* @param unitIds
|
* @param roomDto
|
*/
|
private void computeRoomIdAndUnitId(JSONObject reqJson, String[] unitIds, RoomDto roomDto) {
|
|
//todo 未包含flag 标识
|
if (!reqJson.containsKey("flag") || !"0".equals(reqJson.getString("flag"))) {
|
return;
|
}
|
|
//todo 未包含楼栋编号
|
if (!reqJson.containsKey("floorNum") || StringUtil.isEmpty(reqJson.getString("floorNum"))) {
|
return;
|
}
|
|
//todo 未包含单元编号
|
if (!reqJson.containsKey("unitNum") || StringUtil.isEmpty(reqJson.getString("unitNum"))) {
|
return;
|
}
|
|
//todo 未包含房屋编号
|
if (!reqJson.containsKey("roomNum") || StringUtil.isEmpty(reqJson.getString("roomNum"))) {
|
return;
|
}
|
|
//todo 查询楼栋
|
FloorDto floorDto = new FloorDto();
|
floorDto.setFloorNum(reqJson.getString("floorNum"));
|
floorDto.setCommunityId(reqJson.getString("communityId"));
|
List<FloorDto> floorDtos = floorInnerServiceSMOImpl.queryFloors(floorDto);
|
if (ListUtil.isNull(floorDtos)) {
|
return;
|
}
|
|
String roomId = "";
|
String unitId = "";
|
List<UnitDto> unitDtos = null;
|
for (FloorDto floor : floorDtos) {
|
UnitDto unitDto = new UnitDto();
|
unitDto.setFloorId(floor.getFloorId());
|
unitDto.setUnitNum(reqJson.getString("unitNum"));
|
if (unitIds != null && unitIds.length > 0) {
|
unitDto.setUnitIds(unitIds);
|
}
|
unitDtos = unitInnerServiceSMOImpl.queryUnits(unitDto);
|
if (unitDtos == null || unitDtos.isEmpty()) {
|
continue;
|
}
|
for (UnitDto unit : unitDtos) {
|
RoomDto room = new RoomDto();
|
room.setUnitId(unit.getUnitId());
|
room.setRoomNum(reqJson.getString("roomNum"));
|
room.setCommunityId(reqJson.getString("communityId"));
|
List<RoomDto> roomDtos = roomInnerServiceSMOImpl.queryRooms(room);
|
if (roomDtos == null || roomDtos.isEmpty()) {
|
continue;
|
}
|
unitId = roomDtos.get(0).getUnitId();
|
roomId = roomDtos.get(0).getRoomId();
|
}
|
}
|
roomDto.setRoomId(roomId);
|
roomDto.setUnitId(unitId);
|
}
|
|
|
/**
|
* 刷入房屋业主信息
|
*
|
* @param roomDtos
|
*/
|
private void refreshRoomOwners(String userId, String communityId, List<RoomDto> roomDtos) {
|
|
/**
|
* 量太大时 查询 会比较慢，如果其他地方有bug 切换 查询报表去，不能靠这个接口查询大量数据
|
*/
|
if (roomDtos == null || roomDtos.size() > 20) {
|
return;
|
}
|
List<String> roomIds = new ArrayList<>();
|
for (RoomDto roomDto : roomDtos) {
|
roomIds.add(roomDto.getRoomId());
|
}
|
OwnerDto ownerDto = new OwnerDto();
|
ownerDto.setCommunityId(communityId);
|
ownerDto.setRoomIds(roomIds.toArray(new String[roomIds.size()]));
|
List<Map> mark = getPrivilegeOwnerList("/roomCreateFee", userId);
|
List<OwnerDto> ownerDtos = ownerInnerServiceSMOImpl.queryOwnersByRoom(ownerDto);
|
for (RoomDto roomDto : roomDtos) {
|
for (OwnerDto tmpOwnerDto : ownerDtos) {
|
if (!roomDto.getRoomId().equals(tmpOwnerDto.getRoomId())) {
|
continue;
|
}
|
try {
|
roomDto.setStartTime(DateUtil.getDateFromString(tmpOwnerDto.getStartTime(), DateUtil.DATE_FORMATE_STRING_A));
|
roomDto.setEndTime(DateUtil.getDateFromString(tmpOwnerDto.getEndTime(), DateUtil.DATE_FORMATE_STRING_A));
|
} catch (Exception e) {
|
//
|
}
|
roomDto.setOwnerId(tmpOwnerDto.getOwnerId());
|
roomDto.setOwnerName(tmpOwnerDto.getName());
|
//对业主身份证号隐藏处理
|
String idCard = tmpOwnerDto.getIdCard();
|
if (mark.size() == 0 && idCard != null && !idCard.equals("") && idCard.length() > 15) {
|
idCard = idCard.substring(0, 6) + "**********" + idCard.substring(16);
|
}
|
//对业主手机号隐藏处理
|
String link = tmpOwnerDto.getLink();
|
roomDto.setOwnerTel(link); //程序用 主要用以查询 报修等统计信息
|
if (mark.size() == 0 && link != null && !link.equals("") && link.length() > 10) {
|
link = link.substring(0, 3) + "****" + link.substring(7);
|
}
|
roomDto.setIdCard(idCard);
|
roomDto.setLink(link);
|
|
//商铺类型查询起租时间
|
// if (roomDto.getRoomType().equals(RoomDto.ROOM_TYPE_SHOPS)) {
|
// OwnerRoomRelDto ownerRoomRelDto = new OwnerRoomRelDto();
|
// ownerRoomRelDto.setRoomId(roomDto.getRoomId());
|
// ownerRoomRelDto.setStatusCd("0");
|
// List<OwnerRoomRelDto> ownerRoomRelDtoList = ownerRoomRelInnerServiceSMOImpl.queryOwnerRoomRels(ownerRoomRelDto);
|
// if (ownerRoomRelDtoList != null && ownerRoomRelDtoList.size() == 1) {
|
// roomDto.setStartTime(ownerRoomRelDtoList.get(0).getStartTime());
|
// roomDto.setEndTime(ownerRoomRelDtoList.get(0).getEndTime());
|
// }
|
// }
|
}
|
}
|
}
|
|
/**
|
* 脱敏处理
|
*
|
* @return
|
*/
|
public List<Map> getPrivilegeOwnerList(String resource, String userId) {
|
BasePrivilegeDto basePrivilegeDto = new BasePrivilegeDto();
|
basePrivilegeDto.setResource(resource);
|
basePrivilegeDto.setUserId(userId);
|
List<Map> privileges = menuInnerServiceSMOImpl.checkUserHasResource(basePrivilegeDto);
|
return privileges;
|
}
|
}
|
