X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fcustomer_inquiry.php;h=8bd2d4c72babe5de35ba9bc3128b3de69be8fa9c;hb=8bd22b7671d18cfdf01b8a0f3f66455d5de28014;hp=1bffa40be39e8708c78e22e24109bbc8982ca99e;hpb=d67d5295b9342c011697ce4df325197e29898588;p=fa-stable.git diff --git a/sales/inquiry/customer_inquiry.php b/sales/inquiry/customer_inquiry.php index 1bffa40b..8bd2d4c7 100644 --- a/sales/inquiry/customer_inquiry.php +++ b/sales/inquiry/customer_inquiry.php @@ -1,7 +1,17 @@ . +***********************************************************************/ +$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"); @@ -13,7 +23,7 @@ if ($use_popup_windows) $js .= get_js_open_window(900, 500); if ($use_date_picker) $js .= get_js_date_picker(); -page(_("Customer Transactions"), false, false, "", $js); +page(_($help_context = "Customer Transactions"), false, false, "", $js); if (isset($_GET['customer_id'])) @@ -41,12 +51,10 @@ if (!isset($_POST['filterType'])) cust_allocations_list_cells(null, 'filterType', $_POST['filterType'], true); -submit_cells('Refresh Inquiry', _("Search")); +submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), 'default'); end_row(); end_table(); -end_form(); - set_global_customer($_POST['customer_id']); //------------------------------------------------------------------------------------------------ @@ -81,207 +89,162 @@ function display_customer_summary($customer_record) amount_cell($customer_record["Balance"]); end_row(); - end_table();; + end_table(); } - //------------------------------------------------------------------------------------------------ -function get_transactions() +div_start('totals_tbl'); +if ($_POST['customer_id'] != "" && $_POST['customer_id'] != ALL_TEXT) { - $date_after = date2sql($_POST['TransAfterDate']); - $date_to = date2sql($_POST['TransToDate']); - - $sql = "SELECT ".TB_PREF."debtor_trans.*, - ".TB_PREF."debtors_master.name AS CustName, ".TB_PREF."debtors_master.curr_code AS CustCurrCode, - (".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + " - .TB_PREF."debtor_trans.ov_freight + ".TB_PREF."debtor_trans.ov_freight_tax + ".TB_PREF."debtor_trans.ov_discount) - AS TotalAmount, ".TB_PREF."debtor_trans.alloc AS Allocated, - ((".TB_PREF."debtor_trans.type = 10) - AND ".TB_PREF."debtor_trans.due_date < '" . date2sql(Today()) . "') AS OverDue - FROM ".TB_PREF."debtor_trans, ".TB_PREF."debtors_master - WHERE ".TB_PREF."debtors_master.debtor_no = ".TB_PREF."debtor_trans.debtor_no - AND ".TB_PREF."debtor_trans.tran_date >= '$date_after' - AND ".TB_PREF."debtor_trans.tran_date <= '$date_to'"; - - if ($_POST['customer_id'] != reserved_words::get_all()) - $sql .= " AND ".TB_PREF."debtor_trans.debtor_no = '" . $_POST['customer_id'] . "'"; - - if ($_POST['filterType'] != reserved_words::get_all()) - { - if ($_POST['filterType'] == '1') - { - $sql .= " AND (".TB_PREF."debtor_trans.type = 10 OR ".TB_PREF."debtor_trans.type = 1) "; - } - elseif ($_POST['filterType'] == '2') - { - $sql .= " AND (".TB_PREF."debtor_trans.type = 10) "; - } - elseif ($_POST['filterType'] == '3') - { - $sql .= " AND (".TB_PREF."debtor_trans.type = " . systypes::cust_payment() . " OR ".TB_PREF."debtor_trans.type = 2) "; - } - elseif ($_POST['filterType'] == '4') - { - $sql .= " AND ".TB_PREF."debtor_trans.type = 11 "; - } - elseif ($_POST['filterType'] == '5') - { - $sql .= " AND ".TB_PREF."debtor_trans.type = 13 "; - } - - if ($_POST['filterType'] == '2') - { - $today = date2sql(Today()); - $sql .= " AND ".TB_PREF."debtor_trans.due_date < '$today' - AND (".TB_PREF."debtor_trans.ov_amount + ".TB_PREF."debtor_trans.ov_gst + " - .TB_PREF."debtor_trans.ov_freight_tax + ".TB_PREF."debtor_trans.ov_freight + " - .TB_PREF."debtor_trans.ov_discount - ".TB_PREF."debtor_trans.alloc > 0) "; - } - } - - $sql .= " ORDER BY ".TB_PREF."debtor_trans.tran_date DESC, - ".TB_PREF."debtor_trans.type,".TB_PREF."debtor_trans.trans_no "; - - return db_query($sql,"No transactions were returned"); -} - -//------------------------------------------------------------------------------------------------ -if ($_POST['customer_id'] != "" && $_POST['customer_id'] != reserved_words::get_all()) -{ - $customer_record = get_customer_details($_POST['customer_id']); + $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'); +} //------------------------------------------------------------------------------------------------ -$result = get_transactions(); +function systype_name($dummy, $type) +{ + global $systypes_array; + + return $systypes_array[$type]; +} -if (db_num_rows($result) == 0) +function order_view($row) { - display_note(_("The selected customer has no transactions for the given dates."), 0, 2); - end_page(); - exit; + 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"]); +} -print_hidden_script(10); -start_table("$table_style width='80%'"); +function due_date($row) +{ + return $row["type"] == ST_SALESINVOICE ? $row["due_date"] : ''; +} - $th = array(_("Type"), _("#"), _("Order"), _("Reference"), _("Date"), _("Due Date"), - _("Customer"), _("Branch"), _("Currency"), _("Debit"), _("Credit"), "", "","",""); +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) : ''; -if ($_POST['customer_id'] != reserved_words::get_all()) { - unset($th[6], $th[8]); } -table_header($th); +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["TotalAmount"] - $row["Allocated"] > 0 ? + pager_link(_("Credit This"), + "/sales/customer_credit_invoice.php?InvoiceNumber=". + $row['trans_no'], ICON_CREDIT) + : ''; +} -$j = 1; -$k = 0; //row colour counter -$over_due = false; -while ($myrow = db_fetch($result)) +function edit_link($row) { + $str = ''; - if ($myrow['OverDue'] == 1) - { - start_row("class='overduebg'"); - $over_due = true; - } - else - alt_table_row_color($k); - - $edit_page=''; - $due_date_str = ''; - $credit_me_str = ''; - - switch($myrow['type']) { - case 10: - $due_date_str = sql2date($myrow["due_date"]); - /*Show a link to allow an invoice to be credited */ - // only allow crediting if it's not been totally allocated - if ($myrow["TotalAmount"] - $myrow["Allocated"] > 0) - $credit_me_str = "" . _("Credit This") . ""; - $edit_page= $path_to_root.'/sales/customer_invoice.php?ModifyInvoice=' - . $myrow['trans_no']; + 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 11: - if ($myrow['order_']==0) // free-hand credit note - $edit_page= $path_to_root.'/sales/credit_note_entry.php?ModifyCredit=' - . $myrow['trans_no']; - else // credit invoice - $edit_page= $path_to_root.'/sales/customer_credit_invoice.php?ModifyCredit=' - . $myrow['trans_no']; + 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 13: - $edit_page= $path_to_root.'/sales/customer_delivery.php?ModifyDelivery=' - . $myrow['trans_no']; break; } + if ($str != "" && !is_closed_trans($row['type'], $row["trans_no"])) + return pager_link(_('Edit'), $str, ICON_EDIT); + return ''; +} - $date = sql2date($myrow["tran_date"]); - - if ($myrow["order_"] > 0) - $preview_order_str = get_customer_trans_view_str(systypes::sales_order(), $myrow["order_"]); - else - $preview_order_str = ""; - - $gl_trans_str = get_gl_view_str_cell($myrow["type"], $myrow["trans_no"]); +function prt_link($row) +{ + if ($row['type'] != ST_CUSTPAYMENT && $row['type'] != ST_BANKDEPOSIT) // customer payment or bank deposit printout not defined yet. + return print_document_link($row['trans_no']."-".$row['type'], _("Print"), true, $row['type'], ICON_PRINT); + else + return print_document_link($row['trans_no']."-".$row['type'], _("Print Receipt"), true, ST_CUSTPAYMENT, ICON_PRINT); +} - $branch_name = ""; - if ($myrow["branch_code"] > 0) - { - $branch_name = get_branch_name($myrow["branch_code"]); - } +function check_overdue($row) +{ + return $row['OverDue'] == 1 + && (abs($row["TotalAmount"]) - $row["Allocated"] != 0); +} +//------------------------------------------------------------------------------------------------ +$sql = get_sql_for_customer_inquiry(); - $preview_trans_str = get_trans_view_str($myrow["type"], $myrow["trans_no"]); - - label_cell(systypes::name($myrow["type"])); - - label_cell($preview_trans_str); - label_cell($preview_order_str); - label_cell($myrow["reference"]); - label_cell($date, "nowrap"); - label_cell($due_date_str, "nowrap"); - if ($_POST['customer_id'] == reserved_words::get_all()) - label_cell($myrow["CustName"]); - label_cell($branch_name); - if ($_POST['customer_id'] == reserved_words::get_all()) - label_cell($myrow["CustCurrCode"]); - display_debit_or_credit_cells( - $myrow['type']==11 || $myrow['type']==12 || $myrow['type']==2 ? - -$myrow["TotalAmount"] : $myrow["TotalAmount"]); - - echo $gl_trans_str; - - label_cell($edit_page=='' ? '' : "" . _('Edit') . ''); - if ($myrow['type'] == 10 || $myrow['type'] == 11) - label_cell(print_document_link($myrow['trans_no'], _("Print"), true, $myrow['type'])); - else - label_cell(""); - - if ($credit_me_str != "") - label_cell($credit_me_str, "nowrap"); - else - label_cell(''); - end_row(); +//------------------------------------------------------------------------------------------------ +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'; - $j++; - if ($j == 12) - { - $j = 1; - table_header($th); - } //end of page full new headings if -} //end of transaction while loop +$table =& new_db_pager('trans_tbl', $sql, $cols); +$table->set_marker('check_overdue', _("Marked items are overdue.")); -end_table(1); +$table->width = "85%"; -if ($over_due) - display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'"); +display_db_pager($table); +end_form(); end_page(); ?>