calebesantana Posts - Answer Overflow

calebesantana

•Created by calebesantana on 9/12/2023 in #❓┊help

Datepicker enable range dates

I realized it's possible to create a datepicker with disabled dates, but it's possible to create a datepicker that has only specific dates available to select? Like if you have to select one of the available dates.

3 replies

FFilament

•Created by calebesantana on 6/23/2023 in #❓┊help

Table builder with data from API rest

Hey! I'm using the table builder in a custom livewire component to create a students table, and I'm querying the data from the models using the query builder notation, the student frequency data came from this same query, and its ok, but the grade information came from an external API call. I was reading about this sushi package that fits perfectly for this kinda of occasion, but I've seen examples of the table being constructed over data that only came from the model that sushi it's applied, in my case, I'm getting the student data from a query and I should connect every student row to a grade that came from the API. So I'm using a ->get() in my ::query() to foreach over all students returned from the query to fetch the grades, but I cannot construct the table after this approach, since I'm not returning an Builder Instance anymore...

3 replies

FFilament

•Created by calebesantana on 5/26/2023 in #❓┊help

Table from different database connection

I have this Livewire Component which implementing the HasTable, this component should render a table with data from a query that is mainly using this Model that uses protected $connection = 'other_database', this query has multiple joins with tables that are from the same 'other_database'...the thing is that my table its being rendered, it it's paginating and counting the total number of data etc...the only value that it's being showed it's the id_matricula value, all others are not. The query:

       $this->alunos = Matricula::select('tb_matricula.id_matricula', 'tb_aluno.ra', 'tb_perfil.nome', 'tb_periodo_letivo.descricao', 'tb_curso_base.nome_para_impressao', 'tb_disciplina.descricao', 'tb_matricula_disciplina.frequencia')
                    ->join('tb_aluno', 'tb_aluno.id_aluno', 'tb_matricula.id_aluno')
                    ->join('tb_matricula_disciplina', 'tb_matricula_disciplina.id_matricula', 'tb_matricula.id_matricula')
                    ->join('tb_disciplina_professor', 'tb_disciplina_professor.id_disciplina_professor', 'tb_matricula_disciplina.id_disciplina_professor')
                    ->join('tb_disciplina', 'tb_disciplina.id_disciplina', 'tb_disciplina_professor.id_disciplina')
                    ->join('tb_curso', 'tb_curso.id_curso', 'tb_matricula.id_curso')
                    ->join('tb_curso_base', 'tb_curso_base.id_curso_base', 'tb_curso.id_curso_base')
                    ->join('tb_turma', 'tb_turma.id_turma', 'tb_matricula.id_turma')
                    ->join('tb_perfil', 'tb_perfil.id_perfil', 'tb_aluno.id_perfil')
                    ->join('tb_periodo_letivo', 'tb_periodo_letivo.id_periodo_letivo', 'tb_matricula.id_periodo_letivo')
                    ->where('tb_matricula.id_periodo_letivo', '=', $this->periodo_letivo)
                    ->where('tb_curso_base.id_curso_base', '=', $this->curso)
                    ->where('tb_disciplina.id_disciplina', '=', $this->disciplina)
                    ->get();

       $this->alunos = Matricula::select('tb_matricula.id_matricula', 'tb_aluno.ra', 'tb_perfil.nome', 'tb_periodo_letivo.descricao', 'tb_curso_base.nome_para_impressao', 'tb_disciplina.descricao', 'tb_matricula_disciplina.frequencia')
                    ->join('tb_aluno', 'tb_aluno.id_aluno', 'tb_matricula.id_aluno')
                    ->join('tb_matricula_disciplina', 'tb_matricula_disciplina.id_matricula', 'tb_matricula.id_matricula')
                    ->join('tb_disciplina_professor', 'tb_disciplina_professor.id_disciplina_professor', 'tb_matricula_disciplina.id_disciplina_professor')
                    ->join('tb_disciplina', 'tb_disciplina.id_disciplina', 'tb_disciplina_professor.id_disciplina')
                    ->join('tb_curso', 'tb_curso.id_curso', 'tb_matricula.id_curso')
                    ->join('tb_curso_base', 'tb_curso_base.id_curso_base', 'tb_curso.id_curso_base')
                    ->join('tb_turma', 'tb_turma.id_turma', 'tb_matricula.id_turma')
                    ->join('tb_perfil', 'tb_perfil.id_perfil', 'tb_aluno.id_perfil')
                    ->join('tb_periodo_letivo', 'tb_periodo_letivo.id_periodo_letivo', 'tb_matricula.id_periodo_letivo')
                    ->where('tb_matricula.id_periodo_letivo', '=', $this->periodo_letivo)
                    ->where('tb_curso_base.id_curso_base', '=', $this->curso)
                    ->where('tb_disciplina.id_disciplina', '=', $this->disciplina)
                    ->get();

12 replies

FFilament

•Created by calebesantana on 3/2/2023 in #❓┊help

notifications aren't showing up correctly at custom livewire layout

32 replies

Gaming

Programming