function getAllReviews($category_id = null, $product_id = null, $limitstart = null, $limit = null, $text_search = null, $result = "list", $vendor_id = 0, $order = null, $orderDir = null)
{
$lang = JSFactory::getLang();
$db = JFactory::getDBO();
$where = "";
if ($product_id) {
$where .= " AND pr_rew.product_id='" . $db->escape($product_id) . "' ";
}
if ($vendor_id) {
$where .= " AND pr.vendor_id='" . $db->escape($vendor_id) . "' ";
}
if ($limit > 0) {
$limit = " LIMIT " . $limitstart . " , " . $limit;
}
$where .= $text_search ? " AND CONCAT_WS('|',pr.`" . $lang->get('name') . "`,pr.`" . $lang->get('short_description') . "`,pr.`" . $lang->get('description') . "`,pr_rew.review, pr_rew.user_name, pr_rew.user_email ) LIKE '%" . $db->escape($text_search) . "%' " : '';
$ordering = 'pr_rew.review_id desc';
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
if ($category_id) {
$query = "select pr.`" . $lang->get('name') . "` as name,pr_rew.* , DATE_FORMAT(pr_rew.`time`,'%d.%m.%Y') as dateadd \r\n from #__jshopping_products_reviews as pr_rew\r\n LEFT JOIN #__jshopping_products as pr USING (product_id)\r\n LEFT JOIN `#__jshopping_products_to_categories` AS pr_cat USING (product_id)\r\n WHERE pr_cat.category_id = '" . $db->escape($category_id) . "' " . $where . " ORDER BY " . $ordering . " " . $limit;
} else {
$query = "select pr.`" . $lang->get('name') . "` as name,pr_rew.*, DATE_FORMAT(pr_rew.`time`,'%d.%m.%Y') as dateadd \r\n from #__jshopping_products_reviews as pr_rew\r\n LEFT JOIN #__jshopping_products as pr USING (product_id) \r\n WHERE 1 " . $where . " ORDER BY " . $ordering . " " . $limit;
}
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
if ($result == "list") {
return $db->loadObjectList();
} else {
$db->query();
return $db->getNumRows();
}
}
function getAllList($display = 0)
{
$db = JFactory::getDBO();
$lang = JSFactory::getLang();
$query = "SELECT id, `" . $lang->get("name") . "` as name, field_id FROM `#__jshopping_products_extra_field_values` order by ordering";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
if ($display == 0) {
return $db->loadObjectList();
} elseif ($display == 1) {
$rows = $db->loadObjectList();
$list = array();
foreach ($rows as $k => $row) {
$list[$row->id] = $row->name;
unset($rows[$k]);
}
return $list;
} else {
$rows = $db->loadObjectList();
$list = array();
foreach ($rows as $k => $row) {
$list[$row->field_id][$row->id] = $row->name;
unset($rows[$k]);
}
return $list;
}
}
function getList($groupordering = 0, $order = null, $orderDir = null, $filter = array())
{
$db = JFactory::getDBO();
$lang = JSFactory::getLang();
$ordering = "F.ordering";
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
if ($groupordering) {
$ordering = "G.ordering, " . $ordering;
}
$where = '';
$_where = array();
if ($filter['group']) {
$_where[] = " F.group = '" . $db->escape($filter['group']) . "' ";
}
if ($filter['text_search']) {
$text_search = $filter['text_search'];
$word = addcslashes($db->escape($text_search), "_%");
$_where[] = "(LOWER(F.`" . $lang->get('name') . "`) LIKE '%" . $word . "%' OR LOWER(F.`" . $lang->get('description') . "`) LIKE '%" . $word . "%' OR F.id LIKE '%" . $word . "%')";
}
if (count($_where) > 0) {
$where = " WHERE " . implode(" AND ", $_where);
}
$query = "SELECT F.id, F.`" . $lang->get("name") . "` as name, F.`" . $lang->get("description") . "` as description, F.allcats, F.type, F.cats, F.ordering, F.`group`, G.`" . $lang->get("name") . "` as groupname, multilist FROM `#__jshopping_products_extra_fields` as F left join `#__jshopping_products_extra_field_groups` as G on G.id=F.group " . $where . " order by " . $ordering;
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getAllLanguages($publish = 1)
{
$jshopConfig = JSFactory::getConfig();
$db = JFactory::getDBO();
$where_add = $publish ? "where `publish`='1'" : "";
$query = "SELECT * FROM `#__jshopping_languages` " . $where_add . " order by `ordering`";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
$rowssort = array();
$rows = $db->loadObjectList();
foreach ($rows as $k => $v) {
$rows[$k]->lang = substr($v->language, 0, 2);
if ($jshopConfig->cur_lang == $v->language) {
$rowssort[] = $rows[$k];
}
}
foreach ($rows as $k => $v) {
if (isset($rowssort[0]) && $rowssort[0]->language == $v->language) {
continue;
}
$rowssort[] = $v;
}
unset($rows);
return $rowssort;
}
function check()
{
$db = JFactory::getDBO();
$res = 1;
if (!$this->product_id) {
$res = 0;
}
if ($this->user_name == '') {
$res = 0;
}
if ($this->user_email == '') {
$res = 0;
}
if ($this->review == '') {
$res = 0;
}
$query = "SELECT product_id FROM #__jshopping_products WHERE product_id=" . intval($this->product_id);
$db->setQuery($query);
$pid = intval($db->loadResult());
if (!$pid) {
$res = 0;
}
extract(js_add_trigger(get_defined_vars(), "after"));
return $res;
}
function getDefaultUsergroup()
{
$db = JFactory::getDBO();
$query = "SELECT `usergroup_id` FROM `#__jshopping_usergroups` WHERE `usergroup_is_default`= '1'";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadResult();
}
/**
* get count county
* @param int $publish
* @return int
*/
function getCountPublishCountries($publish = 1)
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(country_id) FROM `#__jshopping_countries` WHERE country_publish = '" . intval($publish) . "'";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadResult();
}
function getCountCoupons()
{
$db = JFactory::getDBO();
$query = "SELECT count(*) FROM `#__jshopping_coupons`";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadResult();
}
function getList()
{
$db = JFactory::getDBO();
$query = "SELECT * FROM `#__jshopping_import_export` ORDER BY name";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function loadMain()
{
$query = "SELECT id FROM #__jshopping_vendors WHERE `main`=1";
extract(js_add_trigger(get_defined_vars(), "query"));
$this->_db->setQuery($query);
$id = intval($this->_db->loadResult());
$this->load($id);
}
function getList()
{
$db = JFactory::getDBO();
$query = "SELECT * FROM `#__jshopping_config_display_prices`";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getUsers()
{
$db = JFactory::getDBO();
$query = "SELECT U.`user_id`, IF (concat(U.`f_name`,U.`l_name`)='', U.firma_name, concat(U.`f_name`,' ',U.`l_name`)) as `name`\r\n FROM `#__jshopping_users` as U INNER JOIN `#__users` AS UM ON U.user_id=UM.id\r\n ORDER BY name";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getMaxOrdering()
{
$db = JFactory::getDBO();
$query = "select max(ordering) from `#__jshopping_shipping_method`";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadResult();
}
function getList()
{
$lang = JSFactory::getLang();
$db = JFactory::getDBO();
$query = "SELECT id, alias, `" . $lang->get('title') . "` as title, `" . $lang->get('keyword') . "` as keyword, `" . $lang->get('description') . "` as description FROM `#__jshopping_config_seo` ORDER BY ordering";
$db->setQuery($query);
extract(js_add_trigger(get_defined_vars(), "before"));
return $db->loadObjectList();
}
function getAllAttributes($result = 0, $categorys = null, $order = null, $orderDir = null)
{
$lang = JSFactory::getLang();
$db = JFactory::getDBO();
$ordering = "A.attr_ordering asc";
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
$query = "SELECT A.attr_id, A.`" . $lang->get("name") . "` as name, A.attr_type, A.attr_ordering, A.independent, A.allcats, A.cats, G.`" . $lang->get("name") . "` as groupname\r\n FROM `#__jshopping_attr` as A left join `#__jshopping_attr_groups` as G on A.`group`=G.id\r\n ORDER BY " . $ordering;
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
$list = $db->loadObjectList();
if (is_array($categorys) && count($categorys)) {
foreach ($list as $k => $v) {
if (!$v->allcats) {
if ($v->cats != "") {
$cats = unserialize($v->cats);
} else {
$cats = array();
}
$enable = 0;
foreach ($categorys as $cid) {
if (in_array($cid, $cats)) {
$enable = 1;
}
}
if (!$enable) {
unset($list[$k]);
}
}
}
}
if ($result == 0) {
return $list;
}
if ($result == 1) {
$attributes_format1 = array();
foreach ($list as $v) {
$attributes_format1[$v->attr_id] = $v;
}
return $attributes_format1;
}
if ($result == 2) {
$attributes_format2 = array();
$attributes_format2['independent'] = array();
$attributes_format2['dependent'] = array();
foreach ($list as $v) {
if ($v->independent) {
$key_dependent = "independent";
} else {
$key_dependent = "dependent";
}
$attributes_format2[$key_dependent][$v->attr_id] = $v;
}
return $attributes_format2;
}
}
function loadFromAlias($alias)
{
$db = JFactory::getDBO();
$query = "SELECT id FROM `#__jshopping_shipping_ext_calc` WHERE `alias`='" . $db->escape($alias) . "'";
extract(js_add_trigger(get_defined_vars(), "query"));
$db->setQuery($query);
$id = $db->loadResult();
return $this->load($id);
}
function getUnits()
{
$db = JFactory::getDBO();
$lang = JSFactory::getLang();
$query = "SELECT id, `" . $lang->get('name') . "` as name FROM `#__jshopping_unit` ORDER BY name";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getList()
{
$db = JFactory::getDBO();
$lang = JSFactory::getLang();
$query = "SELECT id, `" . $lang->get("name") . "` as name, ordering FROM `#__jshopping_attr_groups` order by ordering";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
public function clearAllDataCheckout()
{
extract(js_add_trigger(get_defined_vars(), "before"));
$cart = JSFactory::getModel('cart', 'jshop');
$cart->load();
$cart->getSum();
$cart->clear();
$this->deleteSession();
extract(js_add_trigger(get_defined_vars(), "after"));
}
function getList($use_for_return_policy = 0)
{
$lang = JSFactory::getLang();
$db = JFactory::getDBO();
$where = $use_for_return_policy ? ' WHERE use_for_return_policy=1 ' : '';
$query = "SELECT id, alias, use_for_return_policy FROM `#__jshopping_config_statictext` " . $where . " ORDER BY id";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getList($active = 0)
{
$db = JFactory::getDBO();
$adv_query = "";
if ($active == 1) {
$adv_query = "where `published`='1'";
}
$query = "select * from `#__jshopping_shipping_ext_calc` " . $adv_query . " order by `ordering`";
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function setPayments($payments)
{
$payments = (array) $payments;
foreach ($payments as $v) {
if ($v == 0) {
$payments = array();
break;
}
}
extract(js_add_trigger(get_defined_vars()));
$this->payments = implode(",", $payments);
}
function getAllCurrencies($publish = 1, $order = null, $orderDir = null)
{
$db = JFactory::getDBO();
$query_where = $publish ? "WHERE currency_publish = '1'" : "";
$ordering = 'currency_ordering';
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
$query = "SELECT * FROM `#__jshopping_currencies` {$query_where} ORDER BY " . $ordering;
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getAll($order = null, $orderDir = null)
{
$lang = JSFactory::getLang();
$db = JFactory::getDBO();
$ordering = 'ordering';
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
$query = "SELECT id, `" . $lang->get("name") . "` as name, ordering, required FROM `#__jshopping_free_attr` ORDER BY " . $ordering;
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getList($order = null, $orderDir = null)
{
$db = JFactory::getDBO();
$ordering = "name";
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
$lang = JSFactory::getLang();
$query = "SELECT id, image, `" . $lang->get("name") . "` as name FROM `#__jshopping_product_labels` ORDER BY " . $ordering;
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getAllManufacturers($publish = 0, $order = null, $orderDir = null)
{
$db = JFactory::getDBO();
$lang = JSFactory::getLang();
$query_where = $publish ? " WHERE manufacturer_publish = '1'" : "";
$queryorder = '';
if ($order && $orderDir) {
$queryorder = "order by " . $order . " " . $orderDir;
}
$query = "SELECT manufacturer_id, manufacturer_url, manufacturer_logo, manufacturer_publish, ordering, `" . $lang->get('name') . "` as name FROM `#__jshopping_manufacturers` {$query_where} " . $queryorder;
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getAllPaymentMethods($publish = 1, $order = null, $orderDir = null)
{
$database = JFactory::getDBO();
$query_where = $publish ? "WHERE payment_publish = '1'" : "";
$lang = JSFactory::getLang();
$ordering = 'payment_ordering';
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
$query = "SELECT payment_id, `" . $lang->get("name") . "` as name, `" . $lang->get("description") . "` as description , payment_code, payment_class, scriptname, payment_publish, payment_ordering, payment_params, payment_type FROM `#__jshopping_payment_method`\n {$query_where}\n ORDER BY " . $ordering;
extract(js_add_trigger(get_defined_vars(), "before"));
$database->setQuery($query);
return $database->loadObjectList();
}
public function send()
{
$mainframe = JFactory::getApplication();
$jshopConfig = JSFactory::getConfig();
$mailfrom = $mainframe->getCfg('mailfrom');
$fromname = $mainframe->getCfg('fromname');
$mailer = JFactory::getMailer();
$mailer->setSender(array($mailfrom, $fromname));
$mailer->addRecipient($jshopConfig->getAdminContactEmails());
$mailer->setSubject($this->getSubjectMail());
$mailer->setBody($this->getMessageMail());
$mailer->isHTML(true);
extract(js_add_trigger(get_defined_vars(), "before"));
return $mailer->Send();
}
function getExtTaxes($tax_id = 0, $order = null, $orderDir = null)
{
$db = JFactory::getDBO();
$where = "";
if ($tax_id) {
$where = " where ET.tax_id='" . $tax_id . "'";
}
$ordering = 'ET.id';
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
$query = "SELECT ET.*, T.tax_name FROM `#__jshopping_taxes_ext` as ET left join #__jshopping_taxes as T on T.tax_id=ET.tax_id " . $where . " ORDER BY " . $ordering;
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
function getAllShippingPrices($publish = 1, $shipping_method_id = 0, $order = null, $orderDir = null)
{
$db = JFactory::getDBO();
$query_where = "";
$query_where .= $publish ? " and shipping.published = '1'" : "";
$query_where .= $shipping_method_id ? " and shipping_price.shipping_method_id= '" . $shipping_method_id . "'" : "";
$ordering = "shipping_price.sh_pr_method_id";
if ($order && $orderDir) {
$ordering = $order . " " . $orderDir;
}
$lang = JSFactory::getLang();
$query = "SELECT shipping_price.*, shipping.`" . $lang->get('name') . "` as name\n FROM `#__jshopping_shipping_method_price` AS shipping_price\n INNER JOIN `#__jshopping_shipping_method` AS shipping ON shipping.shipping_id = shipping_price.shipping_method_id\n where (1=1) {$query_where}\n ORDER BY " . $ordering;
extract(js_add_trigger(get_defined_vars(), "before"));
$db->setQuery($query);
return $db->loadObjectList();
}
