<?php

class Torrents_model extends CI_Model
{

    public function __construct()
    {
        $this->data_listing_context = 'torrents.id , torrents.comments_count , torrents.publish_date , torrents.name ,';
        $this->data_listing_context .= 'torrents.size , torrents.seed , torrents.leech , torrents.category ,';
        $this->data_listing_context .= 'categoriesp.name AS parent_category_name , categoriesc.name AS sub_category_name';
    }

    public function get_parent_categories($order = 'order')
    {
        return $this->db->where('parent', 0)->order_by($order, 'asc')->get('categories')->result();
    }

    public function get_parent_categories_noadult($order = 'order')
    {
        return $this->db->where('parent', 0)->order_by($order, 'asc')->where('id !=', 2188)->get('categories')->result();
    }
    
    public function get_categorie_data($id)
    {
        return $this->db->where('id', $id)->get('categories')->row();
    }

    public function get_sub_categorie_data($parent_id, $order = 'name')
    {
        return $this->db->where('parent', $parent_id)->order_by($order, 'asc')->get('categories')->result();
    }

    public function get_parent_categorie_data($id)
    {
        return $this->db->select('c2.*')->from('categories as c1')->where('c1.id', $id)->join('categories as c2', 'c1.parent = c2.id')->get()->row();
    }

    public function get_parent_categoriesid()
    {
        return $this->db->select('id , name')->from('categories')->where('parent', 0)->order_by('order', 'asc')->get()->result();
    }

    public function get_parent_sub_categoriesid()
    {
        return $this->db->select('id , name , parent')->from('categories')->where('parent !=', 0)->order_by('order', 'asc')->get()->result();
    }

   public function get_exclu_torrents($limit,$offset) {
        return $this->db->select('torrents.id, torrents.state, torrents.age, torrents.comments_count, torrents.publish_date, torrents.name, torrents.category_slug, torrents.size, torrents.seed, torrents.leech, torrents.completed, categories.id AS category_id, categories.name AS category')
                ->from('torrents')
                ->where('is_exclusivity', 1)
                ->join('categories','torrents.category = categories.id')
                ->order_by('id','desc')
                ->limit($limit,$offset)
                ->get()
                ->result();
    }


    private function get_prototype_listing($category, $sort, $order, $limit, $offset)
    {
        $this->db->select($this->data_listing_context)
            ->from('torrents')
            ->where('torrents.category', (int) $category)
            ->where('torrents.state', 0)
            ->join('categories AS categoriesp', 'torrents.parent_category = categoriesp.id')
            ->join('categories AS categoriesc', 'torrents.category = categoriesc.id')
            ->order_by($sort, $order)
            ->limit($limit, $offset);

        return $this->db;
    }

    public function get_period_torrents($type, $category, $sort = 'publish_date', $order = 'desc', $limit = 30, $offset = 0)
    {
        $query = $this->get_prototype_listing($category, $sort, $order, $limit, $offset);

        if ($type == 'today_torrents') {
            $where = 'torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)';
        } elseif ($type == 'week_torrents') {
            $where = 'torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 7 DAY)';
        } else {
            $where = 'torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 30 DAY)';
        }

        return $query->where($where)->get()->result();
    }

    public function updateCategoriesStats($parent_cat_id, $sub_cat_id)
    {
        // mis à jour nombre torrents dans la catégorie parente
        $this->db->set('torrents', 'torrents + 1', false);
        $this->db->where('id', $parent_cat_id)->update('categories');
        // mis à jour nombre torrents dans la catégorie fille
        $this->db->set('torrents', 'torrents + 1', false);
        $this->db->where('id', $sub_cat_id)->update('categories');
        return true;
    }

    public function generate_category_slug($id)
    {
        $this->db->select('c1.name AS sub_category_name , c1.id AS sub_category_id , c2.name AS parent_category_name , c2.id AS parent_category_id');
        $this->db->from('categories AS c1');
        $this->db->where('c1.id', $id);
        $this->db->join('categories AS c2', 'c1.parent = c2.id');
        $result = $this->db->get()->row();
        // mis à jour statististiques
        $this->updateCategoriesStats($result->sub_category_id, $result->parent_category_id);
        return url_title($result->parent_category_name, '-', true) . '/' . url_title($result->sub_category_name, '-', true);
    }

    public function torrents_popular($categorie, $limit = 2)
    {
        return $this->db->select('torrents.name , torrents.id , torrents.seed , torrents.leech , torrents.age , torrents.size , torrents.category_slug')
            ->from('track_views as t1')
            ->where('t1.date > UNIX_TIMESTAMP(NOW() - INTERVAL 3 DAY)')
            ->group_by('t1.guid', 'desc')
            ->order_by('count(guid)', 'desc')
            ->where('torrents.parent_category', $categorie)
            ->where('torrents.state', 0)
            ->join('torrents', 't1.guid = torrents.id')
            ->limit($limit)
            ->get()
            ->result();

    }

