Conditions::_parts() - Code Metrics - csphere-cms/cSphere - Measure and Improve Code Quality continuously with Scrutinizer

Conditions::_parts() B
last analyzed 2017-04-21 16:53 UTC

↳ Parent: Conditions

Complexity

Conditions	6
Paths	5

Size

Total Lines	54
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	6
eloc	25
nc	5
nop	3
dl	0
loc	54
rs	8.7449
c	0
b	0
f	0

How to fix Long Method

<?php

/**
 * Parses conditions for where and having clauses
 *
 * PHP Version 5
 *
 * @category  Core
 * @package   SQL
 * @author    Hans-Joachim Piepereit <[email protected]>
 * @copyright 2013 cSphere Team
 * @license   http://opensource.org/licenses/bsd-license Simplified BSD License
 * @link      http://www.csphere.eu
 **/

namespace csphere\core\sql;

/**
 * Parses conditions for where and having clauses
 *
 * @category  Core
 * @package   SQL
 * @author    Hans-Joachim Piepereit <[email protected]>
 * @copyright 2013 cSphere Team
 * @license   http://opensource.org/licenses/bsd-license Simplified BSD License
 * @link      http://www.csphere.eu
 **/

abstract class Conditions
{
    /**
     * Supported operators for conditions
     **/
    private static $_operators = ['=', '!=', '>', '<', '<>', '>=', '<='];

    /**
     * Generate conditional parts of queries
     *
     * @param array   $conditions Conditions with column, operation and value
     * @param boolean $having     This defines if having or where parts are parsed
     *
     * @return array
     **/


    public static function parse(array $conditions, $having = false)
    {
        $assoc = [];
        $short = ($having === true) ? 'hav' : 'con';
        $query = '';

        // Check if array dimensions are fine
        if (isset($conditions[0]) && !is_array($conditions[0])) {

            $conditions = [$conditions];
        }

        foreach ($conditions AS $num => $con) {

            // Process condition parts
            $sub = self::_parts($short, $num, (array)$con);

            // Append operator and add part to result
            $query .= self::_append($sub['query'], $num, (array)$con);

            $assoc = array_merge($assoc, $sub['assoc']);
        }

        $result = ['query' => $query, 'assoc' => $assoc];

        return $result;
    }

    /**
     * Generate part of a single condition
     *
     * @param string  $short Shorthandle for assoc array keys, e.g. con
     * @param integer $num   Number of condition as an integer
     * @param array   $con   Condition details as an array
     *
     * @return array
     **/


    private static function _parts($short, $num, array $con)
    {
        $key   = 0;
        $assoc = [];
        $query = '';

        // Bind must be unique per query condition
        $bind = $short . $num;

        // Append simple oerator checks
        if (in_array($con[1], self::$_operators)) {

            $query .= $con[0] . ' ' . $con[1] . ' :' . $bind;

            $assoc[$bind] = $con[2];

        } elseif ($con[1] == 'like') {

            // Append like comparisons
            $query .= $con[0] . ' LIKE :' . $bind;

            $assoc[$bind] = $con[2];

        } elseif ($con[1] == 'between') {

            // Append between checks
            $query .= $con[0] . ' BETWEEN :' . $bind
                    . 'b1 AND :' . $bind . 'b2';

            $assoc[$bind . 'b1'] = $con[2][0];
            $assoc[$bind . 'b2'] = $con[2][1];

        } elseif ($con[1] == 'in') {

            // Append in array checks
            $query .= $con[0] . ' IN (';

            foreach ($con[2] AS $val) {

                $query .= ':' . $bind . 'i' . $key . ', ';

                $assoc[$bind . 'i' . $key] = $val;

                $key++;
            }

            $query = substr($query, 0, -2) . ')';
        }

        // Create result array
        $result = ['query' => $query, 'assoc' => $assoc];

        return $result;
    }

    /**
     * Append operators to conditions
     *
     * @param string  $query Query string
     * @param integer $num   Number of condition as an integer
     * @param array   $con   Condition details as an array
     *
     * @return string
     **/


    private static function _append($query, $num, array $con)
    {
        // Prepend with NOT if set
        if (isset($con[3]) && $con[3] == true) {

            $query = 'NOT ' . $query;
        }

        // Prepend with AND or OR if not first
        if ($num != 0) {

            $pre = ' AND ';

            if (isset($con[4]) && $con[4] == true) {

                $pre = ' OR ';
            }

            $query = $pre . $query;
        }

        return $query;
    }
}


