Designed using 💾 MySQL Workbench 8.0 CE 💻 Intellij IDEA 🖥️ Visual Studio Code
+ Cat Tracker is a logging and navigation app that allows users to record sightings of outdoor cats in their area.
+ As the application collects data, users can navigate to commonly sighted locations to increase the likelihood of spotting their favorite local cats.
+ User’s will need to be part of a designated club that has an admin user responsible for all admissions.
+ This application will leverage Google’s map API and Amazon Web Services (AWS) S3 bucket for data storage.The application user is an accommodation administrator. They pair guests to hosts to make reservations.
Main App features
- browse profiles by neighborhood/club.
- view sightings per cat profile (map markers of sightings for that cat only)
- view all sightings in neighborhood (click on location map markers)
Profiles for Cats: admin managed.
- alias/name
- picture (if applicable)
- owner (if applicable)
- description: visual description, friendliness/approachability
- Breed (owner only)
- most frequently spotted location (2-3 block radius)
- avg time of day spotted (1–2-hour window)
- Display locations (map markers)
- report profile/sighting to be taken down by admin.
- Image SRC for individual sightings, SVG for images
Profiles for User:
- Username (shown publicly)
- First/last name (shown publicly – optional to user)
- List of cats owned by user (if any)
- List of sightings
Sightings: user submission
- pictures/videos
- date and time
- Location
- Visual/physical description
- Description of sighting/interaction (seemed scared, friendly/asked for pets, collar/no collar, hungry, etc.)
To launch the application Use MySQL workbench 8.0 CE to run queries on the following files
- cat-tracker-schema-prod.sql
- cat-tracker-schema-test.sql
Use Visual Studio code to send HTTP requests using the file below
- App.js
To launch server
- compile the program -->javac App.java
- launch the program --> java App
To lauch User Interface
- navigate to src folder
- run -> npm install
- run -> npm start
- Login or register an account
+ Click Link to view Flow chart in full pageLOGIN PAGE
PROFILE PAGE
ADD FORM
VIEW SIGHTINGS
+ Click the link below to view UML chart in full page
+ Click the link below to view UML chart in full page
+ Click the link below to view UML chart in full page
| DATE | TASK ID | ESTIMATED TIME (HRS) | START TIME (HRS:MINS) | END TIME (HRS:MINS) | STATUS | ASSIGNED TO |
|---|---|---|---|---|---|---|
| 5/18/2021 | Database directories & comments | 0:30 | 3:30 PM | 3:50 PM | Completed | Chike, Quinn |
| 5/18/2021 | Java directories & comments | 0:30 | 3:30 PM | 4:00 PM | Completed | Chike, Quinn |
| 5/18/2021 | DDL: User & Location | 4 | 7:00 PM | 8:10 PM | Completed | Chike |
| 5/18/2021 | DDL: Sightings & Reports | 4 | 4:30pm | 5:00pm | Complete | Quinn |
| 5/18/2021 | DDL: Alias & Cats | 4 | 4:30pm | 5:00pm | Completed | Derek |
| 5/19/2021 | DML: Test Data | 3 | 9:00 AM | 12:00 PM | Completed | Chike, Quinn, Derek |
| 5/19/2021 | User & Location Models | 2 | 1:30 PM | 2:00 PM | Completed | Chike |
| 5/19/2021 | Sightings & Reports Models | 2 | 1:40pm | 2:20pm | Completed | Quinn |
| 5/19/2021 | Alias & Cats Models | 2 | 1:40pm | 2:30pm | Completed | Derek |
| 5/19/2021 | User & Location Mappers | 2 | 10:00 AM | 11:00 AM | Completed | Chike |
| 5/19/2021 | Sightings & Reports Mappers | 2 | 1:40pm | 2:20pm | Completed | Quinn |
| 5/19/2021 | Alias & Cats Mappers | 2 | 6:50pm | 7:30pm | Completed | Derek |
| 5/19/2021 | JdbcTemplate Interface & Repo: U & L | 2 | 1:00 AM | 3:00 AM | Completed | Chike |
| 5/19/2021 | JdbcTemplate Interface & Repo: S & R | 2 | 7:00pm | 9:00pm | Completed | Quinn |
| 5/19/2021 | JdbcTemplate Interface & Repo: A & C | 2 | 4:30 | 5:45pm | Completed | Derek |
| DATE | TASK ID | ESTIMATED TIME (HRS) | START TIME (HRS:MINS) | END TIME (HRS:MINS) | STATUS | ASSIGNED TO |
|---|---|---|---|---|---|---|
| 5/20/2021 | Result, ResultType, Validations | 2 | _ | _ | Completed | Chike, Quinn, Derek |
| 5/20/2021 | U & L Service | 4 | 1:00 AM | 4:00 AM | Completed | Chike |
| 5/20/2021 | S & R Service | 4 | 5:00pm | 8:00pm | Completed | Quinn |
| 5/20/2021 | A & C Service | 4 | 9:00pm | 11:45pm | Completed | Derek |
| 5/21/2021 | ErrorResponse & GlobalExceptionHandler | 1 | 5:00pm | 5:15pm | Completed | Quinn |
| 5/21/2021 | U & L Controller | 4 | 9:07 PM | 10:00 PM | Completed | Chike |
| 5/21/2021 | S & R Controller | 4 | 7:30pm | 9:00pm | Completed | Quinn |
| 5/21/2021 | A & C Controller | 4 | 11:00am | 1:00 | In Progress | Derek |
| 5/21/2021 | React Setup | 1.5 | 5:00pm | 5:15pm | Completed | Quinn |
| 5/21/2021 | Component Setup | 1.5 | _ | _ | Not Started | Chike, Quinn, Derek |
| 5/21/2021 | Roles & Authentication | 1 | _ | _ | Not Started | Derek |
| 5/21/2021 | Navigation Bar | 2 | _ | _ | Completed | Quinn |
| 5/21/2021 | ViewSightings | 4 | 5:00pm | 7:00pm | In Progress | Quinn |
| 5/23/2021 | Azure: Research and Setup | 4 | 2:00 PM | 6:30 PM | Completed | Chike |
| 5/23/2021 | Setup: Install Microsoft Azure desktop, containers, and blop | 4 | 1:00 PM | 3:00 PM | Completed | Chike |
| 5/23/2021 | Populate data and generate individual url | 1 | 7:00 PM | 8:00 PM | Completed | Chike |
| 5/23/2021 | Test Cloud Data with HTTP (VSCODE) | 0.5 | 10:00 PM | 3:00 AM | Completed | Chike |
| DATE | TASK ID | ESTIMATED TIME (HRS) | START TIME (HRS:MINS) | END TIME (HRS:MINS) | STATUS | ASSIGNED TO |
|---|---|---|---|---|---|---|
| 5/24/2021 | ViewSightings (Google Maps) | 4 | 9:30 | _ | In Progress | Quinn |
| 5/24/2021 | Sighting | 2 | _ | _ | Completed | Quinn |
| 5/25/2021 | AddSighting | 1 | _ | _ | In Progress | Quinn |
| 5/25/2021 | UpdateSighting | 1 | _ | _ | In Progress | Quinn |
| 5/25/2021 | DeleteSighting | 2 | _ | _ | Not Started | Quinn |
| 5/24/2021 | CatProfiles | 3 | 6:00 PM | 9:00 PM | Completed | Chike |
| 5/24/2021 | Add Azure configuration to react app (packages and extension) | 3 | 9:00 PM | _ | In progress | Chike |
| 5/24/2021 | Include azure-blop react component | 3 | _ | _ | Not Started | Chike |
| 5/24/2021 | Update Sighting image paths with Controllers | 1 | _ | _ | Not Started | Chike |
| 5/24/2021 | Test and Debugging | 1 | _ | _ | Not Started | Chike |
| 5/24/2021 | ViewCatProfiles | 3 | _ | _ | In Progress | Quinn (by 4) |
| 5/24/2021 | UpdateCatProfile | 2 | _ | _ | Not Started | Chike & Quinn |
| 5/24/2021 | DeleteCatProfile | 2 | _ | _ | Not Started | Chike & Quinn |
| 5/24/2021 | User Access (Login, logout, User Roles) | 2 | _ | _ | Not Started | Derek |
| 5/25/2021 | Debugging | 4 | _ | _ | Not Started | Quinn |
| 5/26/2021 | Styling | 3 | _ | _ | Not Started | Quinn |
| 5/26/2021 | Static Pages (Home, About us, contact, FAQ) | 2 | _ | _ | Not Started | Quinn |
|_ | Stretch Goals | _ | _ | _ | Not Started |_
- Directions to cat from current location
- share sightings on social media (embed link)
- like and comment on sightings in app
- user account page to view all your own recorded sightings.