File manager - Edit - /home/autoph/public_html/tasks/CLR_Clearance_Count.php.tar
Back
home/autoph/public_html/connect/CLR_Clearance_Count.php 0000644 00000005342 15025045172 0017172 0 ustar 00 <?php include '../../cfg/asaconn.php'; $mykey = $_GET['ApiKey']; //========================================================= if($mykey == 'CLR10241977091101'){ $userID= $_REQUEST['user_id']; $forAuthorize = '0'; $forEndorsement = '0'; $forFinal = '0'; $forSign ='0'; $total ='0'; if($userID == "" || $userID == 0){ $forAuthorize = '0'; $forEndorsement = '0'; $forFinal = '0'; $forSign ='0'; $total ='0'; }else{ $sqAuthorize ="SELECT COUNT(1) AS Approval FROM `cl_clearance_header` WHERE `cl_hr_approval_id` ='$userID' AND `hdr_status` = 0"; $resultA = $conn->query($sqAuthorize); if ($resultA->num_rows > 0) { while($rowA = $resultA->fetch_assoc()) { $forAuthorize = $rowA['Approval']; } } $sqEndorsement ="SELECT COUNT(1) AS Endorse FROM `cl_clearance_header` WHERE `cl_recommender_a_id` ='$userID' AND `cl_recommender_a_timestamp`='' AND `cl_h_hr_approval` = 'FOR ENDORSEMENT' || `cl_recommender_b_id` ='$userID' AND `cl_recommender_b_timestamp`='' AND `cl_h_hr_approval` = 'FOR ENDORSEMENT'"; $resultB = $conn->query($sqEndorsement); if ($resultB->num_rows > 0) { while($rowB = $resultB->fetch_assoc()) { $forEndorsement = $rowB['Endorse']; } } $sqFinal ="SELECT COUNT(1) AS forFinal FROM `cl_clearance_header` WHERE `cl_approver_id` ='$userID' AND `cl_approver_id_timestamp`='' AND `cl_recommender_b_timestamp`!='' AND `cl_recommender_a_timestamp`!='' AND `cl_h_hr_approval`='FINAL APPROVAL' || `cl_approver_id_b` ='$userID' AND `cl_approver_id_b_timestamp`='' AND `cl_recommender_b_timestamp`!='' AND `cl_recommender_a_timestamp`!='' AND `cl_h_hr_approval`='FINAL APPROVAL'"; $resultC = $conn->query($sqFinal); if ($resultC->num_rows > 0) { while($rowC = $resultC->fetch_assoc()) { $forFinal = $rowC['forFinal']; } } $sqSign ="SELECT COUNT(1) AS sign FROM `cl_clearance_data` WHERE `cl_approver_id_a`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' AND `deleted`='No' || `cl_approver_id_b`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' AND `deleted`='No'"; $resultD = $conn->query($sqSign); if ($resultD->num_rows > 0) { while($rowD = $resultD->fetch_assoc()) { $forSign = $rowD['sign']; } } $total = $forAuthorize + $forEndorsement + $forFinal + $forSign; } echo json_encode(["forAuthorize" => "$forAuthorize","forEndorsement" =>"$forEndorsement","forFinal" =>"$forFinal", "forSign" => "$forSign","Total" =>"$total"]); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings