request->isAjax) { $query = Admin::find(); $data = []; $params = Yii::$app->request->get('Admin',[]); $query = mergeParams($query,$params); $countQuery = clone $query; //分页 if(isset($_GET['limit'])){ $query->limit(intval($_GET['limit']));} if(isset($_GET['offset'])){ $query->offset(intval($_GET['offset']));} //排序 if(isset($_GET['sort'])&&isset($_GET['sortOrder'])) { $sortWay = $_GET['sortOrder']=='asc'?SORT_ASC:SORT_DESC; $resultList = $query->orderBy([$_GET['sort']=>$sortWay])->all(); } else { $resultList = $query->all(); } foreach($resultList as $result) { $data[] = array('admin_id'=>$result->admin_id,'user_name'=>$result->user_name,'real_name'=>$result->real_name,'avatar'=>getFileUrl($result->avatar),'role_id'=>Admin::roleOptions($result->role_id),'disabled'=>$result->disabled); } $result = ["total"=>$countQuery->count(),"totalNotFiltered"=>$countQuery->count(),"rows"=>$data]; echo_json($result); } $this->tableTitle = array( array('field'=>'admin_id','title'=>Admin::getAttributeName('admin_id'),'align'=>'center','sortable'=>true,'class'=>'col-md-2'), array('field'=>'real_name','title'=>Admin::getAttributeName('real_name'),'align'=>'center','class'=>'col-md-2'), array('field'=>'role_id','title'=>Admin::getAttributeName('role_id'),'align'=>'center','class'=>'col-md-2'), array('field'=>'disabled','title'=>Admin::getAttributeName('disabled'),'align'=>'center','formatter'=>'switchFormatter','class'=>'col-md-2'), array('field'=>'operate','title'=>Admin::getAttributeName('operate'),'align'=>'center','events'=>'window.operateEvents','formatter'=>'operateFormatter','class'=>'col-md-2'), ); $this->tableConfig = array('table'=>Admin::shortTableName(),'url'=>$this->createRealUrl(['admin/admin/list']),'setFieldUrl'=>$this->createRealUrl(['admin/admin/setfield']),'idField'=>Admin::modelPrimaryKey(),'checkbox'=>0,'dropmenu'=>1,'pagination'=>true,'pagesize'=>20,'refresh'=>true); return $this->render('list',array('model'=>new Admin())); } function actionAdd() { $model = new Admin(['scenario' => 'add']); if(Yii::$app->request->isAjax&&$model->load(Yii::$app->request->post())){ $exist = Admin::find()->where("user_name='".$model->user_name."'")->exists(); if($exist) { $msgdata = ['error' => 1,'msg' => '已存在该账号,添加失败']; echo_json($msgdata); } $password = password($model->user_pwd); $model->encrypt = $password['encrypt']; if(!$model->validate()) { $msgdata = ['error' => 1,'msg' => $model->returnFirstError()]; } else { $model->user_pwd = $password['password']; if($model->save(false)) { $msgdata = ['error' => 0,'msg' => '操作成功']; } else { $msgdata = ['error' => 1,'msg' => $model->returnFirstError()]; } } echo_json($msgdata); } return $this->renderAjax('add',array('model'=>$model)); } function actionEdit() { $admin_id = $this->getKeyId('admin_id'); $model = Admin::findOne($admin_id); $model->setScenario('edit'); $old_pwd = $model->user_pwd; check_record_exists($model); if(Yii::$app->request->isAjax&&$model->load(Yii::$app->request->post())){ if(!$model->validate()) { $msgdata = ['error' => 1,'msg' => $model->returnFirstError()]; } else { if(empty($model->user_pwd)) { $model->user_pwd = $old_pwd; } else { $password = password($model->user_pwd); $model->encrypt = $password['encrypt']; $model->user_pwd = $password['password']; } if($model->save(false)) { $msgdata = ['error' => 0,'msg' => '操作成功']; } else { $msgdata = ['error' => 1,'msg' => '操作失败']; } } echo_json($msgdata); } $model->user_pwd = ''; return $this->renderAjax('edit',array('model'=>$model)); } //删除 public function actionDel() { $admin_id = $this->getKeyId('admin_id'); $model = Admin::findOne($admin_id); check_record_exists($model); if($model->delete()) { $msgdata = ['error' => 0,'msg' => '操作成功!']; } else { $msgdata = ['error' => 1,'msg' => '操作失败!']; } echo_json($msgdata); } }