Changed purch_order.requisition_no field name to supp_reference, cleanups in purch_or...
[fa-stable.git] / purchasing / includes / po_class.inc
index fdb1c8d77d2d6de00bc0c92cfa1daca54d4e61b7..22a9bc65b454d48a3a370fe25387f7ae79b14f05 100644 (file)
@@ -16,33 +16,63 @@ class purch_order
 {
 
        var $trans_type; // order/grn/invoice (direct)
-       var $line_items; /*array of objects of class line_details using the product id as the pointer */
-       var $curr_code;
-       var $supp_ref;
-       var $delivery_address;
+       var $supplier_id;
        var $Comments;
+       var $tran_date;
+       var $reference;
+       var $supp_ref;
        var $Location;
-       var $supplier_id;
+       var $delivery_address;
+
+       var $prep_amount = 0; // prepayment required
+       var $alloc; // sum of payments allocated
+       var $tax_included; // type of prices
+
+       var $line_items;
+       var $curr_code;
        var $supplier_name;
-       var $orig_order_date;
+       var $due_date;
        var $order_no; /*Only used for modification of existing orders otherwise only established when order committed */
-       var $lines_on_order;
-       
-       var $reference;
-       
-       function purch_order()
+       var $lines_on_order = 0;
+       var $credit;
+       var $tax_group_id;
+       var $tax_group_array = null; // saves db queries
+       var $terms;
+       var $ex_rate;
+       var $cash_account;
+       var $dimension,
+               $dimension2;
+
+       var $tax_overrides = array();           // array of taxes manually inserted during sales invoice entry (direct invoice)
+
+       var $prepayments = array();
+
+       var $fixed_asset = false;
+       var $grn_id ;   // grn batch id used in edition only
+
+       function __construct()
        {
                /*Constructor function initialises a new purchase order object */
                $this->line_items = array();
                $this->lines_on_order = $this->order_no = $this->supplier_id = 0;
        }
-
-       function add_to_order($line_no, $stock_id, $qty, $item_descr, $price, $uom, $req_del_date, $qty_inv, $qty_recd)
+       
+       function set_supplier($supplier_id, $supplier_name, $curr_code, $tax_group_id, $tax_included)
+       {
+               $this->supplier_id = $supplier_id;
+               $this->supplier_name = $supplier_name;
+               $this->curr_code = $curr_code;
+               $this->tax_group_id = $tax_group_id;
+               $this->tax_included = $tax_included;
+               $this->tax_group_array = get_tax_group_items_as_array($tax_group_id);
+       }
+       
+       function add_to_order($line_no, $stock_id, $qty, $item_descr, $price, $uom, $req_del_date, $qty_inv, $qty_recd, $qty_ordered=0, $grn_item_id=0)
        {
-               if ($qty != 0 && isset($qty))
+               if (isset($qty) && $qty != 0)
                {
-                       $this->line_items[$line_no] = new line_details($line_no, $stock_id, $item_descr, $qty, $price, $uom, 
-                               $req_del_date, $qty_inv, $qty_recd);
+                       $this->line_items[$line_no] = new po_line_details($line_no, $stock_id, $item_descr, $qty, $price, $uom, 
+                               $req_del_date, $qty_inv, $qty_recd, $qty_ordered, $grn_item_id);
                        $this->lines_on_order++;
                        return 1;
                }
@@ -56,7 +86,7 @@ class purch_order
                $this->line_items[$line_no]->quantity = $qty;
                $this->line_items[$line_no]->price = $price;
                $this->line_items[$line_no]->req_del_date = $req_del_date;
-               $this->line_items[$line_no]->price = $price;
+               $this->line_items[$line_no]->item_description = $description;
        }
 
        function remove_from_order($line_no)
@@ -108,9 +138,66 @@ class purch_order
                }
                return 0;
        }
