From ebb5012dc221db17bfad74c3bdfd91d46aa29c03 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Sat, 04 Dec 2021 11:24:41 +0800
Subject: [PATCH] 1.许可

---
 src/main/java/org/springblade/modules/permit/controller/PermitController.java |  186 ++++++++++++++++++++++------------------------
 1 files changed, 88 insertions(+), 98 deletions(-)

diff --git a/src/main/java/org/springblade/modules/permit/controller/PermitController.java b/src/main/java/org/springblade/modules/permit/controller/PermitController.java
index 262222e..f982f2b 100644
--- a/src/main/java/org/springblade/modules/permit/controller/PermitController.java
+++ b/src/main/java/org/springblade/modules/permit/controller/PermitController.java
@@ -88,21 +88,6 @@
 @RequestMapping("/permit")
 @Api(value = "", tags = "接口")
 public class PermitController extends BladeController {
-	//ftp服务器IP地址
-	private static String ftpHost = "192.168.0.105";
-	//ftp服务器端口
-	private static int ftpPort = 21;
-	//ftp服务器用户名
-	private static String ftpUserName = "yly";
-	//ftp服务器密码
-	private static String ftpPassword = "Yly@123";
-	//ftp服务器路径
-	private static String ftpPath = "";
-	//本地路径
-	private static String localPath = "D:\\anbao";
-	//文件名
-	private static String fileName = "sql.json";
-
 	private final IPermitService permitService;
 	private final IDeptService iDeptService;
 	private final IInformationService informationService;
@@ -152,7 +137,7 @@
 	public R save(@Valid @RequestBody Permit permit) throws FileNotFoundException {
 		String cardid = permit.getCardid();
 		String type = permit.getPtype();
-		Map map = permitService.selectIn(cardid,type);
+		Map map = permitService.selectIn(cardid, type);
 		if (map != null) {
 			String id = map.get("id").toString();
 			permitService.removeByIds(Func.toLongList(id));
@@ -161,24 +146,19 @@
 		permit.setStorage("1");
 		permit.setPermitime(new Date());
 		permitService.save(permit);
-		String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getEstablishtime());
-		String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getPermitime());
-		String s = "insert into sys_permit(id,creditCode,enterpriseName,representative,establishTime," +
-			"registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," +
-			"address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,jurisdiction,cardid)" +
-			"values(" + "'" + permit.getId() + "'" + "," + "'" + permit.getCreditcode() + "'" + "," + "'" + permit.getEnterprisename() + "'" + "," + "'"
-			+ permit.getRepresentative() + "'" + "," +
-			"'" + formatStr + "'" + "," + "'" + permit.getRegisteredcapital() + "'" + "," + "'"
-			+ permit.getOrganizationcode() + "'" + "," + "'" + permit.getRegistrationnumber() + "'" + "," +
-			"'" + permit.getIdentificationnumber() + "'" + "," + "'" + permit.getEnterprises() + "'" + "," + "'" +
-			permit.getAddress() + "'" + "," + "'" + permit.getBusiness() + "'" + "," + "'" +
-			permit.getRegion() + "'" + "," + "'" + permit.getRegistration() + "'" + "," + "'" + permit.getIndustry()+ "'" + "," + "'"
-			+ permit.getType() + "'" + "," +
-			"'" + pertime + "'" + "," + "'" + permit.getDeptid() + "'" + "," + "'" + permit.getPtype() + "'" + "," +
-			"'" + permit.getRepresentativecell() + "'" + "," + "'" + permit.getContacts() + "'" + "," + "'"
-			+ permit.getContactscell() + "'"+"," + "'" + permit.getJurisdiction() + "'"+
-			"," + "'" + permit.getCardid() + "'"+")" ;
-		FtpUtil.sqlFileUpload(s);
+//		String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getPermitime());
+//		String overtime = new SimpleDateFormat("yyyy-MM-dd").format(permit.getOvertime());
+//		String s = "insert into sys_permit(id,enterpriseName,representative," +
+//			"address,business,region,registration,industry,type,permitime,ptype,representativecell,contacts,contactscell,jurisdiction,cardid,overtime)" +
+//			"values(" + "'" + permit.getId() + "'" + ","+ "'" + permit.getEnterprisename() + "'" + "," + "'"
+//			+ permit.getRepresentative() + "'" + "," + "'" +
+//			permit.getAddress() + "'" + "," + "'" + permit.getBusiness() + "'" + "," + "'" +
+//			permit.getRegion() + "'" + "," + "'" + permit.getRegistration() + "'" + "," + "'" + permit.getIndustry() + "'" + "," + "'"
+//			+ permit.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + permit.getPtype() + "'" + "," +
+//			"'" + permit.getRepresentativecell() + "'" + "," + "'" + permit.getContacts() + "'" + "," + "'"
+//			+ permit.getContactscell() + "'" + "," + "'" + permit.getJurisdiction() + "'" +
+//			"," + "'" + permit.getCardid() + "'"+ "," + "'" + overtime+ "'" + ")";
+//		FtpUtil.sqlFileUpload(s);
 		return R.success("新增成功");
 	}
 
