";
echo "
";
echo "";
echo "| ORGANIZATIONAL UNIT/DEALERSHIP/COMPANY CLEARANCE | ";
echo "";
echo "";
echo "| ACCOUNTABILITY AREAS | ";
echo "CLEARANCE OFFICERS | ";
echo "DATE | ";
echo "REMARKS | ";
echo "
";
echo "";
echo "| OFFICER NAME | ";
echo " STATUS | ";
echo "RECEIVED DATE | ";
echo "DATE SIGNED | ";
echo "
";
echo "";
echo "";
$aprDiv = mysql_query("SELECT * FROM `cl_approving_division` WHERE `cl_div_status` = 1 ORDER BY `id` ASC");
echo "";
while($dRow = mysql_fetch_array($aprDiv)){
$uCount = 0;
$padding ='5px';
$divID = $dRow['id'];
$counter = $counter + 1;
//$getID
echo "
".$counter." ".$dRow['cl_div_name'];
//=========================================================
//=========================================================
$getUnitData = mysql_query("SELECT * FROM `cl_approving_unit` WHERE `cl_div_id`='$divID' ORDER BY `cl_order` ASC");
echo "";
while($uRow = mysql_fetch_array($getUnitData)){
$unitID = $uRow['id'];
$uCount = $uCount + 1;
echo "";
echo"| ";
echo $counter .".".$uCount." ".$uRow['cl_unit_name'];
echo " | ";
echo"";
$getSignatory = mysql_result(mysql_query("SELECT `cl_approver_id_a` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0);
$getSignatoryFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$getSignatory'"),0);
$getSignatoryLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$getSignatory'"),0);
echo strtoupper($getSignatoryLName.', '.$getSignatoryFName);
echo " | ";
echo"";
$getDateSigned = mysql_result(mysql_query("SELECT `cl_approved_date` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0);
$getTimeSigned = mysql_result(mysql_query("SELECT `cl_approved_time` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0);
if($getDateSigned !='' AND $getTimeSigned !=''){
echo "Signed & Cleared";
}else{
echo "-";
}
echo " | ";
echo"";
$getReceived = mysql_result(mysql_query("SELECT `cl_sla_start` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0);
echo $getReceived;
echo " | ";
echo"";
$getDateSigned = mysql_result(mysql_query("SELECT `cl_approved_date` FROM `cl_clearance_data` WHERE `key_code`='$keyCode' AND `cl_template_id`='$hdrTemplate' AND `cl_div_id`='$divID' AND `cl_unit_id`='$unitID'"),0);
echo $getDateSigned;
echo " | ";
echo"";
echo " | ";
echo " ";
}
//=========================================================
//=========================================================
echo "";
echo " ";
}
echo " | ";
echo " | ";
echo "
";
echo "
";
//################################################################################################################################
//################################################################################################################################
$aprEndorserA = mysql_result(mysql_query("SELECT `cl_recommender_a_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0);
$endorserAFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprEndorserA'"),0);
$endorserALName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprEndorserA'"),0);
$endorserAPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$aprEndorserA'"),0);
$dateEndorsedA = mysql_result(mysql_query("SELECT `cl_recommender_a_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0);
$aprEndorserB = mysql_result(mysql_query("SELECT `cl_recommender_b_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0);
$endorserBFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprEndorserB'"),0);
$endorserBLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprEndorserB'"),0);
$endorserBPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$aprEndorserB'"),0);
$dateEndorsedB = mysql_result(mysql_query("SELECT `cl_recommender_b_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0);
$aprApprover = mysql_result(mysql_query("SELECT `cl_approver_id` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0);
$aprApproverFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprApprover'"),0);
$aprApproverLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprApprover'"),0);
$aprApproverPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$aprApprover'"),0);
$dateApproved = mysql_result(mysql_query("SELECT `cl_approver_id_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0);
$aprApproverB = mysql_result(mysql_query("SELECT `cl_approver_id_b` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0);
$aprApproverBFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$aprApproverB'"),0);
$aprApproverBLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$aprApproverB'"),0);
$aprApproverBPosition = mysql_result(mysql_query("SELECT `u_position` FROM `vts_users` WHERE `u_id`='$aprApproverB'"),0);
$dateApprovedB = mysql_result(mysql_query("SELECT `cl_approver_id_b_timestamp` FROM `cl_clearance_header` WHERE `h_id`='$getID'"),0);
echo "
";
//################################################################################################################################
//################################################################################################################################
echo "
";
echo "