package com.skua.modules.erp.controller;

import java.util.*;
import java.io.UnsupportedEncodingException;
import java.net.URLDecoder;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.skua.core.api.vo.Result;
import com.skua.core.aspect.annotation.AutoLog;
import com.skua.core.context.BaseContextHandler;
import com.skua.core.query.QueryGenerator;
import com.skua.core.util.ConvertUtils;
import com.skua.core.util.DateUtils;
import com.skua.modules.common.service.ICommonSqlService;
import com.skua.modules.erp.entity.ErpSettlement;
import com.skua.modules.erp.entity.ErpSettlementItem;
import com.skua.modules.erp.service.IErpSettlementService;
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.modules.erp.vo.*;
import com.skua.modules.productionduty.utils.HolidaysUtils;
import com.skua.tool.util.JSUtils;
import lombok.extern.slf4j.Slf4j;

import org.apache.commons.collections.map.HashedMap;
import org.apache.commons.lang3.StringUtils;
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;
import com.alibaba.fastjson.JSON;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;

@Slf4j
@Api(tags="药剂结算单详情")
@RestController("webErpSettlementController")
@RequestMapping("/web/erp/erpSettlement")
public class ErpSettlementController {
	@Autowired
	private IErpSettlementService erpSettlementService;
	@Autowired
	private ICommonSqlService  commonSqlService;

	@AutoLog(value = "药剂结算单详情-分页列表查询")
	@ApiOperation(value="药剂结算单详情-分页列表查询(settlementType = 0 供应商结算集合，settlementType= 1 水厂结算)", notes="药剂结算单详情-分页列表查询")
	@GetMapping(value = "/list")
	public Result<IPage<ErpSettlement>> queryPageList(ErpSettlement erpSettlement,
													  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
													  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
													  HttpServletRequest req) {
		Result<IPage<ErpSettlement>> result = new Result<IPage<ErpSettlement>>();
		QueryWrapper<ErpSettlement> queryWrapper =  QueryGenerator.initQueryWrapper(erpSettlement, req.getParameterMap());
		Page<ErpSettlement> page = new Page<ErpSettlement>(pageNo, pageSize);
		//水务公司
		if(StringUtils.isNotEmpty(erpSettlement.getDepartId())){
			queryWrapper.eq("depart_id" ,erpSettlement.getDepartId()) ;
		}
		//供应商
		if(StringUtils.isNotEmpty(erpSettlement.getSupplierId())){
			queryWrapper.eq("supplier_id" ,erpSettlement.getSupplierId()) ;
		}
		//结算类型
		queryWrapper.eq("settlement_type" ,erpSettlement.getSettlementType()) ;

		//根据角色限制列表

		/*String startDate = req.getParameter("startDate");
		if(StringUtils.isNotEmpty(startDate)){
			startDate = startDate+" 00:00:00";
			queryWrapper.ge("settlement_time",startDate);
		}
		String endDate = req.getParameter("endDate");
		if(StringUtils.isNotEmpty(endDate)){
			endDate = endDate+" 23:59:59";
			queryWrapper.le("settlement_time",endDate );
		}*/
		IPage<ErpSettlement> pageList = null;
		if("0".equals(erpSettlement.getSettlementType())){
			pageList = erpSettlementService.querySettlementPageBySupplier(page, queryWrapper);
		}else{
			pageList = erpSettlementService.page(page, queryWrapper);
		}
		result.setSuccess(true);
		result.setResult(pageList);
		return result;
	}

