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]); ?>
就好了