#getArmType$

lsh

10 小时以前 f543f2b2df318ce42111fbe9727a1fb7c7a588d6

#getArmType$

 src/main/java/com/zy/asrs/controller/OpenController.java

@@ -4,6 +4,7 @@
import com.core.annotations.AppAuth;
import com.core.common.*;
import com.core.exception.CoolException;
import com.zy.asrs.entity.ViewStockUseBeanDigitalTwin;
import com.zy.asrs.entity.param.*;
import com.zy.asrs.service.OpenService;
import com.zy.common.model.DetlDto;
@@ -216,4 +217,15 @@
        System.out.println(JSON.toJSONString(param1));
    }


    /**
     * 数据总览
     */
    @RequestMapping("/digitalTwin/overview")
    public R digitalTwinOverview(@RequestHeader(required = false) String appkey,
                        HttpServletRequest request) {
        auth(appkey, null, request);
        return R.ok().add(openService.digitalTwinOverview());
    }

}

 src/main/java/com/zy/asrs/entity/ViewStockUseBeanDigitalTwin.java

New file
@@ -0,0 +1,20 @@
package com.zy.asrs.entity;

import lombok.Data;

/**
 * 库位使用率视图实体类
 * @author admin
 * @date 2018年11月23日
 */
@Data
public class ViewStockUseBeanDigitalTwin {
    private Long totalLoc;        //库位总数
    private Long useLoc;        //已用库位
    private Long idleLoc;        //剩余库位
    private Long todayOutbound;        //今日出库
    private Long todayWarehousing;        //今日入库
    private Long remainingStock;        //剩余库存
    private String nowData;        //剩余库存

}

 src/main/java/com/zy/asrs/service/OpenService.java

@@ -1,5 +1,6 @@
package com.zy.asrs.service;

import com.zy.asrs.entity.ViewStockUseBeanDigitalTwin;
import com.zy.asrs.entity.param.*;
import com.zy.asrs.entity.result.OpenOrderCompeteResult;
import com.zy.asrs.entity.result.StockVo;
@@ -43,4 +44,9 @@
     * @param param
     */
    void syncMat(MatSyncParam param);

    /**
     * 库存统计
     */
    ViewStockUseBeanDigitalTwin digitalTwinOverview();
}

 src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java

@@ -9,6 +9,7 @@
import com.zy.asrs.entity.param.*;
import com.zy.asrs.entity.result.OpenOrderCompeteResult;
import com.zy.asrs.entity.result.StockVo;
import com.zy.asrs.mapper.ReportQueryMapper;
import com.zy.asrs.mapper.TagMapper;
import com.zy.asrs.service.*;
import com.zy.asrs.utils.MatUtils;
@@ -20,6 +21,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@@ -49,6 +51,10 @@
    private TagService tagService;
    @Autowired
    private TagMapper tagMapper;
    @Autowired
    private LocMastServiceImpl locMastService;
    @Autowired
    private ReportQueryMapper reportQueryMapper;

    @Override
    @Transactional
@@ -589,4 +595,30 @@

    }

    @Override
    @Transactional
    public ViewStockUseBeanDigitalTwin digitalTwinOverview() {
        ViewStockUseBeanDigitalTwin viewStockUseBeanDigitalTwin = new ViewStockUseBeanDigitalTwin();
        int selectCountLocDetl = locDetlService.selectCount(new EntityWrapper<LocDetl>());
        viewStockUseBeanDigitalTwin.setRemainingStock(Integer.toUnsignedLong(selectCountLocDetl));
        int selectCountLocMast = locMastService.selectCount(new EntityWrapper<LocMast>());
        viewStockUseBeanDigitalTwin.setTotalLoc(Integer.toUnsignedLong(selectCountLocMast));
        int selectCountLocMastNEO = locMastService.selectCount(new EntityWrapper<LocMast>().ne("loc_sts","O").ne("loc_sts","X"));
        viewStockUseBeanDigitalTwin.setUseLoc(Integer.toUnsignedLong(selectCountLocMastNEO));
        int selectCountLocMastO = locMastService.selectCount(new EntityWrapper<LocMast>().eq("loc_sts","O"));
        viewStockUseBeanDigitalTwin.setIdleLoc(Integer.toUnsignedLong(selectCountLocMastO));
        List<ViewInOutBean> list = reportQueryMapper.getViewInOutAll(new ViewInOutBean());
        Date date = new Date();
        String format = new SimpleDateFormat("yyyy-MM-dd").format(date);
        viewStockUseBeanDigitalTwin.setNowData(format);
        for (ViewInOutBean view : list) {
            if (view.getYmd().equals(format)) {
                viewStockUseBeanDigitalTwin.setTodayOutbound(view.getRet_qty());
                viewStockUseBeanDigitalTwin.setTodayWarehousing(view.getSto_qty());
                break;
            }
        }
        return viewStockUseBeanDigitalTwin;
    }

}