/*
 *      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.performance.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.performance.entity.Performance;
import org.springblade.modules.performance.service.IPerformanceService;
import org.springblade.modules.performance.vo.PerformanceVO;
import org.springblade.modules.system.service.MyAsyncService;
import org.springframework.web.bind.annotation.*;

import javax.validation.Valid;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * 保安员表现管理
 *
 * @author BladeX
 * @since 2021-07-05
 */
@RestController
@AllArgsConstructor
@RequestMapping("/performance")
@Api(value = "", tags = "接口")
public class PerformanceController extends BladeController {

	private final IPerformanceService performanceService;
	private final MyAsyncService myAsyncService;
	/**
	 * 详情
	 */
	@GetMapping("/detail")
	@ApiOperationSupport(order = 1)
	@ApiOperation(value = "详情", notes = "传入performance")
	public R<Performance> detail(Performance performance) {
		Performance detail = performanceService.getOne(Condition.getQueryWrapper(performance));
		return R.data(detail);
	}

	/**
	 * 分页
	 */
	@GetMapping("/list")
	@ApiOperationSupport(order = 2)
	@ApiOperation(value = "分页", notes = "传入performance")
	public R<IPage<Performance>> list(Performance performance, Query query) {
		IPage<Performance> pages = performanceService.page(Condition.getPage(query), Condition.getQueryWrapper(performance));
		return R.data(pages);
	}

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

	/**
	 * 新增
	 */
	@PostMapping("/save")
	@ApiOperationSupport(order = 4)
	@ApiOperation(value = "新增", notes = "传入performance")
	public R save(@Valid @RequestBody Performance performance) {
		boolean save = performanceService.save(performance);
		String s1 =
			"insert into sys_performance(id,securityId,Achievements,time,score) " +
				"values(" + "'" + performance.getId() + "'" + "," +
				"'" + performance.getSecurityid() + "'" + "," +
				"'" + performance.getAchievements() + "'" + "," +
				"'" + new SimpleDateFormat("yyyy-MM-dd").format(performance.getTime()) + "'" + "," +
				"'" + performance.getScore() + "'" + ")";
		//FtpUtil.sqlFileUpload(s1);
		myAsyncService.dataSync(s1);
		return R.status(save);
	}

	/**
	 * 修改
	 */
	@PostMapping("/update")
	@ApiOperationSupport(order = 5)
	@ApiOperation(value = "修改", notes = "传入performance")
	public R update(@Valid @RequestBody Performance performance) {
		boolean b = performanceService.updateById(performance);
		//内网同步
		String s1 = "update sys_performance set securityId = " + "'" + performance.getSecurityid() + "'" +
			",Achievements = " + "'" + performance.getAchievements() + "'" +
			",time = " + "'" + new SimpleDateFormat("yyyy-MM-dd").format(performance.getTime()) + "'" +
			",score = " + "'" + performance.getScore() + "'" +
			" " + "where id = " + "'" + performance.getId() + "'";
		//FtpUtil.sqlFileUpload(s1);
		myAsyncService.dataSync(s1);
		return R.status(b);
	}

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


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


	/**
	 * 查询本年所有月份的表现差的数量
	 *
	 * @return
	 */
	@GetMapping("/queryYearPer")
	public R queryYearAlarm() {
		Calendar cal = Calendar.getInstance();
		String year = String.valueOf(cal.get(Calendar.YEAR));
		Map<String, String> map = performanceService.queryYearPer(year);
		map = (HashMap<String, String>) sortMapBykeyAsc(map);//key升序
		return R.data(map);
	}

	//升序
	public static Map<String, String> sortMapBykeyAsc(Map<String, String> oriMap) {
		Map<String, String> sortedMap = new LinkedHashMap<String, String>();
		try {
			if (oriMap != null && !oriMap.isEmpty()) {
				List<Map.Entry<String, String>> entryList = new ArrayList<Map.Entry<String, String>>(oriMap.entrySet());
				Collections.sort(entryList,
					new Comparator<Map.Entry<String, String>>() {
						public int compare(Map.Entry<String, String> entry2,
										   Map.Entry<String, String> entry1) {
							int value2 = 0, value1 = 0;
							try {
								value2 = Integer.parseInt(entry1.getKey());
								value1 = Integer.parseInt(entry2.getKey());
							} catch (NumberFormatException e) {
								value2 = 0;
								value1 = 0;
							}
							return value1 - value2;
						}
					});
				Iterator<Map.Entry<String, String>> iter = entryList.iterator();
				Map.Entry<String, String> tmpEntry = null;
				while (iter.hasNext()) {
					tmpEntry = iter.next();
					sortedMap.put(tmpEntry.getKey(), tmpEntry.getValue());
				}
			}
		} catch (Exception e) {
		}
		return sortedMap;
	}


}