$expense->delete(); } for ($ii = 0; $ii < $numExpenseEntries; $ii++) { if ($ii <= $numExpenseUpdates - 1) { // update existing expense entry if it has changed $expense = $expenses[$ii]; if ($expenseEntries[$ii]["desc"] !== $expense->description || intval($expenseEntries[$ii]["typeID"]) !== intval($expense->typeID) || floatval($expenseEntries[$ii]["amount"]) !== floatval($expense->amount)) { $expense->description = $expenseEntries[$ii]["desc"]; $expense->amount = Expense::formatAmount($expenseEntries[$ii]["amount"]); $expense->typeID = $expenseEntries[$ii]["typeID"]; $expense->save(array("amount", "description", "typeID")); } } else { // insert new expense entry $expense = new Expense(); $expense->userID = $user->id; $expense->amount = Expense::formatAmount($expenseEntries[$ii]["amount"]); $expense->date = $mySqlFormatedDate; $expense->description = $expenseEntries[$ii]["desc"]; $expense->typeID = $expenseEntries[$ii]["typeID"]; $expense->save(); } } // redirect back to the same day after processing the form header("Location: " . BASE_URL . "main/?month={$selectedMonth}&day={$selectedDay}&year={$selectedYear}"); exit; } // Update $incomes and $expenses so that they contain the modified entries $incomes = Income::findBySql('SELECT * FROM incomes WHERE userID = "' . $user->id . '" AND date = "' . $mySqlFormatedDate . '" ORDER BY id'); $expenses = Expense::findBySql('SELECT * FROM expenses WHERE userID = "' . $user->id . '" AND date = "' . $mySqlFormatedDate . '"ORDER BY id');
<?php $user = User::findById($session->userID); $incomeTypes = IncomeType::findBySql('SELECT * FROM incometypes WHERE userID = "' . $user->id . '" ORDER BY id'); $expenseTypes = ExpenseType::findBySql('SELECT * FROM expensetypes WHERE userID = "' . $user->id . '" ORDER BY id'); // Fetch income and expense data based on the current view if ($view === "daily") { $incomes = Income::findBySql('SELECT * FROM incomes WHERE userID = "' . $user->id . '" AND date = "' . $mySqlFormatedDate . '" ORDER BY id'); $expenses = Expense::findBySql('SELECT * FROM expenses WHERE userID = "' . $user->id . '" AND date = "' . $mySqlFormatedDate . '" ORDER BY id'); } else { if ($view === "monthly" || $view === "yearly") { $incomes = Income::findBySql('SELECT * FROM incomes WHERE userID = "' . $user->id . '" AND date BETWEEN "' . $mySqlFormatedDateStart . '" AND "' . $mySqlFormatedDateEnd . '"'); $expenses = Expense::findBySql('SELECT * FROM expenses WHERE userID = "' . $user->id . '" AND date BETWEEN "' . $mySqlFormatedDateStart . '" AND "' . $mySqlFormatedDateEnd . '"'); } else { if ($view === "allTime") { $incomes = Income::findBySql('SELECT * FROM incomes WHERE userID = "' . $user->id . '" ORDER BY date'); $expenses = Expense::findBySql('SELECT * FROM expenses WHERE userID = "' . $user->id . '" ORDER BY date'); } } }