Configuration files are located in
First, specify which database you want to use. Laravel supports various engines (SQLite, MySQL, PostgreSQL, SQL Server). You can specify which database you want to use with
config/database.php and the related environment variables. To learn more, refer to the Laravel documentation.
When you've set the database engine, create the application tables with the following command:
php artisan migrate
You can create the schema and generate dummy data with the following command:
php artisan migrate:fresh --seed
.env specific to the app, you should file the following variables:
APP_NAME: The name of the application. By default this is
APP_ENV: The application environment. You can set values like
APP_DEBUG: Enable (
true) or disable (
APP_URL: The base URL of the web application.
APP_LOCALE: The locale to use for the application. Use
enfor English or
PROJECTS_CONFIG_FILENAME: the filename used to define your projects in the
configfolder. Will likely be set to
REPORT_TIMEZONE: The timezone to use for reports. Use a timezone name from the IANA database like Europe/Paris.
REPORT_COUNTRY_CODE: The 2-letter ISO country code to use to determine bank holidays. Useful to send reminders on the last working day of the week.
REPORT_EMAIL: To which email address should weekly reports be sent to. Example:
REPORT_SECRET: The password to see previous reports in the web interface.
REPORTS_PASSWORD_HINT: An hint to guess the password of the web interface. If you don't want to provide an hint, leave it null.
SLACK_TOKEN: The Slack token to use when calling the API.
SLACK_GENERAL_CHANNEL: A Slack channel name where a reminder to fill the reports will be posted on Fridays at 10 AM. Example: #general
In order to send the weekly bulletins by email, you'll need to specify which SMTP server to use.
To do so, fill all the environment variables starting with
MAIL_ in the
Creating a Slack application
If you're using Slack, you can send reminders to fill the reports to a channel or to individual people.
To do so, you will need to create a Slack app. The required permissions are
chat:write:bot. Write down the OAuth Access Token and put the value in the
SLACK_TOKEN variable of the
In order to remind people to fill reports or to send the weekly email, we need scheduled tasks. These tasks have already been scheduled, you need to execute them. You can follow Laravel's documentation and put this in your crontab:
* * * * * cd /path-to-your-project && php artisan schedule:run >> /dev/null 2>&1
This Cron will call the Laravel command scheduler every minute. When the schedule:run` command is executed, Laravel will evaluate your scheduled tasks and runs the tasks that are due.
You can define your various teams / projects in the
config folder in a YAML file. We provide a sample file in
config/projects.example.yml that you can copy at
config/projects.yml for instance. Update the environment variable
PROJECTS_CONFIG_FILENAME according to the filename you choose.
Here is what it looks like:
- name: "Example project" notification: slack logo: images/logos/example.png members: - UEMA8DE9Y - UEN897F5U - name: "Bar" notification: email logo: images/logos/bar.png members: - email@example.com
You can mix reminders by email or Slack on a project basis.