package com.skua.modules.material.controller;

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.skua.core.api.vo.Result;
import com.skua.core.aspect.annotation.AutoLog;
import com.skua.core.context.BaseContextHandler;
import com.skua.core.context.SpringContextUtils;
import com.skua.core.query.QueryGenerator;
import com.skua.core.util.DateUtils;
import com.skua.modules.erp.entity.ErpSettlement;
import com.skua.modules.erp.vo.PurchaseContractVO;
import com.skua.modules.material.entity.MaterialInfo;
import com.skua.modules.material.entity.MaterialInfoHandleRecord;
import com.skua.modules.material.entity.MaterialInformation;
import com.skua.modules.material.service.IMaterialInfoHandleRecordService;
import com.skua.modules.material.service.IMaterialInfoService;
import com.skua.modules.material.vo.MaterialInfoStatisticsVO;
import com.skua.modules.system.service.ISysDepartService;
import com.skua.tool.util.JSUtils;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import lombok.extern.slf4j.Slf4j;
import org.apache.commons.lang3.StringUtils;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.net.URLDecoder;
import java.util.*;

/**
 * <pre>
 * 知识学院/学习资料管理
 * </pre>
 * @author Li Yuanyuan
 * @version V0.1, 2022年6月22日 上午10:36:11
 */
@Slf4j
@Api(tags = "制度化文件管理")
@RestController
@RequestMapping("/info/materialInfo")
public class MaterialInfoController {
    @Autowired
    private IMaterialInfoService materialInfoService;
    @Autowired
	private IMaterialInfoHandleRecordService materialInfoHandleRecordService;
    @Resource
    private ISysDepartService departService;

    /**
     * 分页列表查询
     *
     * @param materialInfo
     * @param pageNo
     * @param pageSize
     * @return
     */
  /*  @AutoLog(value = "厂区资料管理-分页列表查询")
    @ApiOperation(value = "厂区资料管理-分页列表查询", notes = "厂区资料管理-分页列表查询")
    @GetMapping(value = "/list")
    public Result<IPage<MaterialInfo>> queryPageList(MaterialInfo materialInfo,
                                                     @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                                                     @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize) {
      *//*  String departIds = null;
        if (StringUtils.isBlank(materialInfo.getDepartId())&&StringUtils.isNotBlank(BaseContextHandler.getDeparts())) {
            departIds = departService.getChildDepartId(BaseContextHandler.getDeparts());
        }else{
            departIds = departService.getChildDepartId(materialInfo.getDepartId());
        }
        IPage<MaterialInfo> pageList = materialInfoService.getList(page, materialInfo, departIds);
*//*
        Result<IPage<MaterialInfo>> result = new Result<IPage<MaterialInfo>>();
        Page<MaterialInfo> page = new Page<MaterialInfo>(pageNo, pageSize);
        QueryWrapper<MaterialInfo> queryWrapper = getMaterialInfoQueryWrapper(materialInfo);
        queryWrapper.eq("status","3");
        IPage<MaterialInfo> pageList = materialInfoService.page(page, queryWrapper);
        result.setSuccess(true);
        result.setResult(pageList);
        return result;
    }*/

    @AutoLog(value = "厂区资料管理-法律法规分页列表")
    @ApiOperation(value = "厂区资料管理-法律法规分页列表", notes = "厂区资料管理-法律法规分页列表")
    @GetMapping(value = "/list")
    public Result<IPage<MaterialInfo>> queryFLFGPageList(MaterialInfo materialInfo,
                                                            @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                                                            @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize) {
        Result<IPage<MaterialInfo>> result = new Result<IPage<MaterialInfo>>();
        Page<MaterialInfo> page = new Page<MaterialInfo>(pageNo, pageSize);
        QueryWrapper<MaterialInfo> queryWrapper = new QueryWrapper();
        queryWrapper.eq("del_flag","0");
        if(StringUtils.isNotEmpty(materialInfo.getFacInformationtype())){
            queryWrapper.eq("fac_informationtype",materialInfo.getFacInformationtype());
        }
        if(StringUtils.isNotEmpty(materialInfo.getFacInformationName())){
            queryWrapper.like("fac_information_name",materialInfo.getFacInformationName());
        }
        if(StringUtils.isNotEmpty(materialInfo.getRulesType())){
            queryWrapper.eq("rules_type",materialInfo.getRulesType());
        }
        if(StringUtils.isNotEmpty(materialInfo.getLawsType())){
            queryWrapper.eq("laws_type",materialInfo.getLawsType());
        }
        if(StringUtils.isNotEmpty(materialInfo.getStandardsType())){
            queryWrapper.eq("standards_type",materialInfo.getStandardsType());
        }
        queryWrapper.eq("status","3");
        IPage<MaterialInfo> pageList = materialInfoService.page(page, queryWrapper);
        result.setSuccess(true);
        result.setResult(pageList);
        return result;
    }

