/** * 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); }