PHP html_heading_bar函数代码示例

 function build_main_html()
 {
     global $db, $messageStack;
     // Build heading bar
     $output = '<table border="0" width="100%" cellspacing="0" cellpadding="1">' . chr(10);
     $output .= '  <tr class="dataTableHeadingRow" valign="top">' . chr(10);
     $heading_array = array('countries_name' => SETUP_INFO_COUNTRY_NAME, 'countries_iso_code_2' => SETUP_INFO_COUNTRY_CODE_2, 'countries_iso_code_3' => SETUP_INFO_COUNTRY_CODE_3);
     $result = html_heading_bar($heading_array, $_GET['list_order']);
     $output .= $result['html_code'];
     $disp_order = $result['disp_order'];
     $output .= '  </tr>' . chr(10);
     // Build field data
     $query_raw = "select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3  \r\n        from " . $this->db_table . " order by {$disp_order}";
     $page_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $query_raw, $query_numrows);
     $result = $db->Execute($query_raw);
     while (!$result->EOF) {
         $output .= '  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">' . chr(10);
         $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $result->fields['countries_id'] . ')">' . htmlspecialchars($result->fields['countries_name']) . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $result->fields['countries_id'] . ')">' . $result->fields['countries_iso_code_2'] . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $result->fields['countries_id'] . ')">' . $result->fields['countries_iso_code_3'] . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" align="right">' . chr(10);
         if ($this->security_id > 1) {
             $output .= html_icon('actions/edit-find-replace.png', TEXT_EDIT, 'small', 'onclick="loadPopUp(\'edit\', ' . $result->fields['countries_id'] . ')"') . chr(10);
         }
         if ($this->security_id > 3) {
             $output .= html_icon('emblems/emblem-unreadable.png', TEXT_DELETE, 'small', 'onclick="if (confirm(\'' . SETUP_COUNTRY_DELETE_INTRO . '\')) submitSeq(' . $result->fields['countries_id'] . ', \'delete\')"') . chr(10);
         }
         $output .= '    </td>' . chr(10);
         $output .= '  </tr>' . chr(10);
         $result->MoveNext();
     }
     $output .= '</table>' . chr(10);
     $output .= '<div class="page_count_right">' . $page_split->display_links($query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']) . '</div>' . chr(10);
     $output .= '<div class="page_count">' . $page_split->display_count($query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_COUNTRIES) . '</div>' . chr(10);
     return $output;
 }

 function build_main_html()
 {
     global $db, $messageStack;
     // Build heading bar
     $output = '<table border="0" width="100%" cellspacing="0" cellpadding="1">' . chr(10);
     $output .= '  <tr class="dataTableHeadingRow" valign="top">' . chr(10);
     $heading_array = array('description_short' => HR_ACCOUNT_ID, 'description' => TEXT_DESCRIPTION, 'subdepartment' => HR_HEADING_SUBACCOUNT, 'department_inactive' => TEXT_INACTIVE);
     $result = html_heading_bar($heading_array, $_GET['list_order']);
     $output .= $result['html_code'];
     $disp_order = $result['disp_order'];
     $output .= '  </tr>' . chr(10);
     // Build field data
     $query_raw = "select id, description_short, description, subdepartment, primary_dept_id, department_inactive from " . $this->db_table . " order by {$disp_order}";
     $page_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $query_raw, $query_numrows);
     $result = $db->Execute($query_raw);
     while (!$result->EOF) {
         $output .= '  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">' . chr(10);
         $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', \'' . $result->fields['id'] . '\')">' . htmlspecialchars($result->fields['description_short']) . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', \'' . $result->fields['id'] . '\')">' . htmlspecialchars($result->fields['description']) . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', \'' . $result->fields['id'] . '\')">' . ($result->fields['subdepartment'] ? TEXT_YES : TEXT_NO) . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', \'' . $result->fields['id'] . '\')">' . ($result->fields['department_inactive'] ? TEXT_YES : TEXT_NO) . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" align="right">' . chr(10);
         if ($this->security_id > 1) {
             $output .= html_icon('actions/edit-find-replace.png', TEXT_EDIT, 'small', 'onclick="loadPopUp(\'edit\', \'' . $result->fields['id'] . '\')"') . chr(10);
         }
         if ($this->security_id > 3) {
             $output .= html_icon('emblems/emblem-unreadable.png', TEXT_DELETE, 'small', 'onclick="if (confirm(\'' . HR_INFO_DELETE_INTRO . '\')) submitSeq(\'' . $result->fields['id'] . '\', \'delete\')"') . chr(10);
         }
         $output .= '    </td>' . chr(10);
         $output .= '  </tr>' . chr(10);
         $result->MoveNext();
     }
     $output .= '</table>' . chr(10);
     $output .= '<div class="page_count_right">' . $page_split->display_links($query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']) . '</div>' . chr(10);
     $output .= '<div class="page_count">' . $page_split->display_count($query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], HR_DISPLAY_NUMBER_OF_DEPTS) . '</div>' . chr(10);
     return $output;
 }

