<?php
defined('BASEPATH') OR exit('No direct script access allowed');
$Site = $this->Site->info();
$User = $this->Users->info();
?>
<?php $this->load->view('admin/Header'); ?>
<!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        Riwayat Saldo
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Admin</a></li>
        <li class="active">Riwayat saldo</li>
      </ol>
    </section>

    <!-- Main content -->
    <section class="content">
     <div class="row">
        <div class="col-md-12">

        <div class="box box-default">
            <div class="box-header with-border">
              <i class="fa fa-list"></i>

              <h3 class="box-title">Data User</h3>
            </div>
            <!-- /.box-header -->
            <div class="box-body">
           <?php
           if(isset($_POST['id'])){
             $id = $this->input->post('id');
             $username = $this->input->post('username');
             $password = $this->input->post('password');
             $balance = $this->input->post('balance');
             $level = $this->input->post('level');
             if(!$id || !$username || !$password){
                echo "<div class='alert alert-danger'>Ada Data Yang kosong</div>";
             } else {
               $d = $this->Users->edit($id,$username,$password,$balance,$level);
               if($d){
                echo "<div class='alert alert-success'>Data Telah Disimpan</div>";
               } else {
                echo "<div class='alert alert-danger'>Gagal Simpan</div>";
               }
             }
           }
           ?>
           <?=$this->session->flashdata('result');?>
            <table class="table table-responsive table-bordered" id="table">
            	<thead>
            	<th>ID</th>
            	<th>Username</th>
            	<th style="width:20%;">Pesan</th>
            	<th style="width:20%;">Tipe</th>
            	<th style="width:20%;">Jumlah</th>
            	<th style="width:10%;">Saldo</th>
            	<th style="width:10%;">Tanggal</th>
            	</thead>
            	<tbody>
            		<?php foreach($this->db->query("SELECT b.*,u.username from balance_history as b inner join user as u on u.id = b.user_id ORDER by b.id DESC")->result() as $result){
                 ?>
            		<tr>
            		<td><?=$result->id;?></td>
            		<td><?=$result->username;?></td>
            		<td><?=$result->message;?></td>
            		 	<td><?=($result->type == '1' ? "<label class='label label-success'>Penambahan</label>" : "<label class='label label-danger'>Pengurangan</label>")?></td>
            		 	<td><?="Rp.".number_format($result->balance);?></td>
            		 	<td><?="Rp.".number_format($result->balance_current);?></td>
            		 	<td><?=$result->date;?></td>
            		</tr>
            		<?php } ?>
            	</tbody>
            </table>
           </div>
           </div>
           </div>

      </div>
    </section>

    <!-- /.content -->
  </div>
  <div class="modal fade" id="editgg" tabindex="-1" role="dialog">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
        <h4 class="modal-title">Ubah User</h4>
      </div>
      <div class="modal-body">
      <form method="post">
      <input type="hidden" name="id" id="id">
      <label>Username</label>
        <input type="text" name="username" id="username" class="form-control" readonly="readonly"><br>
        <label>Password</label>
        <input type="text" name="password" id="password" class="form-control"><br>
        <label>Saldo</label>
        <input type="text" name="balance" id="balance" class="form-control"><br>
        <label>Level</label>
        <select class="form-control" id="level" name="level">
          <option value="1">Member</option>
          <option value="2">Reseller</option>
          <option value="0">Admin</option>
        </select>

       <br>
        <button class="btn btn-success" type="submit">Simpan</button>
        </form>
      </div>

      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
      </div>
    </div><!-- /.modal-content -->
  </div><!-- /.modal-dialog -->
</div><!-- /.modal -->
  <!-- /.content-wrapper -->
    <script type="text/javascript">
  </script>
<?php $this->load->view('admin/Footer'); ?>