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);
}
