Changed license type to GPLv3 in top of files

[fa-stable.git] / includes / db / inventory_db.inc

diff --git a/includes/db/inventory_db.inc b/includes/db/inventory_db.inc
index 84893a11047c4b8f6d4c32b9d6ffce2ecf8dc892..4fcc7a411d1e87a0434a9c3f8929c1fe9669df71 100644 (file)
--- a/includes/db/inventory_db.inc
+++ b/includes/db/inventory_db.inc
@@ -1,6 +1,15 @@
 <?php
-
-function get_qoh_on_date($stock_id, $location=null, $date_=null)
+/**********************************************************************
+    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>.
+***********************************************************************/
+function get_qoh_on_date($stock_id, $location=null, $date_=null, $exclude=0)
 {
        if ($date_ == null)
                $date_ = Today();
@@ -17,6 +26,18 @@ function get_qoh_on_date($stock_id, $location=null, $date_=null)
        $result = db_query($sql, "QOH calulcation failed");
 
        $myrow = db_fetch_row($result);
+       if ($exclude > 0)
+       {
+               $sql = "SELECT SUM(qty) FROM ".TB_PREF."stock_moves
+                       WHERE stock_id='$stock_id'
+                       AND type=$exclude
+                       AND tran_date = '$date'";
+
+               $result = db_query($sql, "QOH calulcation failed");
+               $myrow2 = db_fetch_row($result);
+               if ($myrow2 !== false)
+                       $myrow[0] -= $myrow2[0];
+       }
 
        return $myrow[0];
 }
@@ -25,8 +46,10 @@ function get_qoh_on_date($stock_id, $location=null, $date_=null)
 
 function get_item_edit_info($stock_id)
 {
-       $sql = "SELECT material_cost + labour_cost + overhead_cost AS standard_cost, units
-               FROM ".TB_PREF."stock_master WHERE stock_id='$stock_id'";
+       $sql = "SELECT material_cost + labour_cost + overhead_cost AS standard_cost, units, decimals
+               FROM ".TB_PREF."stock_master,".TB_PREF."item_units
+               WHERE stock_id='$stock_id'
+               AND ".TB_PREF."stock_master.units=".TB_PREF."item_units.abbr";
        $result = db_query($sql, "The standard cost cannot be retrieved");
 
        return db_fetch($result);
@@ -78,7 +101,7 @@ Function get_stock_gl_code($stock_id)
 // $price - in $person_id's currency
 
 function add_stock_move($type, $stock_id, $trans_no, $location,
-    $date_, $reference, $quantity, $std_cost, $person_id=null, $show_or_hide=1,
+    $date_, $reference, $quantity, $std_cost, $person_id=0, $show_or_hide=1,
     $price=0, $discount_percent=0, $error_msg="")
 {
        // do not add a stock move if it's a non-inventory item
@@ -90,7 +113,7 @@ function add_stock_move($type, $stock_id, $trans_no, $location,
        $sql = "INSERT INTO ".TB_PREF."stock_moves (stock_id, trans_no, type, loc_code,
                tran_date, person_id, reference, qty, standard_cost, visible, price,
                discount_percent) VALUES ('$stock_id', $trans_no, $type,
-               ".db_quote($location).", '$date', '$person_id', ".db_quote($reference).", $quantity, $std_cost,
+               ".db_escape($location).", '$date', '$person_id', ".db_escape($reference).", $quantity, $std_cost,
                $show_or_hide, $price, $discount_percent)";
 
        if ($error_msg == "")
@@ -101,6 +124,15 @@ function add_stock_move($type, $stock_id, $trans_no, $location,
        return db_insert_id();
 }
 
+function update_stock_move_pid($type, $stock_id, $from, $to, $pid, $cost)
+{
+       $from = date2sql($from);
+       $to = date2sql($to);
+       $sql = "UPDATE ".TB_PREF."stock_moves SET standard_cost=$cost WHERE type=$type
+               AND stock_id='$stock_id' AND tran_date>='$from' AND tran_date<='$to' AND person_id = $pid";
+       db_query($sql, "The stock movement standard_cost cannot be updated");
+}
+
 //--------------------------------------------------------------------------------------------------
 
 function get_stock_moves($type, $type_no, $visible=false)