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

class Mrentin extends CI_Model {

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

    }

    public function get_rentout_driver(){
        $this->db->select('concat(md.driver_id,"-",rov.rent_out_id) AS driver_id,md.first_name,md.middle_name,md.last_name,md.mobile,mc.car_id,mc.car_no');
        $this->db->from('master_driver md');
        $this->db->join('rent_out_vehcile rov','rov.driver_id=md.driver_id','inner');
        $this->db->join('master_car mc','mc.car_id=rov.car_id','inner');
        $this->db->where('md.status','1');
        $this->db->where('rov.is_rent_in','0');
        $query=$this->db->get();
        return $query->result_array();
    }

    public function getRentinDetails($where=''){
        $this->db->select('riv.*,md.first_name,md.middle_name,md.last_name,md.mobile,DATE_FORMAT(rov.created_ts, "%d/%m/%Y %H:%i:%s") AS rent_out_date,rov.rent_out_no,rov.odometer_reading AS rent_out_odometer_reading,mc.car_id,mc.car_no,br.total_bond_amount,br.refund_type,br.amount_want_to_refund,br.notice_date,br.bond_refund_due_date,br.remarks,bw.bond_reference_no,bw.bond_payment_method');
        $this->db->from('rent_in_vehcile riv');
        $this->db->join('rent_out_vehcile rov','rov.rent_out_id=riv.rent_out_id');
        $this->db->join('master_driver md','md.driver_id=riv.driver_id');
        $this->db->join('master_car mc','mc.car_id=rov.car_id');
        $this->db->join('bond_refund br','br.reference_id=riv.rent_in_id','left');
        $this->db->join('bond_wallet bw','bw.bond_reference_id=riv.rent_in_id AND bw.bond_reference_type = "RENTIN"','left');
        if(!empty($where)){
            $this->db->where('riv.rent_in_id',$where);
            $this->db->group_by('riv.rent_in_id');
            $query=$this->db->get();
            return $query->row_array();
        }else{ 
            $this->db->group_by('riv.rent_in_id');
            $this->db->order_by('riv.rent_in_id','desc');
            $query=$this->db->get();
            return $query->result_array(); 
        }
    }

    public function getRentoutDetails($driver_id,$rent_out_id){
        $this->db->select('rov.*,DATE_FORMAT(rov.created_ts, "%d/%m/%Y") AS rent_out_date,mc.car_id,mc.car_no');
        $this->db->from('rent_out_vehcile rov');       
        $this->db->join('master_car mc','mc.car_id=rov.car_id','inner');
        $this->db->where('rov.driver_id',$driver_id);
        $this->db->where('rov.rent_out_id',$rent_out_id);
        $query=$this->db->get();
        return $query->row_array();
        
    }

    public function get_rent_out_details($rent_out_id){
        $this->db->select('rov.*,mcp.advantage_pay_credentials');
        $this->db->from('rent_out_vehcile rov');       
        $this->db->join('master_car mc','mc.car_id=rov.car_id','inner'); 
        $this->db->join('master_company mcp','mcp.company_id=mc.company_id','inner');
        $this->db->where('rov.rent_out_id',$rent_out_id);
        $query=$this->db->get();
        return $query->row_array();
        
    }

    public function edit_car($car_id){
        $this->db->select('*');
        $this->db->from('master_car');
		$this->db->where('car_id',$car_id);
        $query=$this->db->get();
        return $query->row_array();
    }

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

    public function getdriverbondamount($driver_id){
        $sql = "SELECT sum(bond_amount) total_credit_amount FROM `bond_wallet` WHERE driver_id='".$driver_id."' AND transaction_type='CREDIT'";
        $query = $this->db->query($sql);
        $result=$query->row_array();

        $sql1 = "SELECT sum(bond_amount) total_debit_amount FROM `bond_wallet` WHERE driver_id='".$driver_id."' AND transaction_type='DEBIT'";
        $query1 = $this->db->query($sql1);
        $result1=$query1->row_array();

        return $actual_bond_amount= $result['total_credit_amount'] - $result1['total_debit_amount'];
        
    }
    
    public function submit_rentin($data){
        $this->db->insert('rent_in_vehcile', $data);
        return $this->db->insert_id();
    }

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

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

}