Code Duplication    Length = 52-56 lines in 2 locations

src/module/Albums/Model.php 1 location

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

src/module/Articles/Model.php 1 location

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