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

$gv = filter_input(INPUT_GET, 'gv', FILTER_SANITIZE_STRING);
$gv = strip_tags($fn->escape($gv));

if($year && $volume && $issue && $part && $archivesid && $gv === 'true'):
	$stmt = $mysqli->prepare("SELECT title, titlefont FROM archives WHERE (archivesid = ? AND status = 'enabled') 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($title, $titlefont);
	$stmt->fetch();
	$stmt->close();
	if($count_rows == 1):
		$title = strip_tags($title, '<i><em><sup><sub><img>');
		$title = $titlefont ? '<h5 style="font-size:16px;font-family:'.$titlefont.' !important">'.$title.'</h5>' : '<h5>'.$title.'</h5>';

		echo '<div class="head center-align">'.html_entity_decode($title).'</div><br clear="all"><br clear="all">';

		$s = 1;
		$stmt = $mysqli->prepare("SELECT file, graphicsalt FROM graphics WHERE archivesid = ? ORDER BY graphicsid ASC") 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($uploadpath.'graphics/'.$archivesid.'/'.$graphicsfile)):
					echo '<div class="body center-align"><img src="'.$uploadurl.'graphics/'.$archivesid.'/'.$graphicsfile.'" alt="'.$graphicsalt.'" /><br clear="all"><b>Fig. '.$s++.':</b> '.$graphicsalt.'</div><br clear="all"><br clear="all">';
				endif;
			endwhile;
		endif;
		$stmt->close();
	else:
		echo 'No article found.';
	endif;
elseif($year && $volume && $issue && $part && $archivesid):
	$stmt = $mysqli->prepare("SELECT doi, doistatus, refnumber, title, titlefont, authorname, authornamefont, abstract, abstractfont, file, pagenumber, views, downloads FROM archives WHERE (archivesid = ? AND status = 'enabled') 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($doi, $doistatus, $refnumber, $title, $titlefont, $authorname, $authornamefont, $abstract, $abstractfont, $file, $pagenumber, $views, $downloads);
	$stmt->fetch();
	$stmt->close();
	if($count_rows == 1):
		$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 ? '<h5 style="font-size:18px;font-family:'.$titlefont.' !important">'.$title.'</h5>' : '<h5>'.$title.'</h5>';
		$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="head center-align">'.html_entity_decode($title).'</div><br clear="all"><br clear="all">';
		echo '<b class="red-text">Author(s):</b> '.html_entity_decode($authorname).'<br clear="all"><br clear="all">';

		echo '<b class="red-text">Abstract:</b> '.html_entity_decode($abstract).'<br clear="all"><br clear="all">';

		$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 > 3):
			echo '<b class="red-text">Related Graphics:</b> <a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'.'.$archivesid.'?gv=true">Click here for more related graphics</a><br clear="all"><br clear="all">';
		endif;

		$s = 1;

		$stmt = $mysqli->prepare("SELECT file, graphicsalt FROM graphics WHERE archivesid = ? ORDER BY graphicsid ASC LIMIT 3") or die('An error occurred. Please try after some time.');
		$stmt->bind_param('i', $archivesid);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows()):
			$stmt->bind_result($graphicsfile, $graphicsalt);
			while($stmt->fetch()):
				if($graphicsfile && file_exists($uploadpath.'graphics/'.$archivesid.'/'.$graphicsfile)):
					echo '<div class="body center-align"><img src="'.$uploadurl.'graphics/'.$archivesid.'/'.$graphicsfile.'" alt="'.$graphicsalt.'" /><br clear="all"><b>Fig. '.$s++.':</b> '.$graphicsalt.'</div><br clear="all"><br clear="all">';
				endif;
			endwhile;
		endif;
		$stmt->close();

		if($doi && $doistatus === 'enabled'):
			echo '<b class="red-text">DOI:</b> <a href="https://doi.org/'.$doi.'" target="_blank">'.$doi.'</a><br clear="all"><br clear="all">';
		endif;

		echo '<b>Pages: '.$pagenumber.' | Views: '.$views.' | Downloads: '.$downloads.'</b><br clear="all"><br clear="all">';

		if($file && file_exists($uploadpath.'archives/'.$file)):
			echo '<b class="red-text">Download Full Article:</b> <a href="'.$baseurl.'article/'.$archivesid.'/'.$file.'" target="_blank">Click Here</a>';
		endif;
?>
		<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">'.strip_tags(html_entity_decode(str_replace(' and ', ', ', $authorname))).'</span>. ';
		else:
			echo html_entity_decode(str_replace(' and ', ', ', $authorname)).'. ';
		endif;
		if($titlefont):
			echo '<span style="font-family:'.$titlefont.' !important;font-size:18px;text-align:center">'.strip_tags(html_entity_decode($title)).'</span>';
		else:
			echo '<b>'.strip_tags(html_entity_decode($title)).'</b>';
		endif;
		echo '. '.str_replace('.', ' ', $abbreviation).' '.$year.';'.$volume.'('.$issue.'):'.$pagenumber.'.';
		if($doi):
			echo ' DOI: <a href="https://doi.org/'.$doi.'" target="_blank">'.$doi.'</a>';
		endif;
		echo '</div>';
		echo '</div>';
	else:
		echo 'No article found.';
	endif;
