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; }
public function getTasks() { $tasks = array(); $this->dbQuery("SELECT * FROM task"); while ($r = $this->getResult()) { $task = new Task($r['name'], $r['week']); if ($r['IdUser'] != 0) { $userStore = new UserStore($this->db); $user = $userStore->getUserFromID($r['IdUser']); $task->setUser($user); } array_push($tasks, $task); } return $tasks; }