0 AND `current_status` < 13 AND `deleted` = 0"),0);
//$userCanvassApproval= mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `request_by` ='$userID' AND `current_status`=5 AND `deleted` = 0"),0); 1024008751
$getItemUsrApproval = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `request_by` ='$userID' AND `deleted` = 0 AND `current_status` = 5 ORDER BY id DESC");
while($row=mysql_fetch_array($getItemUsrApproval)){
$chkIfForUSRApproval=$row['user_canvass_approval'];
$hdrRefCode = $row['reference_code'];
$getMyuserApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `header_ref_code`='$hdrRefCode' AND `user_canvass_approval`= 1 AND `user_approval_ts`='' AND `create_canvass_sheet`= '0' AND `deleted`=0"),0);
$userCanvassApproval = $userCanvassApproval + $getMyuserApproval;
}
//echo $userCanvassApproval;
if($userCanvassApproval == ''){
$userCanvassApproval = '0';
}
$PostedForDeptApprovalGM = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_GM_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `gm_approval_date`='' AND `dept_approval_date`!='' AND `admin_approval_date`!=''"),0);
$PostedForDeptApprovalHead = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `dept_head_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `dept_approval_date`='' "),0);
$PostedForDeptApprovalAdmin = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_admin_id` ='$userID' AND `current_status`!= 0 AND `current_status` < 4 AND `deleted` = 0 AND `admin_approval_date`='' AND `dept_approval_date`!='' AND `gm_approval_date`!=''"),0);
$PostedForDeptApproval = $PostedForDeptApprovalHead + $PostedForDeptApprovalGM + $PostedForDeptApprovalAdmin;
$ActiveProposal = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_uploadedcanvass` WHERE `deleted`= 0 AND `validity_date` > '$toDate'"),0);
$procIncomingView = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `current_status` < 4 AND `deleted`=0"),0);
$deptPRFCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `dept_id` '$MyDeptID' AND `deleted`=0"),0);
/* $getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `for_execom_canvass_approval`=0 AND `for_canvass` = 1 ORDER BY id DESC");
while($row=mysql_fetch_array($getItemHdr)){
$itemRefCode=$row['header_ref_code'];
$getPRFApprovalCode = mysql_result(mysql_query("SELECT current_status FROM prf_request_hdr WHERE reference_code='$itemRefCode' "),0);
if($getPRFApprovalCode == 4){
$forCanvassCount = $forCanvassCount + 1;
}
} */
$ahgAdminApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `deleted`=0 AND `ahg_admin_id`=0 AND `ahg_admin_date`='' AND `gm_approval_date`!='' AND `dept_approval_date`!='' AND `admin_approval_date`!=''"),0);
$forCanvassCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted`=0 AND `served`='0' AND `awarded` = 0 AND `for_canvass` = 1 AND `award_to_vendor_id` = 0 AND `user_canvass_approval`=0 AND `ahg_admin_id`!=0 AND `ahg_admin_date`!='' AND `ahg_admin_id`!=0 AND `ahg_admin_date`!='' ORDER BY id DESC"),0);
if($forCanvassCount == ''){
$forCanvassCount = 0;
}
$MyCanvassSheet = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `create_canvass_sheet`= 1 AND `deleted`=0 AND `awarded`='0' AND `create_canvass_sheet`= 1 AND `for_execom_canvass_approval`=0 AND `canvass_sheet_creation_ts`=''"),0);
$chkMyOpenMessage = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_ff_message` WHERE `read`= 1 AND `deleted`=0 AND `send_to`='$userID'"),0);
$PostedExeComApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `for_execom_canvass_approval`=1 AND `canvass_sheet_creation_ts`!='' AND `execom_approval_ts`='' AND `awarded`=0"),0);
$ReadyForPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `awarded`= 1 AND `deleted`=0 AND `execom_approval_ts`!= '' AND `for_execom_canvass_approval`=1 AND `po_code`=''"),0);
$POApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status` = 2"),0);
$ActivePO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1"),0);
$forPaymentPO = mysql_result(mysql_query("SELECT COUNT(1) FROM (SELECT * FROM `prf_delivery_receiving_logs` WHERE `inv_status`='Unpaid' GROUP BY `inv_number`) t1 "),0);
$ReadySubmission = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 3"),0);
$vendorsUpdate = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 4"),0);
echo "