Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $(".edit_scoala").click(function(){
- var id_scoala = $(this).attr("id").substring(12);
- //alert(id_scoala);
- $.ajax({
- type: "POST",
- url: "ajax/edit_scoala.php",
- data:{
- id: id_scoala
- },
- cache:false,
- //dataType: "html"
- }).done(function(ms){
- $("#response").html(ms);
- var map = L.map('map').setView([44.9323281,26.0306833], 12,25);
- L.tileLayer( 'https://api.mapbox.com/styles/v1/mapbox/streets-v10/tiles/{z}/{x}/{y}?access_token=pk.eyJ1IjoibWVnYTYzODIiLCJhIjoiY2ozbXpsZHgxMDAzNjJxbndweDQ4am5mZyJ9.uHEjtQhnIuva7f6pAfrdTw', {
- maxZoom: 18,
- attribution: 'Map data © <a href="http://openstreetmap.org/"> OpenStreetMap </a> contributors, ' +
- '<a href="http://creativecommons.org/"> CC-BY-SA </a>, ' +
- 'Imagery © <a href="http://mapbox.com"> Mapbox </a>',
- id: 'examples.map-i875mjb7'
- }).addTo(map);
- function putDraggable() {
- /* create a draggable marker in the center of the map */
- draggableMarker = L.marker([ map.getCenter().lat, map.getCenter().lng], {draggable:true, zIndexOffset:900}).addTo(map);
- /* collect Lat,Lng values */
- draggableMarker.on('dragend', function(e) {
- $("#latitudine").val(this.getLatLng().lat);
- $("#longitudine").val(this.getLatLng().lng);
- });
- }
- $( document ).ready(function() {
- putDraggable();
- $("#edit_scoala_").change(function() {
- for(var i=0;i<arr.length;i++) {
- if(arr[i]['id'] == $("#edit_scoala_").val()) {
- $('#detalii').val(arr[i]['detalii']);
- $('#latitudine').val(arr[i]['latitudine']);
- $('#longitudine').val(arr[i]['longitudine']);
- $('#telefon').val(arr[i]['telefon']);
- $('#cuv_cheie').val(arr[i]['cuv_cheie']);
- map.panTo([arr[i]['latitudine'], arr[i]['longitudine']]);
- draggableMarker.setLatLng([arr[i]['latitudine'], arr[i]['longitudine']]);
- break;
- }
- }
- });
- });
- });
- });
- var arr = JSON.parse( '<?php echo json_encode($arr) ?>' );
- if (isset($msg))
- echo $msg;
- $conn= new DBConn();
- $arr = $conn->getScoalaList();
- ?>
- <div class= "tabel_c ">
- <div id="response"></div>
- <h1 style="color:white;text-shadow: 4px 4px 7px red;">Lista scoli</h1>
- <table class="table table-condensed" id="tabel-scoala">
- <thead>
- <th style="width:130px">Nume</th>
- <th style="width:230px">Detalii</th>
- <th style="width:150px">Latitudine</th>
- <th style="width:130px">Longitudine</th>
- <th style="width:230px">Nr. Telefon</th>
- <th style="width:150px">Cuvinte cheie</th>
- </thead>
- <?php
- $scoala = $db->DbGetAll("SELECT * FROM scoala");
- if(!$scoala){
- echo "<p>Nu exista scoli</p>";}
- else{
- foreach ($scoala as $scoli)
- {
- echo '<tr>
- <td>'.$scoli["nume"].'</td>
- <td>'.$scoli["detalii"].'</td>
- <td>'.$scoli["latitudine"].'</td>
- <td>'.$scoli["longitudine"].'</td>
- <td>'.$scoli["telefon"].'</td>
- <td>'.$scoli["cuv_cheie"].'</td>
- <!--<td ><button><img style="height:25px; width:20px "src="../images/icon.png""></button> </button> <img style="height:25px; width:20px " src="../images/delete.png""></td> -->
- <td><i class="fa fa-pencil edit_scoala" title="Modifica Scoala" id="edit_scoala_'.$scoli["id"].'" style="cursor: pointer;"></i>
- <i class="fa fa-remove remove_scoala" id="remove_scoala_'.$scoli["id"].'" style="cursor: pointer;" title="Sterge Scoala"></i>
- </td>
- </tr>';
- }
- }
- ?>
- </table>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement