<!-- PHP START -->
<?php
  session_start();
  include('includes/connection.php');
  include('includes/checklogin.php');
  check_login(); 
  $userid = $_SESSION['loginid'];
?>
<!-- PHP END -->

<!-- HTML START -->
<!DOCTYPE html>
<html>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<?php include("includes/head.php"); ?>

<body class="hold-transition sidebar-mini">
  <div class="wrapper">
    <!-- Navbar -->
    <?php include("includes/nav.php"); ?>
    <!-- /.navbar -->

    <!-- Main Sidebar Container -->
    <?php include("includes/sidebar.php"); ?>

    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
      <!-- Content Header (Page header) -->
      <section class="content-header">
        <div class="container-fluid">
          <div class="row mb-2">
            <div class="col-sm-4">
              <h1>PriceList Reports </h1>
            </div>
            <div class="col-sm-2">
                
            </div>            
            <div class="col-sm-6">
              <ol class="breadcrumb float-sm-right">
                <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                <li class="breadcrumb-item"><a href="productrecord_registration_manage.php">PriceList Creation</a></li>
                <li class="breadcrumb-item active">Manage PriceList</li>
              </ol>
            </div>
          </div>
        </div><!-- /.container-fluid -->
      </section>

      <!-- Main content -->
      <section class="content">
        <div class="row">
          <div class="col-12">
            <div class="card">&nbsp;&nbsp;&nbsp;&nbsp;

    <form class="form" id="data" action="pricelist_report_end.php" method="post">

      <div class="row">&nbsp;&nbsp;&nbsp;&nbsp;
      <!-- START NAME -->
          <div class="col-md-5 form-group">
              <label for="productrecord_name">Name</label>  
              <select name="productrecord_name" id="productrecord_name" class="form-control">
                  <option>Select Name</option>&nbsp;&nbsp;&nbsp;&nbsp;
                  <?php 
                      $sqlsss = "SELECT productrecord_name FROM mst_product ORDER BY productrecord_name";
                      $result = $mysqli->query($sqlsss);
                      while($row = mysqli_fetch_array($result)) 
                      {
                  ?>
                  <option value="<?php echo $row['productrecord_name']; ?>"> <?php echo $row['productrecord_name'];?></option>
                  <?php  
                      }
                  ?>
              </select>
          </div>  
      <!-- END NAME -->

      <!-- START VALUE -->
          <div class="col-md-5 form-group">
              <label for="productrecord_value">Value</label>  
              <select name="productrecord_value" id="productrecord_value" class="form-control">
                  <option>Select Value</option>&nbsp;&nbsp;&nbsp;&nbsp;
                  <?php 
                      $sqlsss = "SELECT productrecord_value FROM mst_product ORDER BY productrecord_value";
                      $result = $mysqli->query($sqlsss);
                      while($row = mysqli_fetch_array($result)) 
                      {
                  ?>
                  <option value="<?php echo $row['productrecord_value']; ?>"> <?php echo $row['productrecord_value'];?></option>
                  <?php  
                      }
                  ?>
              </select>
          </div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <!-- END VALUE -->
 
      <!-- START SHOW BUTTON -->
              <a href="pricelist_report_end.php"><button type="show" class="btn btn-success" style="height:40px;" id="show" name="show">SHOW</button></a>  
      <!-- END SHOW BUTTON -->

    </div>
  </form>
  
  <div class="card-body">
    
</tfoot> 
 
      </div>
              <!-- /.card-body -->
            </div>

            <!-- /.card -->
          </div>
          <!-- /.col -->
        </div>
        <!-- /.row -->
      </section><br>
      <!-- /.content -->

    </div>
    <!-- /.content-wrapper -->

    <?php include("includes/footer.php"); ?>

    <!-- Control Sidebar -->
    <aside class="control-sidebar control-sidebar-dark">
      <!-- Control sidebar content goes here -->
    </aside>
    <!-- /.control-sidebar -->
  </div>
  <!-- ./wrapper -->

  <!-- jQuery -->
  <script src="plugins/jquery/jquery.min.js"></script>
  <!-- Bootstrap 4 -->
  <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
  <!-- DataTables -->
  <script src="plugins/datatables/jquery.dataTables.js"></script>
  <script src="plugins/datatables-bs4/js/dataTables.bootstrap4.js"></script>
  <!-- AdminLTE App -->
  <script src="dist/js/adminlte.min.js"></script>
  <!-- AdminLTE for demo purposes -->
  <script src="dist/js/demo.js"></script>

  <!-- PAGE SCRIPT START -->
  <script>
    $(function() 
    {
      $("#table1").DataTable();
      $('#table2').DataTable
      ({
        "paging": true,
        "lengthChange": false,
        "searching": false,
        "ordering": true,
        "info": true,
        "autoWidth": false,
      });
    });
  </script>
  <!-- PAGE SCRIPT END -->

</body>
</html>
<!-- HTML END -->