/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
package org.springblade.modules.permit.controller;
|
|
import com.alibaba.fastjson.JSON;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.toolkit.SqlHelper;
|
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import io.swagger.annotations.ApiParam;
|
import lombok.AllArgsConstructor;
|
import org.apache.http.HttpEntity;
|
import org.apache.http.client.ClientProtocolException;
|
import org.apache.http.client.entity.UrlEncodedFormEntity;
|
import org.apache.http.client.methods.CloseableHttpResponse;
|
import org.apache.http.client.methods.HttpGet;
|
import org.apache.http.client.methods.HttpPost;
|
import org.apache.http.client.utils.URIBuilder;
|
import org.apache.http.impl.client.CloseableHttpClient;
|
import org.apache.http.impl.client.HttpClients;
|
import org.apache.http.message.BasicNameValuePair;
|
import org.apache.http.util.EntityUtils;
|
import org.json.JSONObject;
|
import org.springblade.core.boot.ctrl.BladeController;
|
import org.springblade.core.mp.support.Condition;
|
import org.springblade.core.mp.support.Query;
|
import org.springblade.core.secure.BladeUser;
|
import org.springblade.core.secure.utils.AuthUtil;
|
import org.springblade.core.tool.api.R;
|
import org.springblade.core.tool.utils.Func;
|
import org.springblade.modules.FTP.FtpUtil;
|
import org.springblade.modules.FTP.OutJson;
|
import org.springblade.modules.permit.entity.Permit;
|
import org.springblade.modules.permit.service.IPermitService;
|
import org.springblade.modules.permit.vo.PermitVO;
|
import org.springframework.web.bind.annotation.*;
|
import sun.net.www.http.HttpClient;
|
|
import javax.validation.Valid;
|
import java.io.*;
|
import java.net.HttpURLConnection;
|
import java.net.URI;
|
import java.net.URL;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 控制器
|
*
|
* @author BladeX
|
* @since 2021-07-12
|
*/
|
@RestController
|
@AllArgsConstructor
|
@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;
|
|
/**
|
* 详情
|
*/
|
@GetMapping("/detail")
|
@ApiOperationSupport(order = 1)
|
@ApiOperation(value = "详情", notes = "传入permit")
|
public R<Permit> detail(Permit permit) {
|
Permit detail = permitService.getOne(Condition.getQueryWrapper(permit));
|
return R.data(detail);
|
}
|
|
/**
|
* 分页
|
*/
|
@GetMapping("/list")
|
@ApiOperationSupport(order = 2)
|
@ApiOperation(value = "分页", notes = "传入permit")
|
public R<IPage<Permit>> list(Permit permit, Query query) {
|
permit.setStorage("1");
|
IPage<Permit> pages = permitService.page(Condition.getPage(query), Condition.getQueryWrapper(permit));
|
return R.data(pages);
|
}
|
|
/**
|
* 自定义分页
|
*/
|
@GetMapping("/page")
|
@ApiOperationSupport(order = 3)
|
@ApiOperation(value = "分页", notes = "传入permit")
|
public R<IPage<PermitVO>> page(PermitVO permit, Query query) {
|
IPage<PermitVO> pages = permitService.selectPermitPage(Condition.getPage(query), permit);
|
return R.data(pages);
|
}
|
|
/**
|
* 新增
|
*/
|
@PostMapping("/save")
|
@ApiOperationSupport(order = 4)
|
@ApiOperation(value = "新增", notes = "传入permit")
|
public R save(@Valid @RequestBody Permit permit) throws FileNotFoundException {
|
String cardid = permit.getCardid();
|
Map map = permitService.selectIn(cardid);
|
if (map != null) {
|
String id = map.get("id").toString();
|
permitService.removeByIds(Func.toLongList(id));
|
}
|
permit.setType("2");
|
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)" +
|
"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() + "'"+")" ;
|
FtpUtil.sqlFileUpload(s);
|
return R.success("新增成功");
|
}
|
|
/**
|
* 暂存
|
*/
|
@PostMapping("/storage")
|
@ApiOperation(value = "新增", notes = "传入permit")
|
public R storage(@Valid @RequestBody Permit permit) {
|
String cardid = permit.getCardid();
|
Map map = permitService.selectIn(cardid);
|
if (map != null) {
|
permit.setStorage("0");
|
permitService.updateById(permit);
|
// String formatStr = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(permit.getEstablishtime());
|
// String s1 =
|
// "update sys_permit set creditCode = " + "'" + permit.getCreditcode()+ "'"
|
// + ",enterpriseName = " + "'" + permit.getEnterprisename()+"'"
|
// + ",representative = " + "'" + permit.getRepresentative()+"'"
|
// + ",establishTime = " + "'" + formatStr+"'"
|
// + ",registeredCapital = " + "'" + permit.getRegisteredcapital()+"'"
|
// + ",organizationCode = " + "'" + permit.getOrganizationcode()+"'"
|
// + ",registrationNumber = " + "'" +permit.getRegistrationnumber()+"'"
|
// + ",identificationNumber = " + "'" + permit.getIdentificationnumber()+"'"
|
// + ",enterprises = " + "'" + permit.getEnterprises()+"'"
|
// + ",address = " + "'" + permit.getAddress()+"'"
|
// + ",business = " + "'" + permit.getBusiness()+"'"
|
// + ",region = " + "'" + permit.getRegion()+"'"
|
// + ",registration = " + "'" +permit.getRegistration()+"'"
|
// + ",industry = " + "'" +permit.getIndustry()+"'"
|
// + ",type = " + "'" +permit.getType()+"'"
|
// + ",politicaloutlook = " + "'" +user.getPoliticaloutlook()+"'"
|
// + ",healstats = " + "'" +user.getHealstats()+"'"
|
// + ",height = " + "'" +user.getHeight()+"'"
|
// + ",address = " + "'" +user.getAddress()+"'"
|
// + ",registered = " + "'" +user.getRegistered()+"'"
|
// + ",rtime = " + "'" +rtime+"'"
|
// + ",securitynumber = " + "'" +user.getSecuritynumber()+"'"
|
// + ",hold = " + "'" +user.getHold()+"'"
|
// + ",jurisdiction = " + "'" +user.getJurisdiction()+"'"
|
// + " " +"where id = " + "'" + user.getId() + "'";
|
// FtpUtil.sqlFileUpload(s1);
|
} else {
|
permit.setStorage("0");
|
permit.setPermitime(new Date());
|
permitService.save(permit);
|
}
|
return R.success("暂存成功");
|
}
|
|
|
@PostMapping("/selectIn")
|
public R selectIn(String cardid) {
|
Map map = permitService.selectIn(cardid);
|
return R.data(map);
|
}
|
|
/**
|
* 修改
|
*/
|
@PostMapping("/update")
|
@ApiOperationSupport(order = 5)
|
@ApiOperation(value = "修改", notes = "传入permit")
|
public R update(@Valid @RequestBody Permit permit) {
|
return R.status(permitService.updateById(permit));
|
}
|
|
/**
|
* 新增或修改
|
*/
|
@PostMapping("/submit")
|
@ApiOperationSupport(order = 6)
|
@ApiOperation(value = "新增或修改", notes = "传入permit")
|
public R submit(@Valid @RequestBody Permit permit) {
|
return R.status(permitService.saveOrUpdate(permit));
|
}
|
|
|
/**
|
* 删除
|
*/
|
@PostMapping("/remove")
|
@ApiOperationSupport(order = 8)
|
@ApiOperation(value = "删除", notes = "传入ids")
|
public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
|
return R.status(permitService.removeByIds(Func.toLongList(ids)));
|
}
|
|
public static void main(String[] args) {
|
String id = "1";
|
String s = "delete from sys_permit where id=" + id + ";";
|
System.out.println(s);
|
}
|
}
|