@@ -190,7 +170,7 @@
 	public R storage(@Valid @RequestBody Permit permit) {
 		String cardid = permit.getCardid();
 		String type = permit.getPtype();
-		Map map = permitService.selectIn(cardid,type);
+		Map map = permitService.selectIn(cardid, type);
 		if (map != null) {
 			permit.setStorage("0");
 			permitService.updateById(permit);
@@ -204,8 +184,8 @@
 
 
 	@PostMapping("/selectIn")
-	public R selectIn(String cardid ,String type) {
-		Map map = permitService.selectIn(cardid,type);
+	public R selectIn(String cardid, String type) {
+		Map map = permitService.selectIn(cardid, type);
 		return R.data(map);
 	}
 
@@ -218,68 +198,78 @@
 	public R update(@Valid @RequestBody Permit permit) {
 		//审核通过
 		if (permit.getType().equals("0")) {
-			//新增组织机构和单位信息
-			Information information =new Information();
-			information.setCreditcode(permit.getCreditcode());
-			information.setEnterprisename(permit.getEnterprisename());
-			information.setRepresentative(permit.getRepresentative());
-			information.setEstablishtime(permit.getEstablishtime());
-			information.setRegisteredcapital(permit.getRegisteredcapital());
-			information.setOrganizationcode(permit.getOrganizationcode());
-			information.setRegistrationnumber(permit.getRegistrationnumber());
-			information.setEnterprises(permit.getEnterprises());
-			information.setAddress(permit.getAddress());
-			information.setBusiness(permit.getBusiness());
-			information.setRegion(permit.getRegion());
-			information.setRegistration(permit.getRegistration());
-			information.setIndustry(permit.getIndustry());
-			information.setRepresentativecell(permit.getRepresentativecell());
-			information.setContacts(permit.getContacts());
-			information.setContactscell(permit.getContactscell());
-			Dept dept = new Dept();
-			//本市公司
-			if (permit.getPtype().equals("0")){
-				Long i = 1413470343230877697L;
-				dept.setParentId(i);
-				dept.setAncestors("0,1413470343230877697");
-			}
-			//培训公司
-			else if (permit.getPtype().equals("1")){
-				Long i = 1418458374477549569L;
-				dept.setParentId(i);
-				dept.setAncestors("0,1418458374477549569");
-			}
-			else{
-				Long i = 1420222961377357825L;
-				dept.setParentId(i);
-				dept.setAncestors("0,1420222961377357825");
-			}
-			dept.setTenantId("000000");
-			dept.setDeptName(information.getEnterprisename());
-			dept.setDeptCategory(1);
-			if (iDeptService.submit(dept)) {
-				CacheUtil.clear(SYS_CACHE);
-				// 返回懒加载树更新节点所需字段
-				Kv kv = Kv.create().set("id", String.valueOf(dept.getId())).set("tenantId", dept.getTenantId())
-					.set("deptCategoryName", DictCache.getValue(DictEnum.ORG_CATEGORY, dept.getDeptCategory()));
-				String id = kv.get("id").toString();
-				information.setDepartmentid(id);
-			}
-			informationService.save(information);
-			//注册用户
-			User user = new User();
-			user.setAccount(permit.getEnterprisename());
-			String initPassword = ParamCache.getValue(DEFAULT_PARAM_PASSWORD);
-			user.setPassword(initPassword);
-			userService.saveOrUpdate(user);
+//			//新增组织机构和单位信息
+//			Information information = new Information();
+//			information.setCreditcode(permit.getCreditcode());
+//			information.setEnterprisename(permit.getEnterprisename());
+//			information.setRepresentative(permit.getRepresentative());
+//			information.setEstablishtime(permit.getEstablishtime());
+//			information.setRegisteredcapital(permit.getRegisteredcapital());
+//			information.setOrganizationcode(permit.getOrganizationcode());
+//			information.setRegistrationnumber(permit.getRegistrationnumber());
+//			information.setEnterprises(permit.getEnterprises());
+//			information.setAddress(permit.getAddress());
+//			information.setBusiness(permit.getBusiness());
+//			information.setRegion(permit.getRegion());
+//			information.setRegistration(permit.getRegistration());
+//			information.setIndustry(permit.getIndustry());
+//			information.setRepresentativecell(permit.getRepresentativecell());
+//			information.setContacts(permit.getContacts());
+//			information.setContactscell(permit.getContactscell());
+//			Dept dept = new Dept();
+//			//本市公司
+//			if (permit.getPtype().equals("0")) {
+//				Long i = 1413470343230877697L;
+//				dept.setParentId(i);
+//				dept.setAncestors("0,1413470343230877697");
+//			}
+//			//培训公司
+//			else if (permit.getPtype().equals("1")) {
+//				Long i = 1418458374477549569L;
+//				dept.setParentId(i);
+//				dept.setAncestors("0,1418458374477549569");
+//			} else {
+//				Long i = 1420222961377357825L;
+//				dept.setParentId(i);
+//				dept.setAncestors("0,1420222961377357825");
+//			}
+//			dept.setTenantId("000000");
+//			dept.setDeptName(information.getEnterprisename());
+//			dept.setDeptCategory(1);
+//			if (iDeptService.submit(dept)) {
+//				CacheUtil.clear(SYS_CACHE);
+//				// 返回懒加载树更新节点所需字段
+//				Kv kv = Kv.create().set("id", String.valueOf(dept.getId())).set("tenantId", dept.getTenantId())
+//					.set("deptCategoryName", DictCache.getValue(DictEnum.ORG_CATEGORY, dept.getDeptCategory()));
+//				String id = kv.get("id").toString();
+//				information.setDepartmentid(id);
+//			}
+//			informationService.save(information);
+//			//注册用户
+//			User user = new User();
+//			user.setAccount(permit.getEnterprisename());
+//			String initPassword = ParamCache.getValue(DEFAULT_PARAM_PASSWORD);
+//			user.setPassword(initPassword);
+//			userService.saveOrUpdate(user);
 			//把附件添加单位id
-			attachService.updat(information.getDepartmentid(),permit.getCardid());
-			String s1 = "update sys_permit set type = " + "'" + 0 + "'" +",approve = " + "'" + permit.getApprove() + "'"+
-				" " +"where id = " + "'" + permit.getId() + "'";
-			FtpUtil.sqlFileUpload(s1);
-		}
-		else {
-			String s1 = "update sys_permit set type = " + "'" + 1 + "'" +",approve = " + "'" + permit.getApprove() + "'"+
+//			attachService.updat(information.getDepartmentid(), permit.getCardid());
+//			String s1 = "update sys_permit set type = " + "'" + permit.getType() + "'" +
+//				",papprove = " + "'" + permit.getPapprove() + "'"+
+//				",xapprove = " + "'" + permit.getXapprove() + "'"+
+//				",sapprove = " + "'" + permit.getSapprove() + "'"+
+//				",popinion = " + "'" + permit.getPopinion() + "'"+
+//				",sopinion = " + "'" + permit.getSopinion() + "'"+
+//				",xopinion = " + "'" + permit.getXopinion() + "'"+
+//				" " +"where id = " + "'" + permit.getId() + "'";
+//			FtpUtil.sqlFileUpload(s1);
+		} else {
+			String s1 = "update sys_permit set type = " + "'" + permit.getType() + "'" +
+				",papprove = " + "'" + permit.getPapprove() + "'"+
+				",xapprove = " + "'" + permit.getXapprove() + "'"+
+				",sapprove = " + "'" + permit.getSapprove() + "'"+
+				",popinion = " + "'" + permit.getPopinion() + "'"+
+				",sopinion = " + "'" + permit.getSopinion() + "'"+
+				",xopinion = " + "'" + permit.getXopinion() + "'"+
 				" " +"where id = " + "'" + permit.getId() + "'";
 			FtpUtil.sqlFileUpload(s1);
 		}

--
Gitblit v1.9.3