在 yii2 中使用数组进行分页


Pagination with array in yii2

我想在我的视图中使用分页,但我无法弄清楚如何与find()方法结合使用。

获取页数可以正常工作,但它始终显示数据库中的所有值。我想看到每页 15 条评论。

这是我的ViewAction控制器:

 public function actionView($id) {
     $query = UrComment::find()->where(['IsDeleted' => 0]);
     $pagination = new Pagination(['totalCount' => $query->count(), 'pageSize'=>12]);
     return $this->render('view', [
            'model' => $this->findOneModel($id),
            'comment' => UrComment::findComment($id),
            'pagination'=> $pagination
     ]);
}

这就是我获得评论的方式:

public static function findComment($id)
{
    if (($model = UrUser::findOne($id)) !== null) {
        $Id=$model->Id;
        $comment = UrComment::find()->where(['Rel_User' => $Id])->all();
        return $comment;
    } else {
        throw new NotFoundHttpException('The requested page does not exist.');
    }
}

我尝试使用它:

public function actionView($id) {
    $query = UrComment::find()->where(['IsDeleted' => 0]);
    $pagination = new Pagination(['totalCount' => $query->count(), 'pageSize'=>12]);
    $comment= UrComment::findComment($id);
    $comment->offset($pagination->offset)
        ->limit($pagination->limit)
        ->all();
    return $this->render('view', [
                'model' => $this->findOneModel($id),
                'comment' =>$comment,
                'pagination'=> $pagination
    ]);
}

但是我收到此错误:

调用数组上的成员函数 offset()

然后我在视图中显示它:

<?php
use yii'helpers'Html;
use yii'widgets'DetailView;
use yii'helpers'Url;
/* @var $this yii'web'View */
/* @var $model backend'modules'users'models'UrUser */
$this->title = $model->Name;
$this->params['breadcrumbs'][] = ['label' => Yii::t('app', 'Użytkownicy'), 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="ur-user-view">
    <h1><?= Html::encode($this->title) ?></h1>
    <p>
        <?= Html::a(Yii::t('app', 'Aktualizuj'), ['update', 'id' => $model->Id], ['class' => 'btn btn-primary']) ?>
        <?=
        Html::a(Yii::t('app', 'Usuń'), ['delete', 'id' => $model->Id], [
            'class' => 'btn btn-danger',
            'data' => [
                'confirm' => Yii::t('app', 'Jesteś pewien, że chesz usunąć tego użytkownika?'),
                'method' => 'post',
            ],
        ])
        ?>
    </p>
    <?=
    DetailView::widget([
        'model' => $model,
        'attributes' => [
            'Id',
            'Name',
            'Surname',
            'BirthDate',
            'Login',
            'Email:email',
            ['attribute' => 'Rel_Sex', 'value' => (isset($model->relSex->Name)? $model->relSex->Name : "Nie wybrano")],
            ['attribute' => 'Rel_Language', 'value' => (isset($model->relLanguage->Name)) ? $model->relLanguage->Name : "Nie wybrano"],
            ['attribute' => 'Rel_Country', 'value' => (isset($model->relCountry->Name)) ? $model->relCountry->Name : "Nie wybrano"],
            ['attribute' => 'Rel_Category', 'value' => (isset($model->relUserCategory->Name)) ? $model->relUserCategory->Name : "Nie wybrano"],
        ],
    ])
    ?>
Komentarze użytkownika: <?= $model->Name.' '.$model->Surname;?><br><br>

    <?php foreach ($comment as $comm): ?>
     <?= Html::a(Yii::t('app', 'Edytuj'), ['update-user-comment', 'id' => $comm->Id], ['class' => 'btn btn-primary']) ?>
        <?=
        Html::a(Yii::t('app', 'Usuń'), ['delete-comment', 'id' => $comm->Id], [
            'class' => 'btn btn-danger',
            'data' => [
                'confirm' => Yii::t('app', 'Jesteś pewien, że chesz usunąć tego użytkownika?'),
                'method' => 'post',
            ],
        ])
        ?>
            <p><?= $comm->Text ?></p>
    <hr>
    <?php endforeach; ?>
<?php
   echo 'yii'widgets'LinkPager::widget([
    'pagination' => $pagination,
]);
?>
</div>
</div>    
</div>

如何使用分页限制UrComment::findComment($id)

编辑:

我想我

理解你,我想我已经完成了你在回答中告诉我的一切,但现在我有另一个问题。我需要仅在视图下显示评论,即 id 仅查看此人而不是所有评论。

这是我现在拥有的:

动作视图:

public function actionView($id) {
    $searchModel = new CommentSearch();
    $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
    $dataProvider->query->andWhere(['IsDeleted' => 0]);
    $dataProvider->pagination->pageSize=15;
    return $this->render('view', [
                'model' => $this->findOneModel($id),
                'comment' => UrComment::findComment($id),
                'searchModel' => $searchModel,
                'dataProvider' => $dataProvider,
    ]);
}

评论搜索:

<?php
namespace backend'modules'users'models;
use Yii;
use yii'base'Model;
use yii'data'ActiveDataProvider;
use common'models'UrComment;
class CommentSearch extends UrComment
{        
    public function rules() {
        return [
            [['Id'], 'integer'],
            [['Text'], 'safe'],           
        ];
    }
    public function scenarios() {
        // bypass scenarios() implementation in the parent class
        return Model::scenarios();
    }
    public function search($params) {
        $query = UrComment::find();
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);
        $this->load($params);
        if (!$this->validate()) {
            // uncomment the following line if you do not want to return any records when validation fails
            // $query->where('0=1');
            return $dataProvider;
        }
        $query->andFilterWhere([
            'Id' => $this->Id,
            'Text' => $this->Text,                
        ]);
        $query->andFilterWhere(['like', 'Text', $this->Text]);
        return $dataProvider;
    }
}

