ilMailCronAddressbookSync Class Reference

Address book sync. More...

Inheritance diagram for ilMailCronAddressbookSync:

Collaboration diagram for ilMailCronAddressbookSync:

Public Member Functions
	getId ()
	getTitle ()
	getDescription ()
	getDefaultScheduleType ()
	getDefaultScheduleValue ()
	hasAutoActivation ()
	hasFlexibleSchedule ()
	hasCustomSettings ()
	run ()
	activationWasToggled ($a_currently_active)
Public Member Functions inherited from ilCronJob
	isActive ($a_ts_last_run, $a_schedule_type, $a_schedule_value, $a_manual=false)
	Is job currently active? More...
	getScheduleType ()
	Get current schedule type (if flexible) More...
	getScheduleValue ()
	Get current schedule value (if flexible) More...
	setSchedule ($a_type, $a_value)
	Update current schedule (if flexible) More...
	getValidScheduleTypes ()
	Get all available schedule types. More...
	getTitle ()
	Get title. More...
	getDescription ()
	Get description. More...
	isManuallyExecutable ()
	Defines whether or not a cron job can be started manually. More...
	hasCustomSettings ()
	Has cron job any custom setting which can be edited? More...
	addCustomSettingsToForm (ilPropertyFormGUI $a_form)
	Add custom settings to form. More...
	saveCustomSettings (ilPropertyFormGUI $a_form)
	Save custom settings. More...
	addToExternalSettingsForm ($a_form_id, array &$a_fields, $a_is_active)
	Add external settings to form. More...
	activationWasToggled ($a_currently_active)
	Cron job status was changed. More...
	getId ()
	Get id. More...
	hasAutoActivation ()
	Is to be activated on "installation". More...
	hasFlexibleSchedule ()
	Can the schedule be configured? More...
	getDefaultScheduleType ()
	Get schedule type. More...
	getDefaultScheduleValue ()
	Get schedule value. More...
	run ()
	Run job. More...

Additional Inherited Members
Data Fields inherited from ilCronJob
const	SCHEDULE_TYPE_DAILY = 1
const	SCHEDULE_TYPE_IN_MINUTES = 2
const	SCHEDULE_TYPE_IN_HOURS = 3
const	SCHEDULE_TYPE_IN_DAYS = 4
const	SCHEDULE_TYPE_WEEKLY = 5
const	SCHEDULE_TYPE_MONTHLY = 6
const	SCHEDULE_TYPE_QUARTERLY = 7
const	SCHEDULE_TYPE_YEARLY = 8
Protected Member Functions inherited from ilCronJob
	checkSchedule ($a_ts_last_run, $a_schedule_type, $a_schedule_value)

Detailed Description

Address book sync.

Author

Nadia Ahmad nahma.nosp@m.d@da.nosp@m.tabay.nosp@m..de

Definition at line 12 of file class.ilMailCronAddressbookSync.php.

Member Function Documentation

activationWasToggled()

ilMailCronAddressbookSync::activationWasToggled

(

$a_currently_active

)

Definition at line 116 of file class.ilMailCronAddressbookSync.php.

References $ilSetting.

        {               
                global $ilSetting;
                
                // propagate cron-job setting to object setting
                $ilSetting->set('cron_upd_adrbook', (bool)$a_currently_active);
        }

getDefaultScheduleType()

ilMailCronAddressbookSync::getDefaultScheduleType

(

)

Definition at line 35 of file class.ilMailCronAddressbookSync.php.

        {
                return self::SCHEDULE_TYPE_DAILY;
        }

getDefaultScheduleValue()

ilMailCronAddressbookSync::getDefaultScheduleValue

(

)

Definition at line 40 of file class.ilMailCronAddressbookSync.php.

        {
                return;
        }

getDescription()

ilMailCronAddressbookSync::getDescription

(

)

Definition at line 27 of file class.ilMailCronAddressbookSync.php.

