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 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 $tax_included;
-
- var $trans_type; // invoice or credit
- 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($trans_type)
+ 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,
- $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, $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)
{
+ 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)
{
- 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();
}
-
- function get_taxes($tax_group_id=null, $shipping_cost=0, $gl_codes=true)
+
+ 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)),
- $prices[] =round( ($ln_itm->this_quantity_inv * $ln_itm->chg_price),
- 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);
-///////////////// Joe Hunt 2009.08.18
+ if (isset($this->tax_overrides))
+ foreach($this->tax_overrides as $id => $value) // add values entered manually
+ {
+ $taxes[$id]['Override'] = $value;
+ }
- if ($gl_codes)
+ // 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)
{
- foreach ($this->gl_codes as $gl_code)
+ $index = is_tax_account($gl_code->gl_code);
+ if ($index !== false)
{
- $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;
- }
+ }
//
// 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;
-
+
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($tax_group_id, $this->trans_type)),
user_price_dec());
foreach ($this->gl_codes as $gl_line)
- { //////// 2009-08-18 Joe Hunt
+ {
if (!is_tax_account($gl_line->gl_code))
$total += $gl_line->amount;
- }
+ }
return $total;
}
+ //
+ // Returns transaction total
+ //
function get_items_total()
{
$total = 0;
$total += round($ln_itm->this_quantity_inv * $ln_itm->chg_price, user_price_dec());
foreach ($this->gl_codes as $gl_line)
- { //////// 2010-10-10 Joe Hunt
+ {
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($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
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 $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,
+ 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->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->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($tax_group_id, $tax_group=null)
+
+// 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($tax_group_id, $trans_type=ST_PURCHORDER)
{
- return get_full_price_for_item($this->item_code,
- $this->chg_price, $tax_group_id, $this->tax_included, $tax_group);
+ return get_tax_free_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)
+
+ /*
+ Splits item value to parts posted to GL.
+ */
+ function split_item_value($cart)
{
-// 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, $this->tax_included, $tax_group);
+
+ $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);
}
}
class gl_codes
{
- var $Counter;
var $gl_code;
var $gl_act_name;
var $gl_dim;
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;
}
}
-?>