<?php 
/**
 * Classe para registros de usuários
 *
 * @package TutsupMVC
 * @since 0.1
 */

class FeedbackModel
{

	/**
	 * $form_data
	 *
	 * Os dados do formulário de envio.
	 *
	 * @access public
	 */	
	public $form_data;

	/**
	 * $form_msg
	 *
	 * As mensagens de feedback para o usuário.
	 *
	 * @access public
	 */	
	public $form_msg;

	/**
	 * $db
	 *
	 * O objeto da nossa conexão PDO
	 *
	 * @access public
	 */
	public $db;

	/**
	 * Construtor
	 * 
	 * Carrega  o DB.
	 *
	 * @since 0.1
	 * @access public
	 */
	public function __construct( $db = false ) {
		$this->db = $db;
	}
                
        public function get_feedback($tipo = null,$orderr = null) {                
                 if($tipo == null){$tipo = 1;}
                 if($orderr == null || $orderr == 'data'){ $order = "ORDER BY id ASC";}
                 else if($orderr == 'titulo'){ $order = "ORDER BY titulo ASC";}                 
                 else { $order = "ORDER BY id ASC";}
		// Simplesmente seleciona os dados na base de dados 
                $query =  $this->db->query('SELECT * FROM `feedback`'.$order);
		//$query = $this->db->query('SELECT * FROM `logger` ORDER BY id DESC');		
		return $query->fetchAll();
	} // get_user_list
        
     public function get_feedback_coments(){
         $query =  $this->db->query('SELECT * FROM `feedback_comentarios`');		
	return $query->fetchAll();
     }
     public function  deletar($id){
         $query = $this->db->delete( 'feedback', 'id', $id );
                 $user_name = explode(' ',$_SESSION['userdata']['user_name']);
                $logger = $this->db->insert('logger', array('desc' => "Removeu um FeedBack ",'tipo' => "3",'user_name'=>$user_name[0],'time'=>time(),'link'=>HOME_URI.'tarefas'));
                
                $user_name = explode(' ',$_SESSION['userdata']['user_name']);
                $logger = $this->db->insert('logger', array('desc' => "Deletou um FeedBack",'tipo' => "3",'id_user'=>$_SESSION['userdata']['user_id'],'user_name'=>$user_name[0],'time'=>time(),'link'=>HOME_URI.'tarefas'));   
        }
        
        public function  deletarcomentario($id){
         $query = $this->db->delete( 'feedback_comentarios', 'id', $id );
                 $user_name = explode(' ',$_SESSION['userdata']['user_name']);
                $logger = $this->db->insert('logger', array('desc' => "Removeu um Comentario FeedBack ",'tipo' => "3",'user_name'=>$user_name[0],'time'=>time(),'link'=>HOME_URI.'tarefas'));

                $user_name = explode(' ',$_SESSION['userdata']['user_name']);
                $logger = $this->db->insert('logger', array('desc' => "Deletou um comentario do FeedBack",'tipo' => "3",'id_user'=>$_SESSION['userdata']['user_id'],'user_name'=>$user_name[0],'time'=>time(),'link'=>HOME_URI.'tarefas'));   
        }
        public function alterar_status($id,$status){
            $this->db->update('feedback', 'id', $id, array('status'=>$status));
            $user_name = explode(' ',$_SESSION['userdata']['user_name']);
                $logger = $this->db->insert('logger', array('desc' => "Alterou o Status de um FeedBack",'tipo' => "3",'id_user'=>$_SESSION['userdata']['user_id'],'user_name'=>$user_name[0],'time'=>time(),'link'=>HOME_URI.'tarefas'));   
        }
        public function alterar_status_c($id,$status){
            $this->db->update('feedback_comentarios', 'id', $id, array('status'=>$status));
            $user_name = explode(' ',$_SESSION['userdata']['user_name']);
            $logger = $this->db->insert('logger', array('desc' => "Alterou o Status de um FeedBack",'tipo' => "3",'id_user'=>$_SESSION['userdata']['user_id'],'user_name'=>$user_name[0],'time'=>time(),'link'=>HOME_URI.'tarefas'));               
        }

        public function get_list_feedback_busca($busca = null) {                                                     
                    $query =  $this->db->query('SELECT * FROM `feedback` WHERE `titulo` like "%'.$busca.'%" or `titulo` like "%'.$busca.'%" or `texto` like "%'.$busca.'%"  or `email` like "%'.$busca.'%"');
		//$query = $this->db->query('SELECT * FROM `logger` ORDER BY id DESC');		
		return $query->fetchAll();                
	} // get_user_list
        public function get_feedback_count() {	
		// Simplesmente seleciona os dados na base de dados 
		$query2 = $this->db->query('SELECT * FROM `feedback` ORDER BY id DESC');		
		$data = $query2->fetchAll();
                $in = count($data);
                return $in;
	} // get_user_list
        public function get_feedback_coment_count() {	
		// Simplesmente seleciona os dados na base de dados 
		$query2 = $this->db->query('SELECT * FROM `feedback_comentarios` ORDER BY id DESC');		
		$data = $query2->fetchAll();
                $in = count($data);
                return $in;
	} // get_user_list
        
}