package com.ltkj.hosp.mapper;
|
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.ltkj.hosp.domain.TjCompPay;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
|
/**
|
* 体检单位缴费主Mapper接口
|
*
|
* @author ltkj
|
* @date 2023-03-14
|
*/
|
@Mapper
|
public interface TjCompPayMapper extends BaseMapper<TjCompPay> {
|
|
|
|
@Select("SELECT IFNULL(SUM(a.paid_in),0) yf FROM tj_comp_pay a WHERE a.deleted=0 " +
|
"AND a.comp_id=#{compId} AND a.team_no=#{teamNo} AND a.pac_id=#{pacId}")
|
BigDecimal sumZje(@Param("compId")String compId,@Param("teamNo") String teamNo,@Param("pacId") String pacId);
|
|
@Select("SELECT a.serial_number FROM tj_comp_pay a WHERE a.deleted=0 " +
|
"AND a.comp_id=#{compId} AND a.team_no=#{teamNo} AND a.pac_id=#{pacId}")
|
List<String> serialNumbers(@Param("compId")String compId,@Param("teamNo") String teamNo,@Param("pacId") String pacId);
|
}
|
