esfroglatt/pepe

Overview

React based web app to view and report on production orders from Microsoft Dynamics BC.

Requires a Postgres DB. An https proxy is also required for AD authentication, and a script is used to send data reported in PEpE back to BC.

Adminer (or similar) is optional for DB management.

Compose Example

yml

# Example compose stack
# For multiple instances port mappings must be adjusted
# as well as any stack specific URLs and auth tokens.

# The versions of the pepe and cron containers must be updated
# in the compose files when new builds are pushed.

version: '3.7'

services:
  proxy:
    image: nginx:latest
    container_name: pepe-proxy
    restart: unless-stopped
    ports:
      - "3001:443" # HTTPS-ONLY
    volumes:
      - ./nginx.conf:/etc/nginx/nginx.conf
      - ./certs:/etc/nginx/certs
    depends_on:
      - web

  web:
    image: esfroglatt/pepe:<version>
    container_name: pepe-app
    depends_on:
      - db
    ports:
      - "3010:3000" # HTTP-ONLY
    restart: unless-stopped
    environment:
      # DO NOT CHANGE THIS VALUE
      - DATABASE_URL=postgres://postgres:pepe@db:5432/pepe?schema=public
      # Change these URLs to correspond to the BC instance this Pepe stack should connect to
      # The URLs can be found in BC under Web Services / Webdienste
      - BC_API_ENDPOINT=
      - BC_FEEDBACK_URL=
      - BC_PRODUCTION_DISRUPTION_URL=
      # Name which gets specified in the disruption report "userTaskGroupAssignedTo"
      - DISRUPTION_GROUP=
      # These are always the same between stacks, but in general subject to change
      - BC_AUTH_USERNAME=
      - BC_AUTH_PASSWORD=
      # Grab a new API Key for each stack. A normal UUID works for this purpose.
      - API_KEY=
      # On Premise Active Directory Server
      - LDAP_URI=
      # This URI should be changed to the domain under which the app is later published, eg. https://local.domain.pepe
      # The same URL must be entered in the Azure AD App Admin portal, as the AD auth service checks against this URL (and port).
      - NEXTAUTH_URL=
      # generate new secret with openssl `openssl rand -base64 44` and copy here
      - NEXTAUTH_SECRET=
      # The Azure AD IDs and Secret must be generated in the AD App Admin portal (IT Department)
      - AZURE_AD_CLIENT_ID=
      - AZURE_AD_TENANT_ID=
      - AZURE_AD_CLIENT_SECRET=

  db:
    image: postgres:latest
    container_name: pepe-db
    restart: unless-stopped
    environment:
      - POSTGRES_PASSWORD=pepe
      - POSTGRES_DB=pepe
      - PGDATA=/var/lib/postgresql/pgdata
    ports:
      - "59003:5432" # DO NOT OPEN THIS PORT TO THE INTERNET
    volumes:
      - db:/var/lib/postgresql/pgdata

  adminer:
    image: adminer:latest
    container_name: pepe-adminer
    restart: unless-stopped
    ports:
      - "59004:8080" # DO NOT OPEN THIS PORT TO THE INTERNET

  cron:
    image: esfroglatt/pepe-cron:<version>
    container_name: pepe-cron

volumes:
  db:

networks:
  default:
    name: pepe-network