- Added mailbox quota notifications (if mailbox uses more than 90% of confi...

ftimme

2013-07-04 d1d7fe79cfcde52c95cd0b06991497f433ef99f3

- Added mailbox quota notifications (if mailbox uses more than 90% of configured quota).

 install/tpl/server.ini.master

@@ -33,6 +33,8 @@
message_size_limit=0
mailbox_quota_stats=y
realtime_blackhole_list=
overquota_notify_admin=y
overquota_notify_client=y

[getmail]
getmail_config_dir=/etc/getmail

 interface/web/admin/form/server_config.tform.php

@@ -327,6 +327,18 @@
            'width' => '40',
            'maxlength' => '255'
        ),
        'overquota_notify_admin' => array(
            'datatype' => 'VARCHAR',
            'formtype' => 'CHECKBOX',
            'default' => 'y',
            'value' => array(0 => 'n', 1 => 'y')
        ),
        'overquota_notify_client' => array(
            'datatype' => 'VARCHAR',
            'formtype' => 'CHECKBOX',
            'default' => 'y',
            'value' => array(0 => 'n', 1 => 'y')
        ),
    ##################################
    # ENDE Datatable fields
    ##################################

 interface/web/admin/templates/server_config_mail_edit.htm

@@ -81,6 +81,18 @@
                <label for="realtime_blackhole_list">{tmpl_var name='realtime_blackhole_list_txt'}</label>
                <input name="realtime_blackhole_list" id="realtime_blackhole_list" value="{tmpl_var name='realtime_blackhole_list'}" size="40" maxlength="255" type="text" class="textInput" />&nbsp;{tmpl_var name='realtime_blackhole_list_note_txt'}
            </div>
            <div class="ctrlHolder">
                <p class="label">{tmpl_var name='overquota_notify_admin_txt'}</p>
                <div class="multiField">
                    {tmpl_var name='overquota_notify_admin'}
                </div>
            </div>
            <div class="ctrlHolder">
                <p class="label">{tmpl_var name='overquota_notify_client_txt'}</p>
                <div class="multiField">
                    {tmpl_var name='overquota_notify_client'}
                </div>
            </div>
        </fieldset>
            
        <input type="hidden" name="id" value="{tmpl_var name='id'}">

 server/conf/mail/mail_quota_notification_en.txt

New file
@@ -0,0 +1,9 @@
Subject:Mailbox quota notification

The mailbox {email} is near or over quota.

Mailbox:         {email}
Name:            {name}
Used space:        {used}
Quota:            {quota}
Usage ratio:        {ratio}

 server/cron_daily.php

@@ -875,6 +875,113 @@


#######################################################################################################
// send mail quota warnings by email
#######################################################################################################

