<?php

$q;
//view only overtaken media
if (!empty($_GET["takenSince"])) {
    $datefilter=rotateDate($_GET["takenSince"]);

    $q = $db->prepare("SELECT media_id, reader_id, taken_date, latest_return_date FROM media_taken WHERE library_id=:lid AND return_date IS NULL AND taken_date<:sdate");
    $q->bindParam(":sdate",$datefilter);
} else {
    $q = $db->prepare("SELECT media_id, reader_id, taken_date, latest_return_date FROM media_taken WHERE library_id=:lid AND return_date IS NULL");
}
$q->bindParam(":lid",$session->value("library_id"));
$q->execute();

$d = $q->fetchAll();

if ($MC_TEXT) $entrys="<table class='w3-table-all jh-table-sortable'><thead><tr><td width=5%></td><td width=10%>MNR</td><td></td><td></td><td>Titel</td></tr></thead><tbody>";
else $entrys="<table class='w3-table-all jh-table-sortable'><thead><tr><td width=5%></td><td width=10%>MNR</td><td width=40%>Titel</td><td width=15%>Autor</td><td width=5%>LNR</td><td width=15%>Leser</td><td>Klasse</td><td width=10%>entliehen am</td></tr></thead><tbody>";
$q_mediaData = $db->prepare("SELECT media.title, reader.name, reader.forename, media.media_type_id, `class`.`number`, `class`.`post`, `class`.override_name, media.media_class_text, media.media_class_id, media.author FROM (media LEFT OUTER JOIN reader ON (reader.library_id=:lid AND reader.reader_key=:rid)) LEFT OUTER JOIN `class` ON (`class`.class_id=reader.class_id) WHERE media.media_code_id=:mid AND media.library_id=:lid");
$q_mediaData->bindParam(":lid",$session->value("library_id"));

$q_mediaTypeSymbol = $db->prepare("SELECT symbol FROM media_type WHERE media_type_id=:mti AND library_id=:lid");
$q_mediaTypeSymbol->bindParam(":lid",$session->value("library_id"));


$classFilterUsers=array();
if (isset($_GET["class"])&&intval($_GET["class"])>=0) {
    $q = $db->prepare("SELECT reader_key FROM reader WHERE library_id=:lid and class_id=:cid");
    $q->bindParam(":lid",$session->value("library_id"));
    $q->bindParam(":cid",$_GET["class"]);
    $q->execute();
    $cs = $q->fetchAll();
    foreach ($cs as $c) {
        array_push($classFilterUsers,$c[0]);
    }
}

foreach($d as $entry) {
    if (isFutureDate($entry[latest_return_date])) {
        //dont show - not overtaken
    } else {
        $q_mediaData->bindParam(":mid",$entry[media_id]);
        $q_mediaData->bindParam(":rid",$entry[reader_id]);
        $q_mediaData->execute();
        $mediaData = $q_mediaData->fetch();

        if (isset($_GET["mediaClass"])&&$_GET["mediaClass"]>0&&$_GET["mediaClass"]!=$mediaData["media_class_id"]) {
        } else {

            if ($_GET[checkOvertakenRed]=="true") {
                //show overtaken red color
                $overtaken_color="w3-red";
            } else {
                //hide overtaken red color
                $overtaken_color="";
            }

            $q_mediaTypeSymbol->bindParam(":mti",$mediaData[media_type_id]);
            $q_mediaTypeSymbol->execute();
            $mediaTypeSymbol = $q_mediaTypeSymbol->fetch()[0];

            //check if class filter is set
            if (isset($_GET["class"])&&intval($_GET["class"])>=0) {
                $cont=false;
                foreach($classFilterUsers as $fu) {
                    if ($entry['reader_id']==$fu) {
                        $cont=true;
                    }
                }
                if (!$cont) continue;
            }

            //media_class_text
            if ($MC_TEXT) $entrys.="<tr class=\"$overtaken_color\"><td><i class='fa fa-circle w3-text-red'></i></td><td><i class=\"".$mediaTypeSymbol." w3-margin-right-half\"></i>".$entry[media_id]."</td><td>".$mediaData["media_class_text"]."</td><td>".$mediaData[title]."</td></tr>";
            else $entrys.="<tr class=\"$overtaken_color\"><td><i class='fa fa-circle w3-text-red'></i></td><td><i class=\"".$mediaTypeSymbol." w3-margin-right-half\"></i>".$entry[media_id]."</td><td>".$mediaData[title]."</td><td>".$mediaData[author]."</td><td>".$entry[reader_id]."</td><td>".$mediaData[name]." ".$mediaData[forename]."</td><td>".$mediaData[number].$mediaData[post].$mediaData[override_name]."</td><td>".rotateDate($entry[taken_date])."</td></tr>";
        }
    }
}
$entrys.="</tbody></table>";

?>