在对象阵列中查找最接近的日期/时间

I'm looking for some advise on what would be the best way to find the closest startTime (recommended startTime).

What I've got so far:

<?php
$array = array(    array("meeting_id" => "1812",  
                         "startTime" => "2016-10-07 14:30:00", 
                         "endTime" => "2016-10-07 14:35:00"),
                   array("meeting_id" => "1812",  
                         "startTime" => "2016-10-07 14:35:00", 
                         "endTime" => "2016-10-07 14:40:00"),
                   array("meeting_id" => "1812",  
                         "startTime" => "2016-10-07 14:40:00", 
                         "endTime" => "2016-10-07 14:45:00"),
                   array("meeting_id" => "1813",  
                         "startTime" => "2016-10-07 15:05:00", 
                         "endTime" => "2016-10-07 15:10:00"),
                   array("meeting_id" => "1813",  
                         "startTime" => "2016-10-07 15:10:00", 
                         "endTime" => "2016-10-07 15:15:00"),
                   array("meeting_id" => "1813",  
                         "startTime" => "2016-10-07 15:20:00", 
                         "endTime" => "2016-10-07 15:25:00"),
    );

arsort($array);
$firstTime = $array[0];
foreach($array as $key){
    if($firstTime["startTime"] > $key["endTime"]){
        // Do something in here.
    }
}

print_r($array);


?>

Printed Array:

Array
(
    [5] => Array
        (
            [meeting_id] => 1813
            [startTime] => 2016-10-07 15:20:00
            [endTime] => 2016-10-07 15:25:00
        )

    [4] => Array
        (
            [meeting_id] => 1813
            [startTime] => 2016-10-07 15:10:00
            [endTime] => 2016-10-07 15:15:00
        )

    [3] => Array
        (
            [meeting_id] => 1813
            [startTime] => 2016-10-07 15:05:00
            [endTime] => 2016-10-07 15:10:00
        )

    [2] => Array
        (
            [meeting_id] => 1812
            [startTime] => 2016-10-07 14:40:00
            [endTime] => 2016-10-07 14:45:00
        )

    [1] => Array
        (
            [meeting_id] => 1812
            [startTime] => 2016-10-07 14:35:00
            [endTime] => 2016-10-07 14:40:00
        )

    [0] => Array
        (
            [meeting_id] => 1812
            [startTime] => 2016-10-07 14:30:00
            [endTime] => 2016-10-07 14:35:00
        )

)

How I would expect it to work:

Find the earliest start time for meeting_id == 1812, and then find the closest next meeting whose ID != 1812. However the start time of those meeting ID != 1812 needs to be greater than the selected end time of 1812

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

douguan3470 2016-10-10 10:52

关注

The following function will take your array as the first argument, and the Meeting ID as the second, and will in turn return the nearest meeting to the earliest meeting whose ID is not $id:

function get_nearest_meeting($meetings, $id)
{
    // Start by sorting the meetings:
    function sorter($a, $b)
    {
        return strtotime($a['startTime']) - strtotime($b['startTime']);
    }
    usort($meetings, 'sorter');

    foreach( $meetings as $meeting )
    {
        if( $meeting['meeting_id'] == $id)
        {
            $earliest = strtotime( $meeting['endTime'] );
            break;
        }
    }

    // Now loop over again and get the next meeting:
    foreach( $meetings as $meeting )
    {
        if( $meeting['meeting_id'] != $id && strtotime($meeting['startTime']) > $earliest)
        {
            return $meeting;
        }
    }
}

Given the following input (stored in $meetings):

And calling it like this:

get_nearest_meeting($meetings, 1812);

We end up with the following result:

Array
(
    [errors] => 0
    [meeting_id] => 1813
    [id] => 31305
    [startTime] => 2016-10-07 14:10:00
    [endTime] => 2016-10-07 14:20:00
    [grade_id] => 87
)

本回答被题主选为最佳回答 , 对您是否有帮助呢?

报告相同问题？

关注问题

在对象阵列中查找最接近的日期/时间 php
2016-10-10 10:32

回答 1 已采纳 The following function will take your array as the first argument, and the Meeting ID as the secon
PHP阵列中的JSON解码数据 json php
2017-09-29 14:49

回答 1 已采纳 You have this: array(4) { ["count"]=> int(811) ["previous"]=> NULL ["results
将Base64图像插入到PHP PDO阵列中 mysql php
2018-04-16 18:18

回答 2 已采纳 So the answer to this question came from AbraCadaver. $sql = "SELECT img from artistlocation";
PHP知识点整理（2）
2020-05-21 14:47

温志兴的博客 PHP的意思 PHP是一个基于服务端来创建动态网站的脚本语言，您可以用PHP和HTML生成网站主页什么事面向对象？主要特征是什么？面向对象是程序的一种设计方式，它利于提高程序的重用性，使程序结构更加清晰。主要...
在laravel中单独从阵列中获取数据 laravel php
2018-01-17 08:07

回答 1 已采纳 The foreach will loop through anyhow and pull the relevant info. You just then show it within your
Laravel在路线中传递阵列 laravel php
2018-04-19 08:39

回答 4 已采纳 Just do as you did: {{ route('data', ['min' => 12, 'max' => 123, 'week' => 1, 'month' =&
PHP阵列数组独特 php
2018-02-06 15:57

回答 2 已采纳 Just iterate through the initial array of questions, every time save the value (array of tags) to
PHP面试题(一)
2018-06-09 11:33

嘿丶单炒饭的博客 PHP的意思PHP是一个基于服务端来创建动态网站的脚本语言，您可以用PHP和HTML生成网站主页什么事面向对象？主要特征是什么？面向对象是程序的一种设计方式，它利于提高程序的重用性，使程序结构更加清晰。主要特征...
Laravel 5+，在阵列中收集多个相同的集合 laravel php
2018-04-08 19:32

回答 1 已采纳 You can use the merge() method on the collection. Try the following code where you're currently
php阵列转换处理？ php
2018-07-19 02:37

回答 3 已采纳 You can run a for-loop and generate the array. While generating you need check if the next item
检查邮政编码是否在多个阵列中？ php
2017-02-15 11:20

回答 1 已采纳 I would try to use in_array for this. $input = $row['postcode']; $areas = array( 'Area 1' =&
网络安全管理员高级工理论题库（持续更新中）
2023-11-06 10:37

越来越不懂！的博客网络安全管理员高级工理论题库，持续更新中……
拆分/子串控阵列 - PHP php
2015-09-01 08:29

回答 3 已采纳 Split your data into lines with something like explode(" ", $data); Then process the data line by
面向对象之14：开发中的常用类之一： Math、Random、System、Arrays、BigInteger、BigDecimal、Scanner 的使用总结：
2021-06-07 13:30

Jonny Z的博客（只能是 Math 类自己在自己的类中使用自己的对象。） Math类内部所有的属性、方法都是静态的，被static 修饰，直接用类名.静态成员访问即可。，如果本类中的静态成员有和静态导入的类的静态成员重名时，在...
最后的性能优化策略[关闭]
2020-01-03 13:51

asdfgh0077的博客所以，无论哪个时间最重要的是你的主要候选人。但是既然你说你想要挤出最后几个百分比，你可能还想检查较小的部分，那些你最初没有仔细检查过的部分。最后，通过不同方式实现相同解决方案或可能不同的算法的...
没有解决我的问题, 去提问

悬赏问题

¥35 MIMO天线稀疏阵列排布问题
¥60 用visual studio编写程序，利用间接平差求解水准网
¥15 Llama如何调用shell或者Python
¥20 谁能帮我挨个解读这个php语言编的代码什么意思？
¥15 win10权限管理，限制普通用户使用删除功能
¥15 minnio内存占用过大，内存没被回收（Windows环境）
¥65 抖音咸鱼付款链接转码支付宝
¥15 ubuntu22.04上安装ursim-3.15.8.106339遇到的问题
¥15 blast算法（相关搜索：数据库）
¥15 请问有人会紧聚焦相关的matlab知识嘛？

码龄粉丝数原力等级 --

在对象阵列中查找最接近的日期/时间

1条回答默认最新

码龄粉丝数原力等级 --

悬赏问题

在对象阵列中查找最接近的日期/时间

1条回答 默认 最新

悬赏问题

1条回答默认最新