<?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 Session
 *
 * @author fabi0
 */

namespace Models;

class Session {

    private $_instance = null;

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

    public static function exists($name) {

        $params = array(
            ':name' => array(
                'param' => $name,
                'type' => 1
            )
        );
        $sql = 'SELECT session_id FROM sessions WHERE session_name=:name;';
        $this->_instance->query($sql, $params);
        if ($this->_instance->getCount()) {
            return TRUE;
        } else {
            return FALSE;
        }
    }

    public static function get($name) {
        $params = array(
            ':name' => array(
                'param' => $name,
                'type' => 2
            )
        );
        $sql = 'SELECT session_object FROM sessions WHERE session_name=:name;';
        $this->_instance->query($sql, $params);
        if ($this->_instance->getCount()) {
            return $this->_instance->getResult()[0]->session_object;
        } else {
            return FALSE;
        }
    }

    public static function createSession($array) {
        @$expire = $array['remember_me'];
        unset($array['remember_me']);
        $array = base64_encode(serialize($array));
        $salt = uniqid(rand(), true);
        $session_name = sha1($salt . $salt);
        $params = array(
            ':salt' => array(
                'param' => $salt,
                'type' => 2
            ),
            ':name' => array(
                'param' => $session_name,
                'type' => 2
            ),
            ':object' => array(
                'param' => $array,
                'type' => 2
            ),
            ':time' => array(
                'param' => time(),
                'type' => 1
            ),
            ':expire' => array(
                'param' => (int) $expire,
                'type' => 1
            )
        );
        $sql = "INSERT INTO `sessions` "
                . "( `session_salt`, `session_name`, `session_object`, `session_create`, `session_expire`) "
                . "VALUES (:salt, :name, :object, :time, :expire);";
        $this->_instance->query($sql, $params);
        return $session_name;
    }

    public static function delete($name) {
        $params = array(
            ':name' => array(
                'param' => $name,
                'type' => 2
            )
        );
        $sql = "DELETE FROM sessions WHERE session_name = :name";
        $this->_instance->query($sql, $params);
        return true;
    }

    public static function update($name, $data) {
        // TODO
        $database = \Models\DB::getInstance();
    }

}