Filter::addToSQLString() - Code Metrics - Inspection of "Make PSR-4 compliant" - BurningFlipside/CommonCode - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( ed6c74...ceecfe )

by Patrick

created 2020-06-15 01:11 UTC

Filter::addToSQLString() A

↳ Parent: Filter

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
nc	1
nop	1
dl	0
loc	4
rs	10
c	0
b	0
f	0

<?php
namespace Flipside\Data;

class Filter
{
    protected $children = array();
    protected $string;
    protected $sqlAppend = '';

    /**
     * Creates a new filter object
     *
     * @param false|string $string The string to create the filter from or false for an empty filter
     */
    public function __construct($string = false)
    {
        if($string !== false)
        {
            $this->string = $string;
            $this->children = self::process_string($this->string);
        }
    }

    static public function process_string($string)
    {
        $parens = false;
        //First check for parenthesis...
        if($string[0] === '(' && substr($string, -1) === ')')
        {
            $string = substr($string, 1, strlen($string) - 2);
            $parens = true;
        }
        if(preg_match('/(.+?)( and | or )(.+)/', $string, $clauses) === 0)
        {
            return array(new FilterClause($string));
        }
        $children = array();
        if($parens)
        {
            array_push($children, '(');
        }
        $children = array_merge($children, self::process_string($clauses[1]));
        array_push($children, trim($clauses[2]));
        $children = array_merge($children, self::process_string($clauses[3]));
        if($parens)
        {
            array_push($children, ')');
        }
        return $children;
    }

    public function to_sql_string()
    {
        $ret = '';
        $count = count($this->children);
        for($i = 0; $i < $count; $i++)
        {
            if($this->children[$i] === '(' || $this->children[$i] === ')')
            {
                $ret .= $this->children[$i];
            }
            else if($this->children[$i] === 'and')
            {
                $ret .= ' AND ';
            }
            else if($this->children[$i] === 'or')
            {
                $ret .= ' OR ';
            }
            else
            {
                $ret .= $this->children[$i]->to_sql_string();
            }
        }
        return $ret.$this->sqlAppend;
    }

    public function to_ldap_string()
    {
        $ret = '';
        $count = count($this->children);
        $prefix = '';
        for($i = 0; $i < $count; $i++)
        {
            if($this->children[$i] === 'and')
            {
                if($prefix == '|')
                {
                    throw new \Exception('Do not support both and or');
                }
                $prefix = '&';
            }
            else if($this->children[$i] === 'or')
            {
                if($prefix == '&')
                {
                    throw new \Exception('Do not support both and or');
                }
                $prefix = '|';
            }
            else
            {
                $ret .= $this->children[$i]->to_ldap_string();
            }
        }
        if($count === 1 && $prefix === '')
        {
            return $ret;
        }
        return '('.$prefix.$ret.')';
    }

    public function to_mongo_filter()
    {
        $ret = array();
        $count = count($this->children);
        for($i = 0; $i < $count; $i++)
        {
            if($this->children[$i] === 'and')
            {
                $old = array_pop($ret);
                array_push($ret, array('$and'=>array($old, $this->children[++$i]->toMongoFilter())));
            }
            else if($this->children[$i] === 'or')
            {
                $old = array_pop($ret);
                array_push($ret, array('$or'=>array($old, $this->children[++$i]->toMongoFilter())));
            }
            else
            {
                array_push($ret, $this->children[$i]->toMongoFilter());
            }
        }
        if(count($ret) == 1 && is_array($ret[0]))
        {
            return $ret[0];
        }
        return $ret;
    }

