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

class Jobreport extends MY_Controller {
	public function __construct() {
		parent::__construct();
		$this->redirect_guest();
		$this->admin=$this->session->userdata('admin');		
		$this->load->model('admin/mtyreservicereport');
		$this->load->model('admin/mbookingreport');
	}
	
	public function index() {	
		$this->_load_list_view();		
	}
	
	private function _load_list_view() {

        $assignjobList = $this->mbookingreport->assignedJob(array());
    
        $jobList = array();
        
        if(!empty($assignjobList))
        {
            foreach($assignjobList as $key=>$assignjob)
            {
                
                $job_condition = array("job_id"=>$assignjob['job_id']);
                $job = $this->mcommon->getRow('job',$job_condition);
                
                //if(!empty($job)){
                
                
                    $services = $this->mbookingreport->getServices($assignjob['job_id']);	
    
                    $service_date_condition = array("job_id"=>$assignjob['job_id']);
                    $job_service_date = $this->mcommon->getRow("job_service_date",$service_date_condition);
                            
                    
                    $car_condition = array("car_id"=>$assignjob['car_id']);
                    $car = $this->mcommon->getRow('car',$car_condition);
                    
                    $assigned_by_condition = array("admin_id"=>$assignjob['created_by']);
                    $assigned_by = $this->mcommon->getRow('admins',$assigned_by_condition);
                    
                    $mechanic_condition = array("admin_id"=>$assignjob['mechanic_id']);
                    $mechanic = $this->mcommon->getRow('admins',$mechanic_condition);
                    //$service = explode(',',$job['service']);
                    
                        
                       
                            $jobList[$key]['job_id'] = $assignjob['job_id'];
                            $jobList[$key]['service_date'] = $job_service_date['service_date'];
                            $jobList[$key]['formatted_service_date'] = date("d/m/Y", strtotime($job_service_date['service_date']));
                            $jobList[$key]['company_name'] = $car['company_name'];
                            $jobList[$key]['car_no'] = $car['car_no'];
                            $jobList[$key]['assigned_by'] = $assigned_by['name'];
                            $jobList[$key]['mechanic_name'] = $mechanic['name'];
                            $jobList[$key]['job_type'] = ($assignjob['created_by'] == $assignjob['mechanic_id'])?2:1; //1=>Admin Job,2=>Mechanic Job
                            
                            if($assignjob['job_status'] == 0){
                                $job_status = "Not Started";
                            }else if($assignjob['job_status'] == 1){
                                $job_status = "In Progress";
                            }else if($assignjob['job_status'] == 2){
                                $job_status = "Completed";
                
                                if(!empty($job_service_date['service_end_date']))
                                {
                                    $job_status=$job_status.' On '.date("d/m/Y", strtotime($job_service_date['service_end_date']));
                                }
                            }

                            if($assignjob['assign_status'] == 0){
                                $assign_status = "Rejected";
                            }else if($assignjob['assign_status'] == 1){
                                $assign_status = "Accepted";
                            } else{
                                $assign_status ='Pending';
                            }
                            $jobList[$key]['job_status'] =  $job_status;
                            $jobList[$key]['assign_status'] = $assign_status;
                            
                            $jobList[$key]['service_count'] = sizeof($services);
                            $jobList[$key]['paid_or_unpaid'] = $assignjob['paid_or_unpaid'];
                            
    
                        
                        
                    }
    
        }
        //echo '<pre>';print_r($jobList);die;
        $data['calendar_data'] = $jobList;
        $data['content'] = 'admin/jobreport/list';
        $this->load->view('admin/layouts/index', $data);
	}
 
	
	
}