yii2 with的回调函数中参数使用
public function userPageList($where,$order="id desc",$cityName=""){
if(!empty($cityName)){
global $cName;//定义
$cName = $cityName;//赋值
$query = User::find()->where($where)->innerJoinWith([
"userInfo"=>function($q){
global $cName;//引用
$q->andWhere(["like","birth_city",$cName]);//使用
}
]);
}else{
$query = User::find()->with("userInfo")->where($where);
}
$pages = new Pagination(["totalCount" =>$query->count(), "pageSize" => PAGE_NUM]);
$data["data"] = $query->offset($pages->offset)
->orderBy($order)
->limit($pages->limit)
->all();
$data["pages"]=$pages;
return $data;
}声明:该文观点仅代表作者本人,牛骨文系教育信息发布平台,牛骨文仅提供信息存储空间服务。
