<?php 
class subcategory_model extends CI_Model {
	public function _consruct(){
		parent::_construct();
	}


public function getsubcatData($subcat_id='',$view=''){
		$cond  = (!empty($view))?" status IN ($view) ":" sc.status != '0' ";
		$cond .= (!empty($subcat_id))?" AND sc.id='$subcat_id' ":"";

		$subcatData = $this->db->query("SELECT sc.*,c.cat_name FROM sub_category as sc
           LEFT JOIN  category as c ON c.id = sc.cat_id

			WHERE $cond");

		if(!empty($subcatData)){
			return (empty($subcat_id))?$subcatData->result():$subcatData->row();
		}
		return 0;
	}

	 public function add_subcategory($subcatData){

		$qry = $this->db->insert('sub_category',$subcatData);

		if ($this->db->trans_status() === TRUE)
		{
			$this->db->trans_commit();
			return TRUE;
		}else
		{
			$this->db->trans_rollback();
			return false;
		}
	}

 function update_subcategory($id,$subcatData)
    {


        $this->db->where('id',$id);
        $qry = $this->db->update('sub_category',$subcatData);
        return true;


    }
function getcatData(){
		$query = $this->db->query(" SELECT * FROM `category` order by id DESC ");
		if(!empty($query)){
			return $query->result_array();
		}
		return;
	}
function delete_subcategory($id) {
		$data = array(  
			'status' => '0'   
		);  
		$this->db->where('id', $id);
		$result =  $this->db->update('sub_category', $data); 
		if($result) {
			return "Success";
		}
		else {
			return "Error";
		}
	}


}