基于Java的尚庭公寓租赁平台设计源码

package com.atguigu.lease.web.admin.service.impl; import com.atguigu.lease.common.exception.LeaseException; import com.atguigu.lease.common.result.ResultCodeEnum; import com.atguigu.lease.model.entity.*; import com.atguigu.lease.model.enums.ItemType; import com.atguigu.lease.model.enums.LeaseStatus; import com.atguigu.lease.web.admin.mapper.RoomInfoMapper; import com.atguigu.lease.web.admin.service.*; import com.atguigu.lease.web.admin.vo.attr.AttrValueVo; import com.atguigu.lease.web.admin.vo.graph.GraphVo; import com.atguigu.lease.web.admin.vo.room.RoomDetailVo; import com.atguigu.lease.web.admin.vo.room.RoomItemVo; import com.atguigu.lease.web.admin.vo.room.RoomQueryVo; import com.atguigu.lease.web.admin.vo.room.RoomSubmitVo; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.context.annotation.Lazy; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import java.util.ArrayList; import java.util.List; import java.util.logging.Logger; /** * @author liubo * @description 针对表【room_info(房间信息表)】的数据库操作Service实现 * @createDate 2023-07-24 15:48:00 */ @Service public class RoomInfoServiceImpl extends ServiceImpl<RoomInfoMapper, RoomInfo> implements RoomInfoService { @Autowired private GraphInfoService graphInfoService; @Autowired private RoomAttrValueService roomAttrValueService; @Autowired private RoomFacilityService roomFacilityService; @Autowired private RoomLabelService roomLabelService; @Autowired private RoomPaymentTypeService roomPaymentTypeService; @Autowired private RoomLeaseTermService roomLeaseTermService; @Lazy @Autowired private LeaseAgreementService leaseAgreementService; @Autowired private RoomInfoMapper roomInfoMapper; @Lazy @Autowired private ApartmentInfoService apartmentInfoService; @Autowired private FacilityInfoService facilityInfoService; @Autowired private LabelInfoService labelInfoService; /** * @Description: 先看看lease_agreement里面有没有租约(租约状态是2 ， 5)，没有租约再删除房间 * @Param: [id] * @return: void * @Author: simonf * @Date: 2024/1/24 */ @Override public void customRemoveRoomById(Long id) { //先看看lease_agreement里面有没有租约(租约状态是2，5) // 1.看看房间里面有没有租约,(多表关联查询，根据传入的id查询Lease_Agreement表里的room_id) LambdaQueryWrapper<LeaseAgreement> leaseAgreementIfNull = new LambdaQueryWrapper<>(); leaseAgreementIfNull.eq(LeaseAgreement::getRoomId, id); Long count = leaseAgreementService.count(leaseAgreementIfNull); if (count > 0) { // 2.看看租约状态 LambdaQueryWrapper<LeaseAgreement> leaseAgreementQueryWrapper = new LambdaQueryWrapper<>(); leaseAgreementQueryWrapper.in(LeaseAgreement::getStatus, LeaseStatus.SIGNED,LeaseStatus.WITHDRAWING); List<LeaseAgreement> list = leaseAgreementService.list(leaseAgreementQueryWrapper); //3.如果租约还有且状态为(2,5)抛异常 System.out.println(list+"这是租约相关对象"); if (!list.isEmpty()) { throw new LeaseException(ResultCodeEnum.DELETE_ERROR); } } //1.删除RoomInfo super.removeById(id); //2.删除graphInfoList LambdaQueryWrapper<GraphInfo> graphQueryWrapper = new LambdaQueryWrapper<>(); graphQueryWrapper.eq(GraphInfo::getItemType, ItemType.ROOM); graphQueryWrapper.eq(GraphInfo::getItemId, id); graphInfoService.remove(graphQueryWrapper); //3.删除attrValueList LambdaQueryWrapper<RoomAttrValue> attrQueryWrapper = new LambdaQueryWrapper<>(); attrQueryWrapper.eq(RoomAttrValue::getRoomId, id); roomAttrValueService.remove(attrQueryWrapper); //4.删除facilityInfoList LambdaQueryWrapper<RoomFacility> facilityQueryWrapper = new LambdaQueryWrapper<>(); facilityQueryWrapper.eq(RoomFacility::getRoomId, id); roomFacilityService.remove(facilityQueryWrapper); //5.删除labelInfoList LambdaQueryWrapper<RoomLabel> labelQueryWrapper = new LambdaQueryWrapper<>(); labelQueryWrapper.eq(RoomLabel::getRoomId, id); roomLabelService.remove(labelQueryWrapper); //6.删除paymentTypeList LambdaQueryWrapper<RoomPaymentType> paymentQueryWrapper = new LambdaQueryWrapper<>(); paymentQueryWrapper.eq(RoomPaymentType::getRoomId, id); roomPaymentTypeService.remove(paymentQueryWrapper); //7.删除leaseTermList LambdaQueryWrapper<RoomLeaseTerm> termQueryWrapper = new LambdaQueryWrapper<>(); termQueryWrapper.eq(RoomLeaseTerm::getRoomId, id); roomLeaseTermService.remove(termQueryWrapper); } @Override public void saveOrUpdateRoom(RoomSubmitVo roomSubmitVo) { boolean isUpdate = roomSubmitVo.getId() != null; super.saveOrUpdate(roomSubmitVo); //若为更新操作，则先删除与Room相关的各项信息列表 if (isUpdate) { //1.删除原有graphInfoList LambdaQueryWrapper<GraphInfo> graphQueryWrapper = new LambdaQueryWrapper<>(); graphQueryWrapper.eq(GraphInfo::getItemType, ItemType.ROOM); graphQueryWrapper.eq(GraphInfo::getItemId, roomSubmitVo.getId()); graphInfoService.remove(graphQueryWrapper); //2.删除原有roomAttrValueList LambdaQueryWrapper<RoomAttrValue> attrQueryMapper = new LambdaQueryWrapper<>(); attrQueryMapper.eq(RoomAttrValue::getRoomId, roomSubmitVo.getId()); roomAttrValueService.remove(attrQueryMapper); //3.删除原有roomFacilityList LambdaQueryWrapper<RoomFacility> facilityQueryWrapper = new LambdaQueryWrapper<>(); facilityQueryWrapper.eq(RoomFacility::getRoomId, roomSubmitVo.getId()); roomFacilityService.remove(facilityQueryWrapper); //4.删除原有roomLabelList LambdaQueryWrapper<RoomLabel> labelQueryWrapper = new LambdaQueryWrapper<>(); labelQueryWrapper.eq(RoomLabel::getRoomId, roomSubmitVo.getId()); roomLabelService.remove(labelQueryWrapper); //5.删除原有paymentTypeList LambdaQueryWrapper<RoomPaymentType> paymentQueryWrapper = new LambdaQueryWrapper<>(); paymentQueryWrapper.eq(RoomPaymentType::getRoomId, roomSubmitVo.getId()); roomPaymentTypeService.remove(paymentQueryWrapper); //6.删除原有leaseTermList LambdaQueryWrapper<RoomLeaseTerm> termQueryWrapper = new LambdaQueryWrapper<>(); termQueryWrapper.eq(RoomLeaseTerm::getRoomId, roomSubmitVo.getId()); roomLeaseTermService.remove(termQueryWrapper); } //1.保存新的graphInfoList List<GraphVo> graphVoList = roomSubmitVo.getGraphVoList(); if (!CollectionUtils.isEmpty(graphVoList)) { ArrayList<GraphInfo> graphInfoList = new ArrayList<>(); for (GraphVo graphVo : graphVoList) { GraphInfo graphInfo = new GraphInfo(); graphInfo.setItemType(ItemType.ROOM); graphInfo.setItemId(roomSubmitVo.getId()); graphInfo.setName(graphVo.getName()); graphInfo.setUrl(graphVo.getUrl()); graphInfoList.add(graphInfo); } graphInfoService.saveBatch(graphInfoList); } //2.保存新的