-<?php\r
-/**********************************************************************\r
- Copyright (C) FrontAccounting, LLC.\r
- Released under the terms of the GNU General Public License, GPL, \r
- as published by the Free Software Foundation, either version 3 \r
- of the License, or (at your option) any later version.\r
- This program is distributed in the hope that it will be useful,\r
- but WITHOUT ANY WARRANTY; without even the implied warranty of\r
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. \r
- See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.\r
-***********************************************************************/\r
-$page_security = 'SA_SALESTRANSVIEW';\r
-$path_to_root = "../..";\r
-include($path_to_root . "/includes/db_pager.inc");\r
-include_once($path_to_root . "/includes/session.inc");\r
-\r
-include_once($path_to_root . "/sales/includes/sales_ui.inc");\r
-include_once($path_to_root . "/sales/includes/sales_db.inc");\r
-include_once($path_to_root . "/reporting/includes/reporting.inc");\r
-\r
-$js = "";\r
-if ($use_popup_windows)\r
- $js .= get_js_open_window(900, 500);\r
-if ($use_date_picker)\r
- $js .= get_js_date_picker();\r
-page(_($help_context = "Customer Transactions"), isset($_GET['customer_id']), false, "", $js);\r
-\r
-\r
-if (isset($_GET['customer_id']))\r
-{\r
- $_POST['customer_id'] = $_GET['customer_id'];\r
-}\r
-\r
-//------------------------------------------------------------------------------------------------\r
-\r
-start_form();\r
-\r
-if (!isset($_POST['customer_id']))\r
- $_POST['customer_id'] = get_global_customer();\r
-\r
-start_table(TABLESTYLE_NOBORDER);\r
-start_row();\r
-\r
-customer_list_cells(_("Select a customer: "), 'customer_id', null, true, false, false, !@$_REQUEST['popup']);\r
-\r
-date_cells(_("From:"), 'TransAfterDate', '', null, -30);\r
-date_cells(_("To:"), 'TransToDate', '', null, 1);\r
-\r
-if (!isset($_POST['filterType']))\r
- $_POST['filterType'] = 0;\r
-\r
-cust_allocations_list_cells(null, 'filterType', $_POST['filterType'], true);\r
-\r
-submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), 'default');\r
-end_row();\r
-end_table();\r
-\r
-set_global_customer($_POST['customer_id']);\r
-\r
-//------------------------------------------------------------------------------------------------\r
-\r
-function display_customer_summary($customer_record)\r
-{\r
- $past1 = get_company_pref('past_due_days');\r
- $past2 = 2 * $past1;\r
- if ($customer_record["dissallow_invoices"] != 0)\r
- {\r
- echo "<center><font color=red size=4><b>" . _("CUSTOMER ACCOUNT IS ON HOLD") . "</font></b></center>";\r
- }\r
-\r
- $nowdue = "1-" . $past1 . " " . _('Days');\r
- $pastdue1 = $past1 + 1 . "-" . $past2 . " " . _('Days');\r
- $pastdue2 = _('Over') . " " . $past2 . " " . _('Days');\r
-\r
- start_table(TABLESTYLE, "width=80%");\r
- $th = array(_("Currency"), _("Terms"), _("Current"), $nowdue,\r
- $pastdue1, $pastdue2, _("Total Balance"));\r
- table_header($th);\r
-\r
- start_row();\r
- label_cell($customer_record["curr_code"]);\r
- label_cell($customer_record["terms"]);\r
- amount_cell($customer_record["Balance"] - $customer_record["Due"]);\r
- amount_cell($customer_record["Due"] - $customer_record["Overdue1"]);\r
- amount_cell($customer_record["Overdue1"] - $customer_record["Overdue2"]);\r
- amount_cell($customer_record["Overdue2"]);\r
- amount_cell($customer_record["Balance"]);\r
- end_row();\r
-\r
- end_table();\r
-}\r
-//------------------------------------------------------------------------------------------------\r
-\r
-div_start('totals_tbl');\r
-if ($_POST['customer_id'] != "" && $_POST['customer_id'] != ALL_TEXT)\r
-{\r
- $customer_record = get_customer_details($_POST['customer_id'], $_POST['TransToDate']);\r
- display_customer_summary($customer_record);\r
- echo "<br>";\r
-}\r
-div_end();\r
-\r
-if(get_post('RefreshInquiry'))\r
-{\r
- $Ajax->activate('totals_tbl');\r
-}\r
-//------------------------------------------------------------------------------------------------\r
-\r
-function systype_name($dummy, $type)\r
-{\r
- global $systypes_array;\r
-\r
- return $systypes_array[$type];\r
-}\r
-\r
-function order_view($row)\r
-{\r
- return $row['order_']>0 ?\r
- get_customer_trans_view_str(ST_SALESORDER, $row['order_'])\r
- : "";\r
-}\r
-\r
-function trans_view($trans)\r
-{\r
- return get_trans_view_str($trans["type"], $trans["trans_no"]);\r
-}\r
-\r
-function due_date($row)\r
-{\r
- return $row["type"] == ST_SALESINVOICE ? $row["due_date"] : '';\r
-}\r
-\r
-function gl_view($row)\r
-{\r
- return get_gl_view_str($row["type"], $row["trans_no"]);\r
-}\r
-\r
-function fmt_debit($row)\r
-{\r
- $value =\r
- $row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT ?\r
- -$row["TotalAmount"] : $row["TotalAmount"];\r
- return $value>=0 ? price_format($value) : '';\r
-\r
-}\r
-\r
-function fmt_credit($row)\r
-{\r
- $value =\r
- !($row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT) ?\r
- -$row["TotalAmount"] : $row["TotalAmount"];\r
- return $value>0 ? price_format($value) : '';\r
-}\r
-\r
-function credit_link($row)\r
-{\r
- if (@$_REQUEST['popup'])\r
- return '';\r
- return $row['type'] == ST_SALESINVOICE && $row["Outstanding"] > 0 ?\r
- pager_link(_("Credit This") ,\r
- "/sales/customer_credit_invoice.php?InvoiceNumber=". $row['trans_no'], ICON_CREDIT):'';\r
-}\r
-\r
-function edit_link($row)\r
-{\r
- $str = '';\r
-\r
- if (@$_REQUEST['popup'])\r
- return '';\r
- switch($row['type']) {\r
- case ST_SALESINVOICE:\r
- if (get_voided_entry(ST_SALESINVOICE, $row["trans_no"]) === false && $row['Allocated'] == 0)\r
- $str = "/sales/customer_invoice.php?ModifyInvoice=".$row['trans_no'];\r
- break;\r
- case ST_CUSTCREDIT:\r
- if (get_voided_entry(ST_CUSTCREDIT, $row["trans_no"]) === false && $row['Allocated'] == 0) // 2008-11-19 Joe Hunt\r
- { \r
- if ($row['order_']==0) // free-hand credit note\r
- $str = "/sales/credit_note_entry.php?ModifyCredit=".$row['trans_no'];\r
- else // credit invoice\r
- $str = "/sales/customer_credit_invoice.php?ModifyCredit=".$row['trans_no'];\r
- } \r
- break;\r
- case ST_CUSTDELIVERY:\r
- if (get_voided_entry(ST_CUSTDELIVERY, $row["trans_no"]) === false)\r
- $str = "/sales/customer_delivery.php?ModifyDelivery=".$row['trans_no'];\r
- break;\r
- case ST_CUSTPAYMENT:\r
- if (get_voided_entry(ST_CUSTPAYMENT, $row["trans_no"]) === false)\r
- $str = "/sales/customer_payments.php?trans_no=".$row['trans_no'];\r
- break;\r
- } \r
- if ($str != "" && !is_closed_trans($row['type'], $row["trans_no"]))\r
- return pager_link(_('Edit'), $str, ICON_EDIT);\r
- return ''; \r
-}\r
-\r
-function prt_link($row)\r
-{\r
- if ($row['type'] == ST_CUSTPAYMENT || $row['type'] == ST_BANKDEPOSIT) \r
- return print_document_link($row['trans_no']."-".$row['type'], _("Print Receipt"), true, ST_CUSTPAYMENT, ICON_PRINT);\r
- elseif ($row['type'] == ST_BANKPAYMENT) // bank payment printout not defined yet.\r
- return '';\r
- else \r
- return print_document_link($row['trans_no']."-".$row['type'], _("Print"), true, $row['type'], ICON_PRINT);\r
-}\r
-\r
-function check_overdue($row)\r
-{\r
- return $row['OverDue'] == 1\r
- && (abs($row["TotalAmount"]) - $row["Allocated"] != 0);\r
-}\r
-//------------------------------------------------------------------------------------------------\r
-$sql = get_sql_for_customer_inquiry();\r
-\r
-//------------------------------------------------------------------------------------------------\r
-db_query("set @bal:=0");\r
-\r
-$cols = array(\r
- _("Type") => array('fun'=>'systype_name', 'ord'=>''),\r
- _("#") => array('fun'=>'trans_view', 'ord'=>''),\r
- _("Order") => array('fun'=>'order_view'), \r
- _("Reference"), \r
- _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'desc'),\r
- _("Due Date") => array('type'=>'date', 'fun'=>'due_date'),\r
- _("Customer") => array('ord'=>''), \r
- _("Branch") => array('ord'=>''), \r
- _("Currency") => array('align'=>'center'),\r
- _("Debit") => array('align'=>'right', 'fun'=>'fmt_debit'), \r
- _("Credit") => array('align'=>'right','insert'=>true, 'fun'=>'fmt_credit'), \r
- _("RB") => array('align'=>'right', 'type'=>'amount'),\r
- array('insert'=>true, 'fun'=>'gl_view'),\r
- array('insert'=>true, 'fun'=>'credit_link'),\r
- array('insert'=>true, 'fun'=>'edit_link'),\r
- array('insert'=>true, 'fun'=>'prt_link')\r
- );\r
-\r
-\r
-if ($_POST['customer_id'] != ALL_TEXT) {\r
- $cols[_("Customer")] = 'skip';\r
- $cols[_("Currency")] = 'skip';\r
-}\r
-if ($_POST['filterType'] == ALL_TEXT)\r
- $cols[_("RB")] = 'skip';\r
-\r
-$table =& new_db_pager('trans_tbl', $sql, $cols);\r
-$table->set_marker('check_overdue', _("Marked items are overdue."));\r
-\r
-$table->width = "85%";\r
-\r
-display_db_pager($table);\r
-\r
-hidden('popup', @$_REQUEST['popup']);\r
-end_form();\r
-\r
-end_page(@$_REQUEST['popup'], false, false);\r
-\r
-?>\r
+<?php
+/**********************************************************************
+ Copyright (C) FrontAccounting, LLC.
+ Released under the terms of the GNU General Public License, GPL,
+ as published by the Free Software Foundation, either version 3
+ 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_SALESTRANSVIEW';
+$path_to_root = "../..";
+include_once($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 ($SysPrefs->use_popup_windows)
+ $js .= get_js_open_window(900, 500);
+if (user_use_date_picker())
+ $js .= get_js_date_picker();
+page(_($help_context = "Customer Transactions"), isset($_GET['customer_id']), false, "", $js);
+
+//------------------------------------------------------------------------------------------------
+
+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_amount($row)
+{
+ $value =
+ $row['type']==ST_CUSTCREDIT || $row['type']==ST_CUSTPAYMENT || $row['type']==ST_BANKDEPOSIT ?
+ -$row["TotalAmount"] : $row["TotalAmount"];
+ return price_format($value);
+}
+
+function credit_link($row)
+{
+ global $page_nested;
+
+ if ($page_nested)
+ return '';
+ 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)
+{
+ global $page_nested;
+
+ $str = '';
+ if ($page_nested)
+ return '';
+
+ return $row['type'] == ST_CUSTCREDIT && $row['order_'] ? '' : // allow only free hand credit notes edition
+ trans_editor_link($row['type'], $row['trans_no']);
+}
+
+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
+ && floatcmp($row["TotalAmount"], $row["Allocated"]) != 0;
+}
+//------------------------------------------------------------------------------------------------
+
+function display_customer_summary($customer_record)
+{
+ $past1 = get_company_pref('past_due_days');
+ $past2 = 2 * $past1;
+ if ($customer_record["dissallow_invoices"] != 0)
+ {
+ echo "<center><font color=red size=4><b>" . _("CUSTOMER ACCOUNT IS ON HOLD") . "</font></b></center>";
+ }
+
+ $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();
+}
+
+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();
+
+if (!$page_nested)
+ customer_list_cells(_("Select a customer: "), 'customer_id', null, true, true, false, true);
+
+cust_allocations_list_cells(null, 'filterType', null, true, true);
+
+if ($_POST['filterType'] != '2')
+{
+ date_cells(_("From:"), 'TransAfterDate', '', null, -user_transaction_days());
+ date_cells(_("To:"), 'TransToDate', '', null);
+}
+check_cells(_("Zero values"), 'show_voided');
+
+submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), 'default');
+end_row();
+end_table();
+
+set_global_customer($_POST['customer_id']);
+
+//------------------------------------------------------------------------------------------------
+
+div_start('totals_tbl');
+if ($_POST['customer_id'] != "" && $_POST['customer_id'] != ALL_TEXT)
+{
+ $customer_record = get_customer_details(get_post('customer_id'), get_post('TransToDate'));
+ display_customer_summary($customer_record);
+ echo "<br>";
+}
+div_end();
+
+if (get_post('RefreshInquiry') || list_updated('filterType'))
+{
+ $Ajax->activate('_page_body');
+}
+//------------------------------------------------------------------------------------------------
+$sql = get_sql_for_customer_inquiry(get_post('TransAfterDate'), get_post('TransToDate'),
+ get_post('customer_id'), get_post('filterType'), check_value('show_voided'));
+
+//------------------------------------------------------------------------------------------------
+//db_query("set @bal:=0");
+
+$cols = array(
+ _("Type") => array('fun'=>'systype_name', 'ord'=>''),
+ _("#") => array('fun'=>'trans_view', 'ord'=>'', 'align'=>'right'),
+ _("Order") => array('fun'=>'order_view', 'align'=>'right'),
+ _("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'),
+ _("Amount") => array('align'=>'right', 'fun'=>'fmt_amount'),
+ _("Balance") => 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'] != '2')
+ $cols[_("Balance")] = '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();
projects / fa-stable.git / blobdiff