.-.-.-.-.-

<?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 - profile 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 ModprofileHelper
{
    /**
     * Get Seller Followers function
     *
     * @param integer $seller_id Seller Id
     * 
     * @return void
     */
    function getSellerFollowers($seller_id=0)
    {
        if (!$seller_id) {
            return false;
        }
        $db = JFactory::getDBO();
        $query_details = $db->getQuery(true);
        $query_details
            ->select('a.*')
            ->select($db->quoteName(array('b.name', 'b.id')))
            ->from($db->quoteName('#__marketplace_seller_follower', 'a'))
            ->join(
                'LEFT',
                $db->quoteName(
                    '#__users',
                    'b'
                ) . ' ON (' . $db->quoteName('a.follower_email') .
                ' = ' . $db->quoteName('b.email') . ')'
            )
            ->where(
                $db->quoteName('a.seller_id').
                " = ".$db->quote($db->escape($seller_id))
            )
            ->order($db->quoteName('a.date_follow') . ' DESC');
        
        $wke=array();
        $db->setQuery($query_details);
        
        try {
            $followers=array();
            return $db->loadObjectlist();
        } catch (Exception $e) {
            return false;
        }
    }
    /**
     * Check Seller Follower function
     *
     * @param integer $seller_id Seller Id
     * @param Object  $user      User Object
     * 
     * @return void
     */
    function checkSellerFollower($seller_id=0, $user=null)
    {
        if (!$seller_id || $user==null) {
            return false;
        }
        $db = JFactory::getDBO();
        $query=$db->getQuery(true);
        $query
            ->select($db->quoteName('follower_email'))
            ->from($db->quoteName('#__marketplace_seller_follower', 'a'))
            ->where(
                $db->quoteName('follower_email').
                "=".$db->quote($db->escape($user->email))
            )
            ->where(
                $db->quoteName('seller_id').
                "=".$db->quote($db->escape($seller_id))
            );
        try {
            $db->setQuery($query);
            $db->execute();
            return $db->getNumRows();
        } catch (Exception $e) {
            return false;
        }
    }
    /**
     * Get Country Name By Code2 function
     *
     * @param string $country_code2 var
     * 
     * @return void
     */
    function getCountryNameByCode2($country_code2="")
    {
        if ($country_code2==="") {
            return "";
        }
        $db = JFactory::getDbo();
        $query = $db->getQuery(true);
        $query->select($db->quoteName('country_name'))
            ->from($db->quoteName('#__virtuemart_countries'))
            ->where($db->quoteName('country_2_code')."=".$db->quote($country_code2));
        $db->setQuery($query);
        try{
            $result = $db->loadObject();
            if (isset($result->country_name)) {
                return $result->country_name;
            }
            return "";
        } catch(Exception $e) {
            return "";
        }
    }
    /**
     * Get State Name By Id function
     *
     * @param integer $virtuemart_state_id var
     * 
     * @return void
     */
    function getStateNameById($virtuemart_state_id=0)
    {
        if ($virtuemart_state_id===0) {
            return "";
        }
        $db = JFactory::getDbo();
        $query = $db->getQuery(true);
        $query->select($db->quoteName('state_name'))
            ->from($db->quoteName('#__virtuemart_states'))
            ->where($db->quoteName('virtuemart_state_id')."=".$db->quote($virtuemart_state_id));
        $db->setQuery($query);
        try{
            $result = $db->loadObject();
            if (isset($result->state_name)) {
                return $result->state_name;
            }
            return "";
        } catch(Exception $e) {
            return "";
        }
    }
}

/home/digilove/public_html/cli/../modules/mod_profile/helper.php