From 6781628db9ee02f57dffc5cd5aba7a9f109ee246 Mon Sep 17 00:00:00 2001
From: zhangzeli <123456>
Date: 星期二, 09 十一月 2021 14:58:38 +0800
Subject: [PATCH] 意见建议

---
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SuggestController.java    |   77 +++++++++++++++++++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/ISuggestService.java         |   18 ++++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ISuggestServiceImpl.java |   34 ++++++++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/Suggest.java                  |   43 ++++++++++
 xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/SuggestMapper.java            |   26 ++++++
 5 files changed, 198 insertions(+), 0 deletions(-)

diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SuggestController.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SuggestController.java
new file mode 100644
index 0000000..c0ad03e
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/controller/SuggestController.java
@@ -0,0 +1,77 @@
+package cn.exrick.xboot.your.controller;
+
+import cn.exrick.xboot.core.common.utils.PageUtil;
+import cn.exrick.xboot.core.common.utils.ResultUtil;
+import cn.exrick.xboot.core.common.vo.PageVo;
+import cn.exrick.xboot.core.common.vo.Result;
+import cn.exrick.xboot.your.entity.Suggest;
+import cn.exrick.xboot.your.service.ISuggestService;
+import cn.hutool.core.util.StrUtil;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.List;
+
+/**
+ * @author zhangzeli
+ */
+@Slf4j
+@RestController
+@Api(tags = "鎰忚寤鸿绠$悊鎺ュ彛")
+@RequestMapping("/xboot/suggest")
+@Transactional
+public class SuggestController {
+
+    @Autowired
+    private ISuggestService iSuggestService;
+
+    @RequestMapping(value = "/get/{id}", method = RequestMethod.GET)
+    @ApiOperation(value = "閫氳繃id鑾峰彇")
+    public Result<Suggest> get(@PathVariable String id) {
+
+        Suggest suggest = iSuggestService.getById(id);
+        return new ResultUtil<Suggest>().setData(suggest);
+    }
+
+    @RequestMapping(value = "/getAll", method = RequestMethod.GET)
+    @ApiOperation(value = "鑾峰彇鍏ㄩ儴鏁版嵁")
+    public Result<List<Suggest>> getAll() {
+
+        List<Suggest> list = iSuggestService.list();
+        return new ResultUtil<List<Suggest>>().setData(list);
+    }
+
+    @RequestMapping(value = "/getByPage", method = RequestMethod.GET)
+    @ApiOperation(value = "鍒嗛〉鑾峰彇")
+    public Result<IPage<Suggest>> getByPage(PageVo page) {
+
+        IPage<Suggest> data = iSuggestService.page(PageUtil.initMpPage(page));
+        return new ResultUtil<IPage<Suggest>>().setData(data);
+    }
+
+    @RequestMapping(value = "/insertOrUpdate", method = RequestMethod.POST)
+    @ApiOperation(value = "缂栬緫鎴栨洿鏂版暟鎹�")
+    public Result<Suggest> saveOrUpdate(Suggest suggest) {
+
+        if (iSuggestService.saveOrUpdate(suggest)) {
+            return new ResultUtil<Suggest>().setData(suggest);
+        }
+        return new ResultUtil<Suggest>().setErrorMsg("鎿嶄綔澶辫触");
+    }
+
+    @RequestMapping(value = "/delByIds", method = RequestMethod.POST)
+    @ApiOperation(value = "鎵归噺閫氳繃id鍒犻櫎")
+    public Result<Object> delAllByIds(@RequestParam String[] ids) {
+
+        for (String id : ids) {
+            iSuggestService.removeById(id);
+        }
+        return ResultUtil.success("鎵归噺閫氳繃id鍒犻櫎鏁版嵁鎴愬姛");
+    }
+}
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/Suggest.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/Suggest.java
new file mode 100644
index 0000000..4686bdd
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/entity/Suggest.java
@@ -0,0 +1,43 @@
+package cn.exrick.xboot.your.entity;
+
+import cn.exrick.xboot.core.base.XbootBaseEntity;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+import org.hibernate.annotations.DynamicInsert;
+import org.hibernate.annotations.DynamicUpdate;
+import org.springframework.format.annotation.DateTimeFormat;
+
+import javax.persistence.Entity;
+import javax.persistence.Table;
+import java.util.Date;
+
+/**
+ * @author Exrick
+ */
+@Data
+@Entity
+@DynamicInsert
+@DynamicUpdate
+@Table(name = "t_suggest")
+@TableName("t_suggest")
+@ApiModel(value = "缁翠慨璁板綍")
+public class Suggest extends XbootBaseEntity {
+
+    private static final long serialVersionUID = 1L;
+
+    @ApiModelProperty(value = "鎰忚鍒嗙被瀛楀吀琛╥d")
+    private String dictDataId;
+
+    @ApiModelProperty(value = "鍐呭")
+    private String content;
+
+    @ApiModelProperty(value = "鍟嗘埛ID")
+    private String customerId;
+
+    @ApiModelProperty(value = "鍙告満鎴栭殢杞﹀憳id")
+    private String userId;
+
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/SuggestMapper.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/SuggestMapper.java
new file mode 100644
index 0000000..2993673
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/mapper/SuggestMapper.java
@@ -0,0 +1,26 @@
+package cn.exrick.xboot.your.mapper;
+
+import cn.exrick.xboot.your.entity.CustomerReceive;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import cn.exrick.xboot.your.entity.Suggest;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Constants;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Result;
+import org.apache.ibatis.annotations.Results;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.type.JdbcType;
+
+import java.util.List;
+
+/**
+ * 鎰忚寤鸿鏁版嵁澶勭悊灞�
+ * @author zhangzeli
+ */
+public interface SuggestMapper extends BaseMapper<Suggest> {
+    @Select("SELECT a.*,b.name as temp FROM t_customer_receive a LEFT JOIN t_customer b ON a.customer_id=b.id ${ew.customSqlSegment} ORDER BY a.status ASC,a.create_time DESC")
+    @Results({@Result(column="temp", property="customerName", jdbcType = JdbcType.VARCHAR)})
+    IPage<CustomerReceive> page2(Page initMpPage, @Param(Constants.WRAPPER) QueryWrapper<CustomerReceive> wrapper);
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/ISuggestService.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/ISuggestService.java
new file mode 100644
index 0000000..fa5a07f
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/service/ISuggestService.java
@@ -0,0 +1,18 @@
+package cn.exrick.xboot.your.service;
+
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import cn.exrick.xboot.your.entity.Suggest;
+
+import java.util.List;
+
+/**
+ * 鎰忚寤鸿鎺ュ彛
+ * @author zhangzeli
+ */
+public interface ISuggestService extends IService<Suggest> {
+
+    IPage<Suggest> page2(Page initMpPage, QueryWrapper<Suggest> wrapper);
+}
\ No newline at end of file
diff --git a/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ISuggestServiceImpl.java b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ISuggestServiceImpl.java
new file mode 100644
index 0000000..4ed8ea4
--- /dev/null
+++ b/xboot-modules/xboot-your/src/main/java/cn/exrick/xboot/your/serviceimpl/ISuggestServiceImpl.java
@@ -0,0 +1,34 @@
+package cn.exrick.xboot.your.serviceimpl;
+
+import cn.exrick.xboot.your.mapper.SuggestMapper;
+import cn.exrick.xboot.your.entity.Suggest;
+import cn.exrick.xboot.your.service.ISuggestService;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.ArrayList;
+import java.util.List;
+
+/**
+ * 鎰忚寤鸿鎺ュ彛瀹炵幇
+ * @author zhangzeli
+ */
+@Slf4j
+@Service
+@Transactional
+public class ISuggestServiceImpl extends ServiceImpl<SuggestMapper, Suggest> implements ISuggestService {
+
+    @Autowired
+    private SuggestMapper suggestMapper;
+
+    @Override
+    public IPage<Suggest> page2(Page initMpPage, QueryWrapper<Suggest> wrapper) {
+        return null;
+    }
+}
\ No newline at end of file

--
Gitblit v1.9.1