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">
</div>
<?php
}
?>
</div>
<?php
if ($this->params->get('items_show_intro')) {
?>
<div class="djc_introtext">
<?php
if ($this->params->get('items_intro_length') > 0 && $this->params->get('items_intro_trunc') == '1') {
?>
<p><?php
echo DJCatalog2HtmlHelper::trimText($item->intro_desc, $this->params->get('items_intro_length'));
?>
</p><?php
} else {
echo $item->intro_desc;
}
?>
</div>
<?php
}
?>
<?php
if ($this->params->get('items_show_attributes', '1')) {
?>
<?php
}
?>
<?php
if ($this->params->get('fed_show_price') > 0) {
?>
<li><a href="<?php
echo JRoute::_($orderUrl . 'order=i.price&dir=' . $this->lists['order_Dir'] . '#tlb');
?>
"><?php
echo JText::_('COM_DJCATALOG2_PRICE');
?>
</a><?php
echo DJCatalog2HtmlHelper::orderDirImage($this->lists['order'], 'i.price', $this->lists['order_Dir']);
?>
</li>
<?php
}
?>
<li><a href="<?php
echo JRoute::_($orderUrl . 'order=i.created&dir=' . $this->lists['order_Dir'] . '#tlb');
?>
"><?php
echo JText::_('COM_DJCATALOG2_DATE');
?>
</a><?php
echo DJCatalog2HtmlHelper::orderDirImage($this->lists['order'], 'i.created', $this->lists['order_Dir']);
?>
</li>
</ul>
</div>
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;
}
">
<?php
echo $subcategory->name;
?>
</a>
</h3>
</div>
<?php
if ($this->params->get('category_show_intro')) {
?>
<div class="djc_description">
<?php
if ($this->params->get('category_intro_length') > 0 && $this->params->get('category_intro_trunc') == '1') {
?>
<p><?php
echo DJCatalog2HtmlHelper::trimText($subcategory->description, $this->params->get('category_intro_length'));
?>
</p><?php
} else {
echo $subcategory->description;
}
?>
</div>
<?php
}
?>
<?php
if ((int) $this->params->get('subcategory_showchildren', 0) == 1) {
?>
<?php
$sub_category_obj = $this->categories->get($item->id);
<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>
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
?>
</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>
private function _sendEmail($order)
{
require_once JPATH_ROOT . DS . 'components' . DS . 'com_djcatalog2' . DS . 'helpers' . DS . 'html.php';
require_once JPATH_ROOT . DS . 'components' . DS . 'com_djcatalog2' . DS . 'helpers' . DS . 'djcatalog2.php';
$app = JFactory::getApplication();
$params = JComponentHelper::getParams('com_djcatalog2');
$mailfrom = $app->getCfg('mailfrom');
$fromname = $app->getCfg('fromname');
$sitename = $app->getCfg('sitename');
$contact_list = $params->get('contact_list', false);
$recipient_list = array();
if ($contact_list !== false) {
$recipient_list = explode(PHP_EOL, $params->get('contact_list', ''));
}
$list_is_empty = true;
foreach ($recipient_list as $r) {
if (strpos($r, '@') !== false) {
$list_is_empty = false;
break;
}
}
if ($list_is_empty) {
$recipient_list[] = $mailfrom;
}
$recipient_list = array_unique($recipient_list);
$subject = JText::sprintf('COM_DJCATALOG2_EMAIL_NEW_STATUS_SUBJECT', $order['order_number'], $sitename);
$client_body = DJCatalog2HtmlHelper::getEmailTemplate($order, 'order_status');
// Send an email to customer
$mail = JFactory::getMailer();
//$mail->addRecipient($mailfrom);
$mail->addRecipient($order['email']);
$mail->setSender(array($mailfrom, $fromname));
$mail->setSubject($sitename . ': ' . $subject);
$mail->setBody($client_body);
$mail->isHtml(true);
$mail_sent = $mail->Send();
return $mail_sent;
}
?>
"><?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>
?>
</h3>
</div>
<?php
}
?>
<div class="djc_description">
<?php
if ($this->params->get('producers_show_intro', '0') == '1') {
?>
<div class="djc_introtext">
<?php
if ($this->params->get('producers_intro_length') > 0 && $this->params->get('producers_intro_trunc') == '1') {
?>
<p><?php
echo DJCatalog2HtmlHelper::trimText($item->description, $this->params->get('producers_intro_length'));
?>
</p><?php
} else {
echo $item->description;
}
?>
</div>
<?php
}
?>
</div>
<?php
if ($this->params->get('producers_readmore', '0') == '1') {
?>
<div class="clear"></div>
private function _sendEmail($data, $type)
{
$app = JFactory::getApplication();
$params = JComponentHelper::getParams('com_djcatalog2');
$user = JFactory::getUser();
$mailfrom = $app->getCfg('mailfrom');
$fromname = $app->getCfg('fromname');
$sitename = $app->getCfg('sitename');
$contact_list = $params->get('contact_list', false);
$recipient_list = array();
if ($contact_list !== false) {
$recipient_list = explode(PHP_EOL, $params->get('contact_list', ''));
}
$list_is_empty = true;
foreach ($recipient_list as $r) {
if (strpos($r, '@') !== false) {
$list_is_empty = false;
break;
}
}
if ($list_is_empty) {
$recipient_list[] = $mailfrom;
}
$recipient_list = array_unique($recipient_list);
$subject = null;
$admin_body = null;
$client_body = null;
switch ($type) {
case 'order':
$subject = JText::sprintf('COM_DJCATALOG2_EMAIL_NEW_ORDER_SUBJECT', $data['order_number'], $sitename);
$admin_body = DJCatalog2HtmlHelper::getEmailTemplate($data, 'admin.order');
$client_body = DJCatalog2HtmlHelper::getEmailTemplate($data, 'order');
break;
case 'query':
$subject = JText::sprintf('COM_DJCATALOG2_EMAIL_NEW_QUOTE_SUBJECT', $sitename);
$admin_body = DJCatalog2HtmlHelper::getEmailTemplate($data, 'admin.quote');
$client_body = DJCatalog2HtmlHelper::getEmailTemplate($data, 'quote');
break;
}
if (!$admin_body) {
return false;
}
// Send admin's email first
$mail = JFactory::getMailer();
//$mail->addRecipient($mailfrom);
foreach ($recipient_list as $recipient) {
$mail->addRecipient(trim($recipient));
}
$mail->setSender(array($mailfrom, $fromname));
$mail->setSubject($subject);
$mail->setBody($admin_body);
$mail->isHtml(true);
$admin_sent = $mail->Send();
// Send an email to customer
$mail = JFactory::getMailer();
//$mail->addRecipient($mailfrom);
$mail->addRecipient($data['email']);
$mail->setSender(array($mailfrom, $fromname));
$mail->setSubject($subject);
$mail->setBody($client_body);
$mail->isHtml(true);
$mail->Send();
return $admin_sent;
}
echo DJCatalog2HtmlHelper::orderDirImage($this->lists['order'], 'i.created', $this->lists['order_Dir']);
?>
</li>
<?php
}
?>
<?php
if (count($this->sortables) > 0) {
?>
<?php
foreach ($this->sortables as $sortable) {
?>
<li><a href="<?php
echo JRoute::_($orderUrl . '&order=f_' . $sortable->alias . '&dir=' . $this->lists['order_Dir'] . '#tlb');
?>
"><?php
echo $sortable->name;
?>
</a><?php
echo DJCatalog2HtmlHelper::orderDirImage($this->lists['order'], 'f_' . $sortable->alias, $this->lists['order_Dir']);
?>
</li>
<?php
}
?>
<?php
}
?>
</ul>
</div>
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;
}
