public function actionList() { $page = isset($_GET['page']) ? intval($_GET['page']) : 1; $list = array(); $criteria = new CDbCriteria(array('order' => 'id ASC')); $request = Yii::app()->getRequest(); $id = trim($request->getParam("id")); if ($id) { $criteria->addCondition("id = {$id}"); } $domains = new Domain(); $count = $domains->count($criteria); $pager = new CPagination($count); $pager->pageSize = Yii::app()->params['postsPerPage']; $pager->setCurrentPage($page - 1); $pager->applyLimit($criteria); $list = $domains->findAll($criteria); $this->render('list', array('r' => Yii::app()->request->baseUrl . '/', 'pages' => $pager, 'list' => $list)); }
function process_page($app, $action, &$var) { $var['domain_count'] = Domain::count(); $var['user_count'] = User::count(); $var['domains'] = Domain::list_all(); // perform requested actions switch ($app->action) { case 'edit_domain': $var['domain_name'] = Domain::list_by_id($var['domain_id'])->get_name(); break; case 'insert_new_domain': $domain = new Domain(); $domain->set_name($var['domain_name']); if ($domain->insert()) { $app->reload(); } else { $app->action = 'new_domain'; } break; case 'update_edit_domain': $domain = Domain::list_by_id($var['domain_id']); $domain->set_name($var['domain_name']); if ($domain->update()) { $app->reload(); } else { $app->action = 'edit_domain'; } break; case 'delete_domain': $domain = Domain::list_by_id($var['domain_id']); if ($domain->delete()) { $app->reload(); } break; } }
<?php include __DIR__ . '/../start.php'; use Illuminate\Database\Capsule\Manager as DB; $total = Domain::count(); $totalCompleted = Domain::where('status', 'finished')->count(); $page = isset($_GET['page']) == true ? $_GET['page'] : 1; $perPage = 100; $totalPages = floor($total / $perPage); $sortBy = isset($_GET['sortBy']) == true ? $_GET['sortBy'] : 'tf'; $sortType = isset($_GET['sortType']) == true ? $_GET['sortType'] : 'desc'; $domains = Domain::take($perPage)->skip($perPage * ($page - 1))->orderBy($sortBy, $sortType)->get(); $newSortType = $sortType == 'desc' ? 'asc' : 'desc'; ?> <!DOCTYPE html> <html> <head> <title>Domain Metrics Checker</title> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap-theme.min.css"> <link rel="stylesheet" href="assets/style.css"> </head> <body> <?php include __DIR__ . '/menu.php'; ?> <div class='container'> <div class='clearfix'> <h2 class='pull-left'>Total <?php echo _e($total);
function process_page($app, $action, &$var) { $var['domain_count'] = Domain::count(); $var['user_count'] = User::count(); $var['domains'] = Domain::list_all(); if (!isset($var['domain_id'])) { if (isset($_COOKIE['app/users/domain_id'])) { $var['domain_id'] = filter_var($_COOKIE['app/users/domain_id'], FILTER_SANITIZE_STRING); if (Domain::list_by_id($var['domain_id']) == null) { $var['domain_id'] = 0; } } else { $var['domain_id'] = 0; } } if ($var['domain_id'] != 0) { $var['users'] = User::list_by_domain_id($var['domain_id']); $var['active_domain'] = Domain::list_by_id($var['domain_id']); } else { $var['users'] = User::list_all(); } switch ($app->action) { case 'select_domain': setcookie('app/users/domain_id', $var['domain_id']); $app->reload(); break; case 'edit_user': $user = User::list_by_id($var['user_id']); $var['user_email'] = $user->get_email(); $var['user_password'] = ''; if ($user->is_admin()) { $var['user_admin'] = 'on'; } else { unset($var['user_admin']); } break; case 'insert_new_user': $user = new User(); $user->set_email($var['user_email']); $user->set_password($var['user_password']); $user->set_domain_id($var['domain_id']); $user->set_admin(isset($var['user_admin'])); if ($user->insert()) { $app->reload(); } else { $app->action = 'new_user'; } break; case 'update_edit_user': $user = User::list_by_id($var['user_id']); $user->set_email($var['user_email']); $user->set_password($var['user_password']); $user->set_admin(isset($var['user_admin'])); if ($user->update()) { $app->reload(); } else { $app->action = 'edit_user'; } break; case 'delete_user': $user = User::list_by_id($var['user_id']); if ($user->delete()) { $app->reload(); } break; } }
function process_page($app, $action, &$var) { $var['domain_count'] = Domain::count(); $var['user_count'] = User::count(); $var['domains'] = Domain::list_all(); if (!isset($var['domain_id'])) { if (isset($_COOKIE['app/aliases/domain_id'])) { $var['domain_id'] = filter_var($_COOKIE['app/aliases/domain_id'], FILTER_SANITIZE_STRING); if (Domain::list_by_id($var['domain_id']) == null) { $var['domain_id'] = 0; } } else { $var['domain_id'] = 0; } } if ($var['domain_id'] != 0) { $var['users'] = User::list_by_domain_id($var['domain_id']); $var['active_domain'] = Domain::list_by_id($var['domain_id']); } else { $var['users'] = User::list_all(); } if (!isset($var['user_id'])) { if (isset($_COOKIE['app/aliases/user_id'])) { $var['user_id'] = filter_var($_COOKIE['app/aliases/user_id'], FILTER_SANITIZE_STRING); if (User::list_by_id($var['user_id']) == null) { $var['user_id'] = 0; } } else { $var['user_id'] = 0; } } if ($var['user_id'] != 0) { $var['active_user'] = User::list_by_id($var['user_id']); $var['aliases'] = Alias::list_by_destination($var['active_user']->get_email()); } else { if ($var['domain_id'] != 0) { $var['aliases'] = Alias::list_by_domain_id($var['domain_id']); } else { $var['aliases'] = Alias::list_all(); } } switch ($app->action) { case 'select_domain': setcookie('app/aliases/domain_id', $var['domain_id']); setcookie('app/aliases/user_id', null); $app->reload(); break; case 'select_user': setcookie('app/aliases/user_id', $var['user_id']); $app->reload(); break; case 'edit_alias': $var['alias_source'] = Alias::list_by_id($var['alias_id'])->get_source(); break; case 'insert_new_alias': $alias = new Alias(); $alias->set_destination($var['active_user']->get_email()); $alias->set_domain_id($var['domain_id']); $alias->set_source($var['alias_source']); if ($alias->insert()) { $app->reload(); } else { $app->action = 'new_alias'; } break; case 'update_edit_alias': $alias = Alias::list_by_id($var['alias_id']); $alias->set_source($var['alias_source']); if ($alias->update()) { $app->reload(); } else { $app->action = 'edit_alias'; } break; case 'delete_alias': $alias = Alias::list_by_id($var['alias_id']); if ($alias->delete()) { $app->reload(); } break; } }