.-.-.-.-.-

<?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();
if (!class_exists('VmConfig')) {
    include JPATH_ADMINISTRATOR.'/components/com_virtuemart/helpers/config.php';
}

/**
 * Webkul - sellercategory 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 ModSellerCategoryHelper
{
    /**
     * Get Vm Categories function
     *
     * @return array
     */
    function getVmCategories()
    {
        VmConfig::loadConfig();
        $lang_tag=VmConfig::$vmlang;
        $db = JFactory::getDBO();
        $query=$db->getQuery(true);
        $query->select($db->quoteName('ceg.category_name'));
        $query->select($db->quoteName('ceg.virtuemart_category_id'));
        $query->from($db->quoteName('#__virtuemart_categories_'.$lang_tag, 'ceg'));
        $query->join(
            'LEFT',
            $db->quoteName('#__virtuemart_categories', 'vc')." ON "
            .$db->quoteName('vc.virtuemart_category_id')."=".
            $db->quoteName('ceg.virtuemart_category_id')
        );
        $query->join(
            "LEFT",
            $db->quoteName('#__virtuemart_product_categories', 'vpc').
            " ON ".$db->quoteName('vpc.virtuemart_category_id')."="
            .$db->quoteName('ceg.virtuemart_category_id')
        );
        $query->where($db->quoteName('vc.published')."=".$db->quote('1'));
        $query->group($db->quoteName('ceg.category_name'));
        try {
            $db->setQuery($query);
            return $db->loadObjectlist();
        }
        catch(Exception $e){
            return array();
        }
    }
    /**
     * Virtuemart Categories Seller Product function
     *
     * @param integer $virtuemart_category_id Category Id
     * @param integer $seller_id              Seller Id
     * 
     * @return array
     */
    function virtuemartCategoriesProduct($virtuemart_category_id=0, $seller_id=0)
    {
        $db = JFactory::getDBO();
        $query=$db->getQuery(true);
        $query->select($db->quoteName('vp.virtuemart_product_id'));
        $query->from($db->quoteName('#__virtuemart_products', 'vp'));
        $query->join(
            'LEFT',
            $db->quoteName('#__virtuemart_product_categories', 'vpc')." ON "
            .$db->quoteName('vpc.virtuemart_product_id')."="
            .$db->quoteName('vp.virtuemart_product_id')
        );
        $query->where(
            $db->quoteName('vpc.virtuemart_category_id').
            "=".$db->quote($db->escape($virtuemart_category_id))
        );
        $query->where(
            $db->quoteName('vp.created_by').
            "=".$db->quote($db->escape($seller_id))
        );
        $query->where($db->quoteName('vp.published')."=".$db->quote('1'));
        try {
            $db->setQuery($query);
            return $db->loadObjectlist();
        } catch (Exception $e) {
            return array();
        }
    }
}

/home/digilove/public_html/modules/mod_feed/../mod_sellercategory/helper.php