<?php

include_once 'data.php';

include_once 'functions.php';

session_write_close();

if (isset($_GET['file']))

$_GET['file'] = intval($_GET['file']);

//DELETE BUTTON IN ITEMS VIEW

if (isset($_GET['delete']) && isset($_GET['file']) && isset($_SESSION['permissions']) && $_SESSION['permissions'] == 'A') {

database_connect(IL_DATABASE_PATH, 'library');

$error = null;

$error = delete_record($dbHandle, $_GET['file']);

die($error);

}

if (isset($_GET['file'])) {

// Fetch ids from cache in history.

database_connect(IL_DATABASE_PATH, 'history');

if ($_SESSION['orderby'] == 'id') {

$result = $dbHandle->query("SELECT itemID FROM `" . $_SESSION['display_files'] .

"` WHERE id<=(SELECT id FROM `" . $_SESSION['display_files'] . "` WHERE itemID=" . $_GET['file'] . ")+10 ORDER BY id DESC LIMIT 22");

} else {

$result = $dbHandle->query("SELECT itemID FROM `" . $_SESSION['display_files'] .

"` WHERE id>=(SELECT id FROM `" . $_SESSION['display_files'] . "` WHERE itemID=" . $_GET['file'] . ")-10 LIMIT 22");

}

$export_files = array();

if ($result)

$export_files = $result->fetchAll(PDO::FETCH_COLUMN);

$dbHandle = null;

}

//CHECK IF ITEM IS STILL IN LIST AFTER CHANGES AND RELOAD

if (isset($_GET['checkitem']) && isset($_GET['files'])) {

$found = array();

// Fetch ids from cache in history.

database_connect(IL_DATABASE_PATH, 'library');

$quoted_path = $dbHandle->quote(IL_DATABASE_PATH . DIRECTORY_SEPARATOR . 'history.sq3');

$dbHandle->exec("ATTACH DATABASE $quoted_path as history");

foreach ($_GET['files'] as $file) {

$result = $dbHandle->query("SELECT id FROM history.`" . $_SESSION['display_files'] .

"` WHERE itemID=" . intval($file));

if ($result->fetchColumn())

$found[] = $file;

$result = null;

}

$diff = array_diff((array) $_GET['files'], (array) $found);

echo json_encode($diff);

die();

}

if (empty($export_files))

die('Error! No files to display.');

?>

<div id="items-left" class="noprint alternating_row" style="position:relative;float:left;width:233px;height:100%;overflow:scroll;border:0;margin:0">

<button class="items-nav backbutton" title="Back to list view (Q)"><i class="fa fa-times-circle"></i></button>

<button class="items-nav prevrecord" title="Previous Item (W)"><i class="fa fa-chevron-circle-up"></i></button>

<button class="items-nav nextrecord" title="Next Item (S)"><i class="fa fa-chevron-circle-down"></i></button>

<div style="clear:both"></div>

<?php

if (empty($_GET['file']))

$_GET['file'] = $export_files[0];

$key = array_search($_GET['file'], $export_files);

$offset = max($key - 9, 0);

$display_files = array_slice($export_files, $offset, 20);

if ($offset > 0) {

print '<button id="nav-prev" data-id="' . $export_files[$offset - 1] . '"><i class="fa fa-caret-up"></i></button>';

}

print '<div id="list-title-copy" style="padding:0.75em;font-weight:bold"></div><div class="separator"></div>';

$divs = array();

database_connect(IL_DATABASE_PATH, 'library');

$query = join(",", $display_files);

$result = $dbHandle->query("SELECT id,file,title FROM library WHERE id IN (" . $query . ")");

$dbHandle = null;

$result = $result->fetchAll(PDO::FETCH_ASSOC);

//SORT QUERY RESULTS

$tempresult = array();

foreach ($result as $row) {

$key = array_search($row['id'], $export_files);

$tempresult[$key] = $row;

}

ksort($tempresult);

$result = $tempresult;

foreach ($result as $item) {

$divs[] = '<div id="list-item-' . $item['id'] . '" data-id="' . $item['id'] . '" data-file="' . $item['file'] . '" class="items listleft">' .

lib_htmlspecialchars($item['title']) .

'</div>';

}

$result = null;

$hr = '<div class="separator"></div>';

print join($hr, $divs);

if ($offset < count($export_files) - 20) {

print '<button id="nav-next" data-id="' . $export_files[$offset + 20] . '"><i class="fa fa-caret-down"></i></button>';

}

?>

</div>

<div class="alternating_row middle-panel"

