src/main/java/com/boying/controller/InspectionController.java

New file
@@ -0,0 +1,64 @@
package com.boying.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.boying.common.R;
import com.boying.entity.Inspection;
import com.boying.entity.Repair;
import com.boying.entity.WhiteList;
import com.boying.service.BarrierService;
import com.boying.service.InspectionService;
import com.boying.service.ParkService;
import com.boying.service.WhiteListService;
import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;


@RestController
@RequestMapping("ffzf/inspection")
@RequiredArgsConstructor
public class InspectionController {

    private final InspectionService inspectionService;
    private final ParkService parkService;
    private final BarrierService barrierService;

    @PostMapping("/findPage")
    public Object findPage(Page page,Long parkId) {
        QueryWrapper<Inspection> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .eq(parkId !=null,Inspection::getParkId,parkId)
                .orderByDesc(Inspection::getId);
        Page<Inspection> page1 = inspectionService.page(page, wrapper);
        List<Inspection> records = page1.getRecords();
        for (Inspection record : records) {
            record.setParkName(parkService.getById(record.getParkId()).getName());
            if(record.getBarrierId()!=null){
                record.setBarrierName(barrierService.getById(record.getBarrierId()).getName());
            }
        }
        page1.setRecords(records);
        return R.ok(page1);
    }


    @PostMapping("/save")
    public Object save(Inspection inspection) {
       inspectionService.save(inspection);
        return R.ok("保存成功");
    }

    @PostMapping("/delete")
    public Object delete(Long id) {
        inspectionService.removeById(id);
        return R.ok("删除成功");
    }
}

 src/main/java/com/boying/controller/RepairController.java

New file
@@ -0,0 +1,63 @@
package com.boying.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.StringUtils;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.boying.common.R;
import com.boying.entity.Inspection;
import com.boying.entity.Park;
import com.boying.entity.Repair;
import com.boying.entity.WhiteList;
import com.boying.service.BarrierService;
import com.boying.service.ParkService;
import com.boying.service.RepairService;
import com.boying.service.WhiteListService;
import lombok.RequiredArgsConstructor;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;


@RestController
@RequestMapping("ffzf/repair")
@RequiredArgsConstructor
public class RepairController {

    private final RepairService repairService;
    private final ParkService parkService;
    private final BarrierService barrierService;

    @PostMapping("/findPage")
    public Object findPage(Page page,Long parkId) {
        QueryWrapper<Repair> wrapper = new QueryWrapper<>();
        wrapper.lambda()
                .eq(parkId !=null, Repair::getParkId,parkId)
                .orderByDesc(Repair::getId);
        Page<Repair> page1 = repairService.page(page, wrapper);
        List<Repair> records = page1.getRecords();
        for (Repair record : records) {
            record.setParkName(parkService.getById(record.getParkId()).getName());
            record.setBarrierName(barrierService.getById(record.getBarrierId()).getName());
        }
        page1.setRecords(records);
        return R.ok(page1);
    }


    @PostMapping("/save")
    public Object save(Repair repair) {
        repairService.saveOrUpdate(repair);
        return R.ok("保存成功");
    }

    @PostMapping("/delete")
    public Object delete(Long id) {
        repairService.removeById(id);
        return R.ok("删除成功");
    }
}

 src/main/java/com/boying/entity/Inspection.java

New file
@@ -0,0 +1,64 @@
package com.boying.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.boying.common.BaseEntity;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Transient;
import java.time.LocalDateTime;

/**
 * @author kdq
 * @version 1.0.0
 * @ClassName Inspection.java
 * @Description TODO
 * @createTime 2025年12月26日 11:25:00
 */
@Data
@TableName("inspection")
@javax.persistence.Table(name = "inspection")
@Entity
@org.hibernate.annotations.Table(appliesTo = "inspection", comment = "巡检记录")
@ApiModel(value = "巡检记录")
public class Inspection extends BaseEntity<Inspection> {

    @ApiModelProperty(value = "巡检人")
    @Column(columnDefinition = "varchar(100) comment '巡检人'")
    private String inspecUser;

    private Integer parkId;
    private Integer barrierId;

    @ApiModelProperty(value = "状态 0正常1异常")
    @Column(columnDefinition = "int comment '状态 0正常1异常'")
    private Integer status;

    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private LocalDateTime inspecTime;

    @ApiModelProperty(value = "巡检详情")
    @Column(columnDefinition = "varchar(100) comment '巡检详情'")
    private String content;

    /**
     * 停车场
     */
    @Transient
    @TableField(exist = false)
    private String parkName;

