Merge branch 'master' of http://139.186.142.91:10010/r/productDev/funingyunwei
| | |
| | | datasource: |
| | | url: jdbc:mysql://localhost:3306/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai |
| | | username: root |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | | driver-class-name: com.mysql.cj.jdbc.Driver |
| | | type: com.alibaba.druid.pool.DruidDataSource |
| | | |
| | |
| | | nacos: |
| | | server-addr: http://localhost:8848 #配置Nacos地址 |
| | | username: nacos |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | | discovery: |
| | | server-addr: http://localhost:8848 #配置Nacos地址 |
| | | namespace: dmvisit |
| | | # namespace: dev_renkang |
| | | username: nacos |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | | gateway: |
| | | discovery: |
| | | locator: |
| | |
| | | spring: |
| | | profiles: |
| | | active: dev |
| | | active: test |
| | | application: |
| | | name: system_gateway |
| | | # 安全配置 |
| | |
| | | datasource: |
| | | url: jdbc:mysql://localhost:3306/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai |
| | | username: root |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | | driver-class-name: com.mysql.cj.jdbc.Driver |
| | | type: com.alibaba.druid.pool.DruidDataSource |
| | | |
| | |
| | | nacos: |
| | | server-addr: http://localhost:8848 #配置Nacos地址 |
| | | username: nacos |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | | # config: |
| | | # server-addr: http://175.27.187.84:8848 #配置Nacos地址 |
| | | # namespace: dmvisit |
| | |
| | | server-addr: http://localhost:8848 #配置Nacos地址 |
| | | namespace: dmvisit |
| | | username: nacos |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | |
| | | nacos: |
| | | server-addr: http://localhost:8848 #配置Nacos地址 |
| | | username: nacos |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | | # config: |
| | | # server-addr: http://175.27.187.84:8848 #配置Nacos地址 |
| | | # namespace: dmvisit |
| | |
| | | server-addr: http://localhost:8848 #配置Nacos地址 |
| | | namespace: dmvisit |
| | | username: nacos |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | |
| | | nacos: |
| | | server-addr: http://localhost:8848 #配置Nacos地址 |
| | | username: nacos |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | | # config: |
| | | # server-addr: http://175.27.187.84:8848 #配置Nacos地址 |
| | | # namespace: dmvisit |
| | |
| | | server-addr: http://localhost:8848 #配置Nacos地址 |
| | | namespace: dmvisit |
| | | username: nacos |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | |
| | | spring: |
| | | profiles: |
| | | active: dev |
| | | active: test |
| | | application: |
| | | name: visitsAdmin |
| | | # 安全配置 |
| | |
| | | @ExcelColumn(name="合同编号",index = 2,width = 10) |
| | | @TableField(exist = false) |
| | | private String contractCode; |
| | | @ApiModelProperty(value = "合同状态", example = "1") |
| | | @TableField(exist = false) |
| | | private Integer contractStatus; |
| | | |
| | | @ApiModelProperty(value = "楼宇房间", example = "1") |
| | | @ExcelColumn(name="楼宇房间",index = 1,width = 10) |
| | |
| | | .select(" ( select ifnull( sum( CASE WHEN t.bill_type = 0 and yw.REVENUE_TYPE = 0 THEN yw.ACT_RECEIVABLE_FEE when t.bill_type = 0 and yw.REVENUE_TYPE = 1 then -yw.ACT_RECEIVABLE_FEE when t.bill_type = 1 and yw.REVENUE_TYPE = 0 then -yw.ACT_RECEIVABLE_FEE else yw.ACT_RECEIVABLE_FEE END),0) from yw_contract_revenue yw where yw.bill_id = t.id and yw.status = 0 and yw.isdeleted = 0 ) as actReceivableFee ") |
| | | .selectAs(YwContract::getCode,YwContractBill::getContractCode) |
| | | .selectAs(YwCustomer::getName,YwContractBill::getCustomerName) |
| | | .selectAs(Company::getId,YwContractBill::getCompanyId) |
| | | .selectAs(Company::getName,YwContractBill::getCompanyName) |
| | | .selectAs(SystemUser::getRealname,YwContractBill::getRealname) |
| | | .leftJoin(YwContract.class,YwContract::getId,YwContractBill::getContractId) |
| | |
| | | ){ |
| | | throw new BusinessException(ResponseStatus.BAD_REQUEST); |
| | | } |
| | | YwContractBill ywContractBill = ywContractBillMapper.selectById(ywContractRevenue.getBillId()); |
| | | YwContractBill ywContractBill = ywContractBillMapper.selectJoinOne(YwContractBill.class, |
| | | new MPJLambdaWrapper<YwContractBill>() |
| | | .selectAll(YwContractBill.class) |
| | | .selectAs(YwContract::getStatus, YwContractBill::getContractStatus) |
| | | .leftJoin(YwContract.class,YwContract::getId,YwContractBill::getContractId) |
| | | .eq(YwContractBill::getId,ywContractRevenue.getBillId())); |
| | | if(Objects.isNull(ywContractBill)){ |
| | | throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"未查询到账单信息"); |
| | | } |
| | |
| | | ywContractRevenueMapper.insert(ywContractRevenue); |
| | | ywContractBillMapper.updateById(ywContractBill); |
| | | //如果账单完结,则查询合同下开启中的账单是否存在退款中 如果不存在则标记合同已退款 |
| | | if(Constants.equalsInteger(ywContractBill.getPayStatus(),Constants.ONE)){ |
| | | if(Constants.equalsInteger(ywContractBill.getContractStatus(),Constants.THREE) |
| | | && Constants.equalsInteger(ywContractBill.getPayStatus(),Constants.ONE)){ |
| | | if( ywContractBillMapper |
| | | .selectCount(new QueryWrapper<YwContractBill>().lambda().eq(YwContractBill::getContractId,ywContractBill.getContractId()) |
| | | .ne(YwContractBill::getId,ywContractBill.getId()) |
| | |
| | | .eq(Objects.nonNull(model)&&Objects.nonNull(model.getRevenueType()), |
| | | YwContractRevenue::getRevenueType,model.getRevenueType()) |
| | | .ge(Objects.nonNull(model)&&Objects.nonNull(model.getPayDateStart()),YwContractRevenue::getActPayDate, Utils.Date.getStart(model.getPayDateStart())) |
| | | .le(Objects.nonNull(model)&&Objects.nonNull(model.getPayDateEnd()),YwContractRevenue::getActPayDate, Utils.Date.getEnd(model.getPayDateEnd())) ) |
| | | .le(Objects.nonNull(model)&&Objects.nonNull(model.getPayDateEnd()),YwContractRevenue::getActPayDate, Utils.Date.getEnd(model.getPayDateEnd())) |
| | | .orderByDesc(YwContractRevenue::getId)) |
| | | ; |
| | | |
| | | this.dealRoomDetail(iPage.getRecords()); |
| | |
| | | .replace("{param3}",DateUtil.getDateLongSlash(model.getBtDate())) |
| | | .replace("{param4}",fee.compareTo(new BigDecimal(0)) >=0?"收":"付") |
| | | .replace("{param5}",(fee.compareTo(new BigDecimal(0)) >=0? |
| | | Constants.formatBigdecimal2Float(model.getBtFee()).intValue() |
| | | :(Constants.formatBigdecimal2Float(model.getBtFee()).intValue() * -1))+"" ); |
| | | Constants.formatBigdecimal2Float(model.getBtFee()) |
| | | :(Constants.formatBigdecimal2Float(model.getBtFee()).multiply(new BigDecimal(-1)))).toString()); |
| | | return str; |
| | | } |
| | | private String getbackRentLogByParam(YwContract model) { |
| | | BigDecimal fee = Constants.formatBigdecimal(model.getBtFee()); |
| | | String str = "【退租日{param1},退租原因:{param2},退租协议中统计的费用总计{param3}元。】"; |
| | | String str = "【退租日{param1},退租原因:{param2},退租协议中统计的费用总计需{param4}{param5}元。】"; |
| | | str = str.replace("{param1}",DateUtil.getDateLongSlash(model.getBtDate())) |
| | | .replace("{param2}",StringUtils.defaultString(model.getBtInfo(),"")) |
| | | .replace("{param3}",Constants.formatBigdecimal2Float(model.getBtFee()).doubleValue()+""); |
| | | .replace("{param4}",fee.compareTo(new BigDecimal(0)) >=0?"收":"付") |
| | | .replace("{param5}",(fee.compareTo(new BigDecimal(0)) >=0? |
| | | Constants.formatBigdecimal2Float(model.getBtFee()) |
| | | :(Constants.formatBigdecimal2Float(model.getBtFee()).multiply(new BigDecimal(-1)))).toString()); |
| | | return str; |
| | | } |
| | | |
| | |
| | | addBill.setType(Constants.TWO); |
| | | addBill.setStatus(Constants.ZERO); |
| | | addBill.setTotleFee(addBill.getReceivableFee()); |
| | | addBill.setCompanyId(param.getCompanyId()); |
| | | if(Constants.equalsInteger(addBill.getFeeType(),Constants.ONE)){ |
| | | addBill.setStartDate(addBill.getPlanPayDate()); |
| | | addBill.setEndDate(addBill.getPlanPayDate()); |
| | |
| | | .leftJoin(YwRoom.class,YwRoom::getId,YwWorkorder::getRoomId) |
| | | .leftJoin(YwFloor.class,YwFloor::getId,YwWorkorder::getFloorId) |
| | | .leftJoin(YwBuilding.class,YwBuilding::getId,YwWorkorder::getBuildingId) |
| | | .leftJoin(YwProject.class,YwProject::getId,YwRoom::getProjectId) |
| | | .leftJoin(YwProject.class,YwProject::getId,YwWorkorder::getProjectId) |
| | | .leftJoin(" company t9 on t9.id = t1.company_id ") |
| | | .eq(YwWorkorder::getId,id); |
| | | YwWorkorder model = ywWorkorderMapper.selectJoinOne(YwWorkorder.class,queryWrapper); |
| | |
| | | datasource: |
| | | url: jdbc:mysql://localhost:3306/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai |
| | | username: root |
| | | password: Atwl@2024 |
| | | password: funing@2024 |
| | | driver-class-name: com.mysql.cj.jdbc.Driver |
| | | type: com.alibaba.druid.pool.DruidDataSource |
| | | redis: |