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);
}
}