<?php
/**
 * Class Get
 *
 * @author suxoza <suxoza@gmail.com>
 */


class Get extends Base_class{
    
    public  $_url_masiv_2;
    protected $URL;
    public $if_view_fb_comments;
    
    
    
    public function __construct(){
      parent::__construct();
      $this->URL = explode('/',urldecode($_SERVER['REQUEST_URI']));
      $this->make_url();

      $this->return_link_to_id(126);
	
      //$this->visitors();
    }
    
    public function make_url(){
        $_ = $this;

            $_->make_masiv();
            $_->menu_names(1);

            $lang = $_->_lang == 'Georgia'?1:2;
            $_->_url = isset($_->URL[$lang])?$_->URL[$lang]:$_->URL[$lang - 1];
            $_->_url = (!$_->_url || strlen($_->_url) < 3)?'/':$_->_url;
	    $_->_url = explode('?', $_->_url)[0];
	    try{
                if($_->_url && in_array($_->_url,$_->_url_masiv['Geo']))
                   $_->reflection($_->_url_masiv,__CLASS__);  
                elseif($_->_url && in_array($_->_url,$_->_url_masiv_2['Geo']))
                   $_->reflection($_->_url_masiv_2,__CLASS__); 
                ///widgets
                elseif($_->_url && in_array($_->_url,$_->_menu_['_page_url'])){
                    $reflection = new ReflectionClass(__CLASS__);
                    echo $reflection->getMethod('all_pages')->invoke($_,$_->_url);
                }
                ///end widgets
                else  throw new Page_not_found; 
            }catch(Page_not_found $ex){
                $_->smarty->template_dir = $_->_dir.'view/templates_1';
                die($this->render('404',["menu" => $_->_menu_,'message' => $ex->getMessage()]));
                              
            }
    }


    private function visitors(){
        $_ = $this;
        $getOS = $this->getOS();
        if(!$getOS)return;
        $ip = $_SERVER['REMOTE_ADDR'];
        $session = session_id();
        if(!isset($_SESSION['visitors'])){
            $sql = "insert into visitors(ip,user_agent,user,date) values ('".$ip."','".$_SERVER["HTTP_USER_AGENT"]."','".$getOS."',".time().")";
            $_->con->exec($sql);
            $_SESSION['visitors'] = $ip;
        }

        $sql = $_->join_select("select count(date) as date from visitors_now where ip = '".$ip."' and timest > DATE_SUB(now(), INTERVAL 3 minute)","small");
        if(!$sql['date'])$_->insert("visitors_now",[["ip","date","user"],[$ip,time(),$session]]);

    }

    public function make_masiv(){
        parent::make_masiv();

        $this->_url_masiv_2 = [
            //'Eng' => ['','page'],
            'Geo' => ['exit','page','lang','/','date','rss','search'],
            ['exit_user','page','lang','homePage','search_from_date','rss','search_from_text']
        ];
    }

    public function homePage($a){
        $_ = $this;
    }
    
    public function exit_user($a){
        session_destroy();
        header("Location:/");
    }
    
    public function Hello_word($a){
      $_ = $this;
      $name = $_->select('url_'.$_->_lang,"menu","small",["home_page",1]);
      // if($a == '/')
      //   return $_->homePage($a);
      $_->its_home_page = 1;
      $_->all_pages($name); 

    }
    
    public function lang($a){
        $_ = $this;
        try{
            $lang = $this->URL[array_search('lang',$this->URL) + 1];
            if(!$lang)throw new Exception('language error');
            $_SESSION['language'] = $lang;
            header("location:".$_SERVER['HTTP_REFERER']);
        }catch(Exception $ex){
           die($ex->getMessage()); 
        }
    }

