<?php include("header.php");?>
	<div class="navbar">
		<div class="navbar-inner">
			<?php include("top_header.php");?>
		</div>
	</div>
	<?php $sql = mysqli_query($mysqli, "SELECT * FROM `add_journal` WHERE `id`='".$_GET['id']."'");
		  $row = mysqli_fetch_array($sql);?>
		<div class="container-fluid-full">
		<div class="row-fluid">
			<?php include("sidebar.php");?>
			<div id="content" class="span10">
			<ul class="breadcrumb">
				<li>
					<i class="icon-home"></i>
					<a href="dashboard.php"><b style="color: white;">Home</b></a> 
					<i class="icon-angle-right"></i>
				</li>
				<li><a href="#"><b style="color: white;">Committee</b></a></li>
			</ul>
			<a href="add_committee.php" class="btn btn-primary btn-xs" style="float: ;"><b style="color: white;">Add Committee</b></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			<a href="manage_committee.php" class="btn btn-primary btn-xs" style="float: right;"><b style="color: white;">Back to Committee Page</b></a>
			<div class="row-fluid">
				<div class="box span12">
					<div class="box-header" data-original-title>
						<h2><i class="halflings-icon edit"></i><span class="break"></span><b style="color: white;">List of Committee of <?php echo $row['volume'];?> (<?php echo $row['year'];?>) : <?php echo $row['issue_number'];?> (<?php echo $row['issue_month'];?>)</b></h2>
						<div class="box-icon">
							<a href="#" class="btn-setting"><i class="halflings-icon wrench"></i></a>
							<a href="#" class="btn-minimize"><i class="halflings-icon chevron-up"></i></a>
							<a href="#" class="btn-close"><i class="halflings-icon remove"></i></a>
						</div>
					</div>
					<div class="box-content">
						     
						<table class="table table-striped table-bordered bootstrap-datatable datatable">
						  <thead>
							  <tr>
								  <th>Sr.No</th>
								  <th>Issue Number</th>
								  <th>Committee</th>
								  <th>Sub Committee</th>
								  <th>Name</th>
								  <th>Sr.No (Sort)</th>
								  <th>Details</th>
								  <th>Image</th>
								  <th>Date Time</th>
								  <th>Actions</th>
								  
							  </tr>
						  </thead>   
						  <tbody>
						  <?php $sqls = mysqli_query($mysqli,"SELECT * FROM `body` WHERE `volume`='".$_GET['id']."' ORDER BY sort ASC");
						   $i=1;
						  		while($rows = mysqli_fetch_array($sqls)){?>
							<tr>
								<td><?php echo $i;?></td>
								<td><?php echo $row['journal_name'];?> (<?php echo $row['year'];?> <?php echo $row['issue_number'];?>)</td>
								<td><?php echo ucfirst($rows['body']); ?></td>
								<td><?php echo ucfirst($rows['sub_body']); ?></td>
								<td><?php echo ucfirst($rows['name']); ?></td>
								<td><?php echo ucfirst($rows['sort']); ?></td>
								<td><?php echo $rows['content'];?></td>
								<td><img src="uploadedImage/body/<?php echo $rows['image'];?>" width='50'></td>
								<td><?php echo $rows['date_time'];?></td>
								<td class="center">
									
									<a class="btn btn-info" href="edit_body.php?id=<?php echo $rows['id'];?>&&issue_number=<?php echo $_GET['issue_number'];?>&&year=<?php echo $_GET['year'];?>">
										<i class="halflings-icon white edit"></i>  
									</a>
									<a class="btn btn-danger" href="delete_body.php?id=<?php echo $rows['id'];?>" onclick="return confirm('Are you sure want to Delete');">
										<i class="halflings-icon white trash"></i> 
									</a>
								</td>
								
							</tr>
							<?php $i++;} ?>
							
						  </tbody>
					  </table>  
					</div>
				</div><!--/span-->

			</div>		

	</div><!--/.fluid-container-->
	
			<!-- end: Content -->
		</div><!--/#content.span10-->
		</div><!--/fluid-row-->
	
	<div class="clearfix"></div>
	
	<?php include("footer.php");?>