- Show number of domains in limits dashlet.

Till Brehm

2014-09-09 4aec3040f93a71d0995934e42ee796efd1ff9bf3

 interface/web/dashboard/dashlets/limits.php

@@ -1,163 +1,179 @@
<?php



class dashlet_limits {

	
   function show() {

      global $app, $conf;

		
      $limits = array();

		
      /* Limits to be shown*/

		
      $limits[] = array('field' => 'limit_maildomain',

                    'db_table' => 'mail_domain',

                    'db_where' => '');

		
      $limits[] = array('field' => 'limit_mailbox',

                    'db_table' => 'mail_user',

                    'db_where' => '');

		
      $limits[] = array('field' => 'limit_mailalias',

                    'db_table' => 'mail_forwarding',

                    'db_where' => "type = 'alias'");

		
      $limits[] = array('field' => 'limit_mailaliasdomain',

                    'db_table' => 'mail_forwarding',

                    'db_where' => "type = 'aliasdomain'");

		
      $limits[] = array('field' => 'limit_mailforward',

                    'db_table' => 'mail_forwarding',

                    'db_where' => "type = 'forward'");

		
      $limits[] = array('field' => 'limit_mailcatchall',

                    'db_table' => 'mail_forwarding',

                    'db_where' => "type = 'catchall'");

		
      $limits[] = array('field' => 'limit_mailrouting',

                    'db_table' => 'mail_transport',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_mailfilter',

                    'db_table' => 'mail_user_filter',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_fetchmail',

                    'db_table' => 'mail_get',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_spamfilter_wblist',

                    'db_table' => 'spamfilter_wblist',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_spamfilter_user',

                    'db_table' => 'spamfilter_users',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_spamfilter_policy',

                    'db_table' => 'spamfilter_policy',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_web_domain',

                    'db_table' => 'web_domain',

                    'db_where' => "type = 'vhost'");

		
      $limits[] = array('field' => 'limit_web_subdomain',

                    'db_table' => 'web_domain',

                    'db_where' => "type = 'subdomain'");

		
      $limits[] = array('field' => 'limit_web_aliasdomain',

                    'db_table' => 'web_domain',

                    'db_where' => "type = 'aliasdomain'");

		
      $limits[] = array('field' => 'limit_ftp_user',

                    'db_table' => 'ftp_user',

                    'db_where' => "");



      $limits[] = array('field' => 'limit_shell_user',

                    'db_table' => 'shell_user',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_dns_zone',

                    'db_table' => 'dns_soa',

                    'db_where' => "");



      $limits[] = array('field' => 'limit_dns_record',

                    'db_table' => 'dns_rr',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_database',

                    'db_table' => 'web_database',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_cron',

                    'db_table' => 'cron',

                    'db_where' => "");

		
      $limits[] = array('field' => 'limit_client',

                    'db_table' => 'client',

                    'db_where' => "");

		
		
		
		
      //* Loading Template

      $app->uses('tpl,tform');

		
      $tpl = new tpl;

      $tpl->newTemplate("dashlets/templates/limits.htm");

		
      $lng_file = 'lib/lang/'.$_SESSION['s']['language'].'_dashlet_limits.lng';

      include($lng_file);

      $tpl->setVar($wb);

		
      if($app->auth->is_admin()) {

         $user_is_admin = 1;

      } else {

         $user_is_admin = 0;

      }

      $tpl->setVar('is_admin',$user_is_admin);

		
      if($user_is_admin == 0) {

         $client_group_id = $_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");

			
         $rows = array();

         foreach($limits as $limit) {

            $field = $limit['field'];

            if($client[$field] != 0) {

               $value = ($client[$field] == '-1')?$wb['unlimited_txt']:$client[$field];

               $rows[] = array('field' => $field,

                           'field_txt' => $wb[$field.'_txt'],

                           'value' => $value,

                           'usage' => $this->_get_limit_usage($limit));

            }

         }

         $tpl->setLoop('rows',$rows);

      }

		
		
      return $tpl->grab();

		
   }

	
   function _get_limit_usage($limit) {

      global $app;

		
      $sql = "SELECT count(sys_userid) as number FROM ".$limit['db_table']." WHERE ";

      if($limit['db_where'] != '') $sql .= $limit['db_where']." AND ";

      $sql .= $app->tform->getAuthSQL('r');

      $rec = $app->db->queryOneRecord($sql);

      return $rec['number'];

		
   }

	
}

















?>
<?php

class dashlet_limits {

