Relationships

@tayyabshahzad1 You have a table products and a table franchises and their respected models (Product & Franchise) correct?

I also remember another question you had about products and franchises https://laracasts.com/discuss/channels/laravel/relationship-11.

My suggestion is to create a many-to-many relationship for franchises and products and add the columns you need there.

Create a franchises_products table, have the columns franchise_id, product_id, special_price, is_active.

Define the relationships

//in the Franchise model
public function products()
{
	return $this->belongsToMany(Product::class, 'franchises_products')
		->withPivot([
			'special_price',
			'is_active',
		]);
}

public function active_products()
{
	return $this->belongsToMany(Product::class, 'franchises_products')
		->withPivot([
			'special_price',
			'is_active',
		])
         ->wherePivot('is_active', 1);
}

//in theProduct model
public function franchises()
{
	return $this->belongsToMany(Franchise::class, 'franchises_products')
		->withPivot([
			'special_price',
			'is_active',
		]);
}

Make sure that whenever a new franchise is created, the table is filled with all the products

//in the franchise controller
public function store()
{
    //pseudo code to create the franchise
    $franchise->save();

    $products = Product::all()->pluck('id');

	$franchise->products()->syncWithPivotValues($products , ['is_active' => 1]);

Also, make sure that when a product is created, it is attached to all franchises

//in the product controller
public function store()
{
    //pseudo code to create the product
    $product->save();

    $franchises = Franchise::all()->keyBy('id')->transform(fn($franchise) => [
        'is_active' => 1
    ]);

	$product->franchises()->attach($franchises);

Now, when you want to show the active products of a franchise, you can do this

$franchise = Franchise::with('active_products')->find($franchise_id);

$data = []
foreach ($franchise->products as $product) {
	$data[] = [
		'id' => $product->id,
		'title' => $product->title,
		'price' => $product->pivot->special_price ?? $product->price
	];
}

return response()->json([
	'success' => true,
    'product' =>  $data,
]);