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()
{
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');
check_cells(_("Net Output/Input:"), 'NetAmounts', null);
submit_cells('Show', _("Show"), '', '', 'default');
end_row();
end_table();
end_form();
}
function render($id, $title)
{
global $path_to_root;
include_once $path_to_root . "/includes/ui.inc";
$end_date = date2sql(add_days(Today(), $this->days_future));
$role_id = $_SESSION["wa_current_user"]->access;
$sql = "SELECT id, description, next_date FROM " . TB_PREF . "dashboard_reminders " . " WHERE next_date < '{$end_date}'" . " AND role_id = '{$role_id}'";
if ($this->data_filter != '') {
$sql .= ' AND ' . $this->data_filter;
}
$sql .= " ORDER BY next_date";
$result = db_query($sql);
br();
$th = array(_("Actioned"), _("Date"), _("Description"));
start_table(TABLESTYLE, "id='reminder' width=98%");
table_header($th);
$k = 0;
//row colour counter
while ($myrow = db_fetch($result)) {
$nextdate = sql2date($myrow["next_date"]);
if (date1_greater_date2(Today(), $nextdate)) {
$extra = "class='reminder_overdue'";
} elseif (Today() == $nextdate) {
$extra = "class='reminder_due'";
} else {
$extra = "class='reminder'";
}
alt_table_row_color($k);
$js = 'setTimeout(function(){updateToDoData(' . $myrow["id"] . ');}, 0);';
check_cells(null, null, null, $js);
label_cell($nextdate, $extra);
label_cell("<pre>" . $myrow["description"] . "</pre>", $extra);
end_row();
}
end_table(1);
}
function company_extensions($id)
{
start_table(TABLESTYLE);
$th = array(_("Extension"), _("Modules provided"), _("Options provided"), _("Active"));
$mods = get_company_extensions();
$exts = get_company_extensions($id);
foreach ($mods as $key => $ins) {
foreach ($exts as $ext) {
if ($ext['name'] == $ins['name']) {
$mods[$key]['active'] = @$ext['active'];
continue 2;
}
}
}
$mods = array_natsort($mods, null, 'name');
table_header($th);
$k = 0;
foreach ($mods as $i => $mod) {
if ($mod['type'] != 'extension') {
continue;
}
alt_table_row_color($k);
label_cell($mod['name']);
$entries = fmt_titles(@$mod['entries']);
$tabs = fmt_titles(@$mod['tabs']);
label_cell($tabs);
label_cell($entries);
check_cells(null, 'Active' . $i, @$mod['active'] ? 1 : 0, false, false, "align='center'");
end_row();
}
end_table(1);
submit_center('Refresh', _('Update'), true, false, 'default');
}
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_']) : "";
}
function systype_name($dummy, $type)
{
}
$Ajax->activate('orders_tbl');
}
//--------------------------------------------------------------------------------------
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);
locations_list_cells(_("at Location:"), 'StockLocation', null, true);
check_cells(_("Only Overdue:"), 'OverdueOnly', null);
if ($outstanding_only == 0) {
check_cells(_("Only Open:"), 'OpenOnly', null);
}
stock_manufactured_items_list_cells(_("for item:"), 'SelectedStockItem', null, true);
submit_cells('SearchOrders', _("Search"), '', _('Select documents'), 'default');
end_row();
end_table();
//-----------------------------------------------------------------------------
function check_overdue($row)
{
return !$row["closed"] && date_diff2(Today(), sql2date($row["required_by"]), "d") > 0;
}
function view_link($dummy, $order_no)
{
return get_trans_view_str(ST_WORKORDER, $order_no);
}
function view_stock($row)
submit_center('submit', _("Add New Customer"), true, '', 'default');
} else {
submit_center_first('submit', _("Update Customer"), _('Update customer data'), @$_REQUEST['popup'] ? true : 'default');
submit_return('select', $selected_id, _("Select this customer and return to document entry."));
submit_center_last('delete', _("Delete Customer"), _('Delete customer data if have been never used'), true);
}
div_end();
}
//--------------------------------------------------------------------------------------------
check_db_has_sales_types(_("There are no sales types defined. Please define at least one sales type before adding a customer."));
start_form();
if (db_has_customers()) {
start_table(TABLESTYLE_NOBORDER);
start_row();
customer_list_cells(_("Select a customer: "), 'customer_id', null, _('New customer'), true, check_value('show_inactive'));
check_cells(_("Show inactive:"), 'show_inactive', null, true);
end_row();
end_table();
if (get_post('_show_inactive_update')) {
$Ajax->activate('customer_id');
set_focus('customer_id');
}
} else {
hidden('customer_id');
}
if (!$selected_id) {
unset($_POST['_tabs_sel']);
}
// force settings tab for new customer
tabbed_content_start('tabs', array('settings' => array(_('&General settings'), $selected_id), 'contacts' => array(_('&Contacts'), $selected_id), 'transactions' => array(_('&Transactions'), $selected_id), 'orders' => array(_('Sales &Orders'), $selected_id)));
switch (get_post('_tabs_sel')) {
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');
}
submit_cells('SearchOrders', _("Search"), '', _('Select documents'), 'default');
hidden('order_view_mode', $_POST['order_view_mode']);
hidden('type', $trans_type);
end_row();
end_table(1);
//---------------------------------------------------------------------------------------------
// Orders inquiry table
//
$sql = get_sql_for_sales_orders_view($selected_customer, $trans_type, $_POST['OrderNumber'], $_POST['order_view_mode'], @$selected_stock_item, @$_POST['OrdersAfterDate'], @$_POST['OrdersToDate'], @$_POST['OrderReference'], $_POST['StockLocation'], $_POST['customer_id']);
if ($trans_type == ST_SALESORDER) {
$cols = array(_("Order #") => array('fun' => 'view_link'), _("Ref"), _("Customer"), _("Branch"), _("Cust Order Ref"), _("Order Date") => 'date', _("Required By") => array('type' => 'date', 'ord' => ''), _("Delivery To"), _("Order Total") => array('type' => 'amount', 'ord' => ''), 'Type' => 'skip', _("Currency") => array('align' => 'center'));
} else {
$cols = array(_("Quote #") => array('fun' => 'view_link'), _("Ref"), _("Customer"), _("Branch"), _("Cust Order Ref"), _("Quote Date") => 'date', _("Valid until") => array('type' => 'date', 'ord' => ''), _("Delivery To"), _("Quote Total") => array('type' => 'amount', 'ord' => ''), 'Type' => 'skip', _("Currency") => array('align' => 'center'));
}
//
if (get_post('Search')) {
$Ajax->activate('journal_tbl');
}
//--------------------------------------------------------------------------------------
if (!isset($_POST['filterType'])) {
$_POST['filterType'] = -1;
}
start_form();
start_table(TABLESTYLE_NOBORDER);
start_row();
ref_cells(_("Reference:"), 'Ref', '', null, _('Enter reference fragment or leave empty'));
journal_types_list_cells(_("Type:"), "filterType");
date_cells(_("From:"), 'FromDate', '', null, 0, -1, 0);
date_cells(_("To:"), 'ToDate');
check_cells(_("Show closed:"), 'AlsoClosed', null);
submit_cells('Search', _("Search"), '', '', 'default');
end_row();
start_row();
ref_cells(_("Memo:"), 'Memo', '', null, _('Enter memo fragment or leave empty'));
end_row();
end_table();
function journal_pos($row)
{
return $row['gl_seq'] ? $row['gl_seq'] : '-';
}
function systype_name($dummy, $type)
{
global $systypes_array;
return $systypes_array[$type];
}
$exemptions = get_item_tax_type_exemptions($selected_id);
if (db_num_rows($exemptions) > 0) {
while ($exmp = db_fetch($exemptions)) {
$_POST['ExemptTax' . $exmp["tax_type_id"]] = 1;
}
}
}
hidden('selected_id', $selected_id);
}
text_row_ex(_("Description:"), 'name', 50);
yesno_list_row(_("Is Fully Tax-exempt:"), 'exempt', null, "", "", true);
end_table(1);
if (!isset($_POST['exempt']) || $_POST['exempt'] == 0) {
display_note(_("Select which taxes this item tax type is exempt from."), 0, 1);
start_table(TABLESTYLE2);
$th = array(_("Tax Name"), _("Rate"), _("Is exempt"));
table_header($th);
$tax_types = get_all_tax_types_simple();
while ($myrow = db_fetch($tax_types)) {
alt_table_row_color($k);
label_cell($myrow["name"]);
label_cell(percent_format($myrow["rate"]) . " %", "nowrap align=right");
check_cells("", 'ExemptTax' . $myrow["id"], null);
end_row();
}
end_table(1);
}
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
//------------------------------------------------------------------------------------
end_page();
foreach ($installers as $i => $inst) {
alt_table_row_color($k);
start_row();
label_cell($inst->version);
label_cell($inst->description);
label_cell($inst->sql ? $inst->sql : '<i>' . _('None') . '</i>', 'align=center');
// this is checked only for first (site admin) company,
// but in fact we should always upgrade all data sets after
// source upgrade.
$check = $inst->installed(TB_PREF);
if ($check === true) {
label_cell(_("Installed"));
} else {
if (!$check) {
check_cells(null, 'install_' . $i, 0);
} else {
label_cell("<span class=redfg>" . sprintf(_("Partially installed (%s)"), $check) . "</span>");
$partial++;
}
}
check_cells(null, 'force_' . $i, 0);
end_row();
}
end_table(1);
if ($partial != 0) {
display_note(_("Database upgrades marked as partially installed cannot be installed automatically.\nYou have to clean database manually to enable them, or try to perform forced upgrade."));
br();
}
submit_center('Upgrade', _('Upgrade system'), true, _('Save database and perform upgrade'), 'process');
end_form();
end_page();
continue;
}
$newsec = $parms[0] >> 8 & 0xff;
$newext = $parms[0] >> 16;
if ($newsec != $sec || $newext != $ext && $newsec > 99) {
// features set selection
$ext = $newext;
$sec = $newsec;
$m = $parms[0] & ~0xff;
// if(!isset($security_sections[$m]))
// display_error(sprintf("Bad section %X:", $m));
label_row($security_sections[$m] . ':', checkbox(null, 'Section' . $m, null, true, _("On/off set of features")), "class='tableheader2'", "class='tableheader'");
}
if (check_value('Section' . $m)) {
alt_table_row_color($k);
check_cells($parms[1], 'Area' . $parms[0], null, false, '', "align='center'");
end_row();
} else {
hidden('Area' . $parms[0]);
}
}
end_table(1);
div_end();
div_start('controls');
if ($new_role) {
submit_center_first('Update', _("Update view"), '', null);
submit_center_last('addupdate', _("Insert New Role"), '', 'default');
} else {
submit_center_first('addupdate', _("Save Role"), '', 'default');
submit('Update', _("Update view"), true, '', null);
submit('clone', _("Clone This Role"), true, '', true);
}
if (isset($_GET['ToDate'])) {
$_POST['TransToDate'] = $_GET['ToDate'];
}
//------------------------------------------------------------------------------------------------
start_form(false, true);
if (!isset($_POST['supplier_id'])) {
$_POST['supplier_id'] = get_global_supplier();
}
start_table("class='tablestyle_noborder'");
start_row();
supplier_list_cells(tr("Select a supplier: "), 'supplier_id', $_POST['supplier_id'], true);
date_cells(tr("From:"), 'TransAfterDate', null, -30);
date_cells(tr("To:"), 'TransToDate', null, 1);
supp_allocations_list_cells("filterType", null);
check_cells(tr("show settled:"), 'showSettled', null);
submit_cells('Refresh Inquiry', tr("Search"));
set_global_supplier($_POST['supplier_id']);
end_row();
end_table();
end_form();
//------------------------------------------------------------------------------------------------
function get_transactions()
{
global $db;
$date_after = date2sql($_POST['TransAfterDate']);
$date_to = date2sql($_POST['TransToDate']);
// Sherifoz 22.06.03 Also get the description
$sql = "SELECT supp_trans.type, supp_trans.trans_no,\n \tsupp_trans.tran_date, supp_trans.reference, supp_trans.supp_reference,\n \t(supp_trans.ov_amount + supp_trans.ov_gst + supp_trans.ov_discount) AS TotalAmount, supp_trans.alloc AS Allocated,\n\t\t((supp_trans.type = 20 OR supp_trans.type = 21) AND supp_trans.due_date < '" . date2sql(Today()) . "') AS OverDue,\n\t\tsuppliers.curr_code, suppliers.supp_name, supp_trans.due_date\n \tFROM supp_trans, suppliers\n \tWHERE suppliers.supplier_id = supp_trans.supplier_id\n \tAND supp_trans.tran_date >= '{$date_after}'\n \tAND supp_trans.tran_date <= '{$date_to}'";
if ($_POST['supplier_id'] != reserved_words::get_all()) {
$sql .= " AND supp_trans.supplier_id = '" . $_POST['supplier_id'] . "'";
