<?php

/**

* COPS (Calibre OPDS PHP Server) class file

*

* @license GPL 2 (http://www.gnu.org/licenses/gpl.html)

* @author Sébastien Lucas <sebastien@slucas.fr>

*/

require_once('base.php');

require_once('serie.php');

require_once('author.php');

require_once('rating.php');

require_once('publisher.php');

require_once('tag.php');

require_once('language.php');

require_once("customcolumn.php");

require_once('data.php');

require_once('resources/php-epub-meta/epub.php');

// Silly thing because PHP forbid string concatenation in class const

define ('SQL_BOOKS_LEFT_JOIN', "left outer join comments on comments.book = books.id

left outer join books_ratings_link on books_ratings_link.book = books.id

left outer join ratings on books_ratings_link.rating = ratings.id ");

define ('SQL_BOOKS_ALL', "select {0} from books " . SQL_BOOKS_LEFT_JOIN . " order by books.sort ");

define ('SQL_BOOKS_BY_PUBLISHER', "select {0} from books_publishers_link, books " . SQL_BOOKS_LEFT_JOIN . "

where books_publishers_link.book = books.id and publisher = ? {1} order by publisher");

define ('SQL_BOOKS_BY_FIRST_LETTER', "select {0} from books " . SQL_BOOKS_LEFT_JOIN . "

where upper (books.sort) like ? order by books.sort");

define ('SQL_BOOKS_BY_AUTHOR', "select {0} from books_authors_link, books " . SQL_BOOKS_LEFT_JOIN . "

where books_authors_link.book = books.id and author = ? {1} order by pubdate");

define ('SQL_BOOKS_BY_SERIE', "select {0} from books_series_link, books " . SQL_BOOKS_LEFT_JOIN . "

where books_series_link.book = books.id and series = ? {1} order by series_index");

define ('SQL_BOOKS_BY_TAG', "select {0} from books_tags_link, books " . SQL_BOOKS_LEFT_JOIN . "

where books_tags_link.book = books.id and tag = ? {1} order by sort");

define ('SQL_BOOKS_BY_LANGUAGE', "select {0} from books_languages_link, books " . SQL_BOOKS_LEFT_JOIN . "

where books_languages_link.book = books.id and lang_code = ? {1} order by sort");

define ('SQL_BOOKS_BY_CUSTOM', "select {0} from {2}, books " . SQL_BOOKS_LEFT_JOIN . "

where {2}.book = books.id and {2}.{3} = ? {1} order by sort");

define ('SQL_BOOKS_QUERY', "select {0} from books " . SQL_BOOKS_LEFT_JOIN . "

where (

exists (select null from authors, books_authors_link where book = books.id and author = authors.id and authors.name like ?) or

exists (select null from tags, books_tags_link where book = books.id and tag = tags.id and tags.name like ?) or

exists (select null from series, books_series_link on book = books.id and books_series_link.series = series.id and series.name like ?) or

exists (select null from publishers, books_publishers_link where book = books.id and books_publishers_link.publisher = publishers.id and publishers.name like ?) or

title like ?) {1} order by books.sort");

define ('SQL_BOOKS_RECENT', "select {0} from books " . SQL_BOOKS_LEFT_JOIN . "

where 1=1 {1} order by timestamp desc limit ");

define ('SQL_BOOKS_BY_RATING', "select {0} from books " . SQL_BOOKS_LEFT_JOIN . "

where books_ratings_link.book = books.id and ratings.id = ? {1} order by sort");

class Book extends Base {

}