巡查路线基础接口新增

zhongrj

2023-03-30 c6f2db6574928d1ddd26a74308d41a7890802dae

巡查路线基础接口新增

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/controller/PatrolRouteController.java

New file
@@ -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);
   }

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/entity/PatrolRoute.java

New file
@@ -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;
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.java

New file
@@ -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);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolRouteMapper.xml

New file
@@ -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>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/IPatrolRouteService.java

New file
@@ -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);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/service/impl/PatrolRouteServiceImpl.java

New file
@@ -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));
    }
}