对比新文件 |
| | |
| | | package com.gkhy.safePlatform.targetDuty.repository; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import com.gkhy.safePlatform.targetDuty.entity.TargetDutyWorkApprove; |
| | | import com.gkhy.safePlatform.targetDuty.model.dto.resp.ListCheckDataDto; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | /** |
| | | * 目标责任管理工作流审批表(TargetDutyWorkApprove)表数据库访问层 |
| | | * |
| | | * @author xurui |
| | | * @since 2022-08-11 10:13:37 |
| | | */ |
| | | @Repository |
| | | public interface TargetDutyWorkApproveRepository extends BaseMapper<TargetDutyWorkApprove> { |
| | | |
| | | @Select("<script> select c.duty_department_id,c.value,c.maker_department_id,c.make_date,a.relate_desc,a.gmt_create " + |
| | | "from target_duty_work_approve a INNER JOIN target_divide_detail c on a.relate_id = c.target_id where 1=1 " + |
| | | "AND a.child_id is null AND a.approve_status = 3 AND a.approve_result = 1 AND a.relate_type = 1 AND a.del_flag = 0 AND a.relate_id =#{relateId} ORDER BY a.gmt_create DESC </script> ") |
| | | IPage<ListCheckDataDto> listCheckData(IPage<ListCheckDataDto> page, @Param("relateId") Long relateId); |
| | | } |