public async Task <IActionResult> GetReviewDoctorPageAsync([FromBody] GetReviewDoctorPageRequestDto request)
{
var response = await new DoctorBiz().GetReviewDoctorPageAsync(request);
foreach (var item in response.CurrentPage)
{
if (item.Status == DoctorModel.StatusEnum.Submit.ToString())
{
item.LastUpdatedDate = null;
}
;
}
return(Success(response));
}
/// <summary>
/// 审核医生列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public async Task <GetReviewDoctorPageResponseDto> GetReviewDoctorPageAsync(GetReviewDoctorPageRequestDto request)
{
var sqlWhere = $@"1=1 ";//and enable=1
if (!string.IsNullOrWhiteSpace(request.Name))
{
sqlWhere = $"{sqlWhere} AND user_name like @Name";
}
if (!string.IsNullOrWhiteSpace(request.Status))
{
sqlWhere = $"{sqlWhere} AND status = @Status";
}
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.*,
CONCAT( B.base_path, B.relative_path ) AS PortraitUrl,
CONCAT( D.base_path, D.relative_path ) AS signatureUrl,
C.user_name,
C.Gender
FROM
t_doctor A
LEFT JOIN t_utility_accessory B ON B.accessory_guid = A.portrait_guid
LEFT JOIN t_utility_accessory D ON D.accessory_guid = A.signature_guid
LEFT JOIN t_utility_user C ON C.user_guid = A.doctor_guid
) t
WHERE
{sqlWhere}
ORDER BY
creation_date desc" ;
request.Name = $"%{request.Name}%";
return(await MySqlHelper.QueryByPageAsync <GetReviewDoctorPageRequestDto, GetReviewDoctorPageResponseDto, GetReviewDoctorPageItemDto>(sql, request));
}
