@@ -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(); |
@@ -47,6 +47,10 @@ |
||
| 47 | 47 | return Base::getEntryArrayWithBookNumber (self::SQL_ALL_TAGS, self::TAG_COLUMNS, array (), "Tag"); |
| 48 | 48 | } |
| 49 | 49 | |
| 50 | + /** |
|
| 51 | + * @param string $query |
|
| 52 | + * @param integer $numberPerPage |
|
| 53 | + */ |
|
| 50 | 54 | public static function getAllTagsByQuery($query, $n, $database = NULL, $numberPerPage = NULL) { |
| 51 | 55 | $columns = "tags.id as id, tags.name as name, (select count(*) from books_tags_link where tags.id = tag) as count"; |
| 52 | 56 | $sql = 'select {0} from tags where upper (tags.name) like ? {1} order by tags.name'; |