5 include_once($path_to_root . "/includes/session.inc");
7 include_once($path_to_root . "/includes/date_functions.inc");
9 include_once($path_to_root . "/includes/ui.inc");
10 include_once($path_to_root . "/includes/banking.inc");
12 include_once($path_to_root . "/sales/includes/sales_db.inc");
14 if ($use_popup_windows)
15 $js .= get_js_open_window(900, 500);
16 page(_("Supplier Allocations"), false, false, "", $js);
18 //--------------------------------------------------------------------------------
19 if ($ret = context_restore()) {
20 if(isset($ret['supplier_id']))
21 $_POST['supplier_id'] = $ret['supplier_id'];
23 if (isset($_POST['_supplier_id_editor'])) {
24 context_call($path_to_root.'/purchasing/manage/suppliers.php?supplier_id='.$_POST['supplier_id'] );
27 //--------------------------------------------------------------------------------
29 function display_allocatable_transactions()
31 global $table_style, $path_to_root;
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['supplier_id']))
42 $_POST['supplier_id'] = get_global_supplier();
44 echo "<center>" . _("Select a Supplier: ") . " ";
45 supplier_list('supplier_id', $_POST['supplier_id'], true, true);
47 check(_("Show Settled Items:"), 'ShowSettled', null, true);
48 echo "</center><br><br>";
50 set_global_supplier($_POST['supplier_id']);
52 if (isset($_POST['supplier_id']) && ($_POST['supplier_id'] == reserved_words::get_all()))
54 unset($_POST['supplier_id']);
58 if (check_value('ShowSettled'))
62 if (isset($_POST['supplier_id']))
63 $supplier_id = $_POST['supplier_id'];
65 $trans_items = get_allocatable_from_supp_transactions($supplier_id, $settled);
66 div_start('alloc_tbl');
67 start_table($table_style);
68 if (!isset($_POST['supplier_id']))
69 $th = array(_("Transaction Type"), _("#"), _("Reference"), _("Date"), _("Supplier"),
70 _("Currency"), _("Total"), _("Left To Allocate"));
72 $th = array(_("Transaction Type"), _("#"), _("Reference"), _("Date"),
73 _("Total"), _("Left To Allocate"));
76 $k = 0; //row colour counter
77 $has_settled_items = false;
79 while ($myrow = db_fetch($trans_items))
81 if ($myrow["settled"] == 1)
83 start_row("class='settledbg'");
84 $has_settled_items = true;
88 alt_table_row_color($k);
91 label_cell(systypes::name($myrow["type"]));
92 label_cell(get_trans_view_str($myrow["type"], $myrow["trans_no"]));
93 label_cell($myrow["reference"]);
94 label_cell(sql2date($myrow["tran_date"]));
96 if (!isset($_POST['supplier_id']))
98 label_cell($myrow["supp_name"]);
99 label_cell($myrow["curr_code"]);
101 amount_cell(-$myrow["Total"]);
102 amount_cell(-$myrow["Total"]-$myrow["alloc"]);
103 label_cell("<a href='$path_to_root/purchasing/allocations/supplier_allocate.php?trans_no=" . $myrow["trans_no"] . "&trans_type=" . $myrow["type"] . "'>" . _("Allocate") . "</a>");
109 if ($has_settled_items)
110 display_note(_("Marked items are settled."), 0, 1, "class='settledfg'");
112 if (db_num_rows($trans_items) == 0)
113 display_note(_("There are no allocations to be done."), 1, 2);
118 //--------------------------------------------------------------------------------
120 if (get_post('_ShowSettled_update')) {
121 $Ajax->activate('alloc_tbl');
123 display_allocatable_transactions();
125 //--------------------------------------------------------------------------------