guoyujie
89 分钟以前 b0a4de74b47e2626f51eb4a844db3e62f6a4bf9d
north-glass-erp/src/main/java/com/example/erp/service/mm/FinishedGlassShelfService.java
@@ -57,9 +57,18 @@
                userName = object.get("userName").toString();
            }
            String inventoryArea = "";
            if (object.get("inventoryArea") != null) {
                inventoryArea = object.get("inventoryArea").toString();
            }
            int quantity = 0;
            if (object.get("quantity") != null) {
                quantity = Integer.valueOf(object.get("quantity").toString());
            }
            FinishedGlassShelfInformation finishedGlassShelfInformation =
                    JSONObject.parseObject(JSONObject.toJSONString(object.get("title")), FinishedGlassShelfInformation.class);
            finishedGlassShelfInformation.setMoney(finishedGlassShelfInformation.getPrice()*finishedGlassShelfInformation.getTotalQuantity());
            List<FinishedGlassShelfInformation> finishedGlassShelfInformationList=finishedGlassShelfMapper
                    .getSelectFinishedGlassShelfInformation(finishedGlassShelfInformation);
@@ -68,24 +77,16 @@
                finishedGlassShelfMapper.updateFinishedGlassShelfInformation(finishedGlassShelfInformation,finishedGlassShelfInformation.getId());
                log.setFunction("saveFinishedGlassShelf修改1");
            }else{
                if(finishedGlassShelfInformationList.size()==0){
                    finishedGlassShelfMapper.insetFinishedGlassShelfInformation(finishedGlassShelfInformation);
                    log.setFunction("saveFinishedGlassShelf新增");
                }else if(finishedGlassShelfInformationList.size()==1){
                    finishedGlassShelfMapper.updateFinishedGlassShelfInformationQuantity(finishedGlassShelfInformation.getTotalQuantity(),finishedGlassShelfInformationList.get(0).getId());
                    log.setFunction("saveFinishedGlassShelf修改2");
                }else{
                    saveState = "false";
                int index=finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationInventoryArea(inventoryArea);
                for (int i=1;i<=quantity;i++){
                    index++;
                    finishedGlassShelfMapper.insetFinishedGlassShelfInformation(finishedGlassShelfInformation,inventoryArea+index);
                }
                log.setFunction("saveFinishedGlassShelf新增");
                if(saveState.equals("true")){
                    finishedGlassShelfMapper.insetFinishedGlassShelfLog(finishedGlassShelfInformation);
                }
                finishedGlassShelfMapper.insetFinishedGlassShelfLog(finishedGlassShelfInformation,quantity);
            }
            logService.saveLog(log);
@@ -103,11 +104,16 @@
    }
    public Map<String, Object> getSelectFinishedGlassShelfInformation(Integer pageNum, Integer pageSize) {
    public Map<String, Object> getSelectFinishedGlassShelfInformation(Integer pageNum, Integer pageSize,String type) {
        Integer offset = (pageNum - 1) * pageSize;
        Map<String, Object> map = new HashMap<>();
        map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDate(offset, pageSize));
        map.put("total", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDatePageTotal(offset, pageSize));
        if(type.equals("1")){
            map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDate(offset, pageSize));
            map.put("total", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDatePageTotal(offset, pageSize));
        }else{
            map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDateDetail(offset, pageSize));
            map.put("total", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationDateDetailPageTotal(offset, pageSize));
        }
        return map;
    }
