PHP make_list函数代码示例

/**
 * @version $Id: search.php 237 2014-04-25 11:47:48Z soeren $
 * @package eXtplorer
 * @copyright soeren 2007-2014
 * @author The eXtplorer project (http://extplorer.net)
 * @author The	The QuiX project (http://quixplorer.sourceforge.net)
 *
 * @license
 * The contents of this file are subject to the Mozilla Public License
 * Version 1.1 (the "License"); you may not use this file except in
 * compliance with the License. You may obtain a copy of the License at
 * http://www.mozilla.org/MPL/
 *
 * Software distributed under the License is distributed on an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
 * License for the specific language governing rights and limitations
 * under the License.
 *
 * Alternatively, the contents of this file may be used under the terms
 * of the GNU General Public License Version 2 or later (the "GPL"), in
 * which case the provisions of the GPL are applicable instead of
 * those above. If you wish to allow use of your version of this file only
 * under the terms of the GPL and not to allow others to use
 * your version of this file under the MPL, indicate your decision by
 * deleting  the provisions above and replace  them with the notice and
 * other provisions required by the GPL.  If you do not delete
 * the provisions above, a recipient may use your version of this file
 * under either the MPL or the GPL."
 *
 * File-Search Functions
 */
function ext_search_items($dir)
{
    // search for item
    if (empty($dir) && !empty($GLOBALS['__POST']["item"])) {
        $dir = $GLOBALS['__POST']["item"];
    }
    if (isset($GLOBALS['__POST']["searchitem"])) {
        $searchitem = stripslashes($GLOBALS['__POST']["searchitem"]);
        $subdir = !empty($GLOBALS['__POST']["subdir"]);
        $content = $GLOBALS['__POST']["content"];
        $list = make_list($dir, $searchitem, $subdir, $content);
    } else {
        $searchitem = NULL;
        $subdir = true;
    }
    if (empty($searchitem)) {
        show_searchform($dir);
        return;
    }
    // Results in JSON
    $items['totalCount'] = count($list);
    $result = get_result_array($list);
    $start = (int) $GLOBALS['__POST']["start"];
    $limit = (int) $GLOBALS['__POST']["limit"];
    if ($start < $items['totalCount'] && $limit < $items['totalCount']) {
        $result = array_splice($result, $start, $limit);
    }
    $items['items'] = $result;
    $json = new ext_Json();
    while (@ob_end_clean()) {
    }
    echo $json->encode($items);
}

function make_list ($parent,$all=null){
    static $tasks;
    if(isset($all)){
        $tasks=$all;
    }
    echo'<ol>';
        foreach ($parent as $task_id=>$todo) {
            echo"<li>$todo";
            if(isset($tasks[$task_id])){
                make_list($tasks[$task_id]);
            }
            echo'</li>';
        }
        
    echo'</ol>';
    
}

function make_list($parent)
{
    global $tasks;
    echo '<ol>';
    // Start an ordered list.
    foreach ($parent as $task_id => $todo) {
        echo "<li>{$todo}";
        if (isset($tasks[$task_id])) {
            // Call this function again:
            make_list($tasks[$task_id]);
        }
        echo '</li>';
        // Complete the list item.
    }
    // End of FOREACH loop.
    echo '</ol>';
    // Close the ordered list.
}

function make_list($parent)
{
    global $tasks;
    echo '<ol>';
    // Start an ordered list.
    foreach ($parent as $task_id => $todo) {
        // Start with a checkbox!
        echo <<<EOT
<li><input type="checkbox" name="tasks[{$task_id}]" value="done"> {$todo}
EOT;
        // Check for subtasks:
        if (isset($tasks[$task_id])) {
            make_list($tasks[$task_id]);
        }
        echo '</li>';
        // Complete the list item.
    }
    // End of FOREACH loop.
    echo '</ol>';
    // Close the ordered list.
}

function make_list($parent)
{
    // Need the main $tasks array:
    global $tasks;
    // Start and order list:
    echo '<ol>';
    // Loop through each subarray:
    foreach ($parent as $id => $todo) {
        // Display the item:
        echo <<<EOT
<li><input type="checkbox" name="tasks[{$id}]" value="done" /> {$todo}
EOT;
        // Check for subtasks:
        if (isset($tasks[$id])) {
            // Call function again:
            make_list($tasks[$id]);
        }
        // Complete the list item:
        echo '</li>';
    }
    // End of FOREACH loop
    // Close the ordered list:
    echo '</ol>';
}

