<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class MserviceDue extends CI_Model {

    public function __construct() {
        parent::__construct();

    }

    public function getRentOutDriver($car_id){
        $this->db->select('rov.car_id,rov.rent_out_id,rov.driver_id,rov.basic_excess,rov.age_excess,rov.overseas_dl_excess,mc.car_no,mc.make,mc.model,mc.year,mc.insurance_expire_pic,md.first_name,md.middle_name,md.last_name,md.mobile,ifnull(mc.total_odometer_reading,0) as total_odometer_reading');
        $this->db->from('rent_out_vehcile rov');
        $this->db->join('master_car mc','mc.car_id=rov.car_id','inner');
        $this->db->join('master_driver md','md.driver_id=rov.driver_id','inner');
        $this->db->where('rov.car_id',$car_id);
        $this->db->where('rov.is_rent_in','0');
        $this->db->order_by('rov.rent_out_id', 'ASC');
        $query=$this->db->get();
        $result = $query->result_array(); 
        if($result){
            return $result;
        } 
        return array();
    }

    public function get_service_due_list(){
        
        $query = "SELECT mc.car_id,mc.car_no,mc.make,mc.model,mc.year,ifnull(mc.total_odometer_reading,0) as total_odometer_reading,
        (ifnull(mc.service_kilometer,0) - (ifnull(mc.total_odometer_reading,0) - ifnull(mc.last_service_kilometer,0))) as service_due_kilometer,
        (ifnull(mc.transmission_service,0) - (ifnull(mc.total_odometer_reading,0) - ifnull(mc.last_transmission_service,0))) as transmission_service_due_kilometer,
        (ifnull(mc.spark_plug_for_eg,0) - (ifnull(mc.total_odometer_reading,0) - ifnull(mc.last_spark_plug_for_eg,0))) as spark_plug_service_due_kilometer,
        md.first_name,md.middle_name,md.last_name,md.mobile 
        FROM master_car mc 
        LEFT JOIN rent_out_vehcile rov ON rov.car_id = mc.car_id AND is_rent_in = '0'
        LEFT JOIN master_driver md ON md.driver_id = rov.driver_id
        WHERE mc.status='0' GROUP BY mc.car_id ORDER BY service_due_kilometer ASC,transmission_service_due_kilometer ASC, spark_plug_service_due_kilometer ASC";
        //echo $query;die;
        $run_query=$this->db->query($query);
        return $run_query->result_array();
    }

    public function update_last_service_km($update_type,$car_id){
        
        if($update_type == 'service_kilometer'){

            $sql = "UPDATE master_car SET last_service_kilometer=total_odometer_reading,last_service_kilometer_ts='".date('Y-m-d H"i"s')."',updated_by=".$this->admin_session_data['user_id'].",updated_ts='".date('Y-m-d H"i"s')."' WHERE car_id = ".$car_id."";

        } else if($update_type == 'transmission_service'){
            $sql = "UPDATE master_car SET last_transmission_service=total_odometer_reading,last_transmission_service_ts='".date('Y-m-d H"i"s')."',updated_by=".$this->admin_session_data['user_id'].",updated_ts='".date('Y-m-d H"i"s')."' WHERE car_id = ".$car_id."";
        } else if($update_type == 'spark_plug_for_eg'){
            $sql = "UPDATE master_car SET last_spark_plug_for_eg=total_odometer_reading,last_spark_plug_for_eg_ts='".date('Y-m-d H"i"s')."',updated_by=".$this->admin_session_data['user_id'].",updated_ts='".date('Y-m-d H"i"s')."' WHERE car_id = ".$car_id."";
        }
        $run_sql = $this->db->query($sql);
        if($run_sql){
            return true;
        }
        return false;
    }

    public function get_odometer_details($odometer_id){
        $this->db->select('a.*,md.first_name,md.middle_name,md.last_name,mc.car_no');
        $this->db->from('odometers a');
        $this->db->join('master_driver md','md.driver_id=a.driver_id','inner');
        $this->db->join('master_car mc','mc.car_id=a.car_id','inner');
        $this->db->where('a.odometer_id',$odometer_id);
        $this->db->order_by('a.odometer_id', 'DESC');
        $query=$this->db->get();
        return $query->row_array();
    }

    public function get_odometer_payment_details($odometer_id){
        $this->db->select('ap.*');
        $this->db->from('odometer_payments ap');
        $this->db->where('ap.odometer_id',$odometer_id);
        $this->db->order_by('ap.odometer_payment_id', 'DESC');
        $query=$this->db->get();
        return $query->result_array();
    }

    

    public function get_car(){
        $this->db->select('mc.*,
        (ifnull(service_kilometer,0) - (ifnull(total_odometer_reading,0) - ifnull(last_service_kilometer,0))) as service_due_kilometer');
        $this->db->from('master_car mc');
        $this->db->where('mc.status','0');
        $query=$this->db->get();
        return $query->result_array();
    }


    

    public function edit_odometer($odometer_id){
        $this->db->select('*');
        $this->db->from('master_admin');
		$this->db->where('odometer_id',$odometer_id);
        $query=$this->db->get();
        return $query->row_array();
    }
	
    public function get_role(){
        $this->db->select('*');
        $this->db->from('master_role');
        $this->db->where('status','0');
        $this->db->where('role_id <>','2');
        $this->db->order_by('role_id','DESC');
        $query=$this->db->get();
        return $query->result_array();
		}

    public function get_state(){
        $this->db->select('*');
        $this->db->from('state');
        $this->db->order_by('state_id','ASC');
        $query=$this->db->get();
        return $query->result_array();
    }
    
    public function submit_odometer($data){
        $this->db->insert('master_admin', $data);
        return $this->db->insert_id();
    }

    public function update_odometer($condition,$data){
        $result=$this->db->update('master_admin', $data, $condition);
        return $result;
    }

    public function get_role_permission($role_id = '')
    {
        $role_permission = $this->db->where('role_id', $role_id)
                                    ->get('odometer_permission')->result();
        return $role_permission;
    }

    public function add_edit_permission($data_array = array(), $insert_count_on)
    {
        $role_permission = '';
        if(!empty($data_array['role_id'])){
            $role_permission = $this->db->where('role_id', $data_array['role_id'])
                                        ->where('menu_id', $data_array['menu_id'])
                                        ->get('odometer_permission')->row();
        }
        
        $data_array['created_by'] = $this->admin_session_data['odometer_id'];
        $data_array['created_ts'] = date('Y-m-d h:i:s');

        if(!empty($role_permission)){
            $data_array['created_by'] = $role_permission->created_by;
            $data_array['created_ts'] = $role_permission->created_ts;
            $data_array['updated_by'] = $this->admin_session_data['odometer_id'];
            $data_array['updated_ts'] = date('Y-m-d h:i:s');
            $this->db->where('permission_id', $role_permission->permission_id)->delete('odometer_permission');
        }
        if($insert_count_on){
            $this->db->insert('odometer_permission', $data_array);
            return $this->db->insert_id();
        }else{
            return true;
        }
    }

}