bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

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

$sql = "SELECT
	INV_NOMBORIDS,
	INV_KONTRAKOD,
	INV_LOKASLAND,
	INV_INVENTORI,
	INV_POKOKCODE,
	POK_SAINTIFIK,
	PEM_NAMPEMAJU,
	INV_GARISPUST,
	INV_UKURLILIT,
	INV_HIGHTREES,
	INV_AGEGTREES,
	INV_LEBARTREE,
	INV_CODEROOTS,
	INV_KOORDINAX,
	INV_KOORDINAY,
	INV_RISIKOTRE,
	INV_PEMERIKSA,
	INV_INSPEDATE,
	STA_STATUNAME,
	INV_SAHOPERSS,
    INV_VALUETREE,
	INV_ATTACHMEN,
    POK_TEMPATANS,
    LOK_LOKASNAME,
    INV_KONTRAKOD
FROM
	LAN_INVENTORI
LEFT JOIN LAN_PEMAJUKOD ON INV_KODPEMAJU=PEM_KODPEMAJU 
LEFT JOIN LAN_POKOKCODE ON POK_POKOKCODE=INV_POKOKCODE 
LEFT JOIN LAN_STATUSFLG ON INV_STATUSFLG=STA_STATUSFLG
LEFT JOIN LAN_LOKASCODE ON LOK_LOKASLAND=INV_LOKASLAND
ORDER BY
	INV_INVENTORI";
$result = mysqli_query($mysqli, $sql);

?>
<div class="content-wrapper">
    
    <section class="content-header">
        <div class="container-fluid">
        </div>
    </section>

<section class="content">
        <div class="container-fluid">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-header">
                            <h3 class="card-title">Senarai</h3>
                        </div>
                        
                        <div class="card-body">
                            <table id="example1" class="table table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th>Bil.</th>
                                        <th>#Inventori Pokok</th>
                                        <th>Nama Pokok</th>
                                        
                                        <th>Lokasi Pokok</th>
                                        <th>Diameter (cm)</th>
                                        
                                        <th>Tinggi Pokok(m)</th>
                                        <th>Umur Pokok</th>
                                        <th>Lebar Silara(m)</th>
                                        
                                        <th>Koordinat Pokok (X)</th>
                                        <th>Koordinat Pokok (Y)</th>
                                        
                                        
                                        <th>Nilai Pokok (RM)</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                    $counter = 1;
                                    
                                    while ($row = mysqli_fetch_array($result)) {
                                        $row['0'] = "<a href='view_datapokok?cmd=1&id=" . $row['INV_INVENTORI'] . "'>" . $row['INV_INVENTORI'] . "</a>";
                                        //$row[16] = '<a href="view_datapokok?cmd=1&id='.$row['INV_NOMBORIDS'].'">'.'<img src="img/form-icon.png" width=15 height=15></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'.'<a href="mapvisitor?CusID='.$row['INV_INVENTORI'].'">'.'<img src="img/Globe-icon.png" width=15 height=16></a>';
                                        echo "<tr>";
                                        echo "<td>" . $counter++ . "</td>";
                                        echo "<td>" . $row['0'] ."<br>".$row['INV_KONTRAKOD']. "</td>";
                                        echo "<td>" . $row['POK_TEMPATANS'] . "</td>";
                                        echo "<td>" . $row['LOK_LOKASNAME'] . "</td>";
                                        echo "<td>" . $row['INV_GARISPUST'] . "</td>";
                                        //echo "<td>".$row['INV_UKURLILIT']."</td>";
                                        echo "<td>" . $row['INV_HIGHTREES'] . "</td>";
                                        echo "<td>" . $row['INV_AGEGTREES'] . "</td>";
                                        echo "<td>" . $row['INV_LEBARTREE'] . "</td>";
                                        //echo "<td>".$row['INV_CODEROOTS']."</td>";
                                        echo "<td>" . $row['INV_KOORDINAX'] . "</td>";
                                        echo "<td>" . $row['INV_KOORDINAY'] . "</td>";
                                        //echo "<td>".$row['INV_RISIKOTRE']."</td>";
                                        echo "<td>" . number_format((float)$row['INV_VALUETREE'], 2, '.', ',') . "</td>";
                                        //echo "<td>" . $row['INV_INSPEDATE'] . "</td>";
                                        //echo "<td>" . $row['STA_STATUNAME'] . "</td>";
                                        //echo "<td>".$row['16']."</td>";
                                        echo "</tr>";
                                    }
                                    ?>
                                </tbody>
                            </table>
                        </div>
                        
                    </div>
                    
                </div>
                
            </div>
            
        </div>
        
    </section>
    
</div>
<?php include('footer.php'); ?>