public function getTotalDebtsForUser($user)
{
$debts = array();
$this->dbQuery("SELECT * FROM debt WHERE idUser1='" . $user->getID() . "' AND payed='0' ORDER BY idUser2");
while ($r = $this->getResult()) {
$i = $this->debtExists($debts, $r['idUser1'], $r['idUser2']);
if ($i > -1) {
$debt = $debts[$i];
$amount = $debt->getAmount();
$amount += $r['amount'];
$debt->setAmount($amount);
} else {
$userStore = new UserStore($this->db);
$user1 = $userStore->getUserFromID($r['idUser1']);
$user2 = $userStore->getUserFromID($r['idUser2']);
$debt = new Debt($r['idDebt'], $user1, $user2, $r['amount']);
$debt->setDescription("Total to pay");
array_push($debts, $debt);
}
}
return $debts;
}
