/**
* getData method
* @param $params
* @return array
*/
static function getData($params)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('
c.id,
c.user_id AS user,
c.comment,
c.date_add,
c.rate,
uf.filename AS logo,
u.name
');
$query->from('#__ksenmart_comments AS c');
$query->leftjoin('#__ksen_users AS kmu ON kmu.id=c.user_id');
$query->leftjoin('#__users AS u ON kmu.id=u.id');
$query->leftjoin('#__ksenmart_files AS uf ON uf.owner_id=u.id');
$query->where("type='shop_review'");
$query->where("published=1");
$query->order('date_add DESC');
$db->setQuery($query, 0, $params->get('count_review', 5));
$reviews = $db->loadObjectList();
$reviews = KSUsers::setAvatarLogoInObject($reviews);
return $reviews;
}
public function getShopReview($uid)
{
$this->onExecuteBefore('getShopReview', array(&$uid));
$query = $this->_db->getQuery(true);
$query->select('
c.id,
c.user_id AS user,
c.name,
c.comment,
c.date_add,
c.rate
');
$query->from('#__ksenmart_comments AS c');
$query->where("c.type='shop_review'");
$query->where("c.published=1");
$query->where('c.user_id=' . $uid);
$this->_db->setQuery($query);
$review = $this->_db->loadObject();
$review = KSUsers::setAvatarLogoInObject($review);
$this->onExecuteAfter('getShopReview', array(&$review));
return $review;
}
public function getProductCommentsChild($comments)
{
$this->onExecuteBefore('getProductCommentsChild', array(&$comments));
if (!empty($comments)) {
$i = 0;
$where = '';
$comments_l = count($comments) - 1;
$query = $this->_db->getQuery(true);
$query->select('
c.id,
c.user_id AS user,
c.parent_id,
c.product_id AS product,
c.comment,
c.name AS comment_name,
c.good,
c.bad,
c.rate,
c.date_add,
uf.filename AS logo,
u.name
')->from('#__ksenmart_comments AS c')->leftjoin('#__ksen_users AS kmu ON kmu.id=c.user_id')->leftjoin('#__users AS u ON kmu.id=u.id')->leftjoin('#__ksenmart_files AS uf ON uf.owner_id=u.id')->where('c.published=1');
foreach ($comments as $comment) {
if (!empty($comment->id) && $comment->id > 0) {
$where .= 'c.parent_id=' . $this->_db->escape($comment->id);
if ($comments_l != $i) {
$where .= ' OR ';
}
}
$i++;
continue;
}
$query->where($where);
$query->order('c.date_add desc');
$this->_db->setQuery($query);
$children = $this->_db->loadObjectList();
$this->_db->query();
if ($this->_db->getNumRows() > 0) {
$children = KSUsers::setAvatarLogoInObject($children);
$children_l = count($children);
for ($i = 0; $i < $children_l; $i++) {
for ($j = 0; $j <= $comments_l; $j++) {
if ($children[$i]->parent_id == $comments[$j]->id) {
$comments[$j]->children = $children[$i];
}
continue;
}
}
}
}
$this->onExecuteAfter('getProductCommentsChild', array(&$comments));
return $comments;
}
private static function getEmptyUserObject()
{
global $ext_name_com;
$session = JFactory::getSession();
$params = JComponentHelper::getParams($ext_name_com);
$user = new stdClass();
$user->id = 0;
$user->region_id = $session->get('user_region', 0);
$user->phone = $session->get('phone_code', '');
$user->watched = array();
$user->favorites = array();
$user->name = JText::_('ksm_users_anonym');
$user->username = null;
$user->email = null;
$user->groups = array();
$user->usertype = null;
$user->block = null;
$user->city = null;
$user->zip = null;
$user->street = null;
$user->house = null;
$user->floor = null;
$user->flat = null;
$user->coords = null;
$user->address = null;
$user->sendmails = null;
$user->params = null;
$user->settings = json_decode('{"catalog_layout":"' . $params->get('catalog_default_view', 'grid') . '"}');
$user->folder = 'users';
$user->filename = 'no.jpg';
$user->small_img = KSMedia::resizeImage($user->filename, $user->folder, $params->get('admin_product_thumb_image_width', 36), $params->get('admin_product_thumb_image_heigth', 36));
$user->medium_img = KSMedia::resizeImage($user->filename, $user->folder, $params->get('admin_product_medium_image_width', 120), $params->get('admin_product_medium_image_heigth', 120));
KSUsers::setAvatarLogoInObject($user);
return $user;
}
public function getShopReviewsList()
{
$this->onExecuteBefore('getShopReviewsList');
$this->_db = JFactory::getDbo();
$query = $this->_db->getQuery(true);
$query->select('
c.id,
c.user_id AS user,
c.name,
c.comment,
c.date_add,
c.rate,
uf.filename AS logo
');
$query->from('#__ksenmart_comments AS c');
$query->leftjoin('#__ksen_users AS u ON u.id=c.user_id');
$query->leftjoin('#__ksenmart_files AS uf ON uf.owner_id=u.id');
$query->where("type='shop_review'");
$query->where("published=1");
$query->order('date_add DESC');
$this->_db->setQuery($query);
$reviews = $this->_db->loadObjectList();
KSUsers::setAvatarLogoInObject($reviews);
$this->onExecuteAfter('getShopReviewsList', array(&$reviews));
return $reviews;
}
