jQuery技术:使用开始和结束时间之间的时间过滤数组或XML

好的，所以我编写了一些PHP函数来过滤掉你的需求。

要比较php中的日期，最简单的方法是将它们转换为Unix时间。 这就是第一个function所做的。 Unix时间是自1970年1月1日以来经过的时间（以秒为单位）。转换它们的优势在于您可以简单地使用<和>运算符进行两次比较。

下一个函数（nowBetween）查看当前时间是否在给定的两次（$ start和$ end）之间。

然后我拿了你的JSON字符串（因为我在撰写这篇文章时并没有真正看到XML源代码）并将其转换为PHP数组。 我们可以确定它是数组，因为json_decode中的第二个参数设置为true。

最后但并非最不重要的是，我遍历JSON内容的“数据”部分中的所有预订，阅读GMTStart和GMTEnd时间，并使用我们的函数检查当前时间是否介于它们之间。 如果不是这样，那么我从$ bookings数组中删除预订。

结果只剩下正确时间的预订。 我的输出现在是空的，但那是因为你的预订日期是2014-05-09 …当我调整它的工作时间。

我希望这个答案能满足你的需求。

 function convertDateTime($datetime) { //FORMAT IS date("YYYY-MM-DDThh:mm:ss") $datetime = str_replace("T"," ",$datetime); return date("U",strtotime($datetime)); } function nowBetween($start,$end) { $now = gmdate("U"); $start = convertDateTime($start); $end = convertDateTime($end); if ($start <= $now && $end > $now) { return true; } else { return false; } } $bookings = '{"Bookings":{"Data":[{"BookingDate":["2014-05-09T00:00:00"],"RoomDescription":["Room06"],"TimeEventStart":["2014-05-09T14:00:00"],"TimeEventEnd":["2014-05-09T14:30:00"],"EventName":["Jake Long"],"SetupTypeDescription":["(none)"],"ReservationID":["137"],"OpenTime":["1900-01-01T00:00:00"],"CloseTime":["1900-01-01T00:00:00"],"EventTypeDescription":[[]],"BookingID":["709"],"TimeBookingStart":["2014-05-09T14:00:00"],"TimeBookingEnd":["2014-05-09T14:30:00"],"GMTStartTime":["2014-05-09T18:00:00"],"GMTEndTime":["2014-05-09T18:30:00"],"TimeZone":["ET"],"RoomCode":["R06"],"Room":["Room 6"],"RoomID":["34"],"StatusID":["3"],"EventTypeID":["0"],"DateAdded":["2014-05-09T13:47:29.087"],"DateChanged":["2014-05-09T13:47:29.087"],"ChangedBy":["Admin"]},{"BookingDate":["2014-05-09T00:00:00"],"RoomDescription":["Room06"],"TimeEventStart":["2014-05-09T18:00:00"],"TimeEventEnd":["2014-05-09T20:00:00"],"EventName":["Rob Brown"],"SetupTypeDescription":["(none)"],"ReservationID":["142"],"OpenTime":["1900-01-01T00:00:00"],"CloseTime":["1900-01-01T00:00:00"],"EventTypeDescription":[[]],"BookingID":["714"],"TimeBookingStart":["2014-05-09T18:00:00"],"TimeBookingEnd":["2014-05-09T20:00:00"],"GMTStartTime":["2014-05-09T22:00:00"],"GMTEndTime":["2014-05-10T00:00:00"],"TimeZone":["ET"],"RoomCode":["R06"],"Room":["Room 6"],"RoomID":["34"],"StatusID":["3"],"EventTypeID":["0"],"DateAdded":["2014-05-09T14:58:55.71"],"DateChanged":["2014-05-09T14:58:55.71"],"ChangedBy":["Admin"]},{"BookingDate":["2014-05-9T00:00:00"],"StartBookingDate":["2014-05-09T00:00:00"],"RoomDescription":["Room06"],"TimeEventStart":["2014-05-09T11:00:00"],"TimeEventEnd":["2014-05-09T12:00:00"],"EventName":["Jimmy James"],"SetupTypeDescription":["(none)"],"ReservationID":["141"],"OpenTime":["1900-01-01T00:00:00"],"CloseTime":["1900-01-01T00:00:00"],"EventTypeDescription":[[]],"BookingID":["713"],"TimeBookingStart":["2014-05-09T11:00:00"],"TimeBookingEnd":["2014-05-09T12:00:00"],"GMTStartTime":["2014-05-09T15:00:00"],"GMTEndTime":["2014-05-09T16:00:00"],"TimeZone":["ET"],"RoomCode":["R06"],"Room":["Room 6"],"RoomID":["34"],"StatusID":["1"],"EventTypeID":["0"],"DateAdded":["2014-05-09T14:58:15.17"],"DateChanged":["2014-05-09T14:58:15.17"],"ChangedBy":["Admin"]}]}}'; $bookings = json_decode($bookings,true); foreach ($bookings["Bookings"]["Data"] as $index=>$arrContent) { if (!nowBetween($arrContent["GMTStartTime"][0],$arrContent["GMTEndTime"][0])) { unset($bookings["Bookings"]["Data"][$index]); } } 

您可以使用Xpath过滤XML。 Xpath 1.0无法比较字符串，但您也可以注册PHP函数。

所以用PHP编写条件：

 function isBetween($current, $min, $max) { $current = strtotime($current.'Z'); $min = strtotime($min.'Z'); $max = strtotime($max.'Z'); return $current >= $min && $current <= $max; } 

创建DOM文档并加载XML。 创建Xpath实例注册PHP命名空间和函数。

 $dom = new DOMDocument(); $dom->loadXml($xml); $xpath = new DOMXpath($dom); $xpath->registerNamespace("php", "https://php.net/xpath"); $xpath->registerPhpFunctions('isBetween'); 

定义一个Xpath表达式，该表达式使用该函数来过滤Data元素节点：

 // use gmtime() for current time $now = strtotime('2014-05-13T14:00:00Z'); $expression = sprintf( '/Bookings/Data[ php:function("isBetween", "%s", string(GMTStartTime), string(GMTEndTime)) ]', gmdate('Ymd\TH:i:s', $now) ); 

使用Xpath表达式获取Data元素节点：

 $result = []; foreach($xpath->evaluate($expression) as $dataNode) { $record = []; // convert the matching data into a record array foreach ($xpath->evaluate('*', $dataNode) as $childNode) { $record[$childNode->localName] = $childNode->nodeValue; } $result[] = $record; } var_dump($result); 

演示： https ： //eval.in/151732

据我了解，您将在<预订>中收到几条记录？ 那么你有两个选择：如果记录数总是很大 – 超过几千个那么你应该使用XPath过滤数据之前将数据转换为数组 – 从XPath复制节点 – >查询结果到新文档并转换这个文档到数组。 如果记录数量很小，那么之后更容易转换它们 – 只需使用带有类似于此的回调的array_filter：

 $filteredResult = array_filter($data, function($row) { // parse dates and compare them. }); 

你会得到过滤数组。