// |                                                                 |
// | This program is distributed in the hope that it will be useful, |
// | but WITHOUT ANY WARRANTY; without even the implied warranty of  |
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the   |
// | GNU General Public License for more details.                    |
// +-----------------------------------------------------------------+
//  Path: /modules/contacts/pages/main/template_contacts.php
//
?>
<div id="tab_contacts">
<?php 
if (is_array($cInfo->contacts)) {
    $heading_array = array();
    // don't sort
    $non_sort_array = array(GEN_LAST_NAME, GEN_FIRST_NAME, TEXT_TITLE, GEN_TELEPHONE1, GEN_TELEPHONE4, GEN_EMAIL, TEXT_ACTION);
    $crm_headings = html_heading_bar($heading_array, $non_sort_array);
    ?>
  <fieldset>
    <legend><?php 
    echo TEXT_CONTACTS;
    ?>
</legend>
	 <table class="ui-widget" style="border-collapse:collapse;width:100%;">
	  <thead class="ui-widget-header"><?php 
    echo $crm_headings['html_code'];
    ?>
</thead>
	  <tbody class="ui-widget-content">
<?php 
    $odd = true;
    foreach ($cInfo->contacts as $entry) {

    default:
}
/*****************   prepare to display templates  *************************/
$include_header = true;
$include_footer = true;
$include_tabs = true;
$include_calendar = true;
switch ($action) {
    case 'new':
    case 'edit':
        $include_template = 'template_detail.php';
        define('PAGE_TITLE', $action == 'new' ? PRICE_SHEET_NEW_TITLE : PRICE_SHEET_EDIT_TITLE);
        break;
    default:
        $heading_array = array('sheet_name' => TEXT_SHEET_NAME, 'inactive' => TEXT_INACTIVE, 'revision' => TEXT_REVISION, 'default_sheet' => TEXT_DEFAULT, 'effective_date' => TEXT_EFFECTIVE_DATE, 'expiration_date' => TEXT_EXPIRATION_DATE);
        $result = html_heading_bar($heading_array, $_GET['list_order'], array(TEXT_SPECIAL_PRICING, TEXT_ACTION));
        $list_header = $result['html_code'];
        $disp_order = $result['disp_order'];
        // find the highest rev level by sheet name
        $result = $db->Execute("select distinct sheet_name, max(revision) as rev from " . TABLE_PRICE_SHEETS . " group by sheet_name");
        $rev_levels = array();
        while (!$result->EOF) {
            $rev_levels[$result->fields['sheet_name']] = $result->fields['rev'];
            $result->MoveNext();
        }
        // build the list for the page selected
        if (isset($search_text) && gen_not_null($search_text)) {
            $search_fields = array('sheet_name', 'revision');
            // hook for inserting new search fields to the query criteria.
            if (is_array($extra_search_fields)) {
                $search_fields = array_merge($search_fields, $extra_search_fields);

 function build_main_html()
 {
     global $db, $messageStack;
     // Build heading bar
     $output = '<table border="0" width="100%" cellspacing="0" cellpadding="1">' . chr(10);
     $output .= '  <tr class="dataTableHeadingRow" valign="top">' . chr(10);
     $heading_array = array('title' => SETUP_CURRENCY_NAME, 'code' => SETUP_CURRENCY_CODES, 'value' => TEXT_VALUE);
     $result = html_heading_bar($heading_array, $_GET['list_order']);
     $output .= $result['html_code'];
     $disp_order = $result['disp_order'];
     $output .= '  </tr>' . chr(10);
     // Build field data
     $query_raw = "select currencies_id, title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, last_updated, value \r\n\t    from " . TABLE_CURRENCIES . " order by {$disp_order}";
     $page_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $query_raw, $query_numrows);
     $currency = $db->Execute($query_raw);
     while (!$currency->EOF) {
         $output .= '  <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">' . chr(10);
         if (DEFAULT_CURRENCY == $currency->fields['code']) {
             $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $currency->fields['currencies_id'] . ')"><b>' . htmlspecialchars($currency->fields['title']) . ' (' . TEXT_DEFAULT . ')</b></td>' . chr(10);
         } else {
             $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $currency->fields['currencies_id'] . ')">' . htmlspecialchars($currency->fields['title']) . '</td>' . chr(10);
         }
         $output .= '    <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $currency->fields['currencies_id'] . ')">' . $currency->fields['code'] . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" align="right" onclick="loadPopUp(\'edit\', ' . $currency->fields['currencies_id'] . ')">' . number_format($currency->fields['value'], 8) . '</td>' . chr(10);
         $output .= '    <td class="dataTableContent" align="right">' . chr(10);
         if ($this->security_id > 1) {
             $output .= html_icon('actions/edit-find-replace.png', TEXT_EDIT, 'small', 'onclick="loadPopUp(\'edit\', ' . $currency->fields['currencies_id'] . ')"') . chr(10);
         }
         if ($this->security_id > 3) {
             $output .= html_icon('emblems/emblem-unreadable.png', TEXT_DELETE, 'small', 'onclick="if (confirm(\'' . SETUP_CURR_DELETE_INTRO . '\')) submitSeq(' . $currency->fields['currencies_id'] . ', \'delete\')"') . chr(10);
         }
         $output .= '    </td>' . chr(10);
         $output .= '  </tr>' . chr(10);
         $currency->MoveNext();
     }
     $output .= '</table>' . chr(10);
     $output .= '<div class="page_count_right">' . $page_split->display_links($query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']) . '</div>' . chr(10);
     $output .= '<div class="page_count">' . $page_split->display_count($query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_CURRENCIES) . '</div>' . chr(10);
     return $output;
 }

        $_GET['page']++;
        break;
    case 'go_last':
        $_GET['page'] = 99999;
        break;
    case 'search':
    case 'search_reset':
    case 'go_page':
    default:
}
/*****************   prepare to display templates  *************************/
// generate chart of account types
$coa_types = load_coa_types();
// build the list header
$heading_array = array('post_date' => TEXT_DATE, 'purchase_invoice_id' => TEXT_REFERENCE, 'total_amount' => TEXT_AMOUNT);
$result = html_heading_bar($heading_array, $_GET['list_order'], array(TEXT_DESCRIPTION));
$list_header = $result['html_code'];
$disp_order = $result['disp_order'];
// build the list for the page selected
$acct_period = $_GET['search_period'] ? $_GET['search_period'] : $_POST['search_period'];
if (!$acct_period) {
    $acct_period = CURRENT_ACCOUNTING_PERIOD;
}
$period_filter = $acct_period == 'all' ? '' : ' and period = ' . $acct_period;
$search_text = $_GET['search_text'] == TEXT_SEARCH ? '' : db_input(db_prepare_input($_GET['search_text']));
if (isset($search_text) && gen_not_null($search_text)) {
    $search_fields = array('purchase_invoice_id', 'total_amount');
    // hook for inserting new search fields to the query criteria.
    if (is_array($extra_search_fields)) {
        $search_fields = array_merge($search_fields, $extra_search_fields);
    }

    case 'search':
    case 'search_reset':
    case 'go_page':
    default:
}
/*****************   prepare to display templates  *************************/
// build the list header
if (!isset($_REQUEST['sf'])) {
    $_REQUEST['sf'] = 'post_date';
}
if (!isset($_REQUEST['so'])) {
    $_REQUEST['so'] = 'desc';
}
// default to descending by postdate
$heading_array = array('id' => GEN_LINK_POINT_ID, 'short_name' => GEN_CUSTOMER, 'contact_last' => GEN_LAST_NAME, 'contact_first' => GEN_FIRST_NAME, 'empty_1' => '', 'empty_2' => '', 'empty_3' => '', 'empty_4' => '', 'first_date' => GEN_ACCOUNT_CREATED, 'empty_5' => '');
$result = html_heading_bar($heading_array, $extra_headings = array());
$list_header = $result['html_code'];
$disp_order = $result['disp_order'];
// build the list for the page selected
if ($acct_period == 'all') {
    $period_filter = '';
} else {
    $periods = $db->Execute("select * from " . TABLE_ACCOUNTING_PERIODS . " where period = {$acct_period}");
    $start_date = $periods->fields['start_date'];
    $end_date = $periods->fields['end_date'];
    $period_filter = " and DATE_FORMAT(lp.date_added,'%Y-%m-%d' ) BETWEEN  '{$start_date}' AND '{$end_date}' ";
}
if (isset($_REQUEST['search_text']) && $_REQUEST['search_text'] != '') {
    $search_fields = array('short_name');
    // hook for inserting new search fields to the query criteria.
    $search = ' and (' . implode(' like \'%' . $_REQUEST['search_text'] . '%\' or ', $search_fields) . ' like \'%' . $_REQUEST['search_text'] . '%\')';

        $toc_array[$result->fields['parent_id']][] = array('id' => $result->fields['id'], 'doc_type' => $result->fields['doc_type'], 'doc_title' => $result->fields['doc_title'], 'show' => $result->fields['doc_group'] == $tab ? true : false);
    }
    $result->MoveNext();
}
$toggle_list = false;
if ($group) {
    $result = $db->Execute("select id from " . TABLE_PHREEFORM . " where doc_group = '" . $group . "'");
    if ($result->RecordCount() > 0) {
        $toggle_list = buildToggleList($result->fields['id']);
    }
}
switch ($_REQUEST['action']) {
    // figure which detail page to load
    case 'search':
    case 'view':
        $result = html_heading_bar(array(), array(' ', TEXT_DOCUMENT_TITLE, TEXT_ACTION));
        $list_header = $result['html_code'];
        // build the list for the page selected
        if (isset($_REQUEST['search_text']) && $_REQUEST['search_text'] != '') {
            $search_fields = array('doc_title');
            $search = ' where ' . implode(' like \'%' . $_REQUEST['search_text'] . '%\' or ', $search_fields) . ' like \'%' . $_REQUEST['search_text'] . '%\'';
        } else {
            $search = '';
        }
        $field_list = array('id', 'doc_title', 'doc_ext');
        $query_raw = "select SQL_CALC_FOUND_ROWS " . implode(', ', $field_list) . " from " . TABLE_PHREEFORM . $search;
        $query_result = $db->Execute($query_raw, MAX_DISPLAY_SEARCH_RESULTS * ($_REQUEST['list'] - 1) . ", " . MAX_DISPLAY_SEARCH_RESULTS);
        // the splitPageResults should be run directly after the query that contains SQL_CALC_FOUND_ROWS
        $query_split = new splitPageResults($_REQUEST['list'], '');
        if ($query_split->current_page_number != $_REQUEST['list']) {
            // if here, go last was selected, now we know # pages, requery to get results

  
<?php 
echo TEXT_INFO_SEARCH_PERIOD_FILTER . '&nbsp;' . html_pull_down_menu('search_period', gen_get_period_pull_down(false), $period, 'onchange="submit();"');
?>
</div>
<?php 
if (ENABLE_MULTI_CURRENCY) {
    echo '<p>' . sprintf(GEN_PRICE_SHEET_CURRENCY_NOTE, $currencies->currencies[DEFAULT_CURRENCY]['title']) . '</p>' . chr(10);
}
?>
<table class="ui-widget" style="border-collapse:collapse;width:900px;margin-left:auto;margin-right:auto;">
 <thead class="ui-widget-header">
  <tr>
<?php 
$heading_array = array('reference' => TEXT_REFERENCE, 'post_date' => TEXT_DATE, 'dep_amount' => BNK_DEPOSIT_CREDIT, 'pmt_amount' => BNK_CHECK_PAYMENT);
$result = html_heading_bar($heading_array, array(TEXT_SOURCE, TEXT_CLEAR, '&nbsp;'));
echo $result['html_code'];
?>
  </tr>
 </thead>
 <tbody class="ui-widget-content">
	<?php 
$i = 0;
if (sizeof($combined_list) > 0) {
    $odd = true;
    foreach ($combined_list as $values) {
        $bkgnd = $values['partial'] ? ' style="background-color:yellow"' : '';
        $disabled = $values['cleared'] != $period && $values['cleared'] > 0 ? 'disabled="disabled" ' : '';
        $cleared = $values['cleared'] != $period && $values['cleared'] > 0 ? $values['cleared'] . ' ' : '';
        ?>
		<tr class="<?php 

    ?>
 
	</ol>
</fieldset>
<?php 
} else {
    echo html_hidden_field('till_id', $tills->till_id) . chr(10);
    echo html_hidden_field('post_date', gen_locale_date($post_date)) . chr(10);
    ?>

<table class="ui-widget" style="border-collapse:collapse;width:900px;margin-left:auto;margin-right:auto;">
 <thead class="ui-widget-header">
  <tr>
<?php 
    $heading_array = array();
    $result = html_heading_bar($heading_array, array(TEXT_REFERENCE, TEXT_DATE, TEXT_SOURCE, TEXT_AMOUNT, TEXT_CLEAR, '&nbsp;'));
    echo $result['html_code'];
    ?>
  </tr>
 </thead>
 <tbody class="ui-widget-content">
	<?php 
    $i = 0;
    if (sizeof($combined_list) > 0) {
        $odd = true;
        foreach ($combined_list as $values) {
            $bkgnd = $values['partial'] ? ' style="background-color:yellow"' : '';
            ?>
		<tr class="<?php 
            echo $odd ? 'odd' : 'even';
            ?>

    case 'go_last':
        $_GET['page'] = 99999;
        break;
    case 'search':
    case 'search_reset':
    case 'go_page':
    default:
}
/*****************   prepare to display templates  *************************/
// build the list header
if (!isset($_GET['list_order'])) {
    $_GET['list_order'] = 'post_date-desc';
}
// default to descending by invoice number
$heading_array = array('post_date' => TEXT_DATE, 'purchase_invoice_id' => TEXT_INVOICE, 'closed' => ORD_PAID, 'bill_primary_name' => GEN_PRIMARY_NAME, 'shipper_code' => TEXT_CARRIER);
$result = html_heading_bar($heading_array, $_GET['list_order'], array(ORD_SHIPPED, TEXT_ACTION));
$list_header = $result['html_code'];
$disp_order = $result['disp_order'];
// build the list for the page selected
$period_filter = $acct_period == 'all' ? '' : ' and period = ' . $acct_period;
if (isset($search_text) && gen_not_null($search_text)) {
    $search_fields = array('bill_primary_name', 'purchase_invoice_id', 'purch_order_id');
    // hook for inserting new search fields to the query criteria.
    if (is_array($extra_search_fields)) {
        $search_fields = array_merge($search_fields, $extra_search_fields);
    }
    $search = ' and (' . implode(' like \'%' . $search_text . '%\' or ', $search_fields) . ' like \'%' . $search_text . '%\')';
} else {
    $search = '';
}
$field_list = array('id', 'post_date', 'shipper_code', 'purchase_invoice_id', 'closed', 'bill_primary_name', 'journal_id');

 case 'import':
     $include_template = 'template_import.php';
     define('PAGE_TITLE', TEXT_IMPORT_TRANSLATION);
     break;
 case 'export_all':
     $include_template = 'template_export.php';
     define('PAGE_TITLE', TEXT_EXPORT_TRANSLATION);
     break;
 case 'upload':
     $include_template = 'template_upload.php';
     define('PAGE_TITLE', TEXT_UPLOAD_TRANSLATION);
     break;
 case 'filter_main':
 default:
     $heading_array = array('module' => TEXT_MODULE, 'language' => TEXT_LANGUAGE_CODE, 'version' => TEXT_VERSION);
     $result = html_heading_bar($heading_array, array(TEXT_STATISTICS, TEXT_ACTION));
     $list_header = $result['html_code'];
     $disp_order = $result['disp_order'];
     if (!isset($_GET['list_order'])) {
         $disp_order = 'language';
     }
     if ($mod && $mod != 'all') {
         $criteria[] = "module = '" . $mod . "'";
     }
     if ($lang) {
         $criteria[] = "language = '" . $lang . "'";
     }
     if ($ver && $ver != 'L') {
         $criteria[] = "version = '" . $ver . "'";
     }
     // build the list for the page selected

    case 'search':
    case 'search_reset':
    case 'go_page':
    default:
}
/*****************   prepare to display templates  *************************/
// build the list header
$heading_array = array('m.post_date' => TEXT_DATE, 'purchase_invoice_id' => TEXT_REFERENCE, 'qty' => TEXT_QUANTITY, 'sku' => TEXT_SKU, 'description' => TEXT_DESCRIPTION);
if (ENABLE_MULTI_BRANCH && $adj_type == 'xfr') {
    $extras = array(TEXT_FROM_BRANCH, TEXT_DEST_BRANCH);
} elseif (ENABLE_MULTI_BRANCH) {
    $extras = array(TEXT_BRANCH);
} else {
    $extras = array();
}
$result = html_heading_bar($heading_array, $extras);
$list_header = $result['html_code'];
$disp_order = $result['disp_order'];
// build the list for the page selected
if (isset($_REQUEST['search_text']) && $_REQUEST['search_text'] != '') {
    $search_fields = array('i.sku', 'm.purchase_invoice_id', 'i.debit_amount', 'i.credit_amount', 'i.description', 'i.gl_account');
    // hook for inserting new search fields to the query criteria.
    if (is_array($extra_search_fields)) {
        $search_fields = array_merge($search_fields, $extra_search_fields);
    }
    $filters[] = '(' . implode(' like \'%' . $_REQUEST['search_text'] . '%\' or ', $search_fields) . ' like \'%' . $_REQUEST['search_text'] . '%\')';
}
$field_list = array('m.id', 'm.purchase_invoice_id', 'm.post_date', 'm.store_id', 'm.bill_acct_id', 'sum(i.qty) as qty', 'i.sku', 'count(i.sku) as sku_cnt', 'i.description');
// hook to add new fields to the query return results
if (is_array($extra_query_list_fields) > 0) {
    $field_list = array_merge($field_list, $extra_query_list_fields);

require_once DIR_FS_MODULES . 'phreeform/defaults.php';
require_once DIR_FS_MODULES . 'phreeform/functions/phreeform.php';
/**************   page specific initialization  *************************/
if (!isset($_REQUEST['list'])) {
    $_REQUEST['list'] = 1;
}
$fieldset_content = 'NULL';
$id = (int) $_GET['id'];
if (!isset($_GET['id'])) {
    die;
}
$doc_details = $db->Execute("select * from " . TABLE_PHREEFORM . " where id = '" . $id . "'");
if ($id == 0 || $doc_details->fields['doc_type'] == '0') {
    // folder
    $dir_path = TEXT_PATH . ': /' . build_dir_path($id);
    $result = html_heading_bar(array(), array(' ', $dir_path, TEXT_ACTION));
    $list_header = $result['html_code'];
    $field_list = array('id', 'doc_type', 'doc_title', 'security');
    $query_raw = "select SQL_CALC_FOUND_ROWS " . implode(', ', $field_list) . " from " . TABLE_PHREEFORM . " where parent_id = '" . $id . "'";
    $query_result = $db->Execute($query_raw, MAX_DISPLAY_SEARCH_RESULTS * ($_REQUEST['list'] - 1) . ", " . MAX_DISPLAY_SEARCH_RESULTS);
    // the splitPageResults should be run directly after the query that contains SQL_CALC_FOUND_ROWS
    $query_split = new splitPageResults($_REQUEST['list'], '');
    include DIR_FS_MODULES . 'phreeform/pages/main/tab_folder.php';
} else {
    // load document details
    include DIR_FS_MODULES . 'phreeform/pages/main/tab_report.php';
}
$html = "<div>";
$html .= $fieldset_content;
$html .= "</div>";
$xml .= "\t" . xmlEntry("htmlContents", $html);

        if (DEBUG) {
            $messageStack->write_debug();
        }
        // send to printer (range of check numbers)
        break;
    case 'search':
    default:
}
/*****************   prepare to display templates  *************************/
// load the gl account beginning balance
$acct_balance = load_cash_acct_balance($post_date, $gl_acct_id, $period);
// load gl accounts
$gl_array_list = gen_coa_pull_down();
// build the list header
$heading_array = array('post_date' => BNK_INVOICE_DATE, 'bill_primary_name' => BNK_VENDOR_NAME, 'purchase_invoice_id' => BNK_INVOICE_NUM, 'total_amount' => BNK_AMOUNT_DUE);
$result = html_heading_bar($heading_array, array(TEXT_NOTES, BNK_DUE_DATE, TEXT_DISCOUNT, BNK_20_AMOUNT_PAID, TEXT_PAY));
$list_header = $result['html_code'];
$disp_order = $result['disp_order'];
if (!$disp_order) {
    $disp_order = 'post_date';
}
// build the list for the page selected
$field_list = array('m.id', 'm.journal_id', 'm.post_date', 'm.total_amount', 'm.terms', 'm.gl_acct_id', 'm.purchase_invoice_id', 'm.purch_order_id', 'm.bill_acct_id', 'm.bill_primary_name', 'm.waiting');
// hook to add new fields to the query return results
if (is_array($extra_query_list_fields) > 0) {
    $field_list = array_merge($field_list, $extra_query_list_fields);
}
$query_raw = "select " . implode(', ', $field_list) . " \n\tfrom " . TABLE_JOURNAL_MAIN . " m inner join " . TABLE_CONTACTS . " a on m.bill_acct_id = a.id \n\twhere a.type = 'v' and m.journal_id in (6, 7) and m.closed = '0' \n\torder by {$disp_order}, post_date";
$query_result = $db->Execute($query_raw);
$cal_bills0 = array('name' => 'datePosted', 'form' => 'bulk_bills', 'fieldname' => 'post_date', 'imagename' => 'btn_date_1', 'default' => gen_locale_date($post_date), 'params' => array('align' => 'left', 'onchange' => 'loadNewBalance();'));
$cal_bills1 = array('name' => 'dateInvoice', 'form' => 'bulk_bills', 'fieldname' => 'invoice_date', 'imagename' => 'btn_date_2', 'default' => gen_locale_date($invoice_date), 'params' => array('align' => 'left'));