4include_once 
'Services/Mail/classes/class.ilMailNotification.php';
 
   20        $rcpt = $dqs->get(
'summary_rcpt');
 
   21        $rcpt = explode(
',', $rcpt);
 
   22        $loginnames = array();
 
   23        foreach ($rcpt as $loginname) {
 
   24            $loginname = trim($loginname);
 
   26                $loginnames[] = $loginname;
 
   49                "SELECT u.usr_id,u.gender,u.firstname,u.lastname,u.login,u.email,u.last_login,u.active," .
 
   50                    "u.time_limit_unlimited, " . 
$ilDB->fromUnixtime(
"u.time_limit_from") . 
", " . 
$ilDB->fromUnixtime(
"u.time_limit_until") . 
"," .
 
   56                    "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," .
 
   58                    " CASE WHEN " . 
$ilDB->unixTimestamp() . 
" BETWEEN u.time_limit_from AND u.time_limit_until THEN 0 ELSE 1 END expired," .
 
   59                    "rq.role_disk_quota, system_role.rol_id role_id, " .
 
   60                    "p1.value+0 user_disk_quota," .
 
   61                    "p2.value+0 disk_usage, " .
 
   62                    "p3.value last_update, " .
 
   63                    "p5.value language, " .
 
   67                    "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 " .
 
   71                "JOIN (SELECT u.usr_id usr_id,MAX(rd.disk_quota) role_disk_quota " .
 
   73                    "JOIN rbac_ua ua ON ua.usr_id=u.usr_id " .
 
   74                    "JOIN rbac_fa fa ON fa.rol_id=ua.rol_id AND fa.parent=%s  " .
 
   75                    "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 " .
 
   78                "LEFT JOIN rbac_ua system_role ON system_role.usr_id=u.usr_id AND system_role.rol_id = %s " .
 
   81                "LEFT JOIN usr_pref p1 ON p1.usr_id=u.usr_id AND p1.keyword = 'disk_quota'  " .
 
   84                "LEFT JOIN usr_pref p2 ON p2.usr_id=u.usr_id AND p2.keyword = 'disk_usage'  " .
 
   87                "LEFT JOIN usr_pref p3 ON p3.usr_id=u.usr_id AND p3.keyword = 'disk_usage.last_update'  " .
 
   90                "LEFT JOIN usr_pref p5 ON p5.usr_id=u.usr_id AND p5.keyword = 'language'  " .
 
   95                'WHERE (((p1.value+0 > rq.role_disk_quota OR rq.role_disk_quota IS NULL) AND p2.value+0 > p1.value+0) OR  
   96                                        ((rq.role_disk_quota > p1.value+0 OR p1.value IS NULL) AND p2.value+0 > rq.role_disk_quota)) ' .
 
   97                'AND (u.active=1 AND (u.time_limit_unlimited = 1 OR ' . 
$ilDB->unixTimestamp() . 
' BETWEEN u.time_limit_from AND u.time_limit_until)) ',
 
   98                array(
'integer',
'integer'),
 
   99                array(ROLE_FOLDER_ID, SYSTEM_ROLE_ID)
 
  108                $users[$counter][
'disk_quota'] = $row[
'disk_quota'];
 
  109                $users[$counter][
'disk_usage'] = $details[
'disk_usage'];
 
  110                $users[$counter][
'email'] = $row[
'email'];
 
  111                $users[$counter][
'firstname'] = $row[
'firstname'];
 
  112                $users[$counter][
'lastname'] = $row[
'lastname'];
 
  134                    $numUsers = count($users);
 
  135                    foreach ($users as $user) {
 
  137                            $this->
appendBody(
"\n---------------------------------------------------\n\n");
 
  142                        $user[
'lastname'] . 
', ' . $user[
'firstname']
 
  156                            $this->
getLanguage()->txt(
'currently_used_disk_space') . 
': ' .
 
  162                            $this->
getLanguage()->txt(
'usrf_profile_link') . 
': ' .
 
  166                        if ($counter < $numUsers - 1) {
 
  174                    $this->
getMail()->appendInstallationSignature(
true);
 
  176                    $this->
sendMail(array($rcp), 
false);
 
An exception for terminatinating execution or to throw for unit testing.
static _lookupDiskUsage($a_user_id)
Gets the disk usage info for the specified user account.
send()
Send notifications.
__construct($a_is_personal_workspace=false)
{}
Base class for course/group mail notifications.
appendBody($a_body)
Append body text.
sendMail(array $a_rcp, $a_parse_recipients=true)
initLanguage($a_usr_id)
Init language.
setRecipients(array $a_rcp)
getRecipients()
get array of recipients
static getSalutation($a_usr_id, ilLanguage $a_language=null)
static _lookupId($a_user_str)
Lookup id by login.
static formatSize($size, $a_mode='short', $a_lng=null)
Returns the specified file size value in a human friendly form.
__construct(Container $dic, ilPlugin $plugin)
@inheritDoc
foreach($_POST as $key=> $value) $res