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

class BondReport extends MY_Controller
{
    public function __construct()
    {
        parent::__construct();
        //$this->redirect_guest();
        $this->admin = $this->session->userdata('admin');
        $this->load->model('admin/mreport');
        $this->load->model('admin/Mdriver');
        if ($this->session->userdata('admin') != 1) {
            redirect('admin');
        }
    }
    public function   index() { 
        //$this->session->unset_userdata('driver_settlement');
        //echo $this->session->userdata('email');die;
        $this->_load_bond_report_list();        
    }   
    private function _load_bond_report_list() {
        $data                       =  array();        
        $driver_list                = $this->Mdriver->get_driver_list('1');   
        if(!empty($driver_list)){
            $data['driver_list']    = $driver_list;
        }
        else{
            $data['driver_list']    = '';
        }
        $data['content']            = 'admin/report/bond/bond_report_list';
        $this->load->view('admin/layouts/index', $data);
    }
    public function BondReportGenerate() {
        $data           = array();
        $responce_arr   = array();
        $driver_id      = $this->input->post("driver_id");
        //echo $this->input->post("driver_id");exit;
        $from_date='';
        $to_date='';
        if($this->input->post("from_date") && $this->input->post("to_date")){
            $from_date    = date('Y-m-d',strtotime(str_replace('/','-',$this->input->post("from_date"))));
            $to_date      = date('Y-m-d',strtotime(str_replace('/','-',$this->input->post("to_date"))));
        }
        
        $data                   = array();
        $order                  = '';
        $order_type             = '';
        $data['content']        = 'admin/driver_settlement/driver_settlement_list';
        $joindata   = array('select'        =>'DS.*,master_car.registration_no as car_no,master_user.dc_no,user_profile.first_name,user_profile.middle_name,user_profile.last_name,master_bond.*',
                            'first_table'   =>'driver_settlement DS',
                            'second_table'  =>'master_user',
                            'dependency1'   =>'DS.driver_id = master_user.user_id',
                            'join_type1'    =>'left',                  
                        /********************************/ 
                            'third_table'   =>'user_profile',
                            'dependency2'   =>'user_profile.user_id = master_user.user_id',
                            'join_type2'    =>'left',
                        /*********************************/
                            'forth_table'   =>'roster_driver_maping RDM',
                            'dependency3'   =>'RDM.roster_shift_id = DS.shift_id',
                            'join_type3'    =>'left',
                        /*********************************/ 
                            'fifth_table'   =>'roster',
                            'dependency4'   =>'RDM.roster_id = roster.roster_id',
                            'join_type4'    =>'left',

                        /*********************************/   
                            'sixth_table'   =>'master_car',
                            'dependency5'   =>'master_car.car_id = roster.car_id',
                            'join_type5'    =>'left',
                        /*********************************/   
                            'seventh_table' =>'master_bond',
                            'dependency6'   =>'master_bond.driver_id = DS.driver_id',
                            'join_type6'    =>'left'
                        );
    
                $cond ='1=1';
                if($driver_id){
                    $cond .= " and DS.driver_id ='".$driver_id."'";
                }
                if($from_date && $to_date){
                    $cond .=" and DS.created_on between '".$from_date."' and '".$to_date."'";
                }
        $bond_report_data     = $this->mcommon->joinQuery($joindata,$cond,'result',$order,$order_type);
        //pr($bond_report_data);
        if(!empty($bond_report_data)){
            $total_amt   = 0;
            foreach($bond_report_data as $val){
                $total_amt  = $total_amt+$val['bond_installment'];
            }
            $data['total_amt']            = number_format($total_amt,2);
            $data['bond_report_data']     = $bond_report_data;
        }
        else{
            $data['total_amt']            = '0.00';
            $data['bond_report_data']     = '';
        }
        $responce_arr['html'] = $this->load->view('admin/report/bond/ajax_bond_report',$data,true);
        echo json_encode($responce_arr);exit;
    }
}