public static function sendSubscriptionVerificationTextMail($subscription)
{
$actions = array();
$delivery = array();
$users = new Default_Model_Researchers();
$subject = "EGI AppDB: Email subscription verification";
$body = "";
$nl = "\r\n";
$t = "\t";
//Find subscriber in researchers
$users->filter->id->equals($subscription->researcherid);
$users->refresh();
if (count($users->items) == 0) {
error_log("[appdb:Subscription Verification Email] : Could not find user with id = " . $subscription->researcherID . " . Delivery cancelled.");
return;
}
$user = $users->items[0];
//Get event types of subscriptions
if (NewsEventType::has($subscription->events, NewsEventType::E_INSERT) == true) {
$actions[] = "new software";
}
if (NewsEventType::has($subscription->events, NewsEventType::E_UPDATE) == true) {
$actions[] = "software updates";
}
if (NewsEventType::has($subscription->events, NewsEventType::E_INSERT_CONTACT) == true) {
$actions[] = "new contacts";
}
if (NewsEventType::has($subscription->events, NewsEventType::E_INSERT_COMMENT) == true) {
$actions[] = "new comments";
}
//Get delivery types of subscriptions
if (NewsDeliveryType::has($subscription->delivery, NewsDeliveryType::D_DAILY_DIGEST) == true) {
$delivery[] = "daily";
}
if (NewsDeliveryType::has($subscription->delivery, NewsDeliveryType::D_WEEKLY_DIGEST) == true) {
$delivery[] = "every monday";
}
if (NewsDeliveryType::has($subscription->delivery, NewsDeliveryType::D_MONTHLY_DIGEST) == true) {
$delivery[] = "every 1st day of the month";
}
$body = "Dear " . $user->firstName . " " . $user->lastName . "," . $nl . $nl;
$body .= "Your request to receive e-mail notifications about '" . $subscription->name . "' has been processed. " . $nl . $nl;
//Render actions (events)
$body .= "You will be notified for";
if (count($actions) == 1) {
$body .= " " . $actions[0];
} else {
$ac = count($actions);
for ($i = 0; $i < $ac; $i += 1) {
$body .= " " . $actions[$i];
if ($i == $ac - 2) {
$body .= ($ac > 2 ? "," : "") . " and";
} else {
if ($i < $ac - 1) {
$body .= ",";
}
}
}
}
$body .= "." . $nl;
//Render delivery
$body .= "The delivery of notifications will take place";
if (count($delivery) == 1) {
$body .= " " . $delivery[0];
} else {
$dc = count($delivery);
for ($i = 0; $i < $dc; $i += 1) {
$body .= " " . $delivery[$i];
if ($i == $dc - 2) {
$body .= ($dc > 2 ? "," : "") . " and";
} else {
if ($i < $dc - 1) {
$body .= ",";
}
}
}
}
$body .= "." . $nl . $nl;
$body .= 'If no new software registrations (or updates of existing software) occur within the given delivery time span, no e-mail will be sent.' . $nl . $nl;
$body .= "Sincerely," . $nl;
$body .= "EGI AppDB notifications service" . $nl;
$body .= "website: http://" . $_SERVER["APPLICATION_UI_HOSTNAME"] . "/";
//Get primary e-mail contact of subscriber and send e-mail
$rs = new Default_Model_Contacts();
$rs->filter->researcherid->equals($subscription->researcherid)->and($rs->filter->contacttypeid->equals(7))->and($rs->filter->isprimary->equals(true));
if (count($rs->refresh()->items) > 0) {
$to = $rs->items[0]->data;
//sendMultipartMail($subject, $to, $body,'', '*****@*****.**', 'enadyskolopassword');
EmailService::sendReport($subject, $to, $body);
error_log("[appdb:Subscription Verification Email]: Sending subscription verification to " . $to);
} else {
error_log("[appdb:Subscription Verification Email]: Cannot find a primary e-mail for user with id = " . $subscription->researcherid);
}
}
/**
* implementation of abstract parse() operation from RestXMLParser.
*
* @xml SimpleXMLElement the root element of the application XML representation
*
* @return Default_Model_Researcher
* @access public
*/
public function parse($xml)
{
if (!is_null($this->_user)) {
$person = new Default_Model_Researcher();
try {
$xml = new SimpleXMLElement($xml);
} catch (Exception $e) {
$this->_error = RestErrorEnum::RE_INVALID_REPRESENTATION;
$this->_extError = $e->getMessage();
return $person;
}
$xmli = $xml->xpath('//person:person');
if (count($xmli) === 0) {
$this->_error = RestErrorEnum::RE_INVALID_REPRESENTATION;
return $person;
}
$xml = $xmli[0];
if ($this->_parent->getMethod() === RestMethodEnum::RM_POST) {
if ($xml->attributes()->id) {
$person->id = strval($xml->attributes()->id);
} else {
$this->_error = RestErrorEnum::RE_INVALID_REPRESENTATION;
$this->_extError = 'Resource ID missing';
return $person;
}
}
if ($xml->attributes()->nodissemination) {
$person->noDissemination = strval($xml->attributes()->nodissemination) === "true" ? true : false;
}
if ($xml->attributes()->cname) {
$person->cname = strval($xml->attributes()->cname);
}
$firstname = $this->el($xml, "person:firstname");
if (!is_null($firstname) && trim(strval($firstname)) !== "") {
$person->firstName = trim(strval($firstname));
}
$lastname = $this->el($xml, "person:lastname");
if (!is_null($lastname) && trim(strval($lastname)) !== "") {
$person->lastName = trim(strval($lastname));
}
$gender = $this->el($xml, "person:gender");
if (!is_null($gender)) {
if (trim(strval($gender->attributes(RestAPIHelper::XMLNS_XSI())->nil)) === "true") {
$person->gender = 'n/a';
} elseif (trim(strval($gender)) !== "") {
if (trim(strtolower(strval($gender))) === "male") {
$person->gender = "male";
} elseif (trim(strtolower(strval($gender))) === "female") {
$person->gender = "female";
}
}
}
if ($this->_parent->getMethod() === RestMethodEnum::RM_PUT) {
$person->dateInclusion = date("Y-m-d");
$person->addedByID = $this->_parent->getUser()->id;
}
$person->lastUpdated = date('Y-m-d');
$institute = trim(strval($this->el($xml, "person:institute")));
if (!is_null($institute)) {
$person->institution = trim(strval($institute));
}
$country = $this->el($xml, "regional:country");
if (!is_null($country) && trim(strval($country->attributes()->id)) !== "") {
$person->countryID = trim(strval($country->attributes()->id));
}
$role = $this->el($xml, "person:role");
if (!is_null($role) && trim(strval($role->attributes()->id)) !== "") {
$person->positionTypeID = trim(strval($role->attributes()->id));
}
$image = $this->el($xml, "person:image");
$removeImageCache = false;
if (!is_null($image)) {
if (trim(strval($image->attributes(RestAPIHelper::XMLNS_XSI())->nil)) === "true") {
$person->clearImage();
$removeImageCache = true;
} else {
if (!is_null($image->attributes()->type) && trim(strval($image->attributes()->type)) === "base64") {
// image is given as byte64 encoded string
if (trim(strval($image)) != '') {
$person->image = pg_escape_bytea(trim(strval($image)));
$removeImageCache = true;
}
} else {
// image is given as URL
if (trim(parse_url(strval($image), PHP_URL_SCHEME)) == '') {
// no URL scheme present; assume uploaded file though
// portal's uploadimage action in AppsController
if (trim(strval($image)) != '') {
try {
$person->image = pg_escape_bytea(base64_encode(file_get_contents(APPLICATION_PATH . "/../public/" . trim(strval($image)))));
$removeImageCache = true;
} catch (Exception $e) {
$this->_error = RestErrorEnum::RE_BACKEND_ERROR;
$this->_extError = $e->getMessage();
return $person;
}
}
} else {
// URL scheme present; assume remote file
if (trim(strval($image)) != '') {
try {
$person->image = pg_escape_bytea(base64_encode(file_get_contents(trim(strval($image)))));
$removeImageCache = true;
} catch (Exception $e) {
$this->_error = RestErrorEnum::RE_BACKEND_ERROR;
$this->_extError = $e->getMessage();
return $person;
}
}
}
}
}
}
if ($removeImageCache === true) {
if ($person->id != '' && file_exists(APPLICATION_PATH . "/../cache/ppl-image-" . $person->id . ".png")) {
unlink(APPLICATION_PATH . "/../cache/ppl-image-" . $person->id . ".png");
}
}
$person->save();
if ($this->_parent->getMethod() === RestMethodEnum::RM_POST) {
//remove existing contact info
$conts = new Default_Model_Contacts();
$conts->filter->researcherid->equals($person->id);
$conts->refresh();
for ($i = count($conts->items) - 1; $i >= 0; $i--) {
$conts->remove($conts->items[$i]);
}
}
//add new contact info
$cts = new Default_Model_ContactTypes();
$cts->refresh();
$xmli = $xml->xpath("//person:contact");
$conts2 = new Default_Model_Contacts();
foreach ($xmli as $x) {
if (trim(strval($x)) !== '') {
$cont = new Default_Model_Contact();
$cont->researcherID = $person->id;
$ct = trim(strval($x->attributes()->type));
$ctid = null;
for ($i = 0; $i < count($cts->items); $i++) {
if (strtolower($ct) == strtolower($cts->items[$i]->description)) {
$ctid = $cts->items[$i]->id;
break;
}
}
if (!is_null($ctid)) {
$cont->contactTypeID = $ctid;
} else {
$cont->contactTypeID = 7;
//e-mail by default
}
$cont->data = trim(strval($x));
if (strval($x->attributes()->primary) === "true") {
$cont->isPrimary = true;
}
$conts2->filter->data->equals($cont->data)->and($conts2->filter->contacttypeid->equals(7))->and($conts2->filter->researcherid->notequals($person->id));
$conts2->refresh("xml");
if (count($conts2->items) == 0) {
$cont->save();
} else {
$this->_error = RestErrorEnum::RE_BACKEND_ERROR;
$this->_extError = "e-mail address `" . $cont->data . "' already exists";
return $person;
}
}
}
if ($this->_parent->getMethod() === RestMethodEnum::RM_POST || $this->_parent->getMethod() === RestMethodEnum::RM_PUT) {
$xrels = $xml->xpath("person:relation");
$ps = new Default_Model_Researchers();
$ps->filter->id->equals($person->id);
$p = null;
if (count($ps->items) > 0) {
$p = $ps->items[0];
}
if ($p !== null) {
$rels = array();
if (count($xml->xpath('person:relation[@xsi:nil="true"]')) === 0) {
foreach ($xrels as $x) {
$targuid = trim(strval($x->attributes()->targetguid));
$subguid = trim(strval($x->attributes()->subjectguid));
$rel = array("id" => trim(strval($x->attributes()->id)), "parentid" => trim(strval($x->attributes()->parentid)));
if ($targuid === "") {
$rel["subjectguid"] = $subguid;
} else {
if ($subguid === "") {
$rel["targetguid"] = $targuid;
}
}
if ($rel["parentid"] === "") {
$rel["parentid"] = null;
}
$rels[] = $rel;
}
}
try {
$res = PersonRelations::syncRelations($p->guid, $this->_user->id, $rels);
} catch (Exception $ex) {
$res = $ex->getMessage();
}
if (is_string($res)) {
$this->_error = RestErrorEnum::RE_BACKEND_ERROR;
$this->_extError = $res;
return $p;
}
}
}
}
$this->_error = RestErrorEnum::RE_OK;
return $person;
}
public function loginAction()
{
/* Check whether the user is already logged in */
if ($this->session->userid !== null) {
if (!$this->handle_actions()) {
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender();
header('Location: https://' . $_SERVER['HTTP_HOST'] . '/');
}
return;
}
$this->view->session = $this->session;
$ldap = ApplicationConfiguration::service('egi.ldap.host');
if (array_key_exists('username', $_POST)) {
$this->view->username = $_POST['username'];
$username = "******" . $_POST['username'] . ",ou=People,dc=egi,dc=eu";
$password = $_POST['password'];
$ds = $this->initLDAP(true, $username, $password);
if (is_resource($ds)) {
@ldap_close($ds);
$username = $_POST['username'];
$this->session->username = $username;
$users = new Default_Model_Researchers();
$users->viewModerated = true;
$users->filter->username->equals($username);
if ($users->count() == 1) {
if (!$users->items[0]->deleted) {
$this->session->userid = $users->items[0]->Id;
$this->session->userRole = $users->items[0]->positionTypeID;
$this->session->userCountryID = $users->items[0]->countryID;
$this->session->userCountryName = $users->items[0]->country->name;
$this->session->user = $users->items[0];
$this->session->fullName = $users->items[0]->firstName . " " . $users->items[0]->lastName;
$this->session->cname = $users->items[0]->cname;
setAuthCookies($username, md5($password));
$user = $users->items[0];
$user->lastLogin = time();
$user->password = md5($password);
// TODO: remove this when SAML has been implemented
$user->save();
$this->saveUserCredentials($user->id, md5($password));
// TODO: replace with SAML Auth token
$this->handle_actions();
} else {
$this->view->accountDeleted = true;
error_log(var_export($users->items[0]->delInfo, true));
$this->view->accountDeleter = $users->items[0]->delInfo->deleter->name;
$this->view->accountDeleterID = $users->items[0]->delInfo->deleter->id;
$this->view->accountDeletedOn = $users->items[0]->delInfo->deletedOn;
}
} else {
$this->session->claimPassword = md5($password);
$ds = $this->initLDAP(true);
// no rdn/pwd: root connection
if ($ds !== false) {
$users2 = new Default_Model_Contacts();
$sr = ldap_search($ds, "ou=people,dc=egi,dc=eu", "(uid=" . $_POST['username'] . ")");
$info = ldap_get_entries($ds, $sr);
ldap_close($ds);
if ($info["count"] > 0) {
$this->session->fullName = $info[0]['cn'][0];
$users2->filter->data->ilike($info[0]['mail'][0]);
if ($users2->refresh()->count() != 0) {
// Found existing profiles
$ids = array();
for ($i = 0; $i < $users2->count(); $i++) {
$ids[] = $users2->items[$i]->researcherid;
}
$users->viewModerated = false;
$users->filter->id->in($ids);
$users->refresh();
$entries = array();
$canClaim = array();
for ($i = 0; $i < $users->count(); $i++) {
$entries[] = $users->items[$i];
$canClaim[] = $users->items[$i]->id;
}
$this->view->entries = $entries;
$this->session->canClaim = $canClaim;
} else {
// Create a new profile
$roleTypeID = 3;
if (array_key_exists('usercertificatesubject', $info[0])) {
$sub = explode('/', $info[0]['usercertificatesubject'][0]);
foreach ($sub as $s) {
if (substr($s, 0, 2) == 'C=') {
$country = substr($s, 2);
$cs = new Default_Model_Countries();
$cs->filter->isocode->equals($country);
if ($cs->count() > 0) {
$this->view->country = $cs->items[0]->name;
}
break;
}
}
}
if (array_key_exists('sn', $info[0])) {
$this->view->lastname = $info[0]['sn'][0];
$this->view->firstname = str_replace($info[0]['sn'][0], "", $info[0]['cn'][0]);
}
if (array_key_exists('destinationindicator', $info[0])) {
$this->view->gender = $info[0]['destinationindicator'][0];
}
if (array_key_exists('ou', $info[0])) {
$this->view->institute = $info[0]['ou']['0'];
}
if (array_key_exists('employeetype', $info[0])) {
if ($info[0]['employeetype'][0] == "Experienced researcher" || $info[0]['employeetype'][0] == "Management") {
$roleTypeID = 2;
} else {
if ($info[0]['employeetype'][0] == "Technical Support" || $info[0]['employeetype'][0] == "PhD Student") {
$roleTypeID = 3;
} else {
$roleTypeID = 4;
}
}
}
if (array_key_exists('mail', $info[0])) {
$this->view->SSOmail = $info[0]['mail'][0];
}
$pts = new Default_Model_PositionTypes();
$pts->filter->id->equals($roleTypeID);
$this->view->roleType = $pts->items[0]->description;
$contactTypes = new Default_Model_ContactTypes();
$this->view->contactTypes = $contactTypes->refresh();
}
}
} else {
error_log($this->view->ldapError);
}
}
} else {
error_log($this->view->ldapError);
}
}
}
public function updateAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender();
$hasEditRights = false;
$entries = new Default_Model_Researchers();
if ($this->session->userid !== null) {
// there is a user logged in
$users = new Default_Model_Researchers();
$users->filter->id->equals($this->session->userid);
$user = $users->items[0];
if ($_POST['id'] == '') {
// logged in user registering another user (e.g. a manager registering someone else)
if (userIsAdminOrManager($this->session->userid)) {
$entry = new Default_Model_Researcher();
//prepare new entry
$entry->dateInclusion = date("Y-m-d");
$entry->addedBy = $this->session->userid;
$hasEditRights = true;
} else {
$hasEditRights = false;
}
// logged in user has no permission to register other users
} else {
$entry = $entries->item($_POST['id']);
// this is an update, get existing data
$hasEditRights = $user->privs->canEditPersonProfile($entry);
}
} else {
if ($this->session->username !== null) {
// no user logged in, but new user registering own self
$entry = new Default_Model_Researcher();
//prepare new entry
$entry->dateInclusion = date("Y-m-d");
$entry->username = $this->session->username;
$entry->lastLogin = time();
$entry->password = $this->session->claimPassword;
setAuthCookies($this->session->username, $this->session->claimPassword);
$this->session->claimPassword = null;
$hasEditRights = true;
}
}
if ($hasEditRights) {
$entry->lastName = $_POST['lastName'];
$entry->firstName = $_POST['firstName'];
$entry->gender = $_POST['gender'];
$entry->institution = $_POST['institution'];
$oldCountryID = $entry->countryID;
$entry->countryID = $_POST['countryID'];
$oldRoleID = $entry->positionTypeID;
$entry->positionTypeID = $_POST['positionTypeID'];
if ($_POST['newimage'] !== "") {
$imgfile = APPLICATION_PATH . "/../public/" . $_POST['newimage'];
if (file_exists(APPLICATION_PATH . "/../cache/ppl-image-" . $entry->id . ".png")) {
unlink(APPLICATION_PATH . "/../cache/ppl-image-" . $entry->id . ".png");
}
$entry->image = pg_escape_bytea(base64_encode(file_get_contents($imgfile)));
}
if ($this->session->userid === null) {
$entries->add($entry);
$this->session->userid = $entry->id;
$this->session->user = $entry;
$this->session->fullname = $entry->firstname . " " . $entry->lastname;
} else {
if ($_POST['id'] == '') {
$entries->add($entry);
$this->session->lastPplID = $entry->id;
} else {
$entry->save();
}
}
$entries->filter->id->equals($entry->id);
$found_new_entry = false;
$search_new_entry_count = 0;
while (!$found_new_entry || $search_new_entry_count > 10) {
$entries->refresh();
$found_new_entry = count($entries->items) > 0;
if (!$found_new_entry) {
sleep(1);
}
$search_new_entry_count = $search_new_entry_count + 1;
}
if (!$found_new_entry) {
error_log("Could not find new user entry in DB after 10 tries... This should not happen (userid: " . $entry->id . ")");
return;
}
$entry = $entries->items[0];
$ant = 'his/her';
if (!isnull($entry->gender)) {
if ($entry->gender == 'male') {
$ant = 'his';
}
if ($entry->gender == 'female') {
$ant = 'her';
}
}
$conts = new Default_Model_Contacts();
$conts->refresh();
for ($i = count($entry->contacts) - 1; $i >= 0; $i--) {
$conts->remove($entry->contacts[$i]);
}
foreach ($_POST as $key => $value) {
if (substr($key, 0, 7) === "contact" && substr($key, 0, 11) !== "contactType") {
$cnum = substr($key, 7);
$cont = new Default_Model_Contact();
$cont->researcherID = $entry->id;
$cont->data = $value;
$cont->contactTypeID = $_POST['contactType' . $cnum];
$conts->add($cont);
}
}
}
if ($entry && ($this->session->userid == null || $this->session->userid == $entry->id)) {
$this->session->userid = $entry->id;
//Reload session data in case of claim or save new account
$ppl = new Default_Model_Researchers();
$ppl->filter->id->equals($this->session->userid);
$user = $ppl->items[0];
$this->session->user = $user;
$this->session->fullname = $user->firstname . " " . $user->lastname;
$this->session->userRole = $user->positionTypeID;
$this->session->userCountryID = $user->countryID;
$this->session->userCountryName = $user->country->name;
$this->session->cname = $user->cname;
}
}
