<?php
session_start();
require_once "config.php";
$currentUser = $_SESSION['username'];
$dates;
$balance;
$sql = "SELECT balance FROM students WHERE username = '$currentUser'";
if ($result = $link -> query($sql)) {
  $balance = $result -> fetch_row()[0];
  $result -> free_result();
}
$sql = "SELECT date FROM transactions WHERE receiver = '$currentUser'";
if ($result = $link -> query($sql)) {
  $dates = $result -> fetch_row();
  $result -> free_result();
}
$dates = array_reverse($dates);
$size = count($dates);
for ($i = 0; $i < $size; $i++) {
	$dates[$i] .= ":";
}
if (count($dates) < 9) {
    $difference = 9 - count($dates);
    $i = 0;
    while ($i <= $difference) {
        array_push($dates, " ");
        $i++;
    }
}
$senders;
$sql = "SELECT sender FROM transactions WHERE receiver = '$currentUser'";
if ($result = $link -> query($sql)) {
  $senders = $result -> fetch_row();
  $result -> free_result();
}
$senders = array_reverse($senders);
if (count($senders) < 9) {
    $difference = 9 - count($senders);
    $i = 0;
    while ($i <= $difference) {
        array_push($senders, " ");
        $i++;
    }
}
$numbers;
$colors = array();
$sql = "SELECT number FROM transactions WHERE receiver = '$currentUser'";
if ($result = $link -> query($sql)) {
  $numbers = $result -> fetch_row();
  $result -> free_result();
}
$numbers = array_reverse($numbers);
$i = 0;
while ($i <= count($numbers)-1) {
    if (str_contains($numbers[$i], '-')) {
        array_push($colors, "red");
    } else if (str_contains($numbers[$i], '+')) {
        array_push($colors, "green");
    }
    $i++;
}
if (count($numbers) < 9) {
    $difference = 9 - count($numbers);
    $i = 0;
    while ($i <= $difference) {
        array_push($numbers, " ");
        $i++;
    }
}
?>