app巡检计划概要提交

zhangnaisong

2023-08-02 8afb9184600eb1524b38b172e458143b16739b34

app巡检计划概要提交

 ard-work/src/main/java/com/ruoyi/app/patrolplan/controller/ArdAppPatrolplanController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.ruoyi.app.patrolplan.controller;

import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolplan;
import com.ruoyi.app.patrolplan.service.IArdAppPatrolplanService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * app巡检计划Controller
 * 
 * @author ard
 * @date 2023-08-02
 */
@RestController
@RequestMapping("/app/appPatrolplan")
public class ArdAppPatrolplanController extends BaseController
{
    @Autowired
    private IArdAppPatrolplanService ardAppPatrolplanService;

    /**
     * æŸ¥è¯¢app巡检计划列表
     */
    @PreAuthorize("@ss.hasPermi('app:appPatrolplan:list')")
    @GetMapping("/list")
    public TableDataInfo list(ArdAppPatrolplan ardAppPatrolplan)
    {
        startPage();
        List<ArdAppPatrolplan> list = ardAppPatrolplanService.selectArdAppPatrolplanList(ardAppPatrolplan);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºapp巡检计划列表
     */
    @PreAuthorize("@ss.hasPermi('app:appPatrolplan:export')")
    @Log(title = "app巡检计划", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ArdAppPatrolplan ardAppPatrolplan)
    {
        List<ArdAppPatrolplan> list = ardAppPatrolplanService.selectArdAppPatrolplanList(ardAppPatrolplan);
        ExcelUtil<ArdAppPatrolplan> util = new ExcelUtil<ArdAppPatrolplan>(ArdAppPatrolplan.class);
        util.exportExcel(response, list, "app巡检计划数据");
    }

    /**
     * èŽ·å–app巡检计划详细信息
     */
    @PreAuthorize("@ss.hasPermi('app:appPatrolplan:query')")
    @GetMapping(value = "/{patroEndTime}")
    public AjaxResult getInfo(@PathVariable("patroEndTime") String patroEndTime)
    {
        return success(ardAppPatrolplanService.selectArdAppPatrolplanByPatroEndTime(patroEndTime));
    }

    /**
     * æ–°å¢žapp巡检计划
     */
    @PreAuthorize("@ss.hasPermi('app:appPatrolplan:add')")
    @Log(title = "app巡检计划", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ArdAppPatrolplan ardAppPatrolplan)
    {
        return toAjax(ardAppPatrolplanService.insertArdAppPatrolplan(ardAppPatrolplan));
    }

    /**
     * ä¿®æ”¹app巡检计划
     */
    @PreAuthorize("@ss.hasPermi('app:appPatrolplan:edit')")
    @Log(title = "app巡检计划", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ArdAppPatrolplan ardAppPatrolplan)
    {
        return toAjax(ardAppPatrolplanService.updateArdAppPatrolplan(ardAppPatrolplan));
    }

    /**
     * åˆ é™¤app巡检计划
     */
    @PreAuthorize("@ss.hasPermi('app:appPatrolplan:remove')")
    @Log(title = "app巡检计划", businessType = BusinessType.DELETE)
    @DeleteMapping("/{patroEndTimes}")
    public AjaxResult remove(@PathVariable String[] patroEndTimes)
    {
        return toAjax(ardAppPatrolplanService.deleteArdAppPatrolplanByPatroEndTimes(patroEndTimes));
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/controller/ArdAppPatrolpointController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.ruoyi.app.patrolplan.controller;

import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpoint;
import com.ruoyi.app.patrolplan.service.IArdAppPatrolpointService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * app巡检计划点位Controller
 * 
 * @author ard
 * @date 2023-08-02
 */
@RestController
@RequestMapping("/app/patrolpoint")
public class ArdAppPatrolpointController extends BaseController
{
    @Autowired
    private IArdAppPatrolpointService ardAppPatrolpointService;

    /**
     * æŸ¥è¯¢app巡检计划点位列表
     */
    @PreAuthorize("@ss.hasPermi('app:patrolpoint:list')")
    @GetMapping("/list")
    public TableDataInfo list(ArdAppPatrolpoint ardAppPatrolpoint)
    {
        startPage();
        List<ArdAppPatrolpoint> list = ardAppPatrolpointService.selectArdAppPatrolpointList(ardAppPatrolpoint);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºapp巡检计划点位列表
     */
    @PreAuthorize("@ss.hasPermi('app:patrolpoint:export')")
    @Log(title = "app巡检计划点位", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ArdAppPatrolpoint ardAppPatrolpoint)
    {
        List<ArdAppPatrolpoint> list = ardAppPatrolpointService.selectArdAppPatrolpointList(ardAppPatrolpoint);
        ExcelUtil<ArdAppPatrolpoint> util = new ExcelUtil<ArdAppPatrolpoint>(ArdAppPatrolpoint.class);
        util.exportExcel(response, list, "app巡检计划点位数据");
    }

    /**
     * èŽ·å–app巡检计划点位详细信息
     */
    @PreAuthorize("@ss.hasPermi('app:patrolpoint:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") String id)
    {
        return success(ardAppPatrolpointService.selectArdAppPatrolpointById(id));
    }

    /**
     * æ–°å¢žapp巡检计划点位
     */
    @PreAuthorize("@ss.hasPermi('app:patrolpoint:add')")
    @Log(title = "app巡检计划点位", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ArdAppPatrolpoint ardAppPatrolpoint)
    {
        return toAjax(ardAppPatrolpointService.insertArdAppPatrolpoint(ardAppPatrolpoint));
    }

    /**
     * ä¿®æ”¹app巡检计划点位
     */
    @PreAuthorize("@ss.hasPermi('app:patrolpoint:edit')")
    @Log(title = "app巡检计划点位", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ArdAppPatrolpoint ardAppPatrolpoint)
    {
        return toAjax(ardAppPatrolpointService.updateArdAppPatrolpoint(ardAppPatrolpoint));
    }

    /**
     * åˆ é™¤app巡检计划点位
     */
    @PreAuthorize("@ss.hasPermi('app:patrolpoint:remove')")
    @Log(title = "app巡检计划点位", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable String[] ids)
    {
        return toAjax(ardAppPatrolpointService.deleteArdAppPatrolpointByIds(ids));
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/controller/ArdAppPatroluserController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,104 @@
package com.ruoyi.app.patrolplan.controller;

import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.app.patrolplan.domain.ArdAppPatroluser;
import com.ruoyi.app.patrolplan.service.IArdAppPatroluserService;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.core.page.TableDataInfo;

/**
 * app巡检计划人员Controller
 * 
 * @author ard
 * @date 2023-08-02
 */
@RestController
@RequestMapping("/app/patroluser")
public class ArdAppPatroluserController extends BaseController
{
    @Autowired
    private IArdAppPatroluserService ardAppPatroluserService;

    /**
     * æŸ¥è¯¢app巡检计划人员列表
     */
    @PreAuthorize("@ss.hasPermi('app:patroluser:list')")
    @GetMapping("/list")
    public TableDataInfo list(ArdAppPatroluser ardAppPatroluser)
    {
        startPage();
        List<ArdAppPatroluser> list = ardAppPatroluserService.selectArdAppPatroluserList(ardAppPatroluser);
        return getDataTable(list);
    }

    /**
     * å¯¼å‡ºapp巡检计划人员列表
     */
    @PreAuthorize("@ss.hasPermi('app:patroluser:export')")
    @Log(title = "app巡检计划人员", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, ArdAppPatroluser ardAppPatroluser)
    {
        List<ArdAppPatroluser> list = ardAppPatroluserService.selectArdAppPatroluserList(ardAppPatroluser);
        ExcelUtil<ArdAppPatroluser> util = new ExcelUtil<ArdAppPatroluser>(ArdAppPatroluser.class);
        util.exportExcel(response, list, "app巡检计划人员数据");
    }

    /**
     * èŽ·å–app巡检计划人员详细信息
     */
    @PreAuthorize("@ss.hasPermi('app:patroluser:query')")
    @GetMapping(value = "/{reserved1}")
    public AjaxResult getInfo(@PathVariable("reserved1") String reserved1)
    {
        return success(ardAppPatroluserService.selectArdAppPatroluserByReserved1(reserved1));
    }

    /**
     * æ–°å¢žapp巡检计划人员
     */
    @PreAuthorize("@ss.hasPermi('app:patroluser:add')")
    @Log(title = "app巡检计划人员", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody ArdAppPatroluser ardAppPatroluser)
    {
        return toAjax(ardAppPatroluserService.insertArdAppPatroluser(ardAppPatroluser));
    }

    /**
     * ä¿®æ”¹app巡检计划人员
     */
    @PreAuthorize("@ss.hasPermi('app:patroluser:edit')")
    @Log(title = "app巡检计划人员", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody ArdAppPatroluser ardAppPatroluser)
    {
        return toAjax(ardAppPatroluserService.updateArdAppPatroluser(ardAppPatroluser));
    }

    /**
     * åˆ é™¤app巡检计划人员
     */
    @PreAuthorize("@ss.hasPermi('app:patroluser:remove')")
    @Log(title = "app巡检计划人员", businessType = BusinessType.DELETE)
    @DeleteMapping("/{reserved1s}")
    public AjaxResult remove(@PathVariable String[] reserved1s)
    {
        return toAjax(ardAppPatroluserService.deleteArdAppPatroluserByReserved1s(reserved1s));
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/domain/ArdAppPatrolplan.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,108 @@
package com.ruoyi.app.patrolplan.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * app巡检计划对象 ard_app_patrolplan
 * 
 * @author ard
 * @date 2023-08-02
 */
public class ArdAppPatrolplan extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ç»“束时间(每天为时分秒，仅一次为年月日时分秒) */
    @Excel(name = "结束时间(每天为时分秒，仅一次为年月日时分秒)")
    private String patroEndTime;

    /** åˆ¶å®šäººä¸»é”® */
    @Excel(name = "制定人主键")
    private String userId;

    /** å‘¨æœŸ */
    @Excel(name = "周期")
    private String cycle;

    /** ä¸»é”® */
    private String id;

    /** å·¡æ£€è®¡åˆ’名称 */
    @Excel(name = "巡检计划名称")
    private String planName;

    /** å¼€å§‹æ—¶é—´(每天为时分秒，仅一次为年月日时分秒) */
    @Excel(name = "开始时间(每天为时分秒，仅一次为年月日时分秒)")
    private String patroBeginTime;

    public void setPatroEndTime(String patroEndTime) 
    {
        this.patroEndTime = patroEndTime;
    }

    public String getPatroEndTime() 
    {
        return patroEndTime;
    }
    public void setUserId(String userId) 
    {
        this.userId = userId;
    }

    public String getUserId() 
    {
        return userId;
    }
    public void setCycle(String cycle) 
    {
        this.cycle = cycle;
    }

    public String getCycle() 
    {
        return cycle;
    }
    public void setId(String id) 
    {
        this.id = id;
    }

    public String getId() 
    {
        return id;
    }
    public void setPlanName(String planName) 
    {
        this.planName = planName;
    }

    public String getPlanName() 
    {
        return planName;
    }
    public void setPatroBeginTime(String patroBeginTime) 
    {
        this.patroBeginTime = patroBeginTime;
    }

    public String getPatroBeginTime() 
    {
        return patroBeginTime;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("patroEndTime", getPatroEndTime())
            .append("userId", getUserId())
            .append("cycle", getCycle())
            .append("createTime", getCreateTime())
            .append("id", getId())
            .append("planName", getPlanName())
            .append("patroBeginTime", getPatroBeginTime())
            .toString();
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/domain/ArdAppPatrolpoint.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,79 @@
package com.ruoyi.app.patrolplan.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * app巡检计划点位对象 ard_app_patrolpoint
 * 
 * @author ard
 * @date 2023-08-02
 */
public class ArdAppPatrolpoint extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”® */
    private String id;

    /** å·¡æ£€ä¸»é”® */
    @Excel(name = "巡检主键")
    private String patrolplanId;

    /** å…´è¶£ç‚¹ä¸»é”® */
    @Excel(name = "兴趣点主键")
    private String alarmpointsId;

    /** ç±»åž‹ */
    @Excel(name = "类型")
    private String type;

    public void setId(String id) 
    {
        this.id = id;
    }

    public String getId() 
    {
        return id;
    }
    public void setPatrolplanId(String patrolplanId) 
    {
        this.patrolplanId = patrolplanId;
    }

    public String getPatrolplanId() 
    {
        return patrolplanId;
    }
    public void setAlarmpointsId(String alarmpointsId) 
    {
        this.alarmpointsId = alarmpointsId;
    }

    public String getAlarmpointsId() 
    {
        return alarmpointsId;
    }
    public void setType(String type) 
    {
        this.type = type;
    }

    public String getType() 
    {
        return type;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("patrolplanId", getPatrolplanId())
            .append("alarmpointsId", getAlarmpointsId())
            .append("type", getType())
            .toString();
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/domain/ArdAppPatrolpointRecord.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,108 @@
package com.ruoyi.app.patrolplan.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * app巡检计划记录对象 ard_app_patrolpoint_record
 * 
 * @author ard
 * @date 2023-08-02
 */
public class ArdAppPatrolpointRecord extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”® */
    private String id;

    /** ç»åº¦ */
    @Excel(name = "经度")
    private String longitude;

    /** çº¬åº¦ */
    @Excel(name = "纬度")
    private String latitude;

    /** æ‰“卡人主键 */
    @Excel(name = "打卡人主键")
    private String userId;

    /** æ‰“卡时间 */
    @Excel(name = "打卡时间")
    private String recordTime;

    /** å·¡æ£€ç‚¹ä¸»é”® */
    @Excel(name = "巡检点主键")
    private String appPatrolpointsId;

    public void setId(String id) 
    {
        this.id = id;
    }

    public String getId() 
    {
        return id;
    }
    public void setLongitude(String longitude) 
    {
        this.longitude = longitude;
    }

    public String getLongitude() 
    {
        return longitude;
    }
    public void setLatitude(String latitude) 
    {
        this.latitude = latitude;
    }

    public String getLatitude() 
    {
        return latitude;
    }
    public void setUserId(String userId) 
    {
        this.userId = userId;
    }

    public String getUserId() 
    {
        return userId;
    }
    public void setRecordTime(String recordTime) 
    {
        this.recordTime = recordTime;
    }

    public String getRecordTime() 
    {
        return recordTime;
    }
    public void setAppPatrolpointsId(String appPatrolpointsId) 
    {
        this.appPatrolpointsId = appPatrolpointsId;
    }

    public String getAppPatrolpointsId() 
    {
        return appPatrolpointsId;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("remark", getRemark())
            .append("longitude", getLongitude())
            .append("latitude", getLatitude())
            .append("userId", getUserId())
            .append("recordTime", getRecordTime())
            .append("appPatrolpointsId", getAppPatrolpointsId())
            .toString();
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/domain/ArdAppPatrolpointRecordImg.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,65 @@
package com.ruoyi.app.patrolplan.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * app巡检计划记录图片对象 ard_app_patrolpoint_record_img
 * 
 * @author ard
 * @date 2023-08-02
 */
public class ArdAppPatrolpointRecordImg extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”® */
    private String id;

    /** å·¡æ£€è®°å½•ä¸»é”® */
    @Excel(name = "巡检记录主键")
    private String appPatrolponitRecordId;

    /** å·¡æ£€å›¾ç‰‡ */
    @Excel(name = "巡检图片")
    private String img;

    public void setId(String id) 
    {
        this.id = id;
    }

    public String getId() 
    {
        return id;
    }
    public void setAppPatrolponitRecordId(String appPatrolponitRecordId) 
    {
        this.appPatrolponitRecordId = appPatrolponitRecordId;
    }

    public String getAppPatrolponitRecordId() 
    {
        return appPatrolponitRecordId;
    }
    public void setImg(String img) 
    {
        this.img = img;
    }

    public String getImg() 
    {
        return img;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("appPatrolponitRecordId", getAppPatrolponitRecordId())
            .append("img", getImg())
            .toString();
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/domain/ArdAppPatroluser.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,66 @@
package com.ruoyi.app.patrolplan.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.ruoyi.common.annotation.Excel;
import com.ruoyi.common.core.domain.BaseEntity;

/**
 * app巡检计划人员对象 ard_app_patroluser
 * 
 * @author ard
 * @date 2023-08-02
 */
public class ArdAppPatroluser extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ä¸»é”® */
    @Excel(name = "主键")
    private String reserved1;

    /** å·¡æ£€ä¸»é”® */
    @Excel(name = "巡检主键")
    private String patrolplanId;

    /** app单兵端用户主键 */
    @Excel(name = "app单兵端用户主键")
    private String appUserId;

    public void setReserved1(String reserved1) 
    {
        this.reserved1 = reserved1;
    }

    public String getReserved1() 
    {
        return reserved1;
    }
    public void setPatrolplanId(String patrolplanId) 
    {
        this.patrolplanId = patrolplanId;
    }

    public String getPatrolplanId() 
    {
        return patrolplanId;
    }
    public void setAppUserId(String appUserId) 
    {
        this.appUserId = appUserId;
    }

    public String getAppUserId() 
    {
        return appUserId;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("reserved1", getReserved1())
            .append("patrolplanId", getPatrolplanId())
            .append("appUserId", getAppUserId())
            .toString();
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/mapper/ArdAppPatrolplanMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.mapper;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolplan;

/**
 * app巡检计划Mapper接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface ArdAppPatrolplanMapper 
{
    /**
     * æŸ¥è¯¢app巡检计划
     * 
     * @param patroEndTime app巡检计划主键
     * @return app巡检计划
     */
    public ArdAppPatrolplan selectArdAppPatrolplanByPatroEndTime(String patroEndTime);

    /**
     * æŸ¥è¯¢app巡检计划列表
     * 
     * @param ardAppPatrolplan app巡检计划
     * @return app巡检计划集合
     */
    public List<ArdAppPatrolplan> selectArdAppPatrolplanList(ArdAppPatrolplan ardAppPatrolplan);

    /**
     * æ–°å¢žapp巡检计划
     * 
     * @param ardAppPatrolplan app巡检计划
     * @return ç»“æžœ
     */
    public int insertArdAppPatrolplan(ArdAppPatrolplan ardAppPatrolplan);

    /**
     * ä¿®æ”¹app巡检计划
     * 
     * @param ardAppPatrolplan app巡检计划
     * @return ç»“æžœ
     */
    public int updateArdAppPatrolplan(ArdAppPatrolplan ardAppPatrolplan);

    /**
     * åˆ é™¤app巡检计划
     * 
     * @param patroEndTime app巡检计划主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolplanByPatroEndTime(String patroEndTime);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划
     * 
     * @param patroEndTimes éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolplanByPatroEndTimes(String[] patroEndTimes);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/mapper/ArdAppPatrolpointMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.mapper;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpoint;

/**
 * app巡检计划点位Mapper接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface ArdAppPatrolpointMapper 
{
    /**
     * æŸ¥è¯¢app巡检计划点位
     * 
     * @param id app巡检计划点位主键
     * @return app巡检计划点位
     */
    public ArdAppPatrolpoint selectArdAppPatrolpointById(String id);

    /**
     * æŸ¥è¯¢app巡检计划点位列表
     * 
     * @param ardAppPatrolpoint app巡检计划点位
     * @return app巡检计划点位集合
     */
    public List<ArdAppPatrolpoint> selectArdAppPatrolpointList(ArdAppPatrolpoint ardAppPatrolpoint);

    /**
     * æ–°å¢žapp巡检计划点位
     * 
     * @param ardAppPatrolpoint app巡检计划点位
     * @return ç»“æžœ
     */
    public int insertArdAppPatrolpoint(ArdAppPatrolpoint ardAppPatrolpoint);

    /**
     * ä¿®æ”¹app巡检计划点位
     * 
     * @param ardAppPatrolpoint app巡检计划点位
     * @return ç»“æžœ
     */
    public int updateArdAppPatrolpoint(ArdAppPatrolpoint ardAppPatrolpoint);

    /**
     * åˆ é™¤app巡检计划点位
     * 
     * @param id app巡检计划点位主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointById(String id);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划点位
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointByIds(String[] ids);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/mapper/ArdAppPatrolpointRecordImgMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.mapper;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpointRecordImg;

/**
 * app巡检计划记录图片Mapper接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface ArdAppPatrolpointRecordImgMapper 
{
    /**
     * æŸ¥è¯¢app巡检计划记录图片
     * 
     * @param id app巡检计划记录图片主键
     * @return app巡检计划记录图片
     */
    public ArdAppPatrolpointRecordImg selectArdAppPatrolpointRecordImgById(String id);

    /**
     * æŸ¥è¯¢app巡检计划记录图片列表
     * 
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return app巡检计划记录图片集合
     */
    public List<ArdAppPatrolpointRecordImg> selectArdAppPatrolpointRecordImgList(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg);

    /**
     * æ–°å¢žapp巡检计划记录图片
     * 
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return ç»“æžœ
     */
    public int insertArdAppPatrolpointRecordImg(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg);

    /**
     * ä¿®æ”¹app巡检计划记录图片
     * 
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return ç»“æžœ
     */
    public int updateArdAppPatrolpointRecordImg(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg);

    /**
     * åˆ é™¤app巡检计划记录图片
     * 
     * @param id app巡检计划记录图片主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointRecordImgById(String id);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划记录图片
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointRecordImgByIds(String[] ids);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/mapper/ArdAppPatrolpointRecordMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.mapper;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpointRecord;

/**
 * app巡检计划记录Mapper接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface ArdAppPatrolpointRecordMapper 
{
    /**
     * æŸ¥è¯¢app巡检计划记录
     * 
     * @param id app巡检计划记录主键
     * @return app巡检计划记录
     */
    public ArdAppPatrolpointRecord selectArdAppPatrolpointRecordById(String id);

    /**
     * æŸ¥è¯¢app巡检计划记录列表
     * 
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return app巡检计划记录集合
     */
    public List<ArdAppPatrolpointRecord> selectArdAppPatrolpointRecordList(ArdAppPatrolpointRecord ardAppPatrolpointRecord);

    /**
     * æ–°å¢žapp巡检计划记录
     * 
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return ç»“æžœ
     */
    public int insertArdAppPatrolpointRecord(ArdAppPatrolpointRecord ardAppPatrolpointRecord);

    /**
     * ä¿®æ”¹app巡检计划记录
     * 
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return ç»“æžœ
     */
    public int updateArdAppPatrolpointRecord(ArdAppPatrolpointRecord ardAppPatrolpointRecord);

    /**
     * åˆ é™¤app巡检计划记录
     * 
     * @param id app巡检计划记录主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointRecordById(String id);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划记录
     * 
     * @param ids éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointRecordByIds(String[] ids);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/mapper/ArdAppPatroluserMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.mapper;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatroluser;

/**
 * app巡检计划人员Mapper接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface ArdAppPatroluserMapper 
{
    /**
     * æŸ¥è¯¢app巡检计划人员
     * 
     * @param reserved1 app巡检计划人员主键
     * @return app巡检计划人员
     */
    public ArdAppPatroluser selectArdAppPatroluserByReserved1(String reserved1);

    /**
     * æŸ¥è¯¢app巡检计划人员列表
     * 
     * @param ardAppPatroluser app巡检计划人员
     * @return app巡检计划人员集合
     */
    public List<ArdAppPatroluser> selectArdAppPatroluserList(ArdAppPatroluser ardAppPatroluser);

    /**
     * æ–°å¢žapp巡检计划人员
     * 
     * @param ardAppPatroluser app巡检计划人员
     * @return ç»“æžœ
     */
    public int insertArdAppPatroluser(ArdAppPatroluser ardAppPatroluser);

    /**
     * ä¿®æ”¹app巡检计划人员
     * 
     * @param ardAppPatroluser app巡检计划人员
     * @return ç»“æžœ
     */
    public int updateArdAppPatroluser(ArdAppPatroluser ardAppPatroluser);

    /**
     * åˆ é™¤app巡检计划人员
     * 
     * @param reserved1 app巡检计划人员主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatroluserByReserved1(String reserved1);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划人员
     * 
     * @param reserved1s éœ€è¦åˆ é™¤çš„数据主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatroluserByReserved1s(String[] reserved1s);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/IArdAppPatrolplanService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.service;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolplan;

/**
 * app巡检计划Service接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface IArdAppPatrolplanService 
{
    /**
     * æŸ¥è¯¢app巡检计划
     * 
     * @param patroEndTime app巡检计划主键
     * @return app巡检计划
     */
    public ArdAppPatrolplan selectArdAppPatrolplanByPatroEndTime(String patroEndTime);

    /**
     * æŸ¥è¯¢app巡检计划列表
     * 
     * @param ardAppPatrolplan app巡检计划
     * @return app巡检计划集合
     */
    public List<ArdAppPatrolplan> selectArdAppPatrolplanList(ArdAppPatrolplan ardAppPatrolplan);

    /**
     * æ–°å¢žapp巡检计划
     * 
     * @param ardAppPatrolplan app巡检计划
     * @return ç»“æžœ
     */
    public int insertArdAppPatrolplan(ArdAppPatrolplan ardAppPatrolplan);

    /**
     * ä¿®æ”¹app巡检计划
     * 
     * @param ardAppPatrolplan app巡检计划
     * @return ç»“æžœ
     */
    public int updateArdAppPatrolplan(ArdAppPatrolplan ardAppPatrolplan);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划
     * 
     * @param patroEndTimes éœ€è¦åˆ é™¤çš„app巡检计划主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolplanByPatroEndTimes(String[] patroEndTimes);

    /**
     * åˆ é™¤app巡检计划信息
     * 
     * @param patroEndTime app巡检计划主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolplanByPatroEndTime(String patroEndTime);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/IArdAppPatrolpointRecordImgService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.service;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpointRecordImg;

/**
 * app巡检计划记录图片Service接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface IArdAppPatrolpointRecordImgService 
{
    /**
     * æŸ¥è¯¢app巡检计划记录图片
     * 
     * @param id app巡检计划记录图片主键
     * @return app巡检计划记录图片
     */
    public ArdAppPatrolpointRecordImg selectArdAppPatrolpointRecordImgById(String id);

    /**
     * æŸ¥è¯¢app巡检计划记录图片列表
     * 
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return app巡检计划记录图片集合
     */
    public List<ArdAppPatrolpointRecordImg> selectArdAppPatrolpointRecordImgList(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg);

    /**
     * æ–°å¢žapp巡检计划记录图片
     * 
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return ç»“æžœ
     */
    public int insertArdAppPatrolpointRecordImg(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg);

    /**
     * ä¿®æ”¹app巡检计划记录图片
     * 
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return ç»“æžœ
     */
    public int updateArdAppPatrolpointRecordImg(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划记录图片
     * 
     * @param ids éœ€è¦åˆ é™¤çš„app巡检计划记录图片主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointRecordImgByIds(String[] ids);

    /**
     * åˆ é™¤app巡检计划记录图片信息
     * 
     * @param id app巡检计划记录图片主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointRecordImgById(String id);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/IArdAppPatrolpointRecordService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.service;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpointRecord;

/**
 * app巡检计划记录Service接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface IArdAppPatrolpointRecordService 
{
    /**
     * æŸ¥è¯¢app巡检计划记录
     * 
     * @param id app巡检计划记录主键
     * @return app巡检计划记录
     */
    public ArdAppPatrolpointRecord selectArdAppPatrolpointRecordById(String id);

    /**
     * æŸ¥è¯¢app巡检计划记录列表
     * 
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return app巡检计划记录集合
     */
    public List<ArdAppPatrolpointRecord> selectArdAppPatrolpointRecordList(ArdAppPatrolpointRecord ardAppPatrolpointRecord);

    /**
     * æ–°å¢žapp巡检计划记录
     * 
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return ç»“æžœ
     */
    public int insertArdAppPatrolpointRecord(ArdAppPatrolpointRecord ardAppPatrolpointRecord);

    /**
     * ä¿®æ”¹app巡检计划记录
     * 
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return ç»“æžœ
     */
    public int updateArdAppPatrolpointRecord(ArdAppPatrolpointRecord ardAppPatrolpointRecord);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划记录
     * 
     * @param ids éœ€è¦åˆ é™¤çš„app巡检计划记录主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointRecordByIds(String[] ids);

    /**
     * åˆ é™¤app巡检计划记录信息
     * 
     * @param id app巡检计划记录主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointRecordById(String id);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/IArdAppPatrolpointService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.service;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpoint;

/**
 * app巡检计划点位Service接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface IArdAppPatrolpointService 
{
    /**
     * æŸ¥è¯¢app巡检计划点位
     * 
     * @param id app巡检计划点位主键
     * @return app巡检计划点位
     */
    public ArdAppPatrolpoint selectArdAppPatrolpointById(String id);

    /**
     * æŸ¥è¯¢app巡检计划点位列表
     * 
     * @param ardAppPatrolpoint app巡检计划点位
     * @return app巡检计划点位集合
     */
    public List<ArdAppPatrolpoint> selectArdAppPatrolpointList(ArdAppPatrolpoint ardAppPatrolpoint);

    /**
     * æ–°å¢žapp巡检计划点位
     * 
     * @param ardAppPatrolpoint app巡检计划点位
     * @return ç»“æžœ
     */
    public int insertArdAppPatrolpoint(ArdAppPatrolpoint ardAppPatrolpoint);

    /**
     * ä¿®æ”¹app巡检计划点位
     * 
     * @param ardAppPatrolpoint app巡检计划点位
     * @return ç»“æžœ
     */
    public int updateArdAppPatrolpoint(ArdAppPatrolpoint ardAppPatrolpoint);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划点位
     * 
     * @param ids éœ€è¦åˆ é™¤çš„app巡检计划点位主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointByIds(String[] ids);

    /**
     * åˆ é™¤app巡检计划点位信息
     * 
     * @param id app巡检计划点位主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatrolpointById(String id);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/IArdAppPatroluserService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,61 @@
package com.ruoyi.app.patrolplan.service;

import java.util.List;
import com.ruoyi.app.patrolplan.domain.ArdAppPatroluser;

/**
 * app巡检计划人员Service接口
 * 
 * @author ard
 * @date 2023-08-02
 */
public interface IArdAppPatroluserService 
{
    /**
     * æŸ¥è¯¢app巡检计划人员
     * 
     * @param reserved1 app巡检计划人员主键
     * @return app巡检计划人员
     */
    public ArdAppPatroluser selectArdAppPatroluserByReserved1(String reserved1);

    /**
     * æŸ¥è¯¢app巡检计划人员列表
     * 
     * @param ardAppPatroluser app巡检计划人员
     * @return app巡检计划人员集合
     */
    public List<ArdAppPatroluser> selectArdAppPatroluserList(ArdAppPatroluser ardAppPatroluser);

    /**
     * æ–°å¢žapp巡检计划人员
     * 
     * @param ardAppPatroluser app巡检计划人员
     * @return ç»“æžœ
     */
    public int insertArdAppPatroluser(ArdAppPatroluser ardAppPatroluser);

    /**
     * ä¿®æ”¹app巡检计划人员
     * 
     * @param ardAppPatroluser app巡检计划人员
     * @return ç»“æžœ
     */
    public int updateArdAppPatroluser(ArdAppPatroluser ardAppPatroluser);

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划人员
     * 
     * @param reserved1s éœ€è¦åˆ é™¤çš„app巡检计划人员主键集合
     * @return ç»“æžœ
     */
    public int deleteArdAppPatroluserByReserved1s(String[] reserved1s);

    /**
     * åˆ é™¤app巡检计划人员信息
     * 
     * @param reserved1 app巡检计划人员主键
     * @return ç»“æžœ
     */
    public int deleteArdAppPatroluserByReserved1(String reserved1);
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolplanServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,93 @@
package com.ruoyi.app.patrolplan.service.impl;

import java.util.List;
        import com.ruoyi.common.utils.DateUtils;

import com.ruoyi.common.utils.SecurityUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.app.patrolplan.mapper.ArdAppPatrolplanMapper;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolplan;
import com.ruoyi.app.patrolplan.service.IArdAppPatrolplanService;

import javax.annotation.Resource;

/**
 * app巡检计划Service业务层处理
 *
 * @author ard
 * @date 2023-08-02
 */
@Service
public class ArdAppPatrolplanServiceImpl implements IArdAppPatrolplanService {
    @Resource
    private ArdAppPatrolplanMapper ardAppPatrolplanMapper;

    /**
     * æŸ¥è¯¢app巡检计划
     *
     * @param patroEndTime app巡检计划主键
     * @return app巡检计划
     */
    @Override
    public ArdAppPatrolplan selectArdAppPatrolplanByPatroEndTime(String patroEndTime) {
        return ardAppPatrolplanMapper.selectArdAppPatrolplanByPatroEndTime(patroEndTime);
    }

    /**
     * æŸ¥è¯¢app巡检计划列表
     *
     * @param ardAppPatrolplan app巡检计划
     * @return app巡检计划
     */
    @Override
    public List<ArdAppPatrolplan> selectArdAppPatrolplanList(ArdAppPatrolplan ardAppPatrolplan) {
        return ardAppPatrolplanMapper.selectArdAppPatrolplanList(ardAppPatrolplan);
    }

    /**
     * æ–°å¢žapp巡检计划
     *
     * @param ardAppPatrolplan app巡检计划
     * @return ç»“æžœ
     */
    @Override
    public int insertArdAppPatrolplan(ArdAppPatrolplan ardAppPatrolplan) {
                ardAppPatrolplan.setUserId(SecurityUtils.getUserId());
                ardAppPatrolplan.setCreateTime(DateUtils.getNowDate());
            return ardAppPatrolplanMapper.insertArdAppPatrolplan(ardAppPatrolplan);
    }

    /**
     * ä¿®æ”¹app巡检计划
     *
     * @param ardAppPatrolplan app巡检计划
     * @return ç»“æžœ
     */
    @Override
    public int updateArdAppPatrolplan(ArdAppPatrolplan ardAppPatrolplan) {
        return ardAppPatrolplanMapper.updateArdAppPatrolplan(ardAppPatrolplan);
    }

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划
     *
     * @param patroEndTimes éœ€è¦åˆ é™¤çš„app巡检计划主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatrolplanByPatroEndTimes(String[] patroEndTimes) {
        return ardAppPatrolplanMapper.deleteArdAppPatrolplanByPatroEndTimes(patroEndTimes);
    }

    /**
     * åˆ é™¤app巡检计划信息
     *
     * @param patroEndTime app巡检计划主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatrolplanByPatroEndTime(String patroEndTime) {
        return ardAppPatrolplanMapper.deleteArdAppPatrolplanByPatroEndTime(patroEndTime);
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolpointRecordImgServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,89 @@
package com.ruoyi.app.patrolplan.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.app.patrolplan.mapper.ArdAppPatrolpointRecordImgMapper;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpointRecordImg;
import com.ruoyi.app.patrolplan.service.IArdAppPatrolpointRecordImgService;

import javax.annotation.Resource;

/**
 * app巡检计划记录图片Service业务层处理
 *
 * @author ard
 * @date 2023-08-02
 */
@Service
public class ArdAppPatrolpointRecordImgServiceImpl implements IArdAppPatrolpointRecordImgService {
    @Resource
    private ArdAppPatrolpointRecordImgMapper ardAppPatrolpointRecordImgMapper;

    /**
     * æŸ¥è¯¢app巡检计划记录图片
     *
     * @param id app巡检计划记录图片主键
     * @return app巡检计划记录图片
     */
    @Override
    public ArdAppPatrolpointRecordImg selectArdAppPatrolpointRecordImgById(String id) {
        return ardAppPatrolpointRecordImgMapper.selectArdAppPatrolpointRecordImgById(id);
    }

    /**
     * æŸ¥è¯¢app巡检计划记录图片列表
     *
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return app巡检计划记录图片
     */
    @Override
    public List<ArdAppPatrolpointRecordImg> selectArdAppPatrolpointRecordImgList(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg) {
        return ardAppPatrolpointRecordImgMapper.selectArdAppPatrolpointRecordImgList(ardAppPatrolpointRecordImg);
    }

    /**
     * æ–°å¢žapp巡检计划记录图片
     *
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return ç»“æžœ
     */
    @Override
    public int insertArdAppPatrolpointRecordImg(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg) {
            return ardAppPatrolpointRecordImgMapper.insertArdAppPatrolpointRecordImg(ardAppPatrolpointRecordImg);
    }

    /**
     * ä¿®æ”¹app巡检计划记录图片
     *
     * @param ardAppPatrolpointRecordImg app巡检计划记录图片
     * @return ç»“æžœ
     */
    @Override
    public int updateArdAppPatrolpointRecordImg(ArdAppPatrolpointRecordImg ardAppPatrolpointRecordImg) {
        return ardAppPatrolpointRecordImgMapper.updateArdAppPatrolpointRecordImg(ardAppPatrolpointRecordImg);
    }

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划记录图片
     *
     * @param ids éœ€è¦åˆ é™¤çš„app巡检计划记录图片主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatrolpointRecordImgByIds(String[] ids) {
        return ardAppPatrolpointRecordImgMapper.deleteArdAppPatrolpointRecordImgByIds(ids);
    }

    /**
     * åˆ é™¤app巡检计划记录图片信息
     *
     * @param id app巡检计划记录图片主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatrolpointRecordImgById(String id) {
        return ardAppPatrolpointRecordImgMapper.deleteArdAppPatrolpointRecordImgById(id);
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolpointRecordServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,91 @@
package com.ruoyi.app.patrolplan.service.impl;

import java.util.List;

import com.ruoyi.common.utils.SecurityUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.app.patrolplan.mapper.ArdAppPatrolpointRecordMapper;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpointRecord;
import com.ruoyi.app.patrolplan.service.IArdAppPatrolpointRecordService;

import javax.annotation.Resource;

/**
 * app巡检计划记录Service业务层处理
 *
 * @author ard
 * @date 2023-08-02
 */
@Service
public class ArdAppPatrolpointRecordServiceImpl implements IArdAppPatrolpointRecordService {
    @Resource
    private ArdAppPatrolpointRecordMapper ardAppPatrolpointRecordMapper;

    /**
     * æŸ¥è¯¢app巡检计划记录
     *
     * @param id app巡检计划记录主键
     * @return app巡检计划记录
     */
    @Override
    public ArdAppPatrolpointRecord selectArdAppPatrolpointRecordById(String id) {
        return ardAppPatrolpointRecordMapper.selectArdAppPatrolpointRecordById(id);
    }

    /**
     * æŸ¥è¯¢app巡检计划记录列表
     *
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return app巡检计划记录
     */
    @Override
    public List<ArdAppPatrolpointRecord> selectArdAppPatrolpointRecordList(ArdAppPatrolpointRecord ardAppPatrolpointRecord) {
        return ardAppPatrolpointRecordMapper.selectArdAppPatrolpointRecordList(ardAppPatrolpointRecord);
    }

    /**
     * æ–°å¢žapp巡检计划记录
     *
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return ç»“æžœ
     */
    @Override
    public int insertArdAppPatrolpointRecord(ArdAppPatrolpointRecord ardAppPatrolpointRecord) {
                ardAppPatrolpointRecord.setUserId(SecurityUtils.getUserId());
            return ardAppPatrolpointRecordMapper.insertArdAppPatrolpointRecord(ardAppPatrolpointRecord);
    }

    /**
     * ä¿®æ”¹app巡检计划记录
     *
     * @param ardAppPatrolpointRecord app巡检计划记录
     * @return ç»“æžœ
     */
    @Override
    public int updateArdAppPatrolpointRecord(ArdAppPatrolpointRecord ardAppPatrolpointRecord) {
        return ardAppPatrolpointRecordMapper.updateArdAppPatrolpointRecord(ardAppPatrolpointRecord);
    }

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划记录
     *
     * @param ids éœ€è¦åˆ é™¤çš„app巡检计划记录主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatrolpointRecordByIds(String[] ids) {
        return ardAppPatrolpointRecordMapper.deleteArdAppPatrolpointRecordByIds(ids);
    }

    /**
     * åˆ é™¤app巡检计划记录信息
     *
     * @param id app巡检计划记录主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatrolpointRecordById(String id) {
        return ardAppPatrolpointRecordMapper.deleteArdAppPatrolpointRecordById(id);
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatrolpointServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,89 @@
package com.ruoyi.app.patrolplan.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.app.patrolplan.mapper.ArdAppPatrolpointMapper;
import com.ruoyi.app.patrolplan.domain.ArdAppPatrolpoint;
import com.ruoyi.app.patrolplan.service.IArdAppPatrolpointService;

import javax.annotation.Resource;

/**
 * app巡检计划点位Service业务层处理
 *
 * @author ard
 * @date 2023-08-02
 */
@Service
public class ArdAppPatrolpointServiceImpl implements IArdAppPatrolpointService {
    @Resource
    private ArdAppPatrolpointMapper ardAppPatrolpointMapper;

    /**
     * æŸ¥è¯¢app巡检计划点位
     *
     * @param id app巡检计划点位主键
     * @return app巡检计划点位
     */
    @Override
    public ArdAppPatrolpoint selectArdAppPatrolpointById(String id) {
        return ardAppPatrolpointMapper.selectArdAppPatrolpointById(id);
    }

    /**
     * æŸ¥è¯¢app巡检计划点位列表
     *
     * @param ardAppPatrolpoint app巡检计划点位
     * @return app巡检计划点位
     */
    @Override
    public List<ArdAppPatrolpoint> selectArdAppPatrolpointList(ArdAppPatrolpoint ardAppPatrolpoint) {
        return ardAppPatrolpointMapper.selectArdAppPatrolpointList(ardAppPatrolpoint);
    }

    /**
     * æ–°å¢žapp巡检计划点位
     *
     * @param ardAppPatrolpoint app巡检计划点位
     * @return ç»“æžœ
     */
    @Override
    public int insertArdAppPatrolpoint(ArdAppPatrolpoint ardAppPatrolpoint) {
            return ardAppPatrolpointMapper.insertArdAppPatrolpoint(ardAppPatrolpoint);
    }

    /**
     * ä¿®æ”¹app巡检计划点位
     *
     * @param ardAppPatrolpoint app巡检计划点位
     * @return ç»“æžœ
     */
    @Override
    public int updateArdAppPatrolpoint(ArdAppPatrolpoint ardAppPatrolpoint) {
        return ardAppPatrolpointMapper.updateArdAppPatrolpoint(ardAppPatrolpoint);
    }

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划点位
     *
     * @param ids éœ€è¦åˆ é™¤çš„app巡检计划点位主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatrolpointByIds(String[] ids) {
        return ardAppPatrolpointMapper.deleteArdAppPatrolpointByIds(ids);
    }

    /**
     * åˆ é™¤app巡检计划点位信息
     *
     * @param id app巡检计划点位主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatrolpointById(String id) {
        return ardAppPatrolpointMapper.deleteArdAppPatrolpointById(id);
    }
}

 ard-work/src/main/java/com/ruoyi/app/patrolplan/service/impl/ArdAppPatroluserServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,89 @@
package com.ruoyi.app.patrolplan.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.app.patrolplan.mapper.ArdAppPatroluserMapper;
import com.ruoyi.app.patrolplan.domain.ArdAppPatroluser;
import com.ruoyi.app.patrolplan.service.IArdAppPatroluserService;

import javax.annotation.Resource;

/**
 * app巡检计划人员Service业务层处理
 *
 * @author ard
 * @date 2023-08-02
 */
@Service
public class ArdAppPatroluserServiceImpl implements IArdAppPatroluserService {
    @Resource
    private ArdAppPatroluserMapper ardAppPatroluserMapper;

    /**
     * æŸ¥è¯¢app巡检计划人员
     *
     * @param reserved1 app巡检计划人员主键
     * @return app巡检计划人员
     */
    @Override
    public ArdAppPatroluser selectArdAppPatroluserByReserved1(String reserved1) {
        return ardAppPatroluserMapper.selectArdAppPatroluserByReserved1(reserved1);
    }

    /**
     * æŸ¥è¯¢app巡检计划人员列表
     *
     * @param ardAppPatroluser app巡检计划人员
     * @return app巡检计划人员
     */
    @Override
    public List<ArdAppPatroluser> selectArdAppPatroluserList(ArdAppPatroluser ardAppPatroluser) {
        return ardAppPatroluserMapper.selectArdAppPatroluserList(ardAppPatroluser);
    }

    /**
     * æ–°å¢žapp巡检计划人员
     *
     * @param ardAppPatroluser app巡检计划人员
     * @return ç»“æžœ
     */
    @Override
    public int insertArdAppPatroluser(ArdAppPatroluser ardAppPatroluser) {
            return ardAppPatroluserMapper.insertArdAppPatroluser(ardAppPatroluser);
    }

    /**
     * ä¿®æ”¹app巡检计划人员
     *
     * @param ardAppPatroluser app巡检计划人员
     * @return ç»“æžœ
     */
    @Override
    public int updateArdAppPatroluser(ArdAppPatroluser ardAppPatroluser) {
        return ardAppPatroluserMapper.updateArdAppPatroluser(ardAppPatroluser);
    }

    /**
     * æ‰¹é‡åˆ é™¤app巡检计划人员
     *
     * @param reserved1s éœ€è¦åˆ é™¤çš„app巡检计划人员主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatroluserByReserved1s(String[] reserved1s) {
        return ardAppPatroluserMapper.deleteArdAppPatroluserByReserved1s(reserved1s);
    }

    /**
     * åˆ é™¤app巡检计划人员信息
     *
     * @param reserved1 app巡检计划人员主键
     * @return ç»“æžœ
     */
    @Override
    public int deleteArdAppPatroluserByReserved1(String reserved1) {
        return ardAppPatroluserMapper.deleteArdAppPatroluserByReserved1(reserved1);
    }
}

 ard-work/src/main/resources/mapper/app/ArdAppPatrolplanMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,82 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.app.patrolplan.mapper.ArdAppPatrolplanMapper">
    
    <resultMap type="ArdAppPatrolplan" id="ArdAppPatrolplanResult">
        <result property="patroEndTime"    column="patro_end_time"    />
        <result property="userId"    column="user_id"    />
        <result property="cycle"    column="cycle"    />
        <result property="createTime"    column="create_time"    />
        <result property="id"    column="id"    />
        <result property="planName"    column="plan_name"    />
        <result property="patroBeginTime"    column="patro_begin_time"    />
    </resultMap>

    <sql id="selectArdAppPatrolplanVo">
        select patro_end_time, user_id, cycle, create_time, id, plan_name, patro_begin_time from ard_app_patrolplan
    </sql>

    <select id="selectArdAppPatrolplanList" parameterType="ArdAppPatrolplan" resultMap="ArdAppPatrolplanResult">
        <include refid="selectArdAppPatrolplanVo"/>
        <where>  
            <if test="patroEndTime != null  and patroEndTime != ''"> and patro_end_time = #{patroEndTime}</if>
            <if test="userId != null  and userId != ''"> and user_id = #{userId}</if>
            <if test="cycle != null  and cycle != ''"> and cycle = #{cycle}</if>
            <if test="planName != null  and planName != ''"> and plan_name like '%'||#{planName}||'%'</if>
            <if test="patroBeginTime != null  and patroBeginTime != ''"> and patro_begin_time = #{patroBeginTime}</if>
        </where>
    </select>
    
    <select id="selectArdAppPatrolplanByPatroEndTime" parameterType="String" resultMap="ArdAppPatrolplanResult">
        <include refid="selectArdAppPatrolplanVo"/>
        where patro_end_time = #{patroEndTime}
    </select>
        
    <insert id="insertArdAppPatrolplan" parameterType="ArdAppPatrolplan">
        insert into ard_app_patrolplan
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="patroEndTime != null">patro_end_time,</if>
            <if test="userId != null">user_id,</if>
            <if test="cycle != null">cycle,</if>
            <if test="createTime != null">create_time,</if>
            <if test="id != null">id,</if>
            <if test="planName != null">plan_name,</if>
            <if test="patroBeginTime != null">patro_begin_time,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="patroEndTime != null">#{patroEndTime},</if>
            <if test="userId != null">#{userId},</if>
            <if test="cycle != null">#{cycle},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="id != null">#{id},</if>
            <if test="planName != null">#{planName},</if>
            <if test="patroBeginTime != null">#{patroBeginTime},</if>
         </trim>
    </insert>

    <update id="updateArdAppPatrolplan" parameterType="ArdAppPatrolplan">
        update ard_app_patrolplan
        <trim prefix="SET" suffixOverrides=",">
            <if test="userId != null">user_id = #{userId},</if>
            <if test="cycle != null">cycle = #{cycle},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="id != null">id = #{id},</if>
            <if test="planName != null">plan_name = #{planName},</if>
            <if test="patroBeginTime != null">patro_begin_time = #{patroBeginTime},</if>
        </trim>
        where patro_end_time = #{patroEndTime}
    </update>

    <delete id="deleteArdAppPatrolplanByPatroEndTime" parameterType="String">
        delete from ard_app_patrolplan where patro_end_time = #{patroEndTime}
    </delete>

    <delete id="deleteArdAppPatrolplanByPatroEndTimes" parameterType="String">
        delete from ard_app_patrolplan where patro_end_time in 
        <foreach item="patroEndTime" collection="array" open="(" separator="," close=")">
            #{patroEndTime}
        </foreach>
    </delete>
</mapper>

 ard-work/src/main/resources/mapper/app/ArdAppPatrolpointMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,68 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.app.patrolplan.mapper.ArdAppPatrolpointMapper">
    
    <resultMap type="ArdAppPatrolpoint" id="ArdAppPatrolpointResult">
        <result property="id"    column="id"    />
        <result property="patrolplanId"    column="patrolplan_id"    />
        <result property="alarmpointsId"    column="alarmpoints_id"    />
        <result property="type"    column="type"    />
    </resultMap>

    <sql id="selectArdAppPatrolpointVo">
        select id, patrolplan_id, alarmpoints_id, type from ard_app_patrolpoint
    </sql>

    <select id="selectArdAppPatrolpointList" parameterType="ArdAppPatrolpoint" resultMap="ArdAppPatrolpointResult">
        <include refid="selectArdAppPatrolpointVo"/>
        <where>  
            <if test="patrolplanId != null  and patrolplanId != ''"> and patrolplan_id = #{patrolplanId}</if>
            <if test="alarmpointsId != null  and alarmpointsId != ''"> and alarmpoints_id = #{alarmpointsId}</if>
            <if test="type != null  and type != ''"> and type = #{type}</if>
        </where>
    </select>
    
    <select id="selectArdAppPatrolpointById" parameterType="String" resultMap="ArdAppPatrolpointResult">
        <include refid="selectArdAppPatrolpointVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertArdAppPatrolpoint" parameterType="ArdAppPatrolpoint">
        insert into ard_app_patrolpoint
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="patrolplanId != null">patrolplan_id,</if>
            <if test="alarmpointsId != null">alarmpoints_id,</if>
            <if test="type != null">type,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="patrolplanId != null">#{patrolplanId},</if>
            <if test="alarmpointsId != null">#{alarmpointsId},</if>
            <if test="type != null">#{type},</if>
         </trim>
    </insert>

    <update id="updateArdAppPatrolpoint" parameterType="ArdAppPatrolpoint">
        update ard_app_patrolpoint
        <trim prefix="SET" suffixOverrides=",">
            <if test="patrolplanId != null">patrolplan_id = #{patrolplanId},</if>
            <if test="alarmpointsId != null">alarmpoints_id = #{alarmpointsId},</if>
            <if test="type != null">type = #{type},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteArdAppPatrolpointById" parameterType="String">
        delete from ard_app_patrolpoint where id = #{id}
    </delete>

    <delete id="deleteArdAppPatrolpointByIds" parameterType="String">
        delete from ard_app_patrolpoint where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 ard-work/src/main/resources/mapper/app/ArdAppPatrolpointRecordImgMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,63 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.app.patrolplan.mapper.ArdAppPatrolpointRecordImgMapper">
    
    <resultMap type="ArdAppPatrolpointRecordImg" id="ArdAppPatrolpointRecordImgResult">
        <result property="id"    column="id"    />
        <result property="appPatrolponitRecordId"    column="app_patrolponit_record_id"    />
        <result property="img"    column="img"    />
    </resultMap>

    <sql id="selectArdAppPatrolpointRecordImgVo">
        select id, app_patrolponit_record_id, img from ard_app_patrolpoint_record_img
    </sql>

    <select id="selectArdAppPatrolpointRecordImgList" parameterType="ArdAppPatrolpointRecordImg" resultMap="ArdAppPatrolpointRecordImgResult">
        <include refid="selectArdAppPatrolpointRecordImgVo"/>
        <where>  
            <if test="appPatrolponitRecordId != null  and appPatrolponitRecordId != ''"> and app_patrolponit_record_id = #{appPatrolponitRecordId}</if>
            <if test="img != null  and img != ''"> and img = #{img}</if>
        </where>
    </select>
    
    <select id="selectArdAppPatrolpointRecordImgById" parameterType="String" resultMap="ArdAppPatrolpointRecordImgResult">
        <include refid="selectArdAppPatrolpointRecordImgVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertArdAppPatrolpointRecordImg" parameterType="ArdAppPatrolpointRecordImg">
        insert into ard_app_patrolpoint_record_img
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="appPatrolponitRecordId != null">app_patrolponit_record_id,</if>
            <if test="img != null">img,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="appPatrolponitRecordId != null">#{appPatrolponitRecordId},</if>
            <if test="img != null">#{img},</if>
         </trim>
    </insert>

    <update id="updateArdAppPatrolpointRecordImg" parameterType="ArdAppPatrolpointRecordImg">
        update ard_app_patrolpoint_record_img
        <trim prefix="SET" suffixOverrides=",">
            <if test="appPatrolponitRecordId != null">app_patrolponit_record_id = #{appPatrolponitRecordId},</if>
            <if test="img != null">img = #{img},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteArdAppPatrolpointRecordImgById" parameterType="String">
        delete from ard_app_patrolpoint_record_img where id = #{id}
    </delete>

    <delete id="deleteArdAppPatrolpointRecordImgByIds" parameterType="String">
        delete from ard_app_patrolpoint_record_img where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 ard-work/src/main/resources/mapper/app/ArdAppPatrolpointRecordMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,82 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.app.patrolplan.mapper.ArdAppPatrolpointRecordMapper">
    
    <resultMap type="ArdAppPatrolpointRecord" id="ArdAppPatrolpointRecordResult">
        <result property="id"    column="id"    />
        <result property="remark"    column="remark"    />
        <result property="longitude"    column="longitude"    />
        <result property="latitude"    column="latitude"    />
        <result property="userId"    column="user_id"    />
        <result property="recordTime"    column="record_time"    />
        <result property="appPatrolpointsId"    column="app_patrolpoints_id"    />
    </resultMap>

    <sql id="selectArdAppPatrolpointRecordVo">
        select id, remark, longitude, latitude, user_id, record_time, app_patrolpoints_id from ard_app_patrolpoint_record
    </sql>

    <select id="selectArdAppPatrolpointRecordList" parameterType="ArdAppPatrolpointRecord" resultMap="ArdAppPatrolpointRecordResult">
        <include refid="selectArdAppPatrolpointRecordVo"/>
        <where>  
            <if test="longitude != null  and longitude != ''"> and longitude = #{longitude}</if>
            <if test="latitude != null  and latitude != ''"> and latitude = #{latitude}</if>
            <if test="userId != null  and userId != ''"> and user_id = #{userId}</if>
            <if test="recordTime != null  and recordTime != ''"> and record_time = #{recordTime}</if>
            <if test="appPatrolpointsId != null  and appPatrolpointsId != ''"> and app_patrolpoints_id = #{appPatrolpointsId}</if>
        </where>
    </select>
    
    <select id="selectArdAppPatrolpointRecordById" parameterType="String" resultMap="ArdAppPatrolpointRecordResult">
        <include refid="selectArdAppPatrolpointRecordVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertArdAppPatrolpointRecord" parameterType="ArdAppPatrolpointRecord">
        insert into ard_app_patrolpoint_record
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="remark != null">remark,</if>
            <if test="longitude != null">longitude,</if>
            <if test="latitude != null">latitude,</if>
            <if test="userId != null">user_id,</if>
            <if test="recordTime != null">record_time,</if>
            <if test="appPatrolpointsId != null">app_patrolpoints_id,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="remark != null">#{remark},</if>
            <if test="longitude != null">#{longitude},</if>
            <if test="latitude != null">#{latitude},</if>
            <if test="userId != null">#{userId},</if>
            <if test="recordTime != null">#{recordTime},</if>
            <if test="appPatrolpointsId != null">#{appPatrolpointsId},</if>
         </trim>
    </insert>

    <update id="updateArdAppPatrolpointRecord" parameterType="ArdAppPatrolpointRecord">
        update ard_app_patrolpoint_record
        <trim prefix="SET" suffixOverrides=",">
            <if test="remark != null">remark = #{remark},</if>
            <if test="longitude != null">longitude = #{longitude},</if>
            <if test="latitude != null">latitude = #{latitude},</if>
            <if test="userId != null">user_id = #{userId},</if>
            <if test="recordTime != null">record_time = #{recordTime},</if>
            <if test="appPatrolpointsId != null">app_patrolpoints_id = #{appPatrolpointsId},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteArdAppPatrolpointRecordById" parameterType="String">
        delete from ard_app_patrolpoint_record where id = #{id}
    </delete>

    <delete id="deleteArdAppPatrolpointRecordByIds" parameterType="String">
        delete from ard_app_patrolpoint_record where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 ard-work/src/main/resources/mapper/app/ArdAppPatroluserMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,64 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.app.patrolplan.mapper.ArdAppPatroluserMapper">
    
    <resultMap type="ArdAppPatroluser" id="ArdAppPatroluserResult">
        <result property="reserved1"    column="reserved_1"    />
        <result property="patrolplanId"    column="patrolplan_id"    />
        <result property="appUserId"    column="app_user_id"    />
    </resultMap>

    <sql id="selectArdAppPatroluserVo">
        select reserved_1, patrolplan_id, app_user_id from ard_app_patroluser
    </sql>

    <select id="selectArdAppPatroluserList" parameterType="ArdAppPatroluser" resultMap="ArdAppPatroluserResult">
        <include refid="selectArdAppPatroluserVo"/>
        <where>  
            <if test="reserved1 != null  and reserved1 != ''"> and reserved_1 = #{reserved1}</if>
            <if test="patrolplanId != null  and patrolplanId != ''"> and patrolplan_id = #{patrolplanId}</if>
            <if test="appUserId != null  and appUserId != ''"> and app_user_id = #{appUserId}</if>
        </where>
    </select>
    
    <select id="selectArdAppPatroluserByReserved1" parameterType="String" resultMap="ArdAppPatroluserResult">
        <include refid="selectArdAppPatroluserVo"/>
        where reserved_1 = #{reserved1}
    </select>
        
    <insert id="insertArdAppPatroluser" parameterType="ArdAppPatroluser">
        insert into ard_app_patroluser
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="reserved1 != null">reserved_1,</if>
            <if test="patrolplanId != null">patrolplan_id,</if>
            <if test="appUserId != null">app_user_id,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="reserved1 != null">#{reserved1},</if>
            <if test="patrolplanId != null">#{patrolplanId},</if>
            <if test="appUserId != null">#{appUserId},</if>
         </trim>
    </insert>

    <update id="updateArdAppPatroluser" parameterType="ArdAppPatroluser">
        update ard_app_patroluser
        <trim prefix="SET" suffixOverrides=",">
            <if test="patrolplanId != null">patrolplan_id = #{patrolplanId},</if>
            <if test="appUserId != null">app_user_id = #{appUserId},</if>
        </trim>
        where reserved_1 = #{reserved1}
    </update>

    <delete id="deleteArdAppPatroluserByReserved1" parameterType="String">
        delete from ard_app_patroluser where reserved_1 = #{reserved1}
    </delete>

    <delete id="deleteArdAppPatroluserByReserved1s" parameterType="String">
        delete from ard_app_patroluser where reserved_1 in 
        <foreach item="reserved1" collection="array" open="(" separator="," close=")">
            #{reserved1}
        </foreach>
    </delete>
</mapper>