HEX
Server: Apache/2.4.41 (Amazon) OpenSSL/1.0.2k-fips PHP/5.6.40
System: Linux ip-172-31-40-18 4.14.146-93.123.amzn1.x86_64 #1 SMP Tue Sep 24 00:45:23 UTC 2019 x86_64
User: apache (48)
PHP: 5.6.40
Disabled: NONE
Upload Files
File: //var/www/html/pmw24/pmw_live_testing/app/application/controllers/admin/Bookingreport.php
<?php 
defined('BASEPATH') OR exit('No direct script access allowed');

class Bookingreport 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() {
    $data['content'] = 'admin/bookingreport/list';
    $this->load->view('admin/layouts/index', $data);
	}
 public function ajax_view() {

       $first_date = $this->input->get('start'); 
       $last_date = $this->input->get('end'); 
       $job_bookings = $this->mbookingreport->get_details($first_date,$last_date);

       // print_r($job_bookings); die;
   
        foreach ($job_bookings as $key => $value) {
          $mec_name = $this->mbookingreport->get_mechanic_details($value['mechanic_id']);
            $data[$key]['title'] = '';
            $data[$key]['date'] = $value['service_date'];
           // $data[$key]['backgroundColor'] = "#FF0000";
        }
          // print_r($data); die;
       echo json_encode($data); 

	}
   public function date_wise_details() {

       $service_date = $this->input->post('service_date'); 
       $job_bookings = $this->mbookingreport->get_service_details($service_date);

        foreach ($job_bookings as $key => $value) {
            $mec_name = $this->mbookingreport->get_mechanic_details($value['mechanic_id']);
            $data[$key]['car'] = $value['car_no'];
            $data[$key]['mechanic'] = $mec_name['name'];
            $data[$key]['mechanic_phone'] = $mec_name['phoneno'];
        }
          // print_r($data); die;
       echo json_encode($data); 

  }
	
	
}