Download the PHP package vulpecula-io/laravel-datum without Composer

Datum recording data and aggregations for dashboards

This leans heavily on the Laravel Pulse package for the general idea of how to obtain and process the data, but it's reworked to provide alternative and longer periods and be frontend agnostic. There is no interface built in - that's for you to do and put together, but the base functionality of aggregating data and pulling the data is there for you to use.

Installation

You can install the package via composer:

You can publish and run the migrations with:

You can publish the config file with:

This is the contents of the published config file:

Recorders

Just as in Laravel Pulse, you need to create your own custom recorders to handle the data 'acquisition'. You can review the code of Pulse to see some examples of how to write a custom recorder here.

[!NOTE]
It's important to remember that the recorder should only 'fired' when the data is not going to change or if it makes no difference that it appears multiple times in the data aggregators.

[!TIP] Example: if you're recording turnover based on an Invoice model you need to ensure that you fire the associated recorder only when the invoice is no longer going to be edited/changed, otherwise the turnover will be recorded multiple times and provide an incorrect value for any graphs/aggregators obtained later.

Registering the recorder

Once you have a custom recorder you need to add it to the recorders array in the config file. The key is the class name of the recorder and the value is an array of configuration options. The only required option is enabled which is a boolean value to determine if the recorder should be used or not. The other options are optional and are passed to the recorder's constructor.

Like the standard recorders of Laravel Pulse you can pass a sample_rate or an array of items to ignore. The sample_rate is a number between 0 and 1 that determines the percentage of requests that should be recorded. The ignore option is an array of regular expressions that will be matched. If the item matches any of the regular expressions the recorder will not be used.

Period enum

The Period enum is used to determine the intervals to use for the data. The enum is as follows:

• Period::HOUR - single hour interval split in 60 minute intervals
• Period::SIXHOUR - six hour interval split in 12 half hour intervals
• Period::HALFDAY - twelve hour interval split in 24 half hour intervals
• Period::DAY - single day interval split in 24 hour intervals
• Period::WEEK - standard weekly interval split in 7 day intervals
• Period::MONTH - standard monthly interval split in daily intervals (depending on the numnber of days in the month: CarbonImmutable::now()->daysInMonth is used)
• Period::QUARTER - standard quarterly interval split in (int) CarbonImmutable::now()->daysInYear / 4 (~91 days) intervals
• Period::HALFYEAR - six-month interval split in 6-month intervals
• Period::YEAR - standard yearly interval split in 12-month intervals

If you want to use the Period enum in your own code you can import it with use Vulpecula\Datum\Enums\Period;. There is a label() function which will return the label for the enum value. For example Period::HOUR->label() will return Hour. There is a language file available that can be published using:

Furthermore, you can get an array of all the Period enum values and their corresponding labels using the following:

This is useful if you want to provide a dropdown of the available periods for the user to select.

Getting the data out

Once the data is in the database you'll want to display it on the dashboard (or anywhere else you want to use it).

There are two primary functions available: graph() and aggregate().

graph()

The graph() function will return a Collection of data that can be used to graph the data. The function takes 3 parameters:

• array $types - An array of the types of data you want to graph. The types are the type column of the datum tables and are set in the recorders.
• string $aggregate - The aggregate function to use. This can be any of the standard SQL aggregate functions: count, sum, avg, min, max.
• Period $interval - The interval to use for the data (see above for the available intervals).

This will return a Collection of objects one for user_created and one for user_deleted. Each object will be its own collection of objects with the key for each object the distinct keys in the database that have been recorded against the types. The value of the collection will be (in this example) an array of 24 elements with each having the timestamp of the start of the hour and the count of the number of records for that hour.

aggregate()

The aggregate() function will return a Collection of data that can be used to display the data in a table. The function requires 3 parameters:

• string $type - The type of data you want to aggregate. The type is the type column of the datum tables and is set in the recorders.
• array|string $aggregates - The aggregate function(s) to use. This can be any of the standard SQL aggregate functions: count, sum, avg, min, max. If you want to use multiple aggregate functions you can pass an array of the functions.
• Period $interval - The interval to use for the data (see above for the available intervals).

Optional parameters are:

• ?string $orderBy - The column to order the results by. The default is key.
• string $direction - The direction to order the results by. The default is desc.
• int $limit - The number of results to return. The default is 101 which will return all results.

Testing

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

• Richard Browne
• All Contributors

License

The MIT License (MIT). Please see License File for more information.