   function show() {
      global $app, $conf;

      $limits = array();

      /* Limits to be shown*/

      $limits[] = array('field' => 'limit_maildomain',
         'db_table' => 'mail_domain',
         'db_where' => '');

      $limits[] = array('field' => 'limit_mailmailinglist',
         'db_table' => 'mail_mailinglist',
         'db_where' => '');

      $limits[] = array('field' => 'limit_mailbox',
         'db_table' => 'mail_user',
         'db_where' => '');

      $limits[] = array('field' => 'limit_mailalias',
         'db_table' => 'mail_forwarding',
         'db_where' => "type = 'alias'");

      $limits[] = array('field' => 'limit_mailaliasdomain',
         'db_table' => 'mail_forwarding',
         'db_where' => "type = 'aliasdomain'");

      $limits[] = array('field' => 'limit_mailforward',
         'db_table' => 'mail_forwarding',
         'db_where' => "type = 'forward'");

      $limits[] = array('field' => 'limit_mailcatchall',
         'db_table' => 'mail_forwarding',
         'db_where' => "type = 'catchall'");

      $limits[] = array('field' => 'limit_mailrouting',
         'db_table' => 'mail_transport',
         'db_where' => "");

      $limits[] = array('field' => 'limit_mailfilter',
         'db_table' => 'mail_user_filter',
         'db_where' => "");

      $limits[] = array('field' => 'limit_fetchmail',
         'db_table' => 'mail_get',
         'db_where' => "");

      $limits[] = array('field' => 'limit_spamfilter_wblist',
         'db_table' => 'spamfilter_wblist',
         'db_where' => "");

      $limits[] = array('field' => 'limit_spamfilter_user',
         'db_table' => 'spamfilter_users',
         'db_where' => "");

      $limits[] = array('field' => 'limit_spamfilter_policy',
         'db_table' => 'spamfilter_policy',
         'db_where' => "");

      $limits[] = array('field' => 'limit_web_domain',
         'db_table' => 'web_domain',
         'db_where' => "type = 'vhost'");

      $limits[] = array('field' => 'limit_web_subdomain',
         'db_table' => 'web_domain',
         'db_where' => "(type = 'subdomain' OR type = 'vhostsubdomain')");

      $limits[] = array('field' => 'limit_web_aliasdomain',
         'db_table' => 'web_domain',
         'db_where' => "type = 'alias'");

      $limits[] = array('field' => 'limit_ftp_user',
         'db_table' => 'ftp_user',
         'db_where' => "");

      $limits[] = array('field' => 'limit_shell_user',
         'db_table' => 'shell_user',
         'db_where' => "");

      $limits[] = array('field' => 'limit_dns_zone',
         'db_table' => 'dns_soa',
         'db_where' => "");

      $limits[] = array('field' => 'limit_dns_slave_zone',
         'db_table' => 'dns_slave',
         'db_where' => "");

      $limits[] = array('field' => 'limit_dns_record',
         'db_table' => 'dns_rr',
         'db_where' => "");

      $limits[] = array('field' => 'limit_database',
         'db_table' => 'web_database',
         'db_where' => "");

      $limits[] = array('field' => 'limit_cron',
         'db_table' => 'cron',
         'db_where' => "");

      $limits[] = array('field' => 'limit_client',
         'db_table' => 'client',
         'db_where' => "");

      $limits[] = array('field' => 'limit_domain',
         'db_table' => 'domain',
         'db_where' => "");


      //* Loading Template
      $app->uses('tpl,tform');

      $tpl = new tpl;
      $tpl->newTemplate("dashlets/templates/limits.htm");

      $wb = array();
      $lng_file = 'lib/lang/'.$_SESSION['s']['language'].'_dashlet_limits.lng';
      if(is_file($lng_file)) include $lng_file;
      $tpl->setVar($wb);

      if($app->auth->is_admin()) {
         $user_is_admin = true;
      } else {
         $user_is_admin = false;
      }
      $tpl->setVar('is_admin', $user_is_admin);

      if($user_is_admin == false) {
         $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");
      }

      $rows = array();
      foreach($limits as $limit) {
         $field = $limit['field'];
         if($user_is_admin) {
            $value = $wb['unlimited_txt'];
         } else {
            $value = $client[$field];
         }
         if($value != 0 || $value == $wb['unlimited_txt']) {
            $value_formatted = ($value == '-1')?$wb['unlimited_txt']:$value;
            $rows[] = array('field' => $field,
               'field_txt' => $wb[$field.'_txt'],
               'value' => $value_formatted,
               'usage' => $this->_get_limit_usage($limit));
         }
      }
      $tpl->setLoop('rows', $rows);


      return $tpl->grab();

   }

   function _get_limit_usage($limit) {
      global $app;

      $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);
      return $rec['number'];

   }

}








?>