/**
* Method to get the list
*
* @access public
* @return array
*/
function getData(&$params)
{
$p = $params->get('p');
$p = explode(":", $p);
$p = $p[0];
$t = $params->get('team');
$t = explode(":", $t);
$t = $t[0];
$db = JFactory::getDbo();
$query = "SELECT tt.id AS id, t.name AS team_name\n\t\t\t\t\tFROM #__joomleague_project_team tt\n\t\t\t\t\tINNER JOIN #__joomleague_team t ON t.id = tt.team_id\n\t\t\t\t\tWHERE tt.project_id = " . $p . "\n\t\t\t\t\tAND tt.team_id = " . $t;
$query .= " LIMIT 1";
$db->setQuery($query);
$result = $db->loadRow();
$projectteamid = $result[0];
$team_name = $result[1];
JRequest::setVar('p', $p);
JRequest::setVar('tid', $t);
JRequest::setVar('ttid', $projectteamid);
if (!class_exists('JoomleagueModelRoster')) {
require_once JLG_PATH_SITE . '/models/roster.php';
}
$model =& JLGModel::getInstance('Roster', 'JoomleagueModel');
$model->setProjectId($p);
$project =& $model->getProject();
$project->team_name = $team_name;
return array('project' => $project, 'roster' => $model->getTeamPlayers());
}
/**
* Method to get the list
*
* @access public
* @return array
*/
function getData(&$params)
{
global $mainframe;
$db =& JFactory::getDbo();
if (!class_exists('JoomleagueModelProject')) {
require_once JLG_PATH_SITE . DS . 'models' . DS . 'project.php';
}
$model =& JLGModel::getInstance('project', 'JoomleagueModel');
$model->setProjectId($params->get('p'));
$stat_id = (int) $params->get('sid');
$project =& $model->getProject();
$stat = current(current($model->getProjectStats($stat_id)));
if (!$stat) {
echo 'Undefined stat';
}
$ranking = $stat->getTeamsRanking($project->id, $params->get('limit'), 0, $params->get('ranking_order', 'DESC'));
if (empty($ranking)) {
return false;
}
$ids = array();
foreach ($ranking as $r) {
$ids[] = $db->Quote($r->team_id);
}
$query = ' SELECT t.*, c.logo_small ' . ' , CASE WHEN CHAR_LENGTH( t.alias ) THEN CONCAT_WS( \':\', t.id, t.alias ) ELSE t.id END AS team_slug ' . ' , CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( \':\', c.id, c.alias ) ELSE c.id END AS club_slug ' . ' FROM #__joomleague_team AS t ' . ' LEFT JOIN #__joomleague_club AS c ON c.id = t.club_id ' . ' WHERE t.id IN (' . implode(',', $ids) . ')';
$db->setQuery($query);
$teams = $db->loadObjectList('id');
return array('project' => $project, 'ranking' => $ranking, 'teams' => $teams, 'stat' => $stat);
}
/**
* Method to get the list
*
* @access public
* @return array
*/
function getData(&$params)
{
global $mainframe;
if (!class_exists('JoomleagueModelRanking')) {
require_once JLG_PATH_SITE . '/models/ranking.php';
}
$model = JLGModel::getInstance('project', 'JoomleagueModel');
$model->setProjectId($params->get('p'));
$project = $model->getProject();
$ranking = JLGRanking::getInstance($project);
$ranking->setProjectId($params->get('p'));
$divisionid = explode(':', $params->get('division_id', 0));
$divisionid = $divisionid[0];
$res = $ranking->getRanking(null, null, $divisionid);
$teams = $model->getTeamsIndexedByPtid();
$list = array();
foreach ($res as $ptid => $t) {
$t->team = $teams[$ptid];
$list[] = $t;
}
if ($params->get('visible_team') != '') {
$exParam = explode(':', $params->get('visible_team'));
$list = modJLGRankingHelper::getShrinkedDataAroundOneTeam($list, $exParam[0], $params->get('limit', 5));
}
$colors = array();
if ($params->get('show_rank_colors', 0)) {
$mdlRanking = JLGModel::getInstance("Ranking", "JoomleagueModel");
$mdlRanking->setProjectid($params->get('p'));
$config = $mdlRanking->getTemplateConfig("ranking");
$colors = $mdlRanking->getColors($config["colors"]);
}
return array('project' => $project, 'ranking' => $list, 'colors' => $colors);
}
/**
* Method to get the list
*
* @access private
* @return array
*/
private function _getData()
{
$mainframe = JFactory::getApplication();
if (!class_exists('JoomleagueModelRanking')) {
require_once JLG_PATH_SITE . DS . 'models' . DS . 'ranking.php';
}
$project_id = (JRequest::getVar('option', '') == 'com_joomleague' and JRequest::getInt('p', 0) > 0 and $this->params->get('usepfromcomponent', 0) == 1) ? JRequest::getInt('p') : $this->params->get('project_ids');
if (is_array($project_id)) {
$project_id = $project_id[0];
}
if ($project_id) {
$model =& JLGModel::getInstance('project', 'JoomleagueModel');
$model->setProjectId($project_id);
$this->project =& $model->getProject();
$ranking =& JLGRanking::getInstance($this->project);
$ranking->setProjectId($project_id);
$divisionid = explode(':', $this->params->get('division_id', 0));
$divisionid = $divisionid[0];
$this->ranking = $ranking->getRanking(null, null, $divisionid);
if ($this->params->get('logotype') == 'logo_small') {
$teams = $model->getTeamsIndexedByPtid();
} else {
unset($model);
if (!class_exists('JoomleagueModelTeams')) {
require_once JLG_PATH_SITE . DS . 'models' . DS . 'teams.php';
}
$model =& JLGModel::getInstance('teams', 'JoomleagueModel');
$model->setProjectId($project_id);
$teams = $model->getTeams($divisionid);
}
$this->buildData($teams);
unset($teams);
unset($model);
}
}
/**
* Method to get the list
*
* @access public
* @return array
*/
function getData(&$params)
{
$usedp = $params->get('projects');
$usedtid = $params->get('teams', '0');
$projectstring = is_array($usedp) ? implode(",", $usedp) : $usedp;
$teamstring = is_array($usedtid) ? implode(",", $usedtid) : $usedtid;
$db = JFactory::getDBO();
$query = "SELECT id\n\t\t\t\t\tFROM #__joomleague_project_team tt WHERE tt.project_id > 0 ";
if ($projectstring != "" && $projectstring > 0) {
$query .= " AND tt.project_id IN (" . $projectstring . ") ";
}
if ($teamstring != "" && $teamstring > 0) {
$query .= " AND tt.team_id IN (" . $teamstring . ") ";
}
$query .= " ORDER BY rand() ";
$query .= " LIMIT 1";
$db->setQuery($query);
$projectteamid = $db->loadResult();
$query = ' SELECT pt.person_id, tt.project_id ' . ' FROM #__joomleague_team_player pt ' . ' INNER JOIN #__joomleague_project_team AS tt ON tt.id = pt.projectteam_id ' . ' WHERE pt.projectteam_id = ' . $projectteamid . ' ORDER BY rand() ' . ' LIMIT 1';
$db->setQuery($query);
$res = $db->loadRow();
JRequest::setVar('p', $res[1]);
JRequest::setVar('pid', $res[0]);
JRequest::setVar('pt', $projectteamid);
if (!class_exists('JoomleagueModelPlayer')) {
require_once JLG_PATH_SITE . DS . 'models' . DS . 'player.php';
}
$mdlPerson =& JLGModel::getInstance('Player', 'JoomleagueModel');
$person =& $mdlPerson->getPerson();
$project =& $mdlPerson->getProject();
$info =& $mdlPerson->getTeamPlayer();
$infoteam =& $mdlPerson->getTeaminfo($projectteamid);
return array('project' => $project, 'player' => $person, 'inprojectinfo' => is_array($info) && count($info) ? $info[0] : $info, 'infoteam' => $infoteam);
}
/**
* Method to get the list
*
* @access public
* @return array
*/
function getData(&$params)
{
if (!class_exists('JoomleagueModelResults')) {
require_once JLG_PATH_SITE . DS . 'models' . DS . 'results.php';
}
$model =& JLGModel::getInstance('Results', 'JoomleagueModel');
$model->setProjectId($params->get('p'));
$project =& $model->getProject();
switch ($params->get('round_selection', 0)) {
case 0:
// latest
$roundid = modJLGResultsHelper::getLatestRoundId($project->id);
break;
case 1:
// next
$roundid = modJLGResultsHelper::getNextRoundId($project->id);
break;
case 2:
//manual
$roundid = (int) $params->get('id') ? (int) $params->get('id') : $model->getCurrentRound();
break;
}
if (!$roundid) {
$roundid = $model->getCurrentRound();
}
$model->set('divisionid', (int) $params->get('division_id'));
$model->set('roundid', $roundid);
$round = modJLGResultsHelper::getRound($project->id, $roundid);
$matches = $model->getMatches();
uasort($matches, array('modJLGResultsHelper', '_cmpDate'));
$matches = array_slice($matches, 0, $params->get('limit', 10));
$teams = $model->getTeamsIndexedByPtid();
return array('project' => $project, 'round' => $round, 'matches' => $matches, 'teams' => $teams);
}
/**
* Overrides method to first lookup into potential extension for the model.
*/
protected function createModel($name, $prefix = '', $config = array())
{
// Clean the model name
$modelName = preg_replace('/[^A-Z0-9_]/i', '', $name);
$classPrefix = preg_replace('/[^A-Z0-9_]/i', '', $prefix);
$result = JLGModel::getInstance($modelName, $classPrefix, $config);
return $result;
}
/**
* Method to get the list
*
* @access public
* @return array
*/
public static function getData(&$params)
{
if (!class_exists('JoomleagueModelSportsType')) {
require_once JLG_PATH_SITE . '/models/sportstype.php';
}
$model = JLGModel::getInstance('sportstype', 'JoomleagueModel');
$model->setId($params->get('sportstypes'));
return array('sportstype' => $model->getData(), 'projectscount' => $model->getProjectsCount(), 'leaguescount' => $model->getLeaguesCount(), 'seasonscount' => $model->getSeasonsCount(), 'projectteamscount' => $model->getProjectTeamsCount(), 'projectteamsplayerscount' => $model->getProjectTeamsPlayersCount(), 'projectdivisionscount' => $model->getProjectDivisionsCount(), 'projectroundscount' => $model->getProjectRoundsCount(), 'projectmatchescount' => $model->getProjectMatchesCount(), 'projectmatcheseventscount' => $model->getProjectMatchesEventsCount(), 'projectmatcheseventnames' => $model->getProjectMatchesEventNames(), 'projectmatchesstatscount' => $model->getProjectMatchesStatsCount());
}
/**
* Method to get the list
*
* @access public
* @return array
*/
function getData(&$params)
{
global $mainframe;
if (!class_exists('JoomleagueModelTeams')) {
require_once JLG_PATH_SITE . DS . 'models' . DS . 'teams.php';
}
$model =& JLGModel::getInstance('teams', 'JoomleagueModel');
$model->setProjectId($params->get('p'));
$project =& $model->getProject();
$division_id = $params->get('division_id');
$division_id = explode(":", $division_id);
$division_id = $division_id[0];
$model->divisionid = $division_id;
return array('project' => $project, 'teams' => $model->getTeams());
}
/**
* Method to get the list
*
* @access public
* @return array
*/
public static function getData(&$params)
{
// @todo check! // 23-07-2015
// we are included model Teams but is it needed?
if (!class_exists('JoomleagueModelTeams')) {
require_once JLG_PATH_SITE . '/models/teams.php';
}
$model = JLGModel::getInstance('teams', 'JoomleagueModel');
$model->setProjectId($params->get('p'));
$project = $model->getProject();
$division_id = $params->get('division_id');
$division_id = explode(":", $division_id);
$division_id = $division_id[0];
$model->divisionid = $division_id;
$data = array('project' => $project, 'teams' => $model->getTeams());
return $data;
}
/**
* Method to get the list
*
* @access public
* @return array
*/
function getData(&$params)
{
if (!class_exists('JoomleagueModelEventsRanking')) {
require_once JLG_PATH_SITE . DS . 'models' . DS . 'eventsranking.php';
}
$model =& JLGModel::getInstance('eventsranking', 'JoomleagueModel');
$model->projectid = modJLGEventsrankingHelper::getId($params, 'p');
$model->divisionid = modJLGEventsrankingHelper::getId($params, 'divisionid');
$model->teamid = modJLGEventsrankingHelper::getId($params, 'tid');
$model->setEventid($params->get('evid'));
$model->matchid = modJLGEventsrankingHelper::getId($params, 'mid');
$model->limit = $params->get('limit');
$model->limitstart = 0;
$project = $model->getProject();
$eventtypes = $model->getEventTypes();
$events = $model->getEventRankings($model->limit, $model->limitstart, $params->get('ranking_order', 'DESC'));
$teams =& $model->getTeamsIndexedById();
return array('project' => $project, 'ranking' => $events, 'eventtypes' => $eventtypes, 'teams' => $teams, 'model' => $model);
}
/**
* Method to get the list
*
* @access public
* @return array
*/
public static function getData(&$params)
{
if (!class_exists('JoomleagueModelStatsranking')) {
require_once JLG_PATH_SITE . '/models/statsranking.php';
}
$divisionid = explode(':', $params->get('division_id', 0));
$divisionid = $divisionid[0];
$model = JLGModel::getInstance('statsranking', 'JoomleagueModel');
$model->setProjectId($params->get('p'));
$model->teamid = (int) $params->get('tid', 0);
$model->setStatid($params->get('sid'));
$model->limit = $params->get('limit');
$model->limitstart = 0;
$model->divisionid = $divisionid;
$project = $model->getProject();
$stattypes = $model->getProjectUniqueStats();
$stats = $model->getPlayersStats($params->get('ranking_order', 'DESC'));
$teams = $model->getTeamsIndexedById();
return array('project' => $project, 'ranking' => $stats, 'teams' => $teams, 'stattypes' => $stattypes);
}
/**
* Method to get the list
*
* @access public
* @return array
*/
public static function getData(&$params)
{
$p = $params->get('p');
$p = explode(":", $p);
$p = $p[0];
$t = $params->get('team');
$t = explode(":", $t);
$t = $t[0];
$db = JFactory::getDbo();
$query = "SELECT tt.id AS id, t.name AS team_name\n\t\t\t\t\tFROM #__joomleague_project_team tt\n\t\t\t\t\tINNER JOIN #__joomleague_team t ON t.id = tt.team_id\n\t\t\t\t\tWHERE tt.project_id = " . $p . "\n\t\t\t\t\tAND tt.team_id = " . $t;
$query .= " LIMIT 1";
$db->setQuery($query);
$result = $db->loadRow();
$projectteamid = $result[0];
$team_name = $result[1];
JRequest::setVar('p', $p);
JRequest::setVar('tid', $t);
JRequest::setVar('ttid', $projectteamid);
if (!class_exists('JoomleagueModelRoster')) {
require_once JLG_PATH_SITE . '/models/roster.php';
}
$model = JLGModel::getInstance('Roster', 'JoomleagueModel');
$model->setProjectId($p);
$project = $model->getProject();
$project->team_name = $team_name;
$staffs = $model->getStaffList();
$bypos = array();
foreach ($staffs as $staff) {
if (isset($bypos[$staff->position_id])) {
$bypos[$staff->position_id][] = $staff;
} else {
$bypos[$staff->position_id] = array($staff);
}
}
return array('project' => $project, 'staffs' => $bypos);
}
/**
* SearchTeam
*/
public function searchTeam()
{
header('Content-Type: application/json');
$app = JFactory::getApplication();
$jinput = $app->input;
$option = $jinput->getCmd('option');
$model = JLGModel::getInstance('Quickadd', 'JoomleagueModel');
$query = $jinput->getString('q');
$projectid = $app->getUserState($option . "project");
$results = $model->getNotAssignedTeams($query, $projectid);
$response = array("totalCount" => count($results), "rows" => array());
$names = array();
foreach ($results as $row) {
$names[] = $row->name . " [" . $row->id . "]";
$name = $row->name;
$name .= " (" . $row->info . ")";
$name .= " (" . $row->id . ")";
$response["rows"][] = array("id" => $row->id, "name" => $name);
}
$suggestions = $names;
// Send the response.
echo '{ "suggestions": ' . json_encode($suggestions) . ' }';
JFactory::getApplication()->close();
}
}
}
}
?>
</tr>
</thead>
<tbody>
<?php
$k = 0;
$career = array();
$career['played'] = 0;
$career['started'] = 0;
$career['in'] = 0;
$career['out'] = 0;
$career['playedtime'] = 0;
$player = JLGModel::getInstance("Person", "JoomleagueModel");
if (count($this->historyPlayer) > 0) {
foreach ($this->historyPlayer as $player_hist) {
$model = $this->getModel();
$this->inoutstat = $model->getInOutStats($player_hist->project_id, $player_hist->ptid, $player_hist->tpid);
// time played
$timePlayed = 0;
$this->timePlayed = $model->getTimePlayed($player_hist->tpid, $this->project->game_regular_time);
$timePlayed = $this->timePlayed;
$link1 = JoomleagueHelperRoute::getPlayerRoute($player_hist->project_slug, $player_hist->team_slug, $this->person->slug);
$link2 = JoomleagueHelperRoute::getTeamInfoRoute($player_hist->project_slug, $player_hist->team_slug);
?>
<tr class="<?php
echo $k == 0 ? $this->config['style_class1'] : $this->config['style_class2'];
?>
">
function _displayAssignPlayers($tpl = null)
{
$option = JRequest::getCmd('option');
$params = JComponentHelper::getParams($option);
$mainframe = JFactory::getApplication();
$model = $this->getModel();
$project_id = $mainframe->getUserState($option . 'project');
$mdlProject = JModelLegacy::getInstance("project", "JoomLeagueModel");
$project_name = $mdlProject->getProjectName($project_id);
$project_team_id = $mainframe->getUserState($option . 'project_team_id');
$team_name = $model->getProjectTeamName($project_team_id);
$mdlQuickAdd = JLGModel::getInstance('Quickadd', 'JoomleagueModel');
$filter_state = $mainframe->getUserStateFromRequest($option . 'pl_filter_state', 'filter_state', '', 'word');
$filter_order = $mainframe->getUserStateFromRequest($option . 'pl_filter_order', 'filter_order', 'pl.ordering', 'cmd');
$filter_order_Dir = $mainframe->getUserStateFromRequest($option . 'pl_filter_order_Dir', 'filter_order_Dir', '', 'word');
$search = $mainframe->getUserStateFromRequest($option . 'pl_search', 'search', '', 'string');
$search_mode = $mainframe->getUserStateFromRequest($option . 'pl_search_mode', 'search_mode', '', 'string');
//save icon should be replaced by the apply
JLToolBarHelper::apply('person.saveassigned', 'COM_JOOMLEAGUE_ADMIN_PERSONS_SAVE_SELECTED');
// Set toolbar items for the page
$type = JRequest::getInt('type');
if ($type == 0) {
//back icon should be replaced by the abort/close icon
JToolBarHelper::back('COM_JOOMLEAGUE_ADMIN_PERSONS_BACK', 'index.php?option=com_joomleague&task=teamplayer.display&view=teamplayers');
JToolBarHelper::title(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_ASSIGN_PLAYERS'), 'generic.png');
$items = $mdlQuickAdd->getNotAssignedPlayers(JString::strtolower($search), $project_team_id);
} elseif ($type == 1) {
//back icon should be replaced by the abort/close icon
JToolBarHelper::back('COM_JOOMLEAGUE_ADMIN_PERSONS_BACK', 'index.php?option=com_joomleague&task=teamstaff.display&view=teamstaffs');
JToolBarHelper::title(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_ASSIGN_STAFF'), 'generic.png');
$items = $mdlQuickAdd->getNotAssignedStaff(JString::strtolower($search), $project_team_id);
} elseif ($type == 2) {
//back icon should be replaced by the abort/close icon
JToolBarHelper::back('COM_JOOMLEAGUE_ADMIN_PERSONS_BACK', 'index.php?option=com_joomleague&view=projectreferees&task=projectreferee.display');
JToolBarHelper::title(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_ASSIGN_REFEREES'), 'generic.png');
$items = $mdlQuickAdd->getNotAssignedReferees(JString::strtolower($search), $project_id);
}
JToolBarHelper::help('screen.joomleague', true);
$limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
jimport('joomla.html.pagination');
$pagination = new JPagination($mdlQuickAdd->_total, JRequest::getVar('limitstart', 0, '', 'int'), $limit);
$mdlQuickAdd->_pagination = $pagination;
// table ordering
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
// search filter
$lists['search'] = $search;
$lists['search_mode'] = $search_mode;
$this->prjid = $project_id;
$this->prj_name = $project_name;
/* $this->team_id = $team_id; */
$this->team_name = $team_name;
$this->project_team_id = $project_team_id;
$this->lists = $lists;
$this->items = $items;
$this->pagination = $pagination;
$this->request_url = JFactory::getURI()->toString();
$this->type = $type;
$this->component_params = $params;
parent::display($tpl);
}
/**
* Method to assign teams of an existing project to a copied project
*
* @access public
* @return array
*/
function cpCopyTeams($post, $source_to_copy_division)
{
$mdlTeamPlayer = JLGModel::getInstance('teamplayer', 'JoomleagueModel');
$mdlTeamStaff = JLGModel::getInstance('teamstaff', 'JoomleagueModel');
$old_id = (int) $post['old_id'];
$project_id = (int) $post['id'];
//copy teams
$query = 'SELECT * FROM #__joomleague_project_team WHERE project_id=' . $old_id;
$this->_db->setQuery($query);
if ($results = $this->_db->loadAssocList()) {
foreach ($results as $result) {
$p_team = $this->getTable();
$p_team->bind($result);
$p_team->set('id', NULL);
$p_team->set('project_id', $project_id);
$p_team->set('start_points', 0);
$p_team->set('start_points', 0);
$p_team->set('points_finally', 0);
$p_team->set('neg_points_finally', 0);
$p_team->set('matches_finally', 0);
$p_team->set('won_finally', 0);
$p_team->set('draws_finally', 0);
$p_team->set('lost_finally', 0);
$p_team->set('homegoals_finally', 0);
$p_team->set('guestgoals_finally', 0);
$p_team->set('diffgoals_finally', 0);
$p_team->set('is_in_score', 1);
$p_team->set('use_finally', 0);
//divisions have to be copied first to get a new division id to replace it here
if ($post['project_type'] == 'DIVISIONS_LEAGUE') {
if ($result['division_id'] != null && array_key_exists($result['division_id'], $source_to_copy_division)) {
$p_team->set('division_id', $source_to_copy_division[$result['division_id']]);
}
}
$to_projectteam_id = $p_team->store();
if (!$to_projectteam_id) {
echo $this->_db->getErrorMsg();
return false;
}
$from_projectteam_id = $result['id'];
//copy project team-players
if ($mdlTeamPlayer->cpCopyPlayers($from_projectteam_id, $to_projectteam_id)) {
echo JText::sprintf('COM_JOOMLEAGUE_ADMIN_PROJECTTEAM_MODEL_TP_COPIED', $from_projectteam_id) . '<br />';
} else {
echo JText::sprintf('COM_JOOMLEAGUE_ADMIN_PROJECTTEAM_MODEL_ERROR_TP_COPIED', $from_projectteam_id) . '<br />' . $model->getError() . '<br />';
}
//copy project team-staff
if ($mdlTeamStaff->cpCopyTeamStaffs($from_projectteam_id, $to_projectteam_id)) {
echo JText::sprintf('COM_JOOMLEAGUE_ADMIN_PROJECTTEAM_MODEL_TS_COPIED', $from_projectteam_id) . '<br />';
} else {
echo JText::sprintf('COM_JOOMLEAGUE_ADMIN_PROJECTTEAM_MODEL_ERROR_TS_COPIED', $from_projectteam_id) . '<br />' . $model->getError() . '<br />';
}
//copy project team trainingdata
$query = 'SELECT * FROM #__joomleague_team_trainingdata WHERE project_team_id=' . $from_projectteam_id;
$this->_db->setQuery($query);
if ($results = $this->_db->loadAssocList()) {
foreach ($results as $result) {
$tData = $this->getTable('teamtrainingdata');
$tData->bind($result);
$tData->set('id', NULL);
$tData->set('project_team_id', $to_projectteam_id);
if (!$tData->store()) {
echo JText::sprintf('COM_JOOMLEAGUE_ADMIN_PROJECTTEAM_MODEL_ERROR_TP_COPIED', $from_projectteam_id) . '<br />' . $model->getError() . '<br />';
} else {
echo JText::sprintf('COM_JOOMLEAGUE_ADMIN_PROJECTTEAM_MODEL_ERROR_TRAINING_COPIED', $from_projectteam_id) . '<br />';
}
}
}
}
}
return true;
}
// sprachedatei der extension nachladen, damit wir nicht noch mal alles eintragen müssen
$lang =& JFactory::getLanguage();
$extension = 'com_joomleague_predictiongame';
$base_dir = JPATH_SITE.DS.'components'.DS.'com_joomleague'.DS.'extensions'.DS.'predictiongame';
// $language_tag = 'en-GB';
$language_tag = '';
$reload = true;
$lang->load($extension, $base_dir, $language_tag, $reload);
// sprachdatei der komponente nachladen
$extension = 'com_joomleague';
$base_dir = JPATH_SITE;
$lang->load($extension, $base_dir, $language_tag, $reload);
*/
JRequest::setVar('prediction_id', $pg_id);
// das model laden
$modelpg =& JLGModel::getInstance('PredictionRanking', 'JoomleagueModel');
// jetzt nach das overall template nachladen
// dadurch erhalten wir die sortierung aus dem backend
$overallConfig = $modelpg->getPredictionOverallConfig();
$config = array_merge($overallConfig, $config);
$configavatar = $modelpg->getPredictionTemplateConfig('predictionusers');
$predictionGame[] = $modelpg->getPredictionGame();
$predictionMember[] = $modelpg->getPredictionMember($configavatar);
$predictionProjectS[] = $modelpg->getPredictionProjectS();
$actJoomlaUser[] = JFactory::getUser();
$roundID = $modelpg->roundID;
$type_array = array();
$type_array[] = JHTML::_('select.option', '0', JText::_('JL_PRED_RANK_FULL_RANKING'));
$type_array[] = JHTML::_('select.option', '1', JText::_('JL_PRED_RANK_FIRST_HALF'));
$type_array[] = JHTML::_('select.option', '2', JText::_('JL_PRED_RANK_SECOND_HALF'));
$lists['type'] = $type_array;
public function addTeam()
{
$option = JRequest::getCmd('option');
$mainframe = JFactory::getApplication();
$db = JFactory::getDbo();
$teamid = JRequest::getInt("cteamid", 0);
$name = JRequest::getVar("quickadd", '', 'request', 'string');
$project_id = $mainframe->getUserState($option . "project");
// add the new team as their name was sent through.
if (!$teamid) {
$model = JLGModel::getInstance('Team', 'JoomleagueModel');
$data = array("name" => $name);
$teamid = $model->store($data);
}
if (!$teamid) {
$msg = Jtext::_('COM_JOOMLEAGUE_ADMIN_QUICKADD_CTRL_ERROR_TEAM');
$this->setRedirect("index.php?option=com_joomleague&view=projectteams&task=projectteam.display&projectid=" . $project_id, $msg, 'error');
}
// check if team belongs to project
$query = ' SELECT id FROM #__joomleague_project_team ' . ' WHERE project_id = ' . $db->Quote($project_id) . ' AND team_id = ' . $db->Quote($teamid);
$db->setQuery($query);
$res = $db->loadResult();
if (!$res) {
$new = JTable::getInstance('Projectteam', 'Table');
$new->team_id = $teamid;
$new->project_id = $project_id;
// Set ordering to the last item if not set
$db->setQuery('SELECT MAX(ordering) FROM #__joomleague_project_team WHERE project_id = ' . $db->Quote($project_id));
$max = $db->loadResult();
$new->ordering = $max + 1;
if (!$new->check()) {
$this->setError($new->getError());
}
// Get data from player
$query = "\tSELECT picture\n\t\t\t\t\t\tFROM #__joomleague_team AS t\n\t\t\t\t\t\tWHERE t.id=" . $db->Quote($teamid);
$db->setQuery($query);
$team = $db->loadObject();
if ($team) {
$new->picture = $team->picture;
}
if (!$new->store()) {
$this->setError($new->getError());
}
}
$msg = Jtext::_('COM_JOOMLEAGUE_ADMIN_QUICKADD_CTRL_TEAM_ASSIGNED');
$this->setRedirect("index.php?option=com_joomleague&view=projectteams&task=projectteam.display&projectid=" . $project_id, $msg);
}
function _displayAssignPlayers($tpl = null)
{
$option = JRequest::getCmd('option');
$mainframe = JFactory::getApplication();
$model = $this->getModel();
$project_id = $mainframe->getUserState($option . 'project');
$mdlProject = JModel::getInstance("project", "JoomLeagueModel");
$project_name = $mdlProject->getProjectName($project_id);
$project_team_id = $mainframe->getUserState($option . 'project_team_id');
$team_name = $model->getProjectTeamName($project_team_id);
$mdlQuickAdd =& JLGModel::getInstance('Quickadd', 'JoomleagueModel');
$filter_state = $mainframe->getUserStateFromRequest($option . 'pl_filter_state', 'filter_state', '', 'word');
$filter_order = $mainframe->getUserStateFromRequest($option . 'pl_filter_order', 'filter_order', 'pl.ordering', 'cmd');
$filter_order_Dir = $mainframe->getUserStateFromRequest($option . 'pl_filter_order_Dir', 'filter_order_Dir', '', 'word');
$search = $mainframe->getUserStateFromRequest($option . 'pl_search', 'search', '', 'string');
$search_mode = $mainframe->getUserStateFromRequest($option . 'pl_search_mode', 'search_mode', '', 'string');
$filter_info = $mainframe->getUserStateFromRequest($option . 'pl_filter_info', 'filter_info', '', 'string');
//save icon should be replaced by the apply
JLToolBarHelper::apply('person.saveassigned', JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_SAVE_SELECTED'));
// Set toolbar items for the page
$type = JRequest::getInt('type');
if ($type == 0) {
//back icon should be replaced by the abort/close icon
JToolBarHelper::back(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_BACK'), 'index.php?option=com_joomleague&task=teamplayer.display&view=teamplayers');
JToolBarHelper::title(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_ASSIGN_PLAYERS'), 'generic.png');
$items = $mdlQuickAdd->getNotAssignedPlayers(JString::strtolower($search), $project_team_id, $filter_info);
} elseif ($type == 1) {
//back icon should be replaced by the abort/close icon
JToolBarHelper::back(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_BACK'), 'index.php?option=com_joomleague&task=teamstaff.display&view=teamstaffs');
JToolBarHelper::title(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_ASSIGN_STAFF'), 'generic.png');
$items = $mdlQuickAdd->getNotAssignedStaff(JString::strtolower($search), $project_team_id, $filter_info);
} elseif ($type == 2) {
//back icon should be replaced by the abort/close icon
JToolBarHelper::back(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_BACK'), 'index.php?option=com_joomleague&view=projectreferees&task=projectreferee.display');
JToolBarHelper::title(JText::_('COM_JOOMLEAGUE_ADMIN_PERSONS_ASSIGN_REFEREES'), 'generic.png');
$items = $mdlQuickAdd->getNotAssignedReferees(JString::strtolower($search), $project_id, $filter_info);
}
JLToolBarHelper::onlinehelp();
$limit = $mainframe->getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
//build the html select list for info field
$infoList[] = JHtml::_('select.option', '', JText::_('COM_JOOMLEAGUE_GLOBAL_SELECT_INFO_FIELD'), 'id', 'name');
$infos = JModel::getInstance('person', 'JoomleagueModel');
$allInfos = $infos->getInfofield();
if ($allInfos) {
$infoList = array_merge($infoList, $allInfos);
$lists['infofield'] = JHtml::_('select.genericList', $infoList, 'filter_info', 'class="inputbox" onChange="this.form.submit();" style="width:120px"', 'id', 'name', $filter_info);
unset($infoList);
}
jimport('joomla.html.pagination');
$pagination = new JPagination($mdlQuickAdd->_total, JRequest::getVar('limitstart', 0, '', 'int'), $limit);
$mdlQuickAdd->_pagination = $pagination;
// table ordering
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
// search filter
$lists['search'] = $search;
$lists['search_mode'] = $search_mode;
$this->assignRef('prjid', $project_id);
$this->assignRef('prj_name', $project_name);
$this->assignRef('team_id', $team_id);
$this->assignRef('team_name', $team_name);
$this->assignRef('project_team_id', $project_team_id);
$this->assignRef('lists', $lists);
$this->assignRef('items', $items);
$this->assignRef('pagination', $pagination);
$this->assignRef('request_url', JFactory::getURI()->toString());
$this->assignRef('type', $type);
parent::display($tpl);
}
function addPlayer($projectteam_id, $personid, $name = null)
{
if (!$personid && empty($name)) {
$this->setError(Jtext::_('COM_JOOMLEAGUE_ADMIN_QUICKADD_CTRL_ADD_PLAYER_REQUIRES_ID_OR_NAME'));
return false;
}
// add the new individual as their name was sent through.
if (!$personid) {
$mdlPerson = JLGModel::getInstance('Person', 'JoomleagueModel');
$name = explode(" ", $name);
$firstname = '';
$nickname = '';
$lastname = '';
if (count($name) == 1) {
$firstname = ucfirst($name[0]);
$nickname = $name[0];
$lastname = ".";
}
if (count($name) == 2) {
$firstname = ucfirst($name[0]);
$nickname = $name[1];
$lastname = ucfirst($name[1]);
}
if (count($name) == 3) {
$firstname = ucfirst($name[0]);
$nickname = $name[1];
$lastname = ucfirst($name[2]);
}
$data = array("firstname" => $firstname, "nickname" => $nickname, "lastname" => $lastname, "published" => 1);
$mdlPerson->store($data);
$personid = $mdlPerson->_db->insertid();
}
if (!$personid) {
$this->setError(Jtext::_('COM_JOOMLEAGUE_ADMIN_QUICKADD_CTRL_FAILED_ADDING_PERSON'));
return false;
}
// check if indivual belongs to project team already
$query = ' SELECT person_id FROM #__joomleague_team_player ' . ' WHERE projectteam_id = ' . $this->_db->Quote($projectteam_id) . ' AND person_id = ' . $this->_db->Quote($personid);
$this->_db->setQuery($query);
$res = $this->_db->loadResult();
if (!$res) {
$tblTeamplayer = JTable::getInstance('Teamplayer', 'Table');
$tblTeamplayer->person_id = $personid;
$tblTeamplayer->projectteam_id = $projectteam_id;
$tblProjectTeam = JTable::getInstance('Projectteam', 'Table');
$tblProjectTeam->load($projectteam_id);
if (!$tblTeamplayer->check()) {
$this->setError($tblTeamplayer->getError());
return false;
}
// Get data from player
$query = "\tSELECT picture, position_id\n\t\t\t\t\t\t\tFROM #__joomleague_person AS pl\n\t\t\t\t\t\t\tWHERE pl.id=" . $this->_db->Quote($personid) . "\n\t\t\t\t\t\t\tAND pl.published = 1";
$this->_db->setQuery($query);
$person = $this->_db->loadObject();
if ($person) {
if ($person->position_id) {
$query = "SELECT id FROM #__joomleague_project_position ";
$query .= " WHERE position_id = " . $person->position_id;
$query .= " AND project_id = " . $tblProjectTeam->project_id;
$this->_db->setQuery($query);
if ($resPrjPosition = $this->_db->loadObject()) {
$tblTeamplayer->project_position_id = $resPrjPosition->id;
}
}
$tblTeamplayer->picture = $person->picture;
$tblTeamplayer->projectteam_id = $projectteam_id;
}
$query = "\tSELECT max(ordering) count\n\t\t\t\t\t\t\t\tFROM #__joomleague_team_player";
$this->_db->setQuery($query);
$tp = $this->_db->loadObject();
$tblTeamplayer->ordering = (int) $tp->count + 1;
if (!$tblTeamplayer->store()) {
$this->setError($tblTeamplayer->getError());
return false;
}
}
return true;
}
/**
* get ranking of current team in a project
* @param int projectid
* @param int division_id
* @return array
*/
function getTeamRanking($projectid, $division_id)
{
$rank = array();
$model = JLGModel::getInstance('Project', 'JoomleagueModel');
$model->setProjectID($projectid);
$project = $model->getProject();
$tableconfig = $model->getTemplateConfig("ranking");
$ranking = JLGRanking::getInstance($project);
$ranking->setProjectId($project->id);
$this->ranking = $ranking->getRanking(0, $model->getCurrentRound(), $division_id);
foreach ($this->ranking as $ptid => $value) {
if ($value->getPtid() == $this->projectteamid) {
$rank['rank'] = $value->rank;
$rank['games'] = $value->cnt_matches;
$rank['points'] = $value->getPoints();
$rank['series'] = $value->cnt_won . "/" . $value->cnt_draw . "/" . $value->cnt_lost;
$rank['goals'] = $value->sum_team1_result . ":" . $value->sum_team2_result;
break;
} else {
if ($value->getTeamId() == $this->teamid) {
$rank['rank'] = $value->rank;
$rank['games'] = $value->cnt_matches;
$rank['points'] = $value->getPoints();
$rank['series'] = $value->cnt_won . "/" . $value->cnt_draw . "/" . $value->cnt_lost;
$rank['goals'] = $value->sum_team1_result . ":" . $value->sum_team2_result;
break;
}
}
}
return $rank;
}
/**
* Method to get the list
*
* @access public
* @return array
*/
public static function getData(&$params)
{
// catch variables
$usedp = $params->get('projects');
// required
$usedtid = $params->get('teams', '0');
// not required
// convert to strings
$projectstring = is_array($usedp) ? implode(",", $usedp) : $usedp;
$teamstring = is_array($usedtid) ? implode(",", $usedtid) : $usedtid;
// Project-teamids
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('id');
$query->from('#__joomleague_project_team tt');
$query->where('tt.project_id > 0');
if ($projectstring != "" && $projectstring > 0) {
$query->where('tt.project_id IN (' . $projectstring . ')');
}
if ($teamstring != "" && $teamstring > 0) {
$query->where('tt.team_id IN (' . $teamstring . ')');
}
$db->setQuery($query);
$projectteamids = $db->loadColumn();
// At this point we should have project-teamids //
if (empty($projectteamids)) {
return false;
}
$shuffleKeys = array_keys($projectteamids);
shuffle($shuffleKeys);
$projectidsarray = array();
foreach ($shuffleKeys as $key) {
$projectidsarray[$key] = $projectteamids[$key];
}
// Get person data that can be displayed
foreach ($projectidsarray as $projectteamid) {
# at this point we do have a project-teamid
// Retrieve persons related to a projectteam
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select(array('pt.person_id', 'tt.project_id'));
$query->from('#__joomleague_team_player AS pt');
$query->join('INNER', '#__joomleague_project_team AS tt ON tt.id = pt.projectteam_id');
$query->where('pt.projectteam_id = ' . $projectteamid);
$db->setQuery($query);
$result = $db->loadObjectList();
if ($result) {
break;
} else {
continue;
}
}
if (empty($result)) {
return false;
}
# shuffle results
$key = array_rand($result);
$result = $result[$key];
// Setting variables
JRequest::setVar('p', $result->project_id);
// projectid
JRequest::setVar('pid', $result->person_id);
// personid
JRequest::setVar('pt', $projectteamid);
// project-team
if (!class_exists('JoomleagueModelPlayer')) {
require_once JLG_PATH_SITE . '/models/player.php';
}
// Player model + info
$mdlPerson = JLGModel::getInstance('Player', 'JoomleagueModel');
$person = $mdlPerson->getPerson();
$project = $mdlPerson->getProject();
$current_round = isset($project->current_round) ? $project->current_round : 0;
$person_id = isset($person->id) ? $person->id : 0;
$player = $mdlPerson->getTeamPlayerByRound($current_round, $person_id);
$infoteam = $mdlPerson->getTeaminfo($projectteamid);
$data = array('project' => $project, 'player' => $person, 'inprojectinfo' => !empty($player) ? $player[0] : array(), 'infoteam' => $infoteam);
return $data;
}
foreach ($this->stats as $stat) {
?>
<th class="td_c"><?php
echo $stat->getImage();
?>
</th><?php
}
}
}
?>
</tr>
<?php
$k = 0;
$career = array();
$career['played'] = 0;
$mod = JLGModel::getInstance('Staff', 'JoomleagueModel');
if (count($this->history) > 0) {
foreach ($this->history as $player_hist) {
$model = $this->getModel();
$present = $model->getPresenceStats($player_hist->project_id, $player_hist->ptid, $player_hist->pid);
?>
<tr class="<?php
echo $k == 0 ? $this->config['style_class1'] : $this->config['style_class2'];
?>
">
<td class="td_l" nowrap="nowrap"><?php
echo $player_hist->project_name;
# echo " (".$player_hist->project_id.")";
?>
</td>
<td class="td_l" class="nowrap"><?php
public function save()
{
$app = JFactory::getApplication();
// Check for request forgeries
JSession::checkToken() or die(JText::_('COM_JOOMLEAGUE_GLOBAL_INVALID_TOKEN'));
$post = JRequest::get('post');
$cid = JRequest::getVar('cid', array(0), 'post', 'array');
$post['id'] = (int) $cid[0];
$msg = '';
// convert dates back to mysql date format
if (isset($post['start_date'])) {
$post['start_date'] = strtotime($post['start_date']) ? strftime('%Y-%m-%d', strtotime($post['start_date'])) : null;
} else {
$post['start_date'] = null;
}
if (isset($post['fav_team'])) {
if (count($post['fav_team']) > 0) {
$temp = implode(",", $post['fav_team']);
} else {
$temp = '';
}
$post['fav_team'] = $temp;
} else {
$post['fav_team'] = '';
}
if (isset($post['extension'])) {
if (count($post['extension']) > 0) {
$temp = implode(",", $post['extension']);
} else {
$temp = '';
}
$post['extension'] = $temp;
} else {
$post['extension'] = '';
}
if (isset($post['leagueNew'])) {
$mdlLeague = $this->getModel('league');
$post['league_id'] = $mdlLeague->addLeague($post['leagueNew']);
$msg .= JText::_('COM_JOOMLEAGUE_LEAGUE_CREATED') . ',';
}
if (isset($post['seasonNew'])) {
$mdlSeason = $this->getModel('season');
$post['season_id'] = $mdlSeason->addSeason($post['seasonNew']);
$msg .= JText::_('COM_JOOMLEAGUE_SEASON_CREATED') . ',';
}
$model = $this->getModel('project');
$form = $model->getForm($post, false);
// Test whether the data is valid.
$validData = $model->validate($form, $post);
// Check for validation errors.
if ($validData === false) {
// Get the validation messages.
$errors = $model->getErrors();
// Push up to three validation messages out to the user.
for ($i = 0, $n = count($errors); $i < $n && $i < 3; $i++) {
if ($errors[$i] instanceof Exception) {
$app->enqueueMessage($errors[$i]->getMessage(), 'warning');
} else {
$app->enqueueMessage($errors[$i], 'warning');
}
}
// Save the data in the session.
$app->setUserState('com_joomleague.edit.project' . '.data', $post);
// Redirect back to the edit screen.
$this->setRedirect(JRoute::_('index.php?option=com_joomleague&task=project.edit&cid[]=' . $post['id'], false));
return false;
}
if ($id = $model->store($post)) {
// clear data in the session.
$app->setUserState('com_joomleague.edit.project' . '.data', null);
// save the templates params
if ($post['id'] == 0) {
$post['id'] = $id;
}
$templatesModel = JLGModel::getInstance('Templates', 'JoomleagueModel');
$templatesModel->setProjectId($post['id']);
$templatesModel->checklist();
$msg .= JText::_('COM_JOOMLEAGUE_PROJECT_SAVED');
} else {
$msg = JText::_('COM_JOOMLEAGUE_ERROR_SAVING_PROJECT') . $model->getError();
}
// Check the table in so it can be edited.... we are done with it anyway
$model->checkin();
$task = $this->getTask();
if ($task == 'save') {
$link = 'index.php?option=com_joomleague&view=projects&task=project.display';
} else {
$link = 'index.php?option=com_joomleague&task=project.edit&cid[]=' . $post['id'];
}
//echo $msg;
$this->setRedirect($link, $msg);
}
