File manager - Edit - /home/autoph/public_html/tasks/mancom.tar
Back
saveActualByCompany.php 0000644 00000006635 15025013241 0011172 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['saveMe'])){ $inValue = sanitize($_POST['inValue']); $modelCode = sanitize($_POST['modelCode']); $selYear = sanitize($_POST['selYear']); $userID = sanitize($_POST['userID']); $selMonth = sanitize($_POST['selMonth']); $dealerID = sanitize($_POST['dealerID']); $selectedCompanyID = sanitize($_POST['selectedCompanyID']); $manHeadercomID = sanitize($_POST['manHeadercomID']); //CHECK IF RECORD EXIST IF. IF YES, UPDATE RECORD IF NOT INSERT RECORD $ckRec="SELECT * FROM mancom_synergy_out_company WHERE `year`='$selYear' AND `month_id`='$selMonth' AND `comp_code`='$modelCode' AND `comp_id`='$selectedCompanyID' AND `deal_id`='$dealerID' AND `mancom_hdr_id`='$manHeadercomID'"; $qRec = mysqli_query($conn,$ckRec); $recCount = mysqli_num_rows($qRec); if($recCount > 0){ $sql = "UPDATE mancom_synergy_out_company SET `sales_count`='$inValue',`date_added`='$myTimeStamp',`added_by`='$userID' WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selMonth' AND `comp_code`='$modelCode'"; if($conn->query($sql) === TRUE) { } else { } }else{ $sqlA="INSERT INTO mancom_synergy_out_company( `id`, `mancom_hdr_id`, `comp_id`, `deal_id`, `year`, `month_id`, `comp_code`, `sales_count`, `date_added`, `added_by` ) VALUES( '', '$manHeadercomID', '$selectedCompanyID', '$dealerID', '$selYear', '$selMonth', '$modelCode', '$inValue', '$myTimeStamp', '$userID' )"; if($conn->query($sqlA) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } } $variant = "SELECT * FROM `vts_company` WHERE `comp_status`=1 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_code']; $totayModelSales = "SELECT SUM(sales_count) AS 'totaSalesCount' FROM `mancom_synergy_out_company` WHERE `comp_code`='$activeModel' AND `comp_id`='$selectedCompanyID' AND `year`='$selYear' AND `mancom_hdr_id`='$manHeadercomID' AND `month_id` !='' LIMIT 1"; $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>"; } } $conn->close(); } //1 jan 1 1 //3 jan 1 3 ?> loadMancomReport.php 0000644 00000003225 15025013241 0010516 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['rptMan'])){ $companyID = $_POST['selectedCompanyID']; $userID = $_POST['userID']; $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$companyID' AND deleted = 0 ORDER BY `year` DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'> <i data-toggle='modal' data-target='#updateMancom' class='fa fa-list' aria-hidden='true'></i> </td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } $conn->close(); } readMancomData.php 0000644 00000004361 15025013241 0010112 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['mancom'])){ $companyID = $_POST['selectedCompanyID']; $userID = $_POST['userID']; $reportType = 'vehicle_sales'; $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$companyID' AND deleted = 0 AND `report_type`='$reportType' ORDER BY `year` DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ $linkData = "MANCOM_VehicleSalesReport.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id']; ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'>"; ?> <button class="btn btn-danger border float-right" onClick="window.open('./pdfViewer/<?php echo $linkData;?>')"><i class="fa fa-print"></i></button> <button class="btn btn-info border float-right" ><i data-toggle='modal' data-target='#updateMancom' class='fa fa-pencil-square-o float-right' aria-hidden='true'></i> </button> <?php echo "</td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } $conn->close(); } loadMancomDatabase.php 0000644 00000262166 15025013241 0010762 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['rptMan'])){ $reportType = 'vehicle_sales'; $rtTotalTarget = 0; $flTotalTarget = 0; $opsTotalTarget = 0; $manTotalTarget = 0; $rtTotalActual = 0; $flTotalActual = 0; $opsTotalActual = 0; $manTotalActual = 0; $rtTotalRate = 0; $flTotalRate = 0; $opsTotalRate = 0; $manTotalRate = 0; $year = $_POST['year']; $dealCode = $_POST['dealCode']; $userID = $_POST['userID']; $compCode = $_POST['compCode']; $manHeadercomID = $_POST['manHeadercomID']; $dealerID = getDealerID($dealCode)[0]; $companyID = getCompanyID($compCode)[0]; //EDIT is for editing TARGET //ADD is for adding Actual //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); $moduleID = 38; $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 ============================================================================================== //============================================================================================================== 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'>"; ?> <table style="width:100%"> <tr> <td class='col-lg-3 text-center bg-dark text-light' rowspan="2" style='border:1px solid gray'>MONTH.</td> <td class='col-lg-2 text-center bg-dark text-light' colspan='3' style='border:1px solid gray'>RETAIL</td> <td class='col-lg-2 text-center bg-dark text-light' colspan='3' style='border:1px solid gray'>FLEET</td> <td class='col-lg-2 text-center bg-dark text-light' colspan='3' style='border:1px solid gray'>TOTAL(OPSPLAN)</td> <td class='col-lg-2 text-center bg-dark text-light' colspan='3' style='border:1px solid gray'>PLANT TARGETS</td> </tr> <tr> <td class='bg-danger text-light' style='border:1px solid gray'>TARGET</td> <td class='bg-danger text-light' style='border:1px solid gray'>ACTUAL</td> <td class='bg-danger text-light' style='border:1px solid gray'>RATE(%)</td> <td class='bg-warning text-dark' style='border:1px solid gray'>TARGET</td> <td class='bg-warning text-dark' style='border:1px solid gray'>ACTUAL</td> <td class='bg-warning text-dark' style='border:1px solid gray'>RATE(%)</td> <td class='bg-primary text-light' style='border:1px solid gray'>TARGET</td> <td class='bg-primary text-light' style='border:1px solid gray'>ACTUAL</td> <td class='bg-primary text-light' style='border:1px solid gray'>RATE(%)</td> <td class='bg-success text-light' style='border:1px solid gray'>TARGET</td> <td class='bg-success text-light' style='border:1px solid gray'>ACTUAL</td> <td class='bg-success text-light' style='border:1px solid gray'>RATE(%)</td> </tr> <?php $months = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); $chkJanDec = "SELECT * FROM `mancom_data` 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_data( `id`, `mancom_hdr_id`, `comp_id`, `deal_id`, `year`, `month_id`, `retail_actual_sales`, `retail_target_sales`, `retail_target_vs_actual_rate`, `fleet_actual_sales`, `fleet_target_sales`, `fleet_target_vs_actual`, `ops_total_sales`, `ops_total_target`, `ops_target_vs_actual`, `plant_target_sales`, `plant_actual_sales`, `plant_target_vs_actual`, `date_added`, `added_by` ) VALUES( '', '$manHeadercomID', '$companyID', '$dealerID', '$year', '$value', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '$myTimeStamp', '$userID' )"; if($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } //===================================================================== } } $monthsData = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"); foreach ($monthsData as $value) { echo " <tr onclick='javascript:getData(this);' style='width:100%'>"; $getD = "SELECT * FROM `mancom_data` 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; $flJanTarget = "flTarget".$value; $flJanActual = "flActual".$value; $flJanRate = "flRate".$value; $opsJanTarget = "opsTarget".$value; $opsJanActual = "opsActual".$value; $opsJanRate = "opsRate".$value; $manJanTarget = "manTarget".$value; $manJanActual = "manActual".$value; $manJanRate = "manRate".$value; if($gRow > 0){ while($row=mysqli_fetch_array($qgetD)){ $rtTotalTarget = $rtTotalTarget + $row['retail_target_sales']; $flTotalTarget = $flTotalTarget + $row['fleet_target_sales']; $opsTotalTarget = $opsTotalTarget + $row['ops_total_target']; $manTotalTarget = $manTotalTarget + $row['plant_target_sales']; $manTotalActual = $manTotalActual + $row['plant_actual_sales']; $opsTotalActual = $opsTotalActual + $row['ops_total_sales']; $rtTotalActual = $rtTotalActual + $row['retail_actual_sales']; $flTotalActual = $flTotalActual + $row['fleet_actual_sales']; $temRate = 0; $temRate = str_replace("%","", $row['retail_target_vs_actual_rate']); if(is_numeric($temRate)){ }else{ $temRate = 0; } $rtTotalRate = ($rtTotalRate + $temRate); $temRate=0; $temRate = str_replace("%","", $row['fleet_target_vs_actual']); if(is_numeric($temRate)){ }else{ $temRate=0; } $flTotalRate = $flTotalRate + $temRate; $temRate=0; $temRate = str_replace("%","", $row['ops_target_vs_actual']); if(is_numeric($temRate)){ }else{ $temRate=0; } $opsTotalRate = $opsTotalRate + $temRate; $temRate=0; $temRate = str_replace("%","", $row['plant_target_vs_actual']); if(is_numeric($temRate)){ }else{ $temRate = 0; } $manTotalRate = $manTotalRate + $temRate; echo "<td>".$row['month_id']."</td>"; echo "<td class='text-center' style='border-left:1px solid lightgray'>"; echo "<input $addButton maxlength=20 min=0 value='".$row['retail_target_sales']."' type='number' id='$rtJanTarget' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center'>"; echo "<input $editButton min=0 value='".$row['retail_actual_sales']."' type='number' id='$rtJanActual' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center' style='background:#F7F5F5;'>"; echo "<input disabled min=0 value='".$row['retail_target_vs_actual_rate']."' type='text' id='$rtJanRate' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center' style='border-left:1px solid lightgray'>"; echo "<input $addButton min=0 value='".$row['fleet_target_sales']."' type='number' id='$flJanTarget' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center'>"; echo "<input $editButton min=0 value='".$row['fleet_actual_sales']."' type='number' id='$flJanActual' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center' style='background:#F7F5F5;'>"; echo "<input disabled min=0 value='".$row['fleet_target_vs_actual']."' type='text' id='$flJanRate' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center' style='background:#F7F5F5;border-left:1px solid lightgray'>"; echo "<input min=0 disabled value='".$row['ops_total_target']."' type='number' id='$opsJanTarget' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center' style='background:#F7F5F5;'>"; echo "<input disabled min=0 value='".$row['ops_total_sales']."' type='number' id='$opsJanActual' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center'style='background:#F7F5F5;'>"; echo "<input disabled min=0 value='".$row['ops_target_vs_actual']."' type='text' id='$opsJanRate' style='border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center' style='border-left:1px solid lightgray'>"; echo "<input $addButton min=0 value='".$row['plant_target_sales']."' type='number' id='$manJanTarget' style='display:$plantView;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center' style='background:#F7F5F5;'>"; echo "<input disabled min=0 value='".$row['plant_actual_sales']."' type='number' id='$manJanActual' style='display:$plantView;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; echo "<td class='text-center' style='background:#F7F5F5;'>"; echo "<input disabled min=0 value='".$row['plant_target_vs_actual']."' type='text' id='$manJanRate' style='display:$plantView;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'>"; echo "</td>"; } }else{ echo "Something is wrong!"; } echo "</tr>"; } $rtTotalRate = number_format(($rtTotalRate / 12),2,'.','')."%"; $flTotalRate = number_format(($flTotalRate / 12),2,'.','')."%"; $opsTotalRate = number_format(($opsTotalRate / 12),2,'.','')."%"; $manTotalRate = number_format(($manTotalRate / 12),2,'.','')."%"; echo "<tr>"; echo "<td class='col text-right font-weight-bold'>TOTAL</td>"; echo "<td class='col text-left font-weight-bold'> <input disabled min=0 value='$rtTotalTarget' type='text' id='rtTotalTarget' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-center font-weight-bold'> <input disabled min=0 value='$rtTotalActual' type='text' id='rtTotalActual' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-center font-weight-bold'> <input disabled min=0 value='$rtTotalRate' type='text' id='rtTotalRate' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-left font-weight-bold'> <input disabled min=0 value='$flTotalTarget' type='text' id='flTotalTarget' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-center font-weight-bold'> <input disabled min=0 value='$flTotalActual' type='text' id='flTotalActual' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-center font-weight-bold'> <input disabled min=0 value='$flTotalRate' type='text' id='flTotalRate' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-left font-weight-bold'> <input disabled min=0 value='$opsTotalTarget' type='text' id='opsTotalTarget' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-center font-weight-bold'> <input disabled min=0 value='$opsTotalActual' type='text' id='opsTotalActual' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-center font-weight-bold'> <input disabled min=0 value='$opsTotalRate' type='text' id='opsTotalRate' style='font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-left font-weight-bold'> <input disabled min=0 value='$manTotalTarget' type='text' id='manTotalTarget' style='display:$plantView;font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-center font-weight-bold'> <input disabled min=0 value='$manTotalActual' type='text' id='manTotalActual' style='display:$plantView;font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "<td class='col text-center font-weight-bold'> <input disabled min=0 value='$manTotalRate' type='text' id='manTotalRate' style='display:$plantView;font-weight:bold;border:0px solid lightgray;width:80px;margin:0px;padding:5px;text-align:center'> </td>"; echo "</tr>"; ?> </table> <p id="messageNote"></p> <?php $conn->close(); } ?> <script> //======================================================================================================================================== //JANUARY DATA //======================================================================================================================================== document.getElementById("rtTargetJan").addEventListener("keyup", rtTargetJan); document.getElementById("rtActualJan").addEventListener("keyup", rtTargetJan); document.getElementById("flTargetJan").addEventListener("keyup", rtTargetJan); document.getElementById("flActualJan").addEventListener("keyup", rtTargetJan); document.getElementById("manTargetJan").addEventListener("keyup", rtTargetJan); function rtTargetJan() { var rtTargetJan = $("#rtTargetJan").val(); var rtActualJan = $("#rtActualJan").val(); var rtRateJan = $("#rtRateJan").val(); var flTargetJan = $("#flTargetJan").val(); var flActualJan = $("#flActualJan").val(); var flRateJan = $("#flRateJan").val(); var opsTargetJan = $("#opsTargetJan").val(); var opsActualJan = $("#opsActualJan").val(); var opsRateJan = $("#opsRateJan").val(); var manTargetJan = $("#manTargetJan").val(); var manActualJan = $("#manActualJan").val(); var manRateJan = $("#manRateJan").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateJan").val('0.0%'); }else{ $("#rtRateJan").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateJan").val('0.0%'); }else{ $("#flRateJan").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetJan").val(newOpsTarget); $("#opsActualJan").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateJan").val(newOpsRate); //Update Plant Target $("#manActualJan").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateJan").val(manRating); saveJanRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveJanRecord(){ var rtTargetJan = $("#rtTargetJan").val(); var rtActualJan = $("#rtActualJan").val(); var rtRateJan = $("#rtRateJan").val(); var flTargetJan = $("#flTargetJan").val(); var flActualJan = $("#flActualJan").val(); var flRateJan = $("#flRateJan").val(); var opsTargetJan = $("#opsTargetJan").val(); var opsActualJan = $("#opsActualJan").val(); var opsRateJan = $("#opsRateJan").val(); var manTargetJan = $("#manTargetJan").val(); var manActualJan = $("#manActualJan").val(); var manRateJan = $("#manRateJan").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert('mancom_hdr_id:' + manHeadercomID); //alert('month_id:' + selectedRecord); //alert('comp_id:' + companyID); //alert('deal_id:' + dealerID); // `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selectedRecord' AND `comp_id`='$companyID' AND `deal_id`='$dealerID'"; $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //FEBRUARY DATA //======================================================================================================================================== document.getElementById("rtTargetFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("rtActualFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("flTargetFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("flActualFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("manTargetFeb").addEventListener("keyup", rtTargetFeb); function rtTargetFeb() { var rtTargetJan = $("#rtTargetFeb").val(); var rtActualJan = $("#rtActualFeb").val(); var rtRateJan = $("#rtRateFeb").val(); var flTargetJan = $("#flTargetFeb").val(); var flActualJan = $("#flActualFeb").val(); var flRateJan = $("#flRateFeb").val(); var opsTargetJan = $("#opsTargetFeb").val(); var opsActualJan = $("#opsActualFeb").val(); var opsRateJan = $("#opsRateFeb").val(); var manTargetJan = $("#manTargetFeb").val(); var manActualJan = $("#manActualFeb").val(); var manRateJan = $("#manRateFeb").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateFeb").val('0.0%'); }else{ $("#rtRateFeb").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateFeb").val('0.0%'); }else{ $("#flRateFeb").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetFeb").val(newOpsTarget); $("#opsActualFeb").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateFeb").val(newOpsRate); //Update Plant Target $("#manActualFeb").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateFeb").val(manRating); saveFebRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveFebRecord(){ var rtTargetJan = $("#rtTargetFeb").val(); var rtActualJan = $("#rtActualFeb").val(); var rtRateJan = $("#rtRateFeb").val(); var flTargetJan = $("#flTargetFeb").val(); var flActualJan = $("#flActualFeb").val(); var flRateJan = $("#flRateFeb").val(); var opsTargetJan = $("#opsTargetFeb").val(); var opsActualJan = $("#opsActualFeb").val(); var opsRateJan = $("#opsRateFeb").val(); var manTargetJan = $("#manTargetFeb").val(); var manActualJan = $("#manActualFeb").val(); var manRateJan = $("#manRateFeb").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //MARCH DATA //======================================================================================================================================== document.getElementById("rtTargetMar").addEventListener("keyup", rtTargetMar); document.getElementById("rtActualMar").addEventListener("keyup", rtTargetMar); document.getElementById("flTargetMar").addEventListener("keyup", rtTargetMar); document.getElementById("flActualMar").addEventListener("keyup", rtTargetMar); document.getElementById("manTargetMar").addEventListener("keyup", rtTargetMar); function rtTargetMar() { var rtTargetJan = $("#rtTargetMar").val(); var rtActualJan = $("#rtActualMar").val(); var rtRateJan = $("#rtRateMar").val(); var flTargetJan = $("#flTargetMar").val(); var flActualJan = $("#flActualMar").val(); var flRateJan = $("#flRateMar").val(); var opsTargetJan = $("#opsTargetMar").val(); var opsActualJan = $("#opsActualMar").val(); var opsRateJan = $("#opsRateMar").val(); var manTargetJan = $("#manTargetMar").val(); var manActualJan = $("#manActualMar").val(); var manRateJan = $("#manRateMar").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateMar").val('0.0%'); }else{ $("#rtRateMar").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateMar").val('0.0%'); }else{ $("#flRateMar").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetMar").val(newOpsTarget); $("#opsActualMar").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateMar").val(newOpsRate); //Update Plant Target $("#manActualMar").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateMar").val(manRating); saveMarRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveMarRecord(){ var rtTargetJan = $("#rtTargetMar").val(); var rtActualJan = $("#rtActualMar").val(); var rtRateJan = $("#rtRateMar").val(); var flTargetJan = $("#flTargetMar").val(); var flActualJan = $("#flActualMar").val(); var flRateJan = $("#flRateMar").val(); var opsTargetJan = $("#opsTargetMar").val(); var opsActualJan = $("#opsActualMar").val(); var opsRateJan = $("#opsRateMar").val(); var manTargetJan = $("#manTargetMar").val(); var manActualJan = $("#manActualMar").val(); var manRateJan = $("#manRateMar").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //APRIL DATA //======================================================================================================================================== document.getElementById("rtTargetApr").addEventListener("keyup", rtTargetApr); document.getElementById("rtActualApr").addEventListener("keyup", rtTargetApr); document.getElementById("flTargetApr").addEventListener("keyup", rtTargetApr); document.getElementById("flActualApr").addEventListener("keyup", rtTargetApr); document.getElementById("manTargetApr").addEventListener("keyup", rtTargetApr); function rtTargetApr() { var rtTargetJan = $("#rtTargetApr").val(); var rtActualJan = $("#rtActualApr").val(); var rtRateJan = $("#rtRateApr").val(); var flTargetJan = $("#flTargetApr").val(); var flActualJan = $("#flActualApr").val(); var flRateJan = $("#flRateApr").val(); var opsTargetJan = $("#opsTargetApr").val(); var opsActualJan = $("#opsActualApr").val(); var opsRateJan = $("#opsRateApr").val(); var manTargetJan = $("#manTargetApr").val(); var manActualJan = $("#manActualApr").val(); var manRateJan = $("#manRateApr").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateApr").val('0.0%'); }else{ $("#rtRateApr").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateApr").val('0.0%'); }else{ $("#flRateApr").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetApr").val(newOpsTarget); $("#opsActualApr").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateApr").val(newOpsRate); //Update Plant Target $("#manActualApr").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateApr").val(manRating); saveAprRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveAprRecord(){ var rtTargetJan = $("#rtTargetApr").val(); var rtActualJan = $("#rtActualApr").val(); var rtRateJan = $("#rtRateApr").val(); var flTargetJan = $("#flTargetApr").val(); var flActualJan = $("#flActualApr").val(); var flRateJan = $("#flRateApr").val(); var opsTargetJan = $("#opsTargetApr").val(); var opsActualJan = $("#opsActualApr").val(); var opsRateJan = $("#opsRateApr").val(); var manTargetJan = $("#manTargetApr").val(); var manActualJan = $("#manActualApr").val(); var manRateJan = $("#manRateApr").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //MAY DATA //======================================================================================================================================== document.getElementById("rtTargetMay").addEventListener("keyup", rtTargetMay); document.getElementById("rtActualMay").addEventListener("keyup", rtTargetMay); document.getElementById("flTargetMay").addEventListener("keyup", rtTargetMay); document.getElementById("flActualMay").addEventListener("keyup", rtTargetMay); document.getElementById("manTargetMay").addEventListener("keyup", rtTargetMay); function rtTargetMay() { var rtTargetJan = $("#rtTargetMay").val(); var rtActualJan = $("#rtActualMay").val(); var rtRateJan = $("#rtRateMay").val(); var flTargetJan = $("#flTargetMay").val(); var flActualJan = $("#flActualMay").val(); var flRateJan = $("#flRateMay").val(); var opsTargetJan = $("#opsTargetMay").val(); var opsActualJan = $("#opsActualMay").val(); var opsRateJan = $("#opsRateMay").val(); var manTargetJan = $("#manTargetMay").val(); var manActualJan = $("#manActualMay").val(); var manRateJan = $("#manRateMay").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateMay").val('0.0%'); }else{ $("#rtRateMay").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateMay").val('0.0%'); }else{ $("#flRateMay").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetMay").val(newOpsTarget); $("#opsActualMay").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateMay").val(newOpsRate); //Update Plant Target $("#manActualMay").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateMay").val(manRating); saveMayRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveMayRecord(){ var rtTargetJan = $("#rtTargetMay").val(); var rtActualJan = $("#rtActualMay").val(); var rtRateJan = $("#rtRateMay").val(); var flTargetJan = $("#flTargetMay").val(); var flActualJan = $("#flActualMay").val(); var flRateJan = $("#flRateMay").val(); var opsTargetJan = $("#opsTargetMay").val(); var opsActualJan = $("#opsActualMay").val(); var opsRateJan = $("#opsRateMay").val(); var manTargetJan = $("#manTargetMay").val(); var manActualJan = $("#manActualMay").val(); var manRateJan = $("#manRateMay").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //JUN DATA //======================================================================================================================================== document.getElementById("rtTargetJun").addEventListener("keyup", rtTargetJun); document.getElementById("rtActualJun").addEventListener("keyup", rtTargetJun); document.getElementById("flTargetJun").addEventListener("keyup", rtTargetJun); document.getElementById("flActualJun").addEventListener("keyup", rtTargetJun); document.getElementById("manTargetJun").addEventListener("keyup", rtTargetJun); function rtTargetJun() { var rtTargetJan = $("#rtTargetJun").val(); var rtActualJan = $("#rtActualJun").val(); var rtRateJan = $("#rtRateJun").val(); var flTargetJan = $("#flTargetJun").val(); var flActualJan = $("#flActualJun").val(); var flRateJan = $("#flRateJun").val(); var opsTargetJan = $("#opsTargetJun").val(); var opsActualJan = $("#opsActualJun").val(); var opsRateJan = $("#opsRateJun").val(); var manTargetJan = $("#manTargetJun").val(); var manActualJan = $("#manActualJun").val(); var manRateJan = $("#manRateJun").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateJun").val('0.0%'); }else{ $("#rtRateJun").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateJun").val('0.0%'); }else{ $("#flRateJun").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetJun").val(newOpsTarget); $("#opsActualJun").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateJun").val(newOpsRate); //Update Plant Target $("#manActualJun").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateJun").val(manRating); saveJunRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveJunRecord(){ var rtTargetJan = $("#rtTargetJun").val(); var rtActualJan = $("#rtActualJun").val(); var rtRateJan = $("#rtRateJun").val(); var flTargetJan = $("#flTargetJun").val(); var flActualJan = $("#flActualJun").val(); var flRateJan = $("#flRateJun").val(); var opsTargetJan = $("#opsTargetJun").val(); var opsActualJan = $("#opsActualJun").val(); var opsRateJan = $("#opsRateJun").val(); var manTargetJan = $("#manTargetJun").val(); var manActualJan = $("#manActualJun").val(); var manRateJan = $("#manRateJun").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //JULY DATA //======================================================================================================================================== document.getElementById("rtTargetJul").addEventListener("keyup", rtTargetJul); document.getElementById("rtActualJul").addEventListener("keyup", rtTargetJul); document.getElementById("flTargetJul").addEventListener("keyup", rtTargetJul); document.getElementById("flActualJul").addEventListener("keyup", rtTargetJul); document.getElementById("manTargetJul").addEventListener("keyup", rtTargetJul); function rtTargetJul() { var rtTargetJan = $("#rtTargetJul").val(); var rtActualJan = $("#rtActualJul").val(); var rtRateJan = $("#rtRateJul").val(); var flTargetJan = $("#flTargetJul").val(); var flActualJan = $("#flActualJul").val(); var flRateJan = $("#flRateJul").val(); var opsTargetJan = $("#opsTargetJul").val(); var opsActualJan = $("#opsActualJul").val(); var opsRateJan = $("#opsRateJul").val(); var manTargetJan = $("#manTargetJul").val(); var manActualJan = $("#manActualJul").val(); var manRateJan = $("#manRateJul").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateJul").val('0.0%'); }else{ $("#rtRateJul").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateJul").val('0.0%'); }else{ $("#flRateJul").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetJul").val(newOpsTarget); $("#opsActualJul").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateJul").val(newOpsRate); //Update Plant Target $("#manActualJul").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateJul").val(manRating); saveJulRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveJulRecord(){ var rtTargetJan = $("#rtTargetJul").val(); var rtActualJan = $("#rtActualJul").val(); var rtRateJan = $("#rtRateJul").val(); var flTargetJan = $("#flTargetJul").val(); var flActualJan = $("#flActualJul").val(); var flRateJan = $("#flRateJul").val(); var opsTargetJan = $("#opsTargetJul").val(); var opsActualJan = $("#opsActualJul").val(); var opsRateJan = $("#opsRateJul").val(); var manTargetJan = $("#manTargetJul").val(); var manActualJan = $("#manActualJul").val(); var manRateJan = $("#manRateJul").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //AUGUST DATA //======================================================================================================================================== document.getElementById("rtTargetAug").addEventListener("keyup", rtTargetAug); document.getElementById("rtActualAug").addEventListener("keyup", rtTargetAug); document.getElementById("flTargetAug").addEventListener("keyup", rtTargetAug); document.getElementById("flActualAug").addEventListener("keyup", rtTargetAug); document.getElementById("manTargetAug").addEventListener("keyup", rtTargetAug); function rtTargetAug() { var rtTargetJan = $("#rtTargetAug").val(); var rtActualJan = $("#rtActualAug").val(); var rtRateJan = $("#rtRateAug").val(); var flTargetJan = $("#flTargetAug").val(); var flActualJan = $("#flActualAug").val(); var flRateJan = $("#flRateAug").val(); var opsTargetJan = $("#opsTargetAug").val(); var opsActualJan = $("#opsActualAug").val(); var opsRateJan = $("#opsRateAug").val(); var manTargetJan = $("#manTargetAug").val(); var manActualJan = $("#manActualAug").val(); var manRateJan = $("#manRateAug").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateAug").val('0.0%'); }else{ $("#rtRateAug").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateAug").val('0.0%'); }else{ $("#flRateAug").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetAug").val(newOpsTarget); $("#opsActualAug").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateAug").val(newOpsRate); //Update Plant Target $("#manActualAug").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateAug").val(manRating); saveAugRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveAugRecord(){ var rtTargetJan = $("#rtTargetAug").val(); var rtActualJan = $("#rtActualAug").val(); var rtRateJan = $("#rtRateAug").val(); var flTargetJan = $("#flTargetAug").val(); var flActualJan = $("#flActualAug").val(); var flRateJan = $("#flRateAug").val(); var opsTargetJan = $("#opsTargetAug").val(); var opsActualJan = $("#opsActualAug").val(); var opsRateJan = $("#opsRateAug").val(); var manTargetJan = $("#manTargetAug").val(); var manActualJan = $("#manActualAug").val(); var manRateJan = $("#manRateAug").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //SEPTEMBER DATA //======================================================================================================================================== document.getElementById("rtTargetSep").addEventListener("keyup", rtTargetSep); document.getElementById("rtActualSep").addEventListener("keyup", rtTargetSep); document.getElementById("flTargetSep").addEventListener("keyup", rtTargetSep); document.getElementById("flActualSep").addEventListener("keyup", rtTargetSep); document.getElementById("manTargetSep").addEventListener("keyup", rtTargetSep); function rtTargetSep() { var rtTargetJan = $("#rtTargetSep").val(); var rtActualJan = $("#rtActualSep").val(); var rtRateJan = $("#rtRateSep").val(); var flTargetJan = $("#flTargetSep").val(); var flActualJan = $("#flActualSep").val(); var flRateJan = $("#flRateSep").val(); var opsTargetJan = $("#opsTargetSep").val(); var opsActualJan = $("#opsActualSep").val(); var opsRateJan = $("#opsRateSep").val(); var manTargetJan = $("#manTargetSep").val(); var manActualJan = $("#manActualSep").val(); var manRateJan = $("#manRateSep").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateSep").val('0.0%'); }else{ $("#rtRateSep").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateSep").val('0.0%'); }else{ $("#flRateSep").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetSep").val(newOpsTarget); $("#opsActualSep").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateSep").val(newOpsRate); //Update Plant Target $("#manActualSep").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateSep").val(manRating); saveSepRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveSepRecord(){ var rtTargetJan = $("#rtTargetSep").val(); var rtActualJan = $("#rtActualSep").val(); var rtRateJan = $("#rtRateSep").val(); var flTargetJan = $("#flTargetSep").val(); var flActualJan = $("#flActualSep").val(); var flRateJan = $("#flRateSep").val(); var opsTargetJan = $("#opsTargetSep").val(); var opsActualJan = $("#opsActualSep").val(); var opsRateJan = $("#opsRateSep").val(); var manTargetJan = $("#manTargetSep").val(); var manActualJan = $("#manActualSep").val(); var manRateJan = $("#manRateSep").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //OCTOBER DATA //======================================================================================================================================== document.getElementById("rtTargetOct").addEventListener("keyup", rtTargetOct); document.getElementById("rtActualOct").addEventListener("keyup", rtTargetOct); document.getElementById("flTargetOct").addEventListener("keyup", rtTargetOct); document.getElementById("flActualOct").addEventListener("keyup", rtTargetOct); document.getElementById("manTargetOct").addEventListener("keyup", rtTargetOct); function rtTargetOct() { var rtTargetJan = $("#rtTargetOct").val(); var rtActualJan = $("#rtActualOct").val(); var rtRateJan = $("#rtRateOct").val(); var flTargetJan = $("#flTargetOct").val(); var flActualJan = $("#flActualOct").val(); var flRateJan = $("#flRateOct").val(); var opsTargetJan = $("#opsTargetOct").val(); var opsActualJan = $("#opsActualOct").val(); var opsRateJan = $("#opsRateOct").val(); var manTargetJan = $("#manTargetOct").val(); var manActualJan = $("#manActualOct").val(); var manRateJan = $("#manRateOct").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateOct").val('0.0%'); }else{ $("#rtRateOct").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateOct").val('0.0%'); }else{ $("#flRateOct").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetOct").val(newOpsTarget); $("#opsActualOct").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateOct").val(newOpsRate); //Update Plant Target $("#manActualOct").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateOct").val(manRating); saveOctRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveOctRecord(){ var rtTargetJan = $("#rtTargetOct").val(); var rtActualJan = $("#rtActualOct").val(); var rtRateJan = $("#rtRateOct").val(); var flTargetJan = $("#flTargetOct").val(); var flActualJan = $("#flActualOct").val(); var flRateJan = $("#flRateOct").val(); var opsTargetJan = $("#opsTargetOct").val(); var opsActualJan = $("#opsActualOct").val(); var opsRateJan = $("#opsRateOct").val(); var manTargetJan = $("#manTargetOct").val(); var manActualJan = $("#manActualOct").val(); var manRateJan = $("#manRateOct").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //NOVEMBER DATA //======================================================================================================================================== document.getElementById("rtTargetNov").addEventListener("keyup", rtTargetNov); document.getElementById("rtActualNov").addEventListener("keyup", rtTargetNov); document.getElementById("flTargetNov").addEventListener("keyup", rtTargetNov); document.getElementById("flActualNov").addEventListener("keyup", rtTargetNov); document.getElementById("manTargetNov").addEventListener("keyup", rtTargetNov); function rtTargetNov() { var rtTargetJan = $("#rtTargetNov").val(); var rtActualJan = $("#rtActualNov").val(); var rtRateJan = $("#rtRateNov").val(); var flTargetJan = $("#flTargetNov").val(); var flActualJan = $("#flActualNov").val(); var flRateJan = $("#flRateNov").val(); var opsTargetJan = $("#opsTargetNov").val(); var opsActualJan = $("#opsActualNov").val(); var opsRateJan = $("#opsRateNov").val(); var manTargetJan = $("#manTargetNov").val(); var manActualJan = $("#manActualNov").val(); var manRateJan = $("#manRateNov").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateNov").val('0.0%'); }else{ $("#rtRateNov").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateNov").val('0.0%'); }else{ $("#flRateNov").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetNov").val(newOpsTarget); $("#opsActualNov").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateNov").val(newOpsRate); //Update Plant Target $("#manActualNov").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateNov").val(manRating); saveNovRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveNovRecord(){ var rtTargetJan = $("#rtTargetNov").val(); var rtActualJan = $("#rtActualNov").val(); var rtRateJan = $("#rtRateNov").val(); var flTargetJan = $("#flTargetNov").val(); var flActualJan = $("#flActualNov").val(); var flRateJan = $("#flRateNov").val(); var opsTargetJan = $("#opsTargetNov").val(); var opsActualJan = $("#opsActualNov").val(); var opsRateJan = $("#opsRateNov").val(); var manTargetJan = $("#manTargetNov").val(); var manActualJan = $("#manActualNov").val(); var manRateJan = $("#manRateNov").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //DECEMBER DATA //======================================================================================================================================== document.getElementById("rtTargetDec").addEventListener("keyup", rtTargetDec); document.getElementById("rtActualDec").addEventListener("keyup", rtTargetDec); document.getElementById("flTargetDec").addEventListener("keyup", rtTargetDec); document.getElementById("flActualDec").addEventListener("keyup", rtTargetDec); document.getElementById("manTargetDec").addEventListener("keyup", rtTargetDec); function rtTargetDec() { var rtTargetJan = $("#rtTargetDec").val(); var rtActualJan = $("#rtActualDec").val(); var rtRateJan = $("#rtRateDec").val(); var flTargetJan = $("#flTargetDec").val(); var flActualJan = $("#flActualDec").val(); var flRateJan = $("#flRateDec").val(); var opsTargetJan = $("#opsTargetDec").val(); var opsActualJan = $("#opsActualDec").val(); var opsRateJan = $("#opsRateDec").val(); var manTargetJan = $("#manTargetDec").val(); var manActualJan = $("#manActualDec").val(); var manRateJan = $("#manRateDec").val(); var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; if(isNaN(rtRating)){ $("#rtRateDec").val('0.0%'); }else{ $("#rtRateDec").val(MyRate); } var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; if(isNaN(flRating)){ $("#flRateDec").val('0.0%'); }else{ $("#flRateDec").val(MyRateFL); } //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetDec").val(newOpsTarget); $("#opsActualDec").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateDec").val(newOpsRate); //Update Plant Target $("#manActualDec").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateDec").val(manRating); saveDecRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateRetail(); rateOps(); rateFleet(); rateMan(); } function saveDecRecord(){ var rtTargetJan = $("#rtTargetDec").val(); var rtActualJan = $("#rtActualDec").val(); var rtRateJan = $("#rtRateDec").val(); var flTargetJan = $("#flTargetDec").val(); var flActualJan = $("#flActualDec").val(); var flRateJan = $("#flRateDec").val(); var opsTargetJan = $("#opsTargetDec").val(); var opsActualJan = $("#opsActualDec").val(); var opsRateJan = $("#opsRateDec").val(); var manTargetJan = $("#manTargetDec").val(); var manActualJan = $("#manActualDec").val(); var manRateJan = $("#manRateDec").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveJan.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTargetJan":rtTargetJan, "rtActualJan":rtActualJan, "rtRateJan":rtRateJan, "flTargetJan":flTargetJan, "flActualJan":flActualJan, "flRateJan":flRateJan, "opsTargetJan":opsTargetJan, "opsActualJan":opsActualJan, "opsRateJan":opsRateJan, "manTargetJan":manTargetJan, "manActualJan":manActualJan, "manRateJan":manRateJan, "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 totalFleet(){ var rtTargetJan = $("#flTargetJan").val(); var rtTargetFeb = $("#flTargetFeb").val(); var rtTargetMar = $("#flTargetMar").val(); var rtTargetApr = $("#flTargetApr").val(); var rtTargetMay = $("#flTargetMay").val(); var rtTargetJun = $("#flTargetJun").val(); var rtTargetJul = $("#flTargetJul").val(); var rtTargetAug = $("#flTargetAug").val(); var rtTargetSep = $("#flTargetSep").val(); var rtTargetOct = $("#flTargetOct").val(); var rtTargetNov = $("#flTargetNov").val(); var rtTargetDec = $("#flTargetDec").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); $("#flTotalTarget").val(totalTarget); } function totalOps(){ var rtTargetJan = $("#opsTargetJan").val(); var rtTargetFeb = $("#opsTargetFeb").val(); var rtTargetMar = $("#opsTargetMar").val(); var rtTargetApr = $("#opsTargetApr").val(); var rtTargetMay = $("#opsTargetMay").val(); var rtTargetJun = $("#opsTargetJun").val(); var rtTargetJul = $("#opsTargetJul").val(); var rtTargetAug = $("#opsTargetAug").val(); var rtTargetSep = $("#opsTargetSep").val(); var rtTargetOct = $("#opsTargetOct").val(); var rtTargetNov = $("#opsTargetNov").val(); var rtTargetDec = $("#opsTargetDec").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); $("#opsTotalTarget").val(totalTarget); } function totalMan(){ var rtTargetJan = $("#manTargetJan").val(); var rtTargetFeb = $("#manTargetFeb").val(); var rtTargetMar = $("#manTargetMar").val(); var rtTargetApr = $("#manTargetApr").val(); var rtTargetMay = $("#manTargetMay").val(); var rtTargetJun = $("#manTargetJun").val(); var rtTargetJul = $("#manTargetJul").val(); var rtTargetAug = $("#manTargetAug").val(); var rtTargetSep = $("#manTargetSep").val(); var rtTargetOct = $("#manTargetOct").val(); var rtTargetNov = $("#manTargetNov").val(); var rtTargetDec = $("#manTargetDec").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); $("#manTotalTarget").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 actualFleet(){ var rtTargetJan = $("#flActualJan").val(); var rtTargetFeb = $("#flActualFeb").val(); var rtTargetMar = $("#flActualMar").val(); var rtTargetApr = $("#flActualApr").val(); var rtTargetMay = $("#flActualMay").val(); var rtTargetJun = $("#flActualJun").val(); var rtTargetJul = $("#flActualJul").val(); var rtTargetAug = $("#flActualAug").val(); var rtTargetSep = $("#flActualSep").val(); var rtTargetOct = $("#flActualOct").val(); var rtTargetNov = $("#flActualNov").val(); var rtTargetDec = $("#flActualDec").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); $("#flTotalActual").val(totalTarget); } function actualOps(){ var rtTargetJan = $("#opsActualJan").val(); var rtTargetFeb = $("#opsActualFeb").val(); var rtTargetMar = $("#opsActualMar").val(); var rtTargetApr = $("#opsActualApr").val(); var rtTargetMay = $("#opsActualMay").val(); var rtTargetJun = $("#opsActualJun").val(); var rtTargetJul = $("#opsActualJul").val(); var rtTargetAug = $("#opsActualAug").val(); var rtTargetSep = $("#opsActualSep").val(); var rtTargetOct = $("#opsActualOct").val(); var rtTargetNov = $("#opsActualNov").val(); var rtTargetDec = $("#opsActualDec").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); $("#opsTotalActual").val(totalTarget); } function actualMan(){ var rtTargetJan = $("#manActualJan").val(); var rtTargetFeb = $("#manActualFeb").val(); var rtTargetMar = $("#manActualMar").val(); var rtTargetApr = $("#manActualApr").val(); var rtTargetMay = $("#manActualMay").val(); var rtTargetJun = $("#manActualJun").val(); var rtTargetJul = $("#manActualJul").val(); var rtTargetAug = $("#manActualAug").val(); var rtTargetSep = $("#manActualSep").val(); var rtTargetOct = $("#manActualOct").val(); var rtTargetNov = $("#manActualNov").val(); var rtTargetDec = $("#manActualDec").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); $("#manTotalActual").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); } function rateFleet(){ var rtTargetJanT = $("#flRateJan").val(); var rtTargetFebT = $("#flRateFeb").val(); var rtTargetMarT = $("#flRateMar").val(); var rtTargetAprT = $("#flRateApr").val(); var rtTargetMayT = $("#flRateMay").val(); var rtTargetJunT = $("#flRateJun").val(); var rtTargetJulT = $("#flRateJul").val(); var rtTargetAugT = $("#flRateAug").val(); var rtTargetSepT = $("#flRateSep").val(); var rtTargetOctT = $("#flRateOct").val(); var rtTargetNovT = $("#flRateNov").val(); var rtTargetDecT = $("#flRateDec").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) + "%"; $("#flTotalRate").val(totalTarget); } function rateOps(){ var rtTargetJanT = $("#opsRateJan").val(); var rtTargetFebT = $("#opsRateFeb").val(); var rtTargetMarT = $("#opsRateMar").val(); var rtTargetAprT = $("#opsRateApr").val(); var rtTargetMayT = $("#opsRateMay").val(); var rtTargetJunT = $("#opsRateJun").val(); var rtTargetJulT = $("#opsRateJul").val(); var rtTargetAugT = $("#opsRateAug").val(); var rtTargetSepT = $("#opsRateSep").val(); var rtTargetOctT = $("#opsRateOct").val(); var rtTargetNovT = $("#opsRateNov").val(); var rtTargetDecT = $("#opsRateDec").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) + "%"; $("#opsTotalRate").val(totalTarget); } function rateMan(){ var rtTargetJanT = $("#manRateJan").val(); var rtTargetFebT = $("#manRateFeb").val(); var rtTargetMarT = $("#manRateMar").val(); var rtTargetAprT = $("#manRateApr").val(); var rtTargetMayT = $("#manRateMay").val(); var rtTargetJunT = $("#manRateJun").val(); var rtTargetJulT = $("#manRateJul").val(); var rtTargetAugT = $("#manRateAug").val(); var rtTargetSepT = $("#manRateSep").val(); var rtTargetOctT = $("#manRateOct").val(); var rtTargetNovT = $("#manRateNov").val(); var rtTargetDecT = $("#manRateDec").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 plantTotalTarget = totalTargetT / 12; var FinaltotalTarget = plantTotalTarget.toFixed(2) + "%"; $("#manTotalRate").val(FinaltotalTarget); } </script> .htaccess 0000644 00000000030 15025013241 0006324 0 ustar 00 DirectoryIndex index.php loadSynergySalesData.php 0000644 00000153114 15025013241 0011335 0 ustar 00 <?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> readSynergySalesByModel.php 0000644 00000004471 15025013241 0012014 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['readMe'])){ $year = $_POST['year']; $userID = $_POST['userID']; $dealerID = $_POST['dealerID']; $companyID = $_POST['companyID']; $manHeadercomID = $_POST['manHeadercomID']; $selMonth = $_POST['selMonth']; echo "<input type='text' id='tempVarHolder'>"; echo "<input type='text' id='modelID'>"; ?> <table id="synTable" class='table w-100'> <tr> <td class='text-center bg-dark text-light' style='width:10%;border:1px solid gray'>ID</td> <td class='text-center bg-dark text-light' style='width:50%;border:1px solid gray'>MODEL/VARIANT</td> <td class='text-center bg-dark text-light' style='width:20%;border:1px solid gray'>ACTUAL</td> </tr> <?php $variant = "SELECT * FROM `pms_car_models` WHERE `deleted`=0 AND `dealer_id`='$dealerID' ORDER BY `model_code` ASC"; $qVar = mysqli_query($conn,$variant); $qvCount = mysqli_num_rows($qVar); if($qvCount > 0){ while($row = mysqli_fetch_array($qVar)){ $actualValue=0; $modelID = $row['id']; $fieldID = $row['model_code'] .$selMonth; $getDataFromTable = "SELECT SUM(sales_count) AS 'actualDataCount' FROM `mancom_synergy_by_model` WHERE `model_id`='$modelID' AND comp_id='$companyID' AND `month_id` ='$selMonth'"; $qGet = mysqli_query($conn,$getDataFromTable); while($get = mysqli_fetch_array($qGet)){ $actualValue = $get['actualDataCount']; } ?><tr onclick="javascript:getModelActualData(this);" style="width:100%"><?php echo "<td class='text-left text-center text-dark border'>".$row['id']."</td>"; echo "<td class='text-left text-dark border'>".$row['model_code']."</td>"; echo "<td class='text-center text-dark border p-1'>"; echo "<input class='w-100 p-2 text-center display-5' type='text' id='$fieldID' value='$fieldID'>"; echo "</td>"; echo "</tr>"; } }else{ echo "<p class='text-center text-danger p-5 m-5>No variant detected</p>"; } $conn->close(); } ?> index.php 0000644 00000000113 15025013241 0006350 0 ustar 00 <?php header("Location: ../index.php"); /* Redirect browser */ exit(); ?> manSynergySales.php 0000644 00000046601 15025013241 0010401 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['mancom'])){ $title = $_POST['title']; $userID = $_POST['userID']; $companyID = $_POST['companyID']; $reportType = 'synergy_sales'; //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($userID); $compName = getCompanyNameSub($companyID)[0]; $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='MyCompanyID' value='$companyID'>"; 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';} if($edit==1){ $editVisible=''; }else{ $editVisible='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 ============================================================================================== //============================================================================================================== echo "<input type='hidden' id='manHeadercomID'>"; echo "<input type='hidden' id='year'>"; echo "<input type='hidden' id='compCode'>"; echo "<input type='hidden' id='dealCode'>"; echo "<input type='hidden' id='activeCompany' value='$companyID'>"; ?> <div class="mb-3 pageHeaderContainer content-justify-right pt-2 pb-3" style="padding:0px;height:auto;border:0px solid red" > <div class="pageSearchHeader bg-white p-2 pt-1" style='border:0px solid white'> <h4 class="ml-3 mt-1"><i class="fa fa-building text-success p-2" style='font-size:20px;color:#0471AC border:0px'> <?php echo $title;?> </i></h4> </div> <div class="pageSearchHeader bg-white p-2 "> <select onchange="javascript:loadMancomHeader()" name='selectedCompanyID' id='selectedCompanyID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="<?php echo $companyID;?>"><?php echo getCompanyNameSub($companyID)[0];?></option> <?php $sql = "SELECT * FROM vts_company WHERE comp_status=1 ORDER BY comp_name ASC"; $getGroup = mysqli_query($conn,$sql); $chkIfExist = mysqli_num_rows($getGroup); if($chkIfExist > 0){ while($row = mysqli_fetch_array($getGroup)){ echo "<option value='".$row['comp_id']."'>".$row['comp_code']." - ".$row['comp_name']."</option>"; } } ?> </select> </div> </div> <div class="col-xl-12 border p-1 overflow-auto" > <table id='mancoTable' style="width:100%;border-collapse:collapse;"> <thead> <th style="padding-left:2px;text-align:left;border:0px solid red">REC.ID</thd> <th style="padding-left:2px;text-align:left;border:0px solid red">YEAR</th> <th style="padding-left:2px;text-align:left;border:0px solid red">COMPANY NAME</th> <th style="padding-left:2px;text-align:left;border:0px solid red">DEALER NAME</th> <th style="padding-left:2px;text-align:left;border:0px solid red">UPDATES</th> <th style="border:0px solid red;color:red;font-family:Calibri;font-size:18px;font-weight:normal"> <button <?php echo $addButton;?> class="btn btn-warning float-right"><i data-toggle='modal' data-target='#addMancomHeader' class='fa fa-plus float-left' aria-hidden='true'>Add</i></button> </th> </thead> <thead id ='mancomList'> <?php $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$companyID' AND deleted = 0 AND `report_type`='$reportType' ORDER BY year DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ $linkData = "MANCOM_SynergySalesReport.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id']; ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'>"; ?> <button <?php echo $printButton;?> class="btn btn-danger border float-right" onClick="window.open('./pdfViewer/<?php echo $linkData;?>')"><i class="fa fa-print"></i></button> <button <?php echo $editButton;?> class="btn btn-info border float-right d-<?php echo $editVisible;?>" ><i <?php echo $editButton;?> data-toggle='modal' data-target='#updateMancom' class='fa fa-pencil-square-o'></i> </button> <?php echo "</td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } ?> </thead> </table> </div> <!--MODAL FORM FOR ADD NEW BRAND full-width-div --> <!-- The Modal --> <!--MODAL FORM FOR ADD NEW GROUP--> <!-- The Modal --> <div class="modal fade " id="addMancomHeader"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 class="modal-title">NEW SYNERGY SALES REPORT</h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="dealID">DEALERSHIP/BRANCH:</label> <select name='dealID' id='dealID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <?php $selectedCompanyID = $_POST['selectedCompanyID']; echo "<option value=''>- Branch/Dealership -</option>"; $sql = "SELECT * FROM `vts_dealerships` WHERE `deal_status`=1 AND `comp_id`= '$companyID' ORDER BY `deal_name` ASC"; $qSql = mysqli_query($conn,$sql); while($row = mysqli_fetch_array($qSql)){ echo "<option value='".$row['deal_id']."'>".$row['deal_name']."</option>"; } ?> </select> </div> <div class="form-group"> <label for="applyYear">APPLICABLE YEAR:</label> <input type="number" min="<?php echo $curYear;?>" value="<?php echo $curYear;?>" max="9999" class="form-control W-50" id="applyYear" name="applyYear"> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4" data-dismiss="modal" id="SaveNewMancomHeader"> <span class="btn-label"><i class="fa fa-save"> Save </i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close"> Close</i></button> </div> </div> </div> </div> <!-- The Modal --> <div class="modal" id="updateMancom" style='margin-top:30px;width:98%;margin-left:1%'> <div class="modal-fullscreen m-md-0"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 id='mancomTitle' class="modal-title"></h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="modal-content modal-dialog-scrollable" style='min-width:100%;padding:0px;height:750px'> <!--MAR CONTENT DATA --> <div id='mancomDatabase' class="modal-body" style="background:white;padding:1px"> <!--<table style='width:100%;margin:0px' class='form-control' data-toggle="modal" data-target="#viewMARDataEntryForm"> --> </div> </div> </div> </div> </div> </div> <!-- The Modal --> <div class="modal w-50" id="monthlyDataXXXXXXXXXXxx" style='background:transparent;margin-top:30px;'> <div class="modal-mdp-1" style='background:transparent;'> <div class="modal-content bg-light"> <!-- Modal Header --> <div class="modal-header"> <h5 id='monthlyDataTitle' class="modal-title"></h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="modal-content modal-dialog-scrollable h-100" style='min-width:100%;padding:0px;min-height:800px'> <!--MAR CONTENT DATA --> <div id='addActualData' class="modal-body" style="background:white;padding:1px"> <!--<table style='width:100%;margin:0px' class='form-control' data-toggle="modal" data-target="#viewMARDataEntryForm"> --> adfaf </div> </div> </div> </div> </div> </div> <?php } $conn->close(); ?> <script> // $("#mancoTable tr").click(function() { // var rowCount = document.getElementById('mancoTable').rows.length; // //alert($(this).children("td").html()); // alert(rowCount); // }); $('#mancoTable').on("click","tr td",function(){ //var header = $('#pmsPageTable th').eq($(this).index()).text(); //to get clicked column's header // var trackid = $(this).siblings('td:nth-child(6)').text(); //get column at column 36 var data = $(this).text(); //get clicked column value var dCell = $(this).index(); //get clicked column value //alert(dCell); if(dCell ==5){ var year = $("#year").val(); var dealCode = $("#dealCode").val(); var compCode = $("#compCode").val(); var userID = $("#userID").val(); var manHeadercomID = $("#manHeadercomID").val(); var selectedCompanyID = $("#selectedCompanyID").val(); // var deleteAccess = $("#deleteAccess").val(); // if(deleteAccess == 0){ // Swal.fire({ // icon: 'error', // title: 'Access Denied', // text: 'You are not allowed to delete record from this page...', // footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' // }) // return false; // } //alert(selectedCompanyID); ShowUploadBar(); $.ajax({ url:"./mancom/loadSynergySalesData.php", type:"POST", async:true, data:{ "userID":userID, "year":year, "compCode":compCode, "dealCode":dealCode, "selectedCompanyID":selectedCompanyID, "manHeadercomID":manHeadercomID, "rptMan":1 }, success: function(d){ $("#mancomDatabase").html(d); ShowUploadBar(); } }) } }); $("#SaveNewMancomHeader").click(function(){ var year = $("#applyYear").val(); var dealID = $("#dealID").val(); var activeCompany = $("#selectedCompanyID").val(); var userID = $("#userID").val(); var MyCompanyID = $("#MyCompanyID").val(); //alert(activeCompany); if(activeCompany==""){ activeCompany = MyCompanyID; } if(activeCompany==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select company from the list to continue... ' }) return false; } if(dealID==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select Dealer from the list to continue... ' }) return false; } ShowUploadBar(); $.ajax({ url:"./mancom/saveNewSynergySalesHeader.php", type:"POST", async:true, data:{ "userID":userID, "year":year, "dealID":dealID, "activeCompany":activeCompany, "save":1 }, success: function(d){ $("#mancomList").html(d); ShowUploadBar(); } }) }); function getInfo(row) { var x=row.cells; var myX = x[0].innerHTML; document.getElementById("manHeadercomID").value = x[0].innerHTML; document.getElementById("year").value = x[1].innerHTML; document.getElementById("compCode").value = x[2].innerHTML; document.getElementById("dealCode").value = x[3].innerHTML; document.getElementById("mancomTitle").innerHTML= "MANCOM DATA - " + x[2].innerHTML + " (" + x[3].innerHTML +") - Synergy Sales (IN)"; } function getMonthData(row) { var x=row.cells; var myX = x[0].innerHTML; //alert(myX); document.getElementById("monthlyDataTitle").innerHTML= "ACTUAL SALES - " + x[0].innerHTML; document.getElementById("selMonth").value = x[0].innerHTML; } function loadMancomHeader(){ var selectedCompanyID = $("#selectedCompanyID").val(); var userID = $("#userID").val(); //alert(selectedCompanyID); if(selectedCompanyID==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select company from the list to continue... ' }) return false; } //alert(selectedCompanyID); selectedCompanyID document.getElementById("activeCompany").value = selectedCompanyID; ShowUploadBar(); $.ajax({ url:"./mancom/readSynergySalesData.php", type:"POST", async:true, data:{ "selectedCompanyID":selectedCompanyID, "userID":userID, "mancom":1 }, success: function(d){ $("#mancomList").html(d); ShowUploadBar(); loadDealerships(); } }) } function loadDealerships(){ var activeCompany = $("#activeCompany").val(); //alert(activeCompany); //return false; ShowUploadBar(); $.ajax({ url: "./mancom/loadDealership.php", type: "POST", async: true, data: { "activeCompany":activeCompany, "load": 1 }, success: function(d){ $("#dealID").html(d); ShowUploadBar(); } }) } </script> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="https://cdn.canvasjs.com/jquery.canvasjs.min.js"></script> manVehicleSales.php 0000644 00000042306 15025013241 0010316 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['mancom'])){ $title = $_POST['title']; $userID = $_POST['userID']; $companyID = $_POST['companyID']; $reportType = 'vehicle_sales'; //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($userID); $compName = getCompanyNameSub($companyID)[0]; $moduleID = 38; $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='MyCompanyID' value='$companyID'>"; 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';} 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 ============================================================================================== //============================================================================================================== echo "<input type='hidden' id='manHeadercomID'>"; echo "<input type='hidden' id='year'>"; echo "<input type='hidden' id='compCode'>"; echo "<input type='hidden' id='dealCode'>"; echo "<input type='hidden' id='activeCompany' value='$companyID'>"; ?> <div class="mb-3 pageHeaderContainer content-justify-right pt-2 pb-3" style="padding:0px;height:auto;border:0px solid red" > <div class="pageSearchHeader bg-white p-2 pt-1" style='border:0px solid white'> <h4 class="ml-3 mt-1"><i class="fa fa-building text-info p-2" style='font-size:20px;color:#0471AC border:0px'> <?php echo $title;?> </i></h4> </div> <div class="pageSearchHeader bg-white p-2 "> <select onchange="javascript:loadMancomHeader()" name='selectedCompanyID' id='selectedCompanyID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="">-- SELECT COMPANY --</option> <?php $sql = "SELECT * FROM vts_company WHERE comp_status=1 ORDER BY comp_name ASC"; $getGroup = mysqli_query($conn,$sql); $chkIfExist = mysqli_num_rows($getGroup); if($chkIfExist > 0){ while($row = mysqli_fetch_array($getGroup)){ echo "<option value='".$row['comp_id']."'>".$row['comp_code']." - ".$row['comp_name']."</option>"; } } ?> </select> </div> </div> <div class="col-xl-12 border p-1 overflow-auto" > <table id='mancoTable' style="width:100%;border-collapse:collapse;"> <thead> <th style="padding-left:2px;text-align:left;border:0px solid red">REC.ID</thd> <th style="padding-left:2px;text-align:left;border:0px solid red">YEAR</th> <th style="padding-left:2px;text-align:left;border:0px solid red">COMPANY NAME</th> <th style="padding-left:2px;text-align:left;border:0px solid red">DEALER NAME</th> <th style="padding-left:2px;text-align:left;border:0px solid red">UPDATES</th> <th style="border:0px solid red;color:red;font-family:Calibri;font-size:18px;font-weight:normal"> <button <?php echo $addButton;?> class="btn btn-warning float-right"><i data-toggle='modal' data-target='#addMancomHeader' class='fa fa-plus float-left' aria-hidden='true'>Add</i></button> </th> </thead> <tbody id ='mancomList'> <?php $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$companyID' AND deleted = 0 AND `report_type`='$reportType' ORDER BY year DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ $linkData = "MANCOM_VehicleSalesReport.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id']; ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'>"; ?> <button class="btn btn-danger border float-right" onClick="window.open('./pdfViewer/<?php echo $linkData;?>')"><i class="fa fa-print"></i></button> <button class="btn btn-info border float-right" ><i data-toggle='modal' data-target='#updateMancom' class='fa fa-pencil-square-o float-right' aria-hidden='true'></i> </button> <?php echo "</td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } ?> </tbody> </table> </div> <!--MODAL FORM FOR ADD NEW BRAND full-width-div --> <!-- The Modal --> <!--MODAL FORM FOR ADD NEW GROUP--> <!-- The Modal --> <div class="modal fade " id="addMancomHeader"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 class="modal-title">NEW MANCOM REPORT</h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="dealID">DEALERSHIP/BRANCH:</label> <select name='dealID' id='dealID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <?php $selectedCompanyID = $_POST['selectedCompanyID']; echo "<option value=''>- Branch/Dealership -</option>"; $sql = "SELECT * FROM `vts_dealerships` WHERE `deal_status`=1 AND `comp_id`= '$companyID' ORDER BY `deal_name` ASC"; $qSql = mysqli_query($conn,$sql); while($row = mysqli_fetch_array($qSql)){ echo "<option value='".$row['deal_id']."'>".$row['deal_name']."</option>"; } ?> </select> </div> <div class="form-group"> <label for="applyYear">APPLICABLE YEAR:</label> <input type="number" min="<?php echo $curYear;?>" value="<?php echo $curYear;?>" max="9999" class="form-control W-50" id="applyYear" name="applyYear"> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4" data-dismiss="modal" id="SaveNewMancomHeader"> <span class="btn-label"><i class="fa fa-save"> Add</i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close"> Close</i></button> </div> </div> </div> </div> <!-- The Modal --> <div class="modal" id="updateMancom" style='margin-top:30px;width:98%;margin-left:1%'> <div class="modal-fullscreen m-md-0"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 id='mancomTitle' class="modal-title"></h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="modal-content modal-dialog-scrollable" style='min-width:100%;padding:0px;overflow:auto;height:750px'> <!--MAR CONTENT DATA --> <div id='mancomDatabase' class="modal-body" style="background:white"> <!--<table style='width:100%;margin:0px' class='form-control' data-toggle="modal" data-target="#viewMARDataEntryForm"> --> </div> </div> </div> </div> </div> </div> <?php } $conn->close(); ?> <script> $('#mancoTable').on("click","tr td",function(){ //var header = $('#pmsPageTable th').eq($(this).index()).text(); //to get clicked column's header // var trackid = $(this).siblings('td:nth-child(6)').text(); //get column at column 36 var data = $(this).text(); //get clicked column value var dCell = $(this).index(); //get clicked column value if(dCell ==5){ var year = $("#applyYear").val(); var dealCode = $("#dealCode").val(); var compCode = $("#compCode").val(); var userID = $("#userID").val(); var manHeadercomID = $("#manHeadercomID").val(); // var deleteAccess = $("#deleteAccess").val(); // if(deleteAccess == 0){ // Swal.fire({ // icon: 'error', // title: 'Access Denied', // text: 'You are not allowed to delete record from this page...', // footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' // }) // return false; // } ShowUploadBar(); $.ajax({ url:"./mancom/loadMancomDatabase.php", type:"POST", async:true, data:{ "userID":userID, "year":year, "compCode":compCode, "dealCode":dealCode, "manHeadercomID":manHeadercomID, "rptMan":1 }, success: function(d){ $("#mancomDatabase").html(d); ShowUploadBar(); } }) } }); $("#SaveNewMancomHeader").click(function(){ var year = $("#applyYear").val(); var dealID = $("#dealID").val(); var activeCompany = $("#selectedCompanyID").val(); var userID = $("#userID").val(); var MyCompanyID = $("#MyCompanyID").val(); //alert(activeCompany); if(activeCompany==""){ activeCompany = MyCompanyID; } if(activeCompany==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select company from the list to continue... ' }) return false; } if(dealID==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select Dealer from the list to continue... ' }) return false; } ShowUploadBar(); $.ajax({ url:"./mancom/saveNewMancomHeader.php", type:"POST", async:true, data:{ "userID":userID, "year":year, "dealID":dealID, "activeCompany":activeCompany, "save":1 }, success: function(d){ $("#mancomList").html(d); ShowUploadBar(); } }) }); function getInfo(row) { var x=row.cells; var myX = x[0].innerHTML; document.getElementById("manHeadercomID").value = x[0].innerHTML; document.getElementById("year").value = x[1].innerHTML; document.getElementById("compCode").value = x[2].innerHTML; document.getElementById("dealCode").value = x[3].innerHTML; document.getElementById("mancomTitle").innerHTML= "MANCOM DATA - " + x[2].innerHTML + " (" + x[3].innerHTML +") - Vehicle Sales"; } function loadMancomHeader(){ var selectedCompanyID = $("#selectedCompanyID").val(); var userID = $("#userID").val(); //alert(selectedCompanyID); if(selectedCompanyID==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select company from the list to continue... ' }) return false; } //alert(selectedCompanyID); selectedCompanyID document.getElementById("activeCompany").value = selectedCompanyID; ShowUploadBar(); $.ajax({ url:"./mancom/readMancomData.php", type:"POST", async:true, data:{ "selectedCompanyID":selectedCompanyID, "userID":userID, "mancom":1 }, success: function(d){ $("#mancomList").html(d); ShowUploadBar(); loadDealerships(); } }) } function loadDealerships(){ var activeCompany = $("#activeCompany").val(); //alert(activeCompany); //return false; ShowUploadBar(); $.ajax({ url: "./mancom/loadDealership.php", type: "POST", async: true, data: { "activeCompany":activeCompany, "load": 1 }, success: function(d){ $("#dealID").html(d); ShowUploadBar(); } }) } </script> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="https://cdn.canvasjs.com/jquery.canvasjs.min.js"></script> loadSynergySalesData_OUT.php 0000644 00000067616 15025013241 0012077 0 ustar 00 <?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> saveSenergySalesOUT.php 0000644 00000001652 15025013241 0011125 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['saveTheMan'])){ $selectedRecord = sanitize($_POST['selectedRecord']); $dealerID = sanitize($_POST['dealerID']); $companyID = sanitize($_POST['companyID']); $manHeadercomID = sanitize($_POST['manHeadercomID']); $rtTargetJan = sanitize($_POST['rtTargetJan']); $rtActualJan = sanitize($_POST['rtActualJan']); $rtRateJan = sanitize($_POST['rtRateJan']); $sql = "UPDATE mancom_synergy_out SET `target_sales`='$rtTargetJan',`added_by`='$userID'='', `time_stamp`='$myTimeStamp' WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selectedRecord'"; // AND `comp_id`='$companyID' AND `deal_id`='$dealerID' if($conn->query($sql) === TRUE) { } else { } echo "Record updated."; $conn->close(); } //1 jan 1 1 //3 jan 1 3 ?> saveActualByModel.php 0000644 00000007157 15025013241 0010624 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['saveMe'])){ $inValue = sanitize($_POST['inValue']); $modelCode = sanitize($_POST['modelCode']); //GET MODEL ID $md = "SELECT * FROM `pms_car_models` WHERE `deleted`=0 AND `model_code`='$modelCode' LIMIT 1"; $qMD = mysqli_query($conn,$md); while($row = mysqli_fetch_array($qMD)){ $modelID = $row['id']; } $selYear = sanitize($_POST['selYear']); $userID = sanitize($_POST['userID']); $selMonth = sanitize($_POST['selMonth']); $dealerID = sanitize($_POST['dealerID']); $selectedCompanyID = sanitize($_POST['selectedCompanyID']); $manHeadercomID = sanitize($_POST['manHeadercomID']); //CHECK IF RECORD EXIST IF. IF YES, UPDATE RECORD IF NOT INSERT RECORD $ckRec="SELECT * FROM mancom_synergy_by_model WHERE `year`='$selYear' AND `month_id`='$selMonth' AND `model_id`='$modelID' AND `comp_id`='$selectedCompanyID' AND `deal_id`='$dealerID' AND `mancom_hdr_id`='$manHeadercomID'"; $qRec = mysqli_query($conn,$ckRec); $recCount = mysqli_num_rows($qRec); if($recCount > 0){ $sql = "UPDATE mancom_synergy_by_model SET `sales_count`='$inValue',`date_added`='$myTimeStamp',`added_by`='$userID' WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selMonth' AND `model_id`='$modelID'"; if($conn->query($sql) === TRUE) { } else { } }else{ $sqlA="INSERT INTO mancom_synergy_by_model( `id`, `mancom_hdr_id`, `comp_id`, `deal_id`, `year`, `month_id`, `model_id`, `sales_count`, `date_added`, `added_by` ) VALUES( '', '$manHeadercomID', '$selectedCompanyID', '$dealerID', '$selYear', '$selMonth', '$modelID', '$inValue', '$myTimeStamp', '$userID' )"; if($conn->query($sqlA) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } } $variant = "SELECT * FROM `pms_car_models` WHERE `deleted`=0 AND `brand_id`='$selectedCompanyID' 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`='$selYear' 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>"; } } $conn->close(); } //1 jan 1 1 //3 jan 1 3 ?> MANCOM_DataEntry.php 0000644 00000021530 15025013241 0010174 0 ustar 00 <?php session_start(); include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_SESSION['userID'])) { // pmsReport.php => ReportPEFC.php => loadDataReportC.php $uID = $_SESSION['userID']; } if(isset($_POST['reports'])){ $companyID = $_POST['companyID']; //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($uID); $moduleID = 37; $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='$uID'>"; echo "<input type='hidden' id='companyID' value='$companyID'>"; 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';} 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 ============================================================================================== //============================================================================================================== ?> <div class="shadow-sm mb-3 pageHeaderContainer content-justify-right pt-2 pb-2" style="padding:0px;" > <div class="pageSearchHeader bg-white p-1 pt-1 w-100" > <h4 class="ml-3 mt-1"><i class="fa fa-file-text-o w-25" style='color:#0471AC;float:left;width:40%'> MANCOM Data Entry </i></h4> <!--<h4 class="ml-3 mt-1"><i class="fa fa-file-title-o w-75" id='rptTitle' style='text-align:left;color:#0471AC;float:left;width:30%'> Employee </i></h4>--> </div> </div> <div class="wrapper mt-3 p-0 shadow-sm float:left bg-white h-auto"> <div class="row fluid m-0 w-100 p-0 bg-white h-auto pageBodyMenu"> <div class="bg-red float:left text-left col-xs-12 col-md-4 col-lg-4 col-sm-12 p-2 h-auto" style='background:#F3F3F2;min-height:700px'> <!--########################################################################################--> <!--########################################################################################--> <style> .menuItem{ background:none; font-color:blue; font-size:16px; text-decoration:none; } .menuItem:hover{ background:none; color:blue; font-size:16px; text-decoration:underline; } ul, #myUL { list-style-type: none; } #myUL { margin: 0; padding: 0; } .caret { cursor: pointer; -webkit-user-select: none; /* Safari 3.1+ */ -moz-user-select: none; /* Firefox 2+ */ -ms-user-select: none; /* IE 10+ */ user-select: none; font-size:16px; } .caret:hover{ cursor: pointer; -webkit-user-select: none; /* Safari 3.1+ */ -moz-user-select: none; /* Firefox 2+ */ -ms-user-select: none; /* IE 10+ */ user-select: none; color:blue; font-size:16px; text-decoration:underline; } .caret::before { content: "+"; /*"\271A";*/ color: black; display: inline-block; margin-right: 6px; font-weight:bold; font-size:20px } .caret-down::before { content: "-"; /*-ms-transform: rotate(90deg); IE 9 */ /*-webkit-transform: rotate(90deg); /* Safari /*transform: rotate(90deg); */ } .nested { display: none; cursor: pointer; } .active { display: block; } </style> <!-- <ul id="ReportAa"> <li><span class="caret">KRA List</span> <ul class="nested"> <li>Water</li> <li>Coffee</li> <li><span class="caret">Tea</span> <ul class="nested"> <li>Black Tea</li> <li>White Tea</li> <li><span class="caret">Green Tea</span> <ul class="nested"> <li>Sencha</li> <li>Gyokuro</li> <li>Matcha</li> <li>Pi Lo Chun</li> </ul> </li> </ul> </li> </ul> </li> </ul> --> <h5>Select Reports</h5> <div style="min-height:700px;overflow:auto;background:#F9F9F9"> <ul style='background:#F9F9F9;padding:10px;border:0px solid lightgray;'> <li><span class="caret">MANCOM Report - Operation</span> <ul class="nested"> <li class='menuItem' id="manVehicleSales">Vehicle Sales Report</li> <li class='menuItem' id="senergySalesIn">Synergy Sales Report - (IN)</li> <li class='menuItem' id="senergySalesOut">Synergy Sales Report - (OUT)</li> </ul> </li> </ul> </div> <script> var toggler = document.getElementsByClassName("caret"); var i; for (i = 0; i < toggler.length; i++) { toggler[i].addEventListener("click", function() { this.parentElement.querySelector(".nested").classList.toggle("active"); this.classList.toggle("caret-down"); }); } </script> <!--########################################################################################--> <!--########################################################################################--> </div> <div id="activeReportFrom" class="bg-red float:left text-left col-xs-12 col-xs-12 col-md-8 col-lg-8 col-xl-8 col-sm-12 p-2 h-500"> <!--########################################################################################--> <!--########################################################################################--> <!--########################################################################################--> <!--########################################################################################--> </div> </div> </div> <?php } ?> <script language="javascript" type="text/javascript"> $("#manVehicleSales").click(function(){ var userID = $("#userID").val(); var companyID = $("#companyID").val(); ShowUploadBar(); $.ajax({ url: "./mancom/manVehicleSales.php", type: "POST", async: true, data: { "title":"VEHICLE Sales Report", "userID":userID, "companyID":companyID, "mancom": 1 }, success: function(d){ $("#activeReportFrom").html(d); ShowUploadBar(); } }) }); $("#senergySalesIn").click(function(){ var userID = $("#userID").val(); var companyID = $("#companyID").val(); ShowUploadBar(); $.ajax({ url: "./mancom/manSynergySales.php", type: "POST", async: true, data: { "title":"SYNERGY Sales Report -IN", "userID":userID, "companyID":companyID, "mancom": 1 }, success: function(d){ $("#activeReportFrom").html(d); ShowUploadBar(); } }) }); $("#senergySalesOut").click(function(){ var userID = $("#userID").val(); var companyID = $("#companyID").val(); ShowUploadBar(); $.ajax({ url: "./mancom/manSynergySalesOUT.php", type: "POST", async: true, data: { "title":"SYNERGY Sales Report - OUT", "userID":userID, "companyID":companyID, "mancom": 1 }, success: function(d){ $("#activeReportFrom").html(d); ShowUploadBar(); } }) }); </script> saveSenergySales.php 0000644 00000001757 15025013241 0010543 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['saveTheMan'])){ $selectedRecord = sanitize($_POST['selectedRecord']); $dealerID = sanitize($_POST['dealerID']); $companyID = sanitize($_POST['companyID']); $manHeadercomID = sanitize($_POST['manHeadercomID']); $rtTargetJan = sanitize($_POST['rtTargetJan']); $rtActualJan = sanitize($_POST['rtActualJan']); $rtRateJan = sanitize($_POST['rtRateJan']); $sql = "UPDATE mancom_synergy_sales SET `actual_sales`='$rtActualJan',`target_sales`='$rtTargetJan',`target_vs_actual_rate`='$rtRateJan',`added_by`='$userID'='', `time_stamp`='$myTimeStamp' WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selectedRecord'"; // AND `comp_id`='$companyID' AND `deal_id`='$dealerID' if($conn->query($sql) === TRUE) { } else { } echo "Record updated."; $conn->close(); } //1 jan 1 1 //3 jan 1 3 ?> adrian.php 0000644 00000005250 15025013241 0006506 0 ustar 00 <!DOCTYPE html> <html lang="{{ str_replace('_', '-', app()->getLocale()) }}"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Laravel</title> <!-- Fonts --> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-9ndCyUaIbzAi2FUVXJi0CjmCapSmO7SnpJef0486qhLnuZ2cdeRhO02iuK6FUUVM" crossorigin="anonymous"> <link href="https://fonts.bunny.net/css2?family=Nunito:wght@400;600;700&display=swap" rel="stylesheet"> <!-- Styles --> <style> body { font-family: 'Nunito', sans-serif; } </style> </head> <body class="antialiased"> <div class="relative flex items-top justify-center min-h-screen bg-gray-100 dark:bg-gray-900 sm:items-center py-4 sm:pt-0 p-3"> <?php $headerData = [ 'Ranger','F150','Raptor','Mustang' ]; $month = [ 'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December' ]; ?> <table class="table table-primary"> <tr> <th></th> <!-- Empty cell for the first column --> <?php foreach ($headerData as $header) { echo '<th>' . $header . '</th>'; // Output table header cells } ?> </tr> <?php for ($i = 0; $i < count($month); $i++) { echo '<tr>'; echo '<td>' . $month[$i] . '</td>'; // Output the month as a regular cell for ($j = 0; $j < count($headerData); $j++) { echo '<td><input type="text" data-month="' . $month[$i] . '" data-header="' . $headerData[$j] . '" class="data-input"/></td>'; } echo '</tr>'; } ?> </table> <script> const dataInputs = document.querySelectorAll('.data-input'); dataInputs.forEach(input => { input.addEventListener('click', function() { const month = this.getAttribute('data-month'); const header = this.getAttribute('data-header'); const value = this.value; // Perform your desired action with the data console.log('Month:', month); console.log('Header:', header); console.log('Value:', value); }); }); </script> </div> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-geWF76RCwLtnZ8qwWowPQNguL3RmwHVBC9FhGdlKrxdiJJigb/j/68SIy3Te4Bkz" crossorigin="anonymous"></script> </body> </html> loadDealership.php 0000644 00000001173 15025013241 0010170 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['load'])){ $activeCompany = $_POST['activeCompany']; echo "<option value='' selected>- Branch/Dealership -</option>"; $sql = "SELECT * FROM `vts_dealerships` WHERE `deal_status`=1 AND `comp_id`= '$activeCompany' ORDER BY `deal_name` ASC"; $qSql = mysqli_query($conn,$sql); while($row = mysqli_fetch_array($qSql)){ echo "<option value='".$row['deal_id']."'>".$row['deal_name']."</option>"; } } $conn->close(); ?> readSynergySalesData.php 0000644 00000004361 15025013241 0011330 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['mancom'])){ $companyID = $_POST['selectedCompanyID']; $userID = $_POST['userID']; $reportType = 'synergy_sales'; $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$companyID' AND deleted = 0 AND `report_type`='$reportType' ORDER BY `year` DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ $linkData = "MANCOM_VehicleSalesReport.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id']; ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'>"; ?> <button class="btn btn-danger border float-right" onClick="window.open('./pdfViewer/<?php echo $linkData;?>')"><i class="fa fa-print"></i></button> <button class="btn btn-info border float-right" ><i data-toggle='modal' data-target='#updateMancom' class='fa fa-pencil-square-o float-right' aria-hidden='true'></i> </button> <?php echo "</td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } $conn->close(); } saveJan.php 0000644 00000003511 15025013241 0006635 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['saveTheMan'])){ $selectedRecord = sanitize($_POST['selectedRecord']); $dealerID = sanitize($_POST['dealerID']); $companyID = sanitize($_POST['companyID']); $manHeadercomID = sanitize($_POST['manHeadercomID']); $rtTargetJan = sanitize($_POST['rtTargetJan']); $rtActualJan = sanitize($_POST['rtActualJan']); $rtRateJan = sanitize($_POST['rtRateJan']); $flTargetJan = sanitize($_POST['flTargetJan']); $flActualJan =sanitize($_POST['flActualJan']); $flRateJan = sanitize($_POST['flRateJan']); $opsTargetJan = sanitize($_POST['opsTargetJan']); $opsActualJan = sanitize($_POST['opsActualJan']); $opsRateJan = sanitize($_POST['opsRateJan']); $manTargetJan = sanitize($_POST['manTargetJan']); $manActualJan = sanitize($_POST['manActualJan']); $manRateJan = sanitize($_POST['manRateJan']); $sql = "UPDATE mancom_data SET `retail_actual_sales`='$rtActualJan',`retail_target_sales`='$rtTargetJan',`retail_target_vs_actual_rate`='$rtRateJan', `fleet_actual_sales`='$flActualJan',`fleet_target_sales`='$flTargetJan',`fleet_target_vs_actual`='$flRateJan', `ops_total_sales`='$opsActualJan',`ops_total_target`='$opsTargetJan',`ops_target_vs_actual`='$opsRateJan', `plant_target_sales`='$manTargetJan',`plant_actual_sales`='$manActualJan',`plant_target_vs_actual`='$manRateJan', `updated_by`='$userID'='', `date_updated`='$myTimeStamp' WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selectedRecord'"; // AND `comp_id`='$companyID' AND `deal_id`='$dealerID' if($conn->query($sql) === TRUE) { } else { } echo "Record updated."; $conn->close(); } //1 jan 1 1 //3 jan 1 3 ?> saveNewSynergySalesHeader.php 0000644 00000005053 15025013241 0012343 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['save'])){ $year = $_POST['year']; $userID = $_POST['userID']; $dealID = $_POST['dealID']; $activeCompany = $_POST['activeCompany']; $reportType = 'synergy_sales'; $sql="INSERT INTO mancom_hdr(`id`,`company_id`,`dealer_id`,`last_update_by`,`year`,`report_type`,`date_added` ) VALUES('','$activeCompany','$dealID','$userID','$year','$reportType','$myTimeStamp')"; if($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$activeCompany' AND deleted = 0 AND `report_type`='$reportType' ORDER BY year DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ $linkData = "MANCOM_VehicleSalesReport.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id']; ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'>"; ?> <button class="btn btn-danger border float-right" onClick="window.open('./pdfViewer/<?php echo $linkData;?>')"><i class="fa fa-print"></i></button> <button class="btn btn-info border float-right" ><i data-toggle='modal' data-target='#updateMancom' class='fa fa-pencil-square-o float-right' aria-hidden='true'></i> </button> <?php echo "</td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } $conn->close(); } ?> manSynergySalesOUT.php 0000644 00000046614 15025013241 0010775 0 ustar 00 <?php include_once("../../../cfg/conn.php"); //error_reporting(0); if(isset($_POST['mancom'])){ $title = $_POST['title']; $userID = $_POST['userID']; $companyID = $_POST['companyID']; $reportType = 'synergy_sales'; //============================================================================================================== //VALIDATE ACCESS ============================================================================================== //============================================================================================================== $roleID = userProfileID($userID); include ("../functions/users.php"); $roleID = userProfileID($userID); $compName = getCompanyNameSub($companyID)[0]; $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='MyCompanyID' value='$companyID'>"; 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';} if($edit==1){ $editVisible=''; }else{ $editVisible='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 ============================================================================================== //============================================================================================================== echo "<input type='hidden' id='manHeadercomID'>"; echo "<input type='hidden' id='year'>"; echo "<input type='hidden' id='compCode'>"; echo "<input type='hidden' id='dealCode'>"; echo "<input type='hidden' id='activeCompany' value='$companyID'>"; ?> <div class="mb-3 pageHeaderContainer content-justify-right pt-2 pb-3" style="padding:0px;height:auto;border:0px solid red" > <div class="pageSearchHeader bg-white p-2 pt-1" style='border:0px solid white'> <h4 class="ml-3 mt-1"><i class="fa fa-building text-danger p-2" style='font-size:20px;color:#0471AC border:0px'> <?php echo $title;?> </i></h4> </div> <div class="pageSearchHeader bg-white p-2 "> <select onchange="javascript:loadMancomHeader()" name='selectedCompanyID' id='selectedCompanyID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <option selected value="<?php echo $companyID;?>"><?php echo getCompanyNameSub($companyID)[0];?></option> <?php $sql = "SELECT * FROM vts_company WHERE comp_status=1 AND `brand`='Yes' ORDER BY comp_name ASC"; $getGroup = mysqli_query($conn,$sql); $chkIfExist = mysqli_num_rows($getGroup); if($chkIfExist > 0){ while($row = mysqli_fetch_array($getGroup)){ echo "<option value='".$row['comp_id']."'>".$row['comp_code']." - ".$row['comp_name']."</option>"; } } ?> </select> </div> </div> <div class="col-xl-12 border p-1 overflow-auto" > <table id='mancoTable' style="width:100%;border-collapse:collapse;"> <thead> <th style="padding-left:2px;text-align:left;border:0px solid red">REC.ID</thd> <th style="padding-left:2px;text-align:left;border:0px solid red">YEAR</th> <th style="padding-left:2px;text-align:left;border:0px solid red">COMPANY NAME</th> <th style="padding-left:2px;text-align:left;border:0px solid red">DEALER NAME</th> <th style="padding-left:2px;text-align:left;border:0px solid red">UPDATES</th> <th style="border:0px solid red;color:red;font-family:Calibri;font-size:18px;font-weight:normal"> <button <?php echo $addButton;?> class="btn btn-warning float-right"><i data-toggle='modal' data-target='#addMancomHeader' class='fa fa-plus float-left' aria-hidden='true'>Add</i></button> </th> </thead> <thead id ='mancomList'> <?php $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$companyID' AND deleted = 0 AND `report_type`='$reportType' ORDER BY year DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ $linkData = "MANCOM_SynergySalesReportOUT.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id']; ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'>"; ?> <button <?php echo $printButton;?> class="btn btn-danger border float-right" onClick="window.open('./pdfViewer/<?php echo $linkData;?>')"><i <?php echo $printButton;?> class="fa fa-print"></i></button> <button <?php echo $editButton;?> class="btn btn-info border float-right d-<?php echo $editVisible;?>" ><i <?php echo $editButton;?> data-toggle='modal' data-target='#updateMancom' class='fa fa-pencil-square-o'></i> </button> <?php echo "</td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } ?> </thead> </table> </div> <!--MODAL FORM FOR ADD NEW BRAND full-width-div --> <!-- The Modal --> <!--MODAL FORM FOR ADD NEW GROUP--> <!-- The Modal --> <div class="modal fade " id="addMancomHeader"> <div class="modal-dialog modal-md"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 class="modal-title">NEW SYNERGY SALES REPORT</h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="form-group"> <label for="dealID">DEALERSHIP/BRANCH:</label> <select name='dealID' id='dealID' class="form-select form-select-lg p-2 w-100 rounded-sm selectBG"> <?php $selectedCompanyID = $_POST['selectedCompanyID']; echo "<option value=''>- Branch/Dealership -</option>"; $sql = "SELECT * FROM `vts_dealerships` WHERE `deal_status`=1 AND `comp_id`= '$companyID' ORDER BY `deal_name` ASC"; $qSql = mysqli_query($conn,$sql); while($row = mysqli_fetch_array($qSql)){ echo "<option value='".$row['deal_id']."'>".$row['deal_name']."</option>"; } ?> </select> </div> <div class="form-group"> <label for="applyYear">APPLICABLE YEAR:</label> <input type="number" min="<?php echo $curYear;?>" value="<?php echo $curYear;?>" max="9999" class="form-control W-50" id="applyYear" name="applyYear"> </div> </div> <!-- Modal footer --> <div class="modal-footer"> <button <?php echo $addButton;?> type="button" class="btn btn-success pl-4 pr-4" data-dismiss="modal" id="SaveNewMancomHeader"> <span class="btn-label"><i class="fa fa-save"> Save </i></button> <button type="button" class="btn btn-danger" data-dismiss="modal"> <span class="btn-label"><i class="fa fa-close"> Close</i></button> </div> </div> </div> </div> <!-- The Modal --> <div class="modal" id="updateMancom" style='margin-top:30px;width:98%;margin-left:1%'> <div class="modal-fullscreen m-md-0"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h5 id='mancomTitle' class="modal-title"></h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="modal-content modal-dialog-scrollable" style='min-width:100%;padding:0px;height:750px'> <!--MAR CONTENT DATA --> <div id='mancomDatabase' class="modal-body" style="background:white;padding:1px"> <!--<table style='width:100%;margin:0px' class='form-control' data-toggle="modal" data-target="#viewMARDataEntryForm"> --> </div> </div> </div> </div> </div> </div> <!-- The Modal --> <div class="modal w-50" id="monthlyDataXXXXXXXXXXxx" style='background:transparent;margin-top:30px;'> <div class="modal-mdp-1" style='background:transparent;'> <div class="modal-content bg-light"> <!-- Modal Header --> <div class="modal-header"> <h5 id='monthlyDataTitle' class="modal-title"></h5> <button type="button" class="close" data-dismiss="modal">×</button> </div> <!-- Modal body --> <div class="modal-body"> <div class="modal-content modal-dialog-scrollable h-100" style='min-width:100%;padding:0px;min-height:800px'> <!--MAR CONTENT DATA --> <div id='addActualData' class="modal-body" style="background:white;padding:1px"> <!--<table style='width:100%;margin:0px' class='form-control' data-toggle="modal" data-target="#viewMARDataEntryForm"> --> adfaf </div> </div> </div> </div> </div> </div> <?php } $conn->close(); ?> <script> // $("#mancoTable tr").click(function() { // var rowCount = document.getElementById('mancoTable').rows.length; // //alert($(this).children("td").html()); // alert(rowCount); // }); $('#mancoTable').on("click","tr td",function(){ //var header = $('#pmsPageTable th').eq($(this).index()).text(); //to get clicked column's header // var trackid = $(this).siblings('td:nth-child(6)').text(); //get column at column 36 var data = $(this).text(); //get clicked column value var dCell = $(this).index(); //get clicked column value //alert(dCell); if(dCell ==5){ var year = $("#year").val(); var dealCode = $("#dealCode").val(); var compCode = $("#compCode").val(); var userID = $("#userID").val(); var manHeadercomID = $("#manHeadercomID").val(); var selectedCompanyID = $("#selectedCompanyID").val(); // var deleteAccess = $("#deleteAccess").val(); // if(deleteAccess == 0){ // Swal.fire({ // icon: 'error', // title: 'Access Denied', // text: 'You are not allowed to delete record from this page...', // footer: '<a href="user-guide.php?code=new-area">Why do I have this issue?</a>' // }) // return false; // } ShowUploadBar(); $.ajax({ url:"./mancom/loadSynergySalesData_OUT.php", type:"POST", async:true, data:{ "userID":userID, "year":year, "compCode":compCode, "dealCode":dealCode, "manHeadercomID":manHeadercomID, "selectedCompanyID":selectedCompanyID, "rptMan":1 }, success: function(d){ $("#mancomDatabase").html(d); ShowUploadBar(); } }) } }); $("#SaveNewMancomHeader").click(function(){ var year = $("#applyYear").val(); var dealID = $("#dealID").val(); var activeCompany = $("#selectedCompanyID").val(); var userID = $("#userID").val(); var MyCompanyID = $("#MyCompanyID").val(); //alert(activeCompany); if(activeCompany==""){ activeCompany = MyCompanyID; } if(activeCompany==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select company from the list to continue... ' }) return false; } if(dealID==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select Dealer from the list to continue... ' }) return false; } ShowUploadBar(); $.ajax({ url:"./mancom/saveNewSynergySalesHeader.php", type:"POST", async:true, data:{ "userID":userID, "year":year, "dealID":dealID, "activeCompany":activeCompany, "save":1 }, success: function(d){ $("#mancomList").html(d); ShowUploadBar(); } }) }); function getInfo(row) { var x=row.cells; var myX = x[0].innerHTML; document.getElementById("manHeadercomID").value = x[0].innerHTML; document.getElementById("year").value = x[1].innerHTML; document.getElementById("compCode").value = x[2].innerHTML; document.getElementById("dealCode").value = x[3].innerHTML; document.getElementById("mancomTitle").innerHTML= "MANCOM DATA - " + x[2].innerHTML + " (" + x[3].innerHTML +") - Synergy Sales (OUT)"; } function getMonthData(row) { var x=row.cells; var myX = x[0].innerHTML; //alert(myX); document.getElementById("monthlyDataTitle").innerHTML= "ACTUAL SALES - " + x[0].innerHTML; document.getElementById("selMonth").value = x[0].innerHTML; } function loadMancomHeader(){ var selectedCompanyID = $("#selectedCompanyID").val(); var userID = $("#userID").val(); //alert(selectedCompanyID); if(selectedCompanyID==""){ Swal.fire({ icon: 'Error', title: 'Invalid Data', text: 'Please select company from the list to continue... ' }) return false; } //alert(selectedCompanyID); selectedCompanyID document.getElementById("activeCompany").value = selectedCompanyID; ShowUploadBar(); $.ajax({ url:"./mancom/readSynergySalesData.php", type:"POST", async:true, data:{ "selectedCompanyID":selectedCompanyID, "userID":userID, "mancom":1 }, success: function(d){ $("#mancomList").html(d); ShowUploadBar(); loadDealerships(); } }) } function loadDealerships(){ var activeCompany = $("#activeCompany").val(); //alert(activeCompany); //return false; ShowUploadBar(); $.ajax({ url: "./mancom/loadDealership.php", type: "POST", async: true, data: { "activeCompany":activeCompany, "load": 1 }, success: function(d){ $("#dealID").html(d); ShowUploadBar(); } }) } </script> <script type="text/javascript" src="https://canvasjs.com/assets/script/jquery-1.11.1.min.js"></script> <script type="text/javascript" src="https://cdn.canvasjs.com/jquery.canvasjs.min.js"></script> saveNewMancomHeader.php 0000644 00000005230 15025013241 0011122 0 ustar 00 <?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['save'])){ $year = $_POST['year']; $userID = $_POST['userID']; $dealID = $_POST['dealID']; $activeCompany = $_POST['activeCompany']; $reportType = 'vehicle_sales'; $sql="INSERT INTO mancom_hdr(`id`,`company_id`,`dealer_id`,`last_update_by`,`year`,`report_type`,`date_added` ) VALUES('','$activeCompany','$dealID','$userID','$year','$reportType','$myTimeStamp')"; if($conn->query($sql) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } $getMansHead = "SELECT * FROM mancom_hdr WHERE `company_id`='$activeCompany' AND deleted = 0 AND `report_type`='$reportType' ORDER BY year DESC"; $qHeads = mysqli_query($conn,$getMansHead); $qhRow = mysqli_num_rows($qHeads); if($qhRow > 0){ while($rec = mysqli_fetch_array($qHeads)){ $linkData = "MANCOM_VehicleSalesReport.php?uid=$userID&c=".getCompanyNameSub($rec['company_id'])[1]."&d=".getDealerNameSub($rec['dealer_id'])[1]."&y=".$rec['year']."&token=0&hid=".$rec['id']; ?><tr onclick="javascript:getInfo(this);" style="width:100%"><?php echo "<td class='text-left p-2'>".$rec['id']."</td>"; echo "<td class='text-left p-2'>".$rec['year']."</td>"; echo "<td class='text-left p-2'>".getCompanyNameSub($rec['company_id'])[1]."</td>"; echo "<td class='text-left p-2'>".getDealerNameSub($rec['dealer_id'])[1]."</td>"; echo "<td class='text-left p-2'>"; $update = explode(" ", $rec['last_update']); $updateDate = $update[0]; echo $updateDate; echo "</td>"; echo "<td style='border:0px solid red;color:gray;font-family:Calibri;font-size:18px;font-weight:normal'>"; ?> <button class="btn btn-danger border float-right" onClick="window.open('./pdfViewer/<?php echo $linkData;?>')"><i class="fa fa-print"></i></button> <button class="btn btn-info border float-right" ><i data-toggle='modal' data-target='#updateMancom' class='fa fa-pencil-square-o float-right' aria-hidden='true'></i> </button> <?php echo "</td>"; echo "</tr>"; } }else{ echo "<tr><td colspan='6'><div class='col-lg-12 text-dark p-5 text-center'>No record found.</div></td></tr>"; } $conn->close(); } ?> test.js 0000644 00000033025 15025013241 0006055 0 ustar 00 //======================================================================================================================================== //FEBRUARY DATA //======================================================================================================================================== document.getElementById("rtTargetFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("rtActualFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("flTargetFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("flActualFeb").addEventListener("keyup", rtTargetFeb); document.getElementById("manTargetFeb").addEventListener("keyup", rtTargetFeb); function rtTargetFeb() { var rtTargetJan = $("#rtTargetFeb").val(); var rtActualJan = $("#rtActualFeb").val(); var rtRateJan = $("#rtRateFeb").val(); var flTargetJan = $("#flTargetFeb").val(); var flActualJan = $("#flActualFeb").val(); var flRateJan = $("#flRateFeb").val(); var opsTargetJan = $("#opsTargetFeb").val(); var opsActualJan = $("#opsActualFeb").val(); var opsRateJan = $("#opsRateFeb").val(); var manTargetJan = $("#manTargetFeb").val(); var manActualJan = $("#manActualFeb").val(); var manRateJan = $("#manRateFeb").val(); if(isNaN(rtTargetJan)){ $("#rtTargetFeb").val('0'); } if(isNaN(rtActualJan)){ $("#rtActualFeb").val('0'); } if(isNaN(flTargetJan)){ $("#flTargetFeb").val('0'); } if(isNaN(flActualJan)){ $("#flActualFeb").val('0'); } if(isNaN(flActualJan)){ $("#flActualFeb").val('0'); } var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; $("#rtRateFeb").val(MyRate); var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; $("#flRateFeb").val(MyRateFL); //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetFeb").val(newOpsTarget); $("#opsActualFeb").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateFeb").val(newOpsRate); //Update Plant Target $("#manActualFeb").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateFeb").val(manRating); saveFebRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateTarget(); rateOps(); rateFleet(); rateMan(); } function saveFebRecord(){ var rtTarget = $("#rtTargetFeb").val(); var rtActual = $("#rtActualFeb").val(); var rtRate = $("#rtRateFeb").val(); var flTarget = $("#flTargetFeb").val(); var flActual = $("#flActualFeb").val(); var flRate = $("#flRateFeb").val(); var opsTarget = $("#opsTargetFeb").val(); var opsActual = $("#opsActualFeb").val(); var opsRate = $("#opsRateFeb").val(); var manTarget = $("#manTargetFeb").val(); var manActual = $("#manActualFeb").val(); var manRate = $("#manRateFeb").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveFeb.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTarget":rtTarget, "rtActual":rtActual, "rtRate":rtRate, "flTarget":flTarget, "flActual":flActual, "flRate":flRate, "opsTarget":opsTarget, "opsActual":opsActual, "opsRate":opsRate, "manTarget":manTarget, "manActual":manActual, "manRate":manRate, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //MARCH DATA //======================================================================================================================================== //======================================================================================================================================== //FEBRUARY DATA //======================================================================================================================================== document.getElementById("rtTargetMar").addEventListener("keyup", rtTargetMar); document.getElementById("rtActualMar").addEventListener("keyup", rtTargetMar); document.getElementById("flTargetMar").addEventListener("keyup", rtTargetMar); document.getElementById("flActualMar").addEventListener("keyup", rtTargetMar); document.getElementById("manTargetMar").addEventListener("keyup", rtTargetMar); function rtTargetMar() { var rtTargetJan = $("#rtTargetMar").val(); var rtActualJan = $("#rtActualMar").val(); var rtRateJan = $("#rtRateMar").val(); var flTargetJan = $("#flTargetMar").val(); var flActualJan = $("#flActualMar").val(); var flRateJan = $("#flRateMar").val(); var opsTargetJan = $("#opsTargetMar").val(); var opsActualJan = $("#opsActualMar").val(); var opsRateJan = $("#opsRateMar").val(); var manTargetJan = $("#manTargetMar").val(); var manActualJan = $("#manActualMar").val(); var manRateJan = $("#manRateMar").val(); if(isNaN(rtTargetJan)){ $("#rtTargetFeb").val('0'); } if(isNaN(rtActualJan)){ $("#rtActualFeb").val('0'); } if(isNaN(flTargetJan)){ $("#flTargetFeb").val('0'); } if(isNaN(flActualJan)){ $("#flActualFeb").val('0'); } if(isNaN(flActualJan)){ $("#flActualFeb").val('0'); } var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; $("#rtRateMar").val(MyRate); var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; $("#flRateMar").val(MyRateFL); //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetMar").val(newOpsTarget); $("#opsActualMar").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateMar").val(newOpsRate); //Update Plant Target $("#manActualMar").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateMar").val(manRating); saveMarRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateTarget(); rateOps(); rateFleet(); rateMan(); } function saveMarRecord(){ var rtTarget = $("#rtTargetMar").val(); var rtActual = $("#rtActualMar").val(); var rtRate = $("#rtRateMar").val(); var flTarget = $("#flTargetMar").val(); var flActual = $("#flActualMar").val(); var flRate = $("#flRateMar").val(); var opsTarget = $("#opsTargetMar").val(); var opsActual = $("#opsActualMar").val(); var opsRate = $("#opsRateMar").val(); var manTarget = $("#manTargetMar").val(); var manActual = $("#manActualMar").val(); var manRate = $("#manRateMar").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveMar.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTarget":rtTarget, "rtActual":rtActual, "rtRate":rtRate, "flTarget":flTarget, "flActual":flActual, "flRate":flRate, "opsTarget":opsTarget, "opsActual":opsActual, "opsRate":opsRate, "manTarget":manTarget, "manActual":manActual, "manRate":manRate, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) } //======================================================================================================================================== //APRIL DATA //======================================================================================================================================== document.getElementById("rtTargetApr").addEventListener("keyup", rtTargetApr); document.getElementById("rtActualApr").addEventListener("keyup", rtTargetApr); document.getElementById("flTargetApr").addEventListener("keyup", rtTargetApr); document.getElementById("flActualApr").addEventListener("keyup", rtTargetApr); document.getElementById("manTargetApr").addEventListener("keyup", rtTargetApr); function rtTargetMar() { var rtTargetJan = $("#rtTargetApr").val(); var rtActualJan = $("#rtActualApr").val(); var rtRateJan = $("#rtRateApr").val(); var flTargetJan = $("#flTargetApr").val(); var flActualJan = $("#flActualApr").val(); var flRateJan = $("#flRateApr").val(); var opsTargetJan = $("#opsTargetApr").val(); var opsActualJan = $("#opsActualApr").val(); var opsRateJan = $("#opsRateApr").val(); var manTargetJan = $("#manTargetApr").val(); var manActualJan = $("#manActualApr").val(); var manRateJan = $("#manRateApr").val(); if(isNaN(rtActualJan)){ return false; } if(isNaN(flActualJan)){ return false; } var rtRating = (rtActualJan/ rtTargetJan) * 100; var MyRate = rtRating.toFixed(2) + "%"; $("#rtRateApr").val(MyRate); var flRating = (flActualJan/ flTargetJan) * 100; var MyRateFL = flRating.toFixed(2) + "%"; $("#flRateApr").val(MyRateFL); //update Opsplan Target var newOpsActual = eval(rtActualJan) + eval(flActualJan); var newOpsTarget = eval(flTargetJan) + eval(rtTargetJan); $("#opsTargetApr").val(newOpsTarget); $("#opsActualApr").val(newOpsActual); var opsRate = (newOpsActual/ newOpsTarget) * 100; var newOpsRate = opsRate.toFixed(2) + "%"; $("#opsRateApr").val(newOpsRate); //Update Plant Target $("#manActualApr").val(newOpsActual); var manRate = (newOpsActual / manTargetJan) * 100; var manRating = manRate.toFixed(2) + "%"; $("#manRateApr").val(manRating); saveAprRecord(); //Save chages totalTarget(); totalOps(); totalFleet(); totalMan(); actualTarget(); actualOps(); actualFleet(); actualMan(); rateTarget(); rateOps(); rateFleet(); rateMan(); } function saveAprRecord(){ var rtTarget = $("#rtTargetApr").val(); var rtActual = $("#rtActualApr").val(); var rtRate = $("#rtRateApr").val(); var flTarget = $("#flTargetApr").val(); var flActual = $("#flActualApr").val(); var flRate = $("#flRateApr").val(); var opsTarget = $("#opsTargetApr").val(); var opsActual = $("#opsActualApr").val(); var opsRate = $("#opsRateApr").val(); var manTarget = $("#manTargetApr").val(); var manActual = $("#manActualApr").val(); var manRate = $("#manRateApr").val(); var selectedRecord = $("#selectedRecord").val(); var companyID= $("#companyID").val(); var dealerID= $("#dealerID").val(); var manHeadercomID= $("#manHeadercomID").val(); //alert(manRateJan); $.ajax({ url:"./mancom/saveApr.php", type:"POST", async:true, data:{ "selectedRecord":selectedRecord, "companyID":companyID, "dealerID":dealerID, "manHeadercomID":manHeadercomID, "rtTarget":rtTarget, "rtActual":rtActual, "rtRate":rtRate, "flTarget":flTarget, "flActual":flActual, "flRate":flRate, "opsTarget":opsTarget, "opsActual":opsActual, "opsRate":opsRate, "manTarget":manTarget, "manActual":manActual, "manRate":manRate, "saveTheMan":1 }, success: function(d){ $("messageNote").html(d); //ShowUploadBar(); } }) }
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings