@extends('pdf.layout')

@section('title', 'Mark Sheet')

@section('content')

@php

  $row_size = 13;
  $i = 0;
        
  if($data['basic_info'][0]['degree_code'] == 3){
    $degree_duration = "01 (One) Year";
    $degree_initial_name = "M.";
  }elseif($data['basic_info'][0]['degree_code'] == 2){
    $degree_duration = "o4 (Four) Year (Honours)";
    $degree_initial_name = "B.";
  }

  if($data['basic_info'][0]['subject_code'] >= 10 && $data['basic_info'][0]['subject_code'] <= 18 || $data['basic_info'][0]['subject_code'] == 38){
    $degree_name = "A";
  }else if($data['basic_info'][0]['subject_code'] >= 19 && $data['basic_info'][0]['subject_code'] <= 22){
    $degree_name = "S.S";
  }else if($data['basic_info'][0]['subject_code'] >= 23 && $data['basic_info'][0]['subject_code'] <= 26){
    $degree_name = "B.A";
  }else if($data['basic_info'][0]['subject_code'] >= 27 && $data['basic_info'][0]['subject_code'] <= 37 || $data['basic_info'][0]['subject_code'] == 44){
    $degree_name = "Sc";
  }else if($data['basic_info'][0]['subject_code'] == 45){
    $degree_name = "Music";
  }
      
@endphp
  
<div class="row">
  <div class="col-9">
     <p style="font-size: 30px; font-weight: bold; text-align: center; padding: 0px 0px 0px 0px; margin: 0px 0px 0px 170px;">NATIONAL UNIVERSITY <br>
      <span style="font-size: 20px; font-weight: 400;">BANGLADESH</span>
     </p>
  </div>  
  
  <div class="col-3">
      <p style="text-align: right; float: right; margin: 0px 0px 0px 0px; padding: 0px 0px 0px 0px;">
      17-1-37-112275</p>  
  </div>
</div>

<div class="row">
  <div class="col-5">
    <p style="font-size: 17px; font-weight: bold; margin: 80px 0px 0px 0px; padding: 0;">
      NUMC 18- &nbsp<span style="font-size: 20px; font-weight: bold; color: #5e068a;">0610298</span>
    </p>
  
    <table style="margin: 30px 0px 0px 0px;">
      <tr>
        <td><p style="margin: 0; padding: 0; font-size: 16px;">Roll No.</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 16px;">&nbsp &nbsp:&nbsp</p></td>
        <td><p style="font-weight: bold; margin: 0; padding: 0; font-size: 16px;">{{ $data['basic_info'][0]['exam_roll'] }}</p></td>
      </tr>

      <tr>
        <td><p style="margin: 0; padding: 0; font-size: 16px;">Regn. No.</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 16px;">&nbsp &nbsp:&nbsp</p></td>
        <td><p style="font-weight: bold; margin: 0; padding: 0; font-size: 16px;">{{ $data['basic_info'][0]['reg_no'] }}</p></td>
      </tr>

      <tr>
        <td><p style="margin: 0; padding: 0; font-size: 16px;">Session</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 16px;">&nbsp &nbsp:&nbsp</p></td>
        <td><p style="font-weight: bold; margin: 0; padding: 0; font-size: 16px;">{{ $data['basic_info'][0]['session'] }}</p></td>
      </tr>
    </table>
  </div>

  
  
  <div class="col-4">

    <img src="{{ public_path('img/admit_card/logo.jpg') }}" style="width: 85px !important; height: 125px !important; margin: 15px 0px 0px 0px; ">

    <p style="font-size: 25px; font-weight: bold; padding: 0px 0px 0px 0px; margin: 15px 0px 0px 0px;">Marks Certificate</p>

  </div>

  <div class="col-3">

      <table border="1px solid black" style=" width: 190px; margin: 0px 0px 0px 0px; padding: 0px;  float: right;">
      <tbody>
       <tr>
          <td colspan="3"><p style="font-size: 14px; text-align: center; margin: 0; padding: 0; font-weight: bold;">GRADING SYSTEM</p></td>
        </tr>
        
        <tr>
          <td><p style="font-size: 12px; text-align: left; margin: 0; padding: 0;">80% OR ABOVE</p></td>
          <td><p style="font-size: 12px; text-align: center; margin: 0; padding: 0;">A+</p></td>
          <td><p style="font-size: 12px; text-align: center; margin: 0; padding: 0;">4.00</p></td>
        </tr>

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

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

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

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

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

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

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

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

        <tr>
          <td style="width: 30px;"><p style="font-size: 12px; text-align: left; margin: 0; padding: 0;">Below 40%</p></td>
          <td style=" width: 15px;"><p style="font-size: 12px; text-align: center; margin: 0; padding: 0;">F</p></td>
          <td style="width: 20px;"><p style="font-size: 12px; text-align: center; margin: 0; padding: 0;">0.00</p></td>
        </tr>
      
      </tbody>
    </table> 
  </div>
</div>  

<br>

<div class="row">
  <div class="col-12">
    <p style="text-align: center; font-weight: bold; font-size: 23px; margin: 0px; padding: 0px;">{{ $degree_initial_name }}{{ $degree_name }} Honours Examination - {{ request()->get('year') }}</p>
    <p style="text-align: center; font-weight: bold; font-size: 23px; margin: 10px 0px 0px 0px; padding: 0;">Subject : {{ $data['basic_info'][0]['subject_name'] }}</p>
  </div>
</div>

<br>
<br>

<div class="row">
  <div class="col-12">
    <table>
      <tr>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">Name of Student</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">&nbsp &nbsp:&nbsp</p></td>
        <td><p style="font-weight: bold; margin: 0; padding: 0; font-size: 18px;">{{ $data['basic_info'][0]['student_name'] }}</p></td>
      </tr>

      <tr>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">Father's Name</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">&nbsp &nbsp:&nbsp</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">{{ $data['basic_info'][0]['father_name'] }}</p></td>
      </tr>

      <tr>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">Mother's Name</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">&nbsp &nbsp:&nbsp</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">{{ $data['basic_info'][0]['mother_name'] }}</p></td>
      </tr>

      <tr>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">Mother's Name</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">&nbsp &nbsp:&nbsp</p></td>
        <td><p style="margin: 0; padding: 0; font-size: 18px;">{{ $data['basic_info'][0]['name_of_college'] }}, {{ $data['basic_info'][0]['district_name'] }}</p></td>
      </tr>
    </table> 
  </div>
</div>

<br>
<br>

<div class="row">

  <!-- 1st Year -->
  <div class="col-3">
    <table border="1px solid black;" style="margin: 0px; padding: 0px; width: 100%;">
      <tr>
        <td colspan="3"><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">1st Year</p></td>
      </tr>

      <tr>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Course <br> Code</p></td>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Credit</p></td>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Letter <br> Grade</p></td>
      </tr>



      @for($i = 0; $i < $row_size; $i++)
        <tr style="height: 25px;">
          <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">
          @if(isset($data['first_year_result_details'][$i])) 
              {{ $data['first_year_result_details'][$i]['paper_code'] }}
          @endif
          </p></td>
          <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"> 
          @if(isset($data['first_year_result_details'][$i])) 
              {{ $data['first_year_result_details'][$i]['credit'] }}
          @endif</p></td>
          <td><p style="text-align: left; font-size: 15px; margin: 0px; margin-left: 37px;">@if(isset($data['first_year_result_details'][$i])) 
              {{ $data['first_year_result_details'][$i]['letter_grade'] }}
          @endif</p></td>
      </tr>
      @endfor

      <tr style="height: 25px;">
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">1st Year Credit</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">{{ $data['first_year_summary']['earned_credit'] }}</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"></p></td>
      </tr>

      <tr style="height: 25px;">
        <td colspan="2"><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"><span style="font-weight: bold;">GPA</span></p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">{{ number_format((float)$data['first_year_summary']['cgpa'], 2, '.', '') }}</p></td>
      </tr>
    </table>
  </div>
  
  <!-- 2nd year -->
  <div class="col-3">
    <table border="1px solid black;" style="margin: 0px; padding: 0px; width: 100%;">
      <tr>
        <td colspan="3"><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">2nd Year</p></td>
      </tr>

      <tr>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Course <br> Code</p></td>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Credit</p></td>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Letter <br> Grade</p></td>
      </tr>

      @for($i = 0; $i < $row_size; $i++)
        <tr style="height: 25px;">
          <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">
          @if(isset($data['second_year_result_details'][$i])) 
              {{ $data['second_year_result_details'][$i]['paper_code'] }}
          @endif
          </p></td>
          <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">
          @if(isset($data['second_year_result_details'][$i])) 
              {{ $data['second_year_result_details'][$i]['credit'] }}
          @endif</p></td>
          <td><p style="text-align: left; font-size: 15px; margin: 0px; margin-left: 37px;">
          @if(isset($data['second_year_result_details'][$i])) 
              {{ $data['second_year_result_details'][$i]['letter_grade'] }}
          @endif</p></td>
      </tr>
      @endfor

      <tr style="height: 25px;">
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">2nd Year Credit</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">{{ $data['second_year_summary']['earned_credit'] }}</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"></p></td>
      </tr>

      <tr style="height: 25px;">
        <td colspan="2"><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"><span style="font-weight: bold;">GPA</span></p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">{{ number_format((float)$data['second_year_summary']['cgpa'], 2, '.', '') }}</p></td>
      </tr>
    </table>
  </div>


  <!-- 3rd year -->
  <div class="col-3">
    <table border="1px solid black;" style="margin: 0px; padding: 0px; width: 100%;">
      <tr>
        <td colspan="3"><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">3rd Year</p></td>
      </tr>

      <tr>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Course <br> Code</p></td>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Credit</p></td>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Letter <br> Grade</p></td>
      </tr>

      @for($i = 0; $i < $row_size; $i++)
        <tr style="height: 25px;">
          <td><p style="text-align: center; font-size: 15px; margin: 0px;"> @if(isset($data['third_year_result_details'][$i])) 
              {{ $data['third_year_result_details'][$i]['paper_code'] }}
          @endif</p></td>
          <td><p style="text-align: center; font-size: 15px; margin: 0px; ">@if(isset($data['third_year_result_details'][$i])) 
              {{ $data['third_year_result_details'][$i]['credit'] }}
          @endif</p></td>
          <td><p style="text-align: left; font-size: 15px; margin: 0px; margin-left: 37px;">@if(isset($data['third_year_result_details'][$i])) 
              {{ $data['third_year_result_details'][$i]['letter_grade'] }}
          @endif</p></td>
      </tr>
      @endfor

      <tr style="height: 25px;">
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">3rd Year Credit</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">{{ $data['third_year_summary']['earned_credit'] }}</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"></p></td>
      </tr>

      <tr style="height: 25px;">
        <td colspan="2"><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"><span style="font-weight: bold;">GPA</span></p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">{{ number_format((float)$data['third_year_summary']['cgpa'], 2, '.', '') }}</p></td>
      </tr>
    </table>
  </div>


  <!-- 4th Year -->
  <div class="col-3">
    <table border="1px solid black;" style="margin: 0px; padding: 0px; width: 100%;">
      <tr>
        <td colspan="3"><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">4th Year</p></td>
      </tr>

      <tr>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Course <br> Code</p></td>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Credit</p></td>
        <td><p style="text-align: center; font-weight: bold; font-size: 16px; margin: 0px; padding: 0px;">Letter <br> Grade</p></td>
      </tr>

      @for($i = 0; $i < $row_size; $i++)
        <tr style="height: 25px;">
          <td><p style="text-align: center; font-size: 15px; margin: 0px;">@if(isset($data['fourth_year_result_details'][$i])) 
              {{ $data['fourth_year_result_details'][$i]['paper_code'] }}
          @endif</p></td>
          <td><p style="text-align: center; font-size: 15px; margin: 0px;">@if(isset($data['fourth_year_result_details'][$i])) 
              {{ $data['fourth_year_result_details'][$i]['credit'] }}
          @endif</p></td>
          <td><p style="text-align: left; font-size: 15px; margin: 0px; margin-left: 37px;">@if(isset($data['fourth_year_result_details'][$i])) 
              {{ $data['fourth_year_result_details'][$i]['letter_grade'] }}
          @endif</p></td>
      </tr>
      @endfor

      <tr style="height: 25px;">
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">4th Year Credit</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">{{ $data['fourth_year_summary']['earned_credit'] }}</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"></p></td>
      </tr>

      <tr style="height: 25px;">
        <td colspan="2"><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;"><span style="font-weight: bold;">GPA</span></p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 0px;">{{ number_format((float)$data['fourth_year_summary']['cgpa'], 2, '.', '') }}</p></td>
      </tr>
    </table>
  </div>

