bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

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

<div class="content-wrapper">
  
  <div class="content-header">
    <div class="container">
      <div class="row mb-2">
        <div class="col-sm-8">
          <h4 class="m-0"> Selamat Datang ke <?php echo $main_name . " (" . $main_name_short . ")"; ?></h4>
        </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">Pengenalan</h5>
            </div>
            <div class="card-body">
              
              <div class="row">
                <div class="col-md-1">
                  <img src="img/logoEpt.jpeg" alt="Logo" width="80px">
                </div>
                <div class="col-md-11">
                  <p><?php echo "<b>" . $main_name . " (" . $main_name_short . ")</b> " . $ayat; ?></p>
                </div>
              </div>
              
            </div>
          </div>
        </div>
        
      </div>
      <h5 class="mt-4 mb-2">Data Inventori Pokok</h5>
      <div class="row">
        <div class="col-md-3 col-sm-6 col-12">
          <div class="info-box bg-info">
            <span class="info-box-icon"><i class="fa fa-leaf"></i></span>
            <?php
            $sql1 = "select count(*) as TOTAL from LAN_INVENTORI where INV_POKOKCODE is not null";
            $query_inventori = mysqli_query($mysqli, $sql1);
            $row1 = $query_inventori->fetch_array(MYSQLI_ASSOC);
            ?>
            <div class="info-box-content">
              <span class="info-box-text">Jumlah Pokok</span>
              <span class="info-box-number">
                <h5><strong><?php echo $row1['TOTAL']; ?></strong></h5>
              </span>
            </div>
            
          </div>
          
        </div>
        
        <div class="col-md-3 col-sm-6 col-12">
          <div class="info-box bg-success">
            <span class="info-box-icon"><i class="fa fa-money"></i></span>
            <?php
            $sql2 = "SELECT sum(INV_VALUETREE) AS TOTAL FROM LAN_INVENTORI WHERE INV_VALUETREE IS NOT NULL";
            $query_inventori = mysqli_query($mysqli, $sql2);
            $row2 = $query_inventori->fetch_array(MYSQLI_ASSOC);
            ?>
            <div class="info-box-content">
              <span class="info-box-text">Nilai Pokok (RM)</span>
              <span class="info-box-number">
                <h5><strong><?php echo "RM " . number_format($row2['TOTAL'], 2, '.', ','); ?></strong></h5>
              </span>
            </div>
            
          </div>
          
        </div>
        
        <div class="col-md-3 col-sm-6 col-12">
          <div class="info-box bg-warning">
            <span class="info-box-icon"><i class="fa fa-road"></i></span>
            <?php
            $sql3 = "SELECT count(*) AS TOTAL, INV_LOKASLAND FROM LAN_INVENTORI WHERE INV_LOKASLAND IS NOT NULL GROUP BY INV_LOKASLAND";
            $query_inventori = mysqli_query($mysqli, $sql3);
            //$row4 = $query_inventori->fetch_array(MYSQLI_ASSOC);
            $row3 = $query_inventori->num_rows;
            ?>
            <div class="info-box-content">
              <span class="info-box-text">Jumlah Lokasi</span>
              <span class="info-box-number">
                <h5><strong><?php echo $row3; ?></strong></h5>
              </span>
            </div>
            
          </div>
          
        </div>
        
        <div class="col-md-3 col-sm-6 col-12">
          <div class="info-box bg-danger">
            <span class="info-box-icon"><i class="fa fa-tree"></i></span>
            <?php
            $sql4 = "SELECT count(*) AS TOTAL, INV_POKOKCODE FROM LAN_INVENTORI WHERE INV_POKOKCODE IS NOT NULL GROUP BY INV_POKOKCODE";
            $query_inventori = mysqli_query($mysqli, $sql4);
            //$row4 = $query_inventori->fetch_array(MYSQLI_ASSOC);
            $row4 = $query_inventori->num_rows;
            ?>
            <div class="info-box-content">
              <span class="info-box-text">Spesis Pokok Ditanam</span>
              <span class="info-box-number">
                <h5><strong><?php echo $row4; ?></strong></h5>
              </span>
            </div>
            
          </div>
          
        </div>
        
      </div>
      
      <!--<div class="row">
        <div class="col-md-6">
          <div class="card card-danger">
            <div class="card-header">
              <h3 class="card-title">Pie Chart</h3>

</div>
        </div>
      </div>-->
    </div>
  </div>

</div>

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