<?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);
$compID= $user_data['company'];
$myDate = date_create() ->format("Y-m-d"); 
$toTime =date('H:i:s');
$dateTime = $myDate . " ".$toTime;
$myEmpID = $user_data['u_id'];
//echo $myEmpID;
//$myActiveFinalPay = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id` ='$compID' AND `cl_h_hr_approval`='APPROVED'"),0); 
$myCheckPreparation = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id` ='$compID' AND `cl_h_hr_approval`='CHECK PREPARATION'"),0);
echo $myCheckPreparation;
?>