include('../_left.php');
$y=rq("y");
$part=rq("part");
$part_="";
if($part=='a')$part_=" and journal_subject='Part A' ";
if($part=='b')$part_=" and journal_subject='Part B' ";
if($part=='c')$part_=" and journal_subject='Part C' ";
$dt_=" year(checked_ptime)='$y' ";
if($y=='old')$dt_=" ( year(ptime)='2011' or (year(ptime)='2012') )";
if($y=='2011')$dt_=" ( year(ptime)='2011' or (year(ptime)='2012') and month(ptime)<6 )";
if($y=='2012')$dt_=" ( year(ptime)='2012' and month(ptime)>=6 )";
if($y=='2013')$dt_=" ( year(ptime)='2013' )";
if($y=='2014')$dt_=" ( year(ptime)='2014' )";
if($y=='2015')$dt_=" ( year(ptime)='2015' )";
if($y=='2016')$dt_=" ( year(ptime)='2016' )";
if($y=='2017')$dt_=" ( year(ptime)='2017' )";
if($y=='2018')$dt_=" ( year(ptime)='2018' )";
if($y=='2019')$dt_=" ( year(ptime)='2019' )";
echo '';
$r=g("select * from manuscript where $dt_ and statu='Accepted' $part_ order by ptime desc");
?>
Current
foreach($r->items() as $r)
{
?>
Author:
$s=trim($r['author_ex']);
if($s=='')$s=sv("select concat(first_name,' ',middle_name,' ',last_name) from authors where id='{$r['author_id']}' ");
echo $s;
?>
Accepted Data :;
Published Data : |