按日期和其他識別符號拆分陣列

我有從 mongodb 到陣列的資料，我想處理回傳資料以按日期和其他值拆分它，這是我到目前為止得到的，我需要一些幫助來處理結果

<?php

$stats=array(
    array("source"=>501,"status"=>"answered","dest"=>"100","date"=>"2022-17-01"),
    array("source"=>501,"status"=>"noAnswer","dest"=>"120","date"=>"2022-17-01"),
    array("source"=>501,"status"=>"answered","dest"=>"100","date"=>"2022-18-01"),
    array("source"=>502,"status"=>"answered","dest"=>"120","date"=>"2022-17-01"),
    array("source"=>502,"status"=>"answered","dest"=>"130","date"=>"2022-17-01"),
    array("source"=>502,"status"=>"answered","dest"=>"110","date"=>"2022-18-01")
);

$new1 = array();
$answer = 0;
$noanswer = 0;
$lastsrc = '';
$lastdate = '';
$dest=0;
foreach ($stats as $new) {

    $src = $new['source'];
    $date = $new['date'];
 
    if ( $lastsrc == $src && $lastdate == $date ) {
        $dest  ;

        if($new['status'] == 'answered'){ $answer  ; }
        if($new['status'] == 'noanswer'){ $noanswer  ;}

        $new1[] = array('source' => $src, 
                        'date' => $date, 
                        'ans' => $answer, 
                        'nonans' => $noanswer, 
                        'dest' => $dest  );
    } else if ( $lastsrc == $src && $lastdate != $date ) {

        $dest  ;

        if($new['status'] == 'answered'){ $answer  ;}
        if($new['status'] == 'noanswer'){ $noanswer  ;}

        $new1[] = array('source' => $src, 
                        'date' => $date, 
                        'ans' => $answer, 
                        'nonans' => $noanswer, 
                        'dest' => $dest  );
    } else {

        $dest  ;

        if($new['status'] == 'answered'){ $answer  ; }
        if($new['status'] == 'noanswer'){ $noanswer  ;}
       
        $new1[] = array('source' => $src, 
                       'date' => $date, 
                       'ans' => $answer,
                       'nonans' => $noanswer, 
                       'dest' => $dest  );
        $lastsrc = $src;
        $lastdate = $date;
    }
}   
print_r($new1);
?>

我試圖實作的是按日期和源拆分資料，所以如果在 foreach 回圈中我找到相同的源和相同的日期，那么我修改陣列而不是創建新陣列，如果相反則創建新陣列

我試圖得到的結果是：

    array("source"=>501,"ans"=>"1","noans" => 0,"dest"=>1,"date"=>"2022-17-01"),
    array("source"=>501,"ans"=>"1","noAnswer" => 1,"dest"=>2,"date"=>"2022-18-01"),
    array("source"=>502,"ans"=>"2","noans" => 0,"dest"=>2,"date"=>"2022-17-01"),
    array("source"=>502,"ans"=>"1","noans" => 0,"dest"=>1,"date"=>"2022-18-01")

我不確定它是否正確，任何幫助將不勝感激謝謝

uj5u.com熱心網友回復：

<?php

$stats = [
    [ 'source' => 501, 'status' => 'answered', 'dest' => '100', 'date' => '2022-17-01' ],
    [ 'source' => 501, 'status' => 'noAnswer', 'dest' => '120', 'date' => '2022-17-01' ],
    [ 'source' => 501, 'status' => 'answered', 'dest' => '100', 'date' => '2022-18-01' ],
    [ 'source' => 502, 'status' => 'answered', 'dest' => '120', 'date' => '2022-17-01' ],
    [ 'source' => 502, 'status' => 'answered', 'dest' => '130', 'date' => '2022-17-01' ],
    [ 'source' => 502, 'status' => 'answered', 'dest' => '110', 'date' => '2022-18-01' ]
];

$result = [];

foreach ($stats as $stat) {
  $source = $stat['source'];
  $date = $stat['date'];
  $closure = static fn($item) => $item['source'] === $source && $item['date'] === $date;
  $found = array_filter($result, $closure);
  if (count($found) === 0) {
    $list = array_filter($stats, $closure);
    $list = array_map(static fn($item) => [ 'status' => $item['status'], 'dest' => $item['dest'] ], $list);
    $result[] = [
        'source' => $source,
        'date' => $date,
        'answered' => count(array_filter(array_column($list, 'status'), static fn($item) => $item === 'answered')),
        'noAnswer' => count(array_filter(array_column($list, 'status'), static fn($item) => $item === 'noAnswer')),
        'dest' => count(array_column($list, 'dest')),
    ];
  }
}

print_r($result);

uj5u.com熱心網友回復：

我真的不確定你在這里尋找什么，f.ex dest 的內容，但我認為這正是你想要的（？）。只需從要排序的欄位創建一個復合鍵并使用關聯陣列。（陣列中的單個級別使排序/合并以及array_values()之后提取值（）變得容易）

$result = [];
foreach($stats as $stat) {
    $key = $stat['source'].'_'.$stat['date'];
    if (!array_key_exists($key, $result)) {
        $result[$key] = $stat   ['answered' => 0, 'noAnswer' => 0];
    }

    $result[$key][$stat['status']]  ;
}

print_r(array_values($result));
['source' => 501, 'status' => answered, 'dest' => 100, 'date' => 2022-17-01, 'answered' => 1, 'noAnswer' => 1],
['source' => 501, 'status' => answered, 'dest' => 100, 'date' => 2022-18-01, 'answered' => 1, 'noAnswer' => 0],
['source' => 502, 'status' => answered, 'dest' => 120, 'date' => 2022-17-01, 'answered' => 2, 'noAnswer' => 0],
['source' => 502, 'status' => answered, 'dest' => 110, 'date' => 2022-18-01, 'answered' => 1, 'noAnswer' => 0]

標籤：

上一篇：使用php回圈遍歷Curl回應并提取資訊

下一篇：PHP中的邏輯或運算子