File: /home/cafsindia/allyindian_com/sbltt/application/controllers/Vehicle.php
<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Secure_Controller.php");
class vehicle extends Secure_Controller
{
public function __construct()
{
parent::__construct('vehicle');
$this->load->model('Vehicle_model');
}
public function index(){
if(!$this->Appconfig->isAppvalid())
{
redirect('config');
}
$data['table_headers']=$this->xss_clean(get_vehicle_headers());
$this->load->view('vehicle/manage',$data);
}
public function search()
{
$search=$this->input->get('search');
$limit=$this->input->get('limit');
$offset=$this->input->get('offset');
$sort=$this->input->get('sort');
$order=$this->input->get('order');
$vehicle=$this->Vehicle_model->search($search,$limit,$offset,$sort,$order);
$TotalRows=$this->Vehicle_model->get_found_rows($search);
$DataRows=array();
foreach ($vehicle->result() as $person)
{
$DataRows[]=get_vehicle_datarows($person,$this);
}
$DataRows=$this->xss_clean($DataRows);
echo json_encode(array('total'=>$TotalRows,'rows'=>$DataRows));
}
public function view($vehicle_id=-1)
{
$info=$this->Vehicle_model->get_info($vehicle_id);
foreach (get_object_vars($info) as $property => $value)
{
$info->$property = $this->xss_clean($value);
}
$data['vehicle']=$info;
$vehicle_type[""] = "--Select Vehicle Type--";
foreach($this->Vehicle_model->get_vehicle_type()->result_array() as $row){
$vehicle_type[$this->xss_clean($row['veh_type_id'])] = $this->xss_clean($row['veh_type']);
}
$data['vehicle_type'] = $vehicle_type;
$owned_by[""] = "--Select Owned By--";
foreach($this->Vehicle_model->get_vendor()->result_array() as $row){
$owned_by[$this->xss_clean($row['vendor_id'])] = $this->xss_clean($row['vendor_name']);
}
$data['owned_by'] = $owned_by;
$driver_name[""] = "--Select Driver Name--";
foreach($this->Vehicle_model->get_driver_name()->result_array() as $row){
$driver_name[$this->xss_clean($row['id'])] = $this->xss_clean($row['first_name']);
}
$data['driver_name'] = $driver_name;
$permit_type[""] = "--Select Permit Type--";
foreach($this->Vehicle_model->get_permit_type()->result_array() as $row){
$permit_type[$this->xss_clean($row['permit_type_id'])] = $this->xss_clean($row['permit_type_name']);
}
$data['permit_type'] = $permit_type;
$state_info[""] = "--Select State--";
foreach($this->Vehicle_model->get_state()->result_array() as $row){
$state_info[$this->xss_clean($row['state_code'])] = $this->xss_clean($row['state_name']);
}
$data['state_info'] = $state_info;
$this->load->view("vehicle/form",$data);
}
public function misc($vehicle_id){
$info=$this->Vehicle_model->get_info($vehicle_id);
foreach (get_object_vars($info) as $property => $value){
$info->$property = $this->xss_clean($value);
}
$data['vehicle'] = $info;
$data['expence_info'] = $this->Vehicle_model->get_expence_info($vehicle_id);
$data['emi_info'] = $this->Vehicle_model->get_emi_info($vehicle_id);
$data['doc_info'] = $this->Vehicle_model->get_doc_info($vehicle_id);
$data['mileage_info'] = $this->Vehicle_model->get_mileage_info($vehicle_id);
$expence_type[""] = "--Select Expence Type--";
foreach($this->Vehicle_model->get_expence_type()->result_array() as $row){
$expence_type[$this->xss_clean($row['expence_type_id'])] = $this->xss_clean($row['expence_type_name']);
}
$data['expence_type'] = $expence_type;
$expence_supplier[""] = "--Select Supplier--";
foreach($this->Vehicle_model->get_supplier()->result_array() as $row){
$expence_supplier[$this->xss_clean($row['supplier_id'])] = $this->xss_clean($row['supplier_name']);
}
$data['expence_supplier'] = $expence_supplier;
$this->load->view("vehicle/misc",$data);
}
public function expence_save($vehicle_id){
$vehicle_data = array(
'vehicle_id' => $this->input->post('vehicle_id'),
'expence_date' => date('Y-m-d',strtotime($this->input->post('expence_date'))),
'expence_type' => $this->input->post('expence_type'),
'expence_product' => $this->input->post('expence_product'),
'expence_supplier' => $this->input->post('expence_supplier'),
'remark' => $this->input->post('remark'),
'expence_amt' => $this->input->post('expence_amt'),
);
$expence_id = $this->input->post('expence_id');
if($expence_id === ""){
$vehicle_data['created_date'] = date("Y-m-d h:i:s");
$vehicle_data['created_by'] = $this->session->userdata('emp_id');
$sts = $this->Vehicle_model->expence_save($vehicle_data, $vehicle_id);
}else{
$vehicle_data['updated_date'] = date("Y-m-d h:i:s");
$vehicle_data['updated_by'] = $this->session->userdata('emp_id');
$sts = $this->Vehicle_model->expence_upd($vehicle_data, $expence_id);
}
$expence_info = $this->Vehicle_model->get_expence_info($vehicle_id);
echo json_encode(array('success' => TRUE, 'data' => $expence_info, 'sts' => $sts));
}
public function emi_save($vehicle_id){
$vehicle_data = array(
'vehicle_id' => $this->input->post('emi_vehicle_id'),
'emi_from' => date('Y-m-d',strtotime($this->input->post('emi_from'))),
'emi_to' => date('Y-m-d',strtotime($this->input->post('emi_to'))),
'emi_remark' => $this->input->post('emi_remark'),
'emi_amt' => $this->input->post('emi_amt'),
);
$emi_id = $this->input->post('emi_id');
if($emi_id === ""){
$vehicle_data['created_date'] = date("Y-m-d h:i:s");
$vehicle_data['created_by'] = $this->session->userdata('emp_id');
$sts = $this->Vehicle_model->emi_save($vehicle_data, $vehicle_id);
}else{
$vehicle_data['updated_date'] = date("Y-m-d h:i:s");
$vehicle_data['updated_by'] = $this->session->userdata('emp_id');
$sts = $this->Vehicle_model->emi_upd($vehicle_data, $emi_id);
}
$emi_info = $this->Vehicle_model->get_emi_info($vehicle_id);
echo json_encode(array('success' => TRUE, 'data' => $emi_info, 'sts' => $sts));
}
public function doc_save($vehicle_id){
$vehicle_data = array(
'vehicle_id' => $this->input->post('doc_vehicle_id'),
'doc_from' => date('Y-m-d',strtotime($this->input->post('doc_from'))),
'doc_to' => date('Y-m-d',strtotime($this->input->post('doc_to'))),
'doc_type' => $this->input->post('doc_type'),
'doc_amt' => $this->input->post('doc_amt'),
);
$doc_id = $this->input->post('doc_id');
if($doc_id === ""){
$vehicle_data['created_date'] = date("Y-m-d h:i:s");
$vehicle_data['created_by'] = $this->session->userdata('emp_id');
$sts = $this->Vehicle_model->doc_save($vehicle_data, $vehicle_id);
}else{
$vehicle_data['updated_date'] = date("Y-m-d h:i:s");
$vehicle_data['updated_by'] = $this->session->userdata('emp_id');
$sts = $this->Vehicle_model->doc_upd($vehicle_data, $doc_id);
}
$doc_info = $this->Vehicle_model->get_doc_info($vehicle_id);
echo json_encode(array('success' => TRUE, 'data' => $doc_info , 'sts' => $sts));
}
public function mileage_save($vehicle_id){
$vehicle_data = array(
'vehicle_id' => $this->input->post('mileage_veh_id'),
'mileage_from' => date('Y-m-d',strtotime($this->input->post('mileage_from'))),
'mileage_to' => date('Y-m-d',strtotime($this->input->post('mileage_to'))),
'mileage' => $this->input->post('mileage'),
);
$mileage_id = $this->input->post('mileage_id');
if($mileage_id === ""){
$vehicle_data['created_date'] = date("Y-m-d h:i:s");
$vehicle_data['created_by'] = $this->session->userdata('emp_id');
$sts = $this->Vehicle_model->mileage_save($vehicle_data, $vehicle_id);
}else{
$vehicle_data['updated_date'] = date("Y-m-d h:i:s");
$vehicle_data['updated_by'] = $this->session->userdata('emp_id');
$sts = $this->Vehicle_model->mileage_upd($vehicle_data, $mileage_id);
}
$mileage_info = $this->Vehicle_model->get_mileage_info($vehicle_id);
echo json_encode(array('success' => TRUE, 'data' => $mileage_info , 'sts' => $sts));
}
/*
Inserts/updates a vehicle
*/
public function save($vehicle_id = -1)
{
$vehicle_data = array(
'vehicle_id' => $this->input->post('vehicle_id'),
'vehicle_state' => $this->input->post('vehicle_state'),
'vehicle_no' => $this->input->post('vehicle_no'),
'model' => $this->input->post('model'),
'chasis_no' => $this->input->post('chasis_no'),
'engine_no' => $this->input->post('engine_no'),
'vehicle_type' => $this->input->post('vehicle_type'),
'fule_type' => $this->input->post('fule_type'),
'tracking_link' => $this->input->post('tracking_link'),
'auth_date' => date('Y-m-d',strtotime($this->input->post('auth_date'))),
'fc_date' => date('Y-m-d',strtotime($this->input->post('fc_date'))),
'permit_type' => $this->input->post('permit_type'),
'permit_date' => date('Y-m-d',strtotime($this->input->post('permit_date'))),
'permit_no' => $this->input->post('permit_no'),
'insur_company' => $this->input->post('insur_company'),
'insur_date' => date('Y-m-d',strtotime($this->input->post('insur_date'))),
'pollution_no' => $this->input->post('pollution_no'),
'pollution_date' => date('Y-m-d',strtotime($this->input->post('pollution_date'))),
'driver_name' => $this->input->post('driver_name'),
'owned_by' => $this->input->post('owned_by'),
'emi_amt' => $this->input->post('emi_amt'),
'emi_percentage' => $this->input->post('emi_percentage'),
'emi_from' => date('Y-m-d',strtotime($this->input->post('emi_from'))),
'emi_to' => date('Y-m-d',strtotime($this->input->post('emi_to'))),
'branch_name' => $this->input->post('branch_name'),
'live_chart' => $this->input->post('live_chart'),
'bank_name' => $this->input->post('bank_name'),
'created_by' => $this->session->userdata('emp_id'),
'created_date' => date("Y-m-d h:i:s"),
);
if($this->Vehicle_model->save_vehicle($vehicle_data, $vehicle_id)){
$vehicle_data = $this->xss_clean($vehicle_data);
//New vehicle
if($vehicle_id == -1)
{
echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('vehicle_successful_adding').' '.
$vehicle_data['vehicle_name'], 'id' => $vehicle_data['vehicle_id']));
}else {
//Existing vehicles
echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('vehicle_successful_updating').' '.
$vehicle_data['vehicle_name'], 'id' => $vehicle_id));
}
}else{
//failure
$vehicle_data = $this->xss_clean($vehicle_data);
echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('vehicle_error_adding_updating').' '.
$vehicle_data['vehicle_name'], 'id' => -1));
}
}
public function get_row($vehicle_ids)
{
$vehicle_infos = $this->Vehicle_model->get_multiple_info($vehicle_ids);
$result = array();
foreach($vehicle_infos as $item_info)
{
$result[$item_info->vehicle_id] = $this->xss_clean(get_item_data_row($item_info, $this));
}
echo json_encode($result);
}
/*
This deletes vehicles from the vehicles table
*/
public function delete(){
$vehicle_to_delete = $this->xss_clean($this->input->post('ids'));
if($this->Vehicle_model->delete_list($vehicle_to_delete))
{
echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('vehicle_successful_deleted').' '.
count($vehicle_to_delete).' '.$this->lang->line('vehicle_one_or_multiple')));
}
else
{
echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('vehicle_cannot_be_deleted')));
}
}
}
?>