一 后端

1:entity

package com.woniu.community.entity;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;@Data
@AllArgsConstructor
@NoArgsConstructor
public class Repair {private int id;private String comId;private String comDate;private int ownerId;private Integer status;private int clr;private String remarks;private  String userName;private String  name;}

2:Repairmapper

package com.woniu.community.mapper;import com.woniu.community.entity.Owner;
import com.woniu.community.entity.Repair;import java.util.List;public interface RepairMapper {List selectAll(String name, Integer status, int start, int size);int  count(String name, Integer status);int insertRepair(Repair repair);int  deleteRepair(int id);int  updateRepair(Repair repair);Repair selectById(int  id);
}

3:IRepairService

package com.woniu.community.service;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.Repair;public interface IRepairService {HttpResult selectAll(String name, Integer status, int pageIndex, int pageSize);HttpResult insertRepair(Repair repair);HttpResult  deleteRepair(int id);HttpResult  updateRepair(Repair repair);HttpResult selectById(int  id);
}

4:RepairServiceImpl

package com.woniu.community.service.impl;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.Repair;
import com.woniu.community.mapper.RepairMapper;
import com.woniu.community.service.IRepairService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import javax.swing.*;
import java.util.List;@Service
public class RepairServiceImpl implements IRepairService {@Autowired(required = false)private RepairMapper repairMapper;@Overridepublic HttpResult selectAll(String name, Integer status, int pageIndex, int pageSize) {HttpResult result=null;List repairs = repairMapper.selectAll(name, status, (pageIndex - 1) * pageSize, pageSize);int count = repairMapper.count(name, status);if (repairs!=null&&repairs.size()>0){result=new HttpResult(repairs,count,200,null);}else{result=new HttpResult(null,0,200,"没有更多数据");}return result;}@Overridepublic HttpResult insertRepair(Repair repair) {HttpResult result=null;int count = repairMapper.insertRepair(repair);if (count>0){result=new HttpResult(null,0,200,"添加成功");}else{result=new HttpResult(null,0,500,"添加失败");}return result;}@Overridepublic HttpResult deleteRepair(int id) {HttpResult result=null;int count = repairMapper.deleteRepair(id);if (count>0){result=new HttpResult(null,0,200,"删除成功");}else{result=new HttpResult(null,0,500,"删除失败");}return result;}@Overridepublic HttpResult updateRepair(Repair repair) {HttpResult result=null;int count = repairMapper.updateRepair(repair);if (count>0){result=new HttpResult(null,0,200,"修改成功");}else{result=new HttpResult(null,0,500,"修改失败");}return result;}@Overridepublic HttpResult selectById(int id) {HttpResult result=null;Repair repair = repairMapper.selectById(id);if (repair!=null){result=new HttpResult(repair,0,200,null);}else{result=new HttpResult(null,0,500,"没有更多数据");}return result;}
}

5:RepairController

package com.woniu.community.controller;import com.woniu.community.entity.HttpResult;
import com.woniu.community.entity.Repair;
import com.woniu.community.service.IRepairService;
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("/repair")
@CrossOrigin(origins = "*")
public class RepairController {@Autowiredprivate IRepairService iRepairService;@RequestMapping("list")HttpResult selectAll(String name, Integer status, int pageIndex, int pageSize){return iRepairService.selectAll(name,status,pageIndex,pageSize);}@RequestMapping("add")HttpResult insertRepair(Repair repair){return iRepairService.insertRepair(repair);}@RequestMapping("delete")HttpResult  deleteRepair(int id){return iRepairService.deleteRepair(id);}@RequestMapping("update")HttpResult  updateRepair(Repair repair){return iRepairService.updateRepair(repair);}@RequestMapping("info")HttpResult selectById(int  id){return iRepairService.selectById(id);}
}

6:RepairMapper.xml

selectre.name,r.*,o.usernamefromrepair r left  joinowner  o onr.owner_id=o.idleft  joinrepairtype re onr.com_id=re.idand re.name like '%${name}%'and   status=#{status}limit #{start},#{size}selectcount(r.id)fromrepair r left  joinowner  o onr.owner_id=o.idleft  joinrepairtype re onr.com_id=re.idand re.name like '%${name}%'and   status=#{status}insert into  repair(com_id,remarks,owner_id,com_date,status,clr)values (#{comId},#{remarks},#{ownerId},#{comDate},#{status},#{clr})delete from repair where id=#{id}update repair set status=#{status} where  id=#{id}select * from  repair where  id=#{id}

二前端代码

维修类型:公共部位维修共用设施设备 自用部位维修门窗维修电路维修电梯
处理状态:已处理未处理
搜索
新增
车位收费
保修类型
保修内容
报修人
保修时间
处理状态
处理人
操作
{{c.name}}
{{c.remarks}}
{{c.userName}}
{{c.comDate}}
{{c.status==1?"已处理":"未处理"}}
{{c.clr}}
删除
报修处理删除
{{p}}
{{p}}

{{title}}
维修类型:公共部位维修共用设施设备 自用部位维修门窗维修电路维修电梯
保修内容
保修人:{{o.userName}}
保修时间:
处理状态:已处理未处理
处理人
保存取消

三 页面效果