File manager - Edit - /home/autoph/public_html/connect/home/canvssForExecomApprovalCount.php
Back
<?php include_once 'core/init.php'; $userID = $user_data['u_id']; $prfDate = date_create() ->format("Y-m-d"); if(isset($_POST['trans'])){ $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `for_execom_canvass_approval`= 1 AND `deleted`=0 AND `awarded`='0' AND `execom_approval_ts`=''"); while($row=mysql_fetch_array($getItemHdr)){ $chkIfAlreadySigned = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."' AND `approved_by_execom` = '$userID'"),0); $regHDRcode=$row['header_ref_code']; $getEndorsedAmountFromCanvassSheet = mysql_result(mysql_query("SELECT `amount` FROM `prf_canvass_sheet` WHERE `item_id`='".$row['id']."' AND `user_feedback` = 1 AND `user_feedback` != 0"),0); if($chkIfAlreadySigned == 0){ $getMatrixLevel = mysql_result(mysql_query("SELECT `level` FROM `prf_approval_matrix` WHERE '$getEndorsedAmountFromCanvassSheet' BETWEEN `min_amount` AND `max_amount`"),0); if($getMatrixLevel == 5){ $getDeptID = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0); if($getDeptID == $userID){ $PostedExeComApproval = $PostedExeComApproval + 1; } } if($getMatrixLevel == 4){ $getCompanyGMID = mysql_result(mysql_query("SELECT `approving_GM_id` FROM prf_request_hdr WHERE `reference_code`='$regHDRcode'"),0); if($getCompanyGMID == $userID){ $PostedExeComApproval = $PostedExeComApproval + 1; } } if($getMatrixLevel < 4){ $chkIfImExecom = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `execom_id`='$userID' AND `authority` < 4"),0); if($chkIfImExecom > 0){ $PostedExeComApproval = $PostedExeComApproval + 1; } } } } echo $PostedExeComApproval; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings