All Projects → koolphp → Koolreport

koolphp / Koolreport

Licence: mit
This is an Open Source PHP Reporting Framework which you can use to write perfect data reports or to construct awesome dashboards using PHP

Projects that are alternatives of or similar to Koolreport

Qxorm
QxOrm library - C++ Qt ORM (Object Relational Mapping) and ODM (Object Document Mapper) library - Official repository
Stars: ✭ 176 (-13.73%)
Mutual labels:  oracle, mysql, mongodb, postgresql, sqlserver
Zxw.framework.netcore
基于EF Core的Code First模式的DotNetCore快速开发框架,其中包括DBContext、IOC组件autofac和AspectCore.Injector、代码生成器(也支持DB First)、基于AspectCore的memcache和Redis缓存组件,以及基于ICanPay的支付库和一些日常用的方法和扩展,比如批量插入、更新、删除以及触发器支持,当然还有demo。欢迎提交各种建议、意见和pr~
Stars: ✭ 691 (+238.73%)
Mutual labels:  oracle, mysql, mongodb, postgresql, sqlserver
Helicalinsight
Helical Insight software is world’s first Open Source Business Intelligence framework which helps you to make sense out of your data and make well informed decisions.
Stars: ✭ 214 (+4.9%)
Mutual labels:  reporting, mysql, mongodb, postgresql, data-visualization
Yiigo
🔥 Go 轻量级开发通用库 🚀🚀🚀
Stars: ✭ 304 (+49.02%)
Mutual labels:  mysql, mongodb, postgresql, framework
Servicestack.ormlite
Fast, Simple, Typed ORM for .NET
Stars: ✭ 1,532 (+650.98%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Jsqlparser
JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
Stars: ✭ 3,405 (+1569.12%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Symmetric Ds
SymmetricDS is a database and file synchronization solution that is platform-independent, web-enabled, and database agnostic. SymmetricDS was built to make data replication across two to tens of thousands of databases and file systems fast, easy and resilient. We specialize in near real time, bi-directional data replication across large node networks over the WAN or LAN.
Stars: ✭ 450 (+120.59%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Jooq
jOOQ is the best way to write SQL in Java
Stars: ✭ 4,695 (+2201.47%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Antdata.orm
特色:vs插件或者t4一键生成entity 支持配置非物理外键。分离linq转sql引擎(原生linq非扩展)和执行dal功能,支持异步,支持netcore2.0
Stars: ✭ 428 (+109.8%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Kangaroo
SQL client and admin tool for popular databases
Stars: ✭ 127 (-37.75%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Blog
Everything about database,business.(Most for PostgreSQL).
Stars: ✭ 6,330 (+3002.94%)
Mutual labels:  oracle, mysql, mongodb, postgresql
Metabase
The simplest, fastest way to get business intelligence and analytics to everyone in your company 😋
Stars: ✭ 26,803 (+13038.73%)
Mutual labels:  reporting, mysql, postgresql, data-visualization
Freesql
🦄 .NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, Click house orm, MsAccess orm.
Stars: ✭ 3,077 (+1408.33%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Chartbrew
Open-source web platform for creating charts out of different data sources (databases and APIs) 📈📊
Stars: ✭ 199 (-2.45%)
Mutual labels:  mysql, mongodb, postgresql, data-visualization
Adminer Custom
Customizations for Adminer, the best database management tool written in PHP.
Stars: ✭ 99 (-51.47%)
Mutual labels:  oracle, mysql, mongodb, postgresql
Typeorm
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Stars: ✭ 26,559 (+12919.12%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Smartsql
SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
Stars: ✭ 775 (+279.9%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Csv2db
The CSV to database command line loader
Stars: ✭ 102 (-50%)
Mutual labels:  oracle, mysql, postgresql, sqlserver
Datax
DataX is an open source universal ETL tool that support Cassandra, ClickHouse, DBF, Hive, InfluxDB, Kudu, MySQL, Oracle, Presto(Trino), PostgreSQL, SQL Server
Stars: ✭ 116 (-43.14%)
Mutual labels:  oracle, mysql, sqlserver
Directus
Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.
Stars: ✭ 13,190 (+6365.69%)
Mutual labels:  oracle, mysql, postgresql

Notice: Change Repository

Starting from June 2019, we continue to support KoolReport at new repository https://github.com/koolreport/core. To install the latest KoolReport version, please use

composer require koolreport/core

Thank you very much!

KoolReport

KoolReport is an intuitive and flexible Open-Source PHP Reporting Framework for faster and easier report delivery. It gives you full control of data process as well as data visualization. It is fast, simple and can be extended in many ways.

View examples

Features

  1. Various datasources including relational database MySQL, SQL Server, Oracle or NoSQL like MongoDB, CSV or Excel files.
  2. Various data processes: data transformation, join, group, filter and etc.
  3. Awesome visualization through widgets charts and tables.
  4. Extended packages can be found at KoolReport Extended Packages

Changelog

Get started

You can either clone our project or download directly from KoolReport Download.

If you use composer, you can run following command to install the latest version

$ composer require koolphp/koolreport

What's included

koolreport/
├── packages/
├── src/
│   ├── clients/
│   ├── core/
│   ├── datasources/
│   ├── processes/
│   └── widgets/
├── tests/
└── autoload.php

System Requirement

  1. PHP 5.4 or higher

Installation

Copy the folder koolreport into your project and it is ready to run. You can start creating report.

Create your first report

Make two files SalesByCustomer.php and SalesByCustomer.view.php

/
├── koolreport/
├── SalesByCustomer.php
├── SalesByCustomer.view.php
└── index.php

index.php

<?php
// index.php: Just a bootstrap file
require_once "SalesByCustomer.php";

$salesByCustomer = new SalesByCustomer;
$salesByCustomer->run()->render();

SalesByCustomer.php

<?php
require_once "../koolreport/autoload.php";

//Specify some data processes that will be used to process
use \koolreport\processes\Group;
use \koolreport\processes\Sort;
use \koolreport\processes\Limit;

//Define the class
class SalesByCustomer extends \koolreport\KoolReport
{    
    protected function settings()
    {
        //Define the "sales" data source which is the orders.csv 
        return array(
            "dataSources"=>array(
                "sales"=>array(
                    "class"=>'\koolreport\datasources\CSVDataSource',
                    "filePath"=>"orders.csv",
                ),        
            )
        );
    }
  
    protected function setup()
    {
        //Select the data source then pipe data through various process
        //until it reach the end which is the dataStore named "sales_by_customer".
        $this->src('sales')
        ->pipe(new Group(array(
            "by"=>"customerName",
            "sum"=>"dollar_sales"
        )))
        ->pipe(new Sort(array(
            "dollar_sales"=>"desc"
        )))
        ->pipe(new Limit(array(10)))
        ->pipe($this->dataStore('sales_by_customer'));
    }
}

SalesByCustomer.view.php

<?php 
    use \koolreport\widgets\koolphp\Table;
    use \koolreport\widgets\google\BarChart;
?>

<div class="report-content">
    <div class="text-center">
        <h1>Sales By Customer</h1>
        <p class="lead">This report shows top 10 sales by customer</p>
    </div>

    <?php
    BarChart::create(array(
        "dataStore"=>$this->dataStore('sales_by_customer'),
        "width"=>"100%",
        "height"=>"500px",
        "columns"=>array(
            "customerName"=>array(
                "label"=>"Customer"
            ),
            "dollar_sales"=>array(
                "type"=>"number",
                "label"=>"Amount",
                "prefix"=>"$",
                "emphasis"=>true
            )
        ),
        "options"=>array(
            "title"=>"Sales By Customer",
        )
    ));
    ?>
    <?php
    Table::create(array(
        "dataStore"=>$this->dataStore('sales_by_customer'),
            "columns"=>array(
                "customerName"=>array(
                    "label"=>"Customer"
                ),
                "dollar_sales"=>array(
                    "type"=>"number",
                    "label"=>"Amount",
                    "prefix"=>"$",
                )
            ),
        "cssClass"=>array(
            "table"=>"table table-hover table-bordered"
        )
    ));
    ?>
</div>

You may download the source code sale_report.zip. And the result of this report can be previewed in here.

More examples

  1. Products vs Quarters
  2. Export To PDF
  3. DrillDown Report
  4. Pivot Table

.. and all examples.

Licenses

The KoolReport is licensed under MIT License.

Extended packages:

  • Laravel: Make KoolReport work seamlessly in Laravel PHP Framework [Free]
  • CodeIgniter: Make KoolReport work seamlessly in CodeIgniter Framework [Free]
  • MongoDB: Build report from MongoDB [Free]
  • CleanData: Solution for your missing data [Free]
  • QueryBuilder: Build fast and error-free SQL Query for your report [Free]
  • Instant: Create widget instantly without setting up a full report [Free]
  • Cache: Drive the speed and responsiveness of your report to the max [Free]
  • Statistics: Provide various statistical measures for your data [Free]
  • Bootstrap3: Create beautiful report with Bootstrap 3 [Free]
  • Bootstrap4: Create modern report with Bootstrap 4 [Free]
  • CloudExport: Export your report to PDF, JPG, PNG and other formats using cloud services [Free]
  • Excel: Import and export data to Excel [$29]
  • Cube: Turn your data into two dimensions cross-tab table [$19]
  • Pivot: Build multi-dimenstional pivot table [$49]
  • Export: Export your report to PDF, JPG, PNG and other formats [$29]
  • Morris Chart: Use morris charts in your report [$9]
  • Inputs: A simplest way to build dynamic reports [$29]
  • BarCode: Generate BarCode and QRCode [$9]
  • Sparklines: Create tiny charts [$9]
  • DataGrid: Display data in table format, search, sort, group data and more.. [$19]
  • DrillDown: Build awesome drill-down, drill-through report easily [$29]
  • ChartJS: One of the most beautiful and powerful chart libraries for your report [$29]

KoolReport Pro

KoolReport Pro is the most advanced version of KoolReport. It includes latest KoolReport version plus all available advanced packages from KoolPHP Inc. It costs $129 for Developer License and $349 for Enterprise License. The licenses come with following benefits:

  1. Include all current package and future ones.
  2. Deploying on unlimited servers or projects.
  3. Royal free (no extra charged) when you delivered the KoolReport Pro with your commercial product.
  4. 1 year subscription to get free upgrades, bugs fixed and new released packages regardless price.
  5. 1 year priority support on forum. Your post will be marked with star and got fatest response by our expert.
  6. Enterprise License allows unlimited number of developers in organization.
  7. 50% discount on the next subscription.

If you have further inquiry on this special version, please go to our forum or email us at [email protected]. We will get back to you in no time.

Some thoughts

KoolReport is the sum of our many years experience in making reports for our customers. We hope that it will help you to create powerful report with less effort. We love KoolReport very much and want it to be alive. We hope that you do too.

Being alive means that the source code continues to evolve, more features are added, and everything is back with professional support.

Please consider your purchase of extended packages or subscription as your donation. In exchange, we would like to send you gifts which are extensions or support services. By this way, we together contribute to the existence of KoolReport.

Our vision

"If you want to go fast, go alone. If you want to grow far, go together" - African Proverb

We have learned above statement through years of software development. We choose open-source as software model for KoolReport because we understand that:

  1. Alone, we never keep up with all time-changing needs
  2. Alone, we never have enough man power to serve well.

That's why we designed KoolReport to be simple and extensible. Simple to use and extensible for change. We would like to grow it to be a solid framework supported by market of packages providing various datasources, data processes, visualization widgets and report templates where users can find solution right away.

KoolReport wants to be foundation or ecosystem connecting people who need reporting solution and those who can provide it. All are invited to join us on market to provide excellent solutions. We believe people willing to pay for a good solution. And we are happy to share market and profit.

Vision are big, we take the first step. Join us!

To-do-list

Below are the things we are going to do:

  1. Evolve the structure of KoolReport and its functionalities
  2. Build market to push
    1. Connection to various datasources
    2. Data processing focus on: data cleaning, data analytics, data mining techniques
    3. More widgets to visualize data
  3. Build GUI for non-technical users
  4. Build ecosystem to handle big-data

Author

  1. KoolPHP Inc - A vendor of PHP components
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].