SqlFile::getDatabaseFields() - Code Metrics - Inspection of "XoopsFormTextDateSelect: created var for isNew was..." - txmodxoops/tdmcreate - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — master (38ab27)

by Michael

created 2018-03-02 13:46 UTC

SqlFile::getDatabaseFields() F

↳ Parent: SqlFile

Complexity

Conditions	47
Paths	6363

Size

Total Lines	166
Code Lines	144

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	47
eloc	144
nc	6363
nop	6
dl	0
loc	166
rs	2
c	1
b	0
f	0

How to fix Long Method Complexity

<?php

/*
 You may not change or alter any portion of this comment or credits
 of supporting developers from this source code or any supporting source code
 which is considered copyrighted (c) material of the original comment or credit authors.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 */
/**
 * tdmcreate module.
 *
 * @copyright       XOOPS Project (https://xoops.org)
 * @license         GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
 *
 * @since           2.5.0
 *
 * @author          Txmod Xoops http://www.txmodxoops.org
 *
 * @version         $Id: SqlFile.php 12258 2014-01-02 09:33:29Z timgno $
 */

/**
 * Class SqlFile.
 */
class SqlFile extends TDMCreateFile
{
    /**
     *  @public function constructor
     *
     *  @param null
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * @static function getInstance
     *
     * @param null
     *
     * @return SqlFile
     */
    public static function getInstance()
    {
        static $instance = false;
        if (!$instance) {
            $instance = new self();
        }

        return $instance;
    }

    /**
     *  @public function write
     *
     *  @param $module
     *  @param $filename
     */
    public function write($module, $filename)
    {
        $this->setModule($module);
        $this->setFileName($filename);
    }

    /**
     * @private function getHeaderSqlComments
     *
     * @param $moduleName
     *
     * @return string
     */
    private function getHeaderSqlComments($moduleName)
    {
        $date = date('D M d, Y');
        $time = date('H:i:s');
        $serverName = $_SERVER['SERVER_NAME'];
        $serverVersion = $GLOBALS['xoopsDB']->getServerVersion();
        $phpVersion = PHP_VERSION;
        // Header Sql Comments
        $ret = null;
        $arrayServerInfo = [
            "# SQL Dump for {$moduleName} module", '# PhpMyAdmin Version: 4.0.4',
            '# http://www.phpmyadmin.net', '#', "# Host: {$serverName}",
            "# Generated on: {$date} to {$time}", "# Server version: {$serverVersion}",
            "# PHP Version: {$phpVersion}\n",
        ];
        foreach ($arrayServerInfo as $serverInfo) {
            $ret .= $this->getSimpleString($serverInfo);
        }

        return $ret;
    }

    /**
     *  @private function getHeadDatabaseTable
     *  @param $moduleDirname
     *  @param $tableName
     *  @param integer $fieldsNumb
     *
     *  Unused IF NOT EXISTS
     *
     *  @return string
     */
    private function getHeadDatabaseTable($moduleDirname, $tableName, $fieldsNumb)
    {
        $ret = null;
        $arrayDbTable = [
            '#', "# Structure table for `{$moduleDirname}_{$tableName}` {$fieldsNumb}",
            '#', "\nCREATE TABLE `{$moduleDirname}_{$tableName}` (",
        ];
        foreach ($arrayDbTable as $dbTable) {
            $ret .= $this->getSimpleString($dbTable);
        }

        return $ret;
    }

    /**
     *  @private function getDatabaseTables
     *
     *  @param $module
     *
     *  @return null|string
     */
    private function getDatabaseTables($module)
    {
        $ret = null;
        $moduleDirname = strtolower($module->getVar('mod_dirname'));
        $tables = $this->getTableTables($module->getVar('mod_id'), 'table_order ASC, table_id');
        foreach (array_keys($tables) as $t) {
            $tableId = $tables[$t]->getVar('table_id');
            $tableMid = $tables[$t]->getVar('table_mid');
            $tableName = $tables[$t]->getVar('table_name');
            $tableAutoincrement = $tables[$t]->getVar('table_autoincrement');
            $fieldsNumb = $tables[$t]->getVar('table_nbfields');
            $ret .= $this->getDatabaseFields($moduleDirname, $tableMid, $tableId, $tableName, $tableAutoincrement, $fieldsNumb);
        }

        return $ret;
    }

