File manager

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

Back
<?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>

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