diff options
| author | Andrew Dolgov <fox@fakecake.org> | 2026-05-26 11:06:30 +0300 |
|---|---|---|
| committer | Andrew Dolgov <fox@fakecake.org> | 2026-05-26 11:06:30 +0300 |
| commit | fa1bccd968647f6ab5cce0ec4293b39c6fde7633 (patch) | |
| tree | a51b489a43bdfcc2688bd0855cf3e32382ad958c /classes/Handler/ListHandler.php | |
| parent | ab7702f0e3dd63bdeaea3cb6db138878774c3b47 (diff) | |
| download | the-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.php | 300 |
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, + ])); + } } |