    /**
     * @private function getDatabaseFields
     *
     * @param $moduleDirname
     * @param $tableMid
     * @param $tableId
     * @param $tableName
     * @param $tableAutoincrement
     * @param $fieldsNumb
     * @return null|string
     */
    private function getDatabaseFields($moduleDirname, $tableMid, $tableId, $tableName, $tableAutoincrement, $fieldsNumb)
    {
        $tdmcreate = TDMCreateHelper::getInstance();
        $ret = null;
        $j = 0;
        $comma = [];
        $row = [];
        $type = '';
        $fields = $this->getTableFields($tableMid, $tableId, 'field_id ASC, field_name');
        foreach (array_keys($fields) as $f) {
            // Creation of database table
            $ret = $this->getHeadDatabaseTable($moduleDirname, $tableName, $fieldsNumb);
            $fieldName = $fields[$f]->getVar('field_name');
            $fieldType = $fields[$f]->getVar('field_type');
            $fieldValue = $fields[$f]->getVar('field_value');
            $fieldAttribute = $fields[$f]->getVar('field_attribute');
            $fieldNull = $fields[$f]->getVar('field_null');
            $fieldDefault = $fields[$f]->getVar('field_default');
            $fieldKey = $fields[$f]->getVar('field_key');
            if ($fieldType > 1) {
                $fType = $tdmcreate->getHandler('fieldtype')->get($fieldType);
                $fieldTypeName = $fType->getVar('fieldtype_name');
            } else {
                $fieldType = null;
            }
            if ($fieldAttribute > 1) {
                $fAttribute = $tdmcreate->getHandler('fieldattributes')->get($fieldAttribute);
                $fieldAttribute = $fAttribute->getVar('fieldattribute_name');
            } else {
                $fieldAttribute = null;
            }
            if ($fieldNull > 1) {
                $fNull = $tdmcreate->getHandler('fieldnull')->get($fieldNull);
                $fieldNull = $fNull->getVar('fieldnull_name');
            } else {
                $fieldNull = null;
            }
            if (!empty($fieldName)) {
                switch ($fieldType) {
                    case 2:
                    case 3:
                    case 4:
                    case 5:
                        $type = $fieldTypeName.'('.$fieldValue.')';

                        if (empty($fieldDefault)) {
                            $default = "DEFAULT '0'";
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    case 6:
                    case 7:
                    case 8:
                        $type = $fieldTypeName.'('.$fieldValue.')';
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT '0.00'"; // From MySQL 5.7 Manual
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    case 9:
                    case 10:
                        $fValues = implode("', '", explode(',', str_replace(' ', '', $fieldValue)));
                        $type = $fieldTypeName.'(\''.$fValues.'\')'; // Used with comma separator
                        $default = "DEFAULT '{$fieldDefault}'";
                        break;
                    case 11:
                        $type = $fieldTypeName.'('.$fieldValue.')';
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT '[email protected]'";
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    case 12:
                        $type = $fieldTypeName.'('.$fieldValue.')';
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT 'http:\\'";
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    case 13:
                    case 14:
                        $type = $fieldTypeName.'('.$fieldValue.')';
                        $default = "DEFAULT '{$fieldDefault}'";
                        break;
                    case 15:
                    case 16:
                    case 17:
                    case 18:
                        $type = $fieldTypeName;
                        $default = null;
                        break;
                    case 19:
                    case 20:
                    case 21:
                    case 22:
                        $type = $fieldTypeName.'('.$fieldValue.')';
                        $default = "DEFAULT '{$fieldDefault}'";
                        break;
                    case 23:
                        $type = $fieldTypeName;
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT '1970'"; // From MySQL 5.7 Manual
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    default:
                        $type = $fieldTypeName.'('.$fieldValue.')';
                        $default = "DEFAULT '{$fieldDefault}'";
                        break;
                }
                if ((0 == $f) && (1 == $tableAutoincrement)) {
                    $row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, null, 'AUTO_INCREMENT');
                    $comma[$j] = $this->getKey(2, $fieldName);
                    ++$j;
                } elseif ((0 == $f) && (0 == $tableAutoincrement)) {
                    $row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                    $comma[$j] = $this->getKey(2, $fieldName);
                    ++$j;
                } else {
                    if (3 == $fieldKey || 4 == $fieldKey || 5 == $fieldKey || 6 == $fieldKey) {
                        switch ($fieldKey) {
                            case 3:
                                $row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                                $comma[$j] = $this->getKey(3, $fieldName);
                                ++$j;
                                break;
                            case 4:
                                $row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                                $comma[$j] = $this->getKey(4, $fieldName);
                                ++$j;
                                break;
                            case 5:
                                $row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                                $comma[$j] = $this->getKey(5, $fieldName);
                                ++$j;
                                break;
                            case 6:
                                $row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                                $comma[$j] = $this->getKey(6, $fieldName);
                                ++$j;
                                break;
                        }
                    } else {
                        $row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                    }
                }
            }
        }
        // ================= COMMA ================= //
        for ($i = 0; $i < $j; ++$i) {
            if ($i != $j - 1) {
                $row[] = $comma[$i].',';
            } else {
                $row[] = $comma[$i];
            }
        }
        // ================= COMMA CICLE ================= //
        $ret .= implode("\n", $row);
        unset($j);
        $ret .= $this->getFootDatabaseTable();

        return $ret;
    }

