<?php
/*
+--------------------------------------------------------------------+
- | CiviCRM version 4.4 |
+ | CiviCRM version 4.5 |
+--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2013 |
+ | Copyright CiviCRM LLC (c) 2004-2014 |
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
/**
*
* @package CRM
- * @copyright CiviCRM LLC (c) 2004-2013
+ * @copyright CiviCRM LLC (c) 2004-2014
* $Id$
*
*/
static function getLineTotal($entityId, $entityTable) {
$sqlLineItemTotal = "SELECT SUM(li.line_total)
FROM civicrm_line_item li
-INNER JOIN civicrm_participant_payment pp ON ( li.entity_id = pp.participant_id
-AND li.entity_table = '{$entityTable}'
-AND li.entity_id = {$entityId})";
+WHERE li.entity_table = '{$entityTable}'
+AND li.entity_id = {$entityId}
+";
$lineItemTotal = CRM_Core_DAO::singleValueQuery($sqlLineItemTotal);
return $lineItemTotal;
}
* @param $entityId int participant/contribution id
* @param $entity string participant/contribution.
*
+ * @param null $isQuick
+ * @param bool $isQtyZero
+ *
* @return array of line items
*/
static function getLineItems($entityId, $entity = 'participant', $isQuick = NULL , $isQtyZero = TRUE) {
li.participant_count,
li.price_field_value_id,
li.financial_type_id,
+ li.tax_amount,
pfv.description";
$fromClause = "
'financial_type_id' => $dao->financial_type_id,
'membership_type_id' => $dao->membership_type_id,
'membership_num_terms' => $dao->membership_num_terms,
+ 'tax_amount' => $dao->tax_amount,
);
+ $lineItems[$dao->id]['tax_rate'] = CRM_Price_BAO_LineItem::calculateTaxRate($lineItems[$dao->id]);
+ $lineItems[$dao->id]['subTotal'] = $lineItems[$dao->id]['qty'] * $lineItems[$dao->id]['unit_price'];
}
return $lineItems;
}
* @param int $entityId
* @param int $entityTable
*
+ * @return bool
* @access public
* @static
*/
/**
* Function to process price set and line items.
- * @param int $contributionId contribution id
+ *
+ * @param $entityId
* @param array $lineItem line item array
* @param object $contributionDetails
- * @param decimal $initAmount amount
* @param string $entityTable entity table
*
+ * @param bool $update
+ *
+ * @internal param int $contributionId contribution id
+ * @internal param \decimal $initAmount amount
* @access public
* @return void
* @static
}
}
}
+
+ /**
+ * Calculate tax rate in percentage
+ *
+ * @param $lineItemId an assoc array of lineItem
+ *
+ * @return tax rate
+ *
+ * @access public
+ * @static
+ */
+ public static function calculateTaxRate($lineItemId) {
+ if ($lineItemId['html_type'] == 'Text') {
+ $tax = (($lineItemId['line_total'] - ($lineItemId['unit_price'] * $lineItemId['qty'])))/($lineItemId['unit_price'] * $lineItemId['qty'])*100;
+ }
+ else {
+ $tax = (($lineItemId['line_total'] - $lineItemId['unit_price'])/$lineItemId['unit_price']) * 100;
+ }
+ return $tax;
+ }
}