lavoweb/magento2-customreports 1.1.2

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.

Type

magento2-module

License

OSL-3.0, AFL-3.0

Requires
Requires (dev)

None

Suggests

None

Provides

None

Conflicts

None

Replaces

None

DEG Custom Reports

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

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')
        ),