| | |
|---|
| | | |
|---|
| | | import com.baomidou.mybatisplus.mapper.BaseMapper; |
|---|
| | | import com.zy.asrs.entity.LocDetl; |
|---|
| | | import com.zy.asrs.entity.LocDetlWarningDTO; |
|---|
| | | import com.zy.asrs.entity.result.LocDetlAll; |
|---|
| | | import com.zy.asrs.entity.result.LocDetlDTO; |
|---|
| | | import com.zy.asrs.entity.result.StockVo; |
|---|
| | |
|---|
| | | |
|---|
| | | Integer getStockStatisCountAll(Map<String, Object> map); |
|---|
| | | |
|---|
| | | List<LocDetlAll> getWarningNumList(Map<String, Object> map); |
|---|
| | | |
|---|
| | | Integer getWarningNumListCount(Map<String, Object> map); |
|---|
| | | |
|---|
| | | List<LocDetl> getStockStatisExcel(); |
|---|
| | | |
|---|
| | | @Select("select sum(a.anfme) as sum from asr_loc_detl a left join asr_loc_mast b on a.loc_no = b.loc_no where b.loc_sts = 'F' and a.matnr = #{matnr}") |
|---|
| | |
|---|
| | | //通过订单号、物料号、物料名称、规格、库位号进行模糊搜索 |
|---|
| | | List<LocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo); |
|---|
| | | |
|---|
| | | List<LocDetl> queryStock2(String matnr, String batch, int owner); |
|---|
| | | List<LocDetl> queryStock2(String matnr, String batch); |
|---|
| | | |
|---|
| | | List<LocDetlAll> selectAllOwner(LocDetlDTO locDetlDTO); |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | int selectAllPymentcount(LocDetlDTO locDetlDTO); |
|---|
| | | Double sumAll(); |
|---|
| | | |
|---|
| | | List<LocDetlWarningDTO> selectAllWarning(LocDetlWarningDTO locDetlWarningDTO); |
|---|
| | | |
|---|
| | | int getAllWarningCount(LocDetlWarningDTO locDetlWarningDTO); |
|---|
| | | } |
|---|
