public static function getMessagesByTypeUserId($users_id, $type) { $countSql = "SELECT count(mu.id) as count FROM " . self::tableName() . " mu LEFT JOIN " . Messages::tableName() . " m ON mu.messages_id = m.id WHERE mu.users_id=:users_id AND mu.type=:type"; $sql = "SELECT mu.id,m.title,m.create_time,m.create_user,m.type,mu.users_id,mu.status,m.content FROM " . self::tableName() . " mu LEFT JOIN " . Messages::tableName() . " m ON mu.messages_id = m.id WHERE mu.users_id=:users_id AND mu.type=:type"; $count = Yii::$app->db->createCommand($countSql, [':users_id' => $users_id, ':type' => $type])->queryScalar(); $pages = new Pagination(['totalCount' => $count, 'pageSize' => '20']); $models = Yii::$app->db->createCommand($sql . " limit " . $pages->limit . " offset " . $pages->offset . "", [':users_id' => $users_id, ':type' => $type])->queryAll(); return ['models' => $models, 'pages' => $pages]; }