File manager

File manager - Edit - /home/jardides/www/Jardi-design/j37/plugins/sliderck/hikashop/helper/helper_hikashop.php

Back
<?php /** * @name Slider CK * @package com_sliderck * @copyright Copyright (C) 2016. All rights reserved. * @license GNU General Public License version 2 or later; see LICENSE.txt * @author Cedric Keiflin - http://www.template-creator.com - http://www.joomlack.fr / // No direct access defined('_JEXEC') or die; /* * Helper Class. / class SliderckHelpersourceHikashop { private static $params; / * Get the items from the source */ public static function getItems($params) { if (empty(self::$params)) { self:$params = $params; } // load the items $products = self::loadItems($params);global $Itemid; if (!$products) return false; // load the hikashop config class $configClass = hikashop_get('class.config'); $uploadfoler = $configClass->get('uploadfolder', 'media/com_hikashop/upload/'); // load the hikashop product class $productClass = hikashop_get('class.product'); $items = array(); global $Itemid; foreach ($products as $i => $product) { if (!empty($product->file_path)) { $slideItem = modSliderckHelper::initItem(); // $item->path = JUri::root(true) . '/' . trim($uploadfoler, '/') . '/' . $product->file_path; $slideItem->path = trim($uploadfoler, '/') . '/' . $product->file_path; } else { unset($items[$i]); continue; } $productClass->addAlias($product); $url_itemid = $params->get( 'hikashopitemid', 0 ) ? $params->get( 'hikashopitemid', 0 ) : $Itemid; $url_itemid = empty($url_itemid) ? '' : '&Itemid=' . $url_itemid; $slideItem->link = hikashop_contentLink('&ctrl=product&task=show&cid=' . $product->product_id . '&name=' . $product->alias . $url_itemid, $product); $price = ''; if (!empty($product->price_value) && (bool)$params->get( 'sliderckhikashop_showprice', 0 )) { $currency = hikashop_get('class.currency'); $price = $currency->format($product->price_value, hikashop_getCurrency()); } // $description = modSlideshowckHelper::truncate($item->product_description, '150'); $slideItem->desc = $product->product_description; $slideItem->title = $product->product_name; if ($price) $slideItem->more[] = '<div class="swiper-price">' . $price . '</div>'; $items[] = $slideItem; } return $items; } private static function loadItems($params) { if(!defined('DS')) define('DS', DIRECTORY_SEPARATOR); if(!include_once(rtrim(JPATH_ADMINISTRATOR,DS).DS.'components'.DS.'com_hikashop'.DS.'helpers'.DS.'helper.php')){ echo 'This module can not work without the Hikashop Component'; return; } // Setting $max_items = $params->get( 'numberslides', 0 ); //maximum number of items to display $category_id = $params->get( 'sliderckhikashop_category', null ); // Display products from this category only $filter_category = (bool)$params->get( 'sliderckhikashop_filtercategory', 0 ); // Filter the category $show_price = (bool)$params->get( 'sliderckhikashop_showprice', 0 ); // Display the Product Price? $product_group = $params->get( 'sliderckhikashop_product_group', 'featured'); // Choose which products to display $db = JFactory::getDBO(); if ($filter_category) { $querycategory = " AND #__hikashop_product_category.category_id = ' " . $category_id . "'"; } else { $querycategory = ""; } if ($show_price) { $selectprice = ", price_value, currency_symbol"; $queryprice = " LEFT OUTER JOIN #__hikashop_price" . " ON #__hikashop_price.price_product_id = #__hikashop_product.product_id" . " RIGHT OUTER JOIN #__hikashop_currency" . " ON #__hikashop_price.price_currency_id = #__hikashop_currency.currency_id"; } else { $selectprice = ""; $queryprice = ""; } if ($product_group == 'latest') { $queryorder = " ORDER BY product_created DESC"; } else if ($product_group == 'random') { $queryorder = " ORDER BY RAND()"; } else if ($product_group == 'topten') { $queryorder = " ORDER BY product_sales DESC"; } else if ($product_group == 'mostviewed') { $queryorder = " ORDER BY product_hit DESC"; } else { $queryorder = " ORDER BY ordering ASC"; } $querylimit = $max_items > 0 ? " LIMIT 0, " . $max_items : ""; $query = "SELECT ordering, product_published, #__hikashop_product.product_id, category_id, product_hit, product_created, product_sales, product_sale_start, product_sale_end, product_name, product_description, file_path" . $selectprice . " FROM #__hikashop_product_category" . " RIGHT OUTER JOIN #__hikashop_product" . " ON #__hikashop_product_category.product_id = #__hikashop_product.product_id" . " RIGHT OUTER JOIN #__hikashop_file" . " ON #__hikashop_file.file_ref_id = #__hikashop_product.product_id" . $queryprice . " WHERE #__hikashop_product.product_published = 1" . " AND #__hikashop_product.product_type = 'main'" . $querycategory . " AND ( ('" . time() . "' >= #__hikashop_product.product_sale_start OR #__hikashop_product.product_sale_start = '0' )" . " AND (#__hikashop_product.product_sale_end > '" . time() . "' OR #__hikashop_product.product_sale_end = '0') )" . " GROUP BY product_id" . $queryorder . $querylimit; $db->setQuery($query); if ($db->query()) { $products = $db->loadObjectList(); } else { echo '<p style="color:red;font-weight:bold;">Error loading SQL data : loading the hikashop products in Slideshow CK</p>'; return false; } if(empty($products)) return false; return $products; } }

| ver. 1.4 | Github | . | PHP 7.4.33 | Generation time: 0.01 | proxy | phpinfo | Settings