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 frontendmodulescompanymodels;
use Yii;
use commonmodelsuserUserProfile;
use commonmodelscommonCommon;
/**
* UserProfileSearch represents the model behind the search form about `commonmodelsuserUserProfile`.
*/
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]); ?>
就好了
声明:该文观点仅代表作者本人,牛骨文系教育信息发布平台,牛骨文仅提供信息存储空间服务。
- 上一篇: 【原创】PHP扩展开发进阶
- 下一篇: YII2.0框架分页
