<?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;
?>