function gl_view($row) { if (!isset($row['type'])) { $row['type'] = $_POST['filterType']; } return get_gl_view_str($row["type"], $row["trans_no"]); }
function render($id, $title) { global $path_to_root, $systypes_array; include_once $path_to_root . "/includes/ui.inc"; $start_date = add_days(Today(), -$this->days_past); $end_date = add_days(Today(), $this->days_future); $result = get_bank_trans_for_bank_account($this->bank_act, $start_date, $end_date); start_table(TABLESTYLE, 'width=98%'); $th = array(_("#"), _("Date"), _("Receipt"), _("Payment"), _("Balance"), _("Person/Item"), _("Memo"), ""); table_header($th); $bfw = get_balance_before_for_bank_account($this->bank_act, $start_date); $credit = $debit = 0; start_row("class='inquirybg' style='font-weight:bold'"); label_cell(_("Opening Balance") . " - " . $start_date, "colspan=4"); display_debit_or_credit_cells($bfw); label_cell(""); label_cell("", "colspan=2"); end_row(); $running_total = $bfw; if ($bfw > 0) { $debit += $bfw; } else { $credit += $bfw; } $j = 1; $k = 0; //row colour counter while ($myrow = db_fetch($result)) { alt_table_row_color($k); $running_total += $myrow["amount"]; label_cell(get_trans_view_str($myrow["type"], $myrow["trans_no"])); $trandate = sql2date($myrow["trans_date"]); label_cell($trandate); display_debit_or_credit_cells($myrow["amount"]); amount_cell($running_total); label_cell(payment_person_name($myrow["person_type_id"], $myrow["person_id"])); label_cell(get_comments_string($myrow["type"], $myrow["trans_no"])); label_cell(get_gl_view_str($myrow["type"], $myrow["trans_no"])); end_row(); if ($myrow["amount"] > 0) { $debit += $myrow["amount"]; } else { $credit += $myrow["amount"]; } if ($j == 12) { $j = 1; table_header($th); } $j++; } //end of while loop start_row("class='inquirybg' style='font-weight:bold'"); label_cell(_("Ending Balance") . " - " . $end_date, "colspan=4"); amount_cell($debit + $credit); label_cell(""); label_cell("", "colspan=2"); end_row(); end_table(2); }
} elseif (isset($_GET['ModifyCredit'])) { $_SESSION['page_title'] = sprintf(tr("Modifying Customer Credit Note #%d"), $_GET['ModifyCredit']); handle_new_credit($_GET['ModifyCredit']); $help_page_title = tr("Modifying Customer Credit Note"); } page($_SESSION['page_title'], false, false, "", $js); //----------------------------------------------------------------------------- check_db_has_stock_items(tr("There are no items defined in the system.")); check_db_has_customer_branches(tr("There are no customers, or there are no customers with branches. Please define customers and customer branches.")); //----------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $credit_no = $_GET['AddedID']; $trans_type = 11; display_notification_centered(sprintf(tr("Credit Note # %d has been processed"), $credit_no)); display_note(get_customer_trans_view_str($trans_type, $credit_no, tr("View this credit note")), 0, 1); display_note(get_gl_view_str($trans_type, $credit_no, tr("View the GL Journal Entries for this Credit Note"))); hyperlink_params($_SERVER['PHP_SELF'], tr("Enter Another Credit Note"), "NewCredit=yes"); display_footer_exit(); } //-------------------------------------------------------------------------------- function line_start_focus() { set_focus(get_company_pref('no_supplier_list') ? 'stock_id_edit' : 'StockID2'); } //----------------------------------------------------------------------------- function copy_to_cn() { $_SESSION['Items']->Comments = $_POST['CreditText']; $_SESSION['Items']->document_date = $_POST['OrderDate']; $_SESSION['Items']->freight_cost = input_num('ChargeFreightCost'); $_SESSION['Items']->Location = $_POST["Location"];
label_cell(get_trans_view_str(systypes::work_order(), $myrow["id"], $myrow["wo_ref"])); label_cell(wo_types::name($myrow["type"])); label_cell($myrow["location_name"]); view_stock_status_cell($myrow["stock_id"], $myrow["description"]); qty_cell($myrow["units_reqd"]); qty_cell($myrow["units_issued"]); label_cell(sql2date($myrow["date_"])); label_cell(sql2date($myrow["required_by"])); label_cell($myrow["closed"] ? tr("Yes") : tr("No")); if ($issue_link != "") { label_cell($issue_link); } if ($myrow["released"] == 0) { label_cell("<a href={$release_page}>" . tr("Release") . "</a>"); } if ($myrow["closed"] == 0) { label_cell("<a href={$modify_page}>" . tr("Edit") . "</a>"); } label_cell(get_gl_view_str(systypes::work_order(), $myrow["id"])); end_row(); $j++; if ($j == 12) { $j = 1; table_header($th); } //end of page full new headings if } //end of while loop end_table(1); //--------------------------------------------------------------------------------- end_page();
$js .= get_js_open_window(900, 500); } if ($use_date_picker) { $js .= get_js_date_picker(); } page(tr("Enter Supplier Invoice"), false, false, "", $js); //---------------------------------------------------------------------------------------- check_db_has_suppliers(tr("There are no suppliers defined in the system.")); //--------------------------------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $invoice_no = $_GET['AddedID']; $trans_type = 20; echo "<center>"; display_notification_centered(tr("Supplier invoice has been processed.")); display_note(get_trans_view_str($trans_type, $invoice_no, tr("View this Invoice"))); display_note(get_gl_view_str($trans_type, $invoice_no, tr("View the GL Journal Entries for this Invoice")), 1); hyperlink_params($_SERVER['PHP_SELF'], tr("Enter Another Invoice"), "New=1"); display_footer_exit(); } //-------------------------------------------------------------------------------------------------- if (isset($_GET['New'])) { if (isset($_SESSION['supp_trans'])) { unset($_SESSION['supp_trans']->grn_items); unset($_SESSION['supp_trans']->gl_codes); unset($_SESSION['supp_trans']); } //session_register("SuppInv"); session_register("supp_trans"); $_SESSION['supp_trans'] = new supp_trans(); $_SESSION['supp_trans']->is_invoice = true; }
$help_context = "Modifying Delivery Note"; processing_start(); } elseif (isset($_GET['OrderNumber'])) { $_SESSION['page_title'] = _($help_context = "Deliver Items for a Sales Order"); processing_start(); } page($_SESSION['page_title'], false, false, "", $js); if (isset($_GET['AddedID'])) { $dispatch_no = $_GET['AddedID']; display_notification_centered(sprintf(_("Delivery # %d has been entered."), $dispatch_no)); display_note(get_customer_trans_view_str(ST_CUSTDELIVERY, $dispatch_no, _("&View This Delivery")), 0, 1); display_note(print_document_link($dispatch_no, _("&Print Delivery Note"), true, ST_CUSTDELIVERY)); display_note(print_document_link($dispatch_no, _("&Email Delivery Note"), true, ST_CUSTDELIVERY, false, "printlink", "", 1), 1, 1); display_note(print_document_link($dispatch_no, _("P&rint as Packing Slip"), true, ST_CUSTDELIVERY, false, "printlink", "", 0, 1)); display_note(print_document_link($dispatch_no, _("E&mail as Packing Slip"), true, ST_CUSTDELIVERY, false, "printlink", "", 1, 1), 1); display_note(get_gl_view_str(13, $dispatch_no, _("View the GL Journal Entries for this Dispatch")), 1); hyperlink_params("{$path_to_root}/sales/customer_invoice.php", _("Invoice This Delivery"), "DeliveryNumber={$dispatch_no}"); hyperlink_params("{$path_to_root}/sales/inquiry/sales_orders_view.php", _("Select Another Order For Dispatch"), "OutstandingOnly=1"); display_footer_exit(); } elseif (isset($_GET['UpdatedID'])) { $delivery_no = $_GET['UpdatedID']; display_notification_centered(sprintf(_('Delivery Note # %d has been updated.'), $delivery_no)); display_note(get_trans_view_str(ST_CUSTDELIVERY, $delivery_no, _("View this delivery")), 0, 1); display_note(print_document_link($delivery_no, _("&Print Delivery Note"), true, ST_CUSTDELIVERY)); display_note(print_document_link($delivery_no, _("&Email Delivery Note"), true, ST_CUSTDELIVERY, false, "printlink", "", 1), 1, 1); display_note(print_document_link($delivery_no, _("P&rint as Packing Slip"), true, ST_CUSTDELIVERY, false, "printlink", "", 0, 1)); display_note(print_document_link($delivery_no, _("E&mail as Packing Slip"), true, ST_CUSTDELIVERY, false, "printlink", "", 1, 1), 1); hyperlink_params($path_to_root . "/sales/customer_invoice.php", _("Confirm Delivery and Invoice"), "DeliveryNumber={$delivery_no}"); hyperlink_params($path_to_root . "/sales/inquiry/sales_deliveries_view.php", _("Select A Different Delivery"), "OutstandingOnly=1"); display_footer_exit(); }
function view_gl_link($row) { //if ($row['closed'] == 0) // return ''; return get_gl_view_str(ST_WORKORDER, $row['id']); }
} display_footer_exit(); } elseif (isset($_GET['AddedDI'])) { $invoice = $_GET['AddedDI']; display_notification_centered(sprintf(_("Invoice # %d has been entered."), $invoice)); submenu_view(_("&View This Invoice"), ST_SALESINVOICE, $invoice); submenu_print(_("&Print Sales Invoice"), ST_SALESINVOICE, $invoice . "-" . ST_SALESINVOICE, 'prtopt'); submenu_print(_("&Email Sales Invoice"), ST_SALESINVOICE, $invoice . "-" . ST_SALESINVOICE, null, 1); set_focus('prtopt'); $sql = "SELECT trans_type_from, trans_no_from FROM " . TB_PREF . "cust_allocations\n\t\t\tWHERE trans_type_to=" . ST_SALESINVOICE . " AND trans_no_to=" . db_escape($invoice); $result = db_query($sql, "could not retrieve customer allocation"); $row = db_fetch($result); if ($row !== false) { submenu_print(_("Print &Receipt"), $row['trans_type_from'], $row['trans_no_from'] . "-" . $row['trans_type_from'], 'prtopt'); } display_note(get_gl_view_str(ST_SALESINVOICE, $invoice, _("View the GL &Journal Entries for this Invoice")), 0, 1); if (isset($_GET['Type']) && $_GET['Type'] == 1) { submenu_option(_("Enter a &New Template Invoice"), "/sales/inquiry/sales_orders_view.php?InvoiceTemplates=Yes"); } else { submenu_option(_("Enter a &New Direct Invoice"), "/sales/sales_order_entry.php?NewInvoice=0"); } if ($row === false) { submenu_option(_("Entry &customer payment for this invoice"), "/sales/customer_payments.php?SInvoice=" . $invoice); } submenu_option(_("Add an Attachment"), "/admin/attachments.php?filterType=" . ST_SALESINVOICE . "&trans_no={$invoice}"); display_footer_exit(); } else { check_edit_conflicts(); } //----------------------------------------------------------------------------- function copy_to_cart()
break; } } unset($inv); } else { display_error(_("Invalid purchase invoice number.")); } } } if (isset($_GET['AddedID'])) { $payment_id = $_GET['AddedID']; display_notification_centered(_("Payment has been sucessfully entered")); submenu_print(_("&Print This Remittance"), ST_SUPPAYMENT, $payment_id . "-" . ST_SUPPAYMENT, 'prtopt'); submenu_print(_("&Email This Remittance"), ST_SUPPAYMENT, $payment_id . "-" . ST_SUPPAYMENT, null, 1); submenu_view(_("View this Payment"), ST_SUPPAYMENT, $payment_id); display_note(get_gl_view_str(ST_SUPPAYMENT, $payment_id, _("View the GL &Journal Entries for this Payment")), 0, 1); submenu_option(_("Enter another supplier &payment"), "/purchasing/supplier_payment.php?supplier_id=" . $_POST['supplier_id']); submenu_option(_("Enter Other &Payment"), "/gl/gl_bank.php?NewPayment=Yes"); submenu_option(_("Enter &Customer Payment"), "/sales/customer_payments.php"); submenu_option(_("Enter Other &Deposit"), "/gl/gl_bank.php?NewDeposit=Yes"); submenu_option(_("Bank Account &Transfer"), "/gl/bank_transfer.php"); display_footer_exit(); } //---------------------------------------------------------------------------------------- function check_inputs() { global $Refs; if (!get_post('supplier_id')) { display_error(_("There is no supplier selected.")); set_focus('supplier_id'); return false;
function gl_link($row) { return get_gl_view_str($row["type"], $row["type_no"]); }
if ($use_date_picker) { $js .= get_js_date_picker(); } page(tr("Supplier Payment Entry"), false, false, "", $js); if (isset($_GET['supplier_id'])) { $_POST['supplier_id'] = $_GET['supplier_id']; } //---------------------------------------------------------------------------------------- check_db_has_suppliers(tr("There are no suppliers defined in the system.")); check_db_has_bank_accounts(tr("There are no bank accounts defined in the system.")); check_db_has_bank_trans_types(tr("There are no bank payment types defined in the system.")); //---------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $payment_id = $_GET['AddedID']; display_notification_centered(tr("Payment has been sucessfully entered")); display_note(get_gl_view_str(22, $payment_id, tr("View the GL Journal Entries for this Payment"))); hyperlink_params($path_to_root . "/purchasing/allocations/supplier_allocate.php", tr("Allocate this Payment"), "trans_no={$payment_id}&trans_type=22"); hyperlink_params($_SERVER['PHP_SELF'], tr("Enter another supplier payment"), "supplier_id=" . $_POST['supplier_id']); display_footer_exit(); } //---------------------------------------------------------------------------------------- function display_controls() { global $table_style2; start_form(false, true); if (!isset($_POST['supplier_id'])) { $_POST['supplier_id'] = get_global_supplier(false); } if (!isset($_POST['DatePaid'])) { $_POST['DatePaid'] = Today(); if (!is_date_in_fiscalyear($_POST['DatePaid'])) {
$j = 1; $k = 0; //row colour counter while ($myrow = db_fetch($result)) { alt_table_row_color($k); $running_total += $myrow["amount"]; $trandate = sql2date($myrow["trans_date"]); label_cell($systypes_array[$myrow["type"]]); label_cell(get_trans_view_str($myrow["type"], $myrow["trans_no"])); label_cell(get_trans_view_str($myrow["type"], $myrow["trans_no"], $myrow['ref'])); label_cell($trandate); display_debit_or_credit_cells($myrow["amount"]); amount_cell($running_total); label_cell(payment_person_name($myrow["person_type_id"], $myrow["person_id"])); label_cell(get_comments_string($myrow["type"], $myrow["trans_no"])); label_cell(get_gl_view_str($myrow["type"], $myrow["trans_no"])); end_row(); if ($myrow["amount"] > 0) { $debit += $myrow["amount"]; } else { $credit += $myrow["amount"]; } if ($j == 12) { $j = 1; table_header($th); } $j++; } //end of while loop start_row("class='inquirybg' style='font-weight:bold'"); label_cell(_("Ending Balance") . " - " . $_POST['TransToDate'], "colspan=4");
$old_cost = get_standard_cost($_POST['stock_id']); $new_cost = input_num('material_cost') + input_num('labour_cost') + input_num('overhead_cost'); $should_update = true; if (!check_num('material_cost') || !check_num('labour_cost') || !check_num('overhead_cost')) { display_error(_("The entered cost is not numeric.")); set_focus('material_cost'); $should_update = false; } elseif ($old_cost == $new_cost) { display_error(_("The new cost is the same as the old cost. Cost was not updated.")); $should_update = false; } if ($should_update) { $update_no = stock_cost_update($_POST['stock_id'], input_num('material_cost'), input_num('labour_cost'), input_num('overhead_cost'), $old_cost); display_notification(_("Cost has been updated.")); if ($update_no > 0) { display_notification(get_gl_view_str(ST_COSTUPDATE, $update_no, _("View the GL Journal Entries for this Cost Update"))); } } } if (list_updated('stock_id')) { $Ajax->activate('cost_table'); } //----------------------------------------------------------------------------------------- $action = $_SERVER['PHP_SELF']; if (@$_GET['popup']) { $action .= "?stock_id=" . get_post('stock_id'); } start_form(false, false, $action); if (!isset($_POST['stock_id'])) { $_POST['stock_id'] = get_global_stock_item(); }
$js .= get_js_open_window(800, 500); } if ($use_date_picker) { $js .= get_js_date_picker(); } set_focus('CodeID2'); page(tr("Bank Account Payment Entry"), false, false, '', $js); //----------------------------------------------------------------------------------------------- check_db_has_bank_accounts(tr("There are no bank accounts defined in the system.")); check_db_has_bank_trans_types(tr("There are no bank payment types defined in the system.")); //----------------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $trans_no = $_GET['AddedID']; $trans_type = systypes::bank_payment(); display_notification_centered(tr("Payment has been entered")); display_note(get_gl_view_str($trans_type, $trans_no, tr("View the GL Postings for this Payment"))); hyperlink_no_params($_SERVER['PHP_SELF'], tr("Enter Another Payment")); display_footer_exit(); } //-------------------------------------------------------------------------------------------------- function copy_to_py() { $_SESSION['pay_items']->from_loc = $_POST['bank_account']; $_SESSION['pay_items']->tran_date = $_POST['date_']; $_SESSION['pay_items']->transfer_type = $_POST['type']; $_SESSION['pay_items']->increase = $_POST['PayType']; if (!isset($_POST['person_id'])) { $_POST['person_id'] = ""; } $_SESSION['pay_items']->person_id = $_POST['person_id']; if (!isset($_POST['PersonDetailID'])) {
function handle_search() { global $table_style; if (check_valid_entries() == true) { $db_info = get_systype_db_info($_POST['filterType']); if ($db_info == null) { return; } $table_name = $db_info[0]; $type_name = $db_info[1]; $trans_no_name = $db_info[2]; $trans_ref = $db_info[3]; $sql = "SELECT DISTINCT {$trans_no_name} "; if ($trans_ref) { $sql .= " ,{$trans_ref} "; } $sql .= " FROM {$table_name}\n\t\t\tWHERE {$trans_no_name} >= " . $_POST['FromTransNo'] . "\n\t\t\tAND {$trans_no_name} <= " . $_POST['ToTransNo']; if ($type_name != null) { $sql .= " AND {$type_name} = " . $_POST['filterType']; } $sql .= " ORDER BY {$trans_no_name}"; $result = db_query($sql, "could not query transactions on {$table_name}"); if (db_num_rows($result) == 0) { echo tr("There are no transactions for the given parameters."); return; } $print_type = $_POST['filterType']; $print_out = $print_type == 10 || $print_type == 11 || $print_type == systypes::cust_dispatch() || $print_type == systypes::po() || $print_type == systypes::sales_order(); if ($print_out) { print_hidden_script($print_type); if ($trans_ref) { $th = array(tr("#"), tr("Reference"), tr("View"), tr("Print"), tr("GL")); } else { $th = array(tr("#"), tr("View"), tr("Print"), tr("GL")); } } else { if ($trans_ref) { $th = array(tr("#"), tr("Reference"), tr("View"), tr("GL")); } else { $th = array(tr("#"), tr("View"), tr("GL")); } } start_table($table_style); table_header($th); $k = 0; while ($line = db_fetch($result)) { alt_table_row_color($k); label_cell($line[$trans_no_name]); if ($trans_ref) { label_cell($line[$trans_ref]); } label_cell(get_trans_view_str($_POST['filterType'], $line[$trans_no_name], tr("View"))); if ($print_out) { label_cell(print_document_link($line[$trans_no_name], tr("Print"), true, $print_type)); } label_cell(get_gl_view_str($_POST['filterType'], $line[$trans_no_name], tr("View GL"))); end_row(); } end_table(); } }
$js .= get_js_open_window(800, 500); } if ($use_date_picker) { $js .= get_js_date_picker(); } page(_($help_context = "Item Adjustments Note"), false, false, "", $js); //----------------------------------------------------------------------------------------------- check_db_has_costable_items(_("There are no inventory items defined in the system which can be adjusted (Purchased or Manufactured).")); check_db_has_movement_types(_("There are no inventory movement types defined in the system. Please define at least one inventory adjustment type.")); //----------------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $trans_no = $_GET['AddedID']; $trans_type = ST_INVADJUST; display_notification_centered(_("Items adjustment has been processed")); display_note(get_trans_view_str($trans_type, $trans_no, _("&View this adjustment"))); display_note(get_gl_view_str($trans_type, $trans_no, _("View the GL &Postings for this Adjustment")), 1, 0); hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter &Another Adjustment")); hyperlink_params("{$path_to_root}/admin/attachments.php", _("Add an Attachment"), "filterType={$trans_type}&trans_no={$trans_no}"); display_footer_exit(); } //-------------------------------------------------------------------------------------------------- function line_start_focus() { global $Ajax; $Ajax->activate('items_table'); set_focus('_stock_id_edit'); } //----------------------------------------------------------------------------------------------- function handle_new_order() { if (isset($_SESSION['adj_items'])) {
} if ($use_date_picker) { $js .= get_js_date_picker(); } page(_($help_context = "Produce or Unassemble Finished Items From Work Order"), false, false, "", $js); if (isset($_GET['trans_no']) && $_GET['trans_no'] != "") { $_POST['selected_id'] = $_GET['trans_no']; } //-------------------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { include_once $path_to_root . "/reporting/includes/reporting.inc"; $id = $_GET['AddedID']; $stype = ST_WORKORDER; display_notification(_("The manufacturing process has been entered.")); display_note(get_trans_view_str($stype, $id, _("View this Work Order"))); display_note(get_gl_view_str($stype, $id, _("View the GL Journal Entries for this Work Order")), 1); $ar = array('PARAM_0' => $_GET['date'], 'PARAM_1' => $_GET['date'], 'PARAM_2' => $stype); display_note(print_link(_("Print the GL Journal Entries for this Work Order"), 702, $ar), 1); hyperlink_no_params("search_work_orders.php", _("Select another &Work Order to Process")); br(); end_page(); exit; } //-------------------------------------------------------------------------------------------------- $wo_details = get_work_order($_POST['selected_id']); if (strlen($wo_details[0]) == 0) { display_error(_("The order number sent is not valid.")); exit; } //-------------------------------------------------------------------------------------------------- function can_process()
function show_results() { global $path_to_root, $table_style; if (!isset($_POST["account"]) || $_POST["account"] == "") { return; } $act_name = 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']); $colspan = $dim == 2 ? "6" : ($dim == 1 ? "5" : "4"); //echo "\nDimension =". $_POST['Dimension']; display_heading($_POST["account"] . " " . $act_name); start_table($table_style); if ($dim == 2) { $th = array(tr("Type"), tr("#"), tr("Date"), tr("Dimension") . " 1", tr("Dimension") . " 2", tr("Person/Item"), tr("Debit"), tr("Credit"), tr("Balance"), tr("Memo")); } else { if ($dim == 1) { $th = array(tr("Type"), tr("#"), tr("Date"), tr("Dimension"), tr("Person/Item"), tr("Debit"), tr("Credit"), tr("Balance"), tr("Memo")); } else { $th = array(tr("Type"), tr("#"), tr("Date"), tr("Person/Item"), tr("Debit"), tr("Credit"), tr("Balance"), tr("Memo")); } } table_header($th); if (is_account_balancesheet($_POST["account"])) { $begin = ""; } else { $begin = begin_fiscalyear(); if ($_POST['TransFromDate'] < $begin) { $begin = $_POST['TransFromDate']; } $begin = add_days($begin, -1); } $bfw = get_gl_balance_from_to($begin, $_POST['TransFromDate'], $_POST["account"], $_POST['Dimension'], $_POST['Dimension2']); start_row("class='inquirybg'"); label_cell("<b>" . tr("Opening Balance") . " - " . $_POST['TransFromDate'] . "</b>", "colspan={$colspan}"); display_debit_or_credit_cells($bfw); label_cell(""); end_row(); //$running_total =0; $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::name($myrow["type"])); label_cell(get_gl_view_str($myrow["type"], $myrow["type_no"], $myrow["type_no"], true)); label_cell($trandate); 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_types::person_name($myrow["person_type_id"], $myrow["person_id"])); display_debit_or_credit_cells($myrow["amount"]); amount_cell($running_total); label_cell($myrow['memo_']); end_row(); $j++; if ($j == 12) { $j = 1; table_header($th); } } //end of while loop start_row("class='inquirybg'"); label_cell("<b>" . tr("Ending Balance") . " - " . $_POST['TransToDate'] . "</b>", "colspan={$colspan}"); display_debit_or_credit_cells($running_total); label_cell(""); end_row(); end_table(2); if (db_num_rows($result) == 0) { display_note(tr("No general ledger transactions have been created for this account on the selected dates."), 0, 1); } }
include_once $path_to_root . "/gl/includes/gl_ui.inc"; $js = ""; if ($use_popup_windows) { $js .= get_js_open_window(800, 500); } if ($use_date_picker) { $js .= get_js_date_picker(); } page(_($help_context = "Transfer between Bank Accounts"), false, false, "", $js); check_db_has_bank_accounts(_("There are no bank accounts defined in the system.")); //---------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $trans_no = $_GET['AddedID']; $trans_type = ST_BANKTRANSFER; display_notification_centered(_("Transfer has been entered")); display_note(get_gl_view_str($trans_type, $trans_no, _("&View the GL Journal Entries for this Transfer"))); hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter &Another Transfer")); display_footer_exit(); } if (isset($_POST['_DatePaid_changed'])) { $Ajax->activate('_ex_rate'); } //---------------------------------------------------------------------------------------- function gl_payment_controls() { global $Refs; $home_currency = get_company_currency(); start_form(); start_outer_table(TABLESTYLE2); table_section(1); bank_accounts_list_row(_("From Account:"), 'FromBankAccount', null, true);
if ($use_popup_windows) { $js .= get_js_open_window(900, 500); } if ($use_date_picker) { $js .= get_js_date_picker(); } page(_($help_context = "Receive Purchase Order Items"), false, false, "", $js); //--------------------------------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $grn = $_GET['AddedID']; $trans_type = ST_SUPPRECEIVE; display_notification_centered(_("Purchase Order Delivery has been processed")); display_note(get_trans_view_str($trans_type, $grn, _("&View this Delivery"))); $clearing_act = get_company_pref('grn_clearing_act'); if ($clearing_act) { display_note(get_gl_view_str($trans_type, $grn, _("View the GL Journal Entries for this Delivery")), 1); } hyperlink_params("{$path_to_root}/purchasing/supplier_invoice.php", _("Entry purchase &invoice for this receival"), "New=1"); hyperlink_no_params("{$path_to_root}/purchasing/inquiry/po_search.php", _("Select a different &purchase order for receiving items against")); display_footer_exit(); } //-------------------------------------------------------------------------------------------------- if ((!isset($_GET['PONumber']) || $_GET['PONumber'] == 0) && !isset($_SESSION['PO'])) { die(_("This page can only be opened if a purchase order has been selected. Please select a purchase order first.")); } //-------------------------------------------------------------------------------------------------- function display_po_receive_items() { div_start('grn_items'); start_table(TABLESTYLE, "colspan=7 width='90%'"); $th = array(_("Item Code"), _("Description"), _("Ordered"), _("Units"), _("Received"), _("Outstanding"), _("This Delivery"), _("Price"), _("Total"));
function gl_view($row) { return get_gl_view_str($row["type"], $row["trans_no"]); }
include_once $path_to_root . "/manufacturing/includes/manufacturing_ui.inc"; include_once $path_to_root . "/manufacturing/includes/work_order_issue_ui.inc"; $js = ""; if ($use_popup_windows) { $js .= get_js_open_window(800, 500); } if ($use_date_picker) { $js .= get_js_date_picker(); } page(_($help_context = "Issue Items to Work Order"), false, false, "", $js); //----------------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $id = $_GET['AddedID']; display_notification(_("The work order issue has been entered.")); display_note(get_trans_view_str(ST_WORKORDER, $id, _("View this Work Order"))); display_note(get_gl_view_str(ST_WORKORDER, $id, _("View the GL Journal Entries for this Work Order")), 1); hyperlink_no_params("search_work_orders.php", _("Select another &Work Order to Process")); display_footer_exit(); } //-------------------------------------------------------------------------------------------------- function line_start_focus() { global $Ajax; $Ajax->activate('items_table'); set_focus('_stock_id_edit'); } //-------------------------------------------------------------------------------------------------- function handle_new_order() { if (isset($_SESSION['issue_items'])) { $_SESSION['issue_items']->clear_items();
} } if (isset($_GET['AddedID'])) { $payment_no = $_GET['AddedID']; display_notification_centered(_("The customer payment has been successfully entered.")); submenu_print(_("&Print This Receipt"), ST_CUSTPAYMENT, $payment_no . "-" . ST_CUSTPAYMENT, 'prtopt'); display_note(get_gl_view_str(ST_CUSTPAYMENT, $payment_no, _("&View the GL Journal Entries for this Customer Payment"))); // hyperlink_params($path_to_root . "/sales/allocations/customer_allocate.php", _("&Allocate this Customer Payment"), "trans_no=$payment_no&trans_type=12"); hyperlink_no_params($path_to_root . "/sales/inquiry/customer_allocation_inquiry.php?customer_id=", _("Select Another &Customer Transaction for Payment")); hyperlink_no_params($path_to_root . "/sales/customer_payments.php", _("Enter Another &Customer Payment")); display_footer_exit(); } elseif (isset($_GET['UpdatedID'])) { $payment_no = $_GET['UpdatedID']; display_notification_centered(_("The customer payment has been successfully updated.")); submenu_print(_("&Print This Receipt"), ST_CUSTPAYMENT, $payment_no . "-" . ST_CUSTPAYMENT, 'prtopt'); display_note(get_gl_view_str(ST_CUSTPAYMENT, $payment_no, _("&View the GL Journal Entries for this Customer Payment"))); // hyperlink_params($path_to_root . "/sales/allocations/customer_allocate.php", _("&Allocate this Customer Payment"), "trans_no=$payment_no&trans_type=12"); hyperlink_no_params($path_to_root . "/sales/inquiry/customer_inquiry.php?", _("Select Another Customer Payment for &Edition")); hyperlink_no_params($path_to_root . "/sales/customer_payments.php", _("Enter Another &Customer Payment")); display_footer_exit(); } //---------------------------------------------------------------------------------------------- function can_process() { global $Refs; if (!get_post('customer_id')) { display_error(_("There is no customer selected.")); set_focus('customer_id'); return false; } if (!get_post('BranchID')) {
if ($use_popup_windows) { $js .= get_js_open_window(900, 500); } if ($use_date_picker) { $js .= get_js_date_picker(); } page(tr("Customer Payment Entry"), false, false, "", $js); //---------------------------------------------------------------------------------------------- check_db_has_customers(tr("There are no customers defined in the system.")); check_db_has_bank_accounts(tr("There are no bank accounts defined in the system.")); check_db_has_bank_trans_types(tr("There are no bank payment types defined in the system.")); //---------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $payment_no = $_GET['AddedID']; display_notification_centered(tr("The customer payment has been successfully entered.")); display_note(get_gl_view_str(12, $payment_no, tr("View the GL Journal Entries for this Customer Payment"))); hyperlink_params($path_to_root . "/sales/allocations/customer_allocate.php", tr("Allocate this Customer Payment"), "trans_no={$payment_no}&trans_type=12"); hyperlink_no_params($path_to_root . "/sales/customer_payments.php", tr("Enter Another Customer Payment")); br(1); end_page(); exit; } //---------------------------------------------------------------------------------------------- function can_process() { if (!isset($_POST['DateBanked']) || !is_date($_POST['DateBanked'])) { display_error(tr("The entered date is invalid. Please enter a valid date for the payment.")); set_focus('DateBanked'); return false; } elseif (!is_date_in_fiscalyear($_POST['DateBanked'])) { display_error(tr("The entered date is not in fiscal year."));
display_footer_exit(); } if (isset($_GET['AddedDep'])) { $trans_no = $_GET['AddedDep']; $trans_type = ST_BANKDEPOSIT; display_notification_centered(sprintf(_("Deposit %d has been entered"), $trans_no)); display_note(get_gl_view_str($trans_type, $trans_no, _("View the GL Postings for this Deposit"))); hyperlink_params($_SERVER['PHP_SELF'], _("Enter Another Deposit"), "NewDeposit=yes"); hyperlink_params($_SERVER['PHP_SELF'], _("Enter A Payment"), "NewPayment=yes"); display_footer_exit(); } if (isset($_GET['UpdatedDep'])) { $trans_no = $_GET['UpdatedDep']; $trans_type = ST_BANKDEPOSIT; display_notification_centered(sprintf(_("Deposit %d has been modified"), $trans_no)); display_note(get_gl_view_str($trans_type, $trans_no, _("&View the GL Postings for this Deposit"))); hyperlink_params($_SERVER['PHP_SELF'], _("Enter Another &Deposit"), "NewDeposit=yes"); hyperlink_params($_SERVER['PHP_SELF'], _("Enter A &Payment"), "NewPayment=yes"); display_footer_exit(); } //-------------------------------------------------------------------------------------------------- function create_cart($type, $trans_no) { global $Refs; if (isset($_SESSION['pay_items'])) { unset($_SESSION['pay_items']); } $cart = new items_cart($type); $cart->order_id = $trans_no; if ($trans_no) { $bank_trans = db_fetch(get_bank_trans($type, $trans_no));
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); } }
} //----------------------------------------------------------------------------------------------- if (isset($_GET['AddedID'])) { $trans_no = $_GET['AddedID']; $trans_type = ST_JOURNAL; display_notification_centered(_("Journal entry has been entered") . " #{$trans_no}"); display_note(get_gl_view_str($trans_type, $trans_no, _("&View this Journal Entry"))); reset_focus(); hyperlink_params($_SERVER['PHP_SELF'], _("Enter &New Journal Entry"), "NewJournal=Yes"); hyperlink_params("{$path_to_root}/admin/attachments.php", _("Add an Attachment"), "filterType={$trans_type}&trans_no={$trans_no}"); display_footer_exit(); } elseif (isset($_GET['UpdatedID'])) { $trans_no = $_GET['UpdatedID']; $trans_type = ST_JOURNAL; display_notification_centered(_("Journal entry has been updated") . " #{$trans_no}"); display_note(get_gl_view_str($trans_type, $trans_no, _("&View this Journal Entry"))); hyperlink_no_params($path_to_root . "/gl/inquiry/journal_inquiry.php", _("Return to Journal &Inquiry")); display_footer_exit(); } //-------------------------------------------------------------------------------------------------- if (isset($_GET['NewJournal'])) { create_cart(0, 0); } elseif (isset($_GET['ModifyGL'])) { if (!isset($_GET['trans_type']) || $_GET['trans_type'] != 0) { display_error(_("You can edit directly only journal entries created via Journal Entry page.")); hyperlink_params("{$path_to_root}/gl/gl_journal.php", _("Entry &New Journal Entry"), "NewJournal=Yes"); display_footer_exit(); } create_cart($_GET['trans_type'], $_GET['trans_no']); } function create_cart($type = 0, $trans_no = 0)
$old_cost = $_POST['OldMaterialCost'] + $_POST['OldLabourCost'] + $_POST['OldOverheadCost']; $new_cost = input_num('material_cost') + input_num('labour_cost') + input_num('overhead_cost'); $should_update = true; if (!check_num('material_cost') || !check_num('labour_cost') || !check_num('overhead_cost')) { display_error(tr("The entered cost is not numeric.")); set_focus('material_cost'); $should_update = false; } elseif ($old_cost == $new_cost) { display_error(tr("The new cost is the same as the old cost. Cost was not updated.")); $should_update = false; } if ($should_update) { $update_no = stock_cost_update($_POST['stock_id'], input_num('material_cost'), input_num('labour_cost'), input_num('overhead_cost'), $old_cost); display_note(tr("Cost has been updated.")); if ($update_no > 0) { display_note(get_gl_view_str(systypes::cost_update(), $update_no, tr("View the GL Journal Entries for this Cost Update")), 1, 0); } } } //----------------------------------------------------------------------------------------- start_form(false, true); if (!isset($_POST['stock_id'])) { $_POST['stock_id'] = get_global_stock_item(); } echo "<center>" . tr("Item:") . " "; stock_costable_items_list('stock_id', $_POST['stock_id'], false, true); echo "</center><hr>"; set_global_stock_item($_POST['stock_id']); $sql = "SELECT description, units, last_cost, actual_cost, material_cost, labour_cost,\n\toverhead_cost, mb_flag\n\tFROM stock_master\n\tWHERE stock_id='" . $_POST['stock_id'] . "'\n\tGROUP BY description, units, last_cost, actual_cost, material_cost, labour_cost, overhead_cost, mb_flag"; $result = db_query($sql); check_db_error("The cost details for the item could not be retrieved", $sql);