<?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('Master Setting',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
	
		   
		}
$_SESSION['page_name']="Stock";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
?>

		<script src="plugins/jQuery/jQuery-2.1.4.min.js"  type="text/javascript"></script>
	
<div class="content-wrapper">
  <section class="content-header">
    <h1> Stock Reports</h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Stock Reports</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            
          </div><!-- /.box-header -->
          <div class="box-body"  style="overflow-x: scroll;">
		
		 <form action="" method="GET" style="margin-bottom:50px;" >
			<div class="col-md-12">	
			
			<div class="col-md-6">
			   	<input type="date" name="from" placeholder="dd/mm/yyyy"
value="<?php if(!empty($_GET['from'])){ echo $_GET['from']; }else{ } ?>"
				class="form-control col-md-3" style="width:210px;float:right;margin-right:103px;" /> <b>Stock Report From  :</b> 
				</div>
		<div class="col-md-6">	<b>To:</b>	<input type="date" name="to" placeholder="dd/mm/yyyy"
value="<?php if(!empty($_GET['to'])){ echo $_GET['to']; }else{ } ?>"
				class="form-control col-md-3" style="width:210px;float:right;margin-right:203px;" />
				</div>
				</div>
				<div class="col-md-12">	
            		<div class="col-md-4">  
            		<select name="category" id="coursealert" class="form-control subject "  style="width:130px;float:right;margin-right:0px;">
                      <option value=''>-select-</option>
                      <?php $partycategory=mysqli_query($con,"select * from stockcategry");
	  				  while($CasteRow=mysqli_fetch_array($partycategory)){ 
                      echo '<option value="'.$CasteRow['id'].'" '.($_GET['category'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['name'].'</option>';
					   } ?>                  
                  </select>	<b>Category Wise:</b>	
				</div>
				</div>
				<input type="submit" name="s" value="Search" class="btn btn-success"/>
				<button type="reset" value="Reset" class="btn  btn-primary">Reset</button>
					
				</form>
			  
	
		 		<?php 
				
			
				$mobile=$_GET['s'];
				  ?>
				
			
				
            <table id="example1" class="table table-bordered table-striped">
			
              <thead>
                <tr>
               
			    <th>Sr No</th>
                <th>Name</th>
                <th scope="col">Stock Head</th>
                <th scope="col">Stock Category</th>
                <th scope="col">Price Per Quantity</th>
                <th scope="col">Quantity</th>
                <th scope="col">Total amount</th>
			    <th scope="col">Created</th> 
			    <th scope="col">Entry User</th>
			  
			   
                </tr>
              </thead>
              <tbody>

              <?php 
			 
			 
$from =$_GET['from'];
$to =$_GET['to'];
$category_q="";
if(!empty($_GET["category"])){
	$category_q.=" AND stockadd.category='".$_GET['category']."'";
}
if(!empty($_GET["from"])){
	$category_q.=" AND stockadd.created_at >='$from 00:00:00'";
}
if(!empty($_GET["to"])){
	$category_q.=" AND stock.created_at <='$to 00:00:00'";
}
  
//26.10.1996
    		$Query=mysqli_query($con,"
				select stockadd.id,stockcategry.name as category_name,stockadd.name as name, stockhead.name as head_name,
				stockadd.purchase_date,admin.name as entryuser,stockadd.price,stockadd.quantity,stockadd.amount
				from stockadd
				left join admin on admin.id=stockadd.user_id
				left join stockcategry on stockcategry.id=stockadd.category
				left join stockhead on stockhead.id=stockadd.subcategory
				where 1=1
				$category_q
			 ");
			  
	  		$i = 1;
	  				  while($Row=mysqli_fetch_array($Query)){ 
					  ?>
                    <tr>
					
                     <td><?=$i;?></td>
                      <td><?=$Row['name'];?></td>
                      <td><?=$Row['head_name'];?></td>
                      <td><?=$Row['category_name'];?></td>
                      <td><?=$Row['price'];?></td>
                      <td><?=$Row['quantity'];?></td>
                      <td><?=$Row['amount'];?></td>
                      <td><?=$Row['purchase_date'];?></td>
                      <td><?=$Row['entryuser'];?></td> 
			</tr>
			
						  <?php $i++;}  ?>		  
              </tbody>
                  
            </table>
          </div><!-- /.box-body -->
        </div><!-- /.box -->
      </div><!-- /.col -->
    </div><!-- /.row -->
  </section><!-- /.content -->
</div><!-- /.content-wrapper -->
<!-- footer start -->
<?php
include('include/footer.php');
?>
<!-- footer end -->
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/dataTables.buttons.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/jszip.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/pdfmake.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/buttons.colVis.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js"  type="text/javascript"></script>

<script  type="text/javascript">
$(document).ready(function() {
    $('#example1').DataTable( {
        dom: 'Bfrtip',
        columnDefs: [
            {
                targets: 1,
                className: 'noVis'
            }
        ],
        buttons: [
            {
                extend: 'colvis',
                columns: ':not(.noVis)'
            }
        ],
		 buttons: [
		  { extend: 'colvis', text: 'COLOUMNS' },
		 { extend: 'csv', text: 'Export to CSV' },
		 { extend: 'excel', text: 'Export to Excel' },
           { extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
        ],
		
    } );
    
    $('#example2').DataTable( {
        dom: 'Bfrtip',
        columnDefs: [
            {
                targets: 1,
                className: 'noVis'
            }
        ],
        buttons: [
            {
                extend: 'colvis',
                columns: ':not(.noVis)'
            }
        ],
		 buttons: [
		  { extend: 'colvis', text: 'COLOUMNS' },
		 { extend: 'csv', text: 'Export to CSV' },
		 { extend: 'excel', text: 'Export to Excel' },
           { extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
        ],
		
    } );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>