MongoDataSource

Introduction #

MongoDataSource helps you to connect to MongoDB to retrieve data. You need to install the MongoDB package.

Settings #

Nametypedefaultdescription
classstringMust set to '\koolreport\datasources\MongoDataSource'
connectionStringstringDefine connection string to MongoDB. If you use connectionString, you do not need to set properties host, username and password.
hoststringMongoDB host
usernamestringUsername
passwordstringPassword
databasestringThe name of database you want to connect

Example #

<?php
class MyReport extends \koolreport\KoolReport
{
    public function settings()
    {
        return array(
            "dataSources"=>array(
                "mongo_purchase"=>array(
                    "class"=>'\koolreport\mongodb\MongoDataSource',
                    "connectionString"=>"mongo://johndoe:secret_password@localhost:65432",
                    "database"=>"dbpurchase"
                ),
            )
        );
    }
    public function setup()
    {
        $this->src('mongo_purchase')
        ->query(array(
            'collection' => 'cPurchases',
            'find' => ['age' => ['$gte' => '40']],
            'options' => [
                'skip' => 0,
                'limit' => 5,
                'projection' => [
                    '_id' => 0,
                    'name' => 1,
                    'age' => 1,
                ],    
            ],
        ))
        ->pipe(..)
        ->pipe(...)
        ...
        ->pipe($this->dataStore('mongo_purchases'));
    }
}

Get started with KoolReport

KoolReport will help you to construct good php data report by gathering your data from multiple sources, transforming them into valuable insights, and finally visualizing them in stunning charts and graphs.