@@ 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 |