/**
* Get an array of SearchEntry objects representing expired, unsaved searches.
*
* @access public
* @param int $daysOld Age in days of an "expired" search.
* @return array Matching SearchEntry objects.
*/
function getExpiredSearches($daysOld = 2)
{
// Determine the expiration date:
$expirationDate = date('Y-m-d', time() - $daysOld * 24 * 60 * 60);
// Find expired, unsaved searches:
$sql = 'SELECT * FROM search WHERE saved=0 AND created<"' . $expirationDate . '"';
$s = new SearchEntry();
$s->query($sql);
$searches = array();
if ($s->N) {
while ($s->fetch()) {
$searches[] = clone $s;
}
}
return $searches;
}
function __construct($subAction = false, $record_id = null)
{
global $interface;
global $configArray;
global $library;
global $timer;
global $user;
//Check to see if a user is logged in with admin permissions
if ($user && $user->hasRole('genealogyContributor')) {
$interface->assign('userIsAdmin', true);
} else {
$interface->assign('userIsAdmin', false);
}
$searchSource = isset($_REQUEST['searchSource']) ? $_REQUEST['searchSource'] : 'local';
//Load basic information needed in subclasses
if ($record_id == null || !isset($record_id)) {
$this->id = $_GET['id'];
} else {
$this->id = $record_id;
}
// Setup Search Engine Connection
// Include Search Engine Class
require_once ROOT_DIR . '/sys/' . $configArray['Genealogy']['engine'] . '.php';
$timer->logTime('Include search engine');
// Initialise from the current search globals
$this->db = SearchObjectFactory::initSearchObject($configArray['Genealogy']['searchObject']);
$this->db->init($searchSource);
// Retrieve Full Marc Record
if (!($record = $this->db->getRecord('person' . $this->id))) {
PEAR_Singleton::raiseError(new PEAR_Error('Record Does Not Exist'));
}
$this->record = $record;
//Load person from the database to get additional information
$person = Person::staticGet('personId', $this->id);
$record['picture'] = $person->picture;
$interface->assign('record', $record);
$interface->assign('person', $person);
$this->recordDriver = RecordDriverFactory::initRecordDriver($record);
$timer->logTime('Initialized the Record Driver');
$marriages = array();
$personMarriages = $person->marriages;
if (isset($personMarriages)) {
foreach ($personMarriages as $marriage) {
$marriageArray = (array) $marriage;
$marriageArray['formattedMarriageDate'] = $person->formatPartialDate($marriage->marriageDateDay, $marriage->marriageDateMonth, $marriage->marriageDateYear);
$marriages[] = $marriageArray;
}
}
$interface->assign('marriages', $marriages);
$obituaries = array();
$personObituaries = $person->obituaries;
if (isset($personObituaries)) {
foreach ($personObituaries as $obit) {
$obitArray = (array) $obit;
$obitArray['formattedObitDate'] = $person->formatPartialDate($obit->dateDay, $obit->dateMonth, $obit->dateYear);
$obituaries[] = $obitArray;
}
}
$interface->assign('obituaries', $obituaries);
//Do actions needed if this is the main action.
$interface->assign('id', $this->id);
// Retrieve User Search History
$interface->assign('lastsearch', isset($_SESSION['lastSearchURL']) ? $_SESSION['lastSearchURL'] : false);
$this->cacheId = 'Person|' . $_GET['id'] . '|' . get_class($this);
// Send down text for inclusion in breadcrumbs
$interface->assign('breadcrumbText', $this->recordDriver->getBreadcrumb());
$formattedBirthdate = $person->formatPartialDate($person->birthDateDay, $person->birthDateMonth, $person->birthDateYear);
$interface->assign('birthDate', $formattedBirthdate);
$formattedDeathdate = $person->formatPartialDate($person->deathDateDay, $person->deathDateMonth, $person->deathDateYear);
$interface->assign('deathDate', $formattedDeathdate);
//Setup next and previous links based on the search results.
if (isset($_REQUEST['searchId'])) {
//rerun the search
$s = new SearchEntry();
$s->id = $_REQUEST['searchId'];
$interface->assign('searchId', $_REQUEST['searchId']);
$currentPage = isset($_REQUEST['page']) ? $_REQUEST['page'] : 1;
$interface->assign('page', $currentPage);
$s->find();
if ($s->N > 0) {
$s->fetch();
$minSO = unserialize($s->search_object);
$searchObject = SearchObjectFactory::deminify($minSO);
$searchObject->setPage($currentPage);
//Run the search
$result = $searchObject->processSearch(true, false, false);
//Check to see if we need to run a search for the next or previous page
$currentResultIndex = $_REQUEST['recordIndex'] - 1;
$recordsPerPage = $searchObject->getLimit();
if ($currentResultIndex % $recordsPerPage == 0 && $currentResultIndex > 0) {
//Need to run a search for the previous page
$interface->assign('previousPage', $currentPage - 1);
$previousSearchObject = clone $searchObject;
$previousSearchObject->setPage($currentPage - 1);
$previousSearchObject->processSearch(true, false, false);
$previousResults = $previousSearchObject->getResultRecordSet();
} else {
if (($currentResultIndex + 1) % $recordsPerPage == 0 && $currentResultIndex + 1 < $searchObject->getResultTotal()) {
//Need to run a search for the next page
$nextSearchObject = clone $searchObject;
$interface->assign('nextPage', $currentPage + 1);
$nextSearchObject->setPage($currentPage + 1);
$nextSearchObject->processSearch(true, false, false);
$nextResults = $nextSearchObject->getResultRecordSet();
}
}
if (PEAR_Singleton::isError($result)) {
//If we get an error excuting the search, just eat it for now.
} else {
if ($searchObject->getResultTotal() < 1) {
//No results found
} else {
$recordSet = $searchObject->getResultRecordSet();
//Record set is 0 based, but we are passed a 1 based index
if ($currentResultIndex > 0) {
if (isset($previousResults)) {
$previousRecord = $previousResults[count($previousResults) - 1];
} else {
$previousRecord = $recordSet[$currentResultIndex - 1 - ($currentPage - 1) * $recordsPerPage];
}
$interface->assign('previousId', $previousRecord['id']);
//Convert back to 1 based index
$interface->assign('previousIndex', $currentResultIndex - 1 + 1);
$interface->assign('previousTitle', $previousRecord['title']);
}
if ($currentResultIndex + 1 < $searchObject->getResultTotal()) {
if (isset($nextResults)) {
$nextRecord = $nextResults[0];
} else {
$nextRecord = $recordSet[$currentResultIndex + 1 - ($currentPage - 1) * $recordsPerPage];
}
$interface->assign('nextId', $nextRecord['id']);
//Convert back to 1 based index
$interface->assign('nextIndex', $currentResultIndex + 1 + 1);
$interface->assign('nextTitle', $nextRecord['title']);
}
}
}
}
$timer->logTime('Got next/previous links');
}
}
/**
* Anonymize user account by updating username to a random string
* and setting other user object fields (besides id) to their default values.
* User comments are preserved. Catalog accounts, due date reminders,
* saved searches and lists are deleted.
*
* @return boolean True on success
*/
public function anonymizeAccount()
{
$conn = $this->getDatabaseConnection();
$res = $conn->query("START TRANSACTION");
try {
// Delete catalog accounts
$account = new User_account();
$account->user_id = $this->id;
if ($account->find(false)) {
while ($account->fetch()) {
$account->delete();
}
}
// Delete due date reminders
$reminder = new Due_date_reminder();
$reminder->user_id = $this->id;
if ($reminder->find(false)) {
while ($reminder->fetch()) {
$reminder->delete();
}
}
// Delete lists (linked user_resource objects cascade)
$list = new User_list();
$list->user_id = $this->id;
if ($list->find(false)) {
while ($list->fetch()) {
$list->delete();
}
}
// Delete saved searches
$search = new SearchEntry();
$search->user_id = $this->id;
if ($search->find(false)) {
while ($search->fetch()) {
$search->delete();
}
}
// Anonymize user object
$this->username = '******' . uniqid();
$this->password = '';
$this->firstname = '';
$this->lastname = '';
$this->email = '';
$this->cat_username = '******';
$this->cat_password = '******';
$this->college = '';
$this->major = '';
$this->home_library = '';
$this->language = '';
$this->due_date_notification = 0;
$this->due_date_reminder = 0;
$this->authMethod = 'null';
$this->update();
} catch (Exception $e) {
$conn->query("ROLLBACK");
throw $e;
return false;
}
$conn->query("COMMIT");
return true;
}
/**
* Get an array of SearchEntry objects representing expired, unsaved searches.
*
* @param int $daysOld Age in days of an "expired" search.
*
* @return array Matching SearchEntry objects.
* @access public
*/
public function getExpiredSearches($daysOld = 2)
{
// Determine the expiration date:
$expireDate = date('Y-m-d', time() - $daysOld * 24 * 60 * 60);
// Find expired, unsaved searches:
$sql = 'SELECT * FROM "search" WHERE "saved"=0 AND "created"<' . "'{$expireDate}' LIMIT 0,10000";
$s = new SearchEntry();
$s->query($sql);
$searches = array();
if ($s->N) {
while ($s->fetch()) {
$searches[] = clone $s;
}
}
return $searches;
}
/**
* Send scheduled alerts
*
* @return void
*/
public function send()
{
global $configArray;
global $interface;
global $translator;
$iso8601 = 'Y-m-d\\TH:i:s\\Z';
ini_set('display_errors', true);
$configArray = $mainConfig = readConfig();
$datasourceConfig = getExtraConfigArray('datasources');
$siteLocal = $configArray['Site']['local'];
// Set up time zone. N.B. Don't use msg() or other functions requiring date before this.
date_default_timezone_set($configArray['Site']['timezone']);
$this->msg('Sending scheduled alerts');
// Setup Local Database Connection
ConnectionManager::connectToDatabase();
// Initialize Mailer
$mailer = new VuFindMailer();
// Find all scheduled alerts
$sql = 'SELECT * FROM "search" WHERE "schedule" > 0 ORDER BY user_id';
$s = new SearchEntry();
$s->query($sql);
$this->msg('Processing ' . $s->N . ' searches');
$user = false;
$interface = false;
$institution = false;
$todayTime = new DateTime();
while ($s->fetch()) {
$lastTime = new DateTime($s->last_executed);
if ($s->schedule == 1) {
// Daily
if ($todayTime->format('Y-m-d') == $lastTime->format('Y-m-d')) {
$this->msg('Bypassing search ' . $s->id . ': previous execution too recent (daily, ' . $lastTime->format($iso8601) . ')');
continue;
}
} elseif ($s->schedule == 2) {
// Weekly
$diff = $todayTime->diff($lastTime);
if ($diff->days < 6) {
$this->msg('Bypassing search ' . $s->id . ': previous execution too recent (weekly, ' . $lastTime->format($iso8601) . ')');
continue;
}
} else {
$this->msg('Search ' . $s->id . ': unknown schedule: ' . $s->schedule);
continue;
}
if ($user === false || $s->user_id != $user->id) {
$user = User::staticGet($s->user_id);
}
if (!$user->email || trim($user->email) == '') {
$this->msg('User ' . $user->username . ' does not have an email address, bypassing alert ' . $s->id);
continue;
}
$userInstitution = reset(explode(':', $user->username, 2));
if (!$institution || $institution != $userInstitution) {
$institution = $userInstitution;
if (!isset($datasourceConfig[$institution])) {
foreach ($datasourceConfig as $code => $values) {
if (isset($values['institution']) && strcasecmp($values['institution'], $institution) == 0) {
$institution = $code;
break;
}
}
}
if (!($configArray = $this->readInstitutionConfig($institution))) {
continue;
}
$configArray['Site']['url'] = $s->schedule_base_url;
// Start Interface
$interface = new UInterface($siteLocal);
$validLanguages = array_keys($configArray['Languages']);
$dateFormat = new VuFindDate();
}
$language = $user->language;
if (!in_array($user->language, $validLanguages)) {
$language = $configArray['Site']['language'];
}
$translator = new I18N_Translator(array($configArray['Site']['local'] . '/lang', $configArray['Site']['local'] . '/lang_local'), $language, $configArray['System']['debug']);
$interface->setLanguage($language);
$minSO = unserialize($s->search_object);
// Check minified search object type
$searchObject = SearchObjectFactory::deminify($minSO);
if (!$searchObject instanceof SearchObject_Solr) {
$this->msg('Search ' . $s->id . ': search object type not supported');
continue;
}
// Create a new search object to avoid cached defaults for e.g.
// hidden filters.
$searchObject = SearchObjectFactory::initSearchObject();
$searchObject->deminify($minSO);
$searchObject->setSort('first_indexed desc');
$searchTime = time();
$searchDate = gmdate($iso8601, time());
$searchObject->setLimit(50);
$searchObject->disableLogging();
$results = $searchObject->processSearch();
if (PEAR::isError($results)) {
$this->msg('Search ' . $s->id . ' failed: ' . $results->getMessage());
continue;
}
if ($searchObject->getResultTotal() < 1) {
$this->msg('No results found for search ' . $s->id);
continue;
}
$newestRecordDate = date($iso8601, strtotime($results['response']['docs'][0]['first_indexed']));
$lastExecutionDate = $lastTime->format($iso8601);
if ($newestRecordDate < $lastExecutionDate) {
$this->msg('No new results for search ' . $s->id . ": {$newestRecordDate} < {$lastExecutionDate}");
} else {
$this->msg('New results for search ' . $s->id . ": {$newestRecordDate} >= {$lastExecutionDate}");
$interface->assign('summary', $searchObject->getResultSummary());
$interface->assign('searchDate', $dateFormat->convertToDisplayDate("U", floor($searchTime)));
$interface->assign('lastSearchDate', $dateFormat->convertToDisplayDate("U", floor($lastTime->getTimestamp())));
$records = array();
foreach ($results['response']['docs'] as &$doc) {
$docDate = date($iso8601, strtotime($doc['first_indexed']));
if ($docDate < $lastExecutionDate) {
break;
}
$record = RecordDriverFactory::initRecordDriver($doc);
$records[] = $interface->fetch($record->getSearchResult('email'));
}
$interface->assign('recordSet', $records);
$key = $this->getSecret($user, $s->id);
$params = array('id' => $s->id, 'type' => 'alert', 'key' => $key);
$unsubscribeUrl = $configArray['Site']['url'] . '/MyResearch/Unsubscribe?' . http_build_query($params);
$interface->assign('info', array('time' => $dateFormat->convertToDisplayDate("U", floor($searchObject->getStartTime())), 'url' => $searchObject->renderSearchUrl(), 'searchId' => $searchObject->getSearchId(), 'description' => $searchObject->displayQuery(), 'filters' => $searchObject->getFilterList(), 'hits' => $searchObject->getResultTotal(), 'speed' => round($searchObject->getQuerySpeed(), 2) . "s", 'schedule' => $s->schedule, 'last_executed' => $s->last_executed, 'recordCount' => count($records), 'unsubscribeUrl' => $unsubscribeUrl));
$searchObject->close();
// Load template
$message = $interface->fetch('MyResearch/alert-email.tpl');
if (strstr($message, 'Warning: Smarty error:')) {
$this->msg("Message template processing failed: {$message}");
continue;
}
$result = $mailer->send($user->email, $configArray['Site']['email'], translate('Scheduled Alert Results'), $message);
if (PEAR::isError($result)) {
$this->msg("Failed to send message to {$user->email}: " . $result->getMessage());
continue;
}
}
// Update search date
$s->changeLastExecuted($searchDate);
}
$this->reportErrors();
$this->msg('Scheduled alerts execution completed');
}
public function getNextPrevLinks()
{
global $interface;
global $timer;
//Setup next and previous links based on the search results.
if (isset($_REQUEST['searchId']) && isset($_REQUEST['recordIndex'])) {
//rerun the search
$s = new SearchEntry();
$s->id = $_REQUEST['searchId'];
$interface->assign('searchId', $_REQUEST['searchId']);
$currentPage = isset($_REQUEST['page']) ? $_REQUEST['page'] : 1;
$interface->assign('page', $currentPage);
$s->find();
if ($s->N > 0) {
$s->fetch();
$minSO = unserialize($s->search_object);
$searchObject = SearchObjectFactory::deminify($minSO);
$searchObject->setPage($currentPage);
//Run the search
$result = $searchObject->processSearch(true, false, false);
//Check to see if we need to run a search for the next or previous page
$currentResultIndex = $_REQUEST['recordIndex'] - 1;
$recordsPerPage = $searchObject->getLimit();
$adjustedResultIndex = $currentResultIndex - $recordsPerPage * ($currentPage - 1);
if ($currentResultIndex % $recordsPerPage == 0 && $currentResultIndex > 0) {
//Need to run a search for the previous page
$interface->assign('previousPage', $currentPage - 1);
$previousSearchObject = clone $searchObject;
$previousSearchObject->setPage($currentPage - 1);
$previousSearchObject->processSearch(true, false, false);
$previousResults = $previousSearchObject->getResultRecordSet();
} else {
if (($currentResultIndex + 1) % $recordsPerPage == 0 && $currentResultIndex + 1 < $searchObject->getResultTotal()) {
//Need to run a search for the next page
$nextSearchObject = clone $searchObject;
$interface->assign('nextPage', $currentPage + 1);
$nextSearchObject->setPage($currentPage + 1);
$nextSearchObject->processSearch(true, false, false);
$nextResults = $nextSearchObject->getResultRecordSet();
}
}
if (PEAR_Singleton::isError($result)) {
//If we get an error excuting the search, just eat it for now.
} else {
if ($searchObject->getResultTotal() < 1) {
//No results found
} else {
$recordSet = $searchObject->getResultRecordSet();
//Record set is 0 based, but we are passed a 1 based index
if ($currentResultIndex > 0) {
if (isset($previousResults)) {
$previousRecord = $previousResults[count($previousResults) - 1];
} else {
$previousId = $adjustedResultIndex - 1;
if (isset($recordSet[$previousId])) {
$previousRecord = $recordSet[$previousId];
}
}
//Convert back to 1 based index
if (isset($previousRecord)) {
$interface->assign('previousIndex', $currentResultIndex - 1 + 1);
$interface->assign('previousTitle', $previousRecord['title_display']);
if (strpos($previousRecord['id'], 'econtentRecord') === 0) {
$interface->assign('previousType', 'EcontentRecord');
$interface->assign('previousId', str_replace('econtentRecord', '', $previousRecord['id']));
} elseif (strpos($previousRecord['id'], 'list') === 0) {
$interface->assign('previousType', 'MyAccount/MyList');
$interface->assign('previousId', str_replace('list', '', $previousRecord['id']));
} else {
if ($previousRecord['recordtype'] == 'grouped_work') {
$interface->assign('previousType', 'GroupedWork');
$interface->assign('previousId', $previousRecord['id']);
} else {
$interface->assign('previousType', 'Record');
$interface->assign('previousId', $previousRecord['id']);
}
}
}
}
if ($currentResultIndex + 1 < $searchObject->getResultTotal()) {
if (isset($nextResults)) {
$nextRecord = $nextResults[0];
} else {
$nextRecordIndex = $adjustedResultIndex + 1;
if (isset($recordSet[$nextRecordIndex])) {
$nextRecord = $recordSet[$nextRecordIndex];
}
}
//Convert back to 1 based index
$interface->assign('nextIndex', $currentResultIndex + 1 + 1);
if (isset($nextRecord)) {
$interface->assign('nextTitle', $nextRecord['title_display']);
if (strpos($nextRecord['id'], 'econtentRecord') === 0) {
$interface->assign('nextType', 'EcontentRecord');
$interface->assign('nextId', str_replace('econtentRecord', '', $nextRecord['id']));
} elseif (strpos($nextRecord['id'], 'list') === 0) {
$interface->assign('nextType', 'MyAccount/MyList');
$interface->assign('nextId', str_replace('list', '', $nextRecord['id']));
} else {
if ($nextRecord['recordtype'] == 'grouped_work') {
$interface->assign('nextType', 'GroupedWork');
$interface->assign('nextId', $nextRecord['id']);
} else {
$interface->assign('nextType', 'Record');
$interface->assign('nextId', $nextRecord['id']);
}
}
}
}
}
}
}
$timer->logTime('Got next/previous links');
}
}
