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
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', ''));
$archived = setSessionVar('library_archived', getRequestVar('library_archived', 0));
$libraryUrlPrefix = CCEDocuments::resolveLibraryUrlPrefix();
?>
<h1> Recommended Reading
    <?php
    if (!CurrentStudent())
        echo " - Archived " . $_SESSION["StudentYear"];
    ?>
</h1>
<?php
$pageNum = getRequestVar('pageNum', 1);
$ipp = getRequestVar('ipp', 20);
$docSQL = "CCEBooks b "
        . "LEFT JOIN CCEModules m ON b.CCEModuleID = m.CCEModuleID "
        . "WHERE 1 = 1 ";

if (strlen($searchText) > 0) {
    $searchText = str_replace(' ', '%', $searchText);
    $docSQL .= " AND (b.DocumentName LIKE '%" . $searchText . "%' OR b.Edition LIKE '%" . $searchText . "%' OR b.Publisher LIKE '%" . $searchText . "%'"
            . " OR b.Authors LIKE '%" . $searchText . "%' OR b.ISBN LIKE '%" . $searchText . "%' OR b.PurchaseFrom LIKE '%" . $searchText . "%' "
            . "OR b.TelNumber LIKE '%" . $searchText . "%' OR b.Website 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 (CurrentStudent() && $archived == 0) {
    $docSQL .= " AND b.Archived=0";
} elseif ($archived == 1) {
    $docSQL .= " AND b.Archived=1";
} else {
    $docSQL .= " AND b.Archived=1 AND b.ArchiveYear<=" . $_SESSION["StudentYear"];
}

//echo $docSQL;

$readingLibrary = HTMLHelper::getPaginated($sqlf, $docSQL, array('DocumentName' => 'ASC'), $ipp, $pageNum, array('select-all-class' => 'recommended-reading-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>
                Document Name
            </th>
            <th>
                Download
            </th>
            <th>
                Module
            </th>
            <th>
                Details
            </th>
        </tr>
        <?php
        foreach ($readingLibrary['records'] as $readingLibraryDoc) {
            ?>
            <tr>
                <td>
                    <?php
//                    echo CCEDocuments::getDocumentThumb($readingLibraryDoc);
                    ?>
                    <?php
                    $documentHref = CCEDocuments::getLibraryDocumentHref($readingLibraryDoc, $libraryUrlPrefix);
                    if ($documentHref !== '') {
                        ?>
                        <a href="<?php echo $documentHref; ?>" target="_blank"
                       ><?php echo $readingLibraryDoc['DocumentName']; ?></a>
                        <?php
                    } else {
                        echo $readingLibraryDoc['DocumentName'];
                    }
                    ?>
                    
                </td>
                <td>
                </td>
                <td>
                    <?php echo CCEModules::getDocumentModuleName($readingLibraryDoc['CCEModuleID'], $readingLibraryDoc); ?>
                </td>
                <td class="text-small">
                    <b>Edition:</b> <?php echo $readingLibraryDoc['Edition']; ?><br />
                    <b>Authors:</b> <?php echo $readingLibraryDoc['Authors']; ?><br />
                    <b>Publisher:</b> <?php echo $readingLibraryDoc['Publisher']; ?><br />
                    <b>ISBN:</b> <?php echo $readingLibraryDoc['ISBN']; ?><br />
                    <b>Purchase from:</b> <?php echo $readingLibraryDoc['PurchaseFrom']; ?><br />
                    <b>Website:</b> <?php echo $readingLibraryDoc['Website']; ?><br />
                    <b>Telephone Number:</b> <?php echo $readingLibraryDoc['TelNumber']; ?><br />
                </td>
            </tr>
            <?php
        } //foreach
        ?>
    </table>
    <?php
} else {
    ?>
    <div class="alert alert-warning">No Recommended Reading Documents found</div>
    <?php
    if (strlen($resources['error']) > 0) {
        echo $resources['error'];
    }
}