Trying to get only the specific products for each order in Laravel using arrays

Question

I am trying to display an order page for users based on two tables: orders and order_product.

The orders table keeps all the useful data for an order, as seen in the model:

Order.php

    protected $fillable = [
        'user_id', 'billing_fname', 'billing_lname', 'billing_email', 'billing_phone','billing_address',
        'billing_county', 'billing_locality', 'billing_zipcode', 'billing_total', 'shipped'
    ];
public function user(){
        return $this->belongsTo('App\User');
    }

    public function products(){
        return $this->belongsToMany('App\Product')->withPivot('quantity');
    }

The order_product table displays infos about how many products were bought on that order and what quantity for each product.

OrderProduct.php

protected $table = 'order_product';

    protected $fillable = ['order_id', 'product_id', 'quantity'];

Now, the problem is I want to display all these bounded infos in a view but I am getting all the products id's from all the orders not only the specific one:

myorders.blade.php


    @foreach($orders as $order)
    
  
    
      Order {{$order->id}}
      
        @if(!$o->shipped)
            Not shipped.
        @else
            Shipped.
        @endif
    
    
    User: {{$order->billing_fname}} {{$order->billing_lname}} | Date: {{$order->created_at}} | Total: {{$order->billing_total}} $
    Adresa: {{$order->billing_county}} {{$order->billing_address}} {{$order->billing_city}}
  
  @foreach($products as $product)
  
    
      {{$product->name}}
      Cantitate: {{$product->quantity}}
    
    Price: {{$product->price}}
  
  @endforeach

@endforeach

In the controller I tried to access all the data in 3 different foreach statements, as follows:

OrderController

public function index()  
    {  
            
        $user_id = Auth::user()->id;
        $orders = Order::where('user_id', $user_id)->get();   //from orders table I need all the orders placed by the authenticate user 

        $items = array();
        foreach($orders as $order){
            $items[] = OrderProduct::where('order_id', $order->id)->first();     //from order_product (the pivot table) I need all the data from order_id equals the id in orders
        }

        $products = array();
        foreach($items as $item){
            $prod = Product::where('id', $item->product_id)->first();   //searching for the products in the products table with the id's from order_product
            $products[] = $prod;
        }
        return view('orders.myorders', array(
            'orders' => $orders,
            'products' => $products
        ));

        // dd($products);
        
    }

What I am getting is all the products foreach order, so the view looks something like:

First order id:

-all the products found in array

Second order id:

-again all the products found in array

-and so on, while I only need the specific products for that order

Please feel free to ask anything if I wasn't clear enough. I am new in this field and I would appreciate any piece of advice.

Thanks a bunch.

user_14781353 · Answer

I solved this by using the following logic:

//details of a specific order
    public function index($id) {
        $orders = Order::where('_id', $id)->first();
        
        $details = OrderProduct::where('order_id', $id)->get();    //for an order with the same id we can have multiple products => array
        $product_id = OrderProduct::where('order_id', $id)->get(['product_id']);    //accessing the product from the linked table

        $items = array();
        $products = array();
        foreach($details as $detail){
            $items[] = $detail->product_id;    //an array with all the details from the specific order

            $prod = Product::findOrFail($detail->product_id);   //we add the products with the corresponding id in our products array
            $products[] = $prod;
        }

        return view('orders.myorder', array(
            'orders' => $orders,
            'details' => $details,
            'products' => $products   //returning all the details, orders for accessing the details from Orders, details for accessing all the product's id from that order (OrderProduct and products for getting access to all the products (Products)
        ));

        // dd($items);
    }

And the blade file which displays all the details:


    {{ __('Order no.') }} {{$orders['id']}}

  
    
    {{ __('User Details') }}
         
            {{ __('First Name') }}: {{$orders['billing_fname']}} {{$orders['billing_lname']}}
         
         
            {{ __('Last Name') }}: {{$orders['billing_email']}}
         
         
            {{ __('Phone') }}:  {{$orders['billing_phone']}}
         
         
            {{ __('Address') }}:  {{$orders['billing_address']}}
         
         
            {{ __('County') }}:  {{$orders['billing_county']}}
         
         
            {{ __('City') }}:  {{$orders['billing_city']}}
         
         
            {{ __('Zipcode') }}:  {{$orders['billing_zipcode']}}
         
         
            
            {{ __('Total') }}:  {{$orders['billing_total']}}
         
         
            Status:  {{ $orders['shipped'] === "1" ? __('Shipped') : __('Not shipped') }}
         
    
    
    {{ __('Ordered products') }}
         
               @foreach($products as $product)
               
                    @foreach($details as $detail)
                        @if($product->id == $detail->product_id) 
                            
                        @endif
                   @endforeach 
                  
               @endforeach
            
            
               
                  {{ __('Product Name') }}
                  {{ __('Image') }}
                  {{ __('Price') }}
                  {{ __('Quantity') }}
                  {{ __('Date') }}
               
            
            
                  
                     {{ $product->name }}
                  
                  
                  
                     {{$product->price}} RON
                  {{ $detail->quantity }} buc 
                     {{$orders['created_at']}}
                  
               
         
         
            {{ __('Back') }}

This might be a little bit too difficult to follow, my logic is quite complicated but I hope some of you may find some help in it.

user_3743890 · Answer

You can do this with less coding, with these changes:

changes in Order.php

 public function orderProducts(){
    return $this->hasMany('App\OrderProduct');
}

changes in OrderProduct.php

 public function products(){
    return $this->hasOne('App\Product')->withPivot('quantity');
}

changes in OrderController.php:

 public function index()  
{  
   
    $user_id = Auth::user()->id;
    $orders = Order::where('user_id', $user_id)->get();   
    return view('orders.myorders', array('orders' => $orders));
}

and changes in myorders.blade.php:


@foreach($orders as $order)

  
    
      Order {{$order->id}}
      
        @if(!$o->shipped)
            Not shipped.
        @else
            Shipped.
        @endif
    
    
    User: {{$order->billing_fname}} {{$order->billing_lname}} | Date:     {{$order->created_at}} | Total: {{$order->billing_total}} $
    Adresa: {{$order->billing_county}} {{$order->billing_address}} {{$order->billing_city}}
  
  @foreach($order->orderProducts()->get() as $orderProduct)
  
    
      {{$orderProduct->product->name}}
      Cantitate: {{$orderProduct->product->quantity}}
    
    Price: {{$orderProduct->product->price}}
  
  @endforeach

@endforeach

Trying to get only the specific products for each order in Laravel using arrays

2 Answers