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

$graphicsview = isset($_GET['graphics']) ? sanitize(escape($_GET['graphics'])) : NULL;
if($year && $volume && $issue && $part && $refnumber && $graphicsview == '1'):
	$stmt = $mysqli->prepare("SELECT archivesid, title FROM archives WHERE (year = ? AND refnumber = ? AND volume = ? AND issue = ? AND part = ? AND status = 'enabled' AND conference IS NULL)") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('ssiis', $year, $refnumber, $volume, $issue, $part);
	$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}, Part {$part}</div>";
		echo "<div class=\"abstract\">";
		echo "<div class=\"row\"><h4>{$title}</h4></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 "<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 && $part && $refnumber):
	$stmt = $mysqli->prepare("SELECT archivesid, doi, refnumber, title, titlefont, authorname, authornamefont, abstract, file, supplementaryfile, pagenumber, views, downloads FROM archives WHERE (year = ? AND refnumber = ? AND volume = ? AND issue = ? AND part = ? AND status = 'enabled' AND conference IS NULL)") or die("An error occurred. Please try after some time.");
	$stmt->bind_param('ssiis', $year, $refnumber, $volume, $issue, $part);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
	$stmt->bind_result($archivesid, $doi, $refnumber, $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 /><table><thead><tbody><tfoot><tr><th><td>');
		$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=\"head chead\">{$year}, Vol. {$volume} Issue {$issue}, Part {$part}</div>";
		echo "<div class=\"abstract\">";
		echo "<div class=\"row\"><h4>{$title}</h4></div>";
		echo "<div class=\"row\"><b>AUTHOR(S):</b> {$authorname}</div>";
		echo "<div class=\"row\"><b>ABSTRACT:</b>{$abstract}</div>";
		if($doi):
			echo "<div class=\"row\"><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}/{$volume}/{$issue}/{$part}/{$refnumber}/1\">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\" />{$file_ext} ({$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\" />{$file_ext} ({$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 Appl Dent Sci {$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 && $part)):
echo <<<EOJ
	<div class="head chead">{$year}, Vol. {$volume} Issue {$issue}, Part {$part}</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, title, authorname, abstract, file, supplementaryfile, country, pagenumber, views, downloads FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND part = ? AND status = 'enabled' AND conference IS NULL) ORDER BY LENGTH(pagenumber), pagenumber ASC") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('siis', $year, $volume, $issue, $part);
		$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 doi\">";
					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}/{$volume}/{$issue}/{$part}/{$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 foot\">";
				echo "Pages: <b>{$pagenumber}</b>&nbsp;&nbsp;|&nbsp;&nbsp;<b>{$views}</b> Views&nbsp;&nbsp;<b>{$downloads}</b> Downloaded<br><span class=\"hidden\">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=\"4\">No Results Found</td>";
			echo "</tr>";
		endif;
		$stmt->close();
echo <<<EOJ
	</table>
EOJ;
else:
	echo '<div class="head chead">' . $page_title . '</div>';
	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 = 'enabled' AND conference IS NULL) GROUP BY part ORDER BY part ASC") or die("An error occurred. Please try after some time.");
		$stmt->bind_param('sii', $year, $volume, $issue);
		$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}/{$volume}/{$issue}/{$part}\">Part {$part}</a></li>";
			endwhile;
			$stmt->close();
			$list .= "</ul>";
		endif;
		return $list;
	}
	function voliss($year){
		global $mysqli;
		$list = "";
		$stmt = $mysqli->prepare("SELECT month, volume, issue FROM archives WHERE (year = ? AND status = 'enabled' AND conference IS NULL) 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()):
				$month = preg_replace('/[0-9]+/', '', $month);
				$month = str_replace(' ', '', $month);
				$month = str_replace('-', ' - ', $month);
				$list .= "<div class=\"fluid vi\"><b>VOL. {$volume} : ISSUE {$issue}</b>&nbsp;&nbsp;<span>({$month} {$year})</span></div>";
				$list .= part($year, $volume, $issue);
			endwhile;
			$stmt->close();
		endif;
		return $list;
	}
	$stmt = $mysqli->prepare("SELECT year FROM archives WHERE (status = 'enabled' AND conference IS NULL) GROUP BY year ORDER BY year DESC") or die("An error occurred. Please try after some time.");
	$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">' . voliss($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");
?>