Fix displayed required date

[order_line_extra.git] / hooks.php

diff --git a/hooks.php b/hooks.php
index fc1943f83324faa2c2faf86655fe816af9a570ab..019b6affb13cdeefce212cc0373f2968d6bf59c2 100644 (file)
--- a/hooks.php
+++ b/hooks.php
@@ -44,13 +44,15 @@ class hooks_order_line_extra extends hooks {
         global $db_connections;
 
         $updates = array(
-                                               'alter_sales_order_details.sql' => array('sales_order_details', 'required_date'),
+                                               'alter_sales_order_details.sql' => array('sales_order_details','required_date'),
                                                'create_denorm_order_details_queue.sql' => array('denorm_order_details_queue'),
-
+                                               'create_denorm_qoh.sql' => array('denorm_qoh'),
+                                               'create_order_summary_view.sql' => array('order_summary_view'),
         );
 
-        //return $this->update_databases($company, $updates, $check_only);
-        return $this->update_databases($company, $updates, $check_only) && update_queue_quantities();
+                               return $this->update_databases($company, $updates, $check_only)
+                                                               && update_queue_quantities()
+                                                               && update_qoh_for_item();;
     }
 
     function deactivate_extension($company, $check_only=true)
@@ -63,5 +65,20 @@ class hooks_order_line_extra extends hooks {
 
         return $this->update_databases($company, $updates, $check_only);
     }
+
+               function get_allowed_quantity($detail_id, $opts) {
+                       $location = array_shift($opts);
+                       $date = array_shift($opts);
+                       $qoh = array_shift($opts);
+
+                       $sql = "select quantity_before from ".TB_PREF."denorm_order_details_queue where id = $detail_id";
+                       $result = db_query($sql);
+                       $quantity_before = 0;
+                       if($row=db_fetch($result)) {
+                               $quantity_before = $row['quantity_before'];
+                               }
+
+                       return max($qoh - $quantity_before, 0);
+               }
 }
 ?>