<?php
require_once("header.php");
echo $page_content;

$graphicsview = isset($_GET['graphics']) ? sanitize(escape($_GET['graphics'])) : NULL;
if($year && $volume && $issue && $part && $refnumber && $graphicsview == 'graphics'):
	$stmt = $mysqli->prepare("SELECT archivesid, title FROM archives WHERE (year = ? AND refnumber = ? AND volume = ? AND issue = ? AND part = ? AND status = ?)") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('ssiiss', $year, $refnumber, $volume, $issue, $part, $article_status);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	$stmt->bind_result($archivesid, $title);
	$stmt->fetch();
	$stmt->close();
	if($count_rows > 0):
		echo "<div class=\"abstract\">";
		echo "<div class=\"fluid chead\">{$year}, VOL. {$volume} ISSUE {$issue}, PART {$part}</div>";
		echo "<div class=\"fluid thead\"><h3>{$title}</h3></div>";
		echo "<div class=\"body graphics\">";
		$snum = 0;
		$stmt = $mysqli->prepare("SELECT file, graphicsalt FROM graphics WHERE archivesid = ? ORDER BY graphicsid DESC");
		$stmt->bind_param('i', $archivesid);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($graphicsfile, $graphicsalt);
			while($stmt->fetch()):
				$snum = $snum + 1;
				if(($graphicsfile && file_exists($graphicsuploadpath . $archivesid . '/' . $graphicsfile))):
					echo "<img src=\"{$graphicsdir}{$archivesid}/{$graphicsfile}\" alt=\"{$graphicsalt}\" /><br clear=\"all\">";
					echo "<p><b>Fig. {$snum}:</b> {$graphicsalt}</p><br clear=\"all\">";
				endif;
			endwhile;
			$stmt->close();
		else:
			echo "No graphics found.";
		endif;
		echo "</div>";
		echo "</div>";
	else:
		echo "No article found.";
	endif;
elseif($year && $volume && $issue && $part && $refnumber):
	$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, title, authorname, abstract, file, supplementaryfile, pagenumber, views, downloads FROM archives WHERE (year = ? AND refnumber = ? AND volume = ? AND issue = ? AND part = ? AND status = ?)") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('ssiiss', $year, $refnumber, $volume, $issue, $part, $article_status);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	$stmt->bind_result($archivesid, $doi, $refnumber, $title, $authorname, $abstract, $file, $supplementaryfile, $pagenumber, $views, $downloads);
	$stmt->fetch();
	$stmt->close();
	if($count_rows > 0):
		$newviews = $views + 1;
		$title = strip_tags($title, '<i><em><sup><sub><img>');
		$title = html_entity_decode($title);
		$title = "<h4>{$title}</h4>";
		$abstract = strip_tags($abstract, '<i><em><sup><sub><img><b><strong><div><br><br />');
		$abstract = html_entity_decode($abstract);

		$stmt = $mysqli->prepare("UPDATE archives SET views = ? WHERE archivesid = ?") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('ii', $newviews, $archivesid);
		$stmt->execute();
		$stmt->close();

		echo "<div class=\"abstract\">";
		echo "<div class=\"fluid chead\"><span class=\"fl\">{$year}, VOL. {$volume} ISSUE {$issue}, PART {$part}</span><span class=\"fr\">Pages: {$pagenumber}</span></div>";
		echo "<div class=\"row\">{$title}</div>";
		echo "<div class=\"row\">{$authorname}</div>";
		if($doi):
			echo "<div class=\"row\">";
			echo "<b class=\"heading\">DOI:</b>&nbsp;";
			echo "<a href=\"https://doi.org/{$doi}\" target=\"_blank\">https://doi.org/{$doi}</a>";
			echo "</div>";
		endif;
		echo "<div class=\"row stats\">";
		echo "<div class=\"fl\">Viewed: <b>{$views}</b>&nbsp;&nbsp;-&nbsp;&nbsp;Downloaded: <b>{$downloads}</b></div>";
		echo "<div class=\"fr\">";
		$filepath = $year . '/vol' . $volume . 'issue' . $issue . '/' . $part . '/';
		if(($file && file_exists($archiveuploadpath . $filepath . $file))):
			echo "<a href=\"{$baseurl}download/{$archivesid}/{$file}\" target=\"_blank\" />Full Article</a>";
		endif;
		if(($supplementaryfile && file_exists($archiveuploadpath . $filepath . $supplementaryfile))):
			echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
			echo "<a href=\"{$baseurl}download/{$archivesid}/{$supplementaryfile}\" target=\"_blank\" />Supplementary File</a>";
		endif;
		echo "</div>";
		echo "</div>";
		echo "<div class=\"row\"><b class=\"heading\">Abstract:</b><br clear=\"all\">{$abstract}</div>";

		$stmt = $mysqli->prepare("SELECT * FROM graphics WHERE archivesid = ?") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('i', $archivesid);
		$stmt->execute();
		$stmt->store_result();
		$count_rows = $stmt->num_rows();
		$stmt->close();
		if($count_rows > 1):
			echo "<div class=\"row\">";
			echo "<b class=\"heading\">Related Graphics:</b>&nbsp;";
			echo "<a href=\"{$baseurl}archives/{$year}/vol{$volume}issue{$issue}/{$part}/{$refnumber}/graphics\">Click here for more related graphics:</a>";
			echo "</div>";
		endif;
		$stmt = $mysqli->prepare("SELECT file, graphicsalt FROM graphics WHERE archivesid = ? ORDER BY graphicsid DESC LIMIT 1") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('i', $archivesid);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($graphicsfile, $graphicsalt);
			echo "<div class=\"row graphics\">";
			while($stmt->fetch()):
				if(($graphicsfile && file_exists($graphicsuploadpath . $archivesid . '/' . $graphicsfile))):
					echo "<img src=\"{$graphicsdir}{$archivesid}/{$graphicsfile}\" alt=\"{$graphicsalt}\" /><br clear=\"all\">";
					echo "<p><b>Fig.:</b> {$graphicsalt}</p><br clear=\"all\">";
				endif;
			endwhile;
			$stmt->close();
			echo "</div>";
		endif;
		echo "</div>";
	else:
		echo "No article found.";
	endif;
elseif(($year && $volume && $issue && $part)):
	$stmt = $mysqli->prepare("SELECT (SELECT pagenumber FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND part = ? AND status = ?) ORDER BY creation ASC LIMIT 1), (SELECT pagenumber FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND part = ? AND status = ?) ORDER BY creation DESC LIMIT 1)") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('siisssiiss', $year, $volume, $issue, $part, $article_status, $year, $volume, $issue, $part, $article_status);
	$stmt->execute();
	$stmt->bind_result($firstrow, $lastrow);
	$stmt->fetch();
	$stmt->close();
	$firstpage = strstr($firstrow, '-', true);
	$lastpage = strstr($lastrow, '-');
echo <<<EOJ
	<div class="fluid chead"><span class="fl">{$year}, VOL. {$volume} ISSUE {$issue}, PART {$part}</span><span class="fr">Pages: {$firstpage}{$lastpage}</span></div>
	<table border="0" cellpadding="0" cellspacing="0" class="fluid articles">
		<tr>
			<th align="center" valign="middle" class="xs">S. No.</th>
			<th align="center" valign="middle">Title and Authors Name</th>
			<th align="center" valign="middle" class="sm">Country</th>
		</tr>
EOJ;
		$snum = 0;
		$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, title, authorname, abstract, file, supplementaryfile, country, pagenumber, views, downloads FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND part = ? AND status = ?) ORDER BY LENGTH(pagenumber), pagenumber ASC") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('siiss', $year, $volume, $issue, $part, $article_status);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($archivesid, $doi, $refnumber, $title, $authorname, $abstract, $file, $supplementaryfile, $country, $pagenumber, $views, $downloads);
			while($stmt->fetch()):
				$snum = $snum + 1;
				$title = strip_tags(html_entity_decode($title), '<i><em><sup><sub><img>');
				echo "<tr>";
				echo "<td align=\"center\" valign=\"top\" class=\"xs\">{$snum}</td>";
				echo "<td align=\"left\" valign=\"top\">";
				echo "<div class=\"row\"><b>{$title}</b></div>";
				echo "<div class=\"row\">{$authorname}</div>";
				if($doi):
					echo "<div class=\"row\">";
					echo "<b>DOI:</b>&nbsp;";
					echo "<a href=\"https://doi.org/{$doi}\" target=\"_blank\">https://doi.org/{$doi}</a>";
					echo "</div>";
				endif;
				echo "<div class=\"row link\">";
				if($abstract):
					echo "<a href=\"{$baseurl}archives/{$year}/vol{$volume}issue{$issue}/{$part}/{$refnumber}\">abstract</a>&nbsp;&nbsp;";
				endif;
				$filepath = $archiveuploadpath . $year . '/vol' . $volume . 'issue' . $issue . '/' . $part . '/';
				if(($file && file_exists($filepath . $file))):
					echo "<a href=\"{$baseurl}download/{$archivesid}/{$file}\" target=\"_blank\">download</a>";
				endif;
				if(($supplementaryfile && file_exists($filepath . $supplementaryfile))):
					echo "&nbsp;&nbsp;<a href=\"{$baseurl}download/{$archivesid}/{$supplementaryfile}\" target=\"_blank\">supplementary file</a>";
				endif;
				echo "</div>";
				echo "<div class=\"row\">";
				echo "Pages: <b>{$pagenumber}</b>&nbsp;&nbsp;-&nbsp;&nbsp;Viewed: <b>{$views}</b>";
				echo "&nbsp;&nbsp;-&nbsp;&nbsp;Downloaded: <b>{$downloads}</b>";
				echo "</div>";
				echo "<div class=\"row l\">Country: <b>{$country}</b></div>";
				echo "</td>";
				echo "<td align=\"center\" valign=\"middle\" class=\"sm\">{$country}</td>";
				echo "</tr>";
			endwhile;
		else:
			echo "<tr>";
			echo "<td align=\"center\" valign=\"middle\" colspan=\"3\">No Results Found</td>";
			echo "</tr>";
		endif;
		$stmt->close();
echo <<<EOJ
	</table>
EOJ;
else:
	function part($year, $volume, $issue){
		global $mysqli, $baseurl, $article_status;
		$part_list = "";
		$stmt = $mysqli->prepare("SELECT part FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND status = ?) GROUP BY part ORDER BY part ASC") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('siis', $year, $volume, $issue, $article_status);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$part_list .= "<ul class=\"fluid\">";
			$stmt->bind_result($part);
			while($stmt->fetch()):
				if($part):
					$part_list .= "<li><a href=\"{$baseurl}archives/{$year}/vol{$volume}issue{$issue}/{$part}\">Part {$part}</a></li>";
				endif;
			endwhile;
			$stmt->close();
			$part_list .= "</ul>";
		endif;
		return $part_list;
	}
	function voliss($year){
		global $mysqli, $baseurl, $article_status;
		$issue_list = "";
		$stmt = $mysqli->prepare("SELECT month, volume, issue FROM archives WHERE (year = ? AND status = ?) GROUP BY issue ORDER BY volume DESC, issue DESC") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('ss', $year, $article_status);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($month, $volume, $issue);
			while($stmt->fetch()):
				if(($issue !== $volume . 'S' && $issue !== 'SP' && $issue !== 0)):
					$issue_list .= "<b>vol. {$volume} : issue {$issue}&nbsp;&nbsp;<span>(Posted on " . trim(preg_replace('/[0-9]+/', '', $month)) . " {$year})</span></b>";
					$issue_list .= part($year, $volume, $issue);
				endif;
			endwhile;
			$stmt->close();
		endif;
		return $issue_list;
	}
	$stmt = $mysqli->prepare("SELECT year FROM archives WHERE status = ? GROUP BY year ORDER BY year DESC") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('s', $article_status);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	if($count_rows > 0):
		$stmt->bind_result($year);
		while($stmt->fetch()):
			echo "<div class=\"fluid archives\">";
			echo "<div class=\"fluid chead\">Archives for {$year}</div>";
			echo "<div class=\"body\">" . voliss($year) . "</div>";
			echo "</div>";
		endwhile;
		$stmt->close();
	else:
		echo "<div align=\"center\"><img src=\"{$imageurl}coming-soon.png\" alt=\"Comming Soon\" /></div>";
	endif;
endif;
require_once("footer.php");
?>