+ return true;
+}
+
+function update_order_detail_priority($detail_id, $priority) {
+ $sql = "UPDATE ".TB_PREF."sales_order_details SET priority='".$priority."' WHERE id = $detail_id ";
+ db_query($sql, "can't set priorti to order details $detail_id");
+}
+
+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);
+