<?php if ( ! defined('BASEPATH')) exit ('No direct script access allowed');
/**
 * User: Vlade
 * Date: 4/14/11
 * Time: 2:09 PM
 */

/**
 * @property CI_DB_active_record $db
 */

class Admin_model extends CI_Model{

    function __construct(){
        parent::__construct();
    }

    function insertAdmin($username, $email, $password){
        $sql = "INSERT INTO users VALUES ('','$username','$email',SHA1('$password'))";
        $query = $this->db->query($sql);
    }

    function checkUser($username,$password){
        $sql = "select * from users where name='$username' and password=sha1('$password')";
        $query = $this->db->query($sql);
        return $query->result();
    }

    function listNewsForEdit($number){
        $sql="select * from news ORDER BY id DESC limit $number";
        $query=$this->db->query($sql);
        return $query->result();
    }

    function getDrivers(){
        $sql="select * from drivers order by id";
        $query=$this->db->query($sql);
        return $query->result();
    }

    function getTeams(){
        $sql="select * from teams order by id";
        $query=$this->db->query($sql);
        return $query->result();
    }

    function getTracks(){
        $sql="select * from circuits order by id";
        $query=$this->db->query($sql);
        return $query->result();
    }

    function getNewsForEditById($id){
        $sql = "SELECT * from news where id=$id";
        $query = $this->db->query($sql);
        return $query->row();
    }

    function getDriversForEditById($id){
        $sql = "SELECT * from drivers where id=$id";
        $query = $this->db->query($sql);
        return $query->row();
    }

    function insertDriverPoints($prvi,$drugi,$treci,$cetvrti,$peti,$sesti,$sedmi,$osmi,$deveti,$deseti){
        $sql = "
            update drivers
            set
            points = case when id = $prvi then points+25 else points end,
            points = case when id = $drugi then points+18 else points end,
            points = case when id = $treci then points+15 else points end,
            points = case when id = $cetvrti then points+12 else points end,
            points = case when id = $peti then points+10 else points end,
            points = case when id = $sesti then points+8 else points end,
            points = case when id = $sedmi then points+6 else points end,
            points = case when id = $osmi then points+4 else points end,
            points = case when id = $deveti then points+2 else points end,
            points = case when id = $deseti then points+1 else points end;
        ";
        $query = $this->db->query($sql);
    }

    function insertTeamPoints($prvi,$drugi,$treci,$cetvrti,$peti,$sesti,$sedmi,$osmi,$deveti,$deseti){
        $sql = "
        update teams
        set
          points = case when id = (SELECT team_id from drivers where id=$prvi) then points+25 else points end,
          points = case when id = (SELECT team_id from drivers where id=$drugi) then points+18 else points end,
          points = case when id = (SELECT team_id from drivers where id=$treci) then points+15 else points end,
          points = case when id = (SELECT team_id from drivers where id=$cetvrti) then points+12 else points end,
          points = case when id = (SELECT team_id from drivers where id=$peti) then points+10 else points end,
          points = case when id = (SELECT team_id from drivers where id=$sesti) then points+8 else points end,
          points = case when id = (SELECT team_id from drivers where id=$sedmi) then points+6 else points end,
          points = case when id = (SELECT team_id from drivers where id=$osmi) then points+4 else points end,
          points = case when id = (SELECT team_id from drivers where id=$deveti) then points+2 else points end,
          points = case when id = (SELECT team_id from drivers where id=$deseti) then points+1 else points end;
        ";
        $query = $this->db->query($sql);
    }

    function insertPoints($prvi,$drugi,$treci,$cetvrti,$peti,$sesti,$sedmi,$osmi,$deveti,$deseti,$track){
        $sql="
        insert into points
        (driver_id,driver_points,team_id,team_points,track_id)
        values
        ($prvi,25,(SELECT team_id from drivers where id=$prvi),25,$track),
        ($drugi,18,(SELECT team_id from drivers where id=$drugi),18,$track),
        ($treci,15,(SELECT team_id from drivers where id=$treci),15,$track),
        ($cetvrti,12,(SELECT team_id from drivers where id=$cetvrti),12,$track),
        ($peti,10,(SELECT team_id from drivers where id=$peti),10,$track),
        ($sesti,8,(SELECT team_id from drivers where id=$sesti),8,$track),
        ($sedmi,6,(SELECT team_id from drivers where id=$sedmi),6,$track),
        ($osmi,4,(SELECT team_id from drivers where id=$osmi),4,$track),
        ($deveti,2,(SELECT team_id from drivers where id=$deveti),2,$track),
        ($deseti,1,(SELECT team_id from drivers where id=$deseti),1,$track);
        ";
        $query = $this->db->query($sql);
    }

    function insertNews($title,$intro_text,$full_text,$image,$mainpage,$published,$date){
        $data = array(
            'title' => $title,
            'intro_text' => $intro_text,
            'full_text' => $full_text,
            'image' => $image,
            'mainpage' => $mainpage,
            'published' => $published,
            'date' => $date
        );

        $this->db->insert('news', $data);
    }

    /**
     * Update vesti u bazu
     * @param  $id
     * @param  $title
     * @param  $intro_text
     * @param  $full_text
     * @param  $mainpage
     * @param  $published
     * @param  $date
     * @return void
     */
    function finishEditNews($id,$title,$intro_text,$full_text,$mainpage,$published,$date){
        $data = array(
            'title' => $title,
            'intro_text' => $intro_text,
            'full_text' => $full_text,
            'mainpage' => $mainpage,
            'published' => $published,
            'date' => $date
        );
        $this->db->where('id', $id);
        $this->db->update('news', $data);
    }

    function insertNewsTag($tag){
        $sql = "INSERT IGNORE INTO tags VALUES ('', '$tag')";
        $query = $this->db->query($sql);
    }

    function checkTag($tag){
        $query = $this->db->query("SELECT name FROM tags where name = '$tag'");
        return $query->num_rows();
    }

    function insertTag($tag){
        /*$data = array(
            'id' => '',
            'name' => $tag
        );
        echo $tag;
        $this->db->insert('tags', $data);*/

        $sql = "INSERT INTO tags VALUES ('', '$tag')";
        $query = $this->db->query($sql);
    }
}