Model.php

<?php

// Import additionnal class into the global namespace
use \LaswitchTech\Core\Base\BaseModel;

class FollowupsModel extends BaseModel {

    /**
     * Constructor
     */
    public function __construct()
    {
        // Call the parent constructor
        parent::__construct();

        // Initialize the Model
        $this->init('followups');
    }

    /**
     * Initialize the Model
     *
     * @param string $table
     * @param string|null $primary
     * @return void
     */
    protected function init(string $table, ?string $primary = 'id'): void
    {
        // Call the parent init method
        parent::init($table, $primary);

        // Loop through the additional tables to join
        foreach($this->definition as $field => $col){

            // Check if the field contains a dot
            if(strpos($field, '.') === false) continue;

            // Set the table
            $table = in_array(explode('.',$field)[1],['owner', 'assignedTo']) ? 'users' : explode('.',$field)[1] . 's';
            $table = in_array(explode('.',$field)[1],['category']) ? 'categories' : $table;

            // Check if the field is linked to a table
            if(in_array($table, $this->tables)){

                // Initialize the Schema
                $schema = $this->Database->schema()->define($table);

                // Describe the table
                foreach($schema->describe() as $col){

                    // Add the col to the definition
                    $this->definition[$field.'.'.$col['Field']] = $col;
                }
            };
        }
    }

    /**
     * Process a record
     *
     * @param array $record
     * @return array
     */
    protected function process(array $record): array
    {
        // Call the parent constructor
        $record = parent::process($record);

        // Check if the record has a task
        if(array_key_exists('task', $record) && array_key_exists('process', $record['task'])){

            // Check if the process is a valid JSON string
            if(is_string($record['task']['process']) && $this->isJson($record['task']['process'])){

                // Decode the JSON value
                $record['task']['process'] = json_decode($record['task']['process'], true);
            }
        }

        // Check if the vcard exists in the record
        if(array_key_exists('vcard', $record)){

            // Check if the vcard has tags
            if(array_key_exists('tags', $record['vcard'])){

                // Check if the process is a valid JSON string
                if(is_string($record['vcard']['tags']) && $this->isJson($record['vcard']['tags'])){

                    // Decode the JSON value
                    $record['vcard']['tags'] = json_decode($record['vcard']['tags'], true);
                }
            }

            // Check if the vcard has industries
            if(array_key_exists('industries', $record['vcard'])){

                // Check if the process is a valid JSON string
                if(is_string($record['vcard']['industries']) && $this->isJson($record['vcard']['industries'])){

                    // Decode the JSON value
                    $record['vcard']['industries'] = json_decode($record['vcard']['industries'], true);
                }
            }
        }

        // Return the processed record
        return $record;
    }

    /**
     * Apply Joins to the Query
     *
     * @param Query $Query
     * @return Query
     */
    protected function joins(object $Query): object
    {
        // Apply Joins
        $Query->join('vcard', 'vcards', 'id')
            ->join('task', 'tasks', 'id')
            ->join('task.assignedTo', 'users', 'id');

        return $Query;
    }
}