Download the PHP package ibekzod/visual-report-builder without Composer

On this page you can find all versions of the php package ibekzod/visual-report-builder. 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 ibekzod/visual-report-builder

Informations about the package visual-report-builder

Visual Report Builder

A complete, production-ready Laravel package for creating pivot tables, visual reports, and analytics dashboards with drag-and-drop template creation and template-based execution.

Features

Requirements

Installation

Step 1: Install via Composer

Step 2: Run Migrations

Step 3: Access the Dashboard

Navigate to your application:

The package auto-discovers your Eloquent models and is ready to use immediately.

Quick Start Guide

Creating Your First Report Template

  1. Go to http://yourapp.test/visual-reports
  2. Click the "Create Template" button in the header
  3. Select a data source (model) from the dropdown
  4. Drag dimension fields to the Row Dimensions or Column Dimensions zones
  5. Drag metric fields to the Metrics zone
  6. Click "Preview" to see the data
  7. Click "Save Template" and fill in the template details
  8. Your template now appears in the dashboard for all users

Executing Reports

  1. Go to http://yourapp.test/visual-reports (Dashboard)
  2. Select a template from the left sidebar
  3. Apply any filters in the filter panel
  4. Click "Run Report" to execute
  5. View results as table or chart
  6. Export to CSV, Excel, PDF, or JSON
  7. Save the report to your personal library

Architecture Overview

Two Complementary Workflows

Template Creation (Builder)

Template Execution (Dashboard)

Core Components

Services

Service Purpose
DataSourceManager Auto-discovers models, columns, and relationships using PHP Reflection
QueryBuilder Generates dynamic SQL with GROUP BY, aggregates, HAVING, and JOINs
TemplateExecutor Executes templates with user-selected filter values
PivotEngine Creates pivot table structures from flat query results
AggregateCalculator Computes sum, avg, min, max, count, count_distinct
FilterManager Applies dynamic filter conditions to queries
ExporterFactory Creates appropriate exporter for each format

Models

Model Purpose
ReportTemplate Template definition (model, dimensions, metrics, filters, category)
TemplateFilter Filter configurations with operators and default values
ReportResult Saved report executions with user-applied filters

Controllers

Controller Purpose
BuilderController Model discovery, relationships, template creation
TemplateController Template CRUD, execution, filtering, export
DashboardController Dashboard statistics and overview

Usage

Web Interface

The package provides two main views:

Dashboard (/visual-reports)

Builder (/visual-reports/builder)

PHP Code Usage

REST API

Template Endpoints

Builder Endpoints

Report Result Endpoints

Configuration

Publishing Configuration

Configuration Options

Edit config/visual-report-builder.php:

Environment Variables

Database Support

The package supports multiple database systems with automatic identifier quoting:

Database Quote Character Status
PostgreSQL " (double quotes) Fully supported
MySQL ` (backticks) Fully supported
MariaDB ` (backticks) Fully supported
SQLite " (double quotes) Fully supported
SQL Server " (double quotes) Fully supported

The package automatically detects the database driver and uses the appropriate quoting.

Aggregate Functions

Function Description SQL Generated
sum Total of all values SUM(column)
avg Average value AVG(column)
min Minimum value MIN(column)
max Maximum value MAX(column)
count Count of rows COUNT(column)
count_distinct Count of unique values COUNT(DISTINCT column)
value Raw value (no aggregation) column

Custom Model Configuration

Default Behavior (Auto-Discovery)

The package automatically discovers all Eloquent models and their columns:

Custom Dimensions and Metrics (Optional)

For fine-grained control over what appears in the builder:

Relationship Joins

The package automatically detects Eloquent relationships and allows joining related tables:

Supported relationship types:

Real-World Examples

Sales Report by Region and Month

Inventory Analysis

Customer Spending Analysis

User Activity Report

File Structure

Security

Troubleshooting

Models Not Appearing

  1. Verify models are in app/Models directory
  2. Check model namespace matches configuration
  3. Clear cache: php artisan cache:clear

Dimensions/Metrics Not Loading

  1. Verify the model's table exists in database
  2. Test model in tinker: App\Models\Order::first()
  3. Check browser console for JavaScript errors

Routes Returning 404

Export Not Working

Install optional dependencies:

SQL Errors

Optional Dependencies

Package Purpose Installation
maatwebsite/excel Excel export composer require maatwebsite/excel
barryvdh/laravel-dompdf PDF export composer require barryvdh/laravel-dompdf

Design Patterns

The package implements several design patterns:

API Response Format

All API endpoints return JSON with consistent format:

Success Response

Error Response

Contributing

Contributions are welcome. When adding features:

  1. Follow existing architecture patterns
  2. Keep services single-responsibility
  3. Add tests for new functionality
  4. Update this README for user-facing features
  5. Submit a pull request

License

MIT License - see LICENSE file for details.

Built for developers who want powerful reports without complexity.

All versions of visual-report-builder with dependencies

PHP Build Version
Package Version
Requires php Version ^8.0|^8.1|^8.2|^8.3|^8.4
laravel/framework Version ^8.0|^9.0|^10.0|^11.0|^12.0
maatwebsite/excel Version ^3.1|^4.0
barryvdh/laravel-dompdf Version ^1.0|^2.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 ibekzod/visual-report-builder contains the following files

Loading the files please wait ...