elseif($year && $volume && $issue && $part):
echo <<<EOJ
	<table class="articles white">
		<tr>
		<th class="xs center-align hide-on-small-and-down">S. No.</th>
		<th>Title and Authors Name</th>
		</tr>
EOJ;
		$snum = 1;
		$stmt = $mysqli->prepare("SELECT archivesid, doi, doistatus, refnumber, title, titlefont, authorname, authornamefont, abstract, file, country, pagenumber, views, downloads FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND part = ? AND status = 'enabled') ORDER BY LENGTH(pagenumber), pagenumber ASC") or die('An error occurred. Please try after some time.');
		$stmt->bind_param('siss', $year, $volume, $issue, $part);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($archivesid, $doi, $doistatus, $refnumber, $title, $titlefont, $authorname, $authornamefont, $abstract, $file, $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 class="xs center-align hide-on-small-and-down">'.$snum++.'</td>';
				echo '<td>';
				echo '<div class="body">'.html_entity_decode($title).'</div>';
				echo '<div class="body">'.html_entity_decode($authorname).'</div>';

				if($doi && $doistatus === 'enabled'):
					echo '<div class="body"><b>DOI:</b> <a href="https://doi.org/'.$doi.'" target="_blank">https://doi.org/'.$doi.'</a></div>';
				endif;

				echo '<div class="body">'.$abbreviation.', '.$year.'; '.$volume.'('.$issue.'): '.$pagenumber.'</div>';

				echo '<div class="body">';
				if($abstract):
					echo '<a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'.'.$archivesid.'">Abstract</a>&nbsp;&nbsp;|&nbsp;&nbsp;';
				endif;
				if($file && file_exists($uploadpath.'archives/'.$file)):
					$filesize = round(filesize($uploadpath.'archives/'.$file) / 1024).' KB';
					echo '<a href="'.$baseurl.'article/'.$archivesid.'/'.$file.'" target="_blank">Download</a>&nbsp;&nbsp;|&nbsp;&nbsp;';
				else:
					$filesize = 'NA';
				endif;
				echo '<b>Country:</b> '.$country.'&nbsp;&nbsp;|&nbsp;&nbsp;<b>File Size:</b> '.$filesize.'&nbsp;&nbsp;|&nbsp;&nbsp;<b>Views:</b> '.$views.'&nbsp;&nbsp;&nbsp;<b>Downloads:</b> '.$downloads.'';
				echo '</div>';

				echo '</td>';
				echo '</tr>';
			endwhile;
		else:
			echo '<tr><td colspan="2" class="center-align">No Results Found</td></tr>';
		endif;
		$stmt->close();
	echo '</table>';
else:
	function part($year, $volume, $issue)
	{
		global $mysqli, $baseurl;$html = '';

		$stmt = $mysqli->prepare("SELECT part FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND status = 'enabled') GROUP BY part ORDER BY LENGTH(part),part ASC") or die('An error occurred. Please try after some time.');
		$stmt->bind_param('sis', $year, $volume, $issue);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($part);
			while($stmt->fetch()):
				$html .= '<li class="col s6 m3 l3"><b><a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'">Part '.$part.'</a></b></li>';
			endwhile;
		endif;
		$stmt->close();
		return '<ul class="row">'.$html.'</ul><br clear="all">';
	}
	function issues($year)
	{
		global $mysqli;$html = '';

		$stmt = $mysqli->prepare("SELECT month, volume, issue FROM archives WHERE (year = ? AND status = 'enabled') GROUP BY issue ORDER BY volume DESC, issue DESC") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('s', $year);
		$stmt->execute();
		$stmt->store_result();
		if($stmt->num_rows() > 0):
			$stmt->bind_result($month, $volume, $issue);
			while($stmt->fetch()):
				$html .= '<b>Vol. '.$volume.' : Issue '.preg_replace('/[^0-9]/', '', $issue).'&nbsp;&nbsp;<span class="red-text">('.$month.')</span></b><br clear="all">';
				$html .= part($year, $volume, $issue);
			endwhile;
		endif;
		$stmt->close();
		return $html;
	}
	$stmt = $mysqli->prepare("SELECT year FROM archives WHERE status = 'enabled' GROUP BY year ORDER BY year DESC") or die('An error occurred. Please try after some time.');
	$stmt->execute();
	$stmt->store_result();
	if($stmt->num_rows() > 0):
		$stmt->bind_result($year);
		while($stmt->fetch()):
			echo '<div class="fluid archives z-depth-1">';
			echo '<div class="head">Archives for '.$year.'</div>';
			echo '<div class="body">'.issues($year).'</div>';
			echo '</div><br clear="all"><br clear="all">';
		endwhile;
	else:
		echo '<div class="center-align"><img src="'.$imageurl.'coming-soon.png" alt="Comming Soon" /></div>';
	endif;
	$stmt->close();
endif;
require_once('footer.php');
?>