QueryHelpers::dynamicQueryFilters() - Code Metrics - WillRy/querybuilder - Measure and Improve Code Quality continuously with Scrutinizer

QueryHelpers::dynamicQueryFilters() A
last analyzed 2023-10-04 22:35 UTC

↳ Parent: QueryHelpers

Complexity

Conditions	5
Paths	8

Size

Total Lines	20
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

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

<?php


namespace Willry\QueryBuilder;


class QueryHelpers
{


    public static function bind(\PDOStatement &$stmt, array $params = [])
    {
        $defaultType = \PDO::PARAM_STR;

        foreach ($params as $key => $value) {
            $type = $defaultType;

            if (is_int($value)) {
                $type = \PDO::PARAM_INT;
            }

            if (is_resource($value)) {
                $type = \PDO::PARAM_LOB;
            }

            if (is_bool($value)) {
                $type = \PDO::PARAM_BOOL;
            }

            $stmt->bindValue(
                is_string($key) ? $key : $key + 1,
                $value,
                $type
            );
        }
    }

    public static function dynamicQueryFilters(array &$queryParams, string $queryString, array $bind)
    {
        $queryParams["filters"][] = $queryString;
        $queryParams["binds"] = !empty($queryParams["binds"]) ? array_merge($queryParams["binds"], $bind) : $bind;

        $queryString = "";

        if (empty($queryParams["filters"])) return "";

        foreach ($queryParams["filters"] as $key => $filtro) {
            if ($key === 0) {
                $queryString .= $filtro;
            } else {
                $queryString .= " AND {$filtro}";
            }
        }

        $queryParams["queryString"] = $queryString;

        return $queryParams;
    }

}

1			<?php
2
3
4			namespace Willry\QueryBuilder;
5
6
7			class QueryHelpers
8			{
9
10
11			public static function bind(\PDOStatement &$stmt, array $params = [])
12			{
13			$defaultType = \PDO::PARAM_STR;
14
15			foreach ($params as $key => $value) {
16			$type = $defaultType;
17
18			if (is_int($value)) {
19			$type = \PDO::PARAM_INT;
20			}
21
22			if (is_resource($value)) {
23			$type = \PDO::PARAM_LOB;
24			}
25
26			if (is_bool($value)) {
27			$type = \PDO::PARAM_BOOL;
28			}
29
30			$stmt->bindValue(
31			is_string($key) ? $key : $key + 1,
32			$value,
33			$type
34			);
35			}
36			}
37
38			public static function dynamicQueryFilters(array &$queryParams, string $queryString, array $bind)
39			{
40			$queryParams["filters"][] = $queryString;
41			$queryParams["binds"] = !empty($queryParams["binds"]) ? array_merge($queryParams["binds"], $bind) : $bind;
42
43			$queryString = "";
44
45			if (empty($queryParams["filters"])) return "";
46
47			foreach ($queryParams["filters"] as $key => $filtro) {
48			if ($key === 0) {
49			$queryString .= $filtro;
50			} else {
51			$queryString .= " AND {$filtro}";
52			}
53			}
54
55			$queryParams["queryString"] = $queryString;
56
57			return $queryParams;
58			}
59
60			}

WillRy / querybuilder

QueryHelpers::dynamicQueryFilters() A last analyzed 2023-10-04 22:35 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

QueryHelpers::dynamicQueryFilters() A
last analyzed 2023-10-04 22:35 UTC