|  |  |  | 
|---|
|  |  |  | package com.doumee.service.business.impl; | 
|---|
|  |  |  |  | 
|---|
|  |  |  | import com.doumee.core.constants.ResponseStatus; | 
|---|
|  |  |  | import com.doumee.core.exception.BusinessException; | 
|---|
|  |  |  | import com.doumee.core.model.LoginUserInfo; | 
|---|
|  |  |  | import com.doumee.core.model.PageData; | 
|---|
|  |  |  | import com.doumee.core.model.PageWrap; | 
|---|
|  |  |  | import com.doumee.core.utils.Constants; | 
|---|
|  |  |  | import com.doumee.core.utils.Utils; | 
|---|
|  |  |  | import com.doumee.dao.business.YwBuildingMapper; | 
|---|
|  |  |  | import com.doumee.dao.business.YwRoomMapper; | 
|---|
|  |  |  | import com.doumee.dao.business.model.YwBuilding; | 
|---|
|  |  |  | import com.doumee.dao.business.model.YwProject; | 
|---|
|  |  |  | import com.doumee.dao.business.model.YwRoom; | 
|---|
|  |  |  | import com.doumee.service.business.YwRoomService; | 
|---|
|  |  |  | 
|---|
|  |  |  | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; | 
|---|
|  |  |  | import com.baomidou.mybatisplus.core.metadata.IPage; | 
|---|
|  |  |  | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; | 
|---|
|  |  |  | import com.github.yulichang.wrapper.MPJLambdaWrapper; | 
|---|
|  |  |  | import org.springframework.beans.factory.annotation.Autowired; | 
|---|
|  |  |  | import org.springframework.stereotype.Service; | 
|---|
|  |  |  | import org.springframework.util.CollectionUtils; | 
|---|
|  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Autowired | 
|---|
|  |  |  | private YwRoomMapper ywRoomMapper; | 
|---|
|  |  |  | @Autowired | 
|---|
|  |  |  | private YwBuildingMapper ywBuildingMapper; | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | public Integer create(YwRoom model) { | 
|---|
|  |  |  | if(model.getBuildingId()==null){ | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的楼宇信息!"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | YwBuilding ywBuilding = ywBuildingMapper.selectById(model.getBuildingId()); | 
|---|
|  |  |  | if(ywBuilding ==null ||Constants.equalsInteger(ywBuilding.getIsdeleted(),Constants.ONE)){ | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的楼宇信息!"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | model.setProjectId(ywBuilding.getProjectId()); | 
|---|
|  |  |  | model.setCreator(model.getLoginUserInfo().getId()); | 
|---|
|  |  |  | model.setIsdeleted(Constants.ZERO); | 
|---|
|  |  |  | model.setCreateDate(new Date()); | 
|---|
|  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | public void updateById(YwRoom model) { | 
|---|
|  |  |  | if(model.getBuildingId()==null){ | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的楼宇信息!"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | YwBuilding ywBuilding = ywBuildingMapper.selectById(model.getBuildingId()); | 
|---|
|  |  |  | if(ywBuilding ==null ||Constants.equalsInteger(ywBuilding.getIsdeleted(),Constants.ONE)){ | 
|---|
|  |  |  | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起,请选择正确的楼宇信息!"); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | model.setProjectId(ywBuilding.getProjectId()); | 
|---|
|  |  |  | model.setEditDate(new Date()); | 
|---|
|  |  |  | model.setEditor(model.getLoginUserInfo().getId()); | 
|---|
|  |  |  | ywRoomMapper.updateById(model); | 
|---|
|  |  |  | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | public List<YwRoom> findList(YwRoom ywRoom) { | 
|---|
|  |  |  | QueryWrapper<YwRoom> wrapper = new QueryWrapper<>(ywRoom); | 
|---|
|  |  |  | ywRoom.setIsdeleted(Constants.ZERO); | 
|---|
|  |  |  | QueryWrapper<YwRoom> wrapper = new QueryWrapper< >(ywRoom); | 
|---|
|  |  |  | return ywRoomMapper.selectList(wrapper); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Override | 
|---|
|  |  |  | public PageData<YwRoom> findPage(PageWrap<YwRoom> pageWrap) { | 
|---|
|  |  |  | IPage<YwRoom> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); | 
|---|
|  |  |  | QueryWrapper<YwRoom> queryWrapper = new QueryWrapper<>(); | 
|---|
|  |  |  | MPJLambdaWrapper<YwRoom> queryWrapper = new MPJLambdaWrapper<>(); | 
|---|
|  |  |  | queryWrapper.selectAll(YwBuilding.class ) | 
|---|
|  |  |  | .selectAs(YwProject::getName,YwRoom::getProjectName) | 
|---|
|  |  |  | .selectAs(YwBuilding::getName,YwRoom::getBuildingName) | 
|---|
|  |  |  | .leftJoin(YwProject.class,YwProject::getId,YwRoom::getProjectId) | 
|---|
|  |  |  | .leftJoin(YwBuilding.class,YwBuilding::getId,YwRoom::getBuildingId); | 
|---|
|  |  |  | pageWrap.getModel().setIsdeleted(Constants.ZERO); | 
|---|
|  |  |  | Utils.MP.blankToNull(pageWrap.getModel()); | 
|---|
|  |  |  | if (pageWrap.getModel().getId() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getId, pageWrap.getModel().getId()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getId, pageWrap.getModel().getId()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getCreator() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getCreator, pageWrap.getModel().getCreator()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getCreator, pageWrap.getModel().getCreator()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getCreateDate() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().ge(YwRoom::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); | 
|---|
|  |  |  | queryWrapper.lambda().le(YwRoom::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); | 
|---|
|  |  |  | queryWrapper.ge(YwRoom::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); | 
|---|
|  |  |  | queryWrapper.le(YwRoom::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getEditor() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getEditor, pageWrap.getModel().getEditor()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getEditor, pageWrap.getModel().getEditor()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getEditDate() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().ge(YwRoom::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); | 
|---|
|  |  |  | queryWrapper.lambda().le(YwRoom::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); | 
|---|
|  |  |  | queryWrapper.ge(YwRoom::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); | 
|---|
|  |  |  | queryWrapper.le(YwRoom::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getIsdeleted() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getIsdeleted, pageWrap.getModel().getIsdeleted()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getIsdeleted, pageWrap.getModel().getIsdeleted()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getName() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getName, pageWrap.getModel().getName()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getName, pageWrap.getModel().getName()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getRemark() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getRemark, pageWrap.getModel().getRemark()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getRemark, pageWrap.getModel().getRemark()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getStatus() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getStatus, pageWrap.getModel().getStatus()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getStatus, pageWrap.getModel().getStatus()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getSortnum() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getSortnum, pageWrap.getModel().getSortnum()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getSortnum, pageWrap.getModel().getSortnum()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getImgurl() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getImgurl, pageWrap.getModel().getImgurl()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getImgurl, pageWrap.getModel().getImgurl()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getCode() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getCode, pageWrap.getModel().getCode()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getCode, pageWrap.getModel().getCode()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getRoomNum() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getRoomNum, pageWrap.getModel().getRoomNum()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getRoomNum, pageWrap.getModel().getRoomNum()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getIsInvestment() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getIsInvestment, pageWrap.getModel().getIsInvestment()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getIsInvestment, pageWrap.getModel().getIsInvestment()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getArea() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getArea, pageWrap.getModel().getArea()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getArea, pageWrap.getModel().getArea()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getFeeArea() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getFeeArea, pageWrap.getModel().getFeeArea()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getFeeArea, pageWrap.getModel().getFeeArea()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getRentArea() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getRentArea, pageWrap.getModel().getRentArea()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getRentArea, pageWrap.getModel().getRentArea()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getFloor() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getFloor, pageWrap.getModel().getFloor()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getFloor, pageWrap.getModel().getFloor()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getProjectId() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getProjectId, pageWrap.getModel().getProjectId()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getProjectId, pageWrap.getModel().getProjectId()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | if (pageWrap.getModel().getBuildingId() != null) { | 
|---|
|  |  |  | queryWrapper.lambda().eq(YwRoom::getBuildingId, pageWrap.getModel().getBuildingId()); | 
|---|
|  |  |  | queryWrapper.eq(YwRoom::getBuildingId, pageWrap.getModel().getBuildingId()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | for(PageWrap.SortData sortData: pageWrap.getSorts()) { | 
|---|
|  |  |  | if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) { | 
|---|
|  |  |  | queryWrapper.orderByDesc(sortData.getProperty()); | 
|---|
|  |  |  | } else { | 
|---|
|  |  |  | queryWrapper.orderByAsc(sortData.getProperty()); | 
|---|
|  |  |  | } | 
|---|
|  |  |  | } | 
|---|
|  |  |  | return PageData.from(ywRoomMapper.selectPage(page, queryWrapper)); | 
|---|
|  |  |  | queryWrapper.orderByAsc(YwRoom::getRoomNum); | 
|---|
|  |  |  | return PageData.from(ywRoomMapper.selectJoinPage(page,YwRoom.class, queryWrapper)); | 
|---|
|  |  |  | } | 
|---|
|  |  |  |  | 
|---|
|  |  |  | @Override | 
|---|