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

if($year && $volume && $issue && $part && $archivesid && $graphicsview):
	$stmt = $mysqli->prepare("SELECT archivesid, title, titlefont FROM archives WHERE (archivesid = ? AND year = ? AND volume = ? AND issue = ? AND part = ? AND status = ?)") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('isiiss', $archivesid, $year, $volume, $issue, $part, $article_status);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	$stmt->bind_result($archivesid, $title, $titlefont);
	$stmt->fetch();
	$stmt->close();
	if($count_rows > 0):
		$title = strip_tags($title, '<i><em><sup><sub><img>');
		$title = ($titlefont) ? '<h3 style="font-family:'.$titlefont.' !important;font-size:16px">'.$title.'</h3>' : '<h3>'.$title.'</h3>';

		echo '<div class="abstract">';
		echo '<div class="head">'.$title.'</div>';
		$snum = 1;
		$stmt = $mysqli->prepare("SELECT file, graphicsalt FROM graphics WHERE archivesid = ? ORDER BY graphicsid DESC") 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. '.$snum++.':</b> '.$graphicsalt;
					echo '</div>';
				endif;
			endwhile;
			$stmt->close();
		endif;
		echo '</div>';
	else:
		echo 'No article found.';
	endif;
elseif($year && $volume && $issue && $part && $archivesid):
	$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, title, titlefont, authorname, authornamefont, abstract, abstractfont, file, supplementaryfile, pagenumber, views, downloads FROM archives WHERE (archivesid = ? AND year = ? AND volume = ? AND issue = ? AND part = ? AND status = ?)") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('isiiss', $archivesid, $year, $volume, $issue, $part, $article_status);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	$stmt->bind_result($archivesid, $doi, $refnumber, $title, $titlefont, $authorname, $authornamefont, $abstract, $abstractfont, $file, $supplementaryfile, $pagenumber, $views, $downloads);
	$stmt->fetch();
	$stmt->close();
	if($count_rows > 0):
		$newviews = $views + 1;
		$stmt = $mysqli->prepare("UPDATE archives SET views = ? WHERE archivesid = ? LIMIT 1") or die('An error occurred. Please try after some time.');
		$stmt->bind_param('ii', $newviews, $archivesid);
		$stmt->execute();
		$stmt->close();

		$title = strip_tags($title, '<i><em><sup><sub><img>');
		$title = ($titlefont) ? '<h3 style="font-family:'.$titlefont.' !important;font-size:16px">'.$title.'</h3>' : '<h3>'.$title.'</h3>';
		$authorname = ($authornamefont) ? '<span style="font-family:'.$authornamefont.' !important;font-size:14px">'.$authorname.'</span>' : $authorname;
		$abstract = strip_tags($abstract, '<i><em><sup><sub><img><b><strong><div><br><br><table><td><th><tr><thead><tbody><tfoot><ul><ol><li>');
		$abstract = ($abstractfont) ? '<span style="font-family:'.$abstractfont.' !important;font-size:14px">'.$abstract.'</span>' : $abstract;

		echo '<div class="abstract">';
		echo '<div class="head">'.$title.'</div>';
		echo '<div class="row"><b class="heading">Author(s):</b> '.$authorname.'</div>';
		echo '<div class="row"><b class="heading">Abstract:</b> '.$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> <a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.strtolower($part).'.'.$archivesid.'.GV">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();
		$count_rows = $stmt->num_rows();
		$stmt->bind_result($graphicsfile, $graphicsalt);
		$stmt->fetch();
		$stmt->close();
		if($count_rows):
			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;
				echo '</div>';
			endif;
		endif;
		
		if($doi):
			echo '<div class="row"><b class="heading">DOI:</b> <a href="https://doi.org/'.$doi.'" target="_blank">'.$doi.'</a></div>';
		endif;
		echo '<div class="row foot">';
		echo 'Pages: '.$pagenumber.'&nbsp;&nbsp;|&nbsp;&nbsp;<b>'.$views.'</b> Views&nbsp;&nbsp;<b>'.$downloads.'</b> Downloads';
		echo '</div>';
		echo '<div class="row foot">';
		if(($file && file_exists($archiveuploadpath.$file))):
			$filesize = filesize($archiveuploadpath.$file);
			$filesize = round($filesize / 1024);
			echo '<a href="'.$baseurl.'articles/'.$archivesid.'/'.$file.'" class="button" target="_blank" />download ('.$filesize.'KB)</a>';
		endif;
		if(($supplementaryfile && file_exists($archiveuploadpath.$supplementaryfile))):
			echo '<a href="'.$baseurl.'articles/'.$archivesid.'/'.$supplementaryfile.'" class="button" target="_blank" />supplementary file</a>';
		endif;
		echo '</div>';
		echo '</div>';
	else:
		echo 'No article found.';
	endif;
