- master folder with all info for torrens: https://drive.google.com/open?id=1cZaUjLzV3hIbhGMP-mc-uywEq8HcYkPS
- Figma UI Designs: https://www.figma.com/file/q213rSM1bDSIGCbETgCeAL/Official-SHS-Trophy-UI?node-id=1%3A2
- Images provided by Mr. Torrens: https://drive.google.com/drive/folders/1jjymid-BPNTvE8sj15OUT0PvNo9TRVqW
- Spreadsheet provided by Mr. Torrens of trophyAward information: https://drive.google.com/drive/folders/1uUnlIY1g8QrJMeidAtESJx-MJrDoLoLm
- Test Spreadsheet provided by Arman: https://docs.google.com/spreadsheets/d/1bCjaCRR1ezrEWUXnxYyPRpUK5nr6u3NTP7iEitLEyxo/edit#gid=0
- Example Spreadsheet Mr. Torrens will be using: https://docs.google.com/spreadsheets/d/1DBYBQEN4fZd0ByzcxvvGMDZ--I2-Ku2Rr5zMRpbFRsU/edit#gid=0
- Database schema design: https://docs.google.com/document/d/1I4Tbaf91UoqEknFLpeujyCxKXef-D9utp799DpYx_7g/edit
-- To get the image url: click on the image, then on the right hand side top, click three dots, then click on "Open in new window", and the copy the url
-- P7220156.JPG - Trophy with one year many players - football: https://drive.google.com/file/d/1zOlNzaB-VGyegnQ_3UWZtq64KsVLK4Q7/view -- P7220173.JPG - Trophy with no players - football: https://drive.google.com/file/d/1V1SN5c5wDbUyB0yNlPphWoLM-yMQor98/view -- P7220176.JPG - Trophy with no year no players - football: https://drive.google.com/file/d/1cEOO6vceis57f0MU_wSk-hTojf_Ct_0W/view -- P7220178.JPG - Trophy with many years and one player per year - football: https://drive.google.com/file/d/1ZZkED9UHRSnEVuw-oJVN75B4FvV8jCfX/view
https://drive.google.com/file/d/1zOlNzaB-VGyegnQ_3UWZtq64KsVLK4Q7/view?usp=sharing
Use a 10.1 inch WXGA Tablet running API 28. Press download data and then load database from then on.
- download SQLLiteStudio (https://sqlitestudio.pl/index.rvt?act=download)
- Use the following command to get the name of your device or emulator:
adb devices
- set environment variable DEVICE with the name of your device or emulator:
export DEVICE=emulator-5554
- run the following commands:
adb -s $DEVICE shell run-as com.shs.trophiesapp chmod -R 777 databases && adb -s $DEVICE shell "mkdir -p /sdcard/tempDB" && adb -s $DEVICE shell run-as com.shs.trophiesapp "cp -r databases /sdcard/tempDB/." && adb -s $DEVICE pull sdcard/tempDB/ && adb -s $DEVICE shell "rm -r /sdcard/tempDB/*"
- (Ujjwal) fix all loading bugs
Database related
- (Maybe for later if needed. Dont work on this yet) enable recyclerview pagination
Remaining Search Features
- (Ujjwal) make max suggestion count 2 so suggestions don't overflow
- (Ujjwal) fix advanced search bugs/data validation (ex: when you type John in "Years", all trophies show up)
- (Ujjwal) If someone types in football on homepage, searching should bring them to the football trophies page
- (minor fix) fix overall suggestion wording
UI Related Backend
- (Ujjwal) add report a bug page such as google form embedded
- add content for about the app
- (Arman)fix scroll down all the way for Name's award page
- (Arman) fix advanced search's UI
Mike Cable
Mike Cable in Players Mike Calbe Basketball Mike Cable Football Mike Cable 1995 Mike Cable 1996 Mike Cable 1997 Mike Calble Most Insipration Mike Cable Fearless Player