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

class Minsurance_policies extends CI_Model {

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

    }

    public function getInsurancePolicies($from_date='',$to_date=''){
        $this->db->select('rov.insurance_company,DATE_FORMAT(rov.expire,"%d/%m/%Y") AS expire_date,rov.cover_note_img,mc.car_no,ifnull(mc.insurance_expire_pic,"") insurance_expire_pic,DATE_FORMAT(mc.insurance_expire_date,"%d/%m/%Y") AS insurance_expire_date, rov.insurance_username,rov.insurance_password');
        $this->db->from('master_car mc');
        $this->db->join('rent_out_vehcile rov','mc.car_id=rov.car_id','left');
        if(!empty($from_date) && !empty($to_date)){
            $this->db->where('mc.insurance_expire_date >= date("'.$from_date.'")');
            $this->db->where('mc.insurance_expire_date <= date("'.$to_date.'")');
        }
        $this->db->where('mc.status', '0');
        $this->db->group_by('mc.car_id');
        $this->db->order_by('mc.insurance_expire_date','ASC');
        $this->db->order_by('rov.rent_out_id','DESC');
        $query=$this->db->get();
        //echo $this->db->last_query();die;
        return $query->result_array();
    }

}