| Server IP : 192.169.170.185 / Your IP : 216.73.216.97 Web Server : Apache System : Linux p3plmcpnl495852.prod.phx3.secureserver.net 4.18.0-553.52.1.lve.el8.x86_64 #1 SMP Wed May 21 15:31:29 UTC 2025 x86_64 User : akhilnew ( 1712764) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/akhilnew/public_html/humanresourcejournal.com/ |
Upload File : |
<?php
require_once('header.php');
echo $page_content;
$gv = filter_input(INPUT_GET, 'gv', FILTER_SANITIZE_STRING);
$gv = strip_tags($fn->remaspace($fn->escape($gv)));
if($year && $volume && $issue && $part && $archivesid && $gv === 'true'):
$stmt = $mysqli->prepare("SELECT title, titlefont FROM archives WHERE (archivesid = ? AND status = 'enabled' AND specialissue = 'Y') LIMIT 1") 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->bind_result($title, $titlefont);
$stmt->fetch();
$stmt->close();
if($count_rows == 1):
$title = strip_tags($title, '<i><em><sup><sub><img>');
$title = ($titlefont) ? '<h5 style="font-size:16px;font-family:'.$titlefont.' !important">'.$title.'</h5>' : '<h5>'.$title.'</h5>';
echo '<div class="fluid abstract">';
echo '<div class="center-align">'.html_entity_decode($title).'</div>';
$snum = 1;
$stmt = $mysqli->prepare("SELECT file, graphicsalt FROM graphics WHERE archivesid = ? ORDER BY graphicsid DESC") 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($uploadpath.'graphics/'.$archivesid.'/'.$graphicsfile)):
echo '<div class="center-align body">';
echo '<img src="'.$uploadurl.'graphics/'.$archivesid.'/'.$graphicsfile.'" alt="'.$graphicsalt.'" style="float:none" /><br clear="all">';
echo '<b>Fig.:</b> '.$graphicsalt;
echo '</div>';
endif;
endwhile;
endif;
$stmt->close();
echo '</div>';
else:
echo 'No article found.';
endif;
elseif($year && $volume && $issue && $part && $archivesid):
$stmt = $mysqli->prepare("SELECT doi, doistatus, refnumber, title, titlefont, authorname, authornamefont, abstract, abstractfont, file, filestatus, supplementaryfile, pagenumber, views, downloads, amendment, amendmentfile FROM archives WHERE (archivesid = ? AND status = 'enabled' AND specialissue = 'Y') LIMIT 1") 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->bind_result($doi, $doistatus, $refnumber, $title, $titlefont, $authorname, $authornamefont, $abstract, $abstractfont, $file, $filestatus, $supplementaryfile, $pagenumber, $views, $downloads, $amendment, $amendmentfile);
$stmt->fetch();
$stmt->close();
if($count_rows == 1):
$newviews = $views + 1;
$stmt = $mysqli->prepare("UPDATE archives SET views = ? WHERE archivesid = ? LIMIT 1") or die('An error occurred. Please try after some time.');
$stmt->bind_param('ii', $newviews, $archivesid);
$stmt->execute();
$stmt->close();
$title = strip_tags($title, '<i><em><sup><sub><img>');
$title = ($titlefont) ? '<h5 style="font-size:18px;font-family:'.$titlefont.' !important">'.$title.'</h5>' : '<h5>'.$title.'</h5>';
$authorname = ($authornamefont) ? '<span style="font-family:'.$authornamefont.' !important;font-size:14px">'.$authorname.'</span>' : $authorname;
$abstract = strip_tags($abstract, '<i><em><sup><sub><img><b><strong><div><br><br /><table><td><th><tr><thead><tbody><tfoot><ul><ol><li>');
$abstract = ($abstractfont) ? '<span style="font-family:'.$abstractfont.' !important;font-size:14px">'.$abstract.'</span>' : $abstract;
echo '<div class="fluid abstract">';
echo '<div class="center-align">'.html_entity_decode($title).'</div>';
echo '<div class="body"><label class="red-text label">author(s)</label><br clear="all">'.html_entity_decode($authorname).'</div>';
echo '<div class="body"><label class="red-text label">abstract</label><br clear="all">'.html_entity_decode($abstract).'</div>';
// $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="body">';
// echo '<label class="red-text label">related graphics</label><br clear="all"><a href="'.$baseurl.'archives/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'.'.$archivesid.'?gv=true">Click here for more related graphics</a>';
// echo '</div>';
// endif;
$fignum = 1;
$stmt = $mysqli->prepare("SELECT file, graphicsalt FROM graphics WHERE archivesid = ? ORDER BY graphicsid DESC") 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($uploadpath.'graphics/'.$archivesid.'/'.$graphicsfile)):
echo '<div class="body center-align">';
echo '<img src="'.$uploadurl.'graphics/'.$archivesid.'/'.$graphicsfile.'" alt="'.$graphicsalt.'" style="float:none" /><br clear="all">';
echo '<b>Fig. '.($fignum++).':</b> '.$graphicsalt;
echo '</div>';
endif;
endwhile;
endif;
$stmt->close();
if($doi):
echo '<div class="body"><label class="red-text label">doi</label><br clear="all"><a href="https://doi.org/'.$doi.'" target="_blank">https://doi.org/'.$doi.'</a></div>';
endif;
echo '<div class="foot">Pages : '.$pagenumber.' | <span>'.$views.'</span> Views | <span>'.$downloads.'</span> Downloads</div>';
echo '<div class="foot">';
if($file && file_exists($uploadpath.'archives/'.$file)):
echo '<a href="'.$baseurl.'article/view/'.$archivesid.'/'.$refnumber.'" target="_blank" class="btn-flat waves-effect red white-text">Download Full Article</a>';
endif;
if($supplementaryfile && file_exists($archiveuploadpath.$supplementaryfile)):
echo '<a href="'.$baseurl.'article/supplementaryfile/'.$archivesid.'/'.$refnumber.'" target="_blank" class="btn-flat waves-effect red white-text">Supplementary File</a>';
endif;
echo '</div>';
echo '</div>';
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">'.strip_tags(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">'.strip_tags($title).'</span>';
else:
echo strip_tags($title);
endif;
echo '. Int J Res Hum Resour Manage '.$year.';'.$volume.'('.$issue.'):'.$pagenumber.'.';
if($doi):
echo ' DOI: <a href="https://doi.org/'.$doi.'" target="_blank">'.$doi.'</a>';
endif;
echo '</div>';
echo '</div>';
else:
echo 'No article found.';
endif;
elseif($year && $volume && $issue):
echo <<<EOJ
<table border="0" cellpadding="0" cellspacing="0" class="articles">
<tr>
<th class="xs center-align hide-on-med-and-down">S. No.</th>
<th>Title and Authors Name</th>
</tr>
EOJ;
$snum = 1;
$stmt = $mysqli->prepare("SELECT archivesid, doi, doistatus, refnumber, title, titlefont, authorname, authornamefont, abstract, file, filestatus, supplementaryfile, country, pagenumber, views, downloads FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND part = ? AND status = 'enabled' AND specialissue = 'Y') ORDER BY LENGTH(pagenumber), pagenumber ASC") or die('An error occurred. Please try after some time.');
$stmt->bind_param('siss', $year, $volume, $issue, $part);
$stmt->execute();
$stmt->store_result();
if($stmt->num_rows() > 0):
$stmt->bind_result($archivesid, $doi, $doistatus, $refnumber, $title, $titlefont, $authorname, $authornamefont, $abstract, $file, $filestatus, $supplementaryfile, $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-med-and-down">'.$snum++.'</td>';
echo '<td>';
echo '<div class="body">'.html_entity_decode($title).'</div>';
echo '<div class="body author"><i>'.html_entity_decode($authorname).'</i></div>';
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="body">Int. J. Res. Hum. Resour. Manage., '.$year.'; '.$volume.'('.$issue.'): '.$pagenumber.'</div>';
echo '<div class="foot">';
if($abstract):
echo '<a href="'.$baseurl.'special-issue/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'.'.$archivesid.'" class="green-text text-darken-2"><b>Abstract</b></a> | ';
endif;
if($file && file_exists($uploadpath.'archives/'.$file)):
$filesize = round((filesize($uploadpath.'archives/'.$file)) / 1024).' KB';
echo '<a href="'.$baseurl.'article/view/'.$archivesid.'/'.$refnumber.'" target="_blank" class="green-text text-darken-2"><b>Download</b></a> | ';
else:
$filesize = 'NA';
endif;
if($supplementaryfile && file_exists($uploadpath.'archives/'.$supplementaryfile)):
echo '<a href="'.$baseurl.'article/supplementaryfile/'.$archivesid.'/'.$refnumber.'" target="_blank" class="green-text text-darken-2"><b>Supplementary File</b></a> | ';
endif;
echo 'Country : '.$country.' | File Size: ('.$filesize.') | <b>'.$views.'</b> Views <b>'.$downloads.'</b> Downloads';
echo '</div>';
echo '</td>';
echo '</tr>';
endwhile;
$stmt->close();
else:
echo '<tr><td colspan="4" class="center-align">No Results Found</td></tr>';
endif;
echo '</table>';
else:
function part($year, $volume, $issue){
global $mysqli, $baseurl;$html = '';
$stmt = $mysqli->prepare("SELECT part FROM archives WHERE (year = ? AND volume = ? AND issue = ? AND status = 'enabled' AND specialissue = 'Y') GROUP BY part ORDER BY part ASC") or die('An error occurred. Please try after some time.');
$stmt->bind_param('sis', $year, $volume, $issue);
$stmt->execute();
$stmt->store_result();
if($stmt->num_rows() > 0):
$stmt->bind_result($part);
while($stmt->fetch()):
$html .= '<div class="col s6 m6 l3"><a href="'.$baseurl.'special-issue/'.$year.'.v'.$volume.'.i'.$issue.'.'.$part.'" class="green-text text-darken-2">Part '.$part.'</a></div>';
endwhile;
endif;
$stmt->close();
return $html;
}
function issues($year){
global $mysqli;$html = '';
$stmt = $mysqli->prepare("SELECT month, volume, issue FROM archives WHERE (year = ? AND status = 'enabled' AND specialissue = 'Y') GROUP BY issue ORDER BY Volume DESC, CAST(Issue AS UNSIGNED) 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()):
$html .= '<div class="row issue"><div class="col s12 m12 l12">vol. '.$volume.' : issue '.$issue.' <span class="red-text">('.trim(preg_replace('/[0-9]+/', '', $month)).' '.$year.')</span></div></div>';
$html .= '<div class="row parts"><b>'.part($year, $volume, $issue).'</b></div>';
endwhile;
endif;
$stmt->close();
return $html;
}
$stmt = $mysqli->prepare("SELECT year FROM archives WHERE (status = 'enabled' AND specialissue = 'Y') GROUP BY year ORDER BY year DESC") or die('An error occurred. Please try after some time.');
$stmt->execute();
$stmt->store_result();
if($stmt->num_rows() > 0):
$stmt->bind_result($year);
while($stmt->fetch()):
echo '<div class="fluid archives">';
echo '<div class="col s12 m12 l12 light-green darken-1 white-text head">'.$year.' Issues</div>';
echo '<div class="col s12 m12 l12 body">'.issues($year).'</div>';
echo '</div>';
endwhile;
else:
echo '<div align="center"><img src="'.$imageurl.'coming-soon.png" alt="Comming Soon" style="float:none" /></div>';
endif;
$stmt->close();
endif;
require_once('footer.php');
?>