if ($app->dbmaster == $app->db) {

    $global_config = $app->getconf->get_global_config('mail');

    //* Check email quota
    $sql = "SELECT sys_groupid,email,name,quota FROM mail_user WHERE quota > 0";
    $records = $app->db->queryAllRecords($sql);
    if(is_array($records) && !empty($records)) {
	
        $tmp_rec =  $app->db->queryAllRecords("SELECT data from monitor_data WHERE type = 'email_quota' ORDER BY created DESC");
        $monitor_data = array();
        if(is_array($tmp_rec)) {
            foreach ($tmp_rec as $tmp_mon) {
                //$monitor_data = array_merge_recursive($monitor_data,unserialize($app->db->unquote($tmp_mon['data'])));
                $tmp_array = unserialize($app->db->unquote($tmp_mon['data']));
                if(is_array($tmp_array)) {
                    foreach($tmp_array as $username => $data) {
                        if(@!$monitor_data[$username]['used']) $monitor_data[$username]['used'] = $data['used'];
                    }
                }
            }
        }
		
        foreach($records as $rec) {

            $email = $rec['email'];
		
            $rec['used'] = isset($monitor_data[$email]['used']) ? $monitor_data[$email]['used'] : array(1 => 0);
		
            if (!is_numeric($rec['used'])) $rec['used']=$rec['used'][1];
				
            // used space ratio
            $used_ratio = $rec['used']/$rec['quota'];
			
            // send notifications only if 90% or more of the quota are used
            if($used_ratio < 0.9) continue;
            $rec['ratio'] = number_format($used_ratio * 100, 2, '.', '').'%';
			
            $rec['quota'] = round($rec['quota'] / 1048576,4).' MB';

            if($rec['used'] < 1544000) {
                $rec['used'] = round($rec['used'] / 1024,4).' KB';
            } else {
                $rec['used'] = round($rec['used'] / 1048576,4).' MB';
            } 
				
            //* Send quota notifications
            $mail_config = $app->getconf->get_server_config($conf['server_id'], 'mail');
            if($mail_config['overquota_notify_admin'] == 'y' || $mail_config['overquota_notify_client'] == 'y') {
					
                if(file_exists($conf['rootpath'].'/conf-custom/mail/mail_quota_notification_'.$conf['language'].'.txt')) {
                    $lines = file($conf['rootpath'].'/conf-custom/mail/mail_quota_notification_'.$conf['language'].'.txt');
                } elseif(file_exists($conf['rootpath'].'/conf-custom/mail/mail_quota_notification_en.txt')) {
                    $lines = file($conf['rootpath'].'/conf-custom/mail/mail_quota_notification_en.txt');
                } elseif(file_exists($conf['rootpath'].'/conf/mail/mail_quota_notification_'.$conf['language'].'.txt')) {
                    $lines = file($conf['rootpath'].'/conf/mail/mail_quota_notification_'.$conf['language'].'.txt');
                } else {
                    $lines = file($conf['rootpath'].'/conf/mail/mail_quota_notification_en.txt');
                }
					
                //* Get subject
                $parts = explode(':',trim($lines[0]));
                unset($parts[0]);
                $mailquota_mail_subject  = implode(':',$parts);
                unset($lines[0]);
		
                //* Get message
                $mailquota_mail_message = trim(implode($lines));
                unset($tmp);
					
                //* Replace placeholders
                $mailquota_mail_message = str_replace('{email}',$rec['email'],$mailquota_mail_message);
                $mailquota_mail_message = str_replace('{name}',$rec['name'],$mailquota_mail_message);
                $mailquota_mail_message = str_replace('{used}',$rec['used'],$mailquota_mail_message);
                $mailquota_mail_message = str_replace('{quota}',$rec['quota'],$mailquota_mail_message);
                $mailquota_mail_message = str_replace('{ratio}',$rec['ratio'],$mailquota_mail_message);
						
                $mailHeaders      = "MIME-Version: 1.0" . "\n";
                $mailHeaders     .= "Content-type: text/plain; charset=utf-8" . "\n";
                $mailHeaders     .= "Content-Transfer-Encoding: 8bit" . "\n";
                $mailHeaders     .= "From: ". $global_config['admin_mail'] . "\n";
                $mailHeaders     .= "Reply-To: ". $global_config['admin_mail'] . "\n";
                $mailSubject      = "=?utf-8?B?".base64_encode($mailquota_mail_subject)."?=";
				
                //* send email to admin
                if($global_config['admin_mail'] != '' && $mail_config['overquota_notify_admin'] == 'y') {
                    mail($global_config['admin_mail'], $mailSubject, $mailquota_mail_message, $mailHeaders);
                }
					
                //* Send email to client
                if($mail_config['overquota_notify_client'] == 'y') {
                    $client_group_id = $rec["sys_groupid"];
                    $client = $app->db->queryOneRecord("SELECT client.email FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id");
                    if($client['email'] != '') {
                        mail($client['email'], $mailSubject, $mailquota_mail_message, $mailHeaders);
                    }
                }	
            }	
        }
    }
}


#######################################################################################################
// deactivate virtual servers (run only on the "master-server")
#######################################################################################################