<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /var/www/jonas-eriksen.dk/pic/private/index.php:1) in <b>/var/www/jonas-eriksen.dk/pic/private/index.php</b> on line <b>215</b><br />
<?php

class event
{
    private $db;

    function __construct($DB_con)
    {
        $this->db = $DB_con;
    }

    public function newEvent($year, $shooterId, $point, $crossTen, $typeId)
    {
        try {
            $stmt = $this->db->prepare("INSERT INTO result_event (year, shooterId, point, `cross`, type, date) VALUES (:year, :userId, :point, :crossTen, :typeId, :date)");
            $stmt->execute(array(":year" => $year, ":userId" => $shooterId, ":point" => $point, ":crossTen" => $crossTen, ":typeId" => $typeId, ":date" => date("Y/m/d")));

            return $stmt;
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function getAll($eventYear)
    {
        try {
            $stmt = $this->db->prepare("SELECT result_users.fullname, result_event.point, result_event.`cross`, result_weapon.name, result_event.shooterId, result_users.id, result_weapon.id, result_event.`type`, result_event.year, result_event.id FROM result_event JOIN result_users on result_event.shooterId = result_users.id JOIN result_weapon on result_event.type = result_weapon.id WHERE result_event.year = :eventYear AND result_users.isDeleted != 1 ORDER BY result_event.id");
            $stmt->execute(array(":eventYear" => $eventYear));
            $result = $stmt->fetchAll();
            return $result;
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function getAllForUser($eventYear, $userId)
    {
        try {
            $stmt = $this->db->prepare("SELECT result_event.id, result_event.point, result_event.`cross`, result_weapon.name, result_event.shooterId, result_users.id, result_weapon.id, result_event.`type`, result_event.year, result_event.date FROM result_event JOIN result_users on result_event.shooterId = result_users.id JOIN result_weapon on result_event.type = result_weapon.id WHERE result_event.year = :eventYear AND result_users.id = :userId ORDER BY result_event.id");
            $stmt->execute(array(":eventYear" => $eventYear, ":userId" => $userId));
            $result = $stmt->fetchAll();
            return $result;
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function getAllForUserForPrint($userId)
    {
        try {
            $stmt = $this->db->prepare("SELECT result_event.id, result_event.point, result_event.`cross`, result_weapon.name, result_event.shooterId, result_users.id, result_weapon.id, result_event.`type`, result_event.year, result_event.date FROM result_event JOIN result_users on result_event.shooterId = result_users.id JOIN result_weapon on result_event.type = result_weapon.id WHERE result_users.id = :userId ORDER BY result_event.year, result_event.id");
            $stmt->execute(array( ":userId" => $userId));
            $result = $stmt->fetchAll();
            return $result;
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function getYearCount($eventYear)
    {
        try {
            $stmt = $this->db->prepare("SELECT id FROM result_event WHERE result_event.year = :eventYear");
            $stmt->execute(array(":eventYear" => $eventYear));
            echo $stmt->rowCount();
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function getYearCountForUser($eventYear, $userId)
    {
        try {
            $stmt = $this->db->prepare("SELECT id FROM result_event WHERE result_event.year = :eventYear AND shooterId = :userId");
            $stmt->execute(array(":eventYear" => $eventYear, ":userId" => $userId));
            echo $stmt->rowCount();
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function getYears()
    {
        try {
            $stmt = $this->db->prepare("SELECT year FROM result_event GROUP BY year ORDER BY year DESC LIMIT 10");
            $stmt->execute();
            $result = $stmt->fetchAll();
            return $result;
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function getYearsForUser($userId)
    {
        try {
            $stmt = $this->db->prepare("SELECT year FROM result_event WHERE shooterId = :shooterId GROUP BY year ORDER BY year DESC LIMIT 10");
            $stmt->execute(array(":shooterId" => $userId));
            $result = $stmt->fetchAll();
            return $result;
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function getEvent($eventId)
    {
        try {
            $stmt = $this->db->prepare("SELECT point, `cross`, date, user2.shooterId, fullname, user2.id FROM result_event JOIN result_users user2 on result_event.shooterId = user2.id JOIN result_weapon rw on result_event.type = rw.id WHERE result_event.id = :eventId");
            $stmt->execute(array(":eventId" => $eventId));
            $event = $stmt->fetch();
            return $event;
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

    public function updateEvent($eventId, $point, $cross)
    {
        try {
            $stmt = $this->db->prepare("UPDATE result_event SET point = :point, `cross` = :cross WHERE id = :id");
            $stmt->execute(array(":point" => $point, ":cross" => $cross, ":id" => $eventId));
            return true;
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

}