function gl_inquiry_controls()
{
$dim = get_company_pref('use_dimension');
start_form();
start_table(TABLESTYLE_NOBORDER);
$date = today();
if (!isset($_POST['TransFromDate'])) {
$_POST['TransFromDate'] = begin_month($date);
}
if (!isset($_POST['TransToDate'])) {
$_POST['TransToDate'] = end_month($date);
}
date_cells(_("From:"), 'TransFromDate');
date_cells(_("To:"), 'TransToDate');
if ($dim >= 1) {
dimensions_list_cells(_("Dimension") . " 1:", 'Dimension', null, true, " ", false, 1);
}
if ($dim > 1) {
dimensions_list_cells(_("Dimension") . " 2:", 'Dimension2', null, true, " ", false, 2);
}
check_cells(_("No zero values"), 'NoZero', null);
check_cells(_("Only balances"), 'Balance', null);
submit_cells('Show', _("Show"), '', '', 'default');
end_table();
end_form();
}
function gl_inquiry_controls()
{
$dim = get_company_pref('use_dimension');
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
gl_all_accounts_list_cells(_("Account:"), 'account', null, false, false, _("All Accounts"));
date_cells(_("from:"), 'TransFromDate', '', null, -30);
date_cells(_("to:"), 'TransToDate');
end_row();
end_table();
start_table(TABLESTYLE_NOBORDER);
start_row();
if ($dim >= 1) {
dimensions_list_cells(_("Dimension") . " 1:", 'Dimension', null, true, " ", false, 1);
}
if ($dim > 1) {
dimensions_list_cells(_("Dimension") . " 2:", 'Dimension2', null, true, " ", false, 2);
}
small_amount_cells(_("Amount min:"), 'amount_min', null, " ");
small_amount_cells(_("Amount max:"), 'amount_max', null, " ");
submit_cells('Show', _("Show"), '', '', 'default');
end_row();
end_table();
echo '<hr>';
end_form();
}
function gl_inquiry_controls()
{
start_form();
start_table("class='tablestyle_noborder'");
date_cells(tr("From:"), 'TransFromDate', null, -30);
date_cells(tr("To:"), 'TransToDate');
check_cells(tr("No zero values"), 'NoZero', null);
submit_cells('Show', tr("Show"));
end_table();
end_form();
}
function tax_inquiry_controls()
{
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
date_cells(_("from:"), 'TransFromDate', '', null, -30);
date_cells(_("to:"), 'TransToDate');
submit_cells('Show', _("Show"), '', '', 'default');
end_row();
end_table();
end_form();
}
function inquiry_controls()
{
global $Ajax;
$dim = get_company_pref('use_dimension');
start_table(TABLESTYLE_NOBORDER);
$date = today();
if (!isset($_POST['TransFromDate'])) {
$_POST['TransFromDate'] = begin_month($date);
}
if (!isset($_POST['TransToDate'])) {
$_POST['TransToDate'] = end_month($date);
}
date_cells(_("From:"), 'TransFromDate');
date_cells(_("To:"), 'TransToDate');
type_list_cells(_("Category: "), 'typeId', null, true);
$r = set();
account_list_cells(_(""), 'accountId', $r);
submit_cells('submit_submit', _("Generate Report"), true, '', 'default');
//submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), 'default');
end_table();
}
function gl_inquiry_controls()
{
global $table_style2;
$dim = get_company_pref('use_dimension');
start_form();
//start_table($table_style2);
start_table("class='tablestyle_noborder'");
start_row();
gl_all_accounts_list_cells(tr("Account:"), 'account', null);
date_cells(tr("from:"), 'TransFromDate', null, -30);
date_cells(tr("to:"), 'TransToDate');
submit_cells('Show', tr("Show"));
end_row();
if ($dim >= 1) {
dimensions_list_row(tr("Dimension") . " 1", 'Dimension', null, true, " ", false, 1);
}
if ($dim > 1) {
dimensions_list_row(tr("Dimension") . " 2", 'Dimension2', null, true, " ", false, 2);
}
end_table();
end_form();
}
if (count($invs) > 0) {
$ar = array('PARAM_0' => $min . "-" . ST_SALESINVOICE, 'PARAM_1' => $max . "-" . ST_SALESINVOICE, 'PARAM_2' => "", 'PARAM_3' => 0, 'PARAM_4' => 0, 'PARAM_5' => "", 'PARAM_6' => $def_print_orientation);
display_note(print_link(sprintf(_("&Print Recurrent Invoices # %s - # %s"), $min, $max), 107, $ar), 0, 1);
$ar['PARAM_3'] = 1;
// email
display_note(print_link(sprintf(_("&Email Recurrent Invoices # %s - # %s"), $min, $max), 107, $ar), 0, 1);
}
} else {
display_error(_("The entered date is not in fiscal year."));
}
}
$result = get_recurrent_invoices();
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
date_cells(_("Invoice date:"), 'date', '');
end_row();
end_table();
start_table(TABLESTYLE, "width=70%");
$th = array(_("Description"), _("Template No"), _("Customer"), _("Branch") . "/" . _("Group"), _("Days"), _("Monthly"), _("Begin"), _("End"), _("Last Created"), "");
table_header($th);
$k = 0;
$today = add_days($_POST['date'], 1);
$due = false;
while ($myrow = db_fetch($result)) {
$begin = sql2date($myrow["begin"]);
$end = sql2date($myrow["end"]);
$last_sent = calculate_from($myrow);
$due_date = add_months($last_sent, $myrow['monthly']);
$due_date = add_days($due_date, $myrow['days']);
$overdue = date1_greater_date2($today, $due_date) && date1_greater_date2($today, $begin) && date1_greater_date2($end, $today);
$js .= get_js_date_picker();
}
if ($use_popup_windows) {
$js .= get_js_open_window(900, 500);
}
page(_($help_context = "Disbursement/Journal Voucher Inquiry"), false, false, "", $js);
if (isset($_GET['UpdatedID'])) {
$trans_no = $_GET['AddedID'];
display_notification_centered(_("Check voucher entry has been edited") . " #{$trans_no}");
}
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
booklet_type_row_list(_("Select type: "), 'type');
text_cells(_("Voucher #"), 'voucher_no');
date_cells(_("From:"), 'FromDate', '', null, 0, -1, 0);
submit_cells('RefreshInquiry', _("Search"), '', _('Refresh Inquiry'), 'default');
end_row();
end_table();
br(3);
//------------------------------------------------------------------------------------------------
function type_name($dummy, $type)
{
global $systypes_array;
return $systypes_array[$type];
}
function voucher($row)
{
$vouch = substr($row['YearDate'], 2) . "-" . str_pad($row['customized_no'], 4, 0, STR_PAD_LEFT);
return $vouch;
}
if (get_post('bank_date')) {
// if it is the last updated bank statement retrieve ending balance
$row = get_ending_reconciled($_POST['bank_account'], $_POST['bank_date']);
if ($row) {
$_POST["end_balance"] = price_format($row["ending_reconcile_balance"]);
}
}
}
}
echo "<hr>";
div_start('summary');
start_table(TABLESTYLE);
$th = array(_("Reconcile Date"), _("Beginning<br>Balance"), _("Ending<br>Balance"), _("Account<br>Total"), _("Reconciled<br>Amount"), _("Difference"));
table_header($th);
start_row();
date_cells("", "reconcile_date", _('Date of bank statement to reconcile'), get_post('bank_date') == '', 0, 0, 0, null, true);
amount_cells_ex("", "beg_balance", 15);
amount_cells_ex("", "end_balance", 15);
$reconciled = input_num('reconciled');
$difference = input_num("end_balance") - input_num("beg_balance") - $reconciled;
amount_cell($total);
amount_cell($reconciled, false, '', "reconciled");
amount_cell($difference, false, '', "difference");
end_row();
end_table();
div_end();
echo "<hr>";
//------------------------------------------------------------------------------------------------
if (!isset($_POST['bank_account'])) {
$_POST['bank_account'] = "";
}
$_POST['TransToDate'] = $_GET['ToDate'];
}
//------------------------------------------------------------------------------------------------
if (!@$_GET['popup']) {
start_form();
}
if (!isset($_POST['supplier_id'])) {
$_POST['supplier_id'] = get_global_supplier();
}
start_table(TABLESTYLE_NOBORDER);
start_row();
if (!@$_GET['popup']) {
supplier_list_cells(_("Select a supplier:"), 'supplier_id', null, true, false, false, !@$_GET['popup']);
}
date_cells(_("From:"), 'TransAfterDate', '', null, -30);
date_cells(_("To:"), 'TransToDate');
supp_transactions_list_cell("filterType", null, true);
submit_cells('RefreshInquiry', _("Search"), '', _('Refresh Inquiry'), 'default');
end_row();
end_table();
set_global_supplier($_POST['supplier_id']);
//------------------------------------------------------------------------------------------------
function display_supplier_summary($supplier_record)
{
$past1 = get_company_pref('past_due_days');
$past2 = 2 * $past1;
$nowdue = "1-" . $past1 . " " . _('Days');
$pastdue1 = $past1 + 1 . "-" . $past2 . " " . _('Days');
$pastdue2 = _('Over') . " " . $past2 . " " . _('Days');
start_table(TABLESTYLE, "width='80%'");
$th = array(_("Currency"), _("Terms"), _("Current"), $nowdue, $pastdue1, $pastdue2, _("Total Balance"));
function inquiry_controls()
{
$dim = get_company_pref('use_dimension');
start_table(TABLESTYLE_NOBORDER);
$date = today();
if (!isset($_POST['TransFromDate'])) {
$_POST['TransFromDate'] = begin_month($date);
}
if (!isset($_POST['TransToDate'])) {
$_POST['TransToDate'] = end_month($date);
}
date_cells(_("From:"), 'TransFromDate');
date_cells(_("To:"), 'TransToDate');
//Compare Combo
global $sel;
$sel = array(_("Accumulated"), _("Period Y-1"), _("Budget"));
echo "<td>" . _("Compare to") . ":</td>\n";
echo "<td>";
echo array_selector('Compare', null, $sel);
echo "</td>\n";
if ($dim >= 1) {
dimensions_list_cells(_("Dimension") . " 1:", 'Dimension', null, true, " ", false, 1);
}
if ($dim > 1) {
dimensions_list_cells(_("Dimension") . " 2:", 'Dimension2', null, true, " ", false, 2);
}
submit_cells('Show', _("Show"), '', '', 'default');
end_table();
hidden('AccGrp');
}
if (!isset($_POST['ship_via'])) {
$_POST['ship_via'] = $_SESSION['Items']->ship_via;
}
label_cell(_("Shipping Company"), "class='tableheader2'");
shippers_list_cells(null, 'ship_via', $_POST['ship_via']);
if (!isset($_POST['InvoiceDate']) || !is_date($_POST['InvoiceDate'])) {
$_POST['InvoiceDate'] = new_doc_date();
if (!is_date_in_fiscalyear($_POST['InvoiceDate'])) {
$_POST['InvoiceDate'] = end_fiscalyear();
}
}
date_cells(_("Date"), 'InvoiceDate', '', $_SESSION['Items']->trans_no == 0, 0, 0, 0, "class='tableheader2'", true);
if (!isset($_POST['due_date']) || !is_date($_POST['due_date'])) {
$_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->payment, $_POST['InvoiceDate']);
}
date_cells(_("Due Date"), 'due_date', '', null, 0, 0, 0, "class='tableheader2'");
/*
if ($dim > 1)
label_cells(_("Dimension"). " 2", get_dimension_string($_SESSION['Items']->dimension2_id), "class='tableheader2'");
else if ($dim > 0)
label_cell(" ", "colspan=2");
*/
if ($dim > 1) {
label_cell(_("Dimension") . " 2:", "class='tableheader2'");
$_POST['dimension2_id'] = $_SESSION['Items']->dimension2_id;
dimensions_list_cells(null, 'dimension2_id', null, true, ' ', false, 2, false);
} else {
hidden('dimension2_id', 0);
}
end_row();
end_table();
if ($use_date_picker) {
$js .= get_js_date_picker();
}
page(tr("Customer Transactions"), false, false, "", $js);
if (isset($_GET['customer_id'])) {
$_POST['customer_id'] = $_GET['customer_id'];
}
//------------------------------------------------------------------------------------------------
start_form();
if (!isset($_POST['customer_id'])) {
$_POST['customer_id'] = get_global_customer();
}
start_table("class='tablestyle_noborder'");
customer_list_cells(tr("Select a customer: "), 'customer_id', $_POST['customer_id'], true);
date_cells(tr("From:"), 'TransAfterDate', null, -30);
date_cells(tr("To:"), 'TransToDate', null, 1);
if (!isset($_POST['filterType'])) {
$_POST['filterType'] = 0;
}
cust_allocations_list_cells(null, 'filterType', $_POST['filterType'], true);
submit_cells('Refresh Inquiry', tr("Search"));
end_table();
end_form();
set_global_customer($_POST['customer_id']);
//------------------------------------------------------------------------------------------------
function display_customer_summary($customer_record)
{
global $table_style;
$past1 = get_company_pref('past_due_days');
$past2 = 2 * $past1;
if ($customer_record["dissallow_invoices"] != 0) {
}
label_cell(tr("Delivery From"), "class='tableheader2'");
locations_list_cells(null, 'Location', $_POST['Location'], false, true);
if (!isset($_POST['ship_via'])) {
$_POST['ship_via'] = $_SESSION['Items']->ship_via;
}
label_cell(tr("Shipping Company"), "class='tableheader2'");
shippers_list_cells(null, 'ship_via', $_POST['ship_via']);
// set this up here cuz it's used to calc qoh
if (!isset($_POST['DispatchDate']) || !is_date($_POST['DispatchDate'])) {
$_POST['DispatchDate'] = Today();
if (!is_date_in_fiscalyear($_POST['DispatchDate'])) {
$_POST['DispatchDate'] = end_fiscalyear();
}
}
date_cells(tr("Date"), 'DispatchDate', $_POST['DispatchDate'], 0, 0, 0, "class='tableheader2'");
end_row();
end_table();
echo "</td><td>";
// outer table
start_table("{$table_style} width=90%");
if (!isset($_POST['due_date']) || !is_date($_POST['due_date'])) {
$_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->customer_id, $_POST['DispatchDate']);
}
date_row(tr("Invoice Dead-line"), 'due_date', $_POST['due_date'], 0, 0, 0, "class='tableheader2'");
end_table();
echo "</td></tr>";
end_table(1);
// outer table
display_heading(tr("Delivery Items"));
start_table("{$table_style} width=80%");
function inquiry_controls()
{
$dim = get_company_pref('use_dimension');
start_table(TABLESTYLE_NOBORDER);
date_cells(_("As at:"), 'TransToDate');
if ($dim >= 1) {
dimensions_list_cells(_("Dimension") . " 1:", 'Dimension', null, true, " ", false, 1);
}
if ($dim > 1) {
dimensions_list_cells(_("Dimension") . " 2:", 'Dimension2', null, true, " ", false, 2);
}
submit_cells('Show', _("Show"), '', '', 'default');
end_table();
hidden('TransFromDate');
hidden('AccGrp');
}
$js .= get_js_date_picker();
}
page(_($help_context = "Customer Allocation Inquiry"), false, false, "", $js);
if (isset($_GET['customer_id'])) {
$_POST['customer_id'] = $_GET['customer_id'];
}
//------------------------------------------------------------------------------------------------
if (!isset($_POST['customer_id'])) {
$_POST['customer_id'] = get_global_customer();
}
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
customer_list_cells(_("Select a customer: "), 'customer_id', $_POST['customer_id'], true);
date_cells(_("from:"), 'TransAfterDate', '', null, -30);
date_cells(_("to:"), 'TransToDate', '', null, 1);
cust_allocations_list_cells(_("Type:"), 'filterType', null);
check_cells(" " . _("show settled:"), 'showSettled', null);
submit_cells('RefreshInquiry', _("Search"), '', _('Refresh Inquiry'), 'default');
set_global_customer($_POST['customer_id']);
end_row();
end_table();
//------------------------------------------------------------------------------------------------
function check_overdue($row)
{
return $row['OverDue'] == 1 && abs($row["TotalAmount"]) - $row["Allocated"] != 0;
}
function order_link($row)
{
return $row['order_'] > 0 ? get_customer_trans_view_str(ST_SALESORDER, $row['order_']) : "";
}
dimensions_list_cells(null, 'dimension_id', null, true, ' ', false, 1, false);
end_row();
} else {
hidden('dimension_id', 0);
}
if ($dim > 1) {
start_row();
label_cell(_("Dimension") . " 2:", "class='tableheader2'");
dimensions_list_cells(null, 'dimension2_id', null, true, ' ', false, 2, false);
end_row();
} else {
hidden('dimension2_id', 0);
}
//---------
start_row();
date_cells(_("Invoice Dead-line"), 'due_date', '', null, 0, 0, 0, "class='tableheader2'");
end_row();
end_table();
echo "</td></tr>";
end_table(1);
// outer table
$row = get_customer_to_order($_SESSION['Items']->customer_id);
if ($row['dissallow_invoices'] == 1) {
display_error(_("The selected customer account is currently on hold. Please contact the credit control personnel to discuss."));
end_form();
end_page();
exit;
}
display_heading(_("Delivery Items"));
div_start('Items');
start_table(TABLESTYLE, "width=80%");
if ($show_dates) {
$Ajax->addDisable(true, 'OrdersAfterDate', $disable);
$Ajax->addDisable(true, 'OrdersToDate', $disable);
}
$Ajax->activate('orders_tbl');
}
if (!@$_GET['popup']) {
start_form();
}
start_table(TABLESTYLE_NOBORDER);
start_row();
ref_cells(_("#:"), 'OrderNumber', '', null, '', true);
ref_cells(_("Ref"), 'OrderReference', '', null, '', true);
if ($show_dates) {
date_cells(_("from:"), 'OrdersAfterDate', '', null, -30);
date_cells(_("to:"), 'OrdersToDate', '', null, 1);
}
locations_list_cells(_("Location:"), 'StockLocation', null, true);
if ($show_dates) {
end_row();
end_table();
start_table(TABLESTYLE_NOBORDER);
start_row();
}
stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
if (!@$_GET['popup']) {
customer_list_cells(_("Select a customer: "), 'customer_id', null, true);
}
if ($trans_type == ST_SALESQUOTE) {
check_cells(_("Show All:"), 'show_all');
}
if ($use_date_picker) {
$js .= get_js_date_picker();
}
page(tr("Inventory Item Movement"), false, false, "", $js);
if (isset($_GET['stock_id'])) {
$_POST['stock_id'] = $_GET['stock_id'];
}
start_form(false, true);
if (!isset($_POST['stock_id'])) {
$_POST['stock_id'] = get_global_stock_item();
}
start_table("class='tablestyle_noborder'");
stock_items_list_cells(tr("Item:"), 'stock_id', $_POST['stock_id']);
locations_list_cells(tr("From Location:"), 'StockLocation', null);
date_cells(tr("From:"), 'AfterDate', null, -30);
date_cells(tr("To:"), 'BeforeDate');
submit_cells('ShowMoves', tr("Show Movements"));
end_table();
end_form();
set_global_stock_item($_POST['stock_id']);
$before_date = date2sql($_POST['BeforeDate']);
$after_date = date2sql($_POST['AfterDate']);
$sql = "SELECT type, trans_no, tran_date, person_id, qty, reference\n\tFROM stock_moves\n\tWHERE loc_code='" . $_POST['StockLocation'] . "'\n\tAND tran_date >= '" . $after_date . "'\n\tAND tran_date <= '" . $before_date . "'\n\tAND stock_id = '" . $_POST['stock_id'] . "' ORDER BY tran_date,trans_id";
$result = db_query($sql, "could not query stock moves");
check_db_error("The stock movements for the selected criteria could not be retrieved", $sql);
start_table("{$table_style} width=70%");
$th = array(tr("Type"), tr("#"), tr("Reference"), tr("Date"), tr("Detail"), tr("Quantity In"), tr("Quantity Out"), tr("Quantity On Hand"));
table_header($th);
$sql = "SELECT SUM(qty) FROM stock_moves WHERE stock_id='" . $_POST['stock_id'] . "'\n\tAND loc_code='" . $_POST['StockLocation'] . "'\n\tAND tran_date < '" . $after_date . "'";
$before_qty = db_query($sql, "The starting quantity on hand could not be calculated");
$before_qty_row = db_fetch_row($before_qty);
set_focus('type_');
}
$Ajax->activate('dim_table');
}
//--------------------------------------------------------------------------------------
if (isset($_GET["stock_id"])) {
$_POST['SelectedStockItem'] = $_GET["stock_id"];
}
//--------------------------------------------------------------------------------------
start_form(false, false, $_SERVER['PHP_SELF'] . "?outstanding_only={$outstanding_only}");
start_table(TABLESTYLE_NOBORDER);
start_row();
ref_cells(_("Reference:"), 'OrderNumber', '', null, '', true);
number_list_cells(_("Type"), 'type_', null, 1, 2, _("All"));
date_cells(_("From:"), 'FromDate', '', null, 0, 0, -5);
date_cells(_("To:"), 'ToDate');
check_cells(_("Only Overdue:"), 'OverdueOnly', null);
if (!$outstanding_only) {
check_cells(_("Only Open:"), 'OpenOnly', null);
} else {
$_POST['OpenOnly'] = 1;
}
submit_cells('SearchOrders', _("Search"), '', '', 'default');
end_row();
end_table();
$dim = get_company_pref('use_dimension');
function view_link($row)
{
return get_dimensions_trans_view_str(ST_DIMENSION, $row["id"]);
}
function sum_dimension($row)
elseif ($_POST['order_view_mode']=='InvoiceTemplates')
{
$action .= "?InvoiceTemplates=" . $_POST['InvoiceTemplates'];
}
elseif ($_POST['order_view_mode']=='DeliveryTemplates')
{
$action .= "?DeliveryTemplates=" . $_POST['InvoiceTemplates'];
}
*/
start_form(false, false, $_SERVER['PHP_SELF'] . SID);
start_table("class='tablestyle_noborder'");
start_row();
ref_cells(tr("#:"), 'OrderNumber');
if ($_POST['order_view_mode'] != 'DeliveryTemplates' && $_POST['order_view_mode'] != 'InvoiceTemplates') {
date_cells(tr("from:"), 'OrdersAfterDate', null, -30);
date_cells(tr("to:"), 'OrdersToDate', null, 1);
}
locations_list_cells(tr("Location:"), 'StockLocation', null, true);
stock_items_list_cells(tr("Item:"), 'SelectStockFromList', null, true);
submit_cells('SearchOrders', tr("Search"));
hidden('order_view_mode', $_POST['order_view_mode']);
end_row();
end_table();
end_form();
//---------------------------------------------------------------------------------------------
if (isset($_POST['SelectStockFromList']) && $_POST['SelectStockFromList'] != "" && $_POST['SelectStockFromList'] != reserved_words::get_all()) {
$selected_stock_item = $_POST['SelectStockFromList'];
} else {
unset($selected_stock_item);
}
//---------------------------------------------------------------------------------------------
$_POST['customer_id'] = $_GET['customer_id'];
}
//------------------------------------------------------------------------------------------------
if (!@$_GET['popup']) {
start_form();
}
if (!isset($_POST['customer_id'])) {
$_POST['customer_id'] = get_global_customer();
}
start_table(TABLESTYLE_NOBORDER);
start_row();
if (!@$_GET['popup']) {
customer_list_cells(_("Select a customer: "), 'customer_id', null, true, false, false, !@$_GET['popup']);
}
date_cells(_("From:"), 'TransAfterDate', '', null, -30);
date_cells(_("To:"), 'TransToDate', '', null);
if (!isset($_POST['filterType'])) {
$_POST['filterType'] = 0;
}
cust_allocations_list_cells(null, 'filterType', $_POST['filterType'], true);
submit_cells('RefreshInquiry', _("Search"), '', _('Refresh Inquiry'), 'default');
end_row();
end_table();
set_global_customer($_POST['customer_id']);
//------------------------------------------------------------------------------------------------
function display_customer_summary($customer_record)
{
$past1 = get_company_pref('past_due_days');
$past2 = 2 * $past1;
if ($customer_record["dissallow_invoices"] != 0) {
echo "<center><font color=red size=4><b>" . _("CUSTOMER ACCOUNT IS ON HOLD") . "</font></b></center>";
if ($disable) {
$Ajax->addFocus(true, 'order_number');
} else {
$Ajax->addFocus(true, 'OrdersAfterDate');
}
$Ajax->activate('orders_tbl');
}
//---------------------------------------------------------------------------------------------
if (!@$_GET['popup']) {
start_form();
}
start_table(TABLESTYLE_NOBORDER);
start_row();
ref_cells(_("#:"), 'order_number', '', null, '', true);
date_cells(_("from:"), 'OrdersAfterDate', '', null, -30);
date_cells(_("to:"), 'OrdersToDate');
locations_list_cells(_("into location:"), 'StockLocation', null, true);
end_row();
end_table();
start_table(TABLESTYLE_NOBORDER);
start_row();
stock_items_list_cells(_("for item:"), 'SelectStockFromList', null, true);
submit_cells('SearchOrders', _("Search"), '', _('Select documents'), 'default');
end_row();
end_table(1);
//---------------------------------------------------------------------------------------------
if (isset($_POST['order_number'])) {
$order_number = $_POST['order_number'];
}
if (isset($_POST['SelectStockFromList']) && $_POST['SelectStockFromList'] != "" && $_POST['SelectStockFromList'] != ALL_TEXT) {
$selected_stock_item = $_POST['SelectStockFromList'];
$Ajax->addDisable(true, 'SelectStockFromList', $disable);
// if search is not empty rewrite table
if ($disable) {
$Ajax->addFocus(true, 'DeliveryNumber');
} else {
$Ajax->addFocus(true, 'DeliveryAfterDate');
}
$Ajax->activate('deliveries_tbl');
}
//-----------------------------------------------------------------------------------
start_form(false, false, $_SERVER['PHP_SELF'] . "?OutstandingOnly=" . $_POST['OutstandingOnly']);
start_table(TABLESTYLE_NOBORDER);
start_row();
ref_cells(_("#:"), 'DeliveryNumber', '', null, '', true);
date_cells(_("from:"), 'DeliveryAfterDate', '', null, -30);
date_cells(_("to:"), 'DeliveryToDate', '', null, 1);
locations_list_cells(_("Location:"), 'StockLocation', null, true);
end_row();
end_table();
start_table(TABLESTYLE_NOBORDER);
start_row();
stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
customer_list_cells(_("Select a customer: "), 'customer_id', null, true, true);
submit_cells('SearchOrders', _("Search"), '', _('Select documents'), 'default');
hidden('OutstandingOnly', $_POST['OutstandingOnly']);
end_row();
end_table(1);
//---------------------------------------------------------------------------------------------
if (isset($_POST['SelectStockFromList']) && $_POST['SelectStockFromList'] != "" && $_POST['SelectStockFromList'] != ALL_TEXT) {
$selected_stock_item = $_POST['SelectStockFromList'];
} else {
} else {
$outstanding_only = 0;
page(tr("Search Dimensions"), false, false, "", $js);
}
//--------------------------------------------------------------------------------------
if (isset($_GET["stock_id"])) {
$_POST['SelectedStockItem'] = $_GET["stock_id"];
}
//--------------------------------------------------------------------------------------
start_form(false, true, $_SERVER['PHP_SELF'] . "?outstanding_only=" . $outstanding_only . SID);
start_table("class='tablestyle_noborder'");
start_row();
ref_cells(tr("Reference:"), 'OrderNumber', null);
number_list_cells(tr("Type"), 'type_', null, 0, 2);
date_cells(tr("From:"), 'FromDate', null, 0, 0, -5);
date_cells(tr("To:"), 'ToDate');
check_cells(tr("Only Overdue:"), 'OverdueOnly', null);
if (!$outstanding_only) {
check_cells(tr("Only Open:"), 'OpenOnly', null);
} else {
$_POST['OpenOnly'] = 1;
}
submit_cells('SearchOrders', tr("Search"));
end_row();
end_table();
end_form();
$dim = get_company_pref('use_dimension');
$sql = "SELECT * FROM dimensions WHERE id > 0";
if ($dim == 1) {
$sql .= " AND type_=1";
}
if (!isset($_POST['ship_via'])) {
$_POST['ship_via'] = $_SESSION['Items']->ship_via;
}
label_cell(tr("Shipping Company"), "class='tableheader2'");
shippers_list_cells(null, 'ship_via', $_POST['ship_via']);
if (!isset($_POST['InvoiceDate']) || !is_date($_POST['InvoiceDate'])) {
$_POST['InvoiceDate'] = Today();
if (!is_date_in_fiscalyear($_POST['InvoiceDate'])) {
$_POST['InvoiceDate'] = end_fiscalyear();
}
}
date_cells(tr("Date"), 'InvoiceDate', $_POST['InvoiceDate'], 0, 0, 0, "class='tableheader2'");
if (!isset($_POST['due_date']) || !is_date($_POST['due_date'])) {
$_POST['due_date'] = get_invoice_duedate($_SESSION['Items']->customer_id, $_POST['InvoiceDate']);
}
date_cells(tr("Due Date"), 'due_date', $_POST['due_date'], 0, 0, 0, "class='tableheader2'");
end_row();
end_table();
display_heading(tr("Invoice Items"));
start_table("{$table_style} width=80%");
$th = array(tr("Item Code"), tr("Item Description"), tr("Date"), tr("Description"), tr("Delivered"), tr("Units"), tr("Invoiced"), tr("This Invoice"), tr("Price"), tr("Tax Type"), tr("Discount"), tr("Total"));
if ($is_batch_invoice) {
$th[] = tr("DN");
$th[] = "";
}
if ($is_edition) {
$th[4] = tr("Credited");
}
table_header($th);
$k = 0;
$has_marked = false;
