public async Task <IActionResult> GetListToApprove([FromBody] GetListToApproveRequest requestDto)
{
if (string.IsNullOrWhiteSpace(requestDto.UserID))
{
requestDto.UserID = UserID;
}
var responseList = await new CommonReportThemeBiz().GetListToApprove(requestDto);
return(Success(responseList));
}
/// <summary>
/// 运营-审核列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetListToApproveResponseDto> GetListToApprove(GetListToApproveRequest requestDto)
{
var sqlStr = @"SELECT
th.theme_guid,
th.name,
th.demand,
th.condition_demand,
ap.approve_guid,
ap.apply_user_guid,
u.user_name AS ApplyUserName,
ap.sql_writer_guid,
u2.user_name AS SQLWriterName,
ap.sql_approver_guid,
u3.user_name AS SQLApproverName,
ap.list_approver_guid,
u4.user_name AS ListApproverName,
ap.approved_reason,
ap.approved_datetime,
ap.approve_schedule_enum,
ap.approve_status,
ap.creation_date
FROM
t_report_approve AS ap
LEFT JOIN t_report_theme AS th ON ap.theme_guid = th.theme_guid
AND ap.ENABLE =
TRUE LEFT JOIN t_utility_user AS u ON ap.apply_user_guid = u.user_guid
LEFT JOIN t_utility_user AS u2 ON ap.sql_writer_guid = u2.user_guid
LEFT JOIN t_utility_user AS u3 ON ap.sql_approver_guid = u3.user_guid
LEFT JOIN t_utility_user AS u4 ON ap.list_approver_guid = u4.user_guid
WHERE
th.`enable` = TRUE
AND
( ap.approve_schedule_enum = 'Approve' AND ap.approve_status = 'Pending' )
ORDER BY
ap.creation_date DESC " ;
return(await MySqlHelper.QueryByPageAsync <GetListToApproveRequest, GetListToApproveResponseDto, GetListToApproveItemDto>(sqlStr, requestDto));
}