| | |
|---|
| | | import com.baomidou.mybatisplus.mapper.BaseMapper; |
|---|
| | | import com.zy.asrs.entity.Pla; |
|---|
| | | import org.apache.ibatis.annotations.Mapper; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | import org.springframework.stereotype.Repository; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | | @Mapper |
|---|
| | | @Repository |
|---|
| | | public interface PlaMapper extends BaseMapper<Pla> { |
|---|
| | | |
|---|
| | | @Select("select brand, matnr,workshop, sum(weight_anfme) as weight from asr_pla_detl where brand = #{brand} GROUP BY brand,matnr,workshop ORDER BY matnr,workshop") |
|---|
| | | List<Pla> getStockStatisAllByBrand(@Param("brand") String brand); |
|---|
| | | |
|---|
| | | @Select("select brand, matnr,workshop , sum(weight_anfme) as weight from asr_pla_detl GROUP BY brand,matnr,workshop ORDER BY matnr,workshop desc") |
|---|
| | | List<Pla> getStockStatisAll(); |
|---|
| | | |
|---|
| | | |
|---|
| | | Integer getStockStatisCountAll(Map<String, Object> map); |
|---|
| | | |
|---|
| | | } |
|---|
