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

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

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

	public function view($demand_date_id=-1)
	{
		$info=$this->Demand_date_model->get_info($demand_date_id);
		foreach (get_object_vars($info) as $property => $value){
			$info->$property = $this->xss_clean($value);
		}
		$data['demand_date']=$info;      

		$this->load->view("demand_date/form",$data);
	}
	/*
	Inserts/updates a demand_date
	*/
	public function exists(){
		$demand_date_id = $this->input->post('demand_date_id');
		$demand_month   = $this->input->post('demand_month');
		$demand_month = explode("-",$demand_month);
		$demand_month = $demand_month[1]."-".$demand_month[0];		
		$result = $this->Demand_date_model->exists($demand_date_id, $demand_month);
		echo $result;
	}
	
	public function save($demand_date_id = -1)
	{

		$demand_date_data = array(
			'demand_date_id' => $this->input->post('demand_date_id'),
			'demand_month'   => $this->input->post('demand_month'),
			'percentage'     => $this->input->post('percentage'),
			'demand_date'    => $this->input->post('demand_date'),
			'created_by'     => $this->session->userdata('emp_id'),
			'created_date'   => date("Y-m-d h:i:s"),			

		);

		if($this->Demand_date_model->save_demand_date($demand_date_data, $demand_date_id)){

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


			//New demand_date
			if($demand_date_id == -1){

				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('demand_date_successful_adding').' '.
								$demand_date_data['demand_month'], 'id' => $demand_date_data['demand_date_id']));
			}else {
				//Existing demand_dates
				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('demand_date_successful_updating').' '.
								$demand_date_data['demand_month'], 'id' => $demand_date_id));
			}
		}else{
			//failure
			$demand_date_data = $this->xss_clean($demand_date_data);
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('demand_date_error_adding_updating').' '.
							$demand_date_data['demand_month'], 'id' => -1));
		}

	}

	public function get_row($demand_date_ids)
	{
		$demand_date_infos = $this->Demand_date_model->get_multiple_info($demand_date_ids);

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

		echo json_encode($result);
	}

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

		if($this->Demand_date_model->delete_list($demand_date_to_delete))
		{
			echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('demand_date_successful_deleted').' '.
							count($demand_date_to_delete).' '.$this->lang->line('demand_date_one_or_multiple')));
		}
		else
		{
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('demand_date_cannot_be_deleted')));
		}
	}
}
?>