//.........这里部分代码省略.........
        // ADMIN
        _print_link("admin", permissions_grant(NULL, NULL, "admin") || permissions_grant(NULL, NULL, "password"), $dir, NULL);
        // LOGOUT
        _print_link("logout", true, $dir, NULL);
    }
    echo "</TR></TABLE></TD>\n";
    // Create File / Dir
    if (permissions_grant($dir, NULL, "create")) {
        echo "<TD align=\"right\"><TABLE><FORM action=\"" . make_link("mkitem", $dir, NULL) . "\" method=\"post\">\n<TR><TD>";
        echo "<SELECT name=\"mktype\"><option value=\"file\">" . $GLOBALS["mimes"]["file"] . "</option>";
        echo "<option value=\"dir\">" . $GLOBALS["mimes"]["dir"] . "</option></SELECT>\n";
        echo "<INPUT name=\"mkname\" type=\"text\" size=\"15\">";
        echo "<INPUT type=\"submit\" value=\"" . $GLOBALS["messages"]["btncreate"];
        echo "\"></TD></TR></FORM></TABLE></TD>\n";
    }
    echo "</TR></TABLE>\n";
    // End Toolbar
    // Begin Table + Form for checkboxes
    echo "<TABLE WIDTH=\"95%\"><FORM name=\"selform\" method=\"POST\" action=\"" . make_link("post", $dir, NULL) . "\">\n";
    echo "<INPUT type=\"hidden\" name=\"do_action\"><INPUT type=\"hidden\" name=\"first\" value=\"y\">\n";
    // Table Header
    echo "<TR><TD colspan=\"7\"><HR></TD></TR><TR><TD WIDTH=\"2%\" class=\"header\">\n";
    echo "<INPUT TYPE=\"checkbox\" name=\"toggleAllC\" onclick=\"javascript:ToggleAll(this);\"></TD>\n";
    echo "<TD WIDTH=\"44%\" class=\"header\"><B>\n";
    if ($GLOBALS["order"] == "name") {
        $new_srt = $_srt;
    } else {
        $new_srt = "yes";
    }
    echo "<A href=\"" . make_link("list", $dir, NULL, "name", $new_srt) . "\">" . $GLOBALS["messages"]["nameheader"];
    if ($GLOBALS["order"] == "name") {
        echo $_img;
    }
    echo "</A></B></TD>\n<TD WIDTH=\"10%\" class=\"header\"><B>";
    if ($GLOBALS["order"] == "size") {
        $new_srt = $_srt;
    } else {
        $new_srt = "yes";
    }
    echo "<A href=\"" . make_link("list", $dir, NULL, "size", $new_srt) . "\">" . $GLOBALS["messages"]["sizeheader"];
    if ($GLOBALS["order"] == "size") {
        echo $_img;
    }
    echo "</A></B></TD>\n<TD WIDTH=\"16%\" class=\"header\"><B>";
    if ($GLOBALS["order"] == "type") {
        $new_srt = $_srt;
    } else {
        $new_srt = "yes";
    }
    echo "<A href=\"" . make_link("list", $dir, NULL, "type", $new_srt) . "\">" . $GLOBALS["messages"]["typeheader"];
    if ($GLOBALS["order"] == "type") {
        echo $_img;
    }
    echo "</A></B></TD>\n<TD WIDTH=\"14%\" class=\"header\"><B>";
    if ($GLOBALS["order"] == "mod") {
        $new_srt = $_srt;
    } else {
        $new_srt = "yes";
    }
    echo "<A href=\"" . make_link("list", $dir, NULL, "mod", $new_srt) . "\">" . $GLOBALS["messages"]["modifheader"];
    if ($GLOBALS["order"] == "mod") {
        echo $_img;
    }
    echo "</A></B></TD><TD WIDTH=\"8%\" class=\"header\"><B>" . $GLOBALS["messages"]["permheader"] . "</B>\n";
    echo "</TD><TD WIDTH=\"6%\" class=\"header\"><B>" . $GLOBALS["messages"]["actionheader"] . "</B></TD></TR>\n";
    echo "<TR><TD colspan=\"7\"><HR></TD></TR>\n";
    // make & print Table using lists
    print_table($dir, make_list($dir_list, $file_list));
    // print number of items & total filesize
    echo "<TR><TD colspan=\"7\"><HR></TD></TR><TR>\n<TD class=\"header\"></TD>";
    echo "<TD class=\"header\">" . $num_items . " " . $GLOBALS["messages"]["miscitems"] . " (";
    if (function_exists("disk_free_space")) {
        $free = parse_file_size(disk_free_space(get_abs_dir($dir)));
    } elseif (function_exists("diskfreespace")) {
        $free = parse_file_size(diskfreespace(get_abs_dir($dir)));
    } else {
        $free = "?";
    }
    // echo "Total: ".parse_file_size(disk_total_space(get_abs_dir($dir))).", ";
    echo $GLOBALS["messages"]["miscfree"] . ": " . $free . ")</TD>\n";
    echo "<TD class=\"header\">" . parse_file_size($tot_file_size) . "</TD>\n";
    for ($i = 0; $i < 4; ++$i) {
        echo "<TD class=\"header\"></TD>";
    }
    echo "</TR>\n<TR><TD colspan=\"7\"><HR></TD></TR></FORM></TABLE>\n";
    ?>
<script language="JavaScript1.2" type="text/javascript">
<!--
	// Uncheck all items (to avoid problems with new items)
	var ml = document.selform;
	var len = ml.elements.length;
	for(var i=0; i<len; ++i) {
		var e = ml.elements[i];
		if(e.name == "selitems[]" && e.checked == true) {
			e.checked=false;
		}
	}
// -->
</script><?php 
}

                    $new_entry = $arr_fields[$arr_fields_by_order[$key]] . " LIKE '%" . $text_field[$key] . "%'";
                    break;
                case 'STARTS WITH (..%)':
                    $new_entry = $arr_fields[$arr_fields_by_order[$key]] . " LIKE '" . $text_field[$key] . "%'";
                    break;
                case 'ENDS WITH (%..)':
                    $new_entry = $arr_fields[$arr_fields_by_order[$key]] . " LIKE '%" . $text_field[$key] . "'";
                    break;
                case 'BETWEEN (value1, value2)':
                    $data = explode(',', $text_field[$key]);
                    $value1 = trim($data[0]);
                    $value2 = trim($data[1]);
                    $new_entry = $arr_fields[$arr_fields_by_order[$key]] . " BETWEEN '" . $value1 . "' AND '" . $value2 . "'";
                    break;
            }
            make_list($where_clause, $new_entry, ' AND ', FALSE);
        }
    }
}
//Construct group by - actually just needs to identify the field to use for group by clause
if (isset($arr_fields[$group_field])) {
    $group_clause = $arr_fields[$group_field];
} else {
    $group_clause = '';
}
$obj_custom_report = cobalt_load_class($data_subclass);
$obj_custom_report->custom_select_fields = $select_fields;
$obj_custom_report->custom_where_clause = $where_clause;
$obj_custom_report->custom_group_by = $group_clause;
$obj_custom_report->custom_join = $custom_join;
$obj_custom_report->custom_report();

