This application was built for Aunt Leah's Place by the Code The Change Foundation. See more of CTC's work here.
This application will help Aunt Leah's Place to better manage their volunteers. The application enables volunteers to:
- create an account
- sign in for shifts at various events and locations It also enables administrators to:
- add and delete volunteer locations
- view and export volunteer data for integration with Salesforce
- clear volunteer data
This application was built using React, Redux, Material-UI, and Node.js. The application also uses Azure Functions, an MS SQL database, and Azure's Active Directory for authentication.
- React
- Redux
- Material-UI
- Node.js
- Azure Functions
- Azure Active Directory
- MS SQL
- NPM and Node.js
- Docker
- Azure Data Studio
- Azure Functions Extension for Visual Studio Code
- Clone the repository and open the project in your IDE. We recommend Visual Studio Code to make using Azure a whole lot easier.
- If you do opt to use VSCode, install the Azure Functions extension. Docker will also be handy, although it's not totally necessary.
- In a terminal, navigate to the
aunt-leahs-app
directory and runnpm -i
. Then, open a second terminal window, navigate to theaunt-leahs-functions
directory, and do the same. - In the
aunt-leahs-app
directory, runnpm start
. Your browser should open to the app and crash, because there's no server running yet!
- Install Docker, if you don't have it already.
- Increase the amount of memory allocated to Docker; we recommend at least 4GB.
- Run
sudo docker pull mcr.microsoft.com/mssql/server:2019-latest
to install MS SQL. - Launch the Docker image with
docker run -d --name alp_sql_server -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=YOURPASSWORD' -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest
. Update the password to whatever you prefer. - Run
docker ps
to check that an instance is running. - Install Azure Data Studio.
- In Azure Data Studio, click 'New connection' and fill in the following details:
- Server: localhost
- Authentication type: SQL Login
- User name: sa
- Password: YOURPASSWORD
- Hit connect. You should now be connected to the database.
- Select the option to create a new SQL query.
- From the source code, navigate to the
scripts
folder. Copy the code from the file, paste it into Azure Data Studio, and run the query. You should receive a confirmation message of0 rows affected
. - You may insert test values into the database.
- Go back to the terminal open to the
aunt-leahs-functions
directory and runfunc start
to begin the server. - Play around with the app! You won't be able to access the admin flow without ALP's login credentials, of course. However, you can remove the
<AzureAD>
tags in the front-end and grant yourself access, if you're so inclined.
This app is currently in use by ALP and is not being actively maintained. Want to help out nonprofits with code? Learn more about Code The Change here. If you're not a UBC student, you can likely find a similar club on campuses around the world.
This project is licensed under the MIT License.