} else {
$language = strip_tags(isset($_COOKIE['language']) ? $_COOKIE['language'] : $configArray['Site']['language']);
}
/** @var Memcache $memCache */
$translator = $memCache->get("translator_{$serverName}_{$language}");
if ($translator == false || isset($_REQUEST['reloadTranslator'])) {
// Make sure language code is valid, reset to default if bad:
$validLanguages = array_keys($configArray['Languages']);
if (!in_array($language, $validLanguages)) {
$language = $configArray['Site']['language'];
}
$translator = new I18N_Translator('lang', $language, $configArray['System']['missingTranslations']);
$memCache->set("translator_{$serverName}_{$language}", $translator, 0, $configArray['Caching']['translator']);
$timer->logTime('Translator setup');
}
$interface->setLanguage($language);
/** @var User */
global $user;
$user = UserAccount::isLoggedIn();
$timer->logTime('Check if user is logged in');
$deviceName = get_device_name();
$interface->assign('deviceName', $deviceName);
//Look for spammy searches
if (isset($_REQUEST['lookfor'])) {
$searchTerm = $_REQUEST['lookfor'];
if (preg_match('/http:|mailto:|https:/i', $searchTerm)) {
PEAR_Singleton::raiseError("Sorry it looks like you are searching for a website, please rephrase your query.");
$_REQUEST['lookfor'] = '';
$_GET['lookfor'] = '';
}
if (strlen($searchTerm) >= 256) {
/**
* 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');
}
/**
* Send due date reminders
*
* @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 due date reminders');
// Setup Local Database Connection
ConnectionManager::connectToDatabase();
// And index
$db = ConnectionManager::connectToIndex();
// Initialize Mailer
$mailer = new VuFindMailer();
// Find all scheduled alerts
$sql = 'SELECT * FROM "user" WHERE "due_date_reminder" > 0 ORDER BY id';
$user = new User();
$user->query($sql);
$this->msg('Processing ' . $user->N . ' users');
$interface = false;
$institution = false;
$todayTime = new DateTime();
$catalog = ConnectionManager::connectToCatalog();
while ($user->fetch()) {
if (!$user->email || trim($user->email) == '') {
$this->msg('User ' . $user->username . ' does not have an email address, bypassing due date reminders');
continue;
}
// Initialize settings and interface
$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;
}
// 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);
// Go through accounts and check loans
$account = new User_account();
$account->user_id = $user->id;
if (!$account->find(false)) {
continue;
}
$remindLoans = array();
while ($account->fetch()) {
$patron = $catalog->patronLogin($account->cat_username, $account->cat_password);
if ($patron === null || PEAR::isError($patron)) {
$this->msg('Catalog login failed for user ' . $user->id . ', account ' . $account->id . ' (' . $account->cat_username . '): ' . ($patron ? $patron->getMessage() : 'patron not found'));
continue;
}
$loans = $catalog->getMyTransactions($patron);
if (PEAR::isError($loans)) {
$this->msg('Could not fetch loans for user ' . $user->id . ', account ' . $account->id . ' (' . $account->cat_username . ')');
continue;
}
foreach ($loans as $loan) {
$dueDate = new DateTime($loan['duedate']);
if ($todayTime >= $dueDate || $dueDate->diff($todayTime)->days <= $user->due_date_reminder) {
// Check that a reminder hasn't been sent already
$reminder = new Due_date_reminder();
$reminder->user_id = $user->id;
$reminder->loan_id = $loan['item_id'];
$reminder->due_date = $dueDate->format($iso8601);
if ($reminder->find(false)) {
// Reminder already sent
continue;
}
// Store also title for display in email
$title = isset($loan['title']) ? $loan['title'] : translate('Title not available');
if (isset($loan['id'])) {
$record = $db->getRecord($loan['id']);
if ($record && isset($record['title'])) {
$title = $record['title'];
}
}
$remindLoans[] = array('loanId' => $loan['item_id'], 'dueDate' => $loan['duedate'], 'dueDateFormatted' => $dueDate->format(isset($configArray['Site']['displayDateFormat']) ? $configArray['Site']['displayDateFormat'] : "m-d-Y"), 'title' => $title);
}
}
}
if ($remindLoans) {
$this->msg(count($remindLoans) . ' new loans to remind for user ' . $user->id);
$interface->assign('date', $dateFormat->convertToDisplayDate("U", floor(time())));
$interface->assign('loans', $remindLoans);
$key = $this->getSecret($user, $user->id);
$params = array('id' => $user->id, 'type' => 'reminder', 'key' => $key);
$unsubscribeUrl = $configArray['Site']['url'] . '/MyResearch/Unsubscribe?' . http_build_query($params);
$interface->assign(compact('unsubscribeUrl'));
// Load template
$message = $interface->fetch('MyResearch/due-date-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('due_date_email_subject'), $message);
if (PEAR::isError($result)) {
$this->msg("Failed to send message to {$user->email}: " . $result->getMessage());
continue;
}
// Mark reminders sent
foreach ($remindLoans as $loan) {
$reminder = new Due_date_reminder();
$reminder->user_id = $user->id;
$reminder->loan_id = $loan['loanId'];
$reminder->delete();
$dueDate = new DateTime($loan['dueDate']);
$reminder->due_date = $dueDate->format($iso8601);
$reminder->notification_date = gmdate($iso8601, time());
$reminder->insert();
}
} else {
$this->msg('No loans to remind for user ' . $user->id);
}
}
$this->reportErrors();
$this->msg('Due date reminders execution completed');
}
