benmoony / library_app Goto Github PK

Allow the user to create new Rooms within the database that are not bound by Area's

Create some rough design examples to discuss with Cyril and Cheryl. Nothing elaborate. Just enough to have a conversation about them.

Implement furniture for multiple survey's and show the infor

Implement The ability to upload floor-plans

Display use ratio/average peak/calculated capacity within color-coded areas that display the information queried

When attempting to print the data text document, the script that writes the text document repeats 3 times. Investigate and find a solution for this bug.

Eric:
After looking into the problem I found that when the user went to print the map that the way the plugin works is that it makes a completely new map upon creation and destruction (of the printable map) which then added the report multiple times to the iFrame, at that point I just created a check to make sure the report doesn't get added multiple times.

Example Use Case:
As a Librarian, I want to be to query usage data in each area of the Library so I can make better decisions on how to arrange the furniture for better, more efficient use.

Prepare for initial release (1.0) documentation updated / meeting with facilities / management looking for additional funding.

Allow user to create their own custom activities and check whether or not they are associated with whiteboards.

Improve aesthetic design for intuitive and easy use.

TWO TASKS:
-Improve look and UI for the Layout Editor
-Give users ability to Name Layout after check to ensure that it is a viable layout

Questions for Cyril related to Multiple Survey report on modified furniture:

We have a count for the number of times a modified furniture has been reported how will we report this on the map?

Do you want the modified pieces of furniture to show up on the map?

Do you want a count of the number of furniture that has been modified in the area?

Cyril Wants us to add lines off of pieces of furniture indicating how they were modified in many different directions (Spiderweb)

At the moment, uploading floor-plans looks unfinished and is clunky. I am now going back and fixing up the CSS of that feature

Protect against SQL injection and cross site scripting

Get rid of period information and refactor range of reports to select surveys by floor, start date and end date

Add the legends with the survey data

Show when survey's were taken and properly display time stamp information on the query report select drop down

Walk with users and gather bugs, feedback, and suggestions from library staff

Ensure modified furniture is marked and it’s data displayed appropriately. (i.e. making a note of how many times the specific furniture has been modified)

After a user uploads a new floor-plan svg then have them create new areas.

Table allows for survey’s to be referred to by a survey period, allowing for easy querying and data collection

Add the print button for text report and map

Fix the time format for surveys when adding to DB, from 12hr to 24hr.

Select range of survey's initial page needs to be created and an option to query either a single survey or multiple survey's needs to be build

Eric will handle placing the rooms within the Layout,
Ben will handle the insert statements in php

Implement critical bug fixes and meet to prioritize feedback and goals

Perform use case scenario's with users

Make furniture rotatable with touch screen motions

Print functionality for queried data: Create functions that parse the data and make printable formats of the queried for users to print out

Implement a method to change threshold percentage and change color associated with that

Improve editor based on use cases and test (Ensure users can NAME their layouts)

Update live version before continuing work on the Library App

Take the queried information and display it in a map with color coded areas and pertinent information displayed.

When running furniture_L1.sql - L3.sql the same error messages appear. Looking inside the script file I noticed that the INSERT TO goes to FURNITURE and not furniture. The table "furniture" exists, but not the table "FURNITURE." I wonder is this is why I'm having an issue on Ubuntu?

Investigate and resolve why areas are not added to a layout even after selecting areas to populate.
On submit, the areas are not getting inserted.

Add the day to the Multibox Query

Have date and time of survey on the page after survey has been selected

With the introduction of user uploaded floor-plans the user needs a way to select these floor-plans from the DB when collecting data, creating a layout and querying reports.

Update documentation, push to live site