";
echo "";
echo "";
echo "";
echo "";
echo "";
if($add == 1){$addButton = '';}else{$addButton='Disabled';}
if($edit == 1){$editButton = '';}else{$editButton='Disabled';}
if($delete == 1){$deletButton = '';}else{$deletButton='Disabled';}
if($print == 1){$printButton = '';}else{$printButton='Disabled';}
if($download == 1){$downloadButton = '';}else{$downloadButton='Disabled';}
//use to hide/show data of Plant targets
if($add == 1){$plantView = '';}else{$plantView='none';}
if(checkViewAccessM1024($roleID, $moduleID)[0] == 0){
echo " 
![]()
";
echo " Access Denied
";
echo "
Sorry, you are not authorized to access this page.
Please contact your system support for assistance.
Thank you!
";
exit();
}
//==============================================================================================================
//VALIDATE ACCESS ==============================================================================================
//==============================================================================================================
echo "";
echo "";
echo "";
echo "";
echo "";
?>
| MONTH. |
RETAIL |
FLEET |
TOTAL(OPSPLAN) |
PLANT TARGETS |
| TARGET |
ACTUAL |
RATE(%) |
TARGET |
ACTUAL |
RATE(%) |
TARGET |
ACTUAL |
RATE(%) |
TARGET |
ACTUAL |
RATE(%) |
query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
//=====================================================================
}
}
$monthsData = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
foreach ($monthsData as $value) {
echo " ";
$getD = "SELECT * FROM `mancom_data` WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$value' AND `deleted`=0";
$qgetD = mysqli_query($conn,$getD);
$gRow = mysqli_num_rows($qgetD);
$rtJanTarget = "rtTarget".$value;
$rtJanActual = "rtActual".$value;
$rtJanRate = "rtRate".$value;
$flJanTarget = "flTarget".$value;
$flJanActual = "flActual".$value;
$flJanRate = "flRate".$value;
$opsJanTarget = "opsTarget".$value;
$opsJanActual = "opsActual".$value;
$opsJanRate = "opsRate".$value;
$manJanTarget = "manTarget".$value;
$manJanActual = "manActual".$value;
$manJanRate = "manRate".$value;
if($gRow > 0){
while($row=mysqli_fetch_array($qgetD)){
$rtTotalTarget = $rtTotalTarget + $row['retail_target_sales'];
$flTotalTarget = $flTotalTarget + $row['fleet_target_sales'];
$opsTotalTarget = $opsTotalTarget + $row['ops_total_target'];
$manTotalTarget = $manTotalTarget + $row['plant_target_sales'];
$manTotalActual = $manTotalActual + $row['plant_actual_sales'];
$opsTotalActual = $opsTotalActual + $row['ops_total_sales'];
$rtTotalActual = $rtTotalActual + $row['retail_actual_sales'];
$flTotalActual = $flTotalActual + $row['fleet_actual_sales'];
$temRate = 0;
$temRate = str_replace("%","", $row['retail_target_vs_actual_rate']);
if(is_numeric($temRate)){
}else{
$temRate = 0;
}
$rtTotalRate = ($rtTotalRate + $temRate);
$temRate=0;
$temRate = str_replace("%","", $row['fleet_target_vs_actual']);
if(is_numeric($temRate)){
}else{
$temRate=0;
}
$flTotalRate = $flTotalRate + $temRate;
$temRate=0;
$temRate = str_replace("%","", $row['ops_target_vs_actual']);
if(is_numeric($temRate)){
}else{
$temRate=0;
}
$opsTotalRate = $opsTotalRate + $temRate;
$temRate=0;
$temRate = str_replace("%","", $row['plant_target_vs_actual']);
if(is_numeric($temRate)){
}else{
$temRate = 0;
}
$manTotalRate = $manTotalRate + $temRate;
echo "| ".$row['month_id']." | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
echo "";
echo "";
echo " | ";
}
}else{
echo "Something is wrong!";
}
echo "
";
}
$rtTotalRate = number_format(($rtTotalRate / 12),2,'.','')."%";
$flTotalRate = number_format(($flTotalRate / 12),2,'.','')."%";
$opsTotalRate = number_format(($opsTotalRate / 12),2,'.','')."%";
$manTotalRate = number_format(($manTotalRate / 12),2,'.','')."%";
echo "";
echo "| TOTAL | ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
| ";
echo "
";
?>
close();
}
?>