public async Task <IActionResult> GetConsumersPageList([FromQuery]
GetConsumerListRequestDto request)
{
var consumerBiz = new ConsumerBiz();
return(Success(await consumerBiz.GetConsumersPageList(request)));
}
public async Task <GetConsumerListResponseDto> GetConsumers(GetConsumerListRequestDto requestDto)
{
var sqlWhere = string.Empty;
if (!string.IsNullOrEmpty(requestDto.KeyWord))
{
sqlWhere = $"AND (u.user_name LIKE '%{requestDto.KeyWord}%' OR u.phone LIKE '%{requestDto.KeyWord}%')";
}
if (requestDto.RegistrationTime.HasValue)
{
requestDto.EndTime = requestDto.RegistrationTime.Value.AddDays(1);
sqlWhere = $"{sqlWhere} and m.creation_date >= @RegistrationTime and m.creation_date < @EndTime";
}
var sql = $@"SELECT
u.user_guid as UserGuid,
u.user_name as `Name`,
u.gender as 'Gender',
u.phone AS Phone,
(
IF(birthday IS NULL, '-', TIMESTAMPDIFF(YEAR, birthday, CURDATE()))
) AS Age,
u.last_updated_date AS UpdatedDate,
m.user_name as ManagerName,
m.manager_guid as ManagerGuid,
m.phone as ManagerPhone,
c.creation_date as CreationDate
FROM t_utility_user as u
inner join t_consumer as c on u.user_guid = c.consumer_guid
left join t_health_manager as m on c.health_manager_guid = m.manager_guid
WHERE u.`enable` = 1 {sqlWhere}
ORDER BY u.last_updated_date DESC";
return(await MySqlHelper.QueryByPageAsync <GetConsumerListRequestDto,
GetConsumerListResponseDto,
GetConsumerItem>(sql, requestDto));
}
