This module was inspired by the Magento 1 extension for custom reports (https://github.com/kalenjordan/custom-reports). Thank you to Kalen Jordan and all who contributed to that project.
Easily create reports with custom SQL queries and display them using the Magento admin grid.
This module has the potential to make irreversible changes to your database if set up incorrectly. Use at your own risk.
- Report result table
- Usage of a read-only database connection
- Column filtering
- Column sorting
- CSV export
- Automated exports
A read-only database connection is a requirement for this module.
#!php
'db' => [
'table_prefix' => '',
'connection' => [
'default' => [
'host' => 'host_name',
'dbname' => 'database_name',
'username' => 'database_user',
'password' => 'database_password',
'model' => 'mysql4',
'engine' => 'innodb',
'initStatements' => 'SET NAMES utf8;',
'active' => '1',
'driver_options' => [
1014 => false,
],
],
'readonly' => [
'host' => 'host_name',
'dbname' => 'database_name',
'username' => 'database_readonly_user',
'password' => 'database_readonly_password',
'model' => 'mysql4',
'engine' => 'innodb',
'initStatements' => 'SET NAMES utf8;',
'active' => '1',
'driver_options' => [
1014 => false,
],
],
],
],
'resource' => [
'default_setup' => [
'connection' => 'default',
],
'readonly' => [
'connection' => 'readonly',
],
],