Laravel with mongodb aggregate , select where date

Question

I have a mongo database which has data like this

{ "_id" : ObjectId("5e0202d3fae94619c020c390"), "sys" : "2019-12-19", "time" : ISODate("2019-12-19T11:28:30.454Z"), "time_rcvd" : ISODate("2019-12-19T11:28:30.454Z"), "msg" : "", "syslog_fac" : 23, "syslog_sever" : 6, "syslog_tag" : "11:", "procid" : "11", "pid" : "-", "level" : "INFO", "logtype" : "Traffic LOGS", "date" : "2019-12-19", "Module" : "01SECLOG", "Desc" : "IPVer", "Severity_Level" : "6", "Protocol" : "tcp", "SourceIP" : "10.10.2.101", "Country" : "172.217.169.194", "DestinationIP" : "172.217.169.194", "SourcePort" : "39554", "DestinationPort" : "443", "SourceNatIP" : "192.168.101.2", "SourceNatPort" : "4128", "BeginTime" : "1576754847", "EndTime" : "1576754894", "SendPkts" : "59", "SendBytes" : "11041", "RcvPkts" : "81", "RcvBytes" : "8095", "SourceVpnID" : "0", "DestinationVpnID" : "0", "SourceZone" : "guest", "DestinationZone" : "untrust", "PolicyName" : "guest_to_untrust", "CloseReason" : "tcp-rst", "ApplicationName" : "Google_Service.", "VSys" : "", "User" : "", "Profile" : "", "Type" : "", "Category" : "", "SubCategory" : "", "Page" : "", "Host" : "", "Referer" : "", "Item" : "", "Action" : "" }

I am applying this query to get data from it, using laravel aggregate

$data = Logss::raw(function($collection)use ($topLength,$start)
     {
   return $collection->aggregate([
        [

        '$group'    => [
            '_id'   => '$ApplicationName',

            'count' => [
                '$sum'  => 1
            ]
        ]
    ],
    ['$sort' => ['count' => -1]],

    ['$limit'=> $topLength]
]);
});

I can get data without a problem, but I decided to make a filter of this data depending on the date that user select like

{ last_hour , today , yesterday , this_week , last_week , this_month , last_month , this_year };

when user select today, for example, I will use carbon to get today's date

$today = new Carbon('today');

and it is return

2019-12-25 00:00:00

but I don't know how to do that and retrieve only today's records,
I used this code but return nothings

 $data = Logss::raw(function($collection)use ($topLength)
{
return $collection->aggregate([
 [

        '$group'    => [
            '_id'   => '$ApplicationName',

            'count' => [
                '$sum'  => 1
            ]
        ]
    ],
    ['$sort' => ['count' => -1]],
 [ '$match' => [ 'time' =>['$gt'=>' ISODate("2017-10-01")' ]]],
    ['$limit'=> $topLength]
]);
});

story ks · Answer 1 · 2019-12-25T10:33:03.190

0

Try

    $dt = Carbon::create(2012, 1, 31, 0);
    echo $dt->addHours(24);                  // 2012-02-04 00:00:00
    echo $dt->addHour();                     // 2012-02-04 01:00:00
    echo $dt->subHour();                     // 2012-02-04 00:00:00
    echo $dt->subHours(24);                  // 2012-02-03 00:00:00

Document

edited Dec 25 '19 at 10:33

answered Dec 25 '19 at 10:31

story ks

855
1
16
39

thank you for your reply ,but how can I use it in my query – stack over Dec 25 '19 at 10:32
1

Try db.foo.find({ "dt" : { "$gte" : { "$date" : $dt->subHour();}} }) – story ks Dec 25 '19 at 10:37
You see https://stackoverflow.com/questions/19819870/date-query-with-isodate-in-mongodb-doesnt-seem-to-work This link – story ks Dec 25 '19 at 10:39
thank you for your reply , I updated my post with the new code which I used , but this code return nothings – stack over Dec 25 '19 at 10:51

score 0 · Answer 2 · answered Dec 25 '19 at 10:54

0

Here what I tried. Hope to help you out :)

 db.getCollection('collectionName').find({
    created: {
        $gte: '2019-10-28 00:00:00',
        $lt:  '2019-10-29 10:22:10'
    }
})

answered Dec 25 '19 at 10:54

PHP Ninja

1,055
2
9
28

thank you for reply , I know this code , but I don't know how to apply it in laravel aggregate – stack over Dec 25 '19 at 10:55
did you try noSqlDb ? – PHP Ninja Dec 25 '19 at 10:56

Laravel with mongodb aggregate , select where date

2 Answers2