<?php include("header.php");
include("left-menu.php");
include("config.php");

//header('location:articleview.php?value=');

   
?>
  <noscript>
            <div class="alert alert-block col-md-12">
                <h4 class="alert-heading">Warning!</h4>
					<p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a>
                    enabled to use this site.</p>
            </div>
  </noscript>

  <div id="content" class="col-lg-10 col-sm-10">
  <!-- content starts -->
   <div>
    <ul class="breadcrumb">
        <li>
            <a href="#">Home</a>
        </li>
        <li>
            <a href="#">Special Issue Article</a>
        </li>
    </ul>
  </div>
<div class="row">
    <div class="box col-md-12">
        <div class="box-inner">
    		<div class="box-header well" data-original-title="">
        		<h2><i class="glyphicon glyphicon-home"></i> View Special Issue Article</h2>
			<div class="box-icon">
            	<a href="#" class="btn btn-setting btn-round btn-default"><i class="glyphicon glyphicon-cog"></i></a>
            	<a href="#" class="btn btn-minimize btn-round btn-default"><i
                    class="glyphicon glyphicon-chevron-up"></i></a>
            	<a href="#" class="btn btn-close btn-round btn-default"><i class="glyphicon glyphicon-remove"></i></a>
        	</div>
    	</div>
    <div class="box-content">
    	
    	<table class="table table-striped table-bordered bootstrap-datatable datatable responsive">
    		<thead>
    			<tr>
                    <th>S.NO</th>
                    <th>Conference Name</th>
                    <th>Short form</th>
                    <th>Year</th>
                    <th>Department</th>
                    <th>Part</th>
                    <th>Title</th>
                    <th>Author</th>
                    <th>Pdf</th>
                    <th>Action</th>
                </tr>
    		</thead>
    		<tbody>
				 <?php   
					$i=0;
					
				
						$sshortname = $_REQUEST['name'];
						$sdepartment = $_REQUEST['department'];
						$spart = $_REQUEST['part'];
						$syear = $_REQUEST['year']; 

					$query = "select * from specialissue_conference inner join specialissue_article on specialissue_conference.sp_id=specialissue_article.sc_id Inner join article_department on specialissue_article.department=article_department.dp_id";
					if($sshortname!='')
					{
					   $query.= " where sp_id='$sshortname'";
					}
					if($sdepartment!='')
					{
					   $query.= " And department='$sdepartment'";
					}
					if($spart!='')
					{
					   $query.= " And part='$spart'";
					}
					if($syear!='')
					{
					   $query.= " And specialissue_article.year='$syear'";
					}
					//echo $query;
					//exit;
					$sqls = mysqli_query($conn,$query);
        			//$sqls = mysqli_query($conn,"select * from `specialissue_conference` ");
         			while ($row = mysqli_fetch_array($sqls)) {
			 		$i++;
        		 ?>                                      
    			<tr> 
                	<td class="center"><?php echo $i ?></td>
					<td class="center"><?php echo $row['conference_name']; ?></td>
        			<td class="center"><?php echo $row['shortform']; ?></td>
                    <td class="center"><?php echo $row['year']; ?></td>
                    <td class="center"><?php echo $row['department_name']; ?></td>
                    <td class="center"><?php echo $row['part'] ?></td>
                    <td class="center"><?php echo $row['title'] ?></td>
                    <td class="center"><?php echo $row['author'] ?></td>
                    <td class="center"><?php echo $row['pdf'] ?></td>
                    <td class="center"><a class="btn btn-success" href="edit_specialissue.php?sid=<?php echo $row['sp_id'] ?>">
                               <i class="glyphicon glyphicon-edit icon-white"></i>
                					Edit
            			</a>
						<a class="btn btn-success"  onclick='confirmationDelete(this);return false;' href="delete_specialissue.php?sid=<?php echo $row['sp_id'];?>" >
                				<i class="glyphicon glyphicon-trash icon-white"></i>
                					Delete
            			</a></td>
				</tr>
			<?php } ?>
 		</tbody>
     </table>
    </div>
  </div>
 </div>
</div>  
<?php include("footer.php"); ?>