Skip to content

Instantly share code, notes, and snippets.

@AshlinRejo
Last active October 28, 2022 11:53
Show Gist options
  • Save AshlinRejo/d3429193657fefe8b28c97f100228d30 to your computer and use it in GitHub Desktop.
Save AshlinRejo/d3429193657fefe8b28c97f100228d30 to your computer and use it in GitHub Desktop.
J2Store subscription: Override for show subscription start and end date in order item in back-end
<?php
/**
* @package J2Store
* @copyright Copyright (c)2014-17 Ramesh Elamathi / J2Store.org
* @license GNU GPL v3 or later
*/
/**
* For override copy this file to [BACKEND_TEMPLATE_PATH]/html/com_j2store/myprofile/ordersummary.php
* */
// No direct access to this file
defined ( '_JEXEC' ) or die ();
$order = $this->order;
$items = $this->order->getItems();
$currency = J2Store::currency();
$tz = JFactory::getConfig()->get('offset');
$j2_params = J2Store::config();
?>
<h3><?php echo JText::_('J2STORE_ORDER_SUMMARY')?></h3>
<table class="j2store-cart-table table table-bordered">
<thead>
<tr>
<th><?php echo JText::_('J2STORE_CART_LINE_ITEM'); ?></th>
<th><?php echo JText::_('J2STORE_CART_LINE_ITEM_QUANTITY'); ?></th>
<th><?php echo JText::_('J2STORE_CART_LINE_ITEM_TOTAL'); ?></th>
</tr>
</thead>
<tbody>
<?php foreach ($items as $item): ?>
<?php
$registry = new JRegistry;
$registry->loadString($item->orderitem_params);
$item->params = $registry;
$thumb_image = $item->params->get('thumb_image', '');
$back_order_text = $item->params->get('back_order_item', '');
?>
<tr>
<td>
<?php if($this->params->get('show_thumb_cart', 1) && !empty($thumb_image)): ?>
<span class="cart-thumb-image">
<?php if(JFile::exists(JPATH_SITE.'/'.$thumb_image)): ?>
<img src="<?php echo JUri::root(true). '/'.$thumb_image; ?>" >
<?php endif;?>
</span>
<?php endif; ?>
<?php echo $this->order->get_formatted_lineitem_name($item,'admin');?>
<?php if($this->params->get('show_price_field', 1)): ?>
<span class="cart-product-unit-price">
<span class="cart-item-title"><?php echo JText::_('J2STORE_CART_LINE_ITEM_UNIT_PRICE'); ?></span>
<span class="cart-item-value">
<?php echo $currency->format($this->order->get_formatted_order_lineitem_price($item, $this->params->get('checkout_price_display_options', 1)), $this->order->currency_code, $this->order->currency_value);?>
</span>
</span>
<?php endif; ?>
<?php if(!empty($item->orderitem_sku)): ?>
<br />
<span class="cart-product-sku">
<span class="cart-item-title"><?php echo JText::_('J2STORE_CART_LINE_ITEM_SKU'); ?></span>
<span class="cart-item-value"><?php echo $item->orderitem_sku; ?></span>
</span>
<?php endif; ?>
<?php
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('*');
$query->from('#__j2store_ordersubscriptions');
$query->where('orderitem_id = '.$db->quote($item->j2store_orderitem_id));
$db->setQuery($query);
$subscription_order_item = $db->loadObject();
if(!empty($subscription_order_item)){
$start_date = JFactory::getDate($subscription_order_item->term_start_on, $tz);
$end_date = JFactory::getDate($subscription_order_item->term_end_on, $tz);
?>
<br />
<span class="cart-product-sku">
<span class="cart-item-title"><b>Start on:</b></span>
<span class="cart-item-value"><?php echo $start_date->format($j2_params->get('date_format', JText::_('DATE_FORMAT_LC1')), true); ?></span>
</span>
<br />
<span class="cart-product-sku">
<span class="cart-item-title"><b>End on:</b></span>
<span class="cart-item-value"><?php echo $end_date->format($j2_params->get('date_format', JText::_('DATE_FORMAT_LC1')), true); ?></span>
</span>
<?php } ?>
<?php if($back_order_text):?>
<br />
<span class="label label-inverse"><?php echo JText::_($back_order_text);?></span>
<?php endif;?>
<?php echo J2Store::plugin()->eventWithHtml('AfterDisplayLineItemTitleInOrder', array($item, $this->order, $this->params));?>
</td>
<td><?php echo $item->orderitem_quantity; ?></td>
<td class="cart-line-subtotal">
<?php echo $currency->format($this->order->get_formatted_lineitem_total($item, $this->params->get('checkout_price_display_options', 1)), $this->order->currency_code, $this->order->currency_value ); ?>
</td>
</tr>
<?php endforeach; ?>
</tbody>
<tfoot class="cart-footer">
<?php if($totals = $this->order->get_formatted_order_totals()): ?>
<?php foreach($totals as $total): ?>
<tr>
<th scope="row" colspan="2"> <?php echo $total['label']; ?></th>
<td><?php echo $total['value']; ?></td>
</tr>
<?php endforeach; ?>
<?php endif; ?>
</tfoot>
</table>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment