How can I compare two array value and return what i want value?

Question

Existing Record:

array:3 [
  0 => array:2 [
    "groupTaskUuid" => "98790287437987860"
    "purchaseOrderGroupTasks" => "98790287437987893"
  ]
  1 => array:2 [
    "groupTaskUuid" => "98790287437987862"
    "purchaseOrderGroupTasks" => "98790287437987894"
  ]
  2 => array:2 [
    "groupTaskUuid" => "98790287437987861"
    "purchaseOrderGroupTasks" => "98790287437987895"
  ]
]

GroupTaskUuid Array:

array:2 [
  0 => "98790287437987862"
  1 => "98790287437987861"
]

How can I compare two arrays with the "groupTaskUuid" but return "purchaseOrderGroupTasks" value in the result?

Result what I want (that is "purchaseOrderGroupTasks"):

array:2 [
    "0" => "98790287437987894"
    "1" => "98790287437987895"
]

If you are not hunting for speed, then loop through first one and do an in_array() check. — nice_dev, Jun 29 '20 at 09:35

score 0 · Answer 1 · answered Jun 29 '20 at 09:44

I would suggest something like this:

$filtered = array_filter(
                $records, 
                function($el) use($GroupTaskUuid) { 
                    return in_array($el["groupTaskUuid"], $GroupTaskUuid); 
                }
             );

$only_purchase_column = array_column($filtered, "purchaseOrderGroupTasks")

score 0 · Answer 2 · answered Jun 29 '20 at 09:45

Since you said there would be a lot of rows, you will need to convert GroupTaskUuid array to an associative array where those UUIDs are keys. This way you can do an isset() check in O(1) time on average.

You loop through the dataset, check if that UUID key exists in our map and if it exists, collect it's purchaseOrderGroupTasks in a new result array.

Snippet:

<?php

$data = [
      [
        "groupTaskUuid" => "98790287437987860",
        "purchaseOrderGroupTasks" => "98790287437987893"
      ],
      [
        "groupTaskUuid" => "98790287437987862",
        "purchaseOrderGroupTasks" => "98790287437987894"
      ],
      [
        "groupTaskUuid" => "98790287437987861",
        "purchaseOrderGroupTasks" => "98790287437987895"
      ]
];

$GroupTaskUuid = [
       "98790287437987862",
       "98790287437987861"
    ];

$GroupTaskUuidFlipped = array_flip($GroupTaskUuid); // make UUID values as keys
$purchaseOrderGroupTasks = [];

foreach($data as $value){
    if(isset($GroupTaskUuidFlipped[$value['groupTaskUuid']])){
        $purchaseOrderGroupTasks[] = $value['purchaseOrderGroupTasks'];
    }
}

print_r($purchaseOrderGroupTasks);

score 0 · Answer 3 · answered Jun 29 '20 at 09:46

0

You can use

$purchaseOrderGroupTasks = [];
foreach($GroupTaskUuid as $uuid){
    if($key = array_search($uuid, array_column($data, 'groupTaskUuid')) !== false)
        $purchaseOrderGroupTasks[] = $data[$key]['key'];
}

answered Jun 29 '20 at 09:46

Kongulov

1,156
2
9
19

How can I compare two array value and return what i want value?

3 Answers3