package com.xcong.farmer.cms; import cn.hutool.core.collection.CollUtil; 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.test.dao.TestUserDao; import com.xcong.farmer.cms.modules.test.entity.TestUserEntity; import org.jsoup.Jsoup; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; import javax.annotation.Resource; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStream; 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 { @Resource private TestUserDao testUserDao; @Resource private CmsTemplateMapper cmsTemplateMapper; @Test public void testUserInsert() { for(int i = 0; i < 20; i++) { TestUserEntity testUser = new TestUserEntity(); testUser.setCreateBy("123"); testUser.setCreateTime(new Date()); testUser.setUpdateBy("123"); testUser.setUpdateTime(new Date()); testUser.setAccount("12345" + i); testUser.setName("hehe" + i); testUser.setPassword("33333"); testUserDao.insert(testUser); } } @Test public void start() { System.out.println(1); } @Autowired private CmsProperties cmsProperties; @Test public void viewTemplateInfo() { Long id = 4L; CmsTemplateEntity cmsTemplateEntity = cmsTemplateMapper.selectById(id); String htmlUrl = cmsProperties.getBaseUrl() + cmsProperties.getTemplatePath(); File uploadDir = new File(htmlUrl); if (!uploadDir.isDirectory()) { uploadDir.mkdir(); } htmlUrl = "D:\\cmshtml"; String pathName = htmlUrl+"\\"+cmsTemplateEntity.getPath(); System.out.println(pathName); byte[] bytes = new byte[0]; try { bytes = Files.readAllBytes(Paths.get(pathName)); } catch (IOException e) { e.printStackTrace(); System.out.println("未找到模板"); } String content = new String(bytes, StandardCharsets.UTF_8); System.out.println(content); } @Test public void path(){ Long id = 6L; CmsTemplateEntity cmsTemplateEntity = cmsTemplateMapper.selectById(id); String templatePath = cmsProperties.getTemplatePath(); String pathName = FileUtils.path(templatePath, cmsTemplateEntity.getPath()); System.out.println(templatePath); System.out.println(pathName); byte[] bytes = new byte[0]; try { bytes = Files.readAllBytes(Paths.get(pathName)); } catch (IOException e) { e.printStackTrace(); System.out.println("未找到模板"); } String content = new String(bytes, StandardCharsets.UTF_8); System.out.println(content); } @Autowired private ColumnMapper columnMapper; @Autowired private ArticleMapper articleMapper; @Test public void dateTest(){ String columnIdStrs = "68,63"; AdminArticleDto adminArticleDto = new AdminArticleDto(); adminArticleDto.setColumnId(columnIdStrs); adminArticleDto.setPageNum(1); adminArticleDto.setPageSize(8); Page page = new Page<>(adminArticleDto.getPageNum(), adminArticleDto.getPageSize()); ArticleEntity articleEntity = new ArticleEntity(); String columnIdStr = adminArticleDto.getColumnId(); if(StrUtil.isNotEmpty(columnIdStr)){ long[] columnIdLongs = StrUtil.splitToLong(columnIdStr, StrUtil.COMMA); List 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 objectQueryWrapper = new QueryWrapper<>(); objectQueryWrapper.eq("content_type",contentType); List columnEntities = columnMapper.selectList(objectQueryWrapper); if(CollUtil.isNotEmpty(columnEntities)){ List columIds = new ArrayList<>(); for(ColumnEntity columnEntity : columnEntities){ Long id = columnEntity.getId(); columIds.add(id); } articleEntity.setColumnIds(columIds); } } articleEntity.setCompanyId(24L); IPage list = articleMapper.selectAdminArticleInPage(page,articleEntity); System.out.println(list.getRecords()); } }