<?php
Class coupon_model extends CI_Model {

function get_coupon_list_for_restaurant($params = array(), $action = '',$action2 =0,$get_category_list=0)
    {
        $today = date('Y-m-d');
        $data_up = array('status' => '0');
        $this->db->where('offer_valid_from >', $today);
        $this->db->or_where('offer_valid_to <', $today);
        $this->db->update('rt_restaurant_offer', $data_up);

        if($this->session->userdata('logged_in_restaurant')){
            $session_data = $this->session->userdata('logged_in_restaurant');
            $restaurant_id = $session_data['id'];
        }else{
            $restaurant_id = 0; 
        }
        

        $this->db->select('*');
        $this->db->from('rt_restaurant_offer');
        $this->db->where('restaurant_id', $restaurant_id);
        if ($action == '1' || $action == '0') {
        	$this->db->where('status', $action);
        }
        $this->db->order_by('offer_id', 'DESC');

        
        if(array_key_exists("start",$params) && array_key_exists("limit",$params)){
            $this->db->limit($params['limit'],$params['start']);
        }elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params)){
            $this->db->limit($params['limit']);
        }
        
        $query = $this->db->get();
        
        return ($query->num_rows() > 0)?$query->result_array():FALSE;
    }

    function isCouponExist($offer_id = 0, $coupon_code, $restaurant_id) {
        $this->db->select('*');
        $this->db->from('rt_restaurant_offer');
        if ($offer_id > 0) {
            $this->db->where('offer_id !=', $offer_id);
        }
        $this->db->where('restaurant_id', $restaurant_id);
        $this->db->where('coupon_code', $coupon_code);
        $query = $this->db->get();
        return ($query->num_rows() > 0)?TRUE:FALSE;
    }

}