kevinunger/gpsportplaner

Room Planner for GPS Dresden

GPSportPlaner

Frontend

Angular v16 with i18n

setup:

npm install

develop with:

npm run dev or npm run hostdev (to be able to access it from your phone)

Backend

Express with Typescript and Mongoose

setup:

1. Install packages npm install

2. Setup local mongodb

docker run -d -p 27017:27017 --name gpsmongo -e MONGO_INITDB_ROOT_USERNAME=gpsbackend -e MONGO_INITDB_ROOT_PASSWORD=gpstest mongo:latest

send POST to http://localhost:3000/auth/setInitialPw with

{
    "role": "user",
    "newPassword": "pw"
}

curl command to set all roles:

curl -X POST http://localhost:3000/auth/setInitialPw -H "Content-Type: application/json" -d "{\"role\": \"user\", \"newPassword\": \"userpw\"}"
curl -X POST http://localhost:3000/auth/setInitialPw -H "Content-Type: application/json" -d "{\"role\": \"master\", \"newPassword\": \"masterpw\"}"
curl -X POST http://localhost:3000/auth/setInitialPw -H "Content-Type: application/json" -d "{\"role\": \"admin\", \"newPassword\": \"adminpw\"}"

to set user pw and set pws for all other roles (admin and master)

run mongodb docker

npm run start:db

develop with:

npm run dev

run tests with:

npm run test or npm run testwatch

Hosting

Frontend

Angular frontend is hosted via google firebase hosting

Backend Deployment to VPS for CI/CD with Github Actions

Point A-Record to VPS-IP

adduser username
usermod -aG sudo username
sudo su - username
mkdir ~/.ssh
chmod 700 ~/.ssh
Enter your key: nano ~/.ssh/authorized_keys
chmod 600 ~/.ssh/authorized_keys
sudo service ssh restart
try to login as the user
sudo nano /etc/ssh/sshd_config
change PermitRootLogin no
PasswordAuthentication no if it is yes

sudo systemctl reload sshd
sudo apt install nginx ufw
sudo ufw enable

sudo ufw allow ssh
sudo ufw allow 'Nginx Full'

Optional (new repo)
Goto Github Actions and use the deploy-backend.yml
Goto settings -> actions -> add runner
Enter each command on the server
then
sudo ./svc.sh install
sudo ./svc.sh start

install NodeJs
curl -sL https://deb.nodesource.com/setup_16.x -o nodesource_setup.sh
sudo bash nodesource_setup.sh
sudo apt-get install -y nodejs

setup pm2
mkdir ~/.npm-global
npm config set prefix '~/.npm-global'
nano ~/.profile
add "export PATH=~/.npm-global/bin:$PATH"

npm install -g pm2

gpsportplaner's Issues

e2e testing

prevent "zoom on input focus" on safari

problem safari mobile:

• clicking on any input field on webkit will zoom in too much

revamp design

delete old db entries

Currently all bookings are stored in the bookings table and are never deleted.
ToDo: Backend cronjob / schedular within express that deletes all bookings older than ~1 month.

very low-prio, because the data size is very low (10_000 entries < 2 MB)

add favicon

i18n

• add i18n
• add english / german
• add language switcher to the sidebar

settings service

add persistent settings service (use ls)

improve password form

Problems:

• Password not hidden
  

• autocomplete (on mobile) should be disabled

• browser not remembering login

• not a submittable form (you cant hit ENTER and it submits the whole thing)

add checkboxes

• add a checkbox at the top of the add-booking screen "only show free slots"
  -> only shows slots that aren't booked by someone

• add a checkbox at the top of the overview-bookings screen "only show occupied slots"
  -> only shows slots that are booked by someone

after setting one of the two, set setting in settings service
load settings on init

can only be done after #9

add "edit-admin" feature

let admins change other admins data

complete admin tools

admins can:

• change all bookings
• change other admins data
• add/rm admins

test env

• test db
• test branch
• test autodeployment to test.url

local env will be hotwired to test db

add rules

add rules view

add browser support for login form

login form needs to use autocomplete and "Enter"-Key should log in.

let user change bookings

• add controller function
• add route /bookings/changeBooking body: oldbooking: {...} newbooking: {...}
• check if bookedBy in bookings == decodedJWTPayload.user
  problem: a user can just login as another user and change their booking (we don't care for now)

logging

log stuff to log collection

add darkmode