+       
+       //
+       //      Returns taxes for PO/GRN.
+       //      $receival=true in purchase receive context.
+       //
+       function get_taxes($shipping_cost=null, $receival=false)
+       {
+               $items = array();
+               $prices = array();
+               if($shipping_cost==null)
+                       $shipping_cost = 0;//$this->freight_cost;
+
+               foreach ($this->line_items as $ln_itm) {
+                       $items[] = $ln_itm->stock_id;
+                       $prices[] = round($ln_itm->price * $ln_itm->quantity,  user_price_dec());
+               }
+               $taxes = get_tax_for_items($items, $prices, $shipping_cost,
+                 $this->tax_group_id, $this->tax_included,  $this->tax_group_array);
+
+       // Adjustment for swiss franken, we always have 5 rappen = 1/20 franken
+           if ($this->curr_code == 'CHF') {
+                       $val = $taxes['1']['Value'];
+                       $val1 = (floatval((intval(round(($val*20),0)))/20));
+                       $taxes['1']['Value'] = $val1;
+               }
+               foreach($this->tax_overrides as $id => $value) // add values entered manually
+               {
+                       $taxes[$id]['Override'] = $value;
+               }
+               return $taxes;
+       }
+
+       /*
+               Returns order value including all taxes
+       */
+       function get_trans_total() {
+               
+               $total = 0;
+               $dec = user_price_dec();
+
+               foreach ($this->line_items as $ln_itm) {
+                       $items[] = $ln_itm->stock_id;
+                       $value = round($ln_itm->quantity * $ln_itm->price, $dec);
+                       $prices[] =$value;
+                       $total += $value;
+               }
+
+               if (!$this->tax_included ) {
+                       $taxes = get_tax_for_items($items, $prices, 0, $this->tax_group_id,
+                       $this->tax_included,  $this->tax_group_array);
+
+                       foreach($taxes as $tax)
+                               $total += round($tax['Value'], $dec);
+               }
+               return $total;
+       }
+
 } /* end of class defintion */
 
-class line_details 
+class po_line_details 
 {
 
        var $line_no;
@@ -118,20 +205,21 @@ class line_details
        var $grn_item_id;
        var $stock_id;
        var $item_description;
-       var $quantity;
        var $price;
        var $units;
        var $req_del_date;
-       var $qty_inv;
-       var $qty_received;
-       var $standard_cost;
-       var $receive_qty;
+
+       var $quantity;          // this document line quantity
+       var $qty_inv;   // quantity already invoiced against this line (all PIs)
+       var $qty_received;      // quantity already received against this line (all GRNs)
+       var $qty_ordered;       // quantity on order (not used on PO entry)
+
+       var $unit_cost;
        var $descr_editable;
-       
-       function line_details($line_no, $stock_item, $item_descr, $qty, $prc, $uom, $req_del_date, 
-               $qty_inv, $qty_recd, $grn_item_id=0)
-       {
 
+       function __construct($line_no, $stock_item, $item_descr, $qty, $prc, $uom, $req_del_date, 
+               $qty_inv, $qty_recd, $qty_ordered=0, $grn_item_id=0)
+       {
                /* Constructor function to add a new LineDetail object with passed params */
                $this->line_no = $line_no;
                $this->stock_id = $stock_item;
@@ -151,10 +239,18 @@ class line_details
                $this->units = $item_row["units"];
                $this->qty_received = $qty_recd;
                $this->qty_inv = $qty_inv;
-               $this->receive_qty = 0; /*initialise these last two only */
-               $this->standard_cost =0;
+               $this->unit_cost =0;
                $this->grn_item_id = $grn_item_id;
+               $this->qty_ordered = $qty_ordered;
+       }
+       
+       //
+       // GRN line tax free value.
+       //
+       function taxfree_charge_value($po)
+       {
+               return get_tax_free_price_for_item($this->stock_id, $this->quantity*$this->price,
+                 $po->tax_group_id, $po->tax_included, $po->tax_group_array);
        }
 }
 
-?>