X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fsupp_trans_class.inc;h=107890df0692debc201f6da032e2a596cfd614e9;hb=2917915beba9540193b520f1de59de9e6a33be56;hp=6bffc18570f9b2d9c72392a8c411ef65ffd27036;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git diff --git a/purchasing/includes/supp_trans_class.inc b/purchasing/includes/supp_trans_class.inc index 6bffc185..107890df 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 */ @@ -8,125 +17,228 @@ include_once($path_to_root . "/taxes/tax_calc.inc"); class supp_trans { - 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 $supplier_name; - var $terms_description; var $terms; + var $ex_rate; var $tax_description; var $tax_group_id; + var $tax_included; - var $is_invoice; + var $trans_type; // invoice or credit + var $trans_no; 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 + + var $dimension, + $dimension2; - function supp_trans() + 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, $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); + + $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($tax_group_id=null, $shipping_cost=0, $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); - + + // 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); - + $tax_group_id = $this->tax_group_id; + $taxes = get_tax_for_items($this->trans_type, $items, $prices, $shipping_cost, $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 now 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($tax_group_id=null) { $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; - + 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)), 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; + } + + function split_line_values() + { + // split nominal line values + foreach($this->grn_items as $line) + $line->split_item_value($this); + + // 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_mount[0] is valid + { + $diff = $tax['Override'] - $tax['Value']; + $this->grn_items[$id]->gl_amounts[0]['Value'] += $diff; + if ($this->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 @@ -144,13 +256,15 @@ all the info to do the necessary entries without looking up ie additional querie 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; - 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; @@ -162,23 +276,42 @@ all the info to do the necessary entries without looking up ie additional querie $this->this_quantity_inv = $this_quantity_inv; $this->order_price =$order_price; $this->chg_price = $chg_price; - $this->Complete = $Complete; $this->std_cost_unit = $std_cost_unit; $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($tax_group_id, $tax_group=null) + + function full_charge_price($tax_group_id, $trans_type=ST_PURCHORDER) { - return get_full_price_for_item($this->item_code, - $this->chg_price, $tax_group_id, 0, $tax_group); + return get_full_price_for_item($trans_type, $this->item_code, + $this->chg_price, $tax_group_id, $this->tax_included); } - - function taxfree_charge_price($tax_group_id, $tax_group=null) + + function taxfree_charge_price($tax_group_id, $trans_type=ST_PURCHORDER) + { + return get_tax_free_price_for_item($trans_type, $this->item_code, $this->chg_price, + $tax_group_id, $this->tax_included); + } + + function taxfree_value($tax_group_id, $trans_type=ST_PURCHORDER) { -// 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, 0, $tax_group); + return get_tax_free_price_for_item($trans_type, $this->item_code, $this->this_quantity_inv * $this->chg_price, + $tax_group_id, $this->tax_included, $tax_group); + } + + /* + Splits item value to parts posted to GL. + */ + function split_item_value($cart) + { + + $vat_factor = 1; + + return $this->gl_amounts = split_item_price($this->item_code, $this->chg_price*$this->this_quantity_inv, $cart->tax_group_id, $cart->tax_included, + ST_SUPPINVOICE, $vat_factor, $cart->tran_date); } } @@ -186,7 +319,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; @@ -194,11 +326,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; @@ -208,4 +337,3 @@ class gl_codes } } -?>