@extends('pdf.layout')

@section('title', 'Transcript')

@section('content')

@foreach($transcript as $trans)

<div class="row" style="margin: 0; padding: 0;">

  <div class="col-3" style="margin: 0; padding: 0;">
    <p style="font-size: 15px; margin-top: 50px;">
      Lett: NU/Con/Trans/{{ request()->get('exam_code') }}/{{ $trans->exam_year }}
    </p>
  </div>
  
  <div class="col-1">
      <img src="{{ public_path('img/admit_card/logo.jpg') }}" style="width: 60px !important; float: right; height: 95px !important;">
  </div>
  
  <div class="col-5">
      <p style="font-size: 25px; font-weight: bold; margin: 0 !important; padding: 0 !important;">NATIONAL UNIVERSITY</p>
      <p style="font-size: 20px; font-weight: 400; margin-top: 1px; margin-left: 80px; padding: 0 !important; margin-top: 10px;">BANGLADESH</p>
      <p style="margin-top: 40px; text-decoration: underline; font-weight: bold; font-size: 20px; ">ACADEMIC TRANSCRIPT</p>
  </div>

  <div class="col-3" style="margin: 0; padding: 0;">
      <table border="1px solid black" style=" width: 190px; margin-left: 10px;">
        <tbody>
         
         <tr>
            <td colspan="3"><p style="font-size: 10px; text-align: center; margin: 0; padding: 0;">GRADING SYSTEM</p></td>
          </tr>
          
          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">Numerical grade</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">Letter <br> Grade</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">Grade <br> Point</p></td>
          </tr>
          
          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">80% and Above</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">A+</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">4.00</p></td>
          </tr>

          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">75% to less than 80%</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">A</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">3.75</p></td>
          </tr>

          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">70% to less than 75%</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">A-</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">3.50</p></td>
          </tr>

          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">65% to less than 70%</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">B+</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">3.25</p></td>
          </tr>

          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">60% to less than 65%</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">B</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">3.00</p></td>
          </tr>

          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">55% to less than 60%</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">B-</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">2.75</p></td>
          </tr>

          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">50% to less than 55%</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">C+</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">2.50</p></td>
          </tr>

          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">45% to less than 50%</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">C</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">2.25</p></td>
          </tr>

          <tr>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">40% to less than 45%</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">D</p></td>
            <td><p style="font-size: 9px; text-align: center; margin: 0; padding: 0;">2.00</p></td>
          </tr>

          <tr>
            <td style="width: 90px;"><p style="font-size: 8px; text-align: center; margin: 0; padding: 0;">Below 40%</p></td>
            <td style=" width: 15px;"><p style="font-size: 8px; text-align: center; margin: 0; padding: 0;">F</p></td>
            <td style="width: 20px;"><p style="font-size: 8px; text-align: center; margin: 0; padding: 0;">0.00</p></td>
          </tr>

        
        </tbody>
      </table> 
  </div>

</div>  

<div class="row" style="margin: -30px 0 0 0;">
  <div class="col-12">
    <table style="margin: 0; padding: 0;">
      
      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Name of the Student</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">{{ $trans->name }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Father's Name</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $trans->father_name }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Mother's Name</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $trans->mother_name }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Name of Institution</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $trans->college }}, {{ $trans->district_name }}</p></td>
      </tr>

       @php
        
        if($trans->degree_code == 3){
          $degree_duration = "01 (One) Year";
          $degree_initial_name = "MASTER OF ";
        }elseif($trans->degree_code == 2){
          $degree_duration = "o4 (Four) Year (Honours)";
          $degree_initial_name = "BACHELOR OF ";
        }

        if($trans->subject_code >= 10 && $trans->subject_code <= 18 || $trans->subject_code == 38){
          $degree_name = "Arts";
        }else if($trans->subject_code >= 19 && $trans->subject_code <= 22){
          $degree_name = "Social Science";
        }else if($trans->subject_code >= 23 && $trans->subject_code <= 26){
          $degree_name = "Business Adminstration";
        }else if($trans->subject_code >= 7 && $trans->subject_code <= 37 || $trans->subject_code == 44){
          $degree_name = "Science";
        }else if($trans->subject_code == 45){
          $degree_name = "Music";
        }
      
      @endphp

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Entrance Qualification</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">BACHELOR OF {{ strtoupper($degree_name) }} (HONOURS) EXAMINATION</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Degree Conferred</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $degree_initial_name }} {{ strtoupper($degree_name) }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Discipline/Subject</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $trans->subject }}</p></td>
      </tr>

      @php
        
        if($trans->degree_code == 3){
          $degree_duration = '01 (One) Year';
        }elseif($trans->degree_code == 2){
          $degree_duration = 'o4 (Four) Year (Honours)';
        }

      @endphp

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Duration of Course</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $degree_duration }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Examination Roll No.</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $trans->exam_roll }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Registration No.</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $trans->reg_no }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Session</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $trans->session }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Year of Passing</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ request()->get('year') }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0;">Earned Credit</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0;">{{ $trans->total_credit }} Out of {{ $trans->total_credit }}</p></td>
      </tr>

      <tr>
        <td style="width: 200px; margin: 0; padding: 0;"><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">CGPA</p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">: &nbsp </p></td>
        <td><p style="font-size: 15px; margin: 0; padding: 0; font-weight: bold;">{{ $trans->cgpa }} Out of 4.00</p></td>
      </tr>
    
    </table>
  </div>
