"; 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 ""; ?> 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 ""; 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 ""; echo ""; echo ""; echo ""; echo ""; ?>
MONTH SYNERGY OUT BRAND DISTRIBUTIONS
TARGET ACTUAL RATE(%) 0){ echo ""; while($row = mysqli_fetch_array($qVar)){ echo ""; } }else{ echo "

$myMonth"; $vart = "SELECT * FROM `vts_company` WHERE `comp_status`=1 AND `brand`='Yes' ORDER BY `comp_code` ASC"; $qVart = mysqli_query($conn,$vart); while($vati = mysqli_fetch_array($qVart)){ $activeModel = $vati['comp_id']; $compCode = $vati['comp_code']; $countActualByModelByMonth = "SELECT SUM(sales_count) AS 'SalesCount' FROM `mancom_synergy_out_company` WHERE `comp_code`='$compCode' AND `month_id`='$myMonth' AND `year`='$year' AND `mancom_hdr_id`='$manHeadercomID'"; $qCount = mysqli_query($conn,$countActualByModelByMonth); $qRow = mysqli_num_rows($qCount); if($qRow > 0){ while($mRow = mysqli_fetch_array($qCount)){ $modCount = $compCode."".$myMonth; echo "

"; } } } echo ""; } echo ""; $variant ="SELECT * FROM `vts_company` WHERE `comp_status`=1 AND `brand`='Yes' ORDER BY `comp_code` ASC"; $qVar = mysqli_query($conn,$variant); $qvCount = mysqli_num_rows($qVar); if($qvCount > 0){ echo ""; while($row = mysqli_fetch_array($qVar)){ echo ""; } } echo""; ?>
MONTH".$row['comp_code'].""; //echo ""; echo ""; //echo number_format(($mRow['SalesCount']),0);MANCOM_VehicleSalesReport echo "
TOTAL"; $activeModel = $row['comp_id']; $compCode = $row['comp_code']; $totaSalesCount=0; $totayModelSales = "SELECT SUM(sales_count) AS 'totaSalesCount' FROM `mancom_synergy_out_company` WHERE `comp_code`='$compCode' AND `year`='$year' AND `mancom_hdr_id`='$manHeadercomID'"; $qCount = mysqli_query($conn,$totayModelSales); $qRow = mysqli_num_rows($qCount); if($qRow > 0){ while($sRow = mysqli_fetch_array($qCount)){ $totaSalesCount = $sRow['totaSalesCount']; } echo $totaSalesCount; } echo "
".$row['month_id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
TOTAL"; echo ""; echo""; echo ""; echo ""; echo ""; echo "

close(); } ?>