package com.landtool.lanbase.modules.spcData.controller;

import cn.hutool.core.collection.CollectionUtil;
import com.alibaba.druid.support.json.JSONUtils;
import com.alibaba.druid.util.StringUtils;
import com.alibaba.fastjson.JSON;
import com.google.gson.Gson;
import com.landtool.lanbase.common.utils.Result;
import com.landtool.lanbase.modules.spcData.entity.SpcDataMenu;
import com.landtool.lanbase.modules.spcData.entity.SpcMetadata;
import com.landtool.lanbase.modules.spcData.service.SpcDataService;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.io.File;
import java.io.FileReader;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

@RestController
@RequestMapping("/spcData")
public class SpcDataController {

    @Autowired
    private SpcDataService spcDataService;

    @RequestMapping("/queryMenu")
//    @RequiresPermissions(value="role:ztsj:list")
    public Result queryMenu() {

        List<SpcDataMenu> spcDataMenuList = spcDataService.queryMenu();

        return Result.ok().put("Menu", spcDataMenuList);

    }

    @RequestMapping("/addMenu")
//    @RequiresPermissions(value="role:ztsj:edit")
    public Result addSpcDataMenu(@RequestBody SpcDataMenu spcDataMenu) {

        spcDataService.addSpcDataMenu(spcDataMenu);

        return Result.ok();

    }

    @RequestMapping("/delMenu")
//    @RequiresPermissions(value="role:ztsj:edit")
    public Result delSpcDataMenu(@RequestBody List<Integer> idLists) {

        if (CollectionUtil.isNotEmpty(idLists)) {
            // 删除专题数据菜单
            spcDataService.delSpcDataMenu(idLists);
            // 删除菜单对应的元数据
            spcDataService.delMetaDataByMenuS(idLists);
        }
        ;

        return Result.ok();
    }

    @RequestMapping("/modifySpcDataMenu")
//    @RequiresPermissions(value="role:ztsj:edit")
    public Result modifySpcDataMenu(@RequestBody SpcDataMenu spcDataMenu) {

        spcDataService.modifySpcDataMenu(spcDataMenu);

        return Result.ok();
    }

    @RequestMapping("/addMetaData")
//    @RequiresPermissions(value="role:ztsj:edit")
    public Result addMetaData(@RequestBody SpcMetadata spcMetadata) {
        if(null==spcMetadata.getId()){
            spcDataService.addMetaData(spcMetadata);
            // 更新对应spc_data_menu：metadataId
            SpcDataMenu spcDataMenu = new SpcDataMenu();
            spcDataMenu.setMetadataId(spcMetadata.getId());
            spcDataMenu.setId(spcMetadata.getMenuId());
            spcDataService.modifySpcDataMenu(spcDataMenu);
            return Result.ok();
        }
        spcDataService.modifyMetaData(spcMetadata);
        return Result.ok();
    }

    @RequestMapping("/delMetaData")
//    @RequiresPermissions(value="role:ztsj:edit")
    public Result delMetaData(@RequestBody SpcMetadata spcMetadata) {

        spcDataService.delMetaData(spcMetadata);

        return Result.ok();
    }

    @RequestMapping("/modifyMetaData")
//     @RequiresPermissions(value="role:ztsj:edit")
    public Result modifyMetaData(@RequestBody SpcMetadata spcMetadata) {

        spcDataService.modifyMetaData(spcMetadata);

        return Result.ok();

    }

    @RequestMapping("/queryMetaData")
//    @RequiresPermissions(value="role:ztsj:list")
    public Result queryMetaData(@RequestBody SpcMetadata spcMetadata) {

        SpcMetadata spcData = spcDataService.queryMetaData(spcMetadata);
        spcData.setMenuId(spcMetadata.getMenuId());
        return Result.ok().put("data", spcData);

    }


    @RequestMapping("/statistics")
//    @RequiresPermissions(value="role:ztsj:list")
    public Result getStatistics( String strName,Integer type) {
        Map<String, Object> maps = spcDataService.getStatistics(strName,type);
        return Result.ok().put("data", maps);
    }


        @RequestMapping("/getTbNums")
//    @RequiresPermissions(value="role:ztsj:list")
    public Result getTbNums(String strType,String strCount) {
        List<SpcMetadata> spcMetadatas= spcDataService.queryMetaDatas();
        Map<String, Integer> maps = new HashMap<>();
        spcMetadatas.stream().forEach(
               spcMetadata -> {
                   Map<String, String> sourceMap = (Map<String, String>) JSONUtils.parse(spcMetadata.getMetadata());
                   String type = sourceMap.get(strType);
                   String num = sourceMap.get(strCount);
                   Integer numCount=0;
                   if(!StringUtils.isEmpty(num)){
                       numCount=Integer.valueOf(num);
                   }
                   if(maps.containsKey(type)){
                       //已经存在累加
                       maps.put(type,maps.get(type)+numCount);
                   }else {
                       //第一次新增
                       maps.put(type,numCount);
                   }
               }
        );

        return Result.ok().put("data", maps);
    }



    @RequestMapping("/test/addJson")
//    @RequiresPermissions(value="role:ztsj:list")
    public Result test() throws Exception {
        SpcDataMenu spcDataMenu = new SpcDataMenu();
        SpcMetadata spcMetadata = new SpcMetadata();
        ArrayList<Map<String, Object>> arrayList = new ArrayList<>();
        List<Map<String, Object>> list = new Gson().fromJson(new FileReader(new File("C:\\Users\\Lenovo\\Desktop\\menudata.json")), List.class);
        for (Map<String, Object> map : list) {
            HashMap<String, Object> param = new HashMap<>();
            param.put("pId", (String) map.get("pId"));
            param.put("oldId", map.get("id"));
            spcDataMenu.setpId(0);
            spcDataMenu.setName((String) map.get("name"));
            spcDataMenu.setType(0);
            spcDataMenu.setTableName((String) map.get("tableName"));
            spcDataService.addSpcDataMenu(spcDataMenu);
            param.put("id", spcDataMenu.getId());
            spcMetadata.setMetadata(JSON.toJSONString(map.get("value")));
            spcMetadata.setMenuId(spcDataMenu.getId());
            spcDataService.addMetaData(spcMetadata);
            spcDataMenu.setMetadataId(spcMetadata.getId());
            spcDataMenu.setId(spcMetadata.getMenuId());
            spcDataService.modifySpcDataMenu(spcDataMenu);
            arrayList.add(param);
        }
        for (Map<String, Object> map : arrayList) {
            Integer id = (Integer) map.get("id");
            String oldId = (String) map.get("oldId");
            String pId = (String) map.get("pId");
            for (Map<String, Object> map2 : arrayList) {
                String pId2 = (String) map2.get("pId");
                if(StringUtils.equals(pId2,oldId)){
					SpcDataMenu menu = new SpcDataMenu();
					menu.setId((Integer) map2.get("id"));
					menu.setpId(id);
					spcDataService.modifySpcDataMenu(menu);
				}
            }
        }

        return null;
    }

    public static void main(String[] args) {

    }
}