File manager - Edit - /home/autoph/public_html/connect/home/forMyApprovalClick.php
Back
<?php include_once 'core/init.php'; $userID = $user_data['u_id']; if(isset($_POST['trans'])){ $trans = mysql_escape_string($_POST['trans']); $PostedForDeptApprovalGM = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_GM_id` ='$userID' AND `deleted` = 0 AND `gm_approval_date`='' AND `dept_approval_date`!='' AND `current_status`=2"),0); $PostedForDeptApprovalHead = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `dept_head_id` ='$userID' AND `deleted` = 0 AND `dept_approval_date`='' AND `current_status`!=0 AND `current_status` < 90"),0); $PostedForDeptApprovalAdmin = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_admin_id` ='$userID' AND `admin_approval_date`= '' AND `deleted` = 0 AND `dept_approval_date`!='' AND `gm_approval_date`!='' AND `current_status` < 90"),0); $PostedForDeptApproval = $PostedForDeptApprovalHead + $PostedForDeptApprovalGM + $PostedForDeptApprovalAdmin; echo $PostedForDeptApproval; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings