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

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

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

	public function view($city_id=-1)
	{
		$info=$this->City_model->get_info($city_id);

		foreach (get_object_vars($info) as $property => $value)
		{
			$info->$property = $this->xss_clean($value);
		}
		$data['city']=$info;      

		$this->load->view("city/form",$data);
	}
	/*
	Inserts/updates a city
	*/
	public function save($city_id = -1)
	{

		$city_data = array(
			'city_id'    => $this->input->post('city_id'),
			'city_name'  => $this->input->post('city_name'),
			'created_by'  => $this->session->userdata('emp_id'),
			'created_date' => date("Y-m-d h:i:s"),			

		);

		if($this->City_model->save_city($city_data, $city_id)){

			$city_data = $this->xss_clean($city_data);


			//New city
			if($city_id == -1)
			{

				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('city_successful_adding').' '.
								$city_data['city_name'], 'id' => $city_data['city_id']));
			}else {
				//Existing citys
				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('city_successful_updating').' '.
								$city_data['city_name'], 'id' => $city_id));
			}
		}else{
			//failure
			$city_data = $this->xss_clean($city_data);
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('city_error_adding_updating').' '.
							$city_data['city_name'], 'id' => -1));
		}

	}

	public function get_row($city_ids)
	{
		$city_infos = $this->City_model->get_multiple_info($city_ids);

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

		echo json_encode($result);
	}

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

		if($this->City_model->delete_list($city_to_delete))
		{
			echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('city_successful_deleted').' '.
							count($city_to_delete).' '.$this->lang->line('city_one_or_multiple')));
		}
		else
		{
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('city_cannot_be_deleted')));
		}
	}
}
?>