Check Empty Fields - Orange 5.3

Question

I have an entire field and a date field that are not mandatory and are programmed to accept NULL, but when I send the form data without filling it in my controller receives the empty value instead of ignoring the field, which generates the error:

Incorrect integer value: '' for column vendedor_id

how can I fix this?

Migration:

 $table->integer('vendedor_id')->unsigned()->nullable();
 $table->date('data_venda')->nullable();

Controller:

$new = $this->repository->create($request->all());

View:

<div id="vendedor_id" class="form-group col-sm-4 opt">
    <label for="vendedor_id">Vendedor:</label>
    <select name="vendedor_id" class="form-control select2">
        <option value=""></option>
        <option value="1">User 1</option>
        <option value="2">User 2</option>
    </select>
</div>
<div id="data_venda" class="form-group col-sm-4">
    <label for="data_venda">Data:</label>
    <input type="date" name="data_venda" class="form-control">
</div>

In my request I have some validations for the required fields, but it does not include anything about these 2 fields. Ex.:

public function rules()
{
    return [
        'cnpj' => 'numeric|required|cnpj|unique:empresas',
        'razao_social' => 'required',
    ];
}

Answer 1

If no value is chosen on that select he’s sending "" ai mora the problem, need to be checked before sending to that layer repository:

$data = $request->except('vendedor_id');
$data['vendedor_id'] = $request->input('vendedor_id', "") == "" 
                      ? null
                      : (int)$request->input('vendedor_id')
$new = $this->repository->create($data);

Answer 2

I will pass some solutions below that the framework itself offers:

Model Mutators

It is possible to define a behavior for the definition of a certain attribute of a Model in Laravel.

For example, for you to not have to define at all times verification conditions of a field in your controller, you can create a setter specific to these fields in your Model.

Behold:

  public function setVendedorIdAttribute($valor) {
      $this->attributes['vendedor_id'] = ctype_digit($valor) ? $valor : NULL;
  }

So every time an empty value was passed, it would be inserted as NULL at the bank.

Validation

According to documentation from Laravel 5.3, it is possible, from this version, to define a validation nullable for a given field.

Array_filter

Another solution would be to use array_filter that removes the empty values of a array.

$data = array_filter($request->all());
$new = $this->repository->create($data);

Array_map

If you just want to convert the empty values to NULL, you can also use array_map as a solution:

$data = array_map($request->all(), function ($value) {
  return $value ?: NULL;
});