public async Task <IActionResult> GetHealthQuestionnairePageListAsync([FromQuery] GetHealthQuestionnairePageListRequestDto requestDto)
{
string userId = UserID;
if (!string.IsNullOrWhiteSpace(requestDto.UserId))
{
userId = requestDto.UserId;
}
var response = await new QuestionnaireResultBiz().GetHealthQuestionnaireListAsync(requestDto, userId);
return(Success(response));
}
/// <summary>
/// 获取用户问卷列表
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public async Task <GetHealthQuestionnairePageListResponseDto> GetHealthQuestionnaireListAsync(GetHealthQuestionnairePageListRequestDto requestDto, string userId)
{
string sqlWhere = string.Empty;
if (!requestDto.FillStatus)
{
sqlWhere = $" and (b.fill_status={requestDto.FillStatus} or b.fill_status is null) ";
}
else
{
sqlWhere = $" and (b.fill_status={requestDto.FillStatus} ) ";
}
var sql = $@"SELECT
a.questionnaire_guid,
b.result_guid,
a.questionnaire_name,
a.subhead,
a.has_depend,
b.fill_status,
b.commented,
b.`comment`,
d.questioncount,
d.useranswercount
FROM
t_questionnaire a
LEFT JOIN t_questionnaire_result b ON a.questionnaire_guid = b.questionnaire_guid AND b.user_guid ='{userId}' and b.`enable` = 1
LEFT JOIN t_consumer_questionnaire_hide c on c.questionnaire_guid=a.questionnaire_guid AND c.user_guid ='{userId}'
LEFT JOIN (
SELECT
o.questionnaire_guid,
o.questioncount,
m.useranswercount
FROM
(
SELECT
f.questionnaire_guid,
count( 1 ) questioncount
FROM
t_questionnaire_question f
INNER JOIN t_questionnaire g ON f.questionnaire_guid = g.questionnaire_guid
WHERE
g.has_depend = FALSE
GROUP BY
f.questionnaire_guid
) o
LEFT JOIN (
SELECT
questionnaire_guid,
count( 1 ) useranswercount
FROM
t_questionnaire_result j
LEFT JOIN t_questionnaire_result_detail h ON j.result_guid = h.result_guid
WHERE
j.user_guid = '{userId}' and h.`enable` = 1
GROUP BY
j.questionnaire_guid
) m ON o.questionnaire_guid = m.questionnaire_guid
) d ON d.questionnaire_guid = a.questionnaire_guid
WHERE c.hide_guid is null
AND a.`enable` = 1
AND a.issuing_status=1
AND a.display = 1 {sqlWhere}
ORDER BY a.creation_date desc ";
return(await MySqlHelper.QueryByPageAsync <GetHealthQuestionnairePageListRequestDto, GetHealthQuestionnairePageListResponseDto, GetHealthQuestionnairePageListItemDto>(sql, requestDto));
}
