Download the PHP package masugadesign/labreports without Composer

On this page you can find all versions of the php package masugadesign/labreports. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of masugadesign/labreports

Informations about the package labreports

Lab Reports for Craft CMS

Table of Contents

Requirements

Installation

Add the following to your composer.json requirements. Be sure to adjust the version number to match the version you wish to install.

Configuration

To customize your Lab Reports configuration, create a labreports.php file in your Craft config folder. To start, you may copy the contents of theconfig.php file included in the plugin's src folder.

Lab Reports has the following config options:

debug

Set debug to true to enable some advanced plugin logging. This can assist in diagnosing issues with configuring/running reports.

fileStorageFolder

Specify a full system path to a writable folder without a trailing slash. Lab Reports will store the generated report files there. Do not include this item in the plugin config file if you do not wish to override the default location which is a "labreports" subfolder in the Craft storage folder.

functions

This is the array of PHP formatting functions used by the advanced reports.

Debugging

Lab Reports writes most errors/exceptions to the storage/logs/labreports.log file. In some cases, some errors may bypass that log and Craft will write them to the web.log or queue.log files.

When the Lab Reports debug configuration option is enabled, the plugin logs additional information. Each debug log line is prefixed with [DEBUG].

Errors/Exceptions that occur during the report build process are stored in the Report element's statusMessage property. The value is displayed on the Report detail page in the control panel. Any report build that results in an "error" status should have a statusMessage value which may be helpful in diagnosing issues with the report template or configuration.

Basic Reports

The basic report is a template-based report geared towards smaller data exports (< 3000 rows). These reports load the entire query result into memory at once when generating the CSV export.

Configure

To configure a basic report, click the "New Report" button from the main Lab Reports page in the Craft control panel. On the form, choose "Basic" as the report Type. Enter a Title, a Description (optional) and a relative path to a Template in your main Craft templates folder. Click the "Create" button.

As an example, we will create a basic report that exports some entry metadata. The report template might look something like the following:

The report variable is automatically defined in the template. It contains a Lab Reports Report element instance.

Advanced Reports

The advanced report is a template-based report geared towards larger data exports (>= 3000 rows) with a lot of columns and/or relationships. These reports allow for a developer to define a Query (not executed) as well as a PHP formatting function that should be applied to all the query results behind-the-scenes when the plugin is constructing the report file.

Formatting Functions

The PHP formatting functions should be defined in the labreports.php config file's functions array. Each function must accept one parameter. The value of the parameter is a Craft Element of whatever type your report is centered around. The name of the variable does not matter. The function must return a single array which represents one row in the report. Pay careful attention to the order of each item in the array because it will need to match the order of the column names that you define in the report template.

If you aren't accustomed to coding with PHP, here are some Twig-to-PHP examples that may help you:

Plain Text / Rich Text / Number

Relationship Field (not eager-loaded)

Relationship Field (eager-loaded)

These examples use NULL coalescing operators in case the eager-loaded relationship field has no value.

Date/Time Field

Dropdown/Radio Fields

Checkbox Fields

The "use" statement should be placed at the top of your labreports.php file.

Configure

To configure an advanced report, click the "New Report" button from the main Lab Reports page in the Craft control panel. On the form, choose "Advanced" as the report Type. Enter a Title, a Description (optional), a relative path to a Template in your main Craft templates folder and a Formatting Function Name. Click the "Create" button.

As an example, we will create an advanced report that exports some entry metadata along with some relationship data. Keep in mind the formatting function is saved to the Configured Report element record and does not appear anywhere in the report template. The report template might look something like the following:

Like basic reports, the report variable is automatically defined in the template and contains a Lab Reports Report element instance.

Running Reports

Reports can be generated in multiple ways.

From the Control Panel

In the Configured Reports tab of the Lab Reports control panel area, each configured report has a "Run" link column. Click that button link to generate a new report. Reports can also be generated by clicking the "Run" button from a single configured report's control panel edit form.

