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

class DocketReport 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 GetDocketsList(){
        $return_new_array   = array();  
        $docket_list        = array();  
        $docket_data        = array();
        $company_id         = $this->input->post('company_id');
        
        $dockets_datas      = $this->mdriver->get_docket_list_bu_companyID($company_id);
       //pr($dockets_datas);
        if (!empty($dockets_datas)) {
            foreach($dockets_datas as $val){
                
                $docket_data['docket_name'] = $val['docket_name'];
                $docket_data['docket_id']   = $val['docket_id'];
                $docket_list[]              = $docket_data;
            }

            $return_new_array               = $docket_list;
            //pr($return_new_array);
        } else {
            $return_new_array               = 'Blank';
        }
        //pr($return_new_array);
        echo json_encode($return_new_array);
    }
    public function GetDriverList()
    {
        $return_new_array   = array();  
        $driver_list   		= array();     
        $company_id         = $this->input->post('company_id');
        
        $driver_datas    	= $this->mdriver->get_driver_list_bu_companyID($company_id);
        //pr($car_list);
        if (!empty($driver_datas)) {
        	foreach($driver_datas as $val){
        		if($val['middle_name']!=''){
                  $middle_name  = $val['middle_name'].' ';
                }
                else{
                  $middle_name  ='';
                }
        		$driver_data['driver_name'] = $val['first_name'].' '.$middle_name.$val['last_name'];
        		$driver_data['dc'] 			= $val['dc_no'];
        		$driver_data['driver_id'] 	= $val['user_id'];
        		$driver_list[]				= $driver_data;
        	}

            $return_new_array				= $driver_list;
            //pr($return_new_array);
        } else {
            $return_new_array 				= 'Blank';
        }
        //pr($return_new_array);
        echo json_encode($return_new_array);
    }
    public function   index() { 
        //$this->session->unset_userdata('driver_settlement');
        //echo $this->session->userdata('email');die;
        $this->_load_docket_report_list();        
    }   
    private function _load_docket_report_list() {
        $data                       = array();
        $company_list				= $this->mcommon->getFullDetails('master_company');
        if(!empty($company_list)){
        	$data['company_list']	= $company_list;
        }
        else{
        	$data['company_list']	= '';	
        }
        $order      = '';
        $order_type = '';
        $joindata   = array('select'        =>'DSD.*,master_docket.docket_name,master_car.registration_no,driver_settlement.created_on,master_user.dc_no,user_profile.first_name,user_profile.middle_name,user_profile.last_name',
                            'first_table'   =>'dr_settlement_docket DSD',
                            'second_table'  =>'payin_dockets',
                            'dependency1'   =>'DSD.payin_docket_id =  payin_dockets.payin_dockets_id',
                            'join_type1'    =>'left',                  
                        /********************************/ 
                            'third_table'   =>'master_docket',
                            'dependency2'   =>'payin_dockets.docket_id = master_docket.docket_id',
                            'join_type2'    =>'left',
                        /********************************/ 
                            'forth_table'   =>'driver_settlement',
                            'dependency3'   =>'driver_settlement.dr_settlement_id = DSD.dr_settlement_id',
                            'join_type3'    =>'left',
                        /********************************/ 
                        	'fifth_table'  	=>'master_user',
                            'dependency4'   =>'driver_settlement.driver_id = master_user.user_id',
                            'join_type4'    =>'left',                  
                        /********************************/ 
                            'sixth_table'   =>'user_profile',
                            'dependency5'   =>'user_profile.user_id = master_user.user_id',
                            'join_type5'    =>'left',
                        /********************************/
                            'seventh_table' =>'roster_driver_maping RDM',
                            'dependency6'   =>'RDM.roster_shift_id = driver_settlement.shift_id',
                            'join_type6'    =>'left',
                        /*********************************/ 
                            'eighth_table'  =>'roster',
                            'dependency7'   =>'RDM.roster_id = roster.roster_id',
                            'join_type7'    =>'leftleft',

                        /*********************************/   
                            'ninth_table'   =>'master_car',
                            'dependency8'   =>'master_car.car_id = roster.car_id',
                            'join_type8'    =>'left'    
                        );
        
        $cond 		= "driver_settlement.created_on between '".date('Y-m-d',strtotime('-2 week'))."' and '".date('Y-m-d')."'";
        $docket_report_data     = $this->mcommon->joinQuery($joindata,$cond,'result',$order,$order_type);
        //pr($docket_report_data);
        if($docket_report_data){
        	$data['docket_report_data'] = $docket_report_data;
        }
        else{
        	$data['docket_report_data'] = '';
        }
        $driver_list        = $this->mdriver->get_driver_list();
        if(!empty($driver_list)){
            $data['driver_list'] = $driver_list;
        }
        else{
            $data['driver_list'] = '';
        }
        //pr($driver_list);
        $data['content']    = 'admin/report/docket/docket_report_list';
        $this->load->view('admin/layouts/index', $data);
    }
    public function DocketReportGenerate() {
        $data         = array();
        $responce_arr = array();
        $company_id   = $this->input->post("company_id");
        $driver_id    = $this->input->post("driver_id");        
        $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"))));

        //echo $from_date  = date('Y-m-d',strtotime($this->input->post("from_date")))."<br>";
        //echo $driver_id."<br>".$company_id."<br>".$from_date."<br>".$to_date;exit;
        $data                   = array();
        $order                  = '';
        $order_type             = '';
        $joindata   = array('select'        =>'DSD.*,master_docket.docket_name,driver_settlement.shift_id,driver_settlement.created_on,master_user.dc_no,user_profile.first_name,user_profile.middle_name,user_profile.last_name',
                            'first_table'   =>'dr_settlement_docket DSD',
                            'second_table'  =>'payin_dockets',
                            'dependency1'   =>'DSD.payin_docket_id =  payin_dockets.payin_dockets_id',
                            'join_type1'    =>'left',                  
                        /********************************/ 
                            'third_table'   =>'master_docket',
                            'dependency2'   =>'payin_dockets.docket_id = master_docket.docket_id',
                            'join_type2'    =>'left',
                        /********************************/ 
                            'forth_table'   =>'driver_settlement',
                            'dependency3'   =>'driver_settlement.dr_settlement_id = DSD.dr_settlement_id',
                            'join_type3'    =>'left',
                        /********************************/ 
                        	'fifth_table'  	=>'master_user',
                            'dependency4'   =>'driver_settlement.driver_id = master_user.user_id',
                            'join_type4'    =>'left',                  
                        /********************************/ 
                            'sixth_table'   =>'user_profile',
                            'dependency5'   =>'user_profile.user_id = master_user.user_id',
                            'join_type5'    =>'left',    
                        );
        
        $cond                 = "driver_settlement.driver_id ='".$driver_id."' and driver_settlement.created_on between '".$from_date."' and '".$to_date."'";
        $docket_report_data     = $this->mcommon->joinQuery($joindata,$cond,'result',$order,$order_type);
        //pr($accd_report_data);
        if(!empty($docket_report_data)){            
            
            $data['docket_report_data']     = $docket_report_data;
        }
        else{
            $data['docket_report_data']     = '';
        }
        $responce_arr['html'] = $this->load->view('admin/report/docket/ajax_docket_report',$data,true);
        echo json_encode($responce_arr);exit;
    }
    
}