<?php
class Game_get extends Render{
    
    public  $_url_masiv_2;
    const   session_id                  = 'game_process_maines';
    const   select_last_qustion_id      = 'select_last_qustion_id_maines';
    private $_game_duration             =  15;
    const   global_time                 = 'game_time';
    private $URL;
    const   question_max_count          = 50;
    
    
    
    public function __construct(){
      parent::__construct();
      $this->URL = explode('/',urldecode($_SERVER['REQUEST_URI']));
      $this->make_url();
      
    }
    

    
    public function make_url(){
        $_ = $this;
        $_->make_masiv();
        $lang = 1;
        $_->_url = $_->URL[$lang];
        $_->_url = (!$_->_url || strlen($_->_url) < 2)?'/':$_->_url;
        //echo $_->_url.' '.$_->_lang;
       // $_->pre($_->_url_masiv[$_->_lang]);
        if($_->_url && in_array($_->_url,$_->_url_masiv[$_->_lang]))
           $_->reflection($_->_url_masiv,__CLASS__);  
        elseif($_->_url && in_array($_->_url,$_->_url_masiv_2[$_->_lang]))
           $_->reflection($_->_url_masiv_2,__CLASS__);      
        else echo Render::render('404');
        
    }


    public function make_masiv(){
        parent::make_masiv();
        $this->_url_masiv_2 = [
            'eng' => ['olimpiad','test','fill_balance','about_project','help'],
            'geo' => ['ოლიმპიადა','სატესტო','ცდების_დამატება','პროექტის_შესახებ','დახმარება'],
            ['game','game','balance','about','rules']
        ];
    }
    
    



    public function about($a){
       $_ = $this;
       $bool = ($_->_game_id)?true:false;
       $bool_status = ($_->_game_id && $_->game_user('status'))?true:false;

       $this->render('about',
                                  ["user_is_available" => $bool,
                                   "user_info" =>  ($_->_game_id)?$_->game_user():'',    
                                   "user_is_available_status" => $bool_status,
                                   '_news' => $_->_news_view(),    
                                   'url' => $_->lang_url]);     
    }
    
    public function rules($a){
       $_ = $this;
       $bool = ($_->_game_id)?true:false;
       $bool_status = ($_->_game_id && $_->game_user('status'))?true:false;

       $this->render('wesebi',
                                  ["user_is_available" => $bool,
                                   "user_info" =>  ($_->_game_id)?$_->game_user():'',     
                                   "user_is_available_status" => $bool_status,
                                   '_news' => $_->_news_view(),   
                                   'url' => $_->lang_url]);     
    }
    
   
   

    public function balance($a){
        $_ = $this;
        //$_->pre($_->lang_url);
        try{
            if(!$_->_game_id)throw new Exception("user not found");
        }catch (Exception $exc) {
            header("Location:/");
        }

        $bool_status = ($_->_game_id && $_->game_user('status'))?true:false;
            if(!$_->_game_id)$this->render('404',["img" => "error_403.jpg"]);
                    $this->render('balance',
                                        ["user_is_available" => true,
                                         "user_info" =>  ($_->_game_id)?$_->game_user():'',     
                                         "user_is_available_status" => $bool_status,
                                         'url' => $_->lang_url,
                                         'url_location' => $a,
                                         '_news' => $_->_news_view()
                            ]);
            
                
        }

      

