function table_infor() { global $sectionArray, $file_ini, $columns, $Tablename, $_GET, $GlobalModel; print "<TR><TD class=TableContent align=left width=25% colSpan=2>\n"; print $GlobalModel; print "<table border=1 cellspacing=0 class=small bordercolor=#000000 cellpadding=3 align=center width=100% style=\"border-collapse:collapse\">\n"; print "<TR><TD class=TableContent align=left colSpan=4> 类型属性明细 <font color=green>INIT视图时主KEY字段不可取,可能在表主KEY中设定 add,edit,view也不能选取,只能在表主KEY中设定</font>\n\t</TD></TR>"; //字段表头信息 print "<TR>"; print "<TD class=TableContent align=left colSpan=1> 属性名称</TD>\n"; print "<TD class=TableContent align=left colSpan=1> 是否启用</TD>\n"; $GlobalModel == "init" ? print "<TD class=TableContent align=left colSpan=1> 搜索选项</TD>\n" : ''; $GlobalModel == "init" ? print "<TD class=TableContent align=left colSpan=1> 高级搜索</TD>\n" : ''; $GlobalModel == "init" ? print "<TD class=TableContent align=left colSpan=1> 分组信息</TD>\n" : ''; $GlobalModel == "statistics" ? print "<TD class=TableContent align=left colSpan=1> 图表类型</TD>\n" : ''; $ModelArray = array("add", "edit"); in_array($GlobalModel, $ModelArray) ? print "<TD class=TableContent align=left colSpan=1> 是否空值</TD>\n" : ''; print "<TD class=TableContent align=left colSpan=1> 字段排序/可写权限</TD>\n"; print "<TD class=TableContent align=left colSpan=1> 字段属性</TD>\n"; if ($GlobalModel == "init") { $showlistfieldstopedit = $sectionArray['showlistfieldstopedit']; $showlistfieldstopeditArray = explode(',', $showlistfieldstopedit); $showlistfieldstopdelete = $sectionArray['showlistfieldstopdelete']; $showlistfieldstopdeleteArray = explode(',', $showlistfieldstopdelete); print "<TD class=TableContent align=left colSpan=1> 高级功能<BR> 当字段等于什么值时禁用编辑或删除</TD>\n"; } print "</TR>"; $showlistfieldlist = $sectionArray['showlistfieldlist']; $showlistfieldlistArray = explode(',', $showlistfieldlist); $listKeys = array_keys($showlistfieldlistArray); $listValues = array_values($showlistfieldlistArray); $list_keys_values = array_keys_values($showlistfieldlistArray); //$showlistfieldlistArrayReverse = array_reverse($showlistfieldlistArray); //print_R($showlistfieldlistArrayReverse); //字段空值表 $showlistnull = $sectionArray['showlistnull']; $showlistnullArray = explode(',', $showlistnull); //字段过滤表 $showlistfieldfilter = $sectionArray['showlistfieldfilter']; $showlistfieldfilterArray = explode(',', $showlistfieldfilter); //字段过滤表 $showlistfieldtype = $sectionArray['showlistfieldtype']; $showlistfieldtypeArray = explode(',', $showlistfieldtype); //字段可写权限 $showlistfieldprivate = $sectionArray['showlistfieldprivate']; $showlistfieldprivateArray = explode(',', $showlistfieldprivate); $Tablename = $_GET['Tablename']; //空值信息设定 $radio_array = array("空值" => "null", "非空" => "notnull"); //统计图表类型设定 $radio_statistics = array("饼图" => "pieF", "横柱图" => "hBarF", "竖柱图" => "vBarF"); //统计区为可选项条件性判断 $FILTER_ARRAY = array("tablefilter", "tablefiltercolor", "radiofilter"); //字段启用设定 $radio_boolean = array("开" => "1", "关" => "0"); //搜索信息设定 $action_search = $sectionArray['action_search']; $action_searchArray = array(); if ($action_search != "") { $action_searchArray = explode(',', $action_search); } $radio_search = array("搜索" => "1", "禁用" => "0"); //print_R($file_ini); //高级搜索设定 $exportadv_default_section = $file_ini['exportadv_default']; $showlistfieldlist_section = $exportadv_default_section['showlistfieldlist']; $showlistfieldfilter_section = $exportadv_default_section['showlistfieldfilter']; $action_search_advArray = explode(',', $showlistfieldlist_section); $radio_search_adv = array("高级搜索" => "1", "禁用" => "0"); //分组信息设定 $group_filter = $sectionArray['group_filter']; if ($group_filter != "") { $group_filterArray = explode(',', $group_filter); } $newGroupArray = array(); $IsGroupArrayHidden = array(); for ($i = 0; $i < sizeof($group_filterArray); $i++) { $tempArray = explode(":", $group_filterArray[$i]); $tempArray_INDEX = $tempArray[0]; if ($tempArray_INDEX != "") { if ($tempArray[4] == "") { $GroupFilterArrayADD[$tempArray_INDEX] = $tempArray[1] . ":" . $tempArray[2] . ":" . $tempArray[3]; } else { $GroupFilterArrayADD[$tempArray_INDEX] = $tempArray[1] . ":" . $tempArray[2] . ":" . $tempArray[3] . ":" . $tempArray[4]; } } //print_R($tempArray); if (isset($tempArray[0])) { array_push($newGroupArray, $tempArray[0]); } if (isset($tempArray[4])) { array_push($IsGroupArrayHidden, $tempArray[0]); } //print_R($newGroupArray); } $radio_group = array("分组" => "1", "禁用" => "0"); //print_R($newGroupArray); //权限部门供述 print "<input type=hidden name=departprivte value=" . $sectionArray['departprivte'] . ">"; //字段信息设定 global $html_etc; for ($i = 0; $i < sizeof($columns); $i++) { $columnName = $columns[$i]; $indexName = $html_etc[$Tablename][$columnName]; $listIndex = $list_keys_values[$i]; $nullIndex = $showlistnullArray[$listIndex]; $filterIndex = $showlistfieldfilterArray[$listIndex]; $StopEditIndex = $showlistfieldstopeditArray[$listIndex]; $StopDeleteIndex = $showlistfieldstopdeleteArray[$listIndex]; $typeIndex = $showlistfieldtypeArray[$listIndex]; $privateIndex = $showlistfieldprivateArray[$listIndex]; print "<TR><TD class=TableContent align=left colSpan=1 nowrap>"; print $i . "." . $indexName . "[" . $columnName . "]"; print "</TD><TD class=TableContent align=left colSpan=1 nowrap>\n"; //select_array($array,$columnName,$columnValue); //print "<input type=text name=".$columnName."_list class=SmallInput size=15 value=".$columnName.">"; if (in_array($i, $showlistfieldlistArray)) { $boolean = 1; $readonly = ""; $inputClass = "SmallInput"; } else { $boolean = 0; $readonly = ""; $inputClass = "SmallStatic"; } //print_R($action_search_advArray); if (in_array($i, $action_searchArray) && $boolean == 1) { $boolean_search = 1; } else { $boolean_search = 0; } if (in_array($i, $action_search_advArray) && $boolean == 1) { $boolean_search_adv = 1; } else { $boolean_search_adv = 0; } //print_R($newGroupArray); if (in_array($i, $newGroupArray, false) && $boolean == 1) { $boolean_group = 1; } else { $boolean_group = 0; } //print_R($IsGroupArrayHidden); if (in_array($i, $IsGroupArrayHidden) && $boolean == 1) { $boolean_hidden = 1; } else { $boolean_hidden = 0; } //统计字段开启数据初始化组 $filterIndexArray = explode(':', $filterIndex); if ($GlobalModel == "statistics") { if (in_array($filterIndexArray[0], $FILTER_ARRAY)) { $boolean = 1; } else { $boolean = 0; } } //字段开启信息 //radio_array($radio_boolean,$columnName."_boolean",$boolean,"onclick",$i); if ($boolean) { $boolean_checked_boolean = "checked"; } else { $boolean_checked_boolean = ''; } print "<input type=checkbox name=" . $columnName . "_boolean {$boolean_checked_boolean}/> <font color=green>启用</font>"; //构建Radio函数 print "<script>\n"; print "function onClickUser_" . $i . "_1()\t{\n"; if ($GlobalModel == "add" || $GlobalModel == "edit") { print "\tdocument.form1." . $columnName . "_null.disabled = true;\n"; } //空值判断 //if($GlobalModel=="add"||$GlobalModel=="edit") { print "\tdocument.form1." . $columnName . "_filter.disabled = true;\n"; //}//过滤判断 //if($GlobalModel=="add"||$GlobalModel=="edit") { print "\tdocument.form1." . $columnName . "_select.disabled = true;\n"; //}// if ($GlobalModel == "init") { print "\tdocument.form1." . $columnName . "_search.disabled = true;\n"; print "\tdocument.form1." . $columnName . "_group.disabled = true;\n"; } print "}\n"; print "function onClickUser_" . $i . "_0()\t{\n"; if ($GlobalModel == "add" || $GlobalModel == "edit") { print "\tdocument.form1." . $columnName . "_null.disabled = false;\n"; } //if($GlobalModel=="add"||$GlobalModel=="edit") { print "\tdocument.form1." . $columnName . "_filter.disabled = false;\n"; //} //if($GlobalModel=="add"||$GlobalModel=="edit") { print "\tdocument.form1." . $columnName . "_select.disabled = false;\n"; //} if ($GlobalModel == "init") { print "\tdocument.form1." . $columnName . "_search.disabled = false;\n"; print "\tdocument.form1." . $columnName . "_group.disabled = false;\n"; } print "}\n"; print "</script>\n"; print "</TD>\n"; //搜索信息设定 if ($GlobalModel == "init") { print "<TD class=TableContent align=left colSpan=1 nowrap>\n"; //radio_array($radio_search,$columnName."_search",$boolean_search); if ($boolean_search) { $boolean_checked_search = "checked"; } else { $boolean_checked_search = ''; } print "<input type=checkbox name=" . $columnName . "_search {$boolean_checked_search}/> <font color=green>搜索</font>"; print "</TD>\n"; } //高级搜索设定 if ($GlobalModel == "init") { print "<TD class=TableContent align=left colSpan=1 nowrap>\n"; //radio_array($radio_search,$columnName."_search",$boolean_search); print $boolean_search_adv; if ($boolean_search_adv && $i > 0) { $boolean_checked_search_adv = "checked"; } else { $boolean_checked_search_adv = ''; } print "<input type=checkbox name=" . $columnName . "_search_adv {$boolean_checked_search_adv}/> <font color=gray>高级搜索</font>"; print "</TD>\n"; } //分组信息设定 if ($GlobalModel == "init") { //print_R($boolean_group); print "<TD class=TableContent align=left colSpan=1 nowrap>\n"; //radio_array($radio_group,$columnName."_group",$boolean_group); if ($boolean_group && $i > 0) { $boolean_checked_group = "checked"; } else { $boolean_checked_group = ''; } print "<input type=checkbox name=" . $columnName . "_group {$boolean_checked_group}/> <font color=red>分组</font>"; if ($boolean_hidden == 1 && $i > 0) { $boolean_checked_hidden = "checked"; } else { $boolean_checked_hidden = ''; } //print_R($filterIndexArray); if ($filterIndexArray[0] == "userdefine" && $i > 0) { $分组是否被重定义 = ""; } else { $分组是否被重定义 = ""; } //print_R($GroupFilterArrayADD); if ($GroupFilterArrayADD[$i] != "" && $i > 0) { $GROUP_FILTER_TEXT = $GroupFilterArrayADD[$i]; } else { $GROUP_FILTER_TEXT = ""; } print "<input type=checkbox name=" . $columnName . "_hidden {$boolean_checked_hidden}/> <font color=green title='{$GROUP_FILTER_TEXT}'>隐藏{$GROUP_FILTER_TEXT}</font>"; print "<input type=hidden name=" . $columnName . "_hidden_group_filter value='{$GROUP_FILTER_TEXT}'/>"; print "</TD>\n"; } //统计信息设定 if ($GlobalModel == "statistics" && $i > 0) { print "<TD class=TableContent align=left colSpan=1 nowrap>\n"; //if(in_array($filterIndexArray[0],$FILTER_ARRAY)) { radio_array($radio_statistics, $columnName . "_type", $typeIndex); //} print "</TD>\n"; } //空值信息设定 限定此信息是否显示。 if ($nullIndex == "notnull") { $NullValue = 1; } else { $NullValue = 0; } $ModelArray = array("add", "edit"); if ($GlobalModel == "add" || $GlobalModel == "edit") { print "<TD class=TableContent align=left colSpan=1 nowrap>\n"; Checkbox_One("不允许空值", $columnName . "_null", $NullValue, $boolean); print "</TD>"; } //字段排序 print "<TD class=TableContent align=left colSpan=1 nowrap>\n"; print "<input type=text name=" . $columnName . "_Order class={$inputClass} size=5 value=" . $list_keys_values[$i] . "> "; if ($GlobalModel == "add" || $GlobalModel == "edit") { //可写权限 print "<input type=text name=" . $columnName . "_private class={$inputClass} size=5 value=" . $privateIndex . "> "; } print "</td>"; //空值信息限制信息结束 print "<TD class=TableContent align=left colSpan=1 nowrap>\n"; print "<input type=text name=" . $columnName . "_filter {$readonly} class={$inputClass} size=20 value=" . $filterIndex . "> "; global $SYSTEM_MODE_DIR; print "\n\t\t<script Language=\"JavaScript\">\n\t\tfunction LoadWindow_{$columnName}()\n\t\t{\n\t\t\tURL=\"LoadWindowsFrame.php?action=Detail&parentName=" . $columnName . "_filter§ionName=input&SYSTEM_MODE=" . $SYSTEM_MODE_DIR . "\";\n\t\t\tloc_x=250;\n\t\t\tloc_y=150;\n \t\t\twindow.showModalDialog(URL,self,\"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:570px;dialogHeight:550px;dialogTop:\"+loc_y+\"px;dialogLeft:\"+loc_x+\"px\");\n\t\t}\n\t\t</script>\n\t\t\t"; print "<input type=button name = " . $columnName . "_select onclick='LoadWindow_{$columnName}();' class=SmallButton value=选择>"; print "</td>"; if ($GlobalModel == "init") { print "<TD class=TableContent align=left nowrap colSpan=1>\n\t\t\t\t等于<input type=text name=" . $columnName . "_stop_edit class=SmallInput size=6 value=" . $StopEditIndex . ">时,禁用编辑\n\t\t\t\t等于<input type=text name=" . $columnName . "_stop_delete class=SmallInput size=6 value=" . $StopDeleteIndex . ">时,禁用删除\n\t\t\t\t</TD>\n"; } print "</TR>"; } print "</table>"; }
} $sql = "select chinese from systemlang where tablename='{$Tablerealname}' and fieldname='{$ListTableName}'"; $rs = $db->Execute($sql); $ListTableNameValue = $rs->fields['chinese']; print "<TR><TD class=TableContent align=left width=20% colSpan=1> 对象列显示:</TD><TD class=TableContent align=left colSpan=1> <input name=tabletitle type=text class=SmallInput size=55 value=\"{$ListTableName}\"> 中文显示:<input name=tabletitlevalue type=text class=SmallInput size=30 value=\"{$ListTableNameValue}\"></TD></TR>"; //表格宽度 tablewidth(); //列表显示 $array = array("是" => "1", "否" => "0"); print "<TR><TD class=TableContent align=left width=20% colSpan=1> 列表显示:</TD><TD class=TableContent align=left colSpan=1> \n"; radio_array($array, "nullshow", $sectionArray['nullshow']); print "</TD></TR>"; //双击反应 $array = array("查看" => "init_view", "编辑" => "init_edit"); print "<TR><TD class=TableContent align=left width=20% colSpan=1> 双击反应:</TD><TD class=TableContent align=left colSpan=1> \n"; radio_array($array, "ondblclick_config", $sectionArray['ondblclick_config']); print "</TD></TR>"; //模块动作 //add_default:new:n,export_default:export:x,import_default:import:i $array = array("新增" => "add_default:new:n", "导出" => "export_default:export:x", "导入" => "import_default:import:i"); print "<TR><TD class=TableContent align=left width=20% colSpan=1> 模块动作:</TD><TD class=TableContent align=left colSpan=1 nowrap> <input name=action_model type=text class=SmallInput size=110 value=\"" . $sectionArray['action_model'] . "\">\n"; //checkbox_array($array,"action_model",$sectionArray['action_model']); print "<BR> [示例 add_default:new:n,export_default:export:x,import_default:import:i]</TD></TR>"; //行记录操作 $array = array("查看" => "view:view_default", "编辑" => "edit:edit_default", "删除" => "delete:delete_array"); print "<TR><TD class=TableContent align=left width=20% colSpan=1> 行记录操作:</TD><TD class=TableContent align=left nowrap colSpan=1> <input name=row_element type=text class=SmallInput size=55 value=\"" . $sectionArray['row_element'] . "\">\n"; //checkbox_array($array,"row_element",$sectionArray['row_element']); print "[示例 view:view_default,edit:edit_default,delete:delete_array]</TD></TR>"; //底部记录操作 //chooseall:chooseall,delete:delete_array,edit:edit,report:report $array = array("全选" => "chooseall:chooseall", "编辑" => "edit:edit_default", "删除" => "delete:delete_array", "报表" => "report:report");