<?php 
include 'core/init.php';
//$connect_error = 'Sorry, we\'re experiencing connection problem.  Please try again later...  Thank you!';
//mysql_connect('localhost','root','aee1024') or die ($connect_error);
//mysql_select_db('db_vts') or die($connect_error);
//error_reporting(1);
$userID = $user_data['u_id'];
$compID= $user_data['company'];
$myDate = date_create() ->format("Y-m-d"); 
$toTime =date('H:i:s');
$dateTime = $myDate . " ".$toTime;
if(isset($_POST['done'])){
		$NewCLRecordID = mysql_escape_string($_POST['NewCLRecordID']);	 
		$addCompID = mysql_escape_string($_POST['addCompID']);	 
		$addByUID = mysql_escape_string($_POST['addByUID']);	 
		$keyCode = mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0);	
		$CLempID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0);
		
		$clApproverA = mysql_result(mysql_query("SELECT `cl_approver_id` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0);
		$clApproverATS = mysql_result(mysql_query("SELECT `cl_approver_id_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0);
		
		$clApproverB = mysql_result(mysql_query("SELECT `cl_approver_id_b` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0);
		$clApproverBTS = mysql_result(mysql_query("SELECT `cl_approver_id_b_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0);
		
		
		if($clApproverA == $userID){
			if($clApproverBTS!=''){
				mysql_query("UPDATE `cl_clearance_header` SET `cl_approver_id_timestamp` = '$dateTime', `cl_h_hr_approval`='LASTPAY COMPUTATION', `hdr_status`='4', `cl_second_wave`='LASTPAY COMPUTATION' WHERE `h_id`='$NewCLRecordID'");
				mysql_query("UPDATE `cl_clearance_data` SET `hdr_status`='4' WHERE `key_code`='$keyCode'");	
			}else{
				if($clApproverB == 0){
					mysql_query("UPDATE `cl_clearance_header` SET `cl_approver_id_timestamp` = '$dateTime', `cl_h_hr_approval`='LASTPAY COMPUTATION', `hdr_status`='4', `cl_second_wave`='LASTPAY COMPUTATION' WHERE `h_id`='$NewCLRecordID'");
					mysql_query("UPDATE `cl_clearance_data` SET `hdr_status`='4' WHERE `key_code`='$keyCode'");	
				}else{
					mysql_query("UPDATE `cl_clearance_header` SET `cl_approver_id_timestamp` = '$dateTime' WHERE `h_id`='$NewCLRecordID'");
				}
			}
		}
		
		if($clApproverB == $userID){
			if($clApproverATS!=''){
				mysql_query("UPDATE `cl_clearance_header` SET `cl_approver_id_b_timestamp` = '$dateTime', `cl_h_hr_approval`='LASTPAY COMPUTATION', `hdr_status`='4', `cl_second_wave`='LASTPAY COMPUTATION' WHERE `h_id`='$NewCLRecordID'");
				mysql_query("UPDATE `cl_clearance_data` SET `hdr_status`='4' WHERE `key_code`='$keyCode'");	
			}else{
				mysql_query("UPDATE `cl_clearance_header` SET `cl_approver_id_b_timestamp` = '$dateTime' WHERE `h_id`='$NewCLRecordID'");
			}
		}
		
		
		
		$hFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$CLempID'"),0);
		$hLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$CLempID'"),0);
		$hEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$CLempID'"),0);
		  
//GET INFORMATION OF PAYROLL OFFICER
		$getCLTemplateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0);	
		$getPayrollOfficeID = mysql_result(mysql_query("SELECT `payroll_officer` FROM `cl_template_name` WHERE `id`='$getCLTemplateID'"),0);	
		$payFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getPayrollOfficeID'"),0);
		$payLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getPayrollOfficeID'"),0);
		$payEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$getPayrollOfficeID'"),0);
		$payMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$getPayrollOfficeID'"),0);
		//##########################################################################
		// SEND SMS TO PAYROLL OFFICER=========================================================
		//##########################################################################
		 	$MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0);
			$MyPasswd =  mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); 
			 
			$PaylSMSMessage = $hFname. " ". $hLname . " clearance form has been approved.  You can now process the computation of final pay.";
			$resultP = itexmo($payMobile, $PaylSMSMessage,$MyAPIcode,$MyPasswd);
			if ($resultP == ""){
				echo '<script>alert("No response from SMS server.  SMS failed to send")</script>';	
			}else if ($result == 0){
				//echo "SMS Sent!";
			}
			else{	
				echo "Error Num ". $result . " was encountered!";
			}	
		//##########################################################################
		//##########################################################################

// SEND MAIL FUNCTION TO EMPLOYEE=========================================================
// SEND MAIL FUNCTION TO EMPLOYEE=========================================================		 
$getRegisteredPAY = $payFname ." ". $payLname;
$fromH = "support@autohubgroup.com";
$toPay = $payEmail;
$subjectPay = "CLEARANCE FINAL PAY COMPUTATION";
$msgBoxPAY = "Hi ".$getRegisteredPAY."! 

".$payFname . " " .$payLname . " clearnce form has been approved.  You can now process the computation of final pay. 

HR Admin";
$headersPAY = "From:" . $fromH;
mail($toPay,$subjectPay,$msgBoxPAY, $headersPAY);					
//===============================================================================================================================================
		
// SEND MAIL FUNCTION TO EMPLOYEE=========================================================
// SEND MAIL FUNCTION TO EMPLOYEE=========================================================		 
$getRegisteredHR = $hFname ." ". $hLname;
$fromH = "support@autohubgroup.com";
$toH = $hEmail;
$subjectH = "EMPLOYEE CLEARANCE UPDATE";
$msgBoxH = "Hi ".$getRegisteredHR."! 

Your clearance form has been approved.  We are now processing the computation of your final pay.  Please check your e-mail for more updates about the status of your clerance form and the release of your check.

HR Admin";
$headersH = "From:" . $fromH;
mail($toH,$subjectH,$msgBoxH, $headersH);					
//===============================================================================================================================================
		//##########################################################################
		//##########################################################################
		
		//##########################################################################
		// SEND SMS TO AUTHORIZING HR OFFICER=========================================================
		// SEND SMS TO AUTHORIZING HR OFFICER=========================================================
		//##########################################################################
			//$getTemplateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0);
			
			 
			$MyAPIcode = mysql_result(mysql_query("SELECT `SMSAPICode` FROM `asa_versioning_db` WHERE `type`='Live'"),0);
			$MyPasswd =  mysql_result(mysql_query("SELECT `SMSAPIPass` FROM `asa_versioning_db` WHERE `type`='Live'"),0); 
			$empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$CLempID'"),0);
			$SMSMessage = "Your clearance form has been approved.  We are now processing your Last pay.";
			$result = itexmo($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd);
		 
			if ($result == ""){
				echo '<script>alert("No response from SMS server.  SMS failed to send")</script>';	
			}else if ($result == 0){
				//echo "SMS Sent!";
			}
			else{	
				echo "Error Num ". $result . " was encountered!";
			}	
		//##########################################################################
		//##########################################################################
		
		
			echo "<table>";
						echo "<thead>";
							echo "<th style='width:80px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>DATE</th>";
							echo "<th style='width:50px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>REC ID.</th>";
							echo "<th style='width:220px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>EMPLOYEE NAME</th>";					 
							echo "<th style='width:110px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:12px'>STATUS</th>";
							 
							//echo "<th style='width:220px;border:0px solid white;font-weight:normal'>Action</th>";				
						echo "</thead>";
					$getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_header` WHERE `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4'  AND `cl_approver_id` = '$userID'  || `cl_h_hr_approval`='FINAL APPROVAL' AND `hdr_status`='4' AND `cl_approver_id_b` = '$userID' ORDER BY `cl_h_date_created` DESC");
					while($row=mysql_fetch_array($getActiveClearance)){
					$uID = $row['cl_h_emp_id'];
					$pID = $row['cl_emp_position'];
					$uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
					$uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$uID'"),0);
					$uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$uID'"),0);
					$uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0);
						$count = $count + 1;
							?><tr onclick="javascript:showApproval(this);"><?php
							echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($row['cl_h_date_created'])."</td>";
							echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($row['h_id'])."</td>";
							echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:12px;color:blue'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; 
							 
							echo "<td style=';border:0px solid white;cursor:pointer;font-size:12px;color:blue;font-weight:normal'>";
								if($row['cl_h_hr_approval']=='For HR Approval'){ echo "UNPOSTED"; }
								if($row['cl_h_hr_approval']=='FOR ENDORSEMENT'){ echo "CLEARED"; }
								if($row['cl_h_hr_approval']=='FINAL APPROVAL'){ echo "GM APPROVAL"; }
							echo "</td>";
							 
						echo "</tr>";
					 }
					echo "</table>"; 
		//echo '<script>alert("Clearance has been approved")</script>';
		exit();
	}
 ?>