PHP code example of owlookit / quickrep

1. Go to this page and download the library: Download owlookit/quickrep library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

owlookit / quickrep example snippets


'quickrep_config' => [
    'driver' => 'pgsql',
    'host' => env('APPAPI_DB_HOST', env('DB_HOST')),
    'port' => env('APPAPI_DB_PORT', env('DB_PORT', 5432)),
    'database' => env('APPAPI_DB_DATABASE', env('DB_DATABASE')),
    'username' => env('APPAPI_DB_USERNAME', env('DB_USERNAME')),
    'password' => env('APPAPI_DB_PASSWORD', env('DB_PASSWORD')),
    'charset' => 'utf8',
    'prefix' => '',
    'prefix_indexes' => true,
    'schema' => 'public',
    'options' => extension_loaded('pdo_pgsql') ? [
        PDO::ATTR_EMULATE_PREPARES => true,
    ] : [],
],


PDO::ATTR_EMULATE_PREPARES => true


public function GetSQL()
{
    return DB::connection(quickrep_source_db())
        ->table('mv_school_activity')
        ->select(['school_id', 'active_users', 'total_visits']);
}


$this->getSocket('someWrenchName');

bash
php artisan config:clear
php artisan cache:clear

bash
php artisan migrate

bash
php artisan quickrep:make_tabular YourNewReportName

bash
php artisan route:list | grep Quickrep

bash
php artisan quickrep:make_tabular YourNewReportName

bash
composer update owlookit/quickrep
php artisan quickrep:install