class.ilConsultationHourCron.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once "Services/Cron/classes/class.ilCronJob.php";

class ilConsultationHourCron extends ilCronJob
{
        public function getId()
        {
                return "cal_consultation";
        }
        
        public function getTitle()
        {
                global $lng;
                
                $lng->loadLanguageModule('dateplaner');
                return $lng->txt("cal_ch_cron_reminder");
        }
        
        public function getDescription()
        {
                global $lng;
                
                $lng->loadLanguageModule('dateplaner');
                return $lng->txt("cal_ch_cron_reminder_info");
        }
        
        public function getDefaultScheduleType()
        {
                return self::SCHEDULE_TYPE_DAILY;
        }
        
        public function getDefaultScheduleValue()
        {
                return;
        }
        
        public function hasAutoActivation()
        {
                return false;
        }
        
        public function hasFlexibleSchedule()
        {
                return false;
        }
        
        public function hasCustomSettings() 
        {
                return true;
        }
        
        public function run()
        {                               
                global $ilSetting, $ilDB;
                
                $status = ilCronJobResult::STATUS_NO_ACTION;                                            
                
                $days_before = $ilSetting->get('ch_reminder_days');
                $now = new ilDateTime(time(),IL_CAL_UNIX);
                
                $limit = clone $now;
                $limit->increment(IL_CAL_DAY,$days_before);
                
                $counter = 0;
                
                $query = 'SELECT * FROM booking_user '.
                                'JOIN cal_entries ON entry_id = cal_id '.
                                'WHERE notification_sent = '.$ilDB->quote(0,'integer').' '.
                                'AND starta > '.$ilDB->quote($now->get(IL_CAL_DATETIME,'',  ilTimeZone::UTC),'timestamp'). ' '.
                                'AND starta <= '.$ilDB->quote($limit->get(IL_CAL_DATETIME, '', ilTimeZone::UTC),'timestamp');   
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT))
                {
                        include_once 'Services/Calendar/classes/class.ilCalendarMailNotification.php';
                        $mail = new ilCalendarMailNotification();
                        $mail->setAppointmentId($row->entry_id);
                        $mail->setRecipients(array($row->user_id));
                        $mail->setType(ilCalendarMailNotification::TYPE_BOOKING_REMINDER);
                        $mail->send();
                        
                        // update notification
                        $query = 'UPDATE booking_user '.
                                        'SET notification_sent = '.$ilDB->quote(1,'integer').' '.
                                        'WHERE user_id = '.$ilDB->quote($row->user_id,'integer').' '.
                                        'AND entry_id = '.$ilDB->quote($row->entry_id,'integer');
                        $ilDB->manipulate($query);
                        
                        $counter++;
                }
                                                
                if($counter)
                {
                        $status = ilCronJobResult::STATUS_OK;
                }                       
                $result = new ilCronJobResult();
                $result->setStatus($status);            
                return $result;
        }
        
        public function addCustomSettingsToForm(ilPropertyFormGUI $a_form)
        {
                global $lng, $ilSetting;
                
                $lng->loadLanguageModule('dateplaner');

                $consultation_days = new ilNumberInputGUI($lng->txt('cal_ch_cron_reminder_days'),'ch_reminder_days');
                $consultation_days->setMinValue(1);
                $consultation_days->setMaxLength(2);
                $consultation_days->setSize(2);
                $consultation_days->setValue($ilSetting->get('ch_reminder_days',2));
                $consultation_days->setRequired(true);
                $a_form->addItem($consultation_days);
        }
        
        public function saveCustomSettings(ilPropertyFormGUI $a_form)
        {
                global $ilSetting;

                $ilSetting->set('ch_reminder_days', $a_form->getInput('ch_reminder_days'));
                
                return true;
        }               
}

?>