Help with a join query

@ollie_123

Did you test intersect? Should be good to have your feedback ...

Hey @sr57, i tried intersect but i don't think its quite right as its just returning all values from the brand_options table whereas i need to exclude all options from the brand_options table that match the values on the product_options table leaving only un assigned brand_options to be assigned.

$brandOptions = BrandOption::where('brand_id', $this->brand)->get();
$productOptions = ProductOption::get();

$collection = collect([$brandOptions, $productOptions]);
$intersect = $collection->intersect([$brandOptions]);

Any questions, please let me know. Thanks in advance.

@ollie_123

YES sorry

It should be diff & co

https://laravel.com/docs/9.x/collections#method-diff

https://laravel.com/docs/9.x/collections#method-diffassoc

https://laravel.com/docs/9.x/collections#method-diffkeys

Hi @sr57, thanks for this. Using diff i'm getting an undefined error in my blade foreach so i'm guessing its an empty array.

Does this work using the foreign keys in the ProductOption model i.e belongsTo(BrandOption::class, 'brand_option_id'?

This is where im currently at with the diff

$bo = BrandOption::where('brand_id', $this->brand)->get();
$po = ProductOption::where('product_id', $this->pid)->get();
        
$collection = collect([$bo, $po]);
$brandOptions = $collection->diff($po);

if you could advise where i might be going wrong it would be much appreciated.

Thanks in advance.

@ollie_123

all brand options that aren't assigned to that particular product

all brand options

     $bos=BrandOption::pluck('id')

don't understand why you filter by $this->brand in your code

product options

     $product_bos=ProductOption::where('product_id', $this->pid)->pluck('brand_option_id');

all brand options that aren't assigned to that particular product

     $bos_available = $bos->diff($product_bos);

Hey @sr57

So the don't understand why you filter by $this->brand in your code is so i can filter down the brand options based on the product brand.

If i dd currently i get:-

 #items: array:11 [▼
    0 => 1
    1 => 2
    2 => 3
    3 => 4
    4 => 5
    5 => 6
    6 => 7
    7 => 8
    8 => 9
    9 => 10
    10 => 12

@ollie_123

Step after step, does $bos_available returns the right values?

For your blade error, it's another pb, probably because you have to complete my answer with the option names ...

Share your controller and blade code if needed ... better in another thread (one question per thread and I have to leave now)

Hey @sr57 TBH the array just shows the numbers incrementing which align with the brand options table but not the product options table.

I currently have...

For the controller/component:-

$bo = BrandOption::pluck('id');
$po = ProductOption::where('product_id', $this->pid)->pluck('brand_option_id');
$brandOptions = $bo->diff($po);

For the blade:-

@foreach($brandOptions as $option)
<div class="flex items-center py-2">
    <input type="checkbox" required value="{{ $option->id }}" wire:model="option_id_arr">
    <div class="form-input-label">{{ $option->attribute_name }}</div>
</div>.....

Also i didnt want to start a new thread as this is the same question i posted initially. ;)

Any questions, please let me know. Thanks in advance.

@ollie_123

the array just shows the numbers incrementing which align with the brand options table but not the product options table.

So it was you are looking for ?

As I wrote before, the blade cannot work with that query that returns only the id, you have to add the name (attribute_name)

@sr57

"So it was you are looking for ?" Unfortunatley not quite, for example, on the View Product Page where i can add options to the product, i already have options associated to the product but when i go to add more and dd the array it shows all options from the brand_options table so doesnt appear to be filtering out the brand_options already associated.

If you wanted me to show the table layouts please let me know as sometimes i don't explain myself too well lol.

Thank you in advance.

@ollie_123

Communication is always a difficult art and it seems that I can't get your need or you don't understand my/our answers. Personally I'll be rarely here next days, I suggest you to reread all the answers you got, normally you should be able to find the solution by yourself, if not, try rephrase your need the simpler as possible ( 1 step / 1 question). Good luck.

Hey @sr57, no worries, i appreciate you taking the time to help on this. I managed to get it working in the end with a couple of queries but you definitely helped me in the right direction so will mark your post as best answer.

Thanks again for your help. Much appreciated.