How to implement MongoDB query in Laravel 5?

Question

I created mongodb query which I have to use in laravel controller.

My query is

db.PMS.aggregate([
    { $match: { "PanelID": "A00898" } },
    { 
        $project: { EventTS: 1, MainsPower: 1, } 
    },
    {
        $unwind: {
            path: "$MainsPower",
            includeArrayIndex: "arrayIndex",
            preserveNullAndEmptyArrays: true
        }
    },
    {
        $project: {
            MainsPower: 1,
            timestamp: {
                "$add": [
                    "$EventTS",
                    { "$multiply": [ 60000, "$arrayIndex" ] }
                ]
            }
        }
    }
]);

I tried to use this query in a laravel function but I am little confused. Please help me how to implement this query in laravel.

chridam · Accepted Answer · 2016-06-09 09:04:54Z

1

Perform raw expressions on the internal MongoCollection object to run the aggregation:

$result = DB => collection('PMS')->raw(function ($collection){
    return $collection->aggregate(array(
        array( '$match' => array( "PanelID" => "A00898" ) ),
        array( '$project' => array( 'EventTS' => 1, 'MainsPower' => 1 ) ),
        array(
            '$unwind' => array(
                'path' => "$MainsPower",
                'includeArrayIndex' => "arrayIndex",
                'preserveNullAndEmptyArrays' => true
            )
        ),
        array(
            '$project' => array(
                '_id' => 0,
                'MainsPower' => 1,
                'timestamp' => array(
                    "$add" => array(
                        "$EventTS",
                        array( "$multiply" => array( 60000, "$arrayIndex" ) )
                    )
                )
            )
        )
    ));
});

edited Jun 9, 2016 at 9:04

answered Jun 9, 2016 at 8:20

chridam

104k26 gold badges246 silver badges243 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

sandip kakade Over a year ago

query output in object format how to convert in to array

chridam Over a year ago

@dhanashri Since the original problem is solved, can you create a new question for this issue please?

sandip kakade Over a year ago

ok but last question related to this question i want remove _id, So where i put _id:0 please suggest me... @chridam

chridam Over a year ago

@dhanashri Again, this is considered bad practice as chameleon questions are not encouraged here on SO. Notwithstanding this, I have updated the answer to include how you can remove the _id field.

Collectives™ on Stack Overflow

How to implement MongoDB query in Laravel 5?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related