X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fsupp_trans_class.inc;h=ddb55681e038a515dbe36a0353b840c2da6bc678;hb=1c01c6f19f3a1410814abb63e4143d080373aaba;hp=d6e06714b2f670bf0a8e203e1ba48a348182713b;hpb=d34add5e762a470a52fade37173b4491462ee22a;p=fa-stable.git diff --git a/purchasing/includes/supp_trans_class.inc b/purchasing/includes/supp_trans_class.inc index d6e06714..ddb55681 100644 --- a/purchasing/includes/supp_trans_class.inc +++ b/purchasing/includes/supp_trans_class.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ /* Definition of the Supplier Transactions class to hold all the information for an accounts payable invoice or credit note */ @@ -7,126 +16,223 @@ include_once($path_to_root . "/taxes/tax_calc.inc"); class supp_trans { + //db interface + var $trans_no; + var $trans_type; // invoice or credit + var $supplier_id; + var $reference; + var $supp_reference; + var $tran_date; + var $due_date; + var $ov_amount; + var $ov_discount; + var $ov_gst; + var $ex_rate; + + var $tax_included; - var $grn_items; /*array of objects of class GRNDetails using the GRN No as the pointer */ + var $grn_items; /*array of objects of class grn_item using the id as the pointer */ var $gl_codes; /*array of objects of class gl_codes using a counter as the pointer */ - var $supplier_id; + var $Comments; + //--- + var $supplier_name; - var $terms_description; var $terms; var $tax_description; var $tax_group_id; - - var $is_invoice; - var $Comments; - var $tran_date; - var $due_date; + var $src_docs = array(); // source invoice for this credit note (if any) - var $supp_reference; - var $reference; - var $ov_amount; - var $ov_discount; - var $ov_gst; - var $gl_codes_counter=0; + var $credit = 0; + var $currency; + var $tax_overrides = array(); // array of taxes manually inserted during sales invoice entry - function supp_trans() + var $dimension, + $dimension2; + + function __construct($trans_type, $trans_no=0) { + $this->trans_type = $trans_type; /*Constructor function initialises a new Supplier Transaction object */ - $this->grn_items = array(); - $this->gl_codes = array(); + $this->read($trans_type, $trans_no); + } + + function read($trans_type, $trans_no) + { + $this->trans_type = $trans_type; + $this->trans_no = $trans_no; + $this->grn_items = array(); + $this->gl_codes = array(); + if ($trans_no) { + read_supp_invoice($trans_no, $trans_type, $this); + + if ($trans_type == ST_SUPPCREDIT) + $this->src_docs = find_src_invoices($trans_no); + + read_supplier_details_to_trans($this, $this->supplier_id); + } } function add_grn_to_trans($grn_item_id, $po_detail_item, $item_code, $item_description, $qty_recd, $prev_quantity_inv, $this_quantity_inv, $order_price, $chg_price, - $Complete, $std_cost_unit, $gl_code) + $std_cost_unit=null, $gl_code='') { - $this->grn_items[$grn_item_id] = new grn_item($grn_item_id, $po_detail_item, + $line = new grn_item($grn_item_id, $po_detail_item, $item_code, $item_description, $qty_recd, $prev_quantity_inv, $this_quantity_inv, - $order_price, $chg_price, $Complete, $std_cost_unit, $gl_code); + $order_price, $chg_price, $std_cost_unit, $gl_code, $this->tax_included); + + $line->cart = $this; + $this->grn_items[$grn_item_id] = $line; + $this->src_docs = find_src_invoices($this); + + unset($this->tax_overrides); // cancel tax overrides after cart change return 1; } function add_gl_codes_to_trans($gl_code, $gl_act_name, $gl_dim, $gl_dim2, $amount, $memo_) { - $this->gl_codes[$this->gl_codes_counter] = new gl_codes($this->gl_codes_counter, - $gl_code, $gl_act_name, $gl_dim, $gl_dim2, $amount, $memo_); - $this->gl_codes_counter++; + $this->gl_codes[] = new gl_codes($gl_code, $gl_act_name, $gl_dim, $gl_dim2, $amount, $memo_); + unset($this->tax_overrides); // cancel tax overrides after cart change return 1; } - function remove_grn_from_trans(&$grn_item_id) + function remove_grn_from_trans($grn_item_id) { + unset($this->tax_overrides); // cancel tax overrides after cart change unset($this->grn_items[$grn_item_id]); } - function remove_gl_codes_from_trans(&$gl_code_counter) + function remove_gl_codes_from_trans($gl_code_counter) { - unset($this->gl_codes[$gl_code_counter]); + unset($this->tax_overrides); // cancel tax overrides after cart change + unset($this->gl_codes[$gl_code_counter]); } - + function is_valid_trans_to_post() { return (count($this->grn_items) > 0 || count($this->gl_codes) > 0 || ($this->ov_amount != 0) || ($this->ov_discount > 0)); } - + function clear_items() { unset($this->grn_items); unset($this->gl_codes); $this->ov_amount = $this->ov_discount = $this->supplier_id = 0; - + $this->grn_items = array(); - $this->gl_codes = array(); + $this->gl_codes = array(); } - - function get_taxes($tax_group_id=null, $shipping_cost=0) + + function get_taxes($gl_codes=true) { $items = array(); $prices = array(); - - if ($tax_group_id == null) - $tax_group_id = $this->tax_group_id; - - // preload the taxgroup ! - $tax_group = get_tax_group_items_as_array($tax_group_id); - + foreach ($this->grn_items as $ln_itm) { $items[] = $ln_itm->item_code; - $prices[] =round( ($ln_itm->this_quantity_inv * $ln_itm->taxfree_charge_price($tax_group_id, $tax_group)), - user_price_dec()); + $prices[] = round( $ln_itm->this_quantity_inv * $ln_itm->chg_price, user_price_dec()); } - - if ($tax_group_id == null) - $tax_group_id = $this->tax_group_id; - - $taxes = get_tax_for_items($items, $prices, $shipping_cost, $tax_group_id); - + + $taxes = get_tax_for_items($this->trans_type, $items, $prices, 0, $this->tax_group_id, + $this->tax_included); + + if (isset($this->tax_overrides)) + foreach($this->tax_overrides as $id => $value) // add values entered manually + { + $taxes[$id]['Override'] = $value; + } + + // Taxes included in gl_codes table have exact value, but count to overrides as well. + // Therefore when we want to know taxes only for items (gl_codes==false), + // we have to subtract gl_taxes from override values. + foreach ($this->gl_codes as $gl_code) + { + $index = is_tax_account($gl_code->gl_code); + if ($index !== false) + { + if ($gl_codes) + $taxes[$index]['Value'] += $gl_code->amount; + elseif (isset($this->tax_overrides)) + $taxes[$index]['Override'] -= $gl_code->amount; + } + } return $taxes; - } - - function get_total_charged($tax_group_id=null) + } + // + // Returns total invoice amount without taxes. + // + function get_total_taxfree() { $total = 0; - - // preload the taxgroup ! - if ($tax_group_id != null) - $tax_group = get_tax_group_items_as_array($tax_group_id); - else - $tax_group = null; - + foreach ($this->grn_items as $ln_itm) - $total += round(($ln_itm->this_quantity_inv * $ln_itm->taxfree_charge_price($tax_group_id, $tax_group)), + $total += round(($ln_itm->this_quantity_inv * $ln_itm->taxfree_charge_price()), user_price_dec()); foreach ($this->gl_codes as $gl_line) - $total += $gl_line->amount; - + { + if (!is_tax_account($gl_line->gl_code)) + $total += $gl_line->amount; + } return $total; } + // + // Returns transaction total + // + function get_items_total() + { + $total = 0; + + foreach ($this->grn_items as $ln_itm) + $total += round($ln_itm->this_quantity_inv * $ln_itm->chg_price, user_price_dec()); + + foreach ($this->gl_codes as $gl_line) + { + if (!is_tax_account($gl_line->gl_code) || $this->tax_included) + $total += $gl_line->amount; + } + return $total; + } + + /* + Split line value to cost and taxes. + Stores calculated amounts in $line->gl_amounts array. + */ + function split_line_values() + { + // split nominal line values + foreach($this->grn_items as $line) + $line->split_item_value(); + + // Exact tax values are currently entered as tax totals, so we need to move the differences back on line level. + // currently first item with given tax type will be fixed with the calculated difference + // FIXME: change UI moving tax edit to line level in line edit mode, then this workaround will be obsolete. + foreach($this->get_taxes() as $tax_id => $tax) + { + if ($tax['Value'] != 0 && isset($tax['Override']) && ($tax['Value'] != $tax['Override'])) + { + foreach($this->grn_items as $id => $line) + if ($line->gl_amounts[0]['tax_type_id'] == $tax_id) // assumed single tax rate on item, so always gl_amounts[0] is valid + { + $diff = $tax['Override'] - $tax['Value']; + $this->grn_items[$id]->gl_amounts[0]['Value'] += $diff; + if ($line->vat_category != VC_NONDEDUCT) + $this->grn_items[$id]->gl_amounts[0]['Deductible'] += $diff; + else + $this->grn_items[$id]->gl_amounts['Cost'] += $diff; + // when supplier uses net prices the price is exact, so don't fix net, still record exact VAT. + if ($this->tax_included) { + $this->grn_items[$id]->gl_amounts['Net'] -= $diff; + $this->grn_items[$id]->gl_amounts['Cost'] -= $diff; + } + break; + } + } + } + } } /* end of class defintion */ class grn_item @@ -136,21 +242,28 @@ class grn_item all the info to do the necessary entries without looking up ie additional queries of the database again */ var $id; + + var $gl_code; + var $po_detail_item; var $item_code; var $item_description; + var $this_quantity_inv; + var $chg_price; + var $qty_recd; var $prev_quantity_inv; - var $this_quantity_inv; var $order_price; - var $chg_price; - var $Complete; var $std_cost_unit; - var $gl_code; + var $tax_included; + var $gl_amounts; // splited line value (after call to split_line_value method + var $vat_category; + + var $cart; // line context - function grn_item ($id, $po_detail_item, $item_code, $item_description, $qty_recd, - $prev_quantity_inv, $this_quantity_inv, $order_price, $chg_price, $Complete, - $std_cost_unit, $gl_code) + function __construct($id, $po_detail_item, $item_code, $item_description, $qty_recd, + $prev_quantity_inv, $this_quantity_inv, $order_price, $chg_price, + $std_cost_unit, $gl_code, $tax_included) { $this->id = $id; @@ -160,23 +273,38 @@ all the info to do the necessary entries without looking up ie additional querie $this->qty_recd = $qty_recd; $this->prev_quantity_inv = $prev_quantity_inv; $this->this_quantity_inv = $this_quantity_inv; - $this->order_price =$order_price; + $this->order_price = $order_price; // price on order $this->chg_price = $chg_price; - $this->Complete = $Complete; - $this->std_cost_unit = $std_cost_unit; + $this->std_cost_unit = $std_cost_unit; // provisional cost for clearing $this->gl_code = $gl_code; + $this->tax_included = $tax_included; + + $opts = get_item($item_code); + $this->vat_category = $opts['vat_category']; } - - function full_charge_price() + +// function full_charge_price($tax_group_id, $trans_type=ST_PURCHORDER) +// { +// return get_full_price_for_item($trans_type, $this->item_code, +// $this->chg_price, $tax_group_id, $this->tax_included); +// } + + function taxfree_charge_price() { - return $this->chg_price; + $this->split_item_value(); + return $this->gl_amounts['Net']; } - - function taxfree_charge_price($tax_group_id, $tax_group=null) + + /* + Splits item value to parts posted to GL. + */ + function split_item_value() { - if ($tax_group_id==null) - return $this->chg_price; - return get_tax_free_price_for_item($this->item_code, $this->chg_price, $tax_group_id, $tax_group); + + $vat_factor = 1; + + return $this->gl_amounts = split_item_price($this->item_code, $this->chg_price*$this->this_quantity_inv, $this->cart->tax_group_id, $this->cart->tax_included, + $this->cart->trans_type, $vat_factor); } } @@ -184,7 +312,6 @@ all the info to do the necessary entries without looking up ie additional querie class gl_codes { - var $Counter; var $gl_code; var $gl_act_name; var $gl_dim; @@ -192,11 +319,8 @@ class gl_codes var $amount; var $memo_; - function gl_codes ($Counter, $gl_code, $gl_act_name, $gl_dim, $gl_dim2, $amount, $memo_) + function __construct($gl_code, $gl_act_name, $gl_dim, $gl_dim2, $amount, $memo_) { - - /* Constructor function to add a new gl_codes object with passed params */ - $this->Counter = $Counter; $this->gl_code = $gl_code; $this->gl_act_name = $gl_act_name; $this->gl_dim = $gl_dim; @@ -206,4 +330,3 @@ class gl_codes } } -?>