kevinbui

Lets make some parentheses:

SELECT * 
FROM `conversations` 
WHERE (sender_id = 3 AND receiver_id = 6)
OR (receiver_id = 6 AND sender_id = 3);

Or writing a query in the code:

Conversation::where(function ($query) use ($request) {
    $query->where('sender_id', $request->input('sender_id'))->where('receiver_id', $request->input('receiver_id'));
})->orWhere(function ($query) use ($request) {
    $query->where('sender_id', $request->input('receiver_id'))->where('receiver_id', $request->input('sender_id'));
})
->get();

Which line of code causes the issue?

The error happens at this line:

$purchase->productattribute()->createMany([
    'product_id' => $product->id,
    'sku'=>$request->sku,
    'colour'=>$request->colour        
]);

Instead of using the createMany method, pls simply use the create method:

$purchase->productattribute()->create([
    'product_id' => $product->id,
    'sku'=>$request->sku,
    'colour'=>$request->colour        
]);

@jimb814 You miss the semicolon ; inside each closure.

You might want to create custom validation rules for this:

namespace App\Rules;

use Illuminate\Contracts\Validation\Rule;

class ArrayContainsUniqueValues implements Rule
{
    public function passes($attribute, $value)
    {
        return collect($value)->duplicates()->isEmpty();
    }

    public function message()
    {
        return 'The :attribute array contains duplicate values.';
    }
}

namespace App\Rules;

use Illuminate\Contracts\Validation\Rule;

class ArrayContainsSequentialValues implements Rule
{
    public function passes($attribute, $value)
    {
        return $value == collect($value)->sort()->values()->toArray();
    }

    public function message()
    {
        return 'The :attribute array contains values that are not in sequential order.';
    }
}

Finally, inside the controller, you can say something like:

$request->validate([
    'your_array_field' => ['array', new ArrayContainsUniqueValues, new ArrayContainsSequentialValues]
]);

@jimb814 I have updated my answer accordingly above. Pls use the use keyword to include outside objects to be used in a closure.

Lets make some parentheses:

SELECT * 
FROM `conversations` 
WHERE (sender_id = 3 AND receiver_id = 6)
OR (receiver_id = 6 AND sender_id = 3);

Or writing a query in the code:

Conversation::where(function ($query) use ($request) {
    $query->where('sender_id', $request->input('sender_id'))->where('receiver_id', $request->input('receiver_id'));
})->orWhere(function ($query) use ($request) {
    $query->where('sender_id', $request->input('receiver_id'))->where('receiver_id', $request->input('sender_id'));
})
->get();

We have the following models and relationships:

class Category extends Model
{
    public function subCategories()
    {
        return $this->hasMany(SubCategory::class);
    }
}

class SubCategory extends Model
{
    public function records()
    {
        return $this->hasMany(Record::class);
    }
}

class Record extends Model
{
}

In the controller, you can do something like:

class CategoriesController extends Controller
{
    public function index()
    {
        $categories = Category::with('subCategories.records')->get();

        return view('categories.index', compact('categories'));
    }
}

And finally, in the view, you can say:

@foreach($categories as $category)
    <h1>{{ $category->name }} ({{$category->subcategories->flatMap->records->count()}}):</h1>
    @foreach($category->subCategories as $subCategory)
        <h3>{{ $subCategory->name }} ({{$ subCategory->records->count() }})</h3>
    @endforeach
@endforeach

I believe there are cleaner and more performant approach, but this is gonna achieve your results straightaway.

We have the following models and relationships:

class Category extends Model
{
    public function subCategories()
    {
        return $this->hasMany(SubCategory::class);
    }
}

class SubCategory extends Model
{
    public function records()
    {
        return $this->hasMany(Record::class);
    }
}

class Record extends Model
{
}

In the controller, you can do something like:

class CategoriesController extends Controller
{
    public function index()
    {
        $categories = Category::with('subCategories.records')->get();

        return view('categories.index', compact('categories'));
    }
}

And finally, in the view, you can say:

@foreach($categories as $category)
    <h1>{{ $category->name }} ({{$category->subcategories->flatMap->records->count()}}):</h1>
    @foreach($category->subCategories as $subCategory)
        <h3>{{ $subCategory->name }} ({{$ subCategory->records->count() }})</h3>
    @endforeach
@endforeach

I believe there are cleaner and more performant approach, but this is gonna achieve your results straightaway.