<?php
	include "admin_top_menu.php";
	include "admin_side_menu.php";
?>
  
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        Product
        <small>Product Report</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">Product</li>
      </ol>
    </section>

    <!-- Main content -->
    <section class="content">
	<form name="frmlist" method="post">
      
        <div class="box box-info">
            <div class="box-header">
              <h3 class="box-title">Log Report</h3>
            </div>
            <!-- /.box-header -->
            <div class="box-body">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                  <th>Sr. No</th> 
                  <th>Product Id</th>
                  <th>Product Details</th>  
                  <th>Customer Details</th>
                  <th>Status</th>	
                  <th>Date</th> 
                  <th>Notes</th> 
				  <th>Delete</th> 
                </tr>
                </thead>
                <tbody>
                  <?php 
					$qry=mysqli_query($conn,"SELECT * FROM track_sample t, customer c, swatch s where t.cus_id=c.cus_id and t.sw_id=s.sid")or die(mysqli_error($conn));
					$count=1;
					while($row=mysqli_fetch_array($qry)){
				?>
					<tr>
					<td><?php echo $count++;?></td>
					<td><?php echo $row['snumber'];?></td>
					<td><?php echo $row['sname'].", ".$row['scolor'].", ".$row['sfabric'];?></td>
					<td><?php echo $row['com_name'].", ".$row['cus_name'].", ".$row['cus_contact'].", ".$row['cus_email'];?></td>
					<td><?php echo $row['status'];?></td>
					<td><?php echo $row['date'];?></td>
					<td><?php echo $row['note'];?></td>
					<td><?php echo "<a href='delete_code.php?dr_id=".$row['ts_id']."' onClick=\"javascript:return confirm('are you sure you want to delete this?');\"><i class='fa fa-times fa-fw'></i></a>"; ?></td>
					</tr>              
             <?php  } ?>
                </tbody>
              </table>
            </div>
            <!-- /.box-body -->
          </div>
          <!-- /.box -->
	</form>
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->


<?php
	include "admin_footer.php";
?>

  
  