Query eloquent belongsTo and hasMany (laravel-datatables)

If you are having problems with this

$ordenes =Client::with (['orders, orders.details'])->get(); 

then you need to show the Client model so we can see the orders relationship

Ideally also, your migrations.

You also need to name your variables correctly

this

$ordenes->details->name. 

is expecting $ordenes to be an order, but its not, its a collection of clients.

Model client:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Client extends Model
{
    protected $fillable = [
        'name_client','lastname','address','city','province','postal_code','country','phone_client','email'
    ];

    public $timestamps = true;

    public function company()
    {
        return $this->hasOne(Company::class);
    }    

    public function orders()
    {
        return $this->hasMany(OrderNote::class);
    } 
}

migrations clients:

    public function up()
    {
        Schema::create('clients', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name_client', 80);
            $table->string('lastname', 80);
            $table->string('address', 80)->nullable();
            $table->string('city', 80)->nullable();
            $table->string('province', 80)->nullable();
            $table->string('postal_code', 30)->nullable();
            $table->string('country', 60)->nullable();
            $table->string('phone_client', 30);
            $table->string('email', 100)->unique()->nullable();
            $table->timestamps();                      
        });
    }

migrations order_notes:

public function up()
    {
        Schema::create('order_notes', function (Blueprint $table) {
            $table->increments('id');

            $table->integer('client_id')->unsigned();          

            $table->integer('num_order')->unique();
            $table->enum('status', ['EN PROCESO', 'TERMINADO', 'NO TERMINADO'])->default('EN PROCESO');
            $table->timestamp('date')->nullable();
            $table->timestamp('finished_date')->nullable();

            $table->foreign('client_id')->references('id')->on('clients')
            ->onDelete('cascade')
            ->onUpdate('cascade');           
          
            $table->timestamps();
        });
    }

migrations order_details:

public function up()
    {
        Schema::create('order_details', function (Blueprint $table) {
            $table->increments('id');
            
            $table->integer('order_note_id')->unsigned();

            $table->integer('code')->unique();
            $table->string('name', 80);
            $table->integer('quantity');
            $table->mediumText('description')->nullable();

            $table->foreign('order_note_id')->references('id')->on('order_notes')
            ->onDelete('cascade')
            ->onUpdate('cascade'); 
            
           
            $table->timestamps();
        });
    }

How to access each detail in the collection to obtain its attributes. ? I modify my query?

You are going to have to be explicit about the key names since you don't follow convention.

Add the local and foreign keys to each relationship.

Also in your controller, did you mean to get all orders for all clients?

I was reviewing the relationships: model client:

   public function ordernotes()
    {
        return $this->hasMany(OrderNote::class);
    } 

model ordernote

public function client()
    {
        return $this->belongsTo(Client::class);
    }   

    public function orderdetails()
    {
        return $this->hasMany(OrderDetail::class, 'id', 'order_detail_id');
    } 

model orderdetail

  public function ordernote()
    {
        return $this->belongsTo(OrderNote::class, 'id' ,'order_note_id');
    }  

I still can't show the detail of each order that belongs to you to a client. What I want to show in my datatables are the orders with their details from all customers

I have problems with the product column I can not access the detail right here name and code:

    public function dataTable()
    {
        $clientes = OrderNote::with(['client', 'orderdetails'])->get();             
        return dataTables::of($clientes)
                ->addColumn('id', function ($clientes){
                    return $clientes->id;
                })  
                ->addColumn('fecha', function ($clientes){                 
                    
                    return $clientes->created_at->format('d-m-y');
                })
                ->addColumn('cliente', function ($clientes){

                    return
                        '<i class="fa fa-user"></i>'.' '.$clientes->client->name_client."<br>".
                        '<i class="fa fa-phone"></i>'.' '.$clientes->client->phone_client;
                                   
                }) 
              **  ->addColumn('producto', function ($clientes){
                    
                    return 
                    '<i class="fa fa-industry"></i>'.' '.$clientes->orderdetails->name."<br>".
                    '<i class="fa fa-phone"></i>'.' '.$clientes->orderdetails->code."<br>".
                  
                })**
                ->addColumn('estado', function ($clientes){
                    return $clientes->status;
                })                                              
                ->addColumn('accion', function ($clientes) {
                    return view('admin.orders.partials._action', [
                        'clientes' => $clientes,
                        'url_show' => route('admin.orders.show', $clientes->id),
                        'url_edit' => route('admin.orders.edit', $clientes->id),
                        'url_destroy' => route('admin.orders.destroy', $clientes->id)
                    ]);
                })
               
                ->addIndexColumn()   
                ->rawColumns(['fecha', 'cliente', 'producto', 'estado', 'accion'])                
                ->make(true);          
    }

I receive this error: Property [name] does not exist on this collection instance.

perhaps you have an order with no order details?

Edit

Actually, no, this is not going to work. You have MANY order details per order. You cannot list order and order details on the same row of a table due to the 1:many relationship

$clientes->orderdetails is a collection of orderdetails linked to order. You cannot pluck out a single 'name' since that would require it be a 1:1 relationship