style="float:left;width:6px;height:100%;overflow:hidden;border-right:1px solid rgba(0,0,0,0.2);border-left:1px solid rgba(0,0,0,0.2);cursor:pointer">

<i class="fa fa-caret-left" style="position:relative;left:1px;top:48%"></i>

</div>

<div style="width:auto;height:100%;overflow:hidden" id="items-right" data-file="<?php echo $_GET['file'] ?>">

<?php

if (!empty($_GET['file'])) {

?>

<div class="noprint ui-state-default" id="items-menu">

<div class="tab" id="file-item" style="position:relative">

<i class="fa fa-home"></i><br>Item

<i class="fa fa-caret-right" style="position:absolute;top:0.5em;right:3px;opacity:0.5"></i>

</div>

<div class="tab" id="file-pdf" style="position:relative"

<?php

if (isset($_SESSION['pdfviewer']) && $_SESSION['pdfviewer'] == 'external')

echo 'data-mode="external"';

if (!isset($_SESSION['pdfviewer']) || (isset($_SESSION['pdfviewer']) && $_SESSION['pdfviewer'] == 'internal'))

echo 'data-mode="internal"';

?>

>

<i class="fa fa-file-pdf-o"></i><br>PDF

<i class="fa fa-caret-right" style="position:absolute;top:0.5em;right:3px;opacity:0.5"></i>

</div>

<div class="tab" id="file-notes" style="position:relative">

<i class="fa fa-pencil"></i><br>Notes

<i class="fa fa-caret-right" style="position:absolute;top:0.4em;right:3px;opacity:0.5"></i>

</div>

<div class="tab" id="file-categories">

<i class="fa fa-tags"></i><br>Categ.

</div>

<?php

if ($_SESSION['permissions'] != 'G') {

?>

<div class="tab" id="file-edit">

<i class="fa fa-cog"></i><br>Edit

</div>

<?php

}

?>

<div class="tab" id="file-files">

<i class="fa fa-paperclip"></i><br>Files

</div>

<div class="tab" id="file-discussion">

<i class="fa fa-comments-o"></i><br>Discuss

</div>

<div id="exportfilebutton">

<i class="fa fa-briefcase"></i><br>Export

</div>

<div id="emailbutton">

<a href="" target="_blank" style="display:inline-block;color:inherit">

<i class="fa fa-envelope-o"></i><br>E-Mail

</a>

</div>

<div id="printbutton">

<i class="fa fa-print"></i><br>Print

</div>

<?php

if (isset($_SESSION['auth'])) {

if ($_SESSION['permissions'] == 'A') {

?>

<div id="deletebutton" title="Permanently delete this record (Del)">

<i class="fa fa-trash-o"></i><br>Delete

</div>

<?php

}

}

?>

</div>

<div id="items-item-menu" style="display:none;width:5.5em;position:fixed;top:0;left:0;text-align: center;padding:8px 0;z-index: 2000;cursor: pointer;line-height:1.1em">

<i class="fa fa-external-link" style="font-size:16px"></i><br>New Tab

</div>

<div id="items-notes-menu" style="display:none;width:5.5em;position:fixed;top:0;left:0;text-align: center;padding:8px 0;z-index: 2000;cursor: pointer;line-height:1.1em">

<i class="fa fa-external-link" style="font-size:16px"></i><br>Edit

</div>

<div id="items-pdf-menu" style="display:none;position:fixed;top:0;left:0;width:calc(11em+1px);z-index: 2001;padding:0;border:0;margin:0;line-height:1.1em">

<div id="items-pdf-menu-a" style="display:inline-block;width:5.5em;text-align: center;padding:8px 0;cursor: pointer"

<?php

if (isset($_SESSION['pdfviewer']) && $_SESSION['pdfviewer'] == 'external')

echo 'data-mode="external"';

if (!isset($_SESSION['pdfviewer']) || (isset($_SESSION['pdfviewer']) && $_SESSION['pdfviewer'] == 'internal'))

echo 'data-mode="internal"';

?>

>

<i class="fa fa-external-link" style="font-size:16px"></i><br>

New Tab

</div>

<div id="items-pdf-menu-b" style="float:right;width:5.5em;text-align: center;padding:8px 0;cursor: pointer">

<i class="fa fa-download" style="font-size:16px"></i><br>Download

</div>

<div style="clear:both"></div>

</div>

<div id="file-panel" style="width:auto;height:48%;overflow:auto">

</div>

<?php

} else {

print '<h3>&nbsp;Error! This item does not exist.<br>&nbsp;Reload of the library is recommended.</h3>';

}

?>

</div>