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);
|
}
|
