X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sales%2Finquiry%2Fcustomer_inquiry.php;h=b8e555bbc3389464550f2f4ab8bb81eee990b208;hb=b956923926de6b7eecf57510cf86857354cac1b3;hp=c9d64bdc00548033f60f05fbe14699c26ff10a60;hpb=902e63ca33432a8499a1f2d1c51e9620e975d668;p=fa-stable.git diff --git a/sales/inquiry/customer_inquiry.php b/sales/inquiry/customer_inquiry.php index c9d64bdc..b8e555bb 100644 --- a/sales/inquiry/customer_inquiry.php +++ b/sales/inquiry/customer_inquiry.php @@ -1,5 +1,14 @@ . +***********************************************************************/ $page_security = 1; $path_to_root="../.."; include($path_to_root . "/includes/db_pager.inc"); @@ -45,9 +54,7 @@ cust_allocations_list_cells(null, 'filterType', $_POST['filterType'], true); submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), true); end_row(); end_table(); - end_form(); - set_global_customer($_POST['customer_id']); //------------------------------------------------------------------------------------------------ @@ -82,7 +89,7 @@ function display_customer_summary($customer_record) amount_cell($customer_record["Balance"]); end_row(); - end_table();; + end_table(); } //------------------------------------------------------------------------------------------------ @@ -95,8 +102,12 @@ if ($_POST['customer_id'] != "" && $_POST['customer_id'] != reserved_words::get_ } div_end(); - +if(get_post('RefreshInquiry')) +{ + $Ajax->activate('totals_tbl'); +} //------------------------------------------------------------------------------------------------ + function systype_name($dummy, $type) { return systypes::name($type); @@ -142,23 +153,12 @@ function fmt_credit($row) return $value>0 ? price_format($value) : ''; } -function alloc_link($row) -{ - if ($row['type'] == 10) - if ($row["TotalAmount"] - $row["Allocated"] > 0) - return pager_link(_("Allocation"), - "/sales/allocations/customer_allocate.php" - ."?trans_no={$row['trans_no']}&trans_type=" - .$row['type']); - return ''; -} - function credit_link($row) { return $row['type'] == 10 ? pager_link(_("Credit This"), "/sales/customer_credit_invoice.php?InvoiceNumber=". - $row['trans_no']) + $row['trans_no'], ICON_CREDIT) : ''; } @@ -180,13 +180,13 @@ function edit_link($row) $str = "/sales/customer_delivery.php?ModifyDelivery=".$row['trans_no']; break; } - return pager_link(_('Edit'), $str); + return pager_link(_('Edit'), $str, ICON_EDIT); } function prt_link($row) { if ($row['type'] != 12) // customer payment printout not defined yet. - return print_document_link($row['trans_no'], _("Print"), true, $row['type']); + return print_document_link($row['trans_no'], _("Print"), true, $row['type'], ICON_PRINT); } function check_overdue($row) @@ -219,7 +219,8 @@ function check_overdue($row) .TB_PREF."cust_branch as branch WHERE debtor.debtor_no = trans.debtor_no AND trans.tran_date >= '$date_after' - AND trans.tran_date <= '$date_to'"; + AND trans.tran_date <= '$date_to' + AND trans.branch_code = branch.branch_code"; if ($_POST['customer_id'] != reserved_words::get_all()) $sql .= " AND trans.debtor_no = '" . $_POST['customer_id'] . "'"; @@ -272,7 +273,6 @@ $cols = array( _("Debit") => array('align'=>'right', 'fun'=>'fmt_debit'), _("Credit") => array('align'=>'right','insert'=>true, 'fun'=>'fmt_credit'), array('insert'=>true, 'fun'=>'gl_view'), - array('insert'=>true, 'fun'=>'alloc_link'), array('insert'=>true, 'fun'=>'credit_link'), array('insert'=>true, 'fun'=>'edit_link'), array('insert'=>true, 'fun'=>'prt_link') @@ -287,19 +287,14 @@ if ($_POST['customer_id'] != reserved_words::get_all()) { $table =& new_db_pager('trans_tbl', $sql, $cols); $table->set_marker('check_overdue', _("Marked items are overdue.")); - -if(get_post('RefreshInquiry')) -{ +if (get_post('RefreshInquiry')) { $table->set_sql($sql); $table->set_columns($cols); - $Ajax->activate('trans_tbl'); - $Ajax->activate('totals_tbl'); } +start_form(); +display_db_pager($table); - start_form(); - display_db_pager($table); - end_form(); +end_form(); end_page(); - ?>