<?php

class frontend_model extends CI_Model {
	function RestaurantReviewList($restaurant_id) {
		$this->db->select('rt_restaurant_reviews.*,rt_customer.customer_name,rt_customer.customer_lastname,rt_restaurant.restaurant_name');
        $this->db->from('rt_restaurant_reviews');
        $this->db->join('rt_restaurant','rt_restaurant.restaurant_id=rt_restaurant_reviews.restaurant_id');
        $this->db->join('rt_customer','rt_customer.customer_id=rt_restaurant_reviews.customer_id');
		$this->db->where('rt_restaurant_reviews.restaurant_id', $restaurant_id);
		$this->db->where('rt_restaurant_reviews.status', '1');
		$query = $this->db->get();
		$data = $query->result_array();
		if ($query->num_rows() > 0) {
			return $data;
		}
		else {
			return false;
		}
	}
	function avgRestaurantrating($restaurant_id) {
		$this->db->select('rating');
		$this->db->from('rt_restaurant_reviews');
		$this->db->where('restaurant_id', $restaurant_id);
		$this->db->where('rating !=', 0);
		$this->db->where('status', '1');
		$query = $this->db->get();
		$data = $query->result_array();
		if ($query->num_rows() > 0) {
			$total_rating = 0;
			foreach ($data as $key => $value) {
				$total_rating = $total_rating + $value['rating'];
			}
			$total_row = $query->num_rows();
			$avgRating = ($total_rating / $total_row) * 20;
			return $avgRating;
		}
		else {
			return 0;
		}
	}
	function isFavourite($restaurant_id, $customer_id) {
		$this->db->select('*');
		$this->db->from('rt_myfavorties');
		$this->db->where('restaurant_id', $restaurant_id);
		$this->db->where('customerid', $customer_id);
		$query = $this->db->get();
		if ($query->num_rows() > 0) {
			return true;
		}
		else {
			return false;
		}
	}
	function customerByEmail($customer_email) {
		$this->db->select('*');
		$this->db->from('rt_customer');
		$this->db->where('customer_email', $customer_email);
		$query = $this->db->get();
		if ($query->num_rows() > 0) {
			return $query->row();
		}
		else {
			return false;
		}
	}
	function orderStatus($orderid) {
		$this->db->select('status');
		$this->db->from('rt_order');
		$this->db->where('ordergenerateid', $orderid);
		$this->db->order_by('status', 'ASC');
		$query = $this->db->get();
		if ($query->num_rows() > 0) {
			return $query->row();
		}
		return false;
	}
	function StateList() {
	  	$is_active = '1';
		$this->db->select('*');
		$this->db->from('rt_state');
		$this->db->where('state_status', $is_active);
		$this->db->order_by('statename', 'ASC');
		$query = $this->db->get();
		if ($query->num_rows() > 0) {
			return $query->result();
		}
		return false;
	}
	function CityList() {
	  	$is_active = '1';
		$this->db->select('*');
		$this->db->from('rt_city');
		$this->db->where('city_status', $is_active);
		$this->db->order_by('cityname', 'ASC');
		$query = $this->db->get();
		if ($query->num_rows() > 0) {
			return $query->result();
		}
		return false;
	}
	function getEmailTemplate($template_name) {
		$this->db->select('*');
		$this->db->from('rt_email_template');
		$this->db->where('template_name', $template_name);
		$query = $this->db->get();
		return $query->row();
	}

