﻿<?php
    $papers = Papers::where('url', $url)->get();
?>
<table border="1">
    <tr>
        <th colspan="5"><b>Corresponding Author</b></th>
        <th colspan="16"><b>Paper</b></th>
        <th colspan="6"><b>Evaluation</b></th>
    </tr>
    <tr>
        <th>CA First Name</th>
        <th>CA Middle Name Initial(s)</th>
        <th>CA Last Name</th>
        <th>CA Email</th>
        <th>CA Country</th>
        <th>Paper Title</th>
        <th>Paper-1</th>
        <th>Date of Paper-1</th>
        <th>Paper-2</th>
        <th>Date of Paper-2</th>
        <th>Paper-F</th>
        <th>Date of Paper-F</th>
        <th>Paper-A</th>
        <th>Date of Paper-A</th>
        <th>Paper-C</th>
        <th>Date of Paper-C</th>
        <th>Paper-W</th>
        <th>Date of Paper-W</th>
        <th>Paper Subject Code</th>
        <th>Paper Oral / Poster</th>
        <th>List of Authors in Order</th>
        <th>Eval 1 Name</th>
        <th>Eval 1 Code</th>
        <th>Eval 1 Comm</th>
        <th>Eval 2 Name</th>
        <th>Eval 2 Code</th>
        <th>Eval 2 Comm</th>
    </tr>
    <?php foreach($papers as $paper): ?>
<?php
    $user = Users::find($paper->user_id);
    $country_name = Countries::where('country_code',$user->country_code)->pluck('country_name');
    $meeting_topic = MeetingTopics::find($paper->meeting_topic_id);
    $evaluation_results = EvaluationResults::where('paper_id', $paper->id)->groupBy('user_id')->orderBy('id', 'desc')->get();
?>
        <tr>
            <td><?php echo $user->first_name; ?></td>
            <td><?php echo $user->middle_name; ?></td>
            <td><?php echo $user->last_name; ?></td>
            <td><?php echo $user->email; ?></td>
            <td><?php echo $country_name; ?></td>
            <td><?php echo $paper->title; ?></td>
            <td><a href="<?php echo Config::get('app.storage_public_path'); ?>/documents/<?php echo $url; ?>/<?php echo $paper->document_1; ?>"><?php echo $paper->document_1; ?></a></td>
            <td><?php echo $paper->document_1_date; ?> <?php echo $paper->document_1_time; ?></td>
            <td><a href="<?php echo Config::get('app.storage_public_path'); ?>/documents/<?php echo $url; ?>/<?php echo $paper->document_2; ?>"><?php echo $paper->document_2; ?></a></td>
            <td><?php echo $paper->document_2_date; ?> <?php echo $paper->document_2_time; ?></td>
            <td><a href="<?php echo Config::get('app.storage_public_path'); ?>/documents/<?php echo $url; ?>/<?php echo $paper->document_F; ?>"><?php echo $paper->document_F; ?></a></td>
            <td><?php echo $paper->document_F_date; ?> <?php echo $paper->document_F_time; ?></td>
            <td><a href="<?php echo Config::get('app.storage_public_path'); ?>/documents/<?php echo $url; ?>/<?php echo $paper->document_A; ?>"><?php echo $paper->document_A; ?></a></td>
            <td><?php echo $paper->document_A_date; ?> <?php echo $paper->document_A_time; ?></td>
            <td><a href="<?php echo Config::get('app.storage_public_path'); ?>/documents/<?php echo $url; ?>/<?php echo $paper->document_C; ?>"><?php echo $paper->document_C; ?></a></td>
            <td><?php echo $paper->document_C_date; ?> <?php echo $paper->document_C_time; ?></td>
            <td><a href="<?php echo Config::get('app.storage_public_path'); ?>/documents/<?php echo $url; ?>/<?php echo $paper->document_W; ?>"><?php echo $paper->document_W; ?></a></td>
            <td><?php echo $paper->document_W_date; ?> <?php echo $paper->document_W_time; ?></td>
            <td><?php echo $meeting_topic->title; ?></td>
            <td><?php echo $paper->type; ?></td>
            <td><?php echo $paper->authors; ?></td>
            <?php foreach($evaluation_results as $evaluation_result): ?>
            <td><?php echo Users::where('id',$evaluation_result->user_id)->pluck('first_name'); ?> <?php echo Users::where('id',$evaluation_result->user_id)->pluck('last_name'); ?></td>
            <td><?php echo $evaluation_result->result; ?></td>
            <td><?php echo $evaluation_result->comments; ?></td>
            <?php endforeach; ?>
        </tr>
    <?php endforeach; ?>
</table>