public async Task <IActionResult> GetCompletedConsumptionPageListAsync([FromBody] GetCompletedConsumptionPageListRequestDto requestDto)
{
if (string.IsNullOrWhiteSpace(requestDto.ConsumerGuid))
{
requestDto.ConsumerGuid = UserID;
}
var response = await new ConsumptionBiz().GetCompletedConsumptionPageListAsync(requestDto);
return(Success(response));
}
/// <summary>
/// 获取已完成的消费记录分页列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetCompletedConsumptionPageListResponseDto> GetCompletedConsumptionPageListAsync(GetCompletedConsumptionPageListRequestDto requestDto)
{
var sql = @"SELECT
a.consumption_guid,
a.project_guid,
b.project_name,
CONCAT( acc.base_path, acc.relative_path ) AS project_picture,
merchant.merchant_name,
a.consumption_date,
a.comment_guid,
merchant.merchant_address,
mt.therapist_guid,
mt.therapist_name,
CASE
WHEN ISNULL( comment_guid ) THEN
FALSE ELSE TRUE
END AS is_comment
FROM
t_consumer_consumption a
INNER JOIN t_mall_project b ON a.project_guid = b.project_guid
LEFT JOIN t_utility_accessory acc ON acc.accessory_guid = b.picture_guid
LEFT JOIN t_merchant merchant ON merchant.merchant_guid = a.merchant_guid
left join t_merchant_therapist as mt on a.operator_guid=mt.therapist_guid
WHERE
consumption_status = 'Completed'
AND user_guid = @ConsumerGuid
ORDER BY
is_comment,
consumption_date DESC " ;
return(await MySqlHelper.QueryByPageAsync <GetCompletedConsumptionPageListRequestDto, GetCompletedConsumptionPageListResponseDto, GetCompletedConsumptionPageListItemDto>(sql, requestDto));
}
