Quick and simple PHP gift registry
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
phpgiftreg/categories.php

129 lines
4.0 KiB

<?php
// This program is free software; you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation; either version 2 of the License, or
// (at your option) any later version.
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
require_once(dirname(__FILE__) . "/includes/funcLib.php");
require_once(dirname(__FILE__) . "/includes/MySmarty.class.php");
$smarty = new MySmarty();
$opt = $smarty->opt();
session_start();
if (!isset($_SESSION["userid"])) {
header("Location: " . getFullPath("login.php"));
exit;
}
else if ($_SESSION["admin"] != 1) {
echo "You don't have admin privileges.";
exit;
}
else {
$userid = $_SESSION["userid"];
}
if (!empty($_GET["message"])) {
$message = $_GET["message"];
}
$action = isset($_GET["action"]) ? $_GET["action"] : "";
if ($action == "insert" || $action == "update") {
/* validate the data. */
$category = trim($_GET["category"]);
$haserror = false;
if ($category == "") {
$haserror = true;
$category_error = "A category is required.";
}
}
if ($action == "delete") {
/* first, NULL all category FKs for items that use this category. */
$stmt = $smarty->dbh()->prepare("UPDATE {$opt["table_prefix"]}items SET category = NULL WHERE category = ?");
$stmt->bindValue(1, (int) $_GET["categoryid"], PDO::PARAM_INT);
$stmt->execute();
$stmt = $smarty->dbh()->prepare("DELETE FROM {$opt["table_prefix"]}categories WHERE categoryid = ?");
$stmt->bindValue(1, (int) $_GET["categoryid"], PDO::PARAM_INT);
$stmt->execute();
header("Location: " . getFullPath("categories.php?message=Category+deleted."));
exit;
}
else if ($action == "edit") {
$stmt = $smarty->dbh()->prepare("SELECT category FROM {$opt["table_prefix"]}categories WHERE categoryid = ?");
$stmt->bindValue(1, (int) $_GET["categoryid"], PDO::PARAM_INT);
$stmt->execute();
if ($row = $stmt->fetch()) {
$category = $row["category"];
}
}
else if ($action == "") {
$category = "";
}
else if ($action == "insert") {
if (!$haserror) {
$stmt = $smarty->dbh()->prepare("INSERT INTO {$opt["table_prefix"]}categories(categoryid,category) VALUES(NULL, ?)");
$stmt->bindParam(1, $category, PDO::PARAM_STR);
$stmt->execute();
header("Location: " . getFullPath("categories.php?message=Category+added."));
exit;
}
}
else if ($action == "update") {
if (!$haserror) {
$stmt = $smarty->dbh()->prepare("UPDATE {$opt["table_prefix"]}categories " .
"SET category = ? " .
"WHERE categoryid = ?");
$stmt->bindParam(1, $category, PDO::PARAM_STR);
$stmt->bindValue(2, (int) $_GET["categoryid"], PDO::PARAM_INT);
$stmt->execute();
header("Location: " . getFullPath("categories.php?message=Category+updated."));
exit;
}
}
else {
die("Unknown verb.");
}
$stmt = $smarty->dbh()->prepare("SELECT c.categoryid, c.category, COUNT(itemid) AS itemsin " .
"FROM {$opt["table_prefix"]}categories c " .
"LEFT OUTER JOIN {$opt["table_prefix"]}items i ON i.category = c.categoryid " .
"GROUP BY c.categoryid, category " .
"ORDER BY category");
$stmt->execute();
$categories = array();
while ($row = $stmt->fetch()) {
$categories[] = $row;
}
if (isset($action)) {
$smarty->assign('action', $action);
}
$smarty->assign('categories', $categories);
if (isset($_GET["categoryid"])) {
$smarty->assign('categoryid', (int) $_GET["categoryid"]);
}
if (isset($message)) {
$smarty->assign('message', $message);
}
$smarty->assign('category', $category);
if (isset($category_error)) {
$smarty->assign('category_error', $category_error);
}
$smarty->assign('haserror', isset($haserror) ? $haserror : false);
$smarty->display('categories.tpl');
?>