Good afternoon.
I'm having difficulty popping a select with records from my database.
I have an employee table that relates to 3 other tables (Cargo, Sector and Department). Currently I can only select select if the registry is in the view, but I have implemented the Laravel SoftDeletes feature that delete a record from the view and keep it saved in the database and when I do this, the information already disappears from the select.
Can anyone help me pull this data directly from the bank?
My employee model looks like this:
<?php
namespace App\Models\Treinamento;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
class Funcionario extends Model
{
protected $fillable = [
'nome_funcionario', 'email_funcionario', 'instrutor',
'cargos_id', 'nome_cargo',
'cetors_id', 'nome_cetor',
'departamentos_id', 'nome_departamento',
];
use SoftDeletes;
protected $dates = ['deleted_at'];
}
Employee migration looks like this:
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateFuncionarios extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('funcionarios', function (Blueprint $table) {
$table->increments('id');
$table->string('nome_funcionario');
$table->string('email_funcionario');
$table->string('instrutor');
$table->integer('cargos_id')->unsigned()->nullable();
$table->foreign('cargos_id')->references('id')->on('cargos');
$table->integer('cetors_id')->unsigned()->nullable();
$table->foreign('cetors_id')->references('id')->on('cetors');
$table->integer('departamentos_id')->unsigned()->nullable();
$table->foreign('departamentos_id')->references('id')->on('departamentos');
$table->softDeletes();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('funcionarios');
}
}
The employee view looks like this:
@extends('adminlte::page')
@section('title', 'Módulo de Treinamento')
@section('content_header')
<center>
<br>
<h3 style="margin-top: -30px;">Gerenciador de Funcionários</h3>
</center>
@stop
@section('content')
<br>
<div class="row">
<div class="col-lg-12 margin-tb">
<div class="pull-right">
<!-- Button trigger modal -->
<button type="button" class="btn btn-success" data-toggle="modal" data-target=" .bd-example-modal-lg">Incluir Funcionário</button>
</div>
<!-- Modal -->
<div class="modal fade bd-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<div class="modal-dialog modal-lg">
<div class="modal-content">
<form action="{{ route('funcionarios.store') }}" method="POST">
@csrf
<div class="container box box-success">
<br>
<div class="row">
<div class="col-md-4">
<strong>Nome do Novo Funcionário:</strong>
<input type="text" name="nome_funcionario" class="form-control" placeholder="Digite o nome..." required="ON">
</div>
<div class="col-md-4">
<strong>Email do Novo Funcionário:</strong>
<input type="email" name="email_funcionario" class="form-control" placeholder="Digite o nome..." required="ON">
</div>
<div class="col-md-4">
<strong>Ele é instrutor?</strong>
<select name="instrutor" class="form-control" required="ON">
<option value="">Clique aqui</option>
<option value="Sim">Sim</option>
<option value="Nao">Não</option>
<select>
</div>
</div>
<br>
<div class="row">
<div class="col-md-4">
<strong>Selecione o Cargo</strong>
<select name="cargos_id" class="form-control" required="ON">
<option value="">Clique aqui</option>
@foreach ($classcargo_array as $cargos_id)
<option value="{{$cargos_id->id}}" > {{$cargos_id->nome_cargo}}</option>
@endforeach
</select>
</div>
<div class="col-md-4">
<strong>Selecione o Setor</strong>
<select name="cetors_id" class="form-control" required="ON">
<option value="">Clique aqui</option>
@foreach ($classcetor_array as $cetors_id)
<option value="{{$cetors_id->id}}" > {{$cetors_id->nome_cetor}}</option>
@endforeach
</select>
</div>
<div class="col-md-4">
<strong>Selecione o Departamento</strong>
<select name="departamentos_id" class="form-control" required="ON">
<option value="">Clique aqui</option>
@foreach ($classdepartamento_array as $departamentos_id)
<option value="{{$departamentos_id->id}}" > {{$departamentos_id->nome_departamento}}</option>
@endforeach
</select>
</div>
</div>
<br>
<div class="row">
<div class="col-md-4">
</div>
<div class="col-md-4">
<center><button type="button" class="btn btn-secondary" data-dismiss="modal">Cancelar</button></center>
</div>
<div class="col-md-4">
<button type="submit" class="btn btn-sic btn-success btn-block btn-flat ">Enviar</button>
</div>
</div>
<br>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<head>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css">
<script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.3.1.js"></script><scripttype="text/javascript" language="javascript" src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script><scripttype="text/javascript" language="javascript" src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script><scripttype="text/javascript" class="init">
$(document).ready(function() {
$('#tobarril').DataTable({
"language": {
"lengthMenu": "Visualizando _MENU_ itens por página",
"zeroRecords": "Item não encontrado",
"info": "Visualizando página _PAGE_ de _PAGES_",
"infoEmpty": "No records available",
"infoFiltered": "(Filtrado from _MAX_ total records)"
}
}
);
} );
</script>
</head>
<br>
<div class="container box box-success">
</div>
<br>
<table id="tobarril" class="table table-bordered">
<thead>
<tr>
<th><center>N°</center></th>
<th><center>Nome</center></th>
<th><center>Email</center></th>
<th><center>Instrutor</center></th>
<th><center>Cargo</center></th>
<th><center>Setor</center></th>
<th><center>Departamento</center></th>
<th width="150px"><center>Ação</center></th>
</tr>
</thead>
@foreach ($funcionarios as $funcionario)
<tbody>
<tr>
<td><center>{{ $funcionario->id }}</center></td>
<td><center>{{ $funcionario->nome_funcionario }}</center></td>
<th><center>{{ $funcionario->email_funcionario }}</center></th>
<th><center>{{ $funcionario->instrutor }}</center></th>
<th><center>{{ $funcionario->cargos_id }}</center></th>
<th><center>{{ $funcionario->cetors_id }}</center></th>
<th><center>{{ $funcionario->departamentos_id }}</center></th>
<td>
<center>
<form action="{{ route('funcionarios.destroy',$funcionario->id) }}" method="POST">
<a class="btn btn-primary" href="{{ route('funcionarios.edit',$funcionario->id) }}">Editar</a>
@csrf
@method('DELETE')
<button type="submit" class="btn btn-danger">Deletar</button>
</form>
</center>
</td>
</tr>
</tbody>
@endforeach
</table>
{!! $funcionarios->links() !!}
@endsection