private static function getRecipients() { return array(EmailConfiguration::getSupportAddress()); }
public static function sendMessages($isReminder = false) { $items = db()->query("SELECT * FROM nonvalidated_apps_per_owner")->fetchAll(); foreach ($items as $item) { $text = ""; $body = ""; if (is_null($item["contact"])) { error_log("[OutdatedApps]: No contact info for " . $item["ownerid"] . ":" . $item["firstname"] . " " . $item["lastname"]); //TODO: Case where the owner of the application has no contact point continue; } $recipients = array($item["contact"]); $subject = "Notification:"; if (isnull($item["lastsent"]) == false) { $subject = "Reminder:"; } $subject .= "EGI AppDB outdated software profile"; $appids = $item["appids"]; $appids = explode(";", $appids); $appnames = $item["appnames"]; $appnames = explode(";", $appnames); if (count($appids) == 0) { continue; } if (count($appids) == 1) { $template = self::getTemplateBody($item["firstname"] . " " . $item["lastname"]); $body = preg_replace("/\\[1\\]/", "<a href='http://" . $_SERVER["APPLICATION_UI_HOSTNAME"] . "?p=" . base64_encode("/apps/details?id=" . $appids[0]) . "' target='_blank'>" . $appnames[0] . "</a>", $template); $body = preg_replace("/\\[2\\]/", "<a href='http://" . $_SERVER["APPLICATION_UI_HOSTNAME"] . "' target='_blank'>EGI Applications Database</a>", $body); $body = "<html><head></head><body><pre>" . $body . "</pre></body></html>"; $text = preg_replace("/\\[1\\]/", "" . $appnames[0] . " [1]", $template); $text = preg_replace("/\\[2\\]/", "EGI Applications Database [2]", $text); $text .= "\n\n________________________________________________________________________________________________________\n"; $text .= "[1]. http://" . $_SERVER["APPLICATION_UI_HOSTNAME"] . "?p=" . base64_encode("/apps/details?id=" . $appids[0]) . "\n"; $text .= "[2]. http://" . $_SERVER["APPLICATION_UI_HOSTNAME"]; } else { $template = self::getTemplateListBody($item["firstname"] . " " . $item["lastname"]); $listpermalink = "http://" . $_SERVER["APPLICATION_UI_HOSTNAME"] . "?p=" . base64_encode('{"url":"/apps","query":{"flt":"=application.owner:' . $item["ownerid"] . ' +=application.validated:false"},"ext":{"isBaseQuery":true,"append":true,"filterDisplay":"Search outdated...","mainTitle":"Outdated entries"}}'); $body = preg_replace("/\\[1\\]/", "<a href='" . $listpermalink . "' target='_blank'>software</a>", $template); $body = preg_replace("/\\[2\\]/", "<a href='http://" . $_SERVER["APPLICATION_UI_HOSTNAME"] . "' target='_blank'>EGI Applications Database</a>", $body); $body = "<html><head></head><body><pre>" . $body . "</pre></body></html>"; $text = preg_replace("/\\[1\\]/", "software [1]", $template); $text = preg_replace("/\\[2\\]/", "EGI Applications Database [2]", $text); $text .= "\n\n________________________________________________________________________________________________________\n"; $text .= "[1]. " . $listpermalink . " \n"; $text .= "[2]. http://" . $_SERVER["APPLICATION_UI_HOSTNAME"]; $bodylist = ""; $textlist = ""; //Make unique arrays of application ids and names $unames = array(); $uids = array(); for ($i = 0; $i < count($appids); $i += 1) { if (in_array($appids[$i], $uids) === false) { $uids[] = $appids[$i]; $unames[] = $appnames[$i]; } } $appids = $uids; $appnames = $unames; for ($i = 0; $i < count($appids); $i += 1) { $bodylist .= "<div style='padding-left:10px;'>-<a href='http://" . $_SERVER["APPLICATION_UI_HOSTNAME"] . "?p=" . base64_encode("/apps/details?id=" . $appids[$i]) . "' target='_blank'>" . $appnames[$i] . "</a></div>"; $textlist .= "\t- " . $appnames[$i] . "\n"; } $body = preg_replace("/\\[\\*\\]/", $bodylist, $body); $text = preg_replace("/\\[\\*\\]/", $textlist, $text); } if (ApplicationConfiguration::isProductionInstance() === FALSE) { error_log("SENDING OUTDATED TO:"); error_log("SUBJECT:" . $subject); error_log("RECIPIENTS: " . var_export($recipients, true)); error_log("BODY: " . $text); echo "<div style='background-color:lightgrey;border:1px solid black'><b>subject:</b>" . $subject . "</div><div style='background-color:lightgrey;margin-bottom:10px;border:1px solid black'><b>TO:</b>" . implode(",", $recipients) . "</div><div style='background-color:lightgreen;border:1px solid black;'>" . $body . "</div><div style='background-color:#99DBFF;margin-bottom:10px;border:1px solid black'><pre>" . $text . "</pre></div>"; } else { //sendMultipartMail($subject,$recipients,$text,$body,'*****@*****.**','enadyskolopassword','*****@*****.**',null, false,array("Precedence"=>"bulk")); EmailService::sendBulkReport($subject, $recipients, $text, $body, EmailConfiguration::getSupportAddress()); } } if (APPLICATION_ENV === "production") { db()->query("INSERT INTO app_validation_log (appid) SELECT DISTINCT id FROM applications, (SELECT string_to_array(array_to_string(array_agg(array_to_string(ids,',')),','),',') as ids FROM (SELECT string_to_array(appids, ';') as ids FROM (SELECT * FROM nonvalidated_apps_per_owner) AS t) as tt) as ttt WHERE id::text = ANY(ttt.ids)")->fetchAll(); } return true; }
public function feedbackAction() { $this->_helper->layout->disableLayout(); if ($_SERVER["REQUEST_METHOD"] == "GET") { $this->view->src = isset($_GET["src"]) ? $_GET["src"] : null; $this->view->username = ""; $this->view->contacts = array(); if ($this->session->userid !== null) { $this->view->username = $this->session->fullName; $cnts = new Default_Model_Contacts(); $cnts->filter->researcherid->equals($this->session->userid)->and($cnts->filter->contacttypeid->equals(7)); if (count($cnts->items) > 0) { $this->view->contacts = $cnts->items; } } else { $this->view->captcha = $this->generateCaptchaForm(); } } else { if ($_SERVER["REQUEST_METHOD"] == "POST") { $this->_helper->viewRenderer->setNoRender(); $feedback = isset($_POST["feedback"]) && trim($_POST["feedback"]) !== "" ? $_POST["feedback"] : ""; $subject = isset($_POST["subject"]) && trim(stripslashes($_POST["subject"])) !== "" ? stripslashes($_POST["subject"]) : "<no subject>"; $email = isset($_POST["email"]) && trim(stripslashes($_POST["email"])) !== "" ? stripslashes($_POST["email"]) : ""; $cc = isset($_POST["cc"]) && trim($_POST["cc"]) !== "" ? $_POST["cc"] : false; $name = isset($_POST["name"]) && trim($_POST["name"]) !== "" ? $_POST["name"] : "anonymous"; $captchaid = isset($_POST["captchaid"]) && trim($_POST["captchaid"]) !== "" ? $_POST["captchaid"] : ""; $captcha = isset($_POST["captcha"]) && trim($_POST["captcha"]) !== "" ? $_POST["captcha"] : ""; header("Content-type: text/xml; charset=utf-8"); echo '<' . '?xml version="1.0"?' . '>'; if ($feedback == "") { echo "<response error='no feedback given' group='feedback'></response>"; return; } if ($email == "") { echo "<response error='no email given' group='email'></response>"; return; } $bodyheader = "----------------------------------------------------------------------------\n"; $bodyheader .= "Feedback from user: "******" " . ($this->session->userid !== null ? "(id:" . $this->session->userid . ")" : "") . " \n"; $bodyheader .= "User email: " . $email . " \n"; $bodyheader .= "----------------------------------------------------------------------------\n\n"; //Make receivers array if (strpos($email, ";") !== false) { $emailto = explode(";", $email); $email = array(); for ($i = 0; $i < count($emailto); $i += 1) { $emailto[$i] = trim($emailto[$i]); if ($emailto[$i] !== "") { $email[] = $emailto[$i]; } } } else { $email = array($email); } //Validate email format for ($i = 0; $i < count($email); $i += 1) { if (!preg_match('/^([0-9a-z]+[-._+&])*[0-9a-z]+@([-0-9a-z]+[.])+[a-z]{2,6}$/i', $email[$i])) { echo "<response error='Email " . $email[$i] . " is invalid' group='email'></response>"; return; } } $body = base64_decode($feedback); $body = stripslashes($body); if (trim($body) == "") { echo "<response error='no feedback given' group='feedback'></response>"; return; } if (preg_match("/(\r|\n)(to:|from:|cc:|bcc:)/i", $body)) { echo "<response error='Message body contains invalid headers' group='feedback'></response>"; return; } if ($this->session->userid === null) { if (trim($captchaid) == "" && trim($captcha) == "") { echo "<response error='Must login first to send message'></response>"; return; } $sessionkey = "Zend_Form_Captcha_" . $captchaid; if (isset($_SESSION[$sessionkey]) && isset($_SESSION[$sessionkey]["word"]) && $_SESSION[$sessionkey]["word"] == $captcha) { } else { echo "<response error='Security word is wrong' group='captcha'></response>"; return; } } $subject = "[AppDB Portal Feedback]: " . $subject; $body = $bodyheader . $body; //Send email $recs = array(EmailConfiguration::getSupportAddress()); $ccemails = false; if ($cc == true) { $ccemails = $email; } //sendMultipartMail($subject,$recs, $body, '', '*****@*****.**', 'enadyskolopassword', $email[0], null, $ccemails); EmailService::sendReport($subject, $recs, $body, '', $email[0], null, $ccemails); $to = ""; foreach ($email as $e) { if (trim($to) !== "") { $to .= ";"; } $to .= $e; } echo "<response to='" . htmlspecialchars($to, ENT_QUOTES) . "' subject='" . htmlspecialchars($subject, ENT_QUOTES) . "' cc='" . $cc . "' >" . htmlspecialchars($body, ENT_QUOTES) . "</response>"; } } }
private static function sendConfirmationEmail($session, $pending) { $researcher = $pending->getResearcher(); $email = $researcher->getPrimaryContact(); $accounttype = str_replace("-", " ", trim($pending->accountType)); $accountname = trim($pending->accountName) === "" ? $pending->accountID : $pending->accountName; $res = "Dear " . $researcher->name . ",\n\n"; $res .= " a request has been made to connect the " . $accounttype . " account of " . $accountname . "\n"; $res .= "to your profile in the EGI Applications Database [1].\n"; $res .= "If it is really you the one that made this request and you wish to proceed with the account connection\n"; $res .= " - go to the EGI Applications Database Portal[1] and\n"; $res .= " - sign in with the same " . $accounttype . " account.\n"; $res .= "The system will prompt you with a form where you should enter the confirmation code bellow:\n\n"; $res .= " Confirmation Code: " . $pending->code . "\n\n"; $res .= "Note: The confirmation code expires 30 minutes after this message was sent.\n\n"; $res .= "If you are not the one that made this request, then please report the incident by replying to this message.\n\n"; $res .= "Best regards,\n"; $res .= "EGI AppDB team\n"; $res .= "\n\n__________________________________________________\n"; $res .= "[1]. http://" . $_SERVER["APPLICATION_UI_HOSTNAME"]; $subject = "EGI AppDB: Request to connect " . $accounttype . " account to your profile"; $text = $res; $body = $body = preg_replace("/\n/", "<br/>", $res); $body = "<div>" . $body . "</div>"; //DEVELOPMENT CODE if (ApplicationConfiguration::isProductionInstance() === FALSE) { error_log("\nSending to: " . $email); error_log("\n\n" . $res); } $recipients = array($email); //sendMultipartMail($subject,$recipients,$text,$body,'*****@*****.**','enadyskolopassword','*****@*****.**',null, false,array("Precedence"=>"bulk")); EmailService::sendBulkReport($subject, $recipients, $text, $body, EmailConfiguration::getSupportAddress()); }
private static function mailDispatchReport($recipients, $filename, $folder) { $reportcsv = file_get_contents($folder . $filename . ".csv"); if ($reportcsv === false) { error_log("[SocialReport::mailDispatch]: Could not load report " . $filename); return false; } $subject = "EGI AppDB Social media sharing report (" . date('Y') . "-" . date('m') . "-" . date('d') . ")"; $sbody = "This is an automatically generated report for social media sharing count per registered software item."; $sbody = $sbody . "Please find attached a CSV file containing the report.<br/>"; $sbody = $sbody . "You can access this report at http://" . $_SERVER['APPLICATION_UI_HOSTNAME'] . "/reports/social/" . $filename . ".csv <br/><br/>"; $sbody = $sbody . "Regards,<br/>"; $sbody = $sbody . "EGI AppDB Team"; $textsbody = simpleHTML2Text($sbody); $att = array("data" => $reportcsv, "type" => "application/vnd.ms-excel", "name" => $filename . ".csv"); //sendMultipartMail($subject, $recipients, $textsbody, $sbody, '*****@*****.**', 'enadyskolopassword', '*****@*****.**',$att, false,array("Precedence"=>"bulk")); EmailService::sendBulkReport($subject, $recipients, $textsbody, $sbody, EmailConfiguration::getSupportAddress(), $att); }