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

class MbondRefund extends CI_Model {

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

    }

    public function get_rentout_driver(){
        $this->db->select('md.driver_id,md.first_name,md.middle_name,md.last_name,md.mobile');
        $this->db->from('master_driver md');
        $this->db->where_in('md.status',['1','2']);
        $this->db->order_by('md.first_name','ASC');
        $query=$this->db->get();
        return $query->result_array();
    }

    public function getbondrefundDetails($where=''){
        $this->db->select('br.*,md.driver_id,md.first_name,md.middle_name,md.last_name,md.bank_name,md.bsb,md.account_no,mc.car_no');
        $this->db->from('bond_refund br');
        $this->db->join('master_driver md','md.driver_id=br.driver_id');
        $this->db->join('rent_in_vehcile riv','riv.rent_in_id=br.reference_id AND br.action_type="RENTIN"','left');
        $this->db->join('rent_out_vehcile rov','rov.rent_out_id=riv.rent_out_id','left');
        $this->db->join('master_car mc','mc.car_id=rov.car_id','left');
        if(!empty($where)){
            $this->db->where('br.bond_refund_id',$where);
            $query=$this->db->get();
            return $query->row_array();
        }else{ 
            $this->db->group_by('br.bond_refund_id');
            $this->db->order_by('br.bond_refund_id','desc');
            $query=$this->db->get();
            //echo $this->db->last_query();die;
            return $query->result_array();
        }
    }

    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 update_car($condition,$data){
        $result=$this->db->update('master_car', $data, $condition);
        return $result;
    }

    public function submit_bondrefund($data){
        $this->db->insert('bond_refund', $data);
        return $this->db->insert_id();
    }

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

}