<?php
//CourierStopsResource.php

use \koolreport\dashboard\admin\Resource;
use \koolreport\dashboard\fields\ID;
use \koolreport\dashboard\fields\Text;
use \koolreport\dashboard\fields\Date;
use \koolreport\dashboard\fields\Number;

class CourierStopsResource extends Resource
{
    
    protected function onCreated()
    {
        $this->manageTable("mec_courierstops")->inSource(MECLogs::class);
    }

    protected function fields()
    {
        return [
            ID::create("stopNumber")
                ->showOnCreate(false)
                ->showOnIndex(false),
            Date::create("stopDate")
                ->sortable(true)
                ->sort("desc"),
            
            Text::create("locationName")
                ->inputWidget(
                    Select::create()
                    ->dataSource(function(){
                        return MECLogs::table("mec_locations")
                                ->select("locationId,locationName");
                    })
                    ->fields(function(){
                        return [
                            Text::create("locationName")
                        ];
                    })
                ),
                
            Number::create("covidCount")
            ->label("COVID Count"),
            Number::create("utiCount")
            ->label("UTI Count"),
            Text::create("notes")
            ->label("Notes"),
        ];
    }
}

On Resource Table List, I want to see: Stop Date, Location Name, Covid Count, UTI Count, Notes

On Create page, I want to enter: Stop Date, Location ID, Covid Count, UTI Count, Notes

Create page works but on list page, I see the Location Id instead of Location Name. How can I change it to show the Location Name from the Locations table?

Thanks, I'm returning the right data. How do I show the locationName on the table and in the Select option on the Create page but pass the locationId on the Create page. This code is showing and passing the right information on the Create page but not showing the locationName on the List table.

Text::create("locationName")

            ->inputWidget(
                Select::create()
                ->dataSource(function(){
                    return MECLogs::table("mec_locations")
                            ->select("locationId,locationName");
                })
                ->fields(function(){
                    return [
                        Text::create("locationName")
                    ];
                })
            ),

Ok, figured out the list page and the create page. When click the View and Edit for the row, it doesn't show the row details. How do I get that to work?

Still having an issue. So, if I use this code, it shows the correct locationName on the list page but when I try create a new entry, it fails because I need to pass locationId to the table not locationName. But if I change to Number::create("locationId") the create entry works but the list table shows locationId.

How do I show locationName but pass locationId?

Text::create("locationName")

        ->inputWidget(
            Select::create()
            ->dataSource(function(){
                return MECLogs::table("mec_locations")
                        ->select("locationId,locationName");
            })
            ->fields(function(){
                return [
                    Text::create("locationName")
                ];
            })
        ),

Got it working. Added an additional Text field showing on the Index List only.