	function restaurantDetails($restaurant_id)
	{
		$day = date("l");
		if( $day == "Monday" ){
			#$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime AS open_time, rest.restaurant_delivery_mon_closetime AS close_time, ";
			$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime, rest.restaurant_delivery_mon_closetime, rest.restaurant_delivery_tue_opentime, rest.restaurant_delivery_tue_closetime, rest.restaurant_delivery_wed_opentime, rest.restaurant_delivery_wed_closetime, rest.restaurant_delivery_thu_opentime, rest.restaurant_delivery_thu_closetime, rest.restaurant_delivery_fri_opentime, rest.restaurant_delivery_fri_closetime, rest.restaurant_delivery_sat_opentime, rest.restaurant_delivery_sat_closetime, rest.restaurant_delivery_sun_opentime, rest.restaurant_delivery_sun_closetime, ";
		}
		elseif( $day == "Tuesday" ){
			#$open_close_time_cond = ", rest.restaurant_delivery_tue_opentime AS open_time, rest.restaurant_delivery_tue_closetime AS close_time, ";
			$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime, rest.restaurant_delivery_mon_closetime, rest.restaurant_delivery_tue_opentime, rest.restaurant_delivery_tue_closetime, rest.restaurant_delivery_wed_opentime, rest.restaurant_delivery_wed_closetime, rest.restaurant_delivery_thu_opentime, rest.restaurant_delivery_thu_closetime, rest.restaurant_delivery_fri_opentime, rest.restaurant_delivery_fri_closetime, rest.restaurant_delivery_sat_opentime, rest.restaurant_delivery_sat_closetime, rest.restaurant_delivery_sun_opentime, rest.restaurant_delivery_sun_closetime, ";
		}
		elseif( $day == "Wednesday" ){
			#$open_close_time_cond = ", rest.restaurant_delivery_wed_opentime AS open_time , rest.restaurant_delivery_wed_closetime AS close_time , ";
			$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime, rest.restaurant_delivery_mon_closetime, rest.restaurant_delivery_tue_opentime, rest.restaurant_delivery_tue_closetime, rest.restaurant_delivery_wed_opentime, rest.restaurant_delivery_wed_closetime, rest.restaurant_delivery_thu_opentime, rest.restaurant_delivery_thu_closetime, rest.restaurant_delivery_fri_opentime, rest.restaurant_delivery_fri_closetime, rest.restaurant_delivery_sat_opentime, rest.restaurant_delivery_sat_closetime, rest.restaurant_delivery_sun_opentime, rest.restaurant_delivery_sun_closetime, ";
		}
		elseif( $day == "Thursday" ){
			#$open_close_time_cond = ", rest.restaurant_delivery_thu_opentime AS open_time, rest.restaurant_delivery_thu_closetime AS close_time, ";
			$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime, rest.restaurant_delivery_mon_closetime, rest.restaurant_delivery_tue_opentime, rest.restaurant_delivery_tue_closetime, rest.restaurant_delivery_wed_opentime, rest.restaurant_delivery_wed_closetime, rest.restaurant_delivery_thu_opentime, rest.restaurant_delivery_thu_closetime, rest.restaurant_delivery_fri_opentime, rest.restaurant_delivery_fri_closetime, rest.restaurant_delivery_sat_opentime, rest.restaurant_delivery_sat_closetime, rest.restaurant_delivery_sun_opentime, rest.restaurant_delivery_sun_closetime, ";
		}
		elseif( $day == "Friday" ){
			#$open_close_time_cond = ", rest.restaurant_delivery_fri_opentime AS open_time, rest.restaurant_delivery_fri_closetime AS close_time, ";
			$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime, rest.restaurant_delivery_mon_closetime, rest.restaurant_delivery_tue_opentime, rest.restaurant_delivery_tue_closetime, rest.restaurant_delivery_wed_opentime, rest.restaurant_delivery_wed_closetime, rest.restaurant_delivery_thu_opentime, rest.restaurant_delivery_thu_closetime, rest.restaurant_delivery_fri_opentime, rest.restaurant_delivery_fri_closetime, rest.restaurant_delivery_sat_opentime, rest.restaurant_delivery_sat_closetime, rest.restaurant_delivery_sun_opentime, rest.restaurant_delivery_sun_closetime, ";
		}
		elseif( $day == "Saturday" ){
			#$open_close_time_cond = ", rest.restaurant_delivery_sat_opentime AS open_time, rest.restaurant_delivery_sat_closetime AS close_time, ";
			$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime, rest.restaurant_delivery_mon_closetime, rest.restaurant_delivery_tue_opentime, rest.restaurant_delivery_tue_closetime, rest.restaurant_delivery_wed_opentime, rest.restaurant_delivery_wed_closetime, rest.restaurant_delivery_thu_opentime, rest.restaurant_delivery_thu_closetime, rest.restaurant_delivery_fri_opentime, rest.restaurant_delivery_fri_closetime, rest.restaurant_delivery_sat_opentime, rest.restaurant_delivery_sat_closetime, rest.restaurant_delivery_sun_opentime, rest.restaurant_delivery_sun_closetime, ";
		}
		elseif( $day == "Sunday" ){
			#$open_close_time_cond = ", rest.restaurant_delivery_sun_opentime AS open_time, rest.restaurant_delivery_sun_closetime AS close_time, ";
			$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime, rest.restaurant_delivery_mon_closetime, rest.restaurant_delivery_tue_opentime, rest.restaurant_delivery_tue_closetime, rest.restaurant_delivery_wed_opentime, rest.restaurant_delivery_wed_closetime, rest.restaurant_delivery_thu_opentime, rest.restaurant_delivery_thu_closetime, rest.restaurant_delivery_fri_opentime, rest.restaurant_delivery_fri_closetime, rest.restaurant_delivery_sat_opentime, rest.restaurant_delivery_sat_closetime, rest.restaurant_delivery_sun_opentime, rest.restaurant_delivery_sun_closetime, ";
		}
		else{
			$open_close_time_cond = ", rest.restaurant_delivery_mon_opentime, rest.restaurant_delivery_mon_closetime, rest.restaurant_delivery_tue_opentime, rest.restaurant_delivery_tue_closetime, rest.restaurant_delivery_wed_opentime, rest.restaurant_delivery_wed_closetime, rest.restaurant_delivery_thu_opentime, rest.restaurant_delivery_thu_closetime, rest.restaurant_delivery_fri_opentime, rest.restaurant_delivery_fri_closetime, rest.restaurant_delivery_sat_opentime, rest.restaurant_delivery_sat_closetime, rest.restaurant_delivery_sun_opentime, rest.restaurant_delivery_sun_closetime, ";
		}

		$other_Time=", rest.restaurant_delivery_mon_opentime1, rest.restaurant_delivery_mon_closetime1, rest.restaurant_delivery_tue_opentime1, rest.restaurant_delivery_tue_closetime1, rest.restaurant_delivery_wed_opentime1, rest.restaurant_delivery_wed_closetime1, rest.restaurant_delivery_thu_opentime1, rest.restaurant_delivery_thu_closetime1, rest.restaurant_delivery_fri_opentime1, rest.restaurant_delivery_fri_closetime1, rest.restaurant_delivery_sat_opentime1, rest.restaurant_delivery_sat_closetime1, rest.restaurant_delivery_sun_opentime1, rest.restaurant_delivery_sun_closetime,rest.restaurant_delivery_mon_opentime2, rest.restaurant_delivery_mon_closetime2, rest.restaurant_delivery_tue_opentime2, rest.restaurant_delivery_tue_closetime2, rest.restaurant_delivery_wed_opentime2, rest.restaurant_delivery_wed_closetime2, rest.restaurant_delivery_thu_opentime2, rest.restaurant_delivery_thu_closetime2, rest.restaurant_delivery_fri_opentime2, rest.restaurant_delivery_fri_closetime2, rest.restaurant_delivery_sat_opentime2, rest.restaurant_delivery_sat_closetime2, rest.restaurant_delivery_sun_opentime2, rest.restaurant_delivery_sun_closetime2,, rest.restaurant_delivery_sun_opentime1, rest.restaurant_delivery_sun_closetime1";

		$this->db->select('rest.business_type,rest.restaurant_estimated_time,rest.banner_color,rest.latitude,rest.longitude,rest.restaurant_id, rest.restaurant_name, rest.restaurant_seourl, rest.restaurant_phone, rest.restaurant_logo, rest.restaurant_website, rest.restaurant_fax, rest.restaurant_streetaddress, rest.restaurant_state, rest.restaurant_city, rest.restaurant_zip, rest.restaurant_contact_name, rest.restaurant_contact_phone, rest.restaurant_contact_email, rest.restaurant_description, rest.restaurant_estimated_time, rest.restaurant_delivery, rest.restaurant_delivery_charge, rest.restaurant_minorder_price, rest.restaurant_serving_cuisines, rest.restaurant_delivery_areas, rest.restaurant_displayoption, rest.restaurant_photos1, rest.restaurant_photos2, rest.restaurant_photos3, rest.restaurant_photos4, rest.restaurant_salestax, rest.restaurant_minorder_price, rest.restaurant_video, rest.restaurant_map, rest.res_marketbanner_option, rest.res_marketbanner_img_code, rest.restaurant_display_photo, rest.restaurant_display_video, rest.restaurant_display_banner, rest.restaurant_booktable, rest.restaurant_dinein, rest.restaurant_pickup '.$open_close_time_cond.'rt_city.cityname,rt_zipcode.zipcode, rt_zipcode.areaname,rt_state.statename'.$other_Time.', rest.seo_meta_keyword, rest.seo_meta_description, rest.seo_meta_language, rest.seo_city, rest.seo_state, rest.seo_country');
        $this->db->from('rt_restaurant rest');
        $this->db->join('rt_city','rt_city.city_id=rest.restaurant_city', 'left outer');
        $this->db->join('rt_zipcode','rt_zipcode.zipcode_id=rest.restaurant_zip', 'left outer');
        $this->db->join('rt_state','rt_state.statecode=rest.restaurant_state', 'left outer');
        $this->db->where('rest.restaurant_id', $restaurant_id);
        $query = $this->db->get();
		return $query->row_array();
	}


