(".$getDeptIDFName." ".$getDeptIDLName.")"; $pendingDeptName = "Waiting for ". $getDeptIDFName . " " . $getDeptIDLName. " Approval"; if($getDeptID == $uniqueRefID){ $bgColor='#d1faa0'; $view='True'; }else{ $bgColor='#eef0eb'; $view='False'; } } if($getMatrixLevel == 4){ $chkIfGMSigned = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."' AND `approved_by_execom` = '$getCompanyGMID'"),0); if($chkIfRAOSigned == 1){ $rSign = '✅'; }else{ $rSign = '❌'; } if($chkIfGMSigned == 1){ $gSign = '✅'; }else{ $gSign = '❌'; } $pendingApproval ="GM/SVP/AVP
(".$gSign.") ".$getGMIDFName." ".$getGMIDLName."
(".$rSign.") ".$getRAFName." ".$getRALName." "; $pendingDeptName = "Waiting for approval..."; if($getCompanyGMID == $uniqueRefID || $getRequiredApprover==$uniqueRefID){ $bgColor='#ff8480 '; $view='True'; }else{ $bgColor='#eef0eb'; $view='False'; } } if($getMatrixLevel < 4){ $chkIfImExecom = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execommembers` WHERE `execom_id`='$uniqueRefID' AND `authority` < 4 AND `comp_id`='$reqCompID'"),0); //echo "Im EXE". $chkIfImExecom . "comp: " .$reqCompID; $ExecomCount = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_execomcanvassapproval` WHERE `item_code`='".$row['id']."'"),0); if($chkIfRAOSigned == 1){ $rSign = '✅'; }else{ $rSign = '❌'; } $pendingApproval ="EXECOM:(Any of EXECOM Members)"; $pendingApproval ="ANY EXECOM MEMBERS:
".$ExecomCount." out of 3 has been signed
(".$rSign.") ".$getRAFName." ".$getRALName." "; $pendingDeptName = "Waiting for ". $getGMIDFName . " " . $getGMIDLName. " Approval"; $pendingDeptName = "Waiting for EXECOM Approval"; if($chkIfImExecom > 0){ $bgColor='#ff8480 '; $view='True'; }else{ $bgColor='#eef0eb'; $view='False'; } } if($PRFPUR==1){ ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; }else{ if($view === 'True'){ ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } } } ?>

".strtoupper($reqCompName); echo " PRF.#: ".$regHDRcode .""; echo "	".strtoupper($reqByLName).", ".strtoupper($reqByFName); $chkIfWithComment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomnotes` WHERE `item_id`='$activeItemID'"),0); if($chkIfWithComment > 0){ echo " 🚩"; } echo"	".strtoupper($row['item_description'])."	".$regCatName."	".strtoupper($row['quantity'])."	".strtoupper($dateNeeded)."	".strtoupper($pendingApproval)."	".strtoupper($getMatrixLevel)."
".strtoupper($reqCompName)."	".strtoupper($reqByLName).", ".strtoupper($reqByFName); $chkIfWithComment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_execomnotes` WHERE `item_id`='$activeItemID'"),0); if($chkIfWithComment > 0){ echo " 🚩"; } echo "	".strtoupper($row['item_description'])."	".$regCatName."	".strtoupper($row['quantity'])."	".strtoupper($dateNeeded)."	".strtoupper($pendingApproval)."	".strtoupper($getMatrixLevel)."
Selected Record: