X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fcustomer_inquiry.php;h=715de08ae6495e2f2a429cfb4c18657f37be6a81;hb=3e2a432dd72688dbac39a07716201b2b00c16c8b;hp=57725f38ae833154923911d50a5d98c027d2f60e;hpb=0c1bcd8ce3c089d7ddb3722a097f8fc8417f41e6;p=fa-stable.git diff --git a/sales/inquiry/customer_inquiry.php b/sales/inquiry/customer_inquiry.php index 57725f38..715de08a 100644 --- a/sales/inquiry/customer_inquiry.php +++ b/sales/inquiry/customer_inquiry.php @@ -29,19 +29,20 @@ if (!isset($_POST['customer_id'])) $_POST['customer_id'] = get_global_customer(); start_table("class='tablestyle_noborder'"); +start_row(); -customer_list_cells(_("Select a customer: "), 'customer_id', $_POST['customer_id'], true); +customer_list_cells(_("Select a customer: "), 'customer_id', null, true); -date_cells(_("From:"), 'TransAfterDate', null, -30); -date_cells(_("To:"), 'TransToDate', null, 1); +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('Refresh Inquiry', _("Search")); - +submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), true); +end_row(); end_table(); end_form(); @@ -64,11 +65,11 @@ function display_customer_summary($customer_record) $nowdue = "1-" . $past1 . " " . _('Days'); $pastdue1 = $past1 + 1 . "-" . $past2 . " " . _('Days'); $pastdue2 = _('Over') . " " . $past2 . " " . _('Days'); - + start_table("width=80% $table_style"); $th = array(_("Currency"), _("Terms"), _("Current"), $nowdue, $pastdue1, $pastdue2, _("Total Balance")); - table_header($th); + table_header($th); start_row(); label_cell($customer_record["curr_code"]); @@ -107,28 +108,28 @@ function get_transactions() if ($_POST['filterType'] != reserved_words::get_all()) { - if ($_POST['filterType'] == '1') + if ($_POST['filterType'] == '1') { $sql .= " AND (".TB_PREF."debtor_trans.type = 10 OR ".TB_PREF."debtor_trans.type = 1) "; - } - elseif ($_POST['filterType'] == '2') + } + elseif ($_POST['filterType'] == '2') { $sql .= " AND (".TB_PREF."debtor_trans.type = 10) "; - } - elseif ($_POST['filterType'] == '3') + } + 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') + } + elseif ($_POST['filterType'] == '4') { $sql .= " AND ".TB_PREF."debtor_trans.type = 11 "; } - elseif ($_POST['filterType'] == '5') + elseif ($_POST['filterType'] == '5') { $sql .= " AND ".TB_PREF."debtor_trans.type = 13 "; } - if ($_POST['filterType'] == '2') + if ($_POST['filterType'] == '2') { $today = date2sql(Today()); $sql .= " AND ".TB_PREF."debtor_trans.due_date < '$today' @@ -138,7 +139,7 @@ function get_transactions() } } - $sql .= " ORDER BY ".TB_PREF."debtor_trans.tran_date DESC, + $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"); @@ -146,50 +147,56 @@ function get_transactions() //------------------------------------------------------------------------------------------------ -if (($_POST['customer_id'] != "") && ($_POST['customer_id'] != reserved_words::get_all())) +div_start('totals_tbl'); +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(); //------------------------------------------------------------------------------------------------ $result = get_transactions(); -if (db_num_rows($result) == 0) +//------------------------------------------------------------------------------------------------ +if(get_post('RefreshInquiry')) { - display_note(_("The selected customer has no transactions for the given dates."), 0, 2); - end_page(); - exit; + $Ajax->activate('trans_tbl'); + $Ajax->activate('totals_tbl'); } - //------------------------------------------------------------------------------------------------ +print_hidden_script(10); + +div_start('trans_tbl'); +if (db_num_rows($result) == 0) +{ + display_note(_("The selected customer has no transactions for the given dates."), 0, 2); +} else { -start_table("$table_style width='80%'"); + start_table("$table_style width='80%'"); $th = array(_("Type"), _("#"), _("Order"), _("Reference"), _("Date"), _("Due Date"), - _("Customer"), _("Branch"), _("Currency"), _("Debit"), _("Credit"), "", "","" - /*,"" print */); + _("Customer"), _("Branch"), _("Currency"), _("Debit"), _("Credit"), "", "","",""); -if ($_POST['customer_id'] != reserved_words::get_all()) { - unset($th[6], $th[8]); -} + if ($_POST['customer_id'] != reserved_words::get_all()) { + unset($th[6], $th[8]); + } -table_header($th); + table_header($th); -$j = 1; -$k = 0; //row colour counter -$over_due = false; -while ($myrow = db_fetch($result)) -{ + $j = 1; + $k = 0; //row colour counter + $over_due = false; + while ($myrow = db_fetch($result)) + { if ($myrow['OverDue'] == 1) { start_row("class='overduebg'"); $over_due = true; - } + } else alt_table_row_color($k); @@ -205,18 +212,18 @@ while ($myrow = db_fetch($result)) if ($myrow["TotalAmount"] - $myrow["Allocated"] > 0) $credit_me_str = "" . _("Credit This") . ""; $edit_page= $path_to_root.'/sales/customer_invoice.php?ModifyInvoice=' - . $myrow['trans_no']; + . $myrow['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']; + . $myrow['trans_no']; else // credit invoice $edit_page= $path_to_root.'/sales/customer_credit_invoice.php?ModifyCredit=' - . $myrow['trans_no']; + . $myrow['trans_no']; break; - + case 13: $edit_page= $path_to_root.'/sales/customer_delivery.php?ModifyDelivery=' . $myrow['trans_no']; break; @@ -231,11 +238,8 @@ while ($myrow = db_fetch($result)) $gl_trans_str = get_gl_view_str_cell($myrow["type"], $myrow["trans_no"]); -// $print_str = "" . _("Print") . ""; - - $branch_name = ""; - if ($myrow["branch_code"] > 0) + if ($myrow["branch_code"] > 0) { $branch_name = get_branch_name($myrow["branch_code"]); } @@ -255,39 +259,37 @@ while ($myrow = db_fetch($result)) 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']==11 || $myrow['type']==12 || $myrow['type']==2 ? -$myrow["TotalAmount"] : $myrow["TotalAmount"]); echo $gl_trans_str; - label_cell($edit_page=='' ? '' : "" . _('Edit') . ''); -// label_cell(print_document_link($myrow['trans_no'], _("Print"))); - + 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(''); - -// if ($myrow["type"] == 10) -// label_cell($print_str, 'nowrap'); -// else -// label_cell(''); - end_row(); - $j++; - if ($j == 12) - { - $j = 1; - table_header($th); - } //end of page full new headings if -} //end of transaction while loop + $j++; + if ($j == 12) + { + $j = 1; + table_header($th); + } //end of page full new headings if + } //end of transaction while loop -end_table(1); + end_table(1); -if ($over_due) - display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'"); - + if ($over_due) + display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'"); +} +div_end(); end_page(); ?>