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

class Mreport extends CI_Model {

    public function __construct() {
		
        parent::__construct();
		
    }
	
	function get_unit_summary_report() {
		$stored_procedure = "CALL get_unit_summary_report();";
		$data = array();
		
        $result = $this->db->query($stored_procedure, $data);
		
        if ($result !== NULL) {
			$response = $result->result_array();
			$result->free_result();
			mysqli_next_result( $this->db->conn_id);
			
            return $response;
        }
        return FALSE;
	}

    function get_payments_failed($search_array) {
		$sql = "SELECT mc.car_no,rov.rent_out_no,ddp.*, md.first_name,md.middle_name,md.last_name,mc.car_no
        FROM direct_debit_payments ddp
        LEFT JOIN master_driver md ON  md.driver_id = ddp.driver_id
        LEFT JOIN rent_out_vehcile rov ON  rov.rent_out_id = ddp.direct_debit_id
        LEFT JOIN master_car mc ON  mc.car_id = rov.car_id  
        LEFT JOIN master_company mcm ON  mcm.company_id = mc.company_id  
        WHERE payment_status = 'Failed'";
        
        if(!empty($search_array['from_date']) && !empty($search_array['to_date'])){
            $sql .=" AND DATE(ddp.failed_ts) BETWEEN '".$search_array['from_date']."' AND '".$search_array['to_date']."'";
        }
        
        if(!empty($search_array['company_id'])){
            $sql .=" AND mcm.company_id = '".$search_array['company_id']."'";
        }
        $sql .=" ORDER BY ddp.failed_ts DESC";
		//echo $sql;die; 
        $run_sql = $this->db->query($sql);
		
        if ($run_sql) {
			$response = $run_sql->result_array();
			return $response;
        }
        return FALSE;
	}

    function get_payments_success($search_array) {
		$sql = "SELECT mc.car_no,rov.rent_out_no,ddp.*, md.first_name,md.middle_name,md.last_name,mc.car_no
        FROM direct_debit_payments ddp
        LEFT JOIN master_driver md ON  md.driver_id = ddp.driver_id
        LEFT JOIN rent_out_vehcile rov ON  rov.rent_out_id = ddp.direct_debit_id
        LEFT JOIN master_car mc ON  mc.car_id = rov.car_id  
        LEFT JOIN master_company mcm ON  mcm.company_id = mc.company_id  
        WHERE ddp.payment_status = 'Success' ";
        if(!empty($search_array['from_date']) && !empty($search_array['to_date'])){
            $sql .=" AND DATE(ddp.paid_ts) BETWEEN '".$search_array['from_date']."' AND '".$search_array['to_date']."'";
        }
        
        if(!empty($search_array['company_id'])){
            $sql .=" AND mcm.company_id = '".$search_array['company_id']."'";
        }
        $sql .=" ORDER BY ddp.paid_ts DESC";
		//echo $sql;die; 
        $run_sql = $this->db->query($sql);
		
        if ($run_sql) {
			$response = $run_sql->result_array();
			return $response;
        }
        return FALSE;
	}

}