lavoweb / magento2-customreports
A Magento 2 module that allows an administrator to create reports in the admin panel. This is modeled after the Clean Reports module for Magento 1.
Installs: 71
Dependents: 0
Suggesters: 0
Security: 0
Stars: 1
Watchers: 2
Forks: 40
Type:magento2-module
This package is auto-updated.
Last update: 2024-10-17 02:32:03 UTC
README
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 had contributed to that project.
Description
Easily create reports with custom SQL queries and display them using the magento admin grid.
Disclaimer
This module has the potential to make irreversable changes to your database if set up incorrectly. Use at your own risk.
Features
- Report result table
- Usage of a read only database connection
- Column Filtering
- Column Sorting
- CSV Export
Adding a readonly user
#!php 'db' => array ( 'table_prefix' => '', 'connection' => array ( 'default' => array ( 'host' => '127.0.0.1', 'dbname' => 'database_name', 'username' => 'database_user', 'password' => 'database_password', 'model' => 'mysql4', 'engine' => 'innodb', 'initStatements' => 'SET NAMES utf8;', 'active' => '1', ), 'readonly' => array ( 'host' => '127.0.0.1', 'dbname' => 'database_name', 'username' => 'database_readonly_user', 'password' => 'database_readonly_password', 'model' => 'mysql4', 'engine' => 'innodb', 'initStatements' => 'SET NAMES utf8;', 'active' => '1', ), ), ), 'resource' => array ( 'default_setup' => array ('connection' => 'default'), 'readonly' => array('connection' => 'readonly') ),