<?php
@session_start();
// Exit if accessed directly
if ( !defined( 'ABSPATH' ) ) exit;

// BEGIN ENQUEUE PARENT ACTION
// AUTO GENERATED - Do not modify or remove comment markers above or below:

        
if ( !function_exists( 'chld_thm_cfg_parent_css' ) ):
    function chld_thm_cfg_parent_css() {
        wp_enqueue_style( 'chld_thm_cfg_parent', trailingslashit( get_template_directory_uri() ) . 'style.css' );
		wp_register_script('my_amazing_script', get_stylesheet_directory_uri(). '/custom.js', array('jquery'),'1.1', true);
		wp_enqueue_script('my_amazing_script');
    }
endif;
add_action( 'wp_enqueue_scripts', 'chld_thm_cfg_parent_css' );
add_action( 'dopbsp_action_book_after', 'send_sms_after_booking');

function send_sms_after_booking(){
	//$message = json_encode($args);
	//$message = json_encode($_POST);
	$parLogin 	= '+14168789089'; 
	$smsMSG 	= "You Have Received A Vacation Request For Ontario Service.";
	
	$arg = array('number_to' => $parLogin ,'message' =>$smsMSG); 
	$data = twl_send_sms( $arg ); 
	
	// 4168190111, 4168190182, 4168190187
	$parLogin 	= '+14168190111'; 
	$arg = array('number_to' => $parLogin ,'message' =>$smsMSG); 
	$data = twl_send_sms( $arg ); 
	
	$parLogin 	= '+14168190182'; 
	$arg = array('number_to' => $parLogin ,'message' =>$smsMSG); 
	$data = twl_send_sms( $arg );
	
	$parLogin 	= '+14168190187'; 
	$arg = array('number_to' => $parLogin ,'message' =>$smsMSG); 
	$data = twl_send_sms( $arg ); 

	//wp_mail("jugal.kishor23@gmail.com","Request",$message);  
}

function generatePDF($data,$filename,$form_id,$entry_id){
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;
	
	$root = $_SERVER['DOCUMENT_ROOT'];
	$pdfClass = $root . "/html2pdf/html2pdf.class.php";
	require_once($pdfClass);
	
	ob_start();
	include($root .'/pdfcontent.html');
	$content = ob_get_clean();
	$_SESSION['MYPON'] = $data['vfb-field-6093'];
	$content = str_replace("[LOGOIMG]",$root . '/logo.png',$content);
	$content = str_replace("[PON]",$data['vfb-field-6093'],$content);
	$content = str_replace("[Submission_Date]",$data['vfb-field-6095'],$content);
	$content = str_replace("[Submission_Time]",$data['vfb-field-6094'],$content);
	$content = str_replace("[Type_Of_Purchase]",$data['vfb-field-6096'],$content);
	$content = str_replace("[Ticket_Number]",$data['vfb-field-6097'],$content);
	$content = str_replace("[Job_Number]",$data['vfb-field-6098'],$content);
	$content = str_replace("[Job_Name]",$data['vfb-field-6099'],$content);
	$content = str_replace("[Supplier]",$data['vfb-field-6100'],$content);
	$content = str_replace("[Currency]",$data['vfb-field-6101'],$content);
	$content = str_replace("[Amount]",$data['vfb-field-6102'],$content);
	$content = str_replace("[Quotation_Required]",$data['vfb-field-6103'],$content);
	$content = str_replace("[Description]",$data['vfb-field-6105'],$content);
	$content = str_replace("[Mobile_Number]",$phoneno,$content);
	if($data['vfb-field-6109'] != ""){
			$img = $data['vfb-field-6109'];
			$img = str_replace('data:image/png;base64,', '', $img);
			$img = str_replace(' ', '+', $img);
			$data = base64_decode($img);
			$file = $root.'/MobileUpload/'. uniqid() . '.png';
			file_put_contents($file, $data);
		$content = str_replace("[Service_Technician_Signature]",'<img src="'.$file.'">',$content);
	} else {
		$content = str_replace("[Service_Technician_Signature]",'',$content);
	}
	
	$content = str_replace("[Technician_Name]",$display_name,$content);
	$content = str_replace("[Technician_Email]",$user_email,$content);

	//$content = str_replace("[Service_Technician_Signature]",$data['vfb-field-6237'],$content);
    //echo $content; die;
	$fp = fopen($root.'/Parking_Ticket/content1.txt','w+');
	fwrite($fp,$content);
	fclose($fp);
	
	$html2pdf = new HTML2PDF('P','A4','en');
	
    $html2pdf->WriteHTML($content);
	$fp = fopen($root.'/Parking_Ticket/content2.txt','w+');
	fwrite($fp,$content);
	fclose($fp);
	
    $pdfdoc = $html2pdf->Output($root.'/POLPDF/'.$filename,'F');
	$pdfFilePath = $root.'/POLPDF/'.$filename;
	$attachments = array($pdfFilePath);
	$moreattachments = getEntryAttachmentDetails($entry_id);
	if(!empty($moreattachments)){
		$attachments = array_merge($attachments, $moreattachments);
	}
	global $wpdb;
	$queryEmailTo = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'email-to' AND form_id =".$form_id, OBJECT );
	$queryEmailTo = $queryEmailTo[0]->meta_value;
	
	$querySubject = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'subject' AND form_id =".$form_id, OBJECT );
	$querySubject = $querySubject[0]->meta_value . "  - PDF";
	wp_mail( $queryEmailTo, $querySubject,' ', $headers, $attachments );	
	//wp_mail( 'jugal.kishor23@gmail.com', 'testing mail','message',$headers);
}


add_action( 'vfbp_after_save_entry', 'filter_vfbp_after_save_entry', 10, 2 );

function filter_vfbp_after_save_entry( $entry_id, $form_id ) {
	$root = $_SERVER['DOCUMENT_ROOT'];
	$Form_id = $_POST['_vfb-form-id'];
	$fp = fopen($root.'/Parking_Ticket/ext.txt','w+');
	fwrite($fp,$form_id);
	fclose($fp);
	/* if($Form_id == "96"){
		$fp = fopen($root.'/Parking_Ticket/AutoComplete.txt','w+');
		fwrite($fp,json_encode($_POST));
		fclose($fp);
	} */
	if($Form_id == "68"){
		updateLastPONum();
		$filename = $_POST["vfb-field-6093"].".pdf";
		generatePDF($_POST,$filename,$form_id,$entry_id);
		
	}
	if($Form_id == "82"){
		//$date =date('YmdHis');
		$filename = 'PTA'.date('YmdHis').'.pdf';
		
		generateParkingTicketPDF($_POST,$filename,$form_id,$entry_id);
	}
	if($Form_id == "121"){
		//$date =date('YmdHis');
		$filename = 'PTA'.date('YmdHis').'.pdf';
		
		generateParkingTicketPDF($_POST,$filename,$form_id,$entry_id);
	}
	if($Form_id == "84"){
		//$date =date('YmdHis');
		$filename = 'POA'.date('YmdHis').'.pdf';
		generateParkingovernightTicketPDF($_POST,$filename,$form_id,$entry_id);
	}
	
	if($Form_id == "96"){
		//$date =date('YmdHis');
		$filename = 'UCR'.date('YmdHis').'.pdf';
		generateUnitaryConditionReportPDF($_POST,$filename,$form_id,$entry_id);
	}
	if($Form_id == "75"){
		//$date =date('YmdHis');
		$filename = 'RWC'.date('YmdHis').'.pdf';
		generateRentalWaterCooledPDF($_POST,$filename,$form_id,$entry_id);
	}
	if($Form_id == "77"){
		//$date =date('YmdHis');
		$filename = 'RTMB '.date('YmdHis').'.pdf';
		generateRoofTopMobileBuilddPDF($_POST,$filename,$form_id,$entry_id);
	}
	if($Form_id == "76"){
		//$date =date('YmdHis');
		$filename = 'CTMB '.date('YmdHis').'.pdf';
		generateCoolingTowerMobileBuildPDF($_POST,$filename,$form_id,$entry_id);
	}
	if($Form_id == "69"){
		//$date =date('YmdHis');
		$filename = 'ACC'.date('YmdHis').'.pdf';
		generateAirCooledChillerPDF($_POST,$filename,$form_id,$entry_id);
	}
}

add_action( 'vfbp_after_email', 'filter_vfbp_after_email', 10, 2 );
 
function filter_vfbp_after_email( $entry_id, $form_id ) {
    PurgeFieldFormEntries($form_id,$entry_id,$_POST);
}


function PurgeFieldFormEntries($form_id,$entry_id,$POSTData){
	/*$root = $_SERVER['DOCUMENT_ROOT'];
	$data = $form_id.'---'.$entry_id.'-----'.json_encode($POSTData);
	$num = time().mt_rand(99,9999);
	$fp = fopen($root.'/wp-content/uploads/SaveEntryfile_'.$num.'.txt','w+');
	fwrite($fp,$data);
	fclose($fp); */ 
	
	$USERID = get_current_user_id();
	global $wpdb;
	$results = $wpdb->get_row( "SELECT FieldsIds FROM ".$wpdb->prefix . "PurgeFields WHERE FormId='$form_id'", OBJECT );
	$FormData = $wpdb->get_results("select * from pkh_vfbp_fields WHERE form_id =$form_id");
	$EmailDesign = $wpdb->get_results("select * from pkh_vfbp_formmeta WHERE form_id = $form_id and meta_key = 'email-template'");
	$EmailHtml = $EmailDesign[0]->meta_value;
	$EmailHtml = str_replace('</tr>',PHP_EOL,$EmailHtml);
	$EmailHtml = strip_tags($EmailHtml);
	$EmailHtml = explode(PHP_EOL,$EmailHtml);
	
	foreach($EmailHtml as $da){
		if(strpos($da,":") !== FALSE){
			$da = str_replace('[entry:Field','',$da);
			$emailarray[] = $da;
		}
	}
	$newEmailarray = array();
	foreach($emailarray as $JSON){
		$explodedVal = explode(':',$JSON);
		$value = $explodedVal[1];
		$value = str_replace(']','',$value);
		$value = str_replace(' ','',$value);
		$newEmailarray[] = intval($value);
	}
	
	$FieldIDs = array();
	$FieldIDLabels = array();
	foreach($FormData as $data){
			$serialized_data = $data->data;
			$var1 = unserialize($serialized_data);
			$newarray[$var1['label']] = array('id'=>$data->id,'type'=>$data->field_type);
			$FieldIDs[] = $data->id;
			$FieldIDLabels[$data->id] = $var1['label'];
	}
	
	$TempArray = array();
	asort($newEmailarray);
	asort($FieldIDs);
	if(!empty($FieldIDs)){
		foreach($FieldIDs as $Fields){
			if(in_array($Fields,$newEmailarray)){
				if(is_array($POSTData['vfb-field-'.$Fields])){
					$POSTData['vfb-field-'.$Fields] = implode(',',$POSTData['vfb-field-'.$Fields]);

				}
				$explodedValTxt =   trim($POSTData['vfb-field-'.$Fields]);
				$explodedValTxt = str_replace("\n", ' ', $explodedValTxt);
				$explodedValTxt = str_replace("\r", ' ', $explodedValTxt);
				$explodedValTxt = str_replace(PHP_EOL, ' ', $explodedValTxt);
				
				$TempArray[str_replace("'",'###',$FieldIDLabels[$Fields])] = $explodedValTxt;
			}
		}
		$TempArray = json_encode($TempArray);
		$wpdb->query("INSERT INTO pkh_temp_submission SET Entryid = $entry_id,FormID = '$form_id', userid = '$USERID',entrydata='$TempArray'");
	}
	
	if(!empty($results)){
		$PurgeIDS = json_decode($results->FieldsIds,true);
		foreach($FieldIDs as $Fields){
			if(!in_array($Fields,$PurgeIDS)){
				$wpdb->query("DELETE from pkh_postmeta WHERE post_id = $entry_id AND meta_key = '_vfb_field-".$Fields."'");
			}
		}
	}	
	$meta = get_userdata($USERID);
	
	$roles = $meta->roles;
	$first_name = $meta->first_name;
	$last_name = $meta->last_name;
	$usersRoles = array();
	foreach($roles as $role){
		$usersRoles[] = "'".$role."'";	
	}
	$users_roles = implode(",",$usersRoles);
	
	$Data = $wpdb->get_results("SELECT parent_role from pkh_vfbform_roles_parents WHERE role IN ($users_roles)");
	
	
	$ParentRole = array();
	$AllUSERIDS = array();

	foreach($Data as $Childrole){
		$ParentRole[] = $Childrole->parent_role;
	}
	
	foreach($ParentRole as $SelectedRole){
		$args2 = array(
			'role' =>$SelectedRole
		);
		$authors = get_users($args2);
		foreach ($authors as $user) {
			$AllUSERIDS[] =  "'".$user->ID."'";
		}
	}
	$Parent_rolesUserIDs = implode(",",$AllUSERIDS);
	
	$Formtitle = $wpdb->get_row("select title from pkh_vfbp_forms WHERE id = '$form_id'");
	
	$notifiyID = '';
	$title = $Formtitle->title;
	$Message = 'Submitted By '.$first_name.' '.$last_name;
	Web_push_notification_parent($Parent_rolesUserIDs,$notifiyID,$title,$Message);
	
}

