一 后端

1:entity

package com.woniu.community.entity;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;@Data
@AllArgsConstructor
@NoArgsConstructor
public class PropertyInfo {private int  id;private int typeId;private Double money;private String startDate;private String endDate;private Integer status;private int houseId;private  String remarks;private String numbers;private String userName;private String typeName;}

2:PropertyInfoMapper

package com.woniu.community.mapper;import com.woniu.community.entity.PropertyInfo;import java.util.List;public interface PropertyInfoMapper {List selectAll(int start,int size ,String numbers,Integer status);int  count(String numbers,Integer status);int  insertPropertyInfo(PropertyInfo propertyInfo);int  deletePropertyInfo(int id);int updatePropertyInfo(PropertyInfo propertyInfo);PropertyInfo getById(int id);
}

3:IPropertyInfoService

package com.woniu.community.service;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.PropertyInfo;import java.util.List;public interface IPropertyInfoService {HttpResult selectAll(int pageIndex, int pageSize , String numbers, Integer status);HttpResult  insertPropertyInfo(PropertyInfo propertyInfo);HttpResult  deletePropertyInfo(int id);HttpResult updatePropertyInfo(PropertyInfo propertyInfo);HttpResult getById(int id);}

4:PropertyInfoServiceImpl

package com.woniu.community.service.impl;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.PropertyInfo;
import com.woniu.community.mapper.PropertyInfoMapper;
import com.woniu.community.service.IPropertyInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;@Service
public class PropertyInfoServiceImpl implements IPropertyInfoService {@Autowired(required=false)private PropertyInfoMapper propertyInfoMapper;@Overridepublic HttpResult selectAll(int pageIndex, int pageSize, String numbers, Integer status) {HttpResult  result=null;List propertyInfos = propertyInfoMapper.selectAll((pageIndex - 1) * pageSize, pageSize, numbers, status);int count = propertyInfoMapper.count(numbers, status);if (propertyInfos!=null&&propertyInfos.size()>0){result=new HttpResult(propertyInfos,count,200,null);}else{result=new HttpResult(null,0,500,null);}return result;}@Overridepublic HttpResult insertPropertyInfo(PropertyInfo propertyInfo) {HttpResult  result=null;int count = propertyInfoMapper.insertPropertyInfo(propertyInfo);if (count>0){result=new HttpResult(null,0,200,"新增成功");}else{result=new HttpResult(null,0,500,"新增失败");}return result;}@Overridepublic HttpResult deletePropertyInfo(int id) {HttpResult  result=null;int count = propertyInfoMapper.deletePropertyInfo(id);if (count>0){result=new HttpResult(null,0,200,"删除成功");}else{result=new HttpResult(null,0,500,"删除失败");}return result;}@Overridepublic HttpResult updatePropertyInfo(PropertyInfo propertyInfo) {HttpResult  result=null;int count = propertyInfoMapper.updatePropertyInfo(propertyInfo);if (count>0){result=new HttpResult(null,0,200,"修改成功");}else{result=new HttpResult(null,0,500,"修改失败");}return result;}@Overridepublic HttpResult getById(int id) {HttpResult  result=null;PropertyInfo info = propertyInfoMapper.getById(id);if (info!=null){result=new HttpResult(info,0,200,null);}else{result=new HttpResult(null,0,500,"没有更多数据");}return result;}
}

5:PropertyInfoController

package com.woniu.community.controller;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.PropertyInfo;
import com.woniu.community.service.IPropertyInfoService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;@RestController
@RequestMapping ("/property")
@CrossOrigin(origins = "*")
public class PropertyInfoController {@Autowiredprivate IPropertyInfoService  iPropertyInfoService;@RequestMapping("/list")HttpResult selectAll(int pageIndex, int pageSize , String numbers, Integer status){return iPropertyInfoService.selectAll(pageIndex,pageSize,numbers,status);}@RequestMapping("/add")HttpResult  insertPropertyInfo(PropertyInfo propertyInfo){return  iPropertyInfoService.insertPropertyInfo(propertyInfo);}@RequestMapping("/delete")HttpResult  deletePropertyInfo(int id){return iPropertyInfoService.deletePropertyInfo(id);}@RequestMapping("/update")HttpResult updatePropertyInfo(PropertyInfo propertyInfo){return  iPropertyInfoService.updatePropertyInfo(propertyInfo);}@RequestMapping("/info")HttpResult getById(int id){return iPropertyInfoService.getById(id);}
}

6:PropertyInfoMapper.xml

select  o.username,h.numbers,c.name,p.* from  property_info pleft  join property_type c  onp.type_id=c.id left  join house h  onp.house_id=h.id  left  join   owner o ono.house_id=h.idand  h.numbers=#{numbers}and  p.status=#{status}limit #{start},#{size}selectcount(p.id)fromproperty_info pleft  join property_type c  onp.type_id=c.id left  join house h  onp.house_id=h.id  left  join   owner o ono.house_id=h.idand  h.numbers=#{numbers}and  p.status=#{status}insert  into property_info(house_id,type_id,start_date,end_date,money,status)values (#{houseId},#{typeId},#{startDate},#{endDate},#{money},#{status})delete  from property_info where id=#{id}update property_info set money=#{money},status=#{status} where id=#{id}select  *  from property_info where id=#{id}

二 前端代码

房间号:
缴费状态:已缴费未缴费
搜索
新增
物业收费
房间号
房东
费用类型
开始时间
结束时间
金额
状态
操作
{{p.numbers}}
{{p.userName}}
{{p.typeName}}
{{p.startDate}}
{{p.endDate}}
{{p.money}}
{{p.status==1?"已缴费":"未缴费"}}
删除
缴费删除
{{p}}
{{p}}

{{title}}
房间号:{{h.numbers}}
费用类型:水费电费物业费停车费
开始时间:结束时间:金额
状态:缴费未缴费
保存取消

三 运行结果