DIL-DAZHOU-WMS2/src/main/java/com/steerinfo/dil/controller/WmspGridMaterialController.java

package com.steerinfo.dil.controller;

import com.steerinfo.dil.feign.ESFeign;
import com.steerinfo.dil.model.WmspGridMaterial;
import com.steerinfo.dil.service.IWmspGridMaterialService;
import com.steerinfo.dil.service.impl.WmspGridMaterialServiceImpl;
import com.steerinfo.dil.util.BaseRESTfulController;
import com.steerinfo.dil.util.ColumnDataUtil;
import com.steerinfo.dil.util.PageListAdd;

import com.steerinfo.framework.controller.RESTfulResult;
import com.steerinfo.framework.service.pagehelper.PageHelper;
import com.steerinfo.framework.service.pagehelper.PageList;
import com.steerinfo.framework.utils.collection.ListUtils;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.apache.xmlbeans.impl.xb.xsdschema.Public;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;

import java.math.BigDecimal;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;

/**
 * WmspGridMaterial RESTful接口：
 * @author generator
 * @version 1.0-SNAPSHORT 2021-09-08 06:02
 * 类描述
 * 修订历史：
 * 日期：2021-09-08
 * 作者：generator
 * 参考：
 * 描述：WmspGridMaterial RESTful接口
 * @see null
 * @Copyright 湖南视拓信息技术股份有限公司. All rights reserved.
 */
@RestController
@RequestMapping("/${api.version}/wmspgridmaterials")
public class WmspGridMaterialController extends BaseRESTfulController {

    @Autowired
    WmspGridMaterialServiceImpl wmspGridMaterialService;
    @Autowired
    ColumnDataUtil columnDataUtil;
    @Autowired
    ESFeign esFeign;

    @PostMapping(value = "/insertGridMaterial")
    public RESTfulResult insertGridMaterial(@RequestBody WmspGridMaterial wmspGridMaterial) {
        int code = wmspGridMaterialService.insertSelective(wmspGridMaterial);
        return success(code);
    }

    @PostMapping(value = "/updateGridMeterial")
    public RESTfulResult updateGridMeterial(@RequestBody WmspGridMaterial wmspGridMaterial) {
        int data = wmspGridMaterialService.updateByPrimaryKeySelective(wmspGridMaterial);
        return success(data);
    }

    // 查询实时库存
    @ApiImplicitParam("api:167")
    @PostMapping(value = "/selectGridMaterialList")
    public RESTfulResult selectGridMaterialList(@RequestBody(required = false) Map<String, Object> mapVal,
                                                Integer pageNum,
                                                Integer pageSize,
                                                Integer apiId,
                                                String con) {
        if (con != null) {
            if (!"undefined".equals(con)) {
                String index = "get_gird_materiallist";//设置要查询的索引名称
                return success(esFeign.getConResult(mapVal, index, apiId, pageNum, pageSize, con));//获取查询结果
            }
        }

        List<Map<String, Object>> libaryInBoundList = null;
        if (mapVal.size() == 0) {
            //将查询结果存入索引中
            libaryInBoundList = wmspGridMaterialService.selectGridMaterial(mapVal);
            Map<String, Object> map1 = new HashMap<>();
            //添加索引
            map1.put("index", "get_gird_materiallist");
            //添加id
            map1.put("indexId", "GridMaterialListId");
            libaryInBoundList.add(map1);
            //新建索引
            esFeign.insertIndex(libaryInBoundList);
            //删除
            libaryInBoundList.remove(libaryInBoundList.size() - 1);
        }
        if (libaryInBoundList == null) {
            libaryInBoundList = wmspGridMaterialService.selectGridMaterial(mapVal);
        }
        PageHelper.startPage(pageNum, pageSize);
        List<Map<String, Object>> columnList = wmspGridMaterialService.selectGridMaterial(mapVal);
        PageListAdd pageList = columnDataUtil.tableColumnData(apiId, libaryInBoundList, columnList);
        //库龄预警
        for (Map mapValue : columnList) {
            BigDecimal gridId = (BigDecimal) mapValue.get("gridId");
            List<Map<String, Object>> map2 = wmspGridMaterialService.selectInboundTimeAndThreshold(gridId);
            //取出入库日期转换为时间戳
            for (Map<String, Object> map1 : map2) {
                Date inboundTime = (Date) map1.get("inboundTime");
                Date date1 = new Date();
                //当前时间减去入库日期
                long data1 = date1.getTime() - inboundTime.getTime();
                //日期
                long days = data1 / (1000 * 60 * 60 * 24);
                //小时
                long hours = (data1 - days * (1000 * 60 * 60 * 24)) / (1000 * 60 * 60);
                //分钟
                long minutes = (data1 - days * (1000 * 60 * 60 * 24) - hours * (1000 * 60 * 60)) / (1000 * 60);
                //获取标准值
                BigDecimal max = (BigDecimal) map1.get("max");
                Long Max = max.longValue();
                BigDecimal min = (BigDecimal) map1.get("min");
                Long Min = min.longValue();
                if (days < Max && days >= Min) {
                    return success();
                }
            }
        }
        return success(pageList);
    }
//统计实时库存数量
@PostMapping(value = "/countByGmId")
public RESTfulResult countByGmId() {
    Long code = wmspGridMaterialService.countByGmId();
    return success(code);
}


