Dear openHAB Community,
I’m working on a Smart Public Building project at my university HfT Stuttgart and would appreciate to hear your opinions about my plans.
My task in this project is about capturing damages in the building via smartphone and send that data online to the responsible staff. This should be integrated in openHAB since our university wants to use it as central platform for that specific project.
My idea is to capture the information in a webform by using a smartphone. The data should then be uploaded in a MySQL Database. With MySQL persistence in openHAB i want to integrate the data in the HABPanel.
A damage ticket in the database contains information like
- brief description
- position (room)
- picture of the damage
- e-mail of the ticket-creator
As a first step, it would be nice to have a counter in the HABPanel which tells me how many tickets are in my database, or a visualisation of each ticket with an image of the damage and for example its position. As an extended version it would be useful to inform the ticket-creator when a damage is repaired.
I have many more ideas but I’m having a bit of trouble with the integration in openHAB, so that’s where I’m seeking advice on.
I would be glad if you’d share your thoughts and ideas about the project with me. I try to update this thread in future to keep you on track with my progress.
I really appreciate any help you can provide