php - Display email column from another table instead of referencing ID in laravel backpack

3 of the tables in my database are:

1. Orders
2. Products
3. User

This is the migration of orders table

public function up()
{
    Schema::create('orders', function (Blueprint $table) {
        $table->id();
        $table->foreignId('user_id')->constrained();  // FK to Users table
        $table->foreignId('product_id')->constrained();  // FK to product table
        // ...
        $table->timestamps();
    });
}

Copy code

Now when I am Listing all the data in my Admin panel, I want to display:

1. email (which is unique) from user Table instead ofuser_id
2. product_name (which is also unique) from products Table instead ofproduct_id

app/Http/Controllers/Admin/OrderCrudController.php

[
            'name'  => 'user_id', // Table column which is FK for Customer table
            'label' => 'User', // Label for HTML form field
            'type'  => 'select2',  // HTML element which displaying transactions
            
            'placeholder' => 'Select a User', // placeholder for the select
            'allows_null' => true,
            'attribute' => 'email', // Column which user see in select box
            'minimum_input_length' => 1,
            'hint' => 'The person who ordered the product',
        ],
        [
            'name'  => 'product_id',
            'label' => 'Product',
            'type' => 'select',

            'placeholder' => 'Select a Product', // placeholder for the select
            'allows_null' => true,
            'attribute' => 'name', // Column which user see in select box
            'minimum_input_length' => 1,
            'hint'  => 'The product which was ordered',
        ],
]
Copy code

When I use the above code inprotected function setupCreateOperation(), it gives me the desired results.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.