In a nutshell we are:
1. adding links and filter to make sure that a user has their own set of data and cannot see another user's set of data. A business can 'see' data belonging to all companies within the business.
The following statements/rules must be true:
- a user can belong to many companies and one company can have many users. The first user of the business/company will set up the companies.
- a building can belong to only one company
- a room can only belong to one building
We achieve this by adding the following fields:
1.1 new table company_user that links a specific user to a specific company. Multiple user's can exists in multiple companies.
1.2 extend buildings table with company_id
1.3 extend rooms table with company_id (derived from building)
1.4 extend events table with company_id and building_id (derived from rooom)
The above will make it easier to filter, once we know the user belongs to company A,B and C as defined in company_user, we can filter for building,rooms,events accordingly.
We will re-create the events and update the other tables, so that the new data is available.
It probably sounds worse than it is in the user stories below, but take the above rules into account, then it is not too bad to understand.
Initially all the filters sounded very difficult, but now that we will create new fields on the the different tables, the sql queries should be a lot easier with less joins.
The other biggie is the registration screen (GMM-21), but it works a lot like user profile, except you need to learn a bit about ion_auth (very good documentation at [url removed, login to view] ) and we need to set up mail, leave this one for last, just in case you run out of time. For the time being, I can create users manually.
I have estimated roughly 9h worth of work, if you disagree with some of the hours, then you are welcome to discuss it. Again, if you go over budget, let's work something out.
Taking the amount of time available, I would rather have work done than argue the amount of time. I am trying to get a feel for how long the stuff takes you, which is why I offer an estimate, but I hope to improve my estimates through your feedback and actual time spent.
Sorry, no word document this time, there are not that many layout changes.
Good luck, let me know if anything is unclear. I might have written some of the stories badly, but keep the rules above in mind, then it should be easier to read.
see attached file