Catch a certain amount on a Foreach on the Blade

Question

I wanted to know how I do to walk through a Collection and result a certain value? The Collection works like this and returned various values of employee appointments to be printed on the point, there are two stop meters that considers each marking $markings->VF_ENTRADA returning S for entry and N outgoing $markings->HR_MARCACAO which represents the time of this marking I’m facing a problem to pick the final time of output, of course this last output representing the closing point would be last value of the returned array but there may be editing cases in DB. Summing up I wanted to catch the biggest time HR_MARCACAO worthwhile VF_ENTRADA = N which would represent the last departure of the employee thus closing of the day point.

This is the code I’m using to list on Blade

  ($markings->VF_ENTRADA (RETORANAR VALOR = 'S' OU 'N'))

    <td class="pl-0 pr-0 pb-0 text-center">


           @foreach ($punchcard->markings as $markings)
              @if($loop->last)

                   {{$markings->HR_MARCACAO}}
              @endif

            @endforeach

    </td>

I’m using $loop->last to return the last interaction, but as I said there may be editing cases in DB so this value could be invalid for the result I want.

Search query

public function returnDataPonto($id,$periode_start,$periode_stop)
    {

      $worker=Workers::where('CD_FUNC',$id)->with('cargos')
                                         ->whereHas('punchcards',function($query)
                                        use($periode_start,$periode_stop){

    $date1 = $periode_start;
    $date2 = $periode_stop;

    $query->where('DT_PONTO','>=', $date1)
          ->where('DT_PONTO','<=', $date2);})     


          ->whereHas('punchcards.markings',function($query){
            $query->where('VF_ENTRADA', 'N');
            })
          ->first();

        return $worker;
    }

Answer 1

Answer to your question can be resolved as follows:

On the controller:

$marcacoes = Model::select('HR_MARCACAO')->where('VF_ENTRADA', 'N')->get(); //Dessa forma você pega somente o HR_MARCACAO do VF_ENTRADA n, se quiser todos dados além do HR_MARCACAO só tirar o select

Where relational:

$worker=Workers::where('CD_FUNC',$id)->with('cargos')->whereHas('punchcards',function($query) use($periode_start,$periode_stop)
{
        $query->where('DT_PONTO','>=', $periode_start)->where('DT_PONTO','<=', $periode_stop);

})whereHas('punchcards.markings', function($query){
  $query->where('VF_ENTRADA', 'N');
})->first();

In the Blade:

@foreach($marcacoes as $marcao)
  @if($loop->last)

      {{$markings->HR_MARCACAO}}

   @endif
@endforeach

If you don’t help me answer that I will see you again and help you solve.