@@ -153,17 +159,22 @@
    }
    public Map<String, Object> getSelectFinishedGlassShelfInformationDetails(Integer pageNum, Integer pageSize, String ids) {
        if (ids.startsWith("\"") && ids.endsWith("\"")) {
            ids = ids.substring(1, ids.length() - 1); // 去除首尾引号
        }
        List<Long> id=new ArrayList<>();;
        if(ids!=null && !ids.isEmpty()){
            List<String> result = StrUtil.split(ids, '|');
            id=result.stream().map(Long::valueOf).collect(Collectors.toList());
        }
    public Map<String, Object> getSelectFinishedGlassShelfInformationDetails(Integer pageNum, Integer pageSize, List<Map<String, Object>> object) {
        Map<String, Object> map = new HashMap<>();
        map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationInId(id));
        List<Map<String, Object>> mapList=new ArrayList<>();
        for(Map<String, Object> objectMap:object){
            mapList.add(finishedGlassShelfMapper.getSelectFinishedGlassShelfInformationInId(
                    objectMap.get("glassShelfName").toString(),
                    Double.parseDouble(objectMap.get("price").toString()),
                    objectMap.get("unit").toString(),
                    Double.parseDouble(objectMap.get("weight").toString()),
                    Double.parseDouble(objectMap.get("width").toString()),
                    Double.parseDouble(objectMap.get("height").toString())
            ));
        }
        map.put("data", mapList);
        return map;
    }
@@ -207,15 +218,22 @@
                List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId);
                if (!finishedGlassShelfEmitDetailsList2.isEmpty()) {
                    for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails : finishedGlassShelfEmitDetailsList2) {
                        finishedGlassShelfMapper.updateInformationAvailableQuantityInt(finishedGlassShelfEmitDetails);
                        finishedGlassShelfMapper.updateInformationAvailableQuantityInt(
                                finishedGlassShelfEmitDetails.getMaxWeight(),
                                finishedGlassShelfEmitDetails.getMaxWidth(),
                                finishedGlassShelfEmitDetails.getMaxHeight(),
                                finishedGlassShelfEmitDetails.getQuantity(),
                                finishedGlassShelfEmitDetails.getPrice(),
                                finishedGlassShelfEmitDetails.getUnit(),
                                finishedGlassShelfEmitDetails.getGlassShelfName());
                        finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetails(emitId);
                        finishedGlassShelfMapper.updateFinishedGlassShelfEmitDetailsLog(emitId);
                        finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(emitId);
                    }
                }
                oddNumber = emitId;
                finishedGlassShelfMapper.updateFinishedGlassShelfEmit(finishedGlassShelfEmit, oddNumber);
                log.setFunction("insertDelivery修改:"+oddNumber);
                log.setFunction("insertEmit修改:"+oddNumber);
            } else {
                //获取单号
                oddNumber = orderNumberSetting("出库");
@@ -229,9 +247,30 @@
                int index=1;
                for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails:finishedGlassShelfEmitDetailsList){
                    finishedGlassShelfEmitDetails.setMoney(finishedGlassShelfEmitDetails.getPrice()*finishedGlassShelfEmitDetails.getQuantity());
                    finishedGlassShelfMapper.updateInformationAvailableQuantityOut(finishedGlassShelfEmitDetails);
                    finishedGlassShelfMapper.updateInformationAvailableQuantityOut(
                            finishedGlassShelfEmitDetails.getMaxWeight(),
                            finishedGlassShelfEmitDetails.getMaxWidth(),
                            finishedGlassShelfEmitDetails.getMaxHeight(),
                            finishedGlassShelfEmitDetails.getQuantity(),
                            finishedGlassShelfEmitDetails.getPrice(),
                            finishedGlassShelfEmitDetails.getUnit(),
                            finishedGlassShelfEmitDetails.getGlassShelfName());
                    finishedGlassShelfMapper.insertFinishedGlassShelfEmitDetails(oddNumber,index,finishedGlassShelfEmitDetails);
                    finishedGlassShelfMapper.insertFinishedGlassShelfEmitDetailsLog(oddNumber,index,finishedGlassShelfEmitDetails);
                    finishedGlassShelfMapper.insertFinishedGlassShelfEmitDetailsLog(
                            oddNumber,
                            index,
                            1,
                            finishedGlassShelfEmitDetails.getQuantity(),
                            finishedGlassShelfEmitDetails.getPrice(),
                            finishedGlassShelfEmitDetails.getMoney(),
                            finishedGlassShelfEmitDetails.getUnit(),
                            finishedGlassShelfEmitDetails.getRemarks(),
                            finishedGlassShelfEmitDetails.getMaxWeight(),
                            finishedGlassShelfEmitDetails.getMaxWidth(),
                            finishedGlassShelfEmitDetails.getMaxHeight(),
                            finishedGlassShelfEmitDetails.getGlassShelfName(),
                            object.get("userName").toString()
                    );
                    index++;
                }
                logService.saveLog(log);
