<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Secure_Controller.php");
class average_km  extends Secure_Controller
{
 
	public function __construct()
	{
		parent::__construct('average_km');
		$this->load->model('Average_km_model');
	}
	public function index()
	{
		if(!$this->Appconfig->isAppvalid())
		{
			redirect('config');
		}
		$data['table_headers']=$this->xss_clean(get_average_km_headers());
		$this->load->view('average_km/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');
		$average_km=$this->Average_km_model->search($search,$limit,$offset,$sort,$order);

		$TotalRows=$this->Average_km_model->get_found_rows($search);
		$DataRows=array();

		foreach ($average_km->result() as $person) 
		{	
			$DataRows[]=get_average_km_datarows($person,$this);
		}
		$DataRows=$this->xss_clean($DataRows);
		echo json_encode(array('total'=>$TotalRows,'rows'=>$DataRows));
	}

	public function view($average_km_id=-1)
	{
		$info=$this->Average_km_model->get_info($average_km_id);

		foreach (get_object_vars($info) as $property => $value)
		{
			$info->$property = $this->xss_clean($value);
		}
		$data['average_km']=$info;
		
		$city_info[""] = "--Select City--";
		foreach($this->Average_km_model->get_city()->result_array() as $row){
		    $city_info[$this->xss_clean($row['city_id'])] = $this->xss_clean($row['city_name']);
		}
		$data['city_info'] = $city_info;
		
		$this->load->view("average_km/form",$data);
	}
	/*
	Inserts/updates a average_km
	*/
	public function save($average_km_id = -1){
		$average_km_data = array(
			'average_km_id' => $this->input->post('average_km_id'),
			'frm_city'      => $this->input->post('frm_city'),
			'to_city'       => $this->input->post('to_city'),
			'km'            => $this->input->post('km'),
			'created_by'    => $this->session->userdata('emp_id'),
			'created_date'  => date("Y-m-d h:i:s"),
		);

		if($this->Average_km_model->save_average_km($average_km_data, $average_km_id)){
			$average_km_data = $this->xss_clean($average_km_data);
			if($average_km_id == -1){
				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('average_km_successful_adding').' '.
								$average_km_data['average_km_name'], 'id' => $average_km_data['average_km_id']));
			}else {
				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('average_km_successful_updating').' '.
								$average_km_data['average_km_name'], 'id' => $average_km_id));
			}
		}else{
			$average_km_data = $this->xss_clean($average_km_data);
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('average_km_error_adding_updating').' '.
							$average_km_data['average_km_name'], 'id' => -1));
		}

	}

	public function get_row($average_km_ids)
	{
		$average_km_infos = $this->Average_km_model->get_multiple_info($average_km_ids);

		$result = array();
		foreach($average_km_infos as $item_info)
		{
			$result[$item_info->average_km_id] = $this->xss_clean(get_item_data_row($item_info, $this));
		}

		echo json_encode($result);
	}

	/*
	This deletes average_kms from the average_kms table
	*/
	public function delete(){
		$average_km_to_delete = $this->xss_clean($this->input->post('ids'));

		if($this->Average_km_model->delete_list($average_km_to_delete))
		{
			echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('average_km_successful_deleted').' '.
							count($average_km_to_delete).' '.$this->lang->line('average_km_one_or_multiple')));
		}
		else
		{
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('average_km_cannot_be_deleted')));
		}
	}
}
?>