	@AutoLog(value = "药剂结算单详情-根据ids生成供应商结算")
	@ApiOperation(value="药剂结算单详情-根据ids生成供应商结算", notes="药剂结算单详情-供应商结算")
	@GetMapping(value = "/supplierSettlement")
	public Result<ErpSettlementVO> supplierSettlement(@RequestParam(name="ids",required=true) String ids) {
		Result<ErpSettlementVO> result = new Result<>();
		ErpSettlementVO  erpSettlementVO = null;
		if(StringUtils.isEmpty(ids)){
			result.error500("请选择记录进行结算");
			return result;
		}
		//校验供应商
		List<ErpSettlementVO> settlementVOList = erpSettlementService.checkSettlementBySupplier(JSUtils.quoteEach(ids,","));
		if(settlementVOList==null || settlementVOList.isEmpty()) {
			result.error500("根据供应商与合同号未找到实体");
			return result;
		}
		String  supplierName = "";
		String contractCode = "";
		if(settlementVOList != null ){
			for(ErpSettlementVO  settlementVO : settlementVOList){
				erpSettlementVO = settlementVO;
				erpSettlementVO.setSettlementType("0");

				if(supplierName.length() >0 ) supplierName+=",";
				supplierName += ConvertUtils.getString(settlementVO.getSupplierName(),"");
				contractCode += settlementVO.getContractCode();
			}
		}
		String[] supplierNameList = supplierName.split(",");
		if(settlementVOList  != null && settlementVOList.size() > 1){
			result.error500("查询多个供应商："+supplierName+";合同号："+contractCode+"记录;请选择某一个供应商，同一合同");
		}else{
			List<ErpSettlementItemVO> erpSettlementItemList = erpSettlementService.querySupplierSettlementByMaterialIds(JSUtils.quoteEach(ids,","));
			if(erpSettlementItemList != null && !erpSettlementItemList.isEmpty()){
				erpSettlementVO.setItemList( erpSettlementItemList );
				erpSettlementVO.setSparepartSettlementList( converErpSettlementItemList(erpSettlementItemList)  );
				// 计算总价、总数、价税合计
				erpSettlementVO.calculatePrice();
				result.setResult(erpSettlementVO);
				result.setSuccess(true);
			}else{
				result.error500("未找到审核通过的记录！");
				return result;
			}
		}
		return result;
	}

	@AutoLog(value = "药剂结算单详情-根据ids生成水厂结算")
	@ApiOperation(value="药剂结算单详情-根据ids生成水厂结算", notes="药剂结算单详情-水厂结算")
	@GetMapping(value = "/waterDepartSettlement")
	public Result<ErpSettlementVO> waterDepartSettlement(@RequestParam(name="ids",required=true) String ids) {
		Result<ErpSettlementVO> result = new Result<ErpSettlementVO>();
		ErpSettlementVO  erpSettlementVO = null;
		if(StringUtils.isEmpty(ids)){
			result.error500("请选择记录进行结算");
			return result;
		}

		List<ErpSettlementVO> settlementVOList = erpSettlementService.checkSettlementByWaterDepart(JSUtils.quoteEach(ids,","));
		if(settlementVOList==null || settlementVOList.isEmpty()) {
			result.error500("根据部门与合同号未找到实体");
			return result;
		}
		String  departName = "";
		String contractCode = "";

		if(settlementVOList != null ){
			for(ErpSettlementVO  settlementVO : settlementVOList){
				erpSettlementVO = settlementVO;
				erpSettlementVO.setSettlementType("1");
				if(departName.length() >0 ) departName+=",";
				departName += settlementVO.getDepartName();
				contractCode += settlementVO.getContractCode();
			}
		}
		String[] supplierNameList = departName.split(",");
		if(settlementVOList  != null && settlementVOList.size() > 1){
			result.error500("查询出多个水厂："+departName+"；合同编号:"+contractCode+"记录;请选择某一个水厂，同一合同");
		}else{
			List<ErpSettlementItemVO> settlementItemList = erpSettlementService.queryWaterDepartSettlementByMaterialIds(JSUtils.quoteEach(ids,","));
			if(settlementItemList != null && !settlementItemList.isEmpty()){
				erpSettlementVO.setItemList(settlementItemList );
				//送货单以及物资验收单
				erpSettlementVO.setSparepartSettlementList( converErpSettlementItemList(settlementItemList)  );

				// 计算总价、总数、价税合计
				erpSettlementVO.calculatePrice();
				result.setResult(erpSettlementVO);
				result.setSuccess(true);
			}else{
				result.error500("未找到审核通过的记录！");
				return result;
			}
		}
		return result;
	}

