/** * <p>Company: http://www.ctnrs.com</p> * <p>Copyright: Copyright (c) 2019</p> */ package com.ctnrs.stock.mapper; import com.ctnrs.stock.api.model.Stock; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import org.apache.ibatis.annotations.Update; public interface StockMapper { @Select("select s.id,s.prod_id as prodId, s.sales_stock AS salesStock,s.real_stock AS realStock FROM stock s WHERE prod_id = #{productId}") Stock findStockByProductId(@Param("productId") Long productId); @Update("update stock set real_stock=real_stock-#{count} where prod_id = #{productId}") Long deductionStock(@Param("productId") Long productId,@Param("count") int count); }