            <!-- Exportable Table -->
             <div class="container-fluid">
            <div class="block-header">
                <h2>
                     <ol class="breadcrumb breadcrumb-bg-teal">
                           <li><a href="index.php?home"><i class="material-icons">home</i> Home</a></li>
                           <li class="active"><i class="material-icons">vertical_align_bottom</i> TopUp</li>
                           
                     </ol>
                     
                </h2>
                
            </div>
            <?php 	$qry_=mysqli_query($koneksi,"SELECT * FROM `tb_rekening_koperasi`  order by id desc limit 1"); 
            $row_=mysqli_fetch_array($qry_);
            ?>
           <div style="font-size:26px">
<a href="?rekening">
<span class="badge badge-pill badge-warning" style="font-size:24px">SALDO : Rp. <?php echo number_format($row_['saldo'],2,',','.')?></span>
</a>
</div>
            <!-- Exportable Table -->
            <div class="row clearfix">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    <div class="card">
                        <div class="header">
                            <h2>
                                DATA TopUp
                            </h2>
                            <ul class="header-dropdown m-r--5">
                              
                                    <a href="index.php?setoran&mn=setoran_add" >
										<button type="button" class="btn bg-green btn-circle-lg waves-effect waves-circle waves-float"  data-toggle="tooltip"
                                            data-placement="left" title="Input Data Member">
                                    		<i class="material-icons">add_circle_outline</i> 
                               			</button>
                                    </a>
                                   
								    <a href="index.php?setoran&mn=setoran_upload" >
									<button type="button" class="btn bg-green btn-circle-lg waves-effect waves-circle waves-float" data-toggle="tooltip"
                                            data-placement="left" title="Upload Data Member Template Ms.Excel">
                                    	<i class="material-icons">file_upload</i> 
                                	</button>
                                    </a>
                                
                            </ul>
                        </div>
                        <div class="body">
						
						 <form method="post" action="#">
							<div class="row clearfix">
                            <div class="col-sm-4">
							    <div class="form-group form-float">
                                    <div class="form-line">
                                        <input type="date" class="form-control" name="tgl1" >
                                       
                                    </div>
                                    <div class="help-info">Tanggal Mulai</div>
                                </div>
							  
							</div>
                              
                            <div class="col-sm-4">
						        <div class="form-group form-float">
                                    <div class="form-line">
                                        <input type="date" class="form-control" name="tgl2" >
                                      
                                    </div>
                                    <div class="help-info">Tanggal Akhir</div>
                                </div>
						    </div>
						    <div class="col-sm-4" align="left">
                                <button class="btn btn-primary waves-effect" name="filter" type="submit">Filter</button>
                            </div>
							</div>
							</form>
						
                            <div class="table-responsive">
                                <table class="table table-bordered table-striped table-hover dataTable js-exportable">
                                    <thead>
                                        <tr>
                                          <th>IDMember</th>
                                            <th>Nama</th>
											<th>Kategori</th>
                                            <th>Nominal</th>
                                            <th>Saldo</th>
											<th>Petugas / Tanggal</th>
											  <th></th>
                                        </tr>
                                    </thead>
                                    <tfoot>
                                        <tr>
                                           <th>IDMember</th>
                                            <th>Nama</th>
											<th>Kategori</th>
                                            <th>Nominal</th>
                                            <th>Saldo</th>
											<th>Petugas / Tanggal</th>
											  <th></th>
                                        </tr>
                                    </tfoot>
                                    <tbody>
									<?php 
									
									if(isset($_POST['filter']))
                                    {
		                                $tgl1=noninjection($koneksi,$_POST['tgl1']);
		                                $tgl2=noninjection($koneksi,$_POST['tgl2']);
										$query_cari="SELECT * FROM `tb_rekening` where (in_out='in')  and (tgl BETWEEN '".$tgl1."  00:00:00' AND '".$tgl2." 23:59:59') order by id desc ";
                                    } else {
		    							$query_cari="SELECT * FROM `tb_rekening` where (in_out='in') order by id desc";
                                    }
									$qry_cari=mysqli_query($koneksi,$query_cari);
										$tmp=0; $x=0;
									while($row=mysqli_fetch_array($qry_cari)){$x=$x+1;
									?>
                                        <tr>
										 <td><a href="index.php?anggota&mn=anggota_view&id=<?php echo $row['idanggota'];?>" title="Klik untuk detail"><?php echo $row['idanggota'];?></a></td>
										  <td ><a href="index.php?anggota&mn=anggota_view&id=<?php echo $row['idanggota'];?>" title="Klik untuk detail"><b><?php 
									$qry_rek=mysqli_query($koneksi,"SELECT * FROM `tb_anggota`  WHERE idanggota='".$row['idanggota']."' limit 1");
									$row_rek=mysqli_fetch_array($qry_rek);
									
									echo $row_rek['nama'];
									?> </b></a></td>
										 <td><?php echo $row_rek['kategori'];?></td>
                                            <td align="right"><?php echo number_format($row['nominal'],0,",",".");$tmp=$tmp+$row['nominal'];?> IDR</td>
                                            <td align="right"><?php echo number_format($row['saldo'],0,",",".");?> IDR</td>
                                           <td>
										   <?php 
									$qry_rek=mysqli_query($koneksi,"SELECT * FROM `tb_user`  WHERE id='".$row['iduser']."' limit 1");
									$row_rek=mysqli_fetch_array($qry_rek);
									
									echo $row_rek['nama'];
									?>
										   <br />
										   <?php echo $row['tgl'];?></td>
											<td>
								<div align="right">
									
									<a href="./content/setoran_print.php?id=<?php echo $row['id'];?>" target="_blank">
								 	<button  type="button" data-toggle="modal" data-target="#defaultModal"  class="btn bg-light-green btn-circle waves-effect waves-circle waves-float" data-placement="left" title="Print Data">
                                    	<i class="material-icons">print</i>
                                	</button>
									</a>
									<a href="index.php?setoran&mn=setoran_view&id=<?php echo $row['id'];?>">
								 	<button  type="button" data-toggle="modal" data-target="#defaultModal"  class="btn bg-light-blue btn-circle waves-effect waves-circle waves-float" data-placement="left" title="View Data">
                                    	<i class="material-icons">search</i>
                                	</button>
									</a>
									
									<a href="index.php?setoran&mn=setoran_del&id=<?php echo $row['id'];?>" onclick="return confirm('Yakin ingin Hapus data ini?');">
								  	<button type="button" class="btn bg-red btn-circle waves-effect waves-circle waves-float" data-toggle="tooltip" data-placement="left" title="Hapus Data">
                                    	<i class="material-icons">delete_sweep</i>
                                	</button>
									</a>
									
								</div>
											</td>
                                        </tr>
                                      <?php }?>
                                    </tbody>
                                </table>
								
							 <?php echo "Total Transaksi : <b>".number_format($x,0,",","."); ?></b> X<br>
								<?php echo "Total Setoran : <b>".number_format($tmp,0,",","."); ?></b> IDR
								
								
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!-- #END# Exportable Table -->
<!-- Small Size -->

            