过滤具有多个值的多维数组

Question

I have three multidimensional arrays. I want to filter out values in the first array that match two values in the other two arrays.

Array 1 $a[] contains location $a[LOC], quantity $a[QTY] and last activity date $a[DATE].

---

Array 2 $b[] contains all locations and their last activity date

---

Array 3 $c[] contains all locations and their current quantity

I need to remove from array $a the locations that appear in array $b which have an activity date bigger than that in array $a (for the same location) and remove from array $a the locations with quantities not matching the same location in array $c.

I have tried combinations of foreach loops with array_intersects but cant seem to get anywhere near what I need.

Any help would be greatly appreciated.

Answer 1

I solved it like this,

$b_loc = array_column($b, 'LOC');
$b_date = array_column($b, 'DATE');
$c_loc = array_column($c, 'LOC');
$c_qty = array_column($c, 'QTY');

foreach ($a as $index => $val) {
    $b_pick = array_search($val['LOC'], $b_loc);
    if($b_pick){
        if($val['DATE'] <= $b_date[$b_pick]){
            unset( $a[$index] );
        }
    }
    $key_qty = array_search($val['LOC'], $c_loc);

        if( ($val['QTY']!=$c_qty[$key_qty]) ){
            unset( $a[$index] );
        }   
}