application/models/Game.php

   1 <?php
   2 require_once APPLICATION_PATH . '/models/Player.php';
   3 require_once APPLICATION_PATH . '/models/PlayerList.php';
   4 require_once APPLICATION_PATH . '/models/DbTable/Game.php';
   5 require_once APPLICATION_PATH . '/models/DbTable/Player.php';
   6 require_once APPLICATION_PATH . '/models/DbTable/PlayerInGame.php';
   7
   8 class Game
   9 {
  10         const TABLE_GAME = 'game';
  11         const GAME_DATE = 'game_date';
  12         const GAME_ID = 'game_id';
  13         const PLAYER_ID = 'player_id';
  14
  15         protected $_table;
  16         protected $_game_date;
  17         protected $_game_id;
  18         protected $_playerlist;
  19
  20         public function __construct($game_id)
  21         {
  22             $game_table = $this->getTable();
  23
  24             $select = $game_table->select()->where(self::GAME_ID.'=?', $game_id);
  25             $stmt = $select->query();
  26
  27             if ($res = $stmt->fetchAll()) {
  28                 $this->_game_id = $game_id;
  29                 $this->_game_date = $res[0][self::GAME_DATE];
  30             }
  31             else {
  32                 throw Exeption('Neplatne game_id');
  33             }
  34         }
  35
  36
  37         public function getPlayerList()
  38         {
  39             if (null == $this->_playerlist) {
  40                 $this->_playerlist = new PlayerList();
  41
  42                 $game_table = $this->getTable();
  43                 $games_rowset = $game_table->find($this->getID());
  44                 $act_game = $games_rowset->current();
  45                 $players_rowset = $act_game->findManyToManyRowset('DbTable_Player', 'DbTable_PlayerInGame');
  46                 foreach ($players_rowset as $row) {
  47                     $player = new Player($row->player_id);
  48                     $this->_playerlist->addPlayer($player);
  49                 }
  50             }
  51             return $this->_playerlist;
  52         }
  53
  54         public function addPlayer($player)
  55         {
  56             $this->getPlayerList()->addPlayer($player);
  57             // ulozi zaznam do DB
  58             $player_in_game_table = new Model_DbTable_PlayerInGame();
  59             $player_in_game_table->insert(array(self::PLAYER_ID=>$player->getID(),
  60                                                 self::GAME_ID=>$this->getID()
  61                                         ));
  62             return $this;
  63         }
  64
  65
  66         public function getDate()
  67         {
  68             return $this->_game_date;
  69         }
  70
  71         public function getID()
  72         {
  73             return $this->_game_id;
  74         }
  75
  76         public function countPlayers()
  77         {
  78             return $this->getPlayerList()->count();
  79         }
  80
  81         public function signPlayer($palyer) {
  82         }
  83
  84
  85
  86         protected function _getNewGameDate()
  87         {
  88             $game_date = new Zend_Date();
  89             $game_date->setOptions(array('format_type'=>'php'));
  90             // nastavi utorok
  91             $game_date->setWeekday(2);
  92             //nastavi cas 18:00:00
  93             $game_date->setHour(18);
  94             $game_date->setMinute(0);
  95             $game_date->setSecond(0);
  96             if (-1 == $game_date->compare(Zend_Date::now())) {
  97                     $game_date->addWeek(1);
  98             }
  99             return $game_date;
 100         }
 101
 102         protected function _createNewGame()
 103         {
 104                 $game_date = $this->_getNewGameDate();
 105                 $game_id = $this->getTable()->insert(array('game_date'=>$game_date->toString('Y-m-j H:i:s')));
 106                 return array($game_id=>$game_date);
 107         }
 108
 109         protected function getTable()
 110         {
 111             if (null === $this->_table) {
 112                 // since the dbTable is not a library item but an application item,
 113                 // we must require it to use it
 114                 $this->_table = new Model_DbTable_Game();
 115             }
 116             return $this->_table;
 117         }
 118
 119
 120 }