PHP Paginator::getFirstIndex方法代碼示例

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