public static function listByQuestionId($questionId, $limit, $offset, $userId)
{
$sql = <<<sqlStr
SELECT
\tub.user_id, user_nickname, user_cover, user_expert,
\t(SELECT COUNT(*) FROM question_answer_follow WHERE user_id=:uid AND answer_id=qa.answer_id) user_is_follow,
\tanswer_id, answer_content, answer_pics,
\tanswer_follows answer_best,
\tanswer_follows follow_num,
\tanswer_addtime addtime
FROM question_answer as qa
LEFT JOIN user_base as ub ON qa.user_id = ub.user_id
WHERE answer_state > 0 AND question_id = :qid
ORDER BY user_expert DESC , addtime desc
LIMIT {$limit} OFFSET {$offset};
sqlStr;
$model = new self();
return new ResultSet(null, $model, $model->getReadConnection()->query($sql, ['qid' => $questionId, 'uid' => $userId]));
}
/**
* 区县
* @param string $province 省份名称
* @param string $city 市名称
* @return array
*/
public static function getDistrict($province, $city)
{
$sql = 'SELECT A_NM value, K_ID id FROM sys_area_zip_district_phonecode WHERE P_NM = :province AND C_NM = :city ORDER BY K_ID ASC';
$model = new self();
return $model->getReadConnection()->query($sql, ['province' => $province, 'city' => $city])->fetchAll();
}
