/com_joomleague/administrator/components/com_joomleague/statistics/complexsumpergame.php

<?php

/**

 * @copyright	Copyright (C) 2006-2014 joomleague.at. All rights reserved.

 * @license		GNU/GPL, see LICENSE.php

 * Joomla! is free software. This version may have been modified pursuant

 * to the GNU General Public License, and as distributed it includes or

 * is derivative of works licensed under the GNU General Public License or

 * other free or open source software licenses.

 * See COPYRIGHT.php for copyright notices and details.

 */



// Check to ensure this file is included in Joomla!

defined( '_JEXEC' ) or die( 'Restricted access' );



require_once(JLG_PATH_ADMIN.DS.'statistics'.DS.'base.php');



/**

 * base class for statistics handling.

 *

 * @package Joomla

 * @subpackage Joomleague

 * @since 0.9

 */

class JLGStatisticComplexsumpergame extends JLGStatistic {

//also the name of the associated xml file	

	var $_name = 'complexsumpergame';

	

	var $_calculated = 1;

	

	var $_showinsinglematchreports = 0;

	

	function __construct()

	{

		parent::__construct();

	}

	

	function getSids()

	{

		$params = &$this->getParams();

		if(!is_array($params->get('stat_ids'))) {

			$stat_ids = explode(',', $params->get('stat_ids'));

		} else {

			$stat_ids = $params->get('stat_ids');

		}

		if (!count($stat_ids)) {

			JError::raiseWarning(0, JText::sprintf('STAT %s/%s WRONG CONFIGURATION', $this->_name, $this->id));

			return(array(0));

		}

				

		$sids = array();

		foreach ($stat_ids as $s) {

			$sids[] = (int)$s;

		}		

		return $sids;

	}

	

	function getFactors()

	{

		$params  = &$this->getParams();

		$factors = explode(',', $params->get('factors'));

		$stat_ids = $this->getSids();

		

		if (count($stat_ids) != count($factors)) {

			JError::raiseWarning(0, JText::sprintf('STAT %s/%s WRONG CONFIGURATION - BAD FACTORS COUNT', $this->_name, $this->id));

			return(array(0));

		}

				

		$sids = array();

		foreach ($factors as $s) {

			$sids[] = (float)$s;

		}		

		return $sids;

	}

	

	

	function getQuotedSids()

	{

		$params = &$this->getParams();

		if(!is_array($params->get('stat_ids'))) {

			$stat_ids = explode(',', $params->get('stat_ids'));

		} else {

			$stat_ids = $params->get('stat_ids');

		}

		if (!count($stat_ids)) {

			JError::raiseWarning(0, JText::sprintf('STAT %s/%s WRONG CONFIGURATION', $this->_name, $this->id));

			return(array(0));

		}

				

		$db = JFactory::getDbo();

		$sids = array();

		foreach ($stat_ids as $s) {

			$sids[] = $db->Quote($s);

		}		

		return $sids;

	}



	function getPlayerStatsByProject($person_id, $projectteam_id = 0, $project_id = 0, $sports_type_id = 0)

	{

		$sids = $this->getSids();

		$factors = $this->getFactors();

		

		$num = $this->getPlayerStatsByProjectForIds($person_id, $projectteam_id, $project_id, $sports_type_id, $sids, $factors);

		$den = $this->getGamesPlayedByPlayer($person_id, $projectteam_id, $project_id, $sports_type_id);

		return $this->formatValue($num, $den, $this->getPrecision());

	}



	/**

	 * Get players stats

	 * @param $team_id

	 * @param $project_id

	 * @param $position_id

	 * @return array

	 */

	function getRosterStats($team_id, $project_id, $position_id)

	{

		$sids = $this->getSids();

		$factors  = $this->getFactors();

		$num = $this->getRosterStatsForIds($team_id, $project_id, $position_id, $sids, $factors);

		$den = $this->getGamesPlayedByProjectTeam($team_id, $project_id, $position_id);



		$precision = $this->getPrecision();

		$res = array();

		foreach (array_unique(array_merge(array_keys($num), array_keys($den))) as $person_id) 

		{

			$res[$person_id] = new stdclass();

			$res[$person_id]->person_id = $person_id;

			$n = isset($num[$person_id]->value) ? $num[$person_id]->value : 0;

			$d = isset($den[$person_id]->value) ? $den[$person_id]->value : 0;

			$res[$person_id]->value = $this->formatValue($n, $d, $precision);

		}

		return $res;

	}



