package com.talentcard.server.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.talentcard.server.entity.DependentCardApply;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
@Mapper
|
public interface DependentCardApplyMapper extends BaseMapper<DependentCardApply> {
|
|
@Select("""
|
select c.id as talentCardId, c.talent_id as talentId, c.card_no as talentCardNo,
|
c.card_level as cardLevel, c.is_family_card_enabled as isFamilyCardEnabled,
|
c.family_card_limit as familyCardLimit, u.name as talentName, u.mobile as talentMobile
|
from talent_card c
|
join talent_user u on u.id = c.talent_id and u.deleted = 0
|
where c.id = #{talentCardId}
|
and c.deleted = 0
|
and c.card_type = 'PERSONAL'
|
and c.status = 1
|
limit 1
|
for update
|
""")
|
DependentCardApply selectOwnerCard(@Param("talentCardId") Long talentCardId);
|
|
@Select("""
|
select *
|
from dependent_card_apply
|
where id = #{id} and deleted = 0
|
limit 1
|
for update
|
""")
|
DependentCardApply selectByIdForUpdate(@Param("id") Long id);
|
}
|
