zy-asrs.git - Gitblit

			@@ -2,6 +2,9 @@

			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;
			import org.apache.ibatis.annotations.Mapper;
			import org.apache.ibatis.annotations.Param;
			@@ -45,6 +48,14 @@

			Integer getStockStatisCount(Map<String, Object> map);

			List<LocDetlAll> getStockStatisAll(Map<String, Object> map);

			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}")
			@@ -58,7 +69,7 @@

			// -------------------------------------------------

			List<LocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos);
			List<LocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("owner")int owner);

			List<LocDetl> queryStockViewMerge(@Param("locNo")String locNo);

			@@ -75,4 +86,21 @@

			Integer queryStockViewMergeCount(@Param("row")int row,@Param("lev")int lev);

			//通过订单号、物料号、物料名称、规格、库位号进行模糊搜索
			List<LocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo);

			List<LocDetl> queryStock2(String matnr, String batch);

			List<LocDetlAll> selectAllOwner(LocDetlDTO locDetlDTO);

			int selectAllCount(LocDetlDTO locDetlDTO);

			List<LocDetlAll> selectAllPyment(LocDetlDTO locDetlDTO);

			int selectAllPymentcount(LocDetlDTO locDetlDTO);
			Double sumAll();

			List<LocDetlWarningDTO> selectAllWarning(LocDetlWarningDTO locDetlWarningDTO);

			int getAllWarningCount(LocDetlWarningDTO locDetlWarningDTO);
			}