	/***
	 * 转换ErpSettlementItem
	 * @return
	 */
	private List<SparepartSettlementVO>  converErpSettlementItemList(List<ErpSettlementItemVO> settlementItemList ){
		String jtDepartName = commonSqlService.queryForString("select depart_name  from sys_depart order by parent_id asc  limit 1");
		Map<String, SparepartSettlementVO>  sparepartSettlementMap = new HashedMap();
		SparepartSettlementVO  sparepartSettlementVO = null;
		if(settlementItemList != null ){
			for( ErpSettlementItemVO  settlementItem  : settlementItemList){
				sparepartSettlementVO = sparepartSettlementMap.get(settlementItem.getSparepartId());
				if(sparepartSettlementVO == null ){
					//String projectName,String departName, String contractCode, String sparepartName, String specification, String goodOrigin, String goodBrand
					sparepartSettlementVO = new SparepartSettlementVO(settlementItem.getProjectName(),settlementItem.getDepartName(),settlementItem.getContractCode(),
							settlementItem.getSparepartName(),settlementItem.getSpecification(),settlementItem.getGoodCode() ,settlementItem.getGoodBrand() );
					sparepartSettlementVO.setJtDepartName(jtDepartName);
					sparepartSettlementVO.setSupplierName( settlementItem.getSupplierName()  );
					sparepartSettlementVO.setContractName(settlementItem.getContractName() );
					sparepartSettlementMap.put( settlementItem.getSparepartId() ,sparepartSettlementVO );
				}
				sparepartSettlementVO.addErpSettlementItem( settlementItem );
			}
		}
		return new ArrayList(sparepartSettlementMap.values());
	}


	@AutoLog(value = "药剂结算单-添加")
	@ApiOperation(value="药剂结算单-添加", notes="药剂结算单-添加")
	@PostMapping(value = "/add")
	public Result<ErpSettlementVO> add(@RequestBody ErpSettlementVO erpSettlementVO) {
		Result<ErpSettlementVO> result = new Result<ErpSettlementVO>();
		try {
			if(StringUtils.isEmpty(erpSettlementVO.getApplyTime())){
				erpSettlementVO.setApplyTime(DateUtils.format(new Date(), HolidaysUtils.DATE_TIME_PATTERN));
			}
			if(StringUtils.isEmpty(erpSettlementVO.getApplySign())){
				erpSettlementVO.setApplySign(BaseContextHandler.getUserName());
			}
			erpSettlementService.saveSettlement(erpSettlementVO);
			result.success("添加成功！");
		} catch (Exception e) {
			log.error(e.getMessage(),e);
			result.error500("操作失败");
		}
		return result;
	}

	@AutoLog(value = "药剂结算单详情-编辑")
	@ApiOperation(value="药剂结算单详情-编辑", notes="药剂结算单详情-编辑")
	@PutMapping(value = "/edit")
	public Result<ErpSettlementVO> edit(@RequestBody ErpSettlementVO erpSettlement) {
		Result<ErpSettlementVO> result = new Result<ErpSettlementVO>();
		ErpSettlement erpSettlementEntity = erpSettlementService.getById(erpSettlement.getId());
		if(erpSettlementEntity==null) {
			result.error500("未找到对应实体");
		}else {
			boolean ok = erpSettlementService.updateSettlement(erpSettlement);
			if(ok) {
				result.success("修改成功!");
			}
		}
		return result;
	}

