MySQLiAdvancedOutput::getFieldOutputEnumSet() - Code Metrics - Inspection of "code minor re-organization to maintain a good bala..." - danielgp/common-lib - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — master ( 3cfcb2...176828 )

by Daniel

created 2018-07-01 10:39 UTC

MySQLiAdvancedOutput::getFieldOutputEnumSet() A

↳ Parent: MySQLiAdvancedOutput

Complexity

Conditions	3
Paths	3

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	3
nc	3
nop	4
dl	0
loc	13
rs	9.8333
c	0
b	0
f	0

<?php

/**
 *
 * The MIT License (MIT)
 *
 * Copyright (c) 2015 Daniel Popiniuc
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 *  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 *
 */

namespace danielgp\common_lib;

/**
 * useful functions to get quick results
 *
 * @author Daniel Popiniuc
 */
trait MySQLiAdvancedOutput
{

    use MySQLiByDanielGPtables;
filter:
    dependency_paths: ["lib/*"]

    /**
     * Returns a Enum or Set field to use in form
     *
     * @param string $tblSrc
     * @param string $fldType
     * @param array $val
     * @param array $iar
     * @return string
     */
    private function getFieldOutputEnumSet($tblSrc, $fldType, $val, $iar = [])
    {
        $adnlThings = $this->establishDefaultEnumSet($fldType);
        if (array_key_exists('readonly', $val)) {
            return $this->getFieldOutputEnumSetReadOnly($val, $adnlThings);
        }
        $inAdtnl = $adnlThings['additional'];
        if ($iar !== []) {
            $inAdtnl = array_merge($inAdtnl, $iar);
        }
        $vlSlct    = explode(',', $this->getFieldValue($val));
        $slctOptns = $this->getSetOrEnum2Array($tblSrc, $val['COLUMN_NAME']);
        return $this->setArrayToSelect($slctOptns, $vlSlct, $val['COLUMN_NAME'] . $adnlThings['suffix'], $inAdtnl);
    }

    /**
     * Returns a Numeric field 2 use in a form
     *
     * @param string $tblSrc
     * @param array $value
     * @param array $iar
     * @return string
     */
    private function getFieldOutputNumeric($tblSrc, $value, $iar = [])
    {
        if ($value['EXTRA'] == 'auto_increment') {
            return $this->getFieldOutputNumericAI($value, $iar);
        }
        $fkArray = $this->getForeignKeysToArray($this->advCache['workingDatabase'], $tblSrc, $value['COLUMN_NAME']);
        if ($fkArray === []) {
            $fldNos = $this->setFieldNumbers($value);
            return $this->getFieldOutputTT($value, min(50, (array_key_exists('l', $fldNos) ? $fldNos['l'] : 99)), $iar);
        }
        return $this->getFieldOutputNumericNonFK($fkArray, $value, $iar);
    }

    /**
     * Handles creation of Auto Increment numeric field type output
     *
     * @param array $value
     * @param array $iar
     * @return string
     */
    private function getFieldOutputNumericAI($value, $iar = [])
    {
        if ($this->getFieldValue($value) == '') {
            $spF = ['id' => $value['COLUMN_NAME'], 'style' => 'font-style:italic;'];
            return $this->setStringIntoTag('auto-numar', 'span', $spF);
        }
        $inAdtnl = [
            'type'  => 'hidden',
            'name'  => $value['COLUMN_NAME'],
            'id'    => $value['COLUMN_NAME'],
            'value' => $this->getFieldValue($value),
        ];
        if ($iar !== []) {
            $inAdtnl = array_merge($inAdtnl, $iar);
        }
        return '<b>' . $this->getFieldValue($value) . '</b>' . $this->setStringIntoShortTag('input', $inAdtnl);
    }

    /**
     * Builds field output type for numeric types if not FK
     *
     * @param array $fkArray
     * @param array $value
     * @param array $iar
     * @return string
     */
    private function getFieldOutputNumericNonFK($fkArray, $value, $iar = [])
    {
        $query         = $this->sQueryGenericSelectKeyValue([
            '`' . $value['COLUMN_NAME'] . '`',
            $fkArray[$value['COLUMN_NAME']][2],
            $fkArray[$value['COLUMN_NAME']][0],
        ]);
        $selectOptions = $this->setMySQLquery2Server($query, 'array_key_value')['result'];
        $selectValue   = $this->getFieldValue($value);
        $inAdtnl       = ['size' => 1];
        if ($value['IS_NULLABLE'] == 'YES') {
            $inAdtnl = array_merge($inAdtnl, ['include_null']);
        }
        if ($iar !== []) {
            $inAdtnl = array_merge($inAdtnl, $iar);
        }
        return $this->setArrayToSelect($selectOptions, $selectValue, $value['COLUMN_NAME'], $inAdtnl);
    }