    @AutoLog(value = "厂区资料管理-待审核列表")
    @ApiOperation(value = "厂区资料管理-待审核列表", notes = "厂区资料管理-待审核列表")
    @GetMapping(value = "/unAuditList")
    public Result<IPage<MaterialInfo>> queryUnAuditPageList(MaterialInfo materialInfo,
                                                     @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                                                     @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize) {
        Result<IPage<MaterialInfo>> result = new Result<IPage<MaterialInfo>>();
        Page<MaterialInfo> page = new Page<MaterialInfo>(pageNo, pageSize);
        QueryWrapper<MaterialInfo> queryWrapper = getMaterialInfoQueryWrapper(materialInfo);
        queryWrapper.in("status","'1','2'");
        IPage<MaterialInfo> pageList = materialInfoService.page(page, queryWrapper);
        result.setSuccess(true);
        result.setResult(pageList);
        return result;
    }
    @AutoLog(value = "厂区资料管理-我的")
    @ApiOperation(value = "厂区资料管理-我的", notes = "厂区资料管理-我的")
    @GetMapping(value = "/myList")
    public Result<IPage<MaterialInfo>> queryMyPageList(MaterialInfo materialInfo,
                                                            @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo,
                                                            @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize) {
        Result<IPage<MaterialInfo>> result = new Result<IPage<MaterialInfo>>();
        Page<MaterialInfo> page = new Page<MaterialInfo>(pageNo, pageSize);
        QueryWrapper<MaterialInfo> queryWrapper = getMaterialInfoQueryWrapper(materialInfo);
        //queryWrapper.in("status","'1','2'");
        IPage<MaterialInfo> pageList = materialInfoService.page(page, queryWrapper);
        result.setSuccess(true);
        result.setResult(pageList);
        return result;
    }


    private QueryWrapper<MaterialInfo> getMaterialInfoQueryWrapper(MaterialInfo materialInfo){
        QueryWrapper<MaterialInfo> queryWrapper = new QueryWrapper();
        String departIds = null;
        if (StringUtils.isBlank(materialInfo.getDepartId())&&StringUtils.isNotBlank(BaseContextHandler.getDeparts())) {
            departIds = departService.getChildDepartId(BaseContextHandler.getDeparts());
        }else{
            departIds = departService.getChildDepartId(materialInfo.getDepartId());
        }
        // Page<MaterialInfo> page = new Page<ErpSettlement>(pageNo, pageSize);
        queryWrapper.eq("del_flag","0");
        queryWrapper.in("depart_id", JSUtils.quoteEach(departIds,","));
        if(StringUtils.isNotEmpty(materialInfo.getFacInformationtype())){
            queryWrapper.eq("fac_informationtype",materialInfo.getFacInformationtype());
        }
        //facInformationName
        if(StringUtils.isNotEmpty(materialInfo.getFacInformationName())){
            queryWrapper.like("fac_information_name",materialInfo.getFacInformationName());
        }
        if(StringUtils.isNotEmpty(materialInfo.getRulesType())){
            queryWrapper.eq("rules_type",materialInfo.getRulesType());
        }
        if(StringUtils.isNotEmpty(materialInfo.getLawsType())){
            queryWrapper.eq("laws_type",materialInfo.getLawsType());
        }
        if(StringUtils.isNotEmpty(materialInfo.getStandardsType())){
            queryWrapper.eq("standards_type",materialInfo.getStandardsType());
        }
        return queryWrapper;
    }




