From 6dc323321275c3206acbd1fbdc14812db6e2ae90 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Fri, 20 Aug 2021 08:55:50 +0800
Subject: [PATCH] 1.许可审批
---
src/main/java/org/springblade/modules/information/controller/InformationController.java | 84 ++++++++++++++++++++++++++++++++++++++---
1 files changed, 77 insertions(+), 7 deletions(-)
diff --git a/src/main/java/org/springblade/modules/information/controller/InformationController.java b/src/main/java/org/springblade/modules/information/controller/InformationController.java
index 95d04ba..3fb379d 100644
--- a/src/main/java/org/springblade/modules/information/controller/InformationController.java
+++ b/src/main/java/org/springblade/modules/information/controller/InformationController.java
@@ -24,6 +24,8 @@
import org.springblade.common.cache.DictCache;
import org.springblade.common.enums.DictEnum;
+import org.springblade.common.utils.FtpUtil;
+import org.springblade.common.utils.MysqlCenlint;
import org.springblade.core.cache.utils.CacheUtil;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
@@ -47,7 +49,14 @@
import org.springblade.modules.information.service.IInformationService;
import org.springblade.core.boot.ctrl.BladeController;
import springfox.documentation.annotations.ApiIgnore;
+import java.sql.*;
+import java.sql.DriverManager; //需要这个jar包 mysql-connector-java-5.1.49.jar
+import java.util.List;
+import java.util.ArrayList;
+import java.util.Map;
+import java.util.HashMap;
+import java.io.*;
import java.util.*;
import static org.springblade.core.cache.constant.CacheConstant.SYS_CACHE;
@@ -110,8 +119,8 @@
@ApiOperation(value = "新增", notes = "传入information")
public R save(@Valid @RequestBody Information information) {
Dept dept = new Dept();
- String departmentid = information.getDepartmentid();
- Long l = Long.parseLong(departmentid);
+ //String departmentid = information.getDepartmentid();
+ //Long l = Long.parseLong(departmentid);
//自招保安公司
if (information.getStats().equals("0")) {
Long i = 1420222768149966850L;
@@ -149,7 +158,7 @@
dept.setAncestors("0,1420222961377357825");
dept.setDeptCategory(1);
}
- dept.setId(l);
+ //dept.setId(l);
if (iDeptService.submit(dept)) {
CacheUtil.clear(SYS_CACHE);
// 返回懒加载树更新节点所需字段
@@ -802,8 +811,8 @@
* 保安员统计
*/
@PostMapping("/selectLi")
- public R selectLi(String jurisdiction, String deptid) {
- List<Map<Object, Object>> list = informationService.selectLi(jurisdiction, deptid);
+ public R selectLi(String jurisdiction, String deptid,Integer current,Integer size) {
+ List<Map<Object, Object>> list = informationService.selectLi(jurisdiction, deptid,current,size);
return R.data(list);
}
@@ -854,8 +863,8 @@
* 业务统计情况
*/
@PostMapping("/selectYw")
- public R selectYw(String jurisdiction, String deptid) {
- List<Map<Object, Object>> list = informationService.selectYw(jurisdiction, deptid);
+ public R selectYw(String jurisdiction, String deptid,Integer current,Integer size) {
+ List<Map<Object, Object>> list = informationService.selectYw(jurisdiction, deptid,current,size);
return R.data(list);
}
@@ -925,4 +934,65 @@
return R.data(lists);
}
+// public static void main(String[] args) throws Exception {
+// //ftp服务器IP地址
+// String ftpHost = "192.168.0.105";
+// //ftp服务器端口
+// int ftpPort = 21;
+// //ftp服务器用户名
+// String ftpUserName = "yly";
+// //ftp服务器密码
+// String ftpPassword = "Yly@123";
+// //ftp服务器路径
+// String ftpPath = "";
+// //本地路径
+// String localPath = "D:\\anbao";
+// //文件名
+// String fileName = "sql.json";
+// FtpUtil.downloadFtpFile(ftpHost, ftpUserName, ftpPassword, ftpPort, ftpPath, localPath, fileName);
+// String s = TestJson();
+// String sql = stringReplace(s);
+// MysqlCenlint.inster(sql);
+// MysqlCenlint.delete();
+// }
+ public static String stringReplace(String str) {
+ //去掉" "号
+ String strs= str.replace("\"", "");
+ return strs ;
+
+ }
+ public static String TestJson(){
+ File file = new File("D:\\anbao\\sql.json");
+ StringBuilder localStrBulider = new StringBuilder();
+ if(file.isFile() && file.exists()) {
+ try {
+ InputStreamReader inputStreamReader = new InputStreamReader(new FileInputStream(file), "utf-8");
+ BufferedReader bufferReader = new BufferedReader(inputStreamReader);
+ String lineStr = null;
+ try {
+ while((lineStr = bufferReader.readLine()) != null) {
+ localStrBulider.append(lineStr);
+ }
+ bufferReader.close();
+ inputStreamReader.close();
+ } catch (IOException e) {
+ // TODO Auto-generated catch block
+ System.out.println("file read error!");
+ e.printStackTrace();
+ }
+ } catch (UnsupportedEncodingException e) {
+ // TODO Auto-generated catch block
+ System.out.println("file catch unsupported encoding!");
+ e.printStackTrace();
+ } catch (FileNotFoundException e) {
+ // TODO Auto-generated catch block
+ System.out.println("file not found!");
+ e.printStackTrace();
+ }
+ }else {
+ System.out.println("file is not a file or file is not existing!");
+ }
+ return localStrBulider.toString();
+ }
+
}
--
Gitblit v1.9.3