    /**
     * Returns a Char field 2 use in a form
     *
     * @param string $tbl
     * @param string $fieldType
     * @param array $value
     * @param array $iar
     * @return string
     */
    private function getFieldOutputText($tbl, $fieldType, $value, $iar = [])
    {
        if (!in_array($fieldType, ['char', 'tinytext', 'varchar'])) {
            return '';
        }
        $foreignKeysArray = $this->getFieldOutputTextPrerequisites($tbl, $value);
        if ($foreignKeysArray !== []) {
            return $this->getFieldOutputTextFK($foreignKeysArray, $value, $iar);
        }
        return $this->getFieldOutputTextNonFK($value, $iar);
    }

    /**
     * Returns a Text field 2 use in a form
     *
     * @param string $fieldType
     * @param array $value
     * @param array $iar
     * @return string
     */
    protected function getFieldOutputTextLarge($fieldType, $value, $iar = [])
    {
        if (!in_array($fieldType, ['blob', 'text'])) {
            return '';
        }
        $inAdtnl = [
            'name' => $value['COLUMN_NAME'],
            'id'   => $value['COLUMN_NAME'],
            'rows' => 4,
            'cols' => 55,
        ];
        if ($iar !== []) {
            $inAdtnl = array_merge($inAdtnl, $iar);
        }
        return $this->setStringIntoTag($this->getFieldValue($value), 'textarea', $inAdtnl);
    }

    /**
     * Prepares the text output fields
     *
     * @param string $tbl
     * @param array $value
     * @return array
     */
    private function getFieldOutputTextPrerequisites($tbl, $value)
    {
        $foreignKeysArray = [];
        if (($tbl != 'user_rights') && ($value['COLUMN_NAME'] != 'eid')) {
            $database = $this->advCache['workingDatabase'];
            if (strpos($tbl, '`.`')) {
                $database = substr($tbl, 0, strpos($tbl, '`.`'));
            }
            $foreignKeysArray = $this->getForeignKeysToArray($database, $tbl, $value['COLUMN_NAME']);
        }
        return $foreignKeysArray;
    }

    /**
     * Returns a Timestamp field 2 use in a form
     *
     * @param array $dtl
     * @param array $iar
     * @return string
     */
    private function getFieldOutputTimestamp($dtl, $iar = [])
    {
        if (($dtl['COLUMN_DEFAULT'] == 'CURRENT_TIMESTAMP') || ($dtl['EXTRA'] == 'on update CURRENT_TIMESTAMP')) {
            return $this->getTimestamping($dtl)['input'];
        }
        $input = $this->getFieldOutputTT($dtl, 19, $iar);
        if (!array_key_exists('readonly', $iar)) {
            $input .= $this->setCalendarControlWithTime($dtl['COLUMN_NAME']);
        }
        return $input;
    }

    /**
     * Returns a Year field 2 use in a form
     *
     * @param array $details
     * @param array $iar
     * @return string
     */
    private function getFieldOutputYear($tblName, $details, $iar)
    {
        $listOfValues = [];
        for ($cntr = 1901; $cntr <= 2155; $cntr++) {
            $listOfValues[$cntr] = $cntr;
        }
        if ($iar == []) {
            $slDflt = $this->getFieldValue($details);
            return $this->setArrayToSelect($listOfValues, $slDflt, $details['COLUMN_NAME'], ['size' => 1]);
        }
        return $this->getFieldOutputText($tblName, 'varchar', $details, $iar);
    }

    /**
     * Returns an array with possible values of a SET or ENUM column
     *
     * @param string $refTbl
     * @param string $refCol
     * @return array
     */
    protected function getSetOrEnum2Array($refTbl, $refCol)
    {
        $dat = $this->establishDatabaseAndTable($refTbl);
        foreach ($this->advCache['tableStructureCache'][$dat[0]][$dat[1]] as $vle) {
            if ($vle['COLUMN_NAME'] == $refCol) {
                $kVl = explode('\',\'', substr($vle['COLUMN_TYPE'], strlen($vle['DATA_TYPE']) + 2, -2));
                $fVl = array_combine($kVl, $kVl);
                if ($vle['IS_NULLABLE'] === 'YES') {
                    $fVl['NULL'] = '';
                }
            }
        }
        ksort($fVl);
        return $fVl;
    }

    /**
     * Returns a timestamp field value
     *
     * @param array $dtl
     * @return array
     */
    private function getTimestamping($dtl)
    {
        $fieldValue = $this->getFieldValue($dtl);
        $inM        = $this->setStringIntoTag($fieldValue, 'span');
        if (in_array($fieldValue, ['', 'CURRENT_TIMESTAMP', 'NULL'])) {
            $mCN = [
                'InsertDateTime'        => 'data/timpul ad. informatiei',
                'ModificationDateTime'  => 'data/timpul modificarii inf.',
                'modification_datetime' => 'data/timpul modificarii inf.',
            ];
            if (array_key_exists($dtl['COLUMN_NAME'], $mCN)) {
                $inM = $this->setStringIntoTag($mCN[$dtl['COLUMN_NAME']], 'span', ['style' => 'font-style:italic;']);
            }
        }
        $lbl = '<span class="fake_label">' . $this->getFieldNameForDisplay($dtl) . '</span>';
        return ['label' => $lbl, 'input' => $inM];
    }

    protected function setNeededFieldKnown($tblName, $dtls, $features)
    {
        $iar      = $this->handleFeatures($dtls['COLUMN_NAME'], $features);
        $sReturn  = '';
        $numTypes = ['bigint', 'int', 'mediumint', 'smallint', 'tinyint', 'float', 'double', 'decimal', 'numeric'];
        if (in_array($dtls['DATA_TYPE'], $numTypes)) {
            $sReturn = $this->getFieldOutputNumeric($tblName, $dtls, $iar);
        } elseif (in_array($dtls['DATA_TYPE'], ['char', 'tinytext', 'varchar', 'enum', 'set', 'text', 'blob'])) {
            $sReturn = $this->setNeededFieldTextRelated($tblName, $dtls, $iar);
        } elseif (in_array($dtls['DATA_TYPE'], ['date', 'datetime', 'time', 'timestamp', 'year'])) {
            $sReturn = $this->setNeededFieldSingleType($tblName, $dtls, $iar);
        }
        return $this->getFieldCompletionType($dtls) . $sReturn;
    }

    private function setNeededFieldSingleType($tblName, $dtls, $iar)
    {
        if ($dtls['DATA_TYPE'] == 'date') {
            return $this->getFieldOutputDate($dtls);
        } elseif ($dtls['DATA_TYPE'] == 'time') {
            return $this->getFieldOutputTime($dtls, $iar);
        } elseif (in_array($dtls['DATA_TYPE'], ['datetime', 'timestamp'])) {
            return $this->getFieldOutputTimestamp($dtls, $iar);
        }
        return $this->getFieldOutputYear($tblName, $dtls, $iar);
    }

    /**
     *
     * @param string $tblName
     * @param array $dtls
     * @param array $iar
     * @return string
     */
    private function setNeededFieldTextRelated($tblName, $dtls, $iar)
    {
        if (in_array($dtls['DATA_TYPE'], ['char', 'tinytext', 'varchar'])) {
            return $this->getFieldOutputText($tblName, $dtls['DATA_TYPE'], $dtls, $iar);
        } elseif (in_array($dtls['DATA_TYPE'], ['text', 'blob'])) {
            return $this->getFieldOutputTextLarge($dtls['DATA_TYPE'], $dtls, $iar);
        }
        return $this->getFieldOutputEnumSet($tblName, $dtls['DATA_TYPE'], $dtls, $iar);
    }

}


