<?php
Class menumanagement_model extends CI_Model {

function CategoryStatistics($status='')
{
    if($this->session->userdata('logged_in_restaurant')){
        $session_data = $this->session->userdata('logged_in_restaurant');
        $restaurant_id = $session_data['id']; 
        $id_array = array($restaurant_id, 0);
    }else{
        $restaurant_id = 0; 
    }

	$this -> db -> select('*');
	$this -> db -> from('rt_category_main');
    if($restaurant_id>0)
    {
        $this->db->where_in('restaurant_id', $id_array);
    }

	if($status!='') { $this -> db -> where('status',$status);  }
	$query = $this -> db -> get();
	return $query->num_rows();
}

function MenuStatistics($status='',$menu_popular_dish='',$menu_type='')
{
    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_menu');
    if($restaurant_id>0)
    {
        $this->db->where('restaurant_id', $restaurant_id);
    }
        
    if($status!='') { $this -> db -> where('status',$status);  }
    if($menu_popular_dish!='') { $this -> db -> where('menu_popular_dish',$menu_popular_dish);  }
    if($menu_type!='') { $this -> db -> where('menu_type',$menu_type);  }
    $query = $this -> db -> get();
    return $query->num_rows();
}

function AddonsStatistics($status='')
{
   
        $restaurant_id = 0; 

    $parentid=0;
    $this -> db -> select('*');
    $this -> db -> from('rt_restaurant_addons');
    $this->db->join('rt_category_main','rt_category_main.maincateid=rt_restaurant_addons.category_id', 'left');
    $this->db->where('rt_restaurant_addons.parentid',$parentid);

    if($restaurant_id>0)
    {
        $this->db->where('rt_restaurant_addons.restaurant_id', $restaurant_id);
    }

    if($status!='') { $this -> db -> where('rt_restaurant_addons.status',$status);  }
    $query = $this -> db -> get();
    return $query->num_rows();
}

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

    $parentid=0;
    $this -> db -> select('*');
    $this -> db -> from('rt_restaurant_addons');
    $this->db->join('rt_category_main','rt_category_main.maincateid=rt_restaurant_addons.category_id', 'left');
    $this->db->where('rt_restaurant_addons.parentid',$parentid);

    if($restaurant_id>0)
    {
        //$this->db->where_in('rt_restaurant_addons.restaurant_id', array($restaurant_id, 0));
        $this->db->where_in('rt_restaurant_addons.restaurant_id', $restaurant_id);
    }

    if($status!='') { $this -> db -> where('rt_restaurant_addons.status',$status);  }
    $query = $this -> db -> get();
    return $query->num_rows();
}


function get_category_list($params = array(), $action = '',$action2 =0,$get_category_list=0)
    {

        
        

        $this->db->select('rt_category_main.*, rt_restaurant.restaurant_name');
        $this->db->from('rt_category_main');
        $this->db->join('rt_restaurant', 'rt_restaurant.restaurant_id = rt_category_main.restaurant_id', 'left');

        
        if ($action == '1' || $action == '0') {
            $this->db->where('status', $action);
        }
        else if ($action == '19') {
            $this->db->order_by('maincatename', 'ASC');
        }
        else if ($action == '91') {
            $this->db->order_by('maincatename', 'DESC');
        }
        else if ($action == '89') {
            $this->db->order_by('status', 'ASC');
        }
        else if ($action == '98') {
            $this->db->order_by('status', 'DESC');
        }
        else {
            $this->db->order_by('maincateid', '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 get_category_list_for_restaurant($params = array(), $action = '',$action2 =0,$get_category_list=0)
    {

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

        $this->db->select('rt_category_main.*, rt_restaurant.restaurant_name');
        $this->db->from('rt_category_main');
        $this->db->join('rt_restaurant', 'rt_restaurant.restaurant_id = rt_category_main.restaurant_id', 'left');
        if($restaurant_id>0)
        {
            //$this->db->where_in('rt_category_main.restaurant_id', $id_array);
            $this->db->where('rt_category_main.restaurant_id', $restaurant_id);
        }

        if ($action == '1' || $action == '0') {
        	$this->db->where('status', $action);
        }
        else if ($action == '19') {
        	$this->db->order_by('maincatename', 'ASC');
        }
        else if ($action == '91') {
        	$this->db->order_by('maincatename', 'DESC');
        }
        else if ($action == '89') {
            $this->db->order_by('status', 'ASC');
        }
        else if ($action == '98') {
            $this->db->order_by('status', 'DESC');
        }
        else {
        	$this->db->order_by('maincateid', '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 RestaurantList($business_type = '') 
    {
        $is_active = 1;
        $is_validate = 1;
        $this->db->select('*');
        $this->db->from('rt_restaurant');
        if ($business_type !== '') {
            $this->db->where('business_type', $business_type);
        }
        $this->db->where('restaurant_status = ' . "'" . $is_active . "'".' AND restaurant_validate = ' . "'" . $is_validate . "'".' order by restaurant_name ASC');
        $query = $this->db->get();

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

    function get_menu_list($params = array(), $action = '',$action2 =0)
    {


        /*1 =>Active
        0=>Deactive<                                 
        2=>Popular
        3=>Normal                                
        4=>Menu Type - Veg                                
        5=>Menu Type - Non                                   
        6=>Menu Name A to Z                                
        7=>Menu Name Z to A                                
        8=>Category Name A to Z                                
        9=>Category Name Z to A
        10=>Price A to Z                                
        11=>Price Z to A           */    

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


        $this->db->select('rt_category_main.maincatename,rt_restaurant_menu.*,rt_restaurant.restaurant_name,rt_restaurant.restaurant_seourl');
        $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->join('rt_restaurant','rt_restaurant.restaurant_id=rt_restaurant_menu.restaurant_id', 'left outer');


        if ($action == '1' || $action == '0') {
            $this->db->where('rt_restaurant_menu.status', $action);
        }
        else if ($action == '2') {
            $this->db->order_by('rt_restaurant_menu.menu_popular_dish', 'ASC');
        }
        else if ($action == '3') {
            $this->db->order_by('rt_restaurant_menu.menu_popular_dish', 'DESC');
        }
        else if ($action == '4') {
            //$this->db->order_by('rt_restaurant_menu.menu_type', 'ASC');
            $this->db->where('rt_restaurant_menu.menu_type', 'veg');
        }
        else if ($action == '5') {
            //$this->db->order_by('rt_restaurant_menu.menu_type', 'DESC');
            $this->db->where('rt_restaurant_menu.menu_type', 'nonveg');
        }
        else if ($action == '6') {
            $this->db->order_by('rt_restaurant_menu.menu_name', 'ASC');
        }
        else if ($action == '7') {
            $this->db->order_by('rt_restaurant_menu.menu_name', 'DESC');
        }
        else if ($action == '8') {
            $this->db->order_by('rt_category_main.maincatename', 'ASC');
        }
        else if ($action == '9') {
            $this->db->order_by('rt_category_main.maincatename', 'DESC');
        }
        else if ($action == '10') {
            $this->db->order_by('rt_restaurant_menu.menu_price', 'DESC');
        }
        else if ($action == '11') {
            $this->db->order_by('rt_restaurant_menu.menu_price', 'ASC');
        }
        else {
            $this->db->order_by('id', 'DESC');
        }
        if ($action != '99' && $action > 11) {
            $this->db->where('rt_restaurant_menu.id', $action);
        }
        if($action2>0 && $action != '121'){
            $this->db->where('rt_restaurant_menu.restaurant_id', $action2);
        }
        if ($action == '121' && $action2 != '121121') {
            $this->db->where('rt_category_main.maincateid', $action2);
        }

        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();

        $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 menu_slice_price($restaurant_id,$menu_slice_id) 
        {  
            $this->db->select('*');
            $this->db->from('rt_restaurant_menu_slice');
            $this->db->where('menu_slice_restaurantid',$restaurant_id);
            $this->db->where('menu_slice_menuid',$menu_slice_id);
            $query = $this->db->get();
            if ($query->num_rows() > 0) 
            {
                $price = $query->row_array();
            return $price['menu_slice_price'];
            }
            return 0;
        }

    function get_addons_list($params = array(), $action = '',$action2 =0)
    {
        /*1 =>Active
        0=>Deactive<                                 
        2=>Addons Name A to Z
        3=>Addons Name Z to A                                
        4=>Category Name A to Z                           
        5=>Category Name Z to A  */  

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


        $parentid=0;
        $this->db->select('rt_category_main.maincatename,rt_restaurant_addons.*,rt_restaurant.restaurant_name');
        $this->db->from('rt_restaurant_addons');
        $this->db->join('rt_category_main','rt_category_main.maincateid=rt_restaurant_addons.category_id', 'left');
        $this->db->join('rt_restaurant','rt_restaurant.restaurant_id=rt_restaurant_addons.restaurant_id', 'left');
        //$this->db->join('rt_restaurant','rt_restaurant.restaurant_id=rt_restaurant_addons.restaurant_id');
        $this->db->where('rt_restaurant_addons.parentid',$parentid);

        if ($action == '1' || $action == '0') {
            $this->db->where('rt_restaurant_addons.status', $action);
        }
        else if ($action == '2') {
            $this->db->order_by('rt_restaurant_addons.addonsname', 'ASC');
        }
        else if ($action == '3') {
            $this->db->order_by('rt_restaurant_addons.addonsname', 'DESC');
        }
        else if ($action == '4') {
            $this->db->order_by('rt_category_main.maincatename', 'ASC');
        }
        else if ($action == '5') {
            $this->db->order_by('rt_category_main.maincatename', 'DESC');
        }
        else if ($action != '' && $action != 99999 && $action2 == 99999) {
            $this->db->where('rt_restaurant_addons.restaurant_id', $action);
        }
        
        else {
            $this->db->order_by('id', 'DESC');
        }

        /*if($restaurant_id>0){
            $this->db->where('rt_restaurant_addons.restaurant_id', $restaurant_id);
        }*/
        $this->db->where('rt_restaurant_addons.parentid', '0');
        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 get_addons_list_for_restaurant($params = array(), $action = '',$action2 =0)
    {
        /*1 =>Active
        0=>Deactive<                                 
        2=>Addons Name A to Z
        3=>Addons Name Z to A                                
        4=>Category Name A to Z                           
        5=>Category Name Z to A  */  

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


        $parentid=0;
        $this->db->select('rt_category_main.maincatename,rt_restaurant_addons.*');
        $this->db->from('rt_restaurant_addons');
        $this->db->join('rt_category_main','rt_category_main.maincateid=rt_restaurant_addons.category_id', 'left');
        //$this->db->join('rt_restaurant','rt_restaurant.restaurant_id=rt_restaurant_addons.restaurant_id');
        $this->db->where('rt_restaurant_addons.parentid',$parentid);

        if ($action == '1' || $action == '0') {
            $this->db->where('rt_restaurant_addons.status', $action);
        }
        else if ($action == '2') {
            $this->db->order_by('rt_restaurant_addons.addonsname', 'ASC');
        }
        else if ($action == '3') {
            $this->db->order_by('rt_restaurant_addons.addonsname', 'DESC');
        }
        else if ($action == '4') {
            $this->db->order_by('rt_category_main.maincatename', 'ASC');
        }
        else if ($action == '5') {
            $this->db->order_by('rt_category_main.maincatename', 'DESC');
        }
        
        else {
            $this->db->order_by('id', 'DESC');
        }

        if($restaurant_id>0){
            //$this->db->where_in('rt_restaurant_addons.restaurant_id', array($restaurant_id,0));
            $this->db->where_in('rt_restaurant_addons.restaurant_id', $restaurant_id);
        }
        $this->db->where('rt_restaurant_addons.parentid', '0');
        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 get_order_list($params = array(), $action = '', $action2 =0, $action3 ='',$action4 =0)
    {
        $actionX = 999999;
        if (is_array($action)) {
            $actionX = isset($action[1]) ? $action[1] : 999999;
            $action = $action[0];
        }
        /*1 =>Pending
        2=>In Preparation                              
        3=>Out for delivery
        4=>Delivered                               
        5=>Cancelled                           
        6=>Rejected
        7=>Missed
        8=>Restaurant Name A to Z
        9=>Restaurant Name Z to A
        10=>Email A to Z
        11=>Email Z to A
        12=>Total Price 0 to 9
        13=>Total Price 9 to 0
        14=>Order Type A to Z
        15=>Order Type Z to A
        16=>Order Number 0 to 9
        17=>Order Number 0 to 9
        18=>Order At A to Z
        19=>Order At Z to A
          */     
        /*if($this->session->userdata('logged_in_restaurant')){
        $session_data = $this->session->userdata('logged_in_restaurant');
        $action2 = $session_data['id']; 
        }else{
            $action2 = 0; 
        }*/

        

        $this->db->select('rt_restaurant.restaurant_name name,rt_order.*, rt_customer.customer_name');
        $this->db->from('rt_order');
        $this->db->join('rt_restaurant','rt_restaurant.restaurant_id=rt_order.restaurant_id', 'LEFT');
        $this->db->join('rt_customer','rt_customer.customer_email=rt_order.customeremail', 'LEFT');
        //$this->db->order_by('rt_order.orderid', 'DESC');

        if($action3!='' && $action3 != 'RR') {
             $this->db->where('rt_order.usertype', $action3);
        }
        else if ($action3 == 'RR' && $action != '5' && $action != '6') {
            //$this->db->where('rt_order.status', 'Refund Requested');
            //$this->db->or_where('rt_order.status', 'Refund Accepted');
            $this->db->where_in('rt_order.status', array('Refund Requested','Refund Accepted'));
        }

        if($action4>0 && $action4!=999999){
             $this->db->where('rt_order.restaurant_id', $action4);
        }

        if (!is_numeric($action) && $action != '') {
            $this->db->where('rt_order.ordergenerateid', $action);
        }

        if ($action == '1') {
            $this->db->where('rt_order.status', 'Pending');
        }
        else if ($action == '2') {
            $this->db->where('rt_order.status', 'In Preparation');
        }
        else if ($action == '3') {
            $this->db->where('rt_order.status', 'Out for delivery');
        }
        else if ($action == '4') {
            $this->db->where('rt_order.status', 'Delivered');
        }
        else if ($action == '5') {
            $this->db->where('rt_order.status', 'Refund Requested');
        }
        else if ($action == '6') {
            $this->db->where('rt_order.status', 'Refund Accepted');
        }
        else if ($action == '7') {
            $this->db->where('rt_order.status', 'Missed');
        }
        /* added by arka*/
        $today = date('Y-m-d');
        $date = strtotime($today);
        $startingSunday   = strtotime('-' . date('w', $date) . ' days', $date);
        $previousSaturday = strtotime('-1 day', $startingSunday);
        $nextWeekSaturday   = strtotime('+6 days', $startingSunday);
        $startingSunday = date('Y-m-d',$startingSunday);
        $nextSaturday = date('Y-m-d',$nextWeekSaturday);
        $first_day_this_month = date('Y-m-01'); 
        $last_day_this_month  = date('Y-m-t');
        $first_day_this_year = date('Y-01-01'); 
        $last_day_this_year  = date('Y-12-31');
        $this_month = date('m');
        $previous_month = $this_month - 1;
        $first_day_previous_month = date('Y-'.$previous_month.'-01');
        $last_day_previous_month = date('Y-'.$previous_month.'-t');
        $this_year = date('Y');
        $previous_year = $this_year - 1;
        $first_day_previous_year = date(''.$previous_year.'-01-01'); 
        $last_day_previous_year  = date(''.$previous_year.'-12-31');

        //$this_month = date('m');
        
        if($actionX=='22') 
        {
            $this->db->where('date(orderdate) >=', $startingSunday);
            $this->db->where('date(orderdate) <=', $nextSaturday);
        }
        if($actionX=='25') 
        {
            $this->db->where('date(orderdate) >=', $first_day_this_month);
            $this->db->where('date(orderdate) <=', $last_day_this_month);
        }
        if($actionX=='26') 
        {
            $this->db->where('date(orderdate) >=', $first_day_previous_month);
            $this->db->where('date(orderdate) <=', $last_day_previous_month);
        }
        if($actionX=='28') 
        {
            $this->db->where('date(orderdate) >=', $first_day_this_year);
            $this->db->where('date(orderdate) <=', $last_day_this_year);
        }
        if($actionX=='29') 
        {
            $this->db->where('date(orderdate) >=', $first_day_previous_year);
            $this->db->where('date(orderdate) <=', $last_day_previous_year);
        }
        if($actionX=='30') 
        {
            //$this->db->where('date(orderdate)', $first_day_previous_year);
            $this->db->where('date(orderdate)', $today);
        }
        /* ended by arka */
        if ($action == '8') {
            $this->db->order_by('rt_restaurant.restaurant_name', 'ASC');
        }else if($action == '9'){
            $this->db->order_by('rt_restaurant.restaurant_name', 'DESC');
        }else if($action == '10'){
            $this->db->order_by('rt_order.customeremail', 'ASC');
        }else if($action == '11'){
            $this->db->order_by('rt_order.customeremail', 'DESC');
        }else if($action == '12'){
            $this->db->order_by('rt_order.ordertotalprice', 'ASC');
        }else if($action == '13'){
            $this->db->order_by('rt_order.ordertotalprice', 'DESC');
        }else if($action == '14'){
            $this->db->order_by('rt_order.deliverytype', 'ASC');
        }else if($action == '15'){
            $this->db->order_by('rt_order.deliverytype', 'DESC');
        }else if($action == '16'){
            $this->db->order_by('rt_order.orderid', 'ASC');
        }else if($action == '17'){
            $this->db->order_by('rt_order.orderid', 'DESC');
        }else if($action == '18'){
            $this->db->order_by('rt_order.orderdate', 'ASC');
        }else if($action == '19'){
            $this->db->order_by('rt_order.orderdate', 'DESC');
        }else if($action3 == 'RR' && $action != '5' && $action != '6'){
            $this->db->order_by('rt_order.refund_apply_time', 'ASC');
        }else {
            $this->db->order_by('rt_order.orderid', 'DESC');
        }


        if($action2>0 && $action2 != 999999){
            $this->db->where('rt_order.restaurant_id', $action2);
        }

        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();
        //echo $this->db->last_query(); exit();
        return ($query->num_rows() > 0)?$query->result_array():FALSE;
    }

    function get_catering_request_list($params = array(), $action = '', $action2 =0, $action3 ='',$action4 =0) {
        
        $this->db->select('rt_order_caterer.*, rt_restaurant.restaurant_name, rt_restaurant.restaurant_id');
        $this->db->from('rt_order_caterer');
        $this->db->join('rt_restaurant', 'rt_restaurant.restaurant_id = rt_order_caterer.assigned_caterer', 'LEFT');

        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();
        //echo $this->db->last_query(); exit();
        return ($query->num_rows() > 0)?$query->result_array():FALSE;
    }

    function get_catering_request_list_restaurant($params = array(), $action = '', $action2 =0, $action3 ='',$action4 =0) {
        
        $this->db->select('rt_order_caterer.*, rt_restaurant.restaurant_name, rt_restaurant.restaurant_id');
        $this->db->from('rt_order_caterer');
        $this->db->join('rt_restaurant', 'rt_restaurant.restaurant_id = rt_order_caterer.assigned_caterer', 'LEFT');
        if ($this->session->userdata('logged_in_restaurant')) {
            $restaurant_id = $this->session->userdata('logged_in_restaurant')['id'];
        }
        else {
            $restaurant_id = 'xXxXx';
        }
        $this->db->where('assigned_caterer', $restaurant_id);

        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();
        //echo $this->db->last_query(); exit();
        return ($query->num_rows() > 0)?$query->result_array():FALSE;
    }

    function isCategoryExist($maincateid, $maincatename, $restaurant_id = false) {
        $this->db->select('*');
        $this->db->from('rt_category_main');
        $this->db->where('maincateid !=', $maincateid);
        if ($restaurant_id) {
            $this->db->where('restaurant_id', $restaurant_id);
        }
        $this->db->where('maincatename', $maincatename);
        $query = $this->db->get();
        return ($query->num_rows() > 0)?TRUE:FALSE;
    }
    function CategoryList() {
        $this->db->select('*');
        $this->db->from('rt_category_main');
        $this->db->where('status', '1');
        $this->db->order_by('maincatename', 'ASC');
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return $query->result();
        }
        else {
            return false;
        }
    }
    function CategoryListRestaurant($restaurant_id) {
        $this->db->select('*');
        $this->db->from('rt_category_main');
        $this->db->where('restaurant_id', $restaurant_id);
        $this->db->where('status', '1');
        $this->db->order_by('maincatename', 'ASC');
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return $query->result();
        }
        else {
            return false;
        }
    }
    function showEditMainAddons($id) {
        $this->db->select('*');
        $this->db->from('rt_restaurant_addons');
        $this->db->where('id', $id);
        if ($this->session->userdata('logged_in_restaurant')) {
            $RestaurantIdField = 'restaurant_id';
            $this->db->where($RestaurantIdField, $this->session->userdata('logged_in_restaurant')['id']);
        }
        $query = $this->db->get();
        return ($query->num_rows() > 0)?$query->row_array():FALSE;
    }
    function showEditSubAddons($id) {
        $this->db->select('*');
        $this->db->from('rt_restaurant_addons');
        $this->db->where('parentid', $id);
        if ($this->session->userdata('logged_in_restaurant')) {
            $RestaurantIdField = 'restaurant_id';
            $this->db->where($RestaurantIdField, $this->session->userdata('logged_in_restaurant')['id']);
        }
        $query = $this->db->get();
        return ($query->num_rows() > 0)?$query->result_array():FALSE;
    }
    function deleteAddons($id) {
        $this->db->where('id', $id);
        if ($this->session->userdata('logged_in_restaurant')) {
            $RestaurantIdField = 'restaurant_id';
            $this->db->where($RestaurantIdField, $this->session->userdata('logged_in_restaurant')['id']);
        }
        $query = $this->db->delete('rt_restaurant_addons');
        return $query;
    }

    function get_order_details($orderid)
    {
        $this->db->select('*');
        $this->db->from('rt_order');
        $this->db->where('orderid',$orderid);
        if ($this->session->userdata('logged_in_restaurant')) {
            $RestaurantIdField = 'restaurant_id';
            $this->db->where($RestaurantIdField, $this->session->userdata('logged_in_restaurant')['id']);
        }
        $query = $this->db->get();

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


    function get_order_kart($orderid)
    {
        $this->db->select('*');
        $this->db->from('rt_restaurant_cart');
        $this->db->where('orderid',$orderid);
        if ($this->session->userdata('logged_in_restaurant')) {
            $RestaurantIdField = 'restaurantid';
            $this->db->where($RestaurantIdField, $this->session->userdata('logged_in_restaurant')['id']);
        }
        $query = $this->db->get();

        if ($query->num_rows() > 0) 
        {
        return $query->result();
        }
        return false;
    }
    function CuisineList() {
        $is_active = 1;
        $this->db->select('*');
        $this->db->from('rt_cuisine');
        $this->db->where('cuisine_status = ' . "'" . $is_active . "'".' order by cuisine_name ASC');
        $query = $this->db->get();

        if ($query->num_rows() > 0) 
        {
        return $query->result();
        }
        return false;
    }
    function fetchCatParentAddons($catid, $menuid = false) {
        $is_active = '1';
        $this->db->select('*');
        $this->db->from('rt_restaurant_addons');
        $this->db->where('status', $is_active);
        $this->db->where('category_id', $catid);
        if ($menuid) {
            $this->db->where('`addonsname` NOT IN (SELECT `menuaddons_addonsname` FROM `rt_restaurant_menuaddons` WHERE menuaddons_menuid = '.$menuid.')', NULL, FALSE);
        }
        $this->db->where('parentid', '0');
        $this->db->order_by('addonsname', 'ASC');
        $query = $this->db->get();
        //return $query;
        if ($query->num_rows() > 0) {
            return $query->result_array();
        }
        else {
            return false;
        }
    }
    /*function fetchCatParentAddonsRest($catid, $menuid) {
        $is_active = '1';
        $this->db->select('*');
        $this->db->from('rt_restaurant_addons');
        $this->db->where('status', $is_active);
        $this->db->where('category_id', $catid);
        $this->db->where('`addonsname` NOT IN (SELECT `menuaddons_addonsname` FROM `rt_restaurant_menuaddons` WHERE menuaddons_menuid = 1205)', NULL, FALSE);
        $this->db->where('parentid', '0');
        $this->db->order_by('addonsname', 'ASC');
        $query = $this->db->get();
        //return $query;
        if ($query->num_rows() > 0) {
            return $query->result_array();
        }
        else {
            return false;
        }
    }*/
    function fetchCatChildAddons($parentid) {
        $is_active = '1';
        $this->db->select('*');
        $this->db->from('rt_restaurant_addons');
        $this->db->where('status', $is_active);
        $this->db->where('parentid', $parentid);
        $this->db->order_by('addonsname', 'ASC');
        $query = $this->db->get();
        //return $query;
        if ($query->num_rows() > 0) {
            return $query->result_array();
        }
        else {
            return false;
        }
    }
    function showEditMenu($menuid) {
        $is_active = '1';
        $this->db->select('*');
        $this->db->from('rt_restaurant_menu');
        $this->db->where('id', $menuid);
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return $query->row_array();
        }
        else {
            return false;
        }
    }
    function showEditMenuSize($menuid) {
        $is_active = '1';
        $this->db->select('*');
        $this->db->from('rt_restaurant_menu_slice');
        $this->db->where('menu_slice_menuid', $menuid);
        $this->db->order_by('menu_slice_id', 'ASC');
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return $query->result_array();
        }
        else {
            return false;
        }
    }
    function showEditMenuParentAddon($menuid) {
        $is_active = '1';
        $this->db->select('*');
        $this->db->from('rt_restaurant_menuaddons');
        $this->db->where('menuaddons_menuid', $menuid);
        $this->db->where('addonparentid', '0');
        $this->db->order_by('menuaddons_id', 'ASC');
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return $query->result_array();
        }
        else {
            return false;
        }
    }
    function showEditMenuChildAddon($parentid) {
        $is_active = '1';
        $this->db->select('*');
        $this->db->from('rt_restaurant_menuaddons');
        $this->db->where('addonparentid', $parentid);
        $this->db->order_by('menuaddons_id', 'ASC');
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return $query->result_array();
        }
        else {
            return false;
        }
    }
    function deleteMenuAddons($id) {
        $this->db->where('menuaddons_id', $id);
        $query = $this->db->delete('rt_restaurant_menuaddons');
        return $query;
    }
    function deleteMenuSize($id) {
        $this->db->where('menu_slice_id', $id);
        $query = $this->db->delete('rt_restaurant_menu_slice');
        return $query;
    }




     function get_order_list_restaurant($params = array(), $action = '', $action2 =0, $action3 ='',$action4 =0)
    {

       
        /*1 =>Pending
        2=>In Preparation                              
        3=>Out for delivery
        4=>Delivered                               
        5=>Cancelled                           
        6=>Rejected
        7=>Missed
        8=>Restaurant Name A to Z
        9=>Restaurant Name Z to A
        10=>Email A to Z
        11=>Email Z to A
        12=>Total Price 0 to 9
        13=>Total Price 9 to 0
        14=>Order Type A to Z
        15=>Order Type Z to A
        16=>Order Number 0 to 9
        17=>Order Number 0 to 9
        18=>Order At A to Z
        19=>Order At Z to A
          */     
        if($this->session->userdata('logged_in_restaurant')){
        $session_data = $this->session->userdata('logged_in_restaurant');
        $action2 = $session_data['id']; 
        }else{
            $action2 = 0; 
        }

        

        $this->db->select('rt_restaurant.restaurant_name name,rt_order.*');
        
        $this->db->from('rt_order');
        $this->db->join('rt_restaurant','rt_restaurant.restaurant_id=rt_order.restaurant_id');
        //$this->db->order_by('rt_order.orderid', 'DESC');

        if($action3!='' && $action3 != 'RR') {
             $this->db->where('rt_order.usertype', $action3);
             // Orders are accepted by drivers
            //$this->db->where('rt_order.driverid !=', 0);
        }
        else if ($action3 == 'RR' && $action != '5' && $action != '6') {
            //$this->db->where('rt_order.status', 'Refund Requested');
            //$this->db->or_where('rt_order.status', 'Refund Accepted');
            $this->db->where_in('rt_order.status', array('Refund Requested','Refund Accepted'));
        }
        else if ($action != '5' && $action != '6') {
            // Orders are accepted by drivers
            //$this->db->where('rt_order.driverid !=', 0);
        }

        if($action4>0){
             $this->db->where('rt_order.restaurant_id', $action4);
        }

        if (!is_numeric($action) && $action != '') {
            $this->db->where('rt_order.ordergenerateid', $action);
        }

        if ($action == '1') {
            $this->db->where('rt_order.status', 'Pending');
        }
        else if ($action == '2') {
            $this->db->where('rt_order.status', 'In Preparation');
        }
        else if ($action == '3') {
            $this->db->where('rt_order.status', 'Out for delivery');
        }
        else if ($action == '4') {
            $this->db->where('rt_order.status', 'Delivered');
        }
        else if ($action == '5') {
            $this->db->where('rt_order.status', 'Refund Requested');
        }
        else if ($action == '6') {
            $this->db->where('rt_order.status', 'Refund Accepted');
        }
        else if ($action == '7') {
            $this->db->where('rt_order.status', 'Missed');
        }

        if ($action == '8') {
            $this->db->order_by('rt_restaurant.restaurant_name', 'ASC');
        }else if($action == '9'){
            $this->db->order_by('rt_restaurant.restaurant_name', 'DESC');
        }else if($action == '10'){
            $this->db->order_by('rt_order.customeremail', 'ASC');
        }else if($action == '11'){
            $this->db->order_by('rt_order.customeremail', 'DESC');
        }else if($action == '12'){
            $this->db->order_by('rt_order.ordertotalprice', 'ASC');
        }else if($action == '13'){
            $this->db->order_by('rt_order.ordertotalprice', 'DESC');
        }else if($action == '14'){
            $this->db->order_by('rt_order.deliverytype', 'ASC');
        }else if($action == '15'){
            $this->db->order_by('rt_order.deliverytype', 'DESC');
        }else if($action == '16'){
            $this->db->order_by('rt_order.orderid', 'ASC');
        }else if($action == '17'){
            $this->db->order_by('rt_order.orderid', 'DESC');
        }else if($action == '18'){
            $this->db->order_by('rt_order.orderdate', 'ASC');
        }else if($action == '19'){
            $this->db->order_by('rt_order.orderdate', 'DESC');
        }
        else {
            $this->db->order_by('rt_order.orderid', 'DESC');
        }


        if($action2>0){
            $this->db->where('rt_order.restaurant_id', $action2);
        }

        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();
        //echo $this->db->last_query(); exit();
        return ($query->num_rows() > 0)?$query->result_array():FALSE;
    }

}