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

class Mcar extends CI_Model {


	/*
	Author: soumya Hazra
	purpose: insert new car details
	date:7-9-2019
	*/
	public function submitcar($data)
	{

		$this->db->insert('master_car', $data);
		return true;
	}


	/*
	Author: soumya Hazra
	purpose: get all company
	date:7-9-2019
	*/
	public function master_company()
	{
		$result = array();

		$this->db->select('company_id,company_name');
		$this->db->from('master_company');		
		$this->db->where('company_status',1);		
		$this->db->order_by('company_id','DESC');		
		$query = $this->db->get();
		$result = $query->result_array();

		return $result;
	}

	/*
	Author: soumya Hazra
	purpose: get all Data from dynamic table
	date:7-9-2019
	*/
	public function get_all_data($tbl)
	{
		$result = array();

		$this->db->select('*');
		$this->db->from($tbl);
		$this->db->where('is_active',1);										
		$query = $this->db->get();
		$result = $query->result_array();

		return $result;
	}


	/*
	Author: soumya Hazra
	purpose: get Active Car list
	date:07-9-2019
	*/
	public function get_car($car_no=null)
	{
		$result = array();

		$this->db->select('master_car.*,master_company.company_name,master_car_model.model_name,master_fuel.fuel_name,master_network.network_name');
		$this->db->from('master_car');		
		$this->db->join('master_company','master_company.company_id = master_car.company_id','left');		
		$this->db->join('master_fuel','master_fuel.fuel_id = master_car.fuel_id','left');		
		$this->db->join('master_car_model','master_car_model.car_model_id = master_car.car_model_id','left');
		$this->db->join('master_network','master_network.network_id = master_car.network_id','left');	
		$this->db->where('master_car.status',1);
		if($car_no){
			$this->db->where('master_car.car_id',$car_no);
		}		
		$this->db->order_by('master_car.registration_no','ASC');		
		$query = $this->db->get();
		$result = $query->result_array();

		return $result;
	}
	/*
	Author: soumya Hazra
	purpose: get In-active Car list
	date:07-9-2019
	*/
	public function get_car_inactive()
	{
		$result = array();

		$this->db->select('master_car.*,master_company.company_name,master_car_model.model_name,master_fuel.fuel_name,master_network.network_name');
		$this->db->from('master_car');		
		$this->db->join('master_company','master_company.company_id = master_car.company_id');		
		$this->db->join('master_fuel','master_fuel.fuel_id = master_car.fuel_id');		
		$this->db->join('master_car_model','master_car_model.car_model_id = master_car.car_model_id');
		$this->db->join('master_network','master_network.network_id = master_car.network_id');		
		$this->db->where('master_car.status',0);		
		$this->db->order_by('master_car.registration_no','ASC');	
		$query = $this->db->get();
		$result = $query->result_array();

		return $result;
	}	

	/*
	Author: soumya Hazra
	purpose: get single company
	date:8-9-2019
	*/
	public function updatecar($cid,$data)
	{

		$this->db->where('car_id',$cid);					
		$this->db->update('master_car',$data);		

		return true;
	}	

	/*
	Author: soumya Hazra
	purpose: get single car details
	date:07-9-2019
	*/
	public function get_single_car_details($cid)
	{
		$result = array();

		$this->db->select('master_car.*,master_company.company_name,master_car_model.model_name,master_fuel.fuel_name,master_network.network_name');
		$this->db->from('master_car');		
		$this->db->join('master_company','master_company.company_id = master_car.company_id');		
		$this->db->join('master_fuel','master_fuel.fuel_id = master_car.fuel_id');		
		$this->db->join('master_car_model','master_car_model.car_model_id = master_car.car_model_id');		
		$this->db->join('master_network','master_network.network_id = master_car.network_id');		
		$this->db->where('master_car.car_id',$cid);	
		$query = $this->db->get();
		$result = $query->row_array();

		return $result;
	}

	 /*
    author: soma
    purpose: Set a car deactive
    date: 18-9-2019
    */
    public function set_deactive_car($car_id)
    {

        $this->db->set('status',0);
        $this->db->set('updated_by',$this->session->userdata('user_data'));
        $this->db->set('updated_ts',date('Y-m-d h:i:s'));                  
        $this->db->where('car_id',$car_id);                    
        $this->db->update('master_car'); 
       // echo $this->db->last_query();die;
        return true;     

    }
    /*
    author: soma
    purpose: Set a car active
    date: 128-9-2019
    */
    public function set_active_car($car_id)
    {

        $this->db->set('status',1);
        $this->db->set('updated_by',$this->session->userdata('user_data'));
        $this->db->set('updated_ts',date('Y-m-d h:i:s'));                   
        $this->db->where('car_id',$car_id);                    
        $this->db->update('master_car'); 
        return true;     

    }

  
    /*
    author: soma
    purpose: delete car 
    date: 18-9-2019
    */
    public function delete_car($car_id)
    {

        $this->db->set('is_delete',1);
        $this->db->set('status',0);                    
        $this->db->where('car_id',$car_id);                    
        $this->db->update('master_car'); 
        return true;     

    }
    /*
    author: soma
    purpose: restore car 
    date: 18-9-2019
    */
    public function restore_car($car_id)
    {

        $this->db->set('is_delete',0);
        $this->db->set('status',1);                       
        $this->db->where('car_id',$car_id);                    
        $this->db->update('master_car'); 
        return true;     

    }

}