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