function getData()
{
$app = JFactory::getApplication();
if (!$this->_data) {
$option = $app->input->get('option', '', 'string');
$view = $app->input->get('view', '', 'string');
$id = $app->input->get('id', '', 'int');
if ($option != 'com_djcatalog2' || $view != 'item' || !$id) {
return false;
}
$db = JFactory::getDBO();
$db->setQuery($this->_buildQuery());
$this->_data = $db->loadObjectList();
foreach ($this->_data as $key => $item) {
if ($this->_mparams->get('show_price') == 2 || $this->_mparams->get('show_price') == 1 && $item->price > 0.0) {
$catParams = $this->getCategoryParams($item->cat_id);
if ($item->price != $item->final_price) {
$this->_data[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
$this->_data[$key]->special_price = DJCatalog2HtmlHelper::formatPrice($item->special_price, $catParams);
} else {
$this->_data[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
$this->_data[$key]->special_price = null;
}
//$this->_data[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
} else {
$this->_data[$key]->price = null;
$this->_data[$key]->special_price = null;
}
$this->_data[$key]->slug = empty($this->_data[$key]->alias) ? $this->_data[$key]->id : $this->_data[$key]->id . ':' . $this->_data[$key]->alias;
$this->_data[$key]->catslug = empty($this->_data[$key]->category_alias) ? $this->_data[$key]->category_id : $this->_data[$key]->category_id . ':' . $this->_data[$key]->category_alias;
$this->_data[$key]->prodslug = empty($this->_data[$key]->producer_alias) ? $this->_data[$key]->producer_id : $this->_data[$key]->producer_id . ':' . $this->_data[$key]->producer_alias;
}
}
return $this->_data;
}
function getData()
{
$app = JFactory::getApplication();
if (!$this->_data) {
$option = $app->input->get('option', '', 'string');
$view = $app->input->get('view', '', 'string');
$id = $app->input->get('id', '', 'int');
if ($option != 'com_djcatalog2' || $view != 'item' || !$id) {
return false;
}
$db = JFactory::getDbo();
$db->setQuery($this->_buildQuery());
$this->_data = $db->loadObjectList('id');
$ids = array_keys($this->_data);
if (empty($ids)) {
return false;
}
$query = $db->getQuery(true);
$query->select('i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath');
$query->from('#__djc2_items as i');
$query->join('inner', '#__djc2_images as img on img.id=(select id from #__djc2_images where type=\'item\' and item_id=i.id order by ordering asc limit 1)');
$query->where('i.id IN (' . implode(',', $ids) . ')');
$db->setQuery($query);
$image_list = $db->loadObjectList('id');
foreach ($this->_data as $key => $item) {
if ($this->_mparams->get('show_price') == 2 || $this->_mparams->get('show_price') == 1 && $item->price > 0.0) {
$catParams = $this->getCategoryParams($item->cat_id);
if ($item->price != $item->final_price) {
$this->_data[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
$this->_data[$key]->special_price = DJCatalog2HtmlHelper::formatPrice($item->special_price, $catParams);
} else {
$this->_data[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
$this->_data[$key]->special_price = null;
}
} else {
$this->_data[$key]->price = null;
$this->_data[$key]->special_price = null;
}
$this->_data[$key]->slug = empty($this->_data[$key]->alias) ? $this->_data[$key]->id : $this->_data[$key]->id . ':' . $this->_data[$key]->alias;
$this->_data[$key]->catslug = empty($this->_data[$key]->category_alias) ? $this->_data[$key]->category_id : $this->_data[$key]->category_id . ':' . $this->_data[$key]->category_alias;
$this->_data[$key]->prodslug = empty($this->_data[$key]->producer_alias) ? $this->_data[$key]->producer_id : $this->_data[$key]->producer_id . ':' . $this->_data[$key]->producer_alias;
$this->_data[$key]->item_image = isset($image_list[$this->_data[$key]->id]) ? $image_list[$this->_data[$key]->id]->item_image : null;
$this->_data[$key]->image_caption = isset($image_list[$this->_data[$key]->id]) ? $image_list[$this->_data[$key]->id]->image_caption : null;
$this->_data[$key]->image_path = isset($image_list[$this->_data[$key]->id]) ? $image_list[$this->_data[$key]->id]->image_path : null;
$this->_data[$key]->image_fullpath = isset($image_list[$this->_data[$key]->id]) ? $image_list[$this->_data[$key]->id]->image_fullpath : null;
}
}
return $this->_data;
}
?>
<span><?php
echo DJCatalog2HtmlHelper::formatPrice($this->item->final_price, $this->params);
?>
</span>
<?php
}
?>
<?php
} else {
?>
<?php
echo JText::_('COM_DJCATALOG2_PRICE') . ': ';
?>
<span><?php
echo DJCatalog2HtmlHelper::formatPrice($this->item->price, $this->params);
?>
</span>
<?php
}
?>
</small>
</div>
<?php
}
?>
<?php
if ((int) $this->params->get('show_author_item', 0) > 0 && $this->item->author) {
?>
<div class="djc_author">
function getList($start, $limit)
{
if (empty($this->_list)) {
$query = $this->_buildQuery();
$this->_list = $this->_getList($query, $start, $limit);
}
foreach ($this->_list as $key => $item) {
$catParams = $this->getCategoryParams($item->cat_id);
if ($item->price != $item->final_price) {
$this->_list[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
$this->_list[$key]->special_price = DJCatalog2HtmlHelper::formatPrice($item->special_price, $catParams);
} else {
$this->_list[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
$this->_list[$key]->special_price = null;
}
$this->_list[$key]->slug = empty($this->_list[$key]->alias) ? $this->_list[$key]->id : $this->_list[$key]->id . ':' . $this->_list[$key]->alias;
$this->_list[$key]->catslug = empty($this->_list[$key]->category_alias) ? $this->_list[$key]->category_id : $this->_list[$key]->category_id . ':' . $this->_list[$key]->category_alias;
$this->_list[$key]->prodslug = empty($this->_list[$key]->producer_alias) ? $this->_list[$key]->producer_id : $this->_list[$key]->producer_id . ':' . $this->_list[$key]->producer_alias;
}
return $this->_list;
}
<td class="djc_td_title">
<?php
echo $item->name;
?>
</td>
<td class="djc_td_update_qty" nowrap="nowrap">
<?php
echo (int) $item->_quantity;
?>
</td>
<td class="djc_td_price djc_td_price_net" nowrap="nowrap">
<?php
echo DJCatalog2HtmlHelper::formatPrice($item->_prices['total']['net'], $this->params, false);
?>
</td>
<td class="djc_td_price djc_td_price_tax" nowrap="nowrap">
<?php
echo DJCatalog2HtmlHelper::formatPrice($item->_prices['total']['tax'], $this->params, false);
?>
</td>
<td class="djc_td_price djc_td_price_gross" nowrap="nowrap">
<?php
echo DJCatalog2HtmlHelper::formatPrice($item->_prices['total']['gross'], $this->params, false);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
function getData()
{
if (!$this->_data) {
JModelLegacy::addIncludePath(JPATH_BASE . DS . 'components' . DS . 'com_djcatalog2' . DS . 'models', 'DJCatalog2Model');
$model = JModelLegacy::getInstance('Items', 'Djcatalog2Model', array('ignore_request' => true));
$order = $this->_mparams->get('orderby', 'i.ordering');
$order_Dir = $this->_mparams->get('orderdir', 'asc');
$order_featured = $this->_mparams->get('featured_first', 0);
$filter_catid = $this->_mparams->get('catid', array());
$filter_producerid = $this->_mparams->get('producer_id', 0);
$filter_itemids = $this->_mparams->get('item_ids', null);
$filter_featured = $this->_mparams->get('featured_only', 0);
$limit = $this->_mparams->get('items_limit', 0);
$state = $model->getState();
//$this->_cparams->set('product_catalogue', 0);
$model->setState('params', $this->_cparams);
$model->setState('list.start', 0);
$model->setState('list.limit', $limit);
$model->setState('filter.category', $filter_catid);
if ($filter_producerid > 0) {
$model->setState('filter.producer', (int) $filter_producerid);
}
$model->setState('filter.catalogue', false);
$model->setState('filter.featured', $filter_featured);
$model->setState('list.ordering_featured', $order_featured);
$model->setState('list.ordering', $order);
$model->setState('list.direction', $order_Dir);
if ($filter_itemids) {
$filter_itemids = explode(',', $filter_itemids);
$ids = array();
foreach ($filter_itemids as $k => $v) {
$v = trim($v);
if ((int) $v > 0) {
$ids[] = (int) $v;
}
}
if (!empty($ids)) {
$ids = array_unique($ids);
$model->setState('filter.item_ids', $ids);
}
}
$this->_data = $model->getItems();
foreach ($this->_data as $key => $item) {
if ($this->_mparams->get('show_price') == 2 || $this->_mparams->get('show_price') == 1 && $item->price > 0.0) {
$catParams = $this->getCategoryParams($item->cat_id);
if ($item->price != $item->final_price) {
$this->_data[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
$this->_data[$key]->special_price = DJCatalog2HtmlHelper::formatPrice($item->special_price, $catParams);
} else {
$this->_data[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
$this->_data[$key]->special_price = null;
}
//$this->_data[$key]->price = DJCatalog2HtmlHelper::formatPrice($item->price, $catParams);
} else {
$this->_data[$key]->price = null;
$this->_data[$key]->special_price = null;
}
}
}
return $this->_data;
}
?>
</td>
<td align="center"><?php
echo (int) $item['quantity'];
?>
</td>
<td align="center"><?php
echo DJCatalog2HtmlHelper::formatPrice($item['cost'], $params, false);
?>
</td>
<td align="center"><?php
echo DJCatalog2HtmlHelper::formatPrice($item['tax'], $params, false);
?>
</td>
<td align="center"><?php
echo DJCatalog2HtmlHelper::formatPrice($item['total'], $params, false);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<br />
<p>
<?php
echo JText::_('COM_DJCATALOG2_EMAIL_ORDER_CLIENT_FOOTER');
?>
<a href="<?php
echo JRoute::_(DJCatalogHelperRoute::getOrderRoute($data['id']), true, -1);
djc_row<?php
echo $k;
?>
">
<td class="djc_td_title"><?php
echo $item->item_name;
?>
</td>
<td class="djc_td_qty" nowrap="nowrap"><?php
echo (int) $item->quantity;
?>
</td>
<td class="djc_td_price djc_td_price_net" nowrap="nowrap"><?php
echo DJCatalog2HtmlHelper::formatPrice($item->cost, $this->params, false);
?>
</td>
<td class="djc_td_price djc_td_price_tax" nowrap="nowrap"><?php
echo DJCatalog2HtmlHelper::formatPrice($item->tax, $this->params, false);
?>
</td>
<td class="djc_td_price djc_td_price_gross" nowrap="nowrap"><?php
echo DJCatalog2HtmlHelper::formatPrice($item->total, $this->params, false);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
?>
"><?php
echo str_pad($item->order_number, 5, '0', STR_PAD_LEFT);
?>
</a>
</td>
<td class="djc_td_order_date">
<a href="<?php
echo $order_url;
?>
"><?php
echo JHtml::_('date', $item->created_date, 'd-m-Y');
?>
</a>
</td>
<td class="djc_td_order_status">
<?php
echo JText::_('COM_DJCATALOG2_ORDER_STATUS_' . $item->status);
?>
</td>
<td class="djc_td_order_total">
<?php
echo DJCatalog2HtmlHelper::formatPrice($item->grand_total, $this->params);
?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
echo JText::_('COM_DJCATALOG2_CART_FOOTER_TOTAL');
?>
</td>
<?php
/* ?>
<td>
<?php echo DJCatalog2HtmlHelper::formatPrice($this->total['net'], $this->params)?>
</td>
<td>
<?php echo DJCatalog2HtmlHelper::formatPrice($this->total['tax'], $this->params)?>
</td>
<?php */
?>
<td>
<?php
echo DJCatalog2HtmlHelper::formatPrice($this->total['gross'] + $shipping_charges, $this->params);
?>
</td>
</tr>
<?php
}
?>
-->
<!-- <tr class="djc_cart_buttons">
<td colspan="4">
<input type="submit" class="button btn" value="<?php
echo JText::_('COM_DJCATALOG2_CART_UPDATE_BUTTON');
?>
" />
<input type="hidden" name="task" value="cart.update_batch"/>
<input type="hidden" name="return" value="<?php
