示例#1
0
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>&nbsp;类型属性明细 <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>&nbsp;属性名称</TD>\n";
    print "<TD class=TableContent align=left colSpan=1>&nbsp;是否启用</TD>\n";
    $GlobalModel == "init" ? print "<TD class=TableContent align=left colSpan=1>&nbsp;搜索选项</TD>\n" : '';
    $GlobalModel == "init" ? print "<TD class=TableContent align=left colSpan=1>&nbsp;高级搜索</TD>\n" : '';
    $GlobalModel == "init" ? print "<TD class=TableContent align=left colSpan=1>&nbsp;分组信息</TD>\n" : '';
    $GlobalModel == "statistics" ? print "<TD class=TableContent align=left colSpan=1>&nbsp;图表类型</TD>\n" : '';
    $ModelArray = array("add", "edit");
    in_array($GlobalModel, $ModelArray) ? print "<TD class=TableContent align=left colSpan=1>&nbsp;是否空值</TD>\n" : '';
    print "<TD class=TableContent align=left colSpan=1>&nbsp;字段排序/可写权限</TD>\n";
    print "<TD class=TableContent align=left colSpan=1>&nbsp;字段属性</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>&nbsp;高级功能<BR>&nbsp;当字段等于什么值时禁用编辑或删除</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&sectionName=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>";
}
示例#2
0
 }
 $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>&nbsp;对象列显示:</TD><TD class=TableContent align=left colSpan=1>&nbsp;<input name=tabletitle type=text class=SmallInput size=55 value=\"{$ListTableName}\">&nbsp;&nbsp;中文显示:<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>&nbsp;列表显示:</TD><TD class=TableContent align=left colSpan=1>&nbsp;\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>&nbsp;双击反应:</TD><TD class=TableContent align=left colSpan=1>&nbsp;\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>&nbsp;模块动作:</TD><TD class=TableContent align=left colSpan=1 nowrap>&nbsp;<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>&nbsp;[示例 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>&nbsp;行记录操作:</TD><TD class=TableContent align=left nowrap colSpan=1>&nbsp;<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");