SystemAnnouncementManager::send_system_announcement_by_email()

Complexity

Conditions	19
Paths	385

Size

Total Lines	82
Code Lines	43

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function send_system_announcement_by_email(
        $title,
        $content,
        $teacher,
        $student,
        $language = null,
        $sendEmailTest = false
    ) {
        $content = str_replace(array('\r\n', '\n', '\r'),'', $content);
        $now = api_get_utc_datetime();

        if ($sendEmailTest) {
            MessageManager::send_message_simple(api_get_user_id(), $title, $content);

            return true;
        }

        $user_table = Database :: get_main_table(TABLE_MAIN_USER);
        if (api_is_multiple_url_enabled()) {
            $current_access_url_id = api_get_current_access_url_id();
            $url_rel_user = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
            $url_condition = " INNER JOIN $url_rel_user uu ON uu.user_id = u.user_id ";
        }

        if ($teacher <> 0 && $student == 0) {
			$sql = "SELECT DISTINCT u.user_id FROM $user_table u $url_condition 
					WHERE status = '1' ";
		}

		if ($teacher == 0 && $student <> 0) {
			$sql = "SELECT DISTINCT u.user_id FROM $user_table u $url_condition 
					WHERE status = '5' ";
		}

		if ($teacher<> 0 && $student <> 0) {
			$sql = "SELECT DISTINCT u.user_id FROM $user_table u $url_condition 
					WHERE 1 = 1 ";
		}

		if (!empty($language)) {
			//special condition because language was already treated for SQL insert before
			$sql .= " AND language = '".Database::escape_string($language)."' ";
		}

		if (api_is_multiple_url_enabled()) {
            $sql .= " AND access_url_id = '".$current_access_url_id."' ";
        }

        // Sent to active users.
        $sql .= " AND email <>'' AND active = 1 ";

        // Expiration date
        $sql .= " AND (expiration_date = '' OR expiration_date IS NULL OR expiration_date > '$now') ";

		if ((empty($teacher) || $teacher == '0') && (empty($student) || $student == '0')) {

			return true;
		}

		$result = Database::query($sql);
		if ($result === false) {

			return false;
		}

        $message_sent = false;

		while ($row = Database::fetch_array($result,'ASSOC')) {
            MessageManager::send_message_simple($row['user_id'], $title, $content);
            $message_sent = true;
		}
	    
	    	// Minor validation to clean up the attachment files in the announcement
		if (!empty($_FILES)) {
		    $attachments = $_FILES;
		    foreach ($attachments as $attachment) {
			unlink($attachment['tmp_name']);
		    }
		}

		return $message_sent; //true if at least one e-mail was sent
	}