public async Task <GetMerchantOrderDetailPageResponseDto> GetMerchantOrderDetailPageAsync(GetMerchantOrderDetailPageRequestDto request)
{
var sqlWhere = $@"1=1 and Enable=1";
if (!string.IsNullOrWhiteSpace(request.MerchantGuid))
{
sqlWhere = $"{sqlWhere} AND merchant_guid = @MerchantGuid";
}
if (request.BeginDate != null)
{
request.BeginDate = request.BeginDate?.Date;
sqlWhere = $"{sqlWhere} AND creation_date > @BeginDate";
}
if (request.EndDate != null)
{
request.EndDate = request.EndDate?.AddDays(1).Date;
sqlWhere = $"{sqlWhere} AND creation_date < @EndDate";
}
var sql = $@"
SELECT * FROM(
SELECT
a.*,
b.merchant_guid,
b.category_name,
d.user_Name as UserName,
c.creation_date AS order_date,
c.order_no,
c.user_guid
FROM
t_mall_order_detail a
LEFT JOIN t_mall_product b ON a.product_guid = b.product_guid
LEFT JOIN t_mall_order c ON c.order_guid = a.order_guid
LEFT JOIN t_utility_user d ON c.user_guid = d.user_guid
where c.enable=1
) __t
WHERE
{sqlWhere}
ORDER BY
creation_date desc" ;
return(await MySqlHelper.QueryByPageAsync <GetMerchantOrderDetailPageRequestDto, GetMerchantOrderDetailPageResponseDto, GetMerchantOrderDetailPageItemDto>(sql, request));
}
public async Task <IActionResult> GetMerchantOrderDetailPageAsync([FromBody] GetMerchantOrderDetailPageRequestDto request)
{
var response = await new MerchantBiz().GetMerchantOrderDetailPageAsync(request);
return(Success(response));
}
