package com.gkhy.safePlatform.targetDuty.repository;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.gkhy.safePlatform.targetDuty.entity.RewardPunishmentDetail;
|
import com.gkhy.safePlatform.targetDuty.model.dto.resp.RewardPunishmentDetailDto;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
/**
|
* 奖惩记录(RewardPunishmentDetail)表数据库访问层
|
*
|
* @author xurui
|
* @since 2022-07-21 10:15:45
|
*/
|
@Repository
|
public interface RewardPunishmentDetailRepository extends BaseMapper<RewardPunishmentDetail> {
|
|
@Select("<script> select a.id,a.person_id,a.create_time ,b.standard_type ,b.content ,b.q_name ,b.reason " +
|
"from reward_punishment_detail a left join reward_punishment_standard b on a.reward_punishment_standard_id=b.id where 1=1 " +
|
"<if test =\"personId !='' and personId !=null\">and a.person_id =#{personId}</if> </script> ")
|
IPage<RewardPunishmentDetailDto> queryAll(IPage<RewardPunishmentDetailDto> page, @Param("personId") String personId);
|
}
|
