package com.gkhy.safePlatform.targetDuty.controller;
import java.io.IOException;
import java.net.URLEncoder;
import java.util.*;


import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.gkhy.safePlatform.commons.utils.BeanCopyUtils;
import com.gkhy.safePlatform.targetDuty.entity.TargetDutySummary;
import com.gkhy.safePlatform.targetDuty.entity.TargetMng;
import com.gkhy.safePlatform.targetDuty.model.dto.resp.TargetDutySummaryExcel;
import com.gkhy.safePlatform.targetDuty.service.TargetDutySummaryService;
import com.gkhy.safePlatform.targetDuty.service.baseService.TargetDutySummaryBaseService;
import com.gkhy.safePlatform.targetDuty.utils.DateUtils;
import com.gkhy.safePlatform.targetDuty.utils.poihelper.ExcelUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import com.gkhy.safePlatform.commons.query.PageQuery;
import com.gkhy.safePlatform.commons.utils.PageUtils;
import com.gkhy.safePlatform.commons.vo.ResultVO;
import com.gkhy.safePlatform.commons.enums.ResultCodes;
import com.gkhy.safePlatform.targetDuty.model.dto.req.TargetDutySummaryQueryCriteria;

import java.sql.Timestamp;
import java.util.stream.Collectors;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.Serializable;

/**
 * (TargetDutySummary)表控制层
 *
 * @author xurui
 * @since 2022-07-21 15:35:14
 */
@RestController
@RequestMapping("targetDutySummary")
public class TargetDutySummaryController {
    /**
     * 服务对象
     */
    @Resource
    private TargetDutySummaryService targetDutySummaryService;

    @Resource
    private TargetDutySummaryBaseService targetDutySummaryBaseService;

    @Autowired
    public HttpServletRequest request;

    @Autowired
    public HttpServletResponse response;

    /**
     * 分页查询所有数据
     *
     * @param pageQuery 查询实体
     * @return 所有数据
     */
    @PostMapping(value = "/page/list")
    public ResultVO selectAll(@RequestBody PageQuery<TargetDutySummaryQueryCriteria> pageQuery){
        PageUtils.checkCheck(pageQuery);
		return this.targetDutySummaryService.queryAll(pageQuery);
    }
	

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping(value = "/selectOne/{id}")
    public ResultVO selectOne(@PathVariable Serializable id) {
        return new ResultVO<>(ResultCodes.OK,this.targetDutySummaryBaseService.getById(id));
    }

	/**
     * 新增或者修改数据
     *
     * @param targetDutySummary 实体对象
     * @return 修改结果
     */
    @PostMapping(value = "/addOrUpdate")
    public ResultVO update(@RequestBody TargetDutySummary targetDutySummary) {
        if (targetDutySummary.getId() == null) {
            return new ResultVO<>(ResultCodes.OK,targetDutySummaryBaseService.save(targetDutySummary));
        } else {
            targetDutySummaryBaseService.update(targetDutySummary,new UpdateWrapper<TargetDutySummary>().eq("id",targetDutySummary.getId()));
            return new ResultVO<>(ResultCodes.OK);
        }
    }

    /**
     * 删除数据
     *
     * @param ids 主键结合
     * @return 删除结果
     */
    @RequestMapping(value = "/delete",method = RequestMethod.POST)
    public ResultVO delete(@RequestBody Long[] ids) {
        this.targetDutySummaryService.delete(ids);
        return new ResultVO<>(ResultCodes.OK);
    }

    /**
     * 导出一览数据
     *
     */
    @GetMapping(value = "/exportData")
    public void exportData(TargetDutySummaryQueryCriteria queryCriteria) throws IOException {
        targetDutySummaryService.exportData(queryCriteria);
    }

    public static void main(String[] args) {
        TargetDutySummary mng = new TargetDutySummary();
        mng.setYear("2020");
        mng.setDepartmentId(1L);
        mng.setTargetValue("1");
        mng.setExamineValue("2");
        mng.setExamineResult(1);

        mng.setYiYue("1");
        mng.setErYue("3");
        mng.setSanYue("4");
        mng.setSiYue("5");
        mng.setWuYue("6");
        mng.setLiuYue("7");
        mng.setQiYue("8");
        mng.setBaYue("9");
        mng.setJiuYue("10");
        mng.setShiYue("11");
        mng.setShiyiYue("12");
        mng.setShierYue("13");

        System.out.println(JSONObject.toJSONString(mng));

    }
}