} } // 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.");