使用另一个阵列创建新的唯一数组

Question

I have a simple product system in my project. I need to get my product option names and product options look like this. "Color" => "Red,Blue,Yellow" "Size" => "S,M,L,XL"

My records in database look like this

Option names  Options    
Color,Size    Red-S        
Color,Size    Blue-S        
Color,Size    Yellow-S       
Color,Size    Red-M        
Color,Size    Blue-M        
Color,Size    Yellow-M        
Color,Size    Red-L

This is my code:

   foreach ($data as $product) {
       $variations = Products::where('group', $product['sku'])->get();

   }
       $count = count($variations);
       if($count > 0){
           $array2 = [];
           $ss = [];

           foreach($variations as $variants){
               $oname = explode(',', $variants['o_name']);
               $option = explode('-', $variants['option']);
               $array = array_combine($oname, $option);
               $array2[] = compact('array');
               $x = count($oname);
               $xz = $x - 1;
               for($i = 0; $i <= $xz; $i++){

                   $xs = $option[$i];

               }
               $ss[] = $xs;

           }

           dd($ss);

Output :

      array:12 [▼
      0 => "S"
      1 => "S"
      2 => "S"
      3 => "M"
      4 => "M"
      5 => "M"
      6 => "L"
      7 => "L"
      8 => "L"
      9 => "XL"
      10 => "XL"
      11 => "XL"
       ]

How can i create array like this

"Color" => "Red,Blue,Yellow"

Answer 1

$variations = Products::where('group', $product['sku'])->get();

//This is me emulating your results
$variations = [];
$variations[]= ['o_name'=>'Color,Size', 'option' =>'Red-S'];
$variations[]= ['o_name'=>'Color,Size', 'option' =>'Blue-S'];
$variations[]= ['o_name'=>'Color,Size', 'option' =>'Yellow-S'];
$variations[]= ['o_name'=>'Color,Size', 'option' =>'Red-M'];
$variations[]= ['o_name'=>'Color,Size', 'option' =>'Blue-M'];
$variations[]= ['o_name'=>'Color,Size', 'option' =>'Yellow-M'];
$variations[]= ['o_name'=>'Color,Size', 'option' =>'Red-L'];

//get all the possible options here
$all_options = [];
foreach ( $variations as $variants) {
    $oname = explode(',', $variants['o_name']);
    $option = explode('-', $variants['option']);
    $all_options[] = array_combine($oname, $option);
}

//aggregating attributes and values
$unique = [];
$keys = array_keys( $all_options[0]);
foreach ($keys as $key) {
    $unique[$key] = array_map(function($option) use ($key){
        return $option[$key];
    },$all_options);
}

//selecting unique values
foreach ($unique as $key => $value) {
    $unique[$key] = array_unique($unique[$key]);
    $unique[$key] = implode(',',$unique[$key]);
}

var_dump($unique);