package com.doumee.service.business.impl; import com.doumee.biz.system.SystemDictDataBiz; 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.DateCompare; import com.doumee.core.utils.DateUtil; import com.doumee.core.utils.Utils; import com.doumee.dao.business.*; import com.doumee.dao.business.dao.CompanyMapper; import com.doumee.dao.business.model.*; import com.doumee.dao.system.MultifileMapper; import com.doumee.dao.system.SystemUserMapper; import com.doumee.dao.system.model.Multifile; import com.doumee.dao.system.model.SystemUser; import com.doumee.service.business.YwContractService; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; 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.apache.commons.lang3.StringUtils; import org.checkerframework.checker.units.qual.C; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import java.math.BigDecimal; import java.time.temporal.ChronoUnit; import java.util.*; /** * 运维合同信息表Service实现 * @author 江蹄蹄 * @date 2024/11/19 16:07 */ @Service public class YwContractServiceImpl implements YwContractService { @Autowired private YwContractMapper ywContractMapper; @Autowired private YwContractDetailMapper ywContractDetailMapper; @Autowired private YwContractBillMapper ywContractBillMapper; @Autowired private MultifileMapper multifileMapper; @Autowired private YwWorkorderLogMapper ywWorkorderLogMapper; @Autowired private CompanyMapper companyMapper; @Autowired private YwProjectMapper projectMapper; @Autowired private YwRoomMapper roomMapper; @Autowired private SystemUserMapper systemUserMapper; @Autowired private YwCustomerMapper customerMapper; @Autowired private MemberMapper memberMapper; @Autowired private SystemDictDataBiz systemDictDataBiz; @Override @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public Integer create(YwContract model) { isParamValidCreated(model); model.setCreator(model.getLoginUserInfo().getId()); model.setIsdeleted(Constants.ZERO); model.setCreateDate(new Date()); model.setStatus(Constants.ZERO); model.setEditDate(model.getCreateDate()); model.setEditor(model.getCreator()); model.setStatus(Constants.ZERO);//待执行 model.setRemark(getRemarlByParam(model)); ywContractMapper.insert(model); dealDetailListBiz(model);//处理条款信息 dealMultifileBiz(model);//处理附件信息 dealLogBiz(model,Constants.YwLogType.CONTRACT_CREATE,null,null);//记录新建日志 return model.getId(); } private String getRemarlByParam(YwContract model) { String str = ""; YwContractDetail zl = model.getZlDetailList()!=null&&model.getZlDetailList().size()>0?model.getZlDetailList().get(0):null; YwContractDetail yw = model.getWyDetailList()!=null&&model.getWyDetailList().size()>0?model.getWyDetailList().get(0):null; //起租日2024/06/01，租赁数为500㎡。首期租赁三月一付，租金单价35元/㎡·月。首期物业三月一付，物业单价4.3元/㎡·月 String str0 = "合同摘要：起租日{param1}，租赁数为{param2}㎡。首期租赁{param3}，租金单价{param4}元{param5}。首期物业{param6}，物业单价{param7}{param8}"; String str1 = "合同摘要：起租日{param1}，租赁数为{param2}㎡。首期租赁{param3}，租金单价{param4}元{param5}。"; String str2 = "合同摘要：起租日{param1}，首期物业{param6}，物业单价{param7}元{param8}"; if(Constants.equalsInteger(model.getType(),Constants.ZERO)){ str= str0; } if(Constants.equalsInteger(model.getType(),Constants.ONE)){ str= str1; } if(Constants.equalsInteger(model.getType(),Constants.TWO)){ str= str2; } str = str.replace("{param1}",DateUtil.getDateLongSlash(model.getStartDate())) .replace("{param2}",model.getTotalArea().intValue()+"") .replace("{param3}",getPayTypeByNum(model.getZlPayType())) .replace("{param4}",zl!=null&&zl.getPrice()!=null?(zl.getPrice().intValue()+""):"0") .replace("{param5}",getPayTypeByNum(model.getWyPayType())) .replace("{param6}",getUnitTypeByNum(zl)) .replace("{param7}",zl!=null&&yw.getPrice()!=null?(zl.getPrice().intValue()+""):"0") .replace("{param8}",getUnitTypeByNum(yw)); return str; } private String getbackRentRemarkByParam(YwContract model) { BigDecimal fee = Constants.formatBigdecimal(model.getBtFee()); String str = "退租摘要：剩余未结清账单{param1}份，关闭账单{param2}份【退租日{param3}，退租费用合计需{param4}{param5}元。】"; str = str.replace("{param1}",model.getBtWaitBill()+"") .replace("{param2}",DateUtil.getDateLongSlash(model.getBtDate())) .replace("{param3}",fee.compareTo(new BigDecimal(0)) >=0?"收":"付") .replace("{param4}",(fee.compareTo(new BigDecimal(0)) >=0? Constants.formatBigdecimal(model.getBtFee()).intValue() :(Constants.formatBigdecimal(model.getBtFee()).intValue() * -1))+"" ); return str; } private CharSequence getUnitTypeByNum(YwContractDetail zl) { if(zl==null){ return ""; } // 付款周期类型 0=元每平米天；1=元每平米月；2=元每平米年；3=元每天；4=元每月；5=元每年；6=元每场； int zlPayType = Constants.formatIntegerNum(zl.getCircleType()); if(zlPayType == 1){ return "元/㎡·月"; }else if(zlPayType == 2){ return "元/㎡·天"; }else if(zlPayType == 3){ return "元/天"; }else if(zlPayType == 4){ return "元/月"; }else if(zlPayType == 5){ return "元/年"; }else if(zlPayType == 6){ return "元/场"; } return "元/㎡·天"; } private CharSequence getPayTypeByNum(Integer zlPayType) { //租赁支付方式 0=一次性付款；1=每三个月一付；2=六个月一付；3=一年一付 if(zlPayType == 1){ return "3个月一付"; }else if(zlPayType == 2){ return "6个月一付"; }else if(zlPayType == 3){ return "1年一付"; } return "一次性付款"; } /** * 退租提交 * @param param * @return */ @Override @Transactional(rollbackFor = {BusinessException.class,Exception.class}) public Integer backRent(YwContract param){ isParamValidBackRent(param); param.setEditDate(new Date()); param.setEditor(param.getLoginUserInfo().getId()); //处理 dealBackRentBillBiz(param); YwContract update = new YwContract(); update.setEditDate(new Date()); update.setEditor(param.getLoginUserInfo().getId()); update.setBtActDate(update.getEditDate()); update.setBtActUserId(update.getEditor()); update.setStatus(Constants.THREE); update.setBtInfo(param.getBtInfo()); update.setBtDate(param.getBtDate()); update.setBtType(param.getBtType()); update.setBtUserId(param.getBtUserId()); update.setBtFee(param.getBtFee()); update.setBtRemark(getbackRentRemarkByParam(param)); ywContractMapper.updateById(update); dealLogBiz(param,Constants.YwLogType.CONTRACT_BACK,null,null); return param.getId(); } private void dealBackRentBillBiz(YwContract param) { //查询合同全部账单信息 List closeBills = new ArrayList<>();//带关闭 List newBills = new ArrayList<>();//新的账单 List noBills = new ArrayList<>();//不需要结算的账单 List yjBills = new ArrayList<>();//押金账单 List canBills = new ArrayList<>();//可退租修改数据 List allBills = ywContractBillMapper.selectList(new QueryWrapper(). select("*," + "( select ifnull(sum(yw.ACT_RECEIVABLE_FEE),0) from yw_contract_revenue yw where yw.bill_id = yw_contract_bill.id and yw.status = 0 and yw.isdeleted = 0 ) as actReceivableFee " ) .lambda(). eq(YwContractBill::getIsdeleted,Constants.ZERO) .eq(YwContractBill::getContractId,param.getId())); if(allBills!=null && allBills.size()>0){ for(YwContractBill bill: allBills){ //付款状态：0=待收款；1=已结清；2=部分结清；3=待付款；4=待退款；5=已关闭 // 如果是押金或者保证金，不支持退款，保持原来的状态， 0=租赁费；1=物业费；2=租赁押金；3=物业押金；4=水电费；5=杂项费；6=其他;7=保证金 if(Constants.equalsInteger(Constants.THREE,bill.getCostType()) || Constants.equalsInteger(Constants.FOUR,bill.getCostType()) ||Constants.equalsInteger(Constants.SEVEN,bill.getCostType())){ //押金和保证金 yjBills.add(bill); continue; } if(Constants.equalsInteger(bill.getPayStatus(),Constants.ZERO) ||Constants.equalsInteger(bill.getPayStatus(),Constants.THREE)){ if(bill.getStartDate().getTime()>param.getEditDate().getTime()){ //如果还没开始，账单直接关闭 closeBills.add(bill); noBills.add(bill); }else{ canBills.add(bill); } }else if(Constants.equalsInteger(bill.getPayStatus(),Constants.ONE) ){ if(bill.getEndDate().getTime()0){ //直接关闭关闭账单 for(YwContractBill b : closeBills){ b.setStatus(Constants.ONE); b.setEditDate(param.getEditDate()); b.setEditor(param.getEditor()); //关闭订单 ywContractBillMapper.updateById(b); } } int yjNoBills =0; if(yjBills.size()>0){ // 如果是押金或者保证金，不支持退款，保持原来的状态， 0=租赁费；1=物业费；2=租赁押金；3=物业押金；4=水电费；5=杂项费；6=其他;7=保证金 for(YwContractBill bill : yjBills){ if(!Constants.equalsInteger(bill.getPayStatus(),Constants.ONE) ){ //如果是未结清押金 yjNoBills ++; } } } BigDecimal totalBackFee = new BigDecimal(0); if(canBills.size()>0){ //直接关闭关闭账单 for(YwContractBill b : canBills){ BigDecimal fee = new BigDecimal(0); YwContractBill editBill = getEditBillFromListByParam(b,param.getCanBackRentBills()); if(editBill != null){ //付款状态：0=待收款；1=已结清；2=部分结清；3=待付款；4=待退款；5=已关闭 //如果账单信息做了编辑，金额计算 实收金额 和 修改后应收金额作对比，判断是否应该退款 fee = Constants.formatBigdecimal(b.getActReceivableFee()).subtract(editBill.getReceivableFee()); if(fee.compareTo(new BigDecimal(0))== 0){ //如果费用正好，则修改账单信息为已结清 b.setStatus(Constants.ONE); }else if(fee.compareTo(new BigDecimal(0))> 0){ //如果需要进行退款，更新账单信息为待退款 b.setStatus(Constants.FOUR); }else if(fee.compareTo(new BigDecimal(0)) < 0){ //如果账单还有款待收，则保持状态不变 } } b.setEditDate(param.getEditDate()); b.setEditor(param.getEditor()); b.setBtActDate(param.getBtActDate()); b.setBtDate(param.getBtDate()); b.setBtFee(fee); b.setBtInfo(param.getBtInfo()); b.setBtUserId(param.getBtUserId()); b.setBtSignDate(param.getBtSignDate()); b.setBtType(param.getBtType()); //关闭订单 ywContractBillMapper.updateById(b); totalBackFee = totalBackFee.add(fee);//累计退款金额 } } if(param.getAddBillList()!=null && param.getAddBillList().size()>0){ for(YwContractBill addBill : param.getAddBillList()){ addBill.setIsdeleted(Constants.ZERO); addBill.setContractId(param.getId()); addBill.setType(Constants.ONE); addBill.setStatus(Constants.ZERO); if(Constants.equalsInteger(addBill.getBillType(),Constants.ZERO)){ //如果是收款 totalBackFee = totalBackFee.add(Constants.formatBigdecimal(addBill.getActReceivableFee())); addBill.setPayStatus(Constants.ZERO); addBill.setBtFee(Constants.formatBigdecimal(addBill.getActReceivableFee())); }else{ //如果是付款 addBill.setPayStatus(Constants.THREE); addBill.setBtFee(Constants.formatBigdecimal(addBill.getActReceivableFee()).multiply(new BigDecimal(-1))); } totalBackFee = totalBackFee.add(Constants.formatBigdecimal(addBill.getBtFee())); addBill.setEditDate(param.getEditDate()); addBill.setEditor(param.getEditor()); addBill.setBtActDate(param.getBtActDate()); addBill.setBtDate(param.getBtDate()); addBill.setBtInfo(param.getBtInfo()); addBill.setBtUserId(param.getBtUserId()); addBill.setBtSignDate(param.getBtSignDate()); addBill.setBtType(param.getBtType()); newBills.add(addBill); } ywContractBillMapper.insert(param.getAddBillList());//批量插入数据 } param.setBtWaitBill(canBills.size() + newBills.size()+yjNoBills);//未清算的账单数量 param.setBtCLoseBill(closeBills.size()); param.setBtFee(totalBackFee); } private YwContractBill getEditBillFromListByParam(YwContractBill b, List canBackRentBills) { for(YwContractBill d : canBackRentBills){ if(Constants.equalsInteger(b.getId(),d.getId())){ return d; } } return null; } private void isParamValidBackRent(YwContract param) { if(param.getId()==null || param.getBtType() == null || param.getBtDate() == null || param.getBtUserId() == null || param.getBtSignDate() == null ||StringUtils.isBlank( param.getBtInfo())){ throw new BusinessException(ResponseStatus.BAD_REQUEST); } YwContract model = ywContractMapper.selectById(param.getId()); if(model==null || Constants.equalsInteger(model.getIsdeleted(),Constants.ONE)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，合同信息不存在，请返回列表刷新重试！"); } SystemUser user = systemUserMapper.selectById(param.getUserId()); if(user ==null || (user.getDeleted()!=null&& user.getDeleted() )){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，经办人信息不存在！"); } if(param.getAddBillList()!=null && param.getAddBillList().size()>0){ for(YwContractBill bill: param.getAddBillList()){ if(bill.getCostType() == null ||bill.getFeeType() == null ||bill.getReceivableFee() == null ||bill.getReceivableFee().compareTo(new BigDecimal(0)) < 1 ||bill.getCompanyId() == null ||bill.getPlanPayDate() == null ||bill.getBillType() == null ||(Constants.equalsInteger(bill.getBillType(),Constants.ZERO) &&Constants.equalsInteger(bill.getFeeType(),Constants.ZERO) && (bill.getStartDate() ==null || bill.getEndDate() ==null) )){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请按要求填写自建账单信息！"); } } } } private void dealDetailListBiz(YwContract model) { List details = new ArrayList<>(); int num = 0; if(Constants.equalsInteger(model.getType(),Constants.ZERO ) || Constants.equalsInteger(model.getType(),Constants.ONE)){ for(YwContractDetail d :model.getZlDetailList()){ d.setCreateDate(model.getEditDate()); d.setCreator(model.getEditor()); d.setIsdeleted(Constants.ZERO); d.setContractId(model.getId()); d.setType(Constants.ZERO); d.setSortnum(num++); d.setStatus(Constants.ZERO); details.add(d); } } num = 0; if(Constants.equalsInteger(model.getType(),Constants.ZERO ) || Constants.equalsInteger(model.getType(),Constants.TWO)){ for(YwContractDetail d :model.getWyDetailList()){ d.setCreateDate(model.getEditDate()); d.setCreator(model.getEditor()); d.setIsdeleted(Constants.ZERO); d.setType(Constants.ONE); d.setContractId(model.getId()); d.setSortnum(num++); d.setStatus(Constants.ZERO); details.add(d); } } ywContractDetailMapper.insert(details);//批量插入条款信息信息 //处理账单信息 dealBillListBiz(model,details); } /** * 支付方式 0=一次性付款；1=每三个月一付；2=六个月一付；3=一年一付 * @param model * @param details */ private void dealBillListBiz(YwContract model, List details) { List billList = new ArrayList<>(); if(Constants.equalsInteger(model.getType(),Constants.ZERO ) || Constants.equalsInteger(model.getType(),Constants.ONE)){ //如果有租赁条款 if(Constants.formatBigdecimal(model.getZlDeposit()).compareTo(new BigDecimal(0))>0){ //如果有租赁押金 billList.add(initDepoistBill(Constants.THREE,model)); } if(Constants.equalsInteger(model.getZlPayType(), Constants.ZERO)){ //如果是一次性付清 billList.addAll(getBillsByParamOnce(model,details,model.getZlFreeStartDate(),model.getZlFreeEndDate())); }else if(Constants.equalsInteger(model.getZlPayType(), Constants.ONE)){ //如果每三个月一付 billList.addAll(getBillsByParam3Months(model,details,model.getZlFreeStartDate(),model.getZlFreeEndDate())); }else if(Constants.equalsInteger(model.getZlPayType(), Constants.TWO)){ //如果六个月一付 billList.addAll(getBillsByParam6Months(model,details,model.getZlFreeStartDate(),model.getZlFreeEndDate())); }else if(Constants.equalsInteger(model.getZlPayType(), Constants.THREE)){ //如果一年一付 billList.addAll(getBillsByParam1Year(model,details,model.getZlFreeStartDate(),model.getZlFreeEndDate())); } } if(Constants.equalsInteger(model.getType(),Constants.ZERO ) || Constants.equalsInteger(model.getType(),Constants.TWO)){ //如果物业条款 if(Constants.formatBigdecimal(model.getWyDeposit()).compareTo(new BigDecimal(0))>0){ //如果有租赁押金 billList.add(initDepoistBill(Constants.FOUR,model)); } if(Constants.equalsInteger(model.getWyPayType(), Constants.ZERO)){ //如果是一次性付清 billList.addAll(getBillsByParamOnce(model,details,model.getWyFreeStartDate(),model.getWyFreeEndDate())); }else if(Constants.equalsInteger(model.getWyPayType(), Constants.ONE)){ //如果每三个月一付 billList.addAll(getBillsByParam3Months(model,details,model.getWyFreeStartDate(),model.getWyFreeEndDate())); }else if(Constants.equalsInteger(model.getWyPayType(), Constants.TWO)){ //如果六个月一付 billList.addAll(getBillsByParam6Months(model,details,model.getWyFreeStartDate(),model.getWyFreeEndDate())); }else if(Constants.equalsInteger(model.getWyPayType(), Constants.THREE)){ //如果一年一付 billList.addAll(getBillsByParam1Year(model,details,model.getWyFreeStartDate(),model.getWyFreeEndDate())); } } for(int i=0;i getBillsByParam6Months(YwContract model, List details, Date freeStart, Date freeEnd) { List list = new ArrayList<>(); for(YwContractDetail d : details){ List dateList = getCircleDatesBy6Month(d.getStartDate(),d.getEndDate()); if(dateList.size() ==0){ continue; } dealCircleDateBillBiz(dateList,model,d,freeStart,freeEnd,list); } return list; } /** * 如果3个月一付 * 付款周期类型 0=元每平米天；1=元每平米月；2=元每平米年；3=元每天；4=元每月；5=元每年；6=元每场；" * @param model * @param details * @return */ private Collection getBillsByParam3Months(YwContract model, List details, Date freeStart, Date freeEnd) { List list = new ArrayList<>(); for(YwContractDetail d : details){ List dateList = getCircleDatesBy3Month(d.getStartDate(),d.getEndDate()); if(dateList.size() ==0){ continue; } dealCircleDateBillBiz(dateList,model,d,freeStart,freeEnd,list); } return list; } private List getCircleDatesBy6Month(Date startDate, Date endDate) { DateCompare dateCompare = DateCompare.monthYearCompare(startDate, endDate ); int months = dateCompare.getMonth(); int monthSix = months / 6;//6个月维度数量 int restMonth = months % 6;//剩余的整月 int monthDays = dateCompare.getMonthDays();//不满一个月的天数 Date date = new Date(); List list = new ArrayList<>(); for (int i = 0; i < monthSix; i++) { list.add(DateUtil.addMonthToDate(date,i*6)); } if(restMonth>0 || monthDays>0){ list.add(DateUtil.addDaysToDate(date,monthSix)); } return list; } private List getCircleDatesBy3Month(Date startDate, Date endDate) { DateCompare dateCompare = DateCompare.monthYearCompare(startDate, endDate ); int months = dateCompare.getMonth(); int monthThree = months / 3;//3个月维度数量 int restMonth = months % 3;//剩余的整月 int monthDays = dateCompare.getMonthDays();//不满一个月的天数 Date date = new Date(); List list = new ArrayList<>(); for (int i = 0; i < monthThree; i++) { list.add(DateUtil.addMonthToDate(date,i*3)); } if(restMonth>0 || monthDays>0){ list.add(DateUtil.addDaysToDate(date,monthThree)); } return list; } /** * 如果一年一付 * 付款周期类型 0=元每平米天；1=元每平米月；2=元每平米年；3=元每天；4=元每月；5=元每年；6=元每场；" * @param model * @param details * @return */ private List getBillsByParam1Year(YwContract model, List details,Date freeStart,Date freeEnd) { List list = new ArrayList<>(); for(YwContractDetail d : details){ List dateList = getCircleDatesByYear(d.getStartDate(),d.getEndDate()); if(dateList.size() ==0){ continue; } dealCircleDateBillBiz(dateList,model,d,freeStart,freeEnd,list); } return list; } private void dealCircleDateBillBiz( List dateList ,YwContract model, YwContractDetail d, Date freeStart, Date freeEnd, List list ) { for(Date start : dateList){ Date end = DateUtil.addDaysToDate(DateUtil.addYearToDate(start,1),-1);//结束日期为下一个周期的前一天 if(end.getTime()> d.getEndDate().getTime() ){ end = d.getEndDate(); } YwContractBill bill = initCreateBillModel(model,d ); bill.setStartDate(start);//账单开始 bill.setEndDate(end);//账单结束 bill.setPlanPayDate(DateUtil.addDaysToDate(d.getStartDate(),Constants.formatIntegerNum(d.getAdvanceDays()) * -1)); BigDecimal totalFee =getTotalFeeByStartEnd(model,d,freeStart,freeEnd); bill.setTotleFee(totalFee); list.add(bill); } } private BigDecimal getTotalFeeByStartEnd(YwContract model, YwContractDetail d,Date freeStart,Date freeEnd) { BigDecimal totalFee = new BigDecimal(0); DateCompare dateCompare = DateCompare.dayCompare(d.getStartDate(),d.getEndDate(),freeStart,freeEnd); if(Constants.equalsInteger(d.getCircleType(),Constants.ZERO)){ //0=元每平米天 int days = dateCompare.getDay(); BigDecimal areas = getAreasNumBYRooms(model.getRoomList()); totalFee = new BigDecimal(days).multiply(areas).multiply(Constants.formatBigdecimal(d.getPrice()));//总价格 }else if(Constants.equalsInteger(d.getCircleType(),Constants.ONE)){ //1=元每平米月 BigDecimal areas = getAreasNumBYRooms(model.getRoomList()); BigDecimal month =dateCompare.getMonthFloat(); totalFee = month.multiply(areas).multiply(Constants.formatBigdecimal(d.getPrice()));//总价格 }else if(Constants.equalsInteger(d.getCircleType(),Constants.TWO)){ //2=元每平米年 BigDecimal areas = getAreasNumBYRooms(model.getRoomList()); BigDecimal year = dateCompare.getYearFloat(); totalFee = year.multiply(areas).multiply(Constants.formatBigdecimal(d.getPrice()));//总价格 }else if(Constants.equalsInteger(d.getCircleType(),Constants.THREE)){ //3=元每天 int days = dateCompare.getDay(); totalFee = new BigDecimal(days).multiply(Constants.formatBigdecimal(d.getPrice()));//总价格 }else if(Constants.equalsInteger(d.getCircleType(),Constants.FOUR)){ //4=元每月 BigDecimal month = dateCompare.getMonthFloat(); totalFee = month.multiply(Constants.formatBigdecimal(d.getPrice()));//总价格 }else if(Constants.equalsInteger(d.getCircleType(),Constants.FIVE)){ //5=元每年 BigDecimal year = dateCompare.getYearFloat(); totalFee = year.multiply(Constants.formatBigdecimal(d.getPrice()));//总价格 }else if(Constants.equalsInteger(d.getCircleType(),Constants.SIX)){ //6=元每场 totalFee =Constants.formatBigdecimal(d.getPrice()); } if(Constants.equalsInteger(model.getRoundedUp(),Constants.ONE)){ //如果强制取整 totalFee = Constants.formatBigdecimal0Float(totalFee); }else{ //四舍五入两位小数 totalFee = Constants.formatBigdecimal2Float(totalFee); } return totalFee; } private List getCircleDatesByYear(Date startDate, Date endDate ) { DateCompare dateCompare = DateCompare.monthYearCompare(startDate, endDate ); int years = dateCompare.getYear(); int yeardays = dateCompare.getYearDays(); Date date = new Date(); List list = new ArrayList<>(); for (int i = 0; i < years; i++) { list.add(DateUtil.addYearToDate(date,i)); } if(yeardays>0){ list.add(DateUtil.addYearToDate(date,years)); } return list; } /** * 一次性付款账单 * 付款周期类型 0=元每平米天；1=元每平米月；2=元每平米年；3=元每天；4=元每月；5=元每年；6=元每场；" * @param model * @param details * @return */ private List getBillsByParamOnce(YwContract model, List details,Date freeStart,Date freeEnd) { List list = new ArrayList<>(); for(YwContractDetail d : details){ YwContractBill bill = initCreateBillModel(model,d); bill.setStartDate(d.getStartDate());//账单开始 bill.setEndDate(d.getEndDate());//账单结束 bill.setPlanPayDate(DateUtil.addDaysToDate(d.getStartDate(),Constants.formatIntegerNum(d.getAdvanceDays()) * -1)); bill.setTotleFee(getTotalFeeByStartEnd(model,d,freeStart,freeEnd)); list.add(bill); } return list; } private YwContractBill initCreateBillModel(YwContract model,YwContractDetail d) { YwContractBill bill = new YwContractBill(); bill.setCreateDate(model.getEditDate()); bill.setCreator(model.getEditor()); bill.setEditDate(model.getEditDate()); bill.setEditor(model.getEditor()); bill.setIsdeleted(Constants.ZERO); bill.setContractId(model.getId()); bill.setStatus(Constants.ZERO); bill.setDetailId(d.getId()); bill.setCostType(d.getType()); bill.setType(Constants.ZERO); return bill; } private BigDecimal getAreasNumBYRooms(List roomList) { BigDecimal data= new BigDecimal(0); for(YwRoom r :roomList){ data = data.add(Constants.formatBigdecimal(r.getArea())); } return data; } private void initFiles(YwContract model) { List multifiles = multifileMapper.selectList(new QueryWrapper().lambda() .eq(Multifile::getObjId, model.getId() ) .in(Multifile::getObjType, Arrays.asList(new Integer[]{Constants.MultiFile.YW_CONTRACT_FILE.getKey()})) .eq(Multifile::getIsdeleted,Constants.ZERO)); if(multifiles!=null){ String path = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +systemDictDataBiz.queryByCode(Constants.FTP,Constants.YW_CONTRACT_FILE).getCode(); for(Multifile f : multifiles){ if(StringUtils.isBlank(f.getFileurl())){ continue; } f.setFileurlFull(path+f.getFileurl()); //现场情况 if(model.getFileList() == null){ model.setFileList(new ArrayList<>()); } model.getFileList().add(f); } } } private void dealMultifileBiz(YwContract model) { List fileList = new ArrayList<>(); if(model.getFileList()!=null && model.getFileList().size()>0){ for (int i = 0; i < model.getFileList().size(); i++) { Multifile multifile = model.getFileList().get(i); if(StringUtils.isBlank(multifile.getFileurl())){ continue; } multifile.setCreateDate(model.getEditDate()); multifile.setCreator(model.getEditor()); multifile.setIsdeleted(Constants.ZERO); multifile.setObjId(model.getId()); multifile.setCreator(model.getCreator()); multifile.setObjType(Constants.MultiFile.YW_CONTRACT_FILE.getKey()); multifile.setSortnum(i+1); fileList.add(multifile); } } if(fileList.size()>0){ multifileMapper.insert(fileList); } } private void isParamValidCreated(YwContract model) { if(model.getType()==null || model.getType()>2 || model.getType()<0 ||model.getUserId() == null ||model.getStartDate() == null ||model.getEndDate() == null ||model.getSignDate() == null ||model.getProjectId() == null ||model.getCompanyId() == null ||model.getRoundedUp() == null ||model.getRenterId() == null ||model.getMemberId() == null ||model.getRoomIds() == null ||model.getRoomIds().size() == 0 ){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请按页面要求填写合同信息"); } if(model.getEndDate().getTime()<= model.getStartDate().getTime()){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，合同有效期结束时间不得早于开始时间！"); } if(Constants.equalsInteger(model.getType(),Constants.ZERO ) || Constants.equalsInteger(model.getType(),Constants.ONE)){ if( model.getZlDeposit() == null ||model.getZlPayType() == null || model.getZlPayType()>3 || model.getZlPayType()<0 ||model.getZlDetailList()==null ||model.getZlDetailList().size() ==0){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请按页面要求填写租赁条款信息"); } if(!(model.getZlFreeEndDate()==null && model.getZlFreeStartDate()==null) && ( (model.getZlFreeEndDate()!=null && model.getZlFreeStartDate()==null) ||(model.getZlFreeEndDate()==null && model.getZlFreeStartDate()!=null) ||model.getZlFreeEndDate().getTime()<= model.getZlFreeStartDate().getTime()) ){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请选择正确的租赁条款免租期信息！"); } for(YwContractDetail d :model.getZlDetailList()){ if( d.getStartDate() == null ||d.getEndDate() == null ||d.getPrice() == null ||d.getCircleType() == null || d.getCircleType()>6 || d.getCircleType()<0 ){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请按页面要求填写租赁条款信息!"); } if(d.getEndDate().getTime()<= d.getStartDate().getTime()){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，租赁条款有效期结束时间不得早于开始时间！"); } if(!Constants.equalsInteger(model.getWyPayType(),Constants.ZERO) && Constants.equalsInteger(d.getCircleType(),Constants.SIX)){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，租赁条款只有选择一次性付款时，才能选择该按每场收费；"); } } } if(Constants.equalsInteger(model.getType(),Constants.ZERO ) || Constants.equalsInteger(model.getType(),Constants.TWO)){ if( model.getWyDeposit() == null ||model.getWyPayType() == null || model.getWyPayType()>3 || model.getWyPayType()<0 ||model.getWyDetailList()==null ||model.getWyDetailList().size() ==0 ){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请按页面要求填写物业条款信息"); } if(!(model.getWyFreeEndDate()==null && model.getWyFreeStartDate()==null) && ( (model.getWyFreeEndDate()!=null && model.getWyFreeStartDate()==null) ||(model.getWyFreeEndDate()==null && model.getWyFreeStartDate()!=null) ||model.getWyFreeEndDate().getTime()<= model.getWyFreeStartDate().getTime())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请选择正确的物业条款免租期信息！"); } for(YwContractDetail d :model.getWyDetailList()){ if( d.getStartDate() == null ||d.getEditDate() == null ||d.getPrice() == null ||d.getCircleType() == null || d.getCircleType()>6 || d.getCircleType()<0 ){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请按页面要求填写物业条款信息!"); } if(d.getEndDate().getTime()<= d.getStartDate().getTime()){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，物业条款有效期结束时间不得早于开始时间！"); } if(!Constants.equalsInteger(model.getWyPayType(),Constants.ZERO) && Constants.equalsInteger(d.getCircleType(),Constants.SIX)){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，物业条款只有选择一次性付款时，才能选择该按每场收费；"); } } } YwProject project = projectMapper.selectById(model.getCompanyId()); if(project ==null || Constants.equalsInteger(project.getIsdeleted(),Constants.ONE)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，请选择正确的项目信息！"); } List rooms = roomMapper.selectList(new QueryWrapper().lambda() .eq(YwRoom::getIsdeleted,Constants.ZERO) .in(YwRoom::getId,model.getRoomIds()) .eq(YwRoom::getProjectId,model.getProjectId()) ); if(rooms ==null || rooms.size()==0){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，请选择对应项目下正确的房源信息"); } if(rooms.size() != rooms.size()){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"对不起，存在无效的房源信息！"); } model.setTotalArea(new BigDecimal(0)); for(YwRoom r : rooms){ model.setTotalArea(model.getTotalArea().add(Constants.formatBigdecimal(r.getArea()))); } YwCustomer customer = customerMapper.selectById(model.getRenterId()); if(customer ==null || Constants.equalsInteger(customer.getIsdeleted(),Constants.ONE)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，选择租客信息不存在，请返回刷新重试！"); } Member member = memberMapper.selectOne(new QueryWrapper().lambda() .eq(Member::getIsdeleted,Constants.ZERO) .eq(Member::getType,Constants.THREE) .eq(Member::getCustomerId,model.getRenterId()) .eq(Member::getId,model.getMemberId()) .last("limit 1")); if(member ==null ){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，选择租客联系人信息不存在，请返回刷新重试！"); } Company company = companyMapper.selectById(model.getCompanyId()); if(company ==null || Constants.equalsInteger(company.getIsdeleted(),Constants.ONE) || !Constants.equalsInteger(company.getType(),Constants.TWO)){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，请选择正确的公司信息！"); } SystemUser user = systemUserMapper.selectById(model.getUserId()); if(user ==null || (user.getDeleted()!=null && user.getDeleted()) ){ throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"对不起，经办人信息不存在，请尝试刷新页面重试！"); } } @Override public void deleteById(Integer id, LoginUserInfo user) { ywContractMapper.deleteById(id); } @Override public void delete(YwContract ywContract) { UpdateWrapper deleteWrapper = new UpdateWrapper<>(ywContract); ywContractMapper.delete(deleteWrapper); } @Override public void deleteByIdInBatch(List ids, LoginUserInfo user) { if (CollectionUtils.isEmpty(ids)) { return; } ywContractMapper.deleteBatchIds(ids); } @Override public void updateById(YwContract ywContract) { ywContractMapper.updateById(ywContract); } @Override public void updateByIdInBatch(List ywContracts) { if (CollectionUtils.isEmpty(ywContracts)) { return; } for (YwContract ywContract: ywContracts) { this.updateById(ywContract); } } private void dealLogBiz(YwContract model,Constants.YwLogType type,String param1,String param2) { YwWorkorderLog log = new YwWorkorderLog(); log.setCreateDate(model.getEditDate()); log.setCreator(model.getCreator()); log.setJobId(model.getId()); log.setIsdeleted(Constants.ZERO); log.setObjId(model.getId()+""); log.setObjType(type.getKey()); log.setParam1(param1); log.setParam2(param2); log.setTitle(type.getNoteinfo()); ywWorkorderLogMapper.insert(log); } @Override public YwContract findById(Integer id) { MPJLambdaWrapper queryWrapper = new MPJLambdaWrapper<>(); queryWrapper.selectAll(YwContract.class ) .selectAs(Company::getName,YwContract::getCompanyName ) .selectAs(SystemUser::getRealname,YwContract::getUserName ) .selectAs(YwCustomer::getName,YwContract::getRenterName ) .selectAs(YwProject::getName,YwContract::getProjectName ) .select("t4.realname",YwContract::getCreatorName ) .leftJoin(Company.class,Company::getId,YwContract::getCompanyId) .leftJoin(SystemUser.class,SystemUser::getId,YwContract::getUserId) .leftJoin(SystemUser.class,SystemUser::getId,YwContract::getCreator) .leftJoin(YwProject.class,YwProject::getId,YwContract::getProjectId) .leftJoin(YwCustomer.class,YwCustomer::getId,YwContract::getRenterId); YwContract model = ywContractMapper.selectJoinOne(YwContract.class,queryWrapper); if(model != null){ //合同附件 initFiles(model); //查询房源信息数据 MPJLambdaWrapper rw = new MPJLambdaWrapper<>(); rw.selectAll(YwRoom.class ) .selectAs(YwProject::getName,YwRoom::getProjectName) .selectAs(YwFloor::getName,YwRoom::getFloorName) .selectAs(YwBuilding::getName,YwRoom::getBuildingName) .leftJoin(YwProject.class,YwProject::getId,YwRoom::getProjectId) .leftJoin(YwBuilding.class,YwBuilding::getId,YwRoom::getBuildingId) .leftJoin(YwFloor.class,YwFloor::getId,YwRoom::getFloor) .eq(YwRoom::getIsdeleted,Constants.ZERO) .exists("(select a.id from yw_contract_room a where a.isdeleted=1 and a.room_id=t.id and a.contract_id="+model.getId()+")"); model.setRoomList(roomMapper.selectJoinList(YwRoom.class,rw)); //查询租賃条款信息 MPJLambdaWrapper dw = new MPJLambdaWrapper<>(); dw.selectAll(YwContractDetail.class ) .eq(YwContractDetail::getIsdeleted,Constants.ZERO) .eq(YwContractDetail::getContractId,model.getId()) .in(YwContractDetail::getType,Constants.ZERO,Constants.TWO) .orderByAsc(YwContractDetail::getSortnum); model.setZlDetailList(ywContractDetailMapper.selectJoinList(YwContractDetail.class,dw)); //查询物業条款信息 dw = new MPJLambdaWrapper<>(); dw.selectAll(YwContractDetail.class ) .eq(YwContractDetail::getIsdeleted,Constants.ZERO) .eq(YwContractDetail::getContractId,model.getId()) .in(YwContractDetail::getType,Constants.ONE,Constants.THREE) .orderByAsc(YwContractDetail::getSortnum); model.setWyDetailList(ywContractDetailMapper.selectJoinList(YwContractDetail.class,dw)); //查询操作日志记录 YwWorkorderLog log = new YwWorkorderLog(); log.setJobId(model.getId()); log.setIsdeleted(Constants.ZERO); model.setLogList(ywWorkorderLogMapper.selectList(new QueryWrapper(log) .lambda() .in(YwWorkorderLog::getObjType,Constants.YwLogType.CONTRACT_BACK.getKey() ,Constants.YwLogType.CONTRACT_CREATE.getKey() ,Constants.YwLogType.CONTRACT_UPDATE.getKey()) .orderByAsc(YwWorkorderLog::getCreateDate))); //查询账单集合 model.setBillList(ywContractBillMapper.selectJoinList(YwContractBill.class,new MPJLambdaWrapper() .selectAll(YwContractBill.class ) .eq( YwContractBill::getContractId,model.getId()) .eq(YwContractBill::getIsdeleted,Constants.ZERO) .orderByAsc(YwContractBill::getSortnum,YwContractBill::getCreateDate))); model.setCanBackRentBills(new ArrayList<>()); long nowStart = Utils.Date.getStart(new Date()).getTime(); long nowEnd = Utils.Date.getEnd(new Date()).getTime(); if(model.getBillList()!=null && model.getBillList().size()>0){ for(YwContractBill bill: model.getBillList()){ //付款状态：0=待收款；1=已结清；2=部分结清；3=待付款；4=待退款；5=已关闭 if(Constants.equalsInteger(bill.getPayStatus(),Constants.ZERO) ||Constants.equalsInteger(bill.getPayStatus(),Constants.THREE)){ if(bill.getStartDate().getTime()>nowEnd){ //如果还没开始，账单直接关闭 continue; } model.getCanBackRentBills().add(bill); }else if(Constants.equalsInteger(bill.getPayStatus(),Constants.ONE) ){ if(bill.getEndDate().getTime() wrapper = new QueryWrapper<>(ywContract); return ywContractMapper.selectOne(wrapper); } @Override public List findList(YwContract ywContract) { QueryWrapper wrapper = new QueryWrapper<>(ywContract); return ywContractMapper.selectList(wrapper); } @Override public PageData findPage(PageWrap pageWrap) { IPage page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper queryWrapper = new MPJLambdaWrapper<>(); queryWrapper.selectAll(YwContract.class ) .selectAs(Company::getName,YwContract::getCompanyName ) .select("(select sum(r.area) from yw_contract_room cr left join yw_room r on r.id = cr.room_id where r.isdeleted=0 and cr.contract_id =t.id)",YwContract::getTotalArea ) .leftJoin(Company.class,Company::getId,YwContract::getCompanyId); Utils.MP.blankToNull(pageWrap.getModel()); if (pageWrap.getModel().getId() != null) { queryWrapper.eq(YwContract::getId, pageWrap.getModel().getId()); } if (pageWrap.getModel().getCreator() != null) { queryWrapper.eq(YwContract::getCreator, pageWrap.getModel().getCreator()); } if (pageWrap.getModel().getCreateDate() != null) { queryWrapper.ge(YwContract::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate())); queryWrapper.le(YwContract::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate())); } if (pageWrap.getModel().getEditor() != null) { queryWrapper.eq(YwContract::getEditor, pageWrap.getModel().getEditor()); } if (pageWrap.getModel().getEditDate() != null) { queryWrapper.ge(YwContract::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate())); queryWrapper.le(YwContract::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate())); } if (pageWrap.getModel().getIsdeleted() != null) { queryWrapper.eq(YwContract::getIsdeleted, pageWrap.getModel().getIsdeleted()); } if (pageWrap.getModel().getRemark() != null) { queryWrapper.eq(YwContract::getRemark, pageWrap.getModel().getRemark()); } if (pageWrap.getModel().getStatus() != null) { queryWrapper.eq(YwContract::getStatus, pageWrap.getModel().getStatus()); } if (pageWrap.getModel().getType() != null) { queryWrapper.eq(YwContract::getType, pageWrap.getModel().getType()); } if (pageWrap.getModel().getCode() != null) { queryWrapper.eq(YwContract::getCode, pageWrap.getModel().getCode()); } if (pageWrap.getModel().getUserId() != null) { queryWrapper.eq(YwContract::getUserId, pageWrap.getModel().getUserId()); } if (pageWrap.getModel().getSignDate() != null) { queryWrapper.ge(YwContract::getSignDate, Utils.Date.getStart(pageWrap.getModel().getSignDate())); queryWrapper.le(YwContract::getSignDate, Utils.Date.getEnd(pageWrap.getModel().getSignDate())); } if (pageWrap.getModel().getStartDate() != null) { queryWrapper.ge(YwContract::getStartDate, Utils.Date.getStart(pageWrap.getModel().getStartDate())); queryWrapper.le(YwContract::getStartDate, Utils.Date.getEnd(pageWrap.getModel().getStartDate())); } if (pageWrap.getModel().getEndDate() != null) { queryWrapper.ge(YwContract::getEndDate, Utils.Date.getStart(pageWrap.getModel().getEndDate())); queryWrapper.le(YwContract::getEndDate, Utils.Date.getEnd(pageWrap.getModel().getEndDate())); } if (pageWrap.getModel().getProjectId() != null) { queryWrapper.eq(YwContract::getProjectId, pageWrap.getModel().getProjectId()); } if (pageWrap.getModel().getRoundedUp() != null) { queryWrapper.eq(YwContract::getRoundedUp, pageWrap.getModel().getRoundedUp()); } if (pageWrap.getModel().getCompanyId() != null) { queryWrapper.eq(YwContract::getCompanyId, pageWrap.getModel().getCompanyId()); } if (pageWrap.getModel().getRenterId() != null) { queryWrapper.eq(YwContract::getRenterId, pageWrap.getModel().getRenterId()); } if (pageWrap.getModel().getMemberId() != null) { queryWrapper.eq(YwContract::getMemberId, pageWrap.getModel().getMemberId()); } if (pageWrap.getModel().getZlDeposit() != null) { queryWrapper.eq(YwContract::getZlDeposit, pageWrap.getModel().getZlDeposit()); } if (pageWrap.getModel().getZlPayType() != null) { queryWrapper.eq(YwContract::getZlPayType, pageWrap.getModel().getZlPayType()); } if (pageWrap.getModel().getZlFreeStartDate() != null) { queryWrapper.ge(YwContract::getZlFreeStartDate, Utils.Date.getStart(pageWrap.getModel().getZlFreeStartDate())); queryWrapper.le(YwContract::getZlFreeStartDate, Utils.Date.getEnd(pageWrap.getModel().getZlFreeStartDate())); } if (pageWrap.getModel().getZlFreeEndDate() != null) { queryWrapper.ge(YwContract::getZlFreeEndDate, Utils.Date.getStart(pageWrap.getModel().getZlFreeEndDate())); queryWrapper.le(YwContract::getZlFreeEndDate, Utils.Date.getEnd(pageWrap.getModel().getZlFreeEndDate())); } if (pageWrap.getModel().getWyDeposit() != null) { queryWrapper.eq(YwContract::getWyDeposit, pageWrap.getModel().getWyDeposit()); } if (pageWrap.getModel().getWyPayType() != null) { queryWrapper.eq(YwContract::getWyPayType, pageWrap.getModel().getWyPayType()); } if (pageWrap.getModel().getWyFreeStartDate() != null) { queryWrapper.ge(YwContract::getWyFreeStartDate, Utils.Date.getStart(pageWrap.getModel().getWyFreeStartDate())); queryWrapper.le(YwContract::getWyFreeStartDate, Utils.Date.getEnd(pageWrap.getModel().getWyFreeStartDate())); } if (pageWrap.getModel().getWyFreeEndDate() != null) { queryWrapper.ge(YwContract::getWyFreeEndDate, Utils.Date.getStart(pageWrap.getModel().getWyFreeEndDate())); queryWrapper.le(YwContract::getWyFreeEndDate, Utils.Date.getEnd(pageWrap.getModel().getWyFreeEndDate())); } if (pageWrap.getModel().getZlTotalFee() != null) { queryWrapper.eq(YwContract::getZlTotalFee, pageWrap.getModel().getZlTotalFee()); } if (pageWrap.getModel().getWyTotalFee() != null) { queryWrapper.eq(YwContract::getWyTotalFee, pageWrap.getModel().getWyTotalFee()); } if (pageWrap.getModel().getCompanyName() != null) { queryWrapper.like(Company::getName, pageWrap.getModel().getCompanyName()); } queryWrapper.ge(Objects.nonNull(pageWrap.getModel().getQueryStartTime()), YwContract::getStartDate, pageWrap.getModel().getQueryStartTime()) .le(Objects.nonNull(pageWrap.getModel().getQueryEndTime()), YwContract::getEndDate, pageWrap.getModel().getQueryEndTime()); queryWrapper.orderByDesc(YwContract::getCreateDate ); return PageData.from(ywContractMapper.selectJoinPage(page, YwContract.class,queryWrapper)); } @Override public long count(YwContract ywContract) { QueryWrapper wrapper = new QueryWrapper<>(ywContract); return ywContractMapper.selectCount(wrapper); } }