function generateParkingTicketPDF($data,$filename,$form_id,$entry_id){
	/* wp_mail('ritusharma902@gmail.com','querySubject',json_encode($data), $headers, $attachments );
	die; */
	
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;
	$Currentdate = date('jS \d\a\y \of F, Y');
	$Infraction = $data['vfb-field-6506'];
	$magirate = $data['vfb-field-6514'];
	$Mitigating_Facts = wordwrap($magirate, 90, '<br />');
	$InfraDate = $data['vfb-field-6501'];
	$stringPosslash = strpos($InfraDate,"/");
	$stringPosHi = strpos($InfraDate,"-");
	
	if($stringPosslash !== false){
		$Infractiondate = explode('/',$InfraDate);
		$MM = $Infractiondate[0];
		$DD = $Infractiondate[1];
		$YYYY = $Infractiondate[2];
	}else if($stringPosHi !== false){
		$Infractiondate = explode('-',$InfraDate);
		$MM = $Infractiondate[1];
		$DD = $Infractiondate[2];
		$YYYY = $Infractiondate[0];
	}
	
	$InfractionKey = 0;
	foreach($Infraction as $K=>$V){
		$InfractionKey = $K;
	}
	switch($InfractionKey){
		case 0 :
		$InfractionKey = '<b>Double Parked </b>: I stopped after traversing the area and found no less restrictive spot available.  There was <br/> no curb space available for over 100 feet in either direction due to legally parked vehicles. Parking was <br/> legal at  the  curb.  I expeditiously completed my work and left.';
		break;
		case 1 :
		$InfractionKey = '<b>Traffic Lane </b>:I stopped after traversing the area and double parked. There was no less restrictive spot available.<br/> There was no curb space available for over 100 feet in either direction due to  legally parked vehicles. My vehicle <br/> was not over 8 feet from the curb.  More than 10 feet was available for the free flow of traffic.I expeditiously <br/> finished my work and left.';
		break;
		case 2 :
		$InfractionKey = '<b>No Standing </b>: Except Trucks : I stopped after traversing the area and found no less restrictive spot available. <br/> I expeditiously completed my emergency repair work and left.';
		break;
		case 3 :
		$InfractionKey = '<b>No Parking </b>:  I stopped after traversing the area and found no less restrictive spot available. I expeditiously <br/> completed my work and left.';
		break;
		case 4 :
		$InfractionKey = '<b>Muni Meter Receipt</b>:
				I parked my vehicle, and purchased a muni meter receipt.  I immediately returned to my <br/> vehicle and properly displayed the receipt face-up on my dashboard.  A valid receipt was  properly displayed on <br/>my dashboard until I left the above location.  Attached is/are a copy of the receipt(s).';
		break;
		case 5:
		$InfractionKey = '<b>Registration: </b>: Attached is a copy of the vehicle registration.';
		break;
		case 6 :
		$InfractionKey = '<b>Inspection </b>:Attached is a copy of the vehicle inspection receipt.';
		break;
		case 7 :
		$InfractionKey = '<b>Other(describe the violation and circumstances)</b>:'.$data['vfb-field-6512'];
		break;
		
	}
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;
	
	$root = $_SERVER['DOCUMENT_ROOT'];
	$pdfClass = $root . "/html2pdf/html2pdf.class.php";
	require_once($pdfClass);
	
	ob_start();
	include($root .'/ParkingForms/pon.html');
	$content = ob_get_clean();
	$content = str_replace("[employername]",$display_name,$content);
	$content = str_replace("[LICENSEPLATE]",$data['vfb-field-8543'],$content);
	$content = str_replace("[Infraction_Date]",$data['vfb-field-6501'],$content);
	$content = str_replace("[Customer_Name]",$data['vfb-field-6502'],$content);
	$content = str_replace("[Customer_Address_1]",$data['vfb-field-6503'],$content);
	/* $content = str_replace("[Customer_Address_2]",$data['vfb-field-6656']['address-2'].' '.$data['vfb-field-6656']['country'],$content); */
	$content = str_replace("[Arrival_Time]",$data['vfb-field-6504'],$content);
	$content = str_replace("[MM]",$MM,$content);
	$content = str_replace("[DD]",$DD,$content);
	$content = str_replace("[YYYY]",$YYYY,$content);
	$content = str_replace("[Departure_Time]",$data['vfb-field-6505'],$content);
	$content = str_replace("[InfractionKey]",$InfractionKey,$content);
	if($data['vfb-field-6513'] == 'Yes'){
		$content = str_replace("[Mitigating_Facts]",'Mitigating Facts : '.$Mitigating_Facts,$content);
	}else{
		$content = str_replace("[Mitigating_Facts]",'',$content);
	}
	$content = str_replace("[currentDate]",$Currentdate,$content);
	if($data['vfb-field-6518']!=""){
		$content = str_replace("[Signature]",'<div style="position: absolute;bottom: 140px; left: 10px;width:200px;">	
	<div style="padding-left:50px;font-size:15px;">Signature</div><div><img height="60" width="300" src="'.$data['vfb-field-6518'].'"></div></div>',$content);
	}else{
		$content = str_replace("[Signature]",'<div style="position: absolute;bottom: 150px;width:300px;border-bottom:1px solid #000;padding-bottom:60px;"><div style="font-size:15px; padding-left:30px;">Signature</div></div>',$content);
	}
	$moreattachments = getEntryAttachmentDetailsForParkingTicket($entry_id);
	
	$PDFattachments = '';
	$pdfFilePath = $root.'/Parking_Ticket/'.$filename;
	$attachments = array($pdfFilePath);
	$exts = '';
	foreach($moreattachments as $moreattachment){
		$filetype = wp_check_filetype($moreattachment);
		$exts = $exts .' F--- '.$moreattachment.' - '.$filetype['ext'];
		if(strtolower($filetype['ext']) == 'jpg' || strtolower($filetype['ext']) == 'jpeg' || strtolower($filetype['ext']) == 'png'){
			$PDFattachments = $PDFattachments.'<img style="height:auto;"  width="600" src="'.$moreattachment.'">';
		}else{
			$attachments[] = $moreattachment;
		}
	}
	$content = str_replace("[attachment_1]",$PDFattachments,$content);
	$html2pdf = new HTML2PDF('P','A4','en');
    $html2pdf->WriteHTML($content);
    $pdfdoc = $html2pdf->Output('Parking_Ticket/'.$filename,'F');
	
	
	global $wpdb;
	$queryEmailTo = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'email-to' AND form_id =".$form_id, OBJECT );
	$queryEmailTo = $queryEmailTo[0]->meta_value;
	
	$querySubject = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'subject' AND form_id =".$form_id, OBJECT );
	$querySubject = $querySubject[0]->meta_value .' - '. strtoupper($filename);

	wp_mail( $queryEmailTo, $querySubject,$querySubject, $headers, $attachments );
	wp_mail( $data['vfb-field-6521'], $querySubject,$querySubject, $headers, $attachments );
	$AllAttachments = array_merge($attachments,$moreattachments);
	foreach($AllAttachments as $allattachments){
		@unlink($allattachments);
	}
}

function getEntryAttachmentDetailsForParkingTicket($id){
	$attachments = array();
	$root = $_SERVER['DOCUMENT_ROOT'];
	$postmeta = get_post_meta($id,"_vfb_field-6507");
	
	if(!empty($postmeta) && is_array($postmeta)){
		foreach($postmeta as $post){
			if($post !=""){
				$home = 'https://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$home = 'http://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$attachments[] = $post;
			}
		}
	}
	$postmeta = get_post_meta($id,"_vfb_field-6510");
	
	if(!empty($postmeta) && is_array($postmeta)){
		foreach($postmeta as $post){
			if($post !=""){
				$home = 'https://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$home = 'http://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$attachments[] = $post;
			}
		}
	}
	$postmeta = get_post_meta($id,"_vfb_field-6508");
	
	if(!empty($postmeta) && is_array($postmeta)){
		foreach($postmeta as $post){
			if($post !=""){
				$home = 'https://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$home = 'http://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$attachments[] = $post;
			}
		}
	}
	$postmeta = get_post_meta($id,"_vfb_field-6509");
	
	if(!empty($postmeta) && is_array($postmeta)){
		foreach($postmeta as $post){
			if($post !=""){
				$home = 'https://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$home = 'http://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$attachments[] = $post;
			}
		}
	}
	
	$postmeta = get_post_meta($id,"_vfb_field-6511");
	
	if(!empty($postmeta) && is_array($postmeta)){
		foreach($postmeta as $post){
			if($post !=""){
				$home = 'https://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$home = 'http://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$attachments[] = $post;
			}
		}
	}
	return $attachments;
}

function generateParkingovernightTicketPDF($data,$filename,$form_id,$entry_id){
	/* wp_mail('ritusharma902@gmail.com','querySubject',json_encode($data), $headers, $attachments );
	die; */
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;
	$Currentdate = date('jS \d\a\y \of F, Y');
	$Infractiondate = strtotime($data['vfb-field-6532']);
	$InfractionType = $data['vfb-field-6537'];
	$MM=date('m',$Infractiondate);
	$DD=date('d',$Infractiondate);
	$YYYY=date('Y',$Infractiondate);
	$InfractionKey_Type = 0;
	foreach($InfractionType as $K=>$V){
		$InfractionKey_Type = $K;
	}
	switch($InfractionKey_Type){
		case 0 :
		$InfractionKey_Type = 'No Standing';
		break;
		case 1 :
		$InfractionKey_Type = 'No Parking';
		break;
	}
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;
	
	$root = $_SERVER['DOCUMENT_ROOT'];
	$pdfClass = $root . "/html2pdf/html2pdf.class.php";
	require_once($pdfClass);
	
	ob_start();
	include($root .'/ParkingForms/OvernightAffirmation.html');
	$content = ob_get_clean();
	$content = str_replace("[EmployeeName]",$display_name,$content);
	$content = str_replace("[Customer_Name]",$data['vfb-field-6533'],$content);
	$content = str_replace("[Infraction_Type]",$InfractionKey_Type,$content);
	$content = str_replace("[ATime]",$data['vfb-field-6535'],$content);
	$content = str_replace("[MM]",$MM,$content);
	$content = str_replace("[DD]",$DD,$content);
	$content = str_replace("[YYYY]",$YYYY,$content);
	$content = str_replace("[Dtime]",$data['vfb-field-6536'],$content);
	if($data['vfb-field-6542']!=""){
	$content = str_replace("[signed]",'<tr><td style="width:720px;padding-left:95px;font-size:17px;padding-top:30px;"><table><tr><td>Signed:</td><td><img height="60" width="300" src="'.$data['vfb-field-6542'].'"></td></tr> </table></td></tr>',$content);
	}else{
		$content = str_replace("[signed]",'<tr><td style="width:720px;padding-left:95px;padding-top:40px;font-size:17px"><table><tr><td>Signed:</td><td style="width:300px;border-bottom:1px solid #000;"></td></tr> </table></td></tr>',$content);
	}
	$moreattachments = getEntryAttachmentDetailsForParkingOvernightTicket($entry_id);
	$PDFattachments = '';
	$pdfFilePath = $root.'/Parking_OvernightAffirmation_Ticket/'.$filename;
	$attachments = array($pdfFilePath);
	$fp = fopen($root.'/Parking_OvernightAffirmation_Ticket/ex.txt','w+');
	fwrite($fp, json_encode($moreattachments));
	fclose($fp);
	
	foreach($moreattachments as $moreattachment){
		$filetype = wp_check_filetype($moreattachment);
		if(strtolower($filetype['ext']) == 'jpg' || strtolower($filetype['ext']) == 'jpeg' || strtolower($filetype['ext']) == 'png'){
			$PDFattachments = $PDFattachments.'<img style="height:auto;"  width="600" src="'.$moreattachment.'">';
		}else{
			$attachments[] = $moreattachment;
		}
	}
	
	$content = str_replace("[attachment_1]",$PDFattachments,$content);
	
	$html2pdf = new HTML2PDF('P','A4','en');
    $html2pdf->WriteHTML($content);
    $pdfdoc = $html2pdf->Output('Parking_OvernightAffirmation_Ticket/'.$filename,'F');
	global $wpdb;
	
	$queryEmailTo = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'email-to' AND form_id =".$form_id, OBJECT );
	$queryEmailTo = $queryEmailTo[0]->meta_value;
	
	$querySubject = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'subject' AND form_id =".$form_id, OBJECT );
	$querySubject = $querySubject[0]->meta_value .' - '. strtoupper($filename);

	wp_mail( $queryEmailTo, $querySubject,' ', $headers, $attachments );
	wp_mail( $data['vfb-field-6545'], $querySubject,' ', $headers, $attachments );
	$AllAttachments = array_merge($attachments,$moreattachments);
	 foreach($AllAttachments as $allattachments){
		@unlink($allattachments);
	}
}
function getEntryAttachmentDetailsForParkingOvernightTicket($id){
	$attachments = array();
	$root = $_SERVER['DOCUMENT_ROOT'];
	$postmeta = get_post_meta($id,"_vfb_field-6538");
	if(!empty($postmeta) && is_array($postmeta)){
		foreach($postmeta as $post){
			if($post !=""){
				$home = 'https://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$home = 'http://serviceapp.onetrane.ca';
				$post = str_replace($home,$root,$post);
				$attachments[] = $post;
			}
		}
	}
	return $attachments;
}
function generateRentalWaterCooledPDF($data,$filename,$form_id,$entry_id){
	$adress = implode($data['vfb-field-6292'],',');
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;

	$root = $_SERVER['DOCUMENT_ROOT'];
	$pdfClass = $root . "/html2pdf/html2pdf.class.php";
	require_once($pdfClass);
	
	ob_start();
	include($root .'/RentalsPDF/water_cooled.html');
	$content = ob_get_clean();
	$content = str_replace("[RENTL_PRIO]",$data['vfb-field-6404'],$content);
	$content = str_replace("[TARGET_SDATE]",$data['vfb-field-6405'],$content);
	$content = str_replace("[RENTL_DUR]",$data['vfb-field-6406'],$content);
	$content = str_replace("[tech]",$data['vfb-field-8427'],$content);
	$content = str_replace("[Sub_email]",$data['vfb-field-6310'],$content);
	$content = str_replace("[Sub_phone]",$data['vfb-field-9396'],$content);
	$content = str_replace("[y/n]",$data['vfb-field-6288'],$content);
	$content = str_replace("[NAME]",$data['vfb-field-6289'],$content);
	$content = str_replace("[CUS_CON_NAME]",$data['vfb-field-6290'],$content);
	$content = str_replace("[CUS_EMAIL]",$data['vfb-field-6291'],$content);
	$content = str_replace("[ADDRESS]",$adress,$content);
	$content = str_replace("[OTR]",$data['vfb-field-6402'],$content);
	$content = str_replace("[N/D]",$data['vfb-field-6295'],$content);
	$content = str_replace("[EVAP_ENT]",$data['vfb-field-6296'],$content);
	$content = str_replace("[EVAP_LEA]",$data['vfb-field-6297'],$content);
	$content = str_replace("[BCM]",$data['vfb-field-6298'],$content);
	$content = str_replace("[size_taps]",$data['vfb-field-6315'],$content);
	$content = str_replace("[%SOL]",$data['vfb-field-6549'],$content);
	$content = str_replace("[CONDN_ENT]",$data['vfb-field-6316'],$content);
	$content = str_replace("[CONDN_LEA]",$data['vfb-field-6317'],$content);
	$content = str_replace("[REN_PMP]",$data['vfb-field-6300'],$content);
	$content = str_replace("[HPR]",$data['vfb-field-6321'],$content);
	$content = str_replace("[RCT]",$data['vfb-field-6320'],$content);
	$content = str_replace("[CT_LOC]",$data['vfb-field-6301'],$content);
	$content = str_replace("[EVAPSIZE_TAP]",$data['vfb-field-6319'],$content);
	$content = str_replace("[CHILR__TAPS_LOC]",$data['vfb-field-6302'],$content);
	$content = str_replace("[ELBOWS]",$data['vfb-field-6483'],$content);
	$content = str_replace("[CHLR_LOC]",$data['vfb-field-6322'],$content);
	$content = str_replace("[GEN]",$data['vfb-field-6318'],$content);
	$content = str_replace("[SUP_VOL]",$data['vfb-field-6305'],$content);
	$content = str_replace("[AMPS]",$data['vfb-field-6306'],$content);
	$content = str_replace("[TRANSFORMER]",$data['vfb-field-6323'],$content);
	$content = str_replace("[BAS_SYS]",$data['vfb-field-6308'],$content);
	$content = str_replace("[CHRG_INSTL]",$data['vfb-field-6309'],$content);
	$content = str_replace("[NOTES]",$data['vfb-field-6311'],$content);
	
	$moreattachments = array();
	$PDFattachments = '';
	$pdfFilePath = $root.'/RentalsPDF/'.$filename;
	$attachments = array($pdfFilePath);
	
	
	$html2pdf = new HTML2PDF('P','A4','en');
    $html2pdf->WriteHTML($content);
    $pdfdoc = $html2pdf->Output('RentalsPDF/'.$filename,'F');
	global $wpdb;
	
	$queryEmailTo = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'email-to' AND form_id =".$form_id, OBJECT );
	$queryEmailTo = $queryEmailTo[0]->meta_value;
	
	$querySubject = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'subject' AND form_id =".$form_id, OBJECT );
	$querySubject = $querySubject[0]->meta_value .' - '. strtoupper($filename);

	wp_mail( $queryEmailTo, $querySubject,' ', $headers, $attachments );
	
	$AllAttachments = array_merge($attachments,$moreattachments);
	 foreach($AllAttachments as $allattachments){
		@unlink($allattachments);
	}
	
	
}
function generateRoofTopMobileBuilddPDF($data,$filename,$form_id,$entry_id){
	$adress = implode($data['vfb-field-6369'],',');
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;

	$root = $_SERVER['DOCUMENT_ROOT'];
	$pdfClass = $root . "/html2pdf/html2pdf.class.php";
	require_once($pdfClass);
	
	ob_start();
	include($root .'/RentalsPDF/RoofTop_MobileBuild.html');
	$content = ob_get_clean();
	$content = str_replace("[RENTL_PRIO]",$data['vfb-field-6408'],$content);
	$content = str_replace("[TARGET_SDATE]",$data['vfb-field-6409'],$content);
	$content = str_replace("[RENTL_DUR]",$data['vfb-field-6411'],$content);
	$content = str_replace("[tech]",$data['vfb-field-8425'],$content);
	$content = str_replace("[Sub_email]",$data['vfb-field-6393'],$content);
	$content = str_replace("[Sub_phone]",$data['vfb-field-9395'],$content);
	$content = str_replace("[y/n]",$data['vfb-field-6365'],$content);
	$content = str_replace("[NAME]",$data['vfb-field-6366'],$content);
	$content = str_replace("[CUS_CON_NAME]",$data['vfb-field-6367'],$content);
	$content = str_replace("[CUS_EMAIL]",$data['vfb-field-6368'],$content);
	$content = str_replace("[ADDRESS]",$adress,$content);
	$content = str_replace("[OVRAL_TONN]",$data['vfb-field-6407'],$content);
	$content = str_replace("[EXPEC_LEAV]",$data['vfb-field-6374'],$content);
	$content = str_replace("[USIN_100%/RTRN]",$data['vfb-field-6375'],$content);
	$content = str_replace("[AAT]",$data['vfb-field-6382'],$content);
	$content = str_replace("[BPS_LOC]",$data['vfb-field-6385'],$content);
	$content = str_replace("[GENRTR]",$data['vfb-field-6386'],$content);
	$content = str_replace("[SUP_VOL]",$data['vfb-field-6387'],$content);
	$content = str_replace("[TRNFRMR]",$data['vfb-field-6388'],$content);
	$content = str_replace("[AMPS]",$data['vfb-field-6389'],$content);
	$content = str_replace("[AIR_PLENUM]",$data['vfb-field-6384'],$content);
	$content = str_replace("[SPEC_CFM]",$data['vfb-field-6398'],$content);
	$content = str_replace("[ECOMINZ]",$data['vfb-field-6379'],$content);
	$content = str_replace("[FROM_HEAT2COOL]",$data['vfb-field-6383'],$content);
	$content = str_replace("[STANDALONE]",$data['vfb-field-6390'],$content);
	$content = str_replace("[BAS_SYS]",$data['vfb-field-6391'],$content);
	$content = str_replace("[CHRG_INSTL]",$data['vfb-field-6392'],$content);
	$content = str_replace("[NOTES]",$data['vfb-field-6394'],$content);
	
	$moreattachments = array();
	$PDFattachments = '';
	$pdfFilePath = $root.'/RentalsPDF/'.$filename;
	$attachments = array($pdfFilePath);
	
	
	$html2pdf = new HTML2PDF('P','A4','en');
    $html2pdf->WriteHTML($content);
    $pdfdoc = $html2pdf->Output('RentalsPDF/'.$filename,'F');
	global $wpdb;
	
	$queryEmailTo = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'email-to' AND form_id =".$form_id, OBJECT );
	$queryEmailTo = $queryEmailTo[0]->meta_value;
	
	$querySubject = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'subject' AND form_id =".$form_id, OBJECT );
	$querySubject = $querySubject[0]->meta_value .' - '. strtoupper($filename);

	wp_mail( $queryEmailTo, $querySubject,' ', $headers, $attachments );
	
	$AllAttachments = array_merge($attachments,$moreattachments);
	 foreach($AllAttachments as $allattachments){
		@unlink($allattachments);
	}
	
	
}
function generateCoolingTowerMobileBuildPDF($data,$filename,$form_id,$entry_id){
	$adress = implode($data['vfb-field-6332'],',');
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;

	$root = $_SERVER['DOCUMENT_ROOT'];
	$pdfClass = $root . "/html2pdf/html2pdf.class.php";
	require_once($pdfClass);
	
	ob_start();
	include($root .'/RentalsPDF/Cooling_tower.html');
	$content = ob_get_clean();
	$content = str_replace("[RENTL_PRIO]",$data['vfb-field-6413'],$content);
	$content = str_replace("[TARGET_SDATE]",$data['vfb-field-6414'],$content);
	$content = str_replace("[RENTL_DUR]",$data['vfb-field-6415'],$content);
	$content = str_replace("[tech]",$data['vfb-field-8426'],$content);
	$content = str_replace("[Sub_email]",$data['vfb-field-6356'],$content);
	$content = str_replace("[Sub_phone]",$data['vfb-field-9394'],$content);
	$content = str_replace("[y/n]",$data['vfb-field-6328'],$content);
	$content = str_replace("[NAME]",$data['vfb-field-6329'],$content);
	$content = str_replace("[CUS_CON_NAME]",$data['vfb-field-6330'],$content);
	$content = str_replace("[CUS_EMAIL]",$data['vfb-field-6331'],$content);
	$content = str_replace("[ADDRESS]",$adress,$content);
	$content = str_replace("[OPN_CLSD_TOWER]",$data['vfb-field-6335'],$content);
	$content = str_replace("[OVRAL_TONGE]",$data['vfb-field-6412'],$content);
	$content = str_replace("[EXPEC_LEAV]",$data['vfb-field-6337'],$content);
	$content = str_replace("[EXPEC_ENT]",$data['vfb-field-6336'],$content);
	$content = str_replace("[DRY_BLB_TEM]",$data['vfb-field-6339'],$content);
	$content = str_replace("[WET_BLB_TEMP]",$data['vfb-field-6340'],$content);
	$content = str_replace("[FLW_RTE]",$data['vfb-field-6347'],$content);
	$content = str_replace("[RNTL_PMP]",$data['vfb-field-6342'],$content);
	$content = str_replace("[HPR]",$data['vfb-field-6343'],$content);
	$content = str_replace("[COOLIN_TOWER_LOC]",$data['vfb-field-6348'],$content);
	$content = str_replace("[CT_LOC]",$data['vfb-field-6345'],$content);
	$content = str_replace("[ELBOWS]",$data['vfb-field-6484'],$content);
	$content = str_replace("[SIZ_TAPS]",$data['vfb-field-6346'],$content);
	$content = str_replace("[ENGH_SPACE]",$data['vfb-field-6354'],$content);
	$content = str_replace("[CHRG_INSTL]",$data['vfb-field-6355'],$content);
	$content = str_replace("[NOTES]",$data['vfb-field-6357'],$content);
	
	$moreattachments = array();
	$PDFattachments = '';
	$pdfFilePath = $root.'/RentalsPDF/'.$filename;
	$attachments = array($pdfFilePath);
	
	
	$html2pdf = new HTML2PDF('P','A4','en');
    $html2pdf->WriteHTML($content);
    $pdfdoc = $html2pdf->Output('RentalsPDF/'.$filename,'F');
	global $wpdb;
	
	$queryEmailTo = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'email-to' AND form_id =".$form_id, OBJECT );
	$queryEmailTo = $queryEmailTo[0]->meta_value;
	
	$querySubject = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'subject' AND form_id =".$form_id, OBJECT );
	$querySubject = $querySubject[0]->meta_value .' - '. strtoupper($filename);

	wp_mail( $queryEmailTo, $querySubject,' ', $headers, $attachments );
	
	$AllAttachments = array_merge($attachments,$moreattachments);
	 foreach($AllAttachments as $allattachments){
		@unlink($allattachments);
	}
	
	
}
function generateAirCooledChillerPDF($data,$filename,$form_id,$entry_id){
	$adress = implode($data['vfb-field-6259'],',');
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;

	$root = $_SERVER['DOCUMENT_ROOT'];
	$pdfClass = $root . "/html2pdf/html2pdf.class.php";
	require_once($pdfClass);
	
	ob_start();
	include($root .'/RentalsPDF/AIRCOOLEDCHILLERRENTAL.html');
	$content = ob_get_clean();
	$content = str_replace("[RENTL_PRIO]",$data['vfb-field-6399'],$content);
	$content = str_replace("[TARGET_SDATE]",$data['vfb-field-6400'],$content);
	$content = str_replace("[RENTL_DUR]",$data['vfb-field-6401'],$content);
	$content = str_replace("[tech]",$data['vfb-field-8428'],$content);
	$content = str_replace("[Sub_email]",$data['vfb-field-6129'],$content);
	$content = str_replace("[Sub_phone]",$data['vfb-field-9393'],$content);
	$content = str_replace("[y/n]",$data['vfb-field-6152'],$content);
	$content = str_replace("[NAME]",$data['vfb-field-6260'],$content);
	$content = str_replace("[CUS_CON_NAME]",$data['vfb-field-6115'],$content);
	$content = str_replace("[CUS_EMAIL]",$data['vfb-field-6116'],$content);
	$content = str_replace("[ADDRESS]",$adress,$content);
	$content = str_replace("[OVRAL_TONN]",$data['vfb-field-6403'],$content);
	$content = str_replace("[N/D]",$data['vfb-field-6137'],$content);
	$content = str_replace("[ENT_WTR_TMP]",$data['vfb-field-6138'],$content);
	$content = str_replace("[LEA_WTR_TEMP]",$data['vfb-field-6139'],$content);
	$content = str_replace("[BCM]",$data['vfb-field-6151'],$content);
	$content = str_replace("[%SOL]",$data['vfb-field-6140'],$content);
	$content = str_replace("[RNTL_PMP]",$data['vfb-field-6141'],$content);
	$content = str_replace("[HPR]",$data['vfb-field-6142'],$content);
	$content = str_replace("[CHIL_LOC]",$data['vfb-field-6143'],$content);
	$content = str_replace("[ELOBOWS]",$data['vfb-field-6420'],$content);
	$content = str_replace("[SIZE_TAPS]",$data['vfb-field-6144'],$content);
	$content = str_replace("[CHIL_LOC]",$data['vfb-field-6145'],$content);
	$content = str_replace("[SUP_VOL]",$data['vfb-field-6146'],$content);
	$content = str_replace("[AMPS]",$data['vfb-field-6147'],$content);
	$content = str_replace("[2SEP_SRC]",$data['vfb-field-6148'],$content);
	$content = str_replace("[BAS_SYS]",$data['vfb-field-6149'],$content);
	$content = str_replace("[CHRG_INSTL]",$data['vfb-field-6150'],$content);
	$content = str_replace("[NOTES]",$data['vfb-field-6131'],$content);
	
	$moreattachments = array();
	$PDFattachments = '';
	$pdfFilePath = $root.'/RentalsPDF/'.$filename;
	$attachments = array($pdfFilePath);
	
	
	$html2pdf = new HTML2PDF('P','A4','en');
    $html2pdf->WriteHTML($content);
    $pdfdoc = $html2pdf->Output('RentalsPDF/'.$filename,'F');
	global $wpdb;
	
	$queryEmailTo = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'email-to' AND form_id =".$form_id, OBJECT );
	$queryEmailTo = $queryEmailTo[0]->meta_value;
	
	$querySubject = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'subject' AND form_id =".$form_id, OBJECT );
	$querySubject = $querySubject[0]->meta_value .' - '. strtoupper($filename);

	wp_mail( $queryEmailTo, $querySubject,' ', $headers, $attachments );
	
	$AllAttachments = array_merge($attachments,$moreattachments);
	 foreach($AllAttachments as $allattachments){
		@unlink($allattachments);
	}
	
	
}
function generateUnitaryConditionReportPDF($data,$filename,$form_id,$entry_id){
		
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;
	
	global $current_user;
	$phoneno = $current_user->user_login;
	$display_name = $current_user->display_name;
	$user_email = $current_user->user_email;
	
	$root = $_SERVER['DOCUMENT_ROOT'];
	$pdfClass = $root . "/html2pdf/html2pdf.class.php";
	require_once($pdfClass);
	
	ob_start();
	include($root .'/unitary/unitary.html');
	$content = ob_get_clean();
	$content = str_replace("[REPORT_DATE]",$data['vfb-field-8118'],$content);
	$content = str_replace("[Ticket_Number]",$data['vfb-field-7525'],$content);
	$content = str_replace("[PartSource_Location]",$data['vfb-field-7526'],$content);
	$content = str_replace("[Equipment_Name]",$data['vfb-field-7527'],$content);
	$content = str_replace("[Heating_Type]",$data['vfb-field-7988'],$content);
	$content = str_replace("[Model_Number]",$data['vfb-field-7528'],$content);
	$content = str_replace("[Cooling_Type]",$data['vfb-field-7989'],$content);
	$content = str_replace("[Serail_Number]",$data['vfb-field-7529'],$content);
	$content = str_replace("[Refrigerant]",$data['vfb-field-7532'],$content);
	$content = str_replace("[Manufacturer]",$data['vfb-field-7990'],$content);
	$content = str_replace("[Leaks_Repair_Required]",$data['vfb-field-7533'],$content);
	$content = str_replace("[Equipment_Type]",$data['vfb-field-7531'],$content);
	$content = str_replace("[FILTR_TYPE_1]",$data['vfb-field-7984'],$content);
	$content = str_replace("[FILTR_TYPE_2]",$data['vfb-field-8078'],$content);
	$content = str_replace("[FILTR_TYPE_3]",$data['vfb-field-8079'],$content);
	$content = str_replace("[QTY_1]",$data['vfb-field-8046'],$content);
	$content = str_replace("[QTY_2]",$data['vfb-field-8059'],$content);
	$content = str_replace("[QTY_3]",$data['vfb-field-8060'],$content);
	$content = str_replace("[LXIN_1]",$data['vfb-field-8041'],$content);
	$content = str_replace("[LXIN_2]",$data['vfb-field-8064'],$content);
	$content = str_replace("[LXIN_3]",$data['vfb-field-8065'],$content);
	$content = str_replace("[WXIN_1]",$data['vfb-field-8043'],$content);
	$content = str_replace("[WXIN_2]",$data['vfb-field-8069'],$content);
	$content = str_replace("[WXIN_3]",$data['vfb-field-8068'],$content);
	$content = str_replace("[HXIN_1]",$data['vfb-field-8042'],$content);
	$content = str_replace("[HXIN_2]",$data['vfb-field-8084'],$content);
	$content = str_replace("[HXIN_3]",$data['vfb-field-8083'],$content);
	$content = str_replace("[FILTR_TYPE_4]",$data['vfb-field-8077'],$content);
	$content = str_replace("[FILTR_TYPE_5]",$data['vfb-field-8076'],$content);
	$content = str_replace("[FILTR_TYPE_6]",$data['vfb-field-8075'],$content);
	$content = str_replace("[QTY_4]",$data['vfb-field-8058'],$content);
	$content = str_replace("[QTY_5]",$data['vfb-field-8057'],$content);
	$content = str_replace("[QTY_6]",$data['vfb-field-8056'],$content);
	$content = str_replace("[LXIN_4]",$data['vfb-field-8061'],$content);
	$content = str_replace("[LXIN_5]",$data['vfb-field-8062'],$content);
	$content = str_replace("[LXIN_6]",$data['vfb-field-8063'],$content);
	$content = str_replace("[WXIN_4]",$data['vfb-field-8070'],$content);
	$content = str_replace("[WXIN_5]",$data['vfb-field-8067'],$content);
	$content = str_replace("[WXIN_6]",$data['vfb-field-8066'],$content);
	$content = str_replace("[HXIN_4]",$data['vfb-field-8082'],$content);
	$content = str_replace("[HXIN_5]",$data['vfb-field-8081'],$content);
	$content = str_replace("[HXIN_6]",$data['vfb-field-8080'],$content);
	$content = str_replace("[BELTS_QTY_1]",$data['vfb-field-8048'],$content);
	$content = str_replace("[BELTS_QTY_2]",$data['vfb-field-8052'],$content);
	$content = str_replace("[BELT_LENGTH_1]",$data['vfb-field-8051'],$content);
	$content = str_replace("[BELT_LENGTH_2]",$data['vfb-field-8053'],$content);
	$content = str_replace("[BELT_TYPE_1]",$data['vfb-field-8049'],$content);
	$content = str_replace("[BELT_TYPE_2]",$data['vfb-field-8055'],$content);
	$content = str_replace("[Equipment_Age]",$data['vfb-field-7534'],$content);
	$content = str_replace("[Overall_Condition]",$data['vfb-field-7535'],$content);
	$content = str_replace("[Recommendations]",$data['vfb-field-7536'],$content);
	$content = str_replace("[Healthy_Safety_Concerns]",$data['vfb-field-7991'],$content);
	$content = str_replace("[COMMENTS]",$data['vfb-field-7538'],$content);
	
	$photo = getEntryAttachmentDetailsForUnitaryConditionReport($entry_id);
	
	if($photo != ""){
		$photo = '<img src="'.$photo.'" style="width:200px;"/>';
	} else {
		$photo = '<div class="pic" style="height:100px;"></div>';
	}

	$content = str_replace("[PHOTO]",$photo,$content);
	
	
	$content = str_replace("[TECHNICIAN]",$data['vfb-field-8116'],$content);
	$content = str_replace("[MOBILE_NUMBR]",$data['vfb-field-8115'],$content);
	$content = str_replace("[EMAIL]",$data['vfb-field-7524'],$content);
	
	$SIGN = $data['vfb-field-8117'];
	
	if($SIGN != ""){
		$SIGN = '<td style="width: 350px; font-size: 14px; margin-top: 5px;display: inline-block;"><img src="'.$SIGN.'" style="width:350px;"/></td>';
	} else {
		
		$SIGN = '<td style="width: 350px; font-size: 14px; margin-top: 5px;display: inline-block;border-bottom:2px solid #000; padding-top: 70px;"></td>';
	}
	$content = str_replace("[SIGN]",$SIGN,$content);
		
	//echo $content; die;
	$moreattachments = array();
	$PDFattachments = '';
	$pdfFilePath = $root.'/unitary/'.$filename;
	$attachments = array($pdfFilePath);
	
	
	foreach($moreattachments as $moreattachment){
		$filetype = wp_check_filetype($moreattachment);
		if(strtolower($filetype['ext']) == 'jpg' || strtolower($filetype['ext']) == 'jpeg' || strtolower($filetype['ext']) == 'png'){
			$PDFattachments = $PDFattachments.'<img style="height:auto;"  width="600" src="'.$moreattachment.'">';
		}else{
			$attachments[] = $moreattachment;
		}
	}
	
	$content = str_replace("[attachment_1]",$PDFattachments,$content);
	
	$html2pdf = new HTML2PDF('P','A4','en');
    $html2pdf->WriteHTML($content);
    $pdfdoc = $html2pdf->Output('unitary/'.$filename,'F');
	global $wpdb;
	
	$queryEmailTo = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'email-to' AND form_id =".$form_id, OBJECT );
	$queryEmailTo = $queryEmailTo[0]->meta_value;
	
	$querySubject = $wpdb->get_results("SELECT meta_value FROM `pkh_vfbp_formmeta` WHERE meta_key = 'subject' AND form_id =".$form_id, OBJECT );
	$querySubject = $querySubject[0]->meta_value .' - '. strtoupper($filename);

	wp_mail( $queryEmailTo, $querySubject,' ', $headers, $attachments );
	wp_mail( $data['vfb-field-6545'], $querySubject,' ', $headers, $attachments );
	$AllAttachments = array_merge($attachments,$moreattachments);
	 foreach($AllAttachments as $allattachments){
		@unlink($allattachments);
	}
}
function getEntryAttachmentDetailsForUnitaryConditionReport($id){
	$attachments = '';
	$root = $_SERVER['DOCUMENT_ROOT'];
	$postmeta = get_post_meta($id,"_vfb_field-7537");
	if(!empty($postmeta) && is_array($postmeta)){
		foreach($postmeta as $post){
			if($post !=""){
				$attachments = $post;
			}
		}
	}
	return $attachments;
}








function setUserPOPrefix($prefix){
	$user_ID = get_current_user_id();
	update_user_meta( $user_ID, "PONUMPREFIX", $prefix);
}
//setUserPOPrefix("RCA");
add_shortcode( 'assignPONumber', 'assignPONumber' );
add_shortcode( 'MYPON', 'MYPON' );

function MYPON(){
	return $_SESSION['MYPON'];
}
// .PONTEXTGENERATEDNUMBER
function assignPONumber(){
	$pon = getLastPONum();
	$script = '
			<style>.PONTEXTGENERATEDNUMBER{ display:none !important; }</style>
			<script>
				jQuery(function(){
					jQuery(".PONTEXTGENERATEDNUMBER").val('.$pon.');
				});
			</script>';
	return $script;
}

function getUserPOPrefix(){
	$user_ID = get_current_user_id();
	$prefix = get_user_meta( $user_ID, "PONUMPREFIX" );
	return $prefix[0];
}

function getLastPONum(){
	$current_user = wp_get_current_user();
	$email =  $current_user->user_email;
	$prefix = getUserPOPrefix();
	$option = "PONUMPREFIXCOUNT";
	$PONUMPREFIXCOUNT = get_option( $option);
	$optionvals = json_decode($PONUMPREFIXCOUNT,true);
	if($optionvals[$prefix] < 10000){
		$optionvals[$prefix] = 10000;
	}
	$return = array('PON'=>$prefix.$optionvals[$prefix], 'email'=> $email);
	return $return;
}	


function updateLastPONum(){
	$prefix = getUserPOPrefix();
	$option = "PONUMPREFIXCOUNT";
	$PONUMPREFIXCOUNT = get_option( $option);
	
	$UPDATEPONUMPREFIXCOUNT = "";
	if($PONUMPREFIXCOUNT != ""){
		$optionvals = json_decode($PONUMPREFIXCOUNT,true);
		
		if($optionvals[$prefix]<10000){
			$optionvals[$prefix] = 10000;
		}
		$optionvals[$prefix] = $optionvals[$prefix] + 1;
		
		$UPDATEPONUMPREFIXCOUNT = json_encode($optionvals);
	} else {
		$PONUMPREFIXCOUNT[$prefix] = 10000;
		$UPDATEPONUMPREFIXCOUNT = json_encode($PONUMPREFIXCOUNT);
	}
	update_option( $option, $UPDATEPONUMPREFIXCOUNT, true );
}

function getEntryAttachmentDetails($id){
	$attachments = array();
	$root = $_SERVER['DOCUMENT_ROOT'];
	$postmeta = get_post_meta($id,"_vfb_field-6104");
	
	if(!empty($postmeta) && is_array($postmeta)){
		foreach($postmeta as $post){
			if($post !=""){
				$home = home_url();
				$post = str_replace($home,$root,$post);
				$attachments[] = $post;
			}
		}
	}
	return $attachments;
}

function Get_Initials(){
	$usersInitials = array(
					'Admin' =>'PCA',
					'4168190141'=>'AWL',
					'4168190119'=>'AAF',
					'4168190134'=>'ADL',
					'4168190169'=>'AND',
					'6474050536'=>'ATW',
					'4168190178'=>'AAK',
					'4168190116'=>'RWE',
					'4168190123'=>'RDH',
					'4168190140'=>'REO',
					'4168190187'=>'RSS',
					'4168190152'=>'BBS',
					'4162621437'=>'BRM',
					'6473020276'=>'CEL',
					'6472027824'=>'CAW',
					'4168190199'=>'DGD',
					'4168190185'=>'DJT',
					'4168190112'=>'DPA',
					'4168192460'=>'DMD',
					'4168190149'=>'EJP',
					'4168190130'=>'GLL',
					'4169536427'=>'GTK',
					'4168190362'=>'GEK',
					'4168190137'=>'JSG',
					'4168190113'=>'JAL',
					'4168190126'=>'JAH',
					'4168190156'=>'KJP',
					'6472995890'=>'KFD',
					'6478219949'=>'LTB',
					'4168190133'=>'LVL',
					'4165223326'=>'MEN',
					'4168190146'=>'MJR',
					'4168190148'=>'MDF',
					'4166277289'=>'MGB',
					'4165225981'=>'MWM',
					'4168190138'=>'PJO',
					'4168190131'=>'PPL',
					'4168190122'=>'PDP',
					'4168190125'=>'PAH',
					'4168190147'=>'PSS',
					'4169043002'=>'PKS',
					'4168190101'=>'REB',
					'4168190182'=>'RAO',
					'4168190111'=>'RCA',
					'4168190117'=>'RPF',
					'4168190135'=>'RBN',
					'4168190155'=>'SSS',
					'6472040672'=>'SZB',
					'9059791974'=>'SAH',
					'4168190114'=>'SMB',
					'4168190176'=>'SRH',
					'4168190142'=>'SRM',
					'4166710423'=>'SOS',
					'4162753212'=>'WJS',
					'6476427731'=>'CWL'
				);
	global $current_user;
	get_currentuserinfo();
	$username = $current_user->user_login;
	$initial = $usersInitials[$username];
	return $initial;	
}

function getPONUMCOUNTS(){
	$option = "PONUMPREFIXCOUNT";
	$PONUMPREFIXCOUNT = get_option( $option);
	$UPDATEPONUMPREFIXCOUNT = "";
	if($PONUMPREFIXCOUNT != ""){
		$optionvals = json_decode($PONUMPREFIXCOUNT,true);
	}	
	
	/* foreach($optionvals as $k=>$val){
		$UPDATEPONUMPREFIXCOUNT[$k] = $val;
		$UPDATEPONUMPREFIXCOUNT['CH'.$k] = $val;
	}
	$UPDATEPONUMPREFIXCOUNT = json_encode($UPDATEPONUMPREFIXCOUNT);
	update_option( $option, $UPDATEPONUMPREFIXCOUNT, true ); */
	echo "<pre>";
	print_r($optionvals);
	//print_r($UPDATEPONUMPREFIXCOUNT);
	die;
}


// END ENQUEUE PARENT ACTION
wp_enqueue_script('my-script', get_stylesheet_directory_uri());
wp_localize_script('my-script', 'myScript', array(
    'pluginsUrl' => plugins_url(),
    'homeUrl' => site_url(),
));


function GET_LICENSEPLATENUMBER_CurrentUser(){
	$CurrentUserID = get_current_user_id();
	$UserMeta = get_user_meta($CurrentUserID,'LICENSEPLATE');
	return $UserMeta[0];
}


add_action( 'save_post_salesreps', 'saveValues' );
function saveValues($post_id) {
	global $wpdb;
	$terms = wp_get_post_terms( $post_id, 'Desgination');
	$termsarray = array();
	foreach($terms as $term){
		$termsarray[] =  $term->slug;
	}
	wp_remove_object_terms($post_id,$termsarray, 'Desgination');
	wp_set_object_terms($post_id, $_POST['Designation'], 'Desgination' ,true);	
	
	$Lat = $_POST['Latitude'];
	$Long = $_POST['Longitude'];
	$ManagerId = $_POST['Manager'];
	
	if($post_id != ''){
		$wpdb->query('DELETE  FROM '.$wpdb->prefix.'RespLocation WHERE RespID = "'.$post_id.'"');
		$wpdb->query('DELETE  FROM '.$wpdb->prefix.'managers WHERE RespId = "'.$post_id.'"');
	}
	
	$wpdb->insert( 'wp_RespLocation', array(
		'RespID'=> $post_id,
        'Lat' => $Lat, 
        'Longt' => $Long )
    );
	if($ManagerId!= '0'){
		$wpdb->insert( 'wp_managers', array(
			'RespId'=> $post_id,
			'ManagerId' => $ManagerId)
		);
	}
	
}
add_action( 'delete_post', 'my_delete_function' );
function my_delete_function($postId) { 
   global $wpdb;
   $wpdb->query("DELETE FROM wp_RespLocation WHERE RespID=".$postId);
   $wpdb->query("DELETE FROM wp_managers WHERE RespId=".$postId);
}

function getRolesSorted(){
	 global $wp_roles;
	 $roles = $wp_roles->get_names();
	 ksort($roles);
	 return $roles;
}
function getRolesSortedoptions(){
	$roles = getRolesSorted();
	$options = '';
	foreach($roles as $key => $Val) {
		$options = $options.'<option value="'.$key.'">'.$Val.'</option>';	
	}
	return $options;
}

function Web_push_notification_parent($USERIDS,$notifiyID='',$title,$Message,$ID=0){
	global $wpdb;
	$DeviceDATA = $wpdb->get_results("select * from pkh_userdevices WHERE userid IN($USERIDS)");
	if(!empty($DeviceDATA)){
		foreach($DeviceDATA as $IDS){
			$userID    = $IDS->userid;
			$Device		= $IDS->device;
			$Pushcode  = $IDS->pushcode;
			if($Device == 'iOS' && $Pushcode != ''){
				WebsendGooglePush_func_IOS_Parent($userID,$Pushcode,$title,$Message,$notifiyID,'',0,'PARSUB');
			}
			if($Device == 'Android' && $Pushcode != ''){
				WebsendGooglePush_func_Android_Parent($userID,$Pushcode,$title,$Message,$notifiyID,'',0,'PARSUB');
			} 
		}
	}
	
}
function WebsendGooglePush_func_Android_Parent($userID,$receivers,$title,$message,$notifiyID=0,$roles='',$ID=0,$type=''){
	$googlekey = "AAAAIzlOTRU:APA91bFvYmDFHUQVD6YL0Nmbk4wGbpvK96AqNOEusS67r6K_bTvPTNgNxZtSxhMDZm9HB8JrmNfEVYk6IR0OC1-j_qR6mWPzrjHtd97wPt8QqTIVZIiiOj1njD0_5Mn2wt7AlnvU7QmFuHS3tqkTaIcG_93dd0AnYQ";
	$packagename = "com.quickquote.trane";
	$registrationIds = $receivers;
	$custom = array("userid"=>$userID,'type'=>$type);
	$title = stripslashes($title);
	$message = stripslashes($message);
	$notication = array(
			"title" => "$title",
			"body" => "$message",
			"sound" => "default",
			"color" => "#FFFFFF",
			"collapse_key" => "$title",
			"tag" => "$title",
			"click_action" => "FCM_PLUGIN_ACTIVITY"
			);
	$fields = array(
				"notification" => $notication,
				"data" => $custom,
				"to" => $registrationIds,
				"priority" => "high",
				"restricted_package_name" => $packagename
			);
	$headers = array(
				'Authorization: key=' . $googlekey,
				'Content-Type: application/json'
			);
	
	$ch = curl_init();
	curl_setopt( $ch,CURLOPT_URL, 'https://fcm.googleapis.com/fcm/send' );
	curl_setopt( $ch,CURLOPT_POST, true );
	curl_setopt( $ch,CURLOPT_HTTPHEADER, $headers );
	curl_setopt( $ch,CURLOPT_RETURNTRANSFER, true );
	curl_setopt( $ch,CURLOPT_SSL_VERIFYPEER, false );
	curl_setopt( $ch,CURLOPT_POSTFIELDS, json_encode( $fields ) );
	$result = curl_exec($ch );
	curl_close( $ch );
	/* global $wpdb;
	$sender = get_current_user_id();
	
	$wpdb->query("insert into pkh_PushNotificationStatus set device = 'Android',userid = '$userID',success_code = '',NotificationID = '$notifiyID',sent_from = '$sender',notifytitle = '$title',notifymsg = '$message',role = '$roles',
	FilterNotificationID = '$ID'"); */
	return $result;
}
function WebsendGooglePush_func_IOS_Parent($userID,$Pushcode,$title,$Message,$notifiyID=0,$roles='',$ID=0,$type=''){
	$data = array();
	$data['push_code']  = $Pushcode; //"59ec3c42b825211fd03c1eef1e25a8c4dcf12ffdfa9b0d4f6ed710162fa7620a";
	$data['title'] 		= $title;
	$data['message'] 	= $Message;
	$data['type'] 		= $type;
	$data['id'] 		= "1";
	$data['badge'] 		= 0;
	
	$ch = curl_init();
	curl_setopt( $ch,CURLOPT_URL, site_url('ApnsPHP/sample_push.php') );
	curl_setopt( $ch,CURLOPT_POST, true );
	curl_setopt( $ch,CURLOPT_RETURNTRANSFER, true );
	curl_setopt( $ch,CURLOPT_SSL_VERIFYPEER, false );
	curl_setopt( $ch,CURLOPT_POSTFIELDS, $data);
	$result = curl_exec($ch );
	curl_close( $ch );
	global $wpdb;
	/* $sender = get_current_user_id();
	$wpdb->query("insert into pkh_PushNotificationStatus set device = 'iOS',userid = '$userID',success_code = '',NotificationID = '$notifiyID',sent_from = '$sender',notifytitle = '$title',notifymsg = '$Message',role = '$roles',
	FilterNotificationID = '$ID'"); */
	return $result;
}
add_action('RemoveTemp_Submission', 'RemoveTemp_Submission');

function RemoveTemp_Submission(){
	global $wpdb;
	$wpdb->get_results("DELETE FROM `pkh_temp_submission` WHERE TIMESTAMPDIFF(HOUR, EntryTime , NOW()) > 24");
} 
