function edit_allocations_for_transaction($type, $trans_no)
{
global $systypes_array;
$cart = $_SESSION['alloc'];
display_heading(sprintf(_("Allocation of %s # %d"), $systypes_array[$cart->type], $cart->trans_no));
display_heading($cart->person_name);
display_heading2(_("Date:") . " <b>" . $cart->date_ . "</b>");
display_heading2(_("Total:") . " <b>" . price_format($cart->bank_amount) . ' ' . $cart->currency . "</b>");
if ($cart->currency != $cart->person_curr) {
$total = _("Total in clearing currency:") . " <b>" . price_format($cart->amount) . "</b>" . sprintf(" %s (%s %s/%s)", $cart->person_curr, exrate_format($cart->bank_amount / $cart->amount), $cart->currency, $cart->person_curr);
display_heading2($total);
}
echo "<br>";
start_form();
div_start('alloc_tbl');
if (count($cart->allocs) > 0) {
show_allocatable(true);
submit_center_first('UpdateDisplay', _("Refresh"), _('Start again allocation of selected amount'), true);
submit('Process', _("Process"), true, _('Process allocations'), 'default');
submit_center_last('Cancel', _("Back to Allocations"), _('Abandon allocations and return to selection of allocatable amounts'), 'cancel');
} else {
display_note(_("There are no unsettled transactions to allocate."), 0, 1);
submit_center('Cancel', _("Back to Allocations"), true, _('Abandon allocations and return to selection of allocatable amounts'), 'cancel');
}
div_end();
end_form();
}
function subpage_title($txt)
{
global $path_to_root;
echo '<center><img src="' . $path_to_root . '/themes/default/images/logo_frontaccounting.png" width="250" height="50" alt="Logo" />
</center>';
$page = @$_POST['Page'] ? $_POST['Page'] : 1;
display_heading($page == 6 ? $txt : _("FrontAccouting ERP Installation Wizard") . '<br>' . sprintf(_('Step %d: %s'), $page, $txt));
br();
}
function subpage_title($txt)
{
global $path_to_root;
echo '<center><img src="' . $path_to_root . '/themes/erp/images/logo.png" width="413" height="97" alt="Logo" />
</center>';
$page = @$_POST['Page'] ? $_POST['Page'] : 1;
display_heading($page == 6 ? $txt : _("SerbizHub Suite ERP Installation Wizard") . '<br>' . sprintf(_('Step %d: %s'), $page, $txt));
br();
}
function render($id, $title)
{
global $path_to_root;
if (!isset($this->top)) {
$this->top = 10;
}
global $path_to_root;
$pg = new graph();
$begin = begin_fiscalyear();
$today = Today();
$begin1 = date2sql($begin);
$today1 = date2sql($today);
$sql = "SELECT SUM(-t.amount) AS total, d.reference, d.name FROM\n " . TB_PREF . "gl_trans AS t," . TB_PREF . "dimensions AS d WHERE\n (t.dimension_id = d.id OR t.dimension2_id = d.id) AND\n t.tran_date >= '{$begin1}' AND t.tran_date <= '{$today1}' ";
if ($this->data_filter != '') {
$sql .= ' AND ' . $this->data_filter;
}
$sql .= "GROUP BY d.id ORDER BY total DESC LIMIT " . $this->top;
$result = db_query($sql, "Transactions could not be calculated");
if ($this->graph_type == 'Table') {
$title = _("Top 10 Dimensions in fiscal year");
br(2);
display_heading($title);
br();
$th = array(_("Dimension"), _("Amount"));
start_table(TABLESTYLE, "width=98%");
table_header($th);
$k = 0;
//row colour counter
while ($myrow = db_fetch($result)) {
alt_table_row_color($k);
label_cell($myrow['reference'] . " " . $myrow["name"]);
amount_cell($myrow['total']);
end_row();
}
end_table(2);
} else {
$pg = new graph();
$i = 0;
while ($myrow = db_fetch($result)) {
$pg->x[$i] = $myrow['reference'] . " " . $myrow["name"];
$pg->y[$i] = abs($myrow['total']);
$i++;
}
$pg->title = $title;
$pg->axis_x = _("Dimension");
$pg->axis_y = _("Amount");
$pg->graphic_1 = $today;
$pg->type = 5;
$pg->skin = 1;
$pg->built_in = false;
$filename = company_path() . "/pdf_files/" . uniqid("") . ".png";
$pg->display($filename, true);
echo "<img src='{$filename}' border='0' alt='{$title}' style='max-width:100%'>";
}
}
function edit_allocations_for_transaction($type, $trans_no)
{
global $systypes_array;
start_form();
display_heading(_("Allocation of") . " " . $systypes_array[$_SESSION['alloc']->type] . " # " . $_SESSION['alloc']->trans_no);
display_heading($_SESSION['alloc']->person_name);
display_heading2(_("Date:") . " <b>" . $_SESSION['alloc']->date_ . "</b>");
display_heading2(_("Total:") . " <b>" . price_format(-$_SESSION['alloc']->amount) . "</b>");
echo "<br>";
div_start('alloc_tbl');
if (count($_SESSION['alloc']->allocs) > 0) {
show_allocatable(true);
submit_center_first('UpdateDisplay', _("Refresh"), _('Start again allocation of selected amount'), true);
submit('Process', _("Process"), true, _('Process allocations'), 'default');
submit_center_last('Cancel', _("Back to Allocations"), _('Abandon allocations and return to selection of allocatable amounts'), 'cancel');
} else {
display_note(_("There are no unsettled transactions to allocate."), 0, 1);
submit_center('Cancel', _("Back to Allocations"), true, _('Abandon allocations and return to selection of allocatable amounts'), 'cancel');
}
div_end();
end_form();
}
function render($id, $title)
{
global $path_to_root;
include_once $path_to_root . "/includes/ui.inc";
if (!defined('FLOAT_COMP_DELTA')) {
define('FLOAT_COMP_DELTA', 0.004);
}
$today = date2sql(Today());
$sql = "SELECT trans.trans_no, trans.reference, trans.tran_date, trans.due_date, debtor.debtor_no,\n debtor.name, branch.br_name, debtor.curr_code,\n (trans.ov_amount + trans.ov_gst + trans.ov_freight\n + trans.ov_freight_tax + trans.ov_discount) AS total,\n (trans.ov_amount + trans.ov_gst + trans.ov_freight\n + trans.ov_freight_tax + trans.ov_discount - trans.alloc) AS remainder,\n DATEDIFF('{$today}', trans.due_date) AS days\n FROM " . TB_PREF . "debtor_trans as trans, " . TB_PREF . "debtors_master as debtor,\n " . TB_PREF . "cust_branch as branch\n WHERE debtor.debtor_no = trans.debtor_no AND trans.branch_code = branch.branch_code\n AND trans.type = " . ST_SALESINVOICE . " AND (trans.ov_amount + trans.ov_gst + trans.ov_freight\n + trans.ov_freight_tax + trans.ov_discount - trans.alloc) > " . FLOAT_COMP_DELTA . "\n AND DATEDIFF('{$today}', trans.due_date) > 0 ORDER BY days DESC";
if ($this->data_filter != '') {
$sql .= ' AND ' . $this->data_filter;
}
$result = db_query($sql);
$title = db_num_rows($result) . _(" Overdue Sales Invoices");
br(1);
display_heading($title);
br();
$th = array("#", _("Date"), _("Due Date"), _("Customer"), _("Currency"), _("Total"), _("Remainder"), _("Days"));
start_table(TABLESTYLE, "width=98%");
table_header($th);
$k = 0;
//row colour counter
while ($myrow = db_fetch($result)) {
alt_table_row_color($k);
label_cell(get_trans_view_str(ST_SALESINVOICE, $myrow["trans_no"]));
label_cell(sql2date($myrow['tran_date']));
label_cell(sql2date($myrow['due_date']));
$name = $myrow["debtor_no"] . " " . $myrow["name"];
label_cell($name);
label_cell($myrow['curr_code']);
amount_cell($myrow['total']);
amount_cell($myrow['remainder']);
label_cell($myrow['days'], "align='right'");
end_row();
}
end_table(1);
}
<?php
$page_security = 2;
$path_to_root = "../..";
include $path_to_root . "/purchasing/includes/po_class.inc";
include $path_to_root . "/includes/session.inc";
page(tr("View Purchase Order Delivery"), true);
include $path_to_root . "/purchasing/includes/purchasing_ui.inc";
if (!isset($_GET['trans_no'])) {
die("<BR>" . tr("This page must be called with a Purchase Order Delivery number to review."));
}
$purchase_order = new purch_order();
read_grn($_GET["trans_no"], $purchase_order);
display_heading(tr("Purchase Order Delivery") . " #" . $_GET['trans_no']);
echo "<BR>";
display_grn_summary($purchase_order);
display_heading2(tr("Line Details"));
start_table("colspan=9 {$table_style} width=90%");
$th = array(tr("Item Code"), tr("Item Description"), tr("Delivery Date"), tr("Quantity"), tr("Unit"), tr("Price"), tr("Line Total"), tr("Quantity Invoiced"));
table_header($th);
$total = 0;
$k = 0;
//row colour counter
foreach ($purchase_order->line_items as $stock_item) {
$line_total = $stock_item->qty_received * $stock_item->price;
alt_table_row_color($k);
label_cell($stock_item->stock_id);
label_cell($stock_item->item_description);
label_cell($stock_item->req_del_date, "nowrap align=right");
qty_cell($stock_item->qty_received);
label_cell($stock_item->units);
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
$page_security = 'SA_SUPPTRANSVIEW';
$path_to_root = "../..";
include $path_to_root . "/purchasing/includes/po_class.inc";
include $path_to_root . "/includes/session.inc";
include $path_to_root . "/purchasing/includes/purchasing_ui.inc";
$js = "";
if ($use_popup_windows) {
$js .= get_js_open_window(900, 500);
}
page(_($help_context = "View Purchase Order"), true, false, "", $js);
if (!isset($_GET['trans_no'])) {
die("<br>" . _("This page must be called with a purchase order number to review."));
}
display_heading(_("Purchase Order") . " #" . $_GET['trans_no']);
$purchase_order = new purch_order();
read_po($_GET['trans_no'], $purchase_order);
echo "<br>";
display_po_summary($purchase_order, true);
start_table(TABLESTYLE, "width='90%'", 6);
echo "<tr><td valign=top>";
// outer table
display_heading2(_("Line Details"));
start_table(TABLESTYLE, "width='100%'");
$th = array(_("Item Code"), _("Item Description"), _("Quantity"), _("Unit"), _("Price"), _("Requested By"), _("Line Total"), _("Quantity Received"), _("Quantity Invoiced"));
table_header($th);
$total = $k = 0;
$overdue_items = false;
foreach ($purchase_order->line_items as $stock_item) {
$line_total = $stock_item->quantity * $stock_item->price;
$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'] = "";
}
$sql = get_sql_for_bank_account_reconcile($_POST['bank_account'], get_post('reconcile_date'));
$act = get_bank_account($_POST["bank_account"]);
display_heading($act['bank_account_name'] . " - " . $act['bank_curr_code']);
$cols = array(_("Type") => array('fun' => 'systype_name', 'ord' => ''), _("#") => array('fun' => 'trans_view', 'ord' => ''), _("Reference"), _("Date") => 'date', _("Debit") => array('align' => 'right', 'fun' => 'fmt_debit'), _("Credit") => array('align' => 'right', 'insert' => true, 'fun' => 'fmt_credit'), _("Person/Item") => array('fun' => 'fmt_person'), array('insert' => true, 'fun' => 'gl_view'), "X" => array('insert' => true, 'fun' => 'rec_checkbox'));
$table =& new_db_pager('trans_tbl', $sql, $cols);
$table->width = "80%";
display_db_pager($table);
br(1);
submit_center('Reconcile', _("Reconcile"), true, '', null);
end_form();
//------------------------------------------------------------------------------------------------
end_page();
$_POST[$line->line_no] = qty_format(0);
}
if (!isset($_POST['DefaultReceivedDate']) || $_POST['DefaultReceivedDate'] == "") {
$_POST['DefaultReceivedDate'] = Today();
}
$_SESSION['PO']->line_items[$line->line_no]->receive_qty = input_num($line->line_no);
if (isset($_POST[$line->stock_id . "Desc"]) && strlen($_POST[$line->stock_id . "Desc"]) > 0) {
$_SESSION['PO']->line_items[$line->line_no]->item_description = $_POST[$line->stock_id . "Desc"];
}
}
}
//--------------------------------------------------------------------------------------------------
if (isset($_POST['ProcessGoodsReceived'])) {
process_receive_po();
}
//--------------------------------------------------------------------------------------------------
start_form(false, true);
display_grn_summary($_SESSION['PO'], true);
display_heading(tr("Items to Receive"));
display_po_receive_items();
echo "<br><center>";
submit('Update', tr("Update"));
echo " ";
submit('ProcessGoodsReceived', tr("Process Receive Items"));
echo "</center>";
end_form();
//--------------------------------------------------------------------------------------------------
end_page();
?>
include_once $path_to_root . "/purchasing/includes/purchasing_db.inc";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/purchasing/includes/purchasing_ui.inc";
$js = "";
if ($use_popup_windows) {
$js .= get_js_open_window(900, 500);
}
page(_($help_context = "View Supplier Credit Note"), true, false, "", $js);
if (isset($_GET["trans_no"])) {
$trans_no = $_GET["trans_no"];
} elseif (isset($_POST["trans_no"])) {
$trans_no = $_POST["trans_no"];
}
$supp_trans = new supp_trans(ST_SUPPCREDIT);
read_supp_invoice($trans_no, ST_SUPPCREDIT, $supp_trans);
display_heading("<font color=red>" . _("SUPPLIER CREDIT NOTE") . " # " . $trans_no . "</font>");
echo "<br>";
start_table(TABLESTYLE, "width=95%");
start_row();
label_cells(_("Supplier"), $supp_trans->supplier_name, "class='tableheader2'");
label_cells(_("Reference"), $supp_trans->reference, "class='tableheader2'");
label_cells(_("Supplier's Reference"), $supp_trans->supp_reference, "class='tableheader2'");
end_row();
start_row();
label_cells(_("Invoice Date"), $supp_trans->tran_date, "class='tableheader2'");
label_cells(_("Due Date"), $supp_trans->due_date, "class='tableheader2'");
label_cells(_("Currency"), get_supplier_currency($supp_trans->supplier_id), "class='tableheader2'");
end_row();
comments_display_row(ST_SUPPCREDIT, $trans_no);
end_table(1);
$total_gl = display_gl_items($supp_trans, 3);
//---------
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%");
$new = $_SESSION['Items']->trans_no == 0;
$th = array(_("Item Code"), _("Item Description"), $new ? _("Ordered") : _("Max. delivery"), _("Units"), $new ? _("Delivered") : _("Invoiced"), _("This Delivery"), _("Price"), _("Tax Type"), _("Discount"), _("Total"));
table_header($th);
$k = 0;
$has_marked = false;
foreach ($_SESSION['Items']->line_items as $line => $ln_itm) {
if ($ln_itm->quantity == $ln_itm->qty_done) {
continue;
//this line is fully delivered
}
if (isset($_POST['_Location_update']) || isset($_POST['clear_quantity']) || isset($_POST['reset_quantity'])) {
// reset quantity
$ln_itm->qty_dispatched = $ln_itm->quantity - $ln_itm->qty_done;
$to_trans = $trans2;
} else {
$from_trans = $trans2;
$to_trans = $trans1;
}
$company_currency = get_company_currency();
$show_currencies = false;
$show_both_amounts = false;
if ($from_trans['bank_curr_code'] != $company_currency || $to_trans['bank_curr_code'] != $company_currency) {
$show_currencies = true;
}
if ($from_trans['bank_curr_code'] != $to_trans['bank_curr_code']) {
$show_currencies = true;
$show_both_amounts = true;
}
display_heading($systypes_array[ST_BANKTRANSFER] . " #{$trans_no}");
echo "<br>";
start_table(TABLESTYLE, "width=80%");
start_row();
label_cells(_("From Bank Account"), $from_trans['bank_account_name'], "class='tableheader2'");
if ($show_currencies) {
label_cells(_("Currency"), $from_trans['bank_curr_code'], "class='tableheader2'");
}
label_cells(_("Amount"), number_format2(-$from_trans['amount'], user_price_dec()), "class='tableheader2'", "align=right");
if ($show_currencies) {
end_row();
start_row();
}
label_cells(_("To Bank Account"), $to_trans['bank_account_name'], "class='tableheader2'");
if ($show_currencies) {
label_cells(_("Currency"), $to_trans['bank_curr_code'], "class='tableheader2'");
if (isset($_GET["trans_no"])) {
$trans_no = $_GET["trans_no"];
}
$receipt = get_supp_trans($trans_no, ST_SUPPAYMENT);
$company_currency = get_company_currency();
$show_currencies = false;
$show_both_amounts = false;
if ($receipt['bank_curr_code'] != $company_currency || $receipt['curr_code'] != $company_currency) {
$show_currencies = true;
}
if ($receipt['bank_curr_code'] != $receipt['curr_code']) {
$show_currencies = true;
$show_both_amounts = true;
}
echo "<center>";
display_heading(_("Payment to Supplier") . " #{$trans_no}");
echo "<br>";
start_table(TABLESTYLE2, "width=80%");
start_row();
label_cells(_("To Supplier"), $receipt['supplier_name'], "class='tableheader2'");
label_cells(_("From Bank Account"), $receipt['bank_account_name'], "class='tableheader2'");
label_cells(_("Date Paid"), sql2date($receipt['tran_date']), "class='tableheader2'");
end_row();
start_row();
if ($show_currencies) {
label_cells(_("Payment Currency"), $receipt['bank_curr_code'], "class='tableheader2'");
}
label_cells(_("Amount"), number_format2(-$receipt['bank_amount'], user_price_dec()), "class='tableheader2'");
if ($receipt['ov_discount'] != 0) {
label_cells(_("Discount"), number_format2(-$receipt['ov_discount'] * $receipt['rate'], user_price_dec()), "class='tableheader2'");
} else {
$path_to_root = "../..";
include_once $path_to_root . "/sales/includes/cart_class.inc";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/sales/includes/sales_ui.inc";
include_once $path_to_root . "/sales/includes/sales_db.inc";
$js = "";
if ($use_popup_windows) {
$js .= get_js_open_window(900, 600);
}
if ($_GET['trans_type'] == ST_SALESQUOTE) {
page(_($help_context = "View Sales Quotation"), true, false, "", $js);
display_heading(sprintf(_("Sales Quotation #%d"), $_GET['trans_no']));
} else {
page(_($help_context = "View Sales Order"), true, false, "", $js);
display_heading(sprintf(_("Sales Order #%d"), $_GET['trans_no']));
}
if (isset($_SESSION['View'])) {
unset($_SESSION['View']);
}
$_SESSION['View'] = new Cart($_GET['trans_type'], $_GET['trans_no']);
start_table(TABLESTYLE2, "width=95%", 5);
if ($_GET['trans_type'] != ST_SALESQUOTE) {
echo "<tr valign=top><td>";
display_heading2(_("Order Information"));
echo "</td><td>";
display_heading2(_("Deliveries"));
echo "</td><td>";
display_heading2(_("Invoices/Credits"));
echo "</td></tr>";
}
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 License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
$page_security = 'SA_ITEMSTRANSVIEW';
$path_to_root = "../..";
include $path_to_root . "/includes/session.inc";
page(_($help_context = "View Inventory Adjustment"), true);
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/inventory/includes/inventory_db.inc";
if (isset($_GET["trans_no"])) {
$trans_no = $_GET["trans_no"];
}
display_heading($systypes_array[ST_INVADJUST] . " #{$trans_no}");
br(1);
$adjustment_items = get_stock_adjustment_items($trans_no);
$k = 0;
$header_shown = false;
while ($adjustment = db_fetch($adjustment_items)) {
if (!$header_shown) {
$adjustment_type = get_movement_type($adjustment['person_id']);
start_table(TABLESTYLE2, "width='90%'");
start_row();
label_cells(_("At Location"), $adjustment['location_name'], "class='tableheader2'");
label_cells(_("Reference"), $adjustment['reference'], "class='tableheader2'", "colspan=6");
label_cells(_("Date"), sql2date($adjustment['tran_date']), "class='tableheader2'");
label_cells(_("Adjustment Type"), $adjustment_type['name'], "class='tableheader2'");
end_row();
comments_display_row(ST_INVADJUST, $trans_no);
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
$page_security = 'SA_OPEN';
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/includes/packages.inc";
page(_($help_context = "Package Details"), true);
include_once $path_to_root . "/includes/ui.inc";
if (!isset($_GET['id'])) {
/*Script was not passed the correct parameters */
display_note(_("The script must be called with a valid package id to review the info for."));
end_page();
}
$filter = array('Version' => _('Available version'), 'Type' => _('Package type'), 'Name' => _('Package content'), 'Description' => _('Description'), 'Author' => _('Author'), 'Homepage' => _('Home page'), 'Maintenance' => _('Package maintainer'), 'InstallPath' => _('Installation path'), 'Depends' => _('Minimal software versions'), 'RTLDir' => _('Right to left'), 'Encoding' => _('Charset encoding'));
$pkg = get_package_info($_GET['id'], null, $filter);
display_heading(sprintf(_("Content information for package '%s'"), $_GET['id']));
br();
start_table(TABLESTYLE2, "width='80%'");
$th = array(_("Property"), _("Value"));
table_header($th);
foreach ($pkg as $field => $value) {
if ($value == '') {
continue;
}
start_row();
label_cells($field, nl2br(htmlentities(is_array($value) ? implode("\n", $value) : $value)), "class='tableheader2'");
end_row();
}
end_table(1);
end_page(true);
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();
$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(_("Invoice Items"));
div_start('Items');
start_table(TABLESTYLE, "width='80%'");
$th = array(_("Item Code"), _("Item Description"), _("Delivered"), _("Units"), _("Invoiced"), _("This Invoice"), _("Price"), _("Tax Type"), _("Discount"), _("Total"));
if ($is_batch_invoice) {
$th[] = _("DN");
$th[] = "";
}
if ($is_edition) {
$th[4] = _("Credited");
}
table_header($th);
$k = 0;
$has_marked = false;
$show_qoh = true;
$dn_line_cnt = 0;
<?php
$page_security = 1;
$path_to_root = "../..";
include $path_to_root . "/includes/session.inc";
page(tr("View Inventory Transfer"), true);
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/gl/includes/gl_db.inc";
if (isset($_GET["trans_no"])) {
$trans_no = $_GET["trans_no"];
}
$transfer_items = get_stock_transfer($trans_no);
$from_trans = $transfer_items[0];
$to_trans = $transfer_items[1];
display_heading(systypes::name(systypes::location_transfer()) . " #{$trans_no}");
echo "<br>";
start_table("{$table_style2} width=90%");
start_row();
label_cells(tr("Item"), $from_trans['stock_id'] . " - " . $from_trans['description'], "class='tableheader2'");
label_cells(tr("From Location"), $from_trans['location_name'], "class='tableheader2'");
label_cells(tr("To Location"), $to_trans['location_name'], "class='tableheader2'");
end_row();
start_row();
label_cells(tr("Reference"), $from_trans['reference'], "class='tableheader2'");
$adjustment_type = get_movement_type($from_trans['person_id']);
label_cells(tr("Adjustment Type"), $adjustment_type['name'], "class='tableheader2'");
label_cells(tr("Date"), sql2date($from_trans['tran_date']), "class='tableheader2'");
end_row();
comments_display_row(systypes::location_transfer(), $trans_no);
end_table(1);
function display_applications(&$waapp)
{
global $path_to_root, $use_popup_windows;
include_once "{$path_to_root}/includes/ui.inc";
include_once $path_to_root . "/reporting/includes/class.graphic.inc";
include $path_to_root . "/includes/system_tests.inc";
if ($use_popup_windows) {
echo "<script language='javascript'>\n";
echo get_js_open_window(900, 500);
echo "</script>\n";
}
$selected_app = $waapp->get_selected_application();
// first have a look through the directory,
// and remove old temporary pdfs and pngs
$dir = company_path() . '/pdf_files';
if ($d = @opendir($dir)) {
while (($file = readdir($d)) !== false) {
if (!is_file($dir . '/' . $file) || $file == 'index.php') {
continue;
}
// then check to see if this one is too old
$ftime = filemtime($dir . '/' . $file);
// seems 3 min is enough for any report download, isn't it?
if (time() - $ftime > 180) {
unlink($dir . '/' . $file);
}
}
closedir($d);
}
if ($selected_app->id == "orders") {
display_customer_topten();
} elseif ($selected_app->id == "AP") {
display_supplier_topten();
} elseif ($selected_app->id == "stock") {
display_stock_topten();
} elseif ($selected_app->id == "manuf") {
display_stock_topten(true);
} elseif ($selected_app->id == "proj") {
display_dimension_topten();
} elseif ($selected_app->id == "GL") {
display_gl_info();
} else {
$title = "Display System Diagnostics";
br(2);
display_heading($title);
br();
display_system_tests();
}
}
function edit_allocations_for_transaction($type, $trans_no)
{
global $table_style;
start_form(false, true);
display_heading(sprintf(tr("Allocation of %s # %d"), systypes::name($_SESSION['alloc']->type), $_SESSION['alloc']->trans_no));
display_heading($_SESSION['alloc']->person_name);
display_heading2(tr("Date:") . " <b>" . $_SESSION['alloc']->date_ . "</b>");
display_heading2(tr("Total:") . " <b>" . price_format($_SESSION['alloc']->amount) . "</b>");
echo "<br>";
if (count($_SESSION['alloc']->allocs) > 0) {
start_table($table_style);
$th = array(tr("Transaction Type"), tr("#"), tr("Date"), tr("Due Date"), tr("Amount"), tr("Other Allocations"), tr("This Allocation"), tr("Left to Allocate"), "", "");
table_header($th);
$k = $counter = $total_allocated = 0;
foreach ($_SESSION['alloc']->allocs as $allocn_item) {
alt_table_row_color($k);
label_cell(systypes::name($allocn_item->type));
label_cell(get_trans_view_str($allocn_item->type, $allocn_item->type_no));
label_cell($allocn_item->date_, "align=right");
label_cell($allocn_item->due_date, "align=right");
amount_cell($allocn_item->amount);
amount_cell($allocn_item->amount_allocated);
if (!check_num('amount' . $counter)) {
$_POST['amount' . $counter] = price_format($allocn_item->current_allocated);
}
amount_cells(null, 'amount' . $counter, $_POST['amount' . $counter]);
$un_allocated = round($allocn_item->amount - $allocn_item->amount_allocated, 6);
hidden("un_allocated" . $counter, $un_allocated);
amount_cell($un_allocated);
label_cell("<a href='#' name=Alloc{$counter} onclick='allocate_all(this.name.substr(5));return true;'>" . tr("All") . "</a>");
label_cell("<a href='#' name=DeAll{$counter} onclick='allocate_none(this.name.substr(5));return true;'>" . tr("None") . "</a>");
end_row();
$total_allocated += input_num('amount' . $counter);
$counter++;
}
label_row(tr("Total Allocated"), price_format($total_allocated), "colspan=6 align=right", "nowrap align=right id='total_allocated'");
if ($_SESSION['alloc']->amount - $total_allocated < 0) {
$font1 = "<font color=red>";
$font2 = "</font>";
} else {
$font1 = $font2 = "";
}
$left_to_allocate = $_SESSION['alloc']->amount - $total_allocated;
$left_to_allocate = price_format($left_to_allocate);
label_row(tr("Left to Allocate"), $font1 . $left_to_allocate . $font2, "colspan=6 align=right ", "nowrap align=right id='left_to_allocate'");
end_table(1);
hidden('TotalNumberOfAllocs', $counter);
// hidden('left_to_allocate', $left_to_allocate);
submit_center_first('UpdateDisplay', tr("Update"));
submit('Process', tr("Process"));
} else {
display_note(tr("There are no unsettled transactions to allocate."), 0, 1);
}
submit_center_last('Cancel', tr("Back to Allocations"));
end_form();
}
<?php
$page_security = 1;
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
page(tr("View Customer Payment"), true);
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/sales/includes/sales_db.inc";
if (isset($_GET["trans_no"])) {
$trans_id = $_GET["trans_no"];
}
$receipt = get_customer_trans($trans_id, systypes::cust_payment());
display_heading(sprintf(tr("Customer Payment #%d"), $trans_id));
echo "<br>";
start_table("{$table_style} width=80%");
start_row();
label_cells(tr("From Customer"), $receipt['DebtorName'], "class='tableheader2'");
label_cells(tr("Into Bank Account"), $receipt['bank_account_name'], "class='tableheader2'");
label_cells(tr("Date of Deposit"), sql2date($receipt['tran_date']), "class='tableheader2'");
end_row();
start_row();
label_cells(tr("Payment Currency"), $receipt['curr_code'], "class='tableheader2'");
label_cells(tr("Amount"), price_format($receipt['ov_amount']), "class='tableheader2'");
label_cells(tr("Discount"), price_format($receipt['ov_discount']), "class='tableheader2'");
end_row();
start_row();
label_cells(tr("Payment Type"), $receipt['BankTransType'], "class='tableheader2'");
label_cells(tr("Reference"), $receipt['reference'], "class='tableheader2'", "colspan=4");
end_row();
comments_display_row(systypes::cust_payment(), $trans_id);
include_once $path_to_root . "/gl/includes/gl_db.inc";
if (isset($_GET["trans_no"])) {
$trans_no = $_GET["trans_no"];
}
// get the pay-from bank payment info
$result = get_bank_trans(ST_BANKPAYMENT, $trans_no);
if (db_num_rows($result) != 1) {
display_db_error("duplicate payment bank transaction found", "");
}
$from_trans = db_fetch($result);
$company_currency = get_company_currency();
$show_currencies = false;
if ($from_trans['bank_curr_code'] != $company_currency) {
$show_currencies = true;
}
display_heading(_("GL Payment") . " #{$trans_no}");
echo "<br>";
start_table(TABLESTYLE, "width=80%");
if ($show_currencies) {
$colspan1 = 5;
$colspan2 = 8;
} else {
$colspan1 = 3;
$colspan2 = 6;
}
start_row();
label_cells(_("From Bank Account"), $from_trans['bank_account_name'], "class='tableheader2'");
if ($show_currencies) {
label_cells(_("Currency"), $from_trans['bank_curr_code'], "class='tableheader2'");
}
label_cells(_("Amount"), number_format2(-$from_trans['amount'], user_price_dec()), "class='tableheader2'", "align=right");
function show_results()
{
global $path_to_root, $systypes_array;
if (!isset($_POST["account"])) {
$_POST["account"] = null;
}
$act_name = $_POST["account"] ? get_gl_account_name($_POST["account"]) : "";
$dim = get_company_pref('use_dimension');
/*Now get the transactions */
if (!isset($_POST['Dimension'])) {
$_POST['Dimension'] = 0;
}
if (!isset($_POST['Dimension2'])) {
$_POST['Dimension2'] = 0;
}
$result = get_gl_transactions($_POST['TransFromDate'], $_POST['TransToDate'], -1, $_POST["account"], $_POST['Dimension'], $_POST['Dimension2'], null, input_num('amount_min'), input_num('amount_max'));
$colspan = $dim == 2 ? "6" : ($dim == 1 ? "5" : "4");
if ($_POST["account"] != null) {
display_heading($_POST["account"] . " " . $act_name);
}
// Only show balances if an account is specified AND we're not filtering by amounts
$show_balances = $_POST["account"] != null && input_num("amount_min") == 0 && input_num("amount_max") == 0;
start_table(TABLESTYLE);
$first_cols = array(_("Type"), _("#"), _("Date"));
if ($_POST["account"] == null) {
$account_col = array(_("Account"));
} else {
$account_col = array();
}
if ($dim == 2) {
$dim_cols = array(_("Dimension") . " 1", _("Dimension") . " 2");
} else {
if ($dim == 1) {
$dim_cols = array(_("Dimension"));
} else {
$dim_cols = array();
}
}
if ($show_balances) {
$remaining_cols = array(_("Person/Item"), _("Debit"), _("Credit"), _("Balance"), _("Memo"));
} else {
$remaining_cols = array(_("Person/Item"), _("Debit"), _("Credit"), _("Memo"));
}
$th = array_merge($first_cols, $account_col, $dim_cols, $remaining_cols);
table_header($th);
if ($_POST["account"] != null && is_account_balancesheet($_POST["account"])) {
$begin = "";
} else {
$begin = get_fiscalyear_begin_for_date($_POST['TransFromDate']);
if (date1_greater_date2($begin, $_POST['TransFromDate'])) {
$begin = $_POST['TransFromDate'];
}
$begin = add_days($begin, -1);
}
$bfw = 0;
if ($show_balances) {
$bfw = get_gl_balance_from_to($begin, $_POST['TransFromDate'], $_POST["account"], $_POST['Dimension'], $_POST['Dimension2']);
start_row("class='inquirybg'");
label_cell("<b>" . _("Opening Balance") . " - " . $_POST['TransFromDate'] . "</b>", "colspan={$colspan}");
display_debit_or_credit_cells($bfw, true);
label_cell("");
label_cell("");
end_row();
}
$running_total = $bfw;
$j = 1;
$k = 0;
//row colour counter
while ($myrow = db_fetch($result)) {
alt_table_row_color($k);
$running_total += $myrow["amount"];
$trandate = sql2date($myrow["tran_date"]);
label_cell($systypes_array[$myrow["type"]]);
label_cell(get_gl_view_str($myrow["type"], $myrow["type_no"], $myrow["type_no"], true));
label_cell($trandate);
if ($_POST["account"] == null) {
label_cell($myrow["account"] . ' ' . get_gl_account_name($myrow["account"]));
}
if ($dim >= 1) {
label_cell(get_dimension_string($myrow['dimension_id'], true));
}
if ($dim > 1) {
label_cell(get_dimension_string($myrow['dimension2_id'], true));
}
label_cell(payment_person_name($myrow["person_type_id"], $myrow["person_id"]));
display_debit_or_credit_cells($myrow["amount"]);
if ($show_balances) {
amount_cell($running_total);
}
if ($myrow['memo_'] == "") {
$myrow['memo_'] = get_comments_string($myrow['type'], $myrow['type_no']);
}
label_cell($myrow['memo_']);
end_row();
$j++;
if ($j == 12) {
$j = 1;
table_header($th);
}
}
//end of while loop
if ($show_balances) {
start_row("class='inquirybg'");
label_cell("<b>" . _("Ending Balance") . " - " . $_POST['TransToDate'] . "</b>", "colspan={$colspan}");
display_debit_or_credit_cells($running_total, true);
label_cell("");
label_cell("");
end_row();
}
end_table(2);
if (db_num_rows($result) == 0) {
display_note(_("No general ledger transactions have been created for the specified criteria."), 0, 1);
}
}
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/manufacturing.inc";
include_once $path_to_root . "/includes/data_checks.inc";
include_once $path_to_root . "/manufacturing/includes/manufacturing_db.inc";
include_once $path_to_root . "/manufacturing/includes/manufacturing_ui.inc";
$js = "";
if ($use_popup_windows) {
$js .= get_js_open_window(800, 500);
}
page(_($help_context = "View Work Order"), true, false, "", $js);
//-------------------------------------------------------------------------------------------------
$woid = 0;
if ($_GET['trans_no'] != "") {
$woid = $_GET['trans_no'];
}
display_heading($systypes_array[ST_WORKORDER] . " # " . $woid);
br(1);
$myrow = get_work_order($woid);
if ($myrow["type"] == WO_ADVANCED) {
display_wo_details($woid, true);
} else {
display_wo_details_quick($woid, true);
}
echo "<center>";
// display the WO requirements
br(1);
if ($myrow["released"] == false) {
display_heading2(_("BOM for item:") . " " . $myrow["StockItemName"]);
display_bom($myrow["stock_id"]);
} else {
display_heading2(_("Work Order Requirements"));
<?php
$page_security = 10;
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
page(tr("View Dimension"), true);
include_once $path_to_root . "/includes/date_functions.inc";
include_once $path_to_root . "/includes/data_checks.inc";
include_once $path_to_root . "/dimensions/includes/dimensions_db.inc";
include_once $path_to_root . "/dimensions/includes/dimensions_ui.inc";
//-------------------------------------------------------------------------------------------------
if ($_GET['trans_no'] != "") {
$id = $_GET['trans_no'];
}
display_heading(systypes::name(systypes::dimension()) . " # " . $id);
$myrow = get_dimension($id);
if (strlen($myrow[0]) == 0) {
echo tr("The work order number sent is not valid.");
exit;
}
start_table($table_style);
$th = array(tr("#"), tr("Reference"), tr("Name"), tr("Type"), tr("Date"), tr("Due Date"));
table_header($th);
start_row();
label_cell($myrow["id"]);
label_cell($myrow["reference"]);
label_cell($myrow["name"]);
label_cell($myrow["type_"]);
label_cell(sql2date($myrow["date_"]));
label_cell(sql2date($myrow["due_date"]));
end_row();
$path_to_root = "..";
include_once $path_to_root . "/purchasing/includes/supp_trans_class.inc";
include_once $path_to_root . "/includes/session.inc";
include_once $path_to_root . "/purchasing/includes/purchasing_ui.inc";
include_once $path_to_root . "/purchasing/includes/purchasing_db.inc";
$js = "";
if ($use_date_picker) {
$js .= get_js_date_picker();
}
page(tr("Select Received Items to Add"), false, false, "", $js);
if (!isset($_SESSION['supp_trans'])) {
display_note("To enter supplier transactions the supplier must first be selected from the supplier selection screen, then the link to enter a supplier credit note must be clicked on.", 1, 0);
exit;
}
//-----------------------------------------------------------------------------------------
display_heading($_SESSION['supp_trans']->supplier_name);
echo "<br>";
//-----------------------------------------------------------------------------------------
function check_data()
{
global $check_price_charged_vs_order_price, $check_qty_charged_vs_del_qty;
if (!check_num('this_quantity_inv', 0) || input_num('this_quantity_inv') == 0) {
display_error(tr("The quantity to invoice must be numeric and greater than zero."));
set_focus('this_quantity_inv');
return false;
}
if (!check_num('ChgPrice')) {
display_error(tr("The price is not numeric."));
set_focus('ChgPrice');
return false;
}
exit;
}
if (isset($delete)) {
// deletes all records with id from table reports
$query = "DELETE FROM xx_reports WHERE id = '" . $id . "'";
db_query($query);
$url = REPGENDIR . "/repgen_select.php?id=" . $id;
$url = "http://{$HTTP_HOST}" . $url;
header("Location: " . $url);
// switches to repgen_select.php
exit;
}
page("Report Generator REPGEN");
### Output key administration forms, including all updated
### information, if we come here after a submission...
display_heading(DESCRIPT);
switch (substr($id, 0, 1)) {
case 'B':
$note = DEL_BLOCK;
break;
case 'F':
$note = DEL_FUNC;
break;
default:
$note = DEL_REPORT;
break;
}
$h = explode("|", $attr);
$note = sprintf($note, " " . $h[3] . " ");
/* longname of report*/
display_notification($note);
if (isset($_GET["trans_no"])) {
$trans_no = $_GET["trans_no"];
}
// get the pay-to bank payment info
$result = get_bank_trans(ST_BANKDEPOSIT, $trans_no);
if (db_num_rows($result) != 1) {
display_db_error("duplicate payment bank transaction found", "");
}
$to_trans = db_fetch($result);
$company_currency = get_company_currency();
$show_currencies = false;
if ($to_trans['bank_curr_code'] != $to_trans['settle_curr']) {
$show_currencies = true;
}
echo "<center>";
display_heading(_("GL Deposit") . " #{$trans_no}");
echo "<br>";
start_table(TABLESTYLE, "width=80%");
if ($show_currencies) {
$colspan1 = 1;
$colspan2 = 7;
} else {
$colspan1 = 3;
$colspan2 = 5;
}
start_row();
label_cells(_("To Bank Account"), $to_trans['bank_account_name'], "class='tableheader2'");
if ($show_currencies) {
label_cells(_("Currency"), $to_trans['bank_curr_code'], "class='tableheader2'");
}
label_cells(_("Amount"), number_format2($to_trans['amount'], user_price_dec()), "class='tableheader2'", "align=right");
of the License, or (at your option) any later version.
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 License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
$page_security = 'SA_WORKORDERCOST';
$path_to_root = "../..";
include_once $path_to_root . "/includes/session.inc";
page(_($help_context = "Costed Bill Of Material Inquiry"));
include_once $path_to_root . "/manufacturing/includes/manufacturing_ui.inc";
include_once $path_to_root . "/includes/manufacturing.inc";
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/includes/banking.inc";
include_once $path_to_root . "/includes/data_checks.inc";
check_db_has_bom_stock_items(_("There are no manufactured or kit items defined in the system."));
if (isset($_GET['stock_id'])) {
$_POST['stock_id'] = $_GET['stock_id'];
}
if (list_updated('stock_id')) {
$Ajax->activate('_page_body');
}
start_form(false, true);
start_table(TABLESTYLE_NOBORDER);
stock_manufactured_items_list_row(_("Select a manufacturable item:"), 'stock_id', null, false, true);
end_table();
br();
display_heading(_("All Costs Are In:") . " " . get_company_currency());
display_bom($_POST['stock_id']);
end_form();
end_page();
