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/app/application/controllers/admin/Inspection_01_02_19.php
<?php 
defined('BASEPATH') OR exit('No direct script access allowed');

class Inspection extends MY_Controller {
	public function __construct() {
		parent::__construct();
		$this->redirect_guest();
		$this->admin=$this->session->userdata('admin');		
		$this->load->model('admin/minspection');
	}
	
	public function index() {					
		$this->_load_list_view();		
	}
	
	private function _load_list_view() {
		$admin = $this->admin;
		$data['admin'] = $admin;
		if($admin['role_id'] == 2){
			$condition = array();
			$data['cars'] = $this->minspection->getRows('car',$condition);
			$mechanic_condition = array("role_id"=>14);
			$data['mechanics'] = $this->minspection->getRows('admins',$mechanic_condition);
			$data['content'] = 'admin/inspection/list';		
			$this->load->view('admin/layouts/index', $data);
		}else{
			$condition = array();
			$data['cars'] = $this->minspection->getRows('car',$condition);
			$data['content'] = 'admin/inspection/list_mechanic';		
			$this->load->view('admin/layouts/index', $data);			
		}
	}
	
	public function all_content_list(){
		$car_id = $_POST['car_id']; 
		//$start_date = $_POST['start_date'];        echo  $start_date = date("Y-m-d", strtotime($_POST['start_date']));
		//$end_date = $_POST['end_date'];        echo $end_date = date("Y-m-d", strtotime($_POST['end_date'])); exit() ; 
		
		if($car_id == 0){
			$admin_id = $_POST['admin_id'];  
            $list = $this->minspection->get_datatables($car_id,$start_date,$end_date,$admin_id);
		}
		else{
			  $admin_id = $_POST['admin_id']; 
			  $list = $this->minspection->get_datatables($car_id,$start_date,$end_date,$admin_id);
		}
		$data = array();
        $no = $_POST['start'];
		$i=1;
		foreach ($list as $person) {
			$row = array();	
			$row[]=$i;		
			$row[] = $person->car_no;
			$row[] = $person->mechanic_name;
			/*$row[] = $person->question;
			if($person->option == 1){
				$option = 'yes';
			}else{
				$option = 'No';
			}
			
			$row[] = $option;*/
			$row[] = $person->date_of_creation;
			$row[] = '<a class="btn btn-lg" id="active" href="'.base_url('admin/inspection/details/'.$person->inspection_id).'" title="Question"><span class="glyphicon glyphicon-eye-open"></span></a>';	
            $data[] = $row;
			$i++;
        }
		
		$output = array(
                        "draw" => $_POST['draw'],
                        "recordsTotal" => $this->minspection->count_all($car_id,$start_date,$end_date,$admin_id),
                        "recordsFiltered" => $this->minspection->count_filtered($car_id,$start_date,$end_date,$admin_id),
                        "data" => $data,
                );
        echo json_encode($output);
		
	}
	
	public function all_content_list_mechanic(){
		$car_id = $_POST['car_id'];
		$start_date = $_POST['start_date'];
		$end_date = $_POST['end_date'];
		$admin = $this->admin;
		$admin_id = $admin['admin_id'];
		$list = $this->minspection->get_datatables($car_id,$start_date,$end_date,$admin_id);
		
		$data = array();
        $no = $_POST['start'];
		$i=1;
		foreach ($list as $person) {
			$row = array();	
			$row[]=$i;		
			$row[] = $person->car_no;			
			/*$row[] = $person->question;
			if($person->option == 1){
				$option = 'yes';
			}else{
				$option = 'No';
			}
			
			$row[] = $option;*/
			$row[] = $person->date_of_creation;
			$row[] = '<a class="btn btn-lg" id="active" href="'.base_url('admin/inspection/details/'.$person->inspection_id).'" title="Question"><span class="glyphicon glyphicon-eye-open"></span></a>';	
            $data[] = $row;
			$i++;
        }
		
		$output = array(
                        "draw" => $_POST['draw'],
                        "recordsTotal" => $this->minspection->count_all($car_id,$start_date,$end_date,$admin_id),
                        "recordsFiltered" => $this->minspection->count_filtered($car_id,$start_date,$end_date,$admin_id),
                        "data" => $data,
                );
        echo json_encode($output);
		
	}
	
	public function edit($inspection_id){
		$inspection_answers=$this->minspection->get_details($inspection_id);
		
		
		foreach($inspection_answers as $key=>$inspection_answer)
		{
			
			$condition = array("inspection_answer_id"=>$inspection_answer->inspection_answer_id);		
			$inspection_answer_images = $this->minspection->getRows("inspection_answer_image",$condition);			
			$inspection_answers[$key]->inspection_answer_images = $inspection_answer_images;
			
		}
		
		$data['cms'] = $inspection_answers;
		
		if(empty($data['cms'])){
			$this->_load_list_view();
		}else{			
			$this->_load_details_view($data);
		}
	}
	
	private function _load_details_view($parms){
		$condition = array();		
		$data['cms']=$parms['cms'];	
		//print_r($data['cms']);exit;
		$data['content'] = 'admin/inspection/detail';
		$this->load->view('admin/layouts/index', $data);
	}
}