From f04b8922283120e2bc4a476ddc302ebd3b0894e4 Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Thu, 07 Jul 2022 20:42:05 +0800
Subject: [PATCH] Merge branch 'master' of http://120.27.238.55:7000/r/farmer-cms

---
 src/test/java/com/xcong/farmer/cms/KssframeworkApplicationTests.java |   93 +++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 91 insertions(+), 2 deletions(-)

diff --git a/src/test/java/com/xcong/farmer/cms/KssframeworkApplicationTests.java b/src/test/java/com/xcong/farmer/cms/KssframeworkApplicationTests.java
index efa9df4..5053fe0 100644
--- a/src/test/java/com/xcong/farmer/cms/KssframeworkApplicationTests.java
+++ b/src/test/java/com/xcong/farmer/cms/KssframeworkApplicationTests.java
@@ -1,13 +1,27 @@
 package com.xcong.farmer.cms;
 
+import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.util.ObjectUtil;
+import cn.hutool.core.util.StrUtil;
+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.xcong.farmer.cms.common.response.Result;
 import com.xcong.farmer.cms.common.utils.FileUtils;
 import com.xcong.farmer.cms.configurations.properties.CmsProperties;
+import com.xcong.farmer.cms.modules.system.dto.AdminArticleDto;
 import com.xcong.farmer.cms.modules.system.dto.WebArticleInPageDto;
+import com.xcong.farmer.cms.modules.system.entity.ArticleEntity;
 import com.xcong.farmer.cms.modules.system.entity.CmsTemplateEntity;
+import com.xcong.farmer.cms.modules.system.entity.ColumnEntity;
+import com.xcong.farmer.cms.modules.system.entity.UserEntity;
+import com.xcong.farmer.cms.modules.system.mapper.ArticleMapper;
 import com.xcong.farmer.cms.modules.system.mapper.CmsTemplateMapper;
+import com.xcong.farmer.cms.modules.system.mapper.ColumnMapper;
 import com.xcong.farmer.cms.modules.system.util.LoginUserUtil;
+import com.xcong.farmer.cms.modules.system.vo.AdminArticleVo;
+import com.xcong.farmer.cms.modules.system.vo.WebArticleVo;
 import com.xcong.farmer.cms.modules.test.dao.TestUserDao;
 import com.xcong.farmer.cms.modules.test.entity.TestUserEntity;
 import org.jsoup.Jsoup;
@@ -23,7 +37,9 @@
 import java.nio.charset.StandardCharsets;
 import java.nio.file.Files;
 import java.nio.file.Paths;
+import java.util.ArrayList;
 import java.util.Date;
+import java.util.List;
 
 @SpringBootTest
 class KssframeworkApplicationTests {
@@ -103,11 +119,84 @@
         System.out.println(content);
     }
 
+    @Autowired
+    private ColumnMapper columnMapper;
+
+    @Autowired
+    private ArticleMapper articleMapper;
+
     @Test
-    public void dateTest(){
+    public void articleTest(){
         WebArticleInPageDto webArticleInPageDto = new WebArticleInPageDto();
         webArticleInPageDto.setTimeType("一周内");
-        System.out.println(webArticleInPageDto.getTimeType());
+        webArticleInPageDto.setPageNum(1);
+        webArticleInPageDto.setPageSize(8);
+        Long companyId = 24L;
+        Page<WebArticleVo> page = new Page<>(webArticleInPageDto.getPageNum(), webArticleInPageDto.getPageSize());
+        ArticleEntity articleEntity = new ArticleEntity();
+        Long columnId = webArticleInPageDto.getColumnId() == null ? 0L : webArticleInPageDto.getColumnId();
+        if(columnId != 0L){
+            articleEntity.setColumnId(columnId);
+        }
+        String author = webArticleInPageDto.getAuthor();
+        if(StrUtil.isNotEmpty(author)){
+            articleEntity.setAuthor(author);
+        }
+        String queryKey = webArticleInPageDto.getQueryKey();
+        if(StrUtil.isNotEmpty(queryKey)){
+            articleEntity.setTitle(queryKey);
+        }
+        if(UserEntity.USER_BELONG_TOP != companyId){
+            articleEntity.setCompanyId(companyId);
+        }
+        String timeType = webArticleInPageDto.getTimeType();
+        if(StrUtil.isNotEmpty(timeType)){
+            articleEntity.setTimeType(timeType);
+        }
+        IPage<WebArticleVo> list = articleMapper.selectWebArticleInPage(page,articleEntity);
+        System.out.println(list.getRecords());
+    }
+
+    @Test
+    public void dateTest(){
+        String columnIdStrs = "68,63";
+        AdminArticleDto adminArticleDto = new AdminArticleDto();
+
+        adminArticleDto.setColumnIdStr(columnIdStrs);
+        adminArticleDto.setPageNum(1);
+        adminArticleDto.setPageSize(8);
+        Page<AdminArticleVo> page = new Page<>(adminArticleDto.getPageNum(), adminArticleDto.getPageSize());
+        ArticleEntity articleEntity = new ArticleEntity();
+        String columnIdStr = adminArticleDto.getColumnIdStr();
+        if(StrUtil.isNotEmpty(columnIdStr)){
+            long[] columnIdLongs = StrUtil.splitToLong(columnIdStr, StrUtil.COMMA);
+            List<Long> columnList = new ArrayList<>();
+            for(long columnIdLong : columnIdLongs){
+                columnList.add(columnIdLong);
+            }
+            articleEntity.setColumnList(columnList);
+        }
+        String title = adminArticleDto.getTitle();
+        if(StrUtil.isNotEmpty(title)){
+            articleEntity.setTitle(title);
+        }
+        Integer contentType = adminArticleDto.getContentType() == null ? 0 : adminArticleDto.getContentType();
+        if(contentType != 0){
+            QueryWrapper<ColumnEntity> objectQueryWrapper = new QueryWrapper<>();
+            objectQueryWrapper.eq("content_type",contentType);
+            List<ColumnEntity> columnEntities = columnMapper.selectList(objectQueryWrapper);
+            if(CollUtil.isNotEmpty(columnEntities)){
+                List<Long> columIds = new ArrayList<>();
+                for(ColumnEntity columnEntity : columnEntities){
+                    Long id = columnEntity.getId();
+                    columIds.add(id);
+                }
+                articleEntity.setColumnIds(columIds);
+            }
+        }
+        articleEntity.setCompanyId(24L);
+        IPage<AdminArticleVo> list = articleMapper.selectAdminArticleInPage(page,articleEntity);
+        System.out.println(list.getRecords());
     }
 
 }

--
Gitblit v1.9.1