    /**
     *  @private function getFootDatabaseTable
     *
     *  @param null
     *
     * @return string
     */
    private function getFootDatabaseTable()
    {
        return "\n) ENGINE=InnoDB;\n\n";
    }

    /**
     *  @private function getFieldRow
     *
     *  @param $fieldName
     *  @param $fieldTypeValue
     *  @param $fieldAttribute
     *  @param $fieldNull
     *  @param $fieldDefault
     *  @param $autoincrement
     *
     *  @return string
     */
    private function getFieldRow($fieldName, $fieldTypeValue, $fieldAttribute = null, $fieldNull = null, $fieldDefault = null, $autoincrement = null)
    {
        $retAutoincrement = "  `{$fieldName}` {$fieldTypeValue} {$fieldAttribute} {$fieldNull} {$autoincrement},";
        $retFieldAttribute = "  `{$fieldName}` {$fieldTypeValue} {$fieldAttribute} {$fieldNull} {$fieldDefault},";
        $fieldDefault = "  `{$fieldName}` {$fieldTypeValue} {$fieldNull} {$fieldDefault},";
        $retShort = "  `{$fieldName}` {$fieldTypeValue},";

        $ret = $retShort;
        if (null != $autoincrement) {
            $ret = $retAutoincrement;
        } elseif (null != $fieldAttribute) {
            $ret = $retFieldAttribute;
        } elseif (null === $fieldAttribute) {
            $ret = $fieldDefault;
        }

        return $ret;
    }

    /**
     * @private function getKey
     *
     * @param $key
     * @param $fieldName
     * @return string
     */
    private function getKey($key, $fieldName)
    {
        $ret = null;
        switch ($key) {
            case 2: // PRIMARY KEY
                $ret = "  PRIMARY KEY (`{$fieldName}`)";
                break;
            case 3: // UNIQUE KEY
                $ret = "  UNIQUE KEY `{$fieldName}` (`{$fieldName}`)";
                break;
            case 4: // KEY
                $ret = "  KEY `{$fieldName}` (`{$fieldName}`)";
                break;
            case 5: // INDEX
                $ret = "  INDEX (`{$fieldName}`)";
                break;
            case 6: // FULLTEXT KEY
                $ret = "  FULLTEXT KEY `{$fieldName}` (`{$fieldName}`)";
                break;
        }

        return $ret;
    }

    /**
     *  @private function getComma
     *
     *  @param $row
     *  @param $comma
     *
     *  @return string
     */
    private function getComma($row, $comma = null)
    {
        return " {$row}{$comma}";
    }

    /**
     *  @private function getCommaCicle
     *
     *  @param $comma
     *  @param $index
     *
     *  @return string
     */
    private function getCommaCicle($comma, $index)

