Member Since 8 Months Ago
4,920 experience to go until the next level!
In case you were wondering, you earn Laracasts experience when you:
Earned once you have completed your first Laracasts lesson.
Earned once you have earned your first 1000 experience points.
Earned when you have been with Laracasts for 1 year.
Earned when you have been with Laracasts for 2 years.
Earned when you have been with Laracasts for 3 years.
Earned when you have been with Laracasts for 4 years.
Earned when you have been with Laracasts for 5 years.
Earned when at least one Laracasts series has been fully completed.
Earned after your first post on the Laracasts forum.
Earned once 100 Laracasts lessons have been completed.
Earned once you receive your first "Best Reply" award on the Laracasts forum.
Earned if you are a paying Laracasts subscriber.
Earned if you have a lifetime subscription to Laracasts.
Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.
Earned once you have achieved 500 forum replies.
Earned once your experience points passes 100,000.
Earned once your experience points hits 10,000.
Earned once 1000 Laracasts lessons have been completed.
Earned once your "Best Reply" award count is 100 or more.
Earned once your experience points passes 1 million.
Earned once your experience points ranks in the top 50 of all Laracasts users.
hj_junior left a reply on BelongsToMany Why Is Returning Just The First?
I got it do, but I have a lot of changes, I tried to keep everything in the standart of laravel, so know I'm not using prefix and nothing else, so the breaking changes:
public function basetable() {
$this->integer('id')->autoIncrement()->comment("Identificação");
$this->timestamp('created_at')->useCurrent()->comment("timestamp de criação");
$this->timestamp('updated_at')->comment("timestamp de atualização")->nullable();
$this->timestamp('deleted_at')->nullable()->comment("timestamp de exclusão")->nullble();
}
´´´
$this->schema->create('perfilacessos', function (CustomBlueprint $table) {
$table->basetable();
$table->text('nome');
});
$this->schema->create('paginas', function (CustomBlueprint $table) {
$table->basetable();
$table->text('nome');
});
$this->schema->create('pagina_perfilacessos', function (CustomBlueprint $table) {
$table->basetable();
$table->integer('perfilacessos_id');
$table->integer('pagina_id');
$table->foreign('perfilacessos_id')->references('id')->on('perfilacessos');
$table->foreign('pagina_id')->references('id')->on('paginas');
});
´´´
public function paginas () {
return $this->belongsToMany(Pagina::class);
}
´´´
#### PaginasSistema -> Pagina (Renamed)
public function perfilacesso () {
return $this->belongsToMany(Perfilacessos::class);
}
´´´
hj_junior left a reply on BelongsToMany Why Is Returning Just The First?
@Snapey I think shoud be belongsToMany because of this, look this ER diagram
hj_junior left a reply on BelongsToMany Why Is Returning Just The First?
@Snapey Yes, sorry, I've added this information in the blocks of code too and some stranger think that I have see it in the query.
hj_junior started a new conversation BelongsToMany Why Is Returning Just The First?
I'm trying to create a table who will group a list of permissions to each user, so I have created this following tables:
Table: N_perfilacesso Group of permissions (pages)
| Column | Details | | ------------- | ------------- | | _id | primary key | | nome | text |
Table: N_paginas Just list the pages of system
| Column | Details | | ------------- | ------------- | | _id | primary key | | nome | text |
Table: N_perfilacesso_paginas List of pages of each group of permissions
| Column | Details | | ------------- | ------------- | | _id | primary key | | _perfilacesso | References to N_perfilacesso | | _pagina | References to N_paginas |
So now, the models:
PerfilAcesso
protected $hidden = ['deleted_at','created_at','updated_at','pivot'];
public function paginas () {
return $this->belongsToMany('App\Models\PaginasSistema', 'N_perfilacesso_paginas', '_pagina', '_id');
}
PerfilAcessoPaginas
protected $hidden = ['deleted_at','created_at','updated_at','pivot'];
PaginasSistema
protected $hidden = ['deleted_at','created_at','updated_at','pivot'];
public function perfilacesso () {
return $this->belongsToMany('App\Models\PerfilAcesso', 'N_perfilacesso_paginas', '_pagina', '_id');
}
So in the controller I find the id of profile of access, and after I want to list the pages
$perfilacesso = PerfilAcesso::findOrFail($id);
return response([
'status' => 'ok',
'pages' => $perfilacesso->paginas
]);
But I'm getting result with just the first of result in array
{
"status": "ok",
"paginas": [
{
"_id": 1,
"nome": "evadidos.grafico.instituicao"
}
]
}