0 AND `current_status` < 13 AND `deleted` = 0"),0);
$getItemUsrApproval = mysql_query("SELECT * FROM `prf_request_hdr` WHERE `request_by` ='$userID' AND `deleted` = 0 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 AND `approved_canvass`=1 AND `canvass_review_date`!=''"),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 `deleted` = 0 AND `gm_approval_date`='' AND `dept_approval_date`!='' AND `current_status` =2 "),0);
$PostedForDeptApprovalHead = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `dept_head_id` ='$userID' AND `deleted` = 0 AND `dept_approval_date`='' AND `current_status`!=0 AND `current_status` < 90"),0);
$PostedForDeptApprovalAdmin = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_hdr` WHERE `approving_admin_id` ='$userID' AND `admin_approval_date`= '' AND `deleted` = 0 AND `dept_approval_date`!='' AND `gm_approval_date`!='' AND `current_status` < 90"),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(1) FROM `prf_request_hdr` WHERE `dept_id`='$MyDeptID' AND `deleted`=0"),0);
$userPendingApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `deleted` = 0 AND `user_canvass_approval` = 1 AND `user_approval_ts` ='' AND `create_canvass_sheet`=0 AND `approved_canvass`=1"),0);
$canvassReview = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `deleted` = 0 AND `user_canvass_approval` = 1 AND `user_approval_ts` ='' AND `create_canvass_sheet`=0 AND `approved_canvass`=0 AND `item_status`=5"),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;
}
} */
$ahgAdminApprovalLineCount = 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"),0);
$forCanvassCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval` = 0 AND `item_status`=4 AND `canvass_by`='0' AND `ahg_admin_id`!=''"),0);
if($forCanvassCount == ''){
$forCanvassCount = 0;
}
$forCanvassCountAss = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_request_detl` WHERE `deleted`=0 AND `for_canvass` = 1 AND `user_canvass_approval` = 0 AND `item_status`=4 AND `canvass_by`='$userID'"),0);
if($forCanvassCountAss == ''){
$forCanvassCountAss = 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);
$canvassSheetApproval = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_detl` WHERE `approved_canvass`= 0 AND `deleted`=0 AND `user_canvass_approval` = 1 AND `for_canvass`=1"),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);
$getItemHdr = mysql_query("SELECT * FROM `prf_request_detl` WHERE `for_execom_canvass_approval`= 1 AND `deleted`=0 AND `awarded`='0' AND `execom_approval_ts`=''");
while($row=mysql_fetch_array($getItemHdr)){
$chkIfAlreadySigned = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."' AND `approved_by_execom` = '$userID'"),0);
$regHDRcode=$row['header_ref_code'];
$getEndorsedAmountFromCanvassSheet = mysql_result(mysql_query("SELECT `amount` FROM `prf_canvass_sheet` WHERE `item_id`='".$row['id']."' AND `user_feedback` = 1 AND `user_feedback` != 0"),0);
if($chkIfAlreadySigned == 0){
$getMatrixLevel = mysql_result(mysql_query("SELECT `level` FROM `prf_approval_matrix` WHERE '$getEndorsedAmountFromCanvassSheet' BETWEEN `min_amount` AND `max_amount`"),0);
if($getMatrixLevel == 5){
$getDeptID = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$regHDRcode'"),0);
if($getDeptID == $userID){
$PostedExeComApproval = $PostedExeComApproval+1;
}
}
if($getMatrixLevel == 4){
$getCompanyGMID = mysql_result(mysql_query("SELECT `approving_GM_id` FROM prf_request_hdr WHERE `reference_code`='$regHDRcode'"),0);
if($getCompanyGMID == $userID){
$PostedExeComApproval = $PostedExeComApproval+1;
}
}
if($getMatrixLevel < 4){
$chkIfImExecom = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `execom_id`='$userID' AND `authority` < 4"),0);
if($chkIfImExecom > 0){
$PostedExeComApproval = $PostedExeComApproval+1;
}
}
}
}
$unPostedPO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 0 AND `po_status`!=9"),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);
$ActivePO = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status`= 1"),0);
$POApproval = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_purchase_order` WHERE `po_status` =2"),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 "