From 25ece9c51091bf98f06a4578deb2175e6dfb1112 Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Thu, 22 Feb 2007 07:39:22 -0500 Subject: [PATCH] Updated several base libraries and added advanced search functionality. --- interface/lib/classes/tform_tpl_generator.inc.php | 57 ++++++++++++++++++++++++++++++++------------------------- 1 files changed, 32 insertions(+), 25 deletions(-) diff --git a/interface/lib/classes/tform_tpl_generator.inc.php b/interface/lib/classes/tform_tpl_generator.inc.php index 1a78288..dcc92ff 100644 --- a/interface/lib/classes/tform_tpl_generator.inc.php +++ b/interface/lib/classes/tform_tpl_generator.inc.php @@ -43,22 +43,22 @@ case 'TEXT': $html .= " <tr> - <td width=\"126\" class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> - <td width=\"366\" class=\"frmText11\"><input name=\"".$key."\" type=\"text\" class=\"text\" value=\"{tmpl_var name='".$key."'}\" size=\"".$field['width']."\" maxlength=\"".$field['maxlength']."\"></td> + <td class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> + <td class=\"frmText11\"><input name=\"".$key."\" type=\"text\" class=\"text\" value=\"{tmpl_var name='".$key."'}\" size=\"".$field['width']."\" maxlength=\"".$field['maxlength']."\"></td> </tr>"; break; case 'TEXTAREA': $html .= " <tr> - <td width=\"126\" class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> - <td width=\"366\" class=\"frmText11\"><textarea name='$key' cols='".$field['cols']."' rows='".$field['rows']."'>{tmpl_var name='".$key."'}</textarea></td> + <td class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> + <td class=\"frmText11\"><textarea name='$key' cols='".$field['cols']."' rows='".$field['rows']."'>{tmpl_var name='".$key."'}</textarea></td> </tr>"; break; case 'SELECT': $html .= " <tr> - <td width=\"126\" class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> - <td width=\"366\" class=\"frmText11\"> + <td class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> + <td class=\"frmText11\"> <select name=\"".$key."\" class=\"text\"> {tmpl_var name='".$key."'} </select> @@ -68,8 +68,8 @@ case 'MULTIPLE': $html .= " <tr> - <td width=\"126\" class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> - <td width=\"366\" class=\"frmText11\"> + <td class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> + <td class=\"frmText11\"> <select name=\"".$key."\" class=\"text\" size=\"".$field['rows']."\" multiple> {tmpl_var name='".$key."'} </select> @@ -79,29 +79,29 @@ case 'PASSWORD': $html .= " <tr> - <td width=\"126\" class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> - <td width=\"366\" class=\"frmText11\"><input name=\"".$key."\" type=\"password\" class=\"text\" value=\"{tmpl_var name='".$key."'}\" size=\"".$field['width']."\" maxlength=\"".$field['maxlength']."\"></td> + <td class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> + <td class=\"frmText11\"><input name=\"".$key."\" type=\"password\" class=\"text\" value=\"{tmpl_var name='".$key."'}\" size=\"".$field['width']."\" maxlength=\"".$field['maxlength']."\"></td> </tr>"; break; case 'CHECKBOX': $html .= " <tr> - <td width=\"126\" class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> - <td width=\"366\" class=\"frmText11\">{tmpl_var name='".$key."'}</td> + <td class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> + <td class=\"frmText11\">{tmpl_var name='".$key."'}</td> </tr>"; break; case 'CHECKBOXARRAY': $html .= " <tr> - <td width=\"126\" class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> - <td width=\"366\" class=\"frmText11\">{tmpl_var name='".$key."'}</td> + <td class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> + <td class=\"frmText11\">{tmpl_var name='".$key."'}</td> </tr>"; break; case 'RADIO': $html .= " <tr> - <td width=\"126\" class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> - <td width=\"366\" class=\"frmText11\">{tmpl_var name='".$key."'}</td> + <td class=\"frmText11\">{tmpl_var name='".$key."_txt'}:</td> + <td class=\"frmText11\">{tmpl_var name='".$key."'}</td> </tr>"; break; } @@ -163,7 +163,7 @@ 'name' => $formDef["db_table_idx"], 'type' => 'int64', 'typeValue' => '', - 'defaultValue' => '', + 'defaultValue' => false, 'notNull' => true, 'autoInc' => true, 'option' => 'primary' @@ -178,7 +178,7 @@ 'name' => 'sys_userid', 'type' => 'int32', 'typeValue' => '', - 'defaultValue' => '', + 'defaultValue' => '0', 'notNull' => true ); $columns[] = $col; @@ -186,7 +186,7 @@ 'name' => 'sys_groupid', 'type' => 'int32', 'typeValue' => '', - 'defaultValue' => '', + 'defaultValue' => '0', 'notNull' => true ); $columns[] = $col; @@ -194,7 +194,7 @@ 'name' => 'sys_perm_user', 'type' => 'varchar', 'typeValue' => '5', - 'defaultValue' => '', + 'defaultValue' => 'NULL', 'notNull' => true ); $columns[] = $col; @@ -202,7 +202,7 @@ 'name' => 'sys_perm_group', 'type' => 'varchar', 'typeValue' => '5', - 'defaultValue' => '', + 'defaultValue' => 'NULL', 'notNull' => true ); $columns[] = $col; @@ -210,7 +210,7 @@ 'name' => 'sys_perm_other', 'type' => 'varchar', 'typeValue' => '5', - 'defaultValue' => '', + 'defaultValue' => 'NULL', 'notNull' => true ); $columns[] = $col; @@ -237,26 +237,33 @@ case 'INTEGER': $type = 'int32'; $typevalue = ''; + $defaultValue = ($field["default"] != '')?$field["default"]:'0'; break; case 'DOUBLE': $type = 'double'; $typevalue = ''; + $defaultValue = ($field["default"] != '')?$field["default"]:'0'; break; case 'CURRENCY': $type = 'double'; $typevalue = ''; + $defaultValue = ($field["default"] != '')?$field["default"]:'0'; break; case 'VARCHAR': $type = 'varchar'; $typeValue = ($field["maxlength"] > 0 and $field["maxlength"] <= 256)?$field["maxlength"]:255; + // $defaultValue = ($field["default"] != '')?$field["default"]:'NOT NULL'; + $defaultValue = ($field["default"] != '')?$field["default"]:'NULL'; break; case 'TEXT': $type = 'text'; $typevalue = ''; + $defaultValue = 'NULL'; break; case 'DATE': $type = 'int64'; $typevalue = ''; + $defaultValue = ($field["default"] != '')?$field["default"]:'0'; break; } @@ -265,7 +272,7 @@ 'name' => $name, 'type' => $type, 'typeValue' => $typeValue, - 'defaultValue' => $field["default"], + 'defaultValue' => $defaultValue, 'notNull' => true ); @@ -279,9 +286,9 @@ } function lng_add($lang,$formDef) { - global $go_api, $go_info; + global $go_api, $go_info,$conf; - $lng_file = "lib/lang/en_".$formDef['name'].".lng"; + $lng_file = "lib/lang/".$conf["language"]."_".$formDef['name'].".lng"; if(is_file($lng_file)) { include($lng_file); } else { -- Gitblit v1.9.1