视图:

<?php
use yii'helpers'Html;
use yii'widgets'DetailView;
use yii'helpers'Url;
use yii'widgets'ListView;
/* @var $this yii'web'View */
/* @var $model backend'modules'users'models'UrUser */
$this->title = $model->Name;
$this->params['breadcrumbs'][] = ['label' => Yii::t('app', 'Użytkownicy'), 'url' => ['index']];
$this->params['breadcrumbs'][] = $this->title;
?>
<div class="ur-user-view">
    <h1><?= Html::encode($this->title) ?></h1>
    <p>
        <?= Html::a(Yii::t('app', 'Aktualizuj'), ['update', 'id' => $model->Id], ['class' => 'btn btn-primary']) ?>
        <?=
        Html::a(Yii::t('app', 'Usuń'), ['delete', 'id' => $model->Id], [
            'class' => 'btn btn-danger',
            'data' => [
                'confirm' => Yii::t('app', 'Jesteś pewien, że chesz usunąć tego użytkownika?'),
                'method' => 'post',
            ],
        ])
        ?>
    </p>
    <?=
    DetailView::widget([
        'model' => $model,
        'attributes' => [
            'Id',
            'Name',
            'Surname',
            'BirthDate',
            'Login',
            'Email:email',
            ['attribute' => 'Rel_Sex', 'value' => (isset($model->relSex->Name)? $model->relSex->Name : "Nie wybrano")],
            ['attribute' => 'Rel_Language', 'value' => (isset($model->relLanguage->Name)) ? $model->relLanguage->Name : "Nie wybrano"],
            ['attribute' => 'Rel_Country', 'value' => (isset($model->relCountry->Name)) ? $model->relCountry->Name : "Nie wybrano"],
            ['attribute' => 'Rel_Category', 'value' => (isset($model->relUserCategory->Name)) ? $model->relUserCategory->Name : "Nie wybrano"],
        ],
    ])
    ?>
Komentarze użytkownika: <?= $model->Name.' '.$model->Surname;?><br><br>
<?php    
  echo ListView::widget([
   'dataProvider' => $dataProvider,
   'itemView' => 'comments',
   'viewParams' => ['comment' => $comment, 'model'=>$model],
]);
?>
</div>
</div> 
</div>

我的项目评论:

<?php
use yii'helpers'Html;
use yii'widgets'DetailView;
use yii'helpers'Url;
/* @var $this yii'web'View */
/* @var $model backend'modules'users'models'UrUser */

?> 
     <?= Html::a(Yii::t('app', 'Edytuj'), ['update-user-comment', 'id' => $comment->Id], ['class' => 'btn btn-primary']) ?>
        <?=
        Html::a(Yii::t('app', 'Usuń'), ['delete-comment', 'id' => $comment->Id], [
            'class' => 'btn btn-danger',
            'data' => [
                'confirm' => Yii::t('app', 'Jesteś pewien, że chesz usunąć tego użytkownika?'),
                'method' => 'post',
            ],
        ])
        ?>
            <p><?= $comment->Text ?></p>
    <hr>

使用该代码,现在我在按钮编辑的这个项目中出现错误:

$comment->Id], ['class' => 'btn btn-primary']) ?>

尝试获取非对象的属性

而且我不能在那里使用 foreach,因为我有重复的评论。应该在评论搜索或我的函数中更改某些内容findComment(id)查询?

有我的实际项目"评论",我想在其中显示评论文本和按钮以编辑和删除评论。但这对我不起作用。我有:

使用未定义的常量 Id - 假定为"Id"

使用未定义的常量文本 - 假定为"文本";

<?php
use yii'helpers'Html;
use yii'widgets'DetailView;
use yii'helpers'Url;
/* @var $this yii'web'View */
/* @var $model backend'modules'users'models'UrUser */

?> 
     <?= Html::a(Yii::t('app', 'Edytuj'), ['update-user-comment', 'id' => Id], ['class' => 'btn btn-primary']) ?>
        <?=
        Html::a(Yii::t('app', 'Usuń'), ['delete-comment', 'id' => Id], [
            'class' => 'btn btn-danger',
            'data' => [
                'confirm' => Yii::t('app', 'Jesteś pewien, że chesz usunąć tego użytkownika?'),
                'method' => 'post',
            ],
        ])
        ?>
            <p><?= Text ?></p>
    <hr>

如果你使用模型和foreach并不容易,请使用分页,因为分页如果基于dataProvider而不是直接用于模型..

本质上,像您一样查找模型意味着在数据上工作,而分页不直接对数据起作用,而是使用 sql 查询从数据库检索信息,让这些信息可用于小部件.. 这就是 dataProvider 执行的 .. ..那么我建议您使用像ListView这样的小部件,并根据基于模型搜索的dataProvider的查找来更改查询。

public function actionView($id) {
    $searchModel = new UrCommentSearch();
    $dataProvider = $searchModel->search(Yii::$app->request->queryParams);
    $dataProvider->query->andWhere(['IsDeleted' => 0]);
    $dataProvider->pagination->pageSize=15;
    return $this->render('view', [
        'model' => $this->findOneModel($id),
        'searchModel' => $searchModel,
        'dataProvider' => $dataProvider,
    ]);

和视图.php

<?php 
echo ' <h1>User :  ' .  $model->userName . '</h1>';
echo '<h2>Comments</h2'>,
echo ListView::widget([
   'dataProvider' => $dataProvider,
   'itemView' => '_comment',
]);

其中_comment是您评论布局的部分视图.,。

那么在_comment.php你可以简单地

<?=$model->id;?> 
<?=$model->text;?>