Our one-man-team at c1868921 Inc., is pleased to present the final version (1.0.0) of PontyPridd University's Library Service. This dynamic application extends on top of the Express.js framework provided to create a deployable website that fully complies with the specification.
To reduce deployment time, we(me) have chosen to use:
- bootstrap most basic templates from the Bootstrap Cheat Sheet by Alexander Rechsteiner;
- jQuery and jQueryUI: for interacting the database and the UX.
- pug: as a view engine for the Express.js framework
- scss: Not really needed, but it was prefferred over plain CSS for scalability, and $variables.
This applicaton has been deployed to Google Cloud and it's fully functional.
The server.js file is deprecated. It has been merged with app.js to provide the API and the webserver for easy deployment. CORS has been disabled as there is no Cross-Site referencing.
The initial routes provided has been moved to /routes/api while the .pug files have been routed in /routes/.
/public/javascripts/ contains script.js and user-script.js.
/public/stylesheets/ contains the style.scss and the generated style.css.map
/views contains the pug files used by Express view engine.
app.js file contains the configuration for the Express.js framework, compression and helmet package were added for deployment, as well as express-favicon library. Routes for the pug templates were also added.
This functions are in public/javascripts/user-script.js.
U1 - Add a new User to the Library system with the fields Name, Barcode and Member Type(Staff/Student)
Write down the new user's Name and Barcode, select from the list the member type (Staff or Student) and click the add button. The entry added will appear bellow.
Type a search string and click on the Search button and the results will appear bellow. If all fields are left empty, but either Staff or Student is selected, all Students or Staff members will be listed in the Results (details on ).
Type a search string and click on the Search button and the results will appear bellow.
Search a User to update and click the left-hand selection box. The fields will change and become editable by the user. Fields show their current values in the database as a placeholder in the input field; if left blank it will send the same data. Click Update to save changes to the database. Only one user can be changed. No bulk loading.
After the database has been written an alert box will show the entry just updated.
Search for an user and then click on the left hand side selection box. Selected Entry will turn red. Click on the delete button to delete the entry selected. A confirm message box will ask if the user want to delete the selected entry(ies). If answered Ok, it will show another alert after every entry is deleted from the database. If more than one entry is selected it will bulk delete them.
Books functions are located in script.js file. Users and Loans functions are in user-scripts.js file.
By default when it first loads this page only has one field for author. By clicking on add another author will add another input field for the author. Click on the add button to add the book to the Books table, add all the authors to Authors table, and then relate each on authors_books table. The website will show an alert box with the name of the author just added. This is added to prevent sqlite3 database from locking from concurrency. Added books will appear if we run search.
BUG: If the alert boxes are clicked too quickly, the sqlitedb will lock and the authors will not be written.
Added Books to the database.
As showed before, searching by title works, and the results are scrolled down automatically. Searching by isbn and by authors are implemented:
At the end of script.js there is in the comments my many attempts at rendering results and trying out promises. Because this section was the first I attempted to do, it's somewhat too long, and certain functions added extra complexity (instead of ?queryAll, use a $.Deferred object to query the Authors table using localhost:port/api/search?type=authors&.... This was done as a preparation for the challenges ahead, specially the ones in the loans section.
Delete User functions were a rewrite of this function.
It offers the same functionality. It will bulk delete the entries. The Authors are not automatically deleted, because the system checks if the author exists in the database before adding it and if it does exist it just adds the entry to author_books table. (script.js:133 contains the order of calling for the Delete Entry functions.), so there is some utility in having to remove them manually. This functionality has been included:
![alt][delete-author]
Clicking on Delete will show a confirm box, asking for confirmation for deletion, if answered OK removes the selected author from the database.
Search Title or ISBN implemented. Click on the Loan This Book button on the book you want to loan, then search for the user name or barcode.
Select the date for the loan on the calendar and click on loan. The book will be registered as on loan.
It is Impossible to loan a book to a user if the book is already on loan, see L3 - Get the User currently borrowing a Book,
Search on a user name or barcode will return the list of books loaned by those users that match..
On book search, if the books are loaned:
It shows the user borrowing the book, It will also allow the operator to return the book (deleting it from the loans table) or to extend the due date of the book on loan. BUG: If the user search returns more than one item, selecting a day and clicking on loan will update the entry for all user rendered by the app. This behaviour has been solved in previous functions, but time constraints prevented its implementation here.
Clicking on return book will ask to confirm the user that's returning the book.
Clicking on Extend due date will open the calendar. Select a date and click Extend. It will be added. Search for the book again and the new date will appear next to the user.
Responsive design thanks to Bootstrap.
- Fix: Function has been refactored: Error on deleteting book (cause unknown):
XML Parsing Error: no element found Location: http://localhost:8000/api/books/15 Line Number 1, Column 1 - User has to wait a few seconds for the sqlite database to unlock when adding a book with more than one autor. setTimeout has been added to the function, but does not seem to have any effect.
You can visit this project github.com.