about summary refs log tree commit diff stats
path: root/classes/Handler/ListHandler.php
diff options
context:
space:
mode:
authorAndrew Dolgov <fox@fakecake.org>2026-05-26 11:06:30 +0300
committerAndrew Dolgov <fox@fakecake.org>2026-05-26 11:06:30 +0300
commitfa1bccd968647f6ab5cce0ec4293b39c6fde7633 (patch)
treea51b489a43bdfcc2688bd0855cf3e32382ad958c /classes/Handler/ListHandler.php
parentab7702f0e3dd63bdeaea3cb6db138878774c3b47 (diff)
downloadthe-epube-fa1bccd968647f6ab5cce0ec4293b39c6fde7633.tar.gz
the-epube-fa1bccd968647f6ab5cce0ec4293b39c6fde7633.tar.xz
spaces to tabs
Diffstat (limited to 'classes/Handler/ListHandler.php')
-rw-r--r--classes/Handler/ListHandler.php300
1 files changed, 150 insertions, 150 deletions
diff --git a/classes/Handler/ListHandler.php b/classes/Handler/ListHandler.php
index e4f6455..fbfb2b3 100644
--- a/classes/Handler/ListHandler.php
+++ b/classes/Handler/ListHandler.php
@@ -11,154 +11,154 @@ use PDO;
 
 class ListHandler implements RequestHandlerInterface, AuthRequired
 {
-    public function handle(Request $request): Response
-    {
-        $owner = $_SESSION["owner"] ?? "";
-        $mode = $request->getAttribute('mode', '');
-        $query = $request->getAttribute('query', '');
-        $limit = (int) $request->getAttribute('limit', 60);
-        $offset = (int) $request->getAttribute('offset', 0);
-
-        $ldb = \Db::pdo();
-        $caldb = new PDO('sqlite:' . Config::get(Config::CALIBRE_DB));
-
-        $ids_qpart = "1";
-
-        if ($mode == "favorites") {
-            $fav_sth = $ldb->prepare("SELECT bookid FROM epube_favorites WHERE owner = ?");
-            $fav_sth->execute([$owner]);
-
-            $fav_ids = [];
-            while ($line = $fav_sth->fetch()) {
-                array_push($fav_ids, $line["bookid"]);
-            }
-
-            if (empty($fav_ids)) {
-                return (new Response())->withBody(json_encode(["books" => [], "total" => 0]));
-            }
-
-            $ids_qpart = "books.id IN (" . implode(",", $fav_ids) . ")";
-        }
-
-        $order_by = $query ? "author_sort, series_name, series_index, title, books.id" : "books.id DESC";
-
-        $sth = $caldb->prepare("SELECT books.*, s.name AS series_name,
-            (SELECT id FROM data WHERE book = books.id AND format = 'EPUB' LIMIT 1) AS epub_id FROM books
-            LEFT JOIN books_series_link AS bsl ON (bsl.book = books.id)
-            LEFT JOIN series AS s ON (bsl.series = s.id)
-            WHERE
-                ((:query = '') OR
-                    (
-                        LOWER(books.author_sort) LIKE LOWER(:query) OR
-                        LOWER(books.title) LIKE LOWER(:query) OR
-                        LOWER(series_name) LIKE LOWER(:query)
-                    ))
-                AND $ids_qpart
-            ORDER BY $order_by LIMIT :limit OFFSET :offset");
-
-        $sth->execute([':limit' => $limit, ':offset' => $offset, ':query' => '%' . $query . '%']);
-
-        $books = [];
-        $total = 0;
-
-        while ($line = $sth->fetch()) {
-            $cover_link = "";
-            if ($line['has_cover']) {
-                $cover_filename = Config::get(Config::BOOKS_DIR) . "/" . $line["path"] . "/" . "cover.jpg";
-                if (file_exists($cover_filename)) {
-                    $cover_mtime = filemtime($cover_filename);
-                    $cover_link = "backend.php?" . http_build_query(["op" => "cover", "id" => $line["id"], "ts" => $cover_mtime]);
-                }
-            }
-
-            $read_link = "";
-            $in_progress = false;
-            $is_read = false;
-
-            if ($line["epub_id"]) {
-                $read_link = "read.html?" . http_build_query(["id" => $line["epub_id"], "rt" => $mode, "b" => $line["id"], "ts" => time()]);
-
-                $lastread_sth = $ldb->prepare("SELECT lastread, total_pages FROM epube_books, epube_pagination
-                    WHERE epube_pagination.bookid = epube_books.bookid AND
-                        epube_books.bookid = ? AND owner = ?");
-                $lastread_sth->execute([$line['epub_id'], $owner]);
-
-                if ($lastread_line = $lastread_sth->fetch()) {
-                    $lastread = $lastread_line["lastread"];
-                    $total_pages = $lastread_line["total_pages"];
-
-                    $is_read = $total_pages - $lastread < 5;
-                    $in_progress = $lastread > 1;
-                }
-            }
-
-            $series_link = "";
-            $series_full = "";
-
-            if ($line["series_name"]) {
-                $series_link = "?" . http_build_query(["query" => $line["series_name"]]);
-                $series_full = $line["series_name"] . " [" . $line["series_index"] . "]";
-            }
-
-            $data_sth = $caldb->prepare("SELECT * FROM data WHERE book = ? LIMIT 3");
-            $data_sth->execute([$line['id']]);
-
-            $download_formats = [];
-            while ($data_line = $data_sth->fetch()) {
-                if ($data_line["format"] != "ORIGINAL_EPUB") {
-                    $download_formats[] = [
-                        "format" => $data_line["format"],
-                        "id" => $data_line["id"],
-                    ];
-                }
-            }
-
-            $is_fav = false;
-            $fav_sth = $ldb->prepare("SELECT id FROM epube_favorites
-                WHERE bookid = ? AND owner = ? LIMIT 1");
-            $fav_sth->execute([$line['id'], $owner]);
-            if ($fav_sth->fetch()) {
-                $is_fav = true;
-            }
-
-            $books[] = [
-                "id" => $line["id"],
-                "title" => $line["title"],
-                "author_sort" => $line["author_sort"],
-                "series_name" => $line["series_name"] ?? "",
-                "series_index" => $line["series_index"] ?? 0,
-                "series_link" => $series_link,
-                "series_full" => $series_full,
-                "cover_link" => $cover_link,
-                "read_link" => $read_link,
-                "in_progress" => $in_progress,
-                "is_read" => $is_read,
-                "is_fav" => $is_fav,
-                "epub_id" => $line["epub_id"] ?? 0,
-                "download_formats" => $download_formats,
-            ];
-        }
-
-        // count total for pagination
-        $count_sth = $caldb->prepare("SELECT COUNT(*) FROM books
-            LEFT JOIN books_series_link AS bsl ON (bsl.book = books.id)
-            LEFT JOIN series AS s ON (bsl.series = s.id)
-            WHERE
-                ((:query = '%%') OR
-                    (
-                        LOWER(books.author_sort) LIKE LOWER(:query) OR
-                        LOWER(books.title) LIKE LOWER(:query) OR
-                        LOWER(s.name) LIKE LOWER(:query)
-                    ))
-                AND $ids_qpart");
-        $count_sth->execute([':query' => '%' . $query . '%']);
-        $total = (int) $count_sth->fetchColumn();
-
-        return (new Response())->withBody(json_encode([
-            "books" => $books,
-            "total" => $total,
-            "offset" => $offset,
-            "limit" => $limit,
-        ]));
-    }
+	public function handle(Request $request): Response
+	{
+		$owner = $_SESSION["owner"] ?? "";
+		$mode = $request->getAttribute('mode', '');
+		$query = $request->getAttribute('query', '');
+		$limit = (int) $request->getAttribute('limit', 60);
+		$offset = (int) $request->getAttribute('offset', 0);
+
+		$ldb = \Db::pdo();
+		$caldb = new PDO('sqlite:' . Config::get(Config::CALIBRE_DB));
+
+		$ids_qpart = "1";
+
+		if ($mode == "favorites") {
+			$fav_sth = $ldb->prepare("SELECT bookid FROM epube_favorites WHERE owner = ?");
+			$fav_sth->execute([$owner]);
+
+			$fav_ids = [];
+			while ($line = $fav_sth->fetch()) {
+				array_push($fav_ids, $line["bookid"]);
+			}
+
+			if (empty($fav_ids)) {
+				return (new Response())->withBody(json_encode(["books" => [], "total" => 0]));
+			}
+
+			$ids_qpart = "books.id IN (" . implode(",", $fav_ids) . ")";
+		}
+
+		$order_by = $query ? "author_sort, series_name, series_index, title, books.id" : "books.id DESC";
+
+		$sth = $caldb->prepare("SELECT books.*, s.name AS series_name,
+			(SELECT id FROM data WHERE book = books.id AND format = 'EPUB' LIMIT 1) AS epub_id FROM books
+			LEFT JOIN books_series_link AS bsl ON (bsl.book = books.id)
+			LEFT JOIN series AS s ON (bsl.series = s.id)
+			WHERE
+				((:query = '') OR
+					(
+						LOWER(books.author_sort) LIKE LOWER(:query) OR
+						LOWER(books.title) LIKE LOWER(:query) OR
+						LOWER(series_name) LIKE LOWER(:query)
+					))
+				AND $ids_qpart
+			ORDER BY $order_by LIMIT :limit OFFSET :offset");
+
+		$sth->execute([':limit' => $limit, ':offset' => $offset, ':query' => '%' . $query . '%']);
+
+		$books = [];
+		$total = 0;
+
+		while ($line = $sth->fetch()) {
+			$cover_link = "";
+			if ($line['has_cover']) {
+				$cover_filename = Config::get(Config::BOOKS_DIR) . "/" . $line["path"] . "/" . "cover.jpg";
+				if (file_exists($cover_filename)) {
+					$cover_mtime = filemtime($cover_filename);
+					$cover_link = "backend.php?" . http_build_query(["op" => "cover", "id" => $line["id"], "ts" => $cover_mtime]);
+				}
+			}
+
+			$read_link = "";
+			$in_progress = false;
+			$is_read = false;
+
+			if ($line["epub_id"]) {
+				$read_link = "read.html?" . http_build_query(["id" => $line["epub_id"], "rt" => $mode, "b" => $line["id"], "ts" => time()]);
+
+				$lastread_sth = $ldb->prepare("SELECT lastread, total_pages FROM epube_books, epube_pagination
+					WHERE epube_pagination.bookid = epube_books.bookid AND
+						epube_books.bookid = ? AND owner = ?");
+				$lastread_sth->execute([$line['epub_id'], $owner]);
+
+				if ($lastread_line = $lastread_sth->fetch()) {
+					$lastread = $lastread_line["lastread"];
+					$total_pages = $lastread_line["total_pages"];
+
+					$is_read = $total_pages - $lastread < 5;
+					$in_progress = $lastread > 1;
+				}
+			}
+
+			$series_link = "";
+			$series_full = "";
+
+			if ($line["series_name"]) {
+				$series_link = "?" . http_build_query(["query" => $line["series_name"]]);
+				$series_full = $line["series_name"] . " [" . $line["series_index"] . "]";
+			}
+
+			$data_sth = $caldb->prepare("SELECT * FROM data WHERE book = ? LIMIT 3");
+			$data_sth->execute([$line['id']]);
+
+			$download_formats = [];
+			while ($data_line = $data_sth->fetch()) {
+				if ($data_line["format"] != "ORIGINAL_EPUB") {
+					$download_formats[] = [
+						"format" => $data_line["format"],
+						"id" => $data_line["id"],
+					];
+				}
+			}
+
+			$is_fav = false;
+			$fav_sth = $ldb->prepare("SELECT id FROM epube_favorites
+				WHERE bookid = ? AND owner = ? LIMIT 1");
+			$fav_sth->execute([$line['id'], $owner]);
+			if ($fav_sth->fetch()) {
+				$is_fav = true;
+			}
+
+			$books[] = [
+				"id" => $line["id"],
+				"title" => $line["title"],
+				"author_sort" => $line["author_sort"],
+				"series_name" => $line["series_name"] ?? "",
+				"series_index" => $line["series_index"] ?? 0,
+				"series_link" => $series_link,
+				"series_full" => $series_full,
+				"cover_link" => $cover_link,
+				"read_link" => $read_link,
+				"in_progress" => $in_progress,
+				"is_read" => $is_read,
+				"is_fav" => $is_fav,
+				"epub_id" => $line["epub_id"] ?? 0,
+				"download_formats" => $download_formats,
+			];
+		}
+
+		// count total for pagination
+		$count_sth = $caldb->prepare("SELECT COUNT(*) FROM books
+			LEFT JOIN books_series_link AS bsl ON (bsl.book = books.id)
+			LEFT JOIN series AS s ON (bsl.series = s.id)
+			WHERE
+				((:query = '%%') OR
+					(
+						LOWER(books.author_sort) LIKE LOWER(:query) OR
+						LOWER(books.title) LIKE LOWER(:query) OR
+						LOWER(s.name) LIKE LOWER(:query)
+					))
+				AND $ids_qpart");
+		$count_sth->execute([':query' => '%' . $query . '%']);
+		$total = (int) $count_sth->fetchColumn();
+
+		return (new Response())->withBody(json_encode([
+			"books" => $books,
+			"total" => $total,
+			"offset" => $offset,
+			"limit" => $limit,
+		]));
+	}
 }