    /**
     * 添加
     * @param materialInfo
     * @return
     */
    @AutoLog(value = "厂区资料管理-添加")
    @ApiOperation(value = "厂区资料管理-添加", notes = "厂区资料管理-添加")
    @PostMapping(value = "/add")
    public Result<MaterialInfo> add(@RequestBody MaterialInfo materialInfo) {
        Result<MaterialInfo> result = new Result<MaterialInfo>();
        try {
            if (StringUtils.isBlank(materialInfo.getDepartId())) {
                String userCode = BaseContextHandler.getUserId();
                //根据用户id查询所属厂区 只要第一个
                materialInfo.setDepartId(materialInfoService.queryFacByUserId(userCode));
            }
            materialInfoService.save(materialInfo);
            result.success("添加成功！");
        } catch (Exception e) {
            log.error(e.getMessage(), e);
            result.error500("操作失败");
        }
        return result;
    }

    /**
     * 编辑
     * @param materialInfo
     * @return
     */
    @AutoLog(value = "厂区资料管理-编辑")
    @ApiOperation(value = "厂区资料管理-编辑", notes = "厂区资料管理-编辑")
    @PutMapping(value = "/edit")
    public Result<MaterialInfo> edit(@RequestBody MaterialInfo materialInfo) {
        Result<MaterialInfo> result = new Result<MaterialInfo>();
        MaterialInfo MaterialInfoEntity = materialInfoService.getById(materialInfo.getId());
        if (MaterialInfoEntity == null) {
            result.error500("未找到对应实体");
        } else {
            boolean ok = materialInfoService.updateById(materialInfo);
            if (ok) {
                result.success("修改成功!");
            }
        }

        return result;
    }

    @AutoLog(value = "厂区资料管理-送审")
    @ApiOperation(value="厂区资料管理-送审", notes="厂区资料管理-送审")
    @GetMapping(value = "/sendAudit")
    public Result<MaterialInfo> sendAudit(@RequestParam(name="id",required=true) String id) {
        Result<MaterialInfo> result = new Result<>();
        MaterialInfo materialInfo = materialInfoService.getById(id);
        if(materialInfo==null) {
            result.error500("未找到对应实体");
        }else {
            materialInfo.setStatus("1");
            materialInfoService.updateById(materialInfo);
            result.setResult(materialInfo);
            result.setSuccess(true);
        }
        return result;
    }
    @AutoLog(value = "厂区资料管理-审批")
    @ApiOperation(value="厂区资料管理-审批", notes="厂区资料管理-审批(status=3 审核通过，status=2 驳回)")
    @PutMapping(value = "/audit")
    public Result<MaterialInfo> auditPurchasePlan(@RequestBody MaterialInfo materialInfo) {
        Result<MaterialInfo> result = new Result<>();
        //purchaseContract.setStatus("1");
        //purchaseContract.setApplyUser(BaseContextHandler.getUserId());
        //purchaseContract.setApplyTime(DateUtils.now());
        materialInfo.setApproveUser(BaseContextHandler.getUserName());
        materialInfo.setUpdateTime(new Date());
        materialInfoService.updateById(materialInfo);
        result.setResult(materialInfo);
        result.setSuccess(true);
        return result;
    }


    /**
     * <pre>
     * 更新浏览量/下载量
     * </pre>
     * @return
     * @author Li Yuanyuan, 2022年6月22日 下午2:15:57
     */
    @AutoLog(value = "厂区资料管理-更新浏览量/下载量")
    @ApiOperation(value = "厂区资料管理-更新浏览量/下载量", notes = "厂区资料管理-更新浏览量/下载量")
    @GetMapping(value = "/operationRecord")
    public Result<MaterialInfo> operationRecord(@RequestParam(name = "id", required = true) String id,@ApiParam(name = "operationType",value ="操作类型download/browse") @RequestParam(name = "operationType", required = true) String operationType) {
        Result<MaterialInfo> result = new Result<MaterialInfo>();
        MaterialInfoHandleRecord MaterialInfoHandleRecord = new MaterialInfoHandleRecord();
        MaterialInfoHandleRecord.setInfoId(id);
        MaterialInfoHandleRecord.setCreateUser(BaseContextHandler.getUserId());
        MaterialInfoHandleRecord.setHandleType(operationType);
        MaterialInfoHandleRecord.setCreateTime(DateUtils.getTodayOrMonthDate("day"));
        boolean ok = materialInfoHandleRecordService.save(MaterialInfoHandleRecord);
        if(ok) {
        	result.success("操作记录成功!");
        }else {
        	result.error500("系统异常");
        }
        return result;
    }

