<?php

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of Messages
 *
 * @author fabi0
 */

namespace Models;

class Messages {

    private $_databaseInstance = Null;

    public function __construct($databaseInstance) {
        $this->_databaseInstance = $databaseInstance;
    }

    public function getMessages($settingsInstance, $user_id, $from) {

        $sql = "SELECT * FROM messages WHERE message_to = :user_id LIMIT " . $from . ", " . $settingsInstance->getMessagePerPage();
        $params = array(
            ':user_id' => array(
                'param' => $user_id,
                'type' => 1
            )
        );
        $this->_databaseInstance->query($sql, $params);
        return (array) $this->_databaseInstance->getResult();
    }

    public function sendMessage($user_id, $to, $message) {
        $sql = "INSERT INTO `iziforum`.`messages` "
                . "(`message_id`, `message_from`, `message_to`, `message_date`, `message_content`, `message_read`) "
                . "VALUES (NULL, :from, :to, " . time() . ", :message, '0');";
        $params = array(
            ':from' => array(
                'param' => $user_id,
                'type' => 1
            ),
            ':to' => array(
                'param' => $to,
                'type' => 1
            ),
            ':message' => array(
                'param' => $message,
                'type' => 2
            )
        );
        $this->_databaseInstance->query($sql, $params);
    }

    public function deleteMessage($message_id) {
        $sql = "DELETE FROM `messages` WHERE `messages`.`message_id` = :message_id";
        $param = array(
            ':message_id' => array(
                'param' => $message_id,
                'type' => 1
            )
        );
         $this->_databaseInstance->query($sql, $param);
    }

}