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

$keyword = filter_input(INPUT_GET, 'q', FILTER_SANITIZE_STRING);
$keyword = strip_tags(urldecode($fn->escape($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.supplementaryfile, archive.country, archive.pagenumber, archive.retractcontent, archive.retractstatus, archive.views, archive.downloads, archive.specialissue 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, $supplementaryfile, $country, $pagenumber, $retractcontent, $retractstatus, $views, $downloads, $specialissue);
	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($retractcontent && $retractstatus === 'enabled'):

			echo '<div class="body">';
			echo '<a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'.'.$archivesid.'">Retracted</a>';
			echo '</div>';

		else:

			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">Int. J. Political Sci. Governance, '.$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="'.$uploadurl.'archives/'.$file.'" id="'.$archivesid.'" class="download" target="_blank">Download</a>&nbsp;&nbsp;|&nbsp;&nbsp;';
			else:
				$filesize = 'NA';
			endif;
			if($supplementaryfile && file_exists($uploadpath.'archives/'.$supplementaryfile)):
				echo '<a href="'.$uploadurl.'archives/'.$supplementaryfile.'" id="'.$archivesid.'" class="download" target="_blank">Supplementary File</a>&nbsp;&nbsp;|&nbsp;&nbsp;';
			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>';
			$specialissuetext = (!ctype_digit($issue) && $specialissue === 'Y') ? 'Special Issue' : 'Issue';
			echo '<div class="body"><b>'.$year.'</b>, Vol. <b>'.$volume.'</b>, '.$specialissuetext.' <b>'.preg_replace('/[^0-9]/', '', $issue).'</b>, Part <b>'.$part.'</b></div>';

		endif;

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