    {
        $ret = null;
        // Comma issue
        for ($i = 1; $i <= $index; ++$i) {
            if ($i != $index - 1) {
                $ret = $this->getComma(isset($comma[$i]), ',')."\n";
            } else {
                $ret = $this->getComma(isset($comma[$i]))."\n";
            }
        }

        return $ret;
    }

    /**
     *  @public function render
     *
     *  @param null
     *
     *  @return bool|string
     */
    public function render()
    {
        $module = $this->getModule();
        $filename = $this->getFileName();
        $moduleName = strtolower($module->getVar('mod_name'));
        $moduleDirname = strtolower($module->getVar('mod_dirname'));
        $content = $this->getHeaderSqlComments($moduleName);
        $content .= $this->getDatabaseTables($module);

        $this->create($moduleDirname, 'sql', $filename, $content, _AM_TDMCREATE_FILE_CREATED, _AM_TDMCREATE_FILE_NOTCREATED);

        return $this->renderFile();
    }
}


1			<?php
2
3			/*
4			You may not change or alter any portion of this comment or credits
5			of supporting developers from this source code or any supporting source code
6			which is considered copyrighted (c) material of the original comment or credit authors.
7
8			This program is distributed in the hope that it will be useful,
9			but WITHOUT ANY WARRANTY; without even the implied warranty of
10			MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
11			*/
12			/**
13			* tdmcreate module.
14			*
15			* @copyright XOOPS Project (https://xoops.org)
16			* @license GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
17			*
18			* @since 2.5.0
19			*
20			* @author Txmod Xoops http://www.txmodxoops.org
21			*
22			* @version $Id: SqlFile.php 12258 2014-01-02 09:33:29Z timgno $
23			*/
24
25			/**
26			* Class SqlFile.
27			*/
28			class SqlFile extends TDMCreateFile
29			{
30			/**
31			* @public function constructor
32			*
33			* @param null
34			*/
35			public function __construct()
36			{
37			parent::__construct();
38			}
39
40			/**
41			* @static function getInstance
42			*
43			* @param null
44			*
45			* @return SqlFile
46			*/
47			public static function getInstance()
48			{
49			static $instance = false;
50			if (!$instance) {
51			$instance = new self();
52			}
53
54			return $instance;
55			}
56
57			/**
58			* @public function write
59			*
60			* @param $module
61			* @param $filename
62			*/
63			public function write($module, $filename)
64			{
65			$this->setModule($module);
66			$this->setFileName($filename);
67			}
68
69			/**
70			* @private function getHeaderSqlComments
71			*
72			* @param $moduleName
73			*
74			* @return string
75			*/
76			private function getHeaderSqlComments($moduleName)
77			{
78			$date = date('D M d, Y');
79			$time = date('H:i:s');
80			$serverName = $_SERVER['SERVER_NAME'];
81			$serverVersion = $GLOBALS['xoopsDB']->getServerVersion();
82			$phpVersion = PHP_VERSION;
83			// Header Sql Comments
84			$ret = null;
85			$arrayServerInfo = [
86			"# SQL Dump for {$moduleName} module", '# PhpMyAdmin Version: 4.0.4',
87			'# http://www.phpmyadmin.net', '#', "# Host: {$serverName}",
88			"# Generated on: {$date} to {$time}", "# Server version: {$serverVersion}",
89			"# PHP Version: {$phpVersion}\n",
90			];
91			foreach ($arrayServerInfo as $serverInfo) {
92			$ret .= $this->getSimpleString($serverInfo);
93			}
94
95			return $ret;
96			}
97
98			/**
99			* @private function getHeadDatabaseTable
100			* @param $moduleDirname
101			* @param $tableName
102			* @param integer $fieldsNumb
103			*
104			* Unused IF NOT EXISTS
105			*
106			* @return string
107			*/
108			private function getHeadDatabaseTable($moduleDirname, $tableName, $fieldsNumb)
109			{
110			$ret = null;
111			$arrayDbTable = [
112			'#', "# Structure table for `{$moduleDirname}_{$tableName}` {$fieldsNumb}",
113			'#', "\nCREATE TABLE `{$moduleDirname}_{$tableName}` (",
114			];
115			foreach ($arrayDbTable as $dbTable) {
116			$ret .= $this->getSimpleString($dbTable);
117			}
118
119			return $ret;
120			}
121
122			/**
123			* @private function getDatabaseTables
124			*
125			* @param $module
126			*
127			* @return null\|string
128			*/
129			private function getDatabaseTables($module)
130			{
131			$ret = null;
132			$moduleDirname = strtolower($module->getVar('mod_dirname'));
133			$tables = $this->getTableTables($module->getVar('mod_id'), 'table_order ASC, table_id');
134			foreach (array_keys($tables) as $t) {
135			$tableId = $tables[$t]->getVar('table_id');
136			$tableMid = $tables[$t]->getVar('table_mid');
137			$tableName = $tables[$t]->getVar('table_name');
138			$tableAutoincrement = $tables[$t]->getVar('table_autoincrement');
139			$fieldsNumb = $tables[$t]->getVar('table_nbfields');
140			$ret .= $this->getDatabaseFields($moduleDirname, $tableMid, $tableId, $tableName, $tableAutoincrement, $fieldsNumb);
141			}
142
143			return $ret;
144			}
145
146			/**
147			* @private function getDatabaseFields
148			*
149			* @param $moduleDirname
150			* @param $tableMid
151			* @param $tableId
152			* @param $tableName
153			* @param $tableAutoincrement
154			* @param $fieldsNumb
155			* @return null\|string
156			*/
157			private function getDatabaseFields($moduleDirname, $tableMid, $tableId, $tableName, $tableAutoincrement, $fieldsNumb)
158			{
159			$tdmcreate = TDMCreateHelper::getInstance();
160			$ret = null;
161			$j = 0;
162			$comma = [];
163			$row = [];
164			$type = '';
165			$fields = $this->getTableFields($tableMid, $tableId, 'field_id ASC, field_name');
166			foreach (array_keys($fields) as $f) {
167			// Creation of database table
168			$ret = $this->getHeadDatabaseTable($moduleDirname, $tableName, $fieldsNumb);
169			$fieldName = $fields[$f]->getVar('field_name');
170			$fieldType = $fields[$f]->getVar('field_type');
171			$fieldValue = $fields[$f]->getVar('field_value');
172			$fieldAttribute = $fields[$f]->getVar('field_attribute');
173			$fieldNull = $fields[$f]->getVar('field_null');
174			$fieldDefault = $fields[$f]->getVar('field_default');
175			$fieldKey = $fields[$f]->getVar('field_key');
176			if ($fieldType > 1) {
177			$fType = $tdmcreate->getHandler('fieldtype')->get($fieldType);
178			$fieldTypeName = $fType->getVar('fieldtype_name');
179			} else {
180			$fieldType = null;
181			}
182			if ($fieldAttribute > 1) {
183			$fAttribute = $tdmcreate->getHandler('fieldattributes')->get($fieldAttribute);
184			$fieldAttribute = $fAttribute->getVar('fieldattribute_name');
185			} else {
186			$fieldAttribute = null;
187			}
188			if ($fieldNull > 1) {
189			$fNull = $tdmcreate->getHandler('fieldnull')->get($fieldNull);
190			$fieldNull = $fNull->getVar('fieldnull_name');
191			} else {
192			$fieldNull = null;
193			}
194			if (!empty($fieldName)) {
195			switch ($fieldType) {
196			case 2:
197			case 3:
198			case 4:
199			case 5:
200			$type = $fieldTypeName.'('.$fieldValue.')';
			0 ignored issues – show Comprehensibility Best Practice introduced 2018-03-02 13:49 UTC by Report Bug Copy Issue Report The variable `$fieldTypeName` does not seem to be defined for all execution paths leading up to this point. Loading history...
201			if (empty($fieldDefault)) {
202			$default = "DEFAULT '0'";
203			} else {
204			$default = "DEFAULT '{$fieldDefault}'";
205			}
206			break;
207			case 6:
208			case 7:
209			case 8:
210			$type = $fieldTypeName.'('.$fieldValue.')';
211			if (empty($fieldDefault)) {
212			$default = "DEFAULT '0.00'"; // From MySQL 5.7 Manual
213			} else {
214			$default = "DEFAULT '{$fieldDefault}'";
215			}
216			break;
217			case 9:
218			case 10:
219			$fValues = implode("', '", explode(',', str_replace(' ', '', $fieldValue)));
220			$type = $fieldTypeName.'(\''.$fValues.'\')'; // Used with comma separator
221			$default = "DEFAULT '{$fieldDefault}'";
222			break;
223			case 11:
224			$type = $fieldTypeName.'('.$fieldValue.')';
225			if (empty($fieldDefault)) {
226			$default = "DEFAULT '[email protected]'";
227			} else {
228			$default = "DEFAULT '{$fieldDefault}'";
229			}
230			break;
231			case 12:
232			$type = $fieldTypeName.'('.$fieldValue.')';
233			if (empty($fieldDefault)) {
234			$default = "DEFAULT 'http:\\'";
235			} else {
236			$default = "DEFAULT '{$fieldDefault}'";
237			}
238			break;
239			case 13:
240			case 14:
241			$type = $fieldTypeName.'('.$fieldValue.')';
242			$default = "DEFAULT '{$fieldDefault}'";
243			break;
244			case 15:
245			case 16:
246			case 17:
247			case 18:
248			$type = $fieldTypeName;
249			$default = null;
250			break;
251			case 19:
252			case 20:
253			case 21:
254			case 22:
255			$type = $fieldTypeName.'('.$fieldValue.')';
256			$default = "DEFAULT '{$fieldDefault}'";
257			break;
258			case 23:
259			$type = $fieldTypeName;
260			if (empty($fieldDefault)) {
261			$default = "DEFAULT '1970'"; // From MySQL 5.7 Manual
262			} else {
263			$default = "DEFAULT '{$fieldDefault}'";
264			}
265			break;
266			default:
267			$type = $fieldTypeName.'('.$fieldValue.')';
268			$default = "DEFAULT '{$fieldDefault}'";
269			break;
270			}
271			if ((0 == $f) && (1 == $tableAutoincrement)) {
272			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, null, 'AUTO_INCREMENT');
273			$comma[$j] = $this->getKey(2, $fieldName);
274			++$j;
275			} elseif ((0 == $f) && (0 == $tableAutoincrement)) {
276			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
277			$comma[$j] = $this->getKey(2, $fieldName);
278			++$j;
279			} else {
280			if (3 == $fieldKey \|\| 4 == $fieldKey \|\| 5 == $fieldKey \|\| 6 == $fieldKey) {
281			switch ($fieldKey) {
282			case 3:
283			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
284			$comma[$j] = $this->getKey(3, $fieldName);
285			++$j;
286			break;
287			case 4:
288			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
289			$comma[$j] = $this->getKey(4, $fieldName);
290			++$j;
291			break;
292			case 5:
293			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
294			$comma[$j] = $this->getKey(5, $fieldName);
295			++$j;
296			break;
297			case 6:
298			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
299			$comma[$j] = $this->getKey(6, $fieldName);
300			++$j;
301			break;
302			}
303			} else {
304			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
305			}
306			}
307			}
308			}
309			// ================= COMMA ================= //
310			for ($i = 0; $i < $j; ++$i) {
311			if ($i != $j - 1) {
312			$row[] = $comma[$i].',';
313			} else {
314			$row[] = $comma[$i];
315			}
316			}
317			// ================= COMMA CICLE ================= //
318			$ret .= implode("\n", $row);
319			unset($j);
320			$ret .= $this->getFootDatabaseTable();
321
322			return $ret;
323			}
324
325			/**
326			* @private function getFootDatabaseTable
327			*
328			* @param null
329			*
330			* @return string
331			*/
332			private function getFootDatabaseTable()
333			{
334			return "\n) ENGINE=InnoDB;\n\n";
335			}
336
337			/**
338			* @private function getFieldRow
339			*
340			* @param $fieldName
341			* @param $fieldTypeValue
342			* @param $fieldAttribute
343			* @param $fieldNull
344			* @param $fieldDefault
345			* @param $autoincrement
346			*
347			* @return string
348			*/
349			private function getFieldRow($fieldName, $fieldTypeValue, $fieldAttribute = null, $fieldNull = null, $fieldDefault = null, $autoincrement = null)
350			{
351			$retAutoincrement = " `{$fieldName}` {$fieldTypeValue} {$fieldAttribute} {$fieldNull} {$autoincrement},";
352			$retFieldAttribute = " `{$fieldName}` {$fieldTypeValue} {$fieldAttribute} {$fieldNull} {$fieldDefault},";
353			$fieldDefault = " `{$fieldName}` {$fieldTypeValue} {$fieldNull} {$fieldDefault},";
354			$retShort = " `{$fieldName}` {$fieldTypeValue},";
355
356			$ret = $retShort;
357			if (null != $autoincrement) {
358			$ret = $retAutoincrement;
359			} elseif (null != $fieldAttribute) {
360			$ret = $retFieldAttribute;
361			} elseif (null === $fieldAttribute) {
362			$ret = $fieldDefault;
363			}
364
365			return $ret;
366			}
367
368			/**
369			* @private function getKey
370			*
371			* @param $key
372			* @param $fieldName
373			* @return string
374			*/
375			private function getKey($key, $fieldName)
376			{
377			$ret = null;
378			switch ($key) {
379			case 2: // PRIMARY KEY
380			$ret = " PRIMARY KEY (`{$fieldName}`)";
381			break;
382			case 3: // UNIQUE KEY
383			$ret = " UNIQUE KEY `{$fieldName}` (`{$fieldName}`)";
384			break;
385			case 4: // KEY
386			$ret = " KEY `{$fieldName}` (`{$fieldName}`)";
387			break;
388			case 5: // INDEX
389			$ret = " INDEX (`{$fieldName}`)";
390			break;
391			case 6: // FULLTEXT KEY
392			$ret = " FULLTEXT KEY `{$fieldName}` (`{$fieldName}`)";
393			break;
394			}
395
396			return $ret;
397			}
398
399			/**
400			* @private function getComma
401			*
402			* @param $row
403			* @param $comma
404			*
405			* @return string
406			*/
407			private function getComma($row, $comma = null)
408			{
409			return " {$row}{$comma}";
410			}
411
412			/**
413			* @private function getCommaCicle
414			*
415			* @param $comma
416			* @param $index
417			*
418			* @return string
419			*/
420			private function getCommaCicle($comma, $index)
			0 ignored issues – show Unused Code introduced 2018-03-02 13:49 UTC by Report Bug Copy Issue Report The method `getCommaCicle()` is not used, and could be removed. This check looks for private methods that have been defined, but are not used inside the class. Loading history...
