Sunshine Acres Medication Logger

Inspiration

Sunshine Acres provides a loving, wholesome, Christian home for children who are separated from their parents and help them establish long-term relationships with stable parental figures, preparing them for success in adult life.

Many of the children need medicine, and the Department of Child Safety (DCS) requires Sunshine Acres to record all the times the children are given meds. This is a big headache for their Health Administrator, who has everybody fill out paper record, and they have to manually enter this into spreadsheets to export.

What it does

Our system provides a convenient way for parents caring for the children to digitally submit when they provide meds to the children. This is then logged, and can be aggregated and downloaded into a CSV that has all of the data that DCS requires.

How we built it

Our system is made of 5 distinct parts. 1) MySQL Database 2) Convenient Data Access Layer 3) Robust API 4) Health Administrator Client 5) Parent Client

Challenges we ran into

-Date storage inside MySQL as well as dates interfacing with the server/client. -Displaying large tables within UI

Accomplishments that we're proud of

-Powerful data access layer for dynamic querying -Easy to understand API -Proper implementation of Vuex -Clean Design -Clever data representation in the HA Client (Conveniently editing a M:N relationship) -Thin parent client app

What we learned

-Vuex -MySQL -Value of Data Access Layer

What's next for Team 5

We're on a rollercoaster that only goes up

Built With

amazon-web-services
babel
bootstrap
express.js
jquery
materializecss
mysql
node.js
typescript
vue
vuerouter
vuex
webpack

Submitted to

Opportunity Hack 2017 Arizona
- Winner 1st Place

Created by

I worked on the Vue components for the Parent Client and incorporated a Redux Pattern using Vuex.

Designed using Materializecss and connected API endpoints using Webpack Proxy.

It was my first time using Vuex, and it was a great learning experience for me to pick it up.

Alireza Bahremand
ASU Software Engineer seeking to build things that make me not want to procrastinate.
Helped figure out the requirements for the project and develop a SQL database schema to best represent them.

Developed the REST api server in Node.js using Express.js. I created all the endpoints for CRUD operations for the data and was the interface between the client applications and the data access layer.

Helped contribute when needed to the data access layer and helped debug some client applications.

Joshua Hewlett
Created and Setup MySQL Database. Designed table schema and created tables accordingly.

Created a robust, modular Data Access layer for the API. Designed and implemented varying SQL queries to provide the API with the data it needed.

Worked on Vuex Actions, Mutators and Getters for the Health Admin client. Designed and implemented the reports screen on the HA Client

Provided assistance for API.

James Quigley
I worked on the health administrator client, which gives nearly full control of our mysql tables to the organization's health admin so they can do their job as effectively as possible. Notably, my client seamlessly and intuitively allows editing of a many-to-many relationship without directly exposing the intermediary relationship table.

Chuck Dries
Worked on parent client. Created Vuex Actions, Mutators, State and Getters for the Login modal Vue Component. Also, designed using MaterializeCSS.

This was my first time using Vue.js and Vuex. My learning experience with React/Redux has been helpful to learn it quickly along with Vue's easy to understand documentation.

Saul Lopez