<?php

/**
 * @version     2.1.6
 * @package     com_itemrating
 * @copyright   Copyright (C) 2014. All rights reserved.
 * @license     GNU General Public License version 2 or later; see LICENSE.txt
 * @author      Joomunited <contact@joomunited.com> - www.joomunited.com
 */
// No direct access
defined('_JEXEC') or die;

/**
 * Itemrating helper.
 */
class ItemratingBackendHelper {
	
	
	protected static $actions;

    /**
     * Configure the Linkbar.
     */
    public static function addSubmenu($vName = '') {
        		JHtmlSidebar::addEntry(
			JText::_('COM_ITEMRATING_TITLE_ITEMS'),
			'index.php?option=com_itemrating&view=items',
			$vName == 'items'
		);
			JHtmlSidebar::addEntry(
			JText::_('COM_ITEMRATING_TITLE_GROUPS'),
			'index.php?option=com_itemrating&view=groups',
			$vName == 'groups'
		);
			JHtmlSidebar::addEntry(
			JText::_('COM_ITEMRATING_TITLE_REPORTS'),
			'index.php?option=com_itemrating&view=reports',
			$vName == 'reports'
		);

    }

    /**
     * Gets a list of the actions that can be performed.
     *
     * @return	JObject
     * @since	1.6
     */
    public static function getActions() {
        if (empty(self::$actions))
		{
			$user = JFactory::getUser();
			self::$actions = new JObject;

			$actions = JHelperContent::getActions('com_itemrating');

			foreach ($actions as $name=>$action)
			{
				self::$actions->set($name, $user->authorise($name, 'com_itemrating'));
			}
		}

		return self::$actions;
    }
	 public static function getSyncButton() {
			
	  $db = JFactory::getDBO();
	$query = $db->getQuery(true);
        $query->select('count(*)');
        $query->from('#__itemrating_itemdata as r');
		$query->join('LEFT','#__itemrating_item as i ON r.rating_id = i.id');
        $query->where('r.rating_value=""');
		$query->where('i.type!=0');
	  	try{
	  $db->setQuery($query);
		}catch (Exception $e)
		{
			echo $e->getMessage();
            exit;
        }
      $count = $db->loadResult();
		if($count!=0)
		{
			$html="<a href='index.php?option=com_itemrating&task=sync' class='btn btn-primary'>Click here</a> to Sync the data";
			JFactory::getApplication()->enqueueMessage($html, 'error');
		}
		return ;
	 }
	  public static function loadLanguage() {
            $lang = JFactory::getLanguage();
            $lang->load('com_itemrating',JPATH_ADMINISTRATOR.'/components/com_itemrating',null, true);
            $lang->load('com_itemrating.override',JPATH_ADMINISTRATOR.'/components/com_itemrating',null, true );
            $lang->load('com_itemrating.sys',JPATH_ADMINISTRATOR.'/components/com_itemrating',null, true );
        }
		public static function checkCms()
			{
       if (version_compare(JVERSION, '4.0', 'ge'))
				{
					return true;
                }
            else
            {
            return false;
            }
        
        }
}