Console Command

Another way to generate a new report is to use a console command. Commands like the following example can be set to run periodically via a cron job. Each configured report is a Craft element and has a unique ID, just like any other element. Pass that ID to the command using the reportId option.

Cron Job

Console commands like the example above can be run periodically via cron job. If you plan to schedule a report routine, it would be best to configure Craft to execute the queue via a cron job as well. To do this, add the following line to your general.php config file's array:

That setting will disable Craft's default behavior of executing queue jobs when there is activity in the control panel. Then create the following cron job on the server. Be sure to update the paths accordingly.

Without this configuration in place, queued reports will not run unless someone logs into the control panel.

Template Variables

The following template variables are available for use:

craft.labreports.configuredReports

Query Lab Reports ConfiguredReport elements by the following criteria:

craft.labreports.generatedReports

Query Lab Reports Report elements by the following criteria:

craft.labreports.formatFunctionNames

This template variable returns an array of all the defined PHP formatting function names.

craft.labreports.formatFunctionOptions

This template variable returns an associative array of PHP formatting function HTML select options, including an empty option. This is used by the plugin in the control panel and may not be very useful outside of that context, but hey, it is available.

Element Properties & Methods

ConfiguredReport

These public properties and methods are available on the ConfiguredReport elements.

Properties

The following properties and methods are publicly on ConfiguredReport element objects.

reportTitle

Note that it is not just "title". This element type does not make use of Craft's native titles.

reportType

The value will either be "basic" or "advanced".

reportDescription

The brief description of the report.

template

This value is populated with a relative path to the report template.

formatFunction

This value contains the name of the PHP format function used if the ConfiguredReport is an advanced report.

Methods

getRunUrl()

This method returns the control panel "run" URL for the ConfiguredReport. Note that the returned URL will not work for users that do not have permission to access the plugin in the control panel.

getCpEditUrl()

This method returns the control panel edit form URL.

getTotalRan()

This method returns the total number of times reports have been generated from this configuration.

Report

These public properties and methods are available on the Report (generated report) elements.

Properties

configuredReportId

The related ConfiguredReport element ID.

filename

The filename of the generated report file.

totalRows

The total number of rows that were written to the report file.

dateGenerated

The full UTC date/time that the report file was generated.

reportStatus

The status label of the generated report. The value may be in_progress or finished.

statusMessage

A textual status message that may be populated when errors occur.

userId

The ID of the user that generated the report.

Methods

build($param1, $param2)

This generates the report file. The method parameters vary based on the Report Type. For basic reports, provide a single array of column headers/labels nested within another array. For advanced reports, provide a single array (not nested in another array) of column headers/labels followed by the Query object.

addRows(array $rows)

Provide an array or report row arrays to write them to the report file.

addRow(array $row)

Provide a single report row array to be written to the report file.

filePath()

This method returns the full system file path to the report file whether or not the file actually exists.

fileExists()

This method returns a boolean true/false denoting whether or not the report file exists.

setUser(User $user)

This method sets the report's author to a specified User element.

getUser()

This method returns the report's author User element or null if there isn't one.

setConfiguredReport(ConfiguredReport $cr)

This method sets the ConfiguredReport object on the Report element. This governs which configuration will be used when building the report file.

getConfiguredReport()

This method returns the report's related ConfiguredReport or null if there isn't one.

setQueueJob(GenerateReport $job)

This method sets the report's queue job so it can update the progress of the job while building the report.

updateStatus($status)

This method updates the report's status to a given string (in_progress|finished) then saves the Report element.

getStatusLabel()

This returns the status label of the report otherwise null if it doesn't have one. The possible values are In Progress|Finished

getDownloadUrl()

This method returns the control panel download URL string for the report file. Note that this URL will not work for users that do not have control panel access.

Planned Features

All versions of labreports with dependencies

PHP Build Version
Package Version
Requires craftcms/cms Version ^5.0.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package masugadesign/labreports contains the following files

Loading the files please wait ....