File manager

File manager - Edit - /home/autoph/public_html/pms_v1/mancom/loadSynergySalesData_OUT.php

Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['rptMan'])){ $reportType = 'synergy_sales'; $rtTotalTarget = 0; $rtTotalActual = 0; $rtTotalRate = 0; $year = $_POST['year']; $dealCode = $_POST['dealCode']; $userID = $_POST['userID']; $compCode = $_POST['compCode']; $manHeadercomID = $_POST['manHeadercomID']; $dealerID = getDealerID($dealCode)[0]; //$selectedCompanyID = getCompanyID($compCode)[0]; $selectedCompanyID= $_POST['selectedCompanyID']; //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='selectedCompanyID' value='$selectedCompanyID'>"; echo "<input type='hidden' id='dealerID' value='$dealerID'>"; echo "<input type='hidden' id='manHeadercomID' value='$manHeadercomID'>"; ?> <input type='hidden' id='selMonth'> <table id="synTable" class='table w-100'> <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'>SYNERGY OUT</td> <td class='text-center bg-dark text-light' style='width:80%;border:1px solid gray;background:black'>BRAND DISTRIBUTIONS</td> </tr> <tr> <td class='bg-dark text-light' style='border:1px solid gray'>TARGET</td> <td class='bg-dark text-light' style='border:1px solid gray'>ACTUAL</td> <td class='bg-dark text-light' 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' 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 p-1'>"; //echo "<input type='text' id='$modelCode' value='".$mRow['SalesCount']."' onkeyup='javascript:geetInputDataAndSave(this.value, this.id);'>"; echo "<input $editButton maxlength=20 min=0 value='".$mRow['SalesCount']."' type='number' id='$compCode' onkeyup='javascript:getInputDataAndSave(this.value, this.id);' style='font-weight:normal;color:blue;font-size:14px;border:0px solid lightgray;width:100%;margin:0px;padding:10px;text-align:center'>"; //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', '$selectedCompanyID', '$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`='$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 "<td class='p-1 align-middle'>".$row['month_id']."</td>"; echo "<td class='text-center p-1 align-middle ' style='border-left:1px solid lightgray'>"; echo "<input $addButton maxlength=20 min=0 value='".$row['target_sales']."' type='number' id='$rtJanTarget' onkeyup='javascript:getSaveTarget(this.value, this.id);' style='border:0px solid lightgray;width:100%;margin:0px;padding:10px;text-align:center'>"; echo "</td>"; echo "<td class='text-center p-1 align-middle'>"; echo "<input disabled min=0 value='$monthlySales' type='number' id='$rtJanActual' onkeyup='javascript:getSaveTarget(this.value, this.id);' style='border:0px solid lightgray;width:100%;margin:0px;padding:10px;text-align:center'>"; echo "</td>"; echo "<td class='text-center p-1' style='border-right:1px solid lightgray;background:#F7F5F5;'>"; echo "<input disabled min=0 value='$SalesRatingX' type='text' id='$rtJanRate' onkeyup='javascript:getSaveTarget(this.value, this.id);' style='border:0px solid lightgray;width:100%;margin:0px;padding:10px;text-align:center'>"; 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 "<input class='font-weight-bold' disabled min=0 value='$rtTotalTarget' type='text' id='rtTotalTarget' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo"</td>"; echo "<td class='text-center bg-light font-weight-bold'>"; echo "<input class='font-weight-bold' disabled min=0 value='$rtTotalActual' type='text' id='rtTotalActual' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center bg-light font-weight-bold'>"; echo "<input class='font-weight-bold' disabled min=0 value='$rtTotalRate' type='text' id='rtTotalRate' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "</tr>"; ?> </table> <p id="messageNote"></p> <?php $conn->close(); } ?> <script> function getModelActualData(row) { var selMonth = $("#selMonth").val(); var x=row.cells; var myX = x[0].innerHTML; //alert(selMonth); document.getElementById("modelID").value = x[0].innerHTML; document.getElementById("tempVarHolder").value = x[1].innerHTML; } function getInputDataAndSave(inValue,id) { var selMonth = $("#selMonth").val(); var selYear = $("#year").val(); var selectedCompanyID = $("#selectedCompanyID").val(); var userID = $("#userID").val(); var dealerID = $("#dealerID").val(); var manHeadercomID = $("#manHeadercomID").val(); $.ajax({ url:"./mancom/saveActualByCompany.php", type:"POST", async:true, data:{ "selYear":selYear, "selectedCompanyID":selectedCompanyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "userID":userID, "inValue":inValue, "modelCode":id, "selMonth":selMonth, "saveMe":1 }, success: function(d){ $("#ModelTotal").html(d); //ShowUploadBar(); } }) } $("#synTable tr").click(function() { //alert($(this).children("td").html()); }); //======================================================================================================================================== //JANUARY DATA //======================================================================================================================================== function getSaveTarget(inValue,inID) { var rtTargetJan = $("#TargetJan").val(); var rtActualJan = $("#ActualJan").val(); var rtRateJan = $("#RateJan").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#RateJan").val('0.0%'); }else{ $("#RateJan").val(MyRate); } saveRecordJan(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordJan(){ var rtTargetJan = $("#TargetJan").val(); var rtActualJan = $("#ActualJan").val(); var rtRateJan = $("#RateJan").val(); var selectedRecord = $("#selectedRecord").val(); var selectedCompanyID= $("#selectedCompanyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert('mancom_hdr_id:' + manHeadercomID); //alert('month_id:' + selectedRecord); //alert('comp_id:' + selectedCompanyID); //alert('deal_id:' + dealerID); //return false; // `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selectedRecord' AND `comp_id`='$selectedCompanyID' AND `deal_id`='$dealerID'"; $.ajax({ url:"./mancom/saveSenergySalesOUT.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "selectedCompanyID":selectedCompanyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //END OF DATA //======================================================================================================================================== function getData(row) { var x=row.cells; var myX = x[0].innerHTML; document.getElementById("selectedRecord").value = x[0].innerHTML; } //++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ function totalTarget(){ var rtTargetJan = $("#TargetJan").val(); var rtTargetFeb = $("#TargetFeb").val(); var rtTargetMar = $("#TargetMar").val(); var rtTargetApr = $("#TargetApr").val(); var rtTargetMay = $("#TargetMay").val(); var rtTargetJun = $("#TargetJun").val(); var rtTargetJul = $("#TargetJul").val(); var rtTargetAug = $("#TargetAug").val(); var rtTargetSep = $("#TargetSep").val(); var rtTargetOct = $("#TargetOct").val(); var rtTargetNov = $("#TargetNov").val(); var rtTargetDec = $("#TargetDec").val(); var totalTarget = eval(rtTargetJan) + eval(rtTargetFeb) + eval(rtTargetMar) + eval(rtTargetApr) + eval(rtTargetMay) + eval(rtTargetJun) + eval(rtTargetJul) + eval(rtTargetAug) + eval(rtTargetSep) + eval(rtTargetOct) + eval(rtTargetNov) + eval(rtTargetDec); $("#rtTotalTarget").val(totalTarget); } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ function actualTarget(){ var rtTargetJan = $("#ActualJan").val(); var rtTargetFeb = $("#ActualFeb").val(); var rtTargetMar = $("#ActualMar").val(); var rtTargetApr = $("#ActualApr").val(); var rtTargetMay = $("#ActualMay").val(); var rtTargetJun = $("#ActualJun").val(); var rtTargetJul = $("#ActualJul").val(); var rtTargetAug = $("#ActualAug").val(); var rtTargetSep = $("#ActualSep").val(); var rtTargetOct = $("#ActualOct").val(); var rtTargetNov = $("#ActualNov").val(); var rtTargetDec = $("#ActualDec").val(); var totalTarget = eval(rtTargetJan) + eval(rtTargetFeb) + eval(rtTargetMar) + eval(rtTargetApr) + eval(rtTargetMay) + eval(rtTargetJun) + eval(rtTargetJul) + eval(rtTargetAug) + eval(rtTargetSep) + eval(rtTargetOct) + eval(rtTargetNov) + eval(rtTargetDec); $("#rtTotalActual").val(totalTarget); } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ function rateRetail(){ var rtTargetJanT = $("#RateJan").val(); var rtTargetFebT = $("#RateFeb").val(); var rtTargetMarT = $("#RateMar").val(); var rtTargetAprT = $("#RateApr").val(); var rtTargetMayT = $("#RateMay").val(); var rtTargetJunT = $("#RateJun").val(); var rtTargetJulT = $("#RateJul").val(); var rtTargetAugT = $("#RateAug").val(); var rtTargetSepT = $("#RateSep").val(); var rtTargetOctT = $("#RateOct").val(); var rtTargetNovT = $("#RateNov").val(); var rtTargetDecT = $("#RateDec").val(); var rtTargetJan = rtTargetJanT.replace("%", ""); var rtTargetFeb = rtTargetFebT.replace("%", ""); var rtTargetMar = rtTargetMarT.replace("%", ""); var rtTargetApr = rtTargetAprT.replace("%", ""); var rtTargetMay = rtTargetMayT.replace("%", ""); var rtTargetJun = rtTargetJunT.replace("%", ""); var rtTargetJul = rtTargetJulT.replace("%", ""); var rtTargetAug = rtTargetAugT.replace("%", ""); var rtTargetSep = rtTargetSepT.replace("%", ""); var rtTargetOct = rtTargetOctT.replace("%", ""); var rtTargetNov = rtTargetNovT.replace("%", ""); var rtTargetDec = rtTargetDecT.replace("%", ""); var totalTargetT = eval(rtTargetJan) + eval(rtTargetFeb) + eval(rtTargetMar) + eval(rtTargetApr) + eval(rtTargetMay) + eval(rtTargetJun) + eval(rtTargetJul) + eval(rtTargetAug) + eval(rtTargetSep) + eval(rtTargetOct) + eval(rtTargetNov) + eval(rtTargetDec); var totalTarget = totalTargetT / 12; var totalTarget = totalTarget.toFixed(2) + "%"; $("#rtTotalRate").val(totalTarget); } </script>

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