trait_setter::qOrder() - Code Metrics - Inspection of "traits changes" - webdivane/table - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — master (ea0496)

by Plamen

created 2019-03-30 08:51 UTC

trait_setter::qOrder() A

↳ Parent: trait_setter

Complexity

Conditions	2
Paths	2

Size

Total Lines	7
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	5
nc	2
nop	2
dl	0
loc	7
rs	10
c	0
b	0
f	0

<?php

trait trait_setter
{
    /** @param array Columns (config) */
    public static $cols;
    /** @param array Query result, allows altering before table::load() */
    public static $data = [];
    /** @param bool Export flag (for current request) */
    public static $export;
    /** @param bool Export is allowed (shows buttons in the tfoot) */
    public static $exportActive = true;
    /** @param bool Export data altered (use false for pure result) */
    public static $exportDataAsDisplayed = true;
    /** @param array Collector (values for current table call) */
    protected static $t = ['page' => 1, 'tables' => []];
    /** @param array Re-settable values for current table call */
    protected static $config = [
        'APP' => 'App',
        'DB_COLLATION_CI' => 'utf8mb4_general_ci', //UTF8_GENERAL_CI
        'EMPTY_TABLE_MSG' => 'No results found.',
        'EXPORT_FILE_NAME' => ':app - :items export (:datetime)',
        'FILTER_ACTIVE' => true,
        'FILTER_CASE_SENSITIVE' => false,
        'SAVES' => ['CSV', 'Excel'],
        'UTF8_ASC_SYMBOL' => '&#9650;',
        'UTF8_DESC_SYMBOL' => '&#9660;',
        'UTF8_LEFT_SYMBOL' => '&lsaquo;',
        'UTF8_RIGHT_SYMBOL' => '&rsaquo;'
    ];
    /** @param array Errors collector */
    protected static $errors = [];

    static function assets($path = "/public/table")
    {
        return "<script src=\"{$path}/table_helper.js\" defer></script>\n\t" .
                "<script src=\"{$path}/table.js\" defer></script>\n\t" .
                "<link href=\"{$path}/table.css\" rel=\"stylesheet\">\n";
    }

    /** Set/Get config value
     * @param mixed $c (string) Get if exists, (array) Set if valid
     * @return mixed */
    public static function config($c)
    {
        try {
            switch (gettype($c)) {
                case 'array';
                    foreach ($c as $k => $v) {
                        self::$config[$k] = self::getValid((string)$k, $v);
                    }
                    break;
                case 'string':
                    return self::getValid($c);
                default:
                    throw new Exception("Invalid value type.");
            }
        } catch (Exception $e) {
            self::err('ERROR: ' . $e->getMessage());
        }
    }

    private static function getValid($k, $v = null)
    {
        if (!array_key_exists($k, self::$config)) {
            throw new Exception('Request to undefined value: ' . $k);
        }

        if ($v !== null) {
            if (empty($v) || gettype($v) !== gettype(self::$config[$k])) {
                throw new Exception("Setting invalid value: $v (:$k)");
            }
        }

        return $v === null ? self::$config[$k] : $v;
    }

    /** Adds conditions, orderBy and Limits to query.
     * @param string $q
     * @param mixed $cond
     * @param array $order
     * @param mixed $limit -> 5 or [$start, $count]
     * @param bool $h Having flag - to use HAVING instead of WHERE
     * @return (string) */
    protected static function q($q, $cond = null, array $order = [], $limit = 0, $h = false)
    {
        //Condition: '' | ' (HAVING|WHERE|AND) ' . $cond
        self::qConditions($q, $cond, $h);

        //Order: '' | 'ORDER BY ' . array_keys($order)[0] . ' ' . $order[0]
        self::qOrder($q, $order);

        //Limit: '' | ' LIMIT ' . '(20, 40|20)'
        self::qLimit($q, $limit);

        return $q;
    }