    public function game($a){
        $_ = $this;
         $URL = explode('/',urldecode($_->clier($_SERVER['REQUEST_URI'])));
        //if(!$_->_game_id)$this->render('404',["img" => "error_403.jpg"]);
        
            //$_->pre($_->_url);
        if($_SERVER['REQUEST_METHOD'] == 'POST')exit;
            //$_->pre($_SERVER);
            //exit;
        else{
           
           
            $IDS = $URL[count($URL) - 1]; 
            $_->sagani =  array_search($IDS,$_->ini('sagani'));
            if(!is_numeric($_->sagani))$_->sagani = 8;
            $_SESSION['sagani_variable'] = $_->sagani;
            
            //echo $_SESSION['sagani_variable'];
        }   
        if(!is_numeric($IDS)){
            //$_->game_2($a);
           // return;
            
        }    
            //if(isset($_SESSION['game_process']))unset($_SESSION['game_process']);
                     //$_->pre($_->game_user('klasi'));

                   // $_->pre($configuration);
                    
                    
                 // $_->pre($configuration);
                     
            $bool_status = ($_->_game_id && $_->game_user('status'))?true:false;
            
            $config_menu = [
                'url'  => ['მათემატიკა','უნარები','ბიოლოგია','ქართული','ფიზიკა','გეოგრაფია','ქიმია','ისტორია'],
                'name' => ['მათემატიკა','უნარები','ბიოლოგია','ქართული ენა','ფიზიკა','გეოგრაფია','ქიმია','ისტორია'],
            ];
            
                    $bool = ($_->_game_id)?true:false;
                    $file_name = ($_->_game_id)?'_user':'_user';
                    $bool_status = ($_->_game_id && $_->game_user('status'))?true:false; 
             
                   
                    $pageid = $URL[count($URL) - 1];
                    $localoca = $URL[2];
                    $page_id = (is_numeric($pageid) && $pageid > $_->game_user('klasi'))?$pageid:$_->game_user('klasi');
  
                    $obj = new stdClass();
                    $configuration = [];  
                    $klasi = ($_->_game_id)?$_->game_user('klasi'):7;
                    
                    $obj->c_type = "big";
                    $obj->sql = " and date_end > ".time()." and klasi >= $klasi";
                    $obj->sql .= (!is_numeric($URL[count($URL) - 1]))?" and sagani = $_->sagani ":'';
                    $configuration = $_->select("*","olimpiad_menu",$obj)['body'];
                    
                    
                    
                    
                    
                    $available_klass = [];
                    for($i = 0; $i < count($configuration); $i++){
                      $available_klass[] = $configuration[$i]['klasi'];
                      $available_sagani[] = $configuration[$i]['sagani'];
                    }  
                   //$_->pre($available_klass);
                    
                    
                    $page_id = (!in_array($page_id,$available_klass))?$page_id+1:$page_id;
                    $select_raiting = '';
                    //$_->pre($configuration);
                    
                  // $_->pre($configuration);
                    
                    //if($bool){
                        $_->group_by_sagani_klasi($configuration,$page_id,[],[],[],0);
                        $user_select = $configuration;
//                         /$_->pre($configuration); 
                        $sql = "select 
                                      T.`user_id` , T.`sagani` , T.`klasi` , T.`date_start` , T.`date` , T.`answered_cost`,T.`question_count`,
                                      T3.`final_11`,T3.`final_12`
                                  FROM `game_tours_statistic` T
                                  join `user_register` T3
                                  on 
                                      T.`answered_cost` = (
                                      SELECT max( T2.`answered_cost` )
                                      FROM `game_tours_statistic` T2
                                      WHERE T2.`klasi` = T.`klasi` and T2.`sagani` = T.`sagani` and T2.`user_id` = T.`user_id`)
                                      and T3.`id` = T.`user_id`  
                                      ORDER BY T.`answered_cost` DESC,(T.date - T.date_start) asc";
//echo $sql;
                          $select_raiting = $_->join_select($sql,'big');
                         
                         // $_->pre($select_raiting);
                                if(!is_numeric($URL[count($URL) - 1])){
                                  $_user = $_->return_only_user_2($select_raiting,'sagani',$_->sagani);  
                                  //$_->pre($_user);
                                  $_->group_by_sagani_klasi($select_raiting,$_->sagani,$available_klass,$_user,$user_select,1,1);  
                                   //$_->pre($select_raiting);
                                  //echo $_->game_user('final_11');
                                }else{ 
                                  $_user = $_->return_only_user_2($select_raiting,'klasi',$page_id); 
                                  $_->group_by_sagani_klasi($select_raiting,$page_id,$available_sagani,$_user,$user_select,1,2);
                                }
                                //$_->pre($select_raiting);
//                          if(!count($select_raiting)){
//                              $select_raiting = $user_select;
//                             // $_->pre($select_raiting);
//                                for($i = 0; $i < count($select_raiting); $i++){
//                                     $arrays = ['1' => 0,'0' => 1,'6' => 2,'2' => 3,'5' => 4,'4' => 5,'7' => 6,'3' => 7,'8' => 'ena1','9' => 'ena2'];
//                                     $select_raiting[$i]['sagani_name'] = $_->ini('sagani')[$select_raiting[$i]['sagani']];
//                                     $select_raiting[$i]['sagani_image'] = $arrays[$select_raiting[$i]['sagani']]; 
//                                     $select_raiting[$i]['my_raiting'] = '---';
//                                     $select_raiting[$i]['my_raiting'] = '';
//                                     $select_raiting[$i]['raiting'] = '';
//                                }             
//                          }
//                          
                           $length = count($user_select);
                            for($i = 0; $i < $length; $i++){
                               
                              $user_select[$i]['prizes'] = (array)json_decode($user_select[$i]['prizes']); 
                               for($j = 0; $j < count($user_select[$i]['prizes']); $j++)
                                   $user_select[$i]['prizes'][$j] = (array)$user_select[$i]['prizes'][$j]; 
                              if(is_numeric($URL[count($URL) - 1]))
                                  if($user_select[$i]['klasi'] != $page_id)unset($user_select[$i]);  
                            }sort($user_select);
                          if(is_numeric($URL[count($URL) - 1])){
                            $_->maines_sort_4($user_select,'sagani');
                            $_->maines_sort_4($select_raiting,'sagani');
                          }   
                         // $_->pre($user_select);
                          
                          
                          //$_->pre($select_raiting);
                          //$select_raiting2 = $select_raiting;
                         //$_->pre($_user);
                        // $_->pre($select_raiting);
                         //$_->pre($user_select);
                          //$_->pre($select_raiting);
                       //    for($i = 0; $i < count($user_select); $i++)
                      //         $user_select[$i]['config'] = $select_raiting[$i];     
                         //$_->pre($select_raiting);
                        // $_->pre($configuration);
                        //  $_->find_in_config_2($select_raiting,$user_select);
                         // $_->return_only_user_2($select_raiting,$_->_game_id,1);
                         

                         if(!is_numeric($URL[count($URL) - 1]))$user_select = array_reverse($user_select);
                        // $_->pre($select_raiting);
                        // $_->pre($user_select);
                        // 
                        // 
                        // 
                        // $select_raiting = array_reverse($select_raiting);
                        // $_->pre($select_raiting);
                        // echo "<hr/>";
                        // $_->pre($user_select);
                         //echo mktime(0,0,0,12,12,2012);
                          //$_->pre($select_raiting);
                          //$_->pre($_SERVER);
//ceho $_->main_xesh_2(25,2);
                   // }   
                    //if(count($URL) <= 3 || !is_numeric($pageid))header("Location:".urldecode($_->clier($_SERVER['REQUEST_URI'])).'/'.$page_id);
//                    if(!$_->_game_id)
                    $page_masiv = [
                                   "only_klases" => true,
                                   "user_is_available" => $bool,
                                   "user_is_available_status" => $bool_status,
                                   "user_info" =>  ($_->_game_id)?$_->game_user():['klasi' => 7],  
                                   'url' => $_->lang_url,
                                   'klasi' => ($_->_game_id)?$_->game_user('klasi'):$page_id, 
                                   'klasi_2' => $page_id,
                                   'available_sagani' => $_->available_sagani(),     
                                   'url_location' => $a,
                                   'config_menu' => $config_menu,
                                   'config' => $configuration,
                                   'cdebi'  => $_->user_balance('cdebi'),   
                                   'status' => $_->game_user('status'),
                                   'ini'    => $_->return_url_for_redirect($this->_lang),
                                   'available_klass' => $available_klass,
                                   'page_id' => $page_id,
                                   'localoca' => $localoca,   
                                   'select_function_function' => $user_select,
                                   'masiv' => $select_raiting
                                   
                                   ];
//                    else 
//                           $page_masiv = [
//                                   "only_klases" => true,
//                                   "user_is_available" => $bool,
//                                   "user_is_available_status" => $bool_status,
//                                   "user_info" =>  ($_->_game_id)?$_->game_user():['klasi' => 7],  
//                                   'url' => $_->lang_url,
//                                   'klasi' => $page_id, 
//                                   'klasi_2' => $page_id,
//                                   'available_sagani' => $_->available_sagani(),     
//                                   'url_location' => $a,
//                                   'config_menu' => $config_menu,
//                                   'config' => $configuration,
//                                   'cdebi'  => '',   
//                                   'ini'    => $_->return_url_for_redirect($this->_lang),
//                                   'available_klass' => $available_klass,
//                                   'page_id' => $page_id,
//                                   'localoca' => $localoca,   
//                                   'select_function_function' => $_->available_sagani_guest($page_id),
//                                   ];
                    //$_->pre($_->available_sagani_guest($page_id));
                    
            $this->render('_game'.$file_name,$page_masiv);
            
          
        
    }
    