References $lng.

        {
                global $lng;
                                
                $lng->loadLanguageModule("mail");
                return $lng->txt("cron_update_addressbook_desc");
        }

getId()

ilMailCronAddressbookSync::getId

(

)

Definition at line 14 of file class.ilMailCronAddressbookSync.php.

        {
                return "mail_address_sync";
        }

getTitle()

ilMailCronAddressbookSync::getTitle

(

)

Definition at line 19 of file class.ilMailCronAddressbookSync.php.

References $lng.

        {
                global $lng;
                                
                $lng->loadLanguageModule("mail");
                return $lng->txt("cron_update_addressbook");
        }

hasAutoActivation()

ilMailCronAddressbookSync::hasAutoActivation

(

)

Definition at line 45 of file class.ilMailCronAddressbookSync.php.

        {
                return false;
        }

hasCustomSettings()

ilMailCronAddressbookSync::hasCustomSettings

(

)

Definition at line 55 of file class.ilMailCronAddressbookSync.php.

        {
                return false;
        }

hasFlexibleSchedule()

ilMailCronAddressbookSync::hasFlexibleSchedule

(

)

Definition at line 50 of file class.ilMailCronAddressbookSync.php.

        {
                return false;
        }

run()

ilMailCronAddressbookSync::run

(

)

Definition at line 60 of file class.ilMailCronAddressbookSync.php.

References $ilDB, $result, $row, and ilCronJobResult\STATUS_OK.

        {       
                global $ilDB;

                if($ilDB->getDBType() == 'oracle')
                {
                        $res1 = $ilDB->queryF('
                                SELECT addressbook.addr_id, 
                                           usr_data.firstname,
                                           usr_data.lastname, 
                                           (CASE WHEN epref.value = %s THEN usr_data.email ELSE addressbook.email END) email
                                FROM addressbook
                                INNER JOIN usr_data ON usr_data.login = addressbook.login
                                INNER JOIN usr_pref ppref ON ppref.usr_id = usr_data.usr_id AND ppref.keyword = %s AND ppref.value != %s
                                LEFT JOIN usr_pref epref ON epref.usr_id = usr_data.usr_id AND epref.keyword = %s
                                WHERE addressbook.auto_update = %s',
                                array('text', 'text', 'text', 'text', 'integer'),
                                array('y', 'public_profile', 'n', 'public_email', 1)
                        );

                        $stmt = $ilDB->prepare('
                                UPDATE addressbook 
                                SET firstname = ?,
                                        lastname = ?,
                                        email = ?
                                WHERE addr_id = ?',
                                array('text','text','text', 'integer')
                        );

                        while($row = $ilDB->fetchAssoc($res1))
                        {
                                $ilDB->execute($stmt, array($row['firstname'], $row['lastname'], $row['email'], $row['addr_id']));
                        }
                }
                else
                {
                        $ilDB->queryF('
                                UPDATE addressbook
                                INNER JOIN usr_data ON usr_data.login = addressbook.login
                                INNER JOIN usr_pref ppref ON ppref.usr_id = usr_data.usr_id AND ppref.keyword = %s AND ppref.value != %s
                                LEFT JOIN usr_pref epref ON epref.usr_id = usr_data.usr_id AND epref.keyword = %s
                                SET
                                addressbook.firstname = usr_data.firstname,
                                addressbook.lastname = usr_data.lastname,
                                addressbook.email =  (CASE WHEN epref.value = %s THEN usr_data.email ELSE addressbook.email  END)
                                WHERE addressbook.auto_update = %s',
                                array('text', 'text', 'text', 'text', 'integer'),
                                array('public_profile', 'n', 'public_email', 'y', 1)
                        );
                }
                
                $result = new ilCronJobResult();
                $result->setStatus(ilCronJobResult::STATUS_OK);         
                return $result;
        }

---

The documentation for this class was generated from the following file:

• Services/Mail/classes/class.ilMailCronAddressbookSync.php