    private static function qConditions(&$q, $cond, $h)
    {
        if (!empty($cond)) {
            $clause = !$h ? 'WHERE' : 'HAVING';
            $clue = !strpos($q, $clause) ? $clause : 'AND';
            $q .= (' ' . $clue . ' ' . $cond);
        }
    }

    private static function qOrder(&$q, $order)
    {
        if (!empty($order)) {
            $arr = array_map(function(&$v, $k) {
                return $k . ' ' . strtoupper($v);
            }, $order, array_keys($order));
            $q .= (' ORDER BY ' . implode(', ', $arr));
        }
    }

    private static function qLimit(&$q, $limit)
    {
        if (!empty($limit)) {
            $l = (is_array($limit) ? implode(', ', $limit) : $limit);
            $q .= (' LIMIT ' . $l);
        }
    }

    protected static function err($message = null)
    {
        if (isset($message)) {
            self::$errors[] = $message;
        } else {
            return empty(self::$errors) ? null :
                    '<p class="tbl-err">' . implode('</br>', self::$errors) . '</p>';
        }
    }

    /** Array to space separated key value list
     * @param array $attributes
     * @return string */
    protected static function attributes(array $attributes)
    {
        $list = [' '];
        foreach ($attributes as $key => $value) {
            if ($value === true || (empty($value) && $value != 0)) {
                $list[] = $key;
            } else {
                $list[] = $key . '="' . $value . '"';
            }
        }
        return rtrim(implode(' ', $list));
    }

    /** Parses view to string
     * @param string $template
     * @param array $vars
     * @return string */
    protected static function view($template, $vars = [])
    {
        extract($vars);
        ob_start();
        require $template;
        return (string)ob_get_clean();
    }

    /** Needed for more than one table on page
     * @param string $items */
    protected static function reset($items)
    {
        if (!in_array($items, self::$t["tables"])) {
            self::$t["tables"][] = $items;
            self::$cols = [];
            self::$t['rows'] = null;
        } else {
            echo 'Existing table-id used in table::create(): ' . $items;
        }
    }
}


