+function update_qoh_for_item($stock_id=null) {
+ clear_qoh_for_item($stock_id);
+ $sql = "INSERT INTO ".TB_PREF."denorm_qoh(stock_id, loc_code, quantity)
+ SELECT
+ stock_id
+ ,loc_code
+ ,sum(qty) as quantity
+ FROM ".TB_PREF."stock_moves
+ WHERE tran_date <= NOW()";
+ if(isset($stock_id)) $sql.= " AND stock_id = '$stock_id'";
+ $sql .= " GROUP BY stock_id, loc_code";
+
+
+ return db_query($sql, $sql);
+
+}
+function clear_qoh_for_item($stock_id=null) {
+ if(isset($stock_id)) {
+ $sql = "DELETE FROM ".TB_PREF."denorm_qoh
+ WHERE stock_id = \"$stock_id\"
+";
+ }
+ else {
+ $sql = "TRUNCATE TABLE ".TB_PREF."denorm_qoh";
+ }
+
+ return db_query($sql, 'Error when trying to clean ".TB_PREF."denorm_qoh');
+}
+