version: '3'

services:
  php:
    build: .
    ports:
      - "3000:3000"
      - "443:443"
    volumes:
      - ./:/var/www/html
    environment:
      - DATABASE_URL=mysql://user:password@db_host:3306/database_name?charset=utf8mb4&serverVersion=5.7
      - APACHE_SERVERNAME=localhost
  novosga:
    image: novosga/novosga:latest
    restart: unless-stopped
    depends_on:
      - mysqldb
    ports:
      - "80:80"
      - "2020:2020"
    environment:
      APP_ENV: 'prod'
      # database connection
      DATABASE_URL: 'mysql://novosga:MySQL_App_P4ssw0rd!@mysqldb:3306/novosga2?charset=utf8mb4&serverVersion=5.7'
      # default admin user
      NOVOSGA_ADMIN_USERNAME: 'admin'
      NOVOSGA_ADMIN_PASSWORD: '123456'
      NOVOSGA_ADMIN_FIRSTNAME: 'Administrator'
      NOVOSGA_ADMIN_LASTNAME: 'Global'
      # default unity
      NOVOSGA_UNITY_NAME: 'My Unity'
      NOVOSGA_UNITY_CODE: 'U01'
      # default no-priority
      NOVOSGA_NOPRIORITY_NAME: 'Normal'
      NOVOSGA_NOPRIORITY_DESCRIPTION: 'Normal service'
      # default priority
      NOVOSGA_PRIORITY_NAME: 'Priority'
      NOVOSGA_PRIORITY_DESCRIPTION: 'Priority service'
      # default place
      NOVOSGA_PLACE_NAME: 'Box'
      # Set TimeZone and locale
      TZ: 'America/Sao_Paulo'
      LANGUAGE: 'pt_BR'
  mysqldb:
    image: mysql:5.7
    restart: always
    environment:      
      MYSQL_USER: 'novosga'
      MYSQL_DATABASE: 'novosga2'
      MYSQL_ROOT_PASSWORD: 'MySQL_r00t_P4ssW0rd!'
      MYSQL_PASSWORD: 'MySQL_App_P4ssw0rd!'
      # Set TimeZone
      TZ: 'America/Sao_Paulo'
    command: >
      /bin/bash -c "chmod -R 775 /var/www/html/novosga &&
                    chown -R www-data:www-data /var/www/html/novosga &&
                    apachectl restart &&
                    mysqld_safe &&
                    apachectl -D FOREGROUND"