File manager - Edit - /home/autoph/public_html/voc/home/CL_UPDATE_APPROVAL_COUNT.php
Back
<?php include 'core/init.php'; //$connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; //mysql_connect('localhost','root','aee1024') or die ($connect_error); //mysql_select_db('db_vts') or die($connect_error); error_reporting(0); $comID= $user_data['company']; $myDate = date_create() ->format("Y-m-d"); $toTime =date('H:i:s'); $dateTime = $myDate . " ".$toTime; $userID = $user_data['u_id']; //echo $myEmpID; $clearanceForOfficerApproval = mysql_result(mysql_query("SELECT COUNT(DISTINCT(key_code)) FROM `cl_clearance_data` WHERE `cl_approver_id_a`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1' || `cl_approver_id_b`='$userID' AND `cl_approved_by_id` = 0 AND `hdr_status` = '1'"),0); $forAuthorization = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id`='$comID' AND `cl_hr_approval_id` ='$userID' AND `cl_hr_approval_timestamp`='' AND `hdr_status` = 0"),0); $myEndorsement = mysql_result(mysql_query("SELECT COUNT(h_id) 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'"),0); $myForMyFinalApproval = mysql_result(mysql_query("SELECT COUNT(h_id) 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 `hdr_status` = 4 || `cl_approver_id_b` ='$userID' AND `cl_approver_id_timestamp`='' AND `cl_recommender_b_timestamp`!='' AND `cl_recommender_a_timestamp`!='' AND `hdr_status` = 4"),0); $myForApproval = $clearanceForOfficerApproval + $forAuthorization + $myEndorsement + $myForMyFinalApproval; $myForApproval = $clearanceForOfficerApproval + $forAuthorization + $myEndorsement + $myForMyFinalApproval; echo $myForApproval; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings