<?php 
	include("header.php");
	include("left-menu.php");
	include("config.php");
?>
<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="#">SSRG International Journal of Computer Science and Engineering </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 International Journal of Computer Science and Engineering</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">
    <div class="alert alert-info"><a class="btn btn-success" href="add_ijcse.php"><i class="glyphicon glyphicon-plus icon-white"></i> Add New IJCSE Article</a></div>
    <table class="table table-striped table-bordered bootstrap-datatable datatable responsive">
    	<thead>
    		<tr>
            	<th>S.NO</th>
				<th>Paper ID</th>
        		<th>Volume & Issue</th>
		 		<th>Month & Year</th>
        		<th>Registered Date </th>
       			<th>Status</th>
        		<th>Actions</th>
    		</tr>
    	</thead>
    <tbody>
	 <?php   
		$i=0;
        $sqls = mysqli_query($conn,"select * from `ijcse` order by paperid asc");
        while ($row = mysqli_fetch_array($sqls)) {
		$i++;
    ?>                                      
    <tr> 
    	<td class="center"><?php echo $i ?></td>
		<td class="center"><?php echo $row['paperid'] ?></td>
        <td class="center"><?php echo $row['volume']."  ".$row['issue'] ?></td>
        <td class="center"><?php echo $row['month']." - ".$row['year'] ?></td>
		<td class="center"><?php echo $row['reg_date'] ?></td>
		<td class="center">
            <span class="label-success label label-default"><?php echo $row['status'] ?></span>
        </td>
        <td class="center">
            <a class="btn btn-success" href="edit_ijcse.php?pid=<?php echo $row['sno'] ?>">
                <i class="glyphicon glyphicon-edit icon-white"></i>
                Edit
            </a>
			<a class="btn btn-success"  onclick='confirmationDelete(this);return false;' href="delete_ijcse.php?pid=<?php echo $row['sno'] ?>" >
                <i class="glyphicon glyphicon-trash icon-white"></i>
                Delete
            </a>
        </td>
    </tr>
<?php }?>
   </tbody>
 </table>
 </div>
</div>
</div>
</div>  
                          <h3><center>Article Counts</center></h3><br />
<div class=" row">
    <div class="col-md-2 col-sm-2 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-book yellow"></i>
			<div>2019 Journals</div>
          	<?php
              $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2019' ");
              while ($row = mysqli_fetch_array($sql)) {
          	?>
			<div><?php echo $row['total']; ?></div>
            <?php }?>
        </a>
    </div>

    <div class="col-md-2 col-sm-2 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-book brown"></i>
			<div>2018 Journals</div>
           <?php
               $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2018' ");
               while ($row = mysqli_fetch_array($sql)) {
           ?>
			<div><?php echo $row['total']; ?></div>
           <?php }?>
        </a>
    </div>

    <div class="col-md-2 col-sm-2 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-book red"></i>
			<div>2017 Journals</div>
             <?php
                $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2017' ");
                while ($row = mysqli_fetch_array($sql)) {
             ?>
			 <div><?php echo $row['total']; ?></div>
            <?php }?>
        </a>
    </div>
	
    <div class="col-md-2 col-sm-2 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-book blue"></i>
			<div>2016 Journals</div>
             <?php
                $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2016' ");
                while ($row = mysqli_fetch_array($sql)) {
             ?>
			 <div><?php echo $row['total']; ?></div>
            <?php }?>
        </a>
    </div>
    
    <div class="col-md-2 col-sm-2 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-book green"></i>
			<div>2015 Journals</div>
             <?php
                $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2015' ");
                while ($row = mysqli_fetch_array($sql)) {
             ?>
			 <div><?php echo $row['total']; ?></div>
            <?php }?>
        </a>
    </div>
    
    <div class="col-md-2 col-sm-2 col-xs-12">
        <a data-toggle="tooltip" title="" class="well top-block" href="#">
            <i class="glyphicon glyphicon-book yellow"></i>
			<div>2014 Journals</div>
             <?php
                $sql = mysqli_query($conn,"select count(sno) as total from `ijcse` where year='2014' ");
                while ($row = mysqli_fetch_array($sql)) {
             ?>
			 <div><?php echo $row['total']; ?></div>
            <?php }?>
        </a>
    </div>
</div>
<?php include("footer.php"); ?>