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 $path_to_root="../..";
14 include($path_to_root . "/includes/db_pager.inc");
15 include_once($path_to_root . "/includes/session.inc");
17 include_once($path_to_root . "/sales/includes/sales_ui.inc");
18 include_once($path_to_root . "/sales/includes/sales_db.inc");
20 if ($use_popup_windows)
21 $js .= get_js_open_window(900, 500);
22 page(_("Customer Allocations"), false, false, "", $js);
24 //--------------------------------------------------------------------------------
25 if ($ret = context_restore()) {
26 if(isset($ret['customer_id']))
27 $_POST['customer_id'] = $ret['customer_id'];
29 if (isset($_POST['_customer_id_editor'])) {
30 context_call($path_to_root.'/sales/manage/customers.php?debtor_no='.$_POST['customer_id'] );
34 /* show all outstanding receipts and credits to be allocated */
35 /*Clear any previous allocation records */
36 if (isset($_SESSION['alloc']))
38 unset($_SESSION['alloc']->allocs);
39 unset($_SESSION['alloc']);
41 if (!isset($_POST['customer_id']))
42 $_POST['customer_id'] = get_global_customer();
44 echo "<center>" . _("Select a customer: ") . " ";
45 customer_list('customer_id', $_POST['customer_id'], true, true);
47 check(_("Show Settled Items:"), 'ShowSettled', null, true);
48 echo "</center><br><br>";
50 set_global_customer($_POST['customer_id']);
52 if (isset($_POST['customer_id']) && ($_POST['customer_id'] == reserved_words::get_all()))
54 unset($_POST['customer_id']);
57 /*if (isset($_POST['customer_id'])) {
58 $custCurr = get_customer_currency($_POST['customer_id']);
59 if (!is_company_currency($custCurr))
60 echo _("Customer Currency:") . $custCurr;
64 if (check_value('ShowSettled'))
68 if (isset($_POST['customer_id']))
69 $customer_id = $_POST['customer_id'];
71 //--------------------------------------------------------------------------------
72 function systype_name($dummy, $type)
74 return systypes::name($type);
77 function trans_view($trans)
79 return get_trans_view_str($trans["type"], $trans["trans_no"]);
82 function alloc_link($row)
84 return pager_link(_("Allocate"),
85 "/sales/allocations/customer_allocate.php?trans_no="
86 .$row["trans_no"] . "&trans_type=" . $row["type"], ICON_MONEY);
89 function amount_left($row)
91 return price_format($row["Total"]-$row["alloc"]);
94 function check_settled($row)
96 return $row['settled'] == 1;
100 $sql = get_allocatable_from_cust_sql($customer_id, $settled);
103 _("Transaction Type") => array('fun'=>'systype_name'),
104 _("#") => array('fun'=>'trans_view'),
106 _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'asc'),
107 _("Customer") => array('ord'=>''),
108 _("Currency") => array('align'=>'center'),
109 _("Total") => 'amount',
110 _("Left to Allocate") => array('align'=>'right','insert'=>true, 'fun'=>'amount_left'),
111 array('insert'=>true, 'fun'=>'alloc_link')
114 if (isset($_POST['customer_id'])) {
115 $cols[_("Customer")] = 'skip';
116 $cols[_("Currency")] = 'skip';
119 $table =& new_db_pager('alloc_tbl', $sql, $cols);
120 $table->set_marker('check_settled', _("Marked items are settled."), 'settledbg', 'settledfg');
122 if (get_post('_ShowSettled_update') || get_post('_customer_id_update')) {
123 $table->set_sql($sql);
124 $table->set_columns($cols);
126 $table->width = "75%";
128 display_db_pager($table);