ErpSettlementMapper.java
1.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
package com.skua.modules.erp.mapper;
import java.util.List;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.skua.modules.erp.entity.ErpSettlementItem;
import com.skua.modules.erp.vo.ErpSettlementItemVO;
import com.skua.modules.erp.vo.ErpSettlementVO;
import com.skua.tool.annotation.Anonymous;
import org.apache.ibatis.annotations.Param;
import com.skua.modules.erp.entity.ErpSettlement;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
/**
* 药剂结算单详情
*/
public interface ErpSettlementMapper extends BaseMapper<ErpSettlement> {
//供应商结算--校验供应商
List<ErpSettlementVO> checkSettlementBySupplier(@Param("ids") String ids);
//水厂结算--校验水厂
List<ErpSettlementVO> checkSettlementByWaterDepart(@Param("ids")String ids);
// 根据入库单ids,获取【供应商】结算单详情
@Anonymous
List<ErpSettlementItemVO> querySupplierSettlementByMaterialIds(@Param("ids") String materialIds);
// 根据入库单ids,获取【水厂】结算单详情
@Anonymous
List<ErpSettlementItemVO> queryWaterDepartSettlementByMaterialIds(@Param("ids") String materialIds);
//供应商结算分页列表
@Anonymous
@Select("select * from erp_settlement ${ew.customSqlSegment}")
IPage<ErpSettlement> querySettlementPageBySupplier(Page<ErpSettlement> page, @Param(Constants.WRAPPER) QueryWrapper<ErpSettlement> queryWrapper);
//(供应商)送货单以及物资验收单
/// List<ErpSettlementItemVO> querySupplierSettlementFormById(@Param("id")String id);
//(水厂) 送货单以及物资验收单
// List<ErpSettlementItemVO> queryWaterDepartSettlementFormById(@Param("id")String id);
}