File: /var/www/html/taxicamera/old/application/controllers/admin/Settings.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Settings extends MY_Controller {
public function __construct() {
parent::__construct();
$this->load->model('admin/msetting');
$this->load->model('admin/mdriver');
$this->load->library('imageupload');
if($this->session->userdata('admin') != 1)
{
redirect('admin');
}
}
// Default load function for header and footer inculded
private function _load_view($data) {
$this->load->view('admin/layouts/index',$data);
}
public function index()
{
//print_r($this->session->userdata());die;
}
/*
author: soumya hazra
purpose: Show Listing
date: 9-9-2019
*/
public function lifting()
{
$result = array();
$result['lifting'] = $this->msetting->get_lifting();
$result['content']='admin/setting/lifting';
$this->_load_view($result);
}
/*
author: soumya hazra
purpose: Show Accident charge page
date: 9-9-2019
*/
public function accident_charge()
{
$result = array();
$result['drivers'] = $this->msetting->get_drivers();
//pr($result['drivers']);
$result['accidents'] = $this->msetting->get_accidents();
$result['acc_charges'] = $this->msetting->get_acc_charges();
$result['content']='admin/setting/accidentcharge';
$this->_load_view($result);
}
public function get_accident_charge_list_against_driver(){
$driver_id = $_REQUEST['driver_id'];
$acc_charges = $this->msetting->get_acc_charges($driver_id);
$return_data =array('status'=>true,'accident_charge'=>$acc_charges);
echo json_encode($return_data);
}
/*
author: soumya hazra
purpose: Get accident releted data
date: 13-9-2019
*/
public function fetch_accident_data($accident_id)
{
$result = $this->msetting->fetch_accident_data($accident_id);
$str = date('d/m/Y h:i A',strtotime(str_replace('/','-',$result['accident_datetime'])));
$str .= '.';
$str .= $result['registration_no'];
$str .= '.';
$str .= $result['accident_id'];
echo $str;
}
/*
author: soumya hazra
purpose: Get accident releted in shift Edit
date: 13-9-2019
*/
public function fetch_accident_data_edit($accident_id)
{
$result = $this->msetting->fetch_accident_data_edit($accident_id);
$str = $result['registration_no'];
$str .= '.';
$str .= $result['accident_datetime'];
$str .= '.';
$str .= $result['total_amt'];
$str .= '.';
$str .= $result['amt_pai'];
$str .= '.';
$str .= $result['amt_due'];
$str .= '.';
$str .= $result['shift_amt'];
$str .= '.';
$str .= $result['charge_id'];
echo $str;
}
/*
author: soumya hazra
purpose: Add accident charge
date: 13-9-2019
*/
public function add_acc_charge()
{
$data = array();
$result = array();
$data = array(
'accident_id' => $this->input->post( 'accident_id' ),
'total_amt' => $this->input->post( 'total_amt' ),
'amt_pai' => $this->input->post( 'amt_pai' ),
'amt_due' => $this->input->post( 'amt_due' ),
'shift_amt' => $this->input->post( 'shift_amt' ),
'created_ts' => date('Y-m-d H:i:s'),
'created_by' => $this->session->userdata('user_data')
);
$result = $this->msetting->add_acc_charge($data);
if($result)
{
$this->session->set_flashdata('success_msg','Accident charge successfully added!');
//$this->session->set_flashdata( 'msg', '<div class="alert alert-success alert-dismissible"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>Accident charge successfully added!</div>' );
redirect('admin/settings/accident_charge');
}
}
/*
author: soumya hazra
purpose: Update accident charge
date: 13-9-2019
*/
public function update_acc_charge()
{
$data = array();
$result = array();
$accident_id = $this->input->post( 'ed_act_id' );
$settlement_amount = $this->input->post( 'settlement_amount' );
$result = $this->msetting->update_acc_charge($accident_id,$settlement_amount);
if($result)
{
$this->session->set_flashdata('success_msg','Accident charge successfully updated!');
//$this->session->set_flashdata( 'msg', '<div class="alert alert-success alert-dismissible"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>Accident charge successfully updated!</div>' );
redirect('admin/settings/accident_charge');
}
}
/*
author: soumya hazra
purpose: Show question
date: 9-9-2019
*/
public function addquestion()
{
$result = array();
$result['content']='admin/setting/addquestion';
$this->_load_view($result);
}
/*
author: soumya hazra
purpose: All question list
date: 9-9-2019
*/
public function question()
{
$result = array();
$result['questions'] = $this->msetting->get_questions();
$result['questions_inac'] = $this->msetting->get_questions_inactive();
$result['content']='admin/setting/listquestion';
$this->_load_view($result);
}
/*
author: soumya hazra
purpose: Show question
date: 9-9-2019
*/
public function submit_question()
{
$data = array();
$result = array();
$data = array(
'question' => $this->input->post( 'question' ),
'created_ts' => date('Y-m-d H:i:s'),
);
$result = $this->msetting->submit_question($data);
if($result)
{
$this->session->set_flashdata('success_msg','successfully added.!');
redirect('admin/settings/question');
}
}
/*
author: soumya hazra
purpose: Show Listing
date: 9-9-2019
*/
public function manage_levy()
{
$result = array();
$result['levy'] = $this->msetting->get_levy();
$result['content']='admin/setting/levy';
$this->_load_view($result);
}
/*
author: soumya hazra
purpose: Show Listing comission
date: 9-9-2019
*/
public function commission_list()
{
$result = array();
$result['comissions'] = $this->msetting->get_comissions();
$result['content']='admin/setting/comission_list';
$this->_load_view($result);
}
/*
author: soumya hazra
purpose: Show Listing comission
date: 9-9-2019
*/
public function comission_add()
{
$result = array();
$result['content']='admin/setting/addcomission';
$this->_load_view($result);
}
/*
author: soumya hazra
purpose: Edit comission
date: 9-9-2019
*/
public function edit_comission($cid)
{
$result = array();
$result['singl_comi']= $this->msetting->get_singl_comissions($cid);
$result['content']='admin/setting/addcomission';
$this->_load_view($result);
}
/*
author: soumya hazra
purpose: Edit Question
date: 9-9-2019
*/
public function editques($qid)
{
$result = array();
$result['singl_qus']= $this->msetting->get_singl_qus($qid);
$result['content']='admin/setting/addquestion';
$this->_load_view($result);
}
/*
author: soumya hazra
purpose: Add lifting
date: 9-9-2019
*/
public function addlifting()
{
$result = array();
$data = array();
$data = array(
'lifting_fee' => $this->input->post( 'lifting_fee' ),
'gtn_share' => $this->input->post( 'gtn_share' ),
'driver_share' => $this->input->post( 'driver_share' ),
'created_ts' => date('Y-m-d H:i:s'),
);
$result = $this->msetting->addlifting($data);
if($result)
{
redirect('admin/settings/lifting');
$this->session->set_flashdata('success_msg','Lifting Fees Updated Successfully');
}
}
/*
author: soumya hazra
purpose: Add levy
date: 9-9-2019
*/
public function add_levy()
{
$result = array();
$data = array();
$data = array(
'levy_rate' => $this->input->post( 'levy_rate' ),
'created_ts' => date('Y-m-d H:i:s'),
);
$result = $this->msetting->add_levy($data);
if($result)
{
redirect('admin/settings/manage_levy');
}
}
/*
author: soumya hazra
purpose: Add comission
date: 9-9-2019
*/
public function add_commission()
{
$result = array();
$data = array();
$data = array(
'commission_name' => $this->input->post( 'commission_name' ),
'driver_share' => $this->input->post( 'driver_share' ),
'owner_share' => $this->input->post( 'owner_share' ),
'created_by' => $this->session->userdata('user_data'),
'created_ts' => date('Y-m-d H:i:s')
);
$result = $this->msetting->add_comission($data);
if($result)
{
redirect('admin/settings/commission_list');
}
}
/*
author: soumya hazra
purpose: Add comission
date: 9-9-2019
*/
public function update_commission()
{
$result = array();
$data = array();
$data = array(
'commission_name' => $this->input->post( 'commission_name' ),
'driver_share' => $this->input->post( 'driver_share' ),
'owner_share' => $this->input->post( 'owner_share' ),
'updated_ts' => date('Y-m-d H:i:s'),
'updated_by' => $this->session->userdata('user_data')
);
$commission_id = $this->input->post( 'commission_id' );
$result = $this->msetting->update_commission($data,$commission_id);
if($result)
{
redirect('admin/settings/commission_list');
}
}
/*
author: soumya hazra
purpose: Update lifting
date: 9-9-2019
*/
public function update_lifting()
{
$result = array();
$data = array();
$data = array(
'lifting_fee' => $this->input->post( 'lifting_fee' ),
'gtn_share' => $this->input->post( 'gtn_share' ),
'driver_share' => $this->input->post( 'driver_share' ),
'updated_ts' => date('Y-m-d H:i:s'),
'updated_by' => $this->session->userdata('user_data')
);
$lifting_fee_id = $this->input->post( 'lifting_fee_id' );
$result = $this->msetting->updatelifting($data,$lifting_fee_id);
if($result)
{
redirect('admin/settings/lifting');
$this->session->set_flashdata('success_msg','Lifting Fees Updated Successfully');
}
}
/*
author: soumya hazra
purpose: Update Question
date: 9-9-2019
*/
public function update_question()
{
$result = array();
$data = array();
$data = array(
'question' => $this->input->post( 'question' ),
);
$lifting_fee_id = $this->input->post( 'lifting_fee_id' );
$question_id = $this->input->post( 'question_id' );
$result = $this->msetting->update_question($data,$question_id);
if($result)
{
$this->session->set_flashdata('success_msg','successfully updated.!');
//$this->session->set_flashdata( 'msg', '<div class="alert alert-success alert-dismissible"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>successfully updated.!</div>' );
redirect('admin/settings/question');
}
}
/*
author: soumya hazra
purpose: Update levy
date: 9-9-2019
*/
public function update_levy()
{
$result = array();
$data = array();
$data = array(
'levy_rate' => $this->input->post( 'levy_rate' ),
'updated_by'=> $this->session->userdata('user_data'),
'updated_ts'=> date('Y-m-d h:i:s')
);
$levy_id = $this->input->post( 'levy_id' );
$result = $this->msetting->update_levy($data,$levy_id);
if($result)
{
redirect('admin/settings/manage_levy');
}
}
/*
author: soumya hazra
purpose: Make A question Inactive
date: 11-9-2019
*/
public function set_inactive($qid)
{
$result = array();
$result = $this->msetting->set_inactive($qid);
$this->session->set_flashdata( 'msg', '<div class="alert alert-success alert-dismissible"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>successfully updated.!</div>' );
redirect('admin/settings/question');
}
/*
author: soumya hazra
purpose: Make A question active
date: 11-9-2019
*/
public function set_active($qid)
{
$result = array();
$result = $this->msetting->set_active($qid);
$this->session->set_flashdata( 'msg', '<div class="alert alert-success alert-dismissible"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>successfully updated.!</div>' );
redirect('admin/settings/question');
}
/*
author: soumya hazra
purpose: Inspection Page view and Filter
date: 12-9-2019
*/
public function isnspection()
{
$result = array();
$post_details = array();
$car_id = $this->input->post( 'car_id' );
$driver_id = $this->input->post( 'driver_id' );
$start_date = $this->input->post( 'start_date' );
$end_date = $this->input->post( 'end_date' );
$post_details = array(
'car_id' => $car_id,
'driver_id' => $driver_id,
'start_date' => $start_date,
'end_date' => $end_date,
);
$result['cars'] = $this->msetting->get_cars();
$result['inspections'] = $this->msetting->get_inspection($car_id,$driver_id,$start_date,$end_date);
//pr($result['inspections']);
$result['drivers'] = $this->msetting->get_drivers();
$result['post_data'] = $post_details;
$result['content']='admin/setting/inspection';
$this->_load_view($result);
}
public function InspectionDetails($inspection_id){
$result = array();
$result['title'] ='Punjabmotor: Inspection';
$result['details'] = $this->msetting->get_inspection_details($inspection_id);
//pr($result['details']);
$result['content'] ='admin/inspection/inspection_details';
$this->_load_view($result);
}
public function manageaccident()
{
$result = array();
$result['accidents'] = $this->msetting->get_accidents();
//pr($result['accidents']);
$result['content']='admin/setting/manageaccident';
$this->_load_view($result);
}
public function breakdown_alert()
{ //print_r($_SESSION);die;
$result = array();
$result['breakdown_alert'] = $this->mcommon->getRow('master_breakdown_alert',array());
//print_r($result['breakdown_alert']);die;
$result['content']='admin/setting/breakdown_alert';
$this->_load_view($result);
}
public function manage_breakdown_alert()
{
if(!empty($this->input->post())){
if(!empty($this->input->post('breakdown_alert_id'))){
$condition_breakdown_data=array();
$condition_breakdown_data['breakdown_alert_id']=$this->input->post('breakdown_alert_id');
$breakdown_data['breakdown_alert_sms_no']=$this->input->post('breakdown_alert_sms_no');
$breakdown_data['breakdown_alert_whatsapp_no']=$this->input->post('breakdown_alert_whatsapp_no');
$breakdown_data['breakdown_alert_contact_no']=$this->input->post('breakdown_alert_contact_no');
$breakdown_data['updated_by']=$this->session->userdata('user_data');
$breakdown_data['updated_ts']=date('Y-m-d h:i:s');
$this->mcommon->update('master_breakdown_alert',$condition_breakdown_data,$breakdown_data);
$this->session->set_flashdata( 'msg', '<div class="alert alert-success alert-dismissible"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>Updated Successfully</div>' );
redirect('admin/settings/breakdown_alert');
}
else{
$breakdown_data['breakdown_alert_sms_no']=$this->input->post('breakdown_alert_sms_no');
$breakdown_data['breakdown_alert_whatsapp_no']=$this->input->post('breakdown_alert_whatsapp_no');
$breakdown_data['breakdown_alert_contact_no']=$this->input->post('breakdown_alert_contact_no');
$breakdown_data['created_by']=$this->session->userdata('user_data');
$breakdown_data['created_ts']=date('Y-m-d h:i:s');
$this->mcommon->insert('master_breakdown_alert',$breakdown_data);
$this->session->set_flashdata( 'msg', '<div class="alert alert-success alert-dismissible"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>Updated Successfully</div>' );
redirect('admin/settings/breakdown_alert');
}
}
else{
$this->session->set_flashdata( 'msg', '<div class="alert alert-danger alert-dismissible"><a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>Please provide required fields</div>' );
redirect('admin/settings/breakdown_alert');
}
}
/*
author: soma
purpose: Get single accident by id
date: 19-9-2019
*/
public function editaccident($accident_id)
{
$result = array();
$car_number_plate='car_number_plate';
$driving_licence_front='driving_licence_front';
$driving_licence_back='driving_licence_back';
$accident_media='accident_media';
$result['accident_car_number_plate'] = $this->msetting->accident_car_number_plate($accident_id,$car_number_plate);
$result['accident_driving_licence_front'] = $this->msetting->accident_driving_licence_front($accident_id,$driving_licence_front);
$result['accident_driving_licence_back'] = $this->msetting->accident_driving_licence_back($accident_id,$driving_licence_back);
$result['accident_medi'] = $this->msetting->accident_media($accident_id,$accident_media);
//$result['no_of_car'] = $this->msetting->no_of_car($accident_id);
$result['singl_accidents'] = $this->msetting->singl_accident($accident_id);
if(!empty($result['singl_accidents'])){
$result['no_of_car'] = count($result['singl_accidents'])+1;
}
//pr($result['singl_accidents']);
$condition=array('accident_id'=>$accident_id);
/*$select = 'accident_involved_car.is_insured';
$accident_insured = $this->msetting->getDetails('accident_involved_car',$condition,$select);
//print_r($vehicle_features_data);die;
if(!empty($accident_insured)){
foreach($accident_insured as $row1){
$result['accident_insured'][] = $row1['is_insured'];
}
}else{
$result['accident_insured'] = array();
}*/
$result['content']='admin/setting/editaccident';
$this->_load_view($result);
}
/*
author: soma
purpose: Update accident information
date: 19-9-2019
*/
public function accident_car_number_plate()
{
$accident_car_number_plate= $this->input->post( 'accident_car_number_plate' ); //accident_media_id
$accident_id= $this->input->post( 'accident_id' );
$car_number_plate_image= $this->input->post( 'car_number_plate_image' );
if($_FILES['media_link']['name']){
$path = './public/upload_image/accident_media/';
$upload_file = $this->single_image_upload($path, $_FILES['media_link'],'media_link');
if($upload_file['status']==1){
$accident_data['media_link']=$upload_file['result'];
}
}
else
{
//$this->session->set_flashdata('error_msg','Please Select a file...');
$accident_data['media_link']=$car_number_plate_image;
}
$tab=2;
$condition=array('accident_id'=>$accident_id,'accident_media_id'=>$accident_car_number_plate,'type'=>'car_number_plate');
$result=$this->mcommon->update('accident_media',$condition,$accident_data);
if($result)
{
$this->session->set_flashdata('success_msg','Accident image updated successfully');
redirect('admin/settings/editaccident/'.$accident_id .'/'.$tab);
}else{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}
}
/*
author: soma
purpose: Update accident information
date: 21-9-2019
*/
public function accident_car_number_plate_save()
{
//echo"insert";die;
//print_r($this->input->post());die;
//print_r($_FILES);die;
$car_number_plate_image=$this->input->post( 'car_number_plate_image' );
$accident_car_number_plate= $this->input->post( 'accident_car_number_plate' );
$accident_id= $this->input->post( 'accident_id' );
$data = array(
'accident_id' => $this->input->post( 'accident_id' ),
'type' => $this->input->post( 'accident_car_number_plate' ),
);
if($_FILES['media_link']['name']){
$path = './public/upload_image/accident_media/';
$upload_file = $this->single_image_upload($path, $_FILES['media_link'],'media_link');
if($upload_file['status']==1){
$data['media_link']=$upload_file['result'];
}
}
else
{
// $this->session->set_flashdata('error_msg','Please Select a file...');
$data['media_link']=$car_number_plate_image;
}
$insert_id=$this->mcommon->insert('accident_media',$data);
$tab=2;
if($insert_id)
{
$this->session->set_flashdata('success_msg','Accident image added successfully');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}else{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}
}
/*
author: soma
purpose: Update accident information
date: 20-9-2019
*/
public function accident_driving_licence_front()
{
$accident_driving_licence_front= $this->input->post( 'accident_driving_licence_front' );
$accident_id= $this->input->post( 'accident_id' );
$driving_licence_front= $this->input->post( 'driving_licence_front' );
if($_FILES['media_link']['name']){
$path = './public/upload_image/accident_media/';
$upload_file = $this->single_image_upload($path, $_FILES['media_link'],'media_link');
if($upload_file['status']==1){
$accident_data['media_link']=$upload_file['result'];
}
}
else
{
$accident_data['media_link']=$driving_licence_front;
}
$tab=2;
$condition=array('accident_id'=>$accident_id,'accident_media_id'=>$accident_driving_licence_front,'type'=>'driving_licence_front');
$result=$this->mcommon->update('accident_media',$condition,$accident_data);
if($result)
{
$this->session->set_flashdata('success_msg','Accident image updated successfully');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}else{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}
}
/*
author: soma
purpose: Update accident information
date: 21-9-2019
*/
public function accident_driving_licence_front_save()
{
$accident_id= $this->input->post( 'accident_id' );
$driving_licence_font= $this->input->post( 'driving_licence_font' );
$driving_licence_front_image=$this->input->post( 'driving_licence_front_image' );
if($_FILES['media_link']['name']){
$path = './public/upload_image/accident_media/';
$upload_file = $this->single_image_upload($path, $_FILES['media_link'],'media_link');
if($upload_file['status']==1){
$accident_data['media_link']=$upload_file['result'];
}
}
else
{
$accident_data['media_link']=$driving_licence_front_image;
}
$tab=2;
$accident_data['accident_id']=$this->input->post( 'accident_id' );
$accident_data['type']=$this->input->post( 'driving_licence_font' );
$insert_id=$this->mcommon->insert('accident_media',$accident_data);
if($insert_id)
{
$this->session->set_flashdata('success_msg','Accident image added successfully');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}
else
{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}
}
/*
author: soma
purpose: Update accident information
date: 20-9-2019
*/
public function accident_driving_licence_back()
{
$accident_driving_licence_back= $this->input->post( 'accident_driving_licence_back' ); //accident_media_id
$accident_id= $this->input->post( 'accident_id' );
$driving_licence_back= $this->input->post( 'driving_licence_back' );
if($_FILES['media_link']['name']){
$path = './public/upload_image/accident_media/';
$upload_file = $this->single_image_upload($path, $_FILES['media_link'],'media_link');
if($upload_file['status']==1){
$accident_data['media_link']=$upload_file['result'];
}
}
else
{
$accident_data['media_link']=$driving_licence_back;
}
$condition=array('accident_id'=>$accident_id,'accident_media_id'=>$accident_driving_licence_back,'type'=>'driving_licence_back');
$tab=2;
$result=$this->mcommon->update('accident_media',$condition,$accident_data);
if($result)
{
$this->session->set_flashdata('success_msg','Accident image updated successfully');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}
else
{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}
}
/*
author: soma
purpose: Update accident information
date: 21-9-2019
*/
public function accident_driving_licence_back_save()
{
//$accident_driving_licence_back= $this->input->post( 'accident_driving_licence_back' ); //accident_media_id
$accident_id= $this->input->post( 'accident_id' );
$driving_licence_back= $this->input->post( 'driving_licence_back' );
$driving_licence_back_image= $this->input->post( 'driving_licence_back_image' );
if($_FILES['media_link']['name']){
$path = './public/upload_image/accident_media/';
$upload_file = $this->single_image_upload($path, $_FILES['media_link'],'media_link');
if($upload_file['status']==1){
$accident_data['media_link']=$upload_file['result'];
}
}
else
{
$this->session->set_flashdata('error_msg','Please Choose image');
$accident_data['media_link']=$driving_licence_back_image;
}
$accident_data['accident_id']=$this->input->post( 'accident_id' );
$accident_data['type']=$this->input->post( 'driving_licence_back' );
$insert_id=$this->mcommon->insert('accident_media',$accident_data);
$tab=2;
if($insert_id)
{
$this->session->set_flashdata('success_msg','Accident image added successfully');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}else{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}
}
/*
author: soma
purpose: Update accident information
date: 20-9-2019
*/
public function accident_media()
{
//pr($_FILES);
$data = array();
$result = array();
$imgArry = array();
$accident_id = $this->input->post( 'accident_id' );
$tab = $this->input->post( 'tab' );
if($this->input->post()){
$data = array(
'accident_id' => $this->input->post( 'accident_id'),
'type' => $this->input->post( 'type' ),
);
if(!empty($_FILES['car_number_plate']['name'])){
$image_path_carNO = '/public/upload_image/accident_media/';
$file_carNO = $this->imageupload->image_upload2($image_path_carNO,'car_number_plate');
if($file_carNO['status']==0){
$this->session->set_flashdata('error_msg',$file_carNO['result']);
redirect('admin/settings/editaccident/'.$this->input->post( 'accident_id').'/2');
}
else{
$updatedata_carNO = array('accident_id'=>$this->input->post('accident_id'),'media_link' => $file_carNO['result'],'type'=>'car_number_plate');
$cond_carNO = array('accident_id' => $this->input->post('accident_id'),'type' => 'car_number_plate');
$dr_carno_img_data = $this->mcommon->getROW('accident_media',$cond_carNO);
//pr($dr_carno_img_data);
if(!empty($dr_carno_img_data)){
$this->mcommon->update('accident_media',$cond_carNO,$updatedata_carNO);
}
else{
$this->mcommon->insert('accident_media',$updatedata_carNO);
}
$this->session->set_flashdata('success_msg','Image uploaded successfully.');
}
}
if(!empty($_FILES['dr_licence_front']['name'])){
$image_path_dr_licence_fnt = '/public/upload_image/accident_media/';
$file_dr_licence_fnt = $this->imageupload->image_upload2($image_path_dr_licence_fnt,'dr_licence_front');
if($file_dr_licence_fnt['status']==0){
$this->session->set_flashdata('error_msg',$file_dr_licence_fnt['result']);
redirect('admin/settings/editaccident/'.$this->input->post( 'accident_id').'/2');
}
else{
$updatedata_dr_licence_fnt = array('accident_id'=>$this->input->post('accident_id'),'media_link' => $file_dr_licence_fnt['result'],'type'=>'driving_licence_front');
$cond_dr_licence_fnt = array('accident_id' => $this->input->post('accident_id'),'type' => 'driving_licence_front');
$dr_licence_fnt_img_data = $this->mcommon->getROW('accident_media',$cond_dr_licence_fnt);
if(!empty($dr_licence_fnt_img_data)){
$this->mcommon->update('accident_media',$cond_dr_licence_fnt,$updatedata_dr_licence_fnt);
}
else{
$this->mcommon->insert('accident_media',$updatedata_dr_licence_fnt);
}
$this->session->set_flashdata('success_msg','Image uploaded successfully.');
}
}
if(!empty($_FILES['dr_licence_back']['name'])){
$image_path_dr_licence_bk = '/public/upload_image/accident_media/';
$file_dr_licence_bk = $this->imageupload->image_upload2($image_path_dr_licence_bk,'dr_licence_back');
if($file_dr_licence_bk['status']==0){
$this->session->set_flashdata('error_msg',$file_dr_licence_bk['result']);
redirect('admin/settings/editaccident/'.$this->input->post( 'accident_id').'/2');
}
else{
$updatedata_dr_licence_bk = array('accident_id'=>$this->input->post('accident_id'),'media_link' => $file_dr_licence_bk['result'],'type'=>'driving_licence_back');
$cond_dr_licence_bk = array('accident_id' => $this->input->post('accident_id'),'type' => 'driving_licence_back');
$dr_licence_bk_img_data = $this->mcommon->getROW('accident_media',$cond_dr_licence_bk);
if(!empty($dr_licence_bk_img_data)){
$this->mcommon->update('accident_media',$cond_dr_licence_bk,$updatedata_dr_licence_bk);
}
else{
$this->mcommon->insert('accident_media',$updatedata_dr_licence_bk);
}
$this->session->set_flashdata('success_msg','Image uploaded successfully.');
}
}
if(!empty($_FILES["accident_img"]["name"][0])){
//echo "58947";exit;
$config = array(
'upload_path' => './public/upload_image/accident_media/',
'allowed_types' => 'jpg|gif|png|jpeg',
'overwrite' => 1,
'max_size' => 0
);
$this->load->library('upload', $config);
$images = array();
foreach ($_FILES["accident_img"]["name"] as $key => $image_list) {
$_FILES['images[]']['name'] = $_FILES["accident_img"]["name"][$key];
$_FILES['images[]']['type'] = $_FILES["accident_img"]["type"][$key];
$_FILES['images[]']['tmp_name'] = $_FILES["accident_img"]["tmp_name"][$key];
$_FILES['images[]']['error'] = $_FILES["accident_img"]['error'][$key];
$_FILES['images[]']['size'] = $_FILES["accident_img"]['size'][$key];
$this->upload->initialize($config);
if ($this->upload->do_upload('images[]')) {
$imageDetailArray = $this->upload->data();
$imgArry[] = $imageDetailArray['file_name'];
} else {
//echo "kjdfh";exit;
$error = $this->upload->display_errors();
$this->session->set_flashdata('error_msg', $error);
redirect('admin/settings/editaccident/'.$accident_id.'/2');
}
}
//pr($imgArry);
if(!empty($imgArry)){
foreach($imgArry as $img){
$instdata_accident_media = array('accident_id'=>$this->input->post('accident_id'),'media_link' => $img,'type'=>'accident_media');
$this->mcommon->insert('accident_media',$instdata_accident_media);
}
$this->session->set_flashdata('success_msg','Accident image updated successfully');
}
}
}
redirect('admin/settings/editaccident/'.$accident_id.'/2');
}
/*
author: soma
purpose: Update accident information
date: 20-9-2019
*/
public function update_accident_form1(){
//pr($_POST);
$data = array();
$data = $this->input->post();
/************************ Sreela (12/11/19) update fault type in accident master****************************/
$update_acc_data = array('fault_type' => $data['fault_type'],'updated_ts' => date('Y-m-d H:i:s'),'updated_by' => $this->session->userdata('user_data'));
$cond_acc = array('accident_id' => $data['aid'],'driver_id' => $data['driver_id']);
$this->mcommon->update('master_accident',$cond_acc,$update_acc_data);
/************************ Sreela (12/11/19) update fault type in accident master end ***********************/
for($i=0; $i<count($data['involved_car_id']); $i++){
$batch[] = array( 'involved_car_id' => $data['involved_car_id'][$i],
'accident_id' => $data['aid'],
'make' => $data['make'][$i],
'rego' => $data['rego'][$i],
'insurance_company' => $data['insurance_company'][$i],
'is_insured' => $data['is_insured'.$i],
'owner_name' => $data['owner_name'][$i],
'owner_contact_no' => $data['owner_contact_no'][$i],
'owner_email' => $data['owner_email'][$i],
'owner_address' => $data['owner_address'][$i],
'driver_name' => $data['driver_name'][$i],
'driver_contact_no' => $data['driver_contact_no'][$i],
'driver_email' => $data['driver_email'][$i],
'driver_address' => $data['driver_address'][$i]
);
}
// print_r($batch);die;
// $this->db->update_batch('accident_involved_car',$batch,'involved_car_id');
$condition='involved_car_id';
$result=$this->mcommon->batch_update('accident_involved_car',$batch,$condition);
$aid = $this->input->post( 'aid' );
if($result)
{
$this->session->set_flashdata('success_msg','Accident information updated successfully');
redirect('admin/settings/editaccident/'.$aid.'/'.$tab);
}else{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$aid.'/'.$tab);
}
}
/*
author: soma
purpose: Update accident information
date: 20-9-2019
*/
public function update_accident_form3()
{
$data = array();
$result = array();
$data = array(
'witness_name' => $this->input->post( 'witness_name' ),
'witness_address' => $this->input->post( 'witness_address' ),
'witness_mobile' => $this->input->post( 'witness_mobile' ),
'is_police_attended' => $this->input->post( 'is_police_attended' ),
'officer_name' => $this->input->post( 'officer_name' ),
'police_station' => $this->input->post( 'police_station' ),
'officer_phone_no' => $this->input->post( 'officer_phone_no' ),
'officer_reference_no' => $this->input->post( 'officer_reference_no' ),
);
$aid = $this->input->post( 'accident_id' );
$tab = 3;
$condition=array('accident_id'=>$aid);
$result=$this->mcommon->update('accident_witness',$condition,$data);
if($result)
{
$this->session->set_flashdata('success_msg','Accident information updated successfully');
redirect('admin/settings/editaccident/'.$aid.'/'.$tab);
}
else
{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$aid.'/'.$tab);
}
}
/*
author: soma
purpose: Update accident information
date: 20-9-2019
*/
public function update_accident_form4()
{
//pr($_POST);
$data = array();
$result = array();
$accd_date = $this->input->post('accident_date');
$accd_time = $this->input->post('accident_time');
$new_date = date("Y-m-d", strtotime(str_replace('/','-',$accd_date)));
$new_time = date("H:i:s", strtotime(str_replace('/','-',$accd_time)));
$new_datetime = $new_date.' '.$new_time;
$updatedatetime_data['accident_datetime'] = $new_datetime;
$data = array(
'no_of_car' => $this->input->post( 'no_of_car' ),
'accident_datetime' => $new_datetime,
'place' => $this->input->post( 'place' ),
'description' => $this->input->post( 'description' ),
'updated_by' => $this->session->userdata('user_data'),
'updated_ts' => date('Y-m-d H:i:s'),
);
$aid = $this->input->post( 'accident_id' );
$tab = 4;
$condition=array('accident_id'=>$aid);
$result=$this->mcommon->update('master_accident',$condition,$data);
if($result)
{
$this->session->set_flashdata('success_msg','Accident information updated successfully');
redirect('admin/settings/editaccident/'.$aid.'/'.$tab);
}
else
{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/editaccident/'.$aid.'/'.$tab);
}
}
private function single_image_upload($path,$files,$document_type){
$fileName = $document_type.'_'.time().'_'. str_replace(" ","_",$files['name']);
$config = array(
'upload_path' => $path,
'allowed_types' => 'gif|jpg|png|jpeg|pdf|xls|xlsx|doc|docx',
'overwrite' => 1,
'file_name' =>$fileName
);
//print_r($config);die;
$this->load->library('upload', $config);
if (!$this->upload->do_upload($document_type)){
$message = array('result' => 'The file you are attempting is not correct. Please select gif|jpg|png|jpeg file','status'=>0);
}else{
$data = array('upload_data' => $this->upload->data());
$message = array('result' => $data['upload_data']['file_name'],'status'=>1);
}
return $message;
}
private function upload_Product_images($path,$files,$accident_media_id,$document_type){
//echo"<pre>";print_r($product_id); die;
$config = array(
'upload_path' => $path,
'allowed_types' => 'gif|jpg|png|jpeg|pdf|xls|xlsx|doc|docx',
'overwrite' => 1,
);
$this->load->library('upload', $config);
$images = array();
foreach ($files['name'] as $key => $image) {
$_FILES['images[]']['name']= $files['name'][$key];
$_FILES['images[]']['type']= $files['type'][$key];
$_FILES['images[]']['tmp_name']= $files['tmp_name'][$key];
$_FILES['images[]']['error']= $files['error'][$key];
$_FILES['images[]']['size']= $files['size'][$key];
$fileName = $document_type.'_'.time() .'_'. $key .'_'. str_replace(" ","_",$image);
$images[] = $fileName;
$config['file_name'] = $fileName;
$this->upload->initialize($config);
if ($this->upload->do_upload('images[]')) {
$condition=array('accident_media_id'=>$accident_media_id);
//print_r($condition);die;
$data['accident_media_id'] = $accident_media_id;
$data['document_type']=$document_type;
$data['document_path'] = $fileName;
$this->mcommon->update('accident_media',$condition,$data);
} else {
//echo $this->upload->display_errors(); die;
return false;
}
}
return $images;
}
/*
author: soma
purpose: view accident pdf
date: 01-10-2019
*/
public function view_pdf($accident_id){
$data['content'] = 'admin/setting/accident_pdf';
$data['singl_accidents'] = $this->msetting->singl_accident($accident_id);
$data['owner_vehicle'] = $this->msetting->owner_vehicle($accident_id);
$data['no_of_car'] = $this->msetting->no_of_car($accident_id);
//pr($data);
$this->load->view('admin/setting/pdf', $data);
}
/*
author: soma
purpose: generate accident pdf
date: 23-9-2019
*/
public function generate_pdf($accident_id){
$data['singl_accidents'] = $this->msetting->singl_accident($accident_id);
$data['owner_vehicle'] = $this->msetting->owner_vehicle($accident_id);
$condition = array("accident_id" => $accident_id);
$no_of_car_invol = $this->mcommon->getRow('master_accident',$condition);
if(!empty($no_of_car_invol)){
$data['no_of_car_invol'] = $no_of_car_invol['no_of_car'];
}
else{
$data['no_of_car_invol'] = '0';
}
//pr($data);
//echo $this->load->view('admin/setting/accident_pdf', $data, true);exit;
$html = $this->load->view('admin/setting/accident_pdf', $data, true);
$dompdf = new Dompdf\Dompdf(['isHtml5ParserEnabled' => true]);
$dompdf->set_option("isPhpEnabled", true);
$dompdf->loadHtml($html);
$dompdf->setPaper('A3', 'portrait');
$dompdf->render();
$pdf = $dompdf->output();
$filename='accident_pdf_'.$data['owner_vehicle']['company_rego'].'_'.time();
//$file = './public/folder_name/'.$filename.'.pdf';
$dompdf->stream($filename);
//@file_put_contents($file, $pdf);
}
/*
author: soma
purpose: delete image
date: 20-9-2019
*/
public function delete_accident_image(){
$accident_media_id=$this->uri->segment(4);
$accident_image = $this->msetting->get_details($accident_media_id);
$accident_id=$accident_image['accident_id'];
if($accident_image['media_link']){
unlink('./uploads/images/'.$accident_image['media_link']);
}
$condition=array('accident_media_id'=>$accident_media_id );
$del = $this->mcommon->delete('accident_media',$condition);
$tab=2;
if($del){
$this->session->set_flashdata('success_msg','Deleted successfully..');
redirect('admin/settings/editaccident/'.$accident_id.'/'.$tab);
}else{
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
redirect('admin/settings/manageaccident/'.$accident_id.'/'.$tab);
}
}
/*
author: Arindam
purpose: get_accident_list_against_driver
date: 20-9-2019
*/
public function get_accident_list_against_driver(){
$driver_id=$this->input->post('user_id');
$add_or_settle_flag=$this->input->post('add_or_settle_flag');
$accident_list=$this->msetting->get_accident_list_against_driver($driver_id,$add_or_settle_flag);
if(!empty($accident_list)){
$return_data=array('status'=>true,'accident_list'=>$accident_list);
}
else{
$return_data=array('status'=>false,'accident_list'=>'');
}
echo json_encode($return_data);
}
public function bond_setup()
{ //print_r($_SESSION);die;
$result = array();
$result['drivers'] = $this->msetting->get_drivers();
$result['content']='admin/setting/bond_setup';
$this->_load_view($result);
}
/***************** Sreela(12/11/19) For add accident **********************/
public function AddNewAccident()
{
$result = array();
$result['driver_list'] = $this->mdriver->get_driver_list('1');
$con_car = array('status' => 1);
$all_cars = $this->mcommon->getDetails('master_car',$con_car);
if(!empty($all_cars)){
$result['all_cars'] = $all_cars;
}
else{
$result['all_cars'] = '';
}
$result['content']='admin/setting/addaccident';
$this->_load_view($result);
}
public function AddMoreAccdInvolCar(){
$data = array();
$resultarr = array();
$data['no_of_car'] = $this->input->post('no_of_car');
$resultarr['html'] = $this->load->view('admin/setting/ajax_accd_invol_car_details',$data,true);
echo json_encode($resultarr);exit;
}
/***************** Sreela(13/11/19) For insert accident involved car inform in accident master & accident_involved_car **********************/
public function add_accident_form1(){
//pr($_POST,0);
$inst_accid_arr = array();
$batch = array();
$inst_accid_arr['car_id'] = $this->input->post('car_no');
$inst_accid_arr['no_of_car'] = $this->input->post('no_of_car');
$inst_accid_arr['fault_type'] = $this->input->post('fault_type');
$inst_accid_arr['driver_id'] = $this->input->post('driver_id');
$shift_joindata = array( 'select' =>'DSD.shift_id',
'first_table' =>'roster_driver_maping RDM',
'second_table' =>'driver_shift_details DSD',
'dependency1' =>'RDM.roster_driver_id = DSD.roster_driver_id',
'join_type1' =>'INNER',
/**********************************/
'third_table' =>'roster',
'dependency2' =>'RDM.roster_id = roster.roster_id',
'join_type2' =>'INNER'
);
$shift_cond = array('RDM.driver_id' => $inst_accid_arr['driver_id'],'roster.car_id' =>$inst_accid_arr['car_id']);
$shift_data = $this->mcommon->joinQuery($shift_joindata,$shift_cond,'row','','');
//pr($shift_data);
if(!empty($shift_data)){
$inst_accid_arr['shift_id'] = $shift_data['shift_id'];
}
else{
$inst_accid_arr['shift_id'] = ' ';
}
$inst_accid_arr['created_ts'] = date('Y-m-d H:i:s');
$inst_accid_arr['created_by'] = $this->session->userdata('user_data');
$accident_id = $this->mcommon->insert('master_accident',$inst_accid_arr);
if($accident_id){
$this->session->set_userdata('accident_id', $accident_id);
$car_invol_data = $this->input->post();
//echo count($car_invol_data['make']);exit;
for($i=0; $i<count($car_invol_data['make']); $i++){
$batch_inst[] = array( 'accident_id' => $accident_id,
'make' => $car_invol_data['make'][$i],
'rego' => $car_invol_data['rego'][$i],
'insurance_company' => $car_invol_data['insurance_company'][$i],
'is_insured' => $car_invol_data['is_insured'][$i],
'owner_driver_flag' => $car_invol_data['owner_driver_flag'][$i],
'owner_name' => $car_invol_data['owner_name'][$i],
'owner_contact_no' => $car_invol_data['owner_contact_no'][$i],
'owner_email' => $car_invol_data['owner_email'][$i],
'owner_address' => $car_invol_data['owner_address'][$i],
'driver_name' => $car_invol_data['driver_name'][$i],
'driver_contact_no' => $car_invol_data['driver_contact_no'][$i],
'driver_email' => $car_invol_data['driver_email'][$i],
'driver_address' => $car_invol_data['driver_address'][$i]
);
}
$accidt_invol_car = $this->db->insert_batch('accident_involved_car', $batch_inst);
if($accident_id !="" && $accidt_invol_car !=""){
$this->session->set_flashdata('error_msg','');
$this->session->set_flashdata('success_msg','Accident information added successfully');
}
else{
$this->session->set_flashdata('success_msg','');
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
}
}
redirect('admin/settings/AddNewAccident/1');
}
/***************** Sreela(13/11/19) For insert accident images in accident_media **********************/
public function AccidentImageAdd()
{
$accident_id = '';
if($this->session->userdata('accident_id') !=''){
$accident_id = $this->session->userdata('accident_id');
}
//pr($this->session->userdata('accident_id'));
$data = array();
$result = array();
$imgArry = array();
if($this->input->post()){
if(!empty($_FILES['car_number_plate']['name'])){
$image_path_carNO = './public/upload_image/accident_media/';
$file_carNO = $this->imageupload->image_upload2($image_path_carNO,'car_number_plate');
if($file_carNO['status']==0){
$this->session->set_flashdata('success_msg','');
$this->session->set_flashdata('error_msg',$file_carNO['result']);
redirect('admin/settings/AddNewAccident/2');
}
else{
$data_carNO = array('accident_id'=>$accident_id,'media_link' => $file_carNO['result'],'type'=>'car_number_plate');
$cond_carNO = array('accident_id' => $accident_id,'type' => 'car_number_plate');
$dr_carno_img_data = $this->mcommon->getROW('accident_media',$cond_carNO);
//pr($dr_carno_img_data);
if(!empty($dr_carno_img_data)){
$this->mcommon->update('accident_media',$cond_carNO,$data_carNO);
}
else{
$this->mcommon->insert('accident_media',$data_carNO);
}
$this->session->set_flashdata('error_msg','');
$this->session->set_flashdata('success_msg','Image uploaded successfully.');
}
}
if(!empty($_FILES['dr_licence_front']['name'])){
$image_path_dr_licence_fnt = './public/upload_image/accident_media/';
$file_dr_licence_fnt = $this->imageupload->image_upload2($image_path_dr_licence_fnt,'dr_licence_front');
if($file_dr_licence_fnt['status']==0){
$this->session->set_flashdata('success_msg','');
$this->session->set_flashdata('error_msg',$file_dr_licence_fnt['result']);
redirect('admin/settings/AddNewAccident/2');
}
else{
$data_dr_licence_fnt = array('accident_id'=>$accident_id,'media_link' => $file_dr_licence_fnt['result'],'type'=>'driving_licence_front');
$cond_dr_licence_fnt = array('accident_id' => $accident_id,'type' => 'driving_licence_front');
$dr_licence_fnt_img_data = $this->mcommon->getROW('accident_media',$cond_dr_licence_fnt);
if(!empty($dr_licence_fnt_img_data)){
$this->mcommon->update('accident_media',$cond_dr_licence_fnt,$data_dr_licence_fnt);
}
else{
$this->mcommon->insert('accident_media',$data_dr_licence_fnt);
}
$this->session->set_flashdata('error_msg','');
$this->session->set_flashdata('success_msg','Image uploaded successfully.');
}
}
if(!empty($_FILES['dr_licence_back']['name'])){
$image_path_dr_licence_bk = './public/upload_image/accident_media/';
$file_dr_licence_bk = $this->imageupload->image_upload2($image_path_dr_licence_bk,'dr_licence_back');
if($file_dr_licence_bk['status']==0){
$this->session->set_flashdata('success_msg','');
$this->session->set_flashdata('error_msg',$file_dr_licence_bk['result']);
redirect('admin/settings/AddNewAccident/2');
}
else{
$data_dr_licence_bk = array('accident_id'=>$accident_id,'media_link' => $file_dr_licence_bk['result'],'type'=>'driving_licence_back');
$cond_dr_licence_bk = array('accident_id' => $accident_id,'type' => 'driving_licence_back');
$dr_licence_bk_img_data = $this->mcommon->getROW('accident_media',$cond_dr_licence_bk);
if(!empty($dr_licence_bk_img_data)){
$this->mcommon->update('accident_media',$cond_dr_licence_bk,$data_dr_licence_bk);
}
else{
$this->mcommon->insert('accident_media',$data_dr_licence_bk);
}
$this->session->set_flashdata('error_msg','');
$this->session->set_flashdata('success_msg','Image uploaded successfully.');
}
}
if(!empty($_FILES["accident_img"]["name"][0])){
//echo "58947";exit;
$config = array(
'upload_path' => './public/upload_image/accident_media/',
'allowed_types' => 'jpg|gif|png|jpeg',
'overwrite' => 1,
'max_size' => 0
);
$this->load->library('upload', $config);
$images = array();
foreach ($_FILES["accident_img"]["name"] as $key => $image_list) {
$_FILES['images[]']['name'] = $_FILES["accident_img"]["name"][$key];
$_FILES['images[]']['type'] = $_FILES["accident_img"]["type"][$key];
$_FILES['images[]']['tmp_name'] = $_FILES["accident_img"]["tmp_name"][$key];
$_FILES['images[]']['error'] = $_FILES["accident_img"]['error'][$key];
$_FILES['images[]']['size'] = $_FILES["accident_img"]['size'][$key];
$this->upload->initialize($config);
if ($this->upload->do_upload('images[]')) {
$imageDetailArray = $this->upload->data();
$imgArry[] = $imageDetailArray['file_name'];
} else {
//echo "kjdfh";exit;
$error = $this->upload->display_errors();
$this->session->set_flashdata('success_msg','');
$this->session->set_flashdata('error_msg', $error);
redirect('admin/settings/AddNewAccident/2');
}
}
//pr($imgArry);
if(!empty($imgArry)){
foreach($imgArry as $img){
$instdata_accident_media = array('accident_id'=>$accident_id,'media_link' => $img,'type'=>'accident_media');
$this->mcommon->insert('accident_media',$instdata_accident_media);
}
$this->session->set_flashdata('error_msg','');
$this->session->set_flashdata('success_msg','Accident image updated successfully');
}
}
}
redirect('admin/settings/AddNewAccident/2');
}
/***************** Sreela(13/11/19) For insert accident Witness in accident_witness **********************/
public function AccidentWitnessAdd()
{
//pr($_POST,0);
$accident_id = '26';
if($this->session->userdata('accident_id') !=''){
$accident_id = $this->session->userdata('accident_id');
}
$instwitness_data = array();
$instwitness_data['accident_id'] = $accident_id;
$instwitness_data['witness_name'] = $this->input->post('witness_name');
$instwitness_data['witness_address'] = $this->input->post('witness_address');
$instwitness_data['witness_mobile'] = $this->input->post('witness_mobile');
$instwitness_data['is_police_attended'] = $this->input->post('is_police_attended');
if($instwitness_data['is_police_attended'] == '1'){
$instwitness_data['officer_name'] = $this->input->post('officer_name');
$instwitness_data['police_station'] = $this->input->post('police_station');
$instwitness_data['officer_phone_no'] = $this->input->post('officer_phone_no');
$instwitness_data['officer_reference_no'] = $this->input->post('officer_reference_no');
}
else{
$instwitness_data['officer_name'] = '';
$instwitness_data['police_station'] = '';
$instwitness_data['officer_phone_no'] = '';
$instwitness_data['officer_reference_no'] = '';
}
$insert_id = $this->mcommon->insert('accident_witness',$instwitness_data);
if($insert_id){
$this->session->set_flashdata('error_msg','');
$this->session->set_flashdata('success_msg','Accident witness information added successfully');
}
else{
$this->session->set_flashdata('success_msg','');
$this->session->set_flashdata('error_msg','Oops!Something went wrong...');
}
redirect('admin/settings/AddNewAccident/3');
}
public function AccidentTimePlaceAdd()
{
$accident_id = '26';
if($this->session->userdata('accident_id') !=''){
$accident_id = $this->session->userdata('accident_id');
}
$updatedatetime_data = array();
$accd_date = $this->input->post('accident_datetime');
$accd_time = $this->input->post('accident_time');
$new_date = date("Y-m-d", strtotime(str_replace('/','-',$accd_date)));
$new_time = date("H:i:s", strtotime(str_replace('/','-',$accd_time)));
$new_datetime = $new_date.' '.$new_time;
$updatedatetime_data['accident_datetime'] = $new_datetime;
$updatedatetime_data['place'] = $this->input->post('place');
$updatedatetime_data['description'] = $this->input->post('description');
$updatedatetime_data['updated_ts'] = date('Y-m-d H:i:s');
$updatedatetime_data['updated_by'] = $this->session->userdata('user_data');
$accd_cond = array("accident_id" => $accident_id);
$this->mcommon->update("master_accident",$accd_cond,$updatedatetime_data);
$this->session->set_flashdata('error_msg','');
$this->session->set_flashdata('success_msg','Accident date time place information added successfully');
redirect('admin/settings/AddNewAccident/4');
}
public function get_bond_details_against_driver(){
$driver_id = $this->input->post('user_id');
$bond_data = $this->mcommon->getRow('master_bond',array('driver_id'=>$driver_id));
if(!empty($bond_data)){
$return_data =array('status'=>true,'bond_data'=>$bond_data);
}
else{
$return_data =array('status'=>false,'bond_data'=>array());
}
echo json_encode($return_data);
}
public function bond_submit(){
//echo '<pre>';print_r($this->input->post());die;
$bond_id=$this->input->post('bond_id');
$driver_id=$this->input->post('user_id');
$bond_amt=$this->input->post('bond_amt');
$initial_amt_paid=$this->input->post('initial_amt_paid');
$installment_shift=$this->input->post('installment_shift');
$condition=array('bond_id'=>$bond_id);
$bond_data=array(
'driver_id'=>$driver_id,
'bond_amt' =>$bond_amt,
'initial_amt_paid' => $initial_amt_paid,
'installment_shift'=>$installment_shift,
'updated_by'=> $this->session->userdata('user_data'),
'updated_on'=> date('Y-m-d H:i:s')
);
$this->mcommon->update('master_bond',$condition,$bond_data);
$this->session->set_flashdata('success_msg','Updated Successfully');
redirect('admin/settings/bond_setup');
}
}