ModelAccountDownload::getDownloads() - Code Metrics - Nickbur/Sunrise-CMS - Measure and Improve Code Quality continuously with Scrutinizer

ModelAccountDownload::getDownloads() A
last analyzed 2019-09-02 14:26 UTC

↳ Parent: ModelAccountDownload

Complexity

Conditions	5
Paths	16

Size

Total Lines	36
Code Lines	23

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	5
eloc	23
c	0
b	0
f	0
nc	16
nop	2
dl	0
loc	36
rs	9.2408

<?php

/* 	Divine CMS - Open source CMS for widespread use.
    Copyright (c) 2019 Mykola Burakov ([email protected])

    See SOURCE.txt for other and additional information.

    This file is part of Divine CMS.

    This program is free software: you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program. If not, see <http://www.gnu.org/licenses/>. */

class ModelAccountDownload extends \Divine\Engine\Core\Model
namespace YourVendor;

class YourClass { }
{
    public function getDownload($download_id)

    {
        $implode = array();

        $order_statuses = $this->config->get('config_complete_status');

        foreach ($order_statuses as $order_status_id) {
            $implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
        }

        if ($implode) {
            $query = $this->db->query("
                SELECT d.filename, d.mask 
                FROM `order` o 
				LEFT JOIN order_product op ON (o.order_id = op.order_id) 
				LEFT JOIN product_to_download p2d ON (op.product_id = p2d.product_id) 
				LEFT JOIN download d ON (p2d.download_id = d.download_id) 
				WHERE o.customer_id = '" . (int)$this->customer->getId() . "' 
				    AND (" . implode(" OR ", $implode) . ") 
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				    AND d.download_id = '" . (int)$download_id . "'
			");

            return $query->row;
        } else {
            return;
        }
    }

    public function getDownloads($start = 0, $limit = 20)
    {
        if ($start < 0) {
            $start = 0;
        }

        if ($limit < 1) {
            $limit = 20;
        }

        $implode = array();

        $order_statuses = $this->config->get('config_complete_status');

        foreach ($order_statuses as $order_status_id) {
            $implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
        }

        if ($implode) {
            $query = $this->db->query(
                "
				SELECT DISTINCT d.download_id, o.order_id, o.date_added, dd.name, d.filename FROM `order` o 
				LEFT JOIN order_product op ON (o.order_id = op.order_id) 
				LEFT JOIN product_to_download p2d ON (op.product_id = p2d.product_id) 
				LEFT JOIN download d ON (p2d.download_id = d.download_id) 
				LEFT JOIN download_description dd ON (d.download_id = dd.download_id) 
				WHERE o.customer_id = '" . (int)$this->customer->getId() . "' 
				    AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "' 
				    AND (" . implode(" OR ", $implode) . ") 
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				ORDER BY o.date_added DESC 
				LIMIT " . (int)$start . "," . (int)$limit
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            );

            return $query->rows;
        } else {
            return array();
        }
    }

    public function getTotalDownloads()
    {
        $implode = array();

        $order_statuses = $this->config->get('config_complete_status');

        foreach ($order_statuses as $order_status_id) {
            $implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
        }

        if ($implode) {
            $query = $this->db->query("
                SELECT COUNT(*) AS total 
                FROM `order` o 
				LEFT JOIN order_product op ON (o.order_id = op.order_id) 
				LEFT JOIN product_to_download p2d ON (op.product_id = p2d.product_id) 
				WHERE o.customer_id = '" . (int)$this->customer->getId() . "' 
				    AND (" . implode(" OR ", $implode) . ")
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			");

            return $query->row['total'];
        } else {
            return 0;
        }
    }
}


1			<?php
2
3			/* Divine CMS - Open source CMS for widespread use.
4			Copyright (c) 2019 Mykola Burakov ([email protected])
5
6			See SOURCE.txt for other and additional information.
7
8			This file is part of Divine CMS.
9
10			This program is free software: you can redistribute it and/or modify
11			it under the terms of the GNU General Public License as published by
12			the Free Software Foundation, either version 3 of the License, or
13			(at your option) any later version.
14
15			This program is distributed in the hope that it will be useful,
16			but WITHOUT ANY WARRANTY; without even the implied warranty of
17			MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18			GNU General Public License for more details.
19
20			You should have received a copy of the GNU General Public License
21			along with this program. If not, see <http://www.gnu.org/licenses/>. */
22
23			class ModelAccountDownload extends \Divine\Engine\Core\Model
			0 ignored issues – show Coding Style Compatibility introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions. You can fix this by adding a namespace to your class: namespace YourVendor; class YourClass { } When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries. Loading history...
24			{
25			public function getDownload($download_id)
			0 ignored issues – show Coding Style introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report Expected 2 blank lines before function; 0 found Loading history...
26			{
27			$implode = array();
28
29			$order_statuses = $this->config->get('config_complete_status');
30
31			foreach ($order_statuses as $order_status_id) {
32			$implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
33			}
34
35			if ($implode) {
36			$query = $this->db->query("
37			SELECT d.filename, d.mask
38			FROM `order` o
39			LEFT JOIN order_product op ON (o.order_id = op.order_id)
40			LEFT JOIN product_to_download p2d ON (op.product_id = p2d.product_id)
41			LEFT JOIN download d ON (p2d.download_id = d.download_id)
42			WHERE o.customer_id = '" . (int)$this->customer->getId() . "'
43			AND (" . implode(" OR ", $implode) . ")
			0 ignored issues – show Coding Style Comprehensibility introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report The string literal `OR` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
44			AND d.download_id = '" . (int)$download_id . "'
45			");
46
47			return $query->row;
48			} else {
49			return;
50			}
51			}
52
53			public function getDownloads($start = 0, $limit = 20)
54			{
55			if ($start < 0) {
56			$start = 0;
57			}
58
59			if ($limit < 1) {
60			$limit = 20;
61			}
62
63			$implode = array();
64
65			$order_statuses = $this->config->get('config_complete_status');
66
67			foreach ($order_statuses as $order_status_id) {
68			$implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
69			}
70
71			if ($implode) {
72			$query = $this->db->query(
73			"
74			SELECT DISTINCT d.download_id, o.order_id, o.date_added, dd.name, d.filename FROM `order` o
75			LEFT JOIN order_product op ON (o.order_id = op.order_id)
76			LEFT JOIN product_to_download p2d ON (op.product_id = p2d.product_id)
77			LEFT JOIN download d ON (p2d.download_id = d.download_id)
78			LEFT JOIN download_description dd ON (d.download_id = dd.download_id)
79			WHERE o.customer_id = '" . (int)$this->customer->getId() . "'
80			AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "'
81			AND (" . implode(" OR ", $implode) . ")
			0 ignored issues – show Coding Style Comprehensibility introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report The string literal `OR` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history... Coding Style Comprehensibility introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report The string literal `) \n ORDE...n LIMIT` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
82			ORDER BY o.date_added DESC
83			LIMIT " . (int)$start . "," . (int)$limit
			0 ignored issues – show Coding Style Comprehensibility introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report The string literal `,` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
84			);
85
86			return $query->rows;
87			} else {
88			return array();
89			}
90			}
91
92			public function getTotalDownloads()
93			{
94			$implode = array();
95
96			$order_statuses = $this->config->get('config_complete_status');
97
98			foreach ($order_statuses as $order_status_id) {
99			$implode[] = "o.order_status_id = '" . (int)$order_status_id . "'";
100			}
101
102			if ($implode) {
103			$query = $this->db->query("
104			SELECT COUNT(*) AS total
105			FROM `order` o
106			LEFT JOIN order_product op ON (o.order_id = op.order_id)
107			LEFT JOIN product_to_download p2d ON (op.product_id = p2d.product_id)
108			WHERE o.customer_id = '" . (int)$this->customer->getId() . "'
109			AND (" . implode(" OR ", $implode) . ")
			0 ignored issues – show Coding Style Comprehensibility introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report The string literal `OR` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history... Coding Style Comprehensibility introduced 2019-07-29 15:05 UTC by Report Bug Copy Issue Report The string literal `)\n` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
110			");
111
112			return $query->row['total'];
113			} else {
114			return 0;
115			}
116			}
117			}
118

Nickbur / Sunrise-CMS

ModelAccountDownload::getDownloads() A last analyzed 2019-09-02 14:26 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

ModelAccountDownload::getDownloads() A
last analyzed 2019-09-02 14:26 UTC