package cn.huge.module.cases.controller.script;

import cn.huge.base.common.constant.GzRegionBaseEnum;
import cn.huge.base.common.utils.DateUtils;
import cn.huge.base.common.utils.ObjectUtils;
import cn.huge.base.common.utils.ReturnFailUtils;
import cn.huge.base.common.utils.ReturnSucUtils;
import cn.huge.base.config.CurrentUser;
import cn.huge.module.cases.domain.bo.CasePersonCountBO;
import cn.huge.module.cases.domain.dto.*;
import cn.huge.module.cases.domain.po.CaseInfo;
import cn.huge.module.cases.service.CaseInfoService;
import cn.huge.module.client.api.impl.UtilsClientImpl;
import cn.huge.module.draft.service.CasedraftInfoService;
import com.alibaba.excel.EasyExcel;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.google.common.collect.Maps;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.data.domain.Sort;
import org.springframework.web.bind.annotation.*;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @title: 纠纷信息主表接口api-web端
 * @description: 纠纷信息主表接口api-web端
 * @company: hugeinfo
 * @author: wangwh
 * @time: 2024-08-27 10:00:57
 * @version: 1.0.0
 */
@Slf4j
@RestController
@RequestMapping("/api/script/caseInfo")
public class CaseInfoScriptController {

    @Autowired(required = false)
    private HttpServletRequest request;

    @Autowired
    private CaseInfoService service;
    @Autowired
    private CasedraftInfoService casedraftInfoService;
    @Autowired
    private UtilsClientImpl utilsClient;

    /**
     * 手动更新事项编号
     *
     * @return Object
     * @url {ctx}/api/web/caseInfo/updateCaseRef
     * @CurrentUser String userId
     */
    @GetMapping("/updateCaseRef")
    public Object updateCaseRef(@CurrentUser String userId) {
        try {
            QueryWrapper<CaseInfo> caseInfoQueryWrapper = new QueryWrapper<>();
            caseInfoQueryWrapper.select("id", "case_ref");
            List<CaseInfo> caseInfoList = service.list(caseInfoQueryWrapper);
            for (CaseInfo caseInfo: caseInfoList){
                String oldCaseRef = caseInfo.getCaseRef().replace("GZ", "");
                String day = oldCaseRef.substring(0, 6);
                String index = oldCaseRef.substring(6, 11);
                String newCaseRef = "GZBY-"+day+"-"+index;
                CaseInfo caseInfoPO = new CaseInfo();
                caseInfoPO.setId(caseInfo.getId());
                caseInfoPO.setCaseRef(newCaseRef);
                service.updateCaseInfo(caseInfoPO);
            }
            return ReturnSucUtils.getRepInfo();
        } catch (Exception e) {
            log.error("Controller接口[CaseInfoWebController.updateCaseRef]请求异常：" + e, e);
            return ReturnFailUtils.getRepInfo();
        }
    }

    /**
     * 手动更新事项编号
     *
     * @return Object
     * @url {ctx}/api/web/caseInfo/updateCaseRef2
     * @CurrentUser String userId
     */
    @GetMapping("/updateCaseRef2")
    public Object updateCaseRef2(@CurrentUser String userId) {
        try {
            QueryWrapper<CaseInfo> caseInfoQueryWrapper = new QueryWrapper<>();
            caseInfoQueryWrapper.select("id", "case_ref").isNull("case_ref");
            List<CaseInfo> caseInfoList = service.list(caseInfoQueryWrapper);
            for (CaseInfo caseInfo: caseInfoList){
                CaseInfo caseInfoPO = new CaseInfo();
                caseInfoPO.setId(caseInfo.getId());
                caseInfoPO.setCaseRef(utilsClient.createCaseRef(GzRegionBaseEnum.AREA_7.getIndex()));
                service.updateCaseInfo(caseInfoPO);
            }
            return ReturnSucUtils.getRepInfo();
        } catch (Exception e) {
            log.error("Controller接口[CaseInfoWebController.updateCaseRef2]请求异常：" + e, e);
            return ReturnFailUtils.getRepInfo();
        }
    }

    /**
     * 手动更新调解案号
     *
     * @return Object
     * @url {ctx}/api/web/caseInfo/updateCaseNo
     * @CurrentUser String userId
     */
    @GetMapping("/updateCaseNo")
    public Object updateCaseNo(@CurrentUser String userId) {
        try {
            QueryWrapper<CaseInfo> caseInfoQueryWrapper = new QueryWrapper<>();
            caseInfoQueryWrapper.isNull("case_no").select("id", "case_no").orderByAsc("create_time");
            List<CaseInfo> caseInfoList = service.list(caseInfoQueryWrapper);
            for (CaseInfo caseInfo: caseInfoList){
                CaseInfo caseInfoPO = new CaseInfo();
                caseInfoPO.setId(caseInfo.getId());
                caseInfoPO.setCaseRef(utilsClient.createCaseNo(GzRegionBaseEnum.AREA_7.getIndex()));
                service.updateCaseInfo(caseInfoPO);
            }
            return ReturnSucUtils.getRepInfo();
        } catch (Exception e) {
            log.error("Controller接口[CaseInfoWebController.updateCaseNo]请求异常：" + e, e);
            return ReturnFailUtils.getRepInfo();
        }
    }
}