Файловый менеджер - Редактировать - /home2/cocinasdalloway/lotes.cocinasdalloway.com/Administrador/Home/BulkLoad.php
Назад
<div class="col-xs-12 col-md-12" > <div class="x_panel"> <div class="x_title"> <center> <h6><strong>Carga Masiva</strong> </h6> </center> </div> <div class="box-body" id="ima" style="width: 100%;"> <center> <div id="costo" style="font-weight: bold; text-align: center; font-size: 200%; "> </div> <br /> <input type="file" name="file" id="fileUpload" accept=".xls, .xlsx"> <br /> <br /> <button id="button-a" id="uploadExcel" onclick="loadExcel()">Cargar Excel</button> <pre id="jsonData"> </pre> <div id="loader3"></div> <hr /> </center> </div> </div> </div> <div class="col-md-12 col-sm-12 "> <div class="x_panel"> <div class="x_title"> <h2>Ejemplo orden de los campos <small><b><u>(No agregar el titulo de la columna)</u></b></small></h2> <ul class="nav navbar-right panel_toolbox"> <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a> </li> <li><a class="close-link"><i class="fa fa-close"></i></a> </li> </ul> <div class="clearfix"></div> </div> <div class="x_content"> <table class="table table-striped"> <thead> <tr> <th>Nombre del lote</th> <th>Costo</th> <th>Esquina1 Latitud</th> <th>Esquina1 Longitud</th> <th>Esquina2 Latitud</th> <th>Esquina2 Longitud</th> <th>Esquina3 Latitud</th> <th>Esquina3 Longitud</th> <th>Esquina4 Latitud</th> <th>Esquina4 Longitud</th> </tr> </thead> <tbody> <tr> <th scope="row">Lote 1</th> <td>80000</td> <td>21.232878</td> <td>-99.477416</td> <td>21.233258</td> <td>-99.476858</td> <td>21.232848</td> <td>-99.477416</td> <td>21.232638</td> <td>-99.477320</td> </tr> </tbody> </table> </div> </div> </div> <script lang='javascript' src='xlsx.full.min.js'></script> <script> var selectedFile; let rowObject; document.getElementById("fileUpload").addEventListener("change", function(event){ selectedFile = event.target.files[0]; }); function loadExcel(){ if(selectedFile){ $("#loader3").html("<p align='center'><img src='ajax-loader.gif' /></p>"); var fileReader = new FileReader(); fileReader.onload = function (event){ var data = event.target.result; var workbook = XLSX.read(data,{type:"binary"}); workbook.SheetNames.forEach(sheet => { rowObject = XLSX.utils.sheet_to_json(workbook.Sheets[sheet],{ header: 1 }); // let jsonObject = JSON.stringify(rowObject); //document.getElementById("jsonData").innerHTML = rowObject; console.log(rowObject); }); $("#jsonData").empty(); setTimeout(function(){ loadExcelToBD(rowObject); }, 2000); }; fileReader.readAsBinaryString(selectedFile); } document.getElementById("fileUpload").value=""; } function loadExcelToBD(valorJson){ $("#loader3").html("<p align='center'><img src='ajax-loader.gif' /></p>"); //console.log(valorJson); $.ajax({ url: 'import.php', async: false, type: 'post', data: { 'myData': JSON.stringify(valorJson), }, dataType: 'json', success: function(response){ $("#loader3").html(""); if(response != ''){ document.getElementById("jsonData").innerHTML = (response.message) }else{ document.getElementById("jsonData").innerHTML = (response.message) //alert('file not uploaded'); } } }); } </script>
| ver. 1.4 |
Github
|
.
| PHP 8.2.22 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка