YII2 列表( 不用自带的gridview) 分页+搜索

Controller

public function actionIndex()
    {
        $data = UserProfileSearch::search(Yii::$app->request->get());
        //print_r($data->count());exit;
        $pages = new Pagination(['totalCount' =>$data->count()]);
        $model = $data->offset($pages->offset)->limit($pages->limit)->all();

        return $this->render('index',compact('model','pages'));

    }

UserProfileSearch.php
<?php

namespace frontend\modules\company\models;

use Yii;
use common\models\user\UserProfile;
use common\models\common\Common;


/**
 * UserProfileSearch represents the model behind the search form about `common\models\user\UserProfile`.
 */
class UserProfileSearch
{
    public static function search($params)
    {
        $query = UserProfile::find()
                ->select('i3a_user_profile.user_id,i3a_user_profile.fullname,i3a_user_profile.email,i3a_user_profile.position,i3a_user_profile.department_id,i3a_user.mobile,i3a_user.logged_at,i3a_user.created_at,i3a_user.status')
                ->joinWith('user','user_profile.user_id=user.id')
                //->joinWith('companyuserdepartment','user_profile.user_id=companyuserdepartment.user_id')
                ->andFilterWhere(['i3a_user.company_id'=>Yii::$app->user->identity->company_id]);
        if(isset($params['user_id'])){
            $query->andFilterWhere(['i3a_user_profile.user_id'=>$params['user_id']]);
        }
        if(isset($params['nickname']) && $nickname = Common::POST_CHECK($params['nickname'])){
            $query->andFilterWhere(['like', 'i3a_user_profile.fullname', $nickname]);
        }

        return $query;
    }

} 

View

然后循环数据

再加上

<?= LinkPager::widget(['pagination' => $pages]); ?>

就好了

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值