1<?php 2/********************************************************************** 3 Copyright (C) FrontAccounting, LLC. 4 Released under the terms of the GNU General Public License, GPL, 5 as published by the Free Software Foundation, either version 3 6 of the License, or (at your option) any later version. 7 This program is distributed in the hope that it will be useful, 8 but WITHOUT ANY WARRANTY; without even the implied warranty of 9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>. 11***********************************************************************/ 12$page_security = 'SA_SALESALLOC'; 13$path_to_root = "../.."; 14include($path_to_root . "/includes/db_pager.inc"); 15include_once($path_to_root . "/includes/session.inc"); 16 17include_once($path_to_root . "/sales/includes/sales_ui.inc"); 18include_once($path_to_root . "/sales/includes/sales_db.inc"); 19$js = ""; 20if ($use_popup_windows) 21 $js .= get_js_open_window(900, 500); 22page(_($help_context = "Customer Allocations"), false, false, "", $js); 23 24//-------------------------------------------------------------------------------- 25 26start_form(); 27 /* show all outstanding receipts and credits to be allocated */ 28 29 if (!isset($_POST['customer_id'])) 30 $_POST['customer_id'] = get_global_customer(); 31 32 echo "<center>" . _("Select a customer: ") . " "; 33 echo customer_list('customer_id', $_POST['customer_id'], true, true); 34 echo "<br>"; 35 check(_("Show Settled Items:"), 'ShowSettled', null, true); 36 echo "</center><br><br>"; 37 38 set_global_customer($_POST['customer_id']); 39 40 if (isset($_POST['customer_id']) && ($_POST['customer_id'] == ALL_TEXT)) 41 { 42 unset($_POST['customer_id']); 43 } 44 45 /*if (isset($_POST['customer_id'])) { 46 $custCurr = get_customer_currency($_POST['customer_id']); 47 if (!is_company_currency($custCurr)) 48 echo _("Customer Currency:") . $custCurr; 49 }*/ 50 51 $settled = false; 52 if (check_value('ShowSettled')) 53 $settled = true; 54 55 $customer_id = null; 56 if (isset($_POST['customer_id'])) 57 $customer_id = $_POST['customer_id']; 58 59//-------------------------------------------------------------------------------- 60function systype_name($dummy, $type) 61{ 62 global $systypes_array; 63 64 return $systypes_array[$type]; 65} 66 67function trans_view($trans) 68{ 69 return get_trans_view_str($trans["type"], $trans["trans_no"]); 70} 71 72function alloc_link($row) 73{ 74 return pager_link(_("Allocate"), 75 "/sales/allocations/customer_allocate.php?trans_no=" 76 .$row["trans_no"] . "&trans_type=" . $row["type"]. "&debtor_no=" . $row["debtor_no"], ICON_ALLOC); 77} 78 79function amount_left($row) 80{ 81 return price_format($row["Total"]-$row["alloc"]); 82} 83 84function check_settled($row) 85{ 86 return $row['settled'] == 1; 87} 88 89 90$sql = get_allocatable_from_cust_sql($customer_id, $settled); 91 92$cols = array( 93 _("Transaction Type") => array('fun'=>'systype_name'), 94 _("#") => array('fun'=>'trans_view'), 95 _("Reference"), 96 _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'asc'), 97 _("Customer") => array('ord'=>''), 98 _("Currency") => array('align'=>'center'), 99 _("Total") => 'amount', 100 _("Left to Allocate") => array('align'=>'right','insert'=>true, 'fun'=>'amount_left'), 101 array('insert'=>true, 'fun'=>'alloc_link') 102 ); 103 104if (isset($_POST['customer_id'])) { 105 $cols[_("Customer")] = 'skip'; 106 $cols[_("Currency")] = 'skip'; 107} 108 109$table =& new_db_pager('alloc_tbl', $sql, $cols); 110$table->set_marker('check_settled', _("Marked items are settled."), 'settledbg', 'settledfg'); 111 112$table->width = "75%"; 113 114display_db_pager($table); 115end_form(); 116 117end_page(); 118?>