Ejemplo n.º 1
0
 public function indexAction()
 {
     $this->view->title = "Users";
     $this->view->headTitle($this->view->title, 'PREPEND');
     $users = new Model_DbTable_Users();
     $this->view->users = $users->fetchAll();
 }
Ejemplo n.º 2
0
 public function ajaxdavaaresultAction()
 {
     $davaa_num = $this->_request->getParam('davaa_num');
     $fantasy_id = $this->_request->getParam('fantasy_id');
     $galuud = new Model_DbTable_Gal();
     $gal = $galuud->fetchAll($galuud->select());
     $galname = array();
     $galezenid = array();
     foreach ($gal as $key => $value) {
         $galname[$value['id']] = $value['name'];
         $galezenid[$value['id']] = $value['ezen_id'];
     }
     $users = new Model_DbTable_Users();
     $user = $users->fetchAll($users->select());
     $usr = array();
     foreach ($user as $key => $value) {
         $usr[$value['id']] = $value['lastname'] . ' ' . $value['firstname'];
     }
     $davaas = new Model_DbTable_Davaagal();
     $davaa = $davaas->fetchAll($davaas->select()->where('fantasy_id = ' . $fantasy_id . ' AND davaa_num = ' . $davaa_num)->order('score DESC'));
     $galid = 0;
     $cnt = 5;
     $ret = array();
     foreach ($davaa as $key => $val) {
         $ret[] = array('galname' => $galname[$val['gal_id']], 'score' => $val['score'], 'username' => $usr[$galezenid[$val['gal_id']]], 'galid' => $val['gal_id'], 'davaa' => $davaa_num);
     }
     echo Zend_Json::encode($ret);
 }