package com.ruoyi.web.controller.project;

import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
import com.ruoyi.common.annotation.Log;
import com.ruoyi.common.annotation.NotRepeatCommit;
import com.ruoyi.common.annotation.RepeatSubmit;
import com.ruoyi.common.config.RuoYiConfig;
import com.ruoyi.common.constant.HttpStatus;
import com.ruoyi.common.core.controller.BaseController;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.core.domain.model.LoginUser;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.common.enums.BusinessType;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.exception.base.BaseException;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.bean.DtoConversionUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.project.domain.*;
import com.ruoyi.project.domain.vo.*;
import com.ruoyi.project.mapper.ServiceFunddetailMapper;
import com.ruoyi.project.service.*;
import com.ruoyi.system.service.ISysPostService;
import com.ruoyi.system.service.ISysUserService;
import freemarker.template.Configuration;
import freemarker.template.Template;
import freemarker.template.TemplateException;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.annotations.Options;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.*;

import java.io.*;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.time.LocalDate;
import java.util.*;
import java.util.concurrent.ConcurrentHashMap;
import java.util.stream.Collectors;

import static com.ruoyi.web.controller.project.ServiceReimbursementController.convert;

/**
 * 案例统计
 *
 * @author ruoyi
 * @date 2022-01-24
 */
@Slf4j
@Api("案例统计")
@RestController
@RequestMapping("/project/spstatcase")
public class SpStatCaseController extends BaseController {

    @Autowired
    SpstatCaseService spstatCaseService;

    /**
     * 查询案例统计
     */
    @ApiOperation("查询案例统计")
    @PostMapping("/spStatCaselist")
    public TableDataInfo spStatCaselist(@RequestBody SpStatCaseReq spStatCaseReq) {
        startPage();
        return getDataTable(spstatCaseService.getListBypower(spStatCaseReq));
    }

    /**
     * 导出案例统计
     */
    @ApiOperation("导出案例统计")
    @Log(title = "案例统计", businessType = BusinessType.EXPORT)
    @GetMapping("/export")
    public AjaxResult export(SpStatCaseReq spStatCaseReq) {
        List<SpStatCase> list = spstatCaseService.getListBypower(spStatCaseReq);
        ExcelUtil<SpStatCase> util = new ExcelUtil<SpStatCase>(SpStatCase.class);
        return util.exportExcel(list, "案例统计数据");
    }

    /**
     * 导出案例统计（按业务组）
     */
    @ApiOperation("导出案例统计（按业务组）")
    @Log(title = "案例统计", businessType = BusinessType.EXPORT)
    @GetMapping("/exportDept")
    public AjaxResult exportDept(SpStatCaseReq spStatCaseReq) {
        List<SpStatCase> list = spstatCaseService.getListBypower(spStatCaseReq);
        Map<String, SpStatCaseDept> grouped = new LinkedHashMap<String, SpStatCaseDept>();
        for (SpStatCase row : list) {
            String key = StringUtils.isNotEmpty(row.getDeptid()) ? row.getDeptid() : row.getDeptname();
            if (key == null) {
                key = "";
            }
            SpStatCaseDept dept = grouped.get(key);
            if (dept == null) {
                dept = new SpStatCaseDept();
                dept.setDeptname(row.getDeptname() == null ? "未分组" : row.getDeptname());
                dept.setCaseTotal(0);
                dept.setTerminationTotal(0);
                grouped.put(key, dept);
            }
            dept.setCaseTotal(dept.getCaseTotal() + toInt(row.getWorkflowsum()));
            dept.setTerminationTotal(dept.getTerminationTotal() + toInt(row.getTerminationcase()));
        }
        List<SpStatCaseDept> result = new ArrayList<SpStatCaseDept>(grouped.values());
        ExcelUtil<SpStatCaseDept> util = new ExcelUtil<SpStatCaseDept>(SpStatCaseDept.class);
        return util.exportExcel(result, "案例统计（按业务组）");
    }

    private int toInt(String value) {
        if (StringUtils.isEmpty(value)) {
            return 0;
        }
        try {
            return Integer.parseInt(value.trim());
        } catch (NumberFormatException e) {
            return 0;
        }
    }


}