时间戳

首页 > 解决方案 > 比较数组值并选择特定的值

php - 比较数组值并选择特定的值

问题描述

我需要一些关于以下概念的帮助。

我有一个数组：

$values = array(
    array(
        'logId'     => 1000,
        'userId'    => 1111,
        'dateTime'  => '2021-01-04 08:10:50',
        'event'     => 'OUT'
    ),
    array(
        'logId'     => 1001,
        'userId'    => 1111,
        'dateTime'  => '2021-01-04 08:11:50',
        'event'     => 'IN'
    ),
    array(
        'logId'     => 1002,
        'userId'    => 1111,
        'dateTime'  => '2021-01-04 08:11:53',
        'event'     => 'IN'
    ),
    array(
        'logId'     => 1003,
        'userId'    => 1111,
        'dateTime'  => '2021-01-04 17:10:50',
        'event'     => 'OUT'
    ),
    array(
        'logId'     => 1004,
        'userId'    => 2222,
        'dateTime'  => '2021-01-04 08:10:50',
        'event'     => 'IN'
    ),
    array(
        'logId'     => 1005,
        'userId'    => 2222,
        'dateTime'  => '2021-01-04 17:00:50',
        'event'     => 'OUT'
    ),
);

我想遍历它并根据“dateTime”选择“first IN”和“last OUT”。所以我应该得到：

1 | 1001 | 1111 | 2021-01-04 08:11:50 | IN |
3 | 1003 | 1111 | 2021-01-04 17:10:50 | OUT |
4 | 1004 | 2222 | 2021-01-04 08:10:50 | IN |
5 | 1005 | 2222 | 2021-01-04 17:00:50 | OUT |

怎么可能做到这一点？感谢任何帮助。

谢谢，

标签： phparraysassociative-array

解决方案

我的方法是：

  1. 将 RAW 输入数组过滤为最早in和最新的out. 我们不需要其余的结果。

  2. 以预期的格式重新格式化该输出。

这些dateTime字符串似乎是格式正确的时间戳（可能来自 mysqli 数据库）。这很好，因为这意味着我们可以将时间戳与<和进行比较>。

解决方案

// Define the filter array
$filterArray = [];

foreach($values as $log){

    // Set a reference to this userId in the new array
    $user = &$filterArray[$log["userId"]];


    // If nothing has been added for this person's IN/OUT yet then add it on here
    if(! ($user[$log["event"]] ?? null)){
        $user[$log["event"]] = $log;
    }

    // If the event is IN then check to see if this IN is earlier than the one already stored
    if($log["event"] == "IN" && $user["IN"]["dateTime"] > $log["dateTime"]){
        $user["IN"] = $log["dateTime"];
    }
    
    // If the event is OUT then check to see if this OUT is later than the one already stored
    if($log["event"] == "OUT" && $user["OUT"]["dateTime"] < $log["dateTime"]){
        $user["OUT"] = $log;
    }
}


// Sort by userId
ksort($filterArray);

// Define the output array
$outArray = [];

// Fill the output array
foreach($filterArray as $log){
    $outArray[] = $log["IN"];
    $outArray[] = $log["OUT"];

}

输出

array (
  0 => 
  array (
    'logId' => 1001,
    'userId' => 1111,
    'dateTime' => '2021-01-04 08:11:50',
    'event' => 'IN',
  ),
  1 => 
  array (
    'logId' => 1003,
    'userId' => 1111,
    'dateTime' => '2021-01-04 17:10:50',
    'event' => 'OUT',
  ),
  2 => 
  array (
    'logId' => 1004,
    'userId' => 2222,
    'dateTime' => '2021-01-04 08:10:50',
    'event' => 'IN',
  ),
  3 => 
  array (
    'logId' => 1005,
    'userId' => 2222,
    'dateTime' => '2021-01-04 17:00:50',
    'event' => 'OUT',
  ),
)

没有注释的代码

$filterArray = [];
foreach($values as $log){
    $user = &$filterArray[$log["userId"]];
    if(! ($user[$log["event"]] ?? null)){
        $user[$log["event"]] = $log;
    }
    if($log["event"] == "IN" && $user["IN"]["dateTime"] > $log["dateTime"]){
        $user["IN"] = $log["dateTime"];
    }
    if($log["event"] == "OUT" && $user["OUT"]["dateTime"] < $log["dateTime"]){
        $user["OUT"] = $log;
    }
}
ksort($filterArray);
$outArray = [];
foreach($filterArray as $log){
    $outArray[] = $log["IN"];
    $outArray[] = $log["OUT"];
}

推荐阅读