</div>

<br>

<div class="row" style="margin: 0; padding: 0;">
  <div class="col-12" style="margin: 0; padding: 0;">
    <p style="margin: 0 0 20px 0; padding: 0; font-weight: bold; text-align: center; font-size: 18px;">
      Academic Attainments
    </p>
    <table border="1px solid black;" style="width: 100%; margin: 0; padding: 0;">
      
      <tr>
        <td style="width: 150px; margin: 0; padding: 0;"><p style="font-weight: bold; font-size: 12px; margin: 0; padding: 0; text-align: center;">COURSE CODE</p></td>
        
        <td style="width: 700px; margin: 0; padding: 0;"><p style="font-weight: bold; font-size: 12px; margin: 0; padding: 0; text-align: center;">COURSE TITLE</p></td>
        
        <td style="width: 100px; margin: 0; padding: 0;"><p style="font-weight: bold; font-size: 12px; margin: 0; padding: 0; text-align: center;">CREDIT</p></td>
        
        <td style="width: 100px; margin: 0; padding: 0;"><p style="font-weight: bold; font-size: 12px; margin: 0; padding: 0; text-align: center;">LETTER <br> GRADE</p></td>
      </tr>
     
     @foreach($trans->combineResultDetails as $res)
      <tbody>
        <tr>
          <td><p style="font-size: 12px; margin: 0; padding: 0; text-align: center;">{{ $res->course_code }}</p></td>
          <td><p style=" font-size: 12px; margin: 0; padding: 0;"><span style="text-align: left;"> &nbsp {{ $res->course_title }}</span></p></td>
          <td><p style=" font-size: 12px; margin: 0; padding: 0; text-align: center;">{{ $res->credit }}</p></td>
          <td><p style="font-size: 12px; margin: 0; padding: 0; text-align: left; margin-left: 37px;">{{ $res->letter_grade }}</p></td>
        </tr>
      </tbody>
      @endforeach
    </table>
  </div>
</div>

<div class="row" style="margin: 0; padding: 0;">    
  <div class="col-6" style="margin: 0; padding: 0;">
    <br>
    <br>
    <br>
    <br>
    <p style="font-size: 15px;">
      Result Published Date &nbsp &nbsp : &nbsp {{ \Carbon\Carbon::parse($trans->updated_at)->format('F j, Y ') }} <br>
      Generated on: {{ date('d-m-Y') }} by NU EMS
    </p>
  </div>

  <div class="col-6" style="margin: 0; padding: 0;">
    <p style="font-size: 15px; text-align: center; margin-left: 55px;">
    <br>
    <br>
      <img src="{{ url($signature->image) }}" width="120" height="50" style="display: block; border:0; padding: 0; margin-left: 50px;" /> <br>
      Controller of Examinations <br>
      National University, Bangladesh <br>
      E-mail: controller@nu.ac.bd
    </p>    
  </div>

</div>


@include('include.page_break')
@endforeach
@stop