From 89e4329a8068e3631d3f64f6896fa3907c687cf5 Mon Sep 17 00:00:00 2001 From: Marius Cramer <m.cramer@pixcept.de> Date: Thu, 08 Jan 2015 09:08:50 -0500 Subject: [PATCH] Layout fix: tab toggle and monitor tables --- interface/web/dashboard/dashlets/limits.php | 17 ++++++++++++----- 1 files changed, 12 insertions(+), 5 deletions(-) diff --git a/interface/web/dashboard/dashlets/limits.php b/interface/web/dashboard/dashlets/limits.php index 2d63925..70113f3 100644 --- a/interface/web/dashboard/dashlets/limits.php +++ b/interface/web/dashboard/dashlets/limits.php @@ -71,7 +71,7 @@ $limits[] = array('field' => 'limit_web_aliasdomain', 'db_table' => 'web_domain', - 'db_where' => "type = 'alias'"); + 'db_where' => "(type = 'alias' OR type = 'vhostalias')"); $limits[] = array('field' => 'limit_ftp_user', 'db_table' => 'ftp_user', @@ -105,7 +105,9 @@ 'db_table' => 'client', 'db_where' => ""); - + $limits[] = array('field' => 'limit_domain', + 'db_table' => 'domain', + 'db_where' => ""); //* Loading Template @@ -127,7 +129,7 @@ $tpl->setVar('is_admin', $user_is_admin); if($user_is_admin == false) { - $client_group_id = $_SESSION["s"]["user"]["default_group"]; + $client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]); $client = $app->db->queryOneRecord("SELECT * FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id"); } @@ -141,10 +143,15 @@ } if($value != 0 || $value == $wb['unlimited_txt']) { $value_formatted = ($value == '-1')?$wb['unlimited_txt']:$value; + $usage = $this->_get_limit_usage($limit); + $percentage = ($value == '-1' || $value == 0 ? 0 : round(100 * $usage / $value)); $rows[] = array('field' => $field, 'field_txt' => $wb[$field.'_txt'], 'value' => $value_formatted, - 'usage' => $this->_get_limit_usage($limit)); + 'value_raw' => $value, + 'usage' => $usage, + 'usage_raw' => $usage, + 'percentage' => $percentage); } } $tpl->setLoop('rows', $rows); @@ -157,7 +164,7 @@ function _get_limit_usage($limit) { global $app; - $sql = "SELECT count(sys_userid) as number FROM ".$limit['db_table']." WHERE "; + $sql = "SELECT count(sys_userid) as number FROM ".$app->db->quote($limit['db_table'])." WHERE "; if($limit['db_where'] != '') $sql .= $limit['db_where']." AND "; $sql .= $app->tform->getAuthSQL('r'); $rec = $app->db->queryOneRecord($sql); -- Gitblit v1.9.1