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