</div>

<br>

<div class="row">
  <div class="col-7">
    <table border="1px solid black;" style="padding: 0px; width: 100%; margin: 0px;">
      <tr>
        <td><p style="text-align: center; font-size: 17px; margin: 0px; padding: 5px;">Total Credit</p></td>
        <td><p style="text-align: center; font-size: 17px; margin: 0px; padding: 5px;">Earned Credit</p></td>
        
        @if($data['basic_info'][0]['subject_code'] != 11)
          <td><p style="text-align: center; font-size: 17px; margin: 0px; padding: 5px;">English <br> <span style="font-size: 15px;">(Non Credit)</span></p></td>
        @endif
          
        <td><p style="text-align: center; font-size: 17px; margin: 0px; padding: 5px; font-weight: bold;">CGPA</p></td>
      </tr>

       <tr>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 5px;">{{ $data['basic_info'][0]['total_credit'] }}</p></td>
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 5px;">{{ $data['basic_info'][0]['earned_credit'] }}</p></td>
        
        @if($data['basic_info'][0]['subject_code'] != 11)
          <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 5px;">Pass</span></p></td>
        @endif
        <td><p style="text-align: center; font-size: 15px; margin: 0px; padding: 5px;">{{ number_format((float)$data['basic_info'][0]['cgpa'], 2, '.', '') }}</p></td>
      </tr>
    </table>

    <p style="font-weight: bold; font-size: 15px;">Result Published on : {{ \Carbon\Carbon::parse($data['fourth_year_summary']['publish_date'])->format('F j, Y ') }}</p>
  </div>

  <div class="col-5">
  <br>
   <p style="font-size: 15px; float: right; margin-right: 0px;">
    <img src="{{ url($signature->image) }}" width="120" height="50" style="display: block; border:0px; padding: 0px; margin-left: 50px;" />
    Controller of Examinations
  </p>    
    
  </div>
</div>

<br>
<br>

<div class="row">
  <div class="col-12">
    <p style="text-align: center; color: #f56905; font-size: 12px;">
      N.B. The Marks Certificate is issued without any correction or overwriting.
    </p>
  </div>
</div>

@stop