/**
*
* @param $message
* @param $rec_uname
* @param $user_id
* @param $time
* @param $tmp_message_id
* @param $set_deleted
* @param $signature
* @param $subject
* @param $force_email
* @param $priority
*/
function insert_message($message, $rec_uname, $user_id = '', $time = '', $tmp_message_id = '', $set_deleted = '', $signature = '', $subject = '', $force_email = '', $priority = 'normal', $tags = null)
{
global $user;
$my_messaging_settings = UserConfig::get($user->id)->MESSAGING_SETTINGS;
// wenn kein subject uebergeben
$subject = $subject ?: _('Ohne Betreff');
$email_request = $this->send_as_email ?: $my_messaging_settings['send_as_email'];
// wenn keine zeit uebergeben
$time = $time ?: time();
// wenn keine id uebergeben
$tmp_message_id = $tmp_message_id ?: md5(uniqid('321losgehtes', true));
// wenn keine user_id uebergeben
$user_id = $user_id ?: $user->id;
# send message now
if ($user_id != '____%system%____') {
// real-user message
$snd_user_id = $user_id;
$set_deleted = $set_deleted ?: $my_messaging_settings['save_snd'] != '1';
// don't save sms in outbox
} else {
// system-message
$set_deleted = '1';
// system-signatur
$snd_user_id = '____%system%____';
setTempLanguage();
$message .= $this->sig_string;
$message .= _('Diese Nachricht wurde automatisch vom Stud.IP-System generiert. Sie können darauf nicht antworten.');
restoreLanguage();
}
// Setzen der Message-ID als Range_ID für angehängte Dateien
if (isset($this->provisonal_attachment_id) && $GLOBALS['ENABLE_EMAIL_ATTACHMENTS']) {
$query = "UPDATE dokumente SET range_id = ?, description = '' WHERE dokument_id = ?";
$statement = DBManager::get()->prepare($query);
foreach (get_message_attachments($this->provisonal_attachment_id, true) as $attachment) {
$statement->execute(array($tmp_message_id, $attachment['dokument_id']));
}
}
// insert message
$query = "INSERT INTO message (message_id, autor_id, subject, message, priority, mkdate)\n VALUES (?, ?, ?, ?, ?, UNIX_TIMESTAMP())";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($tmp_message_id, $snd_user_id, $subject, $message, $priority));
// insert snd
$insert_tags = DBManager::get()->prepare("\n INSERT IGNORE INTO message_tags\n SET message_id = :message_id,\n user_id = :user_id,\n tag = :tag,\n chdate = UNIX_TIMESTAMP(),\n mkdate = UNIX_TIMESTAMP()\n ");
$query = "INSERT INTO message_user (message_id, user_id, snd_rec, deleted, mkdate)\n VALUES (?, ?, 'snd', ?, UNIX_TIMESTAMP())";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($tmp_message_id, $snd_user_id, $set_deleted ? 1 : 0));
if ($tags) {
is_array($tags) || ($tags = explode(" ", (string) $tags));
foreach ($tags as $tag) {
$insert_tags->execute(array('message_id' => $tmp_message_id, 'user_id' => $snd_user_id, 'tag' => strtolower($tag)));
}
}
// heben wir kein array bekommen, machen wir einfach eins ...
if (!is_array($rec_uname)) {
$rec_uname = array($rec_uname);
}
// wir bastelen ein neues array, das die user_id statt des user_name enthaelt
$rec_id = array();
foreach ($rec_uname as $one) {
$rec_id[] = User::findByUsername($one)->user_id;
}
$rec_id = array_filter($rec_id);
// wir gehen das eben erstellt array durch und schauen, ob irgendwer was weiterleiten moechte.
// diese user_id schreiben wir in ein tempraeres array
foreach ($rec_id as $one) {
$tmp_forward_id = User::find($this->get_forward_id($one))->user_id;
if ($tmp_forward_id) {
$rec_id[] = $tmp_forward_id;
}
}
// wir mergen die eben erstellten arrays und entfernen doppelte eintraege
$rec_id = array_unique($rec_id);
// hier gehen wir alle empfaenger durch, schreiben das in die db und schicken eine mail
$query = "INSERT INTO message_user (message_id, user_id, snd_rec, mkdate)\n VALUES (?, ?, 'rec', UNIX_TIMESTAMP())";
$insert = DBManager::get()->prepare($query);
$snd_name = $user_id != '____%system%____' ? User::find($user_id)->getFullName() . ' (' . User::find($user_id)->username . ')' : 'Stud.IP-System';
foreach ($rec_id as $one) {
$insert->execute(array($tmp_message_id, $one));
if ($GLOBALS['MESSAGING_FORWARD_AS_EMAIL']) {
// mail to original receiver
$mailstatus_original = $this->user_wants_email($one);
if ($mailstatus_original == 2 || $mailstatus_original == 3 && $email_request == 1 || $force_email) {
$this->sendingEmail($one, $snd_user_id, $message, $subject, $tmp_message_id);
}
}
if ($tags) {
foreach ($tags as $tag) {
$insert_tags->execute(array('message_id' => $tmp_message_id, 'user_id' => $one, 'tag' => strtolower($tag)));
}
}
}
// Obtain all users that should receive a notification
$user_ids = $rec_id;
if (is_object($GLOBALS['user'])) {
$user_ids = array_diff($user_ids, array($GLOBALS['user']->id));
}
// Create notifications
PersonalNotifications::add($user_ids, URLHelper::getUrl("dispatch.php/messages/read/{$tmp_message_id}", array('cid' => null)), sprintf(_('Sie haben eine Nachricht von %s erhalten!'), $snd_name), 'message_' . $tmp_message_id, Icon::create('mail', 'clickable')->asImagePath(80));
return sizeof($rec_id);
}
/**
* Sends the collected messages from sendingMail as e-mail.
*/
function bulkSend()
{
// if nothing to do, return
if (empty($this->bulk_mail)) {
return;
}
// send a mail, for each language one
foreach ($this->bulk_mail as $lang_data) {
foreach ($lang_data as $data) {
$mail = new StudipMail();
$mail->setSubject($data['title']);
foreach ($data['users'] as $user_id => $to) {
$mail->addRecipient($to, get_fullname($user_id), 'Bcc');
}
$mail->setReplyToEmail('')->setBodyText($data['text']);
if (strlen($data['reply_to'])) {
$mail->setSenderEmail($data['reply_to'])->setSenderName($snd_fullname);
}
$user_cfg = UserConfig::get($user_id);
if ($user_cfg->getValue('MAIL_AS_HTML')) {
$mail->setBodyHtml($mailhtml);
}
if ($GLOBALS["ENABLE_EMAIL_ATTACHMENTS"]) {
foreach (get_message_attachments($data['message_id']) as $attachment) {
$mail->addStudipAttachment($attachment['dokument_id']);
}
}
$mail->send();
}
}
}