@@ -243,7 +282,7 @@
            //将异常传入数据库
            SysError sysError = new SysError();
            sysError.setError(e+Arrays.toString(e.getStackTrace()));
            sysError.setFunc("insertDelivery");
            sysError.setFunc("insertFinishedGlassShelfEmit");
            sysErrorService.insert(sysError);
            saveState = "false4";
@@ -289,18 +328,30 @@
            FinishedGlassShelfEmit finishedGlassShelfEmit2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitByemitId(emitId);
            if (finishedGlassShelfEmit2 != null) {
                //编辑还原数据
                List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId);
                if (!finishedGlassShelfEmitDetailsList2.isEmpty()) {
                    for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails : finishedGlassShelfEmitDetailsList2) {
                        finishedGlassShelfMapper.updateInformationAvailableQuantityInt(finishedGlassShelfEmitDetails);
                        finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(emitId);
                if(finishedGlassShelfEmit2.getState()==0){
                    //编辑还原数据
                    List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId);
                    if (!finishedGlassShelfEmitDetailsList2.isEmpty()) {
                        for (FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails : finishedGlassShelfEmitDetailsList2) {
                            finishedGlassShelfMapper.updateInformationAvailableQuantityInt(
                                    finishedGlassShelfEmitDetails.getMaxWeight(),
                                    finishedGlassShelfEmitDetails.getMaxWidth(),
                                    finishedGlassShelfEmitDetails.getMaxHeight(),
                                    finishedGlassShelfEmitDetails.getQuantity(),
                                    finishedGlassShelfEmitDetails.getPrice(),
                                    finishedGlassShelfEmitDetails.getUnit(),
                                    finishedGlassShelfEmitDetails.getGlassShelfName());
                            finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(emitId);
                        }
                        finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetails(emitId);
                        finishedGlassShelfMapper.deleteFinishedGlassShelfEmit(emitId);
                    }
                }else{
                    saveState = "false1";
                }
            }
            finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetails(emitId);
            finishedGlassShelfMapper.deleteFinishedGlassShelfEmit(emitId);
            Log log = new Log();
@@ -310,7 +361,6 @@
            log.setFunction("deleteFinishedGlassShelfEmit删除:"+emitId);
            logService.saveLog(log);
            return "true";
        }catch (Exception e) {
            TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint);
            //将异常传入数据库
