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(); }