gitlabFork/ISPConfig3.git - Solinfo Gitblit

- MySQL table generator: default value of text fields must be NULL, not 'NU...

Falko Timme

2014-08-28 c505a8e45a82ed8673c64a27fde30890a39849e4

commit \| author \| age
836f83	1	<?php
T	2
	3	/*
	4	Copyright (c) 2007, Till Brehm, projektfarm Gmbh
	5	All rights reserved.
	6
	7	Redistribution and use in source and binary forms, with or without modification,
	8	are permitted provided that the following conditions are met:
	9
	10	* Redistributions of source code must retain the above copyright notice,
	11	this list of conditions and the following disclaimer.
	12	* Redistributions in binary form must reproduce the above copyright notice,
	13	this list of conditions and the following disclaimer in the documentation
	14	and/or other materials provided with the distribution.
	15	* Neither the name of ISPConfig nor the names of its contributors
	16	may be used to endorse or promote products derived from this software without
	17	specific prior written permission.
	18
	19	THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
	20	ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
	21	WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
	22	IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
	23	INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
	24	BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
	25	DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
	26	OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
	27	NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
	28	EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
	29	*/
	30
	31	class tform_tpl_generator {
7fe908	32
MC	33	function buildHTML($formDef, $tab) {
	34
836f83	35	global $app;
7fe908	36
836f83	37	$module = $_SESSION["s"]["module"]["name"];
7fe908	38
836f83	39	$html = '<h2><tmpl_var name="list_head_txt"></h2>
T	40	<p><tmpl_var name="list_desc_txt"></p>
	41
	42	<div class="panel panel_'.$formDef['name'].'">
	43
	44	<div class="pnl_formsarea">
	45	<fieldset class="inlineLabels"><legend>'.$formDef['tabs'][$tab]['title'].'</legend>';
	46
	47	$lang = array();
	48	$html_reqestedelement = "<em>*</em> ";
	49
	50	foreach($formDef['tabs'][$tab]['fields'] as $key => $field) {
	51	if ($field['required'] == true ) { $html_reqcode = $html_reqestedelement; } else { $html_reqcode = ''; }
	52
	53	switch ($field['formtype']) {
7fe908	54	case 'TEXT':
MC	55	$html .= "
836f83	56	<div class=\"ctrlHolder\">
T	57	<label for=\"".$key."\">".$html_reqcode."{tmpl_var name='".$key."_txt'}</label>
	58	<input name=\"".$key."\" id=\"".$key."\" value=\"{tmpl_var name='".$key."'}\" size=\"".$field['width']."\" maxlength=\"".$field['maxlength']."\" type=\"text\" class=\"textInput\" />
	59	</div>";
	60	break;
7fe908	61	case 'TEXTAREA':
MC	62	$html .= "
836f83	63	<div class=\"ctrlHolder\">
T	64	<label for=\"".$key."\">".$html_reqcode."{tmpl_var name='".$key."_txt'}</label>
	65	<textarea name=\"".$key."\" id=\"".$key."\" rows='".$field['rows']."' cols='".$field['cols']."'>{tmpl_var name='".$key."'}</textarea>
	66	</div>";
	67	break;
7fe908	68	case 'SELECT':
MC	69	$html .= "
836f83	70	<div class=\"ctrlHolder\">
T	71	<label for=\"".$key."\">".$html_reqcode."{tmpl_var name='".$key."_txt'}</label>
	72	<select name=\"".$key."\" id=\"".$key."\" class=\"selectInput\">
	73	{tmpl_var name='".$key."'}
	74	</select>
	75	</div>";
	76	break;
7fe908	77	case 'MULTIPLE':
MC	78	$html .= "
836f83	79	<div class=\"ctrlHolder\">
T	80	<label for=\"".$key."\">".$html_reqcode."{tmpl_var name='".$key."_txt'}</label>
	81	<select multiple name=\"".$key."\" id=\"".$key."\" class=\"selectInput\">
	82	{tmpl_var name='".$key."'}
	83	</select>
	84	</div>";
	85	break;
7fe908	86	case 'PASSWORD':
MC	87	$html .= "
836f83	88	<div class=\"ctrlHolder\">
T	89	<label for=\"".$key."\">".$html_reqcode."{tmpl_var name='".$key."_txt'}</label>
	90	<input name=\"".$key."\" id=\"".$key."\" value=\"{tmpl_var name='".$key."'}\" size=\"".$field['width']."\" maxlength=\"".$field['maxlength']."\" type=\"password\" class=\"textInput\" />
	91	</div>";
	92	break;
7fe908	93	case 'CHECKBOX':
MC	94	$html .= "
836f83	95	<div class=\"ctrlHolder\">
T	96	<p class=\"label\">".$html_reqcode."{tmpl_var name='".$key."_txt'}</p>
	97	<div class=\"multiField\">
	98	{tmpl_var name='".$key."'}
	99	</div>
	100	</div>";
	101	break;
7fe908	102	case 'CHECKBOXARRAY':
MC	103	$html .= "
836f83	104	<div class=\"ctrlHolder\">
T	105	<p class=\"label\">".$html_reqcode."{tmpl_var name='".$key."_txt'}</p>
	106	<div class=\"multiField\">
	107	{tmpl_var name='".$key."'}
	108	</div>
	109	</div>";
	110	break;
7fe908	111	case 'RADIO':
MC	112	$html .= "
836f83	113	<div class=\"ctrlHolder\">
T	114	<p class=\"label\">".$html_reqcode."{tmpl_var name='".$key."_txt'}</p>
	115	<div class=\"multiField\">
	116	{tmpl_var name='".$key."'}
	117	</div>
	118	</div>";
	119	break;
	120	}
7fe908	121
a9d0b2	122	// Language File Eintrag für "Feld-Titel" anlegen
836f83	123	$lang[$key."_txt"] = $key;
7fe908	124
a9d0b2	125	// language File Eintrag, für error-Text anlegen
836f83	126	if(isset($field["errmsg"]) && $field["errmsg"] != '') {
T	127	$errmsg = $field["errmsg"];
	128	$lang[$errmsg] = $errmsg;
	129	}
7fe908	130
836f83	131	}
7fe908	132
836f83	133	$html .= "
T	134	</fieldset>
	135
	136	<input type=\"hidden\" name=\"id\" value=\"{tmpl_var name='id'}\">
	137
	138	<div class=\"buttonHolder buttons\">
e27086	139	<button class=\"positive iconstxt icoPositive\" type=\"button\" value=\"{tmpl_var name='btn_save_txt'}\" onclick=\"submitForm('pageForm','".$module."/".$formDef["action"]."');\"><span>{tmpl_var name='btn_save_txt'}</span></button>
M	140	<button class=\"negative iconstxt icoNegative\" type=\"button\" value=\"{tmpl_var name='btn_cancel_txt'}\" onclick=\"loadContent('".$module."/".$formDef["list_default"]."');\"><span>{tmpl_var name='btn_cancel_txt'}</span></button>
836f83	141	</div>
T	142	</div>
7fe908	143
836f83	144	</div>
T	145	";
	146
7fe908	147
836f83	148	// speichere Template
7fe908	149	if (!$handle = fopen($formDef['tabs'][$tab]['template'], 'w')) {
MC	150	print "Cannot open file (".$formDef['tabs'][$tab]['template'].")";
	151	exit;
	152	}
	153
	154	if (!fwrite($handle, $html)) {
	155	print "Cannot write to file ($filename)";
	156	exit;
836f83	157	}
T	158	fclose($handle);
7fe908	159
MC	160	$this->lng_add($lang, $formDef);
	161
a9d0b2	162	// überprüfe, ob es die Tabelle schon gibt,
836f83	163	// ansonsten wird sie angelegt
T	164	$tables = $app->db->getTables();
7fe908	165
MC	166	if(!@in_array($formDef['db_table'], $tables)) {
836f83	167	// Datenbank noch nicht vorhanden
7fe908	168
836f83	169	$columns = array();
7fe908	170
a9d0b2	171	// füge ID Feld hinzu
7fe908	172	$col = array( 'action' => 'add',
MC	173	'name' => $formDef["db_table_idx"],
	174	'type' => 'int64',
	175	'typeValue' => '',
	176	'defaultValue' => false,
	177	'notNull' => true,
	178	'autoInc' => true,
	179	'option' => 'primary'
	180	);
	181
836f83	182	$columns[] = $col;
T	183	$app->db->show_error_messages = true;
7fe908	184
836f83	185	if($formDef["auth"] == 'yes') {
7fe908	186
MC	187	$col = array( 'action' => 'add',
	188	'name' => 'sys_userid',
	189	'type' => 'int32',
	190	'typeValue' => '',
	191	'defaultValue' => '0',
	192	'notNull' => true
	193	);
836f83	194	$columns[] = $col;
7fe908	195	$col = array( 'action' => 'add',
MC	196	'name' => 'sys_groupid',
	197	'type' => 'int32',
	198	'typeValue' => '',
	199	'defaultValue' => '0',
	200	'notNull' => true
	201	);
836f83	202	$columns[] = $col;
7fe908	203	$col = array( 'action' => 'add',
MC	204	'name' => 'sys_perm_user',
	205	'type' => 'varchar',
	206	'typeValue' => '5',
	207	'defaultValue' => 'NULL',
	208	'notNull' => true
	209	);
836f83	210	$columns[] = $col;
7fe908	211	$col = array( 'action' => 'add',
MC	212	'name' => 'sys_perm_group',
	213	'type' => 'varchar',
	214	'typeValue' => '5',
	215	'defaultValue' => 'NULL',
	216	'notNull' => true
	217	);
836f83	218	$columns[] = $col;
7fe908	219	$col = array( 'action' => 'add',
MC	220	'name' => 'sys_perm_other',
	221	'type' => 'varchar',
	222	'typeValue' => '5',
	223	'defaultValue' => 'NULL',
	224	'notNull' => true
	225	);
836f83	226	$columns[] = $col;
7fe908	227
836f83	228	}
7fe908	229
MC	230
836f83	231	foreach($formDef['tabs'] as $tab) {
T	232	foreach($tab["fields"] as $name => $field) {
	233	/*
	234	$columns = array(action => add \| alter \| drop
	235	name => Spaltenname
	236	name_new => neuer Spaltenname, nur bei 'alter' belegt
	237	type => 42go-Meta-Type: int16, int32, int64, double, char, varchar, text, blob
	238	typeValue => Wert z.B. bei Varchar
	239	defaultValue => Default Wert
	240	notNull => true \| false
	241	autoInc => true \| false
	242	option => unique \| primary \| index)
7fe908	243
MC	244
836f83	245	*/
T	246	switch ($field["datatype"]) {
7fe908	247	case 'INTEGER':
MC	248	$type = 'int32';
	249	$typevalue = '';
	250	$defaultValue = ($field["default"] != '')?$field["default"]:'0';
836f83	251	break;
7fe908	252	case 'DOUBLE':
MC	253	$type = 'double';
	254	$typevalue = '';
	255	$defaultValue = ($field["default"] != '')?$field["default"]:'0';
836f83	256	break;
7fe908	257	case 'CURRENCY':
MC	258	$type = 'double';
	259	$typevalue = '';
	260	$defaultValue = ($field["default"] != '')?$field["default"]:'0';
836f83	261	break;
7fe908	262	case 'VARCHAR':
MC	263	$type = 'varchar';
	264	$typeValue = ($field["maxlength"] > 0 and $field["maxlength"] <= 256)?$field["maxlength"]:255;
	265	// $defaultValue = ($field["default"] != '')?$field["default"]:'NOT NULL';
	266	$defaultValue = ($field["default"] != '')?$field["default"]:'NULL';
836f83	267	break;
7fe908	268	case 'TEXT':
MC	269	$type = 'text';
	270	$typevalue = '';
c505a8	271	$defaultValue = NULL;
836f83	272	break;
7fe908	273	case 'DATE':
8748b3	274	$type = 'date';
7fe908	275	$typevalue = '';
8748b3	276	$defaultValue = ($field["default"] != '')?$field["default"]:'0000-00-00';
836f83	277	break;
T	278	}
7fe908	279
MC	280
	281	$col = array( 'action' => 'add',
	282	'name' => $name,
	283	'type' => $type,
	284	'typeValue' => $typeValue,
	285	'defaultValue' => $defaultValue,
	286	'notNull' => true
	287	);
	288
836f83	289	$columns[] = $col;
T	290	}
	291	}
7fe908	292
MC	293	$app->db->createTable($formDef["db_table"], $columns);
	294
836f83	295	}
9ac2fa	296	}
7fe908	297
MC	298	function lng_add($lang, $formDef) {
	299	global $go_api, $go_info, $conf;
	300
836f83	301	$lng_file = "lib/lang/".$conf["language"]."_".$formDef['name'].".lng";
T	302	if(is_file($lng_file)) {
7fe908	303	include $lng_file;
836f83	304	} else {
T	305	$wb = array();
	306	}
7fe908	307
MC	308	$wb_out = array_merge($lang, $wb);
	309
836f83	310	if(is_array($wb_out)) {
7fe908	311	$fp = fopen($lng_file, "w");
MC	312	fwrite($fp, "<?php\n");
836f83	313	foreach($wb_out as $key => $val) {
28d1b5	314	$new_line = '$wb["'.$key.'"] = '."'$val';\n";
7fe908	315	fwrite($fp, $new_line);
MC	316
836f83	317	}
7fe908	318	fwrite($fp, "?>");
836f83	319	fclose($fp);
T	320	}
	321	}
7fe908	322
836f83	323	}
T	324
7fe908	325	?>