水知识基础接口新增

zhongrj

2023-09-12 7dec0338f9333877eb59a9f194a6d8b01cb43547

水知识基础接口新增

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/waterKnowledge/controller/WaterKnowledgeController.java

New file
@@ -0,0 +1,115 @@
package cn.gistack.sm.waterKnowledge.controller;


import cn.gistack.sm.waterKnowledge.entity.WaterKnowledge;
import cn.gistack.sm.waterKnowledge.service.WaterKnowledgeService;
import cn.gistack.sm.waterKnowledge.vo.WaterKnowledgeVO;
import com.baomidou.mybatisplus.core.metadata.IPage;
import io.swagger.annotations.ApiOperation;
import lombok.AllArgsConstructor;
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;

/**
 * 水知识控制层
 * @author zhongrj
 * @date 2023-05-29
 */
@RestController
@AllArgsConstructor
@RequestMapping("/waterKnowledge/waterKnowledge")
public class WaterKnowledgeController {

    private final WaterKnowledgeService waterKnowledgeService;

    /**
     * 分页列表查询
     *
     * @param waterKnowledge
     * @return
     */
    @ApiOperation(value="水知识-分页列表查询", notes="水知识-分页列表查询")
    @GetMapping(value = "/list")
    public R queryPageList(WaterKnowledge waterKnowledge, Query query) {
        IPage<WaterKnowledge> pageList = waterKnowledgeService.page(Condition.getPage(query), Condition.getQueryWrapper(waterKnowledge));
        return R.data(pageList);
    }

    /**
     * 自定义分页列表查询
     * @param query
     * @param waterKnowledge
     * @return
     */
    @ApiOperation(value="水知识-自定义分页列表查询", notes="水知识-自定义分页列表查询")
    @GetMapping(value = "/page")
    public R page(WaterKnowledgeVO waterKnowledge, Query query) {
        return R.data( waterKnowledgeService.selectWaterKnowledgePage(Condition.getPage(query),waterKnowledge));
    }

    /**
     * 添加
     *
     * @param waterKnowledge
     * @return
     */
    @ApiOperation(value="水知识-添加", notes="水知识-添加")
    @PostMapping(value = "/add")
    public R add(@RequestBody WaterKnowledge waterKnowledge) {
        return R.data(waterKnowledgeService.save(waterKnowledge));
    }

    /**
     * 编辑
     *
     * @param waterKnowledge
     * @return
     */
    @ApiOperation(value="水知识-编辑", notes="水知识-编辑")
    @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
    public R edit(@RequestBody WaterKnowledge waterKnowledge) {
        return R.data(waterKnowledgeService.updateById(waterKnowledge));
    }

    /**
     * 通过id删除
     *
     * @param id
     * @return
     */
    @ApiOperation(value="水知识-通过id删除", notes="水知识-通过id删除")
    @PostMapping(value = "/delete")
    public R delete(@RequestParam(name="id",required=true) String id) {
        return R.data(waterKnowledgeService.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.waterKnowledgeService.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) {
        WaterKnowledge waterKnowledge = waterKnowledgeService.getById(id);
        return R.data(waterKnowledge);
    }

}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/waterKnowledge/entity/WaterKnowledge.java

New file
@@ -0,0 +1,52 @@
package cn.gistack.sm.waterKnowledge.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

/**
 * 水知识
 *
 * @author zhongrj
 * @date 2023-09-12
 */
@Data
@TableName(value = "sm_water_knowledge")
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
public class WaterKnowledge {

    /**
     * id
     */
    @ApiModelProperty(value = "id")
    @TableId(value = "id",type = IdType.ASSIGN_ID)
    private Long id;

    /**
     * 标题
     */
    @ApiModelProperty(value = "标题")
    private String title;

    /**
     * 内容
     */
    @ApiModelProperty(value = "内容")
    private String content;

    /**
     * 创建时间
     */
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "创建时间")
    private Date createTime;
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/waterKnowledge/mapper/WaterKnowledgeMapper.java

New file
@@ -0,0 +1,26 @@
package cn.gistack.sm.waterKnowledge.mapper;


import cn.gistack.sm.waterKnowledge.entity.WaterKnowledge;
import cn.gistack.sm.waterKnowledge.vo.WaterKnowledgeVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 水知识详情mapper映射层
 * @author zhongrj
 * @date 2023-05-29
 */
public interface WaterKnowledgeMapper extends BaseMapper<WaterKnowledge> {

    /**
     * 自定义分页列表查询
     * @param page
     * @param waterKnowledge
     * @return
     */
    List<WaterKnowledgeVO> selectWaterKnowledgePage(IPage<WaterKnowledgeVO> page, @Param("waterKnowledge") WaterKnowledgeVO waterKnowledge);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/waterKnowledge/mapper/WaterKnowledgeMapper.xml

New file
@@ -0,0 +1,14 @@
<?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.waterKnowledge.mapper.WaterKnowledgeMapper">

    <!--自定义分页列表查询-->
    <select id="selectWaterKnowledgePage" resultType="cn.gistack.sm.waterKnowledge.vo.WaterKnowledgeVO">
        select * from sm_water_knowledge
        where 1=1
        <if test="waterKnowledge.title!=null and waterKnowledge.title!=''">
            and title like concat('%',#{waterKnowledge.title},'%')
        </if>
    </select>

</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/waterKnowledge/service/WaterKnowledgeService.java

New file
@@ -0,0 +1,23 @@
package cn.gistack.sm.waterKnowledge.service;


import cn.gistack.sm.waterKnowledge.entity.WaterKnowledge;
import cn.gistack.sm.waterKnowledge.vo.WaterKnowledgeVO;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.IService;

/**
 * 水知识服务层
 * @author zhongrj
 * @date 2023-09-12
 */
public interface WaterKnowledgeService extends IService<WaterKnowledge> {

    /**
     * 自定义分页列表查询
     * @param page
     * @param waterKnowledge
     * @return
     */
    Object selectWaterKnowledgePage(IPage<WaterKnowledgeVO> page, WaterKnowledgeVO waterKnowledge);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/waterKnowledge/service/impl/WaterKnowledgeServiceImpl.java

New file
@@ -0,0 +1,30 @@
package cn.gistack.sm.waterKnowledge.service.impl;


import cn.gistack.sm.waterKnowledge.entity.WaterKnowledge;
import cn.gistack.sm.waterKnowledge.mapper.WaterKnowledgeMapper;
import cn.gistack.sm.waterKnowledge.service.WaterKnowledgeService;
import cn.gistack.sm.waterKnowledge.vo.WaterKnowledgeVO;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;

/**
 * 水知识服务实现层
 * @author zhongrj
 * @date 2023-09-12
 */
@Service
public class WaterKnowledgeServiceImpl extends ServiceImpl<WaterKnowledgeMapper, WaterKnowledge> implements WaterKnowledgeService {

    /**
     * 自定义分页列表查询
     * @param page
     * @param waterKnowledge
     * @return
     */
    @Override
    public IPage<WaterKnowledgeVO> selectWaterKnowledgePage(IPage<WaterKnowledgeVO> page, WaterKnowledgeVO waterKnowledge) {
        return page.setRecords(baseMapper.selectWaterKnowledgePage(page,waterKnowledge));
    }
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/waterKnowledge/vo/WaterKnowledgeVO.java

New file
@@ -0,0 +1,8 @@
package cn.gistack.sm.waterKnowledge.vo;

import cn.gistack.sm.waterKnowledge.entity.WaterKnowledge;
import lombok.Data;

@Data
public class WaterKnowledgeVO extends WaterKnowledge {
}