MOON
Server: Apache
System: Linux nserver.cafsindia.com 4.18.0-553.104.1.lve.el8.x86_64 #1 SMP Tue Feb 10 20:07:30 UTC 2026 x86_64
User: cafsindia (1002)
PHP: 8.2.30
Disabled: NONE
Upload Files
File: /home/cafsindia/allyindian_com/sbltt/application/controllers/Enquiry.php
<?php if ( ! defined('BASEPATH')) exit('No direct script is allowed');
require_once("Secure_Controller.php");
class Enquiry  extends Secure_Controller
{
 
	public function __construct(){
		parent::__construct('enquiry');
		$this->load->model('Enquiry_model');
		$this->load->model('Sms_model');
		$this->load->model('Email_model');
		$this->load->model('Customer');
	}
	public function index()
	{
		if(!$this->Appconfig->isAppvalid())
		{
			redirect('config');
		}
		$data['table_headers']=$this->xss_clean(get_enquiry_headers());
		$this->load->view('enquiry/manage',$data);
	}
	public function date_difference(){
		$from_date = strtotime($this->input->post('from_date'));
		$to_date   = strtotime($this->input->post('to_date'));
		if($from_date > $to_date){
			echo json_encode(array('success' => false, 'message' =>"Please enter valid form and to date"));
		}else{
			$from_date = date("Y-m-d", $from_date);
			$to_date   = date("Y-m-d", $to_date);
			
			$diff = abs(strtotime($to_date) - strtotime($from_date));
			$years = floor($diff / (365*60*60*24));
			$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
			$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
			$days = $days +1;
			echo json_encode(array('success' => true, 'days'=>$days));
		}
	}
	public function suggest_customer(){
		$suggestions = $this->xss_clean($this->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->Enquiry_model->get_customer_info($this->input->post('term')));
		echo json_encode(array('success' => TRUE, 'search' => $suggestions));
	}
	public function get_average_km(){
		$orgin       = $this->input->post('orgin');
		$destination = $this->input->post('destination');		
		$average_km  = $this->Enquiry_model->get_average_km($orgin,$destination);
		echo json_encode(array('success' => TRUE, 'average_km' => $average_km));
	}
	public function get_tariff(){
		$trip_type    = $this->input->post('trip_type');
		$vehicle_type = $this->input->post('vehicle_type');		
		$tariff  = $this->Enquiry_model->get_tariff($trip_type,$vehicle_type);
		echo json_encode(array('success' => TRUE, 'tariff' => $tariff));
	}
	public function get_amount(){
		$trip_type    = $this->input->post('trip_type');
		$vehicle_type = $this->input->post('vehicle_type');
		$avg_km       = $this->input->post('avg_km');
		$bus_count    = $this->input->post('bus_count');
		$tariff_amt   = $this->Enquiry_model->get_tariff_amt($trip_type,$vehicle_type,$avg_km);
		
		$upto_km      = $tariff_amt->upto_km;
		$upto_amt     = $tariff_amt->upto_amt;
		$extra_km_amt = $tariff_amt->extra_km_amt;
		$trip_ex_km   = (int)$avg_km - (int)$upto_km;
		$trip_ex_amt  = 0;
		if((int)$trip_ex_km > 0){
			$trip_ex_amt  = (int)$trip_ex_km * (int)$extra_km_amt;
		}
		$trip_amt = (int)$upto_amt + (int)$trip_ex_amt;
		if((int)$bus_count > 0){
			$trip_amt = (int)$trip_amt*(int)$bus_count; 
		}
		echo json_encode(array('success' => TRUE, 'trip_amt' => $trip_amt));
	}
	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,'Hot' => FALSE,'Warm' => FALSE,'Dropped' => FALSE);			
		$filledup = array_fill_keys($this->input->get('filters'), TRUE);
		$filters = array_merge($filters, $filledup);
		$filledup1 = array_fill_keys($this->input->get('prospect_list'), TRUE);
		$filters = array_merge($filters, $filledup1);
		
		$enquiry=$this->Enquiry_model->search($search,$filters,$limit,$offset,$sort,$order);
		$TotalRows=$this->Enquiry_model->get_found_rows($search,$filters);
		$DataRows=array();
		foreach ($enquiry->result() as $person){	
			$DataRows[]=get_enquiry_datarows($person,$this);
		}
		$DataRows=$this->xss_clean($DataRows);
		echo json_encode(array('total'=>$TotalRows,'rows'=>$DataRows));
	}

	public function view($enquiry_id=-1)
	{
		$info=$this->Enquiry_model->get_info($enquiry_id);
		foreach (get_object_vars($info) as $property => $value){
			$info->$property = $this->xss_clean($value);
		}
		$data['enquiry']=$info; 
		
		$getcust = $data['enquiry'];
		$cust_id = $getcust->cust_id;
		$type    = $getcust->vehicle_type;
		$trip    = $getcust->trip_type;
		$data['tariff_table']  = $this->Enquiry_model->get_tariff($trip,$type);		
		$cust_info=$this->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->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;
		
		$city_info[""] = "--Select City--";
		foreach($this->Enquiry_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;
		
		$booking_type[""] = "--Select Customer Type--";
		foreach($this->Enquiry_model->get_booking_type()->result_array() as $row){
		    $booking_type[$this->xss_clean($row['booking_type_id'])] = $this->xss_clean($row['booking_type_name']);
		}
		$data['booking_type'] = $booking_type;
		
		$vehicle_type[""] = "--Select Vehicle Type--";
		foreach($this->Enquiry_model->get_vehicle_type()->result_array() as $row){
		    $vehicle_type[$this->xss_clean($row['veh_type_id'])] = $this->xss_clean($row['veh_type']." - ".$row['veh_category']);
		}		
		$data['vehicle_type'] = $vehicle_type;
		
		$trip_type[""] = "--Select Trip Type--";
		foreach($this->Enquiry_model->get_trip_type()->result_array() as $row){
		    $trip_type[$this->xss_clean($row['trip_type_id'])] = $this->xss_clean($row['trip_type_name']);
		}		
		$data['trip_type'] = $trip_type;
		
		$referral_info[""] = "---- Select Refered By ----";
		foreach($this->Enquiry_model->get_referral()->result_array() as $row){
			$referral_info[$this->xss_clean($row['person_id'])] = $this->xss_clean($row['first_name']."-".$row['role_name']);
		}
		$referral_info['0'] = "Others";
		$data['referral_info'] = $referral_info;
		
		$this->load->view("enquiry/form",$data);
	}
	/*
	Inserts/updates a enquiry
	*/
	public function save($enquiry_id = -1){
		$mobile = $this->input->post('phone_number');
		$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'      => $this->input->post('cust_type'),
			'referral_type'  => $this->input->post('referral_type'),
			'allow_contract' => $this->input->post('allow_contract'),
			'cust_sts'       => $this->input->post('cust_sts'),
			'cust_zone'      => $this->input->post('cust_zone'),
			'csut_gst'       => $this->input->post('csut_gst'),
			'csut_pan'       => $this->input->post('csut_pan'),
			'includ_gst'     => $this->input->post('includ_gst')
		);
		$cust_id = $this->Customer->lead_save_customer($customer_data, $mobile);
		
		$enquiry_data = array(
			'enquiry_id'     => $this->input->post('enquiry_id'),
			'cust_id'        => $cust_id,
			'billing_name'   => $this->input->post('billing_name'),
			'report_address' => $this->input->post('report_address'),
			'landmark'       => $this->input->post('landmark'),
			'orgin'          => $this->input->post('orgin'),
			'destination'    => $this->input->post('destination'),
			'avg_km'         => $this->input->post('avg_km'),
			'bus_count'      => $this->input->post('bus_count'),
			'pax'            => $this->input->post('pax'),
			'booking_amount' => $this->input->post('booking_amount'),
			'trip_days'      => $this->input->post('trip_days'),
			'from_date'      => date('Y-m-d',strtotime($this->input->post('from_date'))),
			'to_date'        => date('Y-m-d',strtotime($this->input->post('to_date'))),
			'trip_type'      => $this->input->post('trip_type'),
			'cust_type'      => $this->input->post('cust_type'),
			'vehicle_type'   => $this->input->post('vehicle_type'),
			'enquiry_sts'    => $this->input->post('enquiry_sts'),
			'prospect'       => $this->input->post('prospect'),
			'trip_details'   => $this->input->post('trip_details'),
			'remark'         => $this->input->post('remark'),
			'cancel_reson'   => $this->input->post('cancel_reson'),
			'referral'       => $this->input->post('referral'),
			'ncd'            => date('Y-m-d',strtotime($this->input->post('ncd'))),
			'created_by'     => $this->session->userdata('emp_id'),
			'created_date'   => date("Y-m-d H:i:s"),
		);
		$enquiry_log_data = array(
			'enquiry_id'     => $this->input->post('enquiry_id'),
			'pax'            => $this->input->post('pax'),
			'booking_amount' => $this->input->post('booking_amount'),
			'bus_count'      => $this->input->post('bus_count'),
			'trip_days'      => $this->input->post('trip_days'),
			'trip_type'      => $this->input->post('trip_type'),
			'cust_type'      => $this->input->post('cust_type'),
			'vehicle_type'   => $this->input->post('vehicle_type'),
			'enquiry_sts'    => $this->input->post('enquiry_sts'),
			'prospect'       => $this->input->post('prospect'),
			'trip_details'   => $this->input->post('trip_details'),
			'remark'         => $this->input->post('remark'),
			'ncd'            => date('Y-m-d',strtotime($this->input->post('ncd'))),
			'created_by'     => $this->session->userdata('emp_id'),
			'created_date'   => date("Y-m-d H:i:s"),
		);
		$booking_data = "";
		if($this->input->post('enquiry_sts') === "2"){
			$booking_data = array(
				'enquiry_id'     => $this->input->post('enquiry_id'),
				'cust_id'        => $cust_id,
				'billing_name'   => $this->input->post('billing_name'),
				'report_address' => $this->input->post('report_address'),
				'landmark'       => $this->input->post('landmark'),
				'orgin'          => $this->input->post('orgin'),
				'destination'    => $this->input->post('destination'),
				'avg_km'         => $this->input->post('avg_km'),
				'bus_count'      => $this->input->post('bus_count'),
				'pax'            => $this->input->post('pax'),
				'booking_amount' => $this->input->post('booking_amount'),
				'trip_days'      => $this->input->post('trip_days'),
				'from_date'      => date('Y-m-d',strtotime($this->input->post('from_date'))),
				'to_date'        => date('Y-m-d',strtotime($this->input->post('to_date'))),
				'trip_type'      => $this->input->post('trip_type'),
				'cust_type'      => $this->input->post('cust_type'),
				'vehicle_type'   => $this->input->post('vehicle_type'),
				'booking_sts'    => '1',
				'trip_details'   => $this->input->post('trip_details'),
				'remark'         => $this->input->post('remark'),
				'referral'       => $this->input->post('referral'),
				'created_by'     => $this->session->userdata('emp_id'),
				'created_date'   => date("Y-m-d H:i:s"),
			);
		}
		if($this->Enquiry_model->save_enquiry($enquiry_data, $enquiry_log_data,$booking_data,$enquiry_id)){
			$enquiry_data = $this->xss_clean($enquiry_data);
			if($enquiry_id == -1){
				$enquiry_id = $enquiry_data['enquiry_id'];
                             
                               // Raghu 25aug2018
                               if($mobile){
					$this->Sms_model->send_sms($enquiry_id,$mobile,"enquiry_confirm");
				}
				$this->send_email($enquiry_id);

				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('enquiry_successful_adding').' '.
								$enquiry_data['enquiry_name'], 'id' => $enquiry_data['enquiry_id']));
			}else{
				echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('enquiry_successful_updating').' '.
								$enquiry_data['enquiry_name'], 'id' => $enquiry_id));
			}
			// SEND SMS
			if($this->input->post('enquiry_sts') === "2"){
				if($mobile){
					$this->Sms_model->send_sms($enquiry_id,$mobile,"enquiry_confirm");
				}
				$this->send_email($enquiry_id);
			}
			/*
			if($this->input->post('enquiry_sts') === "3"){
				if($mobile){
					$this->Sms_model->send_sms($enquiry_id,$mobile,"enquiry_confirm");
				}
			}
			*/
			
		}else{
			$enquiry_data = $this->xss_clean($enquiry_data);
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('enquiry_error_adding_updating').' '.
							$enquiry_data['enquiry_name'], 'id' => -1));
		}
	}

	public function get_row($enquiry_ids)
	{
		$enquiry_infos = $this->Enquiry_model->get_multiple_info($enquiry_ids);

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

		echo json_encode($result);
	}
	public function quotation($enquiry_id){
		$data = $this->_load_quotation_data($enquiry_id);
		$this->load->view('enquiry/quotation',$data);
	}
	public function enquiry_log($enquiry_id){
		$data['enquiry_log'] = $this->Enquiry_model->get_enquiry_log($enquiry_id);
		$this->load->view('enquiry/enquiry_log',$data);
	}
	public function send_email($enquiry_id){
		$data = $this->_load_quotation_data($enquiry_id);
		$enquiry_info  = $data['enquiry_info'];
		$hsn           = $data['hsn'];
		$tariff        = $data['tariff'];		
	
		$company  = $this->config->item('company');
		$address  = $this->config->item('address');
		$landline = $this->config->item('landline');
		$phone    = $this->config->item('phone');
		$email    = $this->config->item('email');
		$website  = $this->config->item('website'); 
		
		$company_info = "<b>$company</b><br/>$address<br/>$landline - $phone<br/>$email<br/>$website<br/>";
		
		foreach($enquiry_info as $enquiry){
			$enquiry_id     = $enquiry->enquiry_id;
			$enquiry_id     = "INQ".str_pad($enquiry_id, 4, '0', STR_PAD_LEFT);
			$customer_name  = $enquiry->customer_name;
			$billing_name   = $enquiry->billing_name;
			$report_address = $enquiry->report_address;
			$phone_number   = $enquiry->cust_mobile;
			$alt_number     = $enquiry->cust_alt_number;
			$land_line      = $enquiry->cust_land_line;
			$cust_email     = $enquiry->cust_email;
			$cust_address   = $enquiry->cust_address;
			$city           = $enquiry->cust_city;
			$state          = $enquiry->cust_state;
			$state_name     = $enquiry->state_name;
			$includ_gst     = $enquiry->includ_gst;
			
			$from_date       = date('d-m-Y',strtotime($enquiry->from_date));
			$to_date         = date('d-m-Y',strtotime($enquiry->to_date));
			$frm_city_name  = $enquiry->frm_city_name;
			$to_city_name   = $enquiry->to_city_name;
			$bus_count      = $enquiry->bus_count;
			$trip_days      = $enquiry->trip_days;
			$veh_type       = $enquiry->veh_type;
			$avg_km         = $enquiry->avg_km;
			$booking_amount = $enquiry->booking_amount;
			$attend         = $enquiry->attend;
			$reffered       = $enquiry->reffered;
			$remark         = $enquiry->remark;
			$created_date   = date('d-m-Y H:i:s',strtotime($enquiry->enquiry_date))."Hrs";
		}
		$upto_km      = $tariff->upto_km;
		$upto_amt     = $tariff->upto_amt;
		$extra_km_amt = $tariff->extra_km_amt;
		$trip_ex_km   = (int)$avg_km - (int)$upto_km;
		$trip_ex_amt  = 0;
		if((int)$trip_ex_km > 0){
			$trip_ex_amt  = (int)$trip_ex_km * (int)$extra_km_amt;
		}
		$trip_amt = (int)$upto_amt + (int)$trip_ex_amt;
		if((int)$bus_count > 0){
			$trip_amt = (int)$trip_amt*(int)$bus_count; 
		}
		
		$igst = $hsn->igst;
		$sgst = $hsn->sgst;
		$cgst = $hsn->cgst;
		
		$igst_amt = $trip_amt * $igst/100;
		$sgst_amt = $trip_amt * $sgst/100;
		$cgst_amt = $trip_amt * $cgst/100;
		
		
		$total_amt = $trip_amt;
		if($includ_gst === "1"){
			if($state === "33"){
				$total_amt = $trip_amt + $cgst_amt + $sgst_amt;
			}else{
				$total_amt = $trip_amt + $igst_amt;
			}
		}
		for($i=0;$i<=8;$i++){
			$add_line.= "<tr>
			<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'></td>
			<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'></td>
			<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'></td>
			<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'></td>
			<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'></td>
			</tr>";
		}
		if((int)$booking_amount === 0){
			$txt_bal = "Zero";
		}else{
			$txt_bal = $this->numberTowords($booking_amount);
		}
		$base_url = "http://".$_SERVER['SERVER_NAME'].dirname($_SERVER["REQUEST_URI"].'?').'/';
		$url = str_replace("index.php/enquiry/send_email","","$base_url");
		$url = str_replace("index.php/enquiry/resend_email","","$base_url");
		/*Added by GS Image Issue */
		$url = "http://www.sblt.co.in/sbltt/";
		$email_content = "<div>
							Dear Sir,<br/>
							<b>Enquiry From SBLT!!!</b><br/><br/>
							Enquiry Details $billing_name,<br/>
							Your Enquiry Has Registered Successfully. Your Enquiry Details are below.<br/><br/>
							<table style='width: 100%;border-collapse: collapse; border-spacing: 0;font-size: 12px;font-family: sans-serif;'>
								<tr>
									<td style='padding: 8px;border: 1px solid #333333;'><img src='$url/images/sbltlogo.png' alt='SBLTT Logo' height='45'/></td>
									<td style='padding: 8px;border: 1px solid #333333;border-bottom:0px;font-weight:bold;text-align:right;'>Quotation Sheet</td>
								</tr>
								<tr>
									<td  style='padding: 8px;border: 1px solid #333333;border-right:0px;'>$company_info</td>
									<td>
										<table style='width: 100%;border-collapse: collapse; border-spacing: 0;font-size: 12px;font-family: sans-serif;'>
											<tr>
												<td  style='padding: 8px;border: 1px solid #333333;'><b>Enquiry Date & Time</b></td>
												<td  style='padding: 8px;border: 1px solid #333333;'>$created_date</td>
											</tr>
											<tr>
												<td  style='padding: 8px;border: 1px solid #333333;'><b>Enquiry By</b></td>
												<td style='padding: 8px;border: 1px solid #333333;'>$customer_name / $phone_number</td>
											</tr>
											<tr>
												<td colspan='2'  style='padding: 8px;border: 1px solid #333333;border-bottom:0px;'>
													<b>Reporting Details</b><br/>
													$billing_name<br/>$report_address<br/>$city<br/>$state_name<br/>$phone_number  $alt_number  $land_line<br/>$cust_email<br/> <b>Land Mark</b> : $landmark
												</td>
											</tr>
										</table>		
									</td>
								</tr>
								<tr>
									<td style='padding: 8px;border: 1px solid #333333;'><b>Journey On:</b> $from_date</td>
									<td style='padding: 8px;border: 1px solid #333333;'> </td>
								</tr>
								<tr>
									<td style='padding: 8px;border: 1px solid #333333;'><b>Enquiry No:</b> $enquiry_id</td>
									<td style='padding: 8px;border: 1px solid #333333;'><b>No Of Days:</b> $trip_days</td>			
								</tr>
								<tr>
									<td style='padding: 8px;border: 1px solid #333333;'><b>No Of Vehicle:</b> $bus_count</td>
									<td style='padding: 8px;border: 1px solid #333333;'><b>Coach:</b>$veh_type</td>
								</tr>
								<tr>
									<td style='padding: 8px;border: 1px solid #333333;'><b>Basic charges:</b>$booking_amount</td>
									<td style='padding: 8px;border: 1px solid #333333;'><b>Coverage KM<sup>(Per day)</sup>:</b> $avg_km</td>
								</tr>
								<tr>
									<td style='padding: 8px;border: 1px solid #333333;border-bottom:0px;'><b>Attened By:</b> $attend</td>
									<td style='padding: 8px;border: 1px solid #333333;border-bottom:0px;'><b>Quoted By:</b>$reffered</td>
								</tr>
							</table>
						</div>
						<div>
							<table style='width: 100%;border-collapse: collapse; border-spacing: 0;font-size: 12px;font-family: sans-serif;'>
								<tr>
									<td style='padding: 8px;border: 1px solid #333333;font-weight:bold;'>Sl.no</td>
									<td style='padding: 8px;border: 1px solid #333333;font-weight:bold;'>Particular</td>
									<td style='padding: 8px;border: 1px solid #333333;font-weight:bold;'>Amount</td>
									<td style='padding: 8px;border: 1px solid #333333;font-weight:bold;'>Discount</td>
									<td style='padding: 8px;border: 1px solid #333333;font-weight:bold;'>Total</td>
								</tr>
								<tr>
									<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'> 1 </td>
									<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'>Enquiry for $frm_city_name - $to_city_name , $from_date - $to_date
									</td>
									<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'>$booking_amount</td>
									<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'>0</td>
									<td style='padding: 8px;border-right: 1px solid #333333;border-left: 1px solid #333333;'>$booking_amount</td>
								</tr>
								$add_line
								<tr>
									<td  colspan='5' style='padding: 8px;border: 1px solid #333333;'> 
										Total Amount in Words : <b>Rupees $txt_bal</b>
									</td>
								</tr>
								<tr>
									<td  colspan='5' style='padding: 8px;border: 1px solid #333333;'> <b>Note </b> <br/> $remark </td>
								</tr>
								<tr>
									<td  colspan='2' style='padding: 8px;border: 1px solid #333333;'>
										<b>For further details of enquiry to check with us</b>
										<table style='width: 100%;border-collapse: collapse; border-spacing: 0;font-size: 12px;font-family: sans-serif;'>
											<tr>
												<td>Helpline</td>
												<td>044-46664666 / 9841699966</td>
											</tr>
											<tr>
												<td>Email</td>
												<td>tours@sblt.co.in</td>
											</tr>
										</table>
									</td>
									<td colspan='3' style='padding: 8px;border: 1px solid #333333;border-top: 0px;text-align:right;'>
										<b>for Sri Bhagiyalakshmi Tours & Travels</b><br/><br/><br/><br/><br/><br/>
										Authorised Signatory<br/>
									</td>
								</tr>
							</table>
						</div>";
		//if($cust_email){	 UDY :: REMOVE GS ASKED TO SEND WITH OUT TO EMAIL		 
			$email_data = array(				
				'to_email'       => $cust_email,
				'subject'        => "SBLT Enquiry Sheet for $enquiry_id",
				'email_content'  => $email_content,
				'email_type'     => "ENQUIRY",
			);
			//$this->Email_model->send_email($email_data);
			$this->Email_model->send_phpmailer($email_data);
		//}
		
	}
	public function resend_email($enquiry_id){
		$this->send_email($enquiry_id,"RESEND");
	}
	private function _load_quotation_data($enquiry_id){	
	
		$data['enquiry_info'] = $this->Enquiry_model->get_load_data($enquiry_id);
		
		$getcust = $data['enquiry_info'];		
		$vehicle = $getcust[0]->vehicle_type;
		$trip    = $getcust[0]->trip_type;
		$km      = $getcust[0]->avg_km;
		if($km === ""){ $km = 0; }
		$data['tariff']  = $this->Enquiry_model->get_tariff_amt($trip,$vehicle,$km);
		$data['hsn']  = $this->Enquiry_model->get_hsn();
		return $data;
	}
	public function numberTowords($number){
		$no = round($number);
		$point = round($number - $no, 2) * 100;
		$hundred = null;
		$digits_1 = strlen($no);
		$i = 0;
		$str = array();
		$words = array('0' => '', '1' => 'One', '2' => 'Two',
			'3' => 'Three', '4' => 'Four', '5' => 'Five', '6' => 'Six',
			'7' => 'Seven', '8' => 'Eight', '9' => 'Nine',
			'10' => 'Ten', '11' => 'Eleven', '12' => 'Twelve',
			'13' => 'Thirteen', '14' => 'Fourteen',
			'15' => 'Fifteen', '16' => 'Sixteen', '17' => 'Seventeen',
			'18' => 'Eighteen', '19' =>'Nineteen', '20' => 'Twenty',
			'30' => 'Thirty', '40' => 'Forty', '50' => 'Fifty',
			'60' => 'Sixty', '70' => 'Seventy',
			'80' => 'Eighty', '90' => 'Ninety');
		$digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
		while ($i < $digits_1) {
			$divider = ($i == 2) ? 10 : 100;
			$number = floor($no % $divider);
			$no = floor($no / $divider);
			$i += ($divider == 10) ? 1 : 2;
			if ($number) {
				$plural = (($counter = count($str)) && $number > 9) ? 's' : null;
				$hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
				$str [] = ($number < 21) ? $words[$number] .
				" " . $digits[$counter] . $plural . " " . $hundred
				:
				$words[floor($number / 10) * 10]
				. " " . $words[$number % 10] . " "
				. $digits[$counter] . $plural . " " . $hundred;
			} else $str[] = null;
		}
		$str = array_reverse($str);
		$result = implode('', $str);
		$points = ($point) ?
		"." . $words[$point / 10] . " " . 
		$words[$point = $point % 10] : '';
			//echo $result . "Rupees  " . $points . " Paise";
		return $result . "INR Only ";
	} 
	public function delete(){
		$enquiry_to_delete = $this->xss_clean($this->input->post('ids'));

		if($this->Enquiry_model->delete_list($enquiry_to_delete))
		{
			echo json_encode(array('success' => TRUE, 'message' => $this->lang->line('enquiry_successful_deleted').' '.
							count($enquiry_to_delete).' '.$this->lang->line('enquiry_one_or_multiple')));
		}
		else
		{
			echo json_encode(array('success' => FALSE, 'message' => $this->lang->line('enquiry_cannot_be_deleted')));
		}
	}
}
?>