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

$graphicsview = isset($_GET['graphics']) ? sanitize(escape($_GET['graphics'])) : NULL;
if($year && $volume && $issue && $refnumber && $graphicsview == 'graphics'):
	$stmt = $mysqli->prepare("SELECT archivesid, title FROM archives WHERE (year = ? AND refnumber = ? AND volume = ? AND issue = ? AND status = ?)") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('ssiss', $year, $refnumber, $volume, $issue, $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=\"head chead\">{$year}, Vol. {$volume} Issue {$issue}</div>";
		echo "<div class=\"fluid abstract\">";
		echo "<div class=\"row\"><b>{$title}</b></div>";
		echo "<div class=\"row 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 "<b>Fig. {$snum}:</b> {$graphicsalt}<br clear=\"all\"><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 && $refnumber):
	$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, part, title, titlefont, authorname, authornamefont, abstract, file, supplementaryfile, pagenumber, views, downloads FROM archives WHERE (year = ? AND refnumber = ? AND volume = ? AND issue = ? AND status = ?)") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('ssiss', $year, $refnumber, $volume, $issue, $article_status);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	$stmt->bind_result($archivesid, $doi, $refnumber, $part, $title, $titlefont, $authorname, $authornamefont, $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);
		$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();

		$specialissue = (ctype_digit($issue)) ? 'Issue '.$issue : 'Special Issue '.preg_replace('/[^0-9]/', '', $issue);

		echo "<div class=\"head chead\">{$year}, Vol. {$volume}, {$specialissue}</div>";
		echo "<div class=\"fluid abstract\">";
		echo "<div class=\"row\"><b>{$title}</b></div>";
		echo "<div class=\"row\"><b>Author(s):</b> {$authorname}</div>";
		echo "<div class=\"row\"><b>Abstract:</b><br>{$abstract}</div>";
		
		if($doi):
			echo "<div class=\"row doi\"><b>DOI:</b> <a href=\"https://doi.org/{$doi}\" target=\"_blank\">https://doi.org/{$doi}</a></div>";
		endif;

		$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>Related Graphics:</b> ";
			echo "<a href=\"{$baseurl}archives/{$year}/vol{$volume}/issue{$issue}/{$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);
			while($stmt->fetch()):
				if(($graphicsfile && file_exists($graphicsuploadpath . $archivesid . '/' . $graphicsfile))):
					echo "<div class=\"row graphics\">";
					echo "<img src=\"{$graphicsdir}{$archivesid}/{$graphicsfile}\" alt=\"{$graphicsalt}\" /><br clear=\"all\">";
					echo "<b>Fig.:</b> {$graphicsalt}<br clear=\"all\">";
					echo "</div>";
				endif;
			endwhile;
			$stmt->close();
		endif;

		echo "<div class=\"row\"><b>Pages:</b>&nbsp;{$pagenumber}&nbsp;&nbsp;|&nbsp;&nbsp;<b>{$views}</b> Views&nbsp;&nbsp;<b>{$downloads}</b> Downloads</div>";
		echo "<div class=\"row foot\">";
		$filepath = $year.'/vol'.$volume.'issue'.$issue.'/Part'.$part.'/';
		if(($file && file_exists($archiveuploadpath . $filepath . $file))):
			$filesize = filesize($archiveuploadpath . $filepath . $file);
			$filesize = round($filesize / 1024);
			$file_ext = strtolower(pathinfo($archiveuploadpath . $filepath . $file, PATHINFO_EXTENSION));
			if($file_ext == 'pdf'):
				$file_ext = "PDF";
				$class = "pdf";
			elseif(($file_ext == 'doc' || $file_ext == 'docx')):
				$file_ext = "WORD";
				$class = "doc";
			endif;
			echo "<a href=\"{$archivesdir}{$filepath}{$file}\" id=\"{$archivesid}\" class=\"button {$class} download\" target=\"_blank\" />Download ({$filesize}KB)</a>";
		endif;
		if(($supplementaryfile && file_exists($archiveuploadpath . $filepath . $supplementaryfile))):
			$filesize = filesize($archiveuploadpath . $filepath . $supplementaryfile);
			$filesize = round($filesize / 1024);
			$file_ext = strtolower(pathinfo($archiveuploadpath . $filepath . $supplementaryfile, PATHINFO_EXTENSION));
			if($file_ext == 'pdf'):
				$file_ext = "PDF";
				$class = "pdf";
			elseif(($file_ext == 'doc' || $file_ext == 'docx')):
				$file_ext = "WORD";
				$class = "doc";
			endif;
			echo "<a href=\"{$archivesdir}{$filepath}{$supplementaryfile}\" id=\"{$archivesid}\" class=\"button {$class} download\" target=\"_blank\" />Supplementary File ({$filesize}KB)</a>";
		endif;
		echo "</div>";
		echo "</div>";

?>
		<br clear="all">
		<br clear="all">
		<a href="https://www.akinik.com/journallist" target="_blank">
			<img src="<?php echo $baseurl; ?>images/call-for-paper-ads.jpg" alt="<?php echo $websitename;?>" />
		</a>
<?php
		echo "<div class=\"fluid citation\">";
		echo "<div class=\"head\">How to cite this article:</div>";
		echo "<div class=\"body\">";
		if($authornamefont):
			echo '<span style="font-family:'.$authornamefont.' !important;font-size:18px">'.str_replace(' and ', ', ', $authorname).'</span>. ';
		else:
			echo str_replace(' and ', ', ', $authorname).". ";
		endif;
		if($titlefont):
			echo "<span style=\"font-family:{$titlefont} !important;font-size:18px;text-align:center;\">{$title}</span>";
		else:
			echo $title;
		endif;
		echo ". Int J Physiol Nutr Phys Educ {$year};{$volume}({$issue}):{$pagenumber}.";
		if($doi):
			echo " DOI: <a href=\"https://doi.org/{$doi}\" target=\"_blank\">https://doi.org/{$doi}</a>";
		endif;
		echo "</div>";
		echo "</div>";
	else:
		echo "No article found.";
	endif;
elseif(($year && $volume && $issue)):
	$stmt = $mysqli->prepare("SELECT * FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND status = ?)") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('siss', $year, $volume, $issue, $article_status);
	$stmt->execute();
	$stmt->store_result();
	$totalres = $stmt->num_rows();
	$stmt->close();

	$perpage   = 20;
	$curpage   = isset($_GET['page']) ? strip_tags(sanitize(escape($_GET['page']))) : 1;
	$start     = ($curpage * $perpage) - $perpage;
	$endpage   = ceil($totalres/$perpage);
	$startpage = 1;
	$nextpage  = $curpage + 1;
	$prevpage  = $curpage - 1;

	$specialissue = (ctype_digit($issue)) ? 'Issue '.$issue : 'Special Issue '.preg_replace('/[^0-9]/', '', $issue);
echo <<<EOJ
	<div class="head chead">{$year}, Vol. {$volume}, {$specialissue}</div>
	<table border="0" cellpadding="0" cellspacing="0" class="fluid articles">
		<tr>
			<th align="center" valign="middle" class="xs">S. No.</th>
			<th align="left" 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, part, title, authorname, abstract, file, supplementaryfile, country, pagenumber, views, downloads FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND status = ?) ORDER BY LENGTH(pagenumber), pagenumber ASC LIMIT $start, $perpage") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('siss', $year, $volume, $issue, $article_status);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($archivesid, $doi, $refnumber, $part, $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 doi\">";
					echo "<b>DOI:</b>&nbsp;<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}/{$refnumber}\"><b>[ABSTRACT]</b></a>&nbsp;&nbsp;&nbsp;";
				endif;
				$filepath = $year . '/vol' . $volume . 'issue' . $issue . '/Part' . $part . '/';
				if(($file && file_exists($archiveuploadpath . $filepath . $file))):
					echo "<a href=\"{$archivesdir}{$filepath}{$file}\" id=\"{$archivesid}\" class=\"download\" target=\"_blank\"><b>[DOWNLOAD]</b></a>";
				endif;
				if(($supplementaryfile && file_exists($archiveuploadpath . $filepath . $supplementaryfile))):
					echo "&nbsp;&nbsp;<a href=\"{$archivesdir}{$filepath}{$supplementaryfile}\" id=\"{$archivesid}\" class=\"download\" target=\"_blank\"><b>[SUPPLEMENTARY FILE]</b></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><span class=\"hidden\">&nbsp;&nbsp;-&nbsp;&nbsp;Country: <b>{$country}</b></span>";
				echo "</div>";
				echo "</td>";
				echo "<td align=\"center\" valign=\"top\" 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;
	if($totalres > $perpage):
		$mainurl = $baseurl.'archives/'.$year.'/vol'.$volume.'/issue'.$issue;
		echo '<ul class="fluid pagination">';
		if($curpage != $startpage):
			echo '<li><a href="'.$mainurl.'?page='.$startpage.'">first</a></li>';
		endif;
		if($curpage != $startpage):
			echo '<li><a href="'.$mainurl.'?page='.$prevpage.'" class="arrow">&laquo;</a></li>';
		endif;
		if($curpage >= 2):
			echo '<li><a href="'.$mainurl.'?page='.$prevpage.'">'.$prevpage.'</a></li>';
		endif;
		echo '<li><a href="javascript:void(0);" class="active">'.$curpage.'</a></li>';
		if($curpage != $endpage):
			echo '<li><a href="'.$mainurl.'?page='.$nextpage.'">'.$nextpage.'</a></li>';
		endif;
		if($curpage != $endpage):
			echo '<li><a href="'.$mainurl.'?page='.$nextpage.'" class="arrow">&raquo;</a></li>';
		endif;
		if($curpage != $endpage):
			echo '<li><a href="'.$mainurl.'?page='.$endpage.'">last</a></li>';
		endif;
		echo '</ul>';
	endif;
