laravel函数，它循环所有重复的project_id，只显示上次在show.blade.php上创建的

Question

你好，我有一个困难的函数，我需要解决：

我需要一个函数，它可以过滤出具有相同project_id的项目，并且只接受带有最新created_at数据的项目。

我目前一无所有，因为我不知道从哪里开始，但我很确定我需要在我的ProjectController的索引函数中写它。

overzicht.blade.php

@extends('layouts.app')

@section('content')

<div class="container">
    <div class="well">
            <div class="card mt-5 mb-5">
                    <h2 class="card-header">{{$projectitem->project_name}></h2>
                    <div class="card-body">
                      <h2 class="card-text mt-4 mb-2"><b>Beschrijving:</b></h2><br>
                      {!!$projectitem->description!!}

                      <h2 class="mt-4 mb-2"><b>Tijdsduur(in uren):</b>&nbsp;{{$projectitem->time_span}} Uren</h2><br>

                      <h2 class="mt-2 mb-2"><b>Opdrachtgever:</b> &nbsp;{{$projectitem->client}}</h2>

                      <h2 class="mt-4 mb-2"><b>Text verslag:</b></h2><br>
                        {!!$projectitem->text_report!!}

                      <h2 class="mt-4 mb-2"><b>Foto's vooraf: &nbsp;</b></h2><br>
                        {!!$projectitem->images_before!!}
                        <h2 class="mt-4 mb-2"><b>Foto's achteraf: &nbsp;</b></h2><br>
                        {!!$projectitem->images_after!!}

                        <div class="row">
                                <div class="col-md-6">
                                    <h2 class="mt-4"><b>Beschikbaar op: &nbsp;</b></h2>
                                    <h4>Facebook:&nbsp;<?php if($projectitem->facebook == 1){echo "wel";}else{echo "niet";}?></h4>
                                    <h4>Instagram:&nbsp;<?php if($projectitem->instagram == 1){echo "wel";}else{echo "niet";}?></h4>
                                    <h4>Linkedin:&nbsp;<?php if($projectitem->linkedin == 1){echo "wel";}else{echo "niet";}?></h4>
                                    <h4>Website:&nbsp;<?php if($projectitem->website == 1){echo "wel";}else{echo "niet";}?></h4>
                                </div>                   
                        </div>
                      <h4 class="mt-4 mb-2"><b>Aangemaakt door:</b>&nbsp;{{$projectitem->created_by}}</h4><br>
                        <div class="row">
                            <div class="col-md-6">
                                <h4 class="mt-4 mb-2 floatl "><b>Aangemaakt op:</b>&nbsp;{{$projectitem->created_at}}</h4><br>
                            </div>
                            <div class="col-md-6">                                    
                                <h4 class="mt-4 mb-2 ml-1 mr-1 floatr "><b>Laatst gewijzigd op:</b>&nbsp;{{$projectitem->updated_at}}</h4><br>
                            </div> 
                    </div>
                </div>
            </div>
        </div>
    </div>


@endsection

指标函数在项目控制器中的应用

$projects = Project::where('user_id', auth()->user()->id)->get();
     $projectitem = Projectitem::all();//->orderBy('created_at')->limit(1)

     return view('overzicht', [
        'projects' => $projects,
        'projectitem' => $projectitem,
    ]);

编辑:截图

​

​

所有的帮助都很感激

Answer 1

我不知道它是否适合你，但你可以通过一个查询得到它

顺便说一句，当您从项目对象获得项目id时，您不需要定义它

Project::where('project_id', project->id)->orderBy('created_at', 'desc')->first();