"; 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_sales` 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; 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_by_model 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){ //echo $monthlySales . "TESST"; $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 IN BRAND DISTRIBUTIONS
TARGET ACTUAL RATE(%) 0){ echo ""; while($row = mysqli_fetch_array($qVar)){ echo ""; } }else{ echo "

$myMonth"; $vart = "SELECT * FROM `pms_car_models` WHERE `deleted`=0 AND `brand_id`='$brandID' ORDER BY `model_code` ASC"; $qVart = mysqli_query($conn,$vart); while($vati = mysqli_fetch_array($qVart)){ $activeModel = $vati['id']; $modelCode = $vati['model_code']; $countActualByModelByMonth = "SELECT SUM(sales_count) AS 'SalesCount' FROM `mancom_synergy_by_model` WHERE `model_id`='$activeModel' AND `comp_id`='$selectedCompanyID' 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 = $modelCode."".$myMonth; echo "

"; } } } echo ""; } echo ""; $variant = "SELECT * FROM `pms_car_models` WHERE `deleted`=0 AND `brand_id`='$brandID' ORDER BY `model_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['model_code'].""; //echo ""; echo ""; //echo number_format(($mRow['SalesCount']),0);MANCOM_VehicleSalesReport echo "
TOTAL"; $activeModel = $row['id']; $totaSalesCount=0; $totayModelSales = "SELECT SUM(sales_count) AS 'totaSalesCount' FROM `mancom_synergy_by_model` WHERE `model_id`='$activeModel' AND `comp_id`='$selectedCompanyID' 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(); } ?>