Introduction

This package allows you to connect and get data from MongoDB.

Installation

By downloading .zip file

Download
Unzip the zip file
Copy the folder mongodb into koolreport folder so that look like below

koolreport
├── core
├── mongodb

By composer

composer require koolreport/mongodb

Documentation

Settings

Name	type	description
class	string	Must set to `'\koolreport\mongodb\MongoDataSource'`
connectionString	string	Define connection string to MongoDB. If you use connectionString, you do not need to use properties host, username and password.
host	string	MongoDB host
username	string	Username
password	string	Password
database	string	The 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'));
    }
}

Support

Please use our forum if you need support, by this way other people can benefit as well. If the support request need privacy, you may send email to us at support@koolreport.com.