<?php
	error_reporting(E_ALL);
	ini_set('display_errors', 1);
	include('include/header.php');
	header('Content-Type: text/html; charset=utf-8');	
	date_default_timezone_set('Asia/Ho_Chi_Minh');
	
	if(isset($_SESSION['username']) && $_SESSION['username']){
		include('include/config_db.php');
		$conn = new mysqli($servername, $username, $password, $dbname);
		mysqli_set_charset($conn, 'UTF8');
		// Check connection
		if ($conn->connect_error) {
			die("Connection failed: " . $conn->connect_error);
		}
		
		$result = $conn->query("SELECT * FROM users WHERE username = '".$_SESSION['username']."'");	
		while($row = $result->fetch_assoc()){
			$user_id = $row['id'];
			// admin =1 (Admin); =3 (user)
			$type_user = $row['admin'];
		}
		if($type_user != 1){
			$result2 = $conn->query("SELECT * FROM tranfer_history WHERE user_id = '$user_id' ORDER BY created_at DESC");
			}else{
			$result2 = $conn->query("SELECT * FROM tranfer_history ORDER BY created_at DESC");
		}
		$i=1;
	?>
	<h1 class="text-center mb-4">TRANSACTION HISTORY</h1>
	<div class="container main">
		<div class="row">
			<div class="table-responsive py-2 px-2">
				<table id="tranfer_history_table" class="table table-bordered table-hover table-striped">
					<thead>
						<tr class="success">
							<th>#Num</th>
							<th>Amount transferred</th>
							<th>Credits</th>
							<th>Status</th>
							<?php 
								if($type_user == 1){
									echo '<th>User</th>';
									echo '<th>Updated</th>';
								}
							?>
							<th>Created</th>					
						</tr>
					</thead>
					<tbody>
						<?php while($row2 = $result2->fetch_assoc()){ ?>
							<tr>
								<td><?=$i ?></td>
								<td><?='$'.number_format($row2['amount_transferred']) ?></td>
								<td><?=number_format($row2['credits']) ?></td>
								<td><?=$row2['status'] ?></td>
								<?php if($type_user == 1){ ?>
									<td>
										<?php
											$result = $conn->query("SELECT username, email FROM users WHERE id = '".$row2['user_id']."'");
											while($row = $result->fetch_assoc()){
												echo $row['username'];
											}
										?>
									</td>
									<td><?=$row2['updated_at'] ?></td>
								<?php } ?>
								<td><?=$row2['created_at'] ?></td>
							</tr>
						<?php $i++; } ?>
					</tbody>
				</table>
				<script>
					$(document).ready(function() {
						$('#tranfer_history_table').DataTable();
					} );
				</script>
			</div>
		</div>
	</div>
	<?php
		}else{
		
		echo "<h2 style='text-align: center;'><a href='/login.php'>Login </a>/ <a href='/signup.php'>Signup </a></h2>";
		
	}
	
	include('include/footer.php');
?>