WhereQueryParser::prepareArrayForWhere() - Code Metrics - CruzerSoftwares/Dolphin - Measure and Improve Code Quality continuously with Scrutinizer

WhereQueryParser::prepareArrayForWhere() A
last analyzed 2019-12-29 19:16 UTC

↳ Parent: WhereQueryParser

Complexity

Conditions	5
Paths	8

Size

Total Lines	17
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	0

Metric	Value
cc	5
eloc	8
c	2
b	1
f	0
nc	8
nop	3
dl	0
loc	17
rs	9.6111

<?php
/**
 * The Query builder API.
 *
 * @author RN Kushwaha <[email protected]>
 * @since v0.0.1 <Date: 16th April, 2019>
 */

namespace Dolphin\Parsers;
/**
 * This class provides the mechanism to build the Where Queries.
 */
class WhereQueryParser
{

    protected function prepareArrayForWhere($bindKey, $bindVal = null, $mainAr = []){
        $ar = $conditionAr = [];
        // expecting a string like 'status = :status'
        if ($this->checkWherePrepareUsed($bindKey)) {
            $conditionAr = preg_split('/:/', $bindKey);
        }

        // taking the second part just after :
        if (is_array($conditionAr) && count($conditionAr)) {
            $ar[':'.$conditionAr[1]] = $bindVal;
        }

        if (count($ar)) {
            $mainAr = array_merge($mainAr, $ar);
        }

        return $mainAr;
    }

    public function parseWhereQuery($whereQuery = [])
    {
        $ar = [];
        if(!count($whereQuery)){
          return $ar;
        }

        foreach ($whereQuery as $where) {
            if (is_array($where[1])) {
                foreach ($where[1] as $key => $value) {
                    $ar[':'.$key] = $value;
                }
            } elseif ($where[1] != '') {
                $ar = $this->prepareArrayForWhere($where[0], $where[1], $ar);
            }
        }

        return $ar;
    }

    public function checkWherePrepareUsed($condition)
    {
        return preg_match('/:+[a-zA-Z_]/', $condition);
    }
}


1			<?php
2			/**
3			* The Query builder API.
4			*
5			* @author RN Kushwaha <[email protected]>
6			* @since v0.0.1 <Date: 16th April, 2019>
7			*/
8
9			namespace Dolphin\Parsers;
10			/**
11			* This class provides the mechanism to build the Where Queries.
12			*/
13			class WhereQueryParser
14			{
15
16			protected function prepareArrayForWhere($bindKey, $bindVal = null, $mainAr = []){
17			$ar = $conditionAr = [];
18			// expecting a string like 'status = :status'
19			if ($this->checkWherePrepareUsed($bindKey)) {
20			$conditionAr = preg_split('/:/', $bindKey);
21			}
22
23			// taking the second part just after :
24			if (is_array($conditionAr) && count($conditionAr)) {
25			$ar[':'.$conditionAr[1]] = $bindVal;
26			}
27
28			if (count($ar)) {
29			$mainAr = array_merge($mainAr, $ar);
30			}
31
32			return $mainAr;
33			}
34
35			public function parseWhereQuery($whereQuery = [])
36			{
37			$ar = [];
38			if(!count($whereQuery)){
39			return $ar;
40			}
41
42			foreach ($whereQuery as $where) {
43			if (is_array($where[1])) {
44			foreach ($where[1] as $key => $value) {
45			$ar[':'.$key] = $value;
46			}
47			} elseif ($where[1] != '') {
48			$ar = $this->prepareArrayForWhere($where[0], $where[1], $ar);
49			}
50			}
51
52			return $ar;
53			}
54
55			public function checkWherePrepareUsed($condition)
56			{
57			return preg_match('/:+[a-zA-Z_]/', $condition);
58			}
59			}
60

CruzerSoftwares / Dolphin

WhereQueryParser::prepareArrayForWhere() A last analyzed 2019-12-29 19:16 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

WhereQueryParser::prepareArrayForWhere() A
last analyzed 2019-12-29 19:16 UTC