MongoDB PHP驱动程序：日期搜索不起作用

Question

I am migrating to PHPLIB from the old MongoDB driver. Unfortunately, I am running into issues attempting to convert date searches. I am trying to retrieve documents that were added to the database from a certain date (yesterday), however, when I perform a search, I'm getting back the count for all the records regardless of the value in 'added_on'. Not sure what I'm doing wrong.

    $collection = $mongo->getCollection("records");
$yesterday = new DateTime(date('Y-m-d').' 00:00:00');
$dateFrom = new MongoDB\BSON\UTCDateTime($yesterday->format('U'));
    $response = $collection->count(['added_on' => ['$gte' => $dateFrom], 'instance' => $element, 'invisible' => false]);

var_dump of UTCDateTime shows a valid value:

object(MongoDB\BSON\UTCDateTime)#477 (1) { ["milliseconds"]=>
string(10) "1515954053" }

Example of a document expected to return:

{ "_id" : ObjectId("5a5badcffe23a278e2bb739a"), "instance" : ObjectId("591555806803fa06650b474c"), "added_on" : ISODate("2018-01-14T23:25:55Z"), "invisible" : false, "reviewed" : true }

Any help would be appreciated.

UPDATE: Removing the variable that is sent to the UTCDateTime object like this:

$dateFrom = new MongoDB\BSON\UTCDateTime();

works (as can be seen above I've added one record in the future). Problem is when I send the variable to specify the timestamp that I need.

Answer 1

Was able to find the issue - this behavior is caused when MongoDB\BSON\UTCDateTime receives a value generated by strtotime. The value appears to be valid (no errors are generated), but because it represents and not milliseconds, it does not behave as expected.

I've added the following function to a custom MongoDB class I'm using:

public function date($timestamp) {
    $timestamp = strtotime($timestamp) * 1000;
    $object = new MongoDB\BSON\UTCDateTime($timestamp);
    return $object;
}

Then I just call:

$response = $collection->count(['added_on' => ['$lt' => $mongo->date($yesterday->format('Y-m-d H:i:s'))], 'instance' => $element, 'invisible' => false]);

$mongo being the object of the custom class.