	@AutoLog(value = "药剂结算单详情-审批")
	@ApiOperation(value="药剂结算单详情-审批", notes="药剂结算单详情-审批")
	@GetMapping(value = "/audit")
	public Result<?> audit(@RequestParam(name="id",required=true) String id,Integer auditStatus ,String approveMessage ) {
		Result<ErpSettlementVO> result = new Result<ErpSettlementVO>();
		ErpSettlement erpSettlementEntity = erpSettlementService.getById(id);
		erpSettlementEntity.setInspectTime(DateUtils.format(new Date(), HolidaysUtils.DATE_TIME_PATTERN));
		erpSettlementEntity.setAuditStatus(auditStatus);
		erpSettlementEntity.setApproveMessage(approveMessage);
		erpSettlementEntity.setInspectorSign(BaseContextHandler.getUserName());
		if(erpSettlementEntity==null) {
			result.error500("未找到对应实体");
		}else {
			boolean ok = erpSettlementService.auditAccept(erpSettlementEntity);
			if(ok) {
				result.success("操作成功!");
			}
		}
		return result;
	}
	@AutoLog(value = "药剂结算单详情-验收审批")
	@ApiOperation(value="药剂结算单详情-验收审批", notes="药剂结算单详情-验收审批")
	@GetMapping(value = "/auditAccept")
	public Result<?> auditAccept(@RequestParam(name="id",required=true) String id ) {
		Result<ErpSettlementVO> result = new Result<ErpSettlementVO>();
		ErpSettlement erpSettlementEntity = erpSettlementService.getById(id);
		erpSettlementEntity.setInspectTime(DateUtils.format(new Date(), HolidaysUtils.DATE_TIME_PATTERN));
		erpSettlementEntity.setAuditStatus(2);
		//erpSettlementEntity.setApproveMessage(approveMessage);
		erpSettlementEntity.setInspectorSign(BaseContextHandler.getUserName());
		if(erpSettlementEntity==null) {
			result.error500("未找到对应实体");
		}else {
			boolean ok = erpSettlementService.auditAccept(erpSettlementEntity);
			if(ok) {
				result.success("验收审批成功!");
			}
		}
		return result;
	}

	@AutoLog(value = "药剂结算单详情-经理审批")
	@ApiOperation(value="药剂结算单详情-经理审批", notes="药剂结算单详情-经理审批")
	@GetMapping(value = "/auditManager")
	public Result<?> auditManager(@RequestParam(name="id",required=true) String id ) {
		Result<ErpSettlementVO> result = new Result<ErpSettlementVO>();
		ErpSettlement erpSettlementEntity = erpSettlementService.getById(id);
		erpSettlementEntity.setApproveTime(DateUtils.format(new Date(), HolidaysUtils.DATE_TIME_PATTERN));
		erpSettlementEntity.setApproverSign(BaseContextHandler.getUserName());
		erpSettlementEntity.setAuditStatus(3);
		//erpSettlementEntity.setApproveMessage(approveMessage);
		if(erpSettlementEntity==null) {
			result.error500("未找到对应实体");
		}else {
			boolean ok = erpSettlementService.updateById(erpSettlementEntity);
			if(ok) {
				result.success("审批成功!");
			}
		}
		return result;
	}
	@AutoLog(value = "药剂结算单详情-结算")
	@ApiOperation(value="药剂结算单详情-结算", notes="药剂结算单详情-结算")
	@GetMapping(value = "/settlement")
	public Result<?> settlement(@RequestParam(name="id",required=true) String id) {
		Result<ErpSettlementVO> result = new Result<ErpSettlementVO>();
		ErpSettlement erpSettlementEntity = erpSettlementService.getById(id);
		erpSettlementEntity.setStatus(1);
		erpSettlementEntity.setSettlementTime(DateUtils.format(new Date(), HolidaysUtils.DATE_TIME_PATTERN));
		if(erpSettlementEntity==null) {
			result.error500("未找到对应实体");
		}else {
			//修改 入库表状态
			boolean ok = erpSettlementService.updateById(erpSettlementEntity);
			if(ok) {
                erpSettlementService.updateMaterialInSettlementFlag( erpSettlementEntity,"2");
				result.success("结算成功!");
			}
		}
		return result;
	}

	@AutoLog(value = "药剂结算单详情-通过id删除")
	@ApiOperation(value="药剂结算单详情-通过id删除", notes="药剂结算单详情-通过id删除")
	@DeleteMapping(value = "/delete")
	public Result<?> delete(@RequestParam(name="id",required=true) String id) {
		try {
			erpSettlementService.delById(id);
		} catch (Exception e) {
			log.error("删除失败",e.getMessage());
			return Result.error("删除失败!");
		}
		return Result.ok("删除成功!");
	}