elseif(($year && $volume && $issue && $part)):
echo <<<EOJ
	<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 = 1;
		$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, title, titlefont, authorname, authornamefont, 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, $titlefont, $authorname, $authornamefont, $abstract, $file, $supplementaryfile, $country, $pagenumber, $views, $downloads);
			while($stmt->fetch()):
				$title = strip_tags($title, '<i><em><sup><sub><img>');
				$title = ($titlefont) ? '<b style="font-family:'.$titlefont.' !important;font-size:17px;">'.$title.'</b>' : '<b>'.$title.'</b>';
				$authorname = ($authornamefont) ? '<font style="font-family:'.$authornamefont.' !important;font-size:15px">'.$authorname.'</font>' : $authorname;
				echo '<tr>';
				echo '<td align="center" valign="top" class="xs">'.$snum++.'</td>';
				echo '<td align="left" valign="top">';
				echo '<div class="row">'.$title.'</div>';
				echo '<div class="row">'.$authorname.'</div>';
				if($doi):echo '<div class="row"><b>DOI: <a href="https://doi.org/'.$doi.'" target="_blank">'.$doi.'</a></b></div>';endif;
				echo '<div class="row link">';
				if($abstract):
					echo '<a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.strtolower($part).'.'.$archivesid.'">[<b>ABSTRACT</b>]</a>';
				endif;
				if(($file && file_exists($archiveuploadpath.$file))):
					echo '<a href="'.$baseurl.'articles/'.$archivesid.'/'.$file.'" id="'.$archivesid.'" class="download" target="_blank">[<b>DOWNLOAD</b>]</a>';
				endif;
				if(($supplementaryfile && file_exists($archiveuploadpath.$supplementaryfile))):
					echo '<a href="'.$baseurl.'articles/'.$archivesid.'/'.$supplementaryfile.'" id="'.$archivesid.'" class="download" target="_blank">[<b>SUPPLEMENTARY FILE</b>]</a>';
				endif;
				echo '</div>';
				echo '<div class="row foot">';
				echo 'Pages: '.$pagenumber.'&nbsp;&nbsp;|&nbsp;&nbsp;<b>'.$views.'</b> Views&nbsp;&nbsp;<b>'.$downloads.'</b> Downloads<span>&nbsp;&nbsp;|&nbsp;&nbsp;Country: '.$country.'</span>';
				echo '</div>';
				echo '</td>';
				echo '<td align="center" valign="middle" class="sm">'.$country.'</td>';
				echo '</tr>';
			endwhile;
		else:
			echo '<tr><td align="center" valign="middle" colspan="3">No Results Found</td></tr>';
		endif;
		$stmt->close();
echo <<<EOJ
	</table>
EOJ;
else:
	echo '<div class="fluid archives">';
	function part($year, $volume, $issue){
		global $mysqli, $baseurl, $article_status;$list = '';
		$stmt = $mysqli->prepare("SELECT part FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND status = ?) GROUP BY part ORDER BY LENGTH(part), 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):
			$list .= '<ul class="fluid">';
			$stmt->bind_result($part);
			while($stmt->fetch()):
				$list .= '<li><a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.strtolower($part).'">Part '.$part.'</a></li>';
			endwhile;
			$stmt->close();
			$list .= '</ul>';
		endif;
		return $list;
	}
	function issue($year){
		global $mysqli, $baseurl, $article_status;$list = '';
		$stmt = $mysqli->prepare("SELECT month, volume, issue FROM archives WHERE (year = ? AND status = ?) GROUP BY issue ORDER BY Volume DESC, CAST(issue AS UNSIGNED) 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()):
				$month = str_replace('-', ' - ', str_replace(' ', '', preg_replace('/[0-9]+/', '', $month)));
				$list .= '<div class="fluid vi"><b>VOL. '.$volume.' : ISSUE '.$issue.'&nbsp;&nbsp;<span>('.$month.' '.$year.')</span></b></div>';
				$list .= part($year, $volume, $issue);
			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();
	if($stmt->num_rows() > 0):
		$stmt->bind_result($year);
		while($stmt->fetch()):
			echo '<div class="head">Archives for '.$year.'</div>';
			echo '<div class="body">'.issue($year).'</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');
?>