Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
cleanup-images.php	1.14 KB	-rw-r--r--	2025-06-27 10:14
php_errors.log	6.04 KB	-rw-r--r--	2026-08-21 08:11
reading-library.html.php	5.2 KB	-rw-r--r--	2026-04-29 07:23
recommended-reading.html.php	4.41 KB	-rw-r--r--	2026-04-29 07:23
resource-centre.html.php	4.7 KB	-rw-r--r--	2026-06-01 08:49
templates.html.php	3.25 KB	-rw-r--r--	2026-04-29 07:23

Rename

<?php
//ini_set('display_errors', 1);
//error_reporting(E_ALL);

include($_SERVER['DOCUMENT_ROOT'] . "/cesanet/inc_functions.php");

$searchText = setSessionVar('library_search_text', getRequestVar('library_search_text', ''));
$moduleId = setSessionVar('library_cce_module_id', getRequestVar('library_cce_module_id', ''));
$categoryId = setSessionVar('library_cce_category_id', getRequestVar('library_cce_category_id', ''));
$archived = setSessionVar('library_archived', getRequestVar('library_archived', 0));
$libraryUrlPrefix = CCEDocuments::resolveLibraryUrlPrefix();
?>
<h1> Reading Library
    <?php
    if (!CurrentStudent() && !isConvenor()) {
        echo " - Archived " . $_SESSION["StudentYear"];
    }
    ?>
</h1>
<?php
$pageNum = getRequestVar('pageNum', 1);
$ipp = getRequestVar('ipp', 20);

if (!isset($_SESSION["StudentID"]) || $_SESSION["StudentID"] <= 0) {
    $_SESSION["StudentID"] = 0;
}

$docSQL = "CCEDocuments d "
        . "INNER JOIN CCEDocCategories dc ON d.DocumentCategory = dc.CCEDocCategoryID "
        . "LEFT JOIN CCEModules m ON d.CCEModuleID = m.CCEModuleID "
        . "WHERE (d.ReleaseDate IS NULL OR CONVERT_TZ(d.ReleaseDate, '+00:00', '-02:00') <= NOW()) "
        . "AND (d.ReleaseTime IS NULL OR CONVERT_TZ(d.ReleaseTime, '+00:00', '-02:00') <= CURRENT_TIME()) "
        . "AND (FIND_IN_SET(" . $_SESSION["StudentID"] . ", d.Students) > 0 OR " . $_SESSION["StudentID"] . " = 54 OR d.Students IS NULL)";

if (strlen($searchText) > 0) {
    $searchText = str_replace(' ', '%', $searchText);
    $docSQL .= " AND (d.DocumentCode LIKE '%" . $searchText . "%' OR d.DocumentName LIKE '%" . $searchText . "%' OR d.DocumentFile LIKE '%" . $searchText . "%' "
            . "OR d.DocumentURL LIKE '%" . $searchText . "%' OR d.PresenterName LIKE '%" . $searchText . "%' OR d.Description LIKE '%" . $searchText . "%' "
            . "OR d.KeyWords LIKE '%" . $searchText . "%' OR dc.CategoryName LIKE '%" . $searchText . "%' OR m.ModuleName LIKE '%" . $searchText . "%')";
}

if (strlen($moduleId) > 0) {
    if ($moduleId == 'g') {
        $docSQL .= " AND m.CCEModuleID IS NULL";
    } elseif ($moduleId > 0) {
        $docSQL .= " AND m.CCEModuleID = " . $moduleId;
    }
}

if ($categoryId > 0) {
    $docSQL .= " AND dc.CCEDocCategoryID = " . $categoryId;
}

if ((isConvenor() || CurrentStudent()) && $archived == 0) {
    $docSQL .= " AND d.Archived=0";
} elseif ($archived == 1) {
    $docSQL .= " AND d.Archived=1";
} else {
    $docSQL .= " AND ((d.Archived=1 AND d.ArchiveYear=" . $_SESSION["StudentYear"] . ") OR (d.Archived=0 AND d.DateCreated<'" . $_SESSION["StudentYear"] . "-12-31'))";
}

//echo $docSQL;

$readingLibrary = HTMLHelper::getPaginated($sqlf, $docSQL, array('DocumentName' => 'ASC'), $ipp, $pageNum, array('select-all-class' => 'reading-library-pager-links'));

if ($readingLibrary['totalRecords'] > 0) {
    ?>
    <table class="table" border="0" cellpadding="4" cellspacing="0">
        <tr>
            <th colspan="8">
                <?php echo $readingLibrary['pageSentences'] ?>
                <?php echo $readingLibrary['pageNav'] ?>
            </th>
        </tr>
        <tr>
            <th>
                Module Code
            </th>
            <th>
                Document Name
            </th>
            <th>
                Module
            </th>
            <th>
                Category
            </th>
        </tr>
        <?php
        foreach ($readingLibrary['records'] as $readingLibraryDoc) {
            ?>
            <tr>
                <td>
                    <?php
//                    echo CCEDocuments::getDocumentThumb($readingLibraryDoc);
                    $documentHref = CCEDocuments::getLibraryDocumentHref($readingLibraryDoc, $libraryUrlPrefix);
                    if ($documentHref !== '') {
                        ?>
                        <a href="<?php echo $documentHref; ?>" target="_blank"
                           ><?php echo $readingLibraryDoc['DocumentCode']; ?></a>
                           <?php
                    } else {
                        echo $readingLibraryDoc['DocumentCode'];
                    }
                       ?>
                </td>
                <td>
                    <?php
//                    echo CCEDocuments::getDocumentThumb($readingLibraryDoc);
                    if ($documentHref !== '') {
                        ?>
                        <a href="<?php echo $documentHref; ?>" target="_blank"
                           ><?php echo $readingLibraryDoc['DocumentName']; ?></a>
                           <?php
                    } else {
                        echo $readingLibraryDoc['DocumentName'];
                    }
                       ?>
                </td>
                <td>
                    <?php echo CCEModules::getDocumentModuleName($readingLibraryDoc['CCEModuleID'], $readingLibraryDoc); ?>
                </td>
                <td>
                    <?php echo $readingLibraryDoc['CategoryName']; ?>
                </td>
            </tr>
            <?php
        } //foreach
        ?>
    </table>
    <?php
} else {
    ?>
    <div class="alert alert-warning">No Reading Library Documents found</div>
    <?php
    if (strlen($readingLibrary['error']) > 0) {
//        echo $readingLibrary['error'];
    }
}