<?php
#[\AllowDynamicProperties]
class Product_model extends CI_Model
{

    public function getdata($field = NULL, $value = NULL)
    {
        $this->load->database();
        if ($field != NULL && $value != NULL) {
            $this->db->where('status', 1);
            // $where = "name='Joe' AND status='boss' OR status='active'";
            $this->db->where($field, $value);
        }
        $query = $this->db->get('product');
        return $query->result_array();
    }

    public function activate($table = NULL, $link = NULL)
    {
        if ($table == "users" || $table == "reviews") {
            $this->db->set('status', 1);
            $this->db->where('id', $link);
            $this->db->update($table);
        } else {
            $this->db->set('status', 1);
            $this->db->where('link', $link);
            $this->db->update($table);
        }
    }
    public function deactivate($table = NULL, $link = NULL)
    {
        if ($table == "users") {
            $this->db->set('status', 2);
            $this->db->where('id', $link);
            $this->db->update($table);
        } else if ($table == "reviews") {
            $this->db->set('status', 0);
            $this->db->where('id', $link);
            $this->db->update($table);
        } else {
            $this->db->set('status', 0);
            $this->db->where('link', $link);
            $this->db->update($table);
        }
    }

    public function delete($table = NULL, $link = NULL)
    {
        if ($table == "reviews" || $table == "brands" || $table == "blog" ) {
            $this->db->where('id', $link);
            $this->db->delete($table);
            return true;
        }else {
            $this->db->where('link', $link);
            $this->db->delete($table);
            return true;
        }
    }

    public function search($keyword, $data = NULL)
    {

        $query = "SELECT * FROM product WHERE name like '%$keyword%' or category like '%$keyword%' or category like '%$keyword%' and status = 1";
        if ($data != NULL) {
            if($data == 'price_desc'){
                $query .= "
                ORDER BY price DESC";
            }
            else if($data == 'price_asc'){
                $query .= "
                ORDER BY price ASC";
            }
            if($data == 'id_desc'){
                $query .= "
                ORDER BY id DESC";
            }
            else if($data == 'id_asc'){
                $query .= "
                ORDER BY id ASC";
            }

                
        }
        $result = $this->db->query($query);
        return $result->result_array();
    }
    
    public function insert($data = array())
    {
        $insert = $this->db->insert('product', $data);
        return $insert ? true : false;
    }

    
    public function get_category($link)
    {
        $query = $this->db->get_where('category', array('link' => $link));
        if ($query->num_rows() > 0) {
            return $query->row();
        } else {
            return 0;
        }
    }

    public function getmaincategories()
    {
        $this->db->where('parent', "");
        $query = $this->db->get('category');
        return $query->result_array();
    }

    public function checkcategory($link)
    {

        $query = $this->db->get_where('category', array('link' => $link));
        if ($query->num_rows() > 0) {
            return 1;
        } else {
            return 0;
        }
    }
    
    public function checkblog($link)
    {

        $query = $this->db->get_where('blog', array('link' => $link));
        if ($query->num_rows() > 0) {
            return 1;
        } else {
            return 0;
        }
    }
    
}