1			<?php
2
3			/**
4			* Parses conditions for where and having clauses
5			*
6			* PHP Version 5
7			*
8			* @category Core
9			* @package SQL
10			* @author Hans-Joachim Piepereit <[email protected]>
11			* @copyright 2013 cSphere Team
12			* @license http://opensource.org/licenses/bsd-license Simplified BSD License
13			* @link http://www.csphere.eu
14			**/
15
16			namespace csphere\core\sql;
17
18			/**
19			* Parses conditions for where and having clauses
20			*
21			* @category Core
22			* @package SQL
23			* @author Hans-Joachim Piepereit <[email protected]>
24			* @copyright 2013 cSphere Team
25			* @license http://opensource.org/licenses/bsd-license Simplified BSD License
26			* @link http://www.csphere.eu
27			**/
28
29			abstract class Conditions
30			{
31			/**
32			* Supported operators for conditions
33			**/
34			private static $_operators = ['=', '!=', '>', '<', '<>', '>=', '<='];
35
36			/**
37			* Generate conditional parts of queries
38			*
39			* @param array $conditions Conditions with column, operation and value
40			* @param boolean $having This defines if having or where parts are parsed
41			*
42			* @return array
43			**/
			0 ignored issues – show Coding Style introduced 2017-04-21 16:53 UTC by Report Bug Copy Issue Report There must be no blank lines after the function comment Loading history...
44
45			public static function parse(array $conditions, $having = false)
46			{
47			$assoc = [];
48			$short = ($having === true) ? 'hav' : 'con';
49			$query = '';
50
51			// Check if array dimensions are fine
52			if (isset($conditions[0]) && !is_array($conditions[0])) {
53
54			$conditions = [$conditions];
55			}
56
57			foreach ($conditions AS $num => $con) {
58
59			// Process condition parts
60			$sub = self::_parts($short, $num, (array)$con);
61
62			// Append operator and add part to result
63			$query .= self::_append($sub['query'], $num, (array)$con);
64
65			$assoc = array_merge($assoc, $sub['assoc']);
66			}
67
68			$result = ['query' => $query, 'assoc' => $assoc];
69
70			return $result;
71			}
72
73			/**
74			* Generate part of a single condition
75			*
76			* @param string $short Shorthandle for assoc array keys, e.g. con
77			* @param integer $num Number of condition as an integer
78			* @param array $con Condition details as an array
79			*
80			* @return array
81			**/
			0 ignored issues – show Coding Style introduced 2017-04-21 16:53 UTC by Report Bug Copy Issue Report There must be no blank lines after the function comment Loading history...
82
83			private static function _parts($short, $num, array $con)
84			{
85			$key = 0;
86			$assoc = [];
87			$query = '';
88
89			// Bind must be unique per query condition
90			$bind = $short . $num;
91
92			// Append simple oerator checks
93			if (in_array($con[1], self::$_operators)) {
94
95			$query .= $con[0] . ' ' . $con[1] . ' :' . $bind;
96
97			$assoc[$bind] = $con[2];
98
99			} elseif ($con[1] == 'like') {
100
101			// Append like comparisons
102			$query .= $con[0] . ' LIKE :' . $bind;
103
104			$assoc[$bind] = $con[2];
105
106			} elseif ($con[1] == 'between') {
107
108			// Append between checks
109			$query .= $con[0] . ' BETWEEN :' . $bind
110			. 'b1 AND :' . $bind . 'b2';
111
112			$assoc[$bind . 'b1'] = $con[2][0];
113			$assoc[$bind . 'b2'] = $con[2][1];
114
115			} elseif ($con[1] == 'in') {
116
117			// Append in array checks
118			$query .= $con[0] . ' IN (';
119
120			foreach ($con[2] AS $val) {
121
122			$query .= ':' . $bind . 'i' . $key . ', ';
123
124			$assoc[$bind . 'i' . $key] = $val;
125
126			$key++;
127			}
128
129			$query = substr($query, 0, -2) . ')';
130			}
131
132			// Create result array
133			$result = ['query' => $query, 'assoc' => $assoc];
134
135			return $result;
136			}
137
138			/**
139			* Append operators to conditions
140			*
141			* @param string $query Query string
142			* @param integer $num Number of condition as an integer
143			* @param array $con Condition details as an array
144			*
145			* @return string
146			**/
			0 ignored issues – show Coding Style introduced 2017-04-21 16:53 UTC by Report Bug Copy Issue Report There must be no blank lines after the function comment Loading history...
147
148			private static function _append($query, $num, array $con)
149			{
150			// Prepend with NOT if set
151			if (isset($con[3]) && $con[3] == true) {
152
153			$query = 'NOT ' . $query;
154			}
155
156			// Prepend with AND or OR if not first
157			if ($num != 0) {
158
159			$pre = ' AND ';
160
161			if (isset($con[4]) && $con[4] == true) {
162
163			$pre = ' OR ';
164			}
165
166			$query = $pre . $query;
167			}
168
169			return $query;
170			}
171			}
172

csphere-cms / cSphere

Conditions::_parts() B last analyzed 2017-04-21 16:53 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like

Conditions::_parts() B
last analyzed 2017-04-21 16:53 UTC