public async Task <IActionResult> GetHealthManagerFllowupRecords([FromQuery]
GetHealthManagerFllowupRecordsRequestDto request)
{
var managerBiz = new HealthManagerBiz();
var response = await managerBiz.GetHealthManagerFllowupRecords(request);
return(Success(response));
}
/// <summary>
/// 查询指定会员随访记录分页列表
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <GetHealthManagerFllowupRecordsResponseDto> GetHealthManagerFllowupRecords(GetHealthManagerFllowupRecordsRequestDto requestDto)
{
var sql = @"SELECT
m.user_name,m.phone,f.content,f.suggestion,f.followup_time
FROM t_health_manager_followup_record as f
INNER JOIN t_health_manager as m ON m.manager_guid = f.health_manager_guid
WHERE f.consumer_guid = @ConsumerGuid";
if (!string.IsNullOrEmpty(requestDto.KeyWord))
{
sql = $"{sql} and (m.user_name like '%{requestDto.KeyWord}%' or m.phone like '%{requestDto.KeyWord}%')";
}
if (requestDto.FollowUpTime.HasValue && requestDto.EndTime.HasValue)
{
requestDto.EndTime = requestDto.EndTime.Value.AddDays(1);
sql = $"{sql} and f.followup_time >= @FollowUpTime and f.followup_time < @EndTime";
}
sql = $"{sql} order by f.followup_time desc";
return(await MySqlHelper.QueryByPageAsync <GetHealthManagerFllowupRecordsRequestDto, GetHealthManagerFllowupRecordsResponseDto, GetHealthManagerFllowupRecordsItem>(sql, requestDto));
}
