|
1
|
|
|
<?php |
|
2
|
|
|
/** |
|
3
|
|
|
* COPS (Calibre OPDS PHP Server) class file |
|
4
|
|
|
* |
|
5
|
|
|
* @license GPL 2 (http://www.gnu.org/licenses/gpl.html) |
|
6
|
|
|
* @author Sébastien Lucas <[email protected]> |
|
7
|
|
|
*/ |
|
8
|
|
|
|
|
9
|
|
|
class Serie |
|
10
|
|
|
{ |
|
11
|
|
|
const ALL_SERIES_ID = "cops:series"; |
|
|
|
|
|
|
12
|
|
|
const SERIES_COLUMNS = "series.id as id, series.name as name, series.sort as sort, count(*) as count"; |
|
|
|
|
|
|
13
|
|
|
const SQL_ALL_SERIES = "select {0} from series, books_series_link where series.id = series group by series.id, series.name, series.sort order by series.sort"; |
|
|
|
|
|
|
14
|
|
|
const SQL_SERIES_FOR_SEARCH = "select {0} from series, books_series_link where series.id = series and upper (series.name) like ? group by series.id, series.name, series.sort order by series.sort"; |
|
|
|
|
|
|
15
|
|
|
|
|
16
|
|
|
public $id; |
|
17
|
|
|
public $name; |
|
18
|
|
|
|
|
19
|
49 |
|
public function __construct($post) { |
|
20
|
49 |
|
$this->id = $post->id; |
|
21
|
49 |
|
$this->name = $post->name; |
|
22
|
49 |
|
} |
|
23
|
|
|
|
|
24
|
49 |
|
public function getUri () { |
|
25
|
49 |
|
return "?page=".Base::PAGE_SERIE_DETAIL."&id=$this->id"; |
|
|
|
|
|
|
26
|
|
|
} |
|
27
|
|
|
|
|
28
|
7 |
|
public function getEntryId () { |
|
29
|
7 |
|
return self::ALL_SERIES_ID.":".$this->id; |
|
|
|
|
|
|
30
|
|
|
} |
|
31
|
|
|
|
|
32
|
18 |
|
public static function getCount() { |
|
33
|
|
|
// str_format (localize("series.alphabetical", count(array)) |
|
|
|
|
|
|
34
|
18 |
|
return Base::getCountGeneric ("series", self::ALL_SERIES_ID, Base::PAGE_ALL_SERIES); |
|
|
|
|
|
|
35
|
|
|
} |
|
36
|
|
|
|
|
37
|
48 |
View Code Duplication |
public static function getSerieByBookId ($bookId) { |
|
38
|
48 |
|
$result = Base::getDb ()->prepare('select series.id as id, name |
|
39
|
|
|
from books_series_link, series |
|
40
|
48 |
|
where series.id = series and book = ?'); |
|
41
|
48 |
|
$result->execute (array ($bookId)); |
|
42
|
48 |
|
if ($post = $result->fetchObject ()) { |
|
43
|
43 |
|
return new Serie ($post); |
|
44
|
|
|
} |
|
45
|
21 |
|
return NULL; |
|
46
|
|
|
} |
|
47
|
|
|
|
|
48
|
1 |
View Code Duplication |
public static function getSerieById ($serieId) { |
|
49
|
1 |
|
$result = Base::getDb ()->prepare('select id, name from series where id = ?'); |
|
50
|
1 |
|
$result->execute (array ($serieId)); |
|
51
|
1 |
|
if ($post = $result->fetchObject ()) { |
|
52
|
1 |
|
return new Serie ($post); |
|
53
|
|
|
} |
|
54
|
|
|
return NULL; |
|
55
|
|
|
} |
|
56
|
|
|
|
|
57
|
2 |
|
public static function getAllSeries() { |
|
58
|
2 |
|
return Base::getEntryArrayWithBookNumber (self::SQL_ALL_SERIES, self::SERIES_COLUMNS, array (), "Serie"); |
|
|
|
|
|
|
59
|
|
|
} |
|
60
|
|
|
|
|
61
|
22 |
|
public static function getAllSeriesByQuery($query) { |
|
62
|
22 |
|
return Base::getEntryArrayWithBookNumber (self::SQL_SERIES_FOR_SEARCH, self::SERIES_COLUMNS, array ('%' . $query . '%'), "Serie"); |
|
|
|
|
|
|
63
|
|
|
} |
|
64
|
|
|
} |
|
65
|
|
|
|
PHP provides two ways to mark string literals. Either with single quotes
'literal'or with double quotes"literal". The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences.String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (
\') and the backslash (\\). Every other character is displayed as is.Double quoted string literals may contain other variables or more complex escape sequences.
will print an indented:
Single is ValueIf your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear.
For more information on PHP string literals and available escape sequences see the PHP core documentation.