ILIAS  release_5-1 Revision 5.0.0-5477-g43f3e3fab5f
class.ilDiskQuotaSummaryNotification.php
Go to the documentation of this file.
1<?php
2/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */
3
4include_once 'Services/Mail/classes/class.ilMailNotification.php';
5include_once 'Services/WebDAV/classes/class.ilDiskQuotaChecker.php';
6
14{
22 public function __construct()
23 {
24 $dqs = new ilSetting('disk_quota');
25 $rcpt = $dqs->get('summary_rcpt');
26 $rcpt = explode(',', $rcpt);
27 $loginnames = array();
28 foreach($rcpt as $loginname)
29 {
30 $loginname = trim($loginname);
31 if(ilObjUser::_lookupId($loginname))
32 {
33 $loginnames[] = $loginname;
34 }
35 }
36 $this->setRecipients($loginnames);
37
38 parent::__construct();
39 }
40
48 public function send()
49 {
50 global $ilDB;
51
52 // parent::send();
53
54 if( count($this->getRecipients()) )
55 {
56 $res = $ilDB->queryf(
57 "SELECT u.usr_id,u.gender,u.firstname,u.lastname,u.login,u.email,u.last_login,u.active,".
58 "u.time_limit_unlimited, ".$ilDB->fromUnixtime("u.time_limit_from").", ".$ilDB->fromUnixtime("u.time_limit_until").",".
59
60 // Inactive users get the date 0001-01-01 so that they appear
61 // first when the list is sorted by this field. Users with
62 // unlimited access get the date 9999-12-31 so that they appear
63 // last.
64 "CASE WHEN u.active = 0 THEN '0001-01-01' ELSE CASE WHEN u.time_limit_unlimited=1 THEN '9999-12-31' ELSE ".$ilDB->fromUnixtime("u.time_limit_until")." END END access_until,".
65
66 " CASE WHEN ".$ilDB->unixTimestamp()." BETWEEN u.time_limit_from AND u.time_limit_until THEN 0 ELSE 1 END expired,".
67 "rq.role_disk_quota, system_role.rol_id role_id, ".
68 "p1.value+0 user_disk_quota,".
69 "p2.value+0 disk_usage, ".
70 "p3.value last_update, ".
71 "p5.value language, ".
72
73 // We add 0 to some of the values to convert them into a number.
74 // This is needed for correct sorting.
75 "CASE WHEN rq.role_disk_quota>p1.value+0 OR p1.value IS NULL THEN rq.role_disk_quota ELSE p1.value+0 END disk_quota ".
76 "FROM usr_data u ".
77
78 // Fetch the role with the highest disk quota value.
79 "JOIN (SELECT u.usr_id usr_id,MAX(rd.disk_quota) role_disk_quota ".
80 "FROM usr_data u ".
81 "JOIN rbac_ua ua ON ua.usr_id=u.usr_id ".
82 "JOIN rbac_fa fa ON fa.rol_id=ua.rol_id AND fa.parent=%s ".
83 "JOIN role_data rd ON rd.role_id=ua.rol_id WHERE u.usr_id=ua.usr_id GROUP BY u.usr_id) rq ON rq.usr_id=u.usr_id ".
84
85 // Fetch the system role in order to determine whether the user has unlimited disk quota
86 "LEFT JOIN rbac_ua system_role ON system_role.usr_id=u.usr_id AND system_role.rol_id = %s ".
87
88 // Fetch the user disk quota from table usr_pref
89 "LEFT JOIN usr_pref p1 ON p1.usr_id=u.usr_id AND p1.keyword = 'disk_quota' ".
90
91 // Fetch the disk usage from table usr_pref
92 "LEFT JOIN usr_pref p2 ON p2.usr_id=u.usr_id AND p2.keyword = 'disk_usage' ".
93
94 // Fetch the last update from table usr_pref
95 "LEFT JOIN usr_pref p3 ON p3.usr_id=u.usr_id AND p3.keyword = 'disk_usage.last_update' ".
96
97 // Fetch the language of the user
98 "LEFT JOIN usr_pref p5 ON p5.usr_id=u.usr_id AND p5.keyword = 'language' ".
99
100 // Fetch only users who have exceeded their quota, and who have
101 // access, and who have not received a reminder in the past seven days
102 // #8554 / #10301
103 'WHERE (((p1.value+0 > rq.role_disk_quota OR rq.role_disk_quota IS NULL) AND p2.value+0 > p1.value+0) OR
104 ((rq.role_disk_quota > p1.value+0 OR p1.value IS NULL) AND p2.value+0 > rq.role_disk_quota)) '.
105 'AND (u.active=1 AND (u.time_limit_unlimited = 1 OR '.$ilDB->unixTimestamp().' BETWEEN u.time_limit_from AND u.time_limit_until)) '
106 ,
107 array('integer','integer'),
108 array(ROLE_FOLDER_ID, SYSTEM_ROLE_ID)
109 );
110
111 $users = array();
112
113 $counter = 0;
114 while( $row = $ilDB->fetchAssoc($res) )
115 {
116 $details = ilDiskQuotaChecker::_lookupDiskUsage($row['usr_id']);
117
118 $users[$counter]['disk_quota'] = $row['disk_quota'];
119 $users[$counter]['disk_usage'] = $details['disk_usage'];
120 $users[$counter]['email'] = $row['email'];
121 $users[$counter]['firstname'] = $row['firstname'];
122 $users[$counter]['lastname'] = $row['lastname'];
123
124 ++$counter;
125 }
126
127 if( count($users) ) foreach($this->getRecipients() as $rcp)
128 {
129 $usrId = ilObjUser::_lookupId($rcp);
130
131 $this->initLanguage($usrId);
132 $this->initMail();
133
134 $this->setSubject($this->getLanguage()->txt('disk_quota_summary_subject'));
135
136 $this->setBody(ilMail::getSalutation($usrId, $this->getLanguage()));
137
138 $this->appendBody("\n\n");
139 $this->appendBody($this->getLanguage()->txt('disk_quota_exceeded_headline'));
140 $this->appendBody("\n\n");
141
142 $first = true;
143 $counter = 0;
144 $numUsers = count($users);
145 foreach($users as $user)
146 {
147 if(!$first)
148 {
149 $this->appendBody("\n---------------------------------------------------\n\n");
150 }
151
152 $this->appendBody(
153 $this->getLanguage()->txt('fullname').': '.
154 $user['lastname'].', '.$user['firstname']
155 ."\n");
156 $this->appendBody(
157 $this->getLanguage()->txt('email').': '.
158 $user['email']
159 ."\n");
160 $this->appendBody(
161 $this->getLanguage()->txt('disk_quota').': '.
162 ilFormat::formatSize($user['disk_quota'],'short', $this->getLanguage())
163 ."\n");
164 $this->appendBody(
165 $this->getLanguage()->txt('currently_used_disk_space').': '.
166 ilFormat::formatSize($user['disk_usage'],'short', $this->getLanguage())
167 ."\n");
168
169 $this->appendBody(
170 $this->getLanguage()->txt('usrf_profile_link').': '.
171 ilUtil::_getHttpPath().'/goto.php?target=usrf&client_id='.CLIENT_ID
172 );
173
174 if($counter < $numUsers - 1)
175 {
176 $this->appendBody("\n");
177 }
178
179 ++$counter;
180 $first = false;
181 }
182
183 $this->getMail()->appendInstallationSignature(true);
184
185 $this->sendMail(array($rcp), array('system'), false);
186 }
187 }
188 }
189}
static _lookupDiskUsage($a_user_id)
Gets the disk usage info for the specified user account.
static formatSize($size, $a_mode='short', $a_lng=null)
Returns the specified file size value in a human friendly form.
Base class for course/group mail notifications.
appendBody($a_body)
Append body text.
sendMail(array $a_rcp, $a_type, $a_parse_recipients=true)
initLanguage($a_usr_id)
Init language.
getRecipients()
get array of recipients
static getSalutation($a_usr_id, $a_language=null)
Get salutation.
static _lookupId($a_user_str)
Lookup id by login.
ILIAS Setting Class.
static _getHttpPath()
global $ilDB