From cc057177b2fb17aee9a173a6adbabdc578fd74c7 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Mon, 06 Dec 2021 10:30:44 +0800
Subject: [PATCH] 1.许可

---
 src/main/java/org/springblade/modules/shareholder/controller/ShareholderController.java |   80 ++++++++++++++++++++++++++++++++++++----
 1 files changed, 72 insertions(+), 8 deletions(-)

diff --git a/src/main/java/org/springblade/modules/shareholder/controller/ShareholderController.java b/src/main/java/org/springblade/modules/shareholder/controller/ShareholderController.java
index da0ea4f..9964fac 100644
--- a/src/main/java/org/springblade/modules/shareholder/controller/ShareholderController.java
+++ b/src/main/java/org/springblade/modules/shareholder/controller/ShareholderController.java
@@ -24,16 +24,28 @@
 import lombok.AllArgsConstructor;
 import org.springblade.common.utils.arg;
 import org.springblade.core.boot.ctrl.BladeController;
+import org.springblade.core.excel.util.ExcelUtil;
 import org.springblade.core.mp.support.Condition;
 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.information.excel.InforExcel;
+import org.springblade.modules.information.excel.InforImporter;
+import org.springblade.modules.member.excel.memberExcel;
 import org.springblade.modules.shareholder.entity.Shareholder;
+import org.springblade.modules.shareholder.excel.shareExcel;
+import org.springblade.modules.shareholder.excel.shareImporter;
 import org.springblade.modules.shareholder.service.IShareholderService;
 import org.springblade.modules.shareholder.vo.ShareholderVO;
 import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
 
+import javax.servlet.http.HttpServletResponse;
 import javax.validation.Valid;
+import java.text.SimpleDateFormat;
+import java.util.ArrayList;
+import java.util.List;
 
 /**
  *  控制器
@@ -89,9 +101,19 @@
 	@ApiOperationSupport(order = 4)
 	@ApiOperation(value = "新增", notes = "传入shareholder")
 	public R save(@Valid @RequestBody Shareholder shareholder) throws Exception {
-		arg arg = new arg();
-		arg.test01(arg.url+"/shareholder/save",shareholder);
-		return R.status(shareholderService.save(shareholder));
+		boolean save = shareholderService.save(shareholder);
+		String s1 =
+			"insert into sys_shareholder(id,shareholder,shareholdingratio,capital,capitalTime,cardid,cell,creditCode) " +
+				"values(" + "'" + shareholder.getId() + "'" + "," +
+				"'" + shareholder.getShareholder() + "'" + "," +
+				"'" + shareholder.getShareholdingratio() + "'" + "," +
+				"'" + shareholder.getCapital() + "'" + "," +
+				"'" + new SimpleDateFormat("yyyy-MM-dd").format(shareholder.getCapitaltime()) + "'"+"," +
+				"'" + shareholder.getCardid() + "'"+"," +
+				"'" + shareholder.getCell() + "'"+"," +
+				"'" + shareholder.getCreditcode() + "'" + ")";
+		FtpUtil.sqlFileUpload(s1);
+		return R.status(save);
 	}
 
 	/**
@@ -100,8 +122,19 @@
 	@PostMapping("/update")
 	@ApiOperationSupport(order = 5)
 	@ApiOperation(value = "修改", notes = "传入shareholder")
-	public R update(@Valid @RequestBody Shareholder shareholder) {
-		return R.status(shareholderService.updateById(shareholder));
+	public R update(@Valid @RequestBody Shareholder shareholder) throws Exception {
+		boolean b = shareholderService.updateById(shareholder);
+		//内网同步
+		String s1 = "update sys_shareholder set shareholder = " + "'" + shareholder.getShareholder() + "'" +
+			",shareholdingratio = " + "'" + shareholder.getShareholdingratio() + "'" +
+			",capital = " + "'" + shareholder.getCapital() + "'" +
+			",capitalTime = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(shareholder.getCapitaltime()) + "'" +
+			",cardid = " + "'" + shareholder.getCardid() + "'" +
+			",cell = " + "'" + shareholder.getCell() + "'" +
+			",creditCode = " + "'" + shareholder.getCreditcode() + "'" +
+			" " + "where id = " + "'" + shareholder.getId() + "'";
+		FtpUtil.sqlFileUpload(s1);
+		return R.status(b);
 	}
 
 	/**
@@ -127,14 +160,45 @@
 
 	/**
 	 * 出资人信息
-	 * @param creditcode
+	 * @param shareholderVO
 	 * @return
 	 */
 	@PostMapping("/selectShareholderInfo")
-	public R<IPage<ShareholderVO>> selectShareholderInfo(String creditcode, Query query) {
-		IPage<ShareholderVO> pages=shareholderService.selectShareholderInfo(Condition.getPage(query), creditcode);
+	public R<IPage<ShareholderVO>> selectShareholderInfo(ShareholderVO shareholderVO, Query query) {
+		IPage<ShareholderVO> pages=shareholderService.selectShareholderInfo(Condition.getPage(query), shareholderVO);
 		return R.data(pages);
 	}
 
+	/**
+	 * 导入投资人信息
+	 */
+	@PostMapping("import-share")
+	@ApiOperationSupport(order = 12)
+	@ApiOperation(value = "导入投资人", notes = "传入excel")
+	public R importUser(MultipartFile file, Integer isCovered) {
+		shareImporter shareImporter = new shareImporter(shareholderService, false);
+		ExcelUtil.save(file, shareImporter, shareExcel.class);
+		return R.success("操作成功");
+	}
+
+
+	/**
+	 * 导出模板
+	 */
+	@GetMapping("export-template")
+	@ApiOperation(value = "导出模板")
+	public void exportMember(HttpServletResponse response) {
+		List<shareExcel> list = new ArrayList<>();
+		shareExcel share = new shareExcel();
+		share.setCreditcode("xx12351214112");
+		share.setShareholder("张三");
+		share.setShareholdingratio("10");
+		share.setCardid("360***********0001");
+		share.setCell("131********");
+		share.setCapital("50");
+		share.setCapitaltime("2020/01/01");
+		list.add(share);
+		ExcelUtil.export(response, "出资人数据导入模板", "出资人导入数据表", list, shareExcel.class);
+	}
 
 }

--
Gitblit v1.9.3