.-.-.-.-.-

<?php
/**
 * Marketplace Menus module
 *
 * PHP version 7.0
 *
 * @category   Module
 * @package    Joomla
 * @author     WebKul software private limited <support@webkul.com>
 * @copyright  2010 WebKul software private limited
 * @license    http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
 * @version    GIT:5.2
 * @filesource http://store.webkul.com
 * @link       Technical Support:  webkul.uvdesk.com
 */

// no direct access
defined('_JEXEC') or die();

/**
 * Webkul - shop Helper Class.
 * 
 * @category Module
 * @package  Joomla
 * @author   WebKul software private limited <support@webkul.com>
 * @license  http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
 * @link     Technical Support:  webkul.uvdesk.com
 */
class ModShopHelper
{
    /**
     * Get Seller Info function
     *
     * @param [type] $seller_id Sller Id
     * 
     * @return void
     */
    function getSellerInfo($seller_id)
    {
        $db = JFactory::getDbo();
        $query=$db->getQuery(true);
        $query->select('*')
            ->from($db->quoteName('#__marketplace_sellerprofile'))
            ->where(
                $db->quoteName('seller_id').
                "=".$db->quote($db->escape($seller_id))
            );
        try{
            $db->setQuery($query);
            return $db->loadObject();
        }
        catch(Exception $e){
            return false;
        }
    }
    /**
     * Seller Products function
     
     * @param integer $seller_id Seller Id
     * @param string  $lang_tag  Language tag table
     * 
     * @return void
     */
    function sellerProducts($seller_id=0, $lang_tag="en_gb")
    {
        if (!$seller_id) {
            return false;
        }
        $db = JFactory::getDbo();
        $query=$db->getQuery(true);
        $query->select($db->quoteName('b.virtuemart_product_id'))
            ->from($db->quoteName('#__virtuemart_products', 'b'))
            ->join(
                'LEFT',
                $db->quoteName('#__virtuemart_products_'.$lang_tag, 'e')." ON ".
                $db->quoteName('e.virtuemart_product_id')."=".
                $db->quoteName('b.virtuemart_product_id')
            )
            ->join(
                "LEFT",
                $db->quoteName('#__virtuemart_product_prices', 'g')." ON ".
                $db->quoteName('g.virtuemart_product_id')."=".
                $db->quoteName('b.virtuemart_product_id')
            )
            ->join(
                "LEFT",
                $db->quoteName('#__virtuemart_product_medias', 'vpm')." ON ".
                $db->quoteName('vpm.virtuemart_product_id')."=".
                $db->quoteName('b.virtuemart_product_id')
            )
            ->join(
                "LEFT",
                $db->quoteName('#__virtuemart_medias', 'vm')." ON ".
                $db->quoteName('vm.virtuemart_media_id')."=".
                $db->quoteName('vpm.virtuemart_media_id')
            )
            ->join(
                'LEFT',
                $db->quoteName('#__virtuemart_ratings', 'f')." ON ".
                $db->quoteName('b.virtuemart_product_id')."=".
                $db->quoteName('f.virtuemart_product_id')
            )
            ->where(
                $db->quoteName('b.created_by')."=".
                $db->quote($db->escape($seller_id)).""
            )
            ->where($db->quoteName('b.published')."=1")
            ->group($db->quoteName('b.virtuemart_product_id'))
            ->order($db->quoteName('b.created_on').' DESC');
            
        try {
            $db->setQuery($query);
            return $db->loadObjectList();
        } catch (Exception $e) {
            return false;
        }
    }
    /**
     * Get Seller Orders function
     *
     * @param integer $seller_id var
     * 
     * @return array
     */
    function getSellerOrders($seller_id = 0)
    {
        $db = JFactory::getDbo();
        $query=$db->getQuery(true);
        $query->select($db->quoteName('vo.virtuemart_order_id'))
            ->from($db->quoteName('#__marketplace_orderlist', 'mo'))
            ->join(
                'LEFT',
                $db->quoteName('#__virtuemart_orders', 'vo')." ON ".
                $db->quoteName('vo.virtuemart_order_id')."=".
                $db->quoteName('mo.virtuemart_order_id')
            )
            ->where(
                $db->quoteName('mo.virtuemart_seller_id').
                "=".$db->quote($db->escape($seller_id))
            )
            ->group($db->quoteName('vo.virtuemart_order_id'));
        try {
            $db->setQuery($query);
            return $db->loadObjectlist();
        } catch (Exception $e) {
            return array();
        }
    }
    /**
     * Get Seller Feedback function
     *
     * @param integer $seller_id var
     * 
     * @return void
     */
    function getSellerFeedback($seller_id=0)
    {
        $db = JFactory::getDbo();
        $query = $db->getQuery(true);
        $query->select('*')
            ->from($db->quoteName('#__marketplace_feedback'))
            ->where(
                $db->quoteName('seller_id')."=".$db->quote($db->escape($seller_id))
            )
            ->where($db->quoteName('status')."= 1");
        $db->setQuery($query);
        try{ 
            return $db->loadObjectlist();
        }
        catch(Exception $e){
            return array();
        }
    }
}

/home/digilove/public_html/f7525/../modules/mod_shop/helper.php