function build_main_html()
{
global $db, $messageStack;
$tax_authorities_array = gen_build_tax_auth_array();
$content = array();
$content['thead'] = array('value' => array(SETUP_TAX_DESC_SHORT, TEXT_DESCRIPTION, SETUP_HEADING_TOTAL_TAX, SETUP_HEADING_TAX_FREIGHT, TEXT_ACTION), 'params' => 'width="100%" cellspacing="0" cellpadding="1"');
$result = $db->Execute("select tax_rate_id, description_short, description_long, rate_accounts, freight_taxable \n\t\tfrom " . $this->db_table . " where type = '" . $this->type . "'");
$rowCnt = 0;
while (!$result->EOF) {
$actions = '';
if ($this->security_id > 1) {
$actions .= html_icon('actions/edit-find-replace.png', TEXT_EDIT, 'small', 'onclick="loadPopUp(\'' . $this->code . '_edit\', ' . $result->fields['tax_rate_id'] . ')"') . chr(10);
}
if ($this->security_id > 3) {
$actions .= html_icon('emblems/emblem-unreadable.png', TEXT_DELETE, 'small', 'onclick="if (confirm(\'' . SETUP_TAX_DELETE_INTRO . '\')) subjectDelete(\'' . $this->code . '\', ' . $result->fields['tax_rate_id'] . ')"') . chr(10);
}
$content['tbody'][$rowCnt] = array(array('value' => htmlspecialchars($result->fields['description_short']), 'params' => 'style="cursor:pointer" onclick="loadPopUp(\'' . $this->code . '_edit\',\'' . $result->fields['tax_rate_id'] . '\')"'), array('value' => htmlspecialchars($result->fields['description_long']), 'params' => 'style="cursor:pointer" onclick="loadPopUp(\'' . $this->code . '_edit\',\'' . $result->fields['tax_rate_id'] . '\')"'), array('value' => gen_calculate_tax_rate($result->fields['rate_accounts'], $tax_authorities_array), 'params' => 'style="cursor:pointer" onclick="loadPopUp(\'' . $this->code . '_edit\',\'' . $result->fields['tax_rate_id'] . '\')"'), array('value' => $result->fields['freight_taxable'] ? TEXT_YES : TEXT_NO, 'params' => 'style="cursor:pointer" onclick="loadPopUp(\'' . $this->code . '_edit\',\'' . $result->fields['tax_rate_id'] . '\')"'), array('value' => $actions, 'params' => 'style="cursor:pointer" align="right"'));
$result->MoveNext();
$rowCnt++;
}
return html_datatable('' . $this->code . '_' . $this->type . '_table', $content);
}
function ord_calculate_tax_drop_down($type = 'c')
{
global $db;
$tax_auth_array = gen_build_tax_auth_array();
$sql = "select tax_rate_id, description_short, rate_accounts from " . TABLE_TAX_RATES;
switch ($type) {
default:
case 'c':
case 'v':
$sql .= " where type = '" . $type . "'";
break;
case 'b':
// both
}
$tax_rates = $db->Execute($sql);
$tax_rate_drop_down = array();
$tax_rate_drop_down[] = array('id' => '0', 'rate' => '0', 'text' => TEXT_NONE, 'auths' => '');
while (!$tax_rates->EOF) {
$tax_rate_drop_down[] = array('id' => $tax_rates->fields['tax_rate_id'], 'rate' => gen_calculate_tax_rate($tax_rates->fields['rate_accounts'], $tax_auth_array), 'text' => $tax_rates->fields['description_short'], 'auths' => $tax_rates->fields['rate_accounts']);
$tax_rates->MoveNext();
}
return $tax_rate_drop_down;
}
function build_main_html()
{
global $db, $messageStack;
$tax_authorities_array = gen_build_tax_auth_array();
// 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' => SETUP_TAX_DESC_SHORT, 'account_id' => SETUP_HEADING_TOTAL_TAX, 'tax_rate' => SETUP_HEADING_TAX_FREIGHT);
$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 tax_rate_id, description_short, description_long, rate_accounts, freight_taxable \r\n\t\tfrom " . $this->db_table . " where type = '" . $this->type . "' 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['tax_rate_id'] . ')">' . htmlspecialchars($result->fields['description_short']) . '</td>' . chr(10);
$output .= ' <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $result->fields['tax_rate_id'] . ')">' . gen_calculate_tax_rate($result->fields['rate_accounts'], $tax_authorities_array) . '</td>' . chr(10);
$output .= ' <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $result->fields['tax_rate_id'] . ')">' . ($result->fields['freight_taxable'] ? 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['tax_rate_id'] . ')"') . chr(10);
}
if ($this->security_id > 3) {
$output .= html_icon('emblems/emblem-unreadable.png', TEXT_DELETE, 'small', 'onclick="if (confirm(\'' . SETUP_TAX_DELETE_INTRO . '\')) submitSeq(' . $result->fields['tax_rate_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'], SETUP_DISPLAY_NUMBER_OF_TAX_RATES) . '</div>' . chr(10);
return $output;
}