	function getArrayCuisinesInfo($id){
		
		$serving = '';
		$cuisineid =0;
		if(!empty($id))
		$cuisineid = explode(",",$id);
		$cuisineid = array_filter($cuisineid);
		$cnt = count($cuisineid);
		for($i=0;$i<$cnt;$i++){
			$this->db->select("cuisine_name");
			$this->db->from("rt_cuisine");
			$this->db->where("cuisine_id", $cuisineid[$i]);
			$this->db->where("cuisine_name !=", "");
			$query = $this->db->get();
			$data = $query->row();
			if ($data->cuisine_name != "") {
				$servingcuisine[] = $data->cuisine_name;
			}
			// $servingcuisine[] = $this->getValue("cuisine_name","rt_cuisine","cuisine_id = '".$cuisineid[$i]."'");
		}
		if(isset($servingcuisine) && !empty($servingcuisine))
			$servingcuisine = array_filter($servingcuisine);
			$serving = implode(", ",$servingcuisine);
		
		return $serving;
	}


	function getCuisinesPhoto($id){
		
		$serving = '';
		$cuisineid =0;
		if(!empty($id))
		$cuisineid = explode(",",$id);
		$cnt = count($cuisineid);

		$servingcuisine = $this->getValue("cuisine_photo","rt_cuisine","cuisine_id = '".$cuisineid[0]."'");
		
		return $servingcuisine;
	}




	#Category List
	function categoryList99($restaurantid){
		
				
		$sel_veg = "SELECT id, menu_name, menu_category, menu_type, menu_price, menu_description FROM rt_restaurant_menu WHERE restaurant_id = '".$restaurantid."' AND status = '1' GROUP BY menu_category ORDER BY menu_category ASC";
		
		//$sql_res = mysql_query($sel_veg)or die(mysql_error());
		$res = $this->db->query($sel_veg);
	    $sql_res  = $res->result_array();
		//var_dump($sql_res);
		if(count($sql_res) > 0){
			foreach($sql_res as $key=>$value){
				$sql_res[$key]['catname'] = $this->GetValue("maincatename",'rt_category_main',"maincateid = '".$sql_res[$key]['menu_category']."' AND status = '1'");
				if(strpos($sql_res[$key]['catname'], " / ") !== false){
					$sql_res[$key]['catname2'] = str_replace(" / ", "_", $sql_res[$key]['catname']);
				}else if(strpos($sql_res[$key]['catname'], " ") !== false){ 
					$sql_res[$key]['catname2'] = str_replace(" ", "_", $sql_res[$key]['catname']);
				}else{
					$sql_res[$key]['catname2'] = $sql_res[$key]['catname'];
				}
			}
		}
		

		return stripslashes($sql_res);
	}

	function categoryList($restaurantid){	
				
	$sel_veg = "SELECT maincateid, maincatename, maincatedesc FROM rt_category_main WHERE maincateid IN( SELECT menu_category FROM rt_restaurant_menu WHERE restaurant_id = '".$restaurantid."' AND status = '1' GROUP BY menu_category ORDER BY menu_category ASC)";
	$query = $this->db->query($sel_veg);
	$sql_res  = $query->result_array();

	return $sql_res;
		
	}


	function MenuList($menu_category,$restaurantid){	
				
	$sel_veg = "SELECT * FROM rt_restaurant_menu WHERE restaurant_id = '".$restaurantid."' and menu_category='".$menu_category."' AND status = '1' ";
	$query = $this->db->query($sel_veg);
	$sql_res  = $query->result_array();

	return $sql_res;
		
	}




	function getValue($select,$table_name,$condition){
		$sql = "SELECT ".$select." FROM ".$table_name." WHERE ".$condition." ";
		#echo $sql."<br>";
		// $res = mysql_query($sql)or die(mysql_error());
		// $row = mysql_fetch_assoc($res);
		$res = $this->db->query($sql);
	    $row  = $res->result_array();
        if(isset($row[$select]) && !empty($row[$select]))
		    return stripslashes($row[$select]);
        else
            return false;
	}

	function get_menu($id =0)
    {
        $this->db->select('rt_category_main.maincatename,rt_restaurant_menu.*');
        $this->db->from('rt_restaurant_menu');
        $this->db->join('rt_category_main','rt_category_main.maincateid=rt_restaurant_menu.menu_category', 'left outer');
        $this->db->where('rt_restaurant_menu.id', $id);
        $query = $this->db->get();
        $array  =$query->result();
        ////foreach ($query as &$arrayItem)
        //{
          foreach ($array as &$object)
          {
               $is_menu_slice =  $object->sizeoption;
               if($is_menu_slice=='size'){
                    $restaurant_id = $object->restaurant_id;
                    $menu_slice_menuid= $object->id;
                    $menu_price = $this->menu_slice_price($restaurant_id,$menu_slice_menuid);
                    $object->menu_price = $menu_price;
               }
          }
       // }
        return $array;
        ///$array1 = $array->result_object();
        //print_r($array);
        //return ($query->num_rows() > 0)?$query->result_array():FALSE;
    }

    function GetMenuDetails($id) {
    	$this->db->select('*');
    	$this->db->from('rt_restaurant_menu');
    	$this->db->where('id',$id); 
    	$this->db->limit(1);
    	$query = $this->db->get();
    	if ($query) {
    		return $query->row_array();
    	}
    	else {
    		return false;
    	}
    }


    function GetMenuSize($id) {
    	$this->db->select('*');
    	$this->db->from('rt_restaurant_menu_slice');
    	$this->db->where('menu_slice_menuid',$id); 
    	$query = $this->db->get();
    	if ($query) {
    		return $query->result_array();
    	}
    	else {
    		return false;
    	}
    }


    function GetMenuAddonsHeader($id) {
    	$addonparentid=0;
    	$this->db->select('*');
    	$this->db->from('rt_restaurant_menuaddons');
    	$this->db->where('menuaddons_menuid',$id); 
    	$this->db->where('addonparentid',$addonparentid); 
    	$query = $this->db->get();
    	if ($query) {
    		return $query->result_array();
    	}
    	else {
    		return false;
    	}
    }


