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

class Car extends MY_Controller {
	public function __construct() {
		parent::__construct();
		//$this->redirect_guest();
		$this->admin=$this->session->userdata('admin');		
		$this->load->model('admin/mcar');

		
		if($this->session->userdata('admin') != 1)
		{
			redirect('admin');
			die();
		}

	}


	/*
	author: soumya hazra
	purpose: car Listing
	date: 6-9-2019
	*/
	public function index() { 
		$result = array();
		$result['cars'] = $this->mcar->get_car();
		$result['get_car_inactive'] = $this->mcar->get_car_inactive();
		//pr($result['cars']);
		$result['content']='admin/car/carlist';
		$this->_load_view($result);
				
	}


	// Default load function for header and footer inculded
	private function _load_view($data) {
		$this->load->view('admin/layouts/index',$data);
	}	


		/*
	author: soumya hazra
	purpose: add car view
	date: 7-9-2019
	*/
	public function addcar()
	{	
		$result = array();
		$result['master_company'] = $this->mcar->master_company();		
		$result['master_car_model'] = $this->mcar->get_all_data('master_car_model');		
		$result['master_fuel'] = $this->mcar->get_all_data('master_fuel');		
		$result['master_network'] = $this->mcar->get_all_data('master_network');		
		$result['content']='admin/car/carmaster';
		$this->_load_view($result);
	}

		/*
	author: soumya hazra
	purpose: Edit car View
	date: 8-9-2019
	*/
	public function editcar($cid)
	{	
		$result = array();
		$result['master_company'] = $this->mcar->master_company();		
		$result['master_car_model'] = $this->mcar->get_all_data('master_car_model');		
		$result['master_fuel'] = $this->mcar->get_all_data('master_fuel');	
		$result['master_network'] = $this->mcar->get_all_data('master_network');			
		$result['get_single_car_details'] = $this->mcar->get_single_car_details($cid);		
		$result['content']='admin/car/carmaster';
		$this->_load_view($result);
	}	




	/*
	author: soumya hazra
	purpose: add car Submit
	date: 6-9-2019
	*/
	public function submitcar()
	{
		$data =  array();
		$result =  array();

		$chk_car_no = $this->mcommon->getRow('master_car',array('LOWER(registration_no)' => strtolower($this->input->post('registration_no'))));
		//echo $this->db->last_query(); die;
		if (empty($chk_car_no)) {
			$data = array(
				'company_id' => $this->input->post( 'company_id' ),			
				'network_id' => $this->input->post( 'network_id' ),			
				'car_model_id' => $this->input->post('car_model_id'),			
				'fuel_id' => $this->input->post( 'fuel_id' ),			
				'registration_no' => $this->input->post( 'registration_no' ),			
				'make' => $this->input->post( 'make' ),			
				'body' => $this->input->post( 'body' ),			
				'vin' => $this->input->post( 'vin' ),			
				'engine_no' => $this->input->post( 'engine_no' ),			
				'colour' => $this->input->post( 'colour' ),			
				'service_notification_km' => $this->input->post( 'service_notification_km' ),			
				'vin' => $this->input->post( 'vin' ),			
				//'full_shift_amount' => $this->input->post( 'full_shift_amount' ),			
				//'half_shift_amount' => $this->input->post( 'half_shift_amount' ),			
				'levy_applicable' => $this->input->post( 'levy_applicable' ),			
				'lifting_fees_applicable' => $this->input->post( 'lifting_fees_applicable' ),			
				'silver_service' => $this->input->post( 'silver_service' ),			
				'status' => $this->input->post( 'status' ),			
				'remarks' => $this->input->post( 'remarks' ),		
				'created_by'=>$this->session->userdata('user_data'),				
				'created_ts' => date('Y-m-d H:i:s'),				
			);

			if(!empty($this->input->post( 'compliance_date' ))){
				$data['compliance_date'] = date("Y-m-d", strtotime(str_replace('/', '-', $this->input->post( 'compliance_date' ))));
			}
			// if(!empty($this->input->post( 'registration_exp_date' ))){
			// 	$data['registration_exp_date'] = date("Y-m-d", strtotime(str_replace('/', '-', $this->input->post( 'registration_exp_date' ))));
			// }
			// if(!empty($this->input->post( 'rwc_due_month' ))){
			// 	$data['rwc_due_month'] = date("Y-m-d", strtotime(str_replace('/', '-', $this->input->post( 'rwc_due_month' ))));
			// }		
				
				
				$result = $this->mcar->submitcar($data);

				if($result)
				{   $this->session->set_flashdata('success_msg','Car added successfully');
					redirect('admin/car');
				}    
		} else{
			$this->session->set_flashdata('error_msg','Registration No Already Exist');
			$this->addcar();

		}	

	}	


