package com.zy.asrs.controller;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.core.common.Cools;
import com.core.common.R;
import com.zy.asrs.entity.*;
import com.zy.asrs.entity.vo.QueryLocVo;
import com.zy.asrs.mapper.ReportQueryMapper;
import com.zy.asrs.service.LocDetlService;
import com.zy.asrs.service.LocMastService;
import com.zy.asrs.service.WaitPakinService;
import com.zy.asrs.service.WrkDetlService;
import com.zy.common.web.BaseController;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.text.SimpleDateFormat;
import java.util.*;

@RestController
@RequestMapping("/open/asrs")
public class MonitorController extends BaseController {

    @Autowired
    private WrkDetlService wrkDetlService;
    @Autowired
    private WaitPakinService waitPakinService;
    @Autowired
    private LocMastService locMastService;
    @Autowired
    private ReportQueryMapper  reportQueryMapper;
    @Autowired
    private LocDetlService locDetlService;

    /**
     * WMS任务查询接口
     * @param taskNo
     * @return
     */
    @PostMapping("queryTask")
    public R queryTask(@RequestParam("taskNo") String taskNo) {
        if (Cools.isEmpty(taskNo)) {
            return R.error("参数为空");
        }
        List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", taskNo));
        return R.ok(wrkDetls);
    }

    /**
     * WMS入库任务查询接口
     * @param barcode
     * @return
     */
    @PostMapping("/queryComb")
    public R queryComb(@RequestParam("combNo") String barcode) {
        if (Cools.isEmpty(barcode)) {
            return R.error("参数为空");
        }
        List<WaitPakin> waitPakins = waitPakinService.selectList(new EntityWrapper<WaitPakin>().eq("zpallet", barcode));
        return R.ok(waitPakins);
    }

    /**
     * WMS库存数据查询
     * @return
     */
    @GetMapping("/queryLoc")
    public R queryLoc() {
        QueryLocVo queryLocVo = new QueryLocVo();
        Map<String,Object> map = new HashMap<>();
        List<Map<String, Object>> list = new ArrayList<>();
        int emptyCount = locMastService.selectCount(new EntityWrapper<LocMast>().eq("loc_sts", "O"));
        int disableCount = locMastService.selectCount(new EntityWrapper<LocMast>().eq("loc_sts", "X"));
        int total =  locMastService.selectCount(new EntityWrapper<>());
        int stockCount = locMastService.selectCount(new EntityWrapper<LocMast>().eq("loc_sts", "F"));
        int used = locMastService.selectCount(new EntityWrapper<LocMast>().ne("loc_sts", "O"));
        map.put("在库", stockCount);
        map.put("空库", emptyCount);
        map.put("使用", used);
        map.put("禁用", disableCount);
        list.add(map);
        queryLocVo.setEmptyCount(emptyCount); // 空库位
        queryLocVo.setDisableCount(disableCount); // 禁用
        queryLocVo.setTotal(total); // 总数
        queryLocVo.setStockCount(stockCount); // 在库
        queryLocVo.setUsed(used); // 库位使用
        queryLocVo.setPie(list);
        queryLocVo.setUsedPr((double) used / total * 100); // 使用率
        return R.ok(queryLocVo);




//        Map<String,Object> map=new HashMap<String, Object>();
//        List<ChartBean>  list = new ArrayList<ChartBean>();
//
//        LocChartPie locUseRate = reportQueryMapper.getLocUseRate();
//        if(locUseRate!=null) {
//            ChartBean fqty = new ChartBean();
//            fqty.setName("在库库位");
//            fqty.setY(locUseRate.getFqty());
//            list.add(fqty);
//
//            ChartBean oqty = new ChartBean();
//            oqty.setName("空库位");
//            oqty.setY(locUseRate.getOqty());
//            list.add(oqty);
//
//            ChartBean uqty = new ChartBean();
//            uqty.setName("使用库位");
//            uqty.setY(locUseRate.getUqty());
//            list.add(uqty);
//
//            ChartBean xqty = new ChartBean();
//            xqty.setName("禁用库位");
//            xqty.setY(locUseRate.getXqty());
//            list.add(xqty);
//        }
//        map.put("rows",list);
//        return R.ok(map);
    }

    /**
     * WMS入出库折线图
     * @return
     */
    @GetMapping("/line/charts")
    public R lineCharts() {
        Map<String,Object> map=new HashMap<String, Object>();
        List<AxisBean> list = new ArrayList<AxisBean>();

        List<WorkChartAxis> listChart = reportQueryMapper.getChartAxis();

        if(listChart!=null) {
            ArrayList<Integer> data1 = new ArrayList<Integer>();
            ArrayList<Integer> data2 = new ArrayList<Integer>();

            SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
            Calendar calendar = Calendar.getInstance();
            calendar.add(Calendar.DATE, -12);
            for(int i=0;i<12;i++) {
                boolean flag = true;
                calendar.add(Calendar.DATE, 1);
                String str = sf.format(calendar.getTime());
                for(WorkChartAxis workChart : listChart) {
                    if(str.equals(workChart.getYmd())) {
                        data1.add(workChart.getInqty());
                        data2.add(workChart.getOutqty());
                        flag = false;
                        break;
                    }
                }
                if(flag) {
                    data1.add(0);
                    data2.add(0);
                }
            }
            AxisBean inqty = new AxisBean();
            inqty.setName("入库数量");
            Integer[] array1 = new Integer[data1.size()];
            inqty.setData(data1.toArray(array1));
            list.add(inqty);
            AxisBean outqty = new AxisBean();
            outqty.setName("出库数量");
            Integer[] array2 = new Integer[data2.size()];
            outqty.setData(data2.toArray(array2));
            list.add(outqty);
        }
        map.put("rows",list);
        return R.ok(map);
    }

    @GetMapping("/locDetl/statistics")
    public R locDetlStatistics() {
        List<LocDetl> list = locDetlService.query20();
        return R.ok(list);
    }
}