Call hooks on split.
[order_line_extra.git] / hooks.php
index 8a177c4128d06eac7c9af95ccf0fe092d20c796a..1df1ef5cc4387d555dc9908bdd4f0ec53794a7b9 100644 (file)
--- a/hooks.php
+++ b/hooks.php
@@ -45,8 +45,10 @@ class hooks_order_line_extra extends hooks {
 
         $updates = array(
                                                'alter_sales_order_details.sql' => array('sales_order_details','required_date'),
+                                               'alter_sales_order_details_2.sql' => array('sales_order_details','expiry_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)
@@ -64,5 +66,49 @@ 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);
+               }
+
+               function db_postwrite($cart, $trans_type) {
+                       if(is_a($cart, "Cart")) {
+
+                       // It's a cart. Find all the stock_id and update the cache table 
+                       foreach($cart->line_items as $line_no => $item) {
+                               $stock_id = $item->stock_id;
+                               update_queue_quantity_for_item($stock_id);
+                               update_qoh_for_item($stock_id);
+                       }
+                       }
+
+                       // update null fields of new entered orders.
+                       //
+               $types = array(ST_SALESORDER, 'order_xtra');
+               if(in_array($trans_type, $types)) update_order_detail_defaults();
+       
+               }
+
+
+               function db_prevoid($cart, $trans_type) {
+               // Simple version, rebuild everything
+               $types = array(ST_CUSTCREDIT, ST_CUSTDELIVERY, ST_INVADJUST, ST_PURCHORDER, ST_WORKORDER, ST_MANUISSUE,
+                               ST_SALESORDER, ST_SALESQUOTE, ST_MANURECEIVE);
+               if(in_array($trans_type, $types)) {
+                       update_queue_quantities();
+                       update_qoh_for_item();
+               }
+               }
 }
 ?>