| | |
| | | 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; |
| | | |
| | | /** |
| | |
| | | @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); |
| | | } |