<?php include("sass/icon_for_datepicker_and_datatable.php");?>
        <div class="wrapper row-offcanvas row-offcanvas-left">
            <!-- Left side column. contains the logo and sidebar -->
            <?php include("sass/sidebar.php");?>

            <!-- Right side column. Contains the navbar and content of the page -->
               <aside class="right-side">
                <!-- Content Header (Page header) -->
                <section class="content-header">
                    <h1>
                       <?php echo $company_name ; ?>
                        <small>Control panel</small>
                    </h1>
                    <ol class="breadcrumb">
                        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
                        <li class="active">Dashboard</li>
                    </ol>
                </section>
                 <section class="content">
                 	 <div class="row">
                        <div class="col-md-6">
                 <!---Main Content--->
                  <table class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                               <th>Product Name</th>
                                               <th>Quantity</th>
                                                <th>Buying Price In Dollar</th>
                                                <th>Selling Price In Dollar</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                 			<?php 
				$lc_number =$_REQUEST['lc_number'];
				
				 $query = "SELECT * FROM lc WHERE lc_number = '$lc_number'";
														
                                                $result = mysqli_query($connection,$query);
                                               
                                                while($row=mysqli_fetch_array($result))
                                                {
                                                
                                                $lc_id = $row['lc_id'];
												$product_id = $row['product_id'];
												$quantity = $row['quantity'];
												$buying_price = $row['buying_price'];
												$selling_price = $row['selling_price'];
										
						$result_for_product = mysqli_query($connection,"SELECT product_name, unit_type_id FROM product_setup WHERE product_id  = '$product_id'");
		$test_for_product = mysqli_fetch_array($result_for_product);
				
				$product_name=$test_for_product['product_name'];
				$unit_type_id=$test_for_product['unit_type_id'];
		
				
				$result_for_unit_type = mysqli_query($connection,"SELECT * FROM unit_type WHERE unit_type_id  = '$unit_type_id'");
		$test_for_unit_type = mysqli_fetch_array($result_for_unit_type);
				
				$unit_type_name=$test_for_unit_type['unit_type_name'];
				
												
												echo "
												<tr>
												<td>$product_name</td>
												<td>$quantity $unit_type_name</td>
												<td>$buying_price</td>
												<td>$selling_price</td>
												</tr>
												";
												
												
												}
				
				
				?>
                 
                                        </tbody>
										</table>
                 		</div>
                    </div>
                 
                 
                 </section>
                </aside>
                <!-- /.right-side -->
        </div><!-- ./wrapper -->

        <!-- add new calendar event modal -->


        <!-- jQuery 2.0.2 -->
         <?php include("sass/footer_for_datepicker_and_datatable.php");?>

    </body>
</html>