public async Task <IActionResult> GetMyReplyPageAsync([FromQuery] GetMyReplyPageRequestDto request)
{
var response = await new FaqsQuestionBiz().GetMyReplyPageAsync(request, UserID);
var users = await new UserExBiz().GetListAsync(response.CurrentPage.Select(a => a.UserGuid));
foreach (var item in response.CurrentPage)
{
item.UserName = users.FirstOrDefault(a => a.UserGuid == item.UserGuid)?.UserName;
}
return(Success(response));
}
public async Task <GetFaqsQuestionPageResponseDto> GetMyReplyPageAsync(GetMyReplyPageRequestDto request, string userid)
{
var sqlWhere = $@"AND a.enable=1";
if (request.BeginDate != null)
{
request.BeginDate = request.BeginDate?.Date;
sqlWhere = $"{sqlWhere} AND a.creation_date > @BeginDate";
}
if (request.EndDate != null)
{
request.EndDate = request.EndDate?.AddDays(1).Date;
sqlWhere = $"{sqlWhere} AND a.creation_date < @EndDate";
}
var sql = $@"
SELECT DISTINCT
a.question_guid,
a.user_guid,
a.reward_intergral,
a.`status`,
a.answer_num,
a.content,
a.attachment_guid_list,
a.creation_date,
a.ENABLE,
c.visit_count,
c.like_count
FROM
t_faqs_question a
LEFT JOIN t_faqs_answer b ON a.question_guid = b.question_guid
LEFT JOIN t_utility_hot c ON a.question_guid = c.owner_guid
WHERE
1 = 1 {sqlWhere} and b.user_guid = '{userid}'
ORDER BY
a.creation_date desc" ;
return(await MySqlHelper.QueryByPageAsync <GetMyReplyPageRequestDto, GetFaqsQuestionPageResponseDto, GetFaqsQuestionPageItemDto>(sql, request));
}