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(); }