    // 通过成品仓库网格ID查询实时库存
    @ApiImplicitParam("通过成品仓库网格ID查询实时库存")
    @PostMapping(value = "/selectGridMaterialListByGridId")
    public RESTfulResult selectGridMaterialListByGridId(BigDecimal gridId) {
        Map<String,Object> mapVal = new HashMap<>();
        mapVal.put("gridId",gridId);
        List<Map<String, Object>> list = wmspGridMaterialService.selectGridMaterialListByGridId(mapVal);
        return success(list);
    }

    // 修改物资钢材表的质量是否合格字段和逻辑删除
    @ApiImplicitParam("修改物资钢材表的质量是否合格字段和逻辑删除")
    @PostMapping(value = "/updateRmsMaterialSteelDemotion")
    public RESTfulResult updateRmsMaterialSteelDemotion(@RequestBody Map<String,Object> map) {
        int i = wmspGridMaterialService.updateRmsMaterialSteelDemotion(map);
        return success(i);
    }

    /**
     * 1.查看实时库存物质在实时库存里面没有出库的物质！！！
     * @param
     * @return
     */
    @ApiOperation(value = "新增扫描吊牌实绩")
    @PostMapping("/getReboundScanResultByResultMaterial")
    @Transactional
    public  synchronized RESTfulResult getReboundScanResultByResultMaterial(@RequestBody(required = false)Map<String,Object>map) throws ParseException {

        //已存在的集合
        List<Map<String,Object>> list=null;
        if (map.containsKey("dateList")&&map.get("dateList")!=null){
            list=(List<Map<String, Object>>) map.get("dateList");
        }else{
            list=new ArrayList<>();
        }
        //判断是否重复扫描
        for (int i=0;i<list.size();i++){
            Map<String,Object> item=list.get(i);
            if (item.get("resultMaterial").toString().equals(map.get("resultMaterial").toString())){
                return success(list);
            }
        }
        //解析扫描信息
        //将扫描吊牌结果根据分隔符截取字符串
        String[] split = map.get("resultMaterial").toString().split("-");
        //唯一编码
        String MaterialOnlyCode=split[7];
        //查询是否未出库
        Map<String,Object> result= wmspGridMaterialService.getReboundScanResultByResultMaterial(map.get("resultMaterial").toString().substring(0,map.get("resultMaterial").toString().length()-1),MaterialOnlyCode);


        if (result!=null){
            //赋值一个主键
            result.put("resultMaterial",map.get("resultMaterial").toString());
            //如果没有出库就需要这件钢材放到未出库钢材集合里面
            list.add(result);
        }

        return success(list);
    }



    @ApiOperation(value = "获得物质类型",notes = "根据仓库垛位层号获得物质类型")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "warehouseid",dataType = "DECIMAL",value = "仓库"),
            @ApiImplicitParam(name = "stackingId",dataType = "BigDicemal",value = "垛位"),
            @ApiImplicitParam(name = "gradtionNumber",dataType = "BigDicemal",value = "层号")

    })
    @GetMapping("/getMaterialTypeList")
    public  RESTfulResult getMaterialTypeList(String warehouseid,BigDecimal stackingId,BigDecimal gradtionNumber){
        //获得一个list<Map<String,Object>> map里面包括：物质Id、物质名称、物质型号、理论重量、物质件数
        List<Map<String,Object>> map=wmspGridMaterialService.getMaterialTypeList(warehouseid,stackingId,gradtionNumber);
        return success();
    }
}