";
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 addModelSales==============================================================================================
//==============================================================================================================
echo " ";
echo " ";
echo " ";
echo " ";
echo " ";
echo "";
?>
MONTH
SYNERGY OUT
BRAND DISTRIBUTIONS
TARGET
ACTUAL
RATE(%)
query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . " " . $conn->error;
}
}
}
//READ AND LOAD MONTHLY SYNERGY SALES TOTAL=====================================================
//READ AND LOAD MONTHLY SYNERGY SALES TOTAL=====================================================
$TotalSalesRating =0;
$monthsData = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
foreach ($monthsData as $value) {
echo " ";
$getD = "SELECT * FROM `mancom_synergy_out` WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$value' AND `deleted`=0";
$qgetD = mysqli_query($conn,$getD);
$gRow = mysqli_num_rows($qgetD);
$rtJanTarget = "Target".$value;
$rtJanActual = "Actual".$value;
$rtJanRate = "Rate".$value;
if($gRow > 0){
while($row=mysqli_fetch_array($qgetD)){
$targetSales = $row['target_sales'];
$rtTotalTarget = $rtTotalTarget + $targetSales;
$SalesRating = 0;
$SalesRatingX = 0;
$temRate = 0;
$temRate = str_replace("%","", $row['target_vs_actual_rate']);
if(is_numeric($temRate)){
}else{
$temRate = 0;
}
$rtTotalRate = ($rtTotalRate + $temRate);
//GET MONTHLY SALES
$mSales = "SELECT SUM(`sales_count`) as 'MonthlySales' FROM mancom_synergy_out_company WHERE `mancom_hdr_id`='$manHeadercomID' AND `comp_id`='$selectedCompanyID' AND `deal_id`='$dealerID' AND `month_id`='$value' AND `deleted`=0";
$qSales = mysqli_query($conn,$mSales);
while($sal = mysqli_fetch_array($qSales)){
$monthlySales = $sal['MonthlySales'];
}
if($monthlySales > 0 && $targetSales > 0){
$SalesRatingX = number_format(($monthlySales / $targetSales * 100),2,'.','')."%";
$SalesRating = number_format(($monthlySales / $targetSales * 100),2,'.','');
}else{
$SalesRating = $SalesRating;
}
$TotalSalesRating = $TotalSalesRating + $SalesRating;
$rtTotalActual = $rtTotalActual + $monthlySales;
echo "".$row['month_id']." ";
echo "";
echo " ";
echo " ";
echo "";
echo " ";
echo " ";
echo "";
echo " ";
echo " ";
}
}else{
echo "Something is wrong!";
}
echo " ";
}
//DISPLAY MONTHLY SYNERGY SALES TOTAL SUMMART=====================================================
//DISPLAY MONTHLY SYNERGY SALES TOTAL SUMMART=====================================================
$rtTotalRate = number_format(($TotalSalesRating / 12),2,'.','')."%";
echo "";
echo "TOTAL ";
echo "";
echo " ";
echo" ";
echo "";
echo " ";
echo " ";
echo "";
echo " ";
echo " ";
echo " ";
?>
close();
}
?>