Sky Package Tracking (skypt) is an idea to improve the experience of Sky Staff when receiving packages.
The objective is:
- Easier and faster package registration for the security guard.
- Package arrival notification for the recipient.
- Package arrives.
- Security Guard logs in to the application.
- Security Guard takes photo in application.
- Security Guard fills in the recipient name.
- Security Guard confirms Package Registration.
- Sky Staffer receives notification e-mail (optionally slack).
- Sky Staffer goes to the Security Guard.
- Sky Staffer logs in to the application.
- Sky Staffer marks the package as Retrieve.
- Security Guard checks Package Retrieve List, compares Package Photo against package and delivers the package to Sky Staffer.
- SSL @ramalhais-sky
- Valid SSL Certificate @ramalhais-sky
- Microsoft/Azure sky.uk authentication @ramalhais-sky
- Photo Capture
- Web @ramalhais-sky
- Android
- iOS
- Upload foto
- Backend
- Web
- Firefox @ramalhais-sky
- Android
- iOS
- Register package
- Backend
- Web
- Android
- iOS
- List user packages
- Backend
- Web
- Android
- iOS
- Security Guard Login
- Backend
- Web
- Android
- iOS
- Authentication: Register package
- Authentication: List user packages
- Android App @sky-philipalmeida
- iOS App @dfloureiro
- App notification
- Backend
- Web
- Android
- iOS
- Powerpoint Presentation/Demo
- App running on Docker
- DB running on Docker
- App running on IMP/PIQ kubernetes
- DB running on IMP/PIQ kubernetes
- IMP/PIQ DNS/Ingress/F5
- e-mail notification to user
- Sky Staffer: add tracking number of an expected package
- Security Guard: List expected tracking numbers and select to register
- Sky Staffer: add slack username and receive slack notification
- Allow user to add tracking number using a bot in slack
- OCR Name and register package automatically
- OCR Tracking number and match to a user's expected package
- Read barcodes,qr codes used in shipping to get the recipient name, phone and tracking number, and register automatically.
- Integrate tracking functionality
- Sell this product to the world :D
https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet
https://www.python.org/downloads/
python -m pip install --upgrade pip
pip install mysqlclient
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'OPTIONS': {
'read_default_file': 'my.cnf',
},
'NAME': 'skypt',
'HOST': os.getenv('MYSQL_HOST'),
'USER': os.getenv('MYSQL_USER'),
'PASSWORD': os.getenv('MYSQL_PASSWORD'),
}
}
TIME_ZONE = 'Europe/Lisbon'
export MYSQL_DB="skypt"
export MYSQL_HOST="localhost"
export MYSQL_USER="skypt"
export MYSQL_PASSWORD="XXX"
create database skypt;
create user 'skypt'@'%' identified by 'XXX';
grant all privileges on skypt.* to 'skypt'@'%';
python -m pip install Django
python
>>> import django
>>> print(django.get_version())
3.0
django-admin startproject skypt
cd skypt
python manage.py startapp package_tracking
python manage.py makemigrations
python manage.py migrate
python manage.py createsuperuser
https://developers.google.com/web/fundamentals/media/capturing-images
pip install django_microsoft_auth
- https://portal.azure.com/
- Home > App registrations > Sky Lisbon Hackathon - SkyPT - Authentication
- Callback: https://dd.ramalhais.com/microsoft/auth-callback/
https://docs.djangoproject.com/en/3.0/howto/static-files/
pip install django-sslserver
INSTALLED_APPS = (...
"sslserver",
...
)
python manage.py runsslserver --certificate ../crt --key ../key 0.0.0.0:443
python manage.py runsslserver 0.0.0.0:443
python manage.py runserver 0.0.0.0:80