public static function listForFrontend()
{
$renderer = new DA_Renderer();
$folders = DA_DatabaseHandler::getAllRows(FOLDERS_TABLE);
if (is_array($folders)) {
foreach ($folders as $key => $folder) {
$files = DA_DatabaseHandler::findInTable(FILES_TABLE, "parent_id", $folder["id"], "position ASC");
$folders[$key]["files"] = $files;
}
foreach ($folders as $fkey => $folder) {
foreach ($folder["files"] as $key => $file) {
if (self::checkFileForPic($file["filename"])) {
$file["thumbnail"] = 1;
}
if (self::getThumbForPdf($file["id"])) {
$file["thumbnail"] = 2;
}
$folders[$fkey]["files"][$key] = $file;
$cats = explode(",", $file["categories"]);
foreach ($cats as $cat) {
if ($cat) {
$categories[$cat] = $cat;
}
}
}
}
} else {
echo "<br/>no folders deployed yet.";
}
if (isset($_POST["category"]) && $_POST["category"] === "Alle Kategorien") {
$renderer->templatename = "allcatfrontend.html";
} else {
$renderer->templatename = "frontend.html";
}
$renderer->setTemplate();
$renderer->arr["folders"] = $folders;
if (isset($categories)) {
$renderer->arr["categories"] = $categories;
}
$renderer->arr["dapath"] = "/wp-content/uploads/downloadarea/";
return $renderer->renderArr();
}
/**
* Lists all files in db matching pattern
*/
public function listAllFiles()
{
$folders = DA_DatabaseHandler::getAllRows(FOLDERS_TABLE);
if (is_array($folders)) {
foreach ($folders as $key => $folder) {
$files = DA_DatabaseHandler::findInTable(FILES_TABLE, "parent_id", $folder["id"], "position ASC");
$folders[$key]["files"] = $files;
}
} else {
echo "<br/>no folders deployed yet.";
}
$this->renderer->templatename = "list.html";
$this->renderer->setTemplate();
$this->renderer->arr["folders"] = $folders;
return $this->renderer->renderArr();
}