    public function filterElement($element)
    {
        $res = array();
        $count = count($this->children);
	for($i = 0; $i < $count; $i++)
	{
            if($this->children[$i] === 'and' || $this->children[$i] === 'or')
	    {
                array_push($res, $this->children[$i]);
	    }
	    else
	    {
                $tmp = $this->children[$i]->php_compare($element);
		array_push($res, $tmp);
	    }
	}
	if($count === 1)
	{
            return $res[0];
	}
	while($count >= 3)
	{
	    if($res[1] === 'and')
            {
                $var1 = array_shift($res);
                array_shift($res);
                $var2 = array_shift($res);
	        $res = array_merge(array($var1 && $var2), $res);
            }
	    else if($res[1] === 'or')
            {
                $var1 = array_shift($res);
                array_shift($res);
                $var2 = array_shift($res);
                $res = array_merge(array($var1 || $var2), $res);
	    }
	    $count = count($res);
	}
        return $res[0];
    }

    public function filter_array(&$array)
    {
        if(is_array($array))
	{
            $res = array_filter($array, array($this, 'filterElement'));
            return array_values($res);
        }
        return array();
    }

    public function contains($substr)
    {
        return strstr($this->string, $substr) !== false;
    }

    public function getClause($substr)
    {
        $count = count($this->children);
        for($i = 0; $i < $count; $i++)
        {
            if(!is_object($this->children[$i]))
            {
                continue;
            }
            if(strstr($this->children[$i]->var1, $substr) !== false ||
               strstr($this->children[$i]->var2, $substr) !== false)
            {
                return $this->children[$i];
            }
        }
    }

    public function addToSQLString($string)
    {
        $this->sqlAppend .= $string;
    }

    public function appendChild($child)
    {
        if($child === 'and' || $child === 'or')
        {
            array_push($this->children, $child);
            return;
        }
        else if(is_a($child, '\Data\Filter'))
        {
            $this->children = array_merge($this->children, $child->children);
        }
        else
        {
            $this->children = array_merge($this->children, self::process_string($child));
        }
    }

    public function getChildren()
    {
        return $this->children;
    }
}


