From d1d7fe79cfcde52c95cd0b06991497f433ef99f3 Mon Sep 17 00:00:00 2001
From: ftimme <ft@falkotimme.com>
Date: Thu, 04 Jul 2013 20:39:50 -0400
Subject: [PATCH] - Added mailbox quota notifications (if mailbox uses more than 90% of configured quota).
---
install/tpl/server.ini.master | 2
interface/web/admin/templates/server_config_mail_edit.htm | 12 ++++
interface/web/admin/form/server_config.tform.php | 12 ++++
server/cron_daily.php | 107 +++++++++++++++++++++++++++++++++++
server/conf/mail/mail_quota_notification_en.txt | 9 +++
5 files changed, 142 insertions(+), 0 deletions(-)
diff --git a/install/tpl/server.ini.master b/install/tpl/server.ini.master
index 3c7d29b..9d4e18d 100644
--- a/install/tpl/server.ini.master
+++ b/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
diff --git a/interface/web/admin/form/server_config.tform.php b/interface/web/admin/form/server_config.tform.php
index 4f88543..d9bd317 100644
--- a/interface/web/admin/form/server_config.tform.php
+++ b/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
##################################
diff --git a/interface/web/admin/templates/server_config_mail_edit.htm b/interface/web/admin/templates/server_config_mail_edit.htm
index 4bfd430..08900fe 100644
--- a/interface/web/admin/templates/server_config_mail_edit.htm
+++ b/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" /> {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'}">
diff --git a/server/conf/mail/mail_quota_notification_en.txt b/server/conf/mail/mail_quota_notification_en.txt
new file mode 100644
index 0000000..28c8f7e
--- /dev/null
+++ b/server/conf/mail/mail_quota_notification_en.txt
@@ -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}
\ No newline at end of file
diff --git a/server/cron_daily.php b/server/cron_daily.php
index 1c3c720..bd8e63d 100644
--- a/server/cron_daily.php
+++ b/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")
#######################################################################################################
--
Gitblit v1.9.1