/** * function __renderSenchaFieldSyntax($tableColumn): * Method to render and return the syntax for the Sencha Model fields */ public function __renderSenchaFieldSyntax($tableColumn) { $SenchaField = ''; switch (strtoupper(strstr($tableColumn['Type'], '(', true))) { case 'BIT': case 'TINYINT': case 'SMALLINT': case 'MEDIUMINT': case 'INT': case 'INTEGER': case 'BIGINT': $SenchaType = 'int'; break; case 'REAL': case 'DOUBLE': case 'FLOAT': case 'DECIMAL': case 'NUMERIC': $SenchaType = 'float'; break; case 'DATE': case 'TIME': case 'TIMESTAMP': case 'DATETIME': case 'YEAR': $SenchaType = 'date'; break; case 'CHAR': case 'VARCHAR': $SenchaType = 'string'; break; default: $SenchaType = 'auto'; } $SenchaField .= MatchaUtils::t(1) . "{name: '" . $tableColumn['Field'] . "', type: '" . $SenchaType . "'},"; return $SenchaField; }