    public function search_from_date($a){
      $_ = $this;

      $date = array_search($a,$_->URL) + 1;
      if(!isset($_->URL[$date]))
          throw new Page_not_found;
      $exp = explode('-', $_->clier(addslashes($_->URL[$date])));
      if(count($exp) != 3)
          throw new Page_not_found;  
      list($day, $month, $year) = $exp; 
      $dt = strtotime($_->clier(addslashes($_->URL[$date])));


      $sql = "
           select 
              t.menu_id,
              t1.*,
              t2.name_".$_->_lang." as menu_name,t2.url_".$_->_lang." as menu_url
            from menu_body t 
            join body t1 on t1.id = t.body_id and (DATE_FORMAT(from_unixtime(t1.page_date), '%Y-%m-%d') = date('".date("Y-m-d",$dt)."'))
            join menu t2  on t2.id = t.menu_id and t2.search_with_calendar = 1
              where 1 group by t1.id order by t2.id desc 

          ";
      $obj = new stdClass();
      $obj->c_type = "navigation";
      $obj->navig_name = (($_->URL[1] == 'en' && isset($_->URL[2]))?'en/'.urldecode($_->URL[2]).'/'.urldecode($_->URL[3]):urldecode($_->URL[1]).'/'.urldecode($_->URL[2]));
      $obj->navigation = array_search('navigation', $_->URL) && isset($_->URL[array_search('navigation', $_->URL) + 1])?(int)$_->URL[array_search('navigation', $_->URL) + 1]:1;
      $obj->count_on_one_page = 10;
      $obj->without_li = true;    

      $select_body = $_->select_([$sql,$obj]);
      if(isset($select_body['navigation']))
         $select_body['navigation'] = $_->navigation($select_body['navigation'],$obj->navigation);
     


      $name = $_->select('url_'.$_->_lang,"menu","small",["home_page",1]);
      $select_body['template_dir'] = $_->_dir.'templates/game_on/templates_1';
      $select_body['more_name_'] = ($_->URL[1] == 'en' && isset($_->URL[2]))?urldecode($_->URL[3]):urldecode($_->URL[2]);
      $_->reversed_link = 'date';
      $_->all_pages($name,$select_body);
   }


   public function search_from_text($a){
      $_ = $this;
      if(!(isset($_SESSION['search_string']) && $_SESSION['search_string'])){
        $_->smarty->template_dir = $_->_dir.'view/templates_1';
        die($this->render('404',["menu" => $_->_menu_,'message' => "გვერდი ვერ მოიძებნა"]));
      }
      $search = $_->clier($_SESSION['search_string']);
      $sql = "
           select 
              t.menu_id,
              t1.*,
              t2.name_".$_->_lang." as menu_name,t2.url_".$_->_lang." as menu_url
            from menu_body t 
            join body t1 on t1.id = t.body_id
            join menu t2  on t2.id = t.menu_id 
              where 1 
            and (t1.name_".$_->_lang." like '%".$search."%' or t1.body_".$_->_lang." like '%".$search."%' or t2.name_".$_->_lang." like '%".$search."%')
              group by t1.id order by t2.id desc 

          ";
      $obj = new stdClass();
      $obj->c_type = "navigation";
      $obj->navig_name = (($_->URL[1] == 'en' && isset($_->URL[2]))?'en/'.urldecode($_->URL[1]).'/'.urldecode($_->URL[2]):urldecode($_->URL[1]));
      $obj->navigation = array_search('navigation', $_->URL) && isset($_->URL[array_search('navigation', $_->URL) + 1])?(int)$_->URL[array_search('navigation', $_->URL) + 1]:1;
      $obj->count_on_one_page = 10;
      $obj->without_li = true;    

      $select_body = $_->select_([$sql,$obj]);
      if(isset($select_body['navigation']))
         $select_body['navigation'] = $_->navigation($select_body['navigation'],$obj->navigation);
     


      $name = $_->select('url_'.$_->_lang,"menu","small",["home_page",1]);
      $select_body['template_dir'] = $_->_dir.'templates/game_on/templates_1';
      $select_body['more_name_'] = ($_->URL[1] == 'en' && isset($_->URL[2]))?urldecode($_->URL[2]):urldecode($_->URL[1]);
      $_->reversed_link = 'date';
      $_->all_pages($name,$select_body);
   }
    
   public function rss($a){
      $_ = $this;
      header('Content-Type: application/rss+xml; charset=UTF-8');
      die(require_once("Smarty/rss.php"));
   } 
 
    

    

    
    
 
    
}