	@AutoLog(value = "药剂结算单详情-批量删除")
	@ApiOperation(value="药剂结算单详情-批量删除", notes="药剂结算单详情-批量删除")
	@DeleteMapping(value = "/deleteBatch")
	public Result<ErpSettlement> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
		Result<ErpSettlement> result = new Result<ErpSettlement>();
		if(ids==null || "".equals(ids.trim())) {
			result.error500("参数不识别！");
		}else {
			this.erpSettlementService.removeByIds(Arrays.asList(ids.split(",")));
			result.success("删除成功!");
		}
		return result;
	}
	@AutoLog(value = "药剂结算单详情-通过id查询")
	@ApiOperation(value="药剂结算单详情-通过id查询", notes="药剂结算单详情-通过id查询")
	@GetMapping(value = "/queryById")
	public Result<ErpSettlementVO> queryById(@RequestParam(name="id",required=true) String id) {
		Result<ErpSettlementVO> result = new Result<ErpSettlementVO>();
		ErpSettlementVO erpSettlement = erpSettlementService.queryById(id);
		if(erpSettlement==null) {
			result.error500("未找到对应实体");
		}else {
			result.setResult(erpSettlement);
			result.setSuccess(true);
		}
		return result;
	}

  /*  @AutoLog(value = "药剂结算单详情-导出：(供应商)送货单以及物资验收单")
    @ApiOperation(value="药剂结算单详情-导出：（供应商）送货单以及物资验收单", notes="药剂结算单详情-导出：送货单以及物资验收单")
    @GetMapping(value = "/exportSupplierSupplierFormPDF")
    public Result<ErpSettlementFormVO> exportSupplierSupplierFormPDF(@RequestParam(name="id",required=true) String id) {
        Result<ErpSettlementFormVO> result = new Result<ErpSettlementFormVO>();
		ErpSettlementFormVO erpSettlement = erpSettlementService.querySupplierSettlementFormById(id);
        if(erpSettlement==null) {
            result.error500("未找到对应实体");
        }else {
            result.setResult(erpSettlement);
            result.setSuccess(true);
        }
        return result;
    }
	@AutoLog(value = "药剂结算单详情-导出：(供应商)送货单以及物资验收单")
	@ApiOperation(value="药剂结算单详情-导出：（供应商）送货单以及物资验收单", notes="药剂结算单详情-导出：送货单以及物资验收单")
	@GetMapping(value = "/exportWaterDepartSupplierFormPDF")
	public Result<ErpSettlementFormVO> exportWaterDepartSupplierFormPDF(@RequestParam(name="id",required=true) String id) {
		Result<ErpSettlementFormVO> result = new Result<ErpSettlementFormVO>();
		ErpSettlementFormVO erpSettlement = erpSettlementService.queryWaterDepartSettlementFormById(id);
		if(erpSettlement==null) {
			result.error500("未找到对应实体");
		}else {
			result.setResult(erpSettlement);
			result.setSuccess(true);
		}
		return result;
	}*/

  @RequestMapping(value = "/exportXls")
  public ModelAndView exportXls(ErpSettlement erpSettlement,HttpServletRequest request, HttpServletResponse response) {
      // Step.1 组装查询条件
      QueryWrapper<ErpSettlement> queryWrapper = null;
	  queryWrapper = QueryGenerator.initQueryWrapper(erpSettlement, request.getParameterMap());

      //Step.2 AutoPoi 导出Excel
      ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
      List<ErpSettlement> pageList = erpSettlementService.list(queryWrapper);
      //导出文件名称
      mv.addObject(NormalExcelConstants.FILE_NAME, "药剂结算单详情列表");
      mv.addObject(NormalExcelConstants.CLASS, ErpSettlement.class);
      mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("药剂结算单详情列表数据", "", "导出信息"));
      mv.addObject(NormalExcelConstants.DATA_LIST, pageList);
      return mv;
  }
}