File manager

File manager - Edit - /home/autoph/public_html/pms_v1/pdfViewer/MANCOM_SynergySalesReportOUT.php

Back
<link rel="stylesheet" type="text/css" href="./css/sidebarmain.css?v=<?php echo time(); ?>"/> <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700,800,900"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"> <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); include ("../pages/loadergif.php"); //error_reporting(0); if(isset($_GET['hid'])){ $reportType = 'synergy_sales'; $rtTotalTarget = 0; $rtTotalActual = 0; $rtTotalRate = 0; $year = $_GET['y']; $dealCode = $_GET['d']; $userID = $_GET['uid']; $compCode = $_GET['c']; $manHeadercomID = $_GET['hid']; $dealerID = getDealerID($dealCode)[0]; $companyID = getCompanyID($compCode)[0]; //GET BRAND ID BY DEALER $gB = "SELECT `brand` FROM `vts_dealerships` WHERE `deal_id`='$dealerID'"; $qG = mysqli_query($conn,$gB); while($b=mysqli_fetch_array($qG)){ $brandID=$b['brand']; } //EDIT is for editing TARGET //ADD is for adding Actual //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); $moduleID = 40; $add =checkViewAccessM1024($roleID, $moduleID)[1]; $edit =checkViewAccessM1024($roleID, $moduleID)[2]; $delete =checkViewAccessM1024($roleID, $moduleID)[3]; $print =checkViewAccessM1024($roleID, $moduleID)[4]; $download =checkViewAccessM1024($roleID, $moduleID)[5]; echo "<input type='hidden' id='addAccess' value='$add'>"; echo "<input type='hidden' id='editAccess' value='$edit'>"; echo "<input type='hidden' id='deleteAccess' value='$delete'>"; echo "<input type='hidden' id='printAccess' value='$print'>"; echo "<input type='hidden' id='downloadAccess' value='$download'>"; echo "<input type='hidden' id='userID' value='$userID'>"; 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 " <center><img src='./images/locked_out_icon.png' width='100' style='margin-top:100px'><img></center> "; echo "<h4 class='text-center text-danger align-middle pt-5'> Access Denied </h4>"; echo "<p class='display-5 text-center text-danger'> Sorry, you are not authorized to access this page. <br>Please contact your system support for assistance. <br><br>Thank you! <br><br> </p>"; exit(); } //============================================================================================================== //VALIDATE ACCESS addModelSales============================================================================================== //============================================================================================================== echo "<input type='hidden' id='year' value='$year'>"; echo "<input type='hidden' id='userID' value='$userID'>"; echo "<input type='hidden' id='selectedRecord'>"; echo "<input type='hidden' id='companyID' value='$companyID'>"; echo "<input type='hidden' id='dealerID' value='$dealerID'>"; echo "<input type='hidden' id='manHeadercomID' value='$manHeadercomID'>"; ?> <input type='hidden' id='selMonth'> <center> <div class='col text-left' style='width:90%'> <img src='../images/ahg_logo.png',10,5, 25,10></img> <h5 class='text-dark pb-4'>Synergy Sales Report - <?php echo $_GET['c']." - OUT";?></h5> </div> <table style="width:90%"> <tr> <td rowspan=2 class='text-center bg-dark text-light' style='width:10%;border:1px solid gray'>MONTH</td> <td class='text-center bg-dark text-light' colspan='3' style='width:10%;border:1px solid gray;padding:10px'>SYNERGY OUT</td> <td class='text-center bg-dark text-light' style='width:80%;border:1px solid gray;background:black;padding:10px'>BRAND DISTRIBUTIONS</td> </tr> <tr> <td class='bg-dark text-light text=right' style='border:1px solid gray;padding:13px'>TARGET</td> <td class='bg-dark text-light text=right' style='border:1px solid gray'>ACTUAL</td> <td class='bg-dark text-light text=right' style='border:1px solid gray'>RATE(%)</td> <td rowspan='14' class='text-light' style='padding:0px;width:80%;border:0px solid red;background:white'> <table id='variantDistribution' class='m-0 w-100' style='border=collapse:collapse;margin:0px;'> <tr> <?php //LOAD MODEL NUMBER BASED ON ACTIVE COMPANY================================================================== //LOAD MODEL NUMBER BASED ON ACTIVE COMPANY================================================================== $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 "<td class='text-center bg-dark text-light' style='padding:10px;border:0px solid gray'>MONTH</td>"; while($row = mysqli_fetch_array($qVar)){ echo "<td class='text-center bg-dark text-light align-middle' style='padding:13px;border:0px solid gray'>".$row['comp_code']."</td>"; } }else{ echo "<p class='text-center text-danger p-5 m-5>No variant detected</p>"; } ?> </tr> <?php //LOAD DATA BY MONTH AND BY MODEL NUMBER=========================================================================== //LOAD DATA BY MONTH AND BY MODEL NUMBER=========================================================================== $modelMonth = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); foreach ($modelMonth as $myMonth){ ?><tr onclick="javascript:getMonthData(this);" style="width:100%"><?php //Look in the manSynergySales.php echo "<td class='text-center bold border p-2' style='cursor:pointer;text-decoration:underline;font-size:14px;color:blue;padding:10px; vertical-align: middle;'>$myMonth</td>"; $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 "<td class='text-center text-dark border' style='padding:13px'>"; //echo "<input type='text' id='$modelCode' value='".$mRow['SalesCount']."' onkeyup='javascript:geetInputDataAndSave(this.value, this.id);'>"; echo $mRow['SalesCount']; //echo number_format(($mRow['SalesCount']),0);MANCOM_VehicleSalesReport echo "</td>"; } } } echo "</tr>"; } echo "<tr id='ModelTotal' style='margin:0px;padding:0px;with:100%'>"; $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 "<td class='text-center bg-light text-dark font-weight-bold'>TOTAL</td>"; while($row = mysqli_fetch_array($qVar)){ echo "<td class='text-center bg-light text-dark p-3 font-weight-bold'>"; $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 "</td>"; } } echo"</tr>"; ?> </table> </td> </tr> <?php //GENERATE MONTHLY SYNERGY SALES TOTAL===================================================== //GENERATE MONTHLY SYNERGY SALES TOTAL===================================================== $months = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); $chkJanDec = "SELECT * FROM `mancom_synergy_out` WHERE `mancom_hdr_id`='$manHeadercomID' AND `deleted`=0"; $qgetJD = mysqli_query($conn,$chkJanDec); $gRowJD = mysqli_num_rows($qgetJD); if($gRowJD == 0){ //===================================================================== foreach ($months as $value) { $sql="INSERT INTO mancom_synergy_out( `id`, `mancom_hdr_id`, `comp_id`, `deal_id`, `year`, `month_id`, `actual_sales`, `target_sales`, `target_vs_actual_rate`, `added_by` ) VALUES( '', '$manHeadercomID', '$companyID', '$dealerID', '$year', '$value', '0', '0', '0', '$userID' )"; if($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $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 " <tr onclick='javascript:getData(this);'>"; $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`='$companyID' 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){ $SalesRatingX = number_format(($monthlySales / $targetSales * 100),2,'.','')."%"; $SalesRating = number_format(($monthlySales / $targetSales * 100),2,'.',''); }else{ $SalesRating = $SalesRating; } $TotalSalesRating = $TotalSalesRating + $SalesRating; $rtTotalActual = $rtTotalActual + $monthlySales; echo "<td class='p-1 align-middle border pl-3'>".$row['month_id']."</td>"; echo "<td class='text-center border align-middle ' style='border-left:1px solid lightgray;padding:13px'>"; echo $row['target_sales']; echo "</td>"; echo "<td class='text-center border align-middle' style='border-left:1px solid lightgray;padding:13px'>"; echo $monthlySales; echo "</td>"; echo "<td class='text-center border align-middle' style='border-left:1px solid lightgray;padding:13px'>"; echo $SalesRatingX; echo "</td>"; } }else{ echo "Something is wrong!"; } echo "</tr>"; } //DISPLAY MONTHLY SYNERGY SALES TOTAL SUMMART===================================================== //DISPLAY MONTHLY SYNERGY SALES TOTAL SUMMART===================================================== $rtTotalRate = number_format(($TotalSalesRating / 12),2,'.','')."%"; echo "<tr>"; echo "<td class='text-right bg-light font-weight-bold'>TOTAL</td>"; echo "<td class='text-center bg-light font-weight-bold'>"; echo $rtTotalTarget; echo"</td>"; echo "<td class='text-center bg-light font-weight-bold'>"; echo $rtTotalActual; echo "</td>"; echo "<td class='text-center bg-light font-weight-bold p-3'>"; echo $rtTotalRate; echo "</td>"; echo "</tr>"; ?> </table> </center> <!DOCTYPE HTML> <html> <head> <script> function reportLoader() { var div = document.getElementById("reportLoader"); if (div.style.display == 'none') { div.style.display = ''; } else { div.style.display = 'none' } } window.onload = function() { reportLoader(); CanvasJS.addColorSet("greenShades", [//colorSet Array "#067FA0", "#FC9543", "#FCAA48", "#051BFC", "#EF8E0A", "#D30798", "#FD93CB" ]); CanvasJS.addColorSet("greenShadesB", [//colorSet Array "#078515", "#D4A7F8", "#D30798", "#137A08", "#EF8E0A", "#FCAA48", "#70EEF9", "#FD93CB" ]); CanvasJS.addColorSet("greenShadesC", [//colorSet Array "#137A08", "#70EEF9", "#FD93CB", "#EF8E0A", "#70EEF9", "#051BFC", "#137A08" ]); CanvasJS.addColorSet("greenShadesD", [//colorSet Array "#EF8E0A", "#347CF1", "#D30798", "#F9A8D3", "#890C67", "#70EEF9", "#FD93CB" ]); var chart = new CanvasJS.Chart("chartContainer", { theme: "light2", // "light1", "light2", "dark1", "dark2" exportEnabled: true, animationEnabled: true, colorSet: "greenShades", title: { text: "Target Vs Actual" }, data: [{ type: "pie", startAngle: 25, toolTipContent: "<b>{label}</b>: {y}%", showInLegend: "true", legendText: "{label}", indexLabelFontSize: 16, indexLabel: "{label} {y}%", dataPoints: [ { y: <?php $myActual = ($rtTotalActual / $rtTotalTarget) * 100; echo number_format($myActual,2,'.',''); ?>, label: "ACTUAL" }, { y: <?php echo number_format((100 - $myActual),2,'.',''); ?>, label: "VARIANCE" } ] }] }); chart.render(); var chart = new CanvasJS.Chart("chartContainerB", { theme: "light2", // "light1", "light2", "dark1", "dark2" exportEnabled: true, animationEnabled: true, colorSet: "greenShadesB", title: { text: "Target Vs Actual" }, data: [{ type: "column", startAngle: 25, toolTipContent: "<b>{label}</b>: {y}", showInLegend: "true", legendText: "Actual Unit old versus unit target", indexLabelFontSize: 16, indexLabel: "{y}", dataPoints: [ { y: <?php echo number_format($rtTotalTarget,2,'.',''); ?>, label: "Target" }, { y: <?php echo number_format($rtTotalActual),2,'.',''; ?>, label: "Actual" } ] }] }); chart.render(); var chart = new CanvasJS.Chart("chartContainerC", { theme: "light2", // "light1", "light2", "dark1", "dark2" exportEnabled: true, animationEnabled: true, colorSet: "greenShadesC", title: { text: "Synergy Sales - By Company" }, data: [{ type: "column", startAngle: 25, toolTipContent: "<b>{label}</b>: {y}", showInLegend: "true", legendText: "Sales by model", indexLabelFontSize: 16, indexLabel: "{y}", dataPoints: [ <?php $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); while($row = mysqli_fetch_array($qVar)){ $modelvalue=0; $modelCode =$row['comp_code']; $modelID =$row['comp_id']; $mSales = "SELECT SUM(`sales_count`) as 'MonthlySales' FROM mancom_synergy_out_company WHERE `comp_code`='$modelCode' AND `mancom_hdr_id`='$manHeadercomID' AND `comp_id`='$companyID' AND `deal_id`='$dealerID' AND `year`='$year' AND `deleted`=0"; $qSales = mysqli_query($conn,$mSales); while($sal = mysqli_fetch_array($qSales)){ $modelvalue = $sal['MonthlySales']; } echo "{ y: $modelvalue, label: '$modelCode'},"; } ?> ] }] }); chart.render(); var chart = new CanvasJS.Chart("chartContainerD", { theme: "light2", // "light1", "light2", "dark1", "dark2" exportEnabled: true, animationEnabled: true, colorSet: "greenShadesD", title: { text: "Synergy Sales - per Month" }, data: [{ type: "column", startAngle: 25, toolTipContent: "<b>{label}</b>: {y}", showInLegend: "true", legendText: "Monthly Sales", indexLabelFontSize: 16, indexLabel: "{y}", dataPoints: [ <?php $modelMonth = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); foreach ($modelMonth as $myMonth){ $tVal=0; $sq="SELECT SUM(`sales_count`) AS 'salesCount' FROM mancom_synergy_out_company WHERE `month_id`='$myMonth' AND `mancom_hdr_id`='$manHeadercomID'"; $qsQ = mysqli_query($conn,$sq); while($sq=mysqli_fetch_array($qsQ)){ $tVal = $sq['salesCount']; } if($tVal==''){ $tVal=0; } echo "{ y:$tVal, label: '$myMonth'},"; } ?> ] }] }); chart.render(); reportLoader(); } </script> </head> <body> <script src="https://cdn.canvasjs.com/canvasjs.min.js"></script> </body> </html><center> <div style='width:90%;padding-top:50px;padding-bottom:50px'> <div class='float-left position-relative mb-5 p-5 col-xl-8 col-lg-7 col-md-12 col-sm-12' > <div id="chartContainer" style="position:relative;height: 370px; width: 100%;margin-bottom:100px"></div> </div> <div class='float-left position-relative mb-5 p-5 col-xl-4 col-lg-5 col-md-12 col-sm-12'> <div id="chartContainerB" style="position:relative;height: 370px; width: 100%;margin-bottom:100px"></div> </div> <div class='float-left position-relative mb-5 p-5 col-xl-12 col-lg-12 col-md-12 col-sm-12'> <div id="chartContainerC" style="position:relative;height: 370px; width: 100%;margin-bottom:100px"></div> </div> <div class='float-left position-relative mb-5 p-5 col-xl-12 col-lg-12 col-md-12 col-sm-12'> <div id="chartContainerD" style="position:relative;height: 370px; width: 100%;margin-bottom:100px"></div> </div> </div> </center> <?php $conn->close(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.01 | proxy | phpinfo | Settings