| | |
|---|
| | | @Repository |
|---|
| | | public interface ReportQueryMapper { |
|---|
| | | |
|---|
| | | //分页查询库位使用率 |
|---|
| | | //分页查询四项库库位使用率 |
|---|
| | | List<ViewStockUseBean> queryViewStockUseList(ViewStockUseBean viewStockUse); |
|---|
| | | int getViewStockUseCount(ViewStockUseBean viewStockUse); |
|---|
| | | List<ViewStockUseBean> getViewStockUseAll(ViewStockUseBean viewStockUse); |
|---|
| | | //分页查询agv1楼库位使用率 |
|---|
| | | List<ViewStockUseBean> queryViewStockUse1List(ViewStockUseBean viewStockUse); |
|---|
| | | int getViewStockUse1Count(ViewStockUseBean viewStockUse); |
|---|
| | | List<ViewStockUseBean> getViewStockUse1All(ViewStockUseBean viewStockUse); |
|---|
| | | //分页查询agv3楼库位使用率 |
|---|
| | | List<ViewStockUseBean> queryViewStockUse3List(ViewStockUseBean viewStockUse); |
|---|
| | | int getViewStockUse3Count(ViewStockUseBean viewStockUse); |
|---|
| | | List<ViewStockUseBean> getViewStockUse3All(ViewStockUseBean viewStockUse); |
|---|
| | | |
|---|
| | | //分页查询库存滞留时间 |
|---|
| | | public List<ViewStayTimeBean> queryViewStayTimeList(ViewStayTimeBean viewStayTime); |
|---|
| | |
|---|
| | | //不分页查询所有信息，用于excel导出 |
|---|
| | | public List<ViewStayTimeBean> getViewStayTimeAll(ViewStayTimeBean viewStayTime); |
|---|
| | | |
|---|
| | | //分页查询AGV和四项库库存滞留时间 |
|---|
| | | public List<ViewStayTimeBean> queryAllViewStayTimeList(ViewStayTimeBean viewStayTime); |
|---|
| | | public int getAllViewStayTimeCount(ViewStayTimeBean viewStayTime); |
|---|
| | | //不分页查询AGV和四项库所有信息，用于excel导出 |
|---|
| | | public List<ViewStayTimeBean> getAllViewStayTimeAll(ViewStayTimeBean viewStayTime); |
|---|
| | | |
|---|
| | | // // 库位Map |
|---|
| | | @Select("select distinct row1 from asr_loc_mast order by row1 asc") |
|---|
| | | List<Integer> getViewLocRowTotal(); |
|---|
