<form action="orders_act.php" method="POST">
    <div class="table-responsive">
      <table class="table table-striped b-t b-light">
        <thead>
          <tr>
            <th>No</th>
            <th>Tanggal Order</th>
            <th>Kode Order</th>
            <th>Reseller</th>
            <th>Alamat Kirim</th>
            <th>QTY</th>
            <th>Total Harga</th>
            <th>Pengiriman</th>
            <th></th>
            <th style="width:30px;"></th>
          </tr>
        </thead>

        <tbody>

    <?php
  if(isset($_GET['cari'])){
    $cari= mysqli_real_escape_string($db, $_GET['cari']);
    $sw = $db->query("SELECT* from det_payment where kd_orders like '$cari' or kd_member like '$cari'");
  }
  elseif(isset($_GET['status'])){
    $status= mysqli_real_escape_string($db, $_GET['status']);
    $sw = $db->query("SELECT* from det_payment where status_pay='$status'");
  }
  else{
  $sw = $db->query("SELECT * from det_payment ORDER BY tgl DESC");
  } 
  $no=1;
  while ($b = $sw->fetch_array()) {
 
    ?>

          <tr>
            <input name="kd_orders" id="kd_orders" type="text" hidden="" value="<?php echo $b['kd_orders']?>">
            <td><?php echo $no++ ?>.</td>
            <td><?php echo $b['tgl'] ?></td>
            <td ><a href="../reseller/inv.php?orders=<?php echo $b['kd_orders']?>" target="_blank"><font color="bolt">#<?php echo $b['kd_orders']?></font></a></br>
                (<?php echo $b['status_pay']?> )
            </td>
            <td><?php echo $b['nm_reseller'] ?></br>
                Username : <?php echo $b['email_tagihan'] ?></br>
                ID : <?php echo $b['kd_member'] ?>
            </td>
            <td><?php echo $b['alamat_kirim'] ?></br>
                <?php echo $b['kota_kirim'] ?>
            </td>
            <td><?php echo $b['qty'] ?></td> 
            <td>Rp <?php echo number_format($b['total_pay']) ?></td>
            <td><?php echo strtoupper($b['jenis_kurir']) ?></br>
                <?php echo $b['type_kurir'] ?></br>
                Rp <?php echo number_format($b['harga_kurir']) ?>
            </td>

            <td>
              <input type="submit" name="lunas" class="btn btn-info" value="Lunas">
            </td>
          </tr>
<?php
}
?>


        </tbody>
       
      </table>
    </div>
  </form>

<?php
include 'config.php';

$kd_orders=$_POST['kd_orders'];

if (isset($_POST['lunas'])){

mysqli_query($db,"update det_payment set status_pay='Lunas' where kd_orders='$kd_orders'");
header("location: orders.php");
}


header("location: orders.php");

?>