function churchcal_handleMeetingRequest($cal_id, $params) { global $base_url, $user; $i = new CTInterface(); $i->setParam("cal_id"); $i->setParam("person_id"); $i->setParam("mailsend_date"); $i->setParam("event_date"); $dt = new DateTime(); foreach ($params["meetingRequest"] as $id => $param) { $param["mailsend_date"] = $dt->format('Y-m-d H:i:s'); $param["person_id"] = $id; $param["event_date"] = $params["startdate"]; $param["cal_id"] = $cal_id; $db = db_query('select mr.*, c.modified_pid from {cc_meetingrequest} mr, {cc_cal} c where c.id=mr.cal_id and mr.person_id=:person_id and mr.cal_id=:cal_id', array(":person_id" => $param["person_id"], ":cal_id" => $param["cal_id"]))->fetch(); if ($db == false) { db_insert("cc_meetingrequest")->fields($i->getDBInsertArrayFromParams($param))->execute(false); $txt = "<h3>Hallo [Spitzname]!</h3><p>"; $txt .= "<P>Du wurdest auf " . variable_get('site_name', 'ChurchTools'); $txt .= ' von <i>' . $user->vorname . " " . $user->name . "</i>"; $txt .= " für einen Termin angefragt. "; $db = db_query("select if (password is null and loginstr is null and lastlogin is null,1,0) as invite from {cdb_person}\n where id=:id", array(":id" => $id))->fetch(); if ($db !== false) { if ($db->invite == 1) { include_once CHURCHDB . '/churchdb_ajax.php'; churchdb_invitePersonToSystem($id); $txt .= "Da Du noch nicht kein Zugriff auf das System hast, bekommst Du noch eine separate E-Mail, mit der Du Dich dann anmelden kannst!"; } $txt .= "<p>Zum Zu- oder Absagen bitte hier klicken:"; $loginstr = churchcore_createOnTimeLoginKey($id); $txt .= '<p><a href="' . $base_url . '?q=home&id=' . $id . '&loginstr=' . $loginstr . '" class="btn btn-primary">%sitename aufrufen</a>'; churchcore_sendEMailToPersonids($id, "[" . variable_get('site_name', 'ChurchTools') . "] Neue Termin-Anfrage", $txt, null, true); } } else { /* db_update("cc_meetingrequest") ->fields($i->getDBInsertArrayFromParams($param)) ->condition("person_id", $param["person_id"], "=") ->condition("cal_id", $param["cal_id"], "=") ->execute(false); churchcore_sendEMailToPersonids($id, "[".variable_get('site_name', 'ChurchTools')."] Anpassung in einer Termin-Anfrage", "anpassung", null, true);*/ } } }
/** * * @param array $params * @throws CTException */ public function sendEMail($params) { global $user; include_once './' . CHURCHDB . '/churchdb_db.php'; $groups = churchdb_getMyGroups($user->id, true, false); if (empty($groups[$params["groupid"]])) { throw new CTException("Group is not allowed!"); } $ids = churchdb_getAllPeopleIdsFromGroups(array($params["groupid"])); churchcore_sendEMailToPersonids(implode(",", $ids), "[" . variable_get('site_name', 'ChurchTools') . "] Nachricht von {$user->vorname} {$user->name}", $params["message"], null, true); }