$sortBy = "id";
}
if (isset($_GET["sortOrder"])) {
if (trim(strtolower($_GET["sortOrder"])) === "asc") {
$sortOrder = "asc";
} else {
$sortOrder = "desc";
}
} else {
$sortOrder = "desc";
}
// determine which group to display items from
if (isset($_GET["display"])) {
$displayGroup = trim(ucwords(strtolower($_GET["display"])));
// check if display group exists
if (WishlistGroup::doesGroupExist($user->id, $displayGroup)) {
$display = $displayGroup;
$showAllItems = false;
$sql = 'SELECT wishlistitems.id as id, item, price, groupID, groupName FROM wishlistitems INNER JOIN wishlistgroups ON wishlistitems.groupID = wishlistgroups.id';
$sql .= ' WHERE wishlistitems.userID = ? AND groupName = ?';
$sql .= ' ORDER BY ' . $sortBy . ' ' . $sortOrder;
$paramArray = array($user->id, $displayGroup);
$wishlistItems = WishlistItem::findBySql($sql, $paramArray);
}
}
if ($showAllItems) {
$display = "All Items";
// fetch all items
$sql = 'SELECT wishlistitems.id as id, item, price, groupID, groupName';
$sql .= ' FROM wishlistitems INNER JOIN wishlistgroups ON wishlistitems.groupID = wishlistgroups.id';
$sql .= ' WHERE wishlistitems.userID = ?';
<?php
if (isset($_POST["saveGroup"])) {
if (!isset($_POST["groupName"])) {
$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;
