.-.-.-.-.-

<?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 - Seller view module 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 ModSellerViewHelper
{
    /**
     * Get Sellers function
     *
     * @return void
     */
    function getSellers()
    {
        $db = JFactory::getDBO();
        $query=$db->getQuery(true);
        $query->select('m.screenname');
        $query->select('m.companyname');
        $query->select('m.seller_id');
        $query->select('m.companylogo');
        $query->select('m.companylocality');
        $query->from($db->quoteName('#__marketplace_sellerprofile', 'm'));
        $query->join(
            'INNER',
            $db->quoteName('#__users', 'u')." ON ".
            $db->quoteName('m.seller_id')."=".$db->quoteName('u.id')
        );
        $query->where($db->quoteName('m.is_seller')."=".$db->quote('1'));
        $query->group($db->quoteName('u.id'));
        $db->setQuery($query);
        try{ 
            return $db->loadAssoclist();
        }
        catch(Exception $e){
            return false;
        }
    }
}

/home/digilove/public_html/f7525/../modules/mod_acymailing/../mod_sellerview/helper.php