Link to related model in index

[futurewebsites]

Hi TwillSeekers,

Is it possible to link to a related model in the index view? for example if you have a list of customers and each customer can have one or more (one to many relation) addresses is it possible to link to the related customer_addresses model and have it pre-filtered to just that customers addresses.

customers:
id, first_name, last_name, email

addresses:
id, customer_id, street, town, state, zip_code, phone

if this is not possible how would you tackle it?

Many thanks in advance

[ifox]

Hi @futurewebsites, yes! That would be using a submodule, using dot notation. In your case customers.addresses. See #508.

[futurewebsites]

Hi @ifox thanks for the quick reply, that looks exactly what I need, I have followed the steps in #508 but for some reason the routing isn't working:

Route [admin.customerAddresses.index] not defined

my admin routes are as follows:

Route::module('customers');
Route::module('customers.addresses');

CustomerAddress controller:

    protected $moduleName = 'customers.addresses';
    protected $modelName = 'CustomerAddress';

    protected function getParentModuleForeignKey()
    {
        return 'customer_id';
    }

    protected function indexData($request)
    {
        $customer = app(CustomerAddressRepository::class)->getById(request('customers'));
        return [
            'breadcrumb' => [
                [
                    'label' => 'Customer',
                    'url' => moduleRoute('customers', 'collection', 'index'),
                ],
                [
                    'label' => $customer->email,
                    'url' => moduleRoute('customers', 'collection', 'edit', $customer->id),
                ],
                [
                    'label' => 'Addresses',
                ],

            ],
        ];
    }

    protected function formData($request)
    {
        $customer = app(CustomerAddressRepository::class)->getById(request('customers'));
        return [
            'breadcrumb' => [
                [
                    'label' => 'Customer',
                    'url' => moduleRoute('customers', 'collection', 'index'),
                ],
                [
                    'label' => $customer->email,
                    'url' => moduleRoute('customers', 'collection', 'edit', $customer->id),
                ],
                [
                    'label' => 'Addresses',
                    'url' => moduleRoute('customers.addresses', 'collection', 'index', $request->route('customers')),
                ],
                [
                    'label' => $customer->email,
                ],
            ],
        ];
    }

[futurewebsites]

Ignore me it was unrelated - the error referred to the existing navigation route set up in twill-navigation.php :)