/*
 *      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 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() + "'" + "," +
			"'" + permit.getPermitime() + "'" + "," + "'" + 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);
	}
}