421			{
422			$ret = null;
423			// Comma issue
424			for ($i = 1; $i <= $index; ++$i) {
425			if ($i != $index - 1) {
426			$ret = $this->getComma(isset($comma[$i]), ',')."\n";
427			} else {
428			$ret = $this->getComma(isset($comma[$i]))."\n";
429			}
430			}
431
432			return $ret;
433			}
434
435			/**
436			* @public function render
437			*
438			* @param null
439			*
440			* @return bool\|string
441			*/
442			public function render()
443			{
444			$module = $this->getModule();
445			$filename = $this->getFileName();
446			$moduleName = strtolower($module->getVar('mod_name'));
447			$moduleDirname = strtolower($module->getVar('mod_dirname'));
448			$content = $this->getHeaderSqlComments($moduleName);
449			$content .= $this->getDatabaseTables($module);
450
451			$this->create($moduleDirname, 'sql', $filename, $content, _AM_TDMCREATE_FILE_CREATED, _AM_TDMCREATE_FILE_NOTCREATED);
452
453			return $this->renderFile();
454			}
455			}
456

txmodxoops / tdmcreate

Branch — master (38ab27)

SqlFile::getDatabaseFields() F

Complexity

Size

Duplication

Importance

How to fix Long Method Complexity

Long Method

Duplication Side-by-Side

Filter issues like