require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/PreDefinedConstants.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/CommonFunctions.php';
$actionType = ACTION_ADD;
// Default Action
$editable = TRUE;
$publisherId = NULL;
if (isset($_GET[ACTION_TYPE]) && $_GET[ACTION_TYPE] != NULL) {
switch ($_GET[ACTION_TYPE]) {
case ACTION_EDIT:
checkNullwithRedirect(PUBLISHER_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_EDIT;
$publisherId = $_GET[ITEM_ID];
$title = 'Edit Publisher';
break;
case ACTION_DEL:
checkNullwithRedirect(PUBLISHER_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_DEL;
$publisherId = $_GET[ITEM_ID];
$title = 'Del Publisher';
$editable = FALSE;
break;
case ACTION_ADD:
default:
break;
}
}
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/View/Shared/Header.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/DatabaseLogic/DBConnection.php';
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/PreDefinedConstants.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/CommonFunctions.php';
$actionType = ACTION_ADD;
// Default Action
$editable = TRUE;
$sectionId = NULL;
if (isset($_GET[ACTION_TYPE]) && $_GET[ACTION_TYPE] != NULL) {
switch ($_GET[ACTION_TYPE]) {
case ACTION_EDIT:
checkNullwithRedirect(SECTION_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_EDIT;
$sectionId = $_GET[ITEM_ID];
$title = 'Edit Section';
break;
case ACTION_DEL:
checkNullwithRedirect(SECTION_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_DEL;
$sectionId = $_GET[ITEM_ID];
$title = 'Del Section';
$editable = FALSE;
break;
case ACTION_ADD:
default:
break;
}
}
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/View/Shared/Header.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/DatabaseLogic/DBConnection.php';
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
exit;
break;
case ACTION_DEL:
$actionType = ACTION_DEL;
checkNullwithRedirect(ADD_CATEGORY_PAGE, $_GET[CATEGORY_ID]);
delCategory();
exit;
break;
case ACTION_ADD:
default:
break;
}
}
checkNullwithRedirect(ADD_CATEGORY_PAGE, $_GET[CATEGORY_NAME]);
checkNullwithRedirect(ADD_CATEGORY_PAGE, $_GET[SECTION_ID]);
checkNullwithRedirect(ADD_CATEGORY_PAGE, $_GET[PARENT_CATEGORY_ID]);
addCategory();
function addCategory()
{
// TODO : Escape String for SQL Statement
$categoryName = $_GET[CATEGORY_NAME];
$sectionId = $_GET[SECTION_ID];
$parentCategoryId = $_GET[PARENT_CATEGORY_ID];
$redirectPage = CATEGORY_LIST_PAGE;
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
if ($conn) {
$result = $conn->insertCategory($categoryName, $sectionId, $parentCategoryId);
header("Location: {$redirectPage}");
exit;
break;
case ACTION_DEL_BOOK_COPY:
$actionType = ACTION_DEL_BOOK_COPY;
checkNullwithRedirect(ADD_BOOK_PAGE, $_GET[BOOK_BARCODE]);
delBookCopy();
exit;
break;
case ACTION_ADD:
default:
break;
}
}
checkNullwithRedirect(ADD_BOOK_PAGE, $_GET[BOOK_NAME]);
checkNullwithRedirect(ADD_BOOK_PAGE, $_GET[BOOK_ISBN]);
checkNullwithRedirect(ADD_BOOK_PAGE, $_GET[PUBLISHER_ID]);
checkNullwithRedirect(ADD_BOOK_PAGE, $_GET[CATEGORY_ID]);
addBook();
function addBook()
{
// TODO : Escape String for SQL Statement
$bookName = $_GET[BOOK_NAME];
$bookIsbn = $_GET[BOOK_ISBN];
$publisherId = $_GET[PUBLISHER_ID];
$categoryId = $_GET[CATEGORY_ID];
$redirectPage = BOOK_LIST_PAGE;
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
if ($conn) {
$result = $conn->insertBook($bookName, $bookIsbn, $publisherId, $categoryId);
header("Location: {$redirectPage}");
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/PreDefinedConstants.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/CommonFunctions.php';
$actionType = ACTION_ADD;
// Default Action
$editable = TRUE;
$accountId = NULL;
if (isset($_GET[ACTION_TYPE]) && $_GET[ACTION_TYPE] != NULL) {
switch ($_GET[ACTION_TYPE]) {
case ACTION_EDIT:
checkNullwithRedirect(USER_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_EDIT;
$accountId = $_GET[ITEM_ID];
$title = 'Edit User';
break;
case ACTION_DEL:
checkNullwithRedirect(USER_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_DEL;
$accountId = $_GET[ITEM_ID];
$title = 'Del User';
$editable = FALSE;
break;
case ACTION_ADD:
default:
break;
}
}
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Entity/Account.php';
redirectPageWithoutSession();
$user = getUserInfo();
$role = $user->getRole();
if ($role != 'Admin') {
checkNullwithRedirect(ADD_SECTION_PAGE, $_GET[SECTION_NAME]);
editSection();
exit;
break;
case ACTION_DEL:
$actionType = ACTION_DEL;
checkNullwithRedirect(ADD_SECTION_PAGE, $_GET[SECTION_ID]);
delSection();
exit;
break;
case ACTION_ADD:
default:
break;
}
}
checkNullwithRedirect(ADD_SECTION_PAGE, $_GET[SECTION_NAME]);
addSection();
function addSection()
{
// TODO : Escape String for SQL Statement
$sectionName = $_GET[SECTION_NAME];
$redirectPage = SECTION_LIST_PAGE;
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
if ($conn) {
$result = $conn->insertSection($sectionName);
header("Location: {$redirectPage}");
exit;
}
}
checkNullwithRedirect(ADD_AUTHOR_PAGE, $_GET[AUTHOR_NAME]);
editAuthor();
exit;
break;
case ACTION_DEL:
$actionType = ACTION_DEL;
checkNullwithRedirect(ADD_AUTHOR_PAGE, $_GET[AUTHOR_ID]);
delAuthor();
exit;
break;
case ACTION_ADD:
default:
break;
}
}
checkNullwithRedirect(ADD_AUTHOR_PAGE, $_GET[AUTHOR_NAME]);
addAuthor();
function addAuthor()
{
// TODO : Escape String for SQL Statement
$authorName = $_GET[AUTHOR_NAME];
$redirectPage = AUTHOR_LIST_PAGE;
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
if ($conn) {
$result = $conn->insertAuthor($authorName);
header("Location: {$redirectPage}");
exit;
}
}
checkNullwithRedirect(ADD_USER_PAGE, $_POST[ACCOUNT_ID]);
delUser();
exit;
break;
case ACTION_ADD:
default:
break;
}
}
checkNullwithRedirect(ADD_USER_PAGE, $_POST[ACCOUNT_TYPE]);
checkNullwithRedirect(ADD_USER_PAGE, $_POST[ACCOUNT_NAME]);
checkNullwithRedirect(ADD_USER_PAGE, $_POST[ACCOUNT_ADDRESS]);
checkNullwithRedirect(ADD_USER_PAGE, $_POST[ACCOUNT_PHONE]);
checkNullwithRedirect(ADD_USER_PAGE, $_POST[ACCOUNT_EMAIL]);
//checkNullwithRedirect(ADD_USER_PAGE, $_POST[ACCOUNT_ENROLL_YEAR]);
checkNullwithRedirect(ADD_USER_PAGE, $_POST[ACCOUNT_PASSWORD]);
switch ($_POST[ACCOUNT_TYPE]) {
case 'Student':
case 'Faculty':
case 'Librarian':
break;
default:
header('Location: ' . ADD_USER_PAGE);
exit;
}
if (!isset($_POST[ACCOUNT_ENROLL_YEAR])) {
header('Location: ' . ADD_USER_PAGE);
exit;
}
$userYear = $_POST[ACCOUNT_ENROLL_YEAR];
if ($userYear == NULL) {
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/PreDefinedConstants.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/CommonFunctions.php';
$actionType = ACTION_ADD;
// Default Action
$editable = TRUE;
$authorId = NULL;
if (isset($_GET[ACTION_TYPE]) && $_GET[ACTION_TYPE] != NULL) {
switch ($_GET[ACTION_TYPE]) {
case ACTION_EDIT:
checkNullwithRedirect(AUTHOR_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_EDIT;
$authorId = $_GET[ITEM_ID];
$title = 'Edit Author';
break;
case ACTION_DEL:
checkNullwithRedirect(AUTHOR_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_DEL;
$authorId = $_GET[ITEM_ID];
$title = 'Del Author';
$editable = FALSE;
break;
case ACTION_ADD:
default:
break;
}
}
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/View/Shared/Header.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/DatabaseLogic/DBConnection.php';
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/PreDefinedConstants.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/Global/CommonFunctions.php';
$actionType = ACTION_ADD;
// Default Action
$editable = TRUE;
$categoryId = NULL;
if (isset($_GET[ACTION_TYPE]) && $_GET[ACTION_TYPE] != NULL) {
switch ($_GET[ACTION_TYPE]) {
case ACTION_EDIT:
checkNullwithRedirect(CATEGORY_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_EDIT;
$categoryId = $_GET[ITEM_ID];
$title = 'Edit Category';
break;
case ACTION_DEL:
checkNullwithRedirect(CATEGORY_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_DEL;
$categoryId = $_GET[ITEM_ID];
$title = 'Del Category';
$editable = FALSE;
break;
case ACTION_ADD:
default:
break;
}
}
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/View/Shared/Header.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/DatabaseLogic/DBConnection.php';
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
exit;
break;
case ACTION_DEL:
$actionType = $_GET[ACTION_TYPE];
checkNullwithRedirect(ADD_PUBLISHER_PAGE, $_GET[PUBLISHER_ID]);
delPublisher();
exit;
break;
case ACTION_ADD:
default:
break;
}
}
checkNullwithRedirect(ADD_PUBLISHER_PAGE, $_GET[PUBLISHER_NAME]);
checkNullwithRedirect(ADD_PUBLISHER_PAGE, $_GET[PUBLISHER_ADDRESS]);
checkNullwithRedirect(ADD_PUBLISHER_PAGE, $_GET[PUBLISHER_PHONE]);
addPublisher();
function addPublisher()
{
// TODO : Escape String for SQL Statement
$publisherName = $_GET[PUBLISHER_NAME];
$publisherAddress = $_GET[PUBLISHER_ADDRESS];
$publsiherPhone = $_GET[PUBLISHER_PHONE];
$redirectPage = PUBLISHER_LIST_PAGE;
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
if ($conn) {
$result = $conn->insertPublisher($publisherName, $publisherAddress, $publsiherPhone);
header("Location: {$redirectPage}");
exit;
checkNullwithRedirect(BOOK_LIST_PAGE, $_GET[ITEM_ID]);
checkNullwithRedirect(BOOK_LIST_PAGE, $_GET[BOOK_BARCODE]);
$actionType = ACTION_DEL_BOOK_COPY;
$bookId = $_GET[ITEM_ID];
$bookBarcodeId = $_GET[BOOK_BARCODE];
$title = 'Del Book Copy';
$editable = FALSE;
break;
case ACTION_EDIT:
checkNullwithRedirect(BOOK_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_EDIT;
$bookId = $_GET[ITEM_ID];
$title = 'Edit Book';
break;
case ACTION_DEL:
checkNullwithRedirect(BOOK_LIST_PAGE, $_GET[ITEM_ID]);
$actionType = ACTION_DEL;
$bookId = $_GET[ITEM_ID];
$title = 'Del Book';
$editable = FALSE;
break;
case ACTION_ADD:
default:
break;
}
}
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/View/Shared/Header.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/DatabaseLogic/DBConnection.php';
$user = getUserInfo();
$role = $user->getRole();
$conn = DBConnection::getConnection($role);
