hjkhghopjkertteerterterterertertrtoirh
bnmbertsurhetertertertertertertertpdf'tdfg
C:
/
xampp
/
htdocs
/
tree
/
Upload FileeE
HOME
<?php include('header.php'); include('admin/sel_query.php'); $sql = "SELECT * FROM LAN_INVENTORI LEFT JOIN LAN_PEMAJUKOD ON INV_KODPEMAJU=PEM_KODPEMAJU LEFT JOIN LAN_STATUSFLG ON INV_STATUSFLG=STA_STATUSFLG LEFT JOIN LAN_SYSTMAKAR ON INV_CODEROOTS=SYS_CODEROOTS LEFT JOIN LAN_RISIKOOVAL ON INV_RISIKOTRE=RIS_RISKOCODE WHERE INV_ENTRYDATE='" . date('Y-m-d') . "' ORDER BY INV_INVENTORI"; $result = mysqli_query($mysqli, $sql); if ($_GET['cmd'] == '1') { $sql2 = "SELECT * FROM LAN_INVENTORI LEFT JOIN LAN_PEMAJUKOD ON INV_KODPEMAJU=PEM_KODPEMAJU LEFT JOIN LAN_STATUSFLG ON INV_STATUSFLG=STA_STATUSFLG LEFT JOIN LAN_SYSTMAKAR ON INV_CODEROOTS=SYS_CODEROOTS LEFT JOIN LAN_RISIKOOVAL ON INV_RISIKOTRE=RIS_RISKOCODE LEFT JOIN LAN_POKOKCODE ON INV_POKOKCODE=POK_POKOKCODE WHERE INV_INVENTORI='" . $_GET['id'] . "'"; $result2 = mysqli_query($mysqli, $sql2); $row2 = $result2->fetch_array(MYSQLI_ASSOC); } ?> <script> function initMap() { const uluru = { lat: <?php echo $row2['INV_KOORDINAX'] ?>, lng: <?php echo $row2['INV_KOORDINAY'] ?> }; const map = new google.maps.Map(document.getElementById("map"), { zoom: 14, center: uluru, }); const contentString = '<div id="content">' + '<div id="siteNotice">' + "</div>" + '<div id="bodyContent">' + "<p><b>No. Inventori: </b><?php echo $row2['INV_INVENTORI']; ?></br> " + "<b>Nama Tempatan: </b><?php echo $row2['POK_TEMPATANS']; ?></br> " + "<b>Nama Saintifik: </b><?php echo $row2['POK_SAINTIFIK']; ?></br> " + "</div>" + "</div>"; const infowindow = new google.maps.InfoWindow({ content: contentString, ariaLabel: "Uluru", }); const marker = new google.maps.Marker({ position: uluru, map, title: "Lokasi", }); marker.addListener("click", () => { infowindow.open({ anchor: marker, map, }); }); } window.initMap = initMap; </script> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Main content --> <div class="content"> <div class="container"> <div class="row"> <div class="col-lg-12"> <div class="p-3 text-right"> <a href="#" class="btn btn-warning btn-sm" onclick="history.back();"><i class="fa fa-arrow-left"></i> Kembali</a> </div> </div> </div> <div class="row"> <div class="col-lg-12"> <div class="card card-orange card-outline card-tabs"> <div class="card-header p-0 pt-1 border-bottom-0"> <ul class="nav nav-tabs" id="custom-tabs-three-tab" role="tablist"> <li class="nav-item"> <a class="nav-link active" id="custom-tabs-three-home-tab" data-toggle="pill" href="#custom-tabs-three-home" role="tab" aria-controls="custom-tabs-three-home" aria-selected="true">Maklumat Pokok</a> </li> <li class="nav-item"> <a class="nav-link" id="custom-tabs-three-profile-tab" data-toggle="pill" href="#custom-tabs-three-profile" role="tab" aria-controls="custom-tabs-three-profile" aria-selected="false">Peta</a> </li> <li class="nav-item"> <a class="nav-link" id="custom-tabs-three-messages-tab" data-toggle="pill" href="#custom-tabs-three-messages" role="tab" aria-controls="custom-tabs-three-messages" aria-selected="false">Gambar</a> </li> </ul> </div> <div class="card-body"> <div class="tab-content" id="custom-tabs-three-tabContent"> <div class="tab-pane fade show active" id="custom-tabs-three-home" role="tabpanel" aria-labelledby="custom-tabs-three-home-tab"> <div class="row"> <div class="col-lg-2 text-right"> <label>Kod Lokasi</label> </div> <div class="col-lg-4"> <select class="form-control form-control-sm" name="lokasland" disabled><?php echo $row2['INV_LOKASLAND']; ?> <option value="">Tiada</option> <?php while ($row = mysqli_fetch_array($res_sel1, MYSQLI_ASSOC)) { if ($row['LOK_LOKASLAND'] == $row2['INV_LOKASLAND']) { echo "<option value='" . $row['LOK_LOKASLAND'] . "' selected>" . $row['LOK_LOKASNAME'] . "</option>"; } else { echo "<option value='" . $row['LOK_LOKASLAND'] . "'>" . $row['LOK_LOKASNAME'] . "</option>"; } } ?> </select> </div> <div class="col-lg-2 text-right"> <label>Kod Pokok</label> </div> <div class="col-lg-4"> <select class="form-control form-control-sm" name="pokokcode" disabled> <option value="">Tiada</option> <?php while ($row = mysqli_fetch_array($res_sel3, MYSQLI_ASSOC)) { if ($row['POK_POKOKCODE'] == $row2['INV_POKOKCODE']) { echo "<option value='" . $row['POK_POKOKCODE'] . "' selected>" . $row['POK_TEMPATANS'] . " - " . $row['POK_POKOKCODE'] . "</option>"; } else { echo "<option value='" . $row['POK_POKOKCODE'] . "'>" . $row['POK_TEMPATANS'] . " - " . $row['POK_POKOKCODE'] . "</option>"; } } ?> </select> </div> </div> <div class="row"> <!--<div class="col-lg-2 text-right"> <label>Ukur Lilit (m)</label> </div> <div class="col-lg-4"> <input type="number" step="0.01" name="ukurlilit" value="<?php echo $row2['INV_UKURLILIT']; ?>" class="form-control form-control-sm" maxlength="5" disabled> </div>--> <div class="col-lg-2 text-right"> <label>Diameter (cm)</label> </div> <div class="col-lg-4"> <input type="number" step="0.01" name="garispust" value="<?php echo $row2['INV_GARISPUST']; ?>" class="form-control form-control-sm" maxlength="5" disabled> </div> <div class="col-lg-2 text-right"> <label>Lebar Silara (m)</label> </div> <div class="col-lg-4"> <input type="number" step="0.01" name="lebartree" value="<?php echo $row2['INV_LEBARTREE']; ?>" class="form-control form-control-sm" maxlength="5" disabled> </div> </div> <div class="row"> <div class="col-lg-2 text-right"> <label>Umur Pokok</label> </div> <div class="col-lg-4"> <input type="number" name="agegtrees" value="<?php echo $row2['INV_AGEGTREES']; ?>" class="form-control form-control-sm" maxlength="5" disabled> </div> <div class="col-lg-2 text-right"> <label>Tinggi Pokok (m)</label> </div> <div class="col-lg-4"> <input type="number" step="0.01" name="hightrees" value="<?php echo $row2['INV_HIGHTREES']; ?>" class="form-control form-control-sm" maxlength="5" disabled> </div> </div> <div class="row"> <!--<div class="col-lg-2 text-right"> <label>Kod Akar</label> </div> <div class="col-lg-4"> <select class="form-control form-control-sm" name="coderoots" <?php if ($_GET['cmd'] == '1') { echo "disabled"; } ?>> <option value="">Tiada</option> <?php while ($row = mysqli_fetch_array($res_sel4, MYSQLI_ASSOC)) { if ($row['SYS_CODEROOTS'] == $row2['INV_CODEROOTS']) { echo "<option value='" . $row['SYS_CODEROOTS'] . "' selected>" . $row['SYS_CODEROOTS'] . "-" . $row['SYS_NAMAROOTS'] . "</option>"; } else { echo "<option value='" . $row['SYS_CODEROOTS'] . "'>" . $row['SYS_CODEROOTS'] . "-" . $row['SYS_NAMAROOTS'] . "</option>"; } } ?> </select> </div>--> </div> <div class="row"> <!--<div class="col-lg-2 text-right"> <label>Penanam</label> </div> <div class="col-lg-4"> <select class="form-control form-control-sm" name="kodpemaju" disabled> <option value="">Tiada</option> <?php while ($row = mysqli_fetch_array($res_sel2, MYSQLI_ASSOC)) { if ($row['PEM_KODPEMAJU'] == $row2['INV_KODPEMAJU']) { echo "<option value='" . $row['PEM_KODPEMAJU'] . "' selected>" . $row['PEM_NAMPEMAJU'] . "</option>"; } else { echo "<option value='" . $row['PEM_KODPEMAJU'] . "'>" . $row['PEM_NAMPEMAJU'] . "</option>"; } } ?> </select> </div>--> <div class="col-lg-2 text-right"> <label>Nilai Pokok (RM)</label> </div> <div class="col-lg-4"> <input type="number" step="0.01" name="valuetree" value="<?php echo number_format((float)$row2['INV_VALUETREE'], 2, '.', ''); ?>" class="form-control form-control-sm" maxlength="5" disabled> </div> <div class="col-lg-2 text-right"> <label>Tarikh Pemeriksaan</label> </div> <div class="col-lg-4"> <input type="text" step="0.01" name="valuetree" value="<?php echo $row2['INV_INSPEDATE']; ?>" class="form-control form-control-sm" maxlength="5" disabled> </div> </div> <div class="row"> <!--<div class="col-lg-2 text-right"> <label>Status Pokok</label> </div> <div class="col-lg-4"> <select class="form-control form-control-sm" name="statusflg" disabled> <option value="">Tiada</option> <?php while ($row = mysqli_fetch_array($res_sel5, MYSQLI_ASSOC)) { if ($row['STA_STATUSFLG'] == $row2['INV_STATUSFLG']) { echo "<option value='" . $row['STA_STATUSFLG'] . "' selected>" . $row['STA_STATUNAME'] . "</option>"; } else { echo "<option value='" . $row['STA_STATUSFLG'] . "'>" . $row['STA_STATUNAME'] . "</option>"; } } ?> </select> </div> <div class="col-lg-2 text-right"> <label>Penilaian Risiko Bahaya</label> </div> <div class="col-lg-4"> <select class="form-control form-control-sm" name="risikotre" disabled> <option value="">Tiada</option> <?php while ($row = mysqli_fetch_array($res_sel6, MYSQLI_ASSOC)) { if ($row['RIS_RISKOCODE'] == $row2['INV_RISIKOTRE']) { echo "<option value='" . $row['RIS_RISKOCODE'] . "' selected>" . $row['RIS_RISKKETER'] . "</option>"; } else { echo "<option value='" . $row['RIS_RISKOCODE'] . "'>" . $row['RIS_RISKKETER'] . "</option>"; } } ?> </select> </div>--> </div> <hr /> <div class="row"> <div class="col-lg-2 text-right"> <label>Koordinat Pokok (X)</label> </div> <div class="col-lg-4"> <input type="text" name="koordinax" id="koordinax" value="<?php if ($lat_int != "") { echo $lat_int; } else { echo $row2['INV_KOORDINAX']; } ?>" class="form-control form-control-sm" maxlength="10" disabled> </div> <div class="col-lg-2 text-right"> <label>Koordinat Pokok (Y)</label> </div> <div class="col-lg-4"> <input type="text" name="koordinay" id="koordinay" value="<?php if ($lon_int != "") { echo $lon_int; } else { echo $row2['INV_KOORDINAY']; } ?>" class="form-control form-control-sm" maxlength="10" disabled> </div> </div> </div> <div class="tab-pane fade" id="custom-tabs-three-profile" role="tabpanel" aria-labelledby="custom-tabs-three-profile-tab"> <a href="https://maps.google.com?q=<?php echo $row2['INV_KOORDINAX'] ?>,<?php echo $row2['INV_KOORDINAY'] ?>" target="_blank" class="btn btn-primary">Buka Google Maps</a> Klik sini untuk bergerak ke lokasi pokok teduhan. <div id="map" style="margin: 20px auto; border: #666 solid 2px; width: 80%; height: 400px;"></div> <script async src="https://maps.googleapis.com/maps/api/js?key=<?php echo $map_key;?>&callback=initMap"></script> </div> <div class="tab-pane fade" id="custom-tabs-three-messages" role="tabpanel" aria-labelledby="custom-tabs-three-messages-tab"> <?php if ($row2['INV_ATTACHMEN'] == '') { echo "Tiada Gambar"; } else { ?> <img src="img_tree/<?php echo $row2['INV_ATTACHMEN'] ?>" style="margin: 20px auto; border: #666 solid 2px; width: 80%;"> <?php } ?> </div> </div> </div> <!-- /.card --> </div> </div> </div> <!-- /.row --> </div><!-- /.container-fluid --> </div> <!-- /.content --> </div> <!-- /.content-wrapper --> <?php include('footer.php'); ?>