	function getPlayersRanking($project_id, $division_id, $team_id, $limit = 20, $limitstart = 0, $order = null)

	{		

		$sids = $this->getSids();

		$sqids = $this->getQuotedSids();

		$factors  = $this->getFactors();

		

		$db = JFactory::getDbo();

		

		// get all stats

		$query  = ' SELECT ms.value, ms.statistic_id, tp.id AS tpid'

				. ' FROM #__joomleague_match_statistic AS ms'

				. ' INNER JOIN #__joomleague_team_player AS tp ON ms.teamplayer_id = tp.id'

				. ' INNER JOIN #__joomleague_project_team AS pt ON pt.id = tp.projectteam_id'

				. ' INNER JOIN #__joomleague_match AS m ON m.id = ms.match_id'

				. ' WHERE pt.project_id = '. $db->Quote($project_id);

		if ($division_id != 0)

		{

			$query .= ' AND pt.division_id = '. $db->Quote($division_id);

		}

		if ($team_id != 0)

		{

			$query .= '   AND pt.team_id = ' . $db->Quote($team_id);

		}

		$query .= '   AND ms.statistic_id IN ('. implode(',', $sqids) .')'

				. '   AND m.published = 1';



		$db->setQuery($query);

		$stats = $db->loadObjectList();

		

		$query = $this->getGamesPlayedQuery($project_id, $division_id, $team_id);



		$db->setQuery($query);

		$gp = $db->loadObjectList('tpid');

		

		// now calculate per player

		$players = array();		

		// first, the numerator complex sum

		foreach ($stats as $stat)

		{

			$key = array_search($stat->statistic_id, $sids);

			if ($key !== FALSE)	{

				@$players[$stat->tpid] += $factors[$key]*$stat->value;

			}

		}

		// then divide by games played

		foreach ($players as $k => $value)

		{

			if (isset($gp[$k]) && $gp[$k]->played) {

				$players[$k] = $players[$k] / $gp[$k]->played;

			}

			else {

				unset($players[$k]);

			}

		}

		

		// now we reorder

		$order = (!empty($order) ? $order : $this->getParam('ranking_order', 'DESC'));

		if ($order == 'ASC') {

			asort($players);

		}

		else {

			arsort($players);

		}



		$res = new stdclass;

		$res->pagination_total = count($players);



		$players = array_slice($players, $limitstart, $limit, true);

		$ids = array_keys($players);

		

		$query  = ' SELECT tp.id AS teamplayer_id, tp.person_id, tp.picture AS teamplayerpic,'

				. ' p.firstname, p.nickname, p.lastname, p.picture, p.country,'

				. ' pt.team_id, pt.picture AS projectteam_picture, t.picture AS team_picture,'

				. ' t.name AS team_name, t.short_name AS team_short_name'

				. ' FROM #__joomleague_team_player AS tp'

				. ' INNER JOIN #__joomleague_person AS p ON p.id = tp.person_id'

				. ' INNER JOIN #__joomleague_project_team AS pt ON pt.id = tp.projectteam_id'

				. ' INNER JOIN #__joomleague_team AS t ON pt.team_id = t.id'

				. ' WHERE pt.project_id = '. $db->Quote($project_id)

				. '   AND p.published = 1'

				. '   AND tp.id IN ('. implode(',', $ids) .')';

		if ($division_id != 0)

		{

			$query .= ' AND pt.division_id = '. $db->Quote($division_id);

		}

		if ($team_id != 0)

		{

			$query .= '   AND pt.team_id = ' . $db->Quote($team_id);

		}



		$db->setQuery($query);

		$details = $db->loadObjectList('teamplayer_id');



		$res->ranking = array();

		if (!empty($details))

		{

			$precision = $this->getPrecision();

			// get ranks

			$previousval = 0;

			$currentrank = 1 + $limitstart;

			$i = 0;

			foreach ($players as $k => $value) 

			{

				$res->ranking[$i] = $details[$k];

				$res->ranking[$i]->total = $value;



				if ($value == $previousval) {

					$res->ranking[$i]->rank = $currentrank;

				}

				else {

					$res->ranking[$i]->rank = $i + 1 + $limitstart;

				}

				

				$previousval = $value;

				$currentrank = $res->ranking[$i]->rank;



				$res->ranking[$i]->total = $this->formatValue($res->ranking[$i]->total, 1, $precision);



				$i++;

			}

		}

		return $res;

	}



	function getTeamsRanking($project_id, $limit = 20, $limitstart = 0, $order=null)

	{		

		$sids = $this->getSids();

		$sqids = $this->getQuotedSids();

		$factors  = $this->getFactors();

		

		$db = JFactory::getDbo();

	

		// team games

		$query = ' SELECT COUNT(m.id) AS value, pt.team_id '

		       . ' FROM #__joomleague_project_team AS pt '

		       . ' INNER JOIN #__joomleague_match AS m ON m.projectteam1_id = pt.id OR m.projectteam2_id = pt.id'

		       . '   AND m.published = 1 '

		       . '   AND m.team1_result IS NOT NULL '

		       . ' WHERE pt.project_id = '. $db->Quote($project_id)

		       . ' GROUP BY pt.id '

		       ;

		$db->setQuery($query);

		$gp = $db->loadObjectList('team_id');

				

		// get all stats

		$query = ' SELECT ms.value, ms.statistic_id, pt.team_id '

		       . ' FROM #__joomleague_match_statistic AS ms '

		       . ' INNER JOIN #__joomleague_team_player AS tp ON ms.teamplayer_id = tp.id '

		       . ' INNER JOIN #__joomleague_project_team AS pt ON pt.id = tp.projectteam_id '

		       . ' INNER JOIN #__joomleague_match AS m ON m.id = ms.match_id '

		       . ' WHERE pt.project_id = '. $db->Quote($project_id)

		       . '   AND ms.statistic_id IN ('. implode(',', $sqids) .')'

		       . '   AND tp.published = 1 '

		       . '   AND m.published = 1 '

		       ;

		$db->setQuery($query);

		$stats = $db->loadObjectList();

		

		// now calculate per team

		$teams = array();		

		foreach ($stats as $stat)

		{

			$key = array_search($stat->statistic_id, $sids);

			if ($key !== FALSE)	{

				@$teams[$stat->team_id] += $factors[$key]*$stat->value;

			}

		}

		// then divide by games played

		foreach ($teams as $k => $value)

		{

			if (isset($gp[$k]) && $gp[$k]->value) {

				$teams[$k] = $teams[$k] / $gp[$k]->value;

			}

			else {

				unset($teams[$k]);

			}

		}

		

		// now we reorder

		$order = (!empty($order) ? $order : $this->getParam('ranking_order', 'DESC'));

		if ($order == 'ASC') {

			asort($teams);

		}

		else {

			arsort($teams);

		}

		

		$teams = array_slice($teams, $limitstart, $limit, true);

		

		$res = array();

		foreach ($teams as $id => $value)

		{

			$obj = new stdclass;

			$obj->team_id = $id;

			$obj->total   = $value;

			$res[] = $obj;

		}



		if (!empty($res))

		{

			$precision = $this->getPrecision();

			// get ranks

			$previousval = 0;

			$currentrank = 1 + $limitstart;

			foreach ($res as $k => $row) 

			{

				if ($row->total == $previousval) {

					$res[$k]->rank = $currentrank;

				}

				else {

					$res[$k]->rank = $k + 1 + $limitstart;

				}

				$previousval = $row->total;

				$currentrank = $res[$k]->rank;



				$res[$k]->total = $this->formatValue($res[$k]->total, 1, $precision);

			}

		}

		return $res;

	}

	

	function getStaffStats($person_id, $team_id, $project_id)

	{

		$sids = $this->getSids();

		$sqids = $this->getQuotedSids();

		$factors  = $this->getFactors();

		

		$db = JFactory::getDbo();

		

		$query = ' SELECT ms.value, ms.statistic_id '

		       . ' FROM #__joomleague_team_staff AS tp '

		       . ' INNER JOIN #__joomleague_project_team AS pt ON pt.id = tp.projectteam_id '

		       . ' INNER JOIN #__joomleague_match_staff_statistic AS ms ON ms.team_staff_id = tp.id '

		       . '   AND ms.statistic_id IN ('. implode(',', $sqids) .')'

		       . ' INNER JOIN #__joomleague_match AS m ON m.id = ms.match_id '

		       . '   AND m.published = 1 '

		       . ' WHERE pt.team_id = '. $db->Quote($team_id)

		       . '   AND pt.project_id = '. $db->Quote($project_id)

		       . '   AND tp.person_id = '. $db->Quote($person_id)

		       ;

		$db->setQuery($query);

		$stats = $db->loadObjectList();

		

		$num = 0;

		foreach ($stats as $stat)

		{

			$key = array_search($stat->statistic_id, $sids);

			if ($key !== FALSE)	{

				$num += $factors[$key]*$stat->value;

			}

		}

		

		//games

		$query = ' SELECT COUNT(ms.id) AS value, tp.person_id '

		       . ' FROM #__joomleague_team_staff AS tp '

		       . ' INNER JOIN #__joomleague_project_team AS pt ON pt.id = tp.projectteam_id '

		       . ' INNER JOIN #__joomleague_match_staff AS ms ON ms.team_staff_id = tp.id '

		       . ' INNER JOIN #__joomleague_match AS m ON m.id = ms.match_id '

		       . '   AND m.published = 1 '

		       . ' WHERE pt.team_id = '. $db->Quote($team_id)

		       . '   AND pt.project_id = '. $db->Quote($project_id)

		       . '   AND tp.person_id = '. $db->Quote($person_id)

		       . ' GROUP BY tp.id '

		       ;

		$db->setQuery($query);

		$den = $db->loadResult();

		

		return $this->formatValue($num, $den, $this->getPrecision());;

	}

	

	function getHistoryStaffStats($person_id)

	{

		$sids = $this->getSids();

		$sqids = $this->getQuotedSids();

		$factors  = $this->getFactors();

		

		$db = JFactory::getDbo();

		

		$query = ' SELECT ms.value AS value, ms.statistic_id '

		       . ' FROM #__joomleague_team_staff AS tp '

		       . ' INNER JOIN #__joomleague_project_team AS pt ON pt.id = tp.projectteam_id '

		       . ' INNER JOIN #__joomleague_project AS p ON p.id = pt.project_id '

		       . ' INNER JOIN #__joomleague_match_staff_statistic AS ms ON ms.team_staff_id = tp.id '

		       . '  AND ms.statistic_id IN ('. implode(',', $sqids) .')'

		       . ' INNER JOIN #__joomleague_match AS m ON m.id = ms.match_id '

		       . '   AND m.published = 1 '

		       . ' WHERE tp.person_id = '. $db->Quote($person_id)

		       . '   AND p.published = 1 '

		       ;

		$db->setQuery($query);

		$stats = $db->loadObjectList();	

		

		$num = 0;

		foreach ($stats as $stat)

		{

			$key = array_search($stat->statistic_id, $sids);

			if ($key !== FALSE)	{

				$num += $factors[$key]*$stat->value;

			}

		}

		

		//games

		$query = ' SELECT COUNT(ms.id) AS value, tp.person_id '

		       . ' FROM #__joomleague_team_staff AS tp '

		       . ' INNER JOIN #__joomleague_project_team AS pt ON pt.id = tp.projectteam_id '

		       . ' INNER JOIN #__joomleague_match_staff AS ms ON ms.team_staff_id = tp.id '

		       . ' INNER JOIN #__joomleague_match AS m ON m.id = ms.match_id '

		       . '   AND m.published = 1 '

		       . ' WHERE tp.person_id = '. $db->Quote($person_id)

		       . ' GROUP BY tp.id '

		       ;

		$db->setQuery($query);

		$den = $db->loadResult();

		

		return $this->formatValue($num, $den, $this->getPrecision());;

	}



	function formatValue($num, $den, $precision)

	{

		$value = (!empty($num) && !empty($den)) ? $num / $den : 0;

		return number_format($value, $precision);

	}

}