Inventory Adjustment: negative adjustment should always use current average item...
authorJanusz Dobrowolski <janusz@frontaccounting.eu>
Fri, 28 Jun 2019 12:01:47 +0000 (14:01 +0200)
committerJanusz Dobrowolski <janusz@frontaccounting.eu>
Fri, 28 Jun 2019 12:01:47 +0000 (14:01 +0200)
inventory/adjustments.php
inventory/includes/item_adjustments_ui.inc
js/inserts.js

index ba5dcf49fbcdbe83e1d9ac1f301b07222d78be4a..fe72039205790b54bec9e627f23c44a552407daa 100644 (file)
@@ -210,13 +210,16 @@ $id = find_submit('Delete');
 if ($id != -1)
        handle_delete_item($id);
 
-if (isset($_POST['AddItem']) && check_item_data())
+if (isset($_POST['AddItem']) && check_item_data()) {
        handle_new_item();
-
-if (isset($_POST['UpdateItem']) && check_item_data())
+       unset($_POST['selected_id']);
+}
+if (isset($_POST['UpdateItem']) && check_item_data()) {
        handle_update_item();
-
+       unset($_POST['selected_id']);
+}
 if (isset($_POST['CancelItemChanges'])) {
+       unset($_POST['selected_id']);
        line_start_focus();
 }
 //-----------------------------------------------------------------------------------------------
index 66223fb4a4d20b482b4d219db5d3799908666294..1e15ff950028494475aeda1843fc2a6a21c518e4 100644 (file)
@@ -60,14 +60,13 @@ function display_adjustment_items($title, &$order)
                _("Unit"), _("Unit Cost"), _("Total"), "");
                if ( count($order->line_items)) $th[] = '';
        }
-       if ( count($order->line_items)) $th[] = '';
 
        table_header($th);
        $total = 0;
        $k = 0;  //row colour counter
 
        $low_stock = $order->check_qoh($_POST['StockLocation'], $_POST['AdjDate']);
-       $id = find_submit('Edit');
+       $id = get_post('selected_id', find_submit('Edit'));
        foreach ($order->line_items as $line_no=>$stock_item)
        {
 
@@ -97,9 +96,16 @@ function display_adjustment_items($title, &$order)
                                amount_cell($stock_item->standard_cost * $stock_item->quantity);
 
                if (!$order->fixed_asset) {
-                       edit_button_cell("Edit$line_no", _("Edit"),     _('Edit document line'));
+                       if ($id == -1)
+                               edit_button_cell("Edit$line_no", _("Edit"),     _('Edit document line'));
+                       else
+                               label_cell('');
                }
-                       delete_button_cell("Delete$line_no", _("Delete"), _('Remove line from document'));
+               if ($id == -1)
+                               delete_button_cell("Delete$line_no", _("Delete"), _('Remove line from document'));
+               else
+                       label_cell('');
+                       
                        end_row();
                }
                else
@@ -114,6 +120,9 @@ function display_adjustment_items($title, &$order)
        label_row(_("Total"), number_format2($total,user_price_dec()), "align=right colspan=5", "align=right", 2);
 
     end_table();
+
+       if ($id != -1)
+           hidden('selected_id', $id);
        if ($low_stock)
                display_note(_("Marked items have insufficient quantities in stock as on day of adjustment."), 0, 1, "class='stockmankofg'");
        div_end();
@@ -127,19 +136,20 @@ function adjustment_edit_item_controls(&$order, $line_no=-1)
        start_row();
 
        $dec2 = 0;
-       $id = find_submit('Edit');
-       if ($line_no != -1 && $line_no == $id)
-       {
-               $_POST['stock_id'] = $order->line_items[$id]->stock_id;
-               $_POST['qty'] = qty_format($order->line_items[$id]->quantity, 
-                       $order->line_items[$id]->stock_id, $dec);
-               //$_POST['std_cost'] = price_format($order->line_items[$id]->standard_cost);
-               $_POST['std_cost'] = price_decimal_format($order->line_items[$id]->standard_cost, $dec2);
-               $_POST['units'] = $order->line_items[$id]->units;
 
+       if ($line_no != -1)
+       {
+               if (find_submit('Edit') != -1) {
+                       $_POST['stock_id'] = $order->line_items[$line_no]->stock_id;
+                       $_POST['qty'] = qty_format($order->line_items[$line_no]->quantity, 
+                               $order->line_items[$line_no]->stock_id, $dec);
+               //$_POST['std_cost'] = price_format($order->line_items[$line_no]->standard_cost);
+                       $_POST['std_cost'] = price_decimal_format($order->line_items[$line_no]->standard_cost, $dec2);
+               }
+               $_POST['units'] = $order->line_items[$line_no]->units;
                hidden('stock_id', $_POST['stock_id']);
                label_cell($_POST['stock_id']);
-               label_cell($order->line_items[$id]->item_description, 'nowrap');
+               label_cell($order->line_items[$line_no]->item_description, 'nowrap');
            $Ajax->activate('items_table');
        }
        else
@@ -150,49 +160,53 @@ function adjustment_edit_item_controls(&$order, $line_no=-1)
                        stock_costable_items_list_cells(null, 'stock_id', null, false, true);
 
                if (list_updated('stock_id')) {
-                           $Ajax->activate('units');
-                           $Ajax->activate('qty');
-                           $Ajax->activate('std_cost');
-                           $Ajax->activate('std_cost_view');
-                           $Ajax->activate('initial_price');
+                       $Ajax->activate('items_table');
                }
 
-       $item_info = get_item_edit_info($_POST['stock_id']);
+       }
+
+       $item_info = get_item_edit_info(get_post('stock_id'));
+       if ($item_info) {
                $dec = $item_info['decimals'];
-               $_POST['qty'] = number_format2(0, $dec);
                $_POST['std_cost'] = price_decimal_format($item_info["material_cost"], $dec2);
                $_POST['units'] = $item_info["units"];
-       }
-
+       } else
+               $dec = 0;
        if ($order->fixed_asset) {
                hidden('qty', -1);
                qty_cell(1, false, 0);
        } else
-               qty_cells(null, 'qty', $_POST['qty'], null, null, $dec);
+               label_cell( text_input('qty', get_post('qty', '0'), 15, 15, '',  'class="amount active" dec='.$dec), "nowrap align=right");
 
-       label_cell($_POST['units'], '', 'units');
+       label_cell(get_post('units'), '', 'units');
 
        if ($order->fixed_asset) {
-               /* TODO: check if this is a correct way of creating a fixed item
-                       that still has to be submitted in the form */ 
                hidden('std_cost');
                label_cell($_POST['std_cost'], "nowrap align=right ", 'std_cost_view');
                $price = get_purchase_value($_POST['stock_id']);
                amount_cell($price, false, '', 'initial_price');
        } else {
-               //amount_cells(null, 'std_cost', $_POST['std_cost']);
-               amount_cells(null, 'std_cost', null, null, null, $dec2);
+               if (get_post('_qty_changed')) {
+                       $Ajax->activate('items_table');
+                       set_focus(input_num('qty') >= 0 ? 'std_cost' : 'AddItem');
+               }
+               if (input_num('qty') >= 0)
+                   amount_cells(null, 'std_cost', null, null, null, $dec);
+               else {
+                   hidden('std_cost');
+                       label_cell($_POST['std_cost'], "nowrap align=right");
+               }
                label_cell("&nbsp;");
        }
 
-       if ($id != -1)
+       if ($line_no != -1)
        {
                button_cell('UpdateItem', _("Update"),
                                _('Confirm changes'), ICON_UPDATE);
                button_cell('CancelItemChanges', _("Cancel"),
                                _('Cancel changes'), ICON_CANCEL);
                hidden('LineNo', $line_no);
-               set_focus('qty');
+               set_focus('qty');
        }
        else
        {
index 773fc8f4f7f1b8b8a37c82e20bbe1938cef19602..40337e7a94a68e7bc2df0c3fa0bfc02e36c289a2 100644 (file)
@@ -346,11 +346,18 @@ var inserts = {
                                return false;
                        }
        },
-    '.amount': function(e) {
-               if(e.onblur==undefined) {
+       '.amount': function(e) {
+               if (e.onblur == undefined) {
+                 e.setAttribute('_last_val', e.value);
                  e.onblur = function() {
                        var dec = this.getAttribute("dec");
-                       price_format(this.name, get_amount(this.name), dec);
+                       var val = this.getAttribute('_last_val');
+                       if (val != get_amount(this.name)) {
+                               this.setAttribute('_last_val', get_amount(this.name));
+                               price_format(this.name, get_amount(this.name), dec);
+                               if (e.className.match(/\bactive\b/))
+                                       JsHttpRequest.request('_'+this.name+'_changed', this.form);
+                       }
                  };
                }
        },