Year 2022

Level 122

Your post SHOUTED OUT AT ME when I visited the forum, and DESPITE your best efforts, I have no idea what you are asking.

If there are supposed to be blocks of code in your post, try formatting them.

3 likes

Level 56

<?php // ./routes/web.php

use App\Models\Student;
use Illuminate\Support\Facades\Route;

Route::get('/', function () {
    return view('report', [
        'singleStudent' => Student::query()->where('name', 'John')->get(),
    ]);
});

{{-- ./resources/views/report.blade.php --}}
<h1>Report</h1>

<p>
    <b>Student:</b> {{ $singleStudent->first()?->name ?? 'UNKNOWN' }}
</p>

@foreach($singleStudent->groupBy('year')->sortKeys() as $year => $records)
    <h2>{{ $year }}</h2>

    <ul>
        @foreach($records as $record)
            <li>
                {{ $record->subject }}: <b>{{ $record->grade }}</b>
            </li>
        @endforeach
    </ul>
@endforeach

<?php // ./database/migrations/2024_07_12_022401_create_students_table.php

use App\Models\Student;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration {
    public function up(): void
    {
        Schema::create('students', function (Blueprint $table) {
            $table->id();
            $table->unsignedSmallInteger('year');
            $table->string('name');
            $table->string('subject');
            $table->char('grade', 4);
            $table->timestamps();
        });
    }
};

<?php // ./database/seeders/DatabaseSeeder.php

namespace Database\Seeders;

use App\Models\Student;
use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    public function run(): void
    {
        Student::query()->forceCreate([
            'year' => 2022,
            'name' => 'John',
            'subject' => 'English',
            'grade' => 'PASS',
        ]);

        Student::query()->forceCreate([
            'year' => 2023,
            'name' => 'John',
            'subject' => 'Maths',
            'grade' => 'PASS',
        ]);

        Student::query()->forceCreate([
            'year' => 2022,
            'name' => 'John',
            'subject' => 'Physical Edu',
            'grade' => 'FAIL',
        ]);
    }
}

Screenshot_20240711_233649

1 like

https://docs.github.com/en/get-started/writing-on-github/getting-started-with-writing-and-formatting-on-github/basic-writing-and-formatting-syntax

Level 56

As @snapey said, the way you formatted your post makes it very challenging to understand.

I tried my best and hope it helps you out.

On the text box where you wrote your post, or can write any replies, there is a notice at the bottom saying:

You may use Markdown with GitHub-flavored code blocks.

Take a look at the linked page to learn how to format your code properly. That will make it easier for people to help you without guessing.

Level 1

@rodrigo.pedra

Your really did a great job. Thanks a lot The code works very fine. I am really happy. Thanks once again. Any way to get it in a table format ? I tried but I get only the 2022 data in the table but 2023 fall outside the table. Any idea ?

MohamedTammam

Level 51

@bashiro If that solved your problem, please select it as best answer to close the discussion.

Level 56

@bashiro thanks

please share what you have tried, so I can build on top of that

Level 56

@bashiro

It is very hard to known what table format you refer to, specially when the thread's title asks for help to categorize sub-heading

What does sub-heading mean in a table context?

Level 56

Hope this is what you mean. Note that for the sake of simplicity, I am using deprecated table attributes (border and valign)

{{-- ./resources/views/report.blade.php --}}
<h1>Report</h1>

<p>
    <b>Student:</b> {{ $singleStudent->first()?->name ?? 'UNKNOWN' }}
</p>

<table border="1">
    <thead>
    <tr>
        <th>Year</th>
        <th>Subject</th>
        <th>Grade</th>
    </tr>
    </thead>
    @foreach($singleStudent->groupBy('year')->sortKeys() as $year => $records)
        <tbody>
        <tr>
            <th scope="row" rowspan="{{ $records->count() }}" valign="top">{{ $year }}</th>

            @foreach($records as $record)
                <td>{{ $record->subject }}</td>
                <td>{{ $record->grade }}</td>
                </tr>
                @unless($loop->last)
                    <tr>
                @endunless
            @endforeach
        </tr>
        </tbody>
    @endforeach
</table>

Screenshot_20240715_061842

Level 1

@rodrigo.pedra thats what I did!

  @foreach($singleStudent->groupBy('year')->sortKeys() as $year => $records)
 
  <h6  class="text-center"> <b>{{ $year }}</b> </h6>


      @foreach($records as $record)
      <tbody>
        <tr>        
               <td>{{ $record->subject }} </td>
             <td> {{ $record->grade }} </td>
        </tr>   
        </tbody> 
      @endforeach

@endforeach

Best Answer

Level 56

@bashiro where is your <table> tags?

Do you want the subheading in the middle of the table?

Or one table for each year?

Try this:

{{-- ./resources/views/report.blade.php --}}
<h1>Report</h1>

<p>
    <b>Student:</b> {{ $singleStudent->first()?->name ?? 'UNKNOWN' }}
</p>

@foreach($singleStudent->groupBy('year')->sortKeys() as $year => $records)
    <h2>{{ $year }}</h2>

    <table border="1">
        <thead>
        <tr>
            <th>Subject</th>
            <th>Grade</th>
        </tr>
        </thead>
        <tbody>
        @foreach($records as $record)
            <tr>
                <td>{{ $record->subject }}</td>
                <td>{{ $record->grade }}</td>
            </tr>
        @endforeach
        </tbody>
    </table>
@endforeach

Screenshot_20240715_202540

Level 1

@rodrigo.pedra So beautiful. I have really learnt a lot from you! And not to say the least , from here. I will really love to buy you a cup of coffee. Thanks a lot. It worked perfectly. I am grateful. Thanks once again.

1 like

Level 56

@bashiro great to hear this!

Glad to help =) Have a nice day

1 like