ANTAI-WLTMS-API/src/main/java/com/steerinfo/dil/controller/RMScontroller.java

package com.steerinfo.dil.controller;

import com.alibaba.fastjson.JSONObject;
import com.steerinfo.dil.annotaion.LogAround;
import com.steerinfo.dil.annotaion.RequestLimit;
import com.steerinfo.dil.feign.RmsFeign;
import com.steerinfo.dil.util.BaseRESTfulController;
import com.steerinfo.dil.util.ExcelToolUtils;
import com.steerinfo.dil.util.PageListAdd;
import com.steerinfo.framework.controller.BaseController;
import com.steerinfo.framework.controller.RESTfulResult;
import com.steerinfo.framework.service.pagehelper.PageHelper;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import lombok.extern.java.Log;
import oracle.jdbc.proxy.annotation.Post;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.io.File;
import java.io.FileInputStream;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;

@RestController
@RequestMapping("${api.version}/rms")
public class RMScontroller extends BaseRESTfulController {
    @Autowired
    RmsFeign rmsFeign;

    @ApiOperation(value = "查询所有作业环节")
    @PostMapping("/getStepTypeList")
    public Map<String, Object> getStepTypeList() {
        return rmsFeign.getStepTypeList();
    }

    @ApiOperation(value = "查询运输路线")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "apiId", value = "249", required = false, dataType = "Integer"),
    })
    @PostMapping(value = "/getLineList")
    public Map<String, Object> getLineList(@RequestBody(required = false) Map<String, Object> mapValue,
                                           Integer pageNum,
                                           Integer pageSize,
                                           Integer apiId) {
        return rmsFeign.getLineList(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId);
    }

    @ApiOperation(value = "新增运输路线")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "运输路线", required = false, dataType = "Map"),
    })
    @PostMapping("/insertLine")
    @LogAround(foreignKeys = {"lineId"}, foreignKeyTypes = {"运输路线"})
    public Map<String, Object> insertLine(@RequestBody(required = false) Map<String, Object> mapVal) {
        return rmsFeign.insertLine(mapVal);
    }

    @ApiOperation(value = "删除运输路线")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "运输路线", required = false, dataType = "Map"),
    })
    @PostMapping("/deleteLine")
    @LogAround(foreignKeys = {"lineId"}, foreignKeyTypes = {"运输路线"})
    public Map<String, Object> deleteLine(@RequestBody(required = false) Map<String, Object> mapVal) {
        return rmsFeign.deleteLine(mapVal);
    }

    @ApiOperation(value = "根据id查询线路详情", notes = "")
    @ApiImplicitParam(name = "rmsLineStep", value = "rmsLineStep", required = true, dataType = "rmsLineStep")
    @PostMapping(value = "/getRmsLineStep/{id}")
    public Map<String, Object> getRmsLineStep(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getRmsLineStep(id);
    }


    //================物资类型
    @PostMapping("/getMaterialTypeList")
    @ApiOperation(value = "查询物资种类列表")
    public Map<String, Object> getMaterialTypeList(@RequestBody(required = false) Map<String, Object> mapValue,
                                                   Integer pageNum,
                                                   Integer pageSize,
                                                   Integer apiId,
                                                   String con) {

        return rmsFeign.getMaterialTypeList(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId, con);
    }

    @ApiOperation("新增物资类型")
    @PostMapping("/insertMaterialType")
    @LogAround(foreignKeys = {"materialTypeId"}, foreignKeyTypes = "物资类型", description = "新增物资类型")
    public RESTfulResult insertMaterialType(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertMaterialType(map);
    }

    @ApiOperation("导入物资类型")
    @PostMapping("/importMaterialType")
    public RESTfulResult insertMaterialTypeExcel(@RequestBody MultipartFile file,
                                                 String remark,
                                                 String userId,
                                                 String userName) throws Exception {
        Map<String, Object> map = new HashMap<>();
        //获取Excel中包含的对象数组
        List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
        map.put("list", list);
        Set<String> set = new HashSet<>();
        for (Map<String, Object> item : list) {
            //校验行
            if(
                    item.get("名称")==null || item.get("名称").equals("")
                    || item.get("编码")==null || item.get("编码").equals("")
                    || item.get("NC主键")==null || item.get("NC主键").equals("")
            ){
                throw new Exception("单元格数据异常，请检查模板或数据是否正确!");
            }
            set.add(item.get("NC主键").toString());
            map.put(item.get("NC主键").toString(),item);
        }
        //去重
        String[] setList = set.toArray(new String[0]);
        if (setList.length != list.size()) {
            throw new Exception("NC主键不允许重复！");
        }
        map.put("setList",setList);
        map.put("userId",userId);
        map.put("userName",userName);
        map.put("remark",remark);
        return rmsFeign.importMaterialType(map);
    }

    @ApiOperation(value = "删除物资类型")
    @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
    @PostMapping(value = "/deleteMaterialType")
    @LogAround(foreignKeys = {"materialTypeId"}, foreignKeyTypes = "物资类型", description = "删除物资类型")
    public RESTfulResult deleteMaterialType(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteMaterialType(map);
    }

    @ApiOperation(value = "同步物资类型")
    @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
    @PostMapping(value = "/syncMaterialType")
    @LogAround(foreignKeys = {"materialTypeId"}, foreignKeyTypes = "物资类型", description = "修改物资类型")
    public Map<String, Object> syncMaterialType(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.syncMaterialType(map);
    }

    @ApiOperation(value = "更新物资类型")
    @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
    @PostMapping(value = "/updateMaterialType")
    @LogAround(foreignKeys = {"materialTypeId"}, foreignKeyTypes = "物资类型", description = "修改物资类型")
    public Map<String, Object> updateMaterialType(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.updateMaterialType(map);
    }

    @ApiOperation(value = "根据id查询物资类型信息", notes = "")
    @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
    @PostMapping(value = "/getMaterialTypeById/{id}")
    public Map<String, Object> getMaterialTypeById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getMaterialTypeById(id);
    }

    @ApiOperation(value = "物资树形结构", notes = "")
    @ApiImplicitParam(name = "rmsMaterialType", value = "rmsMaterialType", required = true, dataType = "rmsMaterialType")
    @PostMapping(value = "/getMaterialTree")
    public Map<String, Object> getMaterialTree(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.getMaterialTree(map);
    }


    //====================物资
    @ApiOperation(value = "获取物资列表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
    })
    @PostMapping("/getMaterialList")
    public Map<String, Object> getMaterialList(@RequestBody(required = false) Map<String, Object> mapValue,
                                               Integer apiId,
                                               Integer pageNum,
                                               Integer pageSize
    ) {
        return rmsFeign.getMaterialList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize);
    }

    @ApiOperation(value = "新增物资", notes = "根据rmsMaterial对象创建")
    @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
    @PostMapping(value = "/insertMaterial")
    @LogAround(foreignKeys = {"materialId"}, foreignKeyTypes = {"物资"}, description = "新增物资")
    public Map<String, Object> insertMaterial(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertMaterial(map);
    }

    @ApiOperation(value = "删除", notes = "根据rmsCarrier对象创建")
    @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
    @PostMapping(value = "/deleteMaterial")
    @LogAround(foreignKeys = {"materialId"}, foreignKeyTypes = {"物资"}, description = "删除物资")
    public Map<String, Object> deleteMaterial(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteMaterial(map);
    }

    @ApiOperation(value = "更新物资", notes = "根据rmsMaterial对象创建")
    @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
    @PostMapping(value = "/updateMaterial")
    @LogAround(foreignKeys = {"materialId"}, foreignKeyTypes = {"物资"}, description = "修改物资")
    public Map<String, Object> updateMaterial(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.updateMaterial(map);
    }

    @ApiOperation(value = "根据id查询原料信息", notes = "根据rmsCarrier对象创建")
    @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
    @PostMapping(value = "/getMaterialById/{id}")
    public Map<String, Object> getMaterialById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getMaterialById(id);
    }

    @ApiOperation(value = "同步物资", notes = "根据rmsMaterial对象创建")
    @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsMaterial", required = true, dataType = "rmsMaterial")
    @PostMapping(value = "/syncMaterial")
    @LogAround(foreignKeys = {"materialId"}, foreignKeyTypes = {"物资"}, description = "同步物资")
    public Map<String, Object> syncMaterial(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.syncMaterial(map);
    }

    @ApiOperation("导入物资")
    @PostMapping("/importMaterial")
    public RESTfulResult importMaterial(@RequestBody MultipartFile file,
                                                 String remark,
                                                 String userId,
                                                 String userName) throws Exception {
        Map<String, Object> map = new HashMap<>();
        //获取Excel中包含的对象数组
        List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
        map.put("list", list);
        Set<String> set = new HashSet<>();
        for (Map<String, Object> item : list) {
            //校验行
            if(
                    item.get("名称")==null || item.get("名称").equals("")
                            || item.get("编码")==null || item.get("编码").equals("")
                            || item.get("类型")==null || item.get("类型").equals("")
                            || item.get("NC主键")==null || item.get("NC主键").equals("")
            ){
                throw new Exception("单元格数据异常，请检查模板或数据是否正确!");
            }
            set.add(item.get("NC主键").toString());
            map.put(item.get("NC主键").toString(),item);
        }
        //去重
        String[] setList = set.toArray(new String[0]);
        if (setList.length != list.size()) {
            throw new Exception("NC主键不允许重复！");
        }
        map.put("setList",setList);
        map.put("userId",userId);
        map.put("userName",userName);
        return rmsFeign.importMaterial(map);
    }

    //====================作业点
    @ApiOperation(value = "获取作业点列表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
    })
    @PostMapping("/getOperationPointList")
    public Map<String, Object> getOperationPointList(@RequestBody(required = false) Map<String, Object> mapValue,
                                                     Integer apiId,
                                                     Integer pageNum,
                                                     Integer pageSize
    ) {
        return rmsFeign.getOperationPointList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize);
    }

    @ApiOperation(value = "新增作业点", notes = "根据rmsOperationPoint对象创建")
    @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
    @PostMapping(value = "/insertOperationPoint")
    @LogAround(foreignKeys = {"operationPointId"}, foreignKeyTypes = {"作业点"}, description = "新增作业点")
    public Map<String, Object> insertOperationPoint(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertOperationPoint(map);
    }

    @ApiOperation(value = "删除", notes = "根据rmsCarrier对象创建")
    @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
    @PostMapping(value = "/deleteOperationPoint")
    @LogAround(foreignKeys = {"operationPointId"}, foreignKeyTypes = {"作业点"}, description = "删除作业点")
    public Map<String, Object> deleteOperationPoint(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteOperationPoint(map);
    }

    @ApiOperation(value = "更新作业点", notes = "根据rmsOperationPoint对象创建")
    @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
    @PostMapping(value = "/updateOperationPoint")
    @LogAround(foreignKeys = {"operationPointId"}, foreignKeyTypes = {"作业点"}, description = "修改作业点")
    public Map<String, Object> updateOperationPoint(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.updateOperationPoint(map);
    }

    @ApiOperation("导入作业点")
    @PostMapping("/importOperationPoint")
    public RESTfulResult importOperationPoint(@RequestBody MultipartFile file,
                                         String userId,
                                         String userName) throws Exception {
        Map<String, Object> map = new HashMap<>();
        //获取Excel中包含的对象数组
        List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
        map.put("list", list);
        Set<String> set = new HashSet<>();
        for (Map<String, Object> item : list) {
            //校验行
            if(
                    item.get("名称")==null || item.get("名称").equals("")
                            || item.get("编码")==null || item.get("编码").equals("")
                            || item.get("类型")==null || item.get("类型").equals("")
                            || item.get("NC主键")==null || item.get("NC主键").equals("")
                            || item.get("所属单位")==null || item.get("所属单位").equals("")
            ){
                throw new Exception("单元格数据异常，请检查模板或数据是否正确!");
            }
            //隔开用于查询是否数据库存在
            set.add(item.get("NC主键").toString());
            //key-value结构方便数据库去重后获取值
            map.put(item.get("NC主键").toString(),item);
        }
        //去重
        String[] setList = set.toArray(new String[0]);
        if (setList.length != list.size()) {
            throw new Exception("NC主键不允许重复！");
        }
        map.put("setList",setList);
        map.put("userId",userId);
        map.put("userName",userName);
        return rmsFeign.importOperationPoint(map);
    }

    @ApiOperation(value = "根据id查询原料信息", notes = "根据rmsCarrier对象创建")
    @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
    @PostMapping(value = "/getOperationPointById/{id}")
    public Map<String, Object> getOperationPointById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getOperationPointById(id);
    }
    @ApiOperation(value = "更新作业点同步作业点", notes = "根据rmsOperationPoint对象创建")
    @ApiImplicitParam(name = "rmsOperationPoint", value = "详细实体rmsOperationPoint", required = true, dataType = "rmsOperationPoint")
    @PostMapping(value = "/syncOperationPoint")
    @LogAround(foreignKeys = {"operationPointId"}, foreignKeyTypes = {"作业点"}, description = "同步作业点")
    public Map<String, Object> syncOperationPoint(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.syncOperationPoint(map);
    }

    //============人员信息
    @ApiOperation(value = "获取人员信息列表")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
    })

    @PostMapping("/getPersonnelList")
    public Map<String, Object> getPersonnelList(@RequestBody(required = false) Map<String, Object> mapVal,
                                                Integer apiId,
                                                Integer pageNum,
                                                Integer pageSize,
                                                String con
    ) {
        return rmsFeign.getPersonnelList(mapVal == null ? new HashMap<>() : mapVal, apiId, pageNum, pageSize, con);
    }

    @ApiOperation(value = "新增人员信息", notes = "根据rmsMaterial对象创建")
    @ApiImplicitParam(name = "rmsPersonnel", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
    @PostMapping(value = "/insertPersonnel")
    @LogAround(foreignKeys = {"personnelId"}, foreignKeyTypes = {"人员"})
    public Map<String, Object> insertPersonnel(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertPersonnel(map);
    }

    @ApiOperation(value = "删除", notes = "根据rmsPersonnel对象创建")
    @ApiImplicitParam(name = "rmsMaterial", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
    @PostMapping(value = "/deletePersonnel")
    @LogAround(foreignKeys = {"personnelId"}, foreignKeyTypes = {"人员"})
    public Map<String, Object> deletePersonnel(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deletePersonnel(map);
    }

    @ApiOperation(value = "更新人员信息", notes = "根据rmsMaterial对象创建")
    @ApiImplicitParam(name = "rmsPersonnel", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
    @PostMapping(value = "/updatePersonnel")
    @LogAround(foreignKeys = {"personnelId"}, foreignKeyTypes = {"人员"})
    public Map<String, Object> updatePersonnel(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.updatePersonnel(map);
    }

    @ApiOperation(value = "根据id更新详细人员信息", notes = "根据rmsPersonnel对象创建")
    @ApiImplicitParam(name = "rmsPersonnel", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
    @PostMapping(value = "/getPersonnelById")
    public Map<String, Object> getPersonnelById(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.getPersonnelById(map);
    }

    @ApiOperation(value = "根据id更新详细人员信息", notes = "根据rmsPersonnel对象创建")
    @ApiImplicitParam(name = "rmsPersonnel", value = "详细实体rmsPersonnel", required = true, dataType = "rmsPersonnel")
    @PostMapping(value = "/syncPersonnel")
    @LogAround(foreignKeys = {"personnelId"}, foreignKeyTypes = {"人员"})
    public Map<String, Object> syncPersonnel(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.syncPersonnel(map);
    }

    @ApiOperation("导入人员信息")
    @PostMapping("/importPersonnel")
    public RESTfulResult importPersonnel(@RequestBody MultipartFile file,
                                          String userId,
                                          String userName) throws Exception {
        Map<String, Object> map = new HashMap<>();
        //获取Excel中包含的对象数组
        List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
        Set<String> set = new HashSet<>();
        for (Map<String, Object> item : list) {
            //校验行
            if(
                    item.get("姓名")==null || item.get("姓名").equals("")
                            || item.get("编码")==null || item.get("编码").equals("")
                            || item.get("身份证号")==null || item.get("身份证号").equals("")
                            || item.get("所属单位")==null || item.get("所属单位").equals("")
                            || item.get("NC主键")==null || item.get("NC主键").equals("")
            ){
                throw new Exception("单元格数据异常，请检查模板或数据是否正确!");
            }
            //隔开用于查询是否数据库存在
            set.add(item.get("NC主键").toString() + item.get("所属单位").toString());
            map.put(item.get("NC主键").toString() + item.get("所属单位").toString(),item);
        }
        //去重
        String[] setList = set.toArray(new String[0]);
        if (setList.length != list.size()) {
            throw new Exception("NC主键-所属单位不允许重复！");
        }
        map.put("setList", setList);
        map.put("userId",userId);
        map.put("userName",userName);
        return rmsFeign.importPersonnel(map);
    }


    //================公司
    @ApiOperation(value = "展示公司信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
    })
    @PostMapping("/getCompanyList")
    public Map<String, Object> getCompanyList(@RequestBody(required = false) Map<String, Object> mapValue,
                                              Integer apiId,
                                              Integer pageNum,
                                              Integer pageSize
    ) {
        return rmsFeign.getCompanyList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize);
    }

    @ApiOperation(value = "新增公司信息", notes = "根据rmsCompany对象创建")
    @ApiImplicitParam(name = "rmsCompany", value = "详细实体rmsCompany", required = true, dataType = "rmsCompany")
    @PostMapping(value = "/insertCompany")
    @LogAround(foreignKeys = {"companyId"}, foreignKeyTypes = "公司", description = "新增公司单位")
    public Map<String, Object> insertCompany(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertCompany(map);
    }

    @ApiOperation(value = "删除")
    @ApiImplicitParam(name = "公司id", value = "id", required = true, dataType = "int")
    @PostMapping(value = "/deleteCompany")
    @LogAround(foreignKeys = {"companyId"}, foreignKeyTypes = "公司", description = "删除公司单位")
    public Map<String, Object> deleteCompany(@RequestBody Map<String, Object> map) {
        return rmsFeign.deleteCompany(map);
    }

    @ApiOperation(value = "更新公司信息", notes = "根据rmsCompany对象创建")
    @ApiImplicitParam(name = "rmsCompany", value = "详细实体rmsCompany", required = true, dataType = "rmsCompany")
    @PostMapping(value = "/updateCompany")
    @LogAround(foreignKeys = {"companyId"}, foreignKeyTypes = "公司", description = "修改公司单位")
    public Map<String, Object> updateCompany(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.updateCompany(map);
    }

    @ApiOperation(value = "根据id查询公司信息", notes = "根据rmsCompany对象创建")
    @ApiImplicitParam(name = "公司id", value = "id", required = true, dataType = "int")
    @PostMapping(value = "/getCompanyById/{id}")
    public Map<String, Object> getCompanyById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getCompanyById(id);
    }

    @ApiOperation(value = "同步公司", notes = "根据rmsCompany对象创建")
    @ApiImplicitParam(name = "rmsCompany", value = "详细实体rmsCompany", required = true, dataType = "rmsCompany")
    @PostMapping(value = "/syncCompany")
    @LogAround(foreignKeys = {"companyId"}, foreignKeyTypes = {"公司"}, description = "同步公司")
    public Map<String, Object> syncCompany(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.syncCompany(map);
    }

    @ApiOperation("导入公司")
    @PostMapping("/importCompany")
    public RESTfulResult importCompany(@RequestBody MultipartFile file,
                                                 String remark,
                                                 String userId,
                                                 String userName) throws Exception {
        Map<String, Object> map = new HashMap<>();
        //获取Excel中包含的对象数组
        List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
        map.put("list", list);
        Set<String> set = new HashSet<>();
        for (Map<String, Object> item : list) {
            //校验行
            if(
                    item.get("名称")==null || item.get("名称").equals("")
                    || item.get("编码")==null || item.get("编码").equals("")
                    || item.get("类型")==null || item.get("类型").equals("")
                    || item.get("NC主键")==null || item.get("NC主键").equals("")
            ){
                throw new Exception("单元格数据异常，请检查模板或数据是否正确!");
            }
            set.add(item.get("NC主键").toString()+item.get("类型").toString());
            map.put(item.get("NC主键").toString()+item.get("类型").toString(),item);
        }
        //去重
        String[] setList = set.toArray(new String[0]);
        if (setList.length != list.size()) {
            throw new Exception("NC主键-类型不允许重复！");
        }
        map.put("setList",setList);
        map.put("userId",userId);
        map.put("userName",userName);
        map.put("remark",remark);
        return rmsFeign.importCompany(map);
    }

    //运力
    @ApiOperation(value = "新增运力信息", notes = "根据rmsCapacity对象创建")
    @ApiImplicitParam(name = "rmsCapacity", value = "详细实体rmsCapacity", required = true, dataType = "rmsCapacity")
    @PostMapping(value = "/insertCapacity")
    @LogAround(foreignKeys = {"capacityId"}, foreignKeyTypes = {"运力"})
    public Map<String, Object> insertCapacity(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertCapacity(map);
    }

    @ApiOperation(value = "删除", notes = "根据rmsCarrier对象创建")
    @ApiImplicitParam(name = "运力id", value = "id", required = true, dataType = "int")
    @PostMapping(value = "/deleteCapacity")
    @LogAround(foreignKeys = {"capacityId"}, foreignKeyTypes = {"运力"})
    public Map<String, Object> deleteCapacity(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteCapacity(map);
    }

    @ApiOperation(value = "获取运力详细信息", notes = "根据url的id来获取详细信息")
    @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal")
    @PostMapping(value = "/getCapacityById")
    public Map<String, Object> getCapacityById(@RequestBody Map<String, Object> map) {
        return rmsFeign.getCapacityById(map);
    }

    @ApiOperation(value = "更新详细信息", notes = "根据url的id来指定更新对象，并根据传过来的rmsCapacity信息来更新详细信息")
    @ApiImplicitParams({
            @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "Short"),
            @ApiImplicitParam(name = "rmsCapacity", value = "详细实体rmsCapacity", required = true, dataType = "RmsCapacity")
    })
    @PostMapping(value = "/updateCapacity", produces = "application/json;charset=UTF-8")
    @LogAround(foreignKeys = {"capacityId"}, foreignKeyTypes = {"运力"})
    public Map<String, Object> updateCapacity(@RequestBody Map<String, Object> map) {
        return rmsFeign.updateCapacity(map);
    }

    @PostMapping("/getCapacityList")
    @ApiOperation(value = "模糊查询运力")
    public Map<String, Object> getCapacityList(@RequestBody(required = false) Map<String, Object> mapValue,
                                               Integer pageNum,
                                               Integer pageSize,
                                               Integer apiId,
                                               String con,
                                               String carrierSSOId) {

        return rmsFeign.getCapacityList(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId, con, carrierSSOId);
    }


    @ApiOperation(value = "删除", notes = "根据rmsCarrier对象创建")
    @ApiImplicitParam(name = "仓库id", value = "id", required = true, dataType = "int")
    @PostMapping(value = "/deleteWarehouse/{id}")
    public Map<String, Object> deleteWarehouse(@PathVariable("id") BigDecimal id) {
        return rmsFeign.deleteWarehouse(id);
    }

    @ApiOperation(value = "更新详细信息", notes = "根据url的id来指定更新对象，并根据传过来的rmsCarDriver信息来更新详细信息")
    @ApiImplicitParams({
            @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal"),
            @ApiImplicitParam(name = "rmsWarehouse", value = "详细实体rmsWarehouse", required = true, dataType = "RmsWarehouse")
    })
    @PostMapping(value = "/updateWarehouse", produces = "application/json;charset=UTF-8")
    public Map<String, Object> updateWarehouse(@RequestBody Map<String, Object> map) {
        return rmsFeign.updateWarehouse(map);
    }

    @ApiOperation(value = "获取详细信息", notes = "根据url的id来获取详细信息")
    @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal")
    @PostMapping(value = "/getWarehouseById/{id}")
    public Map<String, Object> getWarehouseById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getWarehouseById(id);
    }

    @PostMapping("/getWarehouseList")
    @ApiOperation(value = "模糊查询原料仓库")
    public Map<String, Object> getWarehouseList(@RequestBody(required = false) Map<String, Object> mapValue,
                                                Integer pageNum,
                                                Integer pageSize,
                                                Integer apiId,
                                                String con) {

        return rmsFeign.getWarehouseList(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId, con);
    }

    @ApiOperation(value = "展示司机排班信息", notes = "分页查询")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "pageNum", value = "查询页数", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "每页记录数", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "apiId", value = "196", required = false, dataType = "BigDecimal"),
    })
    @PostMapping(value = "/getCapacityDriverList")
    public Map<String, Object> getCapacityDriverList(@RequestBody(required = false) Map<String, Object> mapValue,
                                                     Integer pageNum,
                                                     Integer pageSize,
                                                     Integer apiId) {
        return rmsFeign.getCapacityDriverList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize);
    }

    @ApiOperation(value = "创建", notes = "根据RmsDriverCapacity对象创建")
    @ApiImplicitParam(name = "rmsCapacityDriver", value = "详细实体rmsDriverCapacity", required = true, dataType = "RmsDriverCapacity")
    @PostMapping(value = "/insertCapacityDriver")
    @LogAround(foreignKeys = {"capacityDriverId"},foreignKeyTypes = {"司机排班"})
    public Map<String, Object> insertCapacityDriver(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertCapacityDriver(map);
    }

    @ApiOperation(value = "创建", notes = "根据RmsDriverCapacity对象创建")
    @ApiImplicitParam(name = "rmsCapacityDriver", value = "详细实体rmsDriverCapacity", required = true, dataType = "RmsDriverCapacity")
    @PostMapping(value = "/deleteCapacityDriver")
    @LogAround(foreignKeys = {"capacityDriverId"},foreignKeyTypes = {"司机排班"})
    public Map<String, Object> deleteCapacityDriver(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteCapacityDriver(map);
    }


    @ApiOperation(value = "展示门岗信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
    })

    @PostMapping("/getGatepostList")
    public Map<String, Object> getGatepostList(@RequestBody(required = false) Map<String, Object> mapValue,
                                               Integer apiId,
                                               Integer pageNum,
                                               Integer pageSize,
                                               String con
    ) {
        return rmsFeign.getGatepostList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize, con);
    }

    @ApiOperation(value = "新增门岗信息", notes = "根据rmsGatepost对象创建")
    @ApiImplicitParam(name = "rmsGatepost", value = "详细实体rmsGatepost", required = true, dataType = "rmsGatepost")
    @PostMapping(value = "/insertGatepost")
    public Map<String, Object> insertGatepost(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertGatepost(map);
    }

    @ApiOperation(value = "删除", notes = "根据rmsGatepost对象创建")
    @ApiImplicitParam(name = "门岗id", value = "id", required = true, dataType = "int")
    @PostMapping(value = "/deleteGatepost/{id}")
    public Map<String, Object> deleteGatepost(@PathVariable("id") BigDecimal id) {
        return rmsFeign.deleteGatepost(id);
    }

    @ApiOperation(value = "更新门岗信息", notes = "根据rmsGatepost对象创建")
    @ApiImplicitParam(name = "rmsGatepost", value = "详细实体rmsGatepost", required = true, dataType = "rmsGatepost")
    @PostMapping(value = "/updateGatepost")
    public Map<String, Object> updateGatepost(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.updateGatepost(map);
    }

    @ApiOperation(value = "根据id查询门岗信息", notes = "根据rmsGatepost对象创建")
    @ApiImplicitParam(name = "门岗id", value = "id", required = true, dataType = "int")
    @PostMapping(value = "/getGatepostById/{id}")
    public Map<String, Object> getGatepostById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getGatepostById(id);
    }

    @ApiOperation(value = "根据id查询门岗规则信息", notes = "根据rmsGatepost对象创建")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "门岗id", value = "id", required = true, dataType = "int")
    })
    @PostMapping(value = "/getGatepostRulesById/{id}")
    public Map<String, Object> getGatepostRulesById(@PathVariable("id") BigDecimal id,
                                                    Integer apiId) {
        return rmsFeign.getGatepostRulesById(id, apiId);
    }

    @ApiOperation(value = "展示门岗规则信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
    })

    @PostMapping("/getGatepostRulesList")
    public Map<String, Object> getGatepostRulesList(@RequestBody(required = false) Map<String, Object> mapValue,
                                                    Integer apiId,
                                                    Integer pageNum,
                                                    Integer pageSize,
                                                    String con
    ) {
        return rmsFeign.getGatepostRulesList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize, con);
    }

    @ApiOperation(value = "删除", notes = "根据rulesId删除")
    @ApiImplicitParam(name = "门岗规则id", value = "rulesId", required = true, dataType = "int")
    @PostMapping(value = "/deleteGatepostRules/{rulesId}")
    public Map<String, Object> deleteGatepostRules(@PathVariable("rulesId") BigDecimal rulesId) {
        return rmsFeign.deleteGatepostRules(rulesId);
    }

    @ApiOperation(value = "新增门岗规则")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "门岗规则", required = false, dataType = "Map"),
    })
    @PostMapping("/insertGatepostRule")
    public Map<String, Object> insertGatepostRule(@RequestBody(required = false) Map<String, Object> mapValue) {
        return rmsFeign.insertGatepostRule(mapValue);
    }

    @ApiOperation(value = "获取门岗名")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "门岗id", value = "gatepostId", required = true, dataType = "int")
    })
    @PostMapping("/getGatepostName/{gatepostId}")
    public Map<String, Object> getGatepostName(@PathVariable("gatepostId") BigDecimal gatepostId) {
        return rmsFeign.getGatepostName(gatepostId);
    }


    //*******************************下拉框************************
    @GetMapping("getCapacityTypeId")
    @ApiOperation(value = "得到下拉运力id")
    public Map<String, Object> getCapacityTypeId() {
        return rmsFeign.getCapacityTypeId();
    }


    @GetMapping("getMaterialTypeId")
    @ApiOperation(value = "得到下拉物资类型id")
    public Map<String, Object> getMaterialTypeId() {
        return rmsFeign.getMaterialTypeId();
    }


    @GetMapping("getTransportTypeId")
    @ApiOperation(value = "运输类型下拉")
    public Map<String, Object> getTransportTypeId() {
        return rmsFeign.getTransportTypeId();
    }


    @PostMapping(value = "/getNoticeList")
    public Map<String, Object> getNoticeList(@RequestBody(required = false) Map<String, Object> mapValue,
                                             Integer apiId,
                                             Integer pageNum,
                                             Integer pageSize,
                                             String con
    ) {
        if (mapValue == null) {
            mapValue = new HashMap<>();
        }
        return rmsFeign.getNoticeList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize, con);
    }

    @ApiOperation(value = "新增公告信息", notes = "根据DilNotice对象创建")
    @ApiImplicitParam(name = "dilNotice", value = "详细实体dilNotice", required = true, dataType = "DilNotice")
    @PostMapping(value = "/insertNotice")
    public Map<String, Object> insertNotice(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertNotice(map);
    }

    @ApiOperation(value = "更新公告信息", notes = "根据dilNotice对象创建")
    @ApiImplicitParam(name = "dilNotice", value = "详细实体dilNotice", required = true, dataType = "dilNotice")
    @PostMapping(value = "/updateNotice", produces = "application/json;charset=UTF-8")
    public Map<String, Object> updateNotice(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.updateNotice(map);
    }

    @ApiOperation(value = "删除", notes = "根据url的id来指定删除对象")
    @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal")
    @PostMapping(value = "/deleteNotice/{id}")//BigDecimal
    public Map<String, Object> deleteNotice(@PathVariable("id") BigDecimal id) {
        return rmsFeign.deleteNotice(id);
    }


    @ApiOperation(value = "获取详细信息", notes = "根据url的id来获取详细信息")
    @ApiImplicitParam(paramType = "path", name = "公告id", value = "ID", required = true, dataType = "BigDecimal")
    @PostMapping(value = "/getNoticeById/{id}")
    public Map<String, Object> getNoticeById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getNoticeById(id);
    }

    //油价
    @ApiOperation(value = "获取油价信息", notes = "分页查询")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "mapValue", value = "表头和参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "status", value = "状态码", required = false, dataType = "Integer"),
    })


    @PostMapping(value = "/getOilPriceResultList")
    public Map<String, Object> getOilPriceResultList(@RequestBody(required = false) Map<String, Object> mapValue,
                                                     Integer apiId,
                                                     Integer pageNum,
                                                     Integer pageSize,
                                                     String con
    ) {
        if (mapValue == null) {
            mapValue = new HashMap<>();
        }
        return rmsFeign.getOilPriceResultList(mapValue == null ? new HashMap<>() : mapValue, apiId, pageNum, pageSize, con);
    }

    @ApiOperation(value = "新增油价信息", notes = "根据DilNotice对象创建")
    @ApiImplicitParam(name = "addOilPrice", value = "详细实体dilNotice", required = true, dataType = "DilNotice")
    @PostMapping(value = "/insertOilPrice")
    public Map<String, Object> insertOilPrice(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertOilPrice(map);
    }

    @ApiOperation(value = "更新油价信息", notes = "根据油价ID来更新油价")
    @PostMapping(value = "/updateOilPrice")
    public Map<String, Object> updateOilPrice(@RequestBody(required = false) Map<String, Object> mapValue) {
        return rmsFeign.updateOilPrice(mapValue);
    }

    @ApiOperation(value = "删除", notes = "根据url的id来指定删除对象")
    @ApiImplicitParam(paramType = "path", name = "id", value = "ID", required = true, dataType = "BigDecimal")
    @PostMapping(value = "/deleteOilPrice/{id}")//BigDecimal
    public Map<String, Object> deleteOilPrice(@PathVariable("id") BigDecimal id) {
        return rmsFeign.deleteOilPrice(id);
    }

    @ApiOperation(value = "获取详细信息", notes = "根据url的id来获取详细信息")
    @ApiImplicitParam(paramType = "path", name = "公告id", value = "ID", required = true, dataType = "BigDecimal")
    @PostMapping(value = "/getOilPriceById/{id}")
    public Map<String, Object> getOilPriceById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getOilPriceById(id);
    }

    //根据运力id查询公司
    @PostMapping(value = "getCarrierNameById/{id}")
    public Map<String, Object> getCarrierNameById(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getCarrierNameById(id);
    }

    //根据司机id查询公司
    @PostMapping(value = "getCarrierNameByDriverId/{id}")
    public Map<String, Object> getCarrierNameByDriverId(@PathVariable("id") BigDecimal id) {
        return rmsFeign.getCarrierNameByDriverId(id);
    }


    @ApiOperation(value = "创建", notes = "添加油品名称")
    @ApiImplicitParam(name = "oilTypeName", value = "油品名称", required = true, dataType = "String")
    @PostMapping(value = "/addOilType")
    public Map<String, Object> addOilType(String oilTypeName) {
        return rmsFeign.addOilType(oilTypeName);
    }

    @ApiOperation(value = "创建", notes = "查询油品名称")
    @PostMapping(value = "/oilNameSelect")
    public Map<String, Object> oilNameSelect() {
        return rmsFeign.oilNameSelect();
    }

    @ApiOperation("解除公司和车辆的绑定关系")
    @PostMapping("/deleteCapacityCarrier")
    public RESTfulResult deleteCapacityCarrier(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteCapacityCarrier(map != null ? map : new HashMap<>());
    }


    @ApiOperation("渲染运力修改数据")
    @PostMapping("/getCapacityInfoById/{id}")
    public Map<String, Object> getCapacityInfoById(@PathVariable("id") Integer id) {
        return rmsFeign.getCapacityInfoById(id);
    }

    @ApiOperation(value = "查询运力类型")
    @PostMapping("/getCapacityType")
    public Map<String, Object> getCapacityType(@RequestBody(required = false) Map<String, Object> map,
                                               Integer apiId,
                                               Integer pageNum,
                                               Integer pageSize) {
        if (map == null) {
            map = new HashMap<>();
        }
        return rmsFeign.getCapacityType(map, apiId, pageNum, pageSize);
    }

    @ApiOperation(value = "新增运力类型")
    @PostMapping(value = "/insertCapacityType")
    @LogAround(foreignKeys = {"capacityTypeId"}, foreignKeyTypes = {"运力类型"})
    public Map<String, Object> insertCapacityType(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertCapacityType(map);
    }

    @ApiOperation(value = "删除运力类型")
    @PostMapping(value = "/deleteCapacityType")
    @LogAround(foreignKeys = {"capacityTypeId"}, foreignKeyTypes = {"运力类型"})
    public Map<String, Object> deleteCapacityType(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteCapacityType(map);
    }

    @ApiOperation(value = "查询运输范围")
    @PostMapping("/getTransRangeList")
    public Map<String, Object> getTransRangeList(@RequestBody(required = false) Map<String, Object> map,
                                                 Integer apiId,
                                                 Integer pageNum,
                                                 Integer pageSize) {
        if (map == null) {
            map = new HashMap<>();
        }
        return rmsFeign.getTransRangeList(map, apiId, pageNum, pageSize);
    }

    @ApiOperation(value = "新增运输范围")
    @PostMapping(value = "/insertTransRange")
    @LogAround(foreignKeys = {"transRangeId"}, foreignKeyTypes = "运输范围")
    public Map<String, Object> insertTransRange(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.insertTransRange(map);
    }

    @ApiOperation(value = "删除运输范围")
    @PostMapping(value = "/deleteTransRange")
    @LogAround(foreignKeys = {"transRangeId"}, foreignKeyTypes = "运输范围")
    public Map<String, Object> deleteTransRange(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteTransRange(map);
    }

    @ApiOperation("导入运输范围")
    @PostMapping("/importTransRange")
    public RESTfulResult importTransRange(@RequestBody MultipartFile file,
                                                 String userId,
                                                 String userName) throws Exception {
        Map<String, Object> map = new HashMap<>();
        //获取Excel中包含的对象数组
        List<Map<String, Object>> list = ExcelToolUtils.getExcelList(file, 0);
        map.put("list", list);
        Set<String> set = new HashSet<>();
        for (Map<String, Object> item : list) {
            //校验行
            if(
                    item.get("起点")==null || item.get("起点").equals("")
                    || item.get("终点")==null || item.get("终点").equals("")
            ){
                throw new Exception("单元格数据异常（起点/终点），请检查模板或数据是否正确!");
            }
            //隔开用于查询是否数据库存在
            set.add(item.get("起点").toString() + "," + item.get("终点").toString());
        }
        //去重
        String[] transRanges = set.toArray(new String[0]);
        if (transRanges.length != list.size()) {
            throw new Exception("不允许重复！");
        }
        map.put("list",transRanges);
        map.put("userId",userId);
        map.put("userName",userName);
        return rmsFeign.importTransRange(map);
    }



    @ApiOperation(value = "新增集装箱数据")
    @PostMapping("insetShipContainer")
    public Map<String, Object> insetShipContainer(@RequestBody(required = false) Map<String, Object> map) {

        return rmsFeign.insetShipContainer(map);
    }

    @ApiOperation(value = "修改集装箱数据")
    @PostMapping("updateShipContainer")
    public Map<String, Object> updateShipContainer(@RequestBody List<Map<String, Object>> mapList) {
        return rmsFeign.updateShipContainer(mapList);
    }

    @ApiOperation("查询集装箱数据")
    @PostMapping("getShippingContainer")
    public Map<String, Object> getShippingContainer(@RequestBody(required = false) Map<String, Object> map,
                                                    @RequestParam(required = false) Integer apiId,
                                                    @RequestParam(required = false) Integer pageNum,
                                                    @RequestParam(required = false) Integer pageSize) {
        if (map == null) {
            map = new HashMap<>();
        }
        return rmsFeign.getShippingContainer(map, apiId, pageNum, pageSize);
    }

    //   ========================= 岗位信息维护
    @ApiOperation(value = "岗位信息")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
    })
    @PostMapping(value = "/getrmsrmsjobinfos")
    public Map<String, Object> getAmsTransPriceList(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
                                                    Integer pageNum,
                                                    Integer pageSize) {
        return rmsFeign.list(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
    }
    @ApiOperation(value="新增岗位信息")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"jobId"},foreignKeyTypes = {"岗位信息"})
    @PostMapping("/add")
    public  Map<String, Object>  insertTransPrice(@RequestBody(required = false) Map<String, Object> map) {
        map.put("insertUsername",  map.get("userName").toString());
        return  rmsFeign.add(map);
    }

    @ApiOperation(value="修改岗位信息")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/{id}")
    @LogAround(foreignKeys = {"jobId"},foreignKeyTypes = {"岗位信息"})
    public Map<String, Object> purchaseOrderUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
        map.put("updateUsername", map.get("userName").toString());
        return rmsFeign.update(id,map);
    }

    @ApiOperation(value="岗位信息逻辑删除")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/logicdelete")
    @LogAround(foreignKeys = {"jobId"},foreignKeyTypes = {"岗位信息"})
    public Map<String, Object> purchaseOrderLogicDelete(@RequestBody(required = false) Map<String, Object> map){
        return rmsFeign.logicdelete(map);
    }
    @PostMapping(value = "/readExcel")
    public RESTfulResult readExcel(MultipartFile file){
        return rmsFeign.readExcel(file);
    }
    //   ========================= 提取比例维护
    @ApiOperation(value = "提取比例")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
    })
    @PostMapping(value = "/getrmsextractscales")
    public Map<String, Object> getextractscalelist(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
                                                    Integer pageNum,
                                                    Integer pageSize) {
        return rmsFeign.extractscalelist(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
    }
    @ApiOperation(value="新增提取比例")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"scaleId"},foreignKeyTypes = {"提取比例"})
    @PostMapping("/addextractscale")
    public  Map<String, Object> insertExtractscale(@RequestBody(required = false) Map<String, Object> map) {
        map.put("insertUsername",  map.get("userName").toString());
        return  rmsFeign.addExtractscale(map);
    }

    @ApiOperation(value="提取比例逻辑删除")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/extractscalelogicdelete")
    @LogAround(foreignKeys = {"scaleId"},foreignKeyTypes = {"提取比例"})
    public Map<String, Object> ExtractscaleLogicDelete(@RequestBody(required = false) Map<String, Object> map){
        return rmsFeign.Extractscalelogicdelete(map);
    }

    @ApiOperation(value="修改提取比例")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/extractscale/{id}")
    @LogAround(foreignKeys = {"scaleId"},foreignKeyTypes = {"提取比例"})
    public Map<String, Object> ExtractscaleUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
        map.put("updateUsername", map.get("userName").toString());
        return rmsFeign.Extractscaleupdate(id,map);
    }

    //   ========================= 计算公式

    @ApiOperation(value = "计算公式")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
    })
    @PostMapping(value = "/getformula")
    public Map<String, Object> geteformulalist(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
                                                   Integer pageNum,
                                                   Integer pageSize) {
        return rmsFeign.FormulaList(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
    }
    @ApiOperation(value="新增计算公式")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"formulaId"},foreignKeyTypes = {"计算公式"})
    @PostMapping("/addformula")
    public  Map<String, Object> insertformula(@RequestBody(required = false) Map<String, Object> map) {
        map.put("insertUsername",  map.get("userName").toString());
        return  rmsFeign.addFormula(map);
    }

    @ApiOperation(value="计算公式逻辑删除")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/formulalogicdelete")
    @LogAround(foreignKeys = {"formulaId"},foreignKeyTypes = {"计算公式"})
    public Map<String, Object> formulaLogicDelete(@RequestBody(required = false) Map<String, Object> map){
        return rmsFeign.Formulalogicdelete(map);
    }

    @ApiOperation(value="修改计算公式")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/formulaupadete/{id}")
    @LogAround(foreignKeys = {"formulaId"},foreignKeyTypes = {"计算公式"})
    public Map<String, Object> formulaUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
        map.put("updateUsername", map.get("userName").toString());
        return rmsFeign.Formulaupdate(id,map);
    }

    //   ========================= 需求快捷匹配

    @ApiOperation(value = "需求快捷匹配")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
    })
    @PostMapping(value = "/getrmsdemandruless")
    public Map<String, Object> getrmsdemandrulesslist(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
                                               Integer pageNum,
                                               Integer pageSize) {
        return rmsFeign.rmsdemandrulesslist(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
    }
    @ApiOperation(value="新增需求快捷匹配")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"rulesId"},foreignKeyTypes = {"计算公式"})
    @PostMapping("/addrmsdemandruless")
    public  Map<String, Object> insertrmsdemandruless(@RequestBody(required = false) Map<String, Object> map) {
        map.put("insertUsername",  map.get("userName").toString());
        return  rmsFeign.addrmsdemandruless(map);
    }


    @ApiOperation(value="修改需求快捷匹配")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/rmsdemandrulessUpdate/{id}")
    @LogAround(foreignKeys = {"rulesId"},foreignKeyTypes = {"需求快捷匹配"})
    public Map<String, Object> rmsdemandrulessUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
        map.put("updateUsername", map.get("userName").toString());
        return rmsFeign.rmsdemandrulessupdate(id,map);
    }

    //   ========================= 费用类别

    @ApiOperation(value = "费用类别")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
    })
    @PostMapping(value = "/rmsexpansecategorysList")
    public Map<String, Object> getrmsexpansecategorys(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
                                               Integer pageNum,
                                               Integer pageSize) {
        return rmsFeign.rmsexpansecategorysList(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
    }
    @ApiOperation(value="新增费用类别")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"费用类别"})
    @PostMapping("/rmsexpansecategorysInsert")
    public  Map<String, Object> insertrmsexpansecategorys(@RequestBody(required = false) Map<String, Object> map) {
        map.put("insertUsername", map.get("userName").toString());
        return  rmsFeign.addrmsexpansecategorys(map);
    }

    @ApiOperation(value="费用类别删除")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/rmsexpansecategorysDelete")
    @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"费用类别"})
    public Map<String, Object> rmsexpansecategorysDelete(@RequestBody(required = false) Map<String, Object> map){
        return rmsFeign.rmsexpansecategorysdelete(map);
    }

    @ApiOperation(value="修改费用类别")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PutMapping(value = "/rmsexpansecategorysUpdate/{id}")
    @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"费用类别"})
    public Map<String, Object> rmsexpansecategorysUpdate(@PathVariable BigDecimal id,@RequestBody(required = false) Map<String, Object> map){
        map.put("updateUsername", map.get("userName").toString());
        return rmsFeign.rmsexpansecategorysupdate(id,map);
    }

    @ApiOperation(value = "业务类型")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
    })
    @PostMapping(value = "/getBusinessType")
    public Map<String, Object> getBusinessType(@RequestBody(required = false) Map<String, Object> map, Integer apiId,
                                                      Integer pageNum,
                                                      Integer pageSize) {
        return rmsFeign.getBusinessType(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
    }


    @ApiOperation(value="新增业务类型")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"业务类型"})
    @PostMapping("/insertBusinessType")
    public  Map<String, Object> insertBusinessType(@RequestBody(required = false) Map<String, Object> map) {
        map.put("insertUsername", map.get("userName").toString());
        return  rmsFeign.insertBusinessType(map);
    }
   @ApiOperation(value = "审批流程")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
    })
    @PostMapping(value = "/getapprovelines")
    public Map<String, Object> getrmsapprovelines(@RequestBody(required = false) Map<String, Object> mapValue,
                                           Integer pageNum,
                                           Integer pageSize,
                                           Integer apiId) {
        return rmsFeign.getrmsapprovelines(mapValue == null ? new HashMap<>() : mapValue, pageNum, pageSize, apiId);
    }

    @ApiOperation(value="新增审批流程")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"业务类型"})
    @PostMapping("/addapprovelines")
    public  Map<String, Object> addapprovelines(@RequestBody(required = false) Map<String, Object> map) {
        return  rmsFeign.addapprovelines(map);
    }
    @ApiOperation(value="更新审批流程")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"业务类型"})
    @PostMapping("/updateapprovelines")
    public  Map<String, Object> updateapprovelines(@RequestBody(required = false) Map<String, Object> map) {
        return  rmsFeign.updateapprovelines(map);
    }
    @ApiOperation(value="删除审批流程")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"categoryId"},foreignKeyTypes = {"业务类型"})
    @PostMapping("/approvelinesdelete")
    public  Map<String, Object> approvelinesdelete(@RequestBody(required = false) Map<String, Object> map) {
        return  rmsFeign.approvelinesdelete(map);
    }
 @ApiOperation(value = "燃料类型")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "map", value = "参数", required = false, dataType = "map"),
            @ApiImplicitParam(name = "apiId()", value = "动态表头", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageNum", value = "页码", required = false, dataType = "Integer"),
            @ApiImplicitParam(name = "pageSize", value = "页", required = false, dataType = "Integer"),
    })
    @PostMapping("/getFuelTypeList")
    public Map<String, Object> getFuelTypeList(@RequestBody(required = false) Map<String,Object> map,
                                        @RequestParam("apiId") Integer apiId,
                                        @RequestParam("pageNum") Integer pageNum,
                                        @RequestParam("pageSize") Integer pageSize) {
        return rmsFeign.getFuelTypeList(map == null ? new HashMap<>() : map, apiId, pageNum, pageSize);
    }

    @ApiOperation(value="新增燃料类型")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"fuelTypeId"},foreignKeyTypes = {"燃料类型"})
    @PostMapping("/insertFuelType")
    public Map<String, Object> insertFuelType(@RequestBody(required = false)Map<String, Object> map){
        return rmsFeign.insertFuelType(map);
    }

    @ApiOperation(value="删除燃料类型")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"fuelTypeId"},foreignKeyTypes = {"燃料类型"})
    @PostMapping("/deleteFuelType")
    public Map<String, Object> deleteFuelType(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteFuelType(map);
    }

    @ApiOperation(value="新增地图顶点")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {"vertexId"},foreignKeyTypes = {"地图顶点"})
    @PostMapping("/addVertex")
    public Map<String, Object> addVertex(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.addVertex(map);
    }

    @ApiOperation(value="查询地图顶点")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PostMapping("/getVertex")
    public Map<String, Object> getVertex() {
        return rmsFeign.getVertex();
    }

    @ApiOperation(value="新增地图边线")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {},foreignKeyTypes = {"地图边线"})
    @PostMapping("/addEdge")
    public Map<String, Object> addEdge(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.addEdge(map);
    }

    @ApiOperation(value="删除地图边线")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @LogAround(foreignKeys = {},foreignKeyTypes = {"地图边线"})
    @PostMapping("/deleteEdge")
    public Map<String, Object> deleteVertex(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.deleteEdge(map);
    }

    @ApiOperation(value="查询地图边线")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PostMapping("/getEdge")
    public Map<String, Object> getEdge() {
        return rmsFeign.getEdge();
    }

    @ApiOperation(value="查询导航信息")
    @ApiImplicitParam(name = "map", value = "JSON格式数据", required = true, dataType = "Map<String, Object>")
    @PostMapping("/navigation")
    public Map<String, Object> navigation(@RequestBody(required = false) Map<String, Object> map) {
        return rmsFeign.navigation(map);
    }
}