Problem with dynamically generated classes

It looks like the issue you're encountering is related to the dynamic determination of the table and connection in your CdrArchiveDinamyc class. The error SQLSTATE[HY000] [2002] No such file or directory suggests that there might be a problem with the database connection configuration or the way the connection is being set dynamically.

Here are a few steps to troubleshoot and potentially resolve the issue:

1. Check Database Configuration: Ensure that the database connections are correctly configured in your config/database.php file. Specifically, check the mysql_cdr connection settings.

2. Verify Dynamic Connection and Table Logic: Make sure that the logic for setting the table and connection in the CdrArchiveDinamyc class is correct and that it properly handles different dates.

3. Ensure Livewire Component Uses Correct Connection: When you click on the Livewire component, ensure that the component is using the correct connection and table. You might need to pass the connection and table information to the Livewire component.

4. Debugging: Add some debugging statements to verify that the correct connection and table are being used at each step.

Here is a refined version of your code with some additional debugging and improvements:

// CdrArchiveDinamyc.php
class CdrArchiveDinamyc
{
    protected $table;
    protected $connection;

    public function __construct($date)
    {
        if ($date === Carbon::today()->format('Y-m-d')) {
            $this->table = 'cdr';
            $this->connection = 'mysql_cdr';
        } else {
            $this->table = 'cdr_' . $date;
            $this->connection = 'mysql_cdr_archive';
        }
    }

    public function getTable()
    {
        return $this->table;
    }

    public function getConnection()
    {
        return $this->connection;
    }
}

// Your method
public function filterDetails(): array
{
    $cdrInstance = new CdrArchiveDinamyc(Carbon::parse($this->fromDate)->format('Y-m-d'));

    // Set the connection and table dynamically
    $connection = $cdrInstance->getConnection();
    $table = $cdrInstance->getTable();

    // Debugging
    \Log::info("Using connection: $connection and table: $table");

    // Assuming you have a model for CDR
    $cdrModel = new CdrModel();
    $cdrModel->setConnection($connection);
    $cdrModel->setTable($table);

    // Filtering logic
    $builtQuery = $cdrModel->newQuery();
    // Add your filtering conditions here

    $summaryQuery = $cdrModel->newQuery();
    // Add your summary conditions here

    return [
        ...$builtQuery->selectRaw(
            'COUNT(*) AS `today_number_of_calls`, SUM(`call_cost`) AS `today_call_cost`'
        )->first()->toArray(),
        'items' => $summaryQuery->select('*')->get(),
    ];
}

// In your Livewire component
public function setShowCdrDetails($itemId)
{
    $cdrInstance = new CdrArchiveDinamyc(Carbon::parse($this->fromDate)->format('Y-m-d'));
    $connection = $cdrInstance->getConnection();
    $table = $cdrInstance->getTable();

    // Debugging
    \Log::info("Fetching details for item: $itemId using connection: $connection and table: $table");

    $cdrModel = new CdrModel();
    $cdrModel->setConnection($connection);
    $cdrModel->setTable($table);

    $item = $cdrModel->find($itemId);

    if ($item) {
        // Do something with the item
    } else {
        // Handle the case where the item is not found
    }
}

Key Points:

1. Dynamic Connection and Table Setting: Ensure that the connection and table are set dynamically based on the date.
2. Debugging: Add logging to verify that the correct connection and table are being used.
3. Livewire Component: Ensure that the Livewire component uses the correct connection and table when fetching details.

By following these steps, you should be able to identify and resolve the issue with dynamically generated classes and database connections.