items.php

<?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');

    $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>