From f75695448532371e64f0d3033b88389a62d41da3 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Sat, 15 Oct 2011 12:04:41 +0200 Subject: [PATCH] Allowing edit of Customer Payments. (Chaitanya and Joe) --- sales/customer_payments.php | 125 ++++++- sales/includes/db/cust_trans_db.inc | 25 +- sales/includes/db/payment_db.inc | 15 +- sales/inquiry/customer_inquiry.php | 500 ++++++++++++++-------------- 4 files changed, 392 insertions(+), 273 deletions(-) diff --git a/sales/customer_payments.php b/sales/customer_payments.php index 2627cdd6..e73cccd1 100644 --- a/sales/customer_payments.php +++ b/sales/customer_payments.php @@ -95,6 +95,21 @@ if (isset($_GET['AddedID'])) { 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/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/customer_payments.php", _("Enter Another &Customer Payment")); @@ -108,7 +123,7 @@ function can_process() { global $Refs; - if (!get_post('customer_id')) + if (!get_post('customer_id')) { display_error(_("There is no customer selected.")); set_focus('customer_id'); @@ -138,11 +153,19 @@ function can_process() return false; } - if (!is_new_reference($_POST['ref'], ST_CUSTPAYMENT)) { + //Chaitanya : 13-OCT-2011 - To support Edit feature + if (isset($_POST['trans_no']) && $_POST['trans_no'] == 0 && (!is_new_reference($_POST['ref'], ST_CUSTPAYMENT))) { display_error(_("The entered reference is already in use.")); set_focus('ref'); return false; } + //Avoid duplicate reference while modifying + elseif ($_POST['ref'] != $_POST['old_ref'] && !is_new_reference($_POST['ref'], ST_CUSTPAYMENT)) + { + display_error( _("The entered reference is already in use.")); + set_focus('ref'); + return false; + } if (!check_num('amount', 0)) { display_error(_("The entered amount is invalid or negative and cannot be processed.")); @@ -213,9 +236,22 @@ if (isset($_POST['_customer_id_button'])) { if (isset($_POST['_DateBanked_changed'])) { $Ajax->activate('_ex_rate'); } -if (list_updated('customer_id') || list_updated('bank_account')) { + +//Chaitanya : 13-OCT-2011 - To support Edit feature +if (isset($_POST['ref']) && $_SESSION['alloc']->trans_no == 0) // added by Joe to fix the browser back button +{ + $tno = get_customer_trans_from_ref(ST_CUSTPAYMENT, $_POST['ref']); + if ($tno != false) + { + display_error( _("The entered reference is already in use.")); + display_footer_exit(); + } +} +$new = $_SESSION['alloc']->trans_no == 0; + +if (list_updated('customer_id') || ($new && list_updated('bank_account'))) { $_SESSION['alloc']->read(); - $_POST['memo_'] = $_POST['amount'] = ''; + $_POST['memo_'] = $_POST['amount'] = $_POST['discount'] = ''; $Ajax->activate('alloc_tbl'); } //---------------------------------------------------------------------------------------------- @@ -232,38 +268,94 @@ if (isset($_POST['AddPaymentItem'])) { new_doc_date($_POST['DateBanked']); - $payment_no = write_customer_payment(0, $_POST['customer_id'], $_POST['BranchID'], + //Chaitanya : 13-OCT-2011 - To support Edit feature + $payment_no = write_customer_payment($_SESSION['alloc']->trans_no, $_POST['customer_id'], $_POST['BranchID'], $_POST['bank_account'], $_POST['DateBanked'], $_POST['ref'], input_num('amount'), input_num('discount'), $_POST['memo_'], $rate, input_num('charge')); $_SESSION['alloc']->trans_no = $payment_no; $_SESSION['alloc']->write(); + + unset($_POST); + unset($_SESSION); - meta_forward($_SERVER['PHP_SELF'], "AddedID=$payment_no"); + //Chaitanya : 13-OCT-2011 - To support Edit feature + //meta_forward($_SERVER['PHP_SELF'], "AddedID=$payment_no"); + meta_forward($_SERVER['PHP_SELF'], $new ? "AddedID=$payment_no" : "UpdatedID=$payment_no"); } //---------------------------------------------------------------------------------------------- function read_customer_data() { - global $Refs; + global $Refs, $new; $myrow = get_customer_habit($_POST['customer_id']); $_POST['HoldAccount'] = $myrow["dissallow_invoices"]; $_POST['pymt_discount'] = $myrow["pymt_discount"]; - $_POST['ref'] = $Refs->get_next(ST_CUSTPAYMENT); + //Chaitanya : 13-OCT-2011 - To support Edit feature + //If page is called first time and New entry fetch the nex reference number + if ($new && !isset($_POST['charge'])) + $_POST['ref'] = $Refs->get_next(ST_CUSTPAYMENT); } +//---------------------------------------------------------------------------------------------- +$new = 1; +$old_ref = 0; + +//Chaitanya : 13-OCT-2011 - To support Edit feature +if (isset($_GET['trans_no']) && $_GET['trans_no'] > 0 ) + $_POST['trans_no'] = $_GET['trans_no']; +//Read data +if (isset($_POST['trans_no']) && $_POST['trans_no'] > 0 ) +{ + $new = 0; + $myrow = get_customer_trans($_POST['trans_no'], ST_CUSTPAYMENT); + $_POST['customer_id'] = $myrow["debtor_no"]; + $_POST['customer_name'] = $myrow["DebtorName"]; + $_POST['BranchID'] = $myrow["branch_code"]; + $_POST['bank_account'] = $myrow["bank_act"]; + $_POST['ref'] = $myrow["reference"]; + $old_ref = $myrow["reference"]; + //$_POST['charge'] = $myrow[""]; + $_POST['DateBanked'] = sql2date($myrow['tran_date']); + $_POST["amount"] = price_format($myrow['Total'] - $myrow['ov_discount']); + $_POST["discount"] = price_format($myrow['ov_discount']); + $_POST["memo_"] = get_comments_string(ST_CUSTPAYMENT,$_POST['trans_no']); +} +else + $_POST['trans_no'] = 0; + //---------------------------------------------------------------------------------------------- start_form(); + hidden('trans_no', $_POST['trans_no']); + hidden('old_ref', $old_ref); + start_outer_table(TABLESTYLE2, "width=60%", 5); table_section(1); - customer_list_row(_("From Customer:"), 'customer_id', null, false, true); + if ($new) + customer_list_row(_("From Customer:"), 'customer_id', null, false, true); + else { + label_cells(_("From Customer:"), $_POST['customer_name'], "class='label'"); + hidden('customer_id', $_POST['customer_id']); + } + if (!isset($_POST['charge'])) // first page call + { + //Prepare allocation cart + if (isset($_POST['trans_no']) && $_POST['trans_no'] > 0 ) + $_SESSION['alloc'] = new allocation(ST_CUSTPAYMENT,$_POST['trans_no']); + else + { + $_SESSION['alloc'] = new allocation(ST_CUSTPAYMENT,0); + $Ajax->activate('alloc_tbl'); + } + } + if (db_customer_has_branches($_POST['customer_id'])) { customer_branches_list_row(_("Branch:"), $_POST['customer_id'], 'BranchID', null, false, true, true); } else { @@ -281,9 +373,11 @@ start_form(); table_section(2); if (!list_updated('bank_account')) - $_POST['bank_account'] = get_default_customer_bank_account($_POST['customer_id']); - bank_accounts_list_row(_("Into Bank Account:"), 'bank_account', null, true); - + $_POST['bank_account'] = get_default_customer_bank_account($_POST['customer_id']); + + //Chaitanya : 13-OCT-2011 - Is AJAX call really needed ??? + //bank_accounts_list_row(_("Into Bank Account:"), 'bank_account', null, true); + bank_accounts_list_row(_("Into Bank Account:"), 'bank_account', null, false); text_row(_("Reference:"), 'ref', null, 20, 40); @@ -291,8 +385,6 @@ start_form(); date_row(_("Date of Deposit:"), 'DateBanked', '', true, 0, 0, 0, null, true); - - $comp_currency = get_company_currency(); $cust_currency = get_customer_currency($_POST['customer_id']); $bank_currency = get_bank_account_currency($_POST['bank_account']); @@ -326,7 +418,10 @@ start_form(); br(); - submit_center('AddPaymentItem', _("Add Payment"), true, '', 'default'); + if (isset($_POST['trans_no']) && $_POST['trans_no'] > 0 ) + submit_center('AddPaymentItem', _("Update Payment"), true, '', 'default'); + else + submit_center('AddPaymentItem', _("Add Payment"), true, '', 'default'); } br(); diff --git a/sales/includes/db/cust_trans_db.inc b/sales/includes/db/cust_trans_db.inc index 29e611e1..bf28fe60 100644 --- a/sales/includes/db/cust_trans_db.inc +++ b/sales/includes/db/cust_trans_db.inc @@ -43,7 +43,7 @@ function get_customer_trans_version($type, $trans_no) { $sql .= implode(' OR ', $trans_no) . ')'; $res = db_query($sql, 'document version retreival'); - + $vers = array(); while($mysql=db_fetch($res)) { $vers[$mysql['trans_no']] = $mysql['version']; @@ -72,8 +72,10 @@ function write_customer_trans($trans_type, $trans_no, $debtor_no, $BranchNo, if ($trans_type == ST_BANKPAYMENT) $Total = -$Total; - if ($new) { - $trans_no = get_next_trans_no($trans_type); + if ($new || !exists_customer_trans($trans_type, $trans_no)) + { + if ($new) + $trans_no = get_next_trans_no($trans_type); $sql = "INSERT INTO ".TB_PREF."debtor_trans ( trans_no, type, @@ -122,7 +124,8 @@ function get_customer_trans($trans_id, $trans_type) if ($trans_type == ST_CUSTPAYMENT) { // it's a payment so also get the bank account - $sql .= ", ".TB_PREF."bank_accounts.bank_name, ".TB_PREF."bank_accounts.bank_account_name, + // Chaitanya : Added bank_act to support Customer Payment Edit + $sql .= ",bank_act,".TB_PREF."bank_accounts.bank_name, ".TB_PREF."bank_accounts.bank_account_name, ".TB_PREF."bank_accounts.account_type AS BankTransType "; } @@ -160,6 +163,7 @@ function get_customer_trans($trans_id, $trans_type) // it's a payment so also get the bank account $sql .= " AND ".TB_PREF."bank_trans.trans_no =".db_escape($trans_id)." AND ".TB_PREF."bank_trans.type=$trans_type + AND ".TB_PREF."bank_trans.amount != 0 AND ".TB_PREF."bank_accounts.id=".TB_PREF."bank_trans.bank_act "; } if ($trans_type == ST_SALESINVOICE || $trans_type == ST_CUSTCREDIT || $trans_type == ST_CUSTDELIVERY) { @@ -202,6 +206,19 @@ function exists_customer_trans($type, $type_no) //---------------------------------------------------------------------------------------- +function get_customer_trans_from_ref($type, $ref) +{ + $sql = "SELECT trans_no FROM ".TB_PREF."debtor_trans WHERE type=".db_escape($type)." + AND reference=".db_escape($ref); + + $result = db_query($sql, "Cannot retreive a debtor transaction"); + + $row = db_fetch_row($result); + return $row[0]; +} + +//---------------------------------------------------------------------------------------- + // retreives the related sales order for a given trans function get_customer_trans_order($type, $type_no) diff --git a/sales/includes/db/payment_db.inc b/sales/includes/db/payment_db.inc index 8b92dd1c..abee06b6 100644 --- a/sales/includes/db/payment_db.inc +++ b/sales/includes/db/payment_db.inc @@ -24,18 +24,21 @@ function write_customer_payment($trans_no, $customer_id, $branch_id, $bank_accou hook_db_prewrite($args, ST_CUSTPAYMENT); $company_record = get_company_prefs(); - - $payment_no = write_customer_trans(ST_CUSTPAYMENT, $trans_no, $customer_id, $branch_id, - $date_, $ref, $amount, $discount, 0, 0, 0, 0, 0, 0, "", 0, $rate); - - $bank_gl_account = get_bank_gl_account($bank_account); - + + //Chaitanya : 13_OCT_2011 : Voiding Tasks first + //Reason : After modifying the customer trans, it was getting voided later if ($trans_no != 0) { delete_comments(ST_CUSTPAYMENT, $trans_no); void_bank_trans(ST_CUSTPAYMENT, $trans_no, true); void_gl_trans(ST_CUSTPAYMENT, $trans_no, true); void_cust_allocations(ST_CUSTPAYMENT, $trans_no, $date_); } + + $payment_no = write_customer_trans(ST_CUSTPAYMENT, $trans_no, $customer_id, $branch_id, + $date_, $ref, $amount, $discount, 0, 0, 0, 0, 0, 0, "", 0, $rate); + + $bank_gl_account = get_bank_gl_account($bank_account); + $total = 0; /* Bank account entry first */ $total += add_gl_trans_customer(ST_CUSTPAYMENT, $payment_no, $date_, diff --git a/sales/inquiry/customer_inquiry.php b/sales/inquiry/customer_inquiry.php index 92c640d4..1e81a243 100644 --- a/sales/inquiry/customer_inquiry.php +++ b/sales/inquiry/customer_inquiry.php @@ -1,248 +1,252 @@ -. -***********************************************************************/ -$page_security = 'SA_SALESTRANSVIEW'; -$path_to_root = "../.."; -include($path_to_root . "/includes/db_pager.inc"); -include_once($path_to_root . "/includes/session.inc"); - -include_once($path_to_root . "/sales/includes/sales_ui.inc"); -include_once($path_to_root . "/sales/includes/sales_db.inc"); -include_once($path_to_root . "/reporting/includes/reporting.inc"); - -$js = ""; -if ($use_popup_windows) - $js .= get_js_open_window(900, 500); -if ($use_date_picker) - $js .= get_js_date_picker(); -page(_($help_context = "Customer Transactions"), isset($_GET['customer_id']), false, "", $js); - - -if (isset($_GET['customer_id'])) -{ - $_POST['customer_id'] = $_GET['customer_id']; -} - -//------------------------------------------------------------------------------------------------ - -start_form(); - -if (!isset($_POST['customer_id'])) - $_POST['customer_id'] = get_global_customer(); - -start_table(TABLESTYLE_NOBORDER); -start_row(); - -customer_list_cells(_("Select a customer: "), 'customer_id', null, true); - -date_cells(_("From:"), 'TransAfterDate', '', null, -30); -date_cells(_("To:"), 'TransToDate', '', null, 1); - -if (!isset($_POST['filterType'])) - $_POST['filterType'] = 0; - -cust_allocations_list_cells(null, 'filterType', $_POST['filterType'], true); - -submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), 'default'); -end_row(); -end_table(); - -set_global_customer($_POST['customer_id']); - -//------------------------------------------------------------------------------------------------ - -function display_customer_summary($customer_record) -{ - $past1 = get_company_pref('past_due_days'); - $past2 = 2 * $past1; - if ($customer_record["dissallow_invoices"] != 0) - { - echo "
" . _("CUSTOMER ACCOUNT IS ON HOLD") . "
"; - } - - $nowdue = "1-" . $past1 . " " . _('Days'); - $pastdue1 = $past1 + 1 . "-" . $past2 . " " . _('Days'); - $pastdue2 = _('Over') . " " . $past2 . " " . _('Days'); - - start_table(TABLESTYLE, "width=80%"); - $th = array(_("Currency"), _("Terms"), _("Current"), $nowdue, - $pastdue1, $pastdue2, _("Total Balance")); - table_header($th); - - start_row(); - label_cell($customer_record["curr_code"]); - label_cell($customer_record["terms"]); - amount_cell($customer_record["Balance"] - $customer_record["Due"]); - amount_cell($customer_record["Due"] - $customer_record["Overdue1"]); - amount_cell($customer_record["Overdue1"] - $customer_record["Overdue2"]); - amount_cell($customer_record["Overdue2"]); - amount_cell($customer_record["Balance"]); - end_row(); - - end_table(); -} -//------------------------------------------------------------------------------------------------ - -div_start('totals_tbl'); -if ($_POST['customer_id'] != "" && $_POST['customer_id'] != ALL_TEXT) -{ - $customer_record = get_customer_details($_POST['customer_id'], $_POST['TransToDate']); - display_customer_summary($customer_record); - echo "
"; -} -div_end(); - -if(get_post('RefreshInquiry')) -{ - $Ajax->activate('totals_tbl'); -} -//------------------------------------------------------------------------------------------------ - -function systype_name($dummy, $type) -{ - global $systypes_array; - - return $systypes_array[$type]; -} - -function order_view($row) -{ - return $row['order_']>0 ? - get_customer_trans_view_str(ST_SALESORDER, $row['order_']) - : ""; -} - -function trans_view($trans) -{ - return get_trans_view_str($trans["type"], $trans["trans_no"]); -} - -function due_date($row) -{ - return $row["type"] == ST_SALESINVOICE ? $row["due_date"] : ''; -} - -function gl_view($row) -{ - return get_gl_view_str($row["type"], $row["trans_no"]); -} - -function fmt_debit($row) -{ - $value = - $row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT ? - -$row["TotalAmount"] : $row["TotalAmount"]; - return $value>=0 ? price_format($value) : ''; - -} - -function fmt_credit($row) -{ - $value = - !($row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT) ? - -$row["TotalAmount"] : $row["TotalAmount"]; - return $value>0 ? price_format($value) : ''; -} - -function credit_link($row) -{ - return $row['type'] == ST_SALESINVOICE && $row["Outstanding"] > 0 ? - pager_link(_("Credit This") , - "/sales/customer_credit_invoice.php?InvoiceNumber=". $row['trans_no'], ICON_CREDIT):''; -} - -function edit_link($row) -{ - $str = ''; - - switch($row['type']) { - case ST_SALESINVOICE: - if (get_voided_entry(ST_SALESINVOICE, $row["trans_no"]) === false && $row['Allocated'] == 0) - $str = "/sales/customer_invoice.php?ModifyInvoice=".$row['trans_no']; - break; - case ST_CUSTCREDIT: - if (get_voided_entry(ST_CUSTCREDIT, $row["trans_no"]) === false && $row['Allocated'] == 0) // 2008-11-19 Joe Hunt - { - if ($row['order_']==0) // free-hand credit note - $str = "/sales/credit_note_entry.php?ModifyCredit=".$row['trans_no']; - else // credit invoice - $str = "/sales/customer_credit_invoice.php?ModifyCredit=".$row['trans_no']; - } - break; - case ST_CUSTDELIVERY: - if (get_voided_entry(ST_CUSTDELIVERY, $row["trans_no"]) === false) - $str = "/sales/customer_delivery.php?ModifyDelivery=".$row['trans_no']; - break; - } - if ($str != "" && !is_closed_trans($row['type'], $row["trans_no"])) - return pager_link(_('Edit'), $str, ICON_EDIT); - return ''; -} - -function prt_link($row) -{ - if ($row['type'] == ST_CUSTPAYMENT || $row['type'] == ST_BANKDEPOSIT) - return print_document_link($row['trans_no']."-".$row['type'], _("Print Receipt"), true, ST_CUSTPAYMENT, ICON_PRINT); - elseif ($row['type'] == ST_BANKPAYMENT) // bank payment printout not defined yet. - return ''; - else - return print_document_link($row['trans_no']."-".$row['type'], _("Print"), true, $row['type'], ICON_PRINT); -} - -function check_overdue($row) -{ - return $row['OverDue'] == 1 - && (abs($row["TotalAmount"]) - $row["Allocated"] != 0); -} -//------------------------------------------------------------------------------------------------ -$sql = get_sql_for_customer_inquiry(); - -//------------------------------------------------------------------------------------------------ -db_query("set @bal:=0"); - -$cols = array( - _("Type") => array('fun'=>'systype_name', 'ord'=>''), - _("#") => array('fun'=>'trans_view', 'ord'=>''), - _("Order") => array('fun'=>'order_view'), - _("Reference"), - _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'desc'), - _("Due Date") => array('type'=>'date', 'fun'=>'due_date'), - _("Customer") => array('ord'=>''), - _("Branch") => array('ord'=>''), - _("Currency") => array('align'=>'center'), - _("Debit") => array('align'=>'right', 'fun'=>'fmt_debit'), - _("Credit") => array('align'=>'right','insert'=>true, 'fun'=>'fmt_credit'), - _("RB") => array('align'=>'right', 'type'=>'amount'), - array('insert'=>true, 'fun'=>'gl_view'), - array('insert'=>true, 'fun'=>'credit_link'), - array('insert'=>true, 'fun'=>'edit_link'), - array('insert'=>true, 'fun'=>'prt_link') - ); - - -if ($_POST['customer_id'] != ALL_TEXT) { - $cols[_("Customer")] = 'skip'; - $cols[_("Currency")] = 'skip'; -} -if ($_POST['filterType'] == ALL_TEXT) - $cols[_("RB")] = 'skip'; - -$table =& new_db_pager('trans_tbl', $sql, $cols); -$table->set_marker('check_overdue', _("Marked items are overdue.")); - -$table->width = "85%"; - -display_db_pager($table); - -end_form(); -end_page(); - -?> +. +***********************************************************************/ +$page_security = 'SA_SALESTRANSVIEW'; +$path_to_root = "../.."; +include($path_to_root . "/includes/db_pager.inc"); +include_once($path_to_root . "/includes/session.inc"); + +include_once($path_to_root . "/sales/includes/sales_ui.inc"); +include_once($path_to_root . "/sales/includes/sales_db.inc"); +include_once($path_to_root . "/reporting/includes/reporting.inc"); + +$js = ""; +if ($use_popup_windows) + $js .= get_js_open_window(900, 500); +if ($use_date_picker) + $js .= get_js_date_picker(); +page(_($help_context = "Customer Transactions"), isset($_GET['customer_id']), false, "", $js); + + +if (isset($_GET['customer_id'])) +{ + $_POST['customer_id'] = $_GET['customer_id']; +} + +//------------------------------------------------------------------------------------------------ + +start_form(); + +if (!isset($_POST['customer_id'])) + $_POST['customer_id'] = get_global_customer(); + +start_table(TABLESTYLE_NOBORDER); +start_row(); + +customer_list_cells(_("Select a customer: "), 'customer_id', null, true); + +date_cells(_("From:"), 'TransAfterDate', '', null, -30); +date_cells(_("To:"), 'TransToDate', '', null, 1); + +if (!isset($_POST['filterType'])) + $_POST['filterType'] = 0; + +cust_allocations_list_cells(null, 'filterType', $_POST['filterType'], true); + +submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), 'default'); +end_row(); +end_table(); + +set_global_customer($_POST['customer_id']); + +//------------------------------------------------------------------------------------------------ + +function display_customer_summary($customer_record) +{ + $past1 = get_company_pref('past_due_days'); + $past2 = 2 * $past1; + if ($customer_record["dissallow_invoices"] != 0) + { + echo "
" . _("CUSTOMER ACCOUNT IS ON HOLD") . "
"; + } + + $nowdue = "1-" . $past1 . " " . _('Days'); + $pastdue1 = $past1 + 1 . "-" . $past2 . " " . _('Days'); + $pastdue2 = _('Over') . " " . $past2 . " " . _('Days'); + + start_table(TABLESTYLE, "width=80%"); + $th = array(_("Currency"), _("Terms"), _("Current"), $nowdue, + $pastdue1, $pastdue2, _("Total Balance")); + table_header($th); + + start_row(); + label_cell($customer_record["curr_code"]); + label_cell($customer_record["terms"]); + amount_cell($customer_record["Balance"] - $customer_record["Due"]); + amount_cell($customer_record["Due"] - $customer_record["Overdue1"]); + amount_cell($customer_record["Overdue1"] - $customer_record["Overdue2"]); + amount_cell($customer_record["Overdue2"]); + amount_cell($customer_record["Balance"]); + end_row(); + + end_table(); +} +//------------------------------------------------------------------------------------------------ + +div_start('totals_tbl'); +if ($_POST['customer_id'] != "" && $_POST['customer_id'] != ALL_TEXT) +{ + $customer_record = get_customer_details($_POST['customer_id'], $_POST['TransToDate']); + display_customer_summary($customer_record); + echo "
"; +} +div_end(); + +if(get_post('RefreshInquiry')) +{ + $Ajax->activate('totals_tbl'); +} +//------------------------------------------------------------------------------------------------ + +function systype_name($dummy, $type) +{ + global $systypes_array; + + return $systypes_array[$type]; +} + +function order_view($row) +{ + return $row['order_']>0 ? + get_customer_trans_view_str(ST_SALESORDER, $row['order_']) + : ""; +} + +function trans_view($trans) +{ + return get_trans_view_str($trans["type"], $trans["trans_no"]); +} + +function due_date($row) +{ + return $row["type"] == ST_SALESINVOICE ? $row["due_date"] : ''; +} + +function gl_view($row) +{ + return get_gl_view_str($row["type"], $row["trans_no"]); +} + +function fmt_debit($row) +{ + $value = + $row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT ? + -$row["TotalAmount"] : $row["TotalAmount"]; + return $value>=0 ? price_format($value) : ''; + +} + +function fmt_credit($row) +{ + $value = + !($row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT) ? + -$row["TotalAmount"] : $row["TotalAmount"]; + return $value>0 ? price_format($value) : ''; +} + +function credit_link($row) +{ + return $row['type'] == ST_SALESINVOICE && $row["Outstanding"] > 0 ? + pager_link(_("Credit This") , + "/sales/customer_credit_invoice.php?InvoiceNumber=". $row['trans_no'], ICON_CREDIT):''; +} + +function edit_link($row) +{ + $str = ''; + + switch($row['type']) { + case ST_SALESINVOICE: + if (get_voided_entry(ST_SALESINVOICE, $row["trans_no"]) === false && $row['Allocated'] == 0) + $str = "/sales/customer_invoice.php?ModifyInvoice=".$row['trans_no']; + break; + case ST_CUSTCREDIT: + if (get_voided_entry(ST_CUSTCREDIT, $row["trans_no"]) === false && $row['Allocated'] == 0) // 2008-11-19 Joe Hunt + { + if ($row['order_']==0) // free-hand credit note + $str = "/sales/credit_note_entry.php?ModifyCredit=".$row['trans_no']; + else // credit invoice + $str = "/sales/customer_credit_invoice.php?ModifyCredit=".$row['trans_no']; + } + break; + case ST_CUSTDELIVERY: + if (get_voided_entry(ST_CUSTDELIVERY, $row["trans_no"]) === false) + $str = "/sales/customer_delivery.php?ModifyDelivery=".$row['trans_no']; + break; + case ST_CUSTPAYMENT: + if (get_voided_entry(ST_CUSTPAYMENT, $row["trans_no"]) === false) + $str = "/sales/customer_payments.php?trans_no=".$row['trans_no']; + break; + } + if ($str != "" && !is_closed_trans($row['type'], $row["trans_no"])) + return pager_link(_('Edit'), $str, ICON_EDIT); + return ''; +} + +function prt_link($row) +{ + if ($row['type'] == ST_CUSTPAYMENT || $row['type'] == ST_BANKDEPOSIT) + return print_document_link($row['trans_no']."-".$row['type'], _("Print Receipt"), true, ST_CUSTPAYMENT, ICON_PRINT); + elseif ($row['type'] == ST_BANKPAYMENT) // bank payment printout not defined yet. + return ''; + else + return print_document_link($row['trans_no']."-".$row['type'], _("Print"), true, $row['type'], ICON_PRINT); +} + +function check_overdue($row) +{ + return $row['OverDue'] == 1 + && (abs($row["TotalAmount"]) - $row["Allocated"] != 0); +} +//------------------------------------------------------------------------------------------------ +$sql = get_sql_for_customer_inquiry(); + +//------------------------------------------------------------------------------------------------ +db_query("set @bal:=0"); + +$cols = array( + _("Type") => array('fun'=>'systype_name', 'ord'=>''), + _("#") => array('fun'=>'trans_view', 'ord'=>''), + _("Order") => array('fun'=>'order_view'), + _("Reference"), + _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'desc'), + _("Due Date") => array('type'=>'date', 'fun'=>'due_date'), + _("Customer") => array('ord'=>''), + _("Branch") => array('ord'=>''), + _("Currency") => array('align'=>'center'), + _("Debit") => array('align'=>'right', 'fun'=>'fmt_debit'), + _("Credit") => array('align'=>'right','insert'=>true, 'fun'=>'fmt_credit'), + _("RB") => array('align'=>'right', 'type'=>'amount'), + array('insert'=>true, 'fun'=>'gl_view'), + array('insert'=>true, 'fun'=>'credit_link'), + array('insert'=>true, 'fun'=>'edit_link'), + array('insert'=>true, 'fun'=>'prt_link') + ); + + +if ($_POST['customer_id'] != ALL_TEXT) { + $cols[_("Customer")] = 'skip'; + $cols[_("Currency")] = 'skip'; +} +if ($_POST['filterType'] == ALL_TEXT) + $cols[_("RB")] = 'skip'; + +$table =& new_db_pager('trans_tbl', $sql, $cols); +$table->set_marker('check_overdue', _("Marked items are overdue.")); + +$table->width = "85%"; + +display_db_pager($table); + +end_form(); +end_page(); + +?> -- 2.30.2