コード例 #1
0
ファイル: class.notify.php プロジェクト: rkCSD/flyspray
    function Address($task_id, $type)
    {
        global $db, $fs, $proj, $user;
        $users = array();
        $emails = array();
        $jabbers = array();
        $onlines = array();
        $task_details = Flyspray::GetTaskDetails($task_id);
        // Get list of users from the notification tab
        // Decision: If a notification-user have the limited-flag set, only
        // task-relevant messages should be send to him
        if ($type > 4) {
            $limitedStr = " AND n.limited = 0";
        } else {
            $limitedStr = "";
        }
        $get_users = $db->Query('
			SELECT * FROM {notifications} n
			LEFT JOIN {users} u ON n.user_id = u.user_id
			WHERE n.task_id = ? ' . $limitedStr, array($task_id));
        self::AssignRecipients($db->FetchAllArray($get_users), $emails, $jabbers, $onlines);
        // Get list of assignees
        $get_users = $db->Query('
			SELECT * FROM {assigned} a
			LEFT JOIN {users} u ON a.user_id = u.user_id
			WHERE a.task_id = ?', array($task_id));
        self::AssignRecipients($db->FetchAllArray($get_users), $emails, $jabbers, $onlines);
        // Now, we add the project contact addresses...
        // ...but only if the task is public
        if ($task_details['mark_private'] != '1' && in_array($type, Flyspray::int_explode(' ', $proj->prefs['notify_types']))) {
            // FIXME! Have to find users preferred language here too,
            // must fetch from database. But the address could also be a mailing
            // list address and user not exist in database, use fs->prefs in that case,
            $proj_emails = preg_split('/[\\s,;]+/', $proj->prefs['notify_email'], -1, PREG_SPLIT_NO_EMPTY);
            $desired = implode("','", $proj_emails);
            if ($desired != '') {
                $get_users = $db->Query("\n\t\t\t\t\tSELECT DISTINCT u.user_id, u.email_address, u.jabber_id,\n\t\t\t\t\tu.notify_online, u.notify_type, u.notify_own, u.lang_code\n\t\t\t\t\tFROM {users} u\n\t\t\t\t\tWHERE u.email_address IN ('{$desired}')");
                self::AssignRecipients($db->FetchAllArray($get_users), $emails, $jabbers, $onlines);
            }
            $proj_jids = explode(',', $proj->prefs['notify_jabber']);
            $desired = implode("','", $proj_jids);
            if ($desired != '') {
                $get_users = $db->Query("\n\t\t\t\t\tSELECT DISTINCT u.user_id, u.email_address, u.jabber_id,\n\t\t\t\t\tu.notify_online, u.notify_type, u.notify_own, u.lang_code\n\t\t\t\t\tFROM {users} u\n\t\t\t\t\tWHERE u.jabber_id IN ('{$desired}')");
                self::AssignRecipients($db->FetchAllArray($get_users), $emails, $jabbers, $onlines);
            }
            // Now, handle notification addresses that are not assigned to any user...
            foreach ($proj_emails as $email) {
                if (!array_key_exists($email, $emails)) {
                    $emails[$email] = array('recipient' => $email, 'lang' => $fs->prefs['lang_code']);
                }
            }
            foreach ($proj_jids as $jabber) {
                if (!array_key_exists($jabber, $jabbers)) {
                    $jabbers[$jabber] = array('recipient' => $jabber, 'lang' => $fs->prefs['lang_code']);
                }
            }
            /*
            echo "<pre>";
            echo var_dump($proj_emails);
            echo var_dump($proj_jids);
            echo "</pre>";
            */
            // End of checking if a task is private
        }
        // Send back three arrays containing the notification addresses
        return array($emails, $jabbers, $onlines);
    }
コード例 #2
0
 function Address($task_id, $type)
 {
     global $db, $fs, $proj, $user;
     $users = array();
     $jabber_users = array();
     $email_users = array();
     $task_details = Flyspray::GetTaskDetails($task_id);
     // Get list of users from the notification tab
     $get_users = $db->Query('SELECT *
                            FROM {notifications} n
                            LEFT JOIN {users} u ON n.user_id = u.user_id
                            WHERE n.task_id = ?', array($task_id));
     while ($row = $db->FetchRow($get_users)) {
         if ($row['user_id'] == $user->id && !$user->infos['notify_own']) {
             continue;
         }
         if ($fs->prefs['user_notify'] == '1' && ($row['notify_type'] == NOTIFY_EMAIL || $row['notify_type'] == NOTIFY_BOTH) || $fs->prefs['user_notify'] == '2') {
             array_push($email_users, $row['email_address']);
         }
         if ($fs->prefs['user_notify'] == '1' && ($row['notify_type'] == NOTIFY_JABBER || $row['notify_type'] == NOTIFY_BOTH) || $fs->prefs['user_notify'] == '3') {
             array_push($jabber_users, $row['jabber_id']);
         }
     }
     // Get list of assignees
     $get_users = $db->Query('SELECT *
                            FROM {assigned} a
                            LEFT JOIN {users} u ON a.user_id = u.user_id
                            WHERE a.task_id = ?', array($task_id));
     while ($row = $db->FetchRow($get_users)) {
         if ($row['user_id'] == $user->id && !$user->infos['notify_own']) {
             continue;
         }
         if ($fs->prefs['user_notify'] == '1' && ($row['notify_type'] == NOTIFY_EMAIL || $row['notify_type'] == NOTIFY_BOTH) || $fs->prefs['user_notify'] == '2') {
             array_push($email_users, $row['email_address']);
         }
         if ($fs->prefs['user_notify'] == '1' && ($row['notify_type'] == NOTIFY_JABBER || $row['notify_type'] == NOTIFY_BOTH) || $fs->prefs['user_notify'] == '3') {
             array_push($jabber_users, $row['jabber_id']);
         }
     }
     // Now, we add the project contact addresses...
     // ...but only if the task is public
     if ($task_details['mark_private'] != '1' && in_array($type, Flyspray::int_explode(' ', $proj->prefs['notify_types']))) {
         $proj_emails = preg_split('/[\\s,;]+/', $proj->prefs['notify_email'], -1, PREG_SPLIT_NO_EMPTY);
         $proj_jids = explode(',', $proj->prefs['notify_jabber']);
         foreach ($proj_emails as $key => $val) {
             if (!empty($val) && !in_array($val, $email_users)) {
                 array_push($email_users, $val);
             }
         }
         foreach ($proj_jids as $key => $val) {
             if (!empty($val) && !in_array($val, $jabber_users)) {
                 array_push($jabber_users, $val);
             }
         }
         // End of checking if a task is private
     }
     // Send back two arrays containing the notification addresses
     return array($email_users, array_unique($jabber_users));
 }