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

class Maccident extends CI_Model {

    /*
    author: soma
    purpose: Get a single accident by id to generate pdf
    date: 19-9-2019
    */
	public function singl_accident($accident_id)
	{
		//$this->db->select('master_accident.*,accident_witness.*,accident_involved_car.*,master_user.dc_no,master_car.registration_no,CONCAT(user_profile.first_name," ",user_profile.middle_name," ",user_profile.last_name) as drivername');
        $this->db->select('master_accident.*,accident_witness.*,accident_involved_car.*,master_user.dc_no,master_car.registration_no');
        $this->db->from('master_accident');
        $this->db->join('master_car','master_car.car_id = master_accident.car_id');
        $this->db->join('accident_witness','accident_witness.accident_id = master_accident.accident_id');
        $this->db->join('accident_involved_car','accident_involved_car.accident_id = master_accident.accident_id');
        //$this->db->join('user_profile','user_profile.user_id = master_accident.driver_id');
        $this->db->join('master_user','master_user.user_id = master_accident.driver_id');
        $this->db->where('master_accident.accident_id', $accident_id);
        $query = $this->db->get();
        $result = $query->row_array();
        //echo $this->db->last_query();die;                 
        return $result;

	}

	
	
	
	
	



}