From df6b610c57536058d1292a086d56e49dab0acf46 Mon Sep 17 00:00:00 2001
From: whywhyo <1511349576@qq.com>
Date: 星期四, 25 五月 2023 20:12:37 +0800
Subject: [PATCH] 456

---
 zhang-content/src/main/java/com/ruoyi/service/impl/MemoBookServiceImpl.java          |   62 +++++++++++++++
 ruoyi-admin/src/main/resources/application-druid.yml                                 |    4 
 zhang-content/src/main/java/com/ruoyi/domain/MemoBook.java                           |   38 +++++++++
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/MemoBookController.java     |   69 +++++++++++++++++
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfCollectionController.java |    8 ++
 zhang-content/src/main/java/com/ruoyi/mapper/MemoBookMapper.java                     |   16 ++++
 zhang-content/src/main/java/com/ruoyi/service/MemoBookService.java                   |   18 ++++
 zhang-content/src/main/resources/mapper.system/MemoBookMapper.xml                    |    8 ++
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZHonorController.java       |    8 ++
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSecretController.java      |    8 ++
 10 files changed, 237 insertions(+), 2 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/MemoBookController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/MemoBookController.java
new file mode 100644
index 0000000..95c324a
--- /dev/null
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/MemoBookController.java
@@ -0,0 +1,69 @@
+package com.ruoyi.web.controller.zhang;
+
+import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.core.text.Convert;
+import com.ruoyi.common.utils.ServletUtils;
+import com.ruoyi.domain.MemoBook;
+import com.ruoyi.domain.ZHonor;
+import com.ruoyi.service.MemoBookService;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import static com.ruoyi.common.core.page.TableSupport.PAGE_NUM;
+import static com.ruoyi.common.core.page.TableSupport.PAGE_SIZE;
+
+/**
+ * @Author Jinquan_Ou
+ * @Description
+ * @Date 2023-05-25 18:55
+ * @Version 1.0.0
+ **/
+@RestController
+@RequestMapping("/memoBook")
+public class MemoBookController {
+
+    @Autowired
+    private MemoBookService memoBookService;
+
+    /**
+     * 鏌ヨ鎵�鏈夎褰�
+     */
+    @GetMapping("/all")
+    public AjaxResult listAll(Long fid,Long cid){
+        return memoBookService.selectDataList(fid,cid);
+    }
+
+    /**
+     * 鏍规嵁Id鏌ヨ
+     */
+    @GetMapping()
+    public AjaxResult getById(Long id){
+        return AjaxResult.success(memoBookService.getById(id));
+    }
+
+
+    @PostMapping()
+    public AjaxResult saveData(@RequestBody MemoBook memoBook){
+        return memoBookService.mySave(memoBook);
+    }
+
+    @PutMapping()
+    public AjaxResult updateData(@RequestBody MemoBook memoBook){
+        boolean b = memoBookService.updateById(memoBook);
+        if (b){
+            return AjaxResult.success();
+        }else {
+            return AjaxResult.error();
+        }
+    }
+
+    @DeleteMapping()
+    public AjaxResult deleteData(Long id){
+        boolean b = memoBookService.removeById(id);
+        if (b){
+            return AjaxResult.success();
+        }else {
+            return AjaxResult.error();
+        }
+    }
+}
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZHonorController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZHonorController.java
index d20ca2b..c64c92b 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZHonorController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZHonorController.java
@@ -51,6 +51,14 @@
     }
 
     /**
+     * 鏍规嵁id鏌ヨ
+     */
+    @GetMapping()
+    public AjaxResult listById(Long id){
+        return AjaxResult.success(zHonorService.getById(id));
+    }
+
+    /**
      * 妯℃澘
      */
     @GetMapping("/model")
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSecretController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSecretController.java
index 51afe5e..5f85dcb 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSecretController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZSecretController.java
@@ -49,6 +49,14 @@
     }
 
     /**
+     * 鏍规嵁id鏌ヨ
+     */
+    @GetMapping()
+    public AjaxResult listById(Long id){
+        return AjaxResult.success(zSecretService.getById(id));
+    }
+
+    /**
      * 妯℃澘
      */
     @GetMapping("/model")
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfCollectionController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfCollectionController.java
index f938ef0..9884102 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfCollectionController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/zhang/ZfCollectionController.java
@@ -50,6 +50,14 @@
     }
 
     /**
+     * 鏍规嵁id鏌ヨ
+     */
+    @GetMapping()
+    public AjaxResult listById(Long id){
+        return AjaxResult.success(zfCollectionService.getById(id));
+    }
+
+    /**
      * 鑾峰彇瀵煎叆妯℃澘
      */
     @PostMapping("/model")
diff --git a/ruoyi-admin/src/main/resources/application-druid.yml b/ruoyi-admin/src/main/resources/application-druid.yml
index 045d564..b2e66b2 100644
--- a/ruoyi-admin/src/main/resources/application-druid.yml
+++ b/ruoyi-admin/src/main/resources/application-druid.yml
@@ -6,8 +6,8 @@
         druid:
             # 涓诲簱鏁版嵁婧�
             master:
-#                url: jdbc:mysql://47.93.189.255:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
-                url: jdbc:mysql://localhost:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+                url: jdbc:mysql://47.93.189.255:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
+#                url: jdbc:mysql://localhost:3306/ruoyi?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8
                 username: root
                 password: ZhangApp123!
 #                password: 123456