    /**
     * 道闸
     */
    @Transient
    @TableField(exist = false)
    private String barrierName;
}

 src/main/java/com/boying/entity/Repair.java

New file
@@ -0,0 +1,57 @@
package com.boying.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import com.boying.common.BaseEntity;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Transient;
import java.time.LocalDateTime;

/**
 * @author kdq
 * @version 1.0.0
 * @ClassName Repair.java
 * @Description TODO
 * @createTime 2025年12月26日 11:33:00
 */
@Data
@TableName("repair")
@javax.persistence.Table(name = "repair")
@Entity
@org.hibernate.annotations.Table(appliesTo = "repair", comment = "维修维保记录")
@ApiModel(value = "维修维保记录")
public class Repair extends BaseEntity<Repair> {

    private Integer parkId;
    private Integer barrierId;
    private String repairUser;
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private LocalDateTime repairTime;
    @ApiModelProperty(value = "状态 0维修1保养2更换")
    @Column(columnDefinition = "int comment '状态 0维修1保养2更换'")
    private Integer status;
    private String repairContent;

    /**
     * 停车场
     */
    @Transient
    @TableField(exist = false)
    private String parkName;

    /**
     * 道闸
     */
    @Transient
    @TableField(exist = false)
    private String barrierName;

}

 src/main/java/com/boying/mapper/InspectionMapper.java

New file
@@ -0,0 +1,17 @@
package com.boying.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.boying.entity.Inspection;
import com.boying.entity.OutParkLog;
import org.apache.ibatis.annotations.Mapper;

/**
 * @author kdq
 * @version 1.0.0
 * @ClassName OutParkLogMapper.java
 * @Description TODO
 * @createTime 2023年12月12日 17:36:00
 */
@Mapper
public interface InspectionMapper extends BaseMapper<Inspection> {
}

 src/main/java/com/boying/mapper/RepairMapper.java

New file
@@ -0,0 +1,16 @@
package com.boying.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.boying.entity.Inspection;
import com.boying.entity.Repair;
import org.apache.ibatis.annotations.Mapper;

/**
 * @author kdq
 * @version 1.0.0
 * @Description TODO
 * @createTime 2023年12月12日 17:36:00
 */
@Mapper
public interface RepairMapper extends BaseMapper<Repair> {
}

 src/main/java/com/boying/service/InspectionService.java

New file
@@ -0,0 +1,15 @@
package com.boying.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.boying.entity.Inspection;
import com.boying.entity.LedShow;

/**
 * @author kdq
 * @version 1.0.0
 * @ClassName LedShowService.java
 * @Description TODO
 * @createTime 2022年11月21日 08:30:00
 */
public interface InspectionService extends IService<Inspection> {
}

 src/main/java/com/boying/service/RepairService.java

New file
@@ -0,0 +1,14 @@
package com.boying.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.boying.entity.Inspection;
import com.boying.entity.Repair;

/**
 * @author kdq
 * @version 1.0.0
 * @Description TODO
 * @createTime 2022年11月21日 08:30:00
 */
public interface RepairService extends IService<Repair> {
}

 src/main/java/com/boying/service/impl/InspectionServiceImpl.java

New file
@@ -0,0 +1,20 @@
package com.boying.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.boying.entity.Inspection;
import com.boying.mapper.InspectionMapper;
import com.boying.service.InspectionService;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

/**
 * @author kdq
 * @version 1.0.0
 * @ClassName LedShowService.java
 * @Description TODO
 * @createTime 2022年11月21日 08:30:00
 */
@Service
@AllArgsConstructor
public class InspectionServiceImpl extends ServiceImpl<InspectionMapper, Inspection> implements InspectionService {
}

 src/main/java/com/boying/service/impl/RepairServiceImpl.java

New file
@@ -0,0 +1,22 @@
package com.boying.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.boying.entity.Inspection;
import com.boying.entity.Repair;
import com.boying.mapper.InspectionMapper;
import com.boying.mapper.RepairMapper;
import com.boying.service.InspectionService;
import com.boying.service.RepairService;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

/**
 * @author kdq
 * @version 1.0.0
 * @Description TODO
 * @createTime 2022年11月21日 08:30:00
 */
@Service
@AllArgsConstructor
public class RepairServiceImpl extends ServiceImpl<RepairMapper, Repair> implements RepairService {
}

 src/main/resources/application.yml

@@ -3,7 +3,7 @@

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/ffparknew?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
    url: jdbc:mysql://localhost:3306/ffparknew?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
    username: root
    password: rootroot
    driverClassName: com.mysql.cj.jdbc.Driver