/*
 *      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.record.controller;

import com.baomidou.mybatisplus.core.metadata.IPage;
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.springblade.core.boot.ctrl.BladeController;
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.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
 */
@RestController
@AllArgsConstructor
@RequestMapping("/record")
@Api(value = "", tags = "接口")
public class RecordController extends BladeController {

	private final IRecordService recordService;

	/**
	 * 详情
	 */
	@GetMapping("/detail")
	@ApiOperationSupport(order = 1)
	@ApiOperation(value = "详情", notes = "传入record")
	public R<Record> detail(Record record) {
		Record detail = recordService.getOne(Condition.getQueryWrapper(record));
		return R.data(detail);
	}

	/**
	 * 分页
	 */
	@GetMapping("/list")
	@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);
	}

	/**
	 * 自定义分页
	 */
	@GetMapping("/page")
	@ApiOperationSupport(order = 3)
	@ApiOperation(value = "分页", notes = "传入record")
	public R<IPage<RecordVO>> page(RecordVO record, Query query) {
		IPage<RecordVO> pages = recordService.selectRecordPage(Condition.getPage(query), record);
		return R.data(pages);
	}

	/**
	 * 新增
	 */
	@PostMapping("/save")
	@ApiOperationSupport(order = 4)
	@ApiOperation(value = "新增", notes = "传入record")
	public R save(@Valid @RequestBody Record record) {
		String cardid = record.getCardid();
		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");
		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("成功");
	}

	/**
	 * 暂存
	 */
	@PostMapping("/rocordsave")
	@ApiOperationSupport(order = 4)
	@ApiOperation(value = "新增", notes = "传入record")
	public R rocordsave(@Valid @RequestBody Record record) {
		String cardid = record.getCardid();
		String type = record.getPtype();
		Map map = recordService.selectIn(cardid,type);
		if (map != null) {
			record.setStorage("0");
			record.setPermitime(new Date());
			recordService.updateById(record);
		} else {
			record.setStorage("0");
			record.setType("2");
			record.setPermitime(new Date());
			recordService.save(record);
		}
		return R.success("暂存成功");
	}

	/**
	 * 修改
	 */
	@PostMapping("/update")
	@ApiOperationSupport(order = 5)
	@ApiOperation(value = "修改", notes = "传入record")
	public R update(@Valid @RequestBody Record record) {
		return R.status(recordService.updateById(record));
	}

	/**
	 * 新增或修改
	 */
	@PostMapping("/submit")
	@ApiOperationSupport(order = 6)
	@ApiOperation(value = "新增或修改", notes = "传入record")
	public R submit(@Valid @RequestBody Record record) {
		return R.status(recordService.saveOrUpdate(record));
	}


	/**
	 * 删除
	 */
	@PostMapping("/remove")
	@ApiOperationSupport(order = 8)
	@ApiOperation(value = "删除", notes = "传入ids")
	public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) {
		return R.status(recordService.removeByIds(Func.toLongList(ids)));
	}


	@PostMapping("/selectIn")
	public R selectIn(String cardid,String type) {
		Map map = recordService.selectIn(cardid,type);
		return R.data(map);
	}
}