function print_list_page()
{
    global $admin, $template, $HEADING, $TEXT;
    // Generate pages list
    if ($admin->get_permission('pages_view') == true) {
        $template->set_file('pages_list', 'pages_list.htt');
        $template->set_block('pages_list', 'main_block', 'main');
        $template->set_block('main_block', 'page_list_block', 'page_list');
        $template->set_var('HEADING_MODIFY_DELETE_PAGE', $HEADING['MODIFY_DELETE_PAGE']);
        $template->set_var('TEXT_VISIBILITY', $TEXT['VISIBILITY']);
        $template->set_var('TEXT_MENU_TITLE', $TEXT['MENU_TITLE']);
        $template->set_var('TEXT_PAGE_TITLE', $TEXT['PAGE_TITLE']);
        $template->set_var('TEXT_ACTIONS', $TEXT['ACTIONS']);
        $par = array();
        $par['num_subs'] = 1;
        $editable_pages = 0;
        $loop = make_list(0, $editable_pages);
        $template->set_var('PAGES_LIST_LOOP', $loop);
        $template->parse('pages_list', 'page_list_block');
        $template->parse('main', 'main_block');
        $template->pparse('output', 'pages_list');
        if ($editable_pages == 0) {
            echo "</div><div class='empty_list'>" . $TEXT['NONE_FOUND'] . "</div>";
        }
    } else {
        $editable_pages = 0;
        echo "</div><div class='empty_list'>" . $TEXT['NONE_FOUND'] . "</div>";
    }
}

 function get_listview_fields()
 {
     $table_name = $this->table_name;
     $this->arr_subtext_separators = array();
     foreach ($this->fields as $field_name => $field_struct) {
         if ($field_struct['in_listview'] == TRUE) {
             $make_filter_label = TRUE;
             if ($field_struct['attribute'] == 'foreign key' || $field_struct['attribute'] == 'primary&foreign key') {
                 $has_no_defined_relationship = TRUE;
                 //find the relationship information for this field; only 1-1
                 foreach ($this->relations as $key => $rel) {
                     if (strip_back_quote_smart($rel['link_child']) == $field_name && $rel['type'] == '1-1') {
                         $has_no_defined_relationship = FALSE;
                         require_once 'subclasses/' . strip_back_quote_smart($rel['table']) . '.php';
                         $class = strip_back_quote_smart($rel['table']);
                         $data_con = new $class();
                         $database = $data_con->db_use;
                         $temp_field_name = '';
                         $filter_field_name = '';
                         $arr_subtexts = array();
                         $arr_subtext_labels = array();
                         $subtext_cntr = 0;
                         foreach ($rel['link_subtext'] as $subtext) {
                             if ($temp_field_name != '') {
                                 $temp_field_name .= ', ';
                             }
                             if ($filter_field_name != '') {
                                 $filter_field_name .= ', ';
                             }
                             if (isset($rel['alias']) && $rel['alias'] != '') {
                                 $temp_field_name .= back_quote_smart($database) . '.' . back_quote_smart($rel['alias']) . '.' . back_quote_smart($subtext) . ' AS ' . back_quote_smart($database . '_' . $rel['alias'] . '_' . $subtext);
                                 $filter_field_name .= back_quote_smart($database) . '.' . back_quote_smart($rel['alias']) . '.' . back_quote_smart($subtext);
                                 $arr_subtexts[] = $database . '_' . $rel['alias'] . '_' . $subtext;
                             } else {
                                 $temp_field_name .= back_quote_smart($database) . '.' . back_quote_smart($rel['table']) . '.' . back_quote_smart($subtext) . ' AS ' . back_quote_smart($database . '_' . $rel['table'] . '_' . $subtext);
                                 $filter_field_name .= back_quote_smart($database) . '.' . back_quote_smart($rel['table']) . '.' . back_quote_smart($subtext);
                                 $arr_subtexts[] = $database . '_' . $rel['table'] . '_' . $subtext;
                             }
                             $arr_subtext_labels[] = $data_con->fields[$subtext]['label'];
                             ++$subtext_cntr;
                         }
                         if ($subtext_cntr > 1) {
                             foreach ($arr_subtext_labels as $new_filter_label) {
                                 make_list_array($this->arr_filter_field_labels, $new_filter_label);
                             }
                             $make_filter_label = FALSE;
                         }
                         if (isset($this->fields[$field_name]['list_settings']['list_separators'])) {
                             $this->arr_subtext_separators[] = $this->fields[$field_name]['list_settings']['list_separators'];
                         }
                         $related_field_name = $temp_field_name;
                         make_list($this->lst_fields, back_quote_smart($related_field_name), ',', FALSE);
                         make_list($this->lst_filter_fields, back_quote_smart($filter_field_name), ',', FALSE);
                         $this->arr_fields[] = $arr_subtexts;
                         if ($field_struct['attribute'] == 'primary&foreign key') {
                             //if foreign key is also a primary key, we also need the original field aside from the subtext field
                             $orig_field_name = back_quote_smart($table_name) . '.' . back_quote_smart($field_name);
                             make_list($this->lst_fields, back_quote_smart($orig_field_name), ',', FALSE);
                         }
                     }
                 }
                 if ($has_no_defined_relationship) {
                     error_handler('Cannot render ListView, incorrect configuration.', ' Missing relationship information for foreign-key column "' . $field_name . '".');
                 }
             } else {
                 make_list($this->lst_fields, back_quote_smart($table_name) . '.' . back_quote_smart($field_name), ',', FALSE);
                 make_list($this->lst_filter_fields, back_quote_smart($table_name) . '.' . back_quote_smart($field_name), ',', FALSE);
                 make_list_array($this->arr_fields, $field_name);
             }
             make_list($this->lst_field_labels, $field_struct['label'], ',');
             make_list_array($this->arr_field_labels, $field_struct['label']);
             if ($make_filter_label) {
                 make_list_array($this->arr_filter_field_labels, $field_struct['label']);
             }
         } elseif ($field_struct['attribute'] == 'primary key') {
             make_list($this->lst_fields, back_quote_smart($table_name) . '.' . back_quote_smart($field_name), ',', FALSE);
         }
     }
     return $this;
 }

