<?php
  //invoice.php  
  include('db_con.php');
  
  include('function.php');
  
  if (isset($_SESSION['user_id'])) {
    $user_type = $_SESSION['user_type'];
    $user_id = $_SESSION['user_id'];
    $user_name = $_SESSION['user_name'];
    $branch_id = $_SESSION['branch_id'];
    $branch_name = $_SESSION['branch_name'];
    $store_id = $_SESSION['store_id'];
    $store_name = $_SESSION['store_name'];
}else{
  header('Location: login');
  die();
}
$sql = "SELECT IFNULL(doc_status,'ON') FROM user_rights WHERE user_id = '".$user_id."' and doc_name = 'Inventory_reports_item_ledger'";
            $statement = $connect->prepare($sql);
            $statement->execute(); // no need to add `$sql` here, you can take that out
            $Inventory_reports_item_ledger = $statement->fetchColumn();
            if($Inventory_reports_item_ledger=='OFF'){header('Location: dashboard');}
$dated = date('Y-m-d');
  if(isset($_POST["print"]))
  {
   
   
   
    $to_store = $_POST['to_store'];
    $from_store = $_POST['from_store'];
    $item_status = $_POST['item_status'];
  
      
      //$result = $statement->fetchAll();
      header('location:rpt_do_preview?print=1&to_store='.$to_store.'&from_store='.$from_store.'&item_status='.$item_status.'');
  }
           
  ?>
<!DOCTYPE html>
<html>
<head>
  <?php include('include/head.php'); ?>
  
</head>
<body>
  <?php include('include/header.php'); ?>
  <?php include('include/sidebar.php'); ?>
   <?php include('include/script.php'); ?>
<div class="main-container">
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark"></h1>
          </div><!-- /.col -->
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item active">Inventory</li>
              <li class="breadcrumb-item active">Reports </li>
              <li class="breadcrumb-item active">Store Transfer Status</li>
            </ol>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
    </div>
    <!-- /.content-header -->
    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <!-- Small boxes (Stat box) -->
     <span id="alert_action"></span>
    <div class="row">
        <div class="col-12">
          <div class="card">
            <div class="card-header">
            <div class="row">
                          <div class="col-lg-10 col-md-10 col-sm-8 col-xs-6">
                              <h3 class="panel-title">Inventory Report</h3>
                            </div>
                            
                        </div>
            </div>
            <!-- /.card-header -->
            <div class="card-body">
       <form method="post" id="report_form">
      <br />
      
        <div class="table-responsive">
          <table class="table table-bordered">
            <tr>
              <td colspan="2" align="center"><h2 style="margin-top:10.5px">Store Item Status</h2></td>
            </tr>
            <tr>
                <td colspan="2">
                  <div class="row">
                    <div class="col-md-6">

                       <b>From Store :</b>
                     <select name="from_store" id="from_store" class="form-control input-sm from_store" required />                 
                       
                         <?php echo fill_store($connect);?>
                        </select>
                        <br />
                 
                  
                    <b>To Store :</b>
                     <select name="to_store" id="to_store" class="form-control input-sm to_store" required />
                   
                       
                         <?php echo fill_store($connect);?>
                        </select>
                  
                      <br />
                          
                 
                   
                       
                  <b>Status :</b>
                     <select name="item_status" id="item_status" class="form-control input-sm item_status" />                 
                     <option value="">ALL</option>
                       <option value="Not Approved">Not Approved</option>
                       <option value="Approved">Approved</option>
                        </select>
                  
                    
                          
                      <br />
                    
                     
                      
                                  
                
                    </div>
                    
                  </div>
                  
                 
                  </td>
                  </tr>
                
          
            
              <tr>
                <td colspan="2" align="center">
                <input type="submit" name="print" id="print" class="btn btn-info" value="Preview" />
                 
                 
                </td>
              </tr>
          </table>
        </div>
      </form>
         </div>
              </div>
          </div>
      </div>
        
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
 
  <!-- /.content-wrapper -->
  
  <script src="js/jquery-ui.js"></script>
  <script src="js/jquery-ui.min.js"></script>
    </div>
    </div>
 
  
</body>
</html>