function _buildListArray(&$lists, $state)
{
$db = JFactory::getDbo();
// Build plans dropdown
$options = array();
$options[] = JHtml::_('select.option', 0, JText::_('OSM_PLAN'), 'id', 'title');
$sql = 'SELECT id, title FROM #__osmembership_plans WHERE published=1 ORDER BY ordering ';
$db->setQuery($sql);
$options = array_merge($options, $db->loadObjectList());
$lists['plan_id'] = JHtml::_('select.genericlist', $options, 'plan_id', ' class="inputbox" onchange="submit();"', 'id', 'title', $state->plan_id);
// Build countries dropdown
$options = array();
$options[] = JHtml::_('select.option', 0, JText::_('OSM_SELECT_COUNTRY'));
$sql = 'SELECT `name` AS value, `name` AS text FROM `#__osmembership_countries` WHERE `published`=1';
$db->setQuery($sql);
$options = array_merge($options, $db->loadObjectList());
$lists['country'] = JHtml::_('select.genericlist', $options, 'country', ' class="inputbox" onchange="submit();" ', 'value', 'text', $state->country);
$defaultCountry = OSMembershipHelper::getConfigValue('default_country');
$countryCode = OSmembershipHelper::getCountryCode($defaultCountry);
if (OSMembershipHelperEuvat::isEUCountry($countryCode)) {
$this->showVies = true;
$options = array();
$options[] = JHtml::_('select.option', -1, JText::_('OSM_VIES'));
$options[] = JHtml::_('select.option', 0, JText::_('OSM_NO'));
$options[] = JHtml::_('select.option', 1, JText::_('OSM_YES'));
$lists['vies'] = JHtml::_('select.genericlist', $options, 'vies', ' class="inputbox" onchange="submit();" ', 'value', 'text', $state->vies);
} else {
$this->showVies = false;
}
}
function _buildListArray(&$lists, $item)
{
$db = JFactory::getDbo();
$sql = 'SELECT id, title FROM #__osmembership_plans WHERE published = 1 ORDER BY ordering ';
$db->setQuery($sql);
$options = array();
$options[] = JHtml::_('select.option', 0, JText::_('OSM_ALL_PLANS'), 'id', 'title');
$options = array_merge($options, $db->loadObjectList());
$lists['plan_id'] = JHtml::_('select.genericlist', $options, 'plan_id', ' class="inputbox" ', 'id', 'title', $item->plan_id);
$options = array();
$options[] = JHtml::_('select.option', '', JText::_('OSM_ALL_COUNTRIES'));
$sql = 'SELECT `name` AS value, `name` AS text FROM `#__osmembership_countries` WHERE `published`=1';
$db->setQuery($sql);
$options = array_merge($options, $db->loadObjectList());
$lists['country'] = JHtml::_('select.genericlist', $options, 'country', ' class="inputbox" ', 'value', 'text', $item->country, 'country');
$defaultCountry = OSMembershipHelper::getConfigValue('default_country');
$countryCode = OSMembershipHelper::getCountryCode($defaultCountry);
if (OSMembershipHelperEuvat::isEUCountry($countryCode)) {
$lists['vies'] = JHtml::_('select.booleanlist', 'vies', ' class="inputbox" ', $item->vies);
}
return true;
}
/**
* Build EU tax rules
*/
public function build_eu_tax_rules()
{
$db = JFactory::getDbo();
$db->truncateTable('#__osmembership_taxes');
$defaultCountry = OSmembershipHelper::getConfigValue('default_country');
$defaultCountryCode = OSMembershipHelper::getCountryCode($defaultCountry);
// Without VAT number, use local tax rate
foreach (OSMembershipHelperEuvat::$europeanUnionVATInformation as $countryCode => $vatInfo) {
$countryName = $db->quote($vatInfo[0]);
$countryTaxRate = OSMembershipHelperEuvat::getEUCountryTaxRate($countryCode);
$sql = "INSERT INTO #__osmembership_taxes(plan_id, country, rate, vies, published) VALUES(0, {$countryName}, {$countryTaxRate}, 0, 1)";
$db->setQuery($sql);
$db->execute();
if ($countryCode == $defaultCountryCode) {
$localTaxRate = OSMembershipHelperEuvat::getEUCountryTaxRate($defaultCountryCode);
$sql = "INSERT INTO #__osmembership_taxes(plan_id, country, rate, vies, published) VALUES(0, {$countryName}, {$localTaxRate}, 1, 1)";
$db->setQuery($sql);
$db->execute();
}
}
$this->setRedirect('index.php?option=com_osmembership&view=taxes', JText::_('EU Tax Rules were successfully created'));
}
/**
* Calculate subscription fees based on input parameter
*
* @param JTable $rowPlan the object which contains information about the plan
* @param RADForm $form The form object which is used to calculate extra fee
* @param array $data The post data
* @param Object $config
* @param string $paymentMethod
*
* @return array
*/
public static function calculateSubscriptionFee($rowPlan, $form, $data, $config, $paymentMethod = null)
{
$db = JFactory::getDbo();
$fees = array();
$feeAmount = $form->calculateFee();
$trialAmount = $rowPlan->trial_amount + $feeAmount;
$trialDiscountAmount = 0;
$trialTaxAmount = 0;
$regularAmount = $rowPlan->price + $feeAmount;
$regularDiscountAmount = 0;
$regularTaxAmount = 0;
$discountAmount = 0;
$taxAmount = 0;
$action = $data['act'];
if ($action == 'renew') {
$renewOptionId = (int) $data['renew_option_id'];
if ($renewOptionId == OSM_DEFAULT_RENEW_OPTION_ID) {
$amount = $rowPlan->price;
} else {
$sql = 'SELECT price FROM #__osmembership_renewrates WHERE id=' . (int) $data['renew_option_id'];
$db->setQuery($sql);
$amount = $db->loadResult();
}
} elseif ($action == 'upgrade') {
$sql = 'SELECT price FROM #__osmembership_upgraderules WHERE id=' . (int) $data['upgrade_option_id'];
$db->setQuery($sql);
$amount = $db->loadResult();
} else {
if ($rowPlan->recurring_subscription && $rowPlan->trial_duration) {
$amount = $rowPlan->trial_amount;
} else {
$amount = $rowPlan->price;
}
}
$amount += $feeAmount;
$couponCode = isset($data['coupon_code']) ? $data['coupon_code'] : '';
if ($couponCode) {
$planId = $rowPlan->id;
$nullDate = $db->getNullDate();
$query = $db->getQuery(true);
$query->select('*')->from('#__osmembership_coupons')->where('published=1')->where('code="' . $couponCode . '"')->where('(valid_from="' . $nullDate . '" OR DATE(valid_from) <= CURDATE())')->where('(valid_to="' . $nullDate . '" OR DATE(valid_to) >= CURDATE())')->where('(times = 0 OR times > used)')->where('(plan_id=0 OR plan_id=' . $planId . ')');
$db->setQuery($query);
$coupon = $db->loadObject();
if ($coupon) {
$couponValid = 1;
if ($coupon->coupon_type == 0) {
$discountAmount = $amount * $coupon->discount / 100;
$trialDiscountAmount = $trialAmount * $coupon->discount / 100;
$regularDiscountAmount = $regularAmount * $coupon->discount / 100;
} else {
$discountAmount = min($coupon->discount, $amount);
$trialDiscountAmount = min($coupon->discount, $trialAmount);
$regularDiscountAmount = min($coupon->discount, $regularAmount);
}
$discountAmount = round($discountAmount, 2);
$trialDiscountAmount = round($trialDiscountAmount, 2);
$regularDiscountAmount = round($regularDiscountAmount, 2);
} else {
$couponValid = 0;
}
} else {
$couponValid = 1;
}
$country = isset($data['country']) ? $data['country'] : $config->default_country;
$countryCode = self::getCountryCode($country);
// Calculate tax
if (!empty($config->eu_vat_number_field) && isset($data[$config->eu_vat_number_field])) {
$vatNumber = $data[$config->eu_vat_number_field];
if ($vatNumber) {
// If users doesn't enter the country code into the VAT Number, append the code
$firstTwoCharacters = substr($vatNumber, 0, 2);
if (strtoupper($firstTwoCharacters) != $countryCode) {
$vatNumber = $countryCode . $vatNumber;
}
}
} else {
$vatNumber = '';
}
$vatNumberValid = 1;
if ($vatNumber) {
$valid = OSMembershipHelperEuvat::validateEUVATNumber($vatNumber);
if ($valid) {
$taxRate = self::calculateTaxRate($rowPlan->id, $country, 1);
} else {
$vatNumberValid = 0;
$taxRate = self::calculateTaxRate($rowPlan->id, $country, 0);
}
} else {
$taxRate = self::calculateTaxRate($rowPlan->id, $country, 0);
}
if ($taxRate > 0) {
$taxAmount = round(($amount - $discountAmount) * $taxRate / 100, 2);
$trialTaxAmount = round(($trialAmount - $trialDiscountAmount) * $taxRate / 100, 2);
$regularTaxAmount = round(($regularAmount - $regularDiscountAmount) * $taxRate / 100, 2);
}
$trialGrossAmount = $trialAmount - $trialDiscountAmount + $trialTaxAmount;
$regularGrossAmount = $regularAmount - $regularDiscountAmount + $regularTaxAmount;
$grossAmount = $amount - $discountAmount + $taxAmount;
$paymentFeeAmount = 0;
$paymentFeePercent = 0;
if ($paymentMethod) {
$method = os_payments::loadPaymentMethod($paymentMethod);
$params = new JRegistry($method->params);
$paymentFeeAmount = (double) $params->get('payment_fee_amount');
$paymentFeePercent = (double) $params->get('payment_fee_percent');
}
if ($paymentFeeAmount > 0 || $paymentFeePercent > 0) {
$fees['trial_payment_processing_fee'] = round($paymentFeeAmount + $trialAmount * $paymentFeePercent / 100, 2);
$fees['regular_payment_processing_fee'] = round($paymentFeeAmount + $regularGrossAmount * $paymentFeePercent / 100, 2);
$fees['payment_processing_fee'] = round($paymentFeeAmount + $grossAmount * $paymentFeePercent / 100, 2);
$trialGrossAmount += $fees['trial_payment_processing_fee'];
$regularGrossAmount += $fees['regular_payment_processing_fee'];
$grossAmount += $fees['payment_processing_fee'];
} else {
$fees['trial_payment_processing_fee'] = 0;
$fees['regular_payment_processing_fee'] = 0;
$fees['payment_processing_fee'] = 0;
}
$fees['trial_amount'] = $trialAmount;
$fees['trial_discount_amount'] = $trialDiscountAmount;
$fees['trial_tax_amount'] = $trialTaxAmount;
$fees['trial_gross_amount'] = $trialGrossAmount;
$fees['regular_amount'] = $regularAmount;
$fees['regular_discount_amount'] = $regularDiscountAmount;
$fees['regular_tax_amount'] = $regularTaxAmount;
$fees['regular_gross_amount'] = $regularGrossAmount;
$fees['amount'] = $amount;
$fees['discount_amount'] = $discountAmount;
$fees['tax_amount'] = $taxAmount;
$fees['gross_amount'] = $grossAmount;
$fees['coupon_valid'] = $couponValid;
$fees['vatnumber_valid'] = $vatNumberValid;
$fees['country_code'] = $countryCode;
if (OSMembershipHelperEuvat::isEUCountry($countryCode)) {
$fees['show_vat_number_field'] = 1;
} else {
$fees['show_vat_number_field'] = 0;
}
return $fees;
}
