File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_ENDORSE_CLEARANCE_FORM.php

Back
<?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); $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 `h_id`='$NewCLRecordID'"),0); $endorserA = mysql_result(mysql_query("SELECT `cl_recommender_a_id` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0); $endorserAT = mysql_result(mysql_query("SELECT `cl_recommender_a_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0); $endorserB = mysql_result(mysql_query("SELECT `cl_recommender_b_id` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0); $endorserBT = mysql_result(mysql_query("SELECT `cl_recommender_b_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),0); $empFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $empLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); if($endorserA == $addByUID){ if($endorserBT != ''){ mysql_query("UPDATE `cl_clearance_header` SET `cl_recommender_a_timestamp` = '$dateTime', `cl_h_hr_approval`='FINAL APPROVAL', `hdr_status`='4' WHERE `h_id`='$NewCLRecordID'"); mysql_query("UPDATE `cl_clearance_data` SET `hdr_status`='4' WHERE `key_code`='$keyCode'"); //########################################################################## // SEND SMS TO APPROVING OFFICER AND TO EMPLOYEE========================================================= // SEND SMS TO APPROVING OFFICER AND TO EMPLOYEE========================================================= //########################################################################## //$getTemplateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0); //$CLempID = mysql_result(mysql_query("SELECT `cl_hr_approval_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0); $gmApproverID = mysql_result(mysql_query("SELECT `cl_approver_id` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),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); $approverMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $empEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $GMSMSMessage = "Clereance Form of ".$empLName.", ".$empFName. " has been routed to you for your approval."; $SMSMessage = "Your clearance is now for final approval"; $resultg = itexmoAA($approverMobile, $GMSMSMessage,$MyAPIcode,$MyPasswd); $resulte = itexmoAA($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($resulte == ""){ echo '<script>alert("No response from SMS server. SMS failed to send")</script>'; }else if ($result == 0){ //echo "SMS Sent!"; } else{ echo '<script>alert("SMS ERROR: '. $result . ' was encountered!")</script>'; } if ($resultg == ""){ echo '<script>alert("No response from SMS server. SMS failed to send")</script>'; }else if ($result == 0){ //echo "SMS Sent!"; } else{ echo '<script>alert("SMS ERROR: '. $result . ' was encountered!")</script>'; } //########################################################################## //########################################################################## // SEND MAIL FUNCTION TO EMPLOYEE========================================================= // SEND MAIL FUNCTION TO EMPLOYEE========================================================= $gmFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $gmLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $gmEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $gmgetRegisteredHR = $gmFname ." ". $gmLname ."!"; $fromH = "support@autohubgroup.com"; $toGM = $gmEmail; $subjectGM = "CLEARANCE FOR FINAL APPROVAL"; $msgBoxGM = "Hi ".$gmgetRegisteredHR."! Clearance Form of ".$empFName. " ".$empLName." has been routed to your for your final approval. Please login to ASA or to https://autohub.ph/connect to access your portal. HR Admin"; $headersGM = "From:" . $fromH; mail($toGM,$subjectGM,$msgBoxGM, $headersGM); //===================================================================================================================================================== //########################################################################## //########################################################################## }else{ mysql_query("UPDATE `cl_clearance_header` SET `cl_recommender_a_timestamp` = '$dateTime', `hdr_status`='2' WHERE `h_id`='$NewCLRecordID'"); mysql_query("UPDATE `cl_clearance_data` SET `hdr_status` = '2' WHERE `key_code`='$keyCode'"); //########################################################################## // SEND SMS TO EMPLOYEE ONLY ========================================================= // SEND SMS TO EMPLOYEE ONLY ========================================================= //########################################################################## //$getTemplateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0); //$CLempID = mysql_result(mysql_query("SELECT `cl_hr_approval_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); $approverMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $SMSMessage = "Your clearance form has been endorsed to next officer"; //$result = itexmo($approverMobile, $SMSMessage,$MyAPIcode,$MyPasswd); $result = itexmoAA($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 '<script>alert("SMS Error: '. $result . ' was encountered!")</script>'; } //########################################################################## //########################################################################## } } if($endorserB == $addByUID){ if($endorserAT != ''){ mysql_query("UPDATE `cl_clearance_header` SET `cl_recommender_b_timestamp` = '$dateTime', `cl_h_hr_approval`='FINAL APPROVAL' , `hdr_status`='4' WHERE `h_id`='$NewCLRecordID'"); mysql_query("UPDATE `cl_clearance_data` SET `hdr_status`='4' WHERE `key_code`='$keyCode'"); //########################################################################## // SEND SMS TO APPROVING OFFICER AND TO EMPLOYEE========================================================= // SEND SMS TO APPROVING OFFICER AND TO EMPLOYEE========================================================= //########################################################################## //$getTemplateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0); //$CLempID = mysql_result(mysql_query("SELECT `cl_hr_approval_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0); $gmApproverID = mysql_result(mysql_query("SELECT `cl_approver_id` FROM `cl_clearance_header` WHERE `h_id`='$NewCLRecordID'"),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); $approverMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $GMSMSMessage = "Clereance Form of ".$empLName.", ".$empFName. " has been routed to you for your approval."; $SMSMessage = "Your clearance is now for final approval."; $resultg = itexmoAA($approverMobile, $GMSMSMessage,$MyAPIcode,$MyPasswd); $resulte = itexmoAA($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($resulte == ""){ echo '<script>alert("No response from SMS server. SMS failed to send")</script>'; }else if ($result == 0){ //echo "SMS Sent!"; } else{ echo '<script>alert("SMS Error:'. $result . ' was encountered!")</script>'; } if ($resultg == ""){ echo '<script>alert("No response from SMS server. SMS failed to send")</script>'; }else if ($result == 0){ //echo "SMS Sent!"; } else{ echo '<script>alert("SMS Error:'. $result . ' was encountered!")</script>'; } //########################################################################## //########################################################################## //########################################################################## //########################################################################## // SEND MAIL FUNCTION TO EMPLOYEE========================================================= // SEND MAIL FUNCTION TO EMPLOYEE========================================================= $gmFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $gmLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $gmEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $gmgetRegisteredHR = $gmFname ." ". $gmLname ."!"; $fromH = "support@autohubgroup.com"; $toGM = $gmEmail; $subjectGM = "CLEARANCE FOR FINAL APPROVAL"; $msgBoxGM = "Hi ".$gmgetRegisteredHR."! Clearance Form of ".$empFName. " ".$empLName." has been routed to your for your final approval. Please login to ASA or to https://autohub.ph/connect to access your portal. HR Admin"; $headersGM = "From:" . $fromH; mail($toGM,$subjectGM,$msgBoxGM, $headersGM); //===================================================================================================================================================== //########################################################################## //########################################################################## }else{ mysql_query("UPDATE `cl_clearance_header` SET `cl_recommender_b_timestamp` = '$dateTime', `hdr_status`='2' WHERE `h_id`='$NewCLRecordID'"); mysql_query("UPDATE `cl_clearance_data` SET `hdr_status` = '2' WHERE `key_code`='$keyCode'"); //########################################################################## // SEND SMS TO EMPLOYEE ONLY ========================================================= // SEND SMS TO EMPLOYEE ONLY ========================================================= //########################################################################## //$getTemplateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCode'"),0); //$CLempID = mysql_result(mysql_query("SELECT `cl_hr_approval_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); $approverMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$gmApproverID'"),0); $empMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $SMSMessage = "Your clearance form has been endorsed to next officer."; //$result = itexmo($approverMobile, $SMSMessage,$MyAPIcode,$MyPasswd); $result = itexmoAA($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 '<script>alert("SMS Error:'. $result . ' was encountered!")</script>'; } //########################################################################## //########################################################################## } } //########################################################################## //########################################################################## // SEND MAIL FUNCTION TO EMPLOYEE========================================================= // SEND MAIL FUNCTION TO EMPLOYEE========================================================= $hFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $hLname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $hEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $hMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $getRegisteredHR = $hFname ." ". $hLname ."!"; $fromH = "hr@autohubgroup.com"; $toH = $hEmail; $subjectH = "NEW CLEARANCE FORM"; $msgBoxH = "Hi ".$getRegisteredHR."! Your clearance form has been endorsed to next higher officer. HR Admin"; $headersH = "From:" . $fromH; mail($toH,$subjectH,$msgBoxH, $headersH); //===================================================================================================================================================== //########################################################################## //########################################################################## echo "<table>"; echo "<thead>"; echo "<th style='min-width:70px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:11px'>DATE</th>"; echo "<th style='min-width:60px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:11px'>TRANS ID.</th>"; echo "<th style='min-width:200px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:11px'>EMPLOYEE NAME</th>"; echo "<th style='min-width:120px;border:0px solid white;font-weight:normal;font-family:Calibri;font-size:11px'>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`='FOR ENDORSEMENT' AND `cl_status`='1' AND `cl_h_comp_id` = '$addCompID' AND `cl_recommender_a_id` = '$addByUID' AND `cl_recommender_a_timestamp`='' \|\| `cl_h_hr_approval`='FOR ENDORSEMENT' AND `cl_status`='1' AND `cl_h_comp_id` = '$addCompID' AND `cl_recommender_b_id` = '$addByUID' AND `cl_recommender_b_timestamp`='' 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:showEndorsement(this);"><?php echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:11px;color:blue'>".strtoupper($row['cl_h_date_created'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:11px;color:blue'>".strtoupper($row['h_id'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-family:Calibri;font-size:11px;color:blue'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-size:11px;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']=='FILE APPROVAL'){ echo "ENDORSED"; } echo "</td>"; echo "</tr>"; } echo "</table>"; echo '<script>alert("Clearance Form has been Endorsed to next approving officer")</script>'; exit(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings