From 733edfcd6ad1c38dcf4aa761a417f4e4bfd754b2 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Fri, 27 Aug 2021 11:05:44 +0800
Subject: [PATCH] 1.许可审批

---
 src/main/java/org/springblade/modules/record/controller/RecordController.java |   45 ++++++++++++++++++++++++++++++++++-----------
 1 files changed, 34 insertions(+), 11 deletions(-)

diff --git a/src/main/java/org/springblade/modules/record/controller/RecordController.java b/src/main/java/org/springblade/modules/record/controller/RecordController.java
index 44a339a..54bdc57 100644
--- a/src/main/java/org/springblade/modules/record/controller/RecordController.java
+++ b/src/main/java/org/springblade/modules/record/controller/RecordController.java
@@ -27,16 +27,19 @@
 import org.springblade.core.mp.support.Query;
 import org.springblade.core.tool.api.R;
 import org.springblade.core.tool.utils.Func;
+import org.springblade.modules.FTP.FtpUtil;
 import org.springblade.modules.record.entity.Record;
 import org.springblade.modules.record.service.IRecordService;
 import org.springblade.modules.record.vo.RecordVO;
 import org.springframework.web.bind.annotation.*;
 
 import javax.validation.Valid;
+import java.text.SimpleDateFormat;
+import java.util.Date;
 import java.util.Map;
 
 /**
- *  控制器
+ * 控制器
  *
  * @author BladeX
  * @since 2021-07-12
@@ -67,6 +70,7 @@
 	@ApiOperationSupport(order = 2)
 	@ApiOperation(value = "分页", notes = "传入record")
 	public R<IPage<Record>> list(Record record, Query query) {
+		record.setStorage("1");
 		IPage<Record> pages = recordService.page(Condition.getPage(query), Condition.getQueryWrapper(record));
 		return R.data(pages);
 	}
@@ -90,13 +94,31 @@
 	@ApiOperation(value = "新增", notes = "传入record")
 	public R save(@Valid @RequestBody Record record) {
 		String cardid = record.getCardid();
-		Map map = recordService.selectIn(cardid);
-		if (map!=null){
+		String type = record.getPtype();
+		Map map = recordService.selectIn(cardid,type);
+		if (map != null) {
 			String id = map.get("id").toString();
 			recordService.removeByIds(Func.toLongList(id));
 		}
 		record.setStorage("1");
-		return R.status(recordService.save(record));
+		record.setType("2");
+		record.setPermitime(new Date());
+		recordService.save(record);
+		String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getEstablishtime());
+		String offtime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getOfficetime());
+		String pertime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(record.getPermitime());
+		String s = "insert into sys_record(id,creditCode,enterpriseName,representative,establishtime," +
+			"registeredCapital,organizationCode,registrationNumber,identificationNumber,enterprises," +
+			"address,business,region,registration,industry,type,permitime,deptid,ptype,representativecell,contacts,contactscell,perid,offices,officetime,jurisdiction)" +
+			"values(" + "'" + record.getId() + "'" + "," + "'" + record.getCreditcode() + "'" + "," + "'" + record.getEnterprisename() + "'" + "," + "'"+ record.getRepresentative() + "'" + "," +
+			"'" + formatStr + "'" + "," + "'" + record.getRegisteredcapital() + "'" + "," + "'"
+			+ record.getOrganizationcode() + "'" + "," + "'" + record.getRegistrationnumber() + "'" + "," +
+			"'" + record.getIdentificationnumber() + "'" + "," + "'" + record.getEnterprises() + "'" + "," + "'" +
+			record.getAddress() + "'" + "," + "'" + record.getBusiness() + "'" + "," + "'" +
+			record.getRegion() + "'" + "," + "'" + record.getRegistration() + "'" + "," + "'" + record.getIndustry() + "'" + "," + "'" + record.getType() + "'" + "," + "'" + pertime + "'" + "," + "'" + record.getDeptid() + "'" + "," + "'" + record.getPtype() + "'" + "," +
+			"'" + record.getRepresentativecell() + "'" + "," + "'" + record.getContacts() + "'" + "," + "'" + record.getContactscell() + "'" + "," +"'" + record.getPerid() + "'" + "," + "'" + record.getOffices() + "'" + "," + "'" + offtime + "'" + "," + "'" + record.getJurisdiction() + "'" + ")";
+		FtpUtil.sqlFileUpload(s);
+		return R.success("成功");
 	}
 
 	/**
@@ -107,15 +129,16 @@
 	@ApiOperation(value = "新增", notes = "传入record")
 	public R rocordsave(@Valid @RequestBody Record record) {
 		String cardid = record.getCardid();
-		Map map = recordService.selectIn(cardid);
-		if (map!=null){
+		String type = record.getPtype();
+		Map map = recordService.selectIn(cardid,type);
+		if (map != null) {
 			record.setStorage("0");
+			record.setPermitime(new Date());
 			recordService.updateById(record);
-		}
-		else {
+		} else {
 			record.setStorage("0");
 			record.setType("2");
-			record.setPtype("2");
+			record.setPermitime(new Date());
 			recordService.save(record);
 		}
 		return R.success("暂存成功");
@@ -154,8 +177,8 @@
 
 
 	@PostMapping("/selectIn")
-	public R selectIn(String cardid) {
-		Map map = recordService.selectIn(cardid);
+	public R selectIn(String cardid,String type) {
+		Map map = recordService.selectIn(cardid,type);
 		return R.data(map);
 	}
 }

--
Gitblit v1.9.3