<?php
Class driver_model extends CI_Model {

	function get_driver_list($params = array(), $action = '') {

        $driver_validate='1';

        $this->db->select('*');
        $this->db->from('rt_driver');
        $this->db->where('driver_validate', $driver_validate);
        #0 => pending
        #1 => approved
        #2 => rejected

        if ($this->session->userdata('logged_in_restaurant')) {
            $restaurant_id = $this->session->userdata('logged_in_restaurant')['id'];
            $this->db->where('restaurant_id', $restaurant_id);
        }
        if ($action == '0' || $action == '1' || $action == '2') {
            $this->db->where('driver_status', $action);
            $this->db->order_by('driver_id', 'DESC');
        }
        else if ($action == '12') {
            $this->db->order_by('addeddate', 'ASC');
        }
        else if ($action == '21') {
            $this->db->order_by('addeddate', 'DESC');
        }
        else {
            $this->db->order_by('driver_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 getDriverData($driver_id) {
        $this->db->select('rt_driver_temp.*, rt_city.cityname, rt_state.statename');
        $this->db->from('rt_driver_temp');
        $this->db->join('rt_city', 'rt_city.city_id = rt_driver_temp.driver_city', 'left');
        $this->db->join('rt_state', 'rt_state.statecode = rt_driver_temp.driver_license_state', 'left');
        $this->db->where('driver_id', $driver_id);
        $query = $this->db->get();
        return ($query->num_rows() > 0)?$query->row_array():FALSE;
    }

    function getDriverDataOriginal($driver_id) {
        $this->db->select('rt_driver.*, rt_state.statename');
        $this->db->from('rt_driver');
        //$this->db->join('rt_city', 'rt_city.city_id = rt_driver.driver_city', 'left');
        $this->db->join('rt_state', 'rt_state.statecode = rt_driver.driver_license_state', 'left');
        $this->db->where('driver_id', $driver_id);
        $query = $this->db->get();
        return ($query->num_rows() > 0)?$query->row_array():FALSE;
    }


    function getDriverData_byCode($verify_code) {
        $this->db->select('*');
        $this->db->from('rt_driver_temp');
        $this->db->where('driver_validate_id', $verify_code);
        $query = $this->db->get();
        return ($query->num_rows() > 0)?$query->row_array():FALSE;
    }

    function getDriverData_details($driver_id) {
        $this->db->select('*');
        $this->db->from('rt_driver');
        $this->db->where('driver_id', $driver_id);
        $query = $this->db->get();
        return ($query->num_rows() > 0)?$query->row_array():FALSE;
    }

    function getMainDriverSchedule() {
        $this->db->select('driver_per_day');
        $this->db->from('rt_sitesetting');
        $query = $this->db->get();
        return $query->row_array();
    }

    function getDriverSchedule() {
        $this->db->select('*');
        $this->db->from('rt_driver_schedule');
        $query = $this->db->get();
        return $query->result_array();
    }

    function isDriverExist($driver_id) {
        $this->db->select('*');
        $this->db->from('rt_driver');
        $this->db->where('driver_id', $driver_id);
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return true;
        }
        else {
            return false;
        }
    }

    function isEmailExist($driver_email, $driver_id) {
        $this->db->select('driver_id');
        $this->db->from('rt_driver');
        $this->db->where('driver_email', $driver_email);
        $this->db->where('driver_id !=', $driver_id);
        $queryDri = $this->db->get();

        $this->db->select('restaurant_id');
        $this->db->from('rt_restaurant');
        $this->db->where('restaurant_contact_email', $driver_email); 
        $queryRest = $this->db->get();
        
        $this->db->select('customer_id');
        $this->db->from('rt_customer');
        $this->db->where('customer_email', $driver_email);
        $queryCust = $this->db->get();
        //if ($queryDri->num_rows() > 0 || $queryRest->num_rows() > 0 || $queryCust->num_rows() > 0) {
        if ($queryDri->num_rows() > 0) {
            return true;
        }
        else {
            return false;
        }
    }

    function validateDriver($verify_code) {
        $this->db->select('*');
        $this->db->from('rt_driver_temp');
        $this->db->where('driver_validate_id', $verify_code);
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            $data = $query->row();
            if ($data->driver_validate == '1') {
                return 2;
            }
            else {
                $data_up = array(
                    'driver_validate' => '1'
                  );
                $this->db->where('driver_validate_id', $verify_code);
                $this->db->update('rt_driver_temp', $data_up);
                return 1;
            }
        }
        else {
            return 0;
        }
    }


    function DriverList() 
    {
        $is_active = 1;
        $this->db->select('*');
        $this->db->from('rt_driver');
        $this->db->where('driver_status = ' . "'" . $is_active . "'".' order by driver_first_name ASC');
        $query = $this->db->get();

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


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

        $driver_validate='1';

        $this->db->select('*');
        $this->db->from('driver_invoice');
        //$this->db->where('driver_validate', $driver_validate);
        #0 => pending
        #1 => approved
        #2 => rejected
       if ($action == '12') {
            //$this->db->order_by('addeddate', 'ASC');
        }
        else if ($action == '21') {
            //$this->db->order_by('addeddate', 'DESC');
        }
        else {
            $this->db->order_by('invoice_id', 'DESC');
        }


        if ($action != '' && $action != 99999 && $action2 == 99999) {
            $this->db->where('driver_invoice.driverid', $action);
        }

        
        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 checkDriverSchedule($dt) {
        $this->db->select('*');
        $this->db->from('rt_driver_schedule');
        $this->db->where('driver_schedule_date', $dt);
        $query = $this->db->get();
        if($query -> num_rows() == 1)
            {
                return $query->row_array();
            }
            else
            {
                return false;
            }
    }

	function DriverAvailableList($schedule_date) 
    {
        $is_active = 1;
        $this->db->select('*,rt_driver.driver_first_name,rt_driver.driver_last_name,rt_driver.driver_availability_status');
        $this->db->from('rt_driver_available_schedule');
        $this->db->join('rt_driver', 'rt_driver.driver_id = rt_driver_available_schedule.driver_id');
        $this->db->where('schedule_date',$schedule_date);
        $query = $this->db->get();

        if ($query->num_rows() > 0) 
        {
        return $query->result();
        }
        return false;
    }
    function driverAssigned($driver_id) {
        $this->db->select('orderid');
        $this->db->from('rt_order');
        $this->db->where('driverid',$driver_id);
        $this->db->where('delivery_status !=', 3);
        $query = $this->db->get();
        if ($query->num_rows() > 0) {
            return true;
        }
        else {
            return false;
        }
    }

}