format("Y-m-d");
$prfTime = date('H:i:s');
$myDate = date_create() ->format("Y-m-d");
$activeID=$user_data['u_id'];
$ITADM=$user_data['IT_ADM'];
echo "";
echo "";
if(isset($_POST['done'])){
$loadPRFItem = mysql_escape_string($_POST['loadPRFItem']);
echo "";
$chkIfPRFExist = mysql_result(mysql_query("SELECT COUNT(1) FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
if($chkIfPRFExist==0){
echo '';
}else{
$deptHeadID = mysql_result(mysql_query("SELECT `dept_head_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
$deptHeadIDSigned = mysql_result(mysql_query("SELECT `dept_approval_date` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
if($deptHeadIDSigned !=''){
$chngeDeptID ='Enable';
}else{
$chngeDeptID ='Enable';
}
$deptHeadFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0);
$deptHeadLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$deptHeadID'"),0);
$reqID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
$reqFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqID'"),0);
$reqLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqID'"),0);
$gmID = mysql_result(mysql_query("SELECT `approving_GM_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
$gmIDSigned = mysql_result(mysql_query("SELECT `gm_approval_date` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
if($gmIDSigned !=''){
$chngeGMID ='Enable';
}else{
$chngeGMID ='Enable';
}
$gmFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$gmID'"),0);
$gmLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$gmID'"),0);
$assValID = mysql_result(mysql_query("SELECT `approving_admin_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
$assIDSigned = mysql_result(mysql_query("SELECT `admin_approval_date` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
if($assIDSigned !=''){
$chngeAssID ='Enable';
}else{
$chngeAssID ='Enable';
}
$assFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$assValID'"),0);
$assLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$assValID'"),0);
$curStatus = mysql_result(mysql_query("SELECT `current_status` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
if($curStatus > 9){
$chngeStat ='Enable';
}else{
$chngeStat ='Enable';
}
$curStatusName = mysql_result(mysql_query("SELECT `status_name` FROM `prf_status` WHERE `sequence`='$curStatus'"),0);
$curExpenseTypeID = mysql_result(mysql_query("SELECT `category_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
$curExpenseTypeName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$curExpenseTypeID'"),0);
$curExpenseSubTypeID = mysql_result(mysql_query("SELECT `sub_category_id` FROM `prf_request_hdr` WHERE `reference_code`='$loadPRFItem'"),0);
$curExpenseSubTypeName = mysql_result(mysql_query("SELECT `description` FROM `prf_expenseitems` WHERE `id`='$curExpenseSubTypeID'"),0);
}
echo "";
echo "
Department Head:
";
echo "
";
echo "
Gen. Manager:
";
echo "
";
echo "
Requestor:
";
echo "
";
echo "
Asset Validator:
";
echo "
";
echo "
EXPENSE TYPE:
";
echo "
";
echo "
CATEGORY:
";
echo "
";
echo "
RETURN TO CANVASS:
";
echo "
INPUT ITEM CODE:";
echo "
";
echo "
";
echo "NOTES/REMARKS:
";
echo "
";
}
?>