<?php
date_default_timezone_set('UTC');
$home = trim(getenv('WEB'));
error_log(getenv('WEB'));
set_include_path("$home/html/include");
// Works in all PHP versions
ini_set('include_path', "$home/html/include");

require_once("dbconnect.php");
require_once("include/datasetController.php");
require_once("include/metadataController.php");

$output = '';
if(isset($_GET['dsid']) && !empty($_GET['dsid'])){
    $dsid = preg_replace('/\D/', '', trim($_GET['dsid']));
    $datasetController = new datasetController($dbh);

    $submissionData = $datasetController->getSubmissionByDSID($dsid);
    if(!empty($submissionData['subdate'])){
        // Format to English year
        $subdate = explode(' ', $submissionData['subdate']);
        $date = new DateTime($subdate[0]);
        $submissionData['subdate'] = $date->format('d-m-Y');
    }else{
        $dsidErr = true;
    }
    //var_dump($submissionData);

    $metadataController = new metadataController();
    $metadataController->addMetaFields($submissionData);

    // Adds two authors at the moment
    $authorData = $datasetController->getAuthorsByDSID($dsid);

    if(!empty($authorData)){
        foreach($authorData as $author){
            $metadataController->addMetaFields($author);
        }
    }

    $publicationData = $datasetController->getPublicationsByDSID($dsid);

    $acknowledgementData = $datasetController->getAcknowledgementByDSID($dsid);

    $contentData = $datasetController->getContentByDSID($dsid);

    $evidData = $datasetController->getEvidByDSID($dsid);

    $licenceData = $datasetController->getLicenceByDSID($dsid);

    $associatedSubmissionList = $datasetController->getAssociatedSubmissions($dsid);
    if(is_array($associatedSubmissionList)){
        $associatedSubmissionData = $datasetController->getAssociatedSubmissionByList($associatedSubmissionList);
    }else{
        // Otherwise this dataset MAY have a citation
        $citationAssociationData = $datasetController->IsSubDatasetOfDSID($dsid);
        // var_dump($citationAssociationData);
    }
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8" />
    <meta name="viewport" content="initial-scale=1.0, user-scalable=no" />
    <title>ISC Products and Services</title>
    <link rel="icon" href="/images/favicon.ico" type="image/ico" />
    <link rel="stylesheet" type="text/css" href="/css/iscschema.css">
    <style>
        #associatedSubmissions{
            width: 100%;
            border: 1px solid black;
            border-collapse: collapse;
        }

        #associatedSubmissions tr td{
            border: 1px solid black;
        }

        .authorName{

        }
        .nameColumn{
            width: 200px;
        }

        .titleColumn{
            width: 500px;

        }
        .websiteColumn{
            width: 200px;
        }

        ul.affiliationList{
            list-style-type: none;
            padding-left: 0;
        }
        h4{
            margin: 0px;
            display: inline-block;
        }
        p{
            /* line-height: 50px; */
        }
    </style>
    <?php echo($metadataController->formatJsonMetaData()); ?>
</head>

<body>
<div id="container">
    <?php include("$home/html/include/header.php"); ?>
    <div id="maingeneral">
        <div id="content">
        <!-- Loading Left Menu -->
            <?php include("include/leftmenu.php"); ?>
            <div id="rightinner">
                <h3 style="border-bottom:1px dotted #bababa;">Dataset View</h3>
                
                <p style="color:red"><?php if($dsidErr){echo"<b>Warning: incorrect dsid</b>";}?></p>
                
                <!-- DOI OF DATASET -->
                <p><?php echo('<a href="' . $submissionData['doi'] . '">' . $submissionData['doi'] . '</a>'); ?></p>

                <p><b>Submission date:</b> <?php echo($submissionData['subdate']); ?></p>
                <!-- TITLE OF DATASET -->

                <h4><?php echo($submissionData['title']); ?></h4>


                <!-- START OF AUTHOR LISTING -->
                <?php if(isset($authorData)){$output = ''; ?>

                <div id="authorList">
                    <br />
                    <?php
                    $authorAffiliation = array();
                    $i = 0;
                    $contactAuthor = array();
                    $citationName = array();
                    foreach($authorData as $author){
                        $j = $i+1;
                        $authorName = "{$author['first_name']} {$author['initials']} {$author['surname']} <sup>({$j})</sup>, ";
                        $output .= "{$authorName}";
                        $authorAffiliation[$i] = $author['affiliation'];
                        if(!empty($author['correspondent'])){
                            $contactAuthor[0] = $author['email'];
                            $contactAuthor[1] = "{$author['first_name']} {$author['initials']} {$author['surname']}";
                        }


                        $citationName[$i] = $author['surname'] . ", " . substr($author['first_name'], 0, 1) . ".";
                        $i++;
                    }
                    $strippedDOI = explode('/', $submissionData['doi']);
                    $citation = implode(', ', $citationName); //  {$strippedDOI[3]}{$strippedDOI[4]} - From now year is taken from submission but should be taken from field year
                    $citation .= " ({$submissionData['year']}). " . "{$submissionData['title']}, " . "ISC Seismological Dataset Repository, " .  "{$submissionData['doi']}";
                    $output = substr($output, 0, -1);
                    echo $output;
                    unset($output);
                    ?>

                    <ul class="affiliationList">
                        <?php
                        $output = '';
                        for($i = 0;$i < count($authorAffiliation);$i++){
                            $j = $i+1;
                            $output .= "<li>({$j}) {$authorAffiliation[$i]}</li>";
                        }
                        $output .= '</ul>';
                        echo $output;
                        unset($output);
                        ?>
                        <!-- http://publications.isc.ac.uk/index.php/summary/article/view/20
                            Author affiliated to
                        -->
                    </ul>
                </div>
                <?php } ?>

                <!-- DESCRIPTION OF DATASET -->

                <p><b>Brief Description:</b> <?php echo($submissionData['readme']);?></p>

                <?php
                // Loop through all possibilities

                if(!empty($contactAuthor)){
                    echo('<h4 style="font-weight: bold;">Corresponding Author:</h4> <a href="mailto:' . $contactAuthor[0] . '">' . $contactAuthor[1]. '</a><br /><br />');
                }
                if(!empty($publicationData)){
                    echo('<h4 style="font-weight: bold;">Related Publications:</h4>');
                    foreach($publicationData as $value){
                        echo("<p>{$value['publication']}</p>");
                    }
                }

                if($acknowledgementData['acknowledgement']){
                    echo('<h4 style="font-weight: normal;">Acknowledgement:</h4>');
                    foreach($acknowledgementData as $value){
                        echo("<p>{$value}</p>");
                    }
                }

                if($licenceData['licence']){
                    echo("<h4>Licence</h4>");
                    foreach($licenceData as $value){
                        echo("<p>{$value}</p>");
                    }
                }

                if(!empty($evidData)){
                   $output = '<h4>ISC Bulletin Event ID</h4><br>';
                   for($i = 0;$i < count($evidData);$i++){
                       $output .= '<a href=http://www.isc.ac.uk/cgi-bin/web-db-v4?out_format=IMS1.0&event_id=' . trim($evidData[$i]['evid']) . '>' . trim($evidData[$i]['evid']) . '</a></br>';
                   }
                   $output .= '<br>';
                   echo $output;
                   unset($output);
                }

                ?>

                <!-- START OF ASSOCIATED SUBMISSIONS -->
                <?php if(isset($associatedSubmissionData)){$output = ''; ?>
                    <div>
                        <h4>Associated Submissions</h4>
                        <table id="associatedSubmissions">
                        <?php

                        for($i = 0; $i < count($associatedSubmissionData);$i++){
                            if($associatedSubmissionData[$i]['version']){
                                $version = true;
                            }
                            $author = "{$associatedSubmissionData[$i]['first_name']} {$associatedSubmissionData[$i]['initials']} {$associatedSubmissionData[$i]['surname']}";
                            $output .= '<tr>';
                            $output .= '<td class="nameColumn">' . $author. ' </td>';
                            $output .= '<td class="titleColumn"><a href="' . $_SERVER['PHP_SELF']. '?dsid=' . $associatedSubmissionData[$i]['dsid']. '">' . $associatedSubmissionData[$i]['title'] . '</a></td>';
                            if($associatedSubmissionData[$i]['version']){
                                $output .= '<td class="versionColumn">' . $associatedSubmissionData[$i]['version'] . '</td>';
                            }
                            $output .= '<td class="websiteColumn"><a href="' . $associatedSubmissionData[$i]['website']. '">' . $associatedSubmissionData[$i]['doi'] . '</a></td>';
                            $output .= '</tr>';
                        } if(isset($version)){
                            $header = '<tr><th>Name</th><th>Title</th><th>Version</th><th>DOI</th></tr>';
                        } else {
                            $header = '<tr><th>Name</th><th>Title</th><th>DOI</<th></tr>';
                        }
                        echo($header . $output);
                        unset($output);
                        ?>
                        </table>
                    </div>

                <?php } else {
                    $filepath = "http://download.isc.ac.uk/datarepository/";
                    // Check if the file exists, if it does, find the file size and show a link
                    $fileExists = file_exists($filepath . $submissionData['download']);

                    $output = '<h4>Download File:</h4><br />';
                    if ($fileExists) {
                        $realFileSize = exec("du -h /data/ftp/pub/datarepository/" . $submissionData['download']. "| awk {'print $1'};");
                        $output .= ' <a href="' .  $filepath . $submissionData['download']. '">' . $submissionData['download'] . '</a>';
                        $output .= '&nbsp;File size: ' . $realFileSize . '<br />';
                    } else {
                        $output .= "<b>File {$submissionData['download']} could not be located</b><br />";
                    } if(!empty($contentData)){
                        $output .= '<br /><h4>File Contents:</h4>';
                        $output .= '<table>';
                        for($i = 0;$i < count($contentData);$i++){
                            $output .= '<tr>';
                            $output .= '<td>' . trim($contentData[$i]['filename']) . '</td>';
                            $output .= '</tr>';
                       } 
                       $output .= '</table>';
                    }
                    echo($output);
                    unset($output);
                }
                $output = '<br /><h4>Cite as:</h4><br />';
                $output .= $citation;
                echo $output . '<hr />';
                unset($output);
                ?>
                <?php
                    //Author year title, DOI (link)
                    // Show citations if exists
                    // if(isset($citationAssociationData) && !empty($citationAssociationData)){
                    //     $output = '<table><tr>';
                    //     foreach($citationAssociationData as $value){
                    //         $associatedCitation = $datasetController->getSubmissionByDSID($value['dsid']);
                    //         // var_dump($associatedCitation);

                    //         $output .= '<td>' . $associatedCitation['dsid'] . '</td>';
                    //         $output .= '<td>' . $associatedCitation['title'] . '</td>';
                    //         $output .= '<td>' . $associatedCitation['website'] . '</td>';
                    //     }
                    //     $output .= '</tr></table>';
                    //     echo $output;
                    // }
                ?>
            </div>
        </div>
    </div>
    <?php //var_dump($datasetController->getFields('dr_licence_link'));?>
    <?php include("$home/html/include/footer.php");?>
</body>
