}
}
// fetch a single item
if (isset($_GET["item"])) {
$sql = 'SELECT wishlistitems.id as id, wishlistitems.userID as userID, item, price, groupID, groupName';
$sql .= ' FROM wishlistitems INNER JOIN wishlistgroups';
$sql .= ' ON wishlistitems.groupID = wishlistgroups.id';
$sql .= ' WHERE wishlistitems.userID = "' . $user->id . '"';
$sql .= ' AND wishlistitems.id = ? LIMIT 1';
$paramArray = array(trim($_GET["item"]));
$wishlistItems = WishlistItem::findBySql($sql, $paramArray);
if (!$wishlistItems) {
$invalidItem = true;
} else {
$wishlistItem = $wishlistItems[0];
}
}
// fetch a group
if (isset($_GET["group"])) {
$sql = 'SELECT * FROM wishlistgroups WHERE userID = ? AND id = ? LIMIT 1';
$paramArray = array($user->id, $_GET["group"]);
$wishlistGroups = WishlistGroup::findBySql($sql, $paramArray);
if (!$wishlistGroups) {
$invalidGroup = true;
} else {
$wishlistGroup = $wishlistGroups[0];
}
} else {
// fetch all groups
$wishlistGroups = WishlistGroup::findBySql('SELECT * FROM wishlistgroups WHERE userID = "' . $user->id . '" ORDER BY groupName ASC');
}
$user->save();
// Create default income/expense categories
$incomeCategories = array("Work", "Other");
$expenseCategories = array("Food", "Home", "Clothing", "Entertainment", "Transportation", "Other");
foreach ($incomeCategories as $category) {
$incomeType = new IncomeType();
$incomeType->userID = $user->id;
$incomeType->category = $category;
$incomeType->save();
}
foreach ($expenseCategories as $category) {
$expenseType = new ExpenseType();
$expenseType->userID = $user->id;
$expenseType->category = $category;
$expenseType->save();
}
// Create default wishlist group
$wishlistGroup = new WishlistGroup();
$wishlistGroup->userID = $user->id;
$wishlistGroup->groupName = "General";
$wishlistGroup->save();
$session->setMessage("Registration complete.");
header("Location: " . BASE_URL . "login/");
exit;
}
}
$page = "register";
require_once "register.html.php";
?>
if (!isset($_POST["item"]) || !isset($_POST["price"]) || !isset($_POST["itemGroup"])) {
$processItemError = true;
} else {
$item = trim($_POST["item"]);
$price = trim($_POST["price"]);
$group = intval(trim($_POST["itemGroup"]));
$itemError = false;
if (!WishlistItem::isValidItem($item)) {
$itemError = true;
$itemNameError = true;
}
if (!WishlistItem::isValidAmount($price)) {
$itemError = true;
$itemPriceError = true;
}
if (!WishlistGroup::isValidGroup($user->id, $group)) {
$itemError = true;
$itemGroupError = true;
}
if (!$itemError) {
$newItem = new WishlistItem();
$newItem->userID = $user->id;
$newItem->item = $item;
$newItem->groupID = $group;
$newItem->price = WishlistItem::formatAmount($price);
if (isset($wishlistItem)) {
$newItem->id = $wishlistItem->id;
}
$newItem->save();
header("Location: " . BASE_URL . "planner");
exit;
$processGroupError = true;
} else {
$groupName = trim(ucwords(strtolower($_POST["groupName"])));
$groupError = false;
if (!WishlistGroup::isValidGroupName($groupName)) {
$groupError = true;
}
if (WishlistGroup::doesGroupExist($user->id, $groupName)) {
if (!isset($wishlistGroup) || isset($wishlistGroup) && $groupName !== $wishlistGroup->groupName) {
$groupError = true;
$groupExists = true;
}
}
if (!$groupError) {
if ($groupName !== $wishlistGroup->groupName) {
$newWishlistGroup = new WishlistGroup();
$newWishlistGroup->userID = $user->id;
$newWishlistGroup->groupName = $groupName;
if (isset($wishlistGroup)) {
$newWishlistGroup->id = $wishlistGroup->id;
}
$newWishlistGroup->save();
}
header("Location: " . BASE_URL . "planner/?manageGroups");
exit;
} else {
$processGroupError = true;
}
}
if (isset($processGroupError) && $processGroupError === true) {
$session->setMessage("Error processing group.");
