@@ -64,6 +64,9 @@ discard block |
||
64 | 64 | $_SERVER['REDIRECT_STATUS'] = 404; |
65 | 65 | } |
66 | 66 | |
67 | +/** |
|
68 | + * @param string $name |
|
69 | + */ |
|
67 | 70 | function getURLParam($name, $default = NULL) |
68 | 71 | { |
69 | 72 | if (!empty ($_GET) && isset($_GET[$name]) && $_GET[$name] != '') { |
@@ -104,6 +107,11 @@ discard block |
||
104 | 107 | return $url . '?v=' . VERSION; |
105 | 108 | } |
106 | 109 | |
110 | +/** |
|
111 | + * @param string $xml |
|
112 | + * |
|
113 | + * @return string |
|
114 | + */ |
|
107 | 115 | function xml2xhtml($xml) |
108 | 116 | { |
109 | 117 | return preg_replace_callback('#<(\w+)([^>]*)\s*/>#s', function($m) { |
@@ -326,6 +334,9 @@ discard block |
||
326 | 334 | return $phrase; |
327 | 335 | } |
328 | 336 | |
337 | +/** |
|
338 | + * @param string $paramName |
|
339 | + */ |
|
329 | 340 | function addURLParameter($urlParams, $paramName, $paramValue) |
330 | 341 | { |
331 | 342 | if (empty ($urlParams)) { |
@@ -32,9 +32,9 @@ discard block |
||
32 | 32 | // Generate the function for the template |
33 | 33 | $template = new doT (); |
34 | 34 | $dot = $template->template ($page, array ('bookdetail' => $bookdetail, |
35 | - 'header' => $header, |
|
36 | - 'footer' => $footer, |
|
37 | - 'main' => $main)); |
|
35 | + 'header' => $header, |
|
36 | + 'footer' => $footer, |
|
37 | + 'main' => $main)); |
|
38 | 38 | // If there is a syntax error in the function created |
39 | 39 | // $dot will be equal to FALSE |
40 | 40 | if (!$dot) { |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | case LIBXML_ERR_WARNING: |
126 | 126 | $return .= 'Warning ' . $error->code . ': '; |
127 | 127 | break; |
128 | - case LIBXML_ERR_ERROR: |
|
128 | + case LIBXML_ERR_ERROR: |
|
129 | 129 | $return .= 'Error ' . $error->code . ': '; |
130 | 130 | break; |
131 | 131 | case LIBXML_ERR_FATAL: |
@@ -134,8 +134,8 @@ discard block |
||
134 | 134 | } |
135 | 135 | |
136 | 136 | $return .= trim($error->message) . |
137 | - "\n Line: " . $error->line . |
|
138 | - "\n Column: " . $error->column; |
|
137 | + "\n Line: " . $error->line . |
|
138 | + "\n Column: " . $error->column; |
|
139 | 139 | |
140 | 140 | if ($error->file) { |
141 | 141 | $return .= "\n File: " . $error->file; |
@@ -149,7 +149,9 @@ discard block |
||
149 | 149 | $errors = libxml_get_errors(); |
150 | 150 | |
151 | 151 | foreach ($errors as $error) { |
152 | - if ($error->code == 801) return false; |
|
152 | + if ($error->code == 801) { |
|
153 | + return false; |
|
154 | + } |
|
153 | 155 | } |
154 | 156 | return true; |
155 | 157 | } |
@@ -175,7 +177,9 @@ discard block |
||
175 | 177 | } |
176 | 178 | */ |
177 | 179 | |
178 | - if (!are_libxml_errors_ok ()) $output = 'HTML code not valid.'; |
|
180 | + if (!are_libxml_errors_ok ()) { |
|
181 | + $output = 'HTML code not valid.'; |
|
182 | + } |
|
179 | 183 | |
180 | 184 | libxml_use_internal_errors(false); |
181 | 185 | return $output; |
@@ -235,7 +239,9 @@ discard block |
||
235 | 239 | |
236 | 240 | // set default to 1 for any without q factor |
237 | 241 | foreach ($langs as $lang => $val) { |
238 | - if ($val === '') $langs[$lang] = 1; |
|
242 | + if ($val === '') { |
|
243 | + $langs[$lang] = 1; |
|
244 | + } |
|
239 | 245 | } |
240 | 246 | |
241 | 247 | // sort list based on value |
@@ -257,8 +263,7 @@ discard block |
||
257 | 263 | $lang = 'en'; |
258 | 264 | if (!empty($config['cops_language'])) { |
259 | 265 | $lang = $config['cops_language']; |
260 | - } |
|
261 | - elseif (isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) { |
|
266 | + } elseif (isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])) { |
|
262 | 267 | $langs = getAcceptLanguages(); |
263 | 268 | } |
264 | 269 | //echo var_dump($langs); |
@@ -284,12 +289,15 @@ discard block |
||
284 | 289 | function localize($phrase, $count=-1, $reset=false) |
285 | 290 | { |
286 | 291 | global $config; |
287 | - if ($count == 0) |
|
288 | - $phrase .= '.none'; |
|
289 | - if ($count == 1) |
|
290 | - $phrase .= '.one'; |
|
291 | - if ($count > 1) |
|
292 | - $phrase .= '.many'; |
|
292 | + if ($count == 0) { |
|
293 | + $phrase .= '.none'; |
|
294 | + } |
|
295 | + if ($count == 1) { |
|
296 | + $phrase .= '.one'; |
|
297 | + } |
|
298 | + if ($count > 1) { |
|
299 | + $phrase .= '.many'; |
|
300 | + } |
|
293 | 301 | |
294 | 302 | /* Static keyword is used to ensure the file is loaded only once */ |
295 | 303 | static $translations = NULL; |
@@ -38,14 +38,14 @@ discard block |
||
38 | 38 | // If there is a syntax error in the function created |
39 | 39 | // $dot will be equal to FALSE |
40 | 40 | if (!$dot) { |
41 | - return FALSE; |
|
41 | + return false; |
|
42 | 42 | } |
43 | 43 | // Execute the template |
44 | 44 | if (!empty ($data)) { |
45 | 45 | return $dot ($data); |
46 | 46 | } |
47 | 47 | |
48 | - return NULL; |
|
48 | + return null; |
|
49 | 49 | } |
50 | 50 | |
51 | 51 | function getQueryString() |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | $_SERVER['REDIRECT_STATUS'] = 404; |
65 | 65 | } |
66 | 66 | |
67 | -function getURLParam($name, $default = NULL) |
|
67 | +function getURLParam($name, $default = null) |
|
68 | 68 | { |
69 | 69 | if (!empty ($_GET) && isset($_GET[$name]) && $_GET[$name] != '') { |
70 | 70 | return $_GET[$name]; |
@@ -262,7 +262,7 @@ discard block |
||
262 | 262 | $langs = getAcceptLanguages(); |
263 | 263 | } |
264 | 264 | //echo var_dump($langs); |
265 | - $lang_file = NULL; |
|
265 | + $lang_file = null; |
|
266 | 266 | foreach ($langs as $language => $val) { |
267 | 267 | $temp_file = dirname(__FILE__). '/lang/Localization_' . $language . '.json'; |
268 | 268 | if (file_exists($temp_file)) { |
@@ -292,13 +292,13 @@ discard block |
||
292 | 292 | $phrase .= '.many'; |
293 | 293 | |
294 | 294 | /* Static keyword is used to ensure the file is loaded only once */ |
295 | - static $translations = NULL; |
|
295 | + static $translations = null; |
|
296 | 296 | if ($reset) { |
297 | - $translations = NULL; |
|
297 | + $translations = null; |
|
298 | 298 | } |
299 | 299 | /* If no instance of $translations has occured load the language file */ |
300 | 300 | if (is_null($translations)) { |
301 | - $lang_file_en = NULL; |
|
301 | + $lang_file_en = null; |
|
302 | 302 | list ($lang, $lang_file) = getLangAndTranslationFile(); |
303 | 303 | if ($lang != 'en') { |
304 | 304 | $lang_file_en = dirname(__FILE__). '/lang/' . 'Localization_en.json'; |
@@ -8,8 +8,8 @@ discard block |
||
8 | 8 | |
9 | 9 | require 'config.php'; |
10 | 10 | |
11 | -define ('VERSION', '1.2.0'); |
|
12 | -define ('DB', 'db'); |
|
11 | +define('VERSION', '1.2.0'); |
|
12 | +define('DB', 'db'); |
|
13 | 13 | date_default_timezone_set($config['default_timezone']); |
14 | 14 | |
15 | 15 | |
@@ -22,7 +22,7 @@ discard block |
||
22 | 22 | function serverSideRender($data) |
23 | 23 | { |
24 | 24 | // Get the templates |
25 | - $theme = getCurrentTemplate (); |
|
25 | + $theme = getCurrentTemplate(); |
|
26 | 26 | $header = file_get_contents('templates/' . $theme . '/header.html'); |
27 | 27 | $footer = file_get_contents('templates/' . $theme . '/footer.html'); |
28 | 28 | $main = file_get_contents('templates/' . $theme . '/main.html'); |
@@ -30,8 +30,8 @@ discard block |
||
30 | 30 | $page = file_get_contents('templates/' . $theme . '/page.html'); |
31 | 31 | |
32 | 32 | // Generate the function for the template |
33 | - $template = new doT (); |
|
34 | - $dot = $template->template ($page, array ('bookdetail' => $bookdetail, |
|
33 | + $template = new doT(); |
|
34 | + $dot = $template->template($page, array('bookdetail' => $bookdetail, |
|
35 | 35 | 'header' => $header, |
36 | 36 | 'footer' => $footer, |
37 | 37 | 'main' => $main)); |
@@ -42,7 +42,7 @@ discard block |
||
42 | 42 | } |
43 | 43 | // Execute the template |
44 | 44 | if (!empty ($data)) { |
45 | - return $dot ($data); |
|
45 | + return $dot($data); |
|
46 | 46 | } |
47 | 47 | |
48 | 48 | return NULL; |
@@ -58,7 +58,7 @@ discard block |
||
58 | 58 | |
59 | 59 | function notFound() |
60 | 60 | { |
61 | - header($_SERVER['SERVER_PROTOCOL'].' 404 Not Found'); |
|
61 | + header($_SERVER['SERVER_PROTOCOL'] . ' 404 Not Found'); |
|
62 | 62 | header('Status: 404 Not Found'); |
63 | 63 | |
64 | 64 | $_SERVER['REDIRECT_STATUS'] = 404; |
@@ -76,8 +76,8 @@ discard block |
||
76 | 76 | { |
77 | 77 | global $config; |
78 | 78 | if (isset($_COOKIE[$option])) { |
79 | - if (isset($config ['cops_' . $option]) && is_array ($config ['cops_' . $option])) { |
|
80 | - return explode (',', $_COOKIE[$option]); |
|
79 | + if (isset($config ['cops_' . $option]) && is_array($config ['cops_' . $option])) { |
|
80 | + return explode(',', $_COOKIE[$option]); |
|
81 | 81 | } else { |
82 | 82 | return $_COOKIE[$option]; |
83 | 83 | } |
@@ -91,12 +91,12 @@ discard block |
||
91 | 91 | |
92 | 92 | function getCurrentCss() |
93 | 93 | { |
94 | - return 'templates/' . getCurrentTemplate () . '/styles/style-' . getCurrentOption('style') . '.css'; |
|
94 | + return 'templates/' . getCurrentTemplate() . '/styles/style-' . getCurrentOption('style') . '.css'; |
|
95 | 95 | } |
96 | 96 | |
97 | 97 | function getCurrentTemplate() |
98 | 98 | { |
99 | - return getCurrentOption ('template'); |
|
99 | + return getCurrentOption('template'); |
|
100 | 100 | } |
101 | 101 | |
102 | 102 | function getUrlWithVersion($url) |
@@ -160,10 +160,10 @@ discard block |
||
160 | 160 | libxml_use_internal_errors(true); |
161 | 161 | |
162 | 162 | $doc->loadHTML('<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body>' . |
163 | - $html . '</body></html>'); // Load the HTML |
|
163 | + $html . '</body></html>'); // Load the HTML |
|
164 | 164 | $output = $doc->saveXML($doc->documentElement); // Transform to an Ansi xml stream |
165 | 165 | $output = xml2xhtml($output); |
166 | - if (preg_match ('#<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></meta></head><body>(.*)</body></html>#ms', $output, $matches)) { |
|
166 | + if (preg_match('#<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></meta></head><body>(.*)</body></html>#ms', $output, $matches)) { |
|
167 | 167 | $output = $matches [1]; // Remove <html><body> |
168 | 168 | } |
169 | 169 | /* |
@@ -175,7 +175,7 @@ discard block |
||
175 | 175 | } |
176 | 176 | */ |
177 | 177 | |
178 | - if (!are_libxml_errors_ok ()) $output = 'HTML code not valid.'; |
|
178 | + if (!are_libxml_errors_ok()) $output = 'HTML code not valid.'; |
|
179 | 179 | |
180 | 180 | libxml_use_internal_errors(false); |
181 | 181 | return $output; |
@@ -264,7 +264,7 @@ discard block |
||
264 | 264 | //echo var_dump($langs); |
265 | 265 | $lang_file = NULL; |
266 | 266 | foreach ($langs as $language => $val) { |
267 | - $temp_file = dirname(__FILE__). '/lang/Localization_' . $language . '.json'; |
|
267 | + $temp_file = dirname(__FILE__) . '/lang/Localization_' . $language . '.json'; |
|
268 | 268 | if (file_exists($temp_file)) { |
269 | 269 | $lang = $language; |
270 | 270 | $lang_file = $temp_file; |
@@ -272,7 +272,7 @@ discard block |
||
272 | 272 | } |
273 | 273 | } |
274 | 274 | if (empty ($lang_file)) { |
275 | - $lang_file = dirname(__FILE__). '/lang/Localization_' . $lang . '.json'; |
|
275 | + $lang_file = dirname(__FILE__) . '/lang/Localization_' . $lang . '.json'; |
|
276 | 276 | } |
277 | 277 | return array($lang, $lang_file); |
278 | 278 | } |
@@ -281,7 +281,7 @@ discard block |
||
281 | 281 | * This method is based on this page |
282 | 282 | * http://www.mind-it.info/2010/02/22/a-simple-approach-to-localization-in-php/ |
283 | 283 | */ |
284 | -function localize($phrase, $count=-1, $reset=false) |
|
284 | +function localize($phrase, $count = -1, $reset = false) |
|
285 | 285 | { |
286 | 286 | global $config; |
287 | 287 | if ($count == 0) |
@@ -301,7 +301,7 @@ discard block |
||
301 | 301 | $lang_file_en = NULL; |
302 | 302 | list ($lang, $lang_file) = getLangAndTranslationFile(); |
303 | 303 | if ($lang != 'en') { |
304 | - $lang_file_en = dirname(__FILE__). '/lang/' . 'Localization_en.json'; |
|
304 | + $lang_file_en = dirname(__FILE__) . '/lang/' . 'Localization_en.json'; |
|
305 | 305 | } |
306 | 306 | |
307 | 307 | $lang_file_content = file_get_contents($lang_file); |
@@ -309,18 +309,18 @@ discard block |
||
309 | 309 | $translations = json_decode($lang_file_content, true); |
310 | 310 | |
311 | 311 | /* Clean the array of all unfinished translations */ |
312 | - foreach (array_keys ($translations) as $key) { |
|
313 | - if (preg_match ('/^##TODO##/', $key)) { |
|
312 | + foreach (array_keys($translations) as $key) { |
|
313 | + if (preg_match('/^##TODO##/', $key)) { |
|
314 | 314 | unset ($translations [$key]); |
315 | 315 | } |
316 | 316 | } |
317 | 317 | if (!is_null($lang_file_en)) { |
318 | 318 | $lang_file_content = file_get_contents($lang_file_en); |
319 | 319 | $translations_en = json_decode($lang_file_content, true); |
320 | - $translations = array_merge ($translations_en, $translations); |
|
320 | + $translations = array_merge($translations_en, $translations); |
|
321 | 321 | } |
322 | 322 | } |
323 | - if (array_key_exists ($phrase, $translations)) { |
|
323 | + if (array_key_exists($phrase, $translations)) { |
|
324 | 324 | return $translations[$phrase]; |
325 | 325 | } |
326 | 326 | return $phrase; |
@@ -332,7 +332,7 @@ discard block |
||
332 | 332 | $urlParams = ''; |
333 | 333 | } |
334 | 334 | $start = ''; |
335 | - if (preg_match ('#^\?(.*)#', $urlParams, $matches)) { |
|
335 | + if (preg_match('#^\?(.*)#', $urlParams, $matches)) { |
|
336 | 336 | $start = '?'; |
337 | 337 | $urlParams = $matches[1]; |
338 | 338 | } |
@@ -62,6 +62,9 @@ discard block |
||
62 | 62 | return self::getEntryArray (self::SQL_AUTHORS_BY_FIRST_LETTER, array ($letter . "%")); |
63 | 63 | } |
64 | 64 | |
65 | + /** |
|
66 | + * @param string $query |
|
67 | + */ |
|
65 | 68 | public static function getAuthorsForSearch($query) { |
66 | 69 | return self::getEntryArray (self::SQL_AUTHORS_FOR_SEARCH, array ($query . "%", $query . "%")); |
67 | 70 | } |
@@ -70,6 +73,9 @@ discard block |
||
70 | 73 | return self::getEntryArray (self::SQL_ALL_AUTHORS, array ()); |
71 | 74 | } |
72 | 75 | |
76 | + /** |
|
77 | + * @param string $query |
|
78 | + */ |
|
73 | 79 | public static function getEntryArray ($query, $params) { |
74 | 80 | return Base::getEntryArrayWithBookNumber ($query, self::AUTHOR_COLUMNS, $params, "Author"); |
75 | 81 | } |
@@ -25,69 +25,69 @@ |
||
25 | 25 | $this->sort = $post->sort; |
26 | 26 | } |
27 | 27 | |
28 | - public function getUri () { |
|
29 | - return "?page=".parent::PAGE_AUTHOR_DETAIL."&id=$this->id"; |
|
28 | + public function getUri() { |
|
29 | + return "?page=" . parent::PAGE_AUTHOR_DETAIL . "&id=$this->id"; |
|
30 | 30 | } |
31 | 31 | |
32 | - public function getEntryId () { |
|
33 | - return self::ALL_AUTHORS_ID.":".$this->id; |
|
32 | + public function getEntryId() { |
|
33 | + return self::ALL_AUTHORS_ID . ":" . $this->id; |
|
34 | 34 | } |
35 | 35 | |
36 | - public static function getEntryIdByLetter ($startingLetter) { |
|
37 | - return self::ALL_AUTHORS_ID.":letter:".$startingLetter; |
|
36 | + public static function getEntryIdByLetter($startingLetter) { |
|
37 | + return self::ALL_AUTHORS_ID . ":letter:" . $startingLetter; |
|
38 | 38 | } |
39 | 39 | |
40 | 40 | public static function getCount() { |
41 | 41 | // str_format (localize("authors.alphabetical", count(array)) |
42 | - return parent::getCountGeneric ("authors", self::ALL_AUTHORS_ID, parent::PAGE_ALL_AUTHORS); |
|
42 | + return parent::getCountGeneric("authors", self::ALL_AUTHORS_ID, parent::PAGE_ALL_AUTHORS); |
|
43 | 43 | } |
44 | 44 | |
45 | 45 | public static function getAllAuthorsByFirstLetter() { |
46 | - list (, $result) = parent::executeQuery ("select {0} |
|
46 | + list (, $result) = parent::executeQuery("select {0} |
|
47 | 47 | from authors |
48 | 48 | group by substr (upper (sort), 1, 1) |
49 | -order by substr (upper (sort), 1, 1)", "substr (upper (sort), 1, 1) as title, count(*) as count", "", array (), -1); |
|
49 | +order by substr (upper (sort), 1, 1)", "substr (upper (sort), 1, 1) as title, count(*) as count", "", array(), -1); |
|
50 | 50 | $entryArray = array(); |
51 | - while ($post = $result->fetchObject ()) |
|
51 | + while ($post = $result->fetchObject()) |
|
52 | 52 | { |
53 | - array_push ($entryArray, new Entry ($post->title, Author::getEntryIdByLetter ($post->title), |
|
54 | - str_format (localize("authorword", $post->count), $post->count), "text", |
|
55 | - array ( new LinkNavigation ("?page=".parent::PAGE_AUTHORS_FIRST_LETTER."&id=". rawurlencode ($post->title))), "", $post->count)); |
|
53 | + array_push($entryArray, new Entry($post->title, Author::getEntryIdByLetter($post->title), |
|
54 | + str_format(localize("authorword", $post->count), $post->count), "text", |
|
55 | + array(new LinkNavigation("?page=" . parent::PAGE_AUTHORS_FIRST_LETTER . "&id=" . rawurlencode($post->title))), "", $post->count)); |
|
56 | 56 | } |
57 | 57 | return $entryArray; |
58 | 58 | } |
59 | 59 | |
60 | 60 | public static function getAuthorsByStartingLetter($letter) { |
61 | - return self::getEntryArray (self::SQL_AUTHORS_BY_FIRST_LETTER, array ($letter . "%")); |
|
61 | + return self::getEntryArray(self::SQL_AUTHORS_BY_FIRST_LETTER, array($letter . "%")); |
|
62 | 62 | } |
63 | 63 | |
64 | 64 | public static function getAuthorsForSearch($query) { |
65 | - return self::getEntryArray (self::SQL_AUTHORS_FOR_SEARCH, array ($query . "%", $query . "%")); |
|
65 | + return self::getEntryArray(self::SQL_AUTHORS_FOR_SEARCH, array($query . "%", $query . "%")); |
|
66 | 66 | } |
67 | 67 | |
68 | 68 | public static function getAllAuthors() { |
69 | - return self::getEntryArray (self::SQL_ALL_AUTHORS, array ()); |
|
69 | + return self::getEntryArray(self::SQL_ALL_AUTHORS, array()); |
|
70 | 70 | } |
71 | 71 | |
72 | - public static function getEntryArray ($query, $params) { |
|
73 | - return Base::getEntryArrayWithBookNumber ($query, self::AUTHOR_COLUMNS, $params, "Author"); |
|
72 | + public static function getEntryArray($query, $params) { |
|
73 | + return Base::getEntryArrayWithBookNumber($query, self::AUTHOR_COLUMNS, $params, "Author"); |
|
74 | 74 | } |
75 | 75 | |
76 | - public static function getAuthorById ($authorId) { |
|
77 | - $result = parent::getDb ()->prepare('select ' . self::AUTHOR_COLUMNS . ' from authors where id = ?'); |
|
78 | - $result->execute (array ($authorId)); |
|
79 | - $post = $result->fetchObject (); |
|
80 | - return new Author ($post); |
|
76 | + public static function getAuthorById($authorId) { |
|
77 | + $result = parent::getDb()->prepare('select ' . self::AUTHOR_COLUMNS . ' from authors where id = ?'); |
|
78 | + $result->execute(array($authorId)); |
|
79 | + $post = $result->fetchObject(); |
|
80 | + return new Author($post); |
|
81 | 81 | } |
82 | 82 | |
83 | - public static function getAuthorByBookId ($bookId) { |
|
84 | - $result = parent::getDb ()->prepare('select authors.id as id, authors.name as name, authors.sort as sort from authors, books_authors_link |
|
83 | + public static function getAuthorByBookId($bookId) { |
|
84 | + $result = parent::getDb()->prepare('select authors.id as id, authors.name as name, authors.sort as sort from authors, books_authors_link |
|
85 | 85 | where author = authors.id |
86 | 86 | and book = ? order by books_authors_link.id'); |
87 | - $result->execute (array ($bookId)); |
|
88 | - $authorArray = array (); |
|
89 | - while ($post = $result->fetchObject ()) { |
|
90 | - array_push ($authorArray, new Author ($post)); |
|
87 | + $result->execute(array($bookId)); |
|
88 | + $authorArray = array(); |
|
89 | + while ($post = $result->fetchObject()) { |
|
90 | + array_push($authorArray, new Author($post)); |
|
91 | 91 | } |
92 | 92 | return $authorArray; |
93 | 93 | } |
@@ -19,37 +19,42 @@ discard block |
||
19 | 19 | public $name; |
20 | 20 | public $sort; |
21 | 21 | |
22 | - public function __construct($post) { |
|
22 | + public function __construct($post) |
|
23 | + { |
|
23 | 24 | $this->id = $post->id; |
24 | 25 | $this->name = str_replace("|", ",", $post->name); |
25 | 26 | $this->sort = $post->sort; |
26 | 27 | } |
27 | 28 | |
28 | - public function getUri () { |
|
29 | + public function getUri () |
|
30 | + { |
|
29 | 31 | return "?page=".parent::PAGE_AUTHOR_DETAIL."&id=$this->id"; |
30 | 32 | } |
31 | 33 | |
32 | - public function getEntryId () { |
|
34 | + public function getEntryId () |
|
35 | + { |
|
33 | 36 | return self::ALL_AUTHORS_ID.":".$this->id; |
34 | 37 | } |
35 | 38 | |
36 | - public static function getEntryIdByLetter ($startingLetter) { |
|
39 | + public static function getEntryIdByLetter ($startingLetter) |
|
40 | + { |
|
37 | 41 | return self::ALL_AUTHORS_ID.":letter:".$startingLetter; |
38 | 42 | } |
39 | 43 | |
40 | - public static function getCount() { |
|
44 | + public static function getCount() |
|
45 | + { |
|
41 | 46 | // str_format (localize("authors.alphabetical", count(array)) |
42 | 47 | return parent::getCountGeneric ("authors", self::ALL_AUTHORS_ID, parent::PAGE_ALL_AUTHORS); |
43 | 48 | } |
44 | 49 | |
45 | - public static function getAllAuthorsByFirstLetter() { |
|
50 | + public static function getAllAuthorsByFirstLetter() |
|
51 | + { |
|
46 | 52 | list (, $result) = parent::executeQuery ("select {0} |
47 | 53 | from authors |
48 | 54 | group by substr (upper (sort), 1, 1) |
49 | 55 | order by substr (upper (sort), 1, 1)", "substr (upper (sort), 1, 1) as title, count(*) as count", "", array (), -1); |
50 | 56 | $entryArray = array(); |
51 | - while ($post = $result->fetchObject ()) |
|
52 | - { |
|
57 | + while ($post = $result->fetchObject ()) { |
|
53 | 58 | array_push ($entryArray, new Entry ($post->title, Author::getEntryIdByLetter ($post->title), |
54 | 59 | str_format (localize("authorword", $post->count), $post->count), "text", |
55 | 60 | array ( new LinkNavigation ("?page=".parent::PAGE_AUTHORS_FIRST_LETTER."&id=". rawurlencode ($post->title))), "", $post->count)); |
@@ -57,30 +62,36 @@ discard block |
||
57 | 62 | return $entryArray; |
58 | 63 | } |
59 | 64 | |
60 | - public static function getAuthorsByStartingLetter($letter) { |
|
65 | + public static function getAuthorsByStartingLetter($letter) |
|
66 | + { |
|
61 | 67 | return self::getEntryArray (self::SQL_AUTHORS_BY_FIRST_LETTER, array ($letter . "%")); |
62 | 68 | } |
63 | 69 | |
64 | - public static function getAuthorsForSearch($query) { |
|
70 | + public static function getAuthorsForSearch($query) |
|
71 | + { |
|
65 | 72 | return self::getEntryArray (self::SQL_AUTHORS_FOR_SEARCH, array ($query . "%", $query . "%")); |
66 | 73 | } |
67 | 74 | |
68 | - public static function getAllAuthors() { |
|
75 | + public static function getAllAuthors() |
|
76 | + { |
|
69 | 77 | return self::getEntryArray (self::SQL_ALL_AUTHORS, array ()); |
70 | 78 | } |
71 | 79 | |
72 | - public static function getEntryArray ($query, $params) { |
|
80 | + public static function getEntryArray ($query, $params) |
|
81 | + { |
|
73 | 82 | return Base::getEntryArrayWithBookNumber ($query, self::AUTHOR_COLUMNS, $params, "Author"); |
74 | 83 | } |
75 | 84 | |
76 | - public static function getAuthorById ($authorId) { |
|
85 | + public static function getAuthorById ($authorId) |
|
86 | + { |
|
77 | 87 | $result = parent::getDb ()->prepare('select ' . self::AUTHOR_COLUMNS . ' from authors where id = ?'); |
78 | 88 | $result->execute (array ($authorId)); |
79 | 89 | $post = $result->fetchObject (); |
80 | 90 | return new Author ($post); |
81 | 91 | } |
82 | 92 | |
83 | - public static function getAuthorByBookId ($bookId) { |
|
93 | + public static function getAuthorByBookId ($bookId) |
|
94 | + { |
|
84 | 95 | $result = parent::getDb ()->prepare('select authors.id as id, authors.name as name, authors.sort as sort from authors, books_authors_link |
85 | 96 | where author = authors.id |
86 | 97 | and book = ? order by books_authors_link.id'); |
@@ -84,6 +84,9 @@ discard block |
||
84 | 84 | return ""; |
85 | 85 | } |
86 | 86 | |
87 | + /** |
|
88 | + * @return string |
|
89 | + */ |
|
87 | 90 | public static function getDbDirectory ($database = NULL) { |
88 | 91 | global $config; |
89 | 92 | if (self::isMultipleDatabaseEnabled ()) { |
@@ -143,10 +146,18 @@ discard block |
||
143 | 146 | self::$db = NULL; |
144 | 147 | } |
145 | 148 | |
149 | + /** |
|
150 | + * @param string $query |
|
151 | + */ |
|
146 | 152 | public static function executeQuerySingle ($query, $database = NULL) { |
147 | 153 | return self::getDb ($database)->query($query)->fetchColumn(); |
148 | 154 | } |
149 | 155 | |
156 | + /** |
|
157 | + * @param string $table |
|
158 | + * @param string $id |
|
159 | + * @param string $numberOfString |
|
160 | + */ |
|
150 | 161 | public static function getCountGeneric($table, $id, $pageId, $numberOfString = NULL) { |
151 | 162 | if (!$numberOfString) { |
152 | 163 | $numberOfString = $table . ".alphabetical"; |
@@ -159,6 +170,10 @@ discard block |
||
159 | 170 | return $entry; |
160 | 171 | } |
161 | 172 | |
173 | + /** |
|
174 | + * @param string $columns |
|
175 | + * @param string $category |
|
176 | + */ |
|
162 | 177 | public static function getEntryArrayWithBookNumber ($query, $columns, $params, $category) { |
163 | 178 | /* @var $result PDOStatement */ |
164 | 179 | |
@@ -181,6 +196,9 @@ discard block |
||
181 | 196 | return $entryArray; |
182 | 197 | } |
183 | 198 | |
199 | + /** |
|
200 | + * @param string $filter |
|
201 | + */ |
|
184 | 202 | public static function executeQuery($query, $columns, $filter, $params, $n, $database = NULL, $numberPerPage = NULL) { |
185 | 203 | $totalResult = -1; |
186 | 204 |
@@ -37,146 +37,146 @@ discard block |
||
37 | 37 | |
38 | 38 | private static $db = NULL; |
39 | 39 | |
40 | - public static function isMultipleDatabaseEnabled () { |
|
40 | + public static function isMultipleDatabaseEnabled() { |
|
41 | 41 | global $config; |
42 | - return is_array ($config['calibre_directory']); |
|
42 | + return is_array($config['calibre_directory']); |
|
43 | 43 | } |
44 | 44 | |
45 | - public static function useAbsolutePath () { |
|
45 | + public static function useAbsolutePath() { |
|
46 | 46 | global $config; |
47 | 47 | $path = self::getDbDirectory(); |
48 | - return preg_match ('/^\//', $path) || // Linux / |
|
49 | - preg_match ('/^\w\:/', $path); // Windows X: |
|
48 | + return preg_match('/^\//', $path) || // Linux / |
|
49 | + preg_match('/^\w\:/', $path); // Windows X: |
|
50 | 50 | } |
51 | 51 | |
52 | - public static function noDatabaseSelected () { |
|
53 | - return self::isMultipleDatabaseEnabled () && is_null (GetUrlParam (DB)); |
|
52 | + public static function noDatabaseSelected() { |
|
53 | + return self::isMultipleDatabaseEnabled() && is_null(GetUrlParam(DB)); |
|
54 | 54 | } |
55 | 55 | |
56 | - public static function getDbList () { |
|
56 | + public static function getDbList() { |
|
57 | 57 | global $config; |
58 | - if (self::isMultipleDatabaseEnabled ()) { |
|
58 | + if (self::isMultipleDatabaseEnabled()) { |
|
59 | 59 | return $config['calibre_directory']; |
60 | 60 | } else { |
61 | - return array ("" => $config['calibre_directory']); |
|
61 | + return array("" => $config['calibre_directory']); |
|
62 | 62 | } |
63 | 63 | } |
64 | 64 | |
65 | - public static function getDbNameList () { |
|
65 | + public static function getDbNameList() { |
|
66 | 66 | global $config; |
67 | - if (self::isMultipleDatabaseEnabled ()) { |
|
68 | - return array_keys ($config['calibre_directory']); |
|
67 | + if (self::isMultipleDatabaseEnabled()) { |
|
68 | + return array_keys($config['calibre_directory']); |
|
69 | 69 | } else { |
70 | - return array (""); |
|
70 | + return array(""); |
|
71 | 71 | } |
72 | 72 | } |
73 | 73 | |
74 | - public static function getDbName ($database = NULL) { |
|
74 | + public static function getDbName($database = NULL) { |
|
75 | 75 | global $config; |
76 | - if (self::isMultipleDatabaseEnabled ()) { |
|
77 | - if (is_null ($database)) $database = GetUrlParam (DB, 0); |
|
76 | + if (self::isMultipleDatabaseEnabled()) { |
|
77 | + if (is_null($database)) $database = GetUrlParam(DB, 0); |
|
78 | 78 | if (!is_null($database) && !preg_match('/^\d+$/', $database)) { |
79 | - self::error ($database); |
|
79 | + self::error($database); |
|
80 | 80 | } |
81 | - $array = array_keys ($config['calibre_directory']); |
|
81 | + $array = array_keys($config['calibre_directory']); |
|
82 | 82 | return $array[$database]; |
83 | 83 | } |
84 | 84 | return ""; |
85 | 85 | } |
86 | 86 | |
87 | - public static function getDbDirectory ($database = NULL) { |
|
87 | + public static function getDbDirectory($database = NULL) { |
|
88 | 88 | global $config; |
89 | - if (self::isMultipleDatabaseEnabled ()) { |
|
90 | - if (is_null ($database)) $database = GetUrlParam (DB, 0); |
|
89 | + if (self::isMultipleDatabaseEnabled()) { |
|
90 | + if (is_null($database)) $database = GetUrlParam(DB, 0); |
|
91 | 91 | if (!is_null($database) && !preg_match('/^\d+$/', $database)) { |
92 | - self::error ($database); |
|
92 | + self::error($database); |
|
93 | 93 | } |
94 | - $array = array_values ($config['calibre_directory']); |
|
94 | + $array = array_values($config['calibre_directory']); |
|
95 | 95 | return $array[$database]; |
96 | 96 | } |
97 | 97 | return $config['calibre_directory']; |
98 | 98 | } |
99 | 99 | |
100 | 100 | |
101 | - public static function getDbFileName ($database = NULL) { |
|
102 | - return self::getDbDirectory ($database) .'metadata.db'; |
|
101 | + public static function getDbFileName($database = NULL) { |
|
102 | + return self::getDbDirectory($database) . 'metadata.db'; |
|
103 | 103 | } |
104 | 104 | |
105 | - private static function error ($database) { |
|
105 | + private static function error($database) { |
|
106 | 106 | if (php_sapi_name() != "cli") { |
107 | 107 | header("location: checkconfig.php?err=1"); |
108 | 108 | } |
109 | 109 | throw new Exception("Database <{$database}> not found."); |
110 | 110 | } |
111 | 111 | |
112 | - public static function getDb ($database = NULL) { |
|
113 | - if (is_null (self::$db)) { |
|
112 | + public static function getDb($database = NULL) { |
|
113 | + if (is_null(self::$db)) { |
|
114 | 114 | try { |
115 | - if (is_readable (self::getDbFileName ($database))) { |
|
116 | - self::$db = new PDO('sqlite:'. self::getDbFileName ($database)); |
|
117 | - if (useNormAndUp ()) { |
|
118 | - self::$db->sqliteCreateFunction ('normAndUp', 'normAndUp', 1); |
|
115 | + if (is_readable(self::getDbFileName($database))) { |
|
116 | + self::$db = new PDO('sqlite:' . self::getDbFileName($database)); |
|
117 | + if (useNormAndUp()) { |
|
118 | + self::$db->sqliteCreateFunction('normAndUp', 'normAndUp', 1); |
|
119 | 119 | } |
120 | 120 | } else { |
121 | - self::error ($database); |
|
121 | + self::error($database); |
|
122 | 122 | } |
123 | 123 | } catch (Exception $e) { |
124 | - self::error ($database); |
|
124 | + self::error($database); |
|
125 | 125 | } |
126 | 126 | } |
127 | 127 | return self::$db; |
128 | 128 | } |
129 | 129 | |
130 | - public static function checkDatabaseAvailability () { |
|
131 | - if (self::noDatabaseSelected ()) { |
|
132 | - for ($i = 0; $i < count (self::getDbList ()); $i++) { |
|
133 | - self::getDb ($i); |
|
134 | - self::clearDb (); |
|
130 | + public static function checkDatabaseAvailability() { |
|
131 | + if (self::noDatabaseSelected()) { |
|
132 | + for ($i = 0; $i < count(self::getDbList()); $i++) { |
|
133 | + self::getDb($i); |
|
134 | + self::clearDb(); |
|
135 | 135 | } |
136 | 136 | } else { |
137 | - self::getDb (); |
|
137 | + self::getDb(); |
|
138 | 138 | } |
139 | 139 | return true; |
140 | 140 | } |
141 | 141 | |
142 | - public static function clearDb () { |
|
142 | + public static function clearDb() { |
|
143 | 143 | self::$db = NULL; |
144 | 144 | } |
145 | 145 | |
146 | - public static function executeQuerySingle ($query, $database = NULL) { |
|
147 | - return self::getDb ($database)->query($query)->fetchColumn(); |
|
146 | + public static function executeQuerySingle($query, $database = NULL) { |
|
147 | + return self::getDb($database)->query($query)->fetchColumn(); |
|
148 | 148 | } |
149 | 149 | |
150 | 150 | public static function getCountGeneric($table, $id, $pageId, $numberOfString = NULL) { |
151 | 151 | if (!$numberOfString) { |
152 | 152 | $numberOfString = $table . ".alphabetical"; |
153 | 153 | } |
154 | - $count = self::executeQuerySingle ('select count(*) from ' . $table); |
|
154 | + $count = self::executeQuerySingle('select count(*) from ' . $table); |
|
155 | 155 | if ($count == 0) return NULL; |
156 | - $entry = new Entry (localize($table . ".title"), $id, |
|
157 | - str_format (localize($numberOfString, $count), $count), "text", |
|
158 | - array ( new LinkNavigation ("?page=".$pageId)), "", $count); |
|
156 | + $entry = new Entry(localize($table . ".title"), $id, |
|
157 | + str_format(localize($numberOfString, $count), $count), "text", |
|
158 | + array(new LinkNavigation("?page=" . $pageId)), "", $count); |
|
159 | 159 | return $entry; |
160 | 160 | } |
161 | 161 | |
162 | - public static function getEntryArrayWithBookNumber ($query, $columns, $params, $category) { |
|
162 | + public static function getEntryArrayWithBookNumber($query, $columns, $params, $category) { |
|
163 | 163 | /* @var $result PDOStatement */ |
164 | 164 | |
165 | - list (, $result) = self::executeQuery ($query, $columns, "", $params, -1); |
|
165 | + list (, $result) = self::executeQuery($query, $columns, "", $params, -1); |
|
166 | 166 | $entryArray = array(); |
167 | - while ($post = $result->fetchObject ()) |
|
167 | + while ($post = $result->fetchObject()) |
|
168 | 168 | { |
169 | 169 | /* @var $instance Author|Tag|Serie|Publisher */ |
170 | 170 | |
171 | - $instance = new $category ($post); |
|
171 | + $instance = new $category($post); |
|
172 | 172 | if (property_exists($post, "sort")) { |
173 | 173 | $title = $post->sort; |
174 | 174 | } else { |
175 | 175 | $title = $post->name; |
176 | 176 | } |
177 | - array_push ($entryArray, new Entry ($title, $instance->getEntryId (), |
|
178 | - str_format (localize("bookword", $post->count), $post->count), "text", |
|
179 | - array ( new LinkNavigation ($instance->getUri ())), "", $post->count)); |
|
177 | + array_push($entryArray, new Entry($title, $instance->getEntryId(), |
|
178 | + str_format(localize("bookword", $post->count), $post->count), "text", |
|
179 | + array(new LinkNavigation($instance->getUri())), "", $post->count)); |
|
180 | 180 | } |
181 | 181 | return $entryArray; |
182 | 182 | } |
@@ -184,30 +184,30 @@ discard block |
||
184 | 184 | public static function executeQuery($query, $columns, $filter, $params, $n, $database = NULL, $numberPerPage = NULL) { |
185 | 185 | $totalResult = -1; |
186 | 186 | |
187 | - if (useNormAndUp ()) { |
|
187 | + if (useNormAndUp()) { |
|
188 | 188 | $query = preg_replace("/upper/", "normAndUp", $query); |
189 | 189 | $columns = preg_replace("/upper/", "normAndUp", $columns); |
190 | 190 | } |
191 | 191 | |
192 | - if (is_null ($numberPerPage)) { |
|
193 | - $numberPerPage = getCurrentOption ("max_item_per_page"); |
|
192 | + if (is_null($numberPerPage)) { |
|
193 | + $numberPerPage = getCurrentOption("max_item_per_page"); |
|
194 | 194 | } |
195 | 195 | |
196 | 196 | if ($numberPerPage != -1 && $n != -1) |
197 | 197 | { |
198 | 198 | // First check total number of results |
199 | - $result = self::getDb ($database)->prepare (str_format ($query, "count(*)", $filter)); |
|
200 | - $result->execute ($params); |
|
201 | - $totalResult = $result->fetchColumn (); |
|
199 | + $result = self::getDb($database)->prepare(str_format($query, "count(*)", $filter)); |
|
200 | + $result->execute($params); |
|
201 | + $totalResult = $result->fetchColumn(); |
|
202 | 202 | |
203 | 203 | // Next modify the query and params |
204 | 204 | $query .= " limit ?, ?"; |
205 | - array_push ($params, ($n - 1) * $numberPerPage, $numberPerPage); |
|
205 | + array_push($params, ($n - 1) * $numberPerPage, $numberPerPage); |
|
206 | 206 | } |
207 | 207 | |
208 | - $result = self::getDb ($database)->prepare(str_format ($query, $columns, $filter)); |
|
209 | - $result->execute ($params); |
|
210 | - return array ($totalResult, $result); |
|
208 | + $result = self::getDb($database)->prepare(str_format($query, $columns, $filter)); |
|
209 | + $result->execute($params); |
|
210 | + return array($totalResult, $result); |
|
211 | 211 | } |
212 | 212 | |
213 | 213 | } |
@@ -37,23 +37,27 @@ discard block |
||
37 | 37 | |
38 | 38 | private static $db = NULL; |
39 | 39 | |
40 | - public static function isMultipleDatabaseEnabled () { |
|
40 | + public static function isMultipleDatabaseEnabled () |
|
41 | + { |
|
41 | 42 | global $config; |
42 | 43 | return is_array ($config['calibre_directory']); |
43 | 44 | } |
44 | 45 | |
45 | - public static function useAbsolutePath () { |
|
46 | + public static function useAbsolutePath () |
|
47 | + { |
|
46 | 48 | global $config; |
47 | 49 | $path = self::getDbDirectory(); |
48 | 50 | return preg_match ('/^\//', $path) || // Linux / |
49 | 51 | preg_match ('/^\w\:/', $path); // Windows X: |
50 | 52 | } |
51 | 53 | |
52 | - public static function noDatabaseSelected () { |
|
54 | + public static function noDatabaseSelected () |
|
55 | + { |
|
53 | 56 | return self::isMultipleDatabaseEnabled () && is_null (GetUrlParam (DB)); |
54 | 57 | } |
55 | 58 | |
56 | - public static function getDbList () { |
|
59 | + public static function getDbList () |
|
60 | + { |
|
57 | 61 | global $config; |
58 | 62 | if (self::isMultipleDatabaseEnabled ()) { |
59 | 63 | return $config['calibre_directory']; |
@@ -62,7 +66,8 @@ discard block |
||
62 | 66 | } |
63 | 67 | } |
64 | 68 | |
65 | - public static function getDbNameList () { |
|
69 | + public static function getDbNameList () |
|
70 | + { |
|
66 | 71 | global $config; |
67 | 72 | if (self::isMultipleDatabaseEnabled ()) { |
68 | 73 | return array_keys ($config['calibre_directory']); |
@@ -71,10 +76,13 @@ discard block |
||
71 | 76 | } |
72 | 77 | } |
73 | 78 | |
74 | - public static function getDbName ($database = NULL) { |
|
79 | + public static function getDbName ($database = NULL) |
|
80 | + { |
|
75 | 81 | global $config; |
76 | 82 | if (self::isMultipleDatabaseEnabled ()) { |
77 | - if (is_null ($database)) $database = GetUrlParam (DB, 0); |
|
83 | + if (is_null ($database)) { |
|
84 | + $database = GetUrlParam (DB, 0); |
|
85 | + } |
|
78 | 86 | if (!is_null($database) && !preg_match('/^\d+$/', $database)) { |
79 | 87 | self::error ($database); |
80 | 88 | } |
@@ -84,10 +92,13 @@ discard block |
||
84 | 92 | return ""; |
85 | 93 | } |
86 | 94 | |
87 | - public static function getDbDirectory ($database = NULL) { |
|
95 | + public static function getDbDirectory ($database = NULL) |
|
96 | + { |
|
88 | 97 | global $config; |
89 | 98 | if (self::isMultipleDatabaseEnabled ()) { |
90 | - if (is_null ($database)) $database = GetUrlParam (DB, 0); |
|
99 | + if (is_null ($database)) { |
|
100 | + $database = GetUrlParam (DB, 0); |
|
101 | + } |
|
91 | 102 | if (!is_null($database) && !preg_match('/^\d+$/', $database)) { |
92 | 103 | self::error ($database); |
93 | 104 | } |
@@ -98,18 +109,21 @@ discard block |
||
98 | 109 | } |
99 | 110 | |
100 | 111 | |
101 | - public static function getDbFileName ($database = NULL) { |
|
112 | + public static function getDbFileName ($database = NULL) |
|
113 | + { |
|
102 | 114 | return self::getDbDirectory ($database) .'metadata.db'; |
103 | 115 | } |
104 | 116 | |
105 | - private static function error ($database) { |
|
117 | + private static function error ($database) |
|
118 | + { |
|
106 | 119 | if (php_sapi_name() != "cli") { |
107 | 120 | header("location: checkconfig.php?err=1"); |
108 | 121 | } |
109 | 122 | throw new Exception("Database <{$database}> not found."); |
110 | 123 | } |
111 | 124 | |
112 | - public static function getDb ($database = NULL) { |
|
125 | + public static function getDb ($database = NULL) |
|
126 | + { |
|
113 | 127 | if (is_null (self::$db)) { |
114 | 128 | try { |
115 | 129 | if (is_readable (self::getDbFileName ($database))) { |
@@ -127,7 +141,8 @@ discard block |
||
127 | 141 | return self::$db; |
128 | 142 | } |
129 | 143 | |
130 | - public static function checkDatabaseAvailability () { |
|
144 | + public static function checkDatabaseAvailability () |
|
145 | + { |
|
131 | 146 | if (self::noDatabaseSelected ()) { |
132 | 147 | for ($i = 0; $i < count (self::getDbList ()); $i++) { |
133 | 148 | self::getDb ($i); |
@@ -139,33 +154,38 @@ discard block |
||
139 | 154 | return true; |
140 | 155 | } |
141 | 156 | |
142 | - public static function clearDb () { |
|
157 | + public static function clearDb () |
|
158 | + { |
|
143 | 159 | self::$db = NULL; |
144 | 160 | } |
145 | 161 | |
146 | - public static function executeQuerySingle ($query, $database = NULL) { |
|
162 | + public static function executeQuerySingle ($query, $database = NULL) |
|
163 | + { |
|
147 | 164 | return self::getDb ($database)->query($query)->fetchColumn(); |
148 | 165 | } |
149 | 166 | |
150 | - public static function getCountGeneric($table, $id, $pageId, $numberOfString = NULL) { |
|
167 | + public static function getCountGeneric($table, $id, $pageId, $numberOfString = NULL) |
|
168 | + { |
|
151 | 169 | if (!$numberOfString) { |
152 | 170 | $numberOfString = $table . ".alphabetical"; |
153 | 171 | } |
154 | 172 | $count = self::executeQuerySingle ('select count(*) from ' . $table); |
155 | - if ($count == 0) return NULL; |
|
173 | + if ($count == 0) { |
|
174 | + return NULL; |
|
175 | + } |
|
156 | 176 | $entry = new Entry (localize($table . ".title"), $id, |
157 | 177 | str_format (localize($numberOfString, $count), $count), "text", |
158 | 178 | array ( new LinkNavigation ("?page=".$pageId)), "", $count); |
159 | 179 | return $entry; |
160 | 180 | } |
161 | 181 | |
162 | - public static function getEntryArrayWithBookNumber ($query, $columns, $params, $category) { |
|
182 | + public static function getEntryArrayWithBookNumber ($query, $columns, $params, $category) |
|
183 | + { |
|
163 | 184 | /* @var $result PDOStatement */ |
164 | 185 | |
165 | 186 | list (, $result) = self::executeQuery ($query, $columns, "", $params, -1); |
166 | 187 | $entryArray = array(); |
167 | - while ($post = $result->fetchObject ()) |
|
168 | - { |
|
188 | + while ($post = $result->fetchObject ()) { |
|
169 | 189 | /* @var $instance Author|Tag|Serie|Publisher */ |
170 | 190 | |
171 | 191 | $instance = new $category ($post); |
@@ -181,7 +201,8 @@ discard block |
||
181 | 201 | return $entryArray; |
182 | 202 | } |
183 | 203 | |
184 | - public static function executeQuery($query, $columns, $filter, $params, $n, $database = NULL, $numberPerPage = NULL) { |
|
204 | + public static function executeQuery($query, $columns, $filter, $params, $n, $database = NULL, $numberPerPage = NULL) |
|
205 | + { |
|
185 | 206 | $totalResult = -1; |
186 | 207 | |
187 | 208 | if (useNormAndUp ()) { |
@@ -193,8 +214,7 @@ discard block |
||
193 | 214 | $numberPerPage = getCurrentOption ("max_item_per_page"); |
194 | 215 | } |
195 | 216 | |
196 | - if ($numberPerPage != -1 && $n != -1) |
|
197 | - { |
|
217 | + if ($numberPerPage != -1 && $n != -1) { |
|
198 | 218 | // First check total number of results |
199 | 219 | $result = self::getDb ($database)->prepare (str_format ($query, "count(*)", $filter)); |
200 | 220 | $result->execute ($params); |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | |
36 | 36 | const COMPATIBILITY_XML_ALDIKO = "aldiko"; |
37 | 37 | |
38 | - private static $db = NULL; |
|
38 | + private static $db = null; |
|
39 | 39 | |
40 | 40 | public static function isMultipleDatabaseEnabled () { |
41 | 41 | global $config; |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | } |
72 | 72 | } |
73 | 73 | |
74 | - public static function getDbName ($database = NULL) { |
|
74 | + public static function getDbName ($database = null) { |
|
75 | 75 | global $config; |
76 | 76 | if (self::isMultipleDatabaseEnabled ()) { |
77 | 77 | if (is_null ($database)) $database = GetUrlParam (DB, 0); |
@@ -84,7 +84,7 @@ discard block |
||
84 | 84 | return ""; |
85 | 85 | } |
86 | 86 | |
87 | - public static function getDbDirectory ($database = NULL) { |
|
87 | + public static function getDbDirectory ($database = null) { |
|
88 | 88 | global $config; |
89 | 89 | if (self::isMultipleDatabaseEnabled ()) { |
90 | 90 | if (is_null ($database)) $database = GetUrlParam (DB, 0); |
@@ -98,7 +98,7 @@ discard block |
||
98 | 98 | } |
99 | 99 | |
100 | 100 | |
101 | - public static function getDbFileName ($database = NULL) { |
|
101 | + public static function getDbFileName ($database = null) { |
|
102 | 102 | return self::getDbDirectory ($database) .'metadata.db'; |
103 | 103 | } |
104 | 104 | |
@@ -109,7 +109,7 @@ discard block |
||
109 | 109 | throw new Exception("Database <{$database}> not found."); |
110 | 110 | } |
111 | 111 | |
112 | - public static function getDb ($database = NULL) { |
|
112 | + public static function getDb ($database = null) { |
|
113 | 113 | if (is_null (self::$db)) { |
114 | 114 | try { |
115 | 115 | if (is_readable (self::getDbFileName ($database))) { |
@@ -140,19 +140,19 @@ discard block |
||
140 | 140 | } |
141 | 141 | |
142 | 142 | public static function clearDb () { |
143 | - self::$db = NULL; |
|
143 | + self::$db = null; |
|
144 | 144 | } |
145 | 145 | |
146 | - public static function executeQuerySingle ($query, $database = NULL) { |
|
146 | + public static function executeQuerySingle ($query, $database = null) { |
|
147 | 147 | return self::getDb ($database)->query($query)->fetchColumn(); |
148 | 148 | } |
149 | 149 | |
150 | - public static function getCountGeneric($table, $id, $pageId, $numberOfString = NULL) { |
|
150 | + public static function getCountGeneric($table, $id, $pageId, $numberOfString = null) { |
|
151 | 151 | if (!$numberOfString) { |
152 | 152 | $numberOfString = $table . ".alphabetical"; |
153 | 153 | } |
154 | 154 | $count = self::executeQuerySingle ('select count(*) from ' . $table); |
155 | - if ($count == 0) return NULL; |
|
155 | + if ($count == 0) return null; |
|
156 | 156 | $entry = new Entry (localize($table . ".title"), $id, |
157 | 157 | str_format (localize($numberOfString, $count), $count), "text", |
158 | 158 | array ( new LinkNavigation ("?page=".$pageId)), "", $count); |
@@ -181,7 +181,7 @@ discard block |
||
181 | 181 | return $entryArray; |
182 | 182 | } |
183 | 183 | |
184 | - public static function executeQuery($query, $columns, $filter, $params, $n, $database = NULL, $numberPerPage = NULL) { |
|
184 | + public static function executeQuery($query, $columns, $filter, $params, $n, $database = null, $numberPerPage = null) { |
|
185 | 185 | $totalResult = -1; |
186 | 186 | |
187 | 187 | if (useNormAndUp ()) { |
@@ -144,6 +144,9 @@ discard block |
||
144 | 144 | return 'index.php' . $urlParam; |
145 | 145 | } |
146 | 146 | |
147 | + /** |
|
148 | + * @return string |
|
149 | + */ |
|
147 | 150 | public function getTitle () { |
148 | 151 | return $this->title; |
149 | 152 | } |
@@ -331,6 +334,9 @@ discard block |
||
331 | 334 | return reset($reduced); |
332 | 335 | } |
333 | 336 | |
337 | + /** |
|
338 | + * @param string $extension |
|
339 | + */ |
|
334 | 340 | public function getFilePath($extension, $idData = NULL, $relative = false) |
335 | 341 | { |
336 | 342 | if ($extension == 'jpg') |
@@ -464,6 +470,9 @@ discard block |
||
464 | 470 | $this->getLinkArray(), $this); |
465 | 471 | } |
466 | 472 | |
473 | + /** |
|
474 | + * @param integer $database |
|
475 | + */ |
|
467 | 476 | public static function getBookCount($database = NULL) { |
468 | 477 | return parent::executeQuerySingle('select count(*) from books', $database); |
469 | 478 | } |
@@ -512,7 +521,7 @@ discard block |
||
512 | 521 | } |
513 | 522 | |
514 | 523 | /** |
515 | - * @param $customColumn CustomColumn |
|
524 | + * @param CustomColumn $customColumn CustomColumn |
|
516 | 525 | * @param $id integer |
517 | 526 | * @param $n integer |
518 | 527 | * @return array |
@@ -552,6 +561,10 @@ discard block |
||
552 | 561 | return NULL; |
553 | 562 | } |
554 | 563 | |
564 | + /** |
|
565 | + * @param integer $database |
|
566 | + * @param integer $numberPerPage |
|
567 | + */ |
|
555 | 568 | public static function getBooksByQuery($query, $n, $database = NULL, $numberPerPage = NULL) { |
556 | 569 | $i = 0; |
557 | 570 | $critArray = array(); |
@@ -599,6 +612,9 @@ discard block |
||
599 | 612 | return $entryArray; |
600 | 613 | } |
601 | 614 | |
615 | + /** |
|
616 | + * @param integer $numberPerPage |
|
617 | + */ |
|
602 | 618 | public static function getBooksByStartingLetter($letter, $n, $database = NULL, $numberPerPage = NULL) { |
603 | 619 | return self::getEntryArray(self::SQL_BOOKS_BY_FIRST_LETTER, array($letter . '%'), $n, $database, $numberPerPage); |
604 | 620 | } |
@@ -473,15 +473,15 @@ discard block |
||
473 | 473 | $nBooks = parent::executeQuerySingle('select count(*) from books'); |
474 | 474 | $result = array(); |
475 | 475 | $entry = new Entry(localize('allbooks.title'), |
476 | - self::ALL_BOOKS_ID, |
|
477 | - str_format(localize('allbooks.alphabetical', $nBooks), $nBooks), 'text', |
|
478 | - array(new LinkNavigation('?page='.parent::PAGE_ALL_BOOKS)), '', $nBooks); |
|
476 | + self::ALL_BOOKS_ID, |
|
477 | + str_format(localize('allbooks.alphabetical', $nBooks), $nBooks), 'text', |
|
478 | + array(new LinkNavigation('?page='.parent::PAGE_ALL_BOOKS)), '', $nBooks); |
|
479 | 479 | array_push($result, $entry); |
480 | 480 | if ($config['cops_recentbooks_limit'] > 0) { |
481 | 481 | $entry = new Entry(localize('recent.title'), |
482 | - self::ALL_RECENT_BOOKS_ID, |
|
483 | - str_format(localize('recent.list'), $config['cops_recentbooks_limit']), 'text', |
|
484 | - array ( new LinkNavigation ('?page='.parent::PAGE_ALL_RECENT_BOOKS)), '', $config['cops_recentbooks_limit']); |
|
482 | + self::ALL_RECENT_BOOKS_ID, |
|
483 | + str_format(localize('recent.list'), $config['cops_recentbooks_limit']), 'text', |
|
484 | + array ( new LinkNavigation ('?page='.parent::PAGE_ALL_RECENT_BOOKS)), '', $config['cops_recentbooks_limit']); |
|
485 | 485 | array_push($result, $entry); |
486 | 486 | } |
487 | 487 | return $result; |
@@ -556,10 +556,10 @@ discard block |
||
556 | 556 | $i = 0; |
557 | 557 | $critArray = array(); |
558 | 558 | foreach (array(PageQueryResult::SCOPE_AUTHOR, |
559 | - PageQueryResult::SCOPE_TAG, |
|
560 | - PageQueryResult::SCOPE_SERIES, |
|
561 | - PageQueryResult::SCOPE_PUBLISHER, |
|
562 | - PageQueryResult::SCOPE_BOOK) as $key) { |
|
559 | + PageQueryResult::SCOPE_TAG, |
|
560 | + PageQueryResult::SCOPE_SERIES, |
|
561 | + PageQueryResult::SCOPE_PUBLISHER, |
|
562 | + PageQueryResult::SCOPE_BOOK) as $key) { |
|
563 | 563 | if (in_array($key, getCurrentOption('ignored_categories')) || |
564 | 564 | (!array_key_exists($key, $query) && !array_key_exists('all', $query))) { |
565 | 565 | $critArray[$i] = self::BAD_SEARCH; |
@@ -101,13 +101,13 @@ discard block |
||
101 | 101 | public $seriesIndex; |
102 | 102 | public $comment; |
103 | 103 | public $rating; |
104 | - public $datas = NULL; |
|
105 | - public $authors = NULL; |
|
106 | - public $publisher = NULL; |
|
107 | - public $serie = NULL; |
|
108 | - public $tags = NULL; |
|
109 | - public $identifiers = NULL; |
|
110 | - public $languages = NULL; |
|
104 | + public $datas = null; |
|
105 | + public $authors = null; |
|
106 | + public $publisher = null; |
|
107 | + public $serie = null; |
|
108 | + public $tags = null; |
|
109 | + public $identifiers = null; |
|
110 | + public $languages = null; |
|
111 | 111 | public $format = array (); |
112 | 112 | |
113 | 113 | |
@@ -267,7 +267,7 @@ discard block |
||
267 | 267 | /* End of other class (author, series, tag, ...) initialization and accessors */ |
268 | 268 | |
269 | 269 | public static function getFilterString() { |
270 | - $filter = getURLParam('tag', NULL); |
|
270 | + $filter = getURLParam('tag', null); |
|
271 | 271 | if (empty($filter)) return ''; |
272 | 272 | |
273 | 273 | $exists = true; |
@@ -289,7 +289,7 @@ discard block |
||
289 | 289 | { |
290 | 290 | $bestFormatForKindle = array('EPUB', 'PDF', 'AZW3', 'MOBI'); |
291 | 291 | $bestRank = -1; |
292 | - $bestData = NULL; |
|
292 | + $bestData = null; |
|
293 | 293 | foreach ($this->getDatas() as $data) { |
294 | 294 | $key = array_search($data->format, $bestFormatForKindle); |
295 | 295 | if ($key !== false && $key > $bestRank) { |
@@ -356,7 +356,7 @@ discard block |
||
356 | 356 | return reset($reduced); |
357 | 357 | } |
358 | 358 | |
359 | - public function getFilePath($extension, $idData = NULL, $relative = false) |
|
359 | + public function getFilePath($extension, $idData = null, $relative = false) |
|
360 | 360 | { |
361 | 361 | if ($extension == 'jpg') |
362 | 362 | { |
@@ -365,7 +365,7 @@ discard block |
||
365 | 365 | else |
366 | 366 | { |
367 | 367 | $data = $this->getDataById($idData); |
368 | - if (!$data) return NULL; |
|
368 | + if (!$data) return null; |
|
369 | 369 | $file = $data->name . '.' . strtolower($data->format); |
370 | 370 | } |
371 | 371 | |
@@ -417,7 +417,7 @@ discard block |
||
417 | 417 | } |
418 | 418 | } |
419 | 419 | |
420 | - public function getThumbnail($width, $height, $outputfile = NULL) { |
|
420 | + public function getThumbnail($width, $height, $outputfile = null) { |
|
421 | 421 | if (is_null($width) && is_null($height)) { |
422 | 422 | return false; |
423 | 423 | } |
@@ -458,9 +458,9 @@ discard block |
||
458 | 458 | |
459 | 459 | if ($this->hasCover) |
460 | 460 | { |
461 | - array_push($linkArray, Data::getLink($this, 'jpg', 'image/jpeg', Link::OPDS_IMAGE_TYPE, 'cover.jpg', NULL)); |
|
461 | + array_push($linkArray, Data::getLink($this, 'jpg', 'image/jpeg', Link::OPDS_IMAGE_TYPE, 'cover.jpg', null)); |
|
462 | 462 | |
463 | - array_push($linkArray, Data::getLink($this, 'jpg', 'image/jpeg', Link::OPDS_THUMBNAIL_TYPE, 'cover.jpg', NULL)); |
|
463 | + array_push($linkArray, Data::getLink($this, 'jpg', 'image/jpeg', Link::OPDS_THUMBNAIL_TYPE, 'cover.jpg', null)); |
|
464 | 464 | } |
465 | 465 | |
466 | 466 | foreach ($this->getDatas() as $data) |
@@ -491,7 +491,7 @@ discard block |
||
491 | 491 | $this->getLinkArray(), $this); |
492 | 492 | } |
493 | 493 | |
494 | - public static function getBookCount($database = NULL) { |
|
494 | + public static function getBookCount($database = null) { |
|
495 | 495 | return parent::executeQuerySingle('select count(*) from books', $database); |
496 | 496 | } |
497 | 497 | |
@@ -560,7 +560,7 @@ discard block |
||
560 | 560 | $book = new Book($post); |
561 | 561 | return $book; |
562 | 562 | } |
563 | - return NULL; |
|
563 | + return null; |
|
564 | 564 | } |
565 | 565 | |
566 | 566 | public static function getBookByDataId($dataId) { |
@@ -576,10 +576,10 @@ discard block |
||
576 | 576 | $book->datas = array($data); |
577 | 577 | return $book; |
578 | 578 | } |
579 | - return NULL; |
|
579 | + return null; |
|
580 | 580 | } |
581 | 581 | |
582 | - public static function getBooksByQuery($query, $n, $database = NULL, $numberPerPage = NULL) { |
|
582 | + public static function getBooksByQuery($query, $n, $database = null, $numberPerPage = null) { |
|
583 | 583 | $i = 0; |
584 | 584 | $critArray = array(); |
585 | 585 | foreach (array(PageQueryResult::SCOPE_AUTHOR, |
@@ -626,11 +626,11 @@ discard block |
||
626 | 626 | return $entryArray; |
627 | 627 | } |
628 | 628 | |
629 | - public static function getBooksByStartingLetter($letter, $n, $database = NULL, $numberPerPage = NULL) { |
|
629 | + public static function getBooksByStartingLetter($letter, $n, $database = null, $numberPerPage = null) { |
|
630 | 630 | return self::getEntryArray(self::SQL_BOOKS_BY_FIRST_LETTER, array($letter . '%'), $n, $database, $numberPerPage); |
631 | 631 | } |
632 | 632 | |
633 | - public static function getEntryArray($query, $params, $n, $database = NULL, $numberPerPage = NULL) { |
|
633 | + public static function getEntryArray($query, $params, $n, $database = null, $numberPerPage = null) { |
|
634 | 634 | /* @var $totalNumber integer */ |
635 | 635 | /* @var $result PDOStatement */ |
636 | 636 | list($totalNumber, $result) = parent::executeQuery($query, self::BOOK_COLUMNS, self::getFilterString(), $params, $n, $database, $numberPerPage); |
@@ -7,55 +7,55 @@ discard block |
||
7 | 7 | */ |
8 | 8 | |
9 | 9 | // Silly thing because PHP forbid string concatenation in class const |
10 | -define ('SQL_BOOKS_LEFT_JOIN', 'left outer join comments on comments.book = books.id |
|
10 | +define('SQL_BOOKS_LEFT_JOIN', 'left outer join comments on comments.book = books.id |
|
11 | 11 | left outer join books_ratings_link on books_ratings_link.book = books.id |
12 | 12 | left outer join ratings on books_ratings_link.rating = ratings.id '); |
13 | -define ('SQL_BOOKS_ALL', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' order by books.sort '); |
|
14 | -define ('SQL_BOOKS_BY_PUBLISHER', 'select {0} from books_publishers_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
13 | +define('SQL_BOOKS_ALL', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' order by books.sort '); |
|
14 | +define('SQL_BOOKS_BY_PUBLISHER', 'select {0} from books_publishers_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
15 | 15 | where books_publishers_link.book = books.id and publisher = ? {1} order by publisher'); |
16 | -define ('SQL_BOOKS_BY_FIRST_LETTER', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
16 | +define('SQL_BOOKS_BY_FIRST_LETTER', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
17 | 17 | where upper (books.sort) like ? order by books.sort'); |
18 | -define ('SQL_BOOKS_BY_AUTHOR', 'select {0} from books_authors_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
18 | +define('SQL_BOOKS_BY_AUTHOR', 'select {0} from books_authors_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
19 | 19 | left outer join books_series_link on books_series_link.book = books.id |
20 | 20 | where books_authors_link.book = books.id and author = ? {1} order by series desc, series_index asc, pubdate asc'); |
21 | -define ('SQL_BOOKS_BY_SERIE', 'select {0} from books_series_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
21 | +define('SQL_BOOKS_BY_SERIE', 'select {0} from books_series_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
22 | 22 | where books_series_link.book = books.id and series = ? {1} order by series_index'); |
23 | -define ('SQL_BOOKS_BY_TAG', 'select {0} from books_tags_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
23 | +define('SQL_BOOKS_BY_TAG', 'select {0} from books_tags_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
24 | 24 | where books_tags_link.book = books.id and tag = ? {1} order by sort'); |
25 | -define ('SQL_BOOKS_BY_LANGUAGE', 'select {0} from books_languages_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
25 | +define('SQL_BOOKS_BY_LANGUAGE', 'select {0} from books_languages_link, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
26 | 26 | where books_languages_link.book = books.id and lang_code = ? {1} order by sort'); |
27 | -define ('SQL_BOOKS_BY_CUSTOM', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
27 | +define('SQL_BOOKS_BY_CUSTOM', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
28 | 28 | where {2}.book = books.id and {2}.{3} = ? {1} order by sort'); |
29 | -define ('SQL_BOOKS_BY_CUSTOM_BOOL_TRUE', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
29 | +define('SQL_BOOKS_BY_CUSTOM_BOOL_TRUE', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
30 | 30 | where {2}.book = books.id and {2}.value = 1 {1} order by sort'); |
31 | -define ('SQL_BOOKS_BY_CUSTOM_BOOL_FALSE', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
31 | +define('SQL_BOOKS_BY_CUSTOM_BOOL_FALSE', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
32 | 32 | where {2}.book = books.id and {2}.value = 0 {1} order by sort'); |
33 | -define ('SQL_BOOKS_BY_CUSTOM_BOOL_NULL', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
33 | +define('SQL_BOOKS_BY_CUSTOM_BOOL_NULL', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
34 | 34 | where books.id not in (select book from {2}) {1} order by sort'); |
35 | -define ('SQL_BOOKS_BY_CUSTOM_RATING', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
35 | +define('SQL_BOOKS_BY_CUSTOM_RATING', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
36 | 36 | left join {2} on {2}.book = books.id |
37 | 37 | left join {3} on {3}.id = {2}.{4} |
38 | 38 | where {3}.value = ? order by sort'); |
39 | -define ('SQL_BOOKS_BY_CUSTOM_RATING_NULL', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
39 | +define('SQL_BOOKS_BY_CUSTOM_RATING_NULL', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
40 | 40 | left join {2} on {2}.book = books.id |
41 | 41 | left join {3} on {3}.id = {2}.{4} |
42 | 42 | where ((books.id not in (select {2}.book from {2})) or ({3}.value = 0)) {1} order by sort'); |
43 | -define ('SQL_BOOKS_BY_CUSTOM_DATE', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
43 | +define('SQL_BOOKS_BY_CUSTOM_DATE', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
44 | 44 | where {2}.book = books.id and date({2}.value) = ? {1} order by sort'); |
45 | -define ('SQL_BOOKS_BY_CUSTOM_DIRECT', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
45 | +define('SQL_BOOKS_BY_CUSTOM_DIRECT', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
46 | 46 | where {2}.book = books.id and {2}.value = ? {1} order by sort'); |
47 | -define ('SQL_BOOKS_BY_CUSTOM_DIRECT_ID', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
47 | +define('SQL_BOOKS_BY_CUSTOM_DIRECT_ID', 'select {0} from {2}, books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
48 | 48 | where {2}.book = books.id and {2}.id = ? {1} order by sort'); |
49 | -define ('SQL_BOOKS_QUERY', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
49 | +define('SQL_BOOKS_QUERY', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
50 | 50 | where ( |
51 | 51 | exists (select null from authors, books_authors_link where book = books.id and author = authors.id and authors.name like ?) or |
52 | 52 | exists (select null from tags, books_tags_link where book = books.id and tag = tags.id and tags.name like ?) or |
53 | 53 | exists (select null from series, books_series_link on book = books.id and books_series_link.series = series.id and series.name like ?) or |
54 | 54 | exists (select null from publishers, books_publishers_link where book = books.id and books_publishers_link.publisher = publishers.id and publishers.name like ?) or |
55 | 55 | title like ?) {1} order by books.sort'); |
56 | -define ('SQL_BOOKS_RECENT', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
56 | +define('SQL_BOOKS_RECENT', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
57 | 57 | where 1=1 {1} order by timestamp desc limit '); |
58 | -define ('SQL_BOOKS_BY_RATING', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
58 | +define('SQL_BOOKS_BY_RATING', 'select {0} from books ' . SQL_BOOKS_LEFT_JOIN . ' |
|
59 | 59 | where books_ratings_link.book = books.id and ratings.id = ? {1} order by sort'); |
60 | 60 | |
61 | 61 | require('Identifier.php'); |
@@ -108,7 +108,7 @@ discard block |
||
108 | 108 | public $tags = NULL; |
109 | 109 | public $identifiers = NULL; |
110 | 110 | public $languages = NULL; |
111 | - public $format = array (); |
|
111 | + public $format = array(); |
|
112 | 112 | |
113 | 113 | |
114 | 114 | public function __construct($line) { |
@@ -130,24 +130,24 @@ discard block |
||
130 | 130 | } |
131 | 131 | |
132 | 132 | public function getEntryId() { |
133 | - return self::ALL_BOOKS_UUID.':'.$this->uuid; |
|
133 | + return self::ALL_BOOKS_UUID . ':' . $this->uuid; |
|
134 | 134 | } |
135 | 135 | |
136 | - public static function getEntryIdByLetter ($startingLetter) { |
|
137 | - return self::ALL_BOOKS_ID.':letter:'.$startingLetter; |
|
136 | + public static function getEntryIdByLetter($startingLetter) { |
|
137 | + return self::ALL_BOOKS_ID . ':letter:' . $startingLetter; |
|
138 | 138 | } |
139 | 139 | |
140 | - public function getUri () { |
|
141 | - return '?page='.parent::PAGE_BOOK_DETAIL.'&id=' . $this->id; |
|
140 | + public function getUri() { |
|
141 | + return '?page=' . parent::PAGE_BOOK_DETAIL . '&id=' . $this->id; |
|
142 | 142 | } |
143 | 143 | |
144 | - public function getDetailUrl () { |
|
144 | + public function getDetailUrl() { |
|
145 | 145 | $urlParam = $this->getUri(); |
146 | - if (!is_null(GetUrlParam(DB))) $urlParam = addURLParameter($urlParam, DB, GetUrlParam (DB)); |
|
146 | + if (!is_null(GetUrlParam(DB))) $urlParam = addURLParameter($urlParam, DB, GetUrlParam(DB)); |
|
147 | 147 | return 'index.php' . $urlParam; |
148 | 148 | } |
149 | 149 | |
150 | - public function getTitle () { |
|
150 | + public function getTitle() { |
|
151 | 151 | return $this->title; |
152 | 152 | } |
153 | 153 | |
@@ -156,22 +156,22 @@ discard block |
||
156 | 156 | /** |
157 | 157 | * @return Author[] |
158 | 158 | */ |
159 | - public function getAuthors () { |
|
159 | + public function getAuthors() { |
|
160 | 160 | if (is_null($this->authors)) { |
161 | 161 | $this->authors = Author::getAuthorByBookId($this->id); |
162 | 162 | } |
163 | 163 | return $this->authors; |
164 | 164 | } |
165 | 165 | |
166 | - public function getAuthorsName () { |
|
167 | - return implode(', ', array_map(function ($author) { return $author->name; }, $this->getAuthors())); |
|
166 | + public function getAuthorsName() { |
|
167 | + return implode(', ', array_map(function($author) { return $author->name; }, $this->getAuthors())); |
|
168 | 168 | } |
169 | 169 | |
170 | - public function getAuthorsSort () { |
|
171 | - return implode(', ', array_map(function ($author) { return $author->sort; }, $this->getAuthors())); |
|
170 | + public function getAuthorsSort() { |
|
171 | + return implode(', ', array_map(function($author) { return $author->sort; }, $this->getAuthors())); |
|
172 | 172 | } |
173 | 173 | |
174 | - public function getPublisher () { |
|
174 | + public function getPublisher() { |
|
175 | 175 | if (is_null($this->publisher)) { |
176 | 176 | $this->publisher = Publisher::getPublisherByBookId($this->id); |
177 | 177 | } |
@@ -210,7 +210,7 @@ discard block |
||
210 | 210 | * @return Tag[] |
211 | 211 | */ |
212 | 212 | public function getTags() { |
213 | - if (is_null ($this->tags)) { |
|
213 | + if (is_null($this->tags)) { |
|
214 | 214 | $this->tags = array(); |
215 | 215 | |
216 | 216 | $result = parent::getDb()->prepare('select tags.id as id, name |
@@ -228,7 +228,7 @@ discard block |
||
228 | 228 | } |
229 | 229 | |
230 | 230 | public function getTagsName() { |
231 | - return implode(', ', array_map(function ($tag) { return $tag->name; }, $this->getTags())); |
|
231 | + return implode(', ', array_map(function($tag) { return $tag->name; }, $this->getTags())); |
|
232 | 232 | } |
233 | 233 | |
234 | 234 | |
@@ -236,7 +236,7 @@ discard block |
||
236 | 236 | * @return Identifiers[] |
237 | 237 | */ |
238 | 238 | public function getIdentifiers() { |
239 | - if (is_null ($this->identifiers)) { |
|
239 | + if (is_null($this->identifiers)) { |
|
240 | 240 | $this->identifiers = array(); |
241 | 241 | |
242 | 242 | $result = parent::getDb()->prepare('select type, val, id |
@@ -302,7 +302,7 @@ discard block |
||
302 | 302 | |
303 | 303 | public function getDataById($idData) |
304 | 304 | { |
305 | - $reduced = array_filter($this->getDatas(), function ($data) use ($idData) { |
|
305 | + $reduced = array_filter($this->getDatas(), function($data) use ($idData) { |
|
306 | 306 | return $data->id == $idData; |
307 | 307 | }); |
308 | 308 | return reset($reduced); |
@@ -326,7 +326,7 @@ discard block |
||
326 | 326 | if (empty ($this->pubdate)) { |
327 | 327 | return ''; |
328 | 328 | } |
329 | - $dateY = (int) substr($this->pubdate, 0, 4); |
|
329 | + $dateY = (int)substr($this->pubdate, 0, 4); |
|
330 | 330 | if ($dateY > 102) { |
331 | 331 | return str_pad($dateY, 4, '0', STR_PAD_LEFT); |
332 | 332 | } |
@@ -335,15 +335,15 @@ discard block |
||
335 | 335 | |
336 | 336 | public function getComment($withSerie = true) { |
337 | 337 | $addition = ''; |
338 | - $se = $this->getSerie (); |
|
339 | - if (!is_null ($se) && $withSerie) { |
|
338 | + $se = $this->getSerie(); |
|
339 | + if (!is_null($se) && $withSerie) { |
|
340 | 340 | $addition = $addition . '<strong>' . localize('content.series') . '</strong>' . str_format(localize('content.series.data'), $this->seriesIndex, htmlspecialchars($se->name)) . "<br />\n"; |
341 | 341 | } |
342 | 342 | return $addition . html2xhtml($this->comment); |
343 | 343 | } |
344 | 344 | |
345 | 345 | public function getDataFormat($format) { |
346 | - $reduced = array_filter($this->getDatas(), function ($data) use ($format) { |
|
346 | + $reduced = array_filter($this->getDatas(), function($data) use ($format) { |
|
347 | 347 | return $data->format == $format; |
348 | 348 | }); |
349 | 349 | return reset($reduced); |
@@ -364,11 +364,11 @@ discard block |
||
364 | 364 | |
365 | 365 | if ($relative) |
366 | 366 | { |
367 | - return $this->relativePath.'/'.$file; |
|
367 | + return $this->relativePath . '/' . $file; |
|
368 | 368 | } |
369 | 369 | else |
370 | 370 | { |
371 | - return $this->path.'/'.$file; |
|
371 | + return $this->path . '/' . $file; |
|
372 | 372 | } |
373 | 373 | } |
374 | 374 | |
@@ -388,7 +388,7 @@ discard block |
||
388 | 388 | } |
389 | 389 | $epub->Authors($authorArray); |
390 | 390 | $epub->Language($this->getLanguages()); |
391 | - $epub->Description ($this->getComment(false)); |
|
391 | + $epub->Description($this->getComment(false)); |
|
392 | 392 | $epub->Subjects($this->getTagsName()); |
393 | 393 | $epub->Cover2($this->getFilePath('jpg'), 'image/jpeg'); |
394 | 394 | $epub->Calibre($this->uuid); |
@@ -398,7 +398,7 @@ discard block |
||
398 | 398 | $epub->SerieIndex($this->seriesIndex); |
399 | 399 | } |
400 | 400 | $filename = $data->getUpdatedFilenameEpub(); |
401 | - if ($config['cops_provide_kepub'] == '1' && preg_match('/Kobo/', $_SERVER['HTTP_USER_AGENT'])) { |
|
401 | + if ($config['cops_provide_kepub'] == '1' && preg_match('/Kobo/', $_SERVER['HTTP_USER_AGENT'])) { |
|
402 | 402 | $epub->updateForKepub(); |
403 | 403 | $filename = $data->getUpdatedFilenameKepub(); |
404 | 404 | } |
@@ -424,11 +424,11 @@ discard block |
||
424 | 424 | if (!is_null($width)) { |
425 | 425 | $nw = $width; |
426 | 426 | if ($nw >= $w) { return false; } |
427 | - $nh = ($nw*$h)/$w; |
|
427 | + $nh = ($nw * $h) / $w; |
|
428 | 428 | } else { |
429 | 429 | $nh = $height; |
430 | 430 | if ($nh >= $h) { return false; } |
431 | - $nw = ($nh*$w)/$h; |
|
431 | + $nw = ($nh * $w) / $h; |
|
432 | 432 | } |
433 | 433 | } else { |
434 | 434 | return false; |
@@ -436,16 +436,16 @@ discard block |
||
436 | 436 | |
437 | 437 | //draw the image |
438 | 438 | $src_img = imagecreatefromjpeg($file); |
439 | - $dst_img = imagecreatetruecolor($nw,$nh); |
|
440 | - imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $nw, $nh, $w, $h);//resizing the image |
|
441 | - imagejpeg($dst_img,$outputfile,80); |
|
439 | + $dst_img = imagecreatetruecolor($nw, $nh); |
|
440 | + imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $nw, $nh, $w, $h); //resizing the image |
|
441 | + imagejpeg($dst_img, $outputfile, 80); |
|
442 | 442 | imagedestroy($src_img); |
443 | 443 | imagedestroy($dst_img); |
444 | 444 | |
445 | 445 | return true; |
446 | 446 | } |
447 | 447 | |
448 | - public function getLinkArray () |
|
448 | + public function getLinkArray() |
|
449 | 449 | { |
450 | 450 | $linkArray = array(); |
451 | 451 | |
@@ -470,7 +470,7 @@ discard block |
||
470 | 470 | } |
471 | 471 | |
472 | 472 | $serie = $this->getSerie(); |
473 | - if (!is_null ($serie)) { |
|
473 | + if (!is_null($serie)) { |
|
474 | 474 | array_push($linkArray, new LinkNavigation($serie->getUri(), 'related', str_format(localize('content.series.data'), $this->seriesIndex, $serie->name))); |
475 | 475 | } |
476 | 476 | |
@@ -495,13 +495,13 @@ discard block |
||
495 | 495 | $entry = new Entry(localize('allbooks.title'), |
496 | 496 | self::ALL_BOOKS_ID, |
497 | 497 | str_format(localize('allbooks.alphabetical', $nBooks), $nBooks), 'text', |
498 | - array(new LinkNavigation('?page='.parent::PAGE_ALL_BOOKS)), '', $nBooks); |
|
498 | + array(new LinkNavigation('?page=' . parent::PAGE_ALL_BOOKS)), '', $nBooks); |
|
499 | 499 | array_push($result, $entry); |
500 | 500 | if ($config['cops_recentbooks_limit'] > 0) { |
501 | 501 | $entry = new Entry(localize('recent.title'), |
502 | 502 | self::ALL_RECENT_BOOKS_ID, |
503 | 503 | str_format(localize('recent.list'), $config['cops_recentbooks_limit']), 'text', |
504 | - array ( new LinkNavigation ('?page='.parent::PAGE_ALL_RECENT_BOOKS)), '', $config['cops_recentbooks_limit']); |
|
504 | + array(new LinkNavigation('?page=' . parent::PAGE_ALL_RECENT_BOOKS)), '', $config['cops_recentbooks_limit']); |
|
505 | 505 | array_push($result, $entry); |
506 | 506 | } |
507 | 507 | return $result; |
@@ -597,7 +597,7 @@ discard block |
||
597 | 597 | } |
598 | 598 | |
599 | 599 | public static function getBooks($n) { |
600 | - list ($entryArray, $totalNumber) = self::getEntryArray(self::SQL_BOOKS_ALL , array (), $n); |
|
600 | + list ($entryArray, $totalNumber) = self::getEntryArray(self::SQL_BOOKS_ALL, array(), $n); |
|
601 | 601 | return array($entryArray, $totalNumber); |
602 | 602 | } |
603 | 603 | |
@@ -614,7 +614,7 @@ discard block |
||
614 | 614 | { |
615 | 615 | array_push($entryArray, new Entry($post->title, Book::getEntryIdByLetter($post->title), |
616 | 616 | str_format(localize('bookword', $post->count), $post->count), 'text', |
617 | - array(new LinkNavigation('?page='.parent::PAGE_ALL_BOOKS_LETTER.'&id='. rawurlencode($post->title))), '', $post->count)); |
|
617 | + array(new LinkNavigation('?page=' . parent::PAGE_ALL_BOOKS_LETTER . '&id=' . rawurlencode($post->title))), '', $post->count)); |
|
618 | 618 | } |
619 | 619 | return $entryArray; |
620 | 620 | } |
@@ -639,7 +639,7 @@ discard block |
||
639 | 639 | |
640 | 640 | public static function getAllRecentBooks() { |
641 | 641 | global $config; |
642 | - list ($entryArray, ) = self::getEntryArray(self::SQL_BOOKS_RECENT . $config['cops_recentbooks_limit'], array(), -1); |
|
642 | + list ($entryArray,) = self::getEntryArray(self::SQL_BOOKS_RECENT . $config['cops_recentbooks_limit'], array(), -1); |
|
643 | 643 | return $entryArray; |
644 | 644 | } |
645 | 645 |
@@ -111,7 +111,8 @@ discard block |
||
111 | 111 | public $format = array (); |
112 | 112 | |
113 | 113 | |
114 | - public function __construct($line) { |
|
114 | + public function __construct($line) |
|
115 | + { |
|
115 | 116 | $this->id = $line->id; |
116 | 117 | $this->title = $line->title; |
117 | 118 | $this->timestamp = strtotime($line->timestamp); |
@@ -129,25 +130,32 @@ discard block |
||
129 | 130 | $this->rating = $line->rating; |
130 | 131 | } |
131 | 132 | |
132 | - public function getEntryId() { |
|
133 | + public function getEntryId() |
|
134 | + { |
|
133 | 135 | return self::ALL_BOOKS_UUID.':'.$this->uuid; |
134 | 136 | } |
135 | 137 | |
136 | - public static function getEntryIdByLetter ($startingLetter) { |
|
138 | + public static function getEntryIdByLetter ($startingLetter) |
|
139 | + { |
|
137 | 140 | return self::ALL_BOOKS_ID.':letter:'.$startingLetter; |
138 | 141 | } |
139 | 142 | |
140 | - public function getUri () { |
|
143 | + public function getUri () |
|
144 | + { |
|
141 | 145 | return '?page='.parent::PAGE_BOOK_DETAIL.'&id=' . $this->id; |
142 | 146 | } |
143 | 147 | |
144 | - public function getDetailUrl () { |
|
148 | + public function getDetailUrl () |
|
149 | + { |
|
145 | 150 | $urlParam = $this->getUri(); |
146 | - if (!is_null(GetUrlParam(DB))) $urlParam = addURLParameter($urlParam, DB, GetUrlParam (DB)); |
|
151 | + if (!is_null(GetUrlParam(DB))) { |
|
152 | + $urlParam = addURLParameter($urlParam, DB, GetUrlParam (DB)); |
|
153 | + } |
|
147 | 154 | return 'index.php' . $urlParam; |
148 | 155 | } |
149 | 156 | |
150 | - public function getTitle () { |
|
157 | + public function getTitle () |
|
158 | + { |
|
151 | 159 | return $this->title; |
152 | 160 | } |
153 | 161 | |
@@ -156,22 +164,26 @@ discard block |
||
156 | 164 | /** |
157 | 165 | * @return Author[] |
158 | 166 | */ |
159 | - public function getAuthors () { |
|
167 | + public function getAuthors () |
|
168 | + { |
|
160 | 169 | if (is_null($this->authors)) { |
161 | 170 | $this->authors = Author::getAuthorByBookId($this->id); |
162 | 171 | } |
163 | 172 | return $this->authors; |
164 | 173 | } |
165 | 174 | |
166 | - public function getAuthorsName () { |
|
175 | + public function getAuthorsName () |
|
176 | + { |
|
167 | 177 | return implode(', ', array_map(function ($author) { return $author->name; }, $this->getAuthors())); |
168 | 178 | } |
169 | 179 | |
170 | - public function getAuthorsSort () { |
|
180 | + public function getAuthorsSort () |
|
181 | + { |
|
171 | 182 | return implode(', ', array_map(function ($author) { return $author->sort; }, $this->getAuthors())); |
172 | 183 | } |
173 | 184 | |
174 | - public function getPublisher () { |
|
185 | + public function getPublisher () |
|
186 | + { |
|
175 | 187 | if (is_null($this->publisher)) { |
176 | 188 | $this->publisher = Publisher::getPublisherByBookId($this->id); |
177 | 189 | } |
@@ -181,7 +193,8 @@ discard block |
||
181 | 193 | /** |
182 | 194 | * @return Serie |
183 | 195 | */ |
184 | - public function getSerie() { |
|
196 | + public function getSerie() |
|
197 | + { |
|
185 | 198 | if (is_null($this->serie)) { |
186 | 199 | $this->serie = Serie::getSerieByBookId($this->id); |
187 | 200 | } |
@@ -191,7 +204,8 @@ discard block |
||
191 | 204 | /** |
192 | 205 | * @return string |
193 | 206 | */ |
194 | - public function getLanguages() { |
|
207 | + public function getLanguages() |
|
208 | + { |
|
195 | 209 | $lang = array(); |
196 | 210 | $result = parent::getDb()->prepare('select languages.lang_code |
197 | 211 | from books_languages_link, languages |
@@ -199,8 +213,7 @@ discard block |
||
199 | 213 | and book = ? |
200 | 214 | order by item_order'); |
201 | 215 | $result->execute(array($this->id)); |
202 | - while ($post = $result->fetchObject()) |
|
203 | - { |
|
216 | + while ($post = $result->fetchObject()) { |
|
204 | 217 | array_push($lang, Language::getLanguageString($post->lang_code)); |
205 | 218 | } |
206 | 219 | return implode(', ', $lang); |
@@ -209,7 +222,8 @@ discard block |
||
209 | 222 | /** |
210 | 223 | * @return Tag[] |
211 | 224 | */ |
212 | - public function getTags() { |
|
225 | + public function getTags() |
|
226 | + { |
|
213 | 227 | if (is_null ($this->tags)) { |
214 | 228 | $this->tags = array(); |
215 | 229 | |
@@ -219,15 +233,15 @@ discard block |
||
219 | 233 | and book = ? |
220 | 234 | order by name'); |
221 | 235 | $result->execute(array($this->id)); |
222 | - while ($post = $result->fetchObject()) |
|
223 | - { |
|
236 | + while ($post = $result->fetchObject()) { |
|
224 | 237 | array_push($this->tags, new Tag($post)); |
225 | 238 | } |
226 | 239 | } |
227 | 240 | return $this->tags; |
228 | 241 | } |
229 | 242 | |
230 | - public function getTagsName() { |
|
243 | + public function getTagsName() |
|
244 | + { |
|
231 | 245 | return implode(', ', array_map(function ($tag) { return $tag->name; }, $this->getTags())); |
232 | 246 | } |
233 | 247 | |
@@ -235,7 +249,8 @@ discard block |
||
235 | 249 | /** |
236 | 250 | * @return Identifiers[] |
237 | 251 | */ |
238 | - public function getIdentifiers() { |
|
252 | + public function getIdentifiers() |
|
253 | + { |
|
239 | 254 | if (is_null ($this->identifiers)) { |
240 | 255 | $this->identifiers = array(); |
241 | 256 | |
@@ -244,8 +259,7 @@ discard block |
||
244 | 259 | where book = ? |
245 | 260 | order by type'); |
246 | 261 | $result->execute(array($this->id)); |
247 | - while ($post = $result->fetchObject()) |
|
248 | - { |
|
262 | + while ($post = $result->fetchObject()) { |
|
249 | 263 | array_push($this->identifiers, new Identifier($post)); |
250 | 264 | } |
251 | 265 | |
@@ -266,9 +280,12 @@ discard block |
||
266 | 280 | |
267 | 281 | /* End of other class (author, series, tag, ...) initialization and accessors */ |
268 | 282 | |
269 | - public static function getFilterString() { |
|
283 | + public static function getFilterString() |
|
284 | + { |
|
270 | 285 | $filter = getURLParam('tag', NULL); |
271 | - if (empty($filter)) return ''; |
|
286 | + if (empty($filter)) { |
|
287 | + return ''; |
|
288 | + } |
|
272 | 289 | |
273 | 290 | $exists = true; |
274 | 291 | if (preg_match("/^!(.*)$/", $filter, $matches)) { |
@@ -308,7 +325,8 @@ discard block |
||
308 | 325 | return reset($reduced); |
309 | 326 | } |
310 | 327 | |
311 | - public function getRating() { |
|
328 | + public function getRating() |
|
329 | + { |
|
312 | 330 | if (is_null($this->rating) || $this->rating == 0) { |
313 | 331 | return ''; |
314 | 332 | } |
@@ -322,7 +340,8 @@ discard block |
||
322 | 340 | return $retour; |
323 | 341 | } |
324 | 342 | |
325 | - public function getPubDate() { |
|
343 | + public function getPubDate() |
|
344 | + { |
|
326 | 345 | if (empty ($this->pubdate)) { |
327 | 346 | return ''; |
328 | 347 | } |
@@ -333,7 +352,8 @@ discard block |
||
333 | 352 | return ''; |
334 | 353 | } |
335 | 354 | |
336 | - public function getComment($withSerie = true) { |
|
355 | + public function getComment($withSerie = true) |
|
356 | + { |
|
337 | 357 | $addition = ''; |
338 | 358 | $se = $this->getSerie (); |
339 | 359 | if (!is_null ($se) && $withSerie) { |
@@ -342,7 +362,8 @@ discard block |
||
342 | 362 | return $addition . html2xhtml($this->comment); |
343 | 363 | } |
344 | 364 | |
345 | - public function getDataFormat($format) { |
|
365 | + public function getDataFormat($format) |
|
366 | + { |
|
346 | 367 | $reduced = array_filter($this->getDatas(), function ($data) use ($format) { |
347 | 368 | return $data->format == $format; |
348 | 369 | }); |
@@ -351,23 +372,19 @@ discard block |
||
351 | 372 | |
352 | 373 | public function getFilePath($extension, $idData = NULL, $relative = false) |
353 | 374 | { |
354 | - if ($extension == 'jpg') |
|
355 | - { |
|
375 | + if ($extension == 'jpg') { |
|
356 | 376 | $file = 'cover.jpg'; |
357 | - } |
|
358 | - else |
|
359 | - { |
|
377 | + } else { |
|
360 | 378 | $data = $this->getDataById($idData); |
361 | - if (!$data) return NULL; |
|
379 | + if (!$data) { |
|
380 | + return NULL; |
|
381 | + } |
|
362 | 382 | $file = $data->name . '.' . strtolower($data->format); |
363 | 383 | } |
364 | 384 | |
365 | - if ($relative) |
|
366 | - { |
|
385 | + if ($relative) { |
|
367 | 386 | return $this->relativePath.'/'.$file; |
368 | - } |
|
369 | - else |
|
370 | - { |
|
387 | + } else { |
|
371 | 388 | return $this->path.'/'.$file; |
372 | 389 | } |
373 | 390 | } |
@@ -377,8 +394,7 @@ discard block |
||
377 | 394 | global $config; |
378 | 395 | $data = $this->getDataById($idData); |
379 | 396 | |
380 | - try |
|
381 | - { |
|
397 | + try { |
|
382 | 398 | $epub = new EPub($data->getLocalPath()); |
383 | 399 | |
384 | 400 | $epub->Title($this->title); |
@@ -403,14 +419,13 @@ discard block |
||
403 | 419 | $filename = $data->getUpdatedFilenameKepub(); |
404 | 420 | } |
405 | 421 | $epub->download($filename); |
406 | - } |
|
407 | - catch (Exception $e) |
|
408 | - { |
|
422 | + } catch (Exception $e) { |
|
409 | 423 | echo 'Exception : ' . $e->getMessage(); |
410 | 424 | } |
411 | 425 | } |
412 | 426 | |
413 | - public function getThumbnail($width, $height, $outputfile = NULL) { |
|
427 | + public function getThumbnail($width, $height, $outputfile = NULL) |
|
428 | + { |
|
414 | 429 | if (is_null($width) && is_null($height)) { |
415 | 430 | return false; |
416 | 431 | } |
@@ -449,17 +464,14 @@ discard block |
||
449 | 464 | { |
450 | 465 | $linkArray = array(); |
451 | 466 | |
452 | - if ($this->hasCover) |
|
453 | - { |
|
467 | + if ($this->hasCover) { |
|
454 | 468 | array_push($linkArray, Data::getLink($this, 'jpg', 'image/jpeg', Link::OPDS_IMAGE_TYPE, 'cover.jpg', NULL)); |
455 | 469 | |
456 | 470 | array_push($linkArray, Data::getLink($this, 'jpg', 'image/jpeg', Link::OPDS_THUMBNAIL_TYPE, 'cover.jpg', NULL)); |
457 | 471 | } |
458 | 472 | |
459 | - foreach ($this->getDatas() as $data) |
|
460 | - { |
|
461 | - if ($data->isKnownType()) |
|
462 | - { |
|
473 | + foreach ($this->getDatas() as $data) { |
|
474 | + if ($data->isKnownType()) { |
|
463 | 475 | array_push($linkArray, $data->getDataLink(Link::OPDS_ACQUISITION_TYPE, $data->format)); |
464 | 476 | } |
465 | 477 | } |
@@ -478,17 +490,20 @@ discard block |
||
478 | 490 | } |
479 | 491 | |
480 | 492 | |
481 | - public function getEntry() { |
|
493 | + public function getEntry() |
|
494 | + { |
|
482 | 495 | return new EntryBook($this->getTitle(), $this->getEntryId(), |
483 | 496 | $this->getComment(), 'text/html', |
484 | 497 | $this->getLinkArray(), $this); |
485 | 498 | } |
486 | 499 | |
487 | - public static function getBookCount($database = NULL) { |
|
500 | + public static function getBookCount($database = NULL) |
|
501 | + { |
|
488 | 502 | return parent::executeQuerySingle('select count(*) from books', $database); |
489 | 503 | } |
490 | 504 | |
491 | - public static function getCount() { |
|
505 | + public static function getCount() |
|
506 | + { |
|
492 | 507 | global $config; |
493 | 508 | $nBooks = parent::executeQuerySingle('select count(*) from books'); |
494 | 509 | $result = array(); |
@@ -507,27 +522,33 @@ discard block |
||
507 | 522 | return $result; |
508 | 523 | } |
509 | 524 | |
510 | - public static function getBooksByAuthor($authorId, $n) { |
|
525 | + public static function getBooksByAuthor($authorId, $n) |
|
526 | + { |
|
511 | 527 | return self::getEntryArray(self::SQL_BOOKS_BY_AUTHOR, array($authorId), $n); |
512 | 528 | } |
513 | 529 | |
514 | - public static function getBooksByRating($ratingId, $n) { |
|
530 | + public static function getBooksByRating($ratingId, $n) |
|
531 | + { |
|
515 | 532 | return self::getEntryArray(self::SQL_BOOKS_BY_RATING, array($ratingId), $n); |
516 | 533 | } |
517 | 534 | |
518 | - public static function getBooksByPublisher($publisherId, $n) { |
|
535 | + public static function getBooksByPublisher($publisherId, $n) |
|
536 | + { |
|
519 | 537 | return self::getEntryArray(self::SQL_BOOKS_BY_PUBLISHER, array($publisherId), $n); |
520 | 538 | } |
521 | 539 | |
522 | - public static function getBooksBySeries($serieId, $n) { |
|
540 | + public static function getBooksBySeries($serieId, $n) |
|
541 | + { |
|
523 | 542 | return self::getEntryArray(self::SQL_BOOKS_BY_SERIE, array($serieId), $n); |
524 | 543 | } |
525 | 544 | |
526 | - public static function getBooksByTag($tagId, $n) { |
|
545 | + public static function getBooksByTag($tagId, $n) |
|
546 | + { |
|
527 | 547 | return self::getEntryArray(self::SQL_BOOKS_BY_TAG, array($tagId), $n); |
528 | 548 | } |
529 | 549 | |
530 | - public static function getBooksByLanguage($languageId, $n) { |
|
550 | + public static function getBooksByLanguage($languageId, $n) |
|
551 | + { |
|
531 | 552 | return self::getEntryArray(self::SQL_BOOKS_BY_LANGUAGE, array($languageId), $n); |
532 | 553 | } |
533 | 554 | |
@@ -537,32 +558,33 @@ discard block |
||
537 | 558 | * @param $n integer |
538 | 559 | * @return array |
539 | 560 | */ |
540 | - public static function getBooksByCustom($customColumn, $id, $n) { |
|
561 | + public static function getBooksByCustom($customColumn, $id, $n) |
|
562 | + { |
|
541 | 563 | list($query, $params) = $customColumn->getQuery($id); |
542 | 564 | |
543 | 565 | return self::getEntryArray($query, $params, $n); |
544 | 566 | } |
545 | 567 | |
546 | - public static function getBookById($bookId) { |
|
568 | + public static function getBookById($bookId) |
|
569 | + { |
|
547 | 570 | $result = parent::getDb()->prepare('select ' . self::BOOK_COLUMNS . ' |
548 | 571 | from books ' . self::SQL_BOOKS_LEFT_JOIN . ' |
549 | 572 | where books.id = ?'); |
550 | 573 | $result->execute(array($bookId)); |
551 | - while ($post = $result->fetchObject()) |
|
552 | - { |
|
574 | + while ($post = $result->fetchObject()) { |
|
553 | 575 | $book = new Book($post); |
554 | 576 | return $book; |
555 | 577 | } |
556 | 578 | return NULL; |
557 | 579 | } |
558 | 580 | |
559 | - public static function getBookByDataId($dataId) { |
|
581 | + public static function getBookByDataId($dataId) |
|
582 | + { |
|
560 | 583 | $result = parent::getDb()->prepare('select ' . self::BOOK_COLUMNS . ', data.name, data.format |
561 | 584 | from data, books ' . self::SQL_BOOKS_LEFT_JOIN . ' |
562 | 585 | where data.book = books.id and data.id = ?'); |
563 | 586 | $result->execute(array($dataId)); |
564 | - while ($post = $result->fetchObject()) |
|
565 | - { |
|
587 | + while ($post = $result->fetchObject()) { |
|
566 | 588 | $book = new Book($post); |
567 | 589 | $data = new Data($post, $book); |
568 | 590 | $data->id = $dataId; |
@@ -572,7 +594,8 @@ discard block |
||
572 | 594 | return NULL; |
573 | 595 | } |
574 | 596 | |
575 | - public static function getBooksByQuery($query, $n, $database = NULL, $numberPerPage = NULL) { |
|
597 | + public static function getBooksByQuery($query, $n, $database = NULL, $numberPerPage = NULL) |
|
598 | + { |
|
576 | 599 | $i = 0; |
577 | 600 | $critArray = array(); |
578 | 601 | foreach (array(PageQueryResult::SCOPE_AUTHOR, |
@@ -583,8 +606,7 @@ discard block |
||
583 | 606 | if (in_array($key, getCurrentOption('ignored_categories')) || |
584 | 607 | (!array_key_exists($key, $query) && !array_key_exists('all', $query))) { |
585 | 608 | $critArray[$i] = self::BAD_SEARCH; |
586 | - } |
|
587 | - else { |
|
609 | + } else { |
|
588 | 610 | if (array_key_exists($key, $query)) { |
589 | 611 | $critArray[$i] = $query[$key]; |
590 | 612 | } else { |
@@ -596,12 +618,14 @@ discard block |
||
596 | 618 | return self::getEntryArray(self::SQL_BOOKS_QUERY, $critArray, $n, $database, $numberPerPage); |
597 | 619 | } |
598 | 620 | |
599 | - public static function getBooks($n) { |
|
621 | + public static function getBooks($n) |
|
622 | + { |
|
600 | 623 | list ($entryArray, $totalNumber) = self::getEntryArray(self::SQL_BOOKS_ALL , array (), $n); |
601 | 624 | return array($entryArray, $totalNumber); |
602 | 625 | } |
603 | 626 | |
604 | - public static function getAllBooks() { |
|
627 | + public static function getAllBooks() |
|
628 | + { |
|
605 | 629 | /* @var $result PDOStatement */ |
606 | 630 | |
607 | 631 | list (, $result) = parent::executeQuery('select {0} |
@@ -610,8 +634,7 @@ discard block |
||
610 | 634 | order by substr (upper (sort), 1, 1)', 'substr (upper (sort), 1, 1) as title, count(*) as count', self::getFilterString(), array(), -1); |
611 | 635 | |
612 | 636 | $entryArray = array(); |
613 | - while ($post = $result->fetchObject()) |
|
614 | - { |
|
637 | + while ($post = $result->fetchObject()) { |
|
615 | 638 | array_push($entryArray, new Entry($post->title, Book::getEntryIdByLetter($post->title), |
616 | 639 | str_format(localize('bookword', $post->count), $post->count), 'text', |
617 | 640 | array(new LinkNavigation('?page='.parent::PAGE_ALL_BOOKS_LETTER.'&id='. rawurlencode($post->title))), '', $post->count)); |
@@ -619,25 +642,27 @@ discard block |
||
619 | 642 | return $entryArray; |
620 | 643 | } |
621 | 644 | |
622 | - public static function getBooksByStartingLetter($letter, $n, $database = NULL, $numberPerPage = NULL) { |
|
645 | + public static function getBooksByStartingLetter($letter, $n, $database = NULL, $numberPerPage = NULL) |
|
646 | + { |
|
623 | 647 | return self::getEntryArray(self::SQL_BOOKS_BY_FIRST_LETTER, array($letter . '%'), $n, $database, $numberPerPage); |
624 | 648 | } |
625 | 649 | |
626 | - public static function getEntryArray($query, $params, $n, $database = NULL, $numberPerPage = NULL) { |
|
650 | + public static function getEntryArray($query, $params, $n, $database = NULL, $numberPerPage = NULL) |
|
651 | + { |
|
627 | 652 | /* @var $totalNumber integer */ |
628 | 653 | /* @var $result PDOStatement */ |
629 | 654 | list($totalNumber, $result) = parent::executeQuery($query, self::BOOK_COLUMNS, self::getFilterString(), $params, $n, $database, $numberPerPage); |
630 | 655 | |
631 | 656 | $entryArray = array(); |
632 | - while ($post = $result->fetchObject()) |
|
633 | - { |
|
657 | + while ($post = $result->fetchObject()) { |
|
634 | 658 | $book = new Book($post); |
635 | 659 | array_push($entryArray, $book->getEntry()); |
636 | 660 | } |
637 | 661 | return array($entryArray, $totalNumber); |
638 | 662 | } |
639 | 663 | |
640 | - public static function getAllRecentBooks() { |
|
664 | + public static function getAllRecentBooks() |
|
665 | + { |
|
641 | 666 | global $config; |
642 | 667 | list ($entryArray, ) = self::getEntryArray(self::SQL_BOOKS_RECENT . $config['cops_recentbooks_limit'], array(), -1); |
643 | 668 | return $entryArray; |
@@ -649,7 +674,8 @@ discard block |
||
649 | 674 | * @param string[] $columns |
650 | 675 | * @return CustomColumn[] |
651 | 676 | */ |
652 | - public function getCustomColumnValues($columns, $asArray = false) { |
|
677 | + public function getCustomColumnValues($columns, $asArray = false) |
|
678 | + { |
|
653 | 679 | $result = array(); |
654 | 680 | |
655 | 681 | foreach ($columns as $lookup) { |
@@ -39,6 +39,9 @@ discard block |
||
39 | 39 | /** @var null|Entry[] */ |
40 | 40 | private $customValues = NULL; |
41 | 41 | |
42 | + /** |
|
43 | + * @param string $pdatatype |
|
44 | + */ |
|
42 | 45 | protected function __construct($pcustomId, $pdatatype) |
43 | 46 | { |
44 | 47 | $this->columnTitle = self::getTitleByCustomID($pcustomId); |
@@ -147,7 +150,7 @@ discard block |
||
147 | 150 | /** |
148 | 151 | * Encode a value of this column ready to be displayed in an HTML document |
149 | 152 | * |
150 | - * @param integer|string $value |
|
153 | + * @param string $value |
|
151 | 154 | * @return string |
152 | 155 | */ |
153 | 156 | public function encodeHTMLValue($value) |
@@ -277,7 +280,7 @@ discard block |
||
277 | 280 | /** |
278 | 281 | * Get a CustomColumn for a specified (by ID) value |
279 | 282 | * |
280 | - * @param string|integer $id the id of the searched value |
|
283 | + * @param integer $id the id of the searched value |
|
281 | 284 | * @return CustomColumn |
282 | 285 | */ |
283 | 286 | abstract public function getCustom($id); |
@@ -11,18 +11,18 @@ discard block |
||
11 | 11 | */ |
12 | 12 | abstract class CustomColumnType extends Base |
13 | 13 | { |
14 | - const ALL_CUSTOMS_ID = "cops:custom"; |
|
14 | + const ALL_CUSTOMS_ID = "cops:custom"; |
|
15 | 15 | |
16 | - const CUSTOM_TYPE_TEXT = "text"; // type 1 + 2 |
|
17 | - const CUSTOM_TYPE_COMMENT = "comments"; // type 3 |
|
18 | - const CUSTOM_TYPE_SERIES = "series"; // type 4 |
|
16 | + const CUSTOM_TYPE_TEXT = "text"; // type 1 + 2 |
|
17 | + const CUSTOM_TYPE_COMMENT = "comments"; // type 3 |
|
18 | + const CUSTOM_TYPE_SERIES = "series"; // type 4 |
|
19 | 19 | const CUSTOM_TYPE_ENUM = "enumeration"; // type 5 |
20 | - const CUSTOM_TYPE_DATE = "datetime"; // type 6 |
|
21 | - const CUSTOM_TYPE_FLOAT = "float"; // type 7 |
|
22 | - const CUSTOM_TYPE_INT = "int"; // type 8 |
|
23 | - const CUSTOM_TYPE_RATING = "rating"; // type 9 |
|
24 | - const CUSTOM_TYPE_BOOL = "bool"; // type 10 |
|
25 | - const CUSTOM_TYPE_COMPOSITE = "composite"; // type 11 + 12 |
|
20 | + const CUSTOM_TYPE_DATE = "datetime"; // type 6 |
|
21 | + const CUSTOM_TYPE_FLOAT = "float"; // type 7 |
|
22 | + const CUSTOM_TYPE_INT = "int"; // type 8 |
|
23 | + const CUSTOM_TYPE_RATING = "rating"; // type 9 |
|
24 | + const CUSTOM_TYPE_BOOL = "bool"; // type 10 |
|
25 | + const CUSTOM_TYPE_COMPOSITE = "composite"; // type 11 + 12 |
|
26 | 26 | |
27 | 27 | /** @var array[integer]CustomColumnType */ |
28 | 28 | private static $customColumnCacheID = array(); |
@@ -110,7 +110,7 @@ discard block |
||
110 | 110 | $result->execute(array($this->customId)); |
111 | 111 | if ($post = $result->fetchObject()) { |
112 | 112 | $json = json_decode($post->display); |
113 | - return (isset($json->description) && !empty($json->description)) ? $json->description : NULL; |
|
113 | + return (isset($json->description) && !empty($json->description))?$json->description:NULL; |
|
114 | 114 | } |
115 | 115 | return NULL; |
116 | 116 | } |
@@ -181,8 +181,9 @@ discard block |
||
181 | 181 | public static function createByCustomID($customId) |
182 | 182 | { |
183 | 183 | // Reuse already created CustomColumns for performance |
184 | - if (array_key_exists($customId, self::$customColumnCacheID)) |
|
185 | - return self::$customColumnCacheID[$customId]; |
|
184 | + if (array_key_exists($customId, self::$customColumnCacheID)) { |
|
185 | + return self::$customColumnCacheID[$customId]; |
|
186 | + } |
|
186 | 187 | |
187 | 188 | $datatype = self::getDatatypeByCustomID($customId); |
188 | 189 | |
@@ -221,8 +222,9 @@ discard block |
||
221 | 222 | public static function createByLookup($lookup) |
222 | 223 | { |
223 | 224 | // Reuse already created CustomColumns for performance |
224 | - if (array_key_exists($lookup, self::$customColumnCacheLookup)) |
|
225 | - return self::$customColumnCacheLookup[$lookup]; |
|
225 | + if (array_key_exists($lookup, self::$customColumnCacheLookup)) { |
|
226 | + return self::$customColumnCacheLookup[$lookup]; |
|
227 | + } |
|
226 | 228 | |
227 | 229 | $result = parent::getDb()->prepare('SELECT id FROM custom_columns WHERE label = ?'); |
228 | 230 | $result->execute(array($lookup)); |
@@ -241,8 +243,9 @@ discard block |
||
241 | 243 | public function getAllCustomValues() |
242 | 244 | { |
243 | 245 | // lazy loading |
244 | - if ($this->customValues == NULL) |
|
245 | - $this->customValues = $this->getAllCustomValuesFromDatabase(); |
|
246 | + if ($this->customValues == NULL) { |
|
247 | + $this->customValues = $this->getAllCustomValuesFromDatabase(); |
|
248 | + } |
|
246 | 249 | |
247 | 250 | return $this->customValues; |
248 | 251 | } |
@@ -37,14 +37,14 @@ discard block |
||
37 | 37 | /** @var string the datatype of this column (one of the CUSTOM_TYPE_* constant values) */ |
38 | 38 | public $datatype; |
39 | 39 | /** @var null|Entry[] */ |
40 | - private $customValues = NULL; |
|
40 | + private $customValues = null; |
|
41 | 41 | |
42 | 42 | protected function __construct($pcustomId, $pdatatype) |
43 | 43 | { |
44 | 44 | $this->columnTitle = self::getTitleByCustomID($pcustomId); |
45 | 45 | $this->customId = $pcustomId; |
46 | 46 | $this->datatype = $pdatatype; |
47 | - $this->customValues = NULL; |
|
47 | + $this->customValues = null; |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | /** |
@@ -110,9 +110,9 @@ discard block |
||
110 | 110 | $result->execute(array($this->customId)); |
111 | 111 | if ($post = $result->fetchObject()) { |
112 | 112 | $json = json_decode($post->display); |
113 | - return (isset($json->description) && !empty($json->description)) ? $json->description : NULL; |
|
113 | + return (isset($json->description) && !empty($json->description)) ? $json->description : null; |
|
114 | 114 | } |
115 | - return NULL; |
|
115 | + return null; |
|
116 | 116 | } |
117 | 117 | |
118 | 118 | /** |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | if ($post = $result->fetchObject()) { |
169 | 169 | return $post->datatype; |
170 | 170 | } |
171 | - return NULL; |
|
171 | + return null; |
|
172 | 172 | } |
173 | 173 | |
174 | 174 | /** |
@@ -206,7 +206,7 @@ discard block |
||
206 | 206 | case self::CUSTOM_TYPE_BOOL: |
207 | 207 | return self::$customColumnCacheID[$customId] = new CustomColumnTypeBool($customId); |
208 | 208 | case self::CUSTOM_TYPE_COMPOSITE: |
209 | - return NULL; //TODO Currently not supported |
|
209 | + return null; //TODO Currently not supported |
|
210 | 210 | default: |
211 | 211 | throw new Exception("Unkown column type: " . $datatype); |
212 | 212 | } |
@@ -229,7 +229,7 @@ discard block |
||
229 | 229 | if ($post = $result->fetchObject()) { |
230 | 230 | return self::$customColumnCacheLookup[$lookup] = self::createByCustomID($post->id); |
231 | 231 | } |
232 | - return self::$customColumnCacheLookup[$lookup] = NULL; |
|
232 | + return self::$customColumnCacheLookup[$lookup] = null; |
|
233 | 233 | } |
234 | 234 | |
235 | 235 | /** |
@@ -241,7 +241,7 @@ discard block |
||
241 | 241 | public function getAllCustomValues() |
242 | 242 | { |
243 | 243 | // lazy loading |
244 | - if ($this->customValues == NULL) |
|
244 | + if ($this->customValues == null) |
|
245 | 245 | $this->customValues = $this->getAllCustomValuesFromDatabase(); |
246 | 246 | |
247 | 247 | return $this->customValues; |
@@ -8,6 +8,9 @@ |
||
8 | 8 | |
9 | 9 | class LinkFacet extends Link |
10 | 10 | { |
11 | + /** |
|
12 | + * @param string $phref |
|
13 | + */ |
|
11 | 14 | public function __construct($phref, $ptitle = NULL, $pfacetGroup = NULL, $pactiveFacet = FALSE) { |
12 | 15 | parent::__construct ($phref, Link::OPDS_PAGING_TYPE, "http://opds-spec.org/facet", $ptitle, $pfacetGroup, $pactiveFacet); |
13 | 16 | if (!is_null (GetUrlParam (DB))) $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
@@ -9,8 +9,8 @@ |
||
9 | 9 | class LinkFacet extends Link |
10 | 10 | { |
11 | 11 | public function __construct($phref, $ptitle = NULL, $pfacetGroup = NULL, $pactiveFacet = FALSE) { |
12 | - parent::__construct ($phref, Link::OPDS_PAGING_TYPE, "http://opds-spec.org/facet", $ptitle, $pfacetGroup, $pactiveFacet); |
|
13 | - if (!is_null (GetUrlParam (DB))) $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
|
12 | + parent::__construct($phref, Link::OPDS_PAGING_TYPE, "http://opds-spec.org/facet", $ptitle, $pfacetGroup, $pactiveFacet); |
|
13 | + if (!is_null(GetUrlParam(DB))) $this->href = addURLParameter($this->href, DB, GetUrlParam(DB)); |
|
14 | 14 | $this->href = parent::getScriptName() . $this->href; |
15 | 15 | } |
16 | 16 | } |
@@ -8,9 +8,12 @@ |
||
8 | 8 | |
9 | 9 | class LinkFacet extends Link |
10 | 10 | { |
11 | - public function __construct($phref, $ptitle = NULL, $pfacetGroup = NULL, $pactiveFacet = FALSE) { |
|
11 | + public function __construct($phref, $ptitle = NULL, $pfacetGroup = NULL, $pactiveFacet = FALSE) |
|
12 | + { |
|
12 | 13 | parent::__construct ($phref, Link::OPDS_PAGING_TYPE, "http://opds-spec.org/facet", $ptitle, $pfacetGroup, $pactiveFacet); |
13 | - if (!is_null (GetUrlParam (DB))) $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
|
14 | + if (!is_null (GetUrlParam (DB))) { |
|
15 | + $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
|
16 | + } |
|
14 | 17 | $this->href = parent::getScriptName() . $this->href; |
15 | 18 | } |
16 | 19 | } |
@@ -8,7 +8,7 @@ |
||
8 | 8 | |
9 | 9 | class LinkFacet extends Link |
10 | 10 | { |
11 | - public function __construct($phref, $ptitle = NULL, $pfacetGroup = NULL, $pactiveFacet = FALSE) { |
|
11 | + public function __construct($phref, $ptitle = null, $pfacetGroup = null, $pactiveFacet = false) { |
|
12 | 12 | parent::__construct ($phref, Link::OPDS_PAGING_TYPE, "http://opds-spec.org/facet", $ptitle, $pfacetGroup, $pactiveFacet); |
13 | 13 | if (!is_null (GetUrlParam (DB))) $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
14 | 14 | $this->href = parent::getScriptName() . $this->href; |
@@ -8,6 +8,9 @@ |
||
8 | 8 | |
9 | 9 | class LinkNavigation extends Link |
10 | 10 | { |
11 | + /** |
|
12 | + * @param string $prel |
|
13 | + */ |
|
11 | 14 | public function __construct($phref, $prel = NULL, $ptitle = NULL) { |
12 | 15 | parent::__construct ($phref, Link::OPDS_NAVIGATION_TYPE, $prel, $ptitle); |
13 | 16 | if (!is_null (GetUrlParam (DB))) $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
@@ -9,10 +9,10 @@ |
||
9 | 9 | class LinkNavigation extends Link |
10 | 10 | { |
11 | 11 | public function __construct($phref, $prel = NULL, $ptitle = NULL) { |
12 | - parent::__construct ($phref, Link::OPDS_NAVIGATION_TYPE, $prel, $ptitle); |
|
13 | - if (!is_null (GetUrlParam (DB))) $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
|
14 | - if (!preg_match ("#^\?(.*)#", $this->href) && !empty ($this->href)) $this->href = "?" . $this->href; |
|
15 | - if (preg_match ("/(bookdetail|getJSON).php/", parent::getScriptName())) { |
|
12 | + parent::__construct($phref, Link::OPDS_NAVIGATION_TYPE, $prel, $ptitle); |
|
13 | + if (!is_null(GetUrlParam(DB))) $this->href = addURLParameter($this->href, DB, GetUrlParam(DB)); |
|
14 | + if (!preg_match("#^\?(.*)#", $this->href) && !empty ($this->href)) $this->href = "?" . $this->href; |
|
15 | + if (preg_match("/(bookdetail|getJSON).php/", parent::getScriptName())) { |
|
16 | 16 | $this->href = "index.php" . $this->href; |
17 | 17 | } else { |
18 | 18 | $this->href = parent::getScriptName() . $this->href; |
@@ -8,10 +8,15 @@ |
||
8 | 8 | |
9 | 9 | class LinkNavigation extends Link |
10 | 10 | { |
11 | - public function __construct($phref, $prel = NULL, $ptitle = NULL) { |
|
11 | + public function __construct($phref, $prel = NULL, $ptitle = NULL) |
|
12 | + { |
|
12 | 13 | parent::__construct ($phref, Link::OPDS_NAVIGATION_TYPE, $prel, $ptitle); |
13 | - if (!is_null (GetUrlParam (DB))) $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
|
14 | - if (!preg_match ("#^\?(.*)#", $this->href) && !empty ($this->href)) $this->href = "?" . $this->href; |
|
14 | + if (!is_null (GetUrlParam (DB))) { |
|
15 | + $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
|
16 | + } |
|
17 | + if (!preg_match ("#^\?(.*)#", $this->href) && !empty ($this->href)) { |
|
18 | + $this->href = "?" . $this->href; |
|
19 | + } |
|
15 | 20 | if (preg_match ("/(bookdetail|getJSON).php/", parent::getScriptName())) { |
16 | 21 | $this->href = "index.php" . $this->href; |
17 | 22 | } else { |
@@ -8,7 +8,7 @@ |
||
8 | 8 | |
9 | 9 | class LinkNavigation extends Link |
10 | 10 | { |
11 | - public function __construct($phref, $prel = NULL, $ptitle = NULL) { |
|
11 | + public function __construct($phref, $prel = null, $ptitle = null) { |
|
12 | 12 | parent::__construct ($phref, Link::OPDS_NAVIGATION_TYPE, $prel, $ptitle); |
13 | 13 | if (!is_null (GetUrlParam (DB))) $this->href = addURLParameter ($this->href, DB, GetUrlParam (DB)); |
14 | 14 | if (!preg_match ("#^\?(.*)#", $this->href) && !empty ($this->href)) $this->href = "?" . $this->href; |
@@ -8,6 +8,9 @@ discard block |
||
8 | 8 | |
9 | 9 | class PageCustomize extends Page |
10 | 10 | { |
11 | + /** |
|
12 | + * @param string $key |
|
13 | + */ |
|
11 | 14 | private function isChecked ($key, $testedValue = 1) { |
12 | 15 | $value = getCurrentOption ($key); |
13 | 16 | if (is_array ($value)) { |
@@ -22,6 +25,9 @@ discard block |
||
22 | 25 | return ""; |
23 | 26 | } |
24 | 27 | |
28 | + /** |
|
29 | + * @param string $key |
|
30 | + */ |
|
25 | 31 | private function isSelected ($key, $value) { |
26 | 32 | if (getCurrentOption ($key) == $value) { |
27 | 33 | return "selected='selected'"; |
@@ -55,11 +55,11 @@ |
||
55 | 55 | $this->entryArray = array (); |
56 | 56 | |
57 | 57 | $ignoredBaseArray = array (PageQueryResult::SCOPE_AUTHOR, |
58 | - PageQueryResult::SCOPE_TAG, |
|
59 | - PageQueryResult::SCOPE_SERIES, |
|
60 | - PageQueryResult::SCOPE_PUBLISHER, |
|
61 | - PageQueryResult::SCOPE_RATING, |
|
62 | - "language"); |
|
58 | + PageQueryResult::SCOPE_TAG, |
|
59 | + PageQueryResult::SCOPE_SERIES, |
|
60 | + PageQueryResult::SCOPE_PUBLISHER, |
|
61 | + PageQueryResult::SCOPE_RATING, |
|
62 | + "language"); |
|
63 | 63 | |
64 | 64 | $content = ""; |
65 | 65 | if (!preg_match("/(Kobo|Kindle\/3.0|EBRD1101)/", $_SERVER['HTTP_USER_AGENT'])) { |
@@ -8,10 +8,10 @@ discard block |
||
8 | 8 | |
9 | 9 | class PageCustomize extends Page |
10 | 10 | { |
11 | - private function isChecked ($key, $testedValue = 1) { |
|
12 | - $value = getCurrentOption ($key); |
|
13 | - if (is_array ($value)) { |
|
14 | - if (in_array ($testedValue, $value)) { |
|
11 | + private function isChecked($key, $testedValue = 1) { |
|
12 | + $value = getCurrentOption($key); |
|
13 | + if (is_array($value)) { |
|
14 | + if (in_array($testedValue, $value)) { |
|
15 | 15 | return "checked='checked'"; |
16 | 16 | } |
17 | 17 | } else { |
@@ -22,39 +22,39 @@ discard block |
||
22 | 22 | return ""; |
23 | 23 | } |
24 | 24 | |
25 | - private function isSelected ($key, $value) { |
|
26 | - if (getCurrentOption ($key) == $value) { |
|
25 | + private function isSelected($key, $value) { |
|
26 | + if (getCurrentOption($key) == $value) { |
|
27 | 27 | return "selected='selected'"; |
28 | 28 | } |
29 | 29 | return ""; |
30 | 30 | } |
31 | 31 | |
32 | - private function getTemplateList () { |
|
33 | - $result = array (); |
|
34 | - foreach (glob ("templates/*") as $filename) { |
|
35 | - if (preg_match ('/templates\/(.*)/', $filename, $m)) { |
|
36 | - array_push ($result, $m [1]); |
|
32 | + private function getTemplateList() { |
|
33 | + $result = array(); |
|
34 | + foreach (glob("templates/*") as $filename) { |
|
35 | + if (preg_match('/templates\/(.*)/', $filename, $m)) { |
|
36 | + array_push($result, $m [1]); |
|
37 | 37 | } |
38 | 38 | } |
39 | 39 | return $result; |
40 | 40 | } |
41 | 41 | |
42 | - private function getStyleList () { |
|
43 | - $result = array (); |
|
44 | - foreach (glob ("templates/" . getCurrentTemplate () . "/styles/style-*.css") as $filename) { |
|
45 | - if (preg_match ('/styles\/style-(.*?)\.css/', $filename, $m)) { |
|
46 | - array_push ($result, $m [1]); |
|
42 | + private function getStyleList() { |
|
43 | + $result = array(); |
|
44 | + foreach (glob("templates/" . getCurrentTemplate() . "/styles/style-*.css") as $filename) { |
|
45 | + if (preg_match('/styles\/style-(.*?)\.css/', $filename, $m)) { |
|
46 | + array_push($result, $m [1]); |
|
47 | 47 | } |
48 | 48 | } |
49 | 49 | return $result; |
50 | 50 | } |
51 | 51 | |
52 | - public function InitializeContent () |
|
52 | + public function InitializeContent() |
|
53 | 53 | { |
54 | - $this->title = localize ("customize.title"); |
|
55 | - $this->entryArray = array (); |
|
54 | + $this->title = localize("customize.title"); |
|
55 | + $this->entryArray = array(); |
|
56 | 56 | |
57 | - $ignoredBaseArray = array (PageQueryResult::SCOPE_AUTHOR, |
|
57 | + $ignoredBaseArray = array(PageQueryResult::SCOPE_AUTHOR, |
|
58 | 58 | PageQueryResult::SCOPE_TAG, |
59 | 59 | PageQueryResult::SCOPE_SERIES, |
60 | 60 | PageQueryResult::SCOPE_PUBLISHER, |
@@ -65,60 +65,60 @@ discard block |
||
65 | 65 | if (!preg_match("/(Kobo|Kindle\/3.0|EBRD1101)/", $_SERVER['HTTP_USER_AGENT'])) { |
66 | 66 | $content .= "<select id='template' onchange='updateCookie (this); window.location=$(\".headleft\").attr(\"href\");'>"; |
67 | 67 | |
68 | - foreach ($this-> getTemplateList () as $filename) { |
|
69 | - $content .= "<option value='{$filename}' " . $this->isSelected ("template", $filename) . ">{$filename}</option>"; |
|
68 | + foreach ($this-> getTemplateList() as $filename) { |
|
69 | + $content .= "<option value='{$filename}' " . $this->isSelected("template", $filename) . ">{$filename}</option>"; |
|
70 | 70 | } |
71 | 71 | $content .= '</select>'; |
72 | 72 | } else { |
73 | - foreach ($this-> getTemplateList () as $filename) { |
|
74 | - $content .= "<input type='radio' onchange='updateCookieFromCheckbox (this); window.location=$(\".headleft\").attr(\"href\");' id='template' name='template' value='{$filename}' " . $this->isChecked ("template", $filename) . " /><label for='template-{$filename}'> {$filename} </label>"; |
|
73 | + foreach ($this-> getTemplateList() as $filename) { |
|
74 | + $content .= "<input type='radio' onchange='updateCookieFromCheckbox (this); window.location=$(\".headleft\").attr(\"href\");' id='template' name='template' value='{$filename}' " . $this->isChecked("template", $filename) . " /><label for='template-{$filename}'> {$filename} </label>"; |
|
75 | 75 | } |
76 | 76 | } |
77 | - array_push ($this->entryArray, new Entry ("Template", "", |
|
77 | + array_push($this->entryArray, new Entry("Template", "", |
|
78 | 78 | $content, "text", |
79 | - array ())); |
|
79 | + array())); |
|
80 | 80 | |
81 | 81 | $content = ""; |
82 | 82 | if (!preg_match("/(Kobo|Kindle\/3.0|EBRD1101)/", $_SERVER['HTTP_USER_AGENT'])) { |
83 | 83 | $content .= '<select id="style" onchange="updateCookie (this);">'; |
84 | - foreach ($this-> getStyleList () as $filename) { |
|
85 | - $content .= "<option value='{$filename}' " . $this->isSelected ("style", $filename) . ">{$filename}</option>"; |
|
84 | + foreach ($this-> getStyleList() as $filename) { |
|
85 | + $content .= "<option value='{$filename}' " . $this->isSelected("style", $filename) . ">{$filename}</option>"; |
|
86 | 86 | } |
87 | 87 | $content .= '</select>'; |
88 | 88 | } else { |
89 | - foreach ($this-> getStyleList () as $filename) { |
|
90 | - $content .= "<input type='radio' onchange='updateCookieFromCheckbox (this);' id='style-{$filename}' name='style' value='{$filename}' " . $this->isChecked ("style", $filename) . " /><label for='style-{$filename}'> {$filename} </label>"; |
|
89 | + foreach ($this-> getStyleList() as $filename) { |
|
90 | + $content .= "<input type='radio' onchange='updateCookieFromCheckbox (this);' id='style-{$filename}' name='style' value='{$filename}' " . $this->isChecked("style", $filename) . " /><label for='style-{$filename}'> {$filename} </label>"; |
|
91 | 91 | } |
92 | 92 | } |
93 | - array_push ($this->entryArray, new Entry (localize ("customize.style"), "", |
|
93 | + array_push($this->entryArray, new Entry(localize("customize.style"), "", |
|
94 | 94 | $content, "text", |
95 | - array ())); |
|
96 | - if (!useServerSideRendering ()) { |
|
97 | - $content = '<input type="checkbox" onchange="updateCookieFromCheckbox (this);" id="use_fancyapps" ' . $this->isChecked ("use_fancyapps") . ' />'; |
|
98 | - array_push ($this->entryArray, new Entry (localize ("customize.fancybox"), "", |
|
95 | + array())); |
|
96 | + if (!useServerSideRendering()) { |
|
97 | + $content = '<input type="checkbox" onchange="updateCookieFromCheckbox (this);" id="use_fancyapps" ' . $this->isChecked("use_fancyapps") . ' />'; |
|
98 | + array_push($this->entryArray, new Entry(localize("customize.fancybox"), "", |
|
99 | 99 | $content, "text", |
100 | - array ())); |
|
100 | + array())); |
|
101 | 101 | } |
102 | - $content = '<input type="number" onchange="updateCookie (this);" id="max_item_per_page" value="' . getCurrentOption ("max_item_per_page") . '" min="-1" max="1200" pattern="^[-+]?[0-9]+$" />'; |
|
103 | - array_push ($this->entryArray, new Entry (localize ("customize.paging"), "", |
|
102 | + $content = '<input type="number" onchange="updateCookie (this);" id="max_item_per_page" value="' . getCurrentOption("max_item_per_page") . '" min="-1" max="1200" pattern="^[-+]?[0-9]+$" />'; |
|
103 | + array_push($this->entryArray, new Entry(localize("customize.paging"), "", |
|
104 | 104 | $content, "text", |
105 | - array ())); |
|
106 | - $content = '<input type="text" onchange="updateCookie (this);" id="email" value="' . getCurrentOption ("email") . '" />'; |
|
107 | - array_push ($this->entryArray, new Entry (localize ("customize.email"), "", |
|
105 | + array())); |
|
106 | + $content = '<input type="text" onchange="updateCookie (this);" id="email" value="' . getCurrentOption("email") . '" />'; |
|
107 | + array_push($this->entryArray, new Entry(localize("customize.email"), "", |
|
108 | 108 | $content, "text", |
109 | - array ())); |
|
110 | - $content = '<input type="checkbox" onchange="updateCookieFromCheckbox (this);" id="html_tag_filter" ' . $this->isChecked ("html_tag_filter") . ' />'; |
|
111 | - array_push ($this->entryArray, new Entry (localize ("customize.filter"), "", |
|
109 | + array())); |
|
110 | + $content = '<input type="checkbox" onchange="updateCookieFromCheckbox (this);" id="html_tag_filter" ' . $this->isChecked("html_tag_filter") . ' />'; |
|
111 | + array_push($this->entryArray, new Entry(localize("customize.filter"), "", |
|
112 | 112 | $content, "text", |
113 | - array ())); |
|
113 | + array())); |
|
114 | 114 | $content = ""; |
115 | 115 | foreach ($ignoredBaseArray as $key) { |
116 | - $keyPlural = preg_replace ('/(ss)$/', 's', $key . "s"); |
|
117 | - $content .= '<input type="checkbox" name="ignored_categories[]" onchange="updateCookieFromCheckboxGroup (this);" id="ignored_categories_' . $key . '" ' . $this->isChecked ("ignored_categories", $key) . ' > ' . localize ("{$keyPlural}.title") . '</input> '; |
|
116 | + $keyPlural = preg_replace('/(ss)$/', 's', $key . "s"); |
|
117 | + $content .= '<input type="checkbox" name="ignored_categories[]" onchange="updateCookieFromCheckboxGroup (this);" id="ignored_categories_' . $key . '" ' . $this->isChecked("ignored_categories", $key) . ' > ' . localize("{$keyPlural}.title") . '</input> '; |
|
118 | 118 | } |
119 | 119 | |
120 | - array_push ($this->entryArray, new Entry (localize ("customize.ignored"), "", |
|
120 | + array_push($this->entryArray, new Entry(localize("customize.ignored"), "", |
|
121 | 121 | $content, "text", |
122 | - array ())); |
|
122 | + array())); |
|
123 | 123 | } |
124 | 124 | } |
@@ -8,7 +8,8 @@ discard block |
||
8 | 8 | |
9 | 9 | class PageCustomize extends Page |
10 | 10 | { |
11 | - private function isChecked ($key, $testedValue = 1) { |
|
11 | + private function isChecked ($key, $testedValue = 1) |
|
12 | + { |
|
12 | 13 | $value = getCurrentOption ($key); |
13 | 14 | if (is_array ($value)) { |
14 | 15 | if (in_array ($testedValue, $value)) { |
@@ -22,14 +23,16 @@ discard block |
||
22 | 23 | return ""; |
23 | 24 | } |
24 | 25 | |
25 | - private function isSelected ($key, $value) { |
|
26 | + private function isSelected ($key, $value) |
|
27 | + { |
|
26 | 28 | if (getCurrentOption ($key) == $value) { |
27 | 29 | return "selected='selected'"; |
28 | 30 | } |
29 | 31 | return ""; |
30 | 32 | } |
31 | 33 | |
32 | - private function getTemplateList () { |
|
34 | + private function getTemplateList () |
|
35 | + { |
|
33 | 36 | $result = array (); |
34 | 37 | foreach (glob ("templates/*") as $filename) { |
35 | 38 | if (preg_match ('/templates\/(.*)/', $filename, $m)) { |
@@ -39,7 +42,8 @@ discard block |
||
39 | 42 | return $result; |
40 | 43 | } |
41 | 44 | |
42 | - private function getStyleList () { |
|
45 | + private function getStyleList () |
|
46 | + { |
|
43 | 47 | $result = array (); |
44 | 48 | foreach (glob ("templates/" . getCurrentTemplate () . "/styles/style-*.css") as $filename) { |
45 | 49 | if (preg_match ('/styles\/style-(.*?)\.css/', $filename, $m)) { |
@@ -38,6 +38,9 @@ |
||
38 | 38 | return self::getEntryArray (self::SQL_ALL_RATINGS, array ()); |
39 | 39 | } |
40 | 40 | |
41 | + /** |
|
42 | + * @param string $query |
|
43 | + */ |
|
41 | 44 | public static function getEntryArray ($query, $params) { |
42 | 45 | list (, $result) = parent::executeQuery ($query, self::RATING_COLUMNS, "", $params, -1); |
43 | 46 | $entryArray = array(); |
@@ -11,7 +11,7 @@ discard block |
||
11 | 11 | const ALL_RATING_ID = "cops:rating"; |
12 | 12 | |
13 | 13 | const RATING_COLUMNS = "ratings.id as id, ratings.rating as rating, count(*) as count"; |
14 | - const SQL_ALL_RATINGS ="select {0} from ratings, books_ratings_link where books_ratings_link.rating = ratings.id group by ratings.id order by ratings.rating"; |
|
14 | + const SQL_ALL_RATINGS = "select {0} from ratings, books_ratings_link where books_ratings_link.rating = ratings.id group by ratings.id order by ratings.rating"; |
|
15 | 15 | public $id; |
16 | 16 | public $name; |
17 | 17 | |
@@ -20,41 +20,41 @@ discard block |
||
20 | 20 | $this->name = $pname; |
21 | 21 | } |
22 | 22 | |
23 | - public function getUri () { |
|
24 | - return "?page=".parent::PAGE_RATING_DETAIL."&id=$this->id"; |
|
23 | + public function getUri() { |
|
24 | + return "?page=" . parent::PAGE_RATING_DETAIL . "&id=$this->id"; |
|
25 | 25 | } |
26 | 26 | |
27 | - public function getEntryId () { |
|
28 | - return self::ALL_RATING_ID.":".$this->id; |
|
27 | + public function getEntryId() { |
|
28 | + return self::ALL_RATING_ID . ":" . $this->id; |
|
29 | 29 | } |
30 | 30 | |
31 | 31 | public static function getCount() { |
32 | 32 | // str_format (localize("ratings", count(array)) |
33 | - return parent::getCountGeneric ("ratings", self::ALL_RATING_ID, parent::PAGE_ALL_RATINGS, "ratings"); |
|
33 | + return parent::getCountGeneric("ratings", self::ALL_RATING_ID, parent::PAGE_ALL_RATINGS, "ratings"); |
|
34 | 34 | } |
35 | 35 | |
36 | 36 | public static function getAllRatings() { |
37 | - return self::getEntryArray (self::SQL_ALL_RATINGS, array ()); |
|
37 | + return self::getEntryArray(self::SQL_ALL_RATINGS, array()); |
|
38 | 38 | } |
39 | 39 | |
40 | - public static function getEntryArray ($query, $params) { |
|
41 | - list (, $result) = parent::executeQuery ($query, self::RATING_COLUMNS, "", $params, -1); |
|
40 | + public static function getEntryArray($query, $params) { |
|
41 | + list (, $result) = parent::executeQuery($query, self::RATING_COLUMNS, "", $params, -1); |
|
42 | 42 | $entryArray = array(); |
43 | - while ($post = $result->fetchObject ()) |
|
43 | + while ($post = $result->fetchObject()) |
|
44 | 44 | { |
45 | - $ratingObj = new Rating ($post->id, $post->rating); |
|
46 | - $rating=$post->rating/2; |
|
47 | - $rating = str_format (localize("ratingword", $rating), $rating); |
|
48 | - array_push ($entryArray, new Entry ($rating, $ratingObj->getEntryId (), |
|
49 | - str_format (localize("bookword", $post->count), $post->count), "text", |
|
50 | - array ( new LinkNavigation ($ratingObj->getUri ())), "", $post->count)); |
|
45 | + $ratingObj = new Rating($post->id, $post->rating); |
|
46 | + $rating = $post->rating / 2; |
|
47 | + $rating = str_format(localize("ratingword", $rating), $rating); |
|
48 | + array_push($entryArray, new Entry($rating, $ratingObj->getEntryId(), |
|
49 | + str_format(localize("bookword", $post->count), $post->count), "text", |
|
50 | + array(new LinkNavigation($ratingObj->getUri())), "", $post->count)); |
|
51 | 51 | } |
52 | 52 | return $entryArray; |
53 | 53 | } |
54 | 54 | |
55 | - public static function getRatingById ($ratingId) { |
|
56 | - $result = parent::getDb ()->prepare('select rating from ratings where id = ?'); |
|
57 | - $result->execute (array ($ratingId)); |
|
58 | - return new Rating ($ratingId, $result->fetchColumn ()); |
|
55 | + public static function getRatingById($ratingId) { |
|
56 | + $result = parent::getDb()->prepare('select rating from ratings where id = ?'); |
|
57 | + $result->execute(array($ratingId)); |
|
58 | + return new Rating($ratingId, $result->fetchColumn()); |
|
59 | 59 | } |
60 | 60 | } |
@@ -15,33 +15,38 @@ discard block |
||
15 | 15 | public $id; |
16 | 16 | public $name; |
17 | 17 | |
18 | - public function __construct($pid, $pname) { |
|
18 | + public function __construct($pid, $pname) |
|
19 | + { |
|
19 | 20 | $this->id = $pid; |
20 | 21 | $this->name = $pname; |
21 | 22 | } |
22 | 23 | |
23 | - public function getUri () { |
|
24 | + public function getUri () |
|
25 | + { |
|
24 | 26 | return "?page=".parent::PAGE_RATING_DETAIL."&id=$this->id"; |
25 | 27 | } |
26 | 28 | |
27 | - public function getEntryId () { |
|
29 | + public function getEntryId () |
|
30 | + { |
|
28 | 31 | return self::ALL_RATING_ID.":".$this->id; |
29 | 32 | } |
30 | 33 | |
31 | - public static function getCount() { |
|
34 | + public static function getCount() |
|
35 | + { |
|
32 | 36 | // str_format (localize("ratings", count(array)) |
33 | 37 | return parent::getCountGeneric ("ratings", self::ALL_RATING_ID, parent::PAGE_ALL_RATINGS, "ratings"); |
34 | 38 | } |
35 | 39 | |
36 | - public static function getAllRatings() { |
|
40 | + public static function getAllRatings() |
|
41 | + { |
|
37 | 42 | return self::getEntryArray (self::SQL_ALL_RATINGS, array ()); |
38 | 43 | } |
39 | 44 | |
40 | - public static function getEntryArray ($query, $params) { |
|
45 | + public static function getEntryArray ($query, $params) |
|
46 | + { |
|
41 | 47 | list (, $result) = parent::executeQuery ($query, self::RATING_COLUMNS, "", $params, -1); |
42 | 48 | $entryArray = array(); |
43 | - while ($post = $result->fetchObject ()) |
|
44 | - { |
|
49 | + while ($post = $result->fetchObject ()) { |
|
45 | 50 | $ratingObj = new Rating ($post->id, $post->rating); |
46 | 51 | $rating=$post->rating/2; |
47 | 52 | $rating = str_format (localize("ratingword", $rating), $rating); |
@@ -52,7 +57,8 @@ discard block |
||
52 | 57 | return $entryArray; |
53 | 58 | } |
54 | 59 | |
55 | - public static function getRatingById ($ratingId) { |
|
60 | + public static function getRatingById ($ratingId) |
|
61 | + { |
|
56 | 62 | $result = parent::getDb ()->prepare('select rating from ratings where id = ?'); |
57 | 63 | $result->execute (array ($ratingId)); |
58 | 64 | return new Rating ($ratingId, $result->fetchColumn ()); |