File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_OFFICER_APPROVED_SAVEBAK.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; $userID=$user_data['u_id']; if(isset($_POST['done'])){ $ClearanceHdrID = mysql_escape_string($_POST['ClearanceDataID']); $txtHeaderID = mysql_escape_string($_POST['txtHeaderID']); $addCompID = mysql_escape_string($_POST['addCompID']); $addByUID = mysql_escape_string($_POST['addByUID']); $myKeyCode=mysql_result(mysql_query("SELECT `key_code` FROM `cl_clearance_header` WHERE `h_id`='$txtHeaderID'"),0); $CLempID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `h_id`='$txtHeaderID'"),0); $msgFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $msgLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); //CHECK ACTUAL SLA $olddate = mysql_result(mysql_query("SELECT `cl_sla_start` FROM `cl_clearance_data` WHERE `cl_id`='$ClearanceHdrID'"),0); $endDate = mysql_result(mysql_query("SELECT `cl_sla_end` FROM `cl_clearance_data` WHERE `cl_id`='$ClearanceHdrID'"),0); $myEndDate = strtotime($endDate); $your_date = strtotime($olddate); $datediff = $myEndDate - $your_date; $totalCount = round($datediff / (60 * 60 * 24)); //CHECK ACTUAL SLA mysql_query("UPDATE `cl_clearance_data` SET `cl_approved_by_id` = '$addByUID', `cl_approved_date`='$myDate', `cl_approved_time`='$toTime',`cl_sla_end`='$myDate',`cl_status`='Cleared',`cl_actual_sla`='$totalCount' WHERE `key_code`='$myKeyCode' AND `cl_id`='$ClearanceHdrID' AND `cl_approver_id_a`='$addByUID' \|\| `key_code`='$myKeyCode' AND `cl_id`='$ClearanceHdrID' AND `cl_approver_id_b`='$addByUID'"); //CHECK IF CLEARANCE IS AT 100% COMPLETION RATE. IF YES, CHANGE STATUS TO COMPLETED AND ROUTE CLEARANCE TO ENDORSING OFFICERS $countTotalApprover = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `key_code`='$myKeyCode' AND `cl_approver_id_a` != '0' \|\| `key_code`='$myKeyCode' AND `cl_approver_id_b` != 0"),0); $countApproved = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `key_code`='$myKeyCode' AND `cl_approved_by_id` != '0' AND `cl_approved_date` !=''"),0); //$compRatings = number_format((($countApproved / $countTotalApprover) * 100),2); if($countApproved == $countTotalApprover){ mysql_query("UPDATE `cl_clearance_header` SET `cl_h_hr_approval` = 'FOR ENDORSEMENT', `hdr_status`='2',`signatory_completion_date`='$myDate' WHERE `key_code`='$myKeyCode' AND `h_id`='$txtHeaderID'"); mysql_query("UPDATE `cl_clearance_data` SET `hdr_status`='2' WHERE `key_code`='$myKeyCode' AND `cl_id`='$ClearanceHdrID'"); //########################################################################## //##########################################################################caguila@autohubgroup.com //########################################################################## // SEND SMS TO ENDORSING OFFICERS 1 & 2========================================================= // SEND SMS TO ENDORSING OFFICERS 1 & 2========================================================= //########################################################################## $endorsingIDA= mysql_result(mysql_query("SELECT `cl_recommender_a_id` FROM `cl_clearance_header` WHERE `h_id`='$txtHeaderID'"),0); $endorsingIDB= mysql_result(mysql_query("SELECT `cl_recommender_b_id` FROM `cl_clearance_header` WHERE `h_id`='$txtHeaderID'"),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); $empMobileA = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$endorsingIDA'"),0); $empMobileB = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$endorsingIDB'"),0); $SMSMessage = $msgFname. " ".$msgLname."'s Clearance Form has been routed to you for your recommendation."; $result = itexmoAA($empMobileA, $SMSMessage,$MyAPIcode,$MyPasswd); $result = itexmoAA($empMobileB, $SMSMessage,$MyAPIcode,$MyPasswd); if ($result == ""){ echo '<script>alert("No response from SMS server. SMS failed to send. Code: 20024")</script>'; }else if ($result == 0){ echo "SMS Sent!"; } else{ echo "Error Num ". $result . " was encountered!"; } //########################################################################## //########################################################################## } //END OF QUERY// // SEND MAIL FUNCTION HR APPROVING OFFICER========================================================= // SEND MAIL FUNCTION HR APPROVING OFFICER========================================================= // SEND MAIL FUNCTION HR APPROVING OFFICER========================================================= $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); $approvalFname = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$addByUID'"),0); $approvalLname = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$addByUID'"),0); $getApproverFullName = $approvalFname ." ". $approvalLname; $getApproverFullNameSMS = $approvalFname ." ". $approvalLname; $hMobile = mysql_result(mysql_query("SELECT `usr_mobile` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $getRegisteredHR = $hFname ." ". $hLname; $fromH = "support@autohubgroup.com"; $toH = $hEmail; $subjectH = "EMPLOYEE CLEARANCE UPDATE"; //010433967-1 //SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `key_code`='010433967-1' AND `cl_approver_id_a` != '0' \|\| `key_code`='010433967-1' AND `cl_approver_id_b` != 0 $countTotalApprover = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `key_code`='$myKeyCode' AND `cl_approver_id_a` != '0' \|\| `key_code`='$myKeyCode' AND `cl_approver_id_b` != 0"),0); $countApproved = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `key_code`='$myKeyCode' AND `cl_approved_date` !=''"),0); $compRate = number_format((($countApproved / $countTotalApprover) * 100),2) . "%"; $msgBoxH = "Hi ".$getRegisteredHR."! Your clearance form has been signed by ".$getApproverFullName.". Your clearance status is now at ".$compRate." completion rate as of ".$myDate." Autohub Support"; $headersH = "From:" . $fromH; mail($toH,$subjectH,$msgBoxH, $headersH); //########################################################################## //########################################################################## //########################################################################## // SEND SMS TO CLEARANCE OWNER========================================================= // SEND SMS TO CLEARANCE OWNER========================================================= //########################################################################## $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 has been signed by ".$getApproverFullNameSMS."."; $resultA = itexmoAA($empMobile, $SMSMessage,$MyAPIcode,$MyPasswd); if ($resultA == ""){ echo '<script>alert("No response from SMS server. SMS failed to send. Code: 10012")</script>'; }else if ($resultA == 0){ echo "SMS Sent!"; } else{ echo "Error Num ". $result . " was encountered!"; } //########################################################################## //########################################################################## //===================================================================================================================================================== //===================================================================================================================================================== echo "<table>"; echo "<thead>"; echo "<th style='width:50px;border:0px solid white;font-weight:normal'>NO.</th>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal'>REC ID.</th>"; echo "<th style='width:100px;border:0px solid white;font-weight:normal'>DATE.</th>"; echo "<th style='width:100px;border:0px solid white;font-weight:normal'>EMP. ID.</th>"; echo "<th style='width:200px;border:0px solid white;font-weight:normal'>EMPLOYEE NAME</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>POSITION</th>"; echo "<th style='width:80px;border:0px solid white;font-weight:normal'>TYPE</th>"; echo "<th style='width:150px;border:0px solid white;font-weight:normal'>STATUS</th>"; echo "<th style='width:200px;border:0px solid white;font-weight:normal'>INSTRUCTION</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 HR Approval' AND `cl_status`='1' AND `cl_h_comp_id` = '$comID' ORDER BY `cl_h_date_created` DESC"); 090434218-96 $getActiveClearance = mysql_query("SELECT * FROM `cl_clearance_data` WHERE `cl_approver_id_a`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' \|\| `cl_approver_id_b`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' ORDER BY `cl_id` DESC"); while($row=mysql_fetch_array($getActiveClearance)){ $keyCodeID = $row['key_code']; $headerID = mysql_result(mysql_query("SELECT `h_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $empID = mysql_result(mysql_query("SELECT `cl_h_emp_id` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $pID = mysql_result(mysql_query("SELECT `cl_emp_position` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $clCreatedDate = mysql_result(mysql_query("SELECT `cl_h_date_created` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $clRand = mysql_result(mysql_query("SELECT `cl_rank` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $clStatus = mysql_result(mysql_query("SELECT `cl_h_hr_approval` FROM `cl_clearance_header` WHERE `key_code`='$keyCodeID'"),0); $uFName=mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uLName=mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uEMPID=mysql_result(mysql_query("SELECT `employee_id` FROM `vts_users` WHERE `u_id`='$empID'"),0); $uPosition=mysql_result(mysql_query("SELECT `position_title` FROM `db_positions` WHERE `pid`='$pID'"),0); $chkIfIamApprover = mysql_result(mysql_query("SELECT COUNT(cl_id) FROM `cl_clearance_data` WHERE `cl_approver_id_a` ='$userID' AND `key_code` = '$keyCodeID' AND `cl_approved_by_id`='0' \|\| `cl_approver_id_b` ='$userID' AND `key_code` = '$keyCodeID' AND `cl_approved_by_id` ='0'"),0); if($chkIfIamApprover > 0){ $count = $count + 1; ?><tr onclick="javascript:showClearanceApproval(this);"><?php echo "<td style=';border:0px solid white;cursor:pointer'>".$headerID."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($row['cl_id'])."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".$clCreatedDate."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uEMPID)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uLName).", ".strtoupper($uFName)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($uPosition)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer'>".strtoupper($clRand)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-size:11px;color:blue;font-weight:normal'>".strtoupper($clStatus)."</td>"; echo "<td style=';border:0px solid white;cursor:pointer;font-size:11px;color:blue;font-weight:normal'>For clearing officer approval</td>"; echo "</tr>"; } } //echo "</table>"; echo "<script>alert('".$msgFname ." ". $msgLname ." has been cleared!')</script>"; exit(); } ?>

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