/**
 * This function assembles an array (list) of files or directories in the directory specified by $dir
 * The result array is send using JSON
 *
 * @param string $dir
 * @param string $sendWhat Can be "files" or "dirs"
 */
function send_dircontents($dir, $sendWhat = 'files')
{
    // print table of files
    global $dir_up, $mainframe;
    // make file & dir tables, & get total filesize & number of items
    get_dircontents($dir, $dir_list, $file_list, $tot_file_size, $num_items);
    if ($sendWhat == 'files') {
        $list = $file_list;
    } elseif ($sendWhat == 'dirs') {
        $list = $dir_list;
    } else {
        $list = make_list($dir_list, $file_list);
    }
    $i = 0;
    $items['totalCount'] = count($list);
    $items['items'] = array();
    $dirlist = array();
    if ($sendWhat != 'dirs') {
        // Replaced array_splice, because it resets numeric indexes (like files or dirs with a numeric name)
        // Here we reduce the list to the range of $limit beginning at $start
        $a = 0;
        $output_array = array();
        foreach ($list as $key => $value) {
            if ($a >= $GLOBALS['start'] && $a - $GLOBALS['start'] < $GLOBALS['limit']) {
                $output_array[$key] = $value;
            }
            $a++;
        }
        $list = $output_array;
    }
    while (list($item, $info) = each($list)) {
        // link to dir / file
        if (is_array($info)) {
            $abs_item = $info;
            if (extension_loaded('posix')) {
                $user_info = posix_getpwnam($info['user']);
                $file_info['uid'] = $user_info['uid'];
                $file_info['gid'] = $user_info['gid'];
            }
        } else {
            $abs_item = get_abs_item(ext_TextEncoding::fromUTF8($dir), $item);
            $file_info = @stat($abs_item);
        }
        $is_dir = get_is_dir($abs_item);
        if ($GLOBALS['use_mb']) {
            if (ext_isFTPMode()) {
                $items['items'][$i]['name'] = $item;
            } else {
                if (mb_detect_encoding($item) == 'ASCII') {
                    $items['items'][$i]['name'] = ext_TextEncoding::toUTF8($item);
                } else {
                    $items['items'][$i]['name'] = ext_TextEncoding::toUTF8($item);
                }
            }
        } else {
            $items['items'][$i]['name'] = ext_isFTPMode() ? $item : ext_TextEncoding::toUTF8($item);
        }
        $items['items'][$i]['is_file'] = get_is_file($abs_item);
        $items['items'][$i]['is_archive'] = ext_isArchive($item) && !ext_isFTPMode();
        $items['items'][$i]['is_writable'] = $is_writable = @$GLOBALS['ext_File']->is_writable($abs_item);
        $items['items'][$i]['is_chmodable'] = $is_chmodable = @$GLOBALS['ext_File']->is_chmodable($abs_item);
        $items['items'][$i]['is_readable'] = $is_readable = @$GLOBALS['ext_File']->is_readable($abs_item);
        $items['items'][$i]['is_deletable'] = $is_deletable = @$GLOBALS['ext_File']->is_deletable($abs_item);
        $items['items'][$i]['is_editable'] = get_is_editable($abs_item);
        $items['items'][$i]['icon'] = _EXT_URL . "/images/" . get_mime_type($abs_item, "img");
        $items['items'][$i]['size'] = parse_file_size(get_file_size($abs_item));
        // type
        $items['items'][$i]['type'] = get_mime_type($abs_item, "type");
        // modified
        $items['items'][$i]['modified'] = parse_file_date(get_file_date($abs_item));
        // permissions
        $perms = get_file_perms($abs_item);
        if ($perms) {
            if (strlen($perms) > 3) {
                $perms = substr($perms, 2);
            }
            $items['items'][$i]['perms'] = $perms . ' (' . parse_file_perms($perms) . ')';
        } else {
            $items['items'][$i]['perms'] = ' (unknown) ';
        }
        $items['items'][$i]['perms'] = $perms . ' (' . parse_file_perms($perms) . ')';
        if (extension_loaded("posix")) {
            if ($file_info["uid"]) {
                $user_info = posix_getpwuid($file_info["uid"]);
                //$group_info = posix_getgrgid($file_info["gid"]);
                $items['items'][$i]['owner'] = $user_info["name"] . " (" . $file_info["uid"] . ")";
            } else {
                $items['items'][$i]['owner'] = " (unknown) ";
            }
        } else {
            $items['items'][$i]['owner'] = 'n/a';
        }
        if ($is_dir && $sendWhat != 'files') {
//.........这里部分代码省略.........

function search_items($dir)
{
    // search for item
    if (isset($GLOBALS['__POST']["searchitem"])) {
        $searchitem = stripslashes($GLOBALS['__POST']["searchitem"]);
        $subdir = isset($GLOBALS['__POST']["subdir"]) && $GLOBALS['__POST']["subdir"] == "y";
        $list = make_list($dir, $searchitem, $subdir);
    } else {
        $searchitem = NULL;
        $subdir = true;
    }
    $msg = $GLOBALS["messages"]["actsearchresults"];
    if ($searchitem != NULL) {
        $msg .= ": (/" . get_rel_item($dir, $searchitem) . ")";
    }
    show_header($msg);
    // Search Box
    echo "<BR><TABLE><FORM name=\"searchform\" action=\"" . make_link("search", $dir, NULL);
    echo "\" method=\"post\">\n<TR><TD><INPUT name=\"searchitem\" type=\"text\" size=\"25\" value=\"";
    echo $searchitem . "\"><INPUT type=\"submit\" value=\"" . $GLOBALS["messages"]["btnsearch"];
    echo "\">&nbsp;<input type=\"button\" value=\"" . $GLOBALS["messages"]["btnclose"];
    echo "\" onClick=\"javascript:location='" . make_link("list", $dir, NULL);
    echo "';\"></TD></TR><TR><TD><INPUT type=\"checkbox\" name=\"subdir\" value=\"y\"";
    echo ($subdir ? " checked>" : ">") . $GLOBALS["messages"]["miscsubdirs"] . "</TD></TR></FORM></TABLE>\n";
    // Results
    if ($searchitem != NULL) {
        echo "<TABLE width=\"95%\"><TR><TD colspan=\"2\"><HR></TD></TR>\n";
        if (count($list) > 0) {
            // Table Header
            echo "<TR>\n<TD WIDTH=\"42%\" class=\"header\"><B>" . $GLOBALS["messages"]["nameheader"];
            echo "</B></TD>\n<TD WIDTH=\"58%\" class=\"header\"><B>" . $GLOBALS["messages"]["pathheader"];
            echo "</B></TD></TR>\n<TR><TD colspan=\"2\"><HR></TD></TR>\n";
            // make & print table of found items
            print_table($list);
            echo "<TR><TD colspan=\"2\"><HR></TD></TR>\n<TR><TD class=\"header\">" . count($list) . " ";
            echo $GLOBALS["messages"]["miscitems"] . ".</TD><TD class=\"header\"></TD></TR>\n";
        } else {
            echo "<TR><TD>" . $GLOBALS["messages"]["miscnoresult"] . "</TD></TR>";
        }
        echo "<TR><TD colspan=\"2\"><HR></TD></TR></TABLE>\n";
    }
    ?>
<script language="JavaScript1.2" type="text/javascript">
<!--
	if(document.searchform) document.searchform.searchitem.focus();
// -->
</script><?php 
}

                    $value2 = trim($data[1]);
                    $new_entry = $arr_fields[$arr_fields_by_order[$key]] . " BETWEEN '" . $value1 . "' AND '" . $value2 . "'";
                    break;
                case 'NOT BETWEEN (value1, value2)':
                    $data = explode(',', $op_value);
                    $value1 = trim($data[0]);
                    $value2 = trim($data[1]);
                    $new_entry = $arr_fields[$arr_fields_by_order[$key]] . " NOT BETWEEN '" . $value1 . "' AND '" . $value2 . "'";
                    break;
            }
            make_list($where_clause, $new_entry, ' AND ', FALSE);
        }
    }
}
//Construct group by - actually just needs to identify the field to use for group by clause
init_var($group_clause);
if (isset($arr_fields[$group_field1])) {
    make_list($group_clause, $arr_fields[$group_field1], ', ', FALSE);
}
if (isset($arr_fields[$group_field2])) {
    make_list($group_clause, $arr_fields[$group_field2], ', ', FALSE);
}
if (isset($arr_fields[$group_field3])) {
    make_list($group_clause, $arr_fields[$group_field3], ', ', FALSE);
}
$obj_custom_report = cobalt_load_class($data_subclass);
$obj_custom_report->custom_select_fields = $select_fields;
$obj_custom_report->custom_where_clause = $where_clause;
$obj_custom_report->custom_group_by = $group_clause;
$obj_custom_report->custom_join = $custom_join;
$obj_custom_report->custom_report();

//.........这里部分代码省略.........
    		echo "<td><img border=\"0\" width=\"22\" height=\"22\" align=\"absmiddle\" ";
    		echo "src=\""._EXT_URL."/images/_delete_.gif\" alt=\"".$GLOBALS["messages"]["dellink"]."\" title=\"";
    		echo $GLOBALS["messages"]["dellink"]."\"></td>\n";
    		// UPLOAD
    		echo "<td><img border=\"0\" width=\"22\" height=\"22\" align=\"absmiddle\" ";
    		echo "src=\""._EXT_URL."/images/_upload_.gif\" alt=\"".$GLOBALS["messages"]["uplink"];
    		echo "\" title=\"".$GLOBALS["messages"]["uplink"]."\"></td>\n";
    	}
    
    	// ADMIN & LOGOUT
    	if($GLOBALS["require_login"]) {
    		echo "<td>::</td>";
    		// ADMIN
    		if($admin) {
    			echo "<td><a href=\"".make_link("admin",$dir,NULL)."\">";
    			echo "<img border=\"0\" width=\"22\" height=\"22\" align=\"absmiddle\" ";
    			echo "src=\""._EXT_URL."/images/_admin.gif\" alt=\"".$GLOBALS["messages"]["adminlink"]."\" title=\"";
    			echo $GLOBALS["messages"]["adminlink"]."\"></A></td>\n";
    		}
    		// LOGOUT
    		echo "<td><a href=\"".make_link("logout",NULL,NULL)."\">";
    		echo "<img border=\"0\" width=\"22\" height=\"22\" align=\"absmiddle\" ";
    		echo "src=\""._EXT_URL."/images/_logout.gif\" alt=\"".$GLOBALS["messages"]["logoutlink"]."\" title=\"";
    		echo $GLOBALS["messages"]["logoutlink"]."\"></a></td>\n";
    	}
    	// Logo
    	echo "<td style=\"padding-left:10px;\">";
    	//echo "<div style=\"margin-left:10px;float:right;\" width=\"305\" >";
    	echo "<a href=\"".$GLOBALS['ext_home']."\" target=\"_blank\" title=\"joomlaXplorer Project\"><img border=\"0\" align=\"absmiddle\" id=\"ext_logo\" style=\"filter:alpha(opacity=10);-moz-opacity:.10;opacity:.10;\" onmouseover=\"opacity('ext_logo', 60, 99, 500);\" onmouseout=\"opacity('ext_logo', 100, 60, 500);\" ";
    	echo "src=\""._EXT_URL."/images/logo.gif\" align=\"right\" alt=\"" . $GLOBALS['messages']['logolink'] . "\"></a>";
    	//echo "</div>";
    	echo "</td>\n";
    	
    	echo "</tr></table></td>\n";
    	
    	// Create File / Dir
    	
    	if($allow && is_writable($GLOBALS['home_dir'].'/'.$dir)) {
    		echo "<td align=\"right\"><table><form action=\"".make_link("mkitem",$dir,NULL)."\" method=\"post\">\n<tr><td>";
    		echo "<select name=\"mktype\"><option value=\"file\">".$GLOBALS["mimes"]["file"]."</option>";
    		echo "<option value=\"dir\">".$GLOBALS["mimes"]["dir"]."</option></select>\n";
    		echo "<input name=\"mkname\" type=\"text\" size=\"15\">";
    		echo "<input type=\"submit\" value=\"".$GLOBALS["messages"]["btncreate"];
    		echo "\"></td></tr></form></table></td>\n";
    	}
    	
    	echo "</tr></table>\n";
    	*/
    // End Toolbar
    // Begin Table + Form for checkboxes
    echo "<table width=\"95%\" cellpadding=\"5\" cellspacing=\"2\"><tr class=\"sectiontableheader\">\n";
    echo "<th width=\"44%\"><b>\n";
    if ($GLOBALS["order"] == "name") {
        $new_srt = $_srt;
    } else {
        $new_srt = "yes";
    }
    echo "<a href=\"" . make_link("list", $dir, NULL, "name", $new_srt) . "\">" . $GLOBALS["messages"]["nameheader"];
    if ($GLOBALS["order"] == "name") {
        echo $images;
    }
    echo "</a></b></td>\n<th width=\"10%\"><b>";
    if ($GLOBALS["order"] == "size") {
        $new_srt = $_srt;
    } else {
        $new_srt = "yes";
    }
    echo "<a href=\"" . make_link("list", $dir, NULL, "size", $new_srt) . "\">" . $GLOBALS["messages"]["sizeheader"];
    if ($GLOBALS["order"] == "size") {
        echo $images;
    }
    echo "</a></b></th>\n<th width=\"12%\" ><b>";
    if ($GLOBALS["order"] == "type") {
        $new_srt = $_srt;
    } else {
        $new_srt = "yes";
    }
    echo "<a href=\"" . make_link("list", $dir, NULL, "type", $new_srt) . "\">" . $GLOBALS["messages"]["typeheader"];
    if ($GLOBALS["order"] == "type") {
        echo $images;
    }
    echo "</a></b></th>\n<th width=\"12%\"><b>";
    if ($GLOBALS["order"] == "mod") {
        $new_srt = $_srt;
    } else {
        $new_srt = "yes";
    }
    echo "<a href=\"" . make_link("list", $dir, NULL, "mod", $new_srt) . "\">" . $GLOBALS["messages"]["modifheader"];
    if ($GLOBALS["order"] == "mod") {
        echo $images;
    }
    echo "</a></b></th></tr>\n";
    // make & print Table using lists
    print_table($dir, make_list($dir_list, $file_list), $allow);
    // print number of items & total filesize
    echo "<tr><td colspan=\"4\"><hr/></td></tr><tr>\n<td>&nbsp;</td>";
    echo "<td>" . $num_items . " " . $GLOBALS["messages"]["miscitems"] . " " . parse_file_size($tot_file_size) . "</td>\n";
    echo "<td>&nbsp;</td><td>&nbsp;</td>";
    echo "</tr>\n<tr><td colspan=\"4\"><hr/></td></tr></table>\n";
}