@@ -326,6 +376,271 @@
    }
    public String insertFinishedGlassShelfWithdraw(Map<String,Object> object) {
        String saveState = "true";
        //设置回滚点
        Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint();
        try {
            String withdrawId="";
            String oddNumber = null;
            if (object.get("withdrawId") != null) {
                withdrawId = object.get("withdrawId").toString();
            } else {
                withdrawId = "";
            }
            FinishedGlassShelfWithdraw finishedGlassShelfWithdraw = JSONObject.parseObject(JSONObject.toJSONString(object.get("title")), FinishedGlassShelfWithdraw.class);
            List<FinishedGlassShelfWithdrawDetails> finishedGlassShelfWithdrawDetailsList = JSONArray.parseArray(JSONObject.toJSONString(object.get("withdrawDetails")), FinishedGlassShelfWithdrawDetails.class);
            //查询入库单是否存在
            FinishedGlassShelfWithdraw finishedGlassShelfWithdraw2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawByemitId(withdrawId);
            Log log = new Log();
            log.setOperator(object.get("userName").toString());
            log.setOperatorId(object.get("userId").toString());
            log.setContent(object.toString());
            if (finishedGlassShelfWithdraw2 != null) {
                //编辑还原数据
                List<FinishedGlassShelfWithdrawDetails> finishedGlassShelfWithdrawDetailsList2 = finishedGlassShelfMapper
                        .getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId1(withdrawId);
                if (!finishedGlassShelfWithdrawDetailsList2.isEmpty()) {
                    for (FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails : finishedGlassShelfWithdrawDetailsList2) {
                        finishedGlassShelfMapper.updateEmitDetailsWithdrawQuantityOut(finishedGlassShelfWithdrawDetails);
                        finishedGlassShelfMapper.updateInformationAvailableQuantityOut(
                                finishedGlassShelfWithdrawDetails.getMaxWeight(),
                                finishedGlassShelfWithdrawDetails.getMaxWidth(),
                                finishedGlassShelfWithdrawDetails.getMaxHeight(),
                                finishedGlassShelfWithdrawDetails.getQuantity(),
                                finishedGlassShelfWithdrawDetails.getPrice(),
                                finishedGlassShelfWithdrawDetails.getUnit(),
                                finishedGlassShelfWithdrawDetails.getGlassShelfName()
                        );
                        finishedGlassShelfMapper.deleteFinishedGlassShelfWithdrawDetails(withdrawId);
                        finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(withdrawId);
                    }
                }
                oddNumber = withdrawId;
                finishedGlassShelfMapper.updateFinishedGlassShelfWithdraw(finishedGlassShelfWithdraw, oddNumber);
                log.setFunction("insertWithdraw修改:"+oddNumber);
            } else {
                //获取单号
                oddNumber = orderNumberSetting("入库");
                //新增出库数据
                finishedGlassShelfMapper.insertFinishedGlassShelfWithdraw(finishedGlassShelfWithdraw, oddNumber);
                log.setFunction("insertFinishedGlassShelfWithdraw新增:"+oddNumber);
            }
            //获取对象集合循环进行新增修改
            if (finishedGlassShelfWithdrawDetailsList.size()>0) {
                int index=1;
                for (FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails:finishedGlassShelfWithdrawDetailsList){
                    if(finishedGlassShelfWithdrawDetails.getQuantity()>0){
                        finishedGlassShelfWithdrawDetails.setMoney(finishedGlassShelfWithdrawDetails.getPrice()*finishedGlassShelfWithdrawDetails.getQuantity());
                        finishedGlassShelfMapper.updateEmitDetailsWithdrawQuantityInt(finishedGlassShelfWithdrawDetails);
                        finishedGlassShelfMapper.updateInformationAvailableQuantityInt(
                                finishedGlassShelfWithdrawDetails.getMaxWeight(),
                                finishedGlassShelfWithdrawDetails.getMaxWidth(),
                                finishedGlassShelfWithdrawDetails.getMaxHeight(),
                                finishedGlassShelfWithdrawDetails.getQuantity(),
                                finishedGlassShelfWithdrawDetails.getPrice(),
                                finishedGlassShelfWithdrawDetails.getUnit(),
                                finishedGlassShelfWithdrawDetails.getGlassShelfName()
                        );
                        finishedGlassShelfMapper.insertFinishedGlassShelfWithdrawDetails(oddNumber,index,finishedGlassShelfWithdrawDetails);
                        finishedGlassShelfMapper.insertFinishedGlassShelfEmitDetailsLog(
                                oddNumber,
                                index,
                                2,
                                finishedGlassShelfWithdrawDetails.getQuantity(),
                                finishedGlassShelfWithdrawDetails.getPrice(),
                                finishedGlassShelfWithdrawDetails.getMoney(),
                                finishedGlassShelfWithdrawDetails.getUnit(),
                                finishedGlassShelfWithdrawDetails.getRemarks(),
                                finishedGlassShelfWithdrawDetails.getMaxWeight(),
                                finishedGlassShelfWithdrawDetails.getMaxWidth(),
                                finishedGlassShelfWithdrawDetails.getMaxHeight(),
                                finishedGlassShelfWithdrawDetails.getGlassShelfName(),
                                object.get("userName").toString()
                        );
                        index++;
                    }
                }
                getUpdateFinishedGlassShelfEmitState(finishedGlassShelfWithdrawDetailsList.get(0).getEmitId());
                logService.saveLog(log);
            } else {
                return "false3";
            }
        }catch (Exception e) {
            TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint);
            //将异常传入数据库
            SysError sysError = new SysError();
            sysError.setError(e+Arrays.toString(e.getStackTrace()));
            sysError.setFunc("insertFinishedGlassShelfWithdraw");
            sysErrorService.insert(sysError);
            saveState = "false4";
        }
        return saveState;
    }
    public void getUpdateFinishedGlassShelfEmitState(String emitId) {
        List<FinishedGlassShelfEmitDetails> finishedGlassShelfEmitDetailsList2 = finishedGlassShelfMapper
                .getSelectFinishedGlassShelfEmitDetailsByemitId1(emitId);
        int sumWithdrawQuantity=0;
        finishedGlassShelfMapper.updateFinishedGlassShelfEmitState(2,emitId);
        for(FinishedGlassShelfEmitDetails finishedGlassShelfEmitDetails:finishedGlassShelfEmitDetailsList2){
            sumWithdrawQuantity+=finishedGlassShelfEmitDetails.getWithdrawQuantity();
            if(finishedGlassShelfEmitDetails.getQuantity()!=finishedGlassShelfEmitDetails.getWithdrawQuantity()){
                finishedGlassShelfMapper.updateFinishedGlassShelfEmitState(1,emitId);
            }
        }
        if(sumWithdrawQuantity==0){
            finishedGlassShelfMapper.updateFinishedGlassShelfEmitState(0,emitId);
        }
    }
    public Map<String, Object> getSelectFinishedGlassShelfWithdraw(Integer pageNum, Integer pageSize,List<String> selectDate,
                                                                   FinishedGlassShelfWithdraw finishedGlassShelfWithdraw) throws JsonProcessingException {
        Integer offset = (pageNum - 1) * pageSize;
        String endDate = LocalDate.now().toString();
        String startDate = LocalDate.now().minusDays(15).toString();
        if(selectDate !=null && selectDate.size()==2){
            if(!selectDate.get(0).isEmpty()){
                startDate = selectDate.get(0);
            }
            if(!selectDate.get(1).isEmpty()){
                endDate = selectDate.get(1);
            }
        }
        Map<String, Object> map = new HashMap<>();
        map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdraw(offset, pageSize,startDate,endDate, finishedGlassShelfWithdraw));
        map.put("total", finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawPageTotal(offset, pageSize,startDate,endDate, finishedGlassShelfWithdraw));
        List<String> list = new ArrayList<>();
        list.add(startDate);
        list.add(endDate);
        map.put("selectDate",list);
        return map;
    }
    public Map<String, Object> getSelectFinishedGlassShelfWithdrawDetails(Integer pageNum, Integer pageSize, String withdrawId) {
        if (withdrawId.startsWith("\"") && withdrawId.endsWith("\"")) {
            withdrawId = withdrawId.substring(1, withdrawId.length() - 1); // 去除首尾引号
        }
        Map<String, Object> map = new HashMap<>();
        map.put("withdraw", finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawByemitId(withdrawId));
        map.put("data", finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId(withdrawId));
        return map;
    }
    public String deleteFinishedGlassShelfWithdraw(Map<String,Object> object) {
        String saveState = "true";
        //设置回滚点
        Object savePoint = TransactionAspectSupport.currentTransactionStatus().createSavepoint();
        try {
            String withdrawId = "";
            if (object.get("withdrawId") != null) {
                withdrawId = object.get("withdrawId").toString();
            }
            FinishedGlassShelfWithdraw finishedGlassShelfWithdraw2 = finishedGlassShelfMapper.getSelectFinishedGlassShelfWithdrawByemitId(withdrawId);
            if (finishedGlassShelfWithdraw2 != null) {
                //编辑还原数据
                List<FinishedGlassShelfWithdrawDetails> finishedGlassShelfWithdrawDetailsList2 = finishedGlassShelfMapper
                        .getSelectFinishedGlassShelfWithdrawDetailsBywithdrawId1(withdrawId);
                if (!finishedGlassShelfWithdrawDetailsList2.isEmpty()) {
                    for (FinishedGlassShelfWithdrawDetails finishedGlassShelfWithdrawDetails : finishedGlassShelfWithdrawDetailsList2) {
                        finishedGlassShelfMapper.updateEmitDetailsWithdrawQuantityOut(finishedGlassShelfWithdrawDetails);
                        finishedGlassShelfMapper.updateInformationAvailableQuantityOut(
                                finishedGlassShelfWithdrawDetails.getMaxWeight(),
                                finishedGlassShelfWithdrawDetails.getMaxWidth(),
                                finishedGlassShelfWithdrawDetails.getMaxHeight(),
                                finishedGlassShelfWithdrawDetails.getQuantity(),
                                finishedGlassShelfWithdrawDetails.getPrice(),
                                finishedGlassShelfWithdrawDetails.getUnit(),
                                finishedGlassShelfWithdrawDetails.getGlassShelfName()
                        );
                        finishedGlassShelfMapper.deleteFinishedGlassShelfEmitDetailsLog(withdrawId);
                    }
                    finishedGlassShelfMapper.deleteFinishedGlassShelfWithdrawDetails(withdrawId);
                    finishedGlassShelfMapper.deleteFinishedGlassShelfWithdraw(withdrawId);
                    getUpdateFinishedGlassShelfEmitState(finishedGlassShelfWithdrawDetailsList2.get(0).getEmitId());
                }
            }
            Log log = new Log();
            log.setOperatorId(object.get("userId").toString());
            log.setOperator(object.get("userName").toString());
            log.setContent(object.toString());
            log.setFunction("deleteFinishedGlassShelfWithdraw删除:"+withdrawId);
            logService.saveLog(log);
            return "true";
        }catch (Exception e) {
            TransactionAspectSupport.currentTransactionStatus().rollbackToSavepoint(savePoint);
            //将异常传入数据库
            SysError sysError = new SysError();
            sysError.setError(e+Arrays.toString(e.getStackTrace()));
            sysError.setFunc("deleteFinishedGlassShelfWithdraw");
            sysErrorService.insert(sysError);
            saveState = "false";
        }
        return saveState;
    }
    public Map<String, Object> getFinishedGlassShelfLogReport(String type,Integer pageNum, Integer pageSize,
                                                              List<String> selectDate, FinishedGlassShelfLog finishedGlassShelfLog) {
        Integer offset = (pageNum-1)*pageSize;
        String endDate = LocalDate.now().toString();
        String startDate = LocalDate.now().minusDays(15).toString();
        if(selectDate !=null && selectDate.size()==2){
            if(!selectDate.get(0).isEmpty()){
                startDate = selectDate.get(0);
            }
            if(!selectDate.get(1).isEmpty()){
                endDate = selectDate.get(1);
            }
        }
        int state=0;
        if(type.equals("料架出库")){
            state=1;
        }else if(type.equals("料架入库")){
            state=2;
        }
        Map<String, Object> map = new HashMap<>();
        System.out.println(finishedGlassShelfLog.getDocumentId());
        map.put("data", finishedGlassShelfMapper.getFinishedGlassShelfLogReport(offset, pageSize,startDate, endDate, finishedGlassShelfLog,state));
        map.put("total", finishedGlassShelfMapper.getFinishedGlassShelfLogReportTotal(offset, pageSize,startDate, endDate, finishedGlassShelfLog,state));
        List<String> list = new ArrayList<>();
        list.add(startDate);
        list.add(endDate);
        map.put("selectDate",list);
        return map;
    }
    public List<FinishedGlassShelfLog> exportFinishedGlassShelfLogReport(List<LocalDate> dates, String type) {
        int state=0;
        if(type.equals("料架出库")){
            state=1;
        }else if(type.equals("料架入库")){
            state=2;
        }
        return finishedGlassShelfMapper.exportFinishedGlassShelfLogReport(dates,state);
    }