<?php
class ChatModel extends MainModel
{
	/**
	 * Construtor para essa classe
	 *
	 * Configura o DB, o controlador, os parâmetros e dados do usuário.
	 *
	 * @since 0.1
	 * @access public
	 * @param object $db Objeto da nossa conexão PDO
	 * @param object $controller Objeto do controlador
	 */
	public function __construct( $db = false, $controller = null ) {
		// Configura o DB (PDO)
		$this->db = $db;
		
		// Configura o controlador
		$this->controller = $controller;

		// Configura os parâmetros
		$this->parametros = $this->controller->parametros;

		// Configura os dados do usuário
		$this->userdata = $this->controller->userdata;
		
	}
        
        public function pegarchat($me,$you){            
               $query =  $this->db->query('SELECT * FROM `chat` WHERE (`from` like "%'.$me.'%" and `to` like "%'.$you.'%") or (`from` like "%'.$you.'%"  and `to` like "%'.$me.'%")');
               $add = $query->fetchAll();              
                return $add;               
        }
        public function atualizachat($me,$you){            
               $query =  $this->db->query('SELECT * FROM `chat` WHERE (`from` like "%'.$me.'%" and `to` like "%'.$you.'%") or (`from` like "%'.$you.'%"  and `to` like "%'.$me.'%") ');
               $add = $query->fetchAll();
               foreach ($add as $up){
                  $this->db->update('chat', 'id', $up['id'], array('see' => 1,'see_time'=>time()));
               }                               
        }
        
        
function chatHeartbeat() {
        $query = $this->db->query("select * from chat where (chat.to = '" . $_SESSION['username'] . "' AND recd = 0) order by id ASC");
        $qq = $query->fetchAll();
        $items = '';
        $chatBoxes = array();
        foreach ($qq as $chat) {

$text = @ereg_replace("[[:alpha:]]+://[^<>[:space:]]+[[:alnum:]/]",                   '<a target=\"_blank\" style=\"color:#000;text-decoration:none;color:#000000;background-color:; padding:0px; text-decoration:none; \" href=\"\\0">\\0<\/a>', $chat['message']);
            $items .= <<<EOD
					   {
			"s": "0",
			"f": "{$chat['from']}",
			"m": "{$chat['message']}"
	   },
EOD;


            $_SESSION['chatHistory'][$chat['from']] .= <<<EOD
						   {
			"s": "0",
			"f": "{$chat['from']}",
			"m": "{$chat['message']}"
	   },
EOD;

            unset($_SESSION['tsChatBoxes'][$chat['from']]);
            $_SESSION['openChatBoxes'][$chat['from']] = $chat['sent'];
        }

        $query = $this->db->update('chat', 'to', $_SESSION['username'],  array('recd' => '1')); //retirar daqui|

        if ($items != '') {
            $items = substr($items, 0, -1);
        }
        header('Content-type: application/json');
?>
        {
        		"items": [
        <?php echo $items; ?>
                ]
        }
        <?php
        exit(0);
    }

function confirmarmsg() {
    $query = $this->db->update('chat', 'to', $_SESSION['username'] , array('recd' => '1')); //retirar daqui|
}

public function enviarmsgm($from,$to,$message){
    
	
	$data = date('Y-m-d H:i:s', time());
        
        $this->db->insert('chat', array('from' => $from ,'to' => $to , 'message'=>$message,'sent'=>$data,'time'=>time()));   
	
	echo "1";
	exit(0);
}

public function verificar($me){            
               $query =  $this->db->query('SELECT * FROM `chat` WHERE (`to` like "%'.$me.'%" and `see` like "0")');
	       $val = $query->fetchAll();                 
               echo count($val);                
        }
        public function verificarr($me){            
               
        $query = $this->db->query('SELECT * FROM `chat` WHERE (`to` like "%'.$me.'%" and `see` like "0")');
        $qq = $query->fetchAll();
        $items = '';
        $chatBoxes = array();
        $s = 0;
        foreach ($qq as $chat) {
            
            $query =  $this->db->query('SELECT * FROM `chat` WHERE (`from` like "%'.$chat['from'].'%" and `to` like "%'.$chat['to'].'%" and `see` like "0")');
            $val = $query->fetchAll();            
            $vall = count($val);
            
            $items .= <<<EOD
					   {
			"s": "{$vall}",
			"f": "{$chat['from']}",
			"m": "{$chat['message']}"
	   },
EOD;

        }

        

        if ($items != '') {
            $items = substr($items, 0, -1);
        }
        header('Content-type: application/json');
?>
        {
        		"items": [
        <?php echo $items; ?>
                ]
        }
        <?php
        exit(0);            
        }
         public function getlog($id){         
             $query =  $this->db->query('SELECT * FROM `chat` WHERE (`from` like "%'.$id.'%" and `to` like "%'.$_SESSION['userdata']['user_id'].'%") or (`to` like "%'.$id.'%"  and `from` like "%'.$_SESSION['userdata']['user_id'].'%") ORDER BY id DESC');
              return $query->fetchAll();                             		
         }
         
         public function get_list_logger_busca($id,$texto){         
             $query =  $this->db->query('SELECT * FROM `chat` WHERE (`from` like "%'.$_SESSION['userdata']['user_id'].'%" or `to` like "%'.$_SESSION['userdata']['user_id'].'%") and (`message` like "%'.$texto.'%") ORDER BY id DESC');
             return $query->fetchAll();                             		
         }
         
         public function getuser($id){         
             $query = $this->db->query('SELECT * FROM `users` WHERE `user_id` = ?', array($id));						
              return $query->fetchAll();                             		
         }
         public function getlogmax($id,$start){         
             $paginas = $this->db->query (
			'SELECT * FROM `logger` WHERE `id_user` = ?  ORDER BY id DESC LIMIT '.$start.',3', 
			array($id)
		);
		// Preenche a tabela com os dados do usuário
		return $paginas->fetchAll();
         }
}