".$count."";
echo "| ".strtoupper($row['reference_code'])." | ";
echo "".strtoupper($row['date_created'])." | ";
echo "".strtoupper($prfCompName)." | ";
echo "".strtoupper($prfDealName)." | ";
echo "".strtoupper($prfCatName)." | ";
echo "".strtoupper($prfSubCatName)." | ";
echo "";
$status = $row['current_status'];
$statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0);
echo $statusName;
echo" | ";
echo "";
$chkAttachment = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_attachment` WHERE `prf_number` = '".$row['reference_code']."'"),0);
$withMail ='📝';
$attFilename = mysql_result(mysql_query("SELECT `document_name` FROM `prf_attachment` WHERE `prf_number` = '".$row['reference_code']."'"),0);
$noMail = '-';
if($chkAttachment > 0){
echo "📑";
}else{
echo $noMail;
}
echo" | ";
echo "
";
}
//##################################################################################################################################################################################
//FOR GM APPROVAL APPEND TO TABLE
$getItemHdrGM = mysql_query("SELECT *FROM `prf_request_hdr` WHERE `approving_GM_id` ='$uniqueRefID' AND `deleted`=0 AND `gm_approval_date`='' AND `dept_approval_date`!='' AND `current_status` = 2 AND current_status < 90 ORDER BY id DESC");
while($row=mysql_fetch_array($getItemHdrGM)){
$count = $count + 1;
$prfCompID = $row['comp_id'];
$prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0);
$prfDealID = $row['deal_id'];
$prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0);
$prfCatID = $row['category_id'];
$prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0);
$prfSubCatID = $row['sub_category_id'];
$prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0);
$prfDeptApproverID = $row['dept_head_id'];
$prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0);
$prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0);
$prfStatus = $row['current_status'];
//onDblclick="javascript:showFollowUp(this);"
?>".$count."";
echo "| ".strtoupper($row['reference_code'])." | ";
echo "".strtoupper($row['date_created'])." | ";
echo "".strtoupper($prfCompName)." | ";
echo "".strtoupper($prfDealName)." | ";
echo "".strtoupper($prfCatName)." | ";
echo "".strtoupper($prfSubCatName)." | ";
echo "";
$status = $row['current_status'];
$statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0);
echo $statusName;
echo" | ";
echo "";
$checkUnReadMail = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_ff_message` WHERE `ref_code`='".$row['reference_code']."' AND `read`=0 AND `send_to`='$uniqueRefID'"),0);
$withMail ='📩';
$noMail = '✉';
if($checkUnReadMail > 0){
echo "".$withMail."";
}else{
echo $noMail;
}
echo" | ";
echo "
";
}
//##################################################################################################################################################################################
//AUTHORIZING DEPARTMENT / CHECKING ASSET / SPECS
$getItemHdrAsset = mysql_query("SELECT *FROM `prf_request_hdr` WHERE `approving_admin_id` ='$uniqueRefID' AND `gm_approval_date`!= '' AND `admin_approval_date`='' AND `deleted`=0 AND current_status < 90 ORDER BY id DESC");
while($row=mysql_fetch_array($getItemHdrAsset)){
$count = $count + 1;
$prfCompID = $row['comp_id'];
$prfCompName = mysql_result(mysql_query("SELECT comp_name from vts_company WHERE comp_id = $prfCompID"),0);
$prfDealID = $row['deal_id'];
$prfDealName = mysql_result(mysql_query("SELECT deal_name from vts_dealerships WHERE deal_id = $prfDealID"),0);
$prfCatID = $row['category_id'];
$prfCatName = mysql_result(mysql_query("SELECT description from prf_expensecategory WHERE id= $prfCatID"),0);
$prfSubCatID = $row['sub_category_id'];
$prfSubCatName = mysql_result(mysql_query("SELECT description from prf_expenseitems WHERE id= $prfSubCatID"),0);
$prfDeptApproverID = $row['dept_head_id'];
$prfDeptApproverFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $prfDeptApproverID"),0);
$prfDeptApproverLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $prfDeptApproverID"),0);
$prfStatus = $row['current_status'];
//onDblclick="javascript:showFollowUpAsset(this);"
?>".$count."";
echo "| ".strtoupper($row['reference_code'])." | ";
echo "".strtoupper($row['date_created'])." | ";
echo "".strtoupper($prfCompName)." | ";
echo "".strtoupper($prfDealName)." | ";
echo "".strtoupper($prfCatName)." | ";
echo "".strtoupper($prfSubCatName)." | ";
echo "";
$status = $row['current_status'];
$statusName =mysql_result(mysql_query("SELECT status_name FROM prf_status WHERE sequence = $status"),0);
echo $statusName;
echo" | ";
echo "";
$checkUnReadMail = mysql_result(mysql_query("SELECT COUNT(id) FROM `prf_ff_message` WHERE `ref_code`='".$row['reference_code']."' AND `read`=0 AND `send_to`='$uniqueRefID'"),0);
$withMail ='📩';
$noMail = '✉';
if($checkUnReadMail > 0){
echo "".$withMail."";
}else{
echo $noMail;
}
echo" | ";
echo "
";
}
//##################################################################################################################################################################################
//##################################################################################################################################################################################
?>
|
| Selected Record: |
|