@@ -24,55 +24,55 @@ discard block |
||
| 24 | 24 | /* @var Entry[] */ |
| 25 | 25 | public $entryArray = array(); |
| 26 | 26 | |
| 27 | - public static function getPage ($pageId, $id, $query, $n) |
|
| 27 | + public static function getPage($pageId, $id, $query, $n) |
|
| 28 | 28 | { |
| 29 | 29 | switch ($pageId) { |
| 30 | 30 | case Base::PAGE_ALL_AUTHORS : |
| 31 | - return new PageAllAuthors ($id, $query, $n); |
|
| 31 | + return new PageAllAuthors($id, $query, $n); |
|
| 32 | 32 | case Base::PAGE_AUTHORS_FIRST_LETTER : |
| 33 | - return new PageAllAuthorsLetter ($id, $query, $n); |
|
| 33 | + return new PageAllAuthorsLetter($id, $query, $n); |
|
| 34 | 34 | case Base::PAGE_AUTHOR_DETAIL : |
| 35 | - return new PageAuthorDetail ($id, $query, $n); |
|
| 35 | + return new PageAuthorDetail($id, $query, $n); |
|
| 36 | 36 | case Base::PAGE_ALL_TAGS : |
| 37 | - return new PageAllTags ($id, $query, $n); |
|
| 37 | + return new PageAllTags($id, $query, $n); |
|
| 38 | 38 | case Base::PAGE_TAG_DETAIL : |
| 39 | - return new PageTagDetail ($id, $query, $n); |
|
| 39 | + return new PageTagDetail($id, $query, $n); |
|
| 40 | 40 | case Base::PAGE_ALL_LANGUAGES : |
| 41 | - return new PageAllLanguages ($id, $query, $n); |
|
| 41 | + return new PageAllLanguages($id, $query, $n); |
|
| 42 | 42 | case Base::PAGE_LANGUAGE_DETAIL : |
| 43 | - return new PageLanguageDetail ($id, $query, $n); |
|
| 43 | + return new PageLanguageDetail($id, $query, $n); |
|
| 44 | 44 | case Base::PAGE_ALL_CUSTOMS : |
| 45 | - return new PageAllCustoms ($id, $query, $n); |
|
| 45 | + return new PageAllCustoms($id, $query, $n); |
|
| 46 | 46 | case Base::PAGE_CUSTOM_DETAIL : |
| 47 | - return new PageCustomDetail ($id, $query, $n); |
|
| 47 | + return new PageCustomDetail($id, $query, $n); |
|
| 48 | 48 | case Base::PAGE_ALL_RATINGS : |
| 49 | - return new PageAllRating ($id, $query, $n); |
|
| 49 | + return new PageAllRating($id, $query, $n); |
|
| 50 | 50 | case Base::PAGE_RATING_DETAIL : |
| 51 | - return new PageRatingDetail ($id, $query, $n); |
|
| 51 | + return new PageRatingDetail($id, $query, $n); |
|
| 52 | 52 | case Base::PAGE_ALL_SERIES : |
| 53 | - return new PageAllSeries ($id, $query, $n); |
|
| 53 | + return new PageAllSeries($id, $query, $n); |
|
| 54 | 54 | case Base::PAGE_ALL_BOOKS : |
| 55 | - return new PageAllBooks ($id, $query, $n); |
|
| 55 | + return new PageAllBooks($id, $query, $n); |
|
| 56 | 56 | case Base::PAGE_ALL_BOOKS_LETTER: |
| 57 | - return new PageAllBooksLetter ($id, $query, $n); |
|
| 57 | + return new PageAllBooksLetter($id, $query, $n); |
|
| 58 | 58 | case Base::PAGE_ALL_RECENT_BOOKS : |
| 59 | - return new PageRecentBooks ($id, $query, $n); |
|
| 59 | + return new PageRecentBooks($id, $query, $n); |
|
| 60 | 60 | case Base::PAGE_SERIE_DETAIL : |
| 61 | - return new PageSerieDetail ($id, $query, $n); |
|
| 61 | + return new PageSerieDetail($id, $query, $n); |
|
| 62 | 62 | case Base::PAGE_OPENSEARCH_QUERY : |
| 63 | - return new PageQueryResult ($id, $query, $n); |
|
| 63 | + return new PageQueryResult($id, $query, $n); |
|
| 64 | 64 | case Base::PAGE_BOOK_DETAIL : |
| 65 | - return new PageBookDetail ($id, $query, $n); |
|
| 65 | + return new PageBookDetail($id, $query, $n); |
|
| 66 | 66 | case Base::PAGE_ALL_PUBLISHERS: |
| 67 | - return new PageAllPublishers ($id, $query, $n); |
|
| 67 | + return new PageAllPublishers($id, $query, $n); |
|
| 68 | 68 | case Base::PAGE_PUBLISHER_DETAIL : |
| 69 | - return new PagePublisherDetail ($id, $query, $n); |
|
| 69 | + return new PagePublisherDetail($id, $query, $n); |
|
| 70 | 70 | case Base::PAGE_ABOUT : |
| 71 | - return new PageAbout ($id, $query, $n); |
|
| 71 | + return new PageAbout($id, $query, $n); |
|
| 72 | 72 | case Base::PAGE_CUSTOMIZE : |
| 73 | - return new PageCustomize ($id, $query, $n); |
|
| 73 | + return new PageCustomize($id, $query, $n); |
|
| 74 | 74 | default: |
| 75 | - $page = new Page ($id, $query, $n); |
|
| 75 | + $page = new Page($id, $query, $n); |
|
| 76 | 76 | $page->idPage = "cops:catalog"; |
| 77 | 77 | return $page; |
| 78 | 78 | } |
@@ -85,96 +85,96 @@ discard block |
||
| 85 | 85 | $this->query = $pquery; |
| 86 | 86 | $this->n = $pn; |
| 87 | 87 | $this->favicon = $config['cops_icon']; |
| 88 | - $this->authorName = empty($config['cops_author_name']) ? utf8_encode('Sébastien Lucas') : $config['cops_author_name']; |
|
| 89 | - $this->authorUri = empty($config['cops_author_uri']) ? 'http://blog.slucas.fr' : $config['cops_author_uri']; |
|
| 90 | - $this->authorEmail = empty($config['cops_author_email']) ? '[email protected]' : $config['cops_author_email']; |
|
| 88 | + $this->authorName = empty($config['cops_author_name'])? utf8_encode('Sébastien Lucas'):$config['cops_author_name']; |
|
| 89 | + $this->authorUri = empty($config['cops_author_uri'])?'http://blog.slucas.fr':$config['cops_author_uri']; |
|
| 90 | + $this->authorEmail = empty($config['cops_author_email'])?'[email protected]':$config['cops_author_email']; |
|
| 91 | 91 | } |
| 92 | 92 | |
| 93 | - public function InitializeContent () |
|
| 93 | + public function InitializeContent() |
|
| 94 | 94 | { |
| 95 | 95 | global $config; |
| 96 | 96 | $this->title = $config['cops_title_default']; |
| 97 | 97 | $this->subtitle = $config['cops_subtitle_default']; |
| 98 | - if (Base::noDatabaseSelected ()) { |
|
| 98 | + if (Base::noDatabaseSelected()) { |
|
| 99 | 99 | $i = 0; |
| 100 | - foreach (Base::getDbNameList () as $key) { |
|
| 101 | - $nBooks = Book::getBookCount ($i); |
|
| 102 | - array_push ($this->entryArray, new Entry ($key, "cops:{$i}:catalog", |
|
| 103 | - str_format (localize ("bookword", $nBooks), $nBooks), "text", |
|
| 104 | - array ( new LinkNavigation ("?" . DB . "={$i}")), "", $nBooks)); |
|
| 100 | + foreach (Base::getDbNameList() as $key) { |
|
| 101 | + $nBooks = Book::getBookCount($i); |
|
| 102 | + array_push($this->entryArray, new Entry($key, "cops:{$i}:catalog", |
|
| 103 | + str_format(localize("bookword", $nBooks), $nBooks), "text", |
|
| 104 | + array(new LinkNavigation("?" . DB . "={$i}")), "", $nBooks)); |
|
| 105 | 105 | $i++; |
| 106 | - Base::clearDb (); |
|
| 106 | + Base::clearDb(); |
|
| 107 | 107 | } |
| 108 | 108 | } else { |
| 109 | - if (!in_array (PageQueryResult::SCOPE_AUTHOR, getCurrentOption ('ignored_categories'))) { |
|
| 110 | - array_push ($this->entryArray, Author::getCount()); |
|
| 109 | + if (!in_array(PageQueryResult::SCOPE_AUTHOR, getCurrentOption('ignored_categories'))) { |
|
| 110 | + array_push($this->entryArray, Author::getCount()); |
|
| 111 | 111 | } |
| 112 | - if (!in_array (PageQueryResult::SCOPE_SERIES, getCurrentOption ('ignored_categories'))) { |
|
| 112 | + if (!in_array(PageQueryResult::SCOPE_SERIES, getCurrentOption('ignored_categories'))) { |
|
| 113 | 113 | $series = Serie::getCount(); |
| 114 | - if (!is_null ($series)) array_push ($this->entryArray, $series); |
|
| 114 | + if (!is_null($series)) array_push($this->entryArray, $series); |
|
| 115 | 115 | } |
| 116 | - if (!in_array (PageQueryResult::SCOPE_PUBLISHER, getCurrentOption ('ignored_categories'))) { |
|
| 116 | + if (!in_array(PageQueryResult::SCOPE_PUBLISHER, getCurrentOption('ignored_categories'))) { |
|
| 117 | 117 | $publisher = Publisher::getCount(); |
| 118 | - if (!is_null ($publisher)) array_push ($this->entryArray, $publisher); |
|
| 118 | + if (!is_null($publisher)) array_push($this->entryArray, $publisher); |
|
| 119 | 119 | } |
| 120 | - if (!in_array (PageQueryResult::SCOPE_TAG, getCurrentOption ('ignored_categories'))) { |
|
| 120 | + if (!in_array(PageQueryResult::SCOPE_TAG, getCurrentOption('ignored_categories'))) { |
|
| 121 | 121 | $tags = Tag::getCount(); |
| 122 | - if (!is_null ($tags)) array_push ($this->entryArray, $tags); |
|
| 122 | + if (!is_null($tags)) array_push($this->entryArray, $tags); |
|
| 123 | 123 | } |
| 124 | - if (!in_array (PageQueryResult::SCOPE_RATING, getCurrentOption ('ignored_categories'))) { |
|
| 124 | + if (!in_array(PageQueryResult::SCOPE_RATING, getCurrentOption('ignored_categories'))) { |
|
| 125 | 125 | $rating = Rating::getCount(); |
| 126 | - if (!is_null ($rating)) array_push ($this->entryArray, $rating); |
|
| 126 | + if (!is_null($rating)) array_push($this->entryArray, $rating); |
|
| 127 | 127 | } |
| 128 | - if (!in_array ("language", getCurrentOption ('ignored_categories'))) { |
|
| 128 | + if (!in_array("language", getCurrentOption('ignored_categories'))) { |
|
| 129 | 129 | $languages = Language::getCount(); |
| 130 | - if (!is_null ($languages)) array_push ($this->entryArray, $languages); |
|
| 130 | + if (!is_null($languages)) array_push($this->entryArray, $languages); |
|
| 131 | 131 | } |
| 132 | 132 | foreach ($config['cops_calibre_custom_column'] as $lookup) { |
| 133 | 133 | $customColumn = CustomColumnType::createByLookup($lookup); |
| 134 | - if (!is_null ($customColumn) && $customColumn->isSearchable()) { |
|
| 135 | - array_push ($this->entryArray, $customColumn->getCount()); |
|
| 134 | + if (!is_null($customColumn) && $customColumn->isSearchable()) { |
|
| 135 | + array_push($this->entryArray, $customColumn->getCount()); |
|
| 136 | 136 | } |
| 137 | 137 | } |
| 138 | - $this->entryArray = array_merge ($this->entryArray, Book::getCount()); |
|
| 138 | + $this->entryArray = array_merge($this->entryArray, Book::getCount()); |
|
| 139 | 139 | |
| 140 | - if (Base::isMultipleDatabaseEnabled ()) $this->title = Base::getDbName (); |
|
| 140 | + if (Base::isMultipleDatabaseEnabled()) $this->title = Base::getDbName(); |
|
| 141 | 141 | } |
| 142 | 142 | } |
| 143 | 143 | |
| 144 | - public function isPaginated () |
|
| 144 | + public function isPaginated() |
|
| 145 | 145 | { |
| 146 | - return (getCurrentOption ("max_item_per_page") != -1 && |
|
| 146 | + return (getCurrentOption("max_item_per_page") != -1 && |
|
| 147 | 147 | $this->totalNumber != -1 && |
| 148 | - $this->totalNumber > getCurrentOption ("max_item_per_page")); |
|
| 148 | + $this->totalNumber > getCurrentOption("max_item_per_page")); |
|
| 149 | 149 | } |
| 150 | 150 | |
| 151 | - public function getNextLink () |
|
| 151 | + public function getNextLink() |
|
| 152 | 152 | { |
| 153 | - $currentUrl = preg_replace ("/\&n=.*?$/", "", "?" . getQueryString ()); |
|
| 154 | - if (($this->n) * getCurrentOption ("max_item_per_page") < $this->totalNumber) { |
|
| 155 | - return new LinkNavigation ($currentUrl . "&n=" . ($this->n + 1), "next", localize ("paging.next.alternate")); |
|
| 153 | + $currentUrl = preg_replace("/\&n=.*?$/", "", "?" . getQueryString()); |
|
| 154 | + if (($this->n) * getCurrentOption("max_item_per_page") < $this->totalNumber) { |
|
| 155 | + return new LinkNavigation($currentUrl . "&n=" . ($this->n + 1), "next", localize("paging.next.alternate")); |
|
| 156 | 156 | } |
| 157 | 157 | return NULL; |
| 158 | 158 | } |
| 159 | 159 | |
| 160 | - public function getPrevLink () |
|
| 160 | + public function getPrevLink() |
|
| 161 | 161 | { |
| 162 | - $currentUrl = preg_replace ("/\&n=.*?$/", "", "?" . getQueryString ()); |
|
| 162 | + $currentUrl = preg_replace("/\&n=.*?$/", "", "?" . getQueryString()); |
|
| 163 | 163 | if ($this->n > 1) { |
| 164 | - return new LinkNavigation ($currentUrl . "&n=" . ($this->n - 1), "previous", localize ("paging.previous.alternate")); |
|
| 164 | + return new LinkNavigation($currentUrl . "&n=" . ($this->n - 1), "previous", localize("paging.previous.alternate")); |
|
| 165 | 165 | } |
| 166 | 166 | return NULL; |
| 167 | 167 | } |
| 168 | 168 | |
| 169 | - public function getMaxPage () |
|
| 169 | + public function getMaxPage() |
|
| 170 | 170 | { |
| 171 | - return ceil ($this->totalNumber / getCurrentOption ("max_item_per_page")); |
|
| 171 | + return ceil($this->totalNumber / getCurrentOption("max_item_per_page")); |
|
| 172 | 172 | } |
| 173 | 173 | |
| 174 | - public function containsBook () |
|
| 174 | + public function containsBook() |
|
| 175 | 175 | { |
| 176 | - if (count ($this->entryArray) == 0) return false; |
|
| 177 | - if (get_class ($this->entryArray [0]) == "EntryBook") return true; |
|
| 176 | + if (count($this->entryArray) == 0) return false; |
|
| 177 | + if (get_class($this->entryArray [0]) == "EntryBook") return true; |
|
| 178 | 178 | return false; |
| 179 | 179 | } |
| 180 | 180 | } |
@@ -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 | class Book extends Base |
@@ -105,7 +105,7 @@ discard block |
||
| 105 | 105 | public $serie = NULL; |
| 106 | 106 | public $tags = NULL; |
| 107 | 107 | public $languages = NULL; |
| 108 | - public $format = array (); |
|
| 108 | + public $format = array(); |
|
| 109 | 109 | |
| 110 | 110 | |
| 111 | 111 | public function __construct($line) { |
@@ -127,24 +127,24 @@ discard block |
||
| 127 | 127 | } |
| 128 | 128 | |
| 129 | 129 | public function getEntryId() { |
| 130 | - return self::ALL_BOOKS_UUID.':'.$this->uuid; |
|
| 130 | + return self::ALL_BOOKS_UUID . ':' . $this->uuid; |
|
| 131 | 131 | } |
| 132 | 132 | |
| 133 | - public static function getEntryIdByLetter ($startingLetter) { |
|
| 134 | - return self::ALL_BOOKS_ID.':letter:'.$startingLetter; |
|
| 133 | + public static function getEntryIdByLetter($startingLetter) { |
|
| 134 | + return self::ALL_BOOKS_ID . ':letter:' . $startingLetter; |
|
| 135 | 135 | } |
| 136 | 136 | |
| 137 | - public function getUri () { |
|
| 138 | - return '?page='.parent::PAGE_BOOK_DETAIL.'&id=' . $this->id; |
|
| 137 | + public function getUri() { |
|
| 138 | + return '?page=' . parent::PAGE_BOOK_DETAIL . '&id=' . $this->id; |
|
| 139 | 139 | } |
| 140 | 140 | |
| 141 | - public function getDetailUrl () { |
|
| 141 | + public function getDetailUrl() { |
|
| 142 | 142 | $urlParam = $this->getUri(); |
| 143 | - if (!is_null(GetUrlParam(DB))) $urlParam = addURLParameter($urlParam, DB, GetUrlParam (DB)); |
|
| 143 | + if (!is_null(GetUrlParam(DB))) $urlParam = addURLParameter($urlParam, DB, GetUrlParam(DB)); |
|
| 144 | 144 | return 'index.php' . $urlParam; |
| 145 | 145 | } |
| 146 | 146 | |
| 147 | - public function getTitle () { |
|
| 147 | + public function getTitle() { |
|
| 148 | 148 | return $this->title; |
| 149 | 149 | } |
| 150 | 150 | |
@@ -153,22 +153,22 @@ discard block |
||
| 153 | 153 | /** |
| 154 | 154 | * @return Author[] |
| 155 | 155 | */ |
| 156 | - public function getAuthors () { |
|
| 156 | + public function getAuthors() { |
|
| 157 | 157 | if (is_null($this->authors)) { |
| 158 | 158 | $this->authors = Author::getAuthorByBookId($this->id); |
| 159 | 159 | } |
| 160 | 160 | return $this->authors; |
| 161 | 161 | } |
| 162 | 162 | |
| 163 | - public function getAuthorsName () { |
|
| 164 | - return implode(', ', array_map(function ($author) { return $author->name; }, $this->getAuthors())); |
|
| 163 | + public function getAuthorsName() { |
|
| 164 | + return implode(', ', array_map(function($author) { return $author->name; }, $this->getAuthors())); |
|
| 165 | 165 | } |
| 166 | 166 | |
| 167 | - public function getAuthorsSort () { |
|
| 168 | - return implode(', ', array_map(function ($author) { return $author->sort; }, $this->getAuthors())); |
|
| 167 | + public function getAuthorsSort() { |
|
| 168 | + return implode(', ', array_map(function($author) { return $author->sort; }, $this->getAuthors())); |
|
| 169 | 169 | } |
| 170 | 170 | |
| 171 | - public function getPublisher () { |
|
| 171 | + public function getPublisher() { |
|
| 172 | 172 | if (is_null($this->publisher)) { |
| 173 | 173 | $this->publisher = Publisher::getPublisherByBookId($this->id); |
| 174 | 174 | } |
@@ -207,7 +207,7 @@ discard block |
||
| 207 | 207 | * @return Tag[] |
| 208 | 208 | */ |
| 209 | 209 | public function getTags() { |
| 210 | - if (is_null ($this->tags)) { |
|
| 210 | + if (is_null($this->tags)) { |
|
| 211 | 211 | $this->tags = array(); |
| 212 | 212 | |
| 213 | 213 | $result = parent::getDb()->prepare('select tags.id as id, name |
@@ -225,7 +225,7 @@ discard block |
||
| 225 | 225 | } |
| 226 | 226 | |
| 227 | 227 | public function getTagsName() { |
| 228 | - return implode(', ', array_map(function ($tag) { return $tag->name; }, $this->getTags())); |
|
| 228 | + return implode(', ', array_map(function($tag) { return $tag->name; }, $this->getTags())); |
|
| 229 | 229 | } |
| 230 | 230 | |
| 231 | 231 | /** |
@@ -277,7 +277,7 @@ discard block |
||
| 277 | 277 | |
| 278 | 278 | public function getDataById($idData) |
| 279 | 279 | { |
| 280 | - $reduced = array_filter($this->getDatas(), function ($data) use ($idData) { |
|
| 280 | + $reduced = array_filter($this->getDatas(), function($data) use ($idData) { |
|
| 281 | 281 | return $data->id == $idData; |
| 282 | 282 | }); |
| 283 | 283 | return reset($reduced); |
@@ -301,7 +301,7 @@ discard block |
||
| 301 | 301 | if (empty ($this->pubdate)) { |
| 302 | 302 | return ''; |
| 303 | 303 | } |
| 304 | - $dateY = (int) substr($this->pubdate, 0, 4); |
|
| 304 | + $dateY = (int)substr($this->pubdate, 0, 4); |
|
| 305 | 305 | if ($dateY > 102) { |
| 306 | 306 | return str_pad($dateY, 4, '0', STR_PAD_LEFT); |
| 307 | 307 | } |
@@ -310,8 +310,8 @@ discard block |
||
| 310 | 310 | |
| 311 | 311 | public function getComment($withSerie = true) { |
| 312 | 312 | $addition = ''; |
| 313 | - $se = $this->getSerie (); |
|
| 314 | - if (!is_null ($se) && $withSerie) { |
|
| 313 | + $se = $this->getSerie(); |
|
| 314 | + if (!is_null($se) && $withSerie) { |
|
| 315 | 315 | $addition = $addition . '<strong>' . localize('content.series') . '</strong>' . str_format(localize('content.series.data'), $this->seriesIndex, htmlspecialchars($se->name)) . "<br />\n"; |
| 316 | 316 | } |
| 317 | 317 | if (preg_match('/<\/(div|p|a|span)>/', $this->comment)) |
@@ -325,7 +325,7 @@ discard block |
||
| 325 | 325 | } |
| 326 | 326 | |
| 327 | 327 | public function getDataFormat($format) { |
| 328 | - $reduced = array_filter($this->getDatas(), function ($data) use ($format) { |
|
| 328 | + $reduced = array_filter($this->getDatas(), function($data) use ($format) { |
|
| 329 | 329 | return $data->format == $format; |
| 330 | 330 | }); |
| 331 | 331 | return reset($reduced); |
@@ -346,11 +346,11 @@ discard block |
||
| 346 | 346 | |
| 347 | 347 | if ($relative) |
| 348 | 348 | { |
| 349 | - return $this->relativePath.'/'.$file; |
|
| 349 | + return $this->relativePath . '/' . $file; |
|
| 350 | 350 | } |
| 351 | 351 | else |
| 352 | 352 | { |
| 353 | - return $this->path.'/'.$file; |
|
| 353 | + return $this->path . '/' . $file; |
|
| 354 | 354 | } |
| 355 | 355 | } |
| 356 | 356 | |
@@ -370,7 +370,7 @@ discard block |
||
| 370 | 370 | } |
| 371 | 371 | $epub->Authors($authorArray); |
| 372 | 372 | $epub->Language($this->getLanguages()); |
| 373 | - $epub->Description ($this->getComment(false)); |
|
| 373 | + $epub->Description($this->getComment(false)); |
|
| 374 | 374 | $epub->Subjects($this->getTagsName()); |
| 375 | 375 | $epub->Cover2($this->getFilePath('jpg'), 'image/jpeg'); |
| 376 | 376 | $epub->Calibre($this->uuid); |
@@ -380,7 +380,7 @@ discard block |
||
| 380 | 380 | $epub->SerieIndex($this->seriesIndex); |
| 381 | 381 | } |
| 382 | 382 | $filename = $data->getUpdatedFilenameEpub(); |
| 383 | - if ($config['cops_provide_kepub'] == '1' && preg_match('/Kobo/', $_SERVER['HTTP_USER_AGENT'])) { |
|
| 383 | + if ($config['cops_provide_kepub'] == '1' && preg_match('/Kobo/', $_SERVER['HTTP_USER_AGENT'])) { |
|
| 384 | 384 | $epub->updateForKepub(); |
| 385 | 385 | $filename = $data->getUpdatedFilenameKepub(); |
| 386 | 386 | } |
@@ -406,11 +406,11 @@ discard block |
||
| 406 | 406 | if (!is_null($width)) { |
| 407 | 407 | $nw = $width; |
| 408 | 408 | if ($nw >= $w) { return false; } |
| 409 | - $nh = ($nw*$h)/$w; |
|
| 409 | + $nh = ($nw * $h) / $w; |
|
| 410 | 410 | } else { |
| 411 | 411 | $nh = $height; |
| 412 | 412 | if ($nh >= $h) { return false; } |
| 413 | - $nw = ($nh*$w)/$h; |
|
| 413 | + $nw = ($nh * $w) / $h; |
|
| 414 | 414 | } |
| 415 | 415 | } else { |
| 416 | 416 | return false; |
@@ -418,16 +418,16 @@ discard block |
||
| 418 | 418 | |
| 419 | 419 | //draw the image |
| 420 | 420 | $src_img = imagecreatefromjpeg($file); |
| 421 | - $dst_img = imagecreatetruecolor($nw,$nh); |
|
| 422 | - imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $nw, $nh, $w, $h);//resizing the image |
|
| 423 | - imagejpeg($dst_img,$outputfile,80); |
|
| 421 | + $dst_img = imagecreatetruecolor($nw, $nh); |
|
| 422 | + imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $nw, $nh, $w, $h); //resizing the image |
|
| 423 | + imagejpeg($dst_img, $outputfile, 80); |
|
| 424 | 424 | imagedestroy($src_img); |
| 425 | 425 | imagedestroy($dst_img); |
| 426 | 426 | |
| 427 | 427 | return true; |
| 428 | 428 | } |
| 429 | 429 | |
| 430 | - public function getLinkArray () |
|
| 430 | + public function getLinkArray() |
|
| 431 | 431 | { |
| 432 | 432 | $linkArray = array(); |
| 433 | 433 | |
@@ -452,7 +452,7 @@ discard block |
||
| 452 | 452 | } |
| 453 | 453 | |
| 454 | 454 | $serie = $this->getSerie(); |
| 455 | - if (!is_null ($serie)) { |
|
| 455 | + if (!is_null($serie)) { |
|
| 456 | 456 | array_push($linkArray, new LinkNavigation($serie->getUri(), 'related', str_format(localize('content.series.data'), $this->seriesIndex, $serie->name))); |
| 457 | 457 | } |
| 458 | 458 | |
@@ -477,13 +477,13 @@ discard block |
||
| 477 | 477 | $entry = new Entry(localize('allbooks.title'), |
| 478 | 478 | self::ALL_BOOKS_ID, |
| 479 | 479 | str_format(localize('allbooks.alphabetical', $nBooks), $nBooks), 'text', |
| 480 | - array(new LinkNavigation('?page='.parent::PAGE_ALL_BOOKS)), '', $nBooks); |
|
| 480 | + array(new LinkNavigation('?page=' . parent::PAGE_ALL_BOOKS)), '', $nBooks); |
|
| 481 | 481 | array_push($result, $entry); |
| 482 | 482 | if ($config['cops_recentbooks_limit'] > 0) { |
| 483 | 483 | $entry = new Entry(localize('recent.title'), |
| 484 | 484 | self::ALL_RECENT_BOOKS_ID, |
| 485 | 485 | str_format(localize('recent.list'), $config['cops_recentbooks_limit']), 'text', |
| 486 | - array ( new LinkNavigation ('?page='.parent::PAGE_ALL_RECENT_BOOKS)), '', $config['cops_recentbooks_limit']); |
|
| 486 | + array(new LinkNavigation('?page=' . parent::PAGE_ALL_RECENT_BOOKS)), '', $config['cops_recentbooks_limit']); |
|
| 487 | 487 | array_push($result, $entry); |
| 488 | 488 | } |
| 489 | 489 | return $result; |
@@ -579,7 +579,7 @@ discard block |
||
| 579 | 579 | } |
| 580 | 580 | |
| 581 | 581 | public static function getBooks($n) { |
| 582 | - list ($entryArray, $totalNumber) = self::getEntryArray(self::SQL_BOOKS_ALL , array (), $n); |
|
| 582 | + list ($entryArray, $totalNumber) = self::getEntryArray(self::SQL_BOOKS_ALL, array(), $n); |
|
| 583 | 583 | return array($entryArray, $totalNumber); |
| 584 | 584 | } |
| 585 | 585 | |
@@ -596,7 +596,7 @@ discard block |
||
| 596 | 596 | { |
| 597 | 597 | array_push($entryArray, new Entry($post->title, Book::getEntryIdByLetter($post->title), |
| 598 | 598 | str_format(localize('bookword', $post->count), $post->count), 'text', |
| 599 | - array(new LinkNavigation('?page='.parent::PAGE_ALL_BOOKS_LETTER.'&id='. rawurlencode($post->title))), '', $post->count)); |
|
| 599 | + array(new LinkNavigation('?page=' . parent::PAGE_ALL_BOOKS_LETTER . '&id=' . rawurlencode($post->title))), '', $post->count)); |
|
| 600 | 600 | } |
| 601 | 601 | return $entryArray; |
| 602 | 602 | } |
@@ -621,7 +621,7 @@ discard block |
||
| 621 | 621 | |
| 622 | 622 | public static function getAllRecentBooks() { |
| 623 | 623 | global $config; |
| 624 | - list ($entryArray, ) = self::getEntryArray(self::SQL_BOOKS_RECENT . $config['cops_recentbooks_limit'], array(), -1); |
|
| 624 | + list ($entryArray,) = self::getEntryArray(self::SQL_BOOKS_RECENT . $config['cops_recentbooks_limit'], array(), -1); |
|
| 625 | 625 | return $entryArray; |
| 626 | 626 | } |
| 627 | 627 | |
@@ -8,8 +8,8 @@ discard block |
||
| 8 | 8 | |
| 9 | 9 | require 'config.php'; |
| 10 | 10 | |
| 11 | -define ('VERSION', '1.1.3'); |
|
| 12 | -define ('DB', 'db'); |
|
| 11 | +define('VERSION', '1.1.3'); |
|
| 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 | } |