<?php
include '../../config/conn.php';
?>
<div class="col" role="main">
    <div class="">
        <div class="clearfix"></div>

        <div class="row">
            <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="x_panel">
                    <div class="x_title" style="text-transform: capitalize;">
                        <h2>Data Transaksi Anonim<small></small></h2>

                        <div class="clearfix"></div>
                    </div>
                    <div class="divider-dashed"></div>
                    <div class="x_content">

                        <table id="datatable" class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>No</th>
                                    <th>Tanggal</th>
                                    <th>Jam</th>
                                    <th>ID transaksi</th>
                                    <th>Debit</th>
                                    <th>Kredit</th>
                                    <th>Keterangan</th>
                                    <th>Jenis</th>
                                    <th>ID santri</th>
                                    <th>ID Donatur</th>
                                    <th>Donatur tdk ttp</th>
                                    <th>Jenis Donatur</th>
                                    <th>SPP bulan</th>
                                    <th>SPP Thn</th>
                                    <th>dut thn</th>
                                    <th>ID user</th>
                                    <th>ID jenis RT</th>
                                    <th>Jenis KAS</th>
                                    <th>Log Edit</th>

                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $no = 0;
                                $anon = mysqli_query($conn, "SELECT * FROM transaksi WHERE id_transaksi='' OR 
                                debit=0 AND kredit=0 OR id_jenis='' OR id_pegawai='' OR jenis_kas=''");
                                while ($row = mysqli_fetch_array($anon)) {
                                    $no++;
                                ?>
                                    <tr>
                                        <td><?php echo $no; ?></td>
                                        <td><?php echo $row['tanggal']; ?></td>
                                        <td><?php echo $row['jam']; ?></td>
                                        <td><?php echo $row['id_transaksi']; ?></td>
                                        <td><?php echo $row['debit']; ?></td>
                                        <td><?php echo $row['kredit']; ?></td>
                                        <td><?php echo $row['keterangan']; ?></td>
                                        <td><?php echo $row['id_jenis']; ?></td>
                                        <td><?php echo $row['id_santri']; ?></td>
                                        <td><?php echo $row['id_donatur']; ?></td>
                                        <td><?php echo $row['nama_donatur_tidak_tetap']; ?></td>
                                        <td><?php echo $row['jenis_donatur']; ?></td>
                                        <td><?php echo $row['spp_bulan']; ?></td>
                                        <td><?php echo $row['spp_tahun']; ?></td>
                                        <td><?php echo $row['dut_tahun']; ?></td>
                                        <td><?php echo $row['id_pegawai']; ?></td>
                                        <td><?php echo $row['id_jenis_rt']; ?></td>
                                        <td><?php echo $row['jenis_kas']; ?></td>
                                        <td><?php echo $row['log_edit']; ?></td>
                                    </tr>

                                <?php } ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>

        </div>
    </div>
</div>
</div>
</div>
</div><br>