function make_list($array)
{
    $list[''] = '';
    //first value of the list will be empty
    foreach ($array as $item) {
        $list[$item] = $item;
    }
    return $list;
}
echo form_open('home_c/upload', $form_attributes);
//echo form_label('Insect:', 'insect');
echo form_fieldset('Insect');
echo form_dropdown('insect', make_list($insects), '', 'required');
echo form_fieldset_close();
echo form_fieldset('Location');
echo form_dropdown('location', make_list($locations), '', 'required');
echo form_fieldset_close();
$date = ['name' => 'date', 'required' => 'required', 'type' => 'date'];
echo form_fieldset('Date');
echo form_input($date);
echo form_fieldset_close();
$file_data = ['name' => 'file', 'required' => 'required', 'accept' => ".csv"];
echo form_fieldset('File .csv');
echo form_upload($file_data);
echo form_fieldset_close();
echo form_submit(array('id' => 'submit', 'value' => 'Upload'));
echo form_close();
//echo validation_errors();
?>

</div>

 function print_fieldsets($subclass)
 {
     $obj = cobalt_load_class($subclass);
     $lst_fields = '';
     foreach ($obj->fields as $field_name => $field_struct) {
         make_list($lst_fields, $field_name);
     }
     $settings = "        \$this->fieldsets = array(" . "\r\n" . "                                 'default'=>array(" . $lst_fields . ")" . "\r\n" . "                                );";
     echo '<pre>' . $settings . '</pre>';
 }