<?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;
//$unPostedClearance = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id` ='$compID' AND `hdr_status`=0"),0);
$unPostedClearance = mysql_result(mysql_query("SELECT COUNT(h_id) FROM `cl_clearance_header` WHERE `cl_h_comp_id` ='$compID' AND `hdr_status` = 0 AND `cl_status`= 1"),0);
 
echo $unPostedClearance;
?>