/** * (non-PHPdoc) * @see IModel::getTemplateParameters() */ public function getTemplateParameters() { // get team info $teamId = NationalteamsDataService::getNationalTeamManagedByCurrentUser($this->_websoccer, $this->_db); if (!$teamId) { throw new Exception($this->_i18n->getMessage("nationalteams_user_requires_team")); } $result = $this->_db->querySelect("name", $this->_websoccer->getConfig("db_prefix") . "_verein", "id = %d", $teamId); $team = $result->fetch_array(); $result->free(); // query players $firstName = $this->_websoccer->getRequestParameter("fname"); $lastName = $this->_websoccer->getRequestParameter("lname"); $position = $this->_websoccer->getRequestParameter("position"); $mainPosition = $this->_websoccer->getRequestParameter("position_main"); $playersCount = NationalteamsDataService::findPlayersCount($this->_websoccer, $this->_db, $team["name"], $teamId, $firstName, $lastName, $position, $mainPosition); // setup paginator $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($playersCount, $eps, $this->_websoccer); $paginator->addParameter("fname", $firstName); $paginator->addParameter("lname", $lastName); $paginator->addParameter("position", $position); $paginator->addParameter("position_main", $mainPosition); $paginator->addParameter("search", "true"); // get players records if ($playersCount > 0) { $players = NationalteamsDataService::findPlayers($this->_websoccer, $this->_db, $team["name"], $teamId, $firstName, $lastName, $position, $mainPosition, $paginator->getFirstIndex(), $eps); } else { $players = array(); } return array("team_name" => $team["name"], "playersCount" => $playersCount, "players" => $players, "paginator" => $paginator); }
/** * (non-PHPdoc) * @see IModel::getTemplateParameters() */ public function getTemplateParameters() { $teamId = $this->_websoccer->getUser()->getClubId($this->_websoccer, $this->_db); // last training executions $lastExecution = TrainingDataService::getLatestTrainingExecutionTime($this->_websoccer, $this->_db, $teamId); $unitsCount = TrainingDataService::countRemainingTrainingUnits($this->_websoccer, $this->_db, $teamId); $paginator = null; $trainers = null; // has valid training unit? $training_unit = TrainingDataService::getValidTrainingUnit($this->_websoccer, $this->_db, $teamId); if (!isset($training_unit["id"])) { // get trainers $count = TrainingDataService::countTrainers($this->_websoccer, $this->_db); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); if ($count > 0) { $trainers = TrainingDataService::getTrainers($this->_websoccer, $this->_db, $paginator->getFirstIndex(), $eps); } } else { $training_unit["trainer"] = TrainingDataService::getTrainerById($this->_websoccer, $this->_db, $training_unit["trainer_id"]); } // collect effects of executed training unit $trainingEffects = array(); $contextParameters = $this->_websoccer->getContextParameters(); if (isset($contextParameters["trainingEffects"])) { $trainingEffects = $contextParameters["trainingEffects"]; } return array("unitsCount" => $unitsCount, "lastExecution" => $lastExecution, "training_unit" => $training_unit, "trainers" => $trainers, "paginator" => $paginator, "trainingEffects" => $trainingEffects); }
public function getTemplateParameters() { $clubId = $this->_websoccer->getUser()->getClubId($this->_websoccer, $this->_db); $count = YouthMatchesDataService::countMatchesOfTeam($this->_websoccer, $this->_db, $clubId); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); $matches = YouthMatchesDataService::getMatchesOfTeam($this->_websoccer, $this->_db, $clubId, $paginator->getFirstIndex(), $eps); return array("matches" => $matches, "paginator" => $paginator); }
public function getTemplateParameters() { YouthPlayersDataService::deleteInvalidOpenMatchRequests($this->_websoccer, $this->_db); $count = YouthPlayersDataService::countMatchRequests($this->_websoccer, $this->_db); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); $requests = YouthPlayersDataService::getMatchRequests($this->_websoccer, $this->_db, $paginator->getFirstIndex(), $eps); return array("requests" => $requests, "paginator" => $paginator); }
public function getTemplateParameters() { $positionFilter = $this->_websoccer->getRequestParameter("position"); $count = YouthPlayersDataService::countTransferableYouthPlayers($this->_websoccer, $this->_db, $positionFilter); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); if ($positionFilter != null) { $paginator->addParameter("position", $positionFilter); } $players = YouthPlayersDataService::getTransferableYouthPlayers($this->_websoccer, $this->_db, $positionFilter, $paginator->getFirstIndex(), $eps); return array("players" => $players, "paginator" => $paginator); }
public function getTemplateParameters() { $matches = array(); $paginator = null; $count = MatchesDataService::countTodaysMatches($this->_websoccer, $this->_db); if ($count) { $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); $matches = MatchesDataService::getTodaysMatches($this->_websoccer, $this->_db, $paginator->getFirstIndex(), $eps); } return array("matches" => $matches, "paginator" => $paginator); }
public function getTemplateParameters() { $count = MessagesDataService::countInboxMessages($this->_websoccer, $this->_db); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); if ($count > 0) { $messages = MessagesDataService::getInboxMessages($this->_websoccer, $this->_db, $paginator->getFirstIndex(), $eps); } else { $messages = array(); } return array("messages" => $messages, "paginator" => $paginator); }
public function getTemplateParameters() { $count = UsersDataService::countActiveUsersWithHighscore($this->_websoccer, $this->_db); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); if ($count > 0) { $users = UsersDataService::getActiveUsersWithHighscore($this->_websoccer, $this->_db, $paginator->getFirstIndex(), $eps); } else { $users = array(); } return array("users" => $users, "paginator" => $paginator); }
/** * (non-PHPdoc) * @see IModel::getTemplateParameters() */ public function getTemplateParameters() { $userId = $this->_websoccer->getUser()->id; $count = PremiumDataService::countAccountStatementsOfUser($this->_websoccer, $this->_db, $userId); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); if ($count > 0) { $statements = PremiumDataService::getAccountStatementsOfUser($this->_websoccer, $this->_db, $userId, $paginator->getFirstIndex(), $eps); } else { $statements = array(); } return array("statements" => $statements, "paginator" => $paginator, "payments" => PremiumDataService::getPaymentsOfUser($this->_websoccer, $this->_db, $userId, 5)); }
public function getTemplateParameters() { $clubId = $this->_websoccer->getUser()->getClubId($this->_websoccer, $this->_db); $offers = array(); $count = DirectTransfersDataService::countReceivedOffers($this->_websoccer, $this->_db, $clubId); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); if ($count > 0) { $offers = DirectTransfersDataService::getReceivedOffers($this->_websoccer, $this->_db, $paginator->getFirstIndex(), $eps, $clubId); } else { $offers = array(); } return array("offers" => $offers, "paginator" => $paginator); }
public function getTemplateParameters() { $teamId = $this->_websoccer->getUser()->getClubId($this->_websoccer, $this->_db); if ($teamId < 1) { throw new Exception($this->_i18n->getMessage("feature_requires_team")); } $team = TeamsDataService::getTeamSummaryById($this->_websoccer, $this->_db, $teamId); $count = BankAccountDataService::countAccountStatementsOfTeam($this->_websoccer, $this->_db, $teamId); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); if ($count > 0) { $statements = BankAccountDataService::getAccountStatementsOfTeam($this->_websoccer, $this->_db, $teamId, $paginator->getFirstIndex(), $eps); } else { $statements = array(); } return array("budget" => $team["team_budget"], "statements" => $statements, "paginator" => $paginator); }
/** * (non-PHPdoc) * @see IModel::getTemplateParameters() */ public function getTemplateParameters() { // get team info $teamId = NationalteamsDataService::getNationalTeamManagedByCurrentUser($this->_websoccer, $this->_db); if (!$teamId) { throw new Exception($this->_i18n->getMessage("nationalteams_user_requires_team")); } $matchesCount = NationalteamsDataService::countNextMatches($this->_websoccer, $this->_db, $teamId); // setup paginator $eps = 5; $paginator = new Paginator($matchesCount, $eps, $this->_websoccer); $paginator->addParameter("block", "national-next-matches"); $matches = array(); if ($matchesCount) { $matches = NationalteamsDataService::getNextMatches($this->_websoccer, $this->_db, $teamId, $paginator->getFirstIndex(), $eps); } return array("paginator" => $paginator, "matches" => $matches); }
public function getTemplateParameters() { $playersCount = PlayersDataService::findPlayersCount($this->_websoccer, $this->_db, $this->_firstName, $this->_lastName, $this->_club, $this->_position, $this->_strength, $this->_lendableOnly); // setup paginator $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($playersCount, $eps, $this->_websoccer); $paginator->addParameter("block", "playerssearch-results"); $paginator->addParameter("fname", $this->_firstName); $paginator->addParameter("lname", $this->_lastName); $paginator->addParameter("club", $this->_club); $paginator->addParameter("position", $this->_position); $paginator->addParameter("strength", $this->_strength); $paginator->addParameter("lendable", $this->_lendableOnly); // get players records if ($playersCount > 0) { $players = PlayersDataService::findPlayers($this->_websoccer, $this->_db, $this->_firstName, $this->_lastName, $this->_club, $this->_position, $this->_strength, $this->_lendableOnly, $paginator->getFirstIndex(), $eps); } else { $players = array(); } return array("playersCount" => $playersCount, "players" => $players, "paginator" => $paginator); }
/** * (non-PHPdoc) * @see IModel::getTemplateParameters() */ public function getTemplateParameters() { $matches = array(); $paginator = null; $clubId = $this->_websoccer->getUser()->getClubId($this->_websoccer, $this->_db); $whereCondition = '(home_verein = %d OR gast_verein = %d) AND berechnet != \'1\''; $parameters = array($clubId, $clubId); $result = $this->_db->querySelect('COUNT(*) AS hits', $this->_websoccer->getConfig('db_prefix') . '_spiel', $whereCondition, $parameters); $matchesCnt = $result->fetch_array(); $result->free(); if ($matchesCnt) { $count = $matchesCnt['hits']; } else { $count = 0; } if ($count) { $whereCondition .= ' ORDER BY M.datum ASC'; $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); $matches = MatchesDataService::getMatchesByCondition($this->_websoccer, $this->_db, $whereCondition, $parameters, $paginator->getFirstIndex() . ',' . $eps); } return array("matches" => $matches, "paginator" => $paginator); }
public function getTemplateParameters() { $teamId = $this->_websoccer->getUser()->getClubId($this->_websoccer, $this->_db); if ($teamId < 1) { throw new Exception($this->_i18n->getMessage("feature_requires_team")); } $positionInput = $this->_websoccer->getRequestParameter("position"); $positionFilter = null; if ($positionInput == "goaly") { $positionFilter = "Torwart"; } else { if ($positionInput == "defense") { $positionFilter = "Abwehr"; } else { if ($positionInput == "midfield") { $positionFilter = "Mittelfeld"; } else { if ($positionInput == "striker") { $positionFilter = "Sturm"; } } } } $count = PlayersDataService::countPlayersOnTransferList($this->_websoccer, $this->_db, $positionFilter); $eps = $this->_websoccer->getConfig("entries_per_page"); $paginator = new Paginator($count, $eps, $this->_websoccer); if ($positionFilter != null) { $paginator->addParameter("position", $positionInput); } if ($count > 0) { $players = PlayersDataService::getPlayersOnTransferList($this->_websoccer, $this->_db, $paginator->getFirstIndex(), $eps, $positionFilter); } else { $players = array(); } return array("transferplayers" => $players, "playerscount" => $count, "paginator" => $paginator); }
/** * (non-PHPdoc) * @see IModel::getTemplateParameters() */ public function getTemplateParameters() { $fromTable = $this->_websoccer->getConfig("db_prefix") . "_news"; $whereCondition = "status = %d"; $parameters = "1"; // count items for pagination $result = $this->_db->querySelect("COUNT(*) AS hits", $fromTable, $whereCondition, $parameters); $rows = $result->fetch_array(); $result->free(); // enable paginations $eps = NEWS_ENTRIES_PER_PAGE; $paginator = new Paginator($rows["hits"], $eps, $this->_websoccer); // select $columns = "id, titel, datum, nachricht"; $whereCondition .= " ORDER BY datum DESC"; $limit = $paginator->getFirstIndex() . "," . $eps; $result = $this->_db->querySelect($columns, $fromTable, $whereCondition, $parameters, $limit); $articles = array(); while ($article = $result->fetch_array()) { $articles[] = array("id" => $article["id"], "title" => $article["titel"], "date" => $this->_websoccer->getFormattedDate($article["datum"]), "teaser" => $this->_shortenMessage($article["nachricht"])); } $result->free(); return array("articles" => $articles, "paginator" => $paginator); }