1			<?php
2			namespace Flipside\Data;
3
4			class Filter
5			{
6			protected $children = array();
7			protected $string;
8			protected $sqlAppend = '';
9
10			/**
11			* Creates a new filter object
12			*
13			* @param false\|string $string The string to create the filter from or false for an empty filter
14			*/
15			public function __construct($string = false)
16			{
17			if($string !== false)
18			{
19			$this->string = $string;
20			$this->children = self::process_string($this->string);
21			}
22			}
23
24			static public function process_string($string)
25			{
26			$parens = false;
27			//First check for parenthesis...
28			if($string[0] === '(' && substr($string, -1) === ')')
29			{
30			$string = substr($string, 1, strlen($string) - 2);
31			$parens = true;
32			}
33			if(preg_match('/(.+?)( and \| or )(.+)/', $string, $clauses) === 0)
34			{
35			return array(new FilterClause($string));
36			}
37			$children = array();
38			if($parens)
39			{
40			array_push($children, '(');
41			}
42			$children = array_merge($children, self::process_string($clauses[1]));
43			array_push($children, trim($clauses[2]));
44			$children = array_merge($children, self::process_string($clauses[3]));
45			if($parens)
46			{
47			array_push($children, ')');
48			}
49			return $children;
50			}
51
52			public function to_sql_string()
53			{
54			$ret = '';
55			$count = count($this->children);
56			for($i = 0; $i < $count; $i++)
57			{
58			if($this->children[$i] === '(' \|\| $this->children[$i] === ')')
59			{
60			$ret .= $this->children[$i];
61			}
62			else if($this->children[$i] === 'and')
63			{
64			$ret .= ' AND ';
65			}
66			else if($this->children[$i] === 'or')
67			{
68			$ret .= ' OR ';
69			}
70			else
71			{
72			$ret .= $this->children[$i]->to_sql_string();
73			}
74			}
75			return $ret.$this->sqlAppend;
76			}
77
78			public function to_ldap_string()
79			{
80			$ret = '';
81			$count = count($this->children);
82			$prefix = '';
83			for($i = 0; $i < $count; $i++)
84			{
85			if($this->children[$i] === 'and')
86			{
87			if($prefix == '\|')
88			{
89			throw new \Exception('Do not support both and or');
90			}
91			$prefix = '&';
92			}
93			else if($this->children[$i] === 'or')
94			{
95			if($prefix == '&')
96			{
97			throw new \Exception('Do not support both and or');
98			}
99			$prefix = '\|';
100			}
101			else
102			{
103			$ret .= $this->children[$i]->to_ldap_string();
104			}
105			}
106			if($count === 1 && $prefix === '')
107			{
108			return $ret;
109			}
110			return '('.$prefix.$ret.')';
111			}
112
113			public function to_mongo_filter()
114			{
115			$ret = array();
116			$count = count($this->children);
117			for($i = 0; $i < $count; $i++)
118			{
119			if($this->children[$i] === 'and')
120			{
121			$old = array_pop($ret);
122			array_push($ret, array('$and'=>array($old, $this->children[++$i]->toMongoFilter())));
123			}
124			else if($this->children[$i] === 'or')
125			{
126			$old = array_pop($ret);
127			array_push($ret, array('$or'=>array($old, $this->children[++$i]->toMongoFilter())));
128			}
129			else
130			{
131			array_push($ret, $this->children[$i]->toMongoFilter());
132			}
133			}
134			if(count($ret) == 1 && is_array($ret[0]))
135			{
136			return $ret[0];
137			}
138			return $ret;
139			}
140
141			public function filterElement($element)
142			{
143			$res = array();
144			$count = count($this->children);
145			for($i = 0; $i < $count; $i++)
146			{
147			if($this->children[$i] === 'and' \|\| $this->children[$i] === 'or')
148			{
149			array_push($res, $this->children[$i]);
150			}
151			else
152			{
153			$tmp = $this->children[$i]->php_compare($element);
154			array_push($res, $tmp);
155			}
156			}
157			if($count === 1)
158			{
159			return $res[0];
160			}
161			while($count >= 3)
162			{
163			if($res[1] === 'and')
164			{
165			$var1 = array_shift($res);
166			array_shift($res);
167			$var2 = array_shift($res);
168			$res = array_merge(array($var1 && $var2), $res);
169			}
170			else if($res[1] === 'or')
171			{
172			$var1 = array_shift($res);
173			array_shift($res);
174			$var2 = array_shift($res);
175			$res = array_merge(array($var1 \|\| $var2), $res);
176			}
177			$count = count($res);
178			}
179			return $res[0];
180			}
181
182			public function filter_array(&$array)
183			{
184			if(is_array($array))
185			{
186			$res = array_filter($array, array($this, 'filterElement'));
187			return array_values($res);
188			}
189			return array();
190			}
191
192			public function contains($substr)
193			{
194			return strstr($this->string, $substr) !== false;
195			}
196
197			public function getClause($substr)
198			{
199			$count = count($this->children);
200			for($i = 0; $i < $count; $i++)
201			{
202			if(!is_object($this->children[$i]))
203			{
204			continue;
205			}
206			if(strstr($this->children[$i]->var1, $substr) !== false \|\|
207			strstr($this->children[$i]->var2, $substr) !== false)
208			{
209			return $this->children[$i];
210			}
211			}
212			}
213
214			public function addToSQLString($string)
215			{
216			$this->sqlAppend .= $string;
217			}
218
219			public function appendChild($child)
220			{
221			if($child === 'and' \|\| $child === 'or')
222			{
223			array_push($this->children, $child);
224			return;
225			}
226			else if(is_a($child, '\Data\Filter'))
227			{
228			$this->children = array_merge($this->children, $child->children);
229			}
230			else
231			{
232			$this->children = array_merge($this->children, self::process_string($child));
233			}
234			}
235
236			public function getChildren()
237			{
238			return $this->children;
239			}
240			}
241

BurningFlipside / CommonCode

Push — develop ( ed6c74...ceecfe )

Filter::addToSQLString() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like