Filament•3y ago•

1 reply

Must <foreign_model>_id be fillable to save it on resource creation?

I have two models, Opportunity -> belongsTo -> Company. The

opportunities

opportunities

table has a

company_id

company_id

field which is * not nullable* to ensure data integrity. The

Opportunity

Opportunity

model has a relationship

company

company

class Opportunity extends Model
{
  protected $fillable = [
    // attributes of Opportunity, WITHOUT `company_id`
  ];

  public function company(): BelongsTo
  {
      return $this->belongsTo(Company::class, 'company_id');
  }
}

class Opportunity extends Model
{
  protected $fillable = [
    // attributes of Opportunity, WITHOUT `company_id`
  ];

  public function company(): BelongsTo
  {
      return $this->belongsTo(Company::class, 'company_id');
  }
}

Note that

company_id

company_id

is not included in

$fillable

$fillable

, as other sections of my app outside the Filament admin panel should not be able to alter this relationship through requests.

My

OpportunityResource::form

OpportunityResource::form

field for the relationship:

Forms\Components\Select::make('company_id')
  ->label('Company')
  ->relationship(name: 'company', titleAttribute: 'name')
->required(),

Forms\Components\Select::make('company_id')
  ->label('Company')
  ->relationship(name: 'company', titleAttribute: 'name')
->required(),

On the

EditOpportunity

EditOpportunity

page, I can alter the associated company just fine. On

CreateOpportunity

CreateOpportunity

however, I can select a company but I get this error:

SQLSTATE[HY000]: General error: 1364 Field 'company_id' doesn't have a default value

SQLSTATE[HY000]: General error: 1364 Field 'company_id' doesn't have a default value

If I add

company_id

company_id

Opportunity::$fillable

Opportunity::$fillable

, it works as expected.
I'd expect consistent behavior between Create and Edit, so either require

company_id

company_id

$fillable

$fillable

on both operations or on neither.

Must <foreign_model>_id be fillable to save it on resource creation?

I have two models, Opportunity -> belongsTo -> Company. The

opportunities

opportunities

table has a

company_id

company_id

field which is * not nullable* to ensure data integrity. The

Opportunity

Opportunity

model has a relationship

company

company

class Opportunity extends Model
{
  protected $fillable = [
    // attributes of Opportunity, WITHOUT `company_id`
  ];

  public function company(): BelongsTo
  {
      return $this->belongsTo(Company::class, 'company_id');
  }
}

class Opportunity extends Model
{
  protected $fillable = [
    // attributes of Opportunity, WITHOUT `company_id`
  ];

  public function company(): BelongsTo
  {
      return $this->belongsTo(Company::class, 'company_id');
  }
}

Note that

company_id

company_id

is not included in

$fillable

$fillable

, as other sections of my app outside the Filament admin panel should not be able to alter this relationship through requests.

My

OpportunityResource::form

OpportunityResource::form

field for the relationship:

Forms\Components\Select::make('company_id')
  ->label('Company')
  ->relationship(name: 'company', titleAttribute: 'name')
->required(),

Forms\Components\Select::make('company_id')
  ->label('Company')
  ->relationship(name: 'company', titleAttribute: 'name')
->required(),

On the

EditOpportunity

EditOpportunity

page, I can alter the associated company just fine. On

CreateOpportunity

CreateOpportunity

however, I can select a company but I get this error:

SQLSTATE[HY000]: General error: 1364 Field 'company_id' doesn't have a default value

SQLSTATE[HY000]: General error: 1364 Field 'company_id' doesn't have a default value

If I add

company_id

company_id

Opportunity::$fillable

Opportunity::$fillable

, it works as expected.
I'd expect consistent behavior between Create and Edit, so either require

company_id

company_id

$fillable

$fillable

on both operations or on neither.

Must <foreign_model>_id be fillable to save it on resource creation?

Similar Threads

Must <foreign_model>_id be fillable to save it on resource creation?

Similar Threads

Similar Threads

Similar Threads