public function launch()
{
global $interface;
if (isset($_REQUEST['startDate'])) {
$startDate = new DateTime($_REQUEST['startDate']);
} else {
$startDate = new DateTime();
date_sub($startDate, new DateInterval('P1M'));
}
if (isset($_REQUEST['endDate'])) {
$endDate = new DateTime($_REQUEST['endDate']);
} else {
$endDate = new DateTime();
}
$interface->assign('startDate', $startDate->getTimestamp());
$interface->assign('endDate', $endDate->getTimestamp());
$offlineHolds = array();
$offlineHoldsObj = new OfflineHold();
$offlineHoldsObj->whereAdd("timeEntered >= " . $startDate->getTimestamp() . " AND timeEntered <= " . $endDate->getTimestamp());
$offlineHoldsObj->find();
while ($offlineHoldsObj->fetch()) {
$offlineHold = array();
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($offlineHoldsObj->bibId);
if ($recordDriver->isValid()) {
$offlineHold['title'] = $recordDriver->getTitle();
}
$offlineHold['patronBarcode'] = $offlineHoldsObj->patronBarcode;
$offlineHold['bibId'] = $offlineHoldsObj->bibId;
$offlineHold['timeEntered'] = $offlineHoldsObj->timeEntered;
$offlineHold['status'] = $offlineHoldsObj->status;
$offlineHold['notes'] = $offlineHoldsObj->notes;
$offlineHolds[] = $offlineHold;
}
$interface->setPageTitle('Offline Holds Report');
$interface->assign('sidebar', 'MyAccount/account-sidebar.tpl');
$interface->assign('offlineHolds', $offlineHolds);
$interface->setTemplate('offlineHoldsReport.tpl');
$interface->display('layout.tpl');
}
/**
* @param $id
* @return ExternalEContentDriver|MarcRecord|null|OverDriveRecordDriver|PublicEContentDriver|RestrictedEContentDriver
*/
static function initRecordDriverById($id)
{
if (isset(RecordDriverFactory::$recordDrivers[$id])) {
return RecordDriverFactory::$recordDrivers[$id];
}
$recordInfo = explode(':', $id);
$recordType = $recordInfo[0];
$recordId = $recordInfo[1];
disableErrorHandler();
if ($recordType == 'overdrive') {
require_once ROOT_DIR . '/RecordDrivers/OverDriveRecordDriver.php';
$recordDriver = new OverDriveRecordDriver($recordId);
} elseif ($recordType == 'public_domain_econtent') {
require_once ROOT_DIR . '/RecordDrivers/PublicEContentDriver.php';
$recordDriver = new PublicEContentDriver($recordId);
} elseif ($recordType == 'external_econtent') {
require_once ROOT_DIR . '/RecordDrivers/ExternalEContentDriver.php';
$recordDriver = new ExternalEContentDriver($recordId);
} elseif ($recordType == 'restricted_econtent') {
require_once ROOT_DIR . '/RecordDrivers/RestrictedEContentDriver.php';
$recordDriver = new RestrictedEContentDriver($recordId);
} elseif ($recordType == 'hoopla') {
require_once ROOT_DIR . '/RecordDrivers/HooplaDriver.php';
$recordDriver = new HooplaRecordDriver($recordId);
if (!$recordDriver->isValid()) {
global $logger;
$logger->log("Unable to load record driver for hoopla record {$recordId}", PEAR_LOG_WARNING);
$recordDriver = null;
}
} elseif ($recordType == 'ils') {
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($recordId);
if (!$recordDriver->isValid()) {
global $logger;
$logger->log("Unable to load record driver for {$recordId}", PEAR_LOG_WARNING);
$recordDriver = null;
}
} else {
global $logger;
$logger->log("Unknown record type " . $recordType, PEAR_LOG_ERR);
$recordDriver = null;
}
enableErrorHandler();
RecordDriverFactory::$recordDrivers[$id] = $recordDriver;
return $recordDriver;
}
public function getMyTransactions($page = 1, $recordsPerPage = -1, $sortOption = 'dueDate')
{
global $configArray;
global $user;
$userId = $user->id;
$checkedOutTitles = array();
//Get the session token for the user
if (isset(HorizonAPI::$sessionIdsForUsers[$userId])) {
$sessionToken = HorizonAPI::$sessionIdsForUsers[$userId];
} else {
//Log the user in
list($userValid, $sessionToken) = $this->loginViaWebService($user->cat_username, $user->cat_password);
if (!$userValid) {
echo "No session id found for user";
return $checkedOutTitles;
}
}
//Now that we have the session token, get checkouts information
$lookupMyAccountInfoResponse = $this->getWebServiceResponse($configArray['Catalog']['webServiceUrl'] . '/standard/lookupMyAccountInfo?clientID=' . $configArray['Catalog']['clientId'] . '&sessionToken=' . $sessionToken . '&includeItemsOutInfo=true');
if (isset($lookupMyAccountInfoResponse->ItemsOutInfo)) {
$sCount = 0;
foreach ($lookupMyAccountInfoResponse->ItemsOutInfo as $itemOut) {
$sCount++;
$bibId = (string) $itemOut->titleKey;
$curTitle['checkoutSource'] = 'ILS';
$curTitle['recordId'] = $bibId;
$curTitle['shortId'] = $bibId;
$curTitle['id'] = $bibId;
$curTitle['title'] = (string) $itemOut->title;
$curTitle['author'] = (string) $itemOut->author;
$curTitle['duedate'] = (string) $itemOut->dueDate;
$curTitle['checkoutdate'] = (string) $itemOut->ckoDate;
$dueTime = strtotime($curTitle['duedate']);
$daysUntilDue = ceil(($dueTime - time()) / (24 * 60 * 60));
$overdue = $daysUntilDue < 0;
$curTitle['overdue'] = $overdue;
$curTitle['daysUntilDue'] = $daysUntilDue;
$curTitle['renewCount'] = (string) $itemOut->renewals;
$curTitle['canrenew'] = true;
//TODO: Figure out if the user can renew the title or not
$curTitle['renewIndicator'] = (string) $itemOut->itemBarcode;
$curTitle['barcode'] = (string) $itemOut->itemBarcode;
$curTitle['holdQueueLength'] = $this->getNumHolds($bibId);
$curTitle['format'] = 'Unknown';
if ($curTitle['id'] && strlen($curTitle['id']) > 0) {
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($curTitle['id']);
if ($recordDriver->isValid()) {
$curTitle['coverUrl'] = $recordDriver->getBookcoverUrl('medium');
$curTitle['groupedWorkId'] = $recordDriver->getGroupedWorkId();
$formats = $recordDriver->getFormats();
$curTitle['format'] = reset($formats);
} else {
$curTitle['coverUrl'] = "";
}
}
$sortTitle = isset($curTitle['title_sort']) ? $curTitle['title_sort'] : $curTitle['title'];
$sortKey = $sortTitle;
if ($sortOption == 'title') {
$sortKey = $sortTitle;
} elseif ($sortOption == 'author') {
$sortKey = (isset($curTitle['author']) ? $curTitle['author'] : "Unknown") . '-' . $sortTitle;
} elseif ($sortOption == 'dueDate') {
if (isset($curTitle['duedate'])) {
if (preg_match('/.*?(\\d{1,2})[-\\/](\\d{1,2})[-\\/](\\d{2,4}).*/', $curTitle['duedate'], $matches)) {
$sortKey = $matches[3] . '-' . $matches[1] . '-' . $matches[2] . '-' . $sortTitle;
} else {
$sortKey = $curTitle['duedate'] . '-' . $sortTitle;
}
}
} elseif ($sortOption == 'format') {
$sortKey = (isset($curTitle['format']) ? $curTitle['format'] : "Unknown") . '-' . $sortTitle;
} elseif ($sortOption == 'renewed') {
$sortKey = (isset($curTitle['renewCount']) ? $curTitle['renewCount'] : 0) . '-' . $sortTitle;
} elseif ($sortOption == 'holdQueueLength') {
$sortKey = (isset($curTitle['holdQueueLength']) ? $curTitle['holdQueueLength'] : 0) . '-' . $sortTitle;
}
$sortKey .= "_{$sCount}";
$checkedOutTitles[$sortKey] = $curTitle;
}
}
return array('transactions' => $checkedOutTitles, 'numTransactions' => count($checkedOutTitles));
}
public function getReadingHistory($patron, $page = 1, $recordsPerPage = -1, $sortOption = "checkedOut")
{
global $timer;
$patronDump = $this->driver->_getPatronDump($this->driver->_getBarcode());
//Load the information from millennium using CURL
$pageContents = $this->driver->_fetchPatronInfoPage($patronDump, 'readinghistory');
//Check to see if there are multiple pages of reading history
$hasPagination = preg_match('/<td[^>]*class="browsePager"/', $pageContents);
if ($hasPagination) {
//Load a list of extra pages to load. The pagination links display multiple times, so load into an associative array to make them unique
preg_match_all('/<a href="readinghistory&page=(\\d+)">/', $pageContents, $additionalPageMatches);
$maxPageNum = 0;
foreach ($additionalPageMatches[1] as $additionalPageMatch) {
if ($additionalPageMatch > $maxPageNum) {
$maxPageNum = $additionalPageMatch;
}
}
}
$recordsRead = 0;
$readingHistoryTitles = $this->parseReadingHistoryPage($pageContents, $patron, $sortOption, $recordsRead);
$recordsRead += count($readingHistoryTitles);
if (isset($maxPageNum)) {
for ($pageNum = 2; $pageNum <= $maxPageNum; $pageNum++) {
$pageContents = $this->driver->_fetchPatronInfoPage($patronDump, 'readinghistory&page=' . $pageNum);
$additionalTitles = $this->parseReadingHistoryPage($pageContents, $patron, $sortOption, $recordsRead);
$recordsRead += count($additionalTitles);
$readingHistoryTitles = array_merge($readingHistoryTitles, $additionalTitles);
}
}
if ($sortOption == "checkedOut" || $sortOption == "returned") {
krsort($readingHistoryTitles);
} else {
ksort($readingHistoryTitles);
}
$numTitles = count($readingHistoryTitles);
//process pagination
if ($recordsPerPage != -1) {
$startRecord = ($page - 1) * $recordsPerPage;
$readingHistoryTitles = array_slice($readingHistoryTitles, $startRecord, $recordsPerPage);
}
set_time_limit(20 * count($readingHistoryTitles));
foreach ($readingHistoryTitles as $key => $historyEntry) {
//Get additional information from resources table
$historyEntry['ratingData'] = null;
$historyEntry['permanentId'] = null;
$historyEntry['linkUrl'] = null;
$historyEntry['coverUrl'] = null;
$historyEntry['format'] = array();
if (isset($historyEntry['shortId']) && strlen($historyEntry['shortId']) > 0) {
$historyEntry['recordId'] = "." . $historyEntry['shortId'] . $this->driver->getCheckDigit($historyEntry['shortId']);
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($historyEntry['recordId']);
if ($recordDriver->isValid()) {
$historyEntry['ratingData'] = $recordDriver->getRatingData();
$historyEntry['permanentId'] = $recordDriver->getPermanentId();
$historyEntry['linkUrl'] = $recordDriver->getLinkUrl();
$historyEntry['coverUrl'] = $recordDriver->getBookcoverUrl('medium');
$historyEntry['format'] = $recordDriver->getFormats();
}
$recordDriver = null;
}
$readingHistoryTitles[$key] = $historyEntry;
}
//The history is active if there is an opt out link.
$historyActive = strpos($pageContents, 'OptOut') > 0;
$timer->logTime("Loaded Reading history for patron");
global $user;
if ($historyActive && !$user->trackReadingHistory) {
//The user does have reading history even though we hadn't detected it before.
$user->trackReadingHistory = true;
$user->update();
$_SESSION['userinfo'] = serialize($user);
}
if (!$historyActive && $user->trackReadingHistory) {
//The user does have reading history even though we hadn't detected it before.
$user->trackReadingHistory = false;
$user->update();
$_SESSION['userinfo'] = serialize($user);
}
return array('historyActive' => $historyActive, 'titles' => $readingHistoryTitles, 'numTitles' => $numTitles);
}
function launch()
{
global $configArray;
global $interface;
global $user;
//these actions are being moved to MyAccount/AJAX.php
if (isset($_REQUEST['multiAction'])) {
$multiAction = $_REQUEST['multiAction'];
$locationId = isset($_REQUEST['location']) ? $_REQUEST['location'] : null;
$cancelId = array();
$type = 'update';
$freeze = '';
if ($multiAction == 'cancelSelected') {
$type = 'cancel';
// $freeze = ''; // same as default setting.
} elseif ($multiAction == 'freezeSelected') {
// $type = 'update'; // same as default setting.
$freeze = 'on';
} elseif ($multiAction == 'thawSelected') {
// $type = 'update'; // same as default setting.
$freeze = 'off';
}
// elseif ($multiAction == 'updateSelected'){ // same as default settings.
// $type = 'update';
// $freeze = '';
// }
$result = $this->catalog->driver->updateHoldDetailed($user->password, $type, '', null, $cancelId, $locationId, $freeze);
// $interface->assign('holdResult', $result);
//Redirect back here without the extra parameters.
$redirectUrl = $configArray['Site']['path'] . '/MyAccount/Holds?accountSort=' . ($selectedSortOption = isset($_REQUEST['accountSort']) ? $_REQUEST['accountSort'] : 'title');
header("Location: " . $redirectUrl);
die;
}
$interface->assign('allowFreezeHolds', true);
$ils = $configArray['Catalog']['ils'];
$showPosition = $ils == 'Horizon' || ($ils = 'Koha');
$showExpireTime = $ils == 'Horizon';
$suspendRequiresReactivationDate = $ils == 'Horizon';
$interface->assign('suspendRequiresReactivationDate', $suspendRequiresReactivationDate);
$canChangePickupLocation = $ils != 'Koha';
$interface->assign('canChangePickupLocation', $canChangePickupLocation);
// Define sorting options
$sortOptions = array('title' => 'Title', 'author' => 'Author', 'format' => 'Format', 'placed' => 'Date Placed', 'location' => 'Pickup Location', 'status' => 'Status');
if ($showPosition) {
$sortOptions['position'] = 'Position';
}
$interface->assign('sortOptions', $sortOptions);
$selectedSortOption = isset($_REQUEST['accountSort']) ? $_REQUEST['accountSort'] : 'title';
$interface->assign('defaultSortOption', $selectedSortOption);
$profile = $this->catalog->getMyProfile($user);
// TODO: getMyProfile called for second time. First time on index.php
$libraryHoursMessage = Location::getLibraryHoursMessage($profile['homeLocationId']);
$interface->assign('libraryHoursMessage', $libraryHoursMessage);
$allowChangeLocation = $ils == 'Millennium' || $ils == 'Sierra';
$interface->assign('allowChangeLocation', $allowChangeLocation);
//$showPlacedColumn = ($ils == 'Horizon');
//Horizon Web Services does not include data placed anymore
$showPlacedColumn = false;
$interface->assign('showPlacedColumn', $showPlacedColumn);
$showDateWhenSuspending = $ils == 'Horizon';
$interface->assign('showDateWhenSuspending', $showDateWhenSuspending);
$interface->assign('showPosition', $showPosition);
$interface->assign('showNotInterested', false);
// Get My Transactions
if ($configArray['Catalog']['offline']) {
$interface->assign('offline', true);
} else {
$patron = null;
if ($this->catalog->status) {
if ($user->cat_username) {
$patron = $this->catalog->patronLogin($user->cat_username, $user->cat_password);
$patronResult = $this->catalog->getMyProfile($patron);
// TODO: getMyProfile called above already. Is this call necessary?
if (!PEAR_Singleton::isError($patronResult)) {
$interface->assign('profile', $patronResult);
}
$interface->assign('sortOptions', $sortOptions);
$selectedSortOption = isset($_REQUEST['accountSort']) ? $_REQUEST['accountSort'] : 'dueDate';
$interface->assign('defaultSortOption', $selectedSortOption);
$page = isset($_REQUEST['page']) ? $_REQUEST['page'] : 1;
$recordsPerPage = isset($_REQUEST['pagesize']) && is_numeric($_REQUEST['pagesize']) ? $_REQUEST['pagesize'] : 25;
$interface->assign('recordsPerPage', $recordsPerPage);
if (isset($_GET['exportToExcel'])) {
$recordsPerPage = -1;
$page = 1;
}
//Get Holds from the ILS
$ilsHolds = $this->catalog->getMyHolds($patron, 1, -1, $selectedSortOption);
if (PEAR_Singleton::isError($ilsHolds)) {
$ilsHolds = array();
}
//Get holds from OverDrive
require_once ROOT_DIR . '/Drivers/OverDriveDriverFactory.php';
$overDriveDriver = OverDriveDriverFactory::getDriver();
$overDriveHolds = $overDriveDriver->getOverDriveHolds($user);
//Get a list of eContent that has been checked out
require_once ROOT_DIR . '/Drivers/EContentDriver.php';
$driver = new EContentDriver();
$eContentHolds = $driver->getMyHolds($user);
$allHolds = array_merge_recursive($ilsHolds, $overDriveHolds, $eContentHolds);
/* pickUpLocations doesn't seem to be used by the Holds summary page. plb 1-26-2015
$location = new Location();
$pickupBranches = $location->getPickupBranches($patronResult, null);
$locationList = array();
foreach ($pickupBranches as $curLocation) {
$locationList[$curLocation->locationId] = $curLocation->displayName;
}
$interface->assign('pickupLocations', $locationList); */
//Make sure available holds come before unavailable
$interface->assign('recordList', $allHolds['holds']);
//make call to export function
if (isset($_GET['exportToExcelAvailable']) || isset($_GET['exportToExcelUnavailable'])) {
if (isset($_GET['exportToExcelAvailable'])) {
$exportType = "available";
} else {
$exportType = "unavailable";
}
$this->exportToExcel($allHolds['holds'], $exportType, $showDateWhenSuspending, $showPosition, $showExpireTime);
}
}
}
$interface->assign('patron', $patron);
}
//Load holds that have been entered offline
if ($user) {
require_once ROOT_DIR . '/sys/OfflineHold.php';
$twoDaysAgo = time() - 48 * 60 * 60;
$twoWeeksAgo = time() - 14 * 24 * 60 * 60;
$offlineHoldsObj = new OfflineHold();
$offlineHoldsObj->patronId = $user->id;
$offlineHoldsObj->whereAdd("status = 'Not Processed' OR (status = 'Hold Placed' AND timeEntered >= {$twoDaysAgo}) OR (status = 'Hold Failed' AND timeEntered >= {$twoWeeksAgo})");
// mysql has these functions as well: "status = 'Not Processed' OR (status = 'Hold Placed' AND timeEntered >= DATE_SUB(NOW(), INTERVAL 2 DAYS)) OR (status = 'Hold Failed' AND timeEntered >= DATE_SUB(NOW(), INTERVAL 2 WEEKS))");
$offlineHolds = array();
if ($offlineHoldsObj->find()) {
while ($offlineHoldsObj->fetch()) {
//Load the title
$offlineHold = array();
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($offlineHoldsObj->bibId);
if ($recordDriver->isValid()) {
$offlineHold['title'] = $recordDriver->getTitle();
}
$offlineHold['bibId'] = $offlineHoldsObj->bibId;
$offlineHold['timeEntered'] = $offlineHoldsObj->timeEntered;
$offlineHold['status'] = $offlineHoldsObj->status;
$offlineHold['notes'] = $offlineHoldsObj->notes;
$offlineHolds[] = $offlineHold;
}
}
$interface->assign('offlineHolds', $offlineHolds);
}
$interface->setPageTitle('My Holds');
$interface->assign('sidebar', 'MyAccount/account-sidebar.tpl');
global $library;
if (!$library->showDetailedHoldNoticeInformation) {
$notification_method = '';
} else {
$notification_method = $profile['noticePreferenceLabel'] != 'Unknown' ? $profile['noticePreferenceLabel'] : '';
if ($notification_method == 'Mail' && $library->treatPrintNoticesAsPhoneNotices) {
$notification_method = 'Telephone';
}
}
$interface->assign('notification_method', strtolower($notification_method));
$interface->setTemplate('holds.tpl');
//print_r($patron);
$interface->display('layout.tpl');
}
public function getMyHolds($patron = null, $page = 1, $recordsPerPage = -1, $sortOption = 'title')
{
global $timer;
$patronDump = $this->driver->_getPatronDump($this->driver->_getBarcode());
//Load the information from millennium using CURL
$sResult = $this->driver->_fetchPatronInfoPage($patronDump, 'holds');
$timer->logTime("Got holds page from Millennium");
$holds = $this->parseHoldsPage($sResult);
$timer->logTime("Parsed Holds page");
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
foreach ($holds as $section => $holdSections) {
foreach ($holdSections as $key => $hold) {
disableErrorHandler();
$recordDriver = new MarcRecord($hold['recordId']);
if ($recordDriver->isValid()) {
$hold['id'] = $recordDriver->getUniqueID();
$hold['shortId'] = $recordDriver->getShortId();
//Load title, author, and format information about the title
$hold['title'] = $recordDriver->getTitle();
$hold['sortTitle'] = $recordDriver->getSortableTitle();
$hold['author'] = $recordDriver->getAuthor();
$hold['format'] = $recordDriver->getFormat();
$hold['isbn'] = $recordDriver->getCleanISBN();
$hold['upc'] = $recordDriver->getCleanUPC();
$hold['format_category'] = $recordDriver->getFormatCategory();
//Load rating information
$hold['ratingData'] = $recordDriver->getRatingData();
$holds[$section][$key] = $hold;
}
enableErrorHandler();
}
}
//Process sorting
//echo ("<br/>\r\nSorting by $sortOption");
foreach ($holds as $sectionName => $section) {
$sortKeys = array();
$i = 0;
foreach ($section as $key => $hold) {
$sortTitle = isset($hold['sortTitle']) ? $hold['sortTitle'] : (isset($hold['title']) ? $hold['title'] : "Unknown");
if ($sectionName == 'available') {
$sortKeys[$key] = $sortTitle;
} else {
if ($sortOption == 'title') {
$sortKeys[$key] = $sortTitle;
} elseif ($sortOption == 'author') {
$sortKeys[$key] = (isset($hold['author']) ? $hold['author'] : "Unknown") . '-' . $sortTitle;
} elseif ($sortOption == 'placed') {
$sortKeys[$key] = $hold['createTime'] . '-' . $sortTitle;
} elseif ($sortOption == 'format') {
$sortKeys[$key] = (isset($hold['format']) ? $hold['format'] : "Unknown") . '-' . $sortTitle;
} elseif ($sortOption == 'location') {
$sortKeys[$key] = (isset($hold['location']) ? $hold['location'] : "Unknown") . '-' . $sortTitle;
} elseif ($sortOption == 'holdQueueLength') {
$sortKeys[$key] = (isset($hold['holdQueueLength']) ? $hold['holdQueueLength'] : 0) . '-' . $sortTitle;
} elseif ($sortOption == 'position') {
$sortKeys[$key] = str_pad(isset($hold['position']) ? $hold['position'] : 1, 3, "0", STR_PAD_LEFT) . '-' . $sortTitle;
} elseif ($sortOption == 'status') {
$sortKeys[$key] = (isset($hold['status']) ? $hold['status'] : "Unknown") . '-' . (isset($hold['reactivateTime']) ? $hold['reactivateTime'] : "0") . '-' . $sortTitle;
} else {
$sortKeys[$key] = $sortTitle;
}
//echo ("<br/>\r\nSort Key for $key = {$sortKeys[$key]}");
}
$sortKeys[$key] = strtolower($sortKeys[$key] . '-' . $i++);
}
array_multisort($sortKeys, $section);
$holds[$sectionName] = $section;
}
//Limit to a specific number of records
if (isset($holds['unavailable'])) {
$numUnavailableHolds = count($holds['unavailable']);
if ($recordsPerPage != -1) {
$startRecord = ($page - 1) * $recordsPerPage;
$holds['unavailable'] = array_slice($holds['unavailable'], $startRecord, $recordsPerPage);
}
} else {
$numUnavailableHolds = 0;
}
if (!isset($holds['available'])) {
$holds['available'] = array();
}
if (!isset($holds['unavailable'])) {
$holds['unavailable'] = array();
}
//Sort the hold sections so available holds are first.
ksort($holds);
$patronId = isset($patron) ? $patron['id'] : $this->driver->_getBarcode();
$this->holds[$patronId] = $holds;
$timer->logTime("Processed hold pagination and sorting");
return array('holds' => $holds, 'numUnavailableHolds' => $numUnavailableHolds);
}
/**
* Get Patron Holds
*
* This is responsible for retrieving all holds by a specific patron.
*
* @param array|User $patron The patron array from patronLogin
* @param integer $page The current page of holds
* @param integer $recordsPerPage The number of records to show per page
* @param string $sortOption How the records should be sorted
* @param string $summaryPage If the summary page has already been loaded, it can be passed in for performance reasons.
*
* @return mixed Array of the patron's holds on success, PEAR_Error
* otherwise.
* @access public
*/
public function getMyHoldsFromDB($patron, $page = 1, $recordsPerPage = -1, $sortOption = 'title')
{
global $user;
$availableHolds = array();
$unavailableHolds = array();
$holds = array('available' => $availableHolds, 'unavailable' => $unavailableHolds);
$this->initDatabaseConnection();
$sql = "SELECT *, title, author FROM reserves inner join biblio on biblio.biblionumber = reserves.biblionumber where borrowernumber = ?";
$holdsStmt = mysqli_prepare($this->dbConnection, $sql);
$holdsStmt->bind_param('i', $user->username);
$holdsStmt->execute();
$results = $holdsStmt->get_result();
while ($curRow = $results->fetch_assoc()) {
//Each row in the table represents a hold
$curHold = array();
$curHold['holdSource'] = 'ILS';
$bibId = $curRow['biblionumber'];
$curHold['id'] = $curRow['biblionumber'];
$curHold['shortId'] = $curRow['biblionumber'];
$curHold['recordId'] = $curRow['biblionumber'];
$curHold['title'] = $curRow['title'];
$curHold['create'] = date_parse_from_format('Y-M-d H:m:s', $curRow['reservedate']);
$curHold['expire'] = date_parse_from_format('Y-M-d', $curRow['expirationdate']);
$curHold['location'] = $curRow['branchcode'];
$curHold['locationUpdateable'] = false;
$curHold['currentPickupName'] = $curHold['location'];
$curHold['position'] = $curRow['priority'];
$curHold['frozen'] = false;
$curHold['freezeable'] = false;
$curHold['cancelable'] = true;
if ($curRow['found'] == 'S') {
$curHold['frozen'] = true;
$curHold['status'] = "Suspended";
$curHold['cancelable'] = false;
} elseif ($curRow['found'] == 'W') {
$curHold['status'] = "Ready to Pickup";
} elseif ($curRow['found'] == 'T') {
$curHold['status'] = "In Transit";
} else {
$curHold['status'] = "Pending";
$curHold['freezeable'] = true;
}
$curHold['freezeable'] = true;
$curHold['cancelId'] = $curRow['reservenumber'];
if ($bibId) {
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($bibId);
if ($recordDriver->isValid()) {
$curHold['sortTitle'] = $recordDriver->getSortableTitle();
$curHold['format'] = $recordDriver->getFormat();
$curHold['isbn'] = $recordDriver->getCleanISBN();
$curHold['upc'] = $recordDriver->getCleanUPC();
$curHold['format_category'] = $recordDriver->getFormatCategory();
//Load rating information
$curHold['ratingData'] = $recordDriver->getRatingData();
}
}
if (!isset($curHold['status']) || !preg_match('/^Item waiting.*/i', $curHold['status'])) {
$holds['unavailable'][] = $curHold;
} else {
$holds['available'][] = $curHold;
}
}
return array('holds' => $holds, 'numUnavailableHolds' => count($holds['unavailable']));
}
public function getMyTransactions($page = 1, $recordsPerPage = -1, $sortOption = 'dueDate')
{
global $timer;
$patronDump = $this->driver->_getPatronDump($this->driver->_getBarcode());
$timer->logTime("Ready to load checked out titles from Millennium");
//Load the information from millennium using CURL
$sResult = $this->driver->_fetchPatronInfoPage($patronDump, 'items');
$timer->logTime("Loaded checked out titles from Millennium");
$sResult = preg_replace("/<[^<]+?>\\W<[^<]+?>\\W\\d* ITEM.? CHECKED OUT<[^<]+?>\\W<[^<]+?>/i", "", $sResult);
$s = substr($sResult, stripos($sResult, 'patFunc'));
$s = substr($s, strpos($s, ">") + 1);
$s = substr($s, 0, stripos($s, "</table"));
$s = preg_replace("/<br \\/>/", "", $s);
$sRows = preg_split("/<tr([^>]*)>/", $s);
$sCount = 0;
$sKeys = array_pad(array(), 10, "");
$checkedOutTitles = array();
//Get patron's location to determine if renewals are allowed.
global $locationSingleton;
/** @var Location $patronLocation */
$patronLocation = $locationSingleton->getUserHomeLocation();
if (isset($patronLocation)) {
$patronPType = $this->driver->getPType();
$patronCanRenew = false;
if ($patronLocation->ptypesToAllowRenewals == '*') {
$patronCanRenew = true;
} else {
if (preg_match("/^({$patronLocation->ptypesToAllowRenewals})\$/", $patronPType)) {
$patronCanRenew = true;
}
}
} else {
$patronCanRenew = true;
}
$timer->logTime("Determined if patron can renew");
foreach ($sRows as $srow) {
$scols = preg_split("/<t(h|d)([^>]*)>/", $srow);
$curTitle = array();
for ($i = 0; $i < sizeof($scols); $i++) {
$scols[$i] = str_replace(" ", " ", $scols[$i]);
$scols[$i] = preg_replace("/<br+?>/", " ", $scols[$i]);
$scols[$i] = html_entity_decode(trim(substr($scols[$i], 0, stripos($scols[$i], "</t"))));
//print_r($scols[$i]);
if ($sCount == 1) {
$sKeys[$i] = $scols[$i];
} else {
if ($sCount > 1) {
if (stripos($sKeys[$i], "TITLE") > -1) {
if (preg_match('/.*?<a href=\\"\\/record=(.*?)(?:~S\\d{1,2})\\">(.*?)<\\/a>.*/', $scols[$i], $matches)) {
//Standard Millennium WebPAC
$shortId = $matches[1];
$bibid = '.' . $matches[1];
//Technically, this isn't correct since the check digit is missing
$title = strip_tags($matches[2]);
} elseif (preg_match('/.*<a href=".*?\\/record\\/C__R(.*?)\\?.*?">(.*?)<\\/a>.*/si', $scols[$i], $matches)) {
//Encore
$shortId = $matches[1];
$bibid = '.' . $matches[1];
//Technically, this isn't correct since the check digit is missing
$title = strip_tags($matches[2]);
} else {
$title = strip_tags($scols[$i]);
$shortId = '';
$bibid = '';
}
$curTitle['checkoutSource'] = 'ILS';
$curTitle['shortId'] = $shortId;
$curTitle['id'] = $bibid;
$curTitle['title'] = utf8_encode($title);
}
if (stripos($sKeys[$i], "STATUS") > -1) {
// $sret[$scount-2]['duedate'] = strip_tags($scols[$i]);
$due = trim(str_replace("DUE", "", strip_tags($scols[$i])));
$renewCount = 0;
if (preg_match('/FINE\\(up to now\\) (\\$\\d+\\.\\d+)/i', $due, $matches)) {
$curTitle['fine'] = trim($matches[1]);
}
if (preg_match('/(.*)Renewed (\\d+) time(?:s)?/i', $due, $matches)) {
$due = trim($matches[1]);
$renewCount = $matches[2];
} else {
if (preg_match('/(.*)\\+\\d+ HOLD.*/i', $due, $matches)) {
$due = trim($matches[1]);
}
}
if (preg_match('/(\\d{2}-\\d{2}-\\d{2})/', $due, $dueMatches)) {
$dateDue = DateTime::createFromFormat('m-d-y', $dueMatches[1]);
if ($dateDue) {
$dueTime = $dateDue->getTimestamp();
} else {
$dueTime = null;
}
} else {
$dueTime = strtotime($due);
}
if ($dueTime != null) {
$daysUntilDue = ceil(($dueTime - time()) / (24 * 60 * 60));
$overdue = $daysUntilDue < 0;
$curTitle['duedate'] = $dueTime;
$curTitle['overdue'] = $overdue;
$curTitle['daysUntilDue'] = $daysUntilDue;
}
$curTitle['renewCount'] = $renewCount;
}
if (stripos($sKeys[$i], "BARCODE") > -1) {
$curTitle['barcode'] = strip_tags($scols[$i]);
}
if (stripos($sKeys[$i], "RENEW") > -1) {
$matches = array();
if (preg_match('/<input\\s*type="checkbox"\\s*name="renew(\\d+)"\\s*id="renew(\\d+)"\\s*value="(.*?)"\\s*\\/>/', $scols[$i], $matches)) {
$curTitle['canrenew'] = $patronCanRenew;
$curTitle['itemindex'] = $matches[1];
$curTitle['itemid'] = $matches[3];
$curTitle['renewIndicator'] = $curTitle['itemid'] . '|' . $curTitle['itemindex'];
$curTitle['renewMessage'] = '';
} else {
$curTitle['canrenew'] = false;
}
}
if (stripos($sKeys[$i], "CALL NUMBER") > -1) {
$curTitle['request'] = "null";
}
}
}
}
if ($sCount > 1) {
//Get additional information from resources table
if ($curTitle['shortId'] && strlen($curTitle['shortId']) > 0) {
$checkDigit = $this->driver->getCheckDigit($curTitle['shortId']);
$curTitle['recordId'] = '.' . $curTitle['shortId'] . $checkDigit;
$curTitle['id'] = '.' . $curTitle['shortId'] . $checkDigit;
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($curTitle['recordId']);
if ($recordDriver->isValid()) {
$curTitle['coverUrl'] = $recordDriver->getBookcoverUrl('medium');
$curTitle['groupedWorkId'] = $recordDriver->getGroupedWorkId();
$formats = $recordDriver->getFormats();
$curTitle['format'] = reset($formats);
$curTitle['author'] = $recordDriver->getPrimaryAuthor();
if (!isset($curTitle['title']) || empty($curTitle['title'])) {
$curTitle['title'] = $recordDriver->getTitle();
}
} else {
$curTitle['coverUrl'] = "";
$curTitle['groupedWorkId'] = "";
$curTitle['format'] = "Unknown";
$curTitle['author'] = "";
}
}
$sortTitle = isset($curTitle['title_sort']) ? $curTitle['title_sort'] : $curTitle['title'];
$sortKey = $sortTitle;
if ($sortOption == 'title') {
$sortKey = $sortTitle;
} elseif ($sortOption == 'author') {
$sortKey = (isset($curTitle['author']) ? $curTitle['author'] : "Unknown") . '-' . $sortTitle;
} elseif ($sortOption == 'dueDate') {
if (isset($curTitle['duedate'])) {
if (preg_match('/.*?(\\d{1,2})[-\\/](\\d{1,2})[-\\/](\\d{2,4}).*/', $curTitle['duedate'], $matches)) {
$sortKey = $matches[3] . '-' . $matches[1] . '-' . $matches[2] . '-' . $sortTitle;
} else {
$sortKey = $curTitle['duedate'] . '-' . $sortTitle;
}
}
} elseif ($sortOption == 'format') {
$sortKey = (isset($curTitle['format']) ? $curTitle['format'] : "Unknown") . '-' . $sortTitle;
} elseif ($sortOption == 'renewed') {
$sortKey = (isset($curTitle['renewCount']) ? $curTitle['renewCount'] : 0) . '-' . $sortTitle;
} elseif ($sortOption == 'holdQueueLength') {
$sortKey = (isset($curTitle['holdQueueLength']) ? $curTitle['holdQueueLength'] : 0) . '-' . $sortTitle;
}
$sortKey .= "_{$sCount}";
$checkedOutTitles[utf8_encode($sortKey)] = $curTitle;
}
$sCount++;
}
ksort($checkedOutTitles);
$timer->logTime("Parsed checkout information");
$numTransactions = count($checkedOutTitles);
//Process pagination
if ($recordsPerPage != -1) {
$startRecord = ($page - 1) * $recordsPerPage;
if ($startRecord > $numTransactions) {
$startRecord = 0;
}
$checkedOutTitles = array_slice($checkedOutTitles, $startRecord, $recordsPerPage);
}
return array('transactions' => $checkedOutTitles, 'numTransactions' => $numTransactions);
}
/**
* Display a "cover unavailable" graphic and terminate execution.
*/
function getDefaultCover()
{
$useDefaultNoCover = true;
//Get the resource for the cover so we can load the title and author
$title = '';
$author = '';
if ($this->type == 'grouped_work') {
$this->loadGroupedWork();
require_once ROOT_DIR . '/sys/Grouping/GroupedWork.php';
if ($this->groupedWork) {
$title = ucwords($this->groupedWork->getTitle());
$author = ucwords($this->groupedWork->getPrimaryAuthor());
$this->category = 'blank';
}
} elseif ($this->isEContent) {
require_once ROOT_DIR . '/sys/eContent/EContentRecord.php';
$econtentRecord = new EContentRecord();
$econtentRecord->id = $this->id;
if ($econtentRecord->find(true)) {
$title = $econtentRecord->title;
$author = $econtentRecord->author;
}
} else {
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($this->id);
if ($recordDriver->isValid()) {
$title = $recordDriver->getTitle();
$author = $recordDriver->getAuthor();
}
}
require_once ROOT_DIR . '/sys/DefaultCoverImageBuilder.php';
$coverBuilder = new DefaultCoverImageBuilder();
if (strlen($title) > 0 && $coverBuilder->blankCoverExists($this->format, $this->category)) {
$this->log("Looking for default cover, format is {$this->format} category is {$this->category}", PEAR_LOG_DEBUG);
$coverBuilder->getCover($title, $author, $this->format, $this->category, $this->cacheFile);
return $this->processImageURL($this->cacheFile);
} else {
$themeName = $this->configArray['Site']['theme'];
$noCoverUrl = "interface/themes/default/images/noCover2.png";
if (isset($this->format) && strlen($this->format) > 0) {
if (is_readable("interface/themes/{$themeName}/images/{$this->format}_{$this->size}.png")) {
$this->log("Found format image {$this->format}_{$this->size} .", PEAR_LOG_INFO);
$noCoverUrl = "interface/themes/{$themeName}/images/{$this->format}_{$this->size}.png";
$useDefaultNoCover = false;
} elseif (is_readable("interface/themes/{$themeName}/images/{$this->format}.png")) {
$noCoverUrl = "interface/themes/{$themeName}/images/{$this->format}.png";
header('Content-type: image/png');
$useDefaultNoCover = false;
} elseif (is_readable("interface/themes/default/images/{$this->format}_{$this->size}.png")) {
$this->log("Found format image {$this->format}_{$this->size} .", PEAR_LOG_INFO);
$noCoverUrl = "interface/themes/default/images/{$this->format}_{$this->size}.png";
header('Content-type: image/png');
$useDefaultNoCover = false;
} elseif (is_readable("interface/themes/default/images/{$this->format}.png")) {
$noCoverUrl = "interface/themes/default/images/{$this->format}.png";
header('Content-type: image/png');
$useDefaultNoCover = false;
}
}
if ($useDefaultNoCover && isset($this->category) && strlen($this->category) > 0) {
if (is_readable("interface/themes/{$themeName}/images/{$this->category}_{$this->size}.png")) {
$this->log("Found category image {$this->category}_{$this->size} .", PEAR_LOG_INFO);
$noCoverUrl = "interface/themes/{$themeName}/images/{$this->category}_{$this->size}.png";
$useDefaultNoCover = false;
} elseif (is_readable("interface/themes/{$themeName}/images/{$this->category}.png")) {
$noCoverUrl = "interface/themes/{$themeName}/images/{$this->category}.png";
header('Content-type: image/png');
$useDefaultNoCover = false;
} elseif (is_readable("interface/themes/default/images/{$this->category}_{$this->size}.png")) {
$this->log("Found category image {$this->category}_{$this->size} .", PEAR_LOG_INFO);
$noCoverUrl = "interface/themes/default/images/{$this->category}_{$this->size}.png";
header('Content-type: image/png');
$useDefaultNoCover = false;
} elseif (is_readable("interface/themes/default/images/{$this->category}.png")) {
$noCoverUrl = "interface/themes/default/images/{$this->category}.png";
header('Content-type: image/png');
$useDefaultNoCover = false;
}
}
if ($useDefaultNoCover) {
header('Content-type: image/png');
}
$ret = $this->processImageURL($noCoverUrl, true);
//$ret = copy($nocoverurl, $this->cacheFile);
if (!$ret) {
$this->error = "Unable to copy file {$noCoverUrl} to {$this->cacheFile}";
return false;
} else {
return true;
}
}
}
function getPurchaseOptions()
{
global $interface;
if (isset($_REQUEST['id'])) {
$id = $_REQUEST['id'];
$interface->assign('id', $id);
$marcRecord = MarcLoader::loadMarcRecordByILSId($id);
if ($marcRecord) {
$linkFields = $marcRecord->getFields('856');
$purchaseLinks = array();
if ($linkFields) {
$field856Index = 0;
/** @var File_MARC_Data_Field[] $linkFields */
foreach ($linkFields as $marcField) {
$field856Index++;
//Get the link
if ($marcField->getSubfield('u')) {
$link = $marcField->getSubfield('u')->getData();
if ($marcField->getSubfield('3')) {
$linkText = $marcField->getSubfield('3')->getData();
} elseif ($marcField->getSubfield('y')) {
$linkText = $marcField->getSubfield('y')->getData();
} elseif ($marcField->getSubfield('z')) {
$linkText = $marcField->getSubfield('z')->getData();
} else {
$linkText = $link;
}
//Process some links differently so we can either hide them
//or show them in different areas of the catalog.
if (preg_match('/purchase|buy/i', $linkText) || preg_match('/barnesandnoble|tatteredcover|amazon\\.com/i', $link)) {
if (preg_match('/barnesandnoble/i', $link)) {
$purchaseLinks[] = array('link' => $link, 'linkText' => 'Buy from Barnes & Noble', 'storeName' => 'Barnes & Noble', 'image' => '/images/barnes_and_noble.png', 'field856Index' => $field856Index);
} else {
if (preg_match('/tatteredcover/i', $link)) {
$purchaseLinks[] = array('link' => $link, 'linkText' => 'Buy from Tattered Cover', 'storeName' => 'Tattered Cover', 'image' => '/images/tattered_cover.png', 'field856Index' => $field856Index);
} else {
if (preg_match('/amazon\\.com/i', $link)) {
$purchaseLinks[] = array('link' => $link, 'linkText' => 'Buy from Amazon', 'storeName' => 'Amazon', 'image' => '/images/amazon.png', 'field856Index' => $field856Index);
} else {
if (preg_match('/smashwords\\.com/i', $link)) {
$purchaseLinks[] = array('link' => $link, 'linkText' => 'Buy from Smashwords', 'storeName' => 'Smashwords', 'image' => '/images/smashwords.png', 'field856Index' => $field856Index);
} else {
$purchaseLinks[] = array('link' => $link, 'linkText' => $linkText, 'storeName' => 'Smashwords', 'image' => '', 'field856Index' => $field856Index);
}
}
}
}
}
}
}
}
//End checking for purchase information in the marc record
if (count($purchaseLinks) > 0) {
$interface->assign('purchaseLinks', $purchaseLinks);
} else {
require_once ROOT_DIR . '/RecordDrivers/MarcRecord.php';
$recordDriver = new MarcRecord($id);
if ($recordDriver->isValid()) {
$title = $recordDriver->getTitle();
$author = $recordDriver->getAuthor();
require_once ROOT_DIR . '/services/Record/Purchase.php';
$purchaseLinks = Record_Purchase::getStoresForTitle($title, $author);
if (count($purchaseLinks) > 0) {
$interface->assign('purchaseLinks', $purchaseLinks);
} else {
$interface->assign('errors', array("Sorry we couldn't find any stores that offer this title."));
}
} else {
$interface->assign('errors', array("Sorry we couldn't find a resource for that id."));
}
}
} else {
$errors = array("Could not load marc information for that id.");
$interface->assign('errors', $errors);
}
} else {
$errors = array("You must provide the id of the title to be purchased. ");
$interface->assign('errors', $errors);
}
echo $interface->fetch('Record/ajax-purchase-options.tpl');
}
function getItemAvailability()
{
global $timer;
global $configArray;
$itemData = array();
//Load basic information
$this->id = $_GET['id'];
$itemData['id'] = $this->id;
// Setup Search Engine Connection
$class = $configArray['Index']['engine'];
$url = $configArray['Index']['url'];
$this->db = new $class($url);
// Retrieve Full Marc Record
disableErrorHandler();
$record = $this->db->getRecord($this->id);
enableErrorHandler();
if ($record == false) {
$marcRecord = new MarcRecord($this->id);
if ($marcRecord->isValid()) {
$itemData['holdings'] = Record_Holdings::loadHoldings($this->id);
$timer->logTime('Loaded Holdings');
} else {
$itemData['error'] = 'Cannot load Record for id ' . $record['id'];
}
} else {
$this->record = $record;
if ($record['recordtype'] == 'econtentRecord') {
require_once ROOT_DIR . '/sys/eContent/EContentRecord.php';
$eContentRecord = new EContentRecord();
$eContentRecord->id = substr($record['id'], strlen('econtentRecord'));
if (!$eContentRecord->find(true)) {
$itemData['error'] = 'Cannot load eContent Record for id ' . $record['id'];
} else {
require_once ROOT_DIR . '/Drivers/EContentDriver.php';
$driver = new EContentDriver();
$itemData['holdings'] = $driver->getHolding($eContentRecord->id);
}
} else {
$this->recordDriver = RecordDriverFactory::initRecordDriver($record);
$timer->logTime('Initialized the Record Driver');
//Load Holdings
$itemData['holdings'] = Record_Holdings::loadHoldings($this->id);
$timer->logTime('Loaded Holdings');
}
}
return $itemData;
}