1			<?php
2
3			trait trait_setter
4			{
5			/** @param array Columns (config) */
6			public static $cols;
7			/** @param array Query result, allows altering before table::load() */
8			public static $data = [];
9			/** @param bool Export flag (for current request) */
10			public static $export;
11			/** @param bool Export is allowed (shows buttons in the tfoot) */
12			public static $exportActive = true;
13			/** @param bool Export data altered (use false for pure result) */
14			public static $exportDataAsDisplayed = true;
15			/** @param array Collector (values for current table call) */
16			protected static $t = ['page' => 1, 'tables' => []];
17			/** @param array Re-settable values for current table call */
18			protected static $config = [
19			'APP' => 'App',
20			'DB_COLLATION_CI' => 'utf8mb4_general_ci', //UTF8_GENERAL_CI
21			'EMPTY_TABLE_MSG' => 'No results found.',
22			'EXPORT_FILE_NAME' => ':app - :items export (:datetime)',
23			'FILTER_ACTIVE' => true,
24			'FILTER_CASE_SENSITIVE' => false,
25			'SAVES' => ['CSV', 'Excel'],
26			'UTF8_ASC_SYMBOL' => '▲',
27			'UTF8_DESC_SYMBOL' => '▼',
28			'UTF8_LEFT_SYMBOL' => '&lsaquo;',
29			'UTF8_RIGHT_SYMBOL' => '&rsaquo;'
30			];
31			/** @param array Errors collector */
32			protected static $errors = [];
33
34			static function assets($path = "/public/table")
35			{
36			return "<script src=\"{$path}/table_helper.js\" defer></script>\n\t" .
37			"<script src=\"{$path}/table.js\" defer></script>\n\t" .
38			"<link href=\"{$path}/table.css\" rel=\"stylesheet\">\n";
39			}
40
41			/** Set/Get config value
42			* @param mixed $c (string) Get if exists, (array) Set if valid
43			* @return mixed */
44			public static function config($c)
45			{
46			try {
47			switch (gettype($c)) {
48			case 'array';
49			foreach ($c as $k => $v) {
50			self::$config[$k] = self::getValid((string)$k, $v);
51			}
52			break;
53			case 'string':
54			return self::getValid($c);
55			default:
56			throw new Exception("Invalid value type.");
57			}
58			} catch (Exception $e) {
59			self::err('ERROR: ' . $e->getMessage());
60			}
61			}
62
63			private static function getValid($k, $v = null)
64			{
65			if (!array_key_exists($k, self::$config)) {
66			throw new Exception('Request to undefined value: ' . $k);
67			}
68
69			if ($v !== null) {
70			if (empty($v) \|\| gettype($v) !== gettype(self::$config[$k])) {
71			throw new Exception("Setting invalid value: $v (:$k)");
72			}
73			}
74
75			return $v === null ? self::$config[$k] : $v;
76			}
77
78			/** Adds conditions, orderBy and Limits to query.
79			* @param string $q
80			* @param mixed $cond
81			* @param array $order
82			* @param mixed $limit -> 5 or [$start, $count]
83			* @param bool $h Having flag - to use HAVING instead of WHERE
84			* @return (string) */
85			protected static function q($q, $cond = null, array $order = [], $limit = 0, $h = false)
86			{
87			//Condition: '' \| ' (HAVING\|WHERE\|AND) ' . $cond
88			self::qConditions($q, $cond, $h);
89
90			//Order: '' \| 'ORDER BY ' . array_keys($order)[0] . ' ' . $order[0]
91			self::qOrder($q, $order);
92
93			//Limit: '' \| ' LIMIT ' . '(20, 40\|20)'
94			self::qLimit($q, $limit);
95
96			return $q;
97			}
98
99			private static function qConditions(&$q, $cond, $h)
100			{
101			if (!empty($cond)) {
102			$clause = !$h ? 'WHERE' : 'HAVING';
103			$clue = !strpos($q, $clause) ? $clause : 'AND';
104			$q .= (' ' . $clue . ' ' . $cond);
105			}
106			}
107
108			private static function qOrder(&$q, $order)
109			{
110			if (!empty($order)) {
111			$arr = array_map(function(&$v, $k) {
112			return $k . ' ' . strtoupper($v);
113			}, $order, array_keys($order));
114			$q .= (' ORDER BY ' . implode(', ', $arr));
115			}
116			}
117
118			private static function qLimit(&$q, $limit)
119			{
120			if (!empty($limit)) {
121			$l = (is_array($limit) ? implode(', ', $limit) : $limit);
122			$q .= (' LIMIT ' . $l);
123			}
124			}
125
126			protected static function err($message = null)
127			{
128			if (isset($message)) {
129			self::$errors[] = $message;
130			} else {
131			return empty(self::$errors) ? null :
132			'<p class="tbl-err">' . implode('</br>', self::$errors) . '</p>';
133			}
134			}
135
136			/** Array to space separated key value list
137			* @param array $attributes
138			* @return string */
139			protected static function attributes(array $attributes)
140			{
141			$list = [' '];
142			foreach ($attributes as $key => $value) {
143			if ($value === true \|\| (empty($value) && $value != 0)) {
144			$list[] = $key;
145			} else {
146			$list[] = $key . '="' . $value . '"';
147			}
148			}
149			return rtrim(implode(' ', $list));
150			}
151
152			/** Parses view to string
153			* @param string $template
154			* @param array $vars
155			* @return string */
156			protected static function view($template, $vars = [])
157			{
158			extract($vars);
159			ob_start();
160			require $template;
161			return (string)ob_get_clean();
162			}
163
164			/** Needed for more than one table on page
165			* @param string $items */
166			protected static function reset($items)
167			{
168			if (!in_array($items, self::$t["tables"])) {
169			self::$t["tables"][] = $items;
170			self::$cols = [];
171			self::$t['rows'] = null;
172			} else {
173			echo 'Existing table-id used in table::create(): ' . $items;
174			}
175			}
176			}
177

webdivane / table

Branch — master (ea0496)

trait_setter::qOrder() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like