$expense = array_pop($expenses);
$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');
}
}
}
