Incorrect Journal Balance (sales invoice) when many decimals in tax and price.
[fa-stable.git] / inventory / reorder_level.php
index 980d04cfb60ed09e393a45875b8a19c32e79e470..6dfba5f0bdff8f36594c829434c97ff4db0ebb9c 100644 (file)
@@ -1,43 +1,72 @@
 <?php
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+       Released under the terms of the GNU General Public License, GPL, 
+       as published by the Free Software Foundation, either version 3 
+       of the License, or (at your option) any later version.
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
+$page_security = 'SA_REORDER';
+
+if (@$_GET['page_level'] == 1)
+       $path_to_root = "../..";
+else   
+       $path_to_root = "..";
 
-$page_security = 4;
-$path_to_root="..";
 include_once($path_to_root . "/includes/session.inc");
-
-page(_("Reorder Levels"));
-
 include_once($path_to_root . "/includes/date_functions.inc");
 include_once($path_to_root . "/includes/ui.inc");
 include_once($path_to_root . "/includes/data_checks.inc");
-
 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
 
+$js = "";
+if ($SysPrefs->use_popup_windows && $SysPrefs->use_popup_search)
+       $js .= get_js_open_window(900, 500);
+page(_($help_context = "Reorder Levels"), false, false, "", $js);
+
 check_db_has_costable_items(_("There are no inventory items defined in the system (Purchased or manufactured items)."));
 
 //------------------------------------------------------------------------------------
 
 if (isset($_GET['stock_id']))
-{
        $_POST['stock_id'] = $_GET['stock_id'];
-}
 
+if (list_updated('stock_id')) 
+{
+       $Ajax->activate('show_heading');
+       $Ajax->activate('reorders');
+}
 //------------------------------------------------------------------------------------
 
-start_form(false, true);
+$action = $_SERVER['PHP_SELF'];
+if ($page_nested)
+       $action .= "?stock_id=".get_post('stock_id');
+start_form(false, false, $action);
 
 if (!isset($_POST['stock_id']))
        $_POST['stock_id'] = get_global_stock_item();
 
-echo "<center>" . _("Item:"). "&nbsp;";
-stock_costable_items_list('stock_id', $_POST['stock_id'], false, true);
-
-echo "<hr>";
+if (!$page_nested)
+{
+       echo "<center>" . _("Item:"). "&nbsp;";
+       echo stock_costable_items_list('stock_id', $_POST['stock_id'], false, true);
 
+       echo "<hr></center>";
+}
+else
+       br(2);
+div_start('show_heading');
 stock_item_heading($_POST['stock_id']);
+br();
+div_end();
 
 set_global_stock_item($_POST['stock_id']);
 
-start_table("$table_style width=30%");
+div_start('reorders');
+start_table(TABLESTYLE, "width='30%'");
 
 $th = array(_("Location"), _("Quantity On Hand"), _("Re-Order Level"));
 table_header($th);
@@ -47,23 +76,27 @@ $k=0; //row colour counter
 
 $result = get_loc_details($_POST['stock_id']);
 
-while ($myrow = db_fetch($result)) 
+while ($myrow = db_fetch($result))
 {
 
        alt_table_row_color($k);
 
-       if (isset($_POST['UpdateData']) && is_numeric($_POST[$myrow["loc_code"]]))
+       if (isset($_POST['UpdateData']) && check_num($myrow["loc_code"]))
        {
 
-               $myrow["reorder_level"] = $_POST[$myrow["loc_code"]];
-               set_reorder_level($_POST['stock_id'], $myrow["loc_code"], $_POST[$myrow["loc_code"]]);
+               $myrow["reorder_level"] = input_num($myrow["loc_code"]);
+               set_reorder_level($_POST['stock_id'], $myrow["loc_code"], input_num($myrow["loc_code"]));
+               display_notification(_("Reorder levels has been updated."));
        }
 
        $qoh = get_qoh_on_date($_POST['stock_id'], $myrow["loc_code"]);
 
        label_cell($myrow["location_name"]);
-       label_cell(number_format2($qoh,user_qty_dec()), "nowrap align='right'");
-       text_cells(null, $myrow["loc_code"], $myrow["reorder_level"], 10, 10);
+
+       $_POST[$myrow["loc_code"]] = qty_format($myrow["reorder_level"], $_POST['stock_id'], $dec);
+
+       qty_cell($qoh, false, $dec);
+       qty_cells(null, $myrow["loc_code"], null, null, null, $dec);
        end_row();
        $j++;
        If ($j == 12)
@@ -74,10 +107,8 @@ while ($myrow = db_fetch($result))
 }
 
 end_table(1);
-
-submit('UpdateData', _("Update"));
+div_end();
+submit_center('UpdateData', _("Update"), true, false, 'default');
 
 end_form();
 end_page();
-
-?>