public async Task <IActionResult> GetQuestionCollectionListAsync([FromQuery] GetQuestionCollectionListRequestDto requestDto)
{
var response = await new FaqsQuestionBiz().GetQuestionCollectionListAsync(requestDto, UserID);
return(Success(response));
}
/// <summary>
/// 获取用户收藏的问题列表
/// </summary>
/// <param name="requestDto">分页参数</param>
/// <param name="userId">用户guid</param>
/// <returns></returns>
public async Task <GetQuestionCollectionListResponseDto> GetQuestionCollectionListAsync(GetQuestionCollectionListRequestDto requestDto, string userId)
{
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
INNER JOIN t_consumer_collection c ON a.question_guid = c.target_guid
LEFT JOIN t_utility_hot b ON a.question_guid = b.owner_guid
WHERE
c.user_guid = '{userId}'
AND a.`enable` = 1 and c.`enable`=1
ORDER BY
c.creation_date DESC" ;
var result = await MySqlHelper.QueryByPageAsync <GetQuestionCollectionListRequestDto, GetQuestionCollectionListResponseDto, GetQuestionCollectionListItemDto>(sql, requestDto);
return(result);
}
