bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
include('header.php');

if ($_POST['lokasi']=='') {
    $_POST['lokasi']="all";
}

$sql = "SELECT * FROM LAN_INVENTORI ";
$sql .= "LEFT JOIN LAN_POKOKCODE ON LAN_INVENTORI.INV_POKOKCODE=LAN_POKOKCODE.POK_POKOKCODE ";
$sql .= "LEFT JOIN LAN_SYSTMAKAR ON LAN_INVENTORI.INV_CODEROOTS=LAN_SYSTMAKAR.SYS_CODEROOTS ";
if ($_POST['lokasi']!='all') {
    $sql .= "WHERE LAN_INVENTORI.INV_LOKASLAND='$_POST[lokasi]' ";
}else{
    $sql .= " ";
}
$sql .= "ORDER BY INV_INVENTORI";
//$sql .= "WHERE LAN_INVENTORI.INV_INVENTORI='$_GET[CusID]'";

$res1 = mysqli_query($mysqli, $sql);
$res2 = mysqli_query($mysqli, $sql);

$sql2 = "SELECT DISTINCT
INV_LOKASLAND,
LOK_LOKASNAME
FROM
LAN_INVENTORI,
LAN_LOKASCODE 
WHERE
INV_LOKASLAND=LOK_LOKASLAND
ORDER BY
LOK_LOKASNAME";
$res3 = mysqli_query($mysqli, $sql2);

//$maps[$row['INV_LOKASLAND']][] = array($row['INV_KOORDINAY'], $row['INV_KOORDINAX'], $row['INV_INVENTORI'], $row['POK_SAINTIFIK'], $row['POK_TEMPATANS'], $row['INV_AGEGTREES'], $row['SYS_NAMAROOTS']);
//   $categories[$row['INV_LOKASLAND']] = "'{$row['INV_LOKASLAND']}'";
?>
<script>
    // Initialize and add the map
    function initMap() {
        var map;
        var bounds = new google.maps.LatLngBounds();
        var mapOptions = {
            mapTypeId: 'roadmap'
        };

// Display a map on the web page
        map = new google.maps.Map(document.getElementById("map"), mapOptions);
        map.setTilt(50);

// Multiple markers location, latitude, and longitude
        var markers = [
            <?php
            //Fetching all the rows as arrays
            while ($row = mysqli_fetch_array($res1, MYSQLI_ASSOC)) {
                echo "['', " . $row['INV_KOORDINAX'] . ", " . $row['INV_KOORDINAY'] . "],";
            }
            ?>
        ];

// Info window content
        var infoWindowContent = [
            <?php
            //Fetching all the rows as arrays
            while ($row = mysqli_fetch_array($res2, MYSQLI_ASSOC)) {
            ?>['<div class="info_content">' +
                    "<p><b>No. Inventori: </b><?php echo $row['INV_INVENTORI']; ?></br> " +
                    "<b>Nama Tempatan: </b><?php echo $row['POK_TEMPATANS']; ?></br> " +
                    "<b>Nama Saintifik: </b><?php echo $row['POK_SAINTIFIK']; ?></br> " +
                    '</div>'
                ],
            <?php } ?>
        ];

// Add multiple markers to map
        var infoWindow = new google.maps.InfoWindow(),
            marker, i;

// Place each marker on the map  
        for (i = 0; i < markers.length; i++) {
            var position = new google.maps.LatLng(markers[i][1], markers[i][2]);
            bounds.extend(position);
            marker = new google.maps.Marker({
                position: position,
                map: map,
                title: markers[i][0]
            });

// Add info window to marker    
            google.maps.event.addListener(marker, 'click', (function(marker, i) {
                return function() {
                    infoWindow.setContent(infoWindowContent[i][0]);
                    infoWindow.open(map, marker);
                }
            })(marker, i));

// Center the map to fit all markers on the screen
            map.fitBounds(bounds);
        }

// Set zoom level
        var boundsListener = google.maps.event.addListener((map), 'bounds_changed', function(event) {
            this.setZoom(11);
            google.maps.event.removeListener(boundsListener);
        });
    }

window.initMap = initMap;
</script>

<div class="content-wrapper">
    
    <div class="content-header">
        <div class="container">
            <div class="row mb-2">
                <div class="col-sm-6">
                    
                </div>
                <div class="col-sm-6">
                    
                </div>
            </div>
        </div>
    </div>

<div class="content">
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <div class="card card-orange card-outline">
                        <div class="card-header">
                            <h5 class="card-title m-0">Peta Lokasi</h5>
                        </div>
                        <div class="card-body">
                            
                            <form action="" method="post">
                                <div class="row">
                                    <div class="col-md-4">
                                        <label></label>
                                    </div>
                                    <div class="col-md-4">
                                        
                                        <div class="form-group">
                                            <select class="form-control" name="lokasi" onchange="submit()">
                                                <option value="all">Sila Pilih Lokasi</option>
                                                <?php
                                                while ($row = mysqli_fetch_array($res3, MYSQLI_ASSOC)) {
                                                    if ($row['INV_LOKASLAND'] == $_POST['lokasi']) {
                                                        echo "<option value='" . $row['INV_LOKASLAND'] . "' selected>" . $row['LOK_LOKASNAME'] . "</option>";
                                                    } else {
                                                        echo "<option value='" . $row['INV_LOKASLAND'] . "'>" . $row['LOK_LOKASNAME'] . "</option>";
                                                    }
                                                }
                                                ?>
                                            </select>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <label></label>
                                    </div>
                                </div>
                            </form>
                            <div class="row">
                                <div class="col-lg-12">
                                    <div id="map" style="margin: 10px auto; border: #666 solid 2px; width: 100%; height: 500px;"></div>
                                    <script async src="https://maps.googleapis.com/maps/api/js?key=<?php echo $map_key;?>&callback=initMap"></script>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        
    </div>

</div>

<?php include('footer.php'); ?>