/**
*
* @return unknown_type
*/
function onAfterInitialise()
{
$success = null;
if (!$this->isInstalled()) {
return $success;
}
if (!$this->canRun()) {
return $success;
}
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$helper = new CitruscartHelperSubscription();
$helper->checkExpired();
$helper->checkExpiring();
return $success;
}
echo $item->order_id;
?>
</a>
</td>
<td style="text-align: left;">
<?php
if ($display_subnum && strlen($item->sub_number)) {
?>
<?php
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
?>
<b><?php
echo JText::_('COM_CITRUSCART_SUB_NUM');
?>
:</b> <?php
echo CitruscartHelperSubscription::displaySubNum($item->sub_number);
?>
<br />
<?php
}
?>
<?php
if (!empty($item->user_name)) {
?>
<?php
echo $item->user_name . ' [ ' . $item->user_id . ' ]';
?>
<br/>
• <?php
echo $item->email . ' [ ' . $item->user_username . ' ]';
?>
</tr>
<?php
if (Citruscart::getInstance()->get('display_subnum', 0)) {
?>
<tr>
<th style="width: 100px;">
<?php
echo JText::_('COM_CITRUSCART_SUB_NUM');
?>
</th>
<td colspan="2">
<?php
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
?>
<?php
echo CitruscartHelperSubscription::displaySubNum($userinfo->sub_number);
?>
</td>
</tr>
<?php
}
?>
<tr>
<th style="width: 100px;">
<?php
echo JText::_('COM_CITRUSCART_PRIMARY_SHIPPING_ADDRESS');
?>
</th>
<td>
<?php
Citruscart::load('CitruscartHelperUser', 'helpers.user');
/**
* Gets a product's files list
* formatted for display
*
* @param int $address_id
* @return string html
*/
function getFiles($view, $product_id)
{
$html = '';
// get the product's files
JModelLegacy::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_citruscart/models');
$model = JModelLegacy::getInstance('ProductFiles', 'CitruscartModel');
$model->setState('filter_product', $product_id);
$model->setState('filter_enabled', 1);
//$model->setState( 'filter_purchaserequired', 1 );
$items = $model->getList();
// get the user's active subscriptions to this product, if possible
$submodel = JModelLegacy::getInstance('Subscriptions', 'CitruscartModel');
$submodel->setState('filter_userid', JFactory::getUser()->id);
$submodel->setState('filter_productid', $product_id);
$subs = $submodel->getList();
if (!empty($items)) {
// reconcile the list of files to the date the sub's files were last checked
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$subhelper = new CitruscartHelperSubscription();
$subhelper->reconcileFiles($subs);
Citruscart::load('CitruscartHelperBase', 'helpers._base');
$helper = CitruscartHelperBase::getInstance('ProductDownload', 'CitruscartHelper');
$filtered_items = $helper->filterRestricted($items, JFactory::getUser()->id);
$view->setModel($model, true);
$product_file_data = new stdClass();
$product_file_data->downloadItems = $filtered_items[0];
$product_file_data->nondownloadItems = $filtered_items[1];
$product_file_data->product_id = $product_id;
$lyt = $view->getLayout();
$view->setLayout('product_files');
$view->product_file_data = $product_file_data;
ob_start();
echo $view->loadTemplate(null);
$html = ob_get_contents();
ob_end_clean();
$view->setLayout($lyt);
unset($view->product_file_data);
}
return $html;
}
public function getItem($pk = null, $refresh = false, $emptyState = true)
{
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
if ($item = parent::getItem($pk, $refresh, $emptyState)) {
$item->link = 'index.php?option=com_citruscart&view=subscriptions&task=edit&id=' . $item->subscription_id;
$item->link_view = 'index.php?option=com_citruscart&view=subscriptions&task=view&id=' . $item->subscription_id;
$item->history = CitruscartHelperSubscription::getHistory($item->subscription_id);
Citruscart::load('CitruscartQuery', 'library.query');
$q = new CitruscartQuery();
$q->select('order_hash');
$q->from('#__citruscart_orders');
$q->where('order_id = ' . $item->order_id);
$db = JFactory::getDbo();
$db->setQuery($q);
$item->order_hash = $db->loadResult();
}
JFactory::getApplication()->triggerEvent('onPrepare' . $this->getTable()->get('_suffix'), array(&$item));
return $item;
}
public function getList($refresh = false, $getEav = true, $options = array())
{
static $pa, $pao;
if (empty($pa)) {
$pa = array();
}
if (empty($pao)) {
$pao = array();
}
Citruscart::load("CitruscartHelperUser", 'helpers.user');
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$user_helper = CitruscartHelperBase::getInstance('User');
$product_helper = CitruscartHelperBase::getInstance('Product');
if (empty($this->_list)) {
JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_citruscart/tables');
$items = parent::getList($refresh);
// If no item in the list, return an array()
if (empty($items)) {
return array();
}
foreach ($items as $item) {
$filter_group = $user_helper->getUserGroup(JFactory::getUser()->id, $item->product_id);
// at this point, ->product_price holds the default price for the product,
// but the user may qualify for a discount based on volume or date, so let's get that price override
$item->product_price_override = $product_helper->getPrice($item->product_id, $item->product_qty, $filter_group, JFactory::getDate()->toSql());
//checking if we do price override
isset($item->product_price_override->override) ? $item->product_price_override = true : "";
if (!empty($item->product_price_override)) {
$item->product_price = isset($item->product_price_override->product_price) ? $item->product_price_override->product_price : "";
}
if ($item->product_recurs) {
$item->recurring_price = $item->product_price;
if ($item->subscription_prorated) {
$result = CitruscartHelperSubscription::calculateProRatedTrial($item->subscription_prorated_date, $item->subscription_prorated_term, $item->recurring_period_unit, $item->recurring_trial_price, $item->subscription_prorated_charge);
$item->product_price = $result['price'];
$item->recurring_trial_price = $result['price'];
$item->recurring_trial_period_interval = $result['interval'];
$item->recurring_trial_period_unit = $result['unit'];
$item->recurring_trial = $result['trial'];
} else {
if ($item->recurring_trial) {
$item->product_price = $item->recurring_trial_price;
}
}
}
$item->product_parameters = new DSCParameter($item->product_params);
$item->orderitem_attributes_price = '0.00000';
$item->orderitem_attributes_weight = '0.00000';
$attributes_names = array();
if (!empty($item->product_attributes)) {
$item->attributes = array();
// array of each selected attribute's object
$attibutes_array = explode(',', $item->product_attributes);
foreach ($attibutes_array as $attrib_id) {
if (empty($pao[$attrib_id])) {
// load the attrib's object
$pao[$attrib_id] = JTable::getInstance('ProductAttributeOptions', 'CitruscartTable');
$pao[$attrib_id]->load($attrib_id);
}
$table = $pao[$attrib_id];
// update the price
// + or -
if ($table->productattributeoption_prefix != '=') {
$item->product_price = $item->product_price + floatval("{$table->productattributeoption_prefix}" . "{$table->productattributeoption_price}");
// store the attribute's price impact
$item->orderitem_attributes_price = $item->orderitem_attributes_price + floatval("{$table->productattributeoption_prefix}" . "{$table->productattributeoption_price}");
//$item->product_price_override->override = true;
$item->product_price_override = true;
} else {
// assign the product attribute price as the product price
//then set the orderitem_attributes_price to 0.0000
$item->product_price = $table->productattributeoption_price;
//
// store the attribute's price impact
$item->orderitem_attributes_price = "0.00000";
$item->product_price_override->override = false;
}
// update the weight
// + or -
if ($table->productattributeoption_prefix_weight != '=') {
$item->product_weight = $item->product_weight + floatval("{$table->productattributeoption_prefix_weight}" . "{$table->productattributeoption_weight}");
// store the attribute's price impact
$item->orderitem_attributes_weight = $item->orderitem_attributes_weight + floatval("{$table->productattributeoption_prefix_weight}" . "{$table->productattributeoption_weight}");
} else {
// assign the product attribute price as the product price
//then set the orderitem_attributes_price to 0.0000
$item->product_weight = $table->productattributeoption_weight;
//
// store the attribute's price impact
$item->orderitem_attributes_weight = "0.00000";
}
// update product values based on the selected option
$m_values = DSCModel::getInstance('ProductAttributeOptionValues', 'CitruscartModel');
$m_values->setState('filter_option', $attrib_id);
$list_values = $m_values->getList();
if (count($list_values)) {
foreach ($list_values as $val) {
switch ($val->productattributeoptionvalue_field) {
case 'product_model':
case 'product_sku':
$field = $val->productattributeoptionvalue_field;
switch ($val->productattributeoptionvalue_operator) {
case 'prepend':
$item->{$field} = $val->productattributeoptionvalue_value . $item->{$field};
break;
case 'append':
$item->{$field} = $item->{$field} . $val->productattributeoptionvalue_value;
break;
case 'replace':
$item->{$field} = $val->productattributeoptionvalue_value;
break;
}
break;
}
}
}
$item->orderitem_attributes_price = number_format($item->orderitem_attributes_price, '5', '.', '');
$item->orderitem_attributes_weight = number_format($item->orderitem_attributes_weight, '5', '.', '');
// store a csv of the attrib names, built by Attribute name + Attribute option name
if (empty($pa[$table->productattribute_id])) {
$pa[$table->productattribute_id] = JTable::getInstance('ProductAttributes', 'CitruscartTable');
$pa[$table->productattribute_id]->load($table->productattribute_id);
}
$atable = $pa[$table->productattribute_id];
if (!empty($atable->productattribute_id)) {
$name = JText::_($atable->productattribute_name) . ': ' . JText::_($table->productattributeoption_name);
$attributes_names[] = $name;
} else {
$attributes_names[] = JText::_($table->productattributeoption_name);
}
}
// Generate Product Sku based upon attributes
$item->product_sku = CitruscartHelperProduct::getProductSKU($item, $attibutes_array);
// Could someone explain to me why this is necessary?
if ($item->orderitem_attributes_price >= 0) {
// formatted for storage in the DB
$item->orderitem_attributes_price = "+{$item->orderitem_attributes_price}";
}
}
$item->attributes_names = implode(', ', $attributes_names);
$this->prepareItem($item, 0, $refresh);
}
$this->_list = $items;
}
return $this->_list;
}
?>
:</td>
<td><?php
if (empty($row->product_id)) {
// doing a new product, so display a note
?>
<div class="note well">
<?php
echo JText::_('COM_CITRUSCART_CLICK_APPLY_TO_BE_ABLE_TO_ADD_ISSUES_TO_THE_PRODUCT');
?>
</div> <?php
} else {
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$next_issue = CitruscartHelperSubscription::getMarginalIssue($row->product_id);
$last_issue = CitruscartHelperSubscription::getMarginalIssue($row->product_id, 'DESC');
$num_issues = CitruscartHelperSubscription::getNumberIssues($row->product_id);
?>
[<?php
echo CitruscartUrl::popup("index.php?option=com_citruscart&view=products&task=setissues&id=" . $row->product_id . "&tmpl=component", JText::_('COM_CITRUSCART_SET_ISSUES'));
?>
]<br /> <?php
if (isset($next_issue)) {
echo '<b>' . JText::_('COM_CITRUSCART_NEXT_ISSUE_PUBLISHED') . ':</b> ' . JHTML::_('date', $next_issue->publishing_date, JText::_('DATE_FORMAT_LC4')) . '<br />';
}
if (isset($last_issue)) {
echo '<b>' . JText::_('COM_CITRUSCART_LAST_ISSUE_PUBLISHED') . ':</b> ' . JHTML::_('date', $last_issue->publishing_date, JText::_('DATE_FORMAT_LC4')) . '<br />';
}
echo '<b>' . JText::_('COM_CITRUSCART_ISSUES_LEFT') . ':</b> ' . $num_issues;
?>
<br /> <?php
}
/**
* Gets a product's files list
* formatted for display
*
* @param int $address_id
* @return string html
*/
function getFiles($product_id)
{
$html = '';
// get the product's files
JModelLegacy::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_citruscart/models');
$model = JModelLegacy::getInstance('ProductFiles', 'CitruscartModel');
$model->setState('filter_product', $product_id);
$model->setState('filter_enabled', 1);
//$model->setState( 'filter_purchaserequired', 1 );
$items = $model->getList();
// get the user's active subscriptions to this product, if possible
$submodel = JModelLegacy::getInstance('Subscriptions', 'CitruscartModel');
$submodel->setState('filter_userid', JFactory::getUser()->id);
$submodel->setState('filter_productid', $product_id);
$subs = $submodel->getList();
if (!empty($items)) {
// reconcile the list of files to the date the sub's files were last checked
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$subhelper = new CitruscartHelperSubscription();
$subhelper->reconcileFiles($subs);
Citruscart::load('CitruscartHelperBase', 'helpers._base');
$helper = CitruscartHelperBase::getInstance('ProductDownload', 'CitruscartHelper');
$filtered_items = $helper->filterRestricted($items, JFactory::getUser()->id);
$view = $this->getView('products', 'html');
$view->set('_controller', 'products');
$view->set('_view', 'products');
$view->set('_doTask', true);
$view->set('hidemenu', true);
$view->setModel($model, true);
$view->setLayout('product_files');
$view->set('downloadItems', $filtered_items[0]);
$view->set('nondownloadItems', $filtered_items[1]);
$view->set('product_id', $product_id);
ob_start();
$view->display();
$html = ob_get_contents();
ob_end_clean();
}
return $html;
}
/**
* Adds an item to the order object
* $item can be a named array with a minimum of 'product_id' and 'orderitem_quantity' and 'orderitem_attributes' (as CSV of productattributeoptions_ids)
* $item can be an object with minimum of 'product_id' and 'orderitem_quantity' and 'orderitem_attributes' properties
* $item can be a 'product_id' string
*
* $this->_items['product_id'] = TableOrderItems() object;
*
* @param object $item TableOrderItem object
* @return void
*/
function addItem($item)
{
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$orderItem = JTable::getInstance('OrderItems', 'CitruscartTable');
if (is_array($item)) {
$orderItem->bind($item);
} elseif (is_object($item) && is_a($item, 'CitruscartTableOrderItems')) {
$orderItem = $item;
} elseif (is_object($item)) {
$orderItem->product_id = $item->product_id;
$orderItem->orderitem_quantity = $item->orderitem_quantity;
$orderItem->vendor_id = $item->vendor_id;
$orderItem->orderitem_attributes = $item->orderitem_attributes;
} else {
$orderItem->product_id = $item;
$orderItem->orderitem_quantity = '1';
$orderItem->vendor_id = '0';
$orderItem->orderitem_attributes = '';
}
// check whether/not the item recurs
JModelLegacy::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_citruscart/models');
$model = JModelLegacy::getInstance('Products', 'CitruscartModel');
$model->setId($orderItem->product_id);
$product = $model->getItem();
$orderItem->subscription_prorated = $product->subscription_prorated;
// flag the order as recurring
if ($product->product_recurs) {
$this->order_recurs = true;
}
if ($orderItem->subscription_prorated) {
// set the orderitem's recurring product values
$orderItem->orderitem_recurs = $product->product_recurs;
$orderItem->recurring_price = $product->recurring_price;
$orderItem->recurring_payments = $product->recurring_payments;
$orderItem->recurring_period_interval = $product->recurring_period_interval;
$orderItem->recurring_period_unit = $product->recurring_period_unit;
$orderItem->recurring_trial_price = $product->recurring_trial_price;
if ($product->subscription_prorated) {
$result = CitruscartHelperSubscription::calculateProRatedTrial($product->subscription_prorated_date, $product->subscription_prorated_term, $product->recurring_period_unit, $product->recurring_trial_price, $product->subscription_prorated_charge);
$orderItem->recurring_trial = $result['trial'];
$orderItem->recurring_trial_period_interval = $result['interval'];
$orderItem->recurring_trial_period_unit = $result['unit'];
$orderItem->recurring_trial_price = $result['price'];
} else {
$orderItem->recurring_trial = $product->recurring_trial;
$orderItem->recurring_trial_period_interval = $product->recurring_trial_period_interval;
$orderItem->recurring_trial_period_unit = $product->recurring_trial_period_unit;
}
}
if (!empty($product->product_subscription)) {
// set the orderitem's subscription product values
$orderItem->orderitem_subscription = $product->product_subscription;
$orderItem->subscription_lifetime = $product->subscription_lifetime;
$orderItem->subscription_period_interval = $product->subscription_period_interval;
$orderItem->subscription_period_unit = $product->subscription_period_unit;
}
// Use hash to separate items when customer is buying the same product from multiple vendors
// and with different attribs
$hash = intval($orderItem->product_id) . "." . intval($orderItem->vendor_id) . "." . $orderItem->orderitem_attributes;
$results = JFactory::getApplication()->triggerEvent("onGetAdditionalOrderitemKeyValues", array($orderItem));
// JFactory::getApplication()->enqueueMessage( 'orders.php - line 236 - '.Citruscart::dump( $results ) );
foreach ($results as $result) {
foreach ($result as $key => $value) {
$hash = $hash . "." . $value;
}
}
if (isset($orderItem->cart_id)) {
unset($orderItem->cart_id);
}
// $orderItem->orderitem_id = null; // so it can create a new ordreitem, if needed
if (!empty($this->_items[$hash])) {
// merely update quantity if item already in list
$this->_items[$hash]->orderitem_quantity += $orderItem->orderitem_quantity;
} else {
$this->_items[$hash] = $orderItem;
}
// add the vendor to the order
$this->addVendor($orderItem);
// add productdownloads records to the order
// not necessary yet
// $this->addDownloads( $orderItem );
}
/**
* Set basic properties for the item, whether in a list or a singleton
*
* @param unknown_type $item
* @param unknown_type $key
* @param unknown_type $refresh
*/
protected function prepareItem(&$item, $key = 0, $refresh = false)
{
Citruscart::load("CitruscartHelperProduct", 'helpers.product');
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$helper_product = new CitruscartHelperProduct();
if (!empty($item->product_recurs)) {
$item->recurring_price = $item->price;
if ($item->subscription_prorated) {
Citruscart::load('CitruscartHelperSubscription', 'helpers.subscription');
$result = CitruscartHelperSubscription::calculateProRatedTrial($item->subscription_prorated_date, $item->subscription_prorated_term, $item->recurring_period_unit, $item->recurring_trial_price, $item->subscription_prorated_charge);
$item->price = $result['price'];
$item->prorated_price = $result['price'];
$item->prorated_interval = $result['interval'];
$item->prorated_unit = $result['unit'];
// $item->recurring_trial = $result['trial'];
} else {
if (!empty($item->recurring_trial)) {
$item->price = $item->recurring_trial_price;
}
}
}
$user_id = $this->getState('user.id', 0);
$qty = $this->getState('product.qty', -1);
if ($qty > -1) {
$user_group = CitruscartHelperUser::getUserGroup($user_id, $item->product_id);
$price = CitruscartHelperProduct::getPrice($item->product_id, $qty, $user_group);
$item->price = @$price->product_price;
}
$item->product_parameters = new DSCParameter($item->product_params);
$item->slug = $item->product_alias ? ":{$item->product_alias}" : "";
$item->link = 'index.php?option=com_citruscart&view=products&task=view&id=' . $item->product_id;
$item->link_edit = 'index.php?option=com_citruscart&view=products&task=edit&id=' . $item->product_id;
$item->product_categories = $this->getCategories($item->product_id);
$item->default_attributes = $helper_product->getDefaultAttributes($item->product_id);
$item->product_classes = null;
foreach ($item->product_categories as $cat) {
$item->product_classes .= " " . $cat->category_alias;
}
if (!empty($item->product_class_suffix)) {
$item->product_classes .= " " . $item->product_class_suffix;
}
$item->product_classes = trim($item->product_classes);
parent::prepareItem($item, $key, $refresh);
}
