/// <summary>
/// 获取问答热门问题分页列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetHotFAQsResponseDto> GetHotFAQsPageListAsync(GetHotFAQsRequestDto requestDto)
{
var wheresql = "";
if (requestDto.LatestDay != 0)
{
wheresql = "and a.creation_date>DATE_SUB(NOW(),INTERVAL @LatestDay DAY) ";
}
if (!string.IsNullOrWhiteSpace(requestDto.Keyword))
{
wheresql = "and a.content like @Keyword ";
requestDto.Keyword = $"%{requestDto.Keyword}%";
}
var sql = $@"SELECT
a.question_guid,
a.content,
a.creation_date,
a.answer_num,
a.`status`,
ifnull( b.visit_count, 0 ) AS visit_count
FROM
t_faqs_question a
LEFT JOIN t_utility_hot b ON a.question_guid = b.owner_guid
WHERE a.`enable`=1 {wheresql}
ORDER BY
b.visit_count DESC" ;
var result = await MySqlHelper.QueryByPageAsync <GetHotFAQsRequestDto, GetHotFAQsResponseDto, GetHotFAQsItemDto>(sql, requestDto);
return(result);
}
public async Task <IActionResult> GetHotFAQsPageListAsync([FromQuery] GetHotFAQsRequestDto requestDto)
{
var response = await new FaqsQuestionBiz().GetHotFAQsPageListAsync(requestDto);
return(Success(response));
}