    /**
     * 通过id删除
     *
     * @param id
     * @return
     */
    @AutoLog(value = "厂区资料管理-通过id删除")
    @ApiOperation(value = "厂区资料管理-通过id删除", notes = "厂区资料管理-通过id删除")
    @DeleteMapping(value = "/delete")
    public Result<?> delete(@RequestParam(name = "id", required = true) String id) {
        try {
            materialInfoService.removeById(id);
        } catch (Exception e) {
            log.error("删除失败", e.getMessage());
            return Result.error("删除失败!");
        }
        return Result.ok("删除成功!");
    }

    /**
     * 批量删除
     *
     * @param ids
     * @return
     */
    @AutoLog(value = "厂区资料管理-批量删除")
    @ApiOperation(value = "厂区资料管理-批量删除", notes = "厂区资料管理-批量删除")
    @DeleteMapping(value = "/deleteBatch")
    public Result<MaterialInfo> deleteBatch(@RequestParam(name = "ids", required = true) String ids) {
        Result<MaterialInfo> result = new Result<MaterialInfo>();
        if (ids == null || "".equals(ids.trim())) {
            result.error500("参数不识别！");
        } else {
            this.materialInfoService.removeByIds(Arrays.asList(ids.split(",")));
            result.success("删除成功!");
        }
        return result;
    }

    /**
     * 通过id查询
     *
     * @param id
     * @return
     */
    @AutoLog(value = "厂区资料管理-通过id查询")
    @ApiOperation(value = "厂区资料管理-通过id查询", notes = "厂区资料管理-通过id查询")
    @GetMapping(value = "/queryById")
    public Result<MaterialInfo> queryById(@RequestParam(name = "id", required = true) String id) {
        Result<MaterialInfo> result = new Result<MaterialInfo>();
        MaterialInfo MaterialInfo = materialInfoService.getById(id);
        if (MaterialInfo == null) {
            result.error500("未找到对应实体");
        } else {
            result.setResult(MaterialInfo);
            result.setSuccess(true);
        }
        return result;
    }

