☸     CLEARANCE TEMPLATE MODULE

;
"; echo ""; echo "No."; echo "LEVEL"; echo "DESCRIPTION"; echo "COVERAGE"; echo "RECOMMENDER #1"; echo "RECOMMENDER #2"; echo "APPROVER #1"; echo "APPROVER #2"; echo "AUTHORIZING HR"; echo "PAYROLL OFFICER"; echo "ACCOUNTING OFFICER"; echo "TREASURY OFFICER"; echo "LEGAL OFFICER"; ECHO ""; while($row=mysql_fetch_array($gtTempHeader)){ $rcaF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcaL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_a']."'"),0); $rcbF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $rcbL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_recommending_officer_b']."'"),0); $aprF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer']."'"),0); $aprHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_hr_approval_id']."'"),0); $aprHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_hr_approval_id']."'"),0); $aprHRFB = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer_b']."'"),0); $aprHRLB = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['cl_approving_officer_b']."'"),0); $payHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['payroll_officer']."'"),0); $payHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['payroll_officer']."'"),0); $accHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['accounting_officer']."'"),0); $accHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['accounting_officer']."'"),0); $treHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['treasury_officer']."'"),0); $treHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['treasury_officer']."'"),0); $legHRF = mysql_result(mysql_query("SELECT `u_fname` from `vts_users` WHERE `u_id`='".$row['legal_officer']."'"),0); $legHRL = mysql_result(mysql_query("SELECT `u_lname` from `vts_users` WHERE `u_id`='".$row['legal_officer']."'"),0); ?>".$row['id'].""; echo ""; if($row['cl_template_tag']==='CO'){ echo "COMPANY LEVEL"; }else{ echo "AUTOHUB LEVEL"; } echo""; echo "".$row['cl_template_name'].""; echo ""; echo $row['cl_template_rank']; echo""; echo ""; echo $rcaL .', '.$rcaF; echo""; echo ""; echo $rcbL .', '.$rcbF; echo""; echo ""; echo $aprL .', '.$aprF; echo""; echo ""; echo $aprHRLB .', '.$aprHRFB; echo""; echo ""; echo $aprHRL .', '.$aprHRF; echo""; echo ""; echo $payHRL .', '.$payHRF; echo""; echo ""; echo $accHRL .', '.$accHRF; echo""; echo ""; echo $treHRL .', '.$treHRF; echo""; echo ""; echo $legHRL .', '.$legHRF; echo""; echo ""; } echo ""; ?>