<?php

if (!defined('BASEPATH')) {
    exit('No direct script access allowed');
}

class AdminModel extends CI_Model {
    private $tb_repo = 'repo';
    private $tb_type = 'type';
    private $tb_subject = 'subject';
    private $tb_files = 'files';

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

    public function insertDraft() {
        $data = ["user_id" => 1];
        $this->db->insert($this->tb_repo, $data);
        return $this->db->insert_id();
    }

    public function getLastDraft() {
        return $this->db->get_where($this->tb_repo, ['user_id' => 1, 'title' => NULL])->row();
    }

    public function getFiles($repo_id) {
        return $this->db->get_where($this->tb_files, ['repo_id' => $repo_id])->result();
    }

    public function getFile($file_id) {
        return $this->db->get_where($this->tb_files, ['file_id' => $file_id])->row();
    }

    public function getSubject($subject) {
        $query = $this->db->get_where($this->tb_subject, ['subject_name' => clearText($subject)]);
        // echo  $this->db->last_query();
         return $query->row();
    }

    public function getAllType() {
        return $this->db->get($this->tb_type)->result();
    }

    public function getAllSubject() {
        return $this->db->get($this->tb_subject)->result();
    }

    public function deleteFile($file_id) {
        return $this->db->delete($this->tb_files, ['file_id' => $file_id]);
    }

    public function delete($repo_id) {
        return $this->db->delete($this->tb_repo, ['repo_id' => $repo_id]);
    }


    public function getRepo($id) {
        return $this->db->get_where($this->tb_repo, ['repo_id' => $id])->row();
    }

    public function getAllRepo() {
        // $this->db->limit(1000);
        $this->db->join($this->tb_subject, $this->tb_subject.'.subject_id = '. $this->tb_repo.'.subject_id', 'left');
        return $this->db->order_by($this->tb_repo.'.repo_id', 'desc')->get_where($this->tb_repo)->result();    
    }


    public function insertRepo($data) {
         $this->db->insert($this->tb_repo, $data);
         return $this->db->insert_id();
    }

    public function updateRepo($data, $id) {
        return $this->db->update($this->tb_repo, $data, ['repo_id' => $id]);
    }

    public function insertFile($data) {
        return $this->db->insert($this->tb_files, $data);
    }
}