File manager

File manager - Edit - /home/autoph/public_html/connect/home/CL_OFFICER_APPROVED_SAVE.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); $hEmail = mysql_result(mysql_query("SELECT `email` FROM `vts_users` WHERE `u_id`='$CLempID'"),0); $clReason = mysql_result(mysql_query("SELECT `cl_h_reason` FROM `cl_clearance_header` WHERE `h_id`='$txtHeaderID'"),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(1) 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(1) 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){ //CHANGES cl_h_hr_approval STATUS from FOR ENDORSEMENT TO LASTPAY COMPUTATION (DOCUMENTS PREPARATION, CHECK RELEASING,READY FOR RELEASE,DOCUMENTS PREPARATION if($clReason == 'LEAVE' \|\| $clReason == 'REASSIGNMENT' \|\| $clReason == 'TRANSFER' \|\| $clReason == 'DETAIL' \|\| $clReason == 'SUSPENSION' \|\| $clReason == 'REEMPLOYMENT' \|\| $clReason == 'MATERNITY' \|\| $clReason == 'LEAVE OF ABSENCE'){ $smsCode='NO'; mysql_query("UPDATE `cl_clearance_header` SET `cl_approver_id_timestamp` = '$dateTime', `cl_h_hr_approval`='CLOSED', `hdr_status`='4',`cl_sla_end` = '$dateTime',`cl_date_of_release` = '$dateTime',`cl_lastpay_released_date` = '$dateTime',`cl_second_wave`='CLOSED' WHERE `h_id`='$txtHeaderID'"); mysql_query("UPDATE `cl_clearance_data` SET `hdr_status`='4' WHERE `key_code`='$keyCode'"); }else{ $smsCode='YES'; mysql_query("UPDATE `cl_clearance_header` SET `cl_h_hr_approval` = 'LASTPAY COMPUTATION', `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'"); } //DEC. 19, 2023 UPDATES //mysql_query("UPDATE `cl_clearance_header` SET `cl_h_hr_approval` = 'LASTPAY COMPUTATION', `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); $getCLTemplateID = mysql_result(mysql_query("SELECT `cl_h_template_id` FROM `cl_clearance_header` WHERE `h_id`='$ClearanceHdrID'"),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); $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 = $msgFname. " ". $msgLname . " has been cleared. Please prepare the lastpay computation."; $resultP = itexmoAA($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!"; } //$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'>COMPANY</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']; $clCompID = $row['cl_comp_id']; $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); $uComp=mysql_result(mysql_query("SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$clCompID'"),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($uComp)."</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