File manager

File manager - Edit - /home/autoph/public_html/pms_v1/mancom/loadSynergySalesData.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 = 39; $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='text' 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:20%;border:1px solid gray'>MONTH</td> <td class='text-center bg-dark text-light' colspan='3' style='width:20%;border:1px solid gray'>SYNERGY IN</td> <td class='text-center bg-dark text-light' style='width:60%;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:60%;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 `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 "<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['model_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 `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 "<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='$modelCode' 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 `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 "<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['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 "</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_sales` 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_sales( `id`, `mancom_hdr_id`, `comp_id`, `deal_id`, `year`, `month_id`, `actual_sales`, `target_sales`, `target_vs_actual_rate`, `date_added`, `added_by` ) VALUES( '', '$manHeadercomID', '$selectedCompanyID', '$dealerID', '$year', '$value', '0', '0', '0', '$myTimeStamp', '$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_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 "<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' 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' 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' 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(); //alert(selectedCompanyID); $.ajax({ url:"./mancom/saveActualByModel.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 //======================================================================================================================================== document.getElementById("rtTargetJan").addEventListener("keyup", rtTargetJan); document.getElementById("rtActualJan").addEventListener("keyup", rtTargetJan); function rtTargetJan() { var rtTargetJan = $("#rtTargetJan").val(); var rtActualJan = $("#rtActualJan").val(); var rtRateJan = $("#rtRateJan").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateJan").val('0.0%'); }else{ $("#rtRateJan").val(MyRate); } saveRecordJan(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordJan(){ var rtTargetJan = $("#rtTargetJan").val(); var rtActualJan = $("#rtActualJan").val(); var rtRateJan = $("#rtRateJan").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //FEBRUARY DATA //======================================================================================================================================== document.getElementById("rtTargetFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("rtActualFeb").addEventListener("keyup", rtTargetFeb); function rtTargetFeb() { var rtTargetJan = $("#rtTargetFeb").val(); var rtActualJan = $("#rtActualFeb").val(); var rtRateJan = $("#rtRateFeb").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateFeb").val('0.0%'); }else{ $("#rtRateFeb").val(MyRate); } saveRecordFeb(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordFeb(){ var rtTargetJan = $("#rtTargetFeb").val(); var rtActualJan = $("#rtActualFeb").val(); var rtRateJan = $("#rtRateFeb").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //MARCH DATA //======================================================================================================================================== document.getElementById("rtTargetMar").addEventListener("keyup", rtTargetMar); document.getElementById("rtActualMar").addEventListener("keyup", rtTargetMar); function rtTargetMar() { var rtTargetJan = $("#rtTargetMar").val(); var rtActualJan = $("#rtActualMar").val(); var rtRateJan = $("#rtRateMar").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateMar").val('0.0%'); }else{ $("#rtRateMar").val(MyRate); } saveRecordMar(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordMar(){ var rtTargetJan = $("#rtTargetMar").val(); var rtActualJan = $("#rtActualMar").val(); var rtRateJan = $("#rtRateMar").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //APRIL DATA //======================================================================================================================================== document.getElementById("rtTargetApr").addEventListener("keyup", rtTargetApr); document.getElementById("rtActualApr").addEventListener("keyup", rtTargetApr); function rtTargetApr() { var rtTargetJan = $("#rtTargetApr").val(); var rtActualJan = $("#rtActualApr").val(); var rtRateJan = $("#rtRateApr").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateApr").val('0.0%'); }else{ $("#rtRateApr").val(MyRate); } saveRecordApr(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordApr(){ var rtTargetJan = $("#rtTargetApr").val(); var rtActualJan = $("#rtActualApr").val(); var rtRateJan = $("#rtRateApr").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //MAY DATA //======================================================================================================================================== document.getElementById("rtTargetMay").addEventListener("keyup", rtTargetMay); document.getElementById("rtActualMay").addEventListener("keyup", rtTargetMay); function rtTargetMay() { var rtTargetJan = $("#rtTargetMay").val(); var rtActualJan = $("#rtActualMay").val(); var rtRateJan = $("#rtRateMay").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateMay").val('0.0%'); }else{ $("#rtRateMay").val(MyRate); } saveRecordMay(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordMay(){ var rtTargetJan = $("#rtTargetMay").val(); var rtActualJan = $("#rtActualMay").val(); var rtRateJan = $("#rtRateMay").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //JUNE DATA //======================================================================================================================================== document.getElementById("rtTargetJun").addEventListener("keyup", rtTargetJun); document.getElementById("rtActualJun").addEventListener("keyup", rtTargetJun); function rtTargetJun() { var rtTargetJan = $("#rtTargetJun").val(); var rtActualJan = $("#rtActualJun").val(); var rtRateJan = $("#rtRateJun").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateJun").val('0.0%'); }else{ $("#rtRateJun").val(MyRate); } saveRecordJun(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordJun(){ var rtTargetJan = $("#rtTargetJun").val(); var rtActualJan = $("#rtActualJun").val(); var rtRateJan = $("#rtRateJun").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //JULY DATA //======================================================================================================================================== document.getElementById("rtTargetJul").addEventListener("keyup", rtTargetJul); document.getElementById("rtActualJul").addEventListener("keyup", rtTargetJul); function rtTargetJul() { var rtTargetJan = $("#rtTargetJul").val(); var rtActualJan = $("#rtActualJul").val(); var rtRateJan = $("#rtRateJul").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateJul").val('0.0%'); }else{ $("#rtRateJul").val(MyRate); } saveRecordJul(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordJul(){ var rtTargetJan = $("#rtTargetJul").val(); var rtActualJan = $("#rtActualJul").val(); var rtRateJan = $("#rtRateJul").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //AUGUST DATA //======================================================================================================================================== document.getElementById("rtTargetAug").addEventListener("keyup", rtTargetAug); document.getElementById("rtActualAug").addEventListener("keyup", rtTargetAug); function rtTargetAug() { var rtTargetJan = $("#rtTargetAug").val(); var rtActualJan = $("#rtActualAug").val(); var rtRateJan = $("#rtRateAug").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateAug").val('0.0%'); }else{ $("#rtRateAug").val(MyRate); } saveRecordAug(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordAug(){ var rtTargetJan = $("#rtTargetAug").val(); var rtActualJan = $("#rtActualAug").val(); var rtRateJan = $("#rtRateAug").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //SEPTEMBER DATA //======================================================================================================================================== document.getElementById("rtTargetSep").addEventListener("keyup", rtTargetSep); document.getElementById("rtActualSep").addEventListener("keyup", rtTargetSep); function rtTargetSep() { var rtTargetJan = $("#rtTargetSep").val(); var rtActualJan = $("#rtActualSep").val(); var rtRateJan = $("#rtRateSep").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateSep").val('0.0%'); }else{ $("#rtRateSep").val(MyRate); } saveRecordSep(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordSep(){ var rtTargetJan = $("#rtTargetSep").val(); var rtActualJan = $("#rtActualSep").val(); var rtRateJan = $("#rtRateSep").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //OCTOBER DATA //======================================================================================================================================== document.getElementById("rtTargetOct").addEventListener("keyup", rtTargetOct); document.getElementById("rtActualOct").addEventListener("keyup", rtTargetOct); function rtTargetOct() { var rtTargetJan = $("#rtTargetOct").val(); var rtActualJan = $("#rtActualOct").val(); var rtRateJan = $("#rtRateOct").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateOct").val('0.0%'); }else{ $("#rtRateOct").val(MyRate); } saveRecordOct(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordOct(){ var rtTargetJan = $("#rtTargetOct").val(); var rtActualJan = $("#rtActualOct").val(); var rtRateJan = $("#rtRateOct").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //NOVEMBER DATA //======================================================================================================================================== document.getElementById("rtTargetNov").addEventListener("keyup", rtTargetNov); document.getElementById("rtActualNov").addEventListener("keyup", rtTargetNov); function rtTargetNov() { var rtTargetJan = $("#rtTargetNov").val(); var rtActualJan = $("#rtActualNov").val(); var rtRateJan = $("#rtRateNov").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateNov").val('0.0%'); }else{ $("#rtRateNov").val(MyRate); } saveRecordNov(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordNov(){ var rtTargetJan = $("#rtTargetNov").val(); var rtActualJan = $("#rtActualNov").val(); var rtRateJan = $("#rtRateNov").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/saveSenergySales.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(); } }) } //======================================================================================================================================== //DECEMBER DATA //======================================================================================================================================== document.getElementById("rtTargetDec").addEventListener("keyup", rtTargetDec); document.getElementById("rtActualDec").addEventListener("keyup", rtTargetDec); function rtTargetDec() { var rtTargetJan = $("#rtTargetDec").val(); var rtActualJan = $("#rtActualDec").val(); var rtRateJan = $("#rtRateDec").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateDec").val('0.0%'); }else{ $("#rtRateDec").val(MyRate); } saveRecordDec(); //Save chages totalTarget(); actualTarget(); rateRetail(); } function saveRecordDec(){ var rtTargetJan = $("#rtTargetDec").val(); var rtActualJan = $("#rtActualDec").val(); var rtRateJan = $("#rtRateDec").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/saveSenergySales.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 = $("#rtTargetJan").val(); var rtTargetFeb = $("#rtTargetFeb").val(); var rtTargetMar = $("#rtTargetMar").val(); var rtTargetApr = $("#rtTargetApr").val(); var rtTargetMay = $("#rtTargetMay").val(); var rtTargetJun = $("#rtTargetJun").val(); var rtTargetJul = $("#rtTargetJul").val(); var rtTargetAug = $("#rtTargetAug").val(); var rtTargetSep = $("#rtTargetSep").val(); var rtTargetOct = $("#rtTargetOct").val(); var rtTargetNov = $("#rtTargetNov").val(); var rtTargetDec = $("#rtTargetDec").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 = $("#rtActualJan").val(); var rtTargetFeb = $("#rtActualFeb").val(); var rtTargetMar = $("#rtActualMar").val(); var rtTargetApr = $("#rtActualApr").val(); var rtTargetMay = $("#rtActualMay").val(); var rtTargetJun = $("#rtActualJun").val(); var rtTargetJul = $("#rtActualJul").val(); var rtTargetAug = $("#rtActualAug").val(); var rtTargetSep = $("#rtActualSep").val(); var rtTargetOct = $("#rtActualOct").val(); var rtTargetNov = $("#rtActualNov").val(); var rtTargetDec = $("#rtActualDec").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 = $("#rtRateJan").val(); var rtTargetFebT = $("#rtRateFeb").val(); var rtTargetMarT = $("#rtRateMar").val(); var rtTargetAprT = $("#rtRateApr").val(); var rtTargetMayT = $("#rtRateMay").val(); var rtTargetJunT = $("#rtRateJun").val(); var rtTargetJulT = $("#rtRateJul").val(); var rtTargetAugT = $("#rtRateAug").val(); var rtTargetSepT = $("#rtRateSep").val(); var rtTargetOctT = $("#rtRateOct").val(); var rtTargetNovT = $("#rtRateNov").val(); var rtTargetDecT = $("#rtRateDec").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.01 | proxy | phpinfo | Settings