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

$keyword = isset($_GET['q']) ? strip_tags(sanitize(escape($_GET['q']))) : NULL;
if($keyword):
	$like = "%$keyword%";
	$stmt = $mysqli->prepare("SELECT archive.archivesid, archive.doi, archive.year, archive.refnumber, archive.volume, archive.issue, archive.part, archive.title, archive.titlefont, archive.authorname, archive.authornamefont, archive.abstract, archive.file, archive.supplementaryfile, archive.country, archive.pagenumber, archive.views, archive.downloads FROM archives as archive LEFT JOIN archiveauthors as archiveauthor ON archive.archivesid = archiveauthor.archiveid WHERE (archive.refnumber = ? OR STRIP_TAGS(archive.title) LIKE ? OR archive.authorname LIKE ? OR archive.abstract LIKE ? OR archive.keywords LIKE ? OR archive.country LIKE ? OR archive.mobile LIKE ? OR archive.email LIKE ? OR archiveauthor.name LIKE ? OR archiveauthor.email LIKE ? OR archiveauthor.phone LIKE ?) AND (archive.status = 'enabled') GROUP BY archive.archivesid ORDER BY archive.creation DESC") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('sssssssssss', $keyword, $like, $like, $like, $like, $like, $like, $like, $like, $like, $like);
	$stmt->execute();
	$stmt->store_result();
	$count_rows = $stmt->num_rows();
else:
	$count_rows = 0;
endif;
if($count_rows > 0):
	echo '<div class="fluid">Results: <b>' . number_format($count_rows, 0) . '</b>, Query: <b>' . $keyword . '</b></div>';
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 = 0;
	$stmt->bind_result($archivesid, $doi, $year, $refnumber, $volume, $issue, $part, $title, $titlefont, $authorname, $authornamefont, $abstract, $file, $supplementaryfile, $country, $pagenumber, $views, $downloads);
	while($stmt->fetch()):
		$snum = $snum + 1;
		$title = html_entity_decode($title);
		$title = strip_tags($title, '<i><em><sup><sub><img>');
		$title = preg_replace("/($keyword)/i", "<mark>{$keyword}</mark>", $title);
		$title = ($titlefont) ? "<b style=\"font-family:{$titlefont} !important;font-size:17px;\">{$title}</b>" : "<b>{$title}</b>";
		$authorname = preg_replace("/($keyword)/i", "<mark>{$keyword}</mark>", $authorname);
		$authorname = ($authornamefont) ? "<font style=\"font-family:{$authornamefont} !important;font-size:15px;\">{$authorname}</font>" : $authorname;
		$country = preg_replace("/($keyword)/i", "<mark>{$keyword}</mark>", $country);
		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 "<div class=\"row\"><b>{$year}</b>, Vol. <b>{$volume}</b>, Issue <b>{$issue}</b>, Part <b>{$part}</b></div>";
				echo "</td>";
				echo "<td align=\"center\" valign=\"top\" class=\"sm\">{$country}</td>";
				echo "</tr>";
	endwhile;
	$stmt->close();
	echo "</table>";
else:
	echo "Sorry, nothing matched your search terms. Please try again with different keywords.";
endif;
require_once("footer.php");
?>