<?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");

if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	mysqli_query($con,"delete from book where id=".$doid);
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=view_book.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="EditBook";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from book where id=".$_REQUEST['upid']);
	  $upuserarr=mysqli_fetch_array($upuserresult);
}else{
 	  $dovalue="Book";
	  $doid='';
}
?>   

<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Add Book <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Add Book</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 <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" name="addcategory" id="addcategory" 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"];?>" />
               
                <div class="form-group">
                     <label>Book Name *</label>                 
                  <input name="book_name" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['book_name'];}?>" type="text" placeholder="Enter Book Name" class="form-control">
                </div>
                
                
                <div class="form-group">
                  <label>Isbn *</label>                 
                  <input name="isbn" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['isbn'];}?>" type="text" placeholder="Enter Isbn Number" class="form-control">
                </div>
               <div class="form-group">
                  <label>Author *</label>                 
                  <input name="author" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['author'];}?>" type="text" placeholder="Enter Author Name" class="form-control">
                </div>
               <div class="form-group">
                  <label>Publisher *</label>                 
                  <input name="publisher" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['publisher'];}?>" type="text" placeholder="Enter Publisher Name" class="form-control">
                </div>
               <div class="form-group">
                  <label>Year of Publication *</label>                 
                  <input name="publication_year" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['publication_year'];}?>" type="text" placeholder="Enter Year of Publication" class="form-control">
                </div>
                <div class="form-group">
                <label>Course :</label>
                    <select name="course_id" id="coursealert" class="form-control subject" required>
                          <option value=''>-select-</option>
                          <?php $CasteQuery=mysqli_query($con,"select * from course");
    	  				  while($CasteRow=mysqli_fetch_array($CasteQuery)){ 
                          echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['course_id'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['c_name'].'</option>';
    					   } ?>                  
                    </select>   
                </div>
                <div class="form-group">
                  <label>Class Type *</label>                 
                  <input name="class_type" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['class_type'];}?>" type="text" placeholder="Enter Type" class="form-control">
                </div>
                <div class="form-group">
                  <label>Accession Code *</label>                 
                  <input name="accession_code" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['accession_code'];}?>" type="text" placeholder="Enter Accession Code" class="form-control">
                </div>
               <div class="form-group">
                  <label>Edition *</label>                 
                  <input name="edition" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['edition'];}?>" type="text" placeholder="Enter Edition" class="form-control">
                </div>
               <div class="form-group">
                  <label>Book Code *</label>                 
                  <input name="book_code" id="age" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['book_code'];}?>" type="text" placeholder="Enter Book Code" class="form-control">
                </div>
                <!--
                <div class="form-group">
                  <label>Course *</label>
				
                 <select name="course" id="coursealert" class="form-control subject" required>
                      <option value="0">Select</option>
					  <?php /*$CourseQuery=mysqli_query($con,"select * from course");
	  				 while($CasteRow=mysqli_fetch_array($CourseQuery)){ 
                     echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['course_id'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['c_name'].'</option>';
					 } */?>
                                       
                  </select>    
                </div>-->
                
               <div class="form-group">
                  <label>Cost of Single Copy *</label>                 
                  <input name="cost" id="age" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['cost'];}?>" type="text" placeholder="Enter Cost" class="form-control">
                </div>
               <div class="form-group">
                  <label>Number of Copies *</label>                 
                  <input name="copies_number" id="age" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['copies_number'];}?>" type="text" placeholder="Enter Number of Copies" class="form-control">
                </div>
               <div class="form-group">
                  <label>Date of Entry *</label>                 
                  <input name="entry_date" id="dob" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['entry_date'];} else { echo date("Y-m-d"); }?>" type="date" placeholder="" required class="form-control">
                </div>
               <div class="form-group">
                  <label>Rack No *</label>                 
                  <input name="rack_no" id="rack_no" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['rack_no'];}?>" type="text" placeholder="Enter Rack Number" class="form-control">
                </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 -->
  </section><!-- /.content -->
</div>
<?php include('include/footer.php');?>