1			<?php
2
3			/**
4			*
5			* The MIT License (MIT)
6			*
7			* Copyright (c) 2015 Daniel Popiniuc
8			*
9			* Permission is hereby granted, free of charge, to any person obtaining a copy
10			* of this software and associated documentation files (the "Software"), to deal
11			* in the Software without restriction, including without limitation the rights
12			* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
13			* copies of the Software, and to permit persons to whom the Software is
14			* furnished to do so, subject to the following conditions:
15			*
16			* The above copyright notice and this permission notice shall be included in all
17			* copies or substantial portions of the Software.
18			*
19			* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
20			* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
21			* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
22			* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
23			* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
24			* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
25			* SOFTWARE.
26			*
27			*/
28
29			namespace danielgp\common_lib;
30
31			/**
32			* useful functions to get quick results
33			*
34			* @author Daniel Popiniuc
35			*/
36			trait MySQLiAdvancedOutput
37			{
38
39			use MySQLiByDanielGPtables;
			0 ignored issues – show Bug introduced 2018-07-01 10:41 UTC by Report Bug Copy Issue Report The type `danielgp\common_lib\MySQLiByDanielGPtables` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
40
41			/**
42			* Returns a Enum or Set field to use in form
43			*
44			* @param string $tblSrc
45			* @param string $fldType
46			* @param array $val
47			* @param array $iar
48			* @return string
49			*/
50			private function getFieldOutputEnumSet($tblSrc, $fldType, $val, $iar = [])
51			{
52			$adnlThings = $this->establishDefaultEnumSet($fldType);
53			if (array_key_exists('readonly', $val)) {
54			return $this->getFieldOutputEnumSetReadOnly($val, $adnlThings);
55			}
56			$inAdtnl = $adnlThings['additional'];
57			if ($iar !== []) {
58			$inAdtnl = array_merge($inAdtnl, $iar);
59			}
60			$vlSlct = explode(',', $this->getFieldValue($val));
61			$slctOptns = $this->getSetOrEnum2Array($tblSrc, $val['COLUMN_NAME']);
62			return $this->setArrayToSelect($slctOptns, $vlSlct, $val['COLUMN_NAME'] . $adnlThings['suffix'], $inAdtnl);
63			}
64
65			/**
66			* Returns a Numeric field 2 use in a form
67			*
68			* @param string $tblSrc
69			* @param array $value
70			* @param array $iar
71			* @return string
72			*/
73			private function getFieldOutputNumeric($tblSrc, $value, $iar = [])
74			{
75			if ($value['EXTRA'] == 'auto_increment') {
76			return $this->getFieldOutputNumericAI($value, $iar);
77			}
78			$fkArray = $this->getForeignKeysToArray($this->advCache['workingDatabase'], $tblSrc, $value['COLUMN_NAME']);
79			if ($fkArray === []) {
80			$fldNos = $this->setFieldNumbers($value);
81			return $this->getFieldOutputTT($value, min(50, (array_key_exists('l', $fldNos) ? $fldNos['l'] : 99)), $iar);
82			}
83			return $this->getFieldOutputNumericNonFK($fkArray, $value, $iar);
84			}
85
86			/**
87			* Handles creation of Auto Increment numeric field type output
88			*
89			* @param array $value
90			* @param array $iar
91			* @return string
92			*/
93			private function getFieldOutputNumericAI($value, $iar = [])
94			{
95			if ($this->getFieldValue($value) == '') {
96			$spF = ['id' => $value['COLUMN_NAME'], 'style' => 'font-style:italic;'];
97			return $this->setStringIntoTag('auto-numar', 'span', $spF);
98			}
99			$inAdtnl = [
100			'type' => 'hidden',
101			'name' => $value['COLUMN_NAME'],
102			'id' => $value['COLUMN_NAME'],
103			'value' => $this->getFieldValue($value),
104			];
105			if ($iar !== []) {
106			$inAdtnl = array_merge($inAdtnl, $iar);
107			}
108			return '<b>' . $this->getFieldValue($value) . '</b>' . $this->setStringIntoShortTag('input', $inAdtnl);
109			}
110
111			/**
112			* Builds field output type for numeric types if not FK
113			*
114			* @param array $fkArray
115			* @param array $value
116			* @param array $iar
117			* @return string
118			*/
119			private function getFieldOutputNumericNonFK($fkArray, $value, $iar = [])
120			{
121			$query = $this->sQueryGenericSelectKeyValue([
122			'`' . $value['COLUMN_NAME'] . '`',
123			$fkArray[$value['COLUMN_NAME']][2],
124			$fkArray[$value['COLUMN_NAME']][0],
125			]);
126			$selectOptions = $this->setMySQLquery2Server($query, 'array_key_value')['result'];
127			$selectValue = $this->getFieldValue($value);
128			$inAdtnl = ['size' => 1];
129			if ($value['IS_NULLABLE'] == 'YES') {
130			$inAdtnl = array_merge($inAdtnl, ['include_null']);
131			}
132			if ($iar !== []) {
133			$inAdtnl = array_merge($inAdtnl, $iar);
134			}
135			return $this->setArrayToSelect($selectOptions, $selectValue, $value['COLUMN_NAME'], $inAdtnl);
136			}
137
138			/**
139			* Returns a Char field 2 use in a form
140			*
141			* @param string $tbl
142			* @param string $fieldType
143			* @param array $value
144			* @param array $iar
145			* @return string
146			*/
147			private function getFieldOutputText($tbl, $fieldType, $value, $iar = [])
148			{
149			if (!in_array($fieldType, ['char', 'tinytext', 'varchar'])) {
150			return '';
151			}
152			$foreignKeysArray = $this->getFieldOutputTextPrerequisites($tbl, $value);
153			if ($foreignKeysArray !== []) {
154			return $this->getFieldOutputTextFK($foreignKeysArray, $value, $iar);
155			}
156			return $this->getFieldOutputTextNonFK($value, $iar);
157			}
158
159			/**
160			* Returns a Text field 2 use in a form
161			*
162			* @param string $fieldType
163			* @param array $value
164			* @param array $iar
165			* @return string
166			*/
167			protected function getFieldOutputTextLarge($fieldType, $value, $iar = [])
168			{
169			if (!in_array($fieldType, ['blob', 'text'])) {
170			return '';
171			}
172			$inAdtnl = [
173			'name' => $value['COLUMN_NAME'],
174			'id' => $value['COLUMN_NAME'],
175			'rows' => 4,
176			'cols' => 55,
177			];
178			if ($iar !== []) {
179			$inAdtnl = array_merge($inAdtnl, $iar);
180			}
181			return $this->setStringIntoTag($this->getFieldValue($value), 'textarea', $inAdtnl);
182			}
183
184			/**
185			* Prepares the text output fields
186			*
187			* @param string $tbl
188			* @param array $value
189			* @return array
190			*/
191			private function getFieldOutputTextPrerequisites($tbl, $value)
192			{
193			$foreignKeysArray = [];
194			if (($tbl != 'user_rights') && ($value['COLUMN_NAME'] != 'eid')) {
195			$database = $this->advCache['workingDatabase'];
196			if (strpos($tbl, '`.`')) {
197			$database = substr($tbl, 0, strpos($tbl, '`.`'));
198			}
199			$foreignKeysArray = $this->getForeignKeysToArray($database, $tbl, $value['COLUMN_NAME']);
200			}
201			return $foreignKeysArray;
202			}
203
204			/**
205			* Returns a Timestamp field 2 use in a form
206			*
207			* @param array $dtl
208			* @param array $iar
209			* @return string
210			*/
211			private function getFieldOutputTimestamp($dtl, $iar = [])
212			{
213			if (($dtl['COLUMN_DEFAULT'] == 'CURRENT_TIMESTAMP') \|\| ($dtl['EXTRA'] == 'on update CURRENT_TIMESTAMP')) {
214			return $this->getTimestamping($dtl)['input'];
215			}
216			$input = $this->getFieldOutputTT($dtl, 19, $iar);
217			if (!array_key_exists('readonly', $iar)) {
218			$input .= $this->setCalendarControlWithTime($dtl['COLUMN_NAME']);
219			}
220			return $input;
221			}
222
223			/**
224			* Returns a Year field 2 use in a form
225			*
226			* @param array $details
227			* @param array $iar
228			* @return string
229			*/
230			private function getFieldOutputYear($tblName, $details, $iar)
231			{
232			$listOfValues = [];
233			for ($cntr = 1901; $cntr <= 2155; $cntr++) {
234			$listOfValues[$cntr] = $cntr;
235			}
236			if ($iar == []) {
237			$slDflt = $this->getFieldValue($details);
238			return $this->setArrayToSelect($listOfValues, $slDflt, $details['COLUMN_NAME'], ['size' => 1]);
239			}
240			return $this->getFieldOutputText($tblName, 'varchar', $details, $iar);
241			}
242
243			/**
244			* Returns an array with possible values of a SET or ENUM column
245			*
246			* @param string $refTbl
247			* @param string $refCol
248			* @return array
249			*/
250			protected function getSetOrEnum2Array($refTbl, $refCol)
251			{
252			$dat = $this->establishDatabaseAndTable($refTbl);
253			foreach ($this->advCache['tableStructureCache'][$dat[0]][$dat[1]] as $vle) {
254			if ($vle['COLUMN_NAME'] == $refCol) {
255			$kVl = explode('\',\'', substr($vle['COLUMN_TYPE'], strlen($vle['DATA_TYPE']) + 2, -2));
256			$fVl = array_combine($kVl, $kVl);
257			if ($vle['IS_NULLABLE'] === 'YES') {
258			$fVl['NULL'] = '';
259			}
260			}
261			}
262			ksort($fVl);
263			return $fVl;
264			}
265
266			/**
267			* Returns a timestamp field value
268			*
269			* @param array $dtl
270			* @return array
271			*/
272			private function getTimestamping($dtl)
273			{
274			$fieldValue = $this->getFieldValue($dtl);
275			$inM = $this->setStringIntoTag($fieldValue, 'span');
276			if (in_array($fieldValue, ['', 'CURRENT_TIMESTAMP', 'NULL'])) {
277			$mCN = [
278			'InsertDateTime' => 'data/timpul ad. informatiei',
279			'ModificationDateTime' => 'data/timpul modificarii inf.',
280			'modification_datetime' => 'data/timpul modificarii inf.',
281			];
282			if (array_key_exists($dtl['COLUMN_NAME'], $mCN)) {
283			$inM = $this->setStringIntoTag($mCN[$dtl['COLUMN_NAME']], 'span', ['style' => 'font-style:italic;']);
284			}
285			}
286			$lbl = '<span class="fake_label">' . $this->getFieldNameForDisplay($dtl) . '</span>';
287			return ['label' => $lbl, 'input' => $inM];
288			}
289
290			protected function setNeededFieldKnown($tblName, $dtls, $features)
291			{
292			$iar = $this->handleFeatures($dtls['COLUMN_NAME'], $features);
293			$sReturn = '';
294			$numTypes = ['bigint', 'int', 'mediumint', 'smallint', 'tinyint', 'float', 'double', 'decimal', 'numeric'];
295			if (in_array($dtls['DATA_TYPE'], $numTypes)) {
296			$sReturn = $this->getFieldOutputNumeric($tblName, $dtls, $iar);
297			} elseif (in_array($dtls['DATA_TYPE'], ['char', 'tinytext', 'varchar', 'enum', 'set', 'text', 'blob'])) {
298			$sReturn = $this->setNeededFieldTextRelated($tblName, $dtls, $iar);
299			} elseif (in_array($dtls['DATA_TYPE'], ['date', 'datetime', 'time', 'timestamp', 'year'])) {
300			$sReturn = $this->setNeededFieldSingleType($tblName, $dtls, $iar);
301			}
302			return $this->getFieldCompletionType($dtls) . $sReturn;
303			}
304
305			private function setNeededFieldSingleType($tblName, $dtls, $iar)
306			{
307			if ($dtls['DATA_TYPE'] == 'date') {
308			return $this->getFieldOutputDate($dtls);
309			} elseif ($dtls['DATA_TYPE'] == 'time') {
310			return $this->getFieldOutputTime($dtls, $iar);
311			} elseif (in_array($dtls['DATA_TYPE'], ['datetime', 'timestamp'])) {
312			return $this->getFieldOutputTimestamp($dtls, $iar);
313			}
314			return $this->getFieldOutputYear($tblName, $dtls, $iar);
315			}
316
317			/**
318			*
319			* @param string $tblName
320			* @param array $dtls
321			* @param array $iar
322			* @return string
323			*/
324			private function setNeededFieldTextRelated($tblName, $dtls, $iar)
325			{
326			if (in_array($dtls['DATA_TYPE'], ['char', 'tinytext', 'varchar'])) {
327			return $this->getFieldOutputText($tblName, $dtls['DATA_TYPE'], $dtls, $iar);
328			} elseif (in_array($dtls['DATA_TYPE'], ['text', 'blob'])) {
329			return $this->getFieldOutputTextLarge($dtls['DATA_TYPE'], $dtls, $iar);
330			}
331			return $this->getFieldOutputEnumSet($tblName, $dtls['DATA_TYPE'], $dtls, $iar);
332			}
333
334			}
335

danielgp / common-lib

Push — master ( 3cfcb2...176828 )

MySQLiAdvancedOutput::getFieldOutputEnumSet() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like