diff --git a/zhang-content/src/main/java/com/ruoyi/domain/MemoBook.java b/zhang-content/src/main/java/com/ruoyi/domain/MemoBook.java
new file mode 100644
index 0000000..0b65b89
--- /dev/null
+++ b/zhang-content/src/main/java/com/ruoyi/domain/MemoBook.java
@@ -0,0 +1,38 @@
+package com.ruoyi.domain;
+
+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 lombok.Data;
+
+import java.io.Serializable;
+import java.util.Date;
+
+/**
+ * @Author Jinquan_Ou
+ * @Description
+ * @Date 2023-05-25 18:51
+ * @Version 1.0.0
+ **/
+@Data
+@TableName("memo_book")
+public class MemoBook implements Serializable {
+    private static final long serialVersionUID = 1L;
+
+    @TableId(value = "id", type = IdType.AUTO)
+    private Long id;
+
+    private Long fid;
+
+    private Long cid;
+
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    private Date happenTime;
+
+    @JsonFormat(pattern = "yyyy-MM-dd")
+    private Date createTime;
+
+    private String content;
+
+}
diff --git a/zhang-content/src/main/java/com/ruoyi/mapper/MemoBookMapper.java b/zhang-content/src/main/java/com/ruoyi/mapper/MemoBookMapper.java
new file mode 100644
index 0000000..ecd7dc7
--- /dev/null
+++ b/zhang-content/src/main/java/com/ruoyi/mapper/MemoBookMapper.java
@@ -0,0 +1,16 @@
+package com.ruoyi.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.domain.MemoBook;
+import org.apache.ibatis.annotations.Mapper;
+
+/**
+ * @Author Jinquan_Ou
+ * @Description
+ * @Date 2023-05-25 18:57
+ * @Version 1.0.0
+ **/
+@Mapper
+public interface MemoBookMapper extends BaseMapper<MemoBook> {
+
+}
diff --git a/zhang-content/src/main/java/com/ruoyi/service/MemoBookService.java b/zhang-content/src/main/java/com/ruoyi/service/MemoBookService.java
new file mode 100644
index 0000000..19713f7
--- /dev/null
+++ b/zhang-content/src/main/java/com/ruoyi/service/MemoBookService.java
@@ -0,0 +1,18 @@
+package com.ruoyi.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.domain.MemoBook;
+
+/**
+ * @Author Jinquan_Ou
+ * @Description
+ * @Date 2023-05-25 18:57
+ * @Version 1.0.0
+ **/
+public interface MemoBookService extends IService<MemoBook> {
+    AjaxResult mySave(MemoBook memoBook);
+
+
+    AjaxResult selectDataList(Long fid, Long cid);
+}
diff --git a/zhang-content/src/main/java/com/ruoyi/service/impl/MemoBookServiceImpl.java b/zhang-content/src/main/java/com/ruoyi/service/impl/MemoBookServiceImpl.java
new file mode 100644
index 0000000..91ebfee
--- /dev/null
+++ b/zhang-content/src/main/java/com/ruoyi/service/impl/MemoBookServiceImpl.java
@@ -0,0 +1,62 @@
+package com.ruoyi.service.impl;
+
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.common.core.domain.AjaxResult;
+import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.domain.MemoBook;
+import com.ruoyi.mapper.MemoBookMapper;
+import com.ruoyi.service.MemoBookService;
+import org.springframework.stereotype.Service;
+import java.util.List;
+
+/**
+ * @Author Jinquan_Ou
+ * @Description
+ * @Date 2023-05-25 18:58
+ * @Version 1.0.0
+ **/
+@Service
+public class MemoBookServiceImpl extends ServiceImpl<MemoBookMapper, MemoBook> implements MemoBookService {
+
+    private boolean unionCondition(MemoBook memoBook){
+        LambdaQueryWrapper<MemoBook> lqw = new LambdaQueryWrapper<>();
+        lqw.eq(StringUtils.isNotEmpty(memoBook.getContent()),MemoBook::getContent,memoBook.getContent())
+                .eq(memoBook.getCid()!=null,MemoBook::getCid,memoBook.getCid())
+                .eq(memoBook.getFid()!=null,MemoBook::getFid,memoBook.getFid());
+        List<MemoBook> list = list(lqw);
+        if (list.size()>0){
+            return false;
+        }else {
+            return true;
+        }
+    }
+
+    @Override
+    public AjaxResult mySave(MemoBook memoBook) {
+        if(unionCondition(memoBook)){
+            save(memoBook);
+            return AjaxResult.success();
+        }else {
+            return AjaxResult.error("涓嶈兘鎻掑叆閲嶅鏁版嵁");
+        }
+    }
+
+    @Override
+    public AjaxResult selectDataList(Long fid, Long cid) {
+        LambdaQueryWrapper<MemoBook> lqw = new LambdaQueryWrapper<>();
+        if(fid==null || cid==null){
+            throw new RuntimeException("绯荤粺鍑虹幇閿欒");
+        }
+
+        lqw.eq(MemoBook::getFid,fid)
+                .eq(MemoBook::getCid,cid);
+
+        lqw.orderByDesc(MemoBook::getCreateTime);
+
+        List<MemoBook> result = list(lqw);
+        return AjaxResult.success(result);
+
+    }
+
+}
diff --git a/zhang-content/src/main/resources/mapper.system/MemoBookMapper.xml b/zhang-content/src/main/resources/mapper.system/MemoBookMapper.xml
new file mode 100644
index 0000000..778210f
--- /dev/null
+++ b/zhang-content/src/main/resources/mapper.system/MemoBookMapper.xml
@@ -0,0 +1,8 @@
+<?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">
+<!--namespace=缁戝畾涓�涓搴旂殑Dao/Mapper鎺ュ彛-->
+<mapper namespace="com.ruoyi.mapper.MemoBookMapper">
+
+</mapper>
\ No newline at end of file

--
Gitblit v1.9.1