public function initParam() { $param = \fec\helpers\CRequest::param(); if (empty($param['pageNum'])) { $param['pageNum'] = $this->_pageNum; } if (empty($param['numPerPage'])) { $param['numPerPage'] = $this->_numPerPage; } if (empty($param['orderField'])) { $param['orderField'] = $this->_orderField; } if (empty($param['orderField'])) { $param['orderField'] = $this->_paramKey; } if (empty($param['orderDirection'])) { $param['orderDirection'] = $this->_sortDirection; } $this->_param = $param; $this->_currentUrl = CUrl::getCurrentUrlNoParam(); $this->_currentParamUrl = CUrl::getCurrentUrl(); $this->_addUrl = $this->_addUrl ? $this->_addUrl : $this->_currentUrl; $this->_editUrl = $this->_editUrl ? $this->_editUrl : $this->_currentUrl; $this->_deleteUrl = $this->_deleteUrl ? $this->_deleteUrl : $this->_currentUrl; }
public function getLastData() { $updatepass = CRequest::param("updatepass"); if ($updatepass) { if (\Yii::$app->user->identity->username == "admin") { #如果是demo,则不允许修改密码。 if (CConfig::param("is_demo")) { echo json_encode(["statusCode" => "300", "message" => "demo是为了让大家看,admin账户不允许修改密码,请自己添加账户"]); exit; } } $AdminUserResetPassword = new AdminUserResetPassword(); $AdminUserResetPassword->attributes = $updatepass; if ($AdminUserResetPassword->validate()) { $AdminUserResetPassword->updatePassword(); echo json_encode(["statusCode" => "200", "message" => 'Update Password Success']); } else { $errors = $AdminUserResetPassword->errors; echo json_encode(["statusCode" => "300", "message" => CModel::getErrorStr($errors)]); } exit; } $adminUser = \Yii::$app->user->identity; $current_account = $adminUser->username; $editUrl = CUrl::getUrl("fecadmin/myaccount/index"); return ['current_account' => $current_account, 'editUrl' => $editUrl]; }
public function actionIndex() { if (CRequest::param("method") == 'reflush') { $this->getBlock()->reflush(); } $data = $this->getBlock()->getLastData(); return $this->render($this->action->id, $data); }
public function getLastData() { $updatepass = CRequest::param("updatepass"); if ($updatepass) { $AdminUserResetPassword = new AdminUserResetPassword(); $AdminUserResetPassword->attributes = $updatepass; if ($AdminUserResetPassword->validate()) { $AdminUserResetPassword->updatePassword(); echo json_encode(["statusCode" => "200", "message" => 'Update Password Success']); } else { $errors = $AdminUserResetPassword->errors; echo json_encode(["statusCode" => "300", "message" => CModel::getErrorStr($errors)]); } exit; } $adminUser = \Yii::$app->user->identity; $current_account = $adminUser->username; $editUrl = CUrl::getUrl("fecadmin/account/index"); return ['current_account' => $current_account, 'editUrl' => $editUrl]; }
public function actionIndex() { $isGuest = Yii::$app->user->isGuest; //echo $isGuest;exit; if (!$isGuest) { $this->redirect("/", 200); } $errors = ''; $loginParam = \fec\helpers\CRequest::param('login'); if ($loginParam) { //echo 1;exit; $AdminUserLogin = new AdminUserLogin(); $AdminUserLogin->attributes = $loginParam; if ($AdminUserLogin->login()) { $this->redirect("/", 200); } else { $errors = CModel::getErrorStr($AdminUserLogin->errors); } } $this->layout = "login.php"; return $this->render('index', ['error' => $errors]); }
public function delete() { //$request_param = CRequest::param(); //$this->_param = $request_param; //$this->initParam(); if ($role_id = CRequest::param($this->_paramKey)) { $model = AdminRole::findOne([$this->_paramKey => $role_id]); if ($model->role_id) { $innerTransaction = Yii::$app->db->beginTransaction(); try { $model->delete(); # 删除这个role 对应的所有关联的菜单 AdminRoleMenu::deleteAll(['role_id' => $role_id]); $innerTransaction->commit(); } catch (Exception $e) { $innerTransaction->rollBack(); } echo json_encode(["statusCode" => "200", "message" => 'Delete Success!']); exit; } else { echo json_encode(["statusCode" => "300", "message" => "role_id => {$role_id} , is not exist"]); exit; } } else { if ($ids = CRequest::param($this->_paramKey . 's')) { $id_arr = explode(",", $ids); $innerTransaction = Yii::$app->db->beginTransaction(); try { AdminRole::deleteAll(['in', 'role_id', $id_arr]); # 删除这个role 对应的所有关联的菜单 AdminRoleMenu::deleteAll(['in', 'role_id', $id_arr]); $innerTransaction->commit(); } catch (Exception $e) { $innerTransaction->rollBack(); } echo json_encode(["statusCode" => "200", "message" => "{$ids} Delete Success!"]); exit; } } echo json_encode(["statusCode" => "300", "message" => "role_id or ids Param is not Exist!"]); exit; }
public function reflush() { $cacheStr = CRequest::param("ids"); $cacheArr = explode(",", $cacheStr); foreach ($cacheArr as $cacheType) { $cacheType = trim($cacheType); if ($cacheType == all_cache) { CCache::flushAll(); } } echo json_encode(array("statusCode" => "200", "message" => "reflush cache success")); exit; }
public function delete() { //$request_param = CRequest::param(); //$this->_param = $request_param; //$this->initParam(); # admin 用户不能删除 if ($id = CRequest::param('id')) { $model = AdminConfig::findOne(['id' => $id]); if ($model->id) { $model->delete(); echo json_encode(["statusCode" => "200", "message" => 'Delete Success!']); exit; } else { echo json_encode(["statusCode" => "300", "message" => "id => {$id} , is not exist"]); exit; } } else { if ($ids = CRequest::param('ids')) { $id_arr = explode(",", $ids); AdminConfig::deleteAll(['in', 'id', $id_arr]); echo json_encode(["statusCode" => "200", "message" => "{$ids} Delete Success!"]); exit; } } echo json_encode(["statusCode" => "300", "message" => "id or ids Param is not Exist!"]); exit; }
public function delete() { //$request_param = CRequest::param(); //$this->_param = $request_param; //$this->initParam(); # admin 用户不能删除 if ($id = CRequest::param('id')) { $model = AdminUserForm::findOne(['id' => $id]); if ($model->id) { # 不允许删除admin if ($model->username == 'admin') { echo json_encode(["statusCode" => "300", "message" => 'You can not delete Admin User!']); exit; } $innerTransaction = Yii::$app->db->beginTransaction(); try { $model->delete(); AdminUserRole::deleteAll(['user_id' => $model->id]); $innerTransaction->commit(); } catch (Exception $e) { $innerTransaction->rollBack(); echo json_encode(["statusCode" => "300", "message" => 'Delete Fail !']); exit; } echo json_encode(["statusCode" => "200", "message" => 'Delete Success!']); exit; } else { echo json_encode(["statusCode" => "300", "message" => "id => {$id} , is not exist"]); exit; } } else { if ($ids = CRequest::param('ids')) { $id_arr = explode(",", $ids); # 不允许删除admin $adminUser = AdminUserForm::findOne(['username' => 'admin']); $adminUserId = $adminUser->id; if (in_array($adminUserId, $id_arr)) { echo json_encode(["statusCode" => "300", "message" => 'You can not delete Admin User!']); exit; } $innerTransaction = Yii::$app->db->beginTransaction(); try { AdminUserForm::deleteAll(['in', 'id', $id_arr]); AdminUserRole::deleteAll(['in', 'user_id', $id_arr]); $innerTransaction->commit(); } catch (Exception $e) { $innerTransaction->rollBack(); echo json_encode(["statusCode" => "300", "message" => 'Delete All Fail !']); exit; } echo json_encode(["statusCode" => "200", "message" => "{$ids} Delete Success!"]); exit; } } echo json_encode(["statusCode" => "300", "message" => "id or ids Param is not Exist!"]); exit; }
public function deleteMenu() { $id = CRequest::param("id"); if (!$id) { echo json_encode(["statusCode" => "300", "message" => "id can not empty"]); exit; } else { $one = AdminMenu::find()->where(" id = " . $id . " AND can_delete = 2 ")->one(); //echo $one->id; if ($one->id) { $ids = $this->getMenuAllChildId($id); $ids[] = $id; # 1. 删除当前分类对应的所有子分类 # 2. 删除在menu_id 对应到权限中的所有menu_id $innerTransaction = Yii::$app->db->beginTransaction(); try { AdminRoleMenu::deleteAll(['in', 'menu_id', $ids]); $idsStr = implode(",", $ids); $one->deleteAll(" id in (" . $idsStr . ") AND can_delete = 2"); $innerTransaction->commit(); echo json_encode(["statusCode" => "200", "message" => "delete menu success! MENU NAME:" . $one->name]); } catch (Exception $e) { $innerTransaction->rollBack(); } exit; } else { echo json_encode(["statusCode" => "300", "message" => "the menu can not delete"]); exit; } } }
public function delete() { //$request_param = CRequest::param(); //$this->_param = $request_param; //$this->initParam(); # admin 用户不能删除 if ($id = CRequest::param('id')) { $model = AdminUserForm::findOne(['id' => $id]); if ($model->id) { # 不允许删除admin if ($model->username == 'admin') { echo json_encode(["statusCode" => "300", "message" => 'You can not delete Admin User!']); exit; } $model->delete(); echo json_encode(["statusCode" => "200", "message" => 'Delete Success!']); exit; } else { echo json_encode(["statusCode" => "300", "message" => "id => {$id} , is not exist"]); exit; } } else { if ($ids = CRequest::param('ids')) { $id_arr = explode(",", $ids); # 不允许删除admin $adminUser = AdminUserForm::findOne(['username' => 'admin']); $adminUserId = $adminUser->id; if (in_array($adminUserId, $id_arr)) { echo json_encode(["statusCode" => "300", "message" => 'You can not delete Admin User!']); exit; } AdminUserForm::deleteAll(['in', 'id', $id_arr]); echo json_encode(["statusCode" => "200", "message" => "{$ids} Delete Success!"]); exit; } } echo json_encode(["statusCode" => "300", "message" => "id or ids Param is not Exist!"]); exit; }
public function getTableTbody() { $obj = $this->_obj; //$searchArr = $this->getSearchArr(); //$query = $obj::find(); //if(is_array($searchArr) && !empty($searchArr)){ // $this->initDateWhere($query,$searchArr); //} //$this->_param['numCount'] = $query->count(); //$query->limit = $this->_param['numPerPage']; # 偏离值 //$query->offset = ($this->_param['pageNum'] -1)*$this->_param['numPerPage'] ; //$query->orderBy([$this->_param['orderField']=> (($this->_param['orderDirection'] == 'desc') ? SORT_DESC : SORT_ASC)]); //$data = $query->all(); $offset = ($this->_param['pageNum'] - 1) * $this->_param['numPerPage']; $limit = $this->_param['numPerPage']; $limit = " limit {$offset} , {$limit} "; $group = " account "; $account = CRequest::param('account'); $person = CRequest::param('person'); $tj_type = CRequest::param('tj_type'); $created_at_lt = $this->_param['created_at_lt']; $created_at_gte = $this->_param['created_at_gte']; $where = []; if ($account) { $where[] = " account = '{$account}' "; } if ($person) { $where[] = " person = '{$person}' "; } if ($tj_type == '账号登录') { $where[] = " menu = '账号登录' "; $group .= " ,menu "; } if ($created_at_lt) { $where[] = " created_at < '{$created_at_lt}' "; } if ($created_at_gte) { $where[] = " created_at >= '{$created_at_gte}' "; } if (!empty($where)) { $where = ' where ' . implode(' and ', $where); } else { $where = ''; } $table = $obj::tableName(); $db = \Yii::$app->db; # 得到 总数。 $sql = "select count(*) as count from (select account,person,menu ,count(*) as click_count \r\n\t\tfrom {$table} {$where} group by {$group} ) as t "; $data_count = $db->createCommand($sql, [])->queryOne(); $this->_param['numCount'] = $data_count['count']; # 得到数据 $sql = "select account,person,menu ,count(*) as click_count \r\n\t\tfrom {$table} {$where} group by {$group} order by click_count DESC {$limit} "; $data = $db->createCommand($sql, [])->queryAll(); return $this->getTableTbodyHtml($data); }