<?php 
include ("include/makeSession.php");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
$installment_id=mysqli_fetch_array($installment_id); 
$installment_id=$installment_id['menuper'];
$menuper=explode(',',$installment_id);
	   
if(in_array('Manage Library',$menuper)){
  
}else{
	header("location:index.php");
}
$_SESSION['page_name']="Library";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
$book_id=$_REQUEST['book_id'];
if(!empty($_REQUEST['did'])){
    $did=$_REQUEST['did'];
    $d=mysqli_query($con,"delete from book_copies where id=$did");
    if($d){
        $_SESSION['msg']="Book Copy Deleted";
        mysqli_query($con,"update book set copies_number=copiesnumber-1 where id='".$_REQUEST['did']."'");
    }else{
        $_SESSION['msg']="Book Copy Delete Operation Failed";
    }
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=book_copies_manage.php?book_id='.$_REQUEST['book_id'].'">';
	exit;
}
if(!empty($_REQUEST['upid'])){
    $dovalue="EditBookCopies";
    $doid=$_REQUEST['upid'];    
    $Row=mysqli_fetch_array(mysqli_query($con,"select * from book_copies where id=$doid"));
}else{
    $dovalue="BookCopiesManage";
    $doid="";
}
$copies_number=mysqli_fetch_array(mysqli_query($con,"select copies_number from book where id=$book_id"))['copies_number'];
?>   

<div class="content-wrapper">
  <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1> Add Book Copy Details <small></small> </h1>
        <ol class="breadcrumb">
            <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
            <li><a href="#">Add Book Copy Details</a></li>
        </ol> 
    </section>
    <!-- Main content -->
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                <div class="box box-info">
                    <div class="box-header">
                        <h3 class="box-title"> Add Book Copy Details <small></small></h3>
                        <!-- tools box -->
                        <div class="pull-right box-tools">
                            <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
                            <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
                        </div><!-- /. tools -->
                    </div><!-- /.box-header -->
                    <div class="box-body pad">
                        <div class="col-md-8">
                            <form method="post" action="action_library.php"  enctype="multipart/form-data"  role="form">
                                <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                                <input type="hidden"  name="doid" value="<?php echo $doid;?>" />
                                <input type="hidden"  name="user_id" value="<?php echo $_SESSION["ecomid"];?>" />
                                <input type="hidden"  name="book_id" value="<?php echo $book_id;?>" /> 
                                <div class="form-group">
                                    <label>Accession Code *</label>                 
                                    <input name="accession_code"  type="text" placeholder="Enter Accession Code" class="form-control" value="<?php if(!empty($_REQUEST['upid'])){ echo $Row['accession_code'];} ?>" required>
                                </div>   
                                <div class="row">                                                            
                                    <div class="col-md-6">
                                    <div class="form-group">
                                        <input type="submit" id="submit" class="btn btn-primary" value="Save"/>
                                        <input type="reset" value="Reset" class="btn btn-primary"/>           
                                    </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div><!-- /.box -->
            </div><!-- /.col-->
        </div><!-- ./row -->
        <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">View Book Copies :</h3>
          </div><!-- /.box-header -->
          <div class="box-body table-responsive" >
            <table id="example1" class="table table-bordered table-striped">
			  <?php if(!empty($_SESSION['msg'])){
			  $msg=$_SESSION["msg"];
           echo '<div class="col-md-8">
			<div class="alert alert-success alert-dismissible">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  '.$msg.'
		  </div>'; $_SESSION["msg"]='';} ?>
              <thead>
                <tr>
                    <th>#ID</th>
                    <th scope="col">Distributed To</th>
                    <th scope="col">Accession Code</th>
                    <th scope="col">Barcode</th>
    				<th scope="col">Action</th>
                </tr>
              </thead>
              <tbody>
              <?php $q=mysqli_query($con,"select * from book_copies where book_id='$book_id'");
			  		$i = 1;	
	  				  while($r=mysqli_fetch_array($q)){ ?>
                    <tr>
                        <td><?=$i;?></td>
                        <td><?=$r['student_id'];?></td>
                        <td><span id=""><?=$r['accession_code'];?></span></td>
                        <td>
                        <?php
                         $text=$r['accession_code'];
                          echo "<img alt='testing' src='barcode/barcode.php?codetype=Code39&size=40&text=".$text."&print=true'/>";
                        ?>
                        
                        </td>
					  <td><a href="./book_copies_manage.php?upid=<?php echo $r["id"]; ?>&book_id=<?php echo $r["book_id"]; ?>"><i class="fa fa-pencil text-yellow"></i></a>&nbsp;&nbsp; 
					  <a href="./book_copies_manage.php?did=<?php echo $r["id"]; ?>&book_id=<?php echo $r["book_id"]; ?>" onclick="return confirm_click();"><i class="fa fa-remove text-red"></i></a></td>
                    </tr>                
                <?php $i++;} ?>                    
              </tbody>
            </table>
          </div><!-- /.box-body -->
        </div><!-- /.box -->
      </div><!-- /.col -->
    </div><!-- /.row -->
  </section><!-- /.content -->
</div>
<?php include('include/footer.php');?>