    /**
     * 导出excel
     *
     * @param request
     * @param response
     */
    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, HttpServletResponse response) {
        // Step.1 组装查询条件
        QueryWrapper<MaterialInfo> queryWrapper = null;
        try {
            String paramsStr = request.getParameter("paramsStr");
            if (StringUtils.isNotEmpty(paramsStr)) {
                String deString = URLDecoder.decode(paramsStr, "UTF-8");
                MaterialInfo MaterialInfo = JSON.parseObject(deString, MaterialInfo.class);
                queryWrapper = QueryGenerator.initQueryWrapper(MaterialInfo, request.getParameterMap());
            }
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
        }

        //Step.2 AutoPoi 导出Excel
        ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
        List<MaterialInfo> pageList = materialInfoService.list(queryWrapper);
        //导出文件名称
        mv.addObject(NormalExcelConstants.FILE_NAME, "厂区资料管理列表");
        mv.addObject(NormalExcelConstants.CLASS, MaterialInformation.class);
        mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("厂区资料管理列表数据", "导出人:Jeecg", "导出信息"));
        mv.addObject(NormalExcelConstants.DATA_LIST, pageList);
        return mv;
    }

    /**
     * 通过excel导入数据
     *
     * @param request
     * @param response
     * @return
     */
    @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
    public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
        MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
        Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
        for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
            MultipartFile file = entity.getValue();// 获取上传文件对象
            ImportParams params = new ImportParams();
            params.setTitleRows(2);
            params.setHeadRows(1);
            params.setNeedSave(true);
            try {
                List<MaterialInfo> listMaterialInformations = ExcelImportUtil.importExcel(file.getInputStream(), MaterialInfo.class, params);
                materialInfoService.saveBatch(listMaterialInformations);
                return Result.ok("文件导入成功！数据行数:" + listMaterialInformations.size());
            } catch (Exception e) {
                log.error(e.getMessage(), e);
                return Result.error("文件导入失败:" + e.getMessage());
            } finally {
                try {
                    file.getInputStream().close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        return Result.ok("文件导入失败！");
    }

    @AutoLog(value = "安全态势总览-安全生成知识库")
    @ApiOperation(value = "安全态势总览-安全生成知识库", notes = "安全态势总览-安全生成知识库")
    @GetMapping(value = "/statistics")
    public Result<List<MaterialInfoStatisticsVO>> statistics() {
        Result<List<MaterialInfoStatisticsVO>> result = new Result<>();
      /*  if (StringUtils.isBlank(materialInfo.getDepartId())&&StringUtils.isNotBlank(BaseContextHandler.getDeparts())) {
            materialInfo.setDepartId(departService.getChildDepartId(BaseContextHandler.getDeparts()));
        }else{
            materialInfo.setDepartId(departService.getChildDepartId(materialInfo.getDepartId()));
        }*/
        List<MaterialInfoStatisticsVO> resultList = new ArrayList<>();
        List<MaterialInfoStatisticsVO> flfgDataList  = getMaterialInfoStatisticsSql("法律法规","flfg","laws_type");
        List<MaterialInfoStatisticsVO> bzgfDataList  = getMaterialInfoStatisticsSql("标准规范","bzgf","standards_type");
        List<MaterialInfoStatisticsVO> gzzdDataList  = getMaterialInfoStatisticsSql("企业安环制度","gzzd","rules_type");
        if(flfgDataList != null )  resultList.addAll(flfgDataList);
        if(bzgfDataList != null )  resultList.addAll(bzgfDataList);
        if(gzzdDataList != null )  resultList.addAll(gzzdDataList);
        result.setSuccess(true);
        result.setResult(resultList);
        return result;
    }
    private List<MaterialInfoStatisticsVO> getMaterialInfoStatisticsSql(String  fileTypeName,String fileType,String dictCode){
        String sql = "select  '"+fileTypeName+"' sonFileTypeName,  bbb.item_text file_type_name, aaa.* from ( ";
            sql += " SELECT  SUBSTRING_INDEX("+dictCode+", ',', 1) AS file_type, COUNT(*) AS count  FROM material_info where  fac_informationtype = '"+fileType+"' GROUP BY file_type ";
            sql += ")aaa";
            sql+=" left join ( ";
            sql += "SELECT item_text, item_value FROM sys_dict_item WHERE dict_id = ( SELECT id FROM sys_dict WHERE dict_code = '"+dictCode+"')";
            sql += ")bbb   on bbb.item_value = aaa.file_type ";
             JdbcTemplate masterDB = (JdbcTemplate) SpringContextUtils.getBean("master");
             List<MaterialInfoStatisticsVO> dataList = masterDB.query(sql,new BeanPropertyRowMapper<MaterialInfoStatisticsVO>(MaterialInfoStatisticsVO.class));
             return dataList;
    }



    /**
     * 类型统计查询
     * @param materialInfo
     * @return
     */
    @AutoLog(value = "厂区资料管理-类型统计查询")
    @ApiOperation(value = "厂区资料管理-类型统计查询", notes = "厂区资料管理-类型统计查询")
    @GetMapping(value = "/getAnalysis")
    public Result<List<Map<String, Object>>> getAnalysis(MaterialInfo materialInfo) {
        Result<List<Map<String, Object>>> result = new Result<>();
        if (StringUtils.isBlank(materialInfo.getDepartId())&&StringUtils.isNotBlank(BaseContextHandler.getDeparts())) {
            materialInfo.setDepartId(departService.getChildDepartId(BaseContextHandler.getDeparts()));
        }else{
            materialInfo.setDepartId(departService.getChildDepartId(materialInfo.getDepartId()));
        }
        List<Map<String, Object>> pageList = materialInfoService.getAnalysis(materialInfo);
        result.setSuccess(true);
        result.setResult(pageList);
        return result;
    }

    @AutoLog(value = "厂区资料管理-流量统计")
    @ApiOperation(value = "厂区资料管理-流量统计", notes = "厂区资料管理-流量统计")
    @GetMapping(value = "/flowStatistics")
    public Result<List<Map<String, Object>>> flowStatistics(String departId,String startTime,String endTime,String facInformationtype) {
        Result<List<Map<String, Object>>> result = new Result<>();
        if (StringUtils.isBlank(departId)&&StringUtils.isNotBlank(BaseContextHandler.getDeparts())) {
            departId = departService.getChildDepartId(BaseContextHandler.getDeparts());
        }else{
            departId = departService.getChildDepartId(departId);
        }
        List<Map<String, Object>> pageList = materialInfoService.flowStatistics(departId,startTime,endTime,facInformationtype);
        result.setSuccess(true);
        result.setResult(pageList);
        return result;
    }

}