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);