| @@ 7-58 (lines=52) @@ | ||
| 4 | ||
| 5 | use Rudolf\Framework\Model\FrontModel; |
|
| 6 | ||
| 7 | abstract class Model extends FrontModel |
|
| 8 | { |
|
| 9 | /** |
|
| 10 | * Returns part of query. |
|
| 11 | * |
|
| 12 | * @param string $part |
|
| 13 | * |
|
| 14 | * @return string |
|
| 15 | */ |
|
| 16 | protected function queryPart($part) |
|
| 17 | { |
|
| 18 | switch ($part) { |
|
| 19 | case 'full': |
|
| 20 | return " |
|
| 21 | SELECT album.id, |
|
| 22 | album.category_ID, |
|
| 23 | album.title, |
|
| 24 | album.author, |
|
| 25 | album.date, |
|
| 26 | album.added, |
|
| 27 | album.modified, |
|
| 28 | album.adder_ID, |
|
| 29 | album.modifier_ID, |
|
| 30 | album.views, |
|
| 31 | album.slug, |
|
| 32 | album.album, |
|
| 33 | album.thumb, |
|
| 34 | album.photos, |
|
| 35 | album.published, |
|
| 36 | adder.nick AS adder_nick, |
|
| 37 | adder.first_name AS adder_first_name, |
|
| 38 | adder.surname AS adder_surname, |
|
| 39 | adder.email AS adder_email, |
|
| 40 | modifier.nick AS adder_nick, |
|
| 41 | modifier.first_name AS modifier_first_name, |
|
| 42 | modifier.surname AS modifier_surname, |
|
| 43 | modifier.email AS modifier_email, |
|
| 44 | category.title AS category_title, |
|
| 45 | category.slug AS category_url |
|
| 46 | FROM {$this->prefix}albums AS album |
|
| 47 | LEFT JOIN {$this->prefix}users AS adder ON album.adder_ID = adder.id |
|
| 48 | LEFT JOIN {$this->prefix}users AS modifier ON album.modifier_ID = modifier.id |
|
| 49 | LEFT JOIN {$this->prefix}categories AS category ON album.category_ID = category.id |
|
| 50 | "; |
|
| 51 | break; |
|
| 52 | ||
| 53 | default: |
|
| 54 | return "SELECT * FROM {$this->prefix}albums "; |
|
| 55 | break; |
|
| 56 | } |
|
| 57 | } |
|
| 58 | } |
|
| 59 | ||
| @@ 7-62 (lines=56) @@ | ||
| 4 | ||
| 5 | use Rudolf\Framework\Model\FrontModel; |
|
| 6 | ||
| 7 | abstract class Model extends FrontModel |
|
| 8 | { |
|
| 9 | /** |
|
| 10 | * Returns part of query. |
|
| 11 | * |
|
| 12 | * @param string $part |
|
| 13 | * |
|
| 14 | * @return string |
|
| 15 | */ |
|
| 16 | protected function queryPart($part) |
|
| 17 | { |
|
| 18 | switch ($part) { |
|
| 19 | case 'full': |
|
| 20 | return " |
|
| 21 | SELECT article.id, |
|
| 22 | article.category_ID, |
|
| 23 | article.title, |
|
| 24 | article.keywords, |
|
| 25 | article.description, |
|
| 26 | article.content, |
|
| 27 | article.author, |
|
| 28 | article.date, |
|
| 29 | article.added, |
|
| 30 | article.modified, |
|
| 31 | article.adder_ID, |
|
| 32 | article.modifier_ID, |
|
| 33 | article.views, |
|
| 34 | article.slug, |
|
| 35 | article.album, |
|
| 36 | article.thumb, |
|
| 37 | article.photos, |
|
| 38 | article.homepage_hidden, |
|
| 39 | article.published, |
|
| 40 | adder.nick AS adder_nick, |
|
| 41 | adder.first_name AS adder_first_name, |
|
| 42 | adder.surname AS adder_surname, |
|
| 43 | adder.email AS adder_email, |
|
| 44 | modifier.nick AS adder_nick, |
|
| 45 | modifier.first_name AS modifier_first_name, |
|
| 46 | modifier.surname AS modifier_surname, |
|
| 47 | modifier.email AS modifier_email, |
|
| 48 | category.title AS category_title, |
|
| 49 | category.slug AS category_url |
|
| 50 | FROM {$this->prefix}articles AS article |
|
| 51 | LEFT JOIN {$this->prefix}users AS adder ON article.adder_ID = adder.id |
|
| 52 | LEFT JOIN {$this->prefix}users AS modifier ON article.modifier_ID = modifier.id |
|
| 53 | LEFT JOIN {$this->prefix}categories AS category ON article.category_ID = category.id |
|
| 54 | "; |
|
| 55 | break; |
|
| 56 | ||
| 57 | default: |
|
| 58 | return "SELECT * FROM {$this->prefix}articles "; |
|
| 59 | break; |
|
| 60 | } |
|
| 61 | } |
|
| 62 | } |
|
| 63 | ||