<?php
require_once('header.php');

$keyword = $fn->entities(filter_input(INPUT_GET, 'q', FILTER_SANITIZE_STRING));
$keyword = urldecode($keyword);
if($keyword):
	$like = "%$keyword%";
	$stmt = $mysqli->prepare("SELECT archive.archivesid, archive.doi, archive.doistatus, archive.year, archive.refnumber, archive.volume, archive.issue, archive.part, archive.title, archive.titlefont, archive.authorname, archive.authornamefont, archive.abstract, archive.file, 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>'.trim($keyword,'%').'</b></div>';
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->bind_result($archivesid, $doi, $doistatus, $year, $refnumber, $volume, $issue, $part, $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">'.$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 '<div class="body"><b>'.$year.'</b>, Vol. <b>'.$volume.'</b>, Issue <b>'.preg_replace('/[^0-9]/', '', $issue).'</b>, Part <b>'.$part.'</b></div>';

		echo '</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');
?>