else:
	echo '<div class="head chead">' . $page_title . '</div>';
	echo '<div class="fluid archives">';
	function voliss($year){
		global $mysqli, $baseurl, $article_status;
		$list = "";
		$stmt = $mysqli->prepare("SELECT month, volume, issue, conference, specialissue 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, $conference, $specialissue);
			while($stmt->fetch()):
				$month = str_replace('-', ' - ', str_replace(' ', '', preg_replace('/[0-9]+/', '', $month)));
				if(ctype_digit($issue) && $specialissue == 'N'):
					$list .= '<li><a href="'.$baseurl.'archives/'.$year.'/vol'.$volume.'/issue'.$issue.'"><b>Vol. '.$volume.' : Issue '.$issue.'</b></a>&nbsp;&nbsp;<i>('.$month.' '.$year.')</i></li>';
				else:
					$list .= '<li><a href="'.$baseurl.'archives/'.$year.'/vol'.$volume.'/issue'.$issue.'"><b>Vol. '.$volume.' : Special Issue '.preg_replace('/[^0-9]/', '', $issue).'</b></a>&nbsp;&nbsp;<i>('.$conference.')</i></li>';
				endif;
			endwhile;
			$stmt->close();
		endif;
		return $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="head"><b>Archives for '.$year.'</b></div>';
			echo '<div class="body"><ul class="fluid">'.voliss($year).'</ul></div>';
		endwhile;
		$stmt->close();
	else:
		echo "<div align=\"center\"><img src=\"{$imageurl}coming-soon.png\" alt=\"Comming Soon\" /></div>";
	endif;
	echo "</div>";
endif;
require_once("footer.php");
?>