<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Secure_Controller.php");
class temple_enquiry  extends Secure_Controller
{
 
	public function __construct(){
		parent::__construct('temple_enquiry');
		$this->load->model('Temple_enquiry_model');
		$this->load->model('Sms_model');
		$this->load->model('Customer');
	}
	public function index()
	{
		if(!$this->Appconfig->isAppvalid())
		{
			redirect('config');
		}
		$data['table_headers']=$this->xss_clean(get_temple_enquiry_headers());
		$this->load->view('temple_enquiry/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');
		$filters = array('start_date' => $this->input->get('start_date'),'end_date' => $this->input->get('end_date'),'Follow_Up' => FALSE,'Confirm' => FALSE,'Cancelled' => FALSE);			
		$filledup = array_fill_keys($this->input->get('filters'), TRUE);
		$filters = array_merge($filters, $filledup);
		$temple_enquiry=$this->Temple_enquiry_model->search($search,$filters,$limit,$offset,$sort,$order);

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

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

	public function view($temple_enquiry_id=-1){
		$info=$this->Temple_enquiry_model->get_info($temple_enquiry_id);
		foreach (get_object_vars($info) as $property => $value){
			$info->$property = $this->xss_clean($value);
		}
		$data['temple_enquiry']=$info;
		$getcust = $data['temple_enquiry'];
		$cust_id = $getcust->cust_id;
		
		$cust_info=$this->Temple_enquiry_model->get_customer($cust_id);
		foreach (get_object_vars($info) as $property => $value){
			$info->$property = $this->xss_clean($value);
		}
		$data['cust_info']=$cust_info; 
		
		$state_info[""] = "--Select State--";
		foreach($this->Temple_enquiry_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;
		
		$package_info[""] = "--Select package--";
		foreach($this->Temple_enquiry_model->get_package()->result_array() as $row){
		    $package_info[$this->xss_clean($row['package_id'])] = $this->xss_clean($row['package_name']."/".$row['from_date']." To ".$row['to_date']);
		}
		$data['package_info'] = $package_info;
		
		$this->load->view("temple_enquiry/form",$data);
	}
	
	public function save($temple_enquiry_id = -1){
		$mobile      = $this->input->post('phone_number');
		$enquiry_sts = $this->input->post('enquiry_sts');
		$customer_data = array(
			'customer_name'  => $this->input->post('customer_name'),
			'phone_number'   => $this->input->post('phone_number'),
			'alt_number'     => $this->input->post('alt_number'),
			'land_line'      => $this->input->post('land_line'),
			'cust_email'     => $this->input->post('email'),
			'cust_address'   => $this->input->post('cust_address'),
			'city'           => $this->input->post('city'),
			'state'          => $this->input->post('state'),
			'dob'            => date('Y-m-d',strtotime($this->input->post('dob'))),
			//'cust_type'      => "4",
			'created_by'     => $this->session->userdata('emp_id'),
			'created_date'   => date("Y-m-d h:i:s"),
		);
		$cust_id = $this->Customer->lead_save_customer($customer_data, $mobile);
		$temple_enquiry_data = array(
			'temple_enquiry_id' => $this->input->post('temple_enquiry_id'),
			'cust_id'           => $cust_id,
			'enquiry_date'      => date('Y-m-d',strtotime($this->input->post('enquiry_date'))),
			'enquiry_month'     => $this->input->post('enquiry_month'),
			'ticket_count'      => $this->input->post('ticket_count'),
			'pickup_point'      => $this->input->post('pickup_point'),
			//'discount'          => $this->input->post('discount'),
			'sourcing'          => $this->input->post('sourcing'),
			'package_id'        => $this->input->post('package_id'),
			'enquiry_sts'       => $this->input->post('enquiry_sts'),
			'remark'            => $this->input->post('remark'),
			'created_by'        => $this->session->userdata('emp_id'),
			'created_date'      => date("Y-m-d h:i:s"),
		);
		$package_data = "";
		if($enquiry_sts === "2"){
			$package_data = array(
				'package_id'        => $this->input->post('package_id'),
				'cust_id'           => $cust_id,
				'pickup_point'      => $this->input->post('pickup_point'),
				//'discount'          => $this->input->post('discount'),
				'sourcing'          => $this->input->post('sourcing'),
				'enquiry_sts'       => $this->input->post('enquiry_sts'),
				'remark'            => $this->input->post('remark'),
				'created_by'        => $this->session->userdata('emp_id'),
				'created_date'      => date("Y-m-d h:i:s"),
			);
		}else
		if($enquiry_sts === "3"){
			$package_data = array(
				'enquiry_sts'       => $this->input->post('enquiry_sts'),
			);
		}
		if($this->Temple_enquiry_model->save_temple_enquiry($temple_enquiry_data, $package_data,$temple_enquiry_id)){
			$temple_enquiry_data = $this->xss_clean($temple_enquiry_data);
			if($temple_enquiry_id == -1){
				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('temple_enquiry_successful_adding').' '.
								$temple_enquiry_data['temple_enquiry_name'], 'id' => $temple_enquiry_data['temple_enquiry_id']));
									if($mobile){
					$this->Sms_model->send_sms($temple_enquiry_data['temple_enquiry_id'],$mobile,"pkgenquiry_confirm");
				}
			}else {
				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('temple_enquiry_successful_updating').' '.
								$temple_enquiry_data['temple_enquiry_name'], 'id' => $temple_enquiry_id));
			}
			/*if($this->input->post('enquiry_sts') === "2"){
				if($mobile){
					$this->Sms_model->send_sms($temple_enquiry_id,$mobile,"pkgenquiry_confirm");
				}
			}*/			
		}else{
			$temple_enquiry_data = $this->xss_clean($temple_enquiry_data);
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('temple_enquiry_error_adding_updating').' '.
							$temple_enquiry_data['temple_enquiry_name'], 'id' => -1));
		}

	}

	public function get_row($temple_enquiry_ids){
		$temple_enquiry_infos = $this->Temple_enquiry_model->get_multiple_info($temple_enquiry_ids);
		$result = array();
		foreach($temple_enquiry_infos as $item_info){
			$result[$item_info->temple_enquiry_id] = $this->xss_clean(get_item_data_row($item_info, $this));
		}
		echo json_encode($result);
	}
	public function suggest_customer(){
		$suggestions = $this->xss_clean($this->Temple_enquiry_model->get_customer_suggestions($this->input->post('term')));
		echo json_encode(array('success' => TRUE, 'search' => $suggestions));
	}
	public function get_customer(){
		$suggestions = $this->xss_clean($this->Temple_enquiry_model->get_customer_info($this->input->post('term')));
		echo json_encode(array('success' => TRUE, 'search' => $suggestions));
	}
	public function delete(){
		$temple_enquiry_to_delete = $this->xss_clean($this->input->post('ids'));
		if($this->Temple_enquiry_model->delete_list($temple_enquiry_to_delete)){
			echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('temple_enquiry_successful_deleted').' '.
							count($temple_enquiry_to_delete).' '.$this->lang->line('temple_enquiry_one_or_multiple')));
		}else{
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('temple_enquiry_cannot_be_deleted')));
		}
	}
}
?>