ramalhais-sky / skypt

Sky Lisbon Hackathon - Sky Package Tracking

What is this

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.

How it should work

0. Package arrives.
1. Security Guard logs in to the application.
2. Security Guard takes photo in application.
3. Security Guard fills in the recipient name.
4. Security Guard confirms Package Registration.
5. Sky Staffer receives notification e-mail (optionally slack).
6. Sky Staffer goes to the Security Guard.
7. Sky Staffer logs in to the application.
8. Sky Staffer marks the package as Retrieve.
9. Security Guard checks Package Retrieve List, compares Package Photo against package and delivers the package to Sky Staffer.

TODO

• 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

Nice to Have

• 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

Ideas

• 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

Crazy Ideas

• OCR Name and register package automatically
• OCR Tracking number and match to a user's expected package
  • https://tesseract.projectnaptha.com/
    • https://progur.com/2016/10/how-to-use-tesseract-for-ocr-javascript.html
    • https://www.ttmind.com/TechPost/HOW-TO-EXTRACT-TEXT-FROM-IMAGE-USING-JAVASCRIPT-OCR-with-Tesseract-js
  • https://kdzwinel.github.io/JS-OCR-demo/
  • http://antimatter15.com/ocrad.js/demo.html
• Read barcodes,qr codes used in shipping to get the recipient name, phone and tracking number, and register automatically.
  • https://github.com/yushulx/zxing-cpp-emscripten/tree/master/examples/js
    • https://dd.ramalhais.com/.well-known/index.html
  • https://www.codepool.biz/html5-barcode-reader-javascript-webassembly.html
  • https://serratus.github.io/quaggaJS/
    • https://a.kabachnik.info/a-javascript-barcode-reader-with-bootstrap-3-and-quaggajs.html
• Integrate tracking functionality
  • https://geartrack.hdn.pt/
  • https://www.17track.net/en
• Sell this product to the world :D

Notes

Markdown cheat-sheet

https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet

Install latest python

https://www.python.org/downloads/

Upgrade PIP

python -m pip install --upgrade pip

MySQL

pip install mysqlclient

settings.py

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'@'%';

Install Django

python -m pip install Django

python
>>> import django
>>> print(django.get_version())
3.0

Create Django Project and App

django-admin startproject skypt

cd skypt
python manage.py startapp package_tracking

Setup Django Database

python manage.py makemigrations
python manage.py migrate

Create Superuser

python manage.py createsuperuser

HTML photo capture

https://developers.google.com/web/fundamentals/media/capturing-images

Microsoft/Azure Authentication (SSO)

pip install django_microsoft_auth

Create app registration in azure

• https://portal.azure.com/
• Home > App registrations > Sky Lisbon Hackathon - SkyPT - Authentication
• Callback: https://dd.ramalhais.com/microsoft/auth-callback/

Django Static files

https://docs.djangoproject.com/en/3.0/howto/static-files/

Django SSL

• https://github.com/teddziuba/django-sslserver

pip install django-sslserver

INSTALLED_APPS = (...
"sslserver",
...
)

SSL Certificate (letsencrypt)

• https://zerossl.com/free-ssl/#crt
• https://letsencrypt.org/docs/rate-limits/

Start HTTPS server with certificate

python manage.py runsslserver --certificate ../crt --key ../key 0.0.0.0:443

Start HTTPS server with self-signed certificate

python manage.py runsslserver 0.0.0.0:443

Start HTTP server (no HTTPS/SSL)

python manage.py runserver 0.0.0.0:80