	/*
	author: soumya hazra
	purpose: update car Submit
	date: 8-9-2019
	*/
	public function updatecar()
	{
		$data =  array();
		$cid = '';
		$result =  array();
		$cid  = $this->input->post( 'car_id' );	
		$chk_car_no = $this->mcommon->getRow('master_car',array('LOWER(registration_no)' => strtolower($this->input->post('registration_no')),'car_id !='=>$cid));
		//echo $this->db->last_query(); die;
		if (empty($chk_car_no)) {
			$data = array(
				'company_id' => $this->input->post( 'company_id' ),			
				'network_id' => $this->input->post( 'network_id' ),			
				'car_model_id' => $this->input->post('car_model_id'),			
				'fuel_id' => $this->input->post( 'fuel_id' ),			
				'registration_no' => $this->input->post('registration_no'),			
				'make' => $this->input->post('make'),			
				'body' => $this->input->post('body'),			
				'vin' => $this->input->post('vin'),			
				'engine_no' => $this->input->post('engine_no'),			
				'colour' => $this->input->post( 'colour' ),			
				'service_notification_km' => $this->input->post( 'service_notification_km' ),			
				'vin' => $this->input->post( 'vin' ),			
				// 'full_shift_amount' => $this->input->post( 'full_shift_amount' ),			
				// 'half_shift_amount' => $this->input->post( 'half_shift_amount' ),			
				'levy_applicable' => $this->input->post( 'levy_applicable' ),			
				'lifting_fees_applicable' => $this->input->post( 'lifting_fees_applicable' ),			
				'silver_service' => $this->input->post( 'silver_service' ),			
				'status' => $this->input->post( 'status' ),			
				'remarks' => $this->input->post( 'remarks' ),
				'updated_by'=>$this->session->userdata('user_data'),
				'updated_ts' => date('Y-m-d H:i:s'),								
				
				);

				if(!empty($this->input->post( 'compliance_date' ))){
					$data['compliance_date'] = date("Y-m-d", strtotime(str_replace('/', '-', $this->input->post( 'compliance_date' ))));
				}
				// if(!empty($this->input->post( 'registration_exp_date' ))){
				// 	$data['registration_exp_date'] = date("Y-m-d", strtotime(str_replace('/', '-', $this->input->post( 'registration_exp_date' ))));
				// }
				// if(!empty($this->input->post( 'rwc_due_month' ))){
				// 	$data['rwc_due_month'] = date("Y-m-d", strtotime(str_replace('/', '-', $this->input->post( 'rwc_due_month' ))));
				// }
				
				

				$result = $this->mcar->updatecar($cid,$data);

				if($result)
				{
					$this->session->set_flashdata('success_msg','Car updated successfully');
					redirect('admin/car');
				}    
			} else{
				$this->session->set_flashdata('error_msg','Registration No Already Exist');
				$this->editcar($cid);
	
			}		
	}	
	/*
	author: soma 
	purpose: Set a car deactive
	date: 18-9-2019
	*/
	public function set_deactive_car($car_id)
	{
		$result = array();
		$result = $this->mcar->set_deactive_car($car_id);
		if($result)
		{
			$this->session->set_flashdata('success_msg','Deactivated successfully');
			redirect('admin/car');
		}else{
			$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
		}
	}

	/*
	author: soma
	purpose: Set a car Active
	date: 18-9-2019
	*/
	public function set_active_car($car_id)
	{
		$result = array();
		$result = $this->mcar->set_active_car($car_id);
		if($result)
		{
			$this->session->set_flashdata('success_msg','Activated successfully...');
			redirect('admin/car');
		}else{
			$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
		}
	}
	/*
	author: soma
	purpose: delete a car 
	date: 18-9-2019
	*/
	public function delete_car($car_id)
	{
		$result = array();
		$result = $this->mcar->delete_car($car_id);
		if($result)
		{
			redirect('admin/car');
		}
	}

	/*
	author: soma
	purpose: restore car 
	date: 18-9-2019
	*/
	public function restore_car($car_id)
	{
		$result = array();
		$result = $this->mcar->restore_car($car_id);
		if($result)
		{
			redirect('admin/car');
		}
	}


}