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

$keyword = filter_input(INPUT_GET, 'q', FILTER_SANITIZE_STRING);
$keyword = strip_tags($fn->entities($fn->escape($keyword)));
if($keyword):
	$like = "%$keyword%";
	$stmt = $mysqli->prepare("SELECT archivesid, doi, doistatus, year, refnumber, volume, issue, part, title, titlefont, authorname, authornamefont, abstract, file, supplementaryfile, country, pagenumber, retractcontent, retractstatus, views, downloads FROM archives WHERE (refnumber = ? OR STRIP_TAGS(title) LIKE ? OR authorname LIKE ? OR abstract LIKE ? OR keywords LIKE ? OR country LIKE ? OR mobile LIKE ? OR email LIKE ?) AND (status = 'enabled') GROUP BY archivesid ORDER BY creation DESC") or die('An error occurred. Please try after some time.');
	$stmt->bind_param('ssssssss', $keyword, $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 border="0" cellpadding="0" cellspacing="0" class="articles">
	<tr>
	<th class="xs center-align grey lighten-3 hide-on-med-and-down">S. No.</th>
	<th class="grey lighten-3">Title and Authors Name</th>
	<th class="sm center-align grey lighten-3 hide-on-med-and-down">Country</th>
	</tr>
EOJ;
	$snum = 1;
	$stmt->bind_result($archivesid, $doi, $doistatus, $year, $refnumber, $volume, $issue, $part, $title, $titlefont, $authorname, $authornamefont, $abstract, $file, $supplementaryfile, $country, $pagenumber, $retractcontent, $retractstatus, $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;
		$filepath = $year.'/vol'.$volume.'issue'.$issue.'/Part'.$part.'/';

		echo '<tr>';
		echo '<td class="xs center-align hide-on-med-and-down">'.$snum++.'</td>';
		echo '<td>';
		echo '<div class="body"><b>'.html_entity_decode($title).'</b></div>';
		echo '<div class="body author">'.html_entity_decode($authorname).'</div>';

		if($retractcontent && $retractstatus == 'enabled'):

			echo '<div class="foot">';
			echo '<a href="'.$baseurl.'archives/?year='.$year.'&vol='.$volume.'&issue='.$issue.'&part='.$part.'&ArticleId='.$archivesid.'" class="green-text"><b class="red-text">[</b>retracted<b class="red-text">]</b></a>';
			echo '</div>';

		else:

			if($doi && $doistatus == 'enabled'):
				echo '<div class="body"><b style="font-size:12px">DOI: <a href="https://doi.org/'.$doi.'" class="green-text text-darken-2" target="_blank">'.$doi.'</a></b></div>';
			endif;
	
			echo '<div class="foot">';
			if($abstract):
				echo '<a href="'.$baseurl.'archives/?year='.$year.'&vol='.$volume.'&issue='.$issue.'&part='.$part.'&ArticleId='.$archivesid.'" class="green-text"><b class="red-text">[</b>abstract<b class="red-text">]</b></a>&nbsp;&nbsp;';
			endif;
			if($file && file_exists($archiveuploadpath.$filepath.$file)):
				echo '<a href="'.$archivesdir.$filepath.$file.'" id="'.$archivesid.'" class="green-text download" target="_blank"><b class="red-text">[</b>download<b class="red-text">]</b></a>&nbsp;&nbsp;';
			endif;
			if($supplementaryfile && file_exists($archiveuploadpath.$filepath.$supplementaryfile)):
				echo '<a href="'.$archivesdir.$filepath.$supplementaryfile.'" id="'.$archivesid.'" class="green-text download" target="_blank"><b class="red-text">[</b>supplementary file<b class="red-text">]</b></a>';
			endif;
			echo '</div>';
			echo '<div class="foot"><b class="left">pages: '.$pagenumber.'&nbsp;&nbsp;|&nbsp;&nbsp;'.$views.' views&nbsp;&nbsp;'.$downloads.' downloads</b><b class="left show-on-medium-and-down" style="display:none">&nbsp;&nbsp;|&nbsp;&nbsp;country: '.$country.'</b></div>';
			echo '<div class="foot">'.$year.', vol. '.$volume.', issue '.$issue.', part '.$part.'</div>';

		endif;

		echo '</td>';
		echo '<td class="center-align hide-on-med-and-down">'.$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');
?>