/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
package org.springblade.modules.soldr.mapper;
|
|
import org.apache.ibatis.annotations.Param;
|
import org.springblade.modules.soldr.entity.Soldr;
|
import org.springblade.modules.soldr.vo.SoldrVO;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.springblade.modules.soldrecord.vo.SoldrecordVO;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 已出库存数量记录表 Mapper 接口
|
*
|
* @author BladeX
|
* @since 2022-05-27
|
*/
|
public interface SoldrMapper extends BaseMapper<Soldr> {
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param soldr
|
* @return
|
*/
|
List<SoldrVO> selectSoldrPage(IPage page, SoldrVO soldr);
|
List<SoldrVO> selectLists(IPage page, SoldrVO soldr);
|
void del(Long id);
|
void dels(Long id);
|
List<SoldrVO> selectSol(@Param("farmId") String farmId);
|
List<Map<String, Object>> selectCz(@Param("sid") Long sid,@Param("deptId") String deptId);
|
/**
|
* 根据stockId、specs1、specs_val1、specs_val2、sid 找到soldr表中对应的数据
|
* @param stockId1 种类id
|
* @param specs1 规格
|
* @param specsVal1 规格值（0：克 1：斤 2：公斤 3：吨 4：毫升 5：升 ）
|
* @param specsVal2 规格值2( 0:袋 1：包 2：瓶 3：盒 4：箱 5：桶 6:支)
|
* @param sid 农资库存表主键
|
* @param type 出库类型
|
*/
|
Soldr getByServalParam(@Param("stockId1") String stockId1,
|
@Param("specs1") String specs1,
|
@Param("specsVal1") Integer specsVal1,
|
@Param("specsVal2") Integer specsVal2,
|
@Param("sid") Long sid,
|
@Param("type") String type);
|
|
void cancelDel(Long id);
|
}
|