    private function game_2($a){
        $_ = $this;
        
        $URL = explode('/',urldecode($_->clier($_SERVER['REQUEST_URI'])));
        $IDS = $URL[count($URL) - 1]; 
        
        //$_->pre($_->return_url_for_redirect($this->_lang));
        //$_->pre($_->available_sagani(7));
        $bool = ($_->_game_id)?true:false;
        $file_name = ($_->_game_id)?'_user':'_guest';
        $bool_status = ($_->_game_id && $_->game_user('status'))?true:false; 
        
        
        $obj = new stdClass();
        $configuration = [];  
        $obj->c_type = "big";
        $klasi = ($_->_game_id)?$_->game_user('klasi'):7;
        $obj->sql = " and date_end > ".time()." and sagani = $_->sagani  and klasi >= ".$klasi." ";
        $configuration = $_->select("*","olimpiad_menu",$obj)['body'];
        
        $array = ['1' => 0,'0' => 1,'6' => 2,'2' => 3,'5' => 4,'4' => 5,'7' => 6,'3' => 7,'8' => 'ena1','9' => 'ena2'];
        $sagani_image = $array[$_->sagani];
        $sagani_id = $_->sagani;
        
         //$_->pre($_->return_url_for_redirect($this->_lang));
       
        
         $maines_config = [];
         $klasebi = []; 
         for($i = 0; $i < count($configuration); $i++){
           $klasebi[] = $configuration[$i]['klasi'];  
           if($_->game_user)  
              $maines_config[$configuration[$i]['klasi']] = $_->available_sagani($configuration[$i]['klasi']);
           else
              $maines_config[$configuration[$i]['klasi']] = $_->available_sagani_guest($configuration[$i]['klasi']);  
         }
         sort($klasebi);
        
        if($_->_game_id)
                    $page_masiv = [
                                   "only_klases"      => false,
                                   "sagani"           => $IDS, 
                                   "user_is_available" => $bool,
                                   "user_is_available_status" => $bool_status,
                                   "user_info" =>  ($_->_game_id)?$_->game_user():'',  
                                   'url' => $_->lang_url,
                                   'available_sagani' => $_->available_sagani(),     
                                   'url_location' => $a,
                                   'sagani_image' => $sagani_image,
                                   'sagani_id' => $sagani_id,
                                  // 'config_menu' => $config_menu,
                                   'config' => $configuration,
                                   'cdebi'  => $_->user_balance('cdebi'),   
                                   'status' => $_->game_user('status'),
                                   'ini'    => $_->return_url_for_redirect($this->_lang),
                                 //  'available_klass' => $available_klass,
                                  // 'localoca' => $localoca,   
                                   'select_function_function' => $_->available_sagani(),
                                   'maines_config' => $maines_config,
                                   'klasebi' => $klasebi
                                   ];
                    else 
                           $page_masiv = [
                                   "only_klases" => false,
                                   "sagani"           => $IDS, 
                                   "user_is_available" => $bool,
                                   "user_is_available_status" => $bool_status,
                                   "user_info" =>  ($_->_game_id)?$_->game_user():['klasi' => 7],  
                                   'url' => $_->lang_url,
                                   'available_sagani' => $_->available_sagani(),     
                                   'url_location' => $a,
                                   'sagani_image' => $sagani_image,
                                   'sagani_id' => $sagani_id,
                                 //  'config_menu' => $config_menu,
                                   'config' => $configuration,
                                   'cdebi'  => '',   
                                   'ini'    => $_->return_url_for_redirect($this->_lang),
                                //   'available_klass' => $available_klass,
                                 //  'localoca' => $localoca,   
                                   'select_function_function' => $_->available_sagani_guest(),
                                   'maines_config' => $maines_config,
                                   'klasebi' => $klasebi
                                   ];
                  //  $_->pre($page_masiv);
      $this->render('_game'.$file_name,$page_masiv);
    }
    
    
    
    
 
    

    

    
    
 
    
}