    function GetMenuSubAddons($menuaddons_id) {
    	
    	$this->db->select('*');
    	$this->db->from('rt_restaurant_menuaddons');
    	$this->db->where('addonparentid',$menuaddons_id); 
    	$query = $this->db->get();
    	if ($query) {
    		return $query->result_array();
    	}
    	else {
    		return false;
    	}
    }


/*function menu_slice_price($menu_slice_menuid) 
        {  
            $this->db->select('*');
            $this->db->from('rt_restaurant_menu_slice');
            $this->db->where('menu_slice_menuid',$menu_slice_menuid);
            $query = $this->db->get();
            if ($query->num_rows() > 0) 
            {
                $price = $query->row_array();
            return $price['menu_slice_price'];
            }
            return 0;
        }*/

function menu_slice_price($menu_slice_menuid) 
        {  
            $this->db->select('MIN(menu_slice_price) AS min_size_price');
            $this->db->from('rt_restaurant_menu_slice');
            $this->db->where('menu_slice_menuid',$menu_slice_menuid);
            $query = $this->db->get();
            if ($query->num_rows() > 0) 
            {
                $price = $query->row_array();
            return $price['min_size_price'];
            }
            return 0;
        }

function feature_restaurant()
{
	$restaurant_feature_status="Yes";
	$restaurant_status = '1';
	$this->db->select('restaurant_id,restaurant_seourl,restaurant_logo,restaurant_name,restaurant_city');
	$this->db->from('rt_restaurant');
	$this->db->where('restaurant_feature_status',$restaurant_feature_status); 
	$this->db->where('restaurant_status',$restaurant_status); 
	// $this->db->limit(12);
	$query = $this->db->get();
	if ($query) {
		$resArray = $query->result_array();
		if (sizeof($resArray) > 0) {
			foreach ($resArray as $key => $value) {
				$this->db->select('maincatename');
				$this->db->from('rt_category_main');
				$this->db->where('restaurant_id', $value['restaurant_id']);
				$this->db->where('status', '1');
				$query = $this->db->get();
				$catArray = $query->result_array();
				if (sizeof($catArray) > 0) {
					$catString = '';
					foreach ($catArray as $keyX => $valueX) {
						if ($keyX != 0) {
							$catString .= ', ';
						}
						$catString .= $valueX['maincatename'];
					}
					$resArray[$key]['categories'] = $catString;
				}
				if ($this->session->userdata('logged_in_customer')) {
					$customerData = $this->session->userdata('logged_in_customer');
					$this->db->select('id');
					$this->db->from('rt_myfavorties');
					$this->db->where('restaurant_id', $value['restaurant_id']);
					$this->db->where('customerid', $customerData['id']);
					$query = $this->db->get();
					if ($query->num_rows() > 0) {
						$resArray[$key]['favourite'] = true;
					}
					else {
						$resArray[$key]['favourite'] = false;
					}
				}
			}
		}
		return $resArray;
	}
	else {
		return false;
	}
}

function top_restaurant()
{
	$restaurant_footer_status="Yes";
	$restaurant_status = '1';
	$this->db->select('restaurant_id,restaurant_seourl,restaurant_logo,restaurant_name,restaurant_city');
	$this->db->from('rt_restaurant');
	$this->db->where('restaurant_footer_status',$restaurant_footer_status); 
	$this->db->where('restaurant_status',$restaurant_status); 
	// $this->db->limit(12);
	$query = $this->db->get();
	if ($query) {
		$resArray = $query->result_array();
		return $resArray;
	}
	else {
		return false;
	}
}

function popular_locality()
{
	// SELECT COUNT(*) AS totalCount, `restaurant_name`, `restaurant_city` FROM `rt_restaurant` WHERE 1 GROUP BY `restaurant_city`
	$restaurant_status = '1';
	$restaurant_validate = '1';
	$this->db->select('COUNT(*) AS restaurant_count, restaurant_city');
	$this->db->from('rt_restaurant');
	$this->db->where('restaurant_status', $restaurant_status);
	$this->db->where('restaurant_validate', $restaurant_validate);
	$this->db->group_by('restaurant_city');
	$query = $this->db->get();
	if ($query) {
		$myArray = $query->result_array();
		return $myArray;
	}
	else {
		return false;
	}
}

function language_list()
{
	$this->db->select('lang_code, lang_name, lan_photo');
	$this->db->from('rt_language');
	$query = $this->db->get();
	//print_r($query);
	if ($query) {
		$myArray = $query->result_array();
		//print_r($myArray);
		return $myArray;
	}
	else {
		return false;
	}
}

function random_restaurant()
{
	$restaurant_status = '1';
	$restaurant_validate = '1';
	$this->db->select('restaurant_id,restaurant_seourl,restaurant_logo,restaurant_name');
	$this->db->from('rt_restaurant');
	$this->db->where('restaurant_status', $restaurant_status);
	$this->db->where('restaurant_validate', $restaurant_validate);
	$query = $this->db->get();
	//print_r($query);
	if ($query) {
		$myArray = $query->result_array();
		return $myArray;
	}
	else {
		return false;
	}
}


function populer_cuisine()
{
	$cuisine_popular_dish="Yes";
	$cuisine_status = '1';
	$this->db->select('*');
	$this->db->from('rt_cuisine');
	$this->db->where('cuisine_popular_dish',$cuisine_popular_dish); 
	$this->db->where('cuisine_status',$cuisine_status); 
	$this->db->limit(6);
	$query = $this->db->get();
	if ($query) {
		return $query->result_array();
	}
	else {
		return false;
	}
}



function cms_data($content_id) {
    	$this->db->select('*');
    	$this->db->from('rt_content');
    	$this->db->where('content_id',$content_id); 
    	$this->db->limit(1);
    	$query = $this->db->get();
    	if ($query) {
    		return $query->row_array();
    	}
    	else {
    		return false;
    	}
    }

