File manager - Edit - /home/autoph/public_html/connect/CLR_Clearance_update.php
Back
<?php include '../../cfg/asaconn.php'; $mykey = $_GET['keyID']; //========================================================= if($mykey == 20101088991122){ //SIGN CLEARANCE FORM $userID= $_REQUEST['empID']; $clID= $_REQUEST['clID']; $keyCode= $_REQUEST['keyCode']; $sla= $_REQUEST['sla']; $TotalApprover = 0; $totalSignature = 0; $Rating = 0; $status =""; $sql="UPDATE cl_clearance_data SET cl_approved_by_id = '$userID',cl_approved_date='$curDate',cl_sla_end='$curDate',cl_status='Cleared',cl_actual_sla='$sla',cl_approved_time='$curTime' WHERE cl_id='$clID'"; if ($conn->query($sql) === TRUE) { $status ="Clearance has been signed."; } $countApprover = "SELECT COUNT(1) AS TotalApprover FROM cl_clearance_data WHERE cl_approver_id_a != 0 AND `key_code`='$keyCode'"; $resultA = $conn->query($countApprover); if ($resultA->num_rows > 0) { while($rowA = $resultA->fetch_assoc()){ $totalApprover = $rowA['TotalApprover']; } } $countSignature = "SELECT COUNT(1) AS signedClearance FROM cl_clearance_data WHERE cl_approved_by_id != 0 AND `key_code`='$keyCode'"; $resultB = $conn->query($countSignature); if ($resultB->num_rows > 0) { while($rowB = $resultB->fetch_assoc()){ $totalSignature = $rowB['signedClearance']; } } if($totalSignature > 100 ){ $totalSignature = 100; } $Rating = ($totalSignature / $totalApprover) * 100; $myRating = number_format($Rating,2,'.',','); echo json_encode(["TotalApprover" => "$totalApprover","totalSignature" => "$totalSignature","status"=>"$status","myRating"=>"$myRating"]); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings