From c6f2db6574928d1ddd26a74308d41a7890802dae Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Thu, 30 Mar 2023 15:50:19 +0800
Subject: [PATCH] 巡查路线基础接口新增
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.java | 22 +++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/IPatrolRouteService.java | 19 ++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/controller/PatrolRouteController.java | 112 ++++++++++++++++++++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/entity/PatrolRoute.java | 44 +++++++++++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.xml | 15 +++
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/impl/PatrolRouteServiceImpl.java | 26 ++++++
6 files changed, 238 insertions(+), 0 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/controller/PatrolRouteController.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/controller/PatrolRouteController.java
new file mode 100644
index 0000000..dc0b361
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/controller/PatrolRouteController.java
@@ -0,0 +1,112 @@
+package cn.gistack.sm.patrol.controller;
+
+import cn.gistack.sm.patrol.entity.PatrolRoute;
+import cn.gistack.sm.patrol.service.IPatrolRouteService;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.AllArgsConstructor;
+import lombok.extern.slf4j.Slf4j;
+import org.springblade.core.boot.ctrl.BladeController;
+import org.springblade.core.mp.support.Condition;
+import org.springblade.core.mp.support.Query;
+import org.springblade.core.tool.api.R;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.Arrays;
+
+/**
+* @Description: 巡查路线
+*/
+@Slf4j
+@Api(tags="巡查路线")
+@RestController
+@RequestMapping("/patrol/patrolRoute")
+@AllArgsConstructor
+public class PatrolRouteController extends BladeController {
+
+ private IPatrolRouteService patrolRouteService;
+
+ /**
+ * 分页列表查询
+ */
+ @ApiOperation(value="巡查路线-分页列表查询", notes="巡查路线-分页列表查询")
+ @GetMapping(value = "/list")
+ public R<IPage<PatrolRoute>> queryPageList(PatrolRoute patrolRoute,Query query) {
+ IPage<PatrolRoute> pageList = patrolRouteService.page(Condition.getPage(query), Condition.getQueryWrapper(patrolRoute));
+ return R.data(pageList);
+ }
+
+ /**
+ * 自定义分页列表查询
+ */
+ @ApiOperation(value="巡查路线-自定义分页列表查询", notes="巡查路线-自定义分页列表查询")
+ @GetMapping(value = "/page")
+ public R<IPage<PatrolRoute>> getPage(PatrolRoute patrolRoute,Query query) {
+ IPage<PatrolRoute> pageList = patrolRouteService.selectPatrolRoute(Condition.getPage(query),patrolRoute);
+ return R.data(pageList);
+ }
+
+ /**
+ * 添加
+ *
+ * @param patrolRoute
+ * @return
+ */
+ @ApiOperation(value="巡查路线-添加", notes="巡查路线-添加")
+ @PostMapping(value = "/add")
+ public R add(@RequestBody PatrolRoute patrolRoute) {
+ return R.data(patrolRouteService.save(patrolRoute));
+ }
+
+ /**
+ * 编辑
+ *
+ * @param patrolRoute
+ * @return
+ */
+ @ApiOperation(value="巡查路线-编辑", notes="巡查路线-编辑")
+ @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
+ public R edit(@RequestBody PatrolRoute patrolRoute) {
+ return R.data(patrolRouteService.updateById(patrolRoute));
+ }
+
+ /**
+ * 通过id删除
+ *
+ * @param id
+ * @return
+ */
+ @ApiOperation(value="巡查路线-通过id删除", notes="巡查路线-通过id删除")
+ @DeleteMapping(value = "/delete")
+ public R delete(@RequestParam(name="id",required=true) String id) {
+ patrolRouteService.removeById(id);
+ return R.data(patrolRouteService.removeById(id));
+ }
+
+ /**
+ * 批量删除
+ *
+ * @param ids
+ * @return
+ */
+ @ApiOperation(value="巡查路线-批量删除", notes="巡查路线-批量删除")
+ @PostMapping(value = "/deleteBatch")
+ public R deleteBatch(@RequestParam(name="ids",required=true) String ids) {
+ return R.data(this.patrolRouteService.removeByIds(Arrays.asList(ids.split(","))));
+ }
+
+ /**
+ * 通过id查询
+ *
+ * @param id
+ * @return
+ */
+ @ApiOperation(value="巡查路线-通过id查询", notes="巡查路线-通过id查询")
+ @GetMapping(value = "/queryById")
+ public R queryById(@RequestParam(name="id",required=true) String id) {
+ PatrolRoute patrolRoute = patrolRouteService.getById(id);
+ return R.data(patrolRoute);
+ }
+
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/entity/PatrolRoute.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/entity/PatrolRoute.java
new file mode 100644
index 0000000..e0aeb38
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/entity/PatrolRoute.java
@@ -0,0 +1,44 @@
+package cn.gistack.sm.patrol.entity;
+
+import com.baomidou.mybatisplus.annotation.TableName;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+import lombok.experimental.Accessors;
+import org.springblade.core.mp.base.BaseEntity;
+
+/**
+ * @author zhongrj
+ * @Description: 巡查路线
+ */
+@Data
+@TableName("sm_patrol_route")
+@EqualsAndHashCode(callSuper = false)
+@Accessors(chain = true)
+@ApiModel(value = "sm_patrol_route对象", description = "巡查设置")
+public class PatrolRoute extends BaseEntity {
+ /**
+ * 路线名称
+ */
+ @ApiModelProperty(value = "路线名称")
+ private String routeName;
+
+ /**
+ * 所属水库
+ */
+ @ApiModelProperty(value = "所属水库")
+ private String reservoirId;
+
+ /**
+ * 路线空间数据
+ */
+ @ApiModelProperty(value = "路线空间数据")
+ private String routeCoordinates;
+
+ /**
+ * 备注
+ */
+ @ApiModelProperty(value = "备注")
+ private String remark;
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.java
new file mode 100644
index 0000000..dbc25e5
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.java
@@ -0,0 +1,22 @@
+package cn.gistack.sm.patrol.mapper;
+
+import cn.gistack.sm.patrol.entity.PatrolRoute;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+
+/**
+ * @Description: 巡查路线
+ */
+public interface PatrolRouteMapper extends BaseMapper<PatrolRoute> {
+
+ /**
+ * 自定义分页查询
+ * @param page
+ * @param patrolRoute
+ * @return
+ */
+ List<PatrolRoute> selectPatrolRoute(IPage<PatrolRoute> page,@Param("patrolRoute") PatrolRoute patrolRoute);
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.xml b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.xml
new file mode 100644
index 0000000..ac710dc
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.xml
@@ -0,0 +1,15 @@
+<?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="cn.gistack.sm.patrol.mapper.PatrolRouteMapper">
+
+ <!--自定义分页查询-->
+ <select id="selectPatrolRoute" resultType="cn.gistack.sm.patrol.entity.PatrolRoute">
+ select * from sm_patrol_route where is_deleted = 0
+ <if test="patrolRoute.routeName!=null and patrolRoute.routeName!=''">
+ and route_name like concat(concat('%',#{patrolRoute.routeName}),'%')
+ </if>
+ <if test="patrolRoute.reservoirId!=null and patrolRoute.reservoirId!=''">
+ and reservoir_id like concat(concat('%',#{patrolRoute.reservoirId}),'%')
+ </if>
+ </select>
+</mapper>
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/IPatrolRouteService.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/IPatrolRouteService.java
new file mode 100644
index 0000000..14afb60
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/IPatrolRouteService.java
@@ -0,0 +1,19 @@
+package cn.gistack.sm.patrol.service;
+
+import cn.gistack.sm.patrol.entity.PatrolRoute;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.springblade.core.mp.base.BaseService;
+
+/**
+ * @Description: 巡查路线
+ */
+public interface IPatrolRouteService extends BaseService<PatrolRoute> {
+
+ /**
+ * 自定义分页查询
+ * @param page
+ * @param patrolRoute
+ * @return
+ */
+ IPage<PatrolRoute> selectPatrolRoute(IPage<PatrolRoute> page, PatrolRoute patrolRoute);
+}
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/impl/PatrolRouteServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/impl/PatrolRouteServiceImpl.java
new file mode 100644
index 0000000..2643787
--- /dev/null
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/impl/PatrolRouteServiceImpl.java
@@ -0,0 +1,26 @@
+package cn.gistack.sm.patrol.service.impl;
+
+import cn.gistack.sm.patrol.entity.PatrolRoute;
+import cn.gistack.sm.patrol.mapper.PatrolRouteMapper;
+import cn.gistack.sm.patrol.service.IPatrolRouteService;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.springblade.core.mp.base.BaseServiceImpl;
+import org.springframework.stereotype.Service;
+
+/**
+ * @Description: 巡查路线
+ */
+@Service
+public class PatrolRouteServiceImpl extends BaseServiceImpl<PatrolRouteMapper, PatrolRoute> implements IPatrolRouteService {
+
+ /**
+ * 自定义分页查询
+ * @param page
+ * @param patrolRoute
+ * @return
+ */
+ @Override
+ public IPage<PatrolRoute> selectPatrolRoute(IPage<PatrolRoute> page, PatrolRoute patrolRoute) {
+ return page.setRecords(baseMapper.selectPatrolRoute(page,patrolRoute));
+ }
+}
--
Gitblit v1.9.3