/// <summary>
/// 获取客户端综合文章(普通文章+健康管理文章)分页列表
/// </summary>
/// <param name="requestDto"></param>
public async Task <GetClientArticlePageListResponseDto> GetClientArticlePageListAsync(GetClientArticlePageListRequestDto requestDto)
{
var whereSql = string.Empty;
if (!string.IsNullOrWhiteSpace(requestDto.ArticleTypeDic))
{
whereSql = "and article.article_type_dic=@ArticleTypeDic";
}
if (!string.IsNullOrWhiteSpace(requestDto.AuthorGuid))
{
whereSql = $"{whereSql} and article.author_guid=@AuthorGuid";
}
#region MyRegion
//var sql = $@"SELECT
// article.article_guid AS ArticleGuid,
// article.title AS Title,
// article.last_updated_date AS LastUpdatedDate,
// article.author_guid AS AuthorGuid,
// u.user_name AS AuthorName,
// CONCAT( acce.base_path, acce.relative_path ) AS Picture,
// article.article_type_dic AS ArticleTypeDic,
// articleType.config_name AS ArticleType,
// article.source_type AS ArticleSource,
// count( DISTINCT l.like_guid ) AS LikeTotal,
// count( DISTINCT av.view_guid ) AS PageView
// FROM
// t_utility_article AS article
// LEFT JOIN t_utility_user u ON u.user_guid = article.author_guid
// LEFT JOIN t_utility_accessory AS acce ON acce.accessory_guid = article.picture_guid
// AND acce.`enable` = 1
// LEFT JOIN t_manager_dictionary AS articleType ON articleType.dic_guid = article.article_type_dic
// AND articleType.`enable` = 1
// LEFT JOIN t_consumer_like l ON article.article_guid = l.target_guid
// AND l.`enable` = 1
// LEFT JOIN t_consumer_article_view av ON article.article_guid = av.target_guid
// AND av.`enable` = 1
// WHERE
// article.`enable` = 1
// AND article.`actcle_release_status` = 'Release'
// AND article.visible = 1 {whereSql}
// GROUP BY
// article.article_guid,
// article.title,
// article.last_updated_date,
// u.user_name,
// Picture,
// article.article_type_dic,
// articleType.config_name ,
// article.source_type
// ORDER BY
// LastUpdatedDate DESC";
#endregion
var sql = $@"SELECT
article.article_guid AS ArticleGuid,
article.title AS Title,
article.external_link as ExternalLink,
article.last_updated_date AS LastUpdatedDate,
article.author_guid AS AuthorGuid,
u.user_name AS AuthorName,
CONCAT( acce.base_path, acce.relative_path ) AS Picture,
article.article_type_dic AS ArticleTypeDic,
articleType.config_name AS ArticleType,
article.source_type AS ArticleSource,
IFNULL(hot.like_count, 0) AS LikeTotal,
IFNULL(hot.visit_count, 0) AS PageView
FROM
t_utility_article AS article
LEFT JOIN t_utility_user u ON u.user_guid = article.author_guid
LEFT JOIN t_utility_accessory AS acce ON acce.accessory_guid = article.picture_guid
AND acce.`enable` = 1
LEFT JOIN t_manager_dictionary AS articleType ON articleType.dic_guid = article.article_type_dic
AND articleType.`enable` = 1
LEFT JOIN t_utility_hot hot ON hot.owner_guid = article.article_guid
AND hot.`enable` = 1
WHERE
article.`enable` = 1
AND article.`actcle_release_status` = 'Release'
AND article.visible = 1 {whereSql}
ORDER BY
LastUpdatedDate DESC" ;
return(await MySqlHelper.QueryByPageAsync <GetClientArticlePageListRequestDto, GetClientArticlePageListResponseDto, GetClientArticlePageListItemDto>(sql, requestDto));
}
public async Task <IActionResult> GetClientArticlePageListAsync([FromBody] GetClientArticlePageListRequestDto requestDto)
{
var response = await new UnionArticleBiz().GetClientArticlePageListAsync(requestDto);
return(Success(response));
}
