確定每個 PhaseId 的持續時間

Question

我有以下陣列：array(size=8)0=>array(size=5)'entity_id'=>int571962'time'=>int1671101084788'timetodatetime'=>string'2022-12-1511:44:44'( length=19)'PhaseId_new'=>string'Close'(length=5)'PhaseId_o

P粉029327711 · Answer

嘗試這樣的事情。

//group by entity_id
$data_grouped = [];
foreach($data as $element) {
  $data_grouped[$element['entity_id']][] = $element;
}

$entity_phases = [];
//get all phases and their times
foreach ($data_grouped as $entity_id => $elements) {
  foreach ($elements as $element) {
    if ($element['PhaseId_new']) {
      $entity_phases[$entity_id][$element['PhaseId_new']][] = $element['time'];
    }
    if ($element['PhaseId_old']) {
      $entity_phases[$entity_id][$element['PhaseId_old']][] = $element['time'];
    }
  }
}

$result = [];
//iterate all phases and calculate time diffs
foreach ($entity_phases as $entity_id => $phases) {
  foreach ($phases as $key => $values) {
    if (!isset($result[$entity_id][$key])) {
      $result[$entity_id][$key] = 0;
    }
    //iterate in chunks of two elements
    foreach (array_chunk($values, 2) as $value) {
      //continue if only one value is found (e.g. for "Close")
      if (!isset($value[1])) {
        continue;
      }
      $result[$entity_id][$key] = $result[$entity_id][$key] + $value[0] - $value[1];
    }
  }
}
var_dump($result);

這給你：

array(1) {
  [571962]=>
  array(6) {
    ["Close"]=>
    int(0)
    ["Accept"]=>
    int(729914)
    ["Fulfill"]=>
    int(73006092)
    ["Review"]=>
    int(27033)
    ["Approve"]=>
    int(16152972)
    ["Log"]=>
    int(2700)
  }
}

P粉587970021 · Answer

好吧，這花了我比我想要的更長的時間，但我得到了結果。首先是程式碼：

$entityPhases = [];
foreach ($data as $element) {
    $entityPhases[$element['entity_id']][] = $element;
}

$durations = [];
$oldPhases = [];
foreach ($entityPhases as $phases) {
    foreach(array_reverse($phases) as $phase) {
        if ($phase['PhaseId_old']) {
            $oldPhaseName = $phase['PhaseId_old'];
            $duration = $phase['time'] - $oldPhases[$oldPhaseName]['time'];
            $durations[$oldPhaseName] = ($durations[$oldPhaseName] ?? 0) + $duration;
        }   
        $oldPhases[$phase['PhaseId_new']] = $phase;
    }
}

print_r($durations);

請參閱：https://onlinephp.io/c/92d7f

#結果是：

Array
(
    [Log] => 2700
    [Approve] => 16152972
    [Fulfill] => 73006092
    [Accept] => 729914
    [Review] => 27033
)

現在解釋一下：

首先，您的資料數組看起來是顛倒的，因此我使用 array_reverse() 來解決它。這裡的假設是存在邏輯順序。

由於可能需要將多個週期相加，因此我使用一個名為 $durations 的陣列來將它們相加。

然後在內部循環中，如果有舊的階段 ID，我可以計算持續時間並將其相加。最後我記得舊的階段，因為我在循環的下一個迭代中需要它。

我還重命名了很多東西，使其名稱能夠傳達變數的內容。