From b6b0cb226fcf184525ee7b36af3a09471e9c0057 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 25 三月 2024 11:29:33 +0800
Subject: [PATCH] 修改数据统计的查询条件
---
src/main/java/com/lf/server/service/all/TestService.java | 53 +++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 43 insertions(+), 10 deletions(-)
diff --git a/src/main/java/com/lf/server/service/all/TestService.java b/src/main/java/com/lf/server/service/all/TestService.java
index 69aef8d..ccde796 100644
--- a/src/main/java/com/lf/server/service/all/TestService.java
+++ b/src/main/java/com/lf/server/service/all/TestService.java
@@ -8,12 +8,12 @@
import com.lf.server.entity.all.PermsAuthEntity;
import com.lf.server.entity.all.ResAuthEntity;
import com.lf.server.entity.bd.DlgagnpEntity;
+import com.lf.server.entity.ctrl.CountEntity;
import com.lf.server.entity.data.MetaEntity;
import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.entity.md.MdzxcgEntity;
import com.lf.server.helper.*;
import com.lf.server.mapper.bd.DlgagnpMapper;
-import com.lf.server.service.data.FmeService;
import com.lf.server.service.data.MetaService;
import com.lf.server.service.data.UploadService;
import com.lf.server.service.show.LocateService;
@@ -71,14 +71,7 @@
@Autowired
MetaService metaService;
- @Autowired
- FmeService fmeService;
-
private final static Log log = LogFactory.getLog(TestService.class);
-
- public void testRegiste() {
- //
- }
public void testGdal() {
GdalHelper.readTif("E:\\data\\7.Insar\\insartest.tif");
@@ -165,7 +158,7 @@
// 椤垫暟 / 姣忛〉璁板綍鏁�
Page<DlgagnpEntity> page = new Page<>(1, 10);
// 鍗囧簭鎺掑簭
- page.addOrder(OrderItem.asc("gid"));
+ page.addOrder(OrderItem.desc("gid"));
// 鍒嗛〉锛歐rapper鏌ヨ鏉′欢
Page<DlgagnpEntity> userPage = dlgagnpMapper.selectPage(page, null);
// 鎬婚〉鏁� / 鎬昏褰曟暟锛�325 / 3247
@@ -205,7 +198,7 @@
List<PermsAuthEntity> pauList = permsService.selectPermsEntity("admin");
List<PermsAuthEntity> pauList2 = permsService.selectPermsEntity("admin");
- permsService.clearResCache();
+ // permsService.clearResCache()
permsService.clearPermsCache();
raeList = permsService.selectRes("admin");
@@ -273,4 +266,44 @@
//
}
}
+
+ public void testWord() {
+ String inputFile = "C:\\Users\\Administrator\\Desktop\\ts\\椤圭洰鏁版嵁鍒嗙被缁熻.docx";
+ String outPutFile = "C:\\Users\\Administrator\\Desktop\\ts\\NewWord.docx";
+
+ Map<String, String> textMap = new HashMap<>(1);
+ textMap.put("title", "娣卞湷娑插寲澶╃劧姘斿簲鎬ヨ皟宄扮珯澶栬緭绠￠亾宸ョ▼锛圶Q03T04锛�");
+
+ List<String[]> tableList = new ArrayList<>();
+ tableList.add(new String[]{"" + 1, "鏁板瓧绾垮垝鍥�", "123.54骞虫柟绫�"});
+ tableList.add(new String[]{"" + 2, "鍦扮伨鐐�", "120涓�"});
+
+ WordHelper.generateWord(inputFile, outPutFile, textMap, tableList);
+ }
+
+ public void testExcel() {
+ String source = "C:\\Users\\Administrator\\Desktop\\ts\\椤圭洰鏁版嵁鍒嗙被缁熻.xlsx";
+ String target = "C:\\Users\\Administrator\\Desktop\\ts\\NewWord.xlsx";
+
+ List<CountEntity> list = new ArrayList<>();
+ CountEntity c1 = new CountEntity();
+ c1.setNo(1);
+ c1.setM1("鏁板瓧绾垮垝鍥�");
+ c1.setM2("123.54骞虫柟绫�");
+ list.add(c1);
+
+ CountEntity c2 = new CountEntity();
+ c2.setNo(2);
+ c2.setM1("鍦扮伨鐐�");
+ c2.setM2("120涓�");
+ list.add(c2);
+
+ Map<String, Object> map = new HashMap<>(1);
+ map.put("title", "娣卞湷娑插寲澶╃劧姘斿簲鎬ヨ皟宄扮珯澶栬緭绠￠亾宸ョ▼锛圶Q03T04锛�");
+
+ Map<String, List<CountEntity>> listMap = new HashMap<>(1);
+ listMap.put("data", list);
+
+ ExcelHelper.writeToTemplate(source, target, map, listMap);
+ }
}
--
Gitblit v1.9.3