/** * 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; }