	function faq_data() {
    	$this->db->select('*');
    	$this->db->from('rt_faq');
    	$query = $this->db->get();
    	if ($query->num_rows() > 0) {
    		return $query->result();
    	}
    	else {
    		return false;
    	}
    }


function get_website_settings() 
{
	$this->db->select('*');
	$this->db->from('rt_sitesetting');
	$query = $this->db->get();
	if ($query->num_rows() > 0) 
	{
	return $query->row_array();
	}
	return false;
}


function restaurantList($longitude,$latitude,$orerby=1,$cuisineids='',$searchnm='',$restaurant_state = '',$restaurant_city = '')
{

	//2 = newest
	$orerbyOpt="ORDER BY distance ASC";
	$xwhere='';
	$ywhere = '';
	$cusinesWhere ='';
	$searchFlag = 0;
	$isOffer = false;
	$isCusine = false;
    if($orerby==2)
    {
    	$orerbyOpt="ORDER BY  r1.addeddate DESC";
    }

	if($orerby==4)
    {
  //   	$restaurant_id = 0;
  //   	$is_active = 1;
		// $this->db->select('restaurant_estimated_time');
		// $this->db->from('rt_restaurant');
		// $this->db->where('restaurant_id',$restaurant_id);
		// $this->db->order_by('restaurant_id','ASC');
		// $query = $this->db->get();

  //   	$DelliveryTimeList =$query->row_array();

  //   	$Estimated_delivery_time = !empty($DelliveryTimeList['estimated_time']) ? $DelliveryTimeList['estimated_time'] : '0';

  //   	$this->db->trans_start();
  //       $data_up= array(
  //         'restaurant_estimated_time' => $Estimated_delivery_time
  //       );

  //       $this->db->where('restaurant_estimated_time','0');
  //       $this->db->update('rt_restaurant',$data_up);
  //       $this->db->trans_complete(); 


    	$orerbyOpt="ORDER BY ABS(r1.restaurant_estimated_time) ASC";
    }
	if($orerby == 6) {
    	$orerbyOpt = "ORDER BY r1.restaurant_name ASC";
    }
	if($orerby == 7) {
    	$orerbyOpt = "ORDER BY r1.restaurant_minorder_price ASC, r1.restaurant_minorder_price_2 ASC, r1.restaurant_minorder_price_3 ASC";
    }
	if($orerby == 8) {
    	$orerbyOpt = "ORDER BY r1.restaurant_delivery_charge ASC, r1.restaurant_delivery_charge_2 ASC, r1.restaurant_delivery_charge_3 ASC";
    }


    if($orerby==3)
    {
    $today_date = date('Y-m-d');
    $this -> db -> select('*');
    $this -> db -> from('rt_restaurant_offer');
    $this->db->where('offer_valid_to >= ' . "'" . $today_date . "'");
    $this->db->group_by('restaurant_id');
    $query = $this -> db -> get();
    $offer = $query->result_array();

    if(!empty($offer))
		{
			foreach($offer as $k=> $ids)
			{
				$newOfferArr[$k] = $ids["restaurant_id"];
			}
		}
		$searchFlag++;
		$isOffer = true;

		
	}


	
	$cusinesArray = array();
	if($cuisineids != '')
	{
		$cusinesNewArr = explode(",", $cuisineids);
		$cusinesNew = "";
		if(!empty($cusinesNewArr))
		{
			foreach($cusinesNewArr as $ResIds)
			{
				//$cusinesNew .= trim($ResIds).",";
                $cusinesWhere .= " FIND_IN_SET('".trim($ResIds)."', `restaurant_serving_cuisines` ) " ." OR ";
			}
			$cusinesWhere = rtrim($cusinesWhere, " OR ");
		}
		//$_POST["new_cusine"] = $cusinesNew;
               
		//$findCusines = find("all", RESTAURANT, "restaurant_id", "where ".$cusinesWhere." GROUP BY restaurant_id", array());

		$sql_query = "select restaurant_id FROM  `rt_restaurant`  WHERE ".$cusinesWhere." GROUP BY restaurant_id";
		$query = $this->db->query($sql_query);

		$findCusines = $query->result_array();
		//print_r($findCusines);
		//exit();

		if(!empty($findCusines))
		{
			foreach($findCusines as $k=> $resTId)
			{

				$cusinesArray[$k] = $resTId["restaurant_id"];;
			}
		}
		$searchFlag++;
		$isCusine = true;
	}

	if($isCusine && $isOffer){
		if(!empty($cusinesArray))
		{
			$newRestaurantArr = array_intersect($newOfferArr, $cusinesArray);
		}else
		{
			$newRestaurantArr = $newOfferArr;
		}
		//print_r($newRestaurantArr);
		//exit();
	}
	elseif($isCusine)
	{
		$newRestaurantArr = $cusinesArray;
	}
	elseif ($isOffer) {
		$newRestaurantArr = $newOfferArr;
	}


	$newRestaurantString = "";
	if(!empty($newRestaurantArr))
	{
		foreach($newRestaurantArr as $ResIds)
		{
			$newRestaurantString .= $ResIds.",";
		}
		$newRestaurantString = rtrim($newRestaurantString, ",");
	}

	//echo $newRestaurantString;
	//exit();
	if($searchFlag>0)
	{
		if($newRestaurantString != "")
		{
			$zwhere = " WHERE r1.restaurant_id IN(".$newRestaurantString.") AND  r1.restaurant_status='1' AND  r1.restaurant_validate='1' ";	
		}else{
			$zwhere = " WHERE r1.restaurant_id IN(0) AND  r1.restaurant_status='1' AND  r1.restaurant_validate='1' ";
		}
	}else{

		$zwhere = " WHERE r1.restaurant_status='1' AND  r1.restaurant_validate='1' ";
	}



	if($searchnm!='')
	{
		$ywhere = " AND  r1.restaurant_name LIKE '%".addslashes($searchnm)."%'";	
		
	}
	if ($restaurant_state != '') {
		$ywhere .= " AND r1.restaurant_state = '".$restaurant_state."'";
	}
	if ($restaurant_city) {
		$ywhere .= " AND r1.restaurant_city = '".$restaurant_city."'";
	}
    $sql_query = "select *, (111.1111 * DEGREES(ACOS(COS(RADIANS(".$latitude.")) * COS(RADIANS(latitude)) * COS(RADIANS(longitude - ".$longitude.")) + SIN(RADIANS(".$latitude.")) * SIN(RADIANS(latitude))))) AS distance FROM  `rt_restaurant`  r1 ".$zwhere." ".$ywhere." AND r1.braintree_sub_merchant_status = 'active' ".$orerbyOpt."" ;

    if($orerby==5)
    {
    	$sql_query ='';
    $sql_query = "select r1.*, (111.1111 * DEGREES(ACOS(COS(RADIANS(".$latitude.")) * COS(RADIANS( r1.latitude)) * COS(RADIANS(longitude - ".$longitude.")) + SIN(RADIANS(".$latitude.")) * SIN(RADIANS( r1.latitude))))) AS distance,count(o2.orderid) orderctn FROM rt_restaurant r1  LEFT JOIN rt_order o2 on o2.restaurant_id = r1.restaurant_id ".$zwhere." ".$ywhere." AND r1.braintree_sub_merchant_status = 'active' group by r1.restaurant_id ORDER BY orderctn desc";
    }


    //echo $sql_query;
	$query = $this->db->query($sql_query);
	//$query = $this->db->get();
	if ($query->num_rows() > 0) 
	{
	return $query->result();
	}
	return false;
}

function getCustomerData($customer_id) {
    $this->db->select('*');
    $this->db->from('rt_customer');
    $this->db->where('customer_id', $customer_id);
    $query = $this->db->get();
    return ($query->num_rows() > 0)?$query->row_array():FALSE;
    }
    function validateCustomer($verify_code) {
        $this->db->select('*');
        $this->db->from('rt_customer');
        $this->db->where('customer_validate_id', $verify_code);
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            $data = $query->row();
            if ($data->customer_validate == '1') {
                return 2;
            }
            else {
                $data_up = array(
                    'customer_validate' => '1'
                  );
                $this->db->where('customer_validate_id', $verify_code);
                $this->db->update('rt_customer', $data_up);
                return 1;
            }
        }
        else {
            return 0;
        }
    }


    function DelliveryTimeList($restaurant_id=0)
	{
		$is_active = 1;
		$this->db->select('*');
		$this->db->from('rt_delivery_zone');
		$this->db->where('restaurant_id',$restaurant_id);
		$this->db->order_by('id','ASC');
		$query = $this->db->get();

		if ($query->num_rows() > 0) 
		{
		return $query->result_array();
		}
		return false;
	}

	function cateringRestaurantList() {
		$this->db->select('restaurant_id, restaurant_name');
		$this->db->from('rt_restaurant');
		$this->db->where('restaurant_validate', '1');
		$this->db->where('restaurant_status', '1');
		$this->db->where('business_type', '1');
		$this->db->order_by('restaurant_name','ASC');
		$query = $this->db->get();
		if ($query->num_rows() > 0) 
		{
		return $query->result_array();
		}
		return false;
	}
    /**
     * Check whether reward poin system is applicable for this system
     * @param boolean if needed return data
     * @return boolean
     */
	function checkRewardPointStatus($returnData = false)
    {
        $this->db->select('reward_point_status, reward_point, redemption_point, min_reward_withdrawal');
        $this->db->from('rt_sitesetting');
        $this->db->where('id', '1');
        $query = $this->db->get();
        if ($query->num_rows() > 0)
        {
            $result = $query->row_array();
            if($returnData)
            {
                return $result;
            }else {
                if ($result["reward_point_status"] == "Yes")
                    return true;
            }
        }
        return false;
    }

    /**
     * Pay reward for every purchase
     * @param1 string customer id, @param2 string orderAmount
     * @return void
     */

    function payRewardPoint($customerId, $orderAmount, $pointAmount = 0) {
        if (frontend_model::checkRewardPointStatus()) {
            $rewardSetting = frontend_model::checkRewardPointStatus(true);

            if ($rewardSetting["reward_point"] > 0) {
                //print_r($rewardSetting);
                //$orderAmount = $orderAmount / $CFG["reward"]["point_per_amount"];
                $point = $orderAmount * $rewardSetting["reward_point"];
                if($pointAmount > 0)
                {
                    $point = $pointAmount;
                }
                $this->db->query("UPDATE rt_customer SET reward_points = reward_points + " . floor($point)." WHERE customer_id = ".$customerId);
                //echo $this->db->last_query();
            }
        }
    }
    //ALTER TABLE `rt_customer` ADD `reward_points` DECIMAL(10,2) NOT NULL DEFAULT '0' AFTER `device_token_ios`;
    //ALTER TABLE `rt_order` ADD `point_amount` DECIMAL(10,2) NOT NULL DEFAULT '0.00' AFTER `refund_apply_time`;
    //ALTER TABLE `rt_sitesetting` ADD `reward_point_status` ENUM("Yes","No") NOT NULL DEFAULT 'No' AFTER `site_tax`, ADD `reward_point` INT NOT NULL AFTER `reward_point_status`, ADD `redemption_point` INT NOT NULL AFTER `reward_point`, ADD `min_reward_withdrawal` INT NOT NULL AFTER `redemption_point`;

    /**
     * deduct reward for point purchase
     * @param1 customer id, @param2 orderAmount
     * @return void
     */

    function deductPoint($customerId, $orderAmount, $pointVal = "") {
        if (frontend_model::checkRewardPointStatus()) {
            $rewardSetting = frontend_model::checkRewardPointStatus(true);
            if ($rewardSetting["reward_point"] > 0) {
                $points = frontend_model::getRewardPoints($customerId);
                //print_r($points);
                //$orderAmount = $orderAmount / $CFG["reward"]["point_per_amount"];
                $point = $orderAmount * $rewardSetting["reward_point"];
                if(!empty($pointVal)) $point = $pointVal;
                $this->db->query("UPDATE rt_customer SET reward_points = reward_points - " . floor($point)." WHERE customer_id = ".$customerId);
                //echo $this->db->last_query();
            }
        }
    }
    /**
     * Retrieve reward for every purchase
     * @param1 String customer id
     * @return array
     */

    function getRewardPoints($customerId) {
        $rewards = array();
        $rewards["points"] = 0;
        $rewards["amount"] = 0;
        if (frontend_model::checkRewardPointStatus()) {
            $rewardSetting = frontend_model::checkRewardPointStatus(true);
            $this->db->select('reward_points');
            $this->db->from('rt_customer');
            $this->db->where('customer_id', $customerId);
            $query = $this->db->get();
            if ($query->num_rows() > 0) {
                $result = $query->row_array();
                $rewards["points"] = floor($result["reward_points"]);
                $rewards["amount"] = $rewards["points"] / $rewardSetting["redemption_point"];
            }
        }
        return $rewards;
    }
    /**
     * Retrieve Redemption Availability
     * @param1 String customer id
     * @return boolean
     */

    function getRedemptionAvailability($customerId) {
        if (frontend_model::checkRewardPointStatus()) {
            $rewardSetting = frontend_model::checkRewardPointStatus(true);
            $points = $this->getRewardPoints($customerId);
            if($points["points"] > $rewardSetting["min_reward_withdrawal"]) return true;
        }
        return false;
    }

    /**
     * Newsletter Subcription
     * @param $subscriber_type
     * @param $subscriber_email
     */
    function newsletterSubscribe($subscriber_type, $subscriber_email)
    {
        $table = "rt_newsletter_subscriber";
        $this->db->select('id');
        $this->db->from($table);
        $this->db->where('subscriber_type', $subscriber_type);
        $this->db->where('subscriber_email', $subscriber_email);
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            // Subscriber already exists
        }else{
            $this->db->trans_start();
            $this->db->insert($table,
                array(
                    "subscriber_email"=>$subscriber_email,
                    "subscriber_type"=>$subscriber_type
                    )
            );
            $this->db->trans_complete();
        }
    }

    /**
     * @param array $params
     * @param string $subscriber_type
     * @return bool
     */
    function getNewsletterSubscriberList($params = array(), $action = "", $subscriber_type = "all")
    {
        $table = "rt_newsletter_subscriber";
        $this->db->select('*');
        $this->db->from($table);
        if(!empty($subscriber_type) && $subscriber_type != "all") {
            $this->db->where('subscriber_type', $subscriber_type);
        }
        if ($action == '4') {
            $this->db->order_by('subscriber_email', 'ASC');
        }
        else if ($action == '5') {
            $this->db->order_by('subscriber_email', 'DESC');
        }
        else if ($action == '6') {
            $this->db->order_by('subscriber_type', 'ASC');
        }
        else if ($action == '7') {
            $this->db->order_by('subscriber_type', 'DESC');
        }
        else {
            $this->db->order_by('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();
        if ($query->num_rows() > 0) {
            return $query->result_array();
        }
        return false;
    }
}
?>