    public function last_torrents($categorie)
    {
        return $this->db->select('torrents.name , torrents.id , torrents.seed , torrents.leech , torrents.age , torrents.size , torrents.category_slug')
            ->from('torrents')
            ->order_by('torrents.id', 'desc')
            ->where('torrents.parent_category', $categorie)
            ->where('torrents.state', 0)
            ->where('torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)')
            ->limit(30)
            ->get()
            ->result();
    }

    public function week_torrents($categorie)
    {
        return $this->db->select('torrents.name , torrents.id , torrents.seed , torrents.leech , torrents.age , torrents.size , torrents.category_slug')
            ->from('torrents')
            ->order_by('torrents.id', 'desc')
            ->where('torrents.parent_category', $categorie)
            ->where('torrents.state', 0)
            ->where('torrents.publish_date < UNIX_TIMESTAMP(NOW() - INTERVAL 7 DAY)')
            ->limit(30)
            ->get()
            ->result();
    }

    public function getMostSeeded()
    {
        return $this->db->select('torrents.id, torrents.name, torrents.seed, torrents.leech, torrents.completed, torrents.age, torrents.size, torrents.category_slug, torrents.parent_category, torrents.category, torrents.publish_date, torrents.comments_count , users.nickname AS uploader')->from('torrents')->join('users', 'torrents.uploader = users.id')->where('torrents.seed >', '0')->order_by('torrents.seed', 'desc')->where('torrents.state', 0)->limit(100)->get()->result_array();
    }

    public function getMostCompleted()
    {
        return $this->db->select('torrents.id, torrents.name, torrents.seed, torrents.leech, torrents.completed, torrents.age, torrents.size, torrents.category_slug, torrents.parent_category, torrents.category, torrents.publish_date, torrents.comments_count , users.nickname AS uploader')->from('torrents')->where('torrents.parent_category !=','2188')->join('users', 'torrents.uploader = users.id')->where('torrents.seed >', '0')->where('torrents.comments_count >', '20')->order_by('torrents.completed', 'desc')->where('torrents.state', 0)->limit(100)->get()->result_array();
    }

    public function get_torrent_from_period($type, $out = '')
    {
        if ($type == 'day') {
            $this->db->where('torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)');
            //$this->db->where('torrents.seed >', '1');
            //$this->db->where('torrents.completed >', '5');
        } else if ($type == 'week') {
            $this->db->where('torrents.publish_date < UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)');
            $this->db->where('torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 8 DAY)');
            $this->db->where('torrents.seed >', 20);
            //$this->db->where('torrents.completed >', 30);
        } else if ($type == 'month') {
            $this->db->where('torrents.publish_date < UNIX_TIMESTAMP(NOW() - INTERVAL 8 DAY)');
            $this->db->where('torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 38 DAY)');
            $this->db->where('torrents.seed >', 25);
            //$this->db->where('torrents.completed >', 150);
        }
        $this->db->select('torrents.id, torrents.name, torrents.seed, torrents.leech, torrents.completed, torrents.age, torrents.size, torrents.category_slug, torrents.parent_category, torrents.category, torrents.publish_date, torrents.comments_count , users.nickname AS uploader')->from('torrents')->join('users', 'torrents.uploader = users.id')->order_by('torrents.id', 'desc')->where('torrents.state', 0);
        return $out == 'object' ? $this->db->get()->result() : $this->db->get()->result_array();
    }

    public function get_torrent($id)
    {
        return $this->db->select('torrents.* , users.nickname AS nickname, users.settings AS user_settings')->from('torrents')->join('users', 'torrents.uploader = users.id')->where('torrents.id', $id)->get()->row();
    }

    public function get_torrent_comments($guid, $limit = 15, $offset = 0)
    {
        return $this->db->select('comments.* , users.nickname AS publisher , users.last_activity_date AS publisher_activity , users.uploaded AS up , users.downloaded AS down , users.id AS publisher_id  , users.rank AS publisher_rank , users.avatar AS avatar')
            ->from('comments')
            ->where('comments.guid', $guid)
            ->order_by('comments.id', 'desc')
            ->join('users', 'comments.publisher = users.id')
            ->limit($limit, $offset)
            ->get()->result();
    }

    public function get_focused_comment($id, $torrent)
    {
        return $this->db->select('comments.* , users.nickname AS publisher , users.last_activity_date AS publisher_activity , users.uploaded AS up , users.downloaded AS down , users.id AS publisher_id  , users.rank AS publisher_rank , users.avatar AS avatar')
            ->from('comments')
            ->where('comments.id', $id)
            ->where('comments.guid', $torrent)
            ->order_by('comments.id', 'desc')
            ->join('users', 'comments.publisher = users.id')
            ->get()->row();
    }

    public function get_from_ids($torrents_id)
    {
        $sql = 'SELECT `torrents`.*, `users`.`nickname` AS `nickname`, `categories`.`id` AS `category_id`, `categories`.`name` AS `category`';
        $sql .= 'FROM `torrents` JOIN `users` ON `torrents`.`uploader` = `users`.`id` JOIN `categories` ON `torrents`.`category` = `categories`.`id`';
        $sql .= "WHERE `torrents`.`id` IN ('$torrents_id') AND `torrents`.`state` = 0 ORDER BY FIELD (torrents.id,'$torrents_id') DESC";
        return $this->db->query($sql)->result();
    }

    public function get_today_torrents($category, $sort = 'publish_date', $order = 'desc', $limit = 30, $offset = 0)
    {
        return $this->db->select($this->torrent_data)
            ->from('torrents')
            ->join('users', 'torrents.uploader = users.id')
            ->where('torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)')
            ->where('torrents.parent_category', $category)
            ->where('torrents.state', 0)
            ->join('categories', 'torrents.category = categories.id')
            ->order_by($sort, $order)
            ->limit($limit, $offset)
            ->get()
            ->result();
    }

    public function count_today_torrents($category)
    {
        return $this->db->select('torrents.id')
            ->from('torrents')
            ->where('torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)')
            ->where('torrents.parent_category', $category)
            ->join('categories', 'torrents.category = categories.id')
            ->get()
            ->num_rows();
    }

    public function get_yesterday_torrents($category, $sort = 'publish_date', $order = 'desc', $limit = 30, $offset = 0)
    {
        return $this->db->select($this->torrent_data)
            ->from('torrents')
            ->join('users', 'torrents.uploader = users.id')
            ->where('torrents.publish_date < UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY)')
            ->where('torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 2 DAY)')
            ->where('torrents.state', 0)
            ->where('torrents.parent_category', $category)
            ->join('categories', 'torrents.category = categories.id')
            ->order_by($sort, $order)
            ->get()
            ->result();
    }

    public function count_yesterday_torrents($category)
    {
        return $this->db->select('torrents.id')
            ->from('torrents')
            ->where('torrents.publish_date > UNIX_TIMESTAMP(NOW() - INTERVAL 7 DAY)')
            ->where('torrents.parent_category', $category)
            ->join('categories', 'torrents.category = categories.id')
            ->get()
            ->num_rows();
    }

    public function get_popular_torrents($category, $sort = 'seed', $order = 'desc', $limit = 12, $offset = 0)
    {
        return $this->db->select($this->torrent_data)
            ->from('torrents')
            ->join('users', 'torrents.uploader = users.id')
            ->where('torrents.parent_category', (int) $category)
            ->where('torrents.state', 0)
            ->join('categories', 'torrents.category = categories.id')
            ->order_by($sort, $order)
            ->limit($limit, $offset)
            ->get()
            ->result();
    }

    public function count_popular_torrents($category)
    {
        return $this->db->select('torrents.id')
            ->from('torrents')
            ->where('torrents.parent_category', (int) $category)
            ->join('categories', 'torrents.category = categories.id')
            ->get()
            ->num_rows();
    }

    public function get_category_icon($name)
    {
        return $this->db->where('name', $name)->get('categories')->row()->icon;
    }

    public function get_torrents_all_categories($sort_type)
    {

        //$this->output->enable_profiler();
        $categories = $this->get_categories();
        $torrents   = array();
        if ($sort_type == 'popular') {
            foreach ($categories as $category) {
                $torrents[$category->name]                       = $this->get_popular_torrents($category->id);
                $torrents[$category->name]['parent_category_id'] = $category->id;
            }
        }
        if ($sort_type == 'today') {
            foreach ($categories as $category) {
                $torrents[$category->name]                       = $this->get_today_torrents($category->id);
                $torrents[$category->name]['parent_category_id'] = $category->id;
            }
        }
        if ($sort_type == 'yesterday') {
            foreach ($categories as $category) {
                $torrents[$category->name]                       = $this->get_yesterday_torrents($category->id);
                $torrents[$category->name]['parent_category_id'] = $category->id;
            }
        }
        return $torrents;
    }

    public function get_categories()
    {
        return $this->db->where('parent', '0')->order_by('order', 'asc')->get('categories')->result();
    }
}