<?php
session_start();
require_once 'includes/config.php';

if (!isset($_SESSION['user_logged_in']) && $_SESSION['user_logged_in'] != TRUE) {
    header('Location:login.php');
}

if (isset($_POST['search'])) {
	$start_date=$_POST['start_date'];
	$end_date=$_POST['end_date'];
	
	$customers=mysqli_query($con,"SELECT * FROM points_logs WHERE DATE(created_at) >= '".$start_date."' AND DATE(created_at)<= '".$end_date."' ORDER BY id DESC");
	
	
}
//$customers=mysqli_query($con,'SELECT * FROM points_logs    ORDER BY id DESC');


require_once 'includes/header.php';
?>
<style>
.modal{
	z-index: 9999;
	max-height: 55%;
	
}
.modal-content{
	border:none;
}
</style>
<div class="content">
        <div class="container-fluid">
		<div class="container mt-5">
  <!--Grid row-->
  <form action="" method="POST">
  <div class="row">
	
    <!--Grid column-->
    <div class="col-md-4 mb-4">

      <div class="md-form">
        <!--The "from" Date Picker -->
        <input name="start_date" placeholder="Selected starting date datepicker" type="text" id="startingDate" class="form-control datepicker">
       <!-- <label for="startingDate">start</label>-->
      </div>

    </div>
    <!--Grid column-->

    <!--Grid column-->
    <div class="col-md-4 mb-4">

      <div class="md-form">
        <!--The "to" Date Picker -->
        <input name="end_date" placeholder="Selected ending date datepicker" type="text" id="endingDate" class="form-control datepicker">
       <!-- <label for="endingDate">end</label>-->
      </div>

    </div>
    <!--Grid column-->
	 <div class="col-md-2 mb-4">
<button name="search" type="submit" class="btn btn-primary">Go</button>
</div>

  </div>
  <!--Grid row-->
  </form>
</div>
		<?php if($customers){ ?>
		
          <div class="row">
            <div class="col-md-12">
			<!--<a href="add_compliant.php" class="btn btn-primary btn-round">Add New Compliants<div class="ripple-container"></div></a>-->
              <div class="card">
                <div class="card-header card-header-primary">
                  <h4 class="card-title "> 每日积分赚取交易 - Daily Points Earning Transaction </h4>
                  <p class="card-category"> </p>
                </div>
                <div class="card-body">
                  <div class="table-responsive">
                    <table class="table">
                      <thead class=" text-primary">
                        <th>UID</th>  
		  <th>名稱<br>
Name</th> 
		  <th>水平 <br>
Level</th> 
		  <th>可用積分<br>
Available Points</th>
 <th>收入金额<br>
Earning Amount</th> 
		 
		  <th>类型  <br>
Type</th>
		  <th>Date</th>
                      </thead>
                      <tbody>
                        <?php
		if(mysqli_num_rows($customers)>0){	
		$i=1;
		while($customer=mysqli_fetch_array($customers)){
			$level=0;
	$credits=$customer['credits'];
	if($credits<=1000){
		$level=1;
	}elseif($credits<=50000 && $credits>1000){
		$level=2;
	}elseif($credits<=100000 && $credits>50000){
		$level=3;
	}elseif($credits<=1000000 && $credits>100000){
		$level=4;
	}
			?>
		<tr>
		
		<?php $cat=mysqli_fetch_array(mysqli_query($con,"SELECT * FROM users WHERE id=".$customer['user_id'])); ?>
		<td><?php  echo $cat['phone'];?></td>
		<td><?php echo $cat['first_name'];?></td>
		<td>Level <?php echo $level;?></td>
		<td><?php echo $customer['points'];?></td>
		<td>- <?php echo $customer['difference'];?></td>
		
		<td>
		<?php echo $customer['created_at'];?>
		</td>
		</tr>	
		<?php $i++;}
		}
		?>   
                      </tbody>
                    </table>
                  </div>
                </div>
              </div>
            </div>
            
          </div>
		   <?php } ?>
        </div>
      </div>

<?php include_once 'includes/footer.php'; ?>

<script type="text/javascript">
$(document).ready(function(){
    $('.datepicker').datepicker({ format: 'yyyy-mm-dd' });
  });
    $(document).ready(function () {
        $('.delete_btn').click(function () {
            var r = confirm("Are you sure?")
            if (r == true) {
                return true;
            } else {
                return false;
            }
        });
    });
</script> 