public function getComment()
{
$this->onExecuteBefore('getComment');
$id = JRequest::getInt('id', 0);
$comment = KSSystem::getTableByIds(array($id), 'comments', array('t.id', 't.parent_id', 't.user_id AS user', 't.product_id AS product', 't.name', 't.comment', 't.good', 't.bad', 't.rate', 't.date_add', 't.type'), true, false, true);
if (!empty($comment)) {
$comment->user = KSUsers::getUser($comment->user);
if (isset($comment->product) && $comment->product > 0) {
$comment->product = KSMProducts::getProduct($comment->product);
}
$this->onExecuteAfter('getComment', array(&$comment));
return $comment;
}
return new stdClass();
}
function getProductCategory($product_id)
{
$final_categories = array();
$parent_ids = array();
$default_category = $this->getDefaultCategory($product_id);
$product_categories = $this->getProductCategories($product_id);
foreach ($product_categories as $product_category) {
if (!empty($default_category)) {
$id_default_way = false;
} else {
$id_default_way = true;
}
$categories = array();
$parent = $product_category->category_id;
while ($parent != 0) {
if ($parent == $default_category) {
$id_default_way = true;
}
$category = KSSystem::getTableByIds(array($parent), 'categories', array('t.id', 't.parent_id'), true, false, true);
$categories[] = $category->id;
$parent = $category->parent_id;
}
if ($id_default_way && count($categories) > count($final_categories)) {
$final_categories = $categories;
}
}
$category_id = count($final_categories) ? $final_categories[0] : 0;
return $category_id;
}
public function updateCart()
{
$this->onExecuteBefore('updateCart');
$params = JComponentHelper::getParams('com_ksenmart');
$jinput = JFactory::getApplication()->input;
$count = $jinput->get('count', 0, 'float');
$price = $jinput->get('price', 0, 'float');
$item_id = $jinput->get('item_id', 0, 'int');
$item = KSSystem::getTableByIds(array($item_id), 'order_items', array('t.id', 't.order_id', 't.price', 't.count', 't.product_id'), false, false, true);
if ($price != 0 && $price != $item->price) {
$order_item_object = new stdClass();
$order_item_object->id = $item_id;
$order_item_object->price = $price;
$order_item_object->count = $count;
try {
$result = $this->_db->updateObject('#__ksenmart_order_items', $order_item_object, 'id');
} catch (Exception $e) {
}
$diff = ($price - $item->price) * $item->count;
$item->price = $price;
$order_object = new stdClass();
$order_object->id = $item->order_id;
$order_object->cost = $this->getOrderCost($this->order_id) + $diff;
try {
$result = $this->_db->updateObject('#__ksenmart_orders', $order_object, 'id');
} catch (Exception $e) {
}
}
$prd = KSMProducts::getProduct($item->product_id);
$item_properties = array();
foreach ($prd->properties as $property) {
$value = JRequest::getVar('property_' . $property->id, '');
if (!empty($value)) {
$item_properties[] = $property->id . ':' . $value;
}
}
$order_item_object = new stdClass();
$order_item_object->id = $item_id;
$order_item_object->properties = json_encode($item_properties);
try {
$result = $this->_db->updateObject('#__ksenmart_order_items', $order_item_object, 'id');
} catch (Exception $e) {
}
$diff_count = $count - $item->count;
$diff = ($count - $item->count) * $item->price;
if ($count == 0) {
$query = $this->_db->getQuery(true);
$conditions = array('id=' . $this->_db->escape($item_id));
$query->delete(KSDb::quoteName('#__ksenmart_order_items'))->where($conditions);
$this->_db->setQuery($query);
try {
$result = $this->_db->query();
// $this->_db->execute(); for Joomla 3.0.
} catch (Exception $e) {
}
} else {
$order_item_object = new stdClass();
$order_item_object->id = $item_id;
$order_item_object->count = $count;
try {
$result = $this->_db->updateObject('#__ksenmart_order_items', $order_item_object, 'id');
} catch (Exception $e) {
}
}
if ($params->get('use_stock', 1)) {
$product_object = new stdClass();
$product_object->id = $item->product_id;
$product_object->in_stock = $prd->in_stock - $diff_count;
try {
$result = $this->_db->updateObject('#__ksenmart_products', $product_object, 'id');
} catch (Exception $e) {
}
}
$order_object = new stdClass();
$order_object->id = $item->order_id;
$order_object->cost = $this->getOrderCost($item->order_id) + $diff;
try {
$result = $this->_db->updateObject('#__ksenmart_orders', $order_object, 'id');
} catch (Exception $e) {
}
$orderItem = $this->getOrderUpdateItems($item->order_id, $item->id);
$this->onExecuteAfter('updateCart', array(&$orderItem));
return $orderItem;
}
/**
* KsenMartModelProfile::getWatched()
*
* @return
*/
public function getWatched()
{
$this->onExecuteBefore('getWatched');
$user = KSUsers::getUser();
$limitstart = JFactory::getApplication()->input->get('limitstart', 0, 'int');
$rows = KSSystem::getTableByIds($user->watched, 'products', array('t.id'));
if (!empty($rows)) {
foreach ($rows as &$row) {
$row = KSMProducts::getProduct($row->id);
}
$this->_pagination = new JPagination($this->_total, $limitstart, $this->_limit);
}
$this->onExecuteAfter('getWatched', array(&$rows));
return $rows;
}
public function getProductTitle()
{
$this->onExecuteBefore('getProductTitle');
$params = JComponentHelper::getParams('com_ksenmart');
$config = KSSystem::getSeoTitlesConfig('product');
$shop_name = $params->get('shop_name', '');
$path_separator = $params->get('path_separator', ' ');
$title = array();
if (empty($this->_product->metatitle)) {
if ($shop_name != '') {
$title[] = $shop_name;
}
foreach ($config as $key => $val) {
if ($val->user == 0) {
if ($val->active == 1) {
if ($key == 'seo-product') {
$title[] = $this->_product->title;
}
if ($key == 'seo-product_code') {
$title[] = $this->_product->product_code;
}
if ($key == 'seo-manufacturer' && isset($this->_product->manufacturer->id)) {
$manufacturer_title = KSSystem::getTableByIds(array($this->_product->manufacturer->id), 'manufacturers', array('t.title'), false, false, true);
$title[] = $manufacturer_title->title;
}
if ($key == 'seo-country' && isset($this->_product->manufacturer->id)) {
if (!empty($this->_product->manufacturer->country)) {
$country_title = KSSystem::getTableByIds(array($this->_product->manufacturer->country->id), 'countries', array('t.title'), false, false, true);
$title[] = $country_title->title;
}
} elseif ($key == 'seo-parent-category') {
$categories = array();
$query = $this->_db->getQuery(true);
$query->select('category_id')->from('#__ksenmart_products_categories')->where('product_id=' . $this->_db->Quote((int) $this->_id))->where('is_default=1');
$this->_db->setQuery($query);
$default_category = $this->_db->loadResult();
$parent = $default_category;
while ($parent != 0) {
$query = $this->_db->getQuery(true);
$query->select('title,parent_id')->from('#__ksenmart_categories')->where('id=' . $this->_db->Quote($parent));
$this->_db->setQuery($query);
$category = $this->_db->loadObject();
if ($category->title != '' && $parent != $default_category) {
$categories[] = $category->title;
}
$parent = $category->parent_id;
}
$categories = array_reverse($categories);
foreach ($categories as $category) {
$title[] = $category;
}
} elseif ($key == 'seo-category') {
$query = $this->_db->getQuery(true);
$query->select('category_id')->from('#__ksenmart_products_categories')->where('product_id=' . $this->_db->Quote((int) $this->_id))->where('is_default=1');
$this->_db->setQuery($query);
$default_category = $this->_db->loadResult();
$query = $this->_db->getQuery(true);
$query->select('title')->from('#__ksenmart_categories')->where('id=' . $this->_db->Quote($default_category));
$this->_db->setQuery($query);
$cat_title = $this->_db->loadResult();
if (!empty($cat_title)) {
$title[] = $cat_title;
}
}
}
} else {
if (strpos($key, 'property_') !== false) {
$property_id = str_replace('property_', '', $key);
if (isset($this->_product->properties[$property_id]->values)) {
$values = array();
foreach ($this->_product->properties[$property_id]->values as $value) {
if ($value->title != '') {
$values[] = $value->title;
}
}
if (count($values) > 0) {
$title[] = $val->title . ' - ' . implode(', ', $values);
}
}
} else {
$title[] = $val->title;
}
}
}
} else {
$title[] = $this->_product->metatitle;
}
$this->onExecuteAfter('getProductTitle', array(&$path_separator, &$title));
return implode($path_separator, $title);
}
/**
* KsenMartModelcatalog::setManufacturerMetaData()
*
* @return
*/
public function setManufacturerMetaData()
{
$this->onExecuteBefore('setManufacturerMetaData');
$document = JFactory::getDocument();
$metatitle = '';
$metadescription = '';
$metakeywords = '';
$manufacturer = $this->getManufacturer();
$config = KSSystem::getSeoTitlesConfig('manufacturer', 'meta');
if (empty($manufacturer->metatitle)) {
$metatitle = $manufacturer->title;
} else {
$metatitle = $manufacturer->metatitle;
}
if (empty($manufacturer->metadescription)) {
if ($config->description->flag == 1) {
if ($config->description->type == 'seo-type-mini-description') {
$metadescription = strip_tags($manufacturer->introcontent);
} elseif ($config->description->type == 'seo-type-description') {
$metadescription = strip_tags($manufacturer->content);
}
$metadescription = mb_substr($metadescription, 0, $config->description->symbols);
}
} else {
$metadescription = $manufacturer->metadescription;
}
if (empty($manufacturer->metakeywords)) {
if ($config->keywords->flag == 1) {
if ($config->keywords->type == 'seo-type-country') {
$countries = KSSystem::getTableByIds(array($manufacturer->country), 'countries', array('t.title'));
if (!empty($countries[0]->title)) {
$metakeywords = $countries[0]->title;
}
} elseif ($config->keywords->type == 'seo-type-title') {
$metakeywords = strip_tags($manufacturer->title);
}
}
} else {
$metakeywords = $manufacturer->metakeywords;
}
if (!empty($metatitle)) {
$document->setMetaData('title', $metatitle);
}
if (!empty($metadescription)) {
$document->setMetaData('description', $metadescription);
}
if (!empty($metakeywords)) {
$document->setMetaData('keywords', $metakeywords);
}
$this->onExecuteAfter('setManufacturerMetaData', array(&$this));
return true;
}
