bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php

error_reporting (0);

include "dbc.php";

page_protect();
?>
<?php include'header.php';?>
      <div class="main-bar">
        <h3><i class="fa fa-archive"></i>&nbsp; Stock Report</h3>
      </div>
       
    </header>
     
  </div>
  
  <?php include'admin_admin.php';?>
  
  <div id="content">
    <div class="outer">
      <div class="inner bg-light lter">
        <style>
              .form-control.col-lg-6 {
                width: 50% !important;
              }
            </style>
              <div class="row">
                <div class="col-lg-12">
                <div class="box">
                  <header class="dark">
                  <div class="icons"> <i class="fa fa-check"></i> </div>
                  
                  <h5>Stock Report On <?php echo date('d-m-Y'); ?></h5>
                  </header>
                    <div id="collapse4" class="body">
                    	 <table id="datatable-responsive" class="table table-bordered table-condensed table-hover table-striped">
						  <thead>
							  <tr>
								  <th>S.NO</th>
                                  <th>Product Details</th>
                                  <th>Purchase Qty</th>
                                  <th>Sales Qty</th>
                                  <th>Available Qty</th>
							  </tr>
						  </thead>   
						  <tbody>
						  <?php 
                          $sno=1;
						  $sel_order = mysqli_query($link,"select * from product_tbl");
                          while($rw_order = mysqli_fetch_object($sel_order)){
							  $pid = $rw_order->product_id;
							  $id = $rw_order->id;
							?>
                           
                          	<tr>
								<td><?php echo $sno;?></td>
                                <td>
								<?php echo $rw_order->product_name; ?>, <?php echo $rw_order->product_name_en; ?> (<?php echo $pid; ?>), <?php echo $rw_order->size; ?>
                                </td>
                                <td>
                                  <?php
                                  list($purchase_qty) = mysqli_fetch_row(mysqli_query($link,"select sum(quantity) from purchasedetails_tbl where product_id='$pid'"));
                                  if($purchase_qty == ""){ $purchase_qty = 0; }
                                  echo $purchase_qty;
                                  ?>
                                </td>
                                <td>
                                  <?php
                                  list($sales_qty) = mysqli_fetch_row(mysqli_query($link,"select sum(quantity) from shopping_tbl where product_id='$id' and item_status !='Cancelled' and order_status='Complete'"));
                                  if($sales_qty == ""){ $sales_qty = 0; }
                                  echo $sales_qty;
                                  ?>
                                </td>
                                <td>
                                <?php echo $quantity = $purchase_qty - $sales_qty; ?>
                                </td>
                            </tr>
							<?php $sno++; } ?>
                         </tbody>
					  </table> 
                                
					</div>
				</div>
			
			</div>

</div>
	
			
		</div>
		</div>
		
	<div class="modal hide fade" id="myModal">
		<div class="modal-header">
			<button type="button" class="close" data-dismiss="modal">×</button>
			<h3>Settings</h3>
		</div>
		<div class="modal-body">
			<p>Here settings can be configured...</p>
		</div>
		<div class="modal-footer">
			<a href="#" class="btn" data-dismiss="modal">Close</a>
			<a href="#" class="btn btn-primary">Save changes</a>
		</div>
	</div>	
                    
            </div>   
            </div>
                
                
                
                
                
                
                
              </div>
            </div>
            
            
          </div>
        </div>
      </div>
      <div id="right" class="bg-light lter">
        <div class="alert alert-danger">
          <button type="button" class="close" data-dismiss="alert">&times;</button>
          <strong>Warning!</strong>  Best check yo self, you're not looking too good.
        </div>

<div class="well well-small dark">
          <ul class="list-unstyled">
            <li>Visitor <span class="inlinesparkline pull-right">1,4,4,7,5,9,10</span> 
            </li>
            <li>Online Visitor <span class="dynamicsparkline pull-right">Loading..</span> 
            </li>
            <li>Popularity <span class="dynamicbar pull-right">Loading..</span> 
            </li>
            <li>New Users <span class="inlinebar pull-right">1,3,4,5,3,5</span> 
            </li>
          </ul>
        </div>

<div class="well well-small dark">
          <button class="btn btn-block">Default</button>
          <button class="btn btn-primary btn-block">Primary</button>
          <button class="btn btn-info btn-block">Info</button>
          <button class="btn btn-success btn-block">Success</button>
          <button class="btn btn-danger btn-block">Danger</button>
          <button class="btn btn-warning btn-block">Warning</button>
          <button class="btn btn-inverse btn-block">Inverse</button>
          <button class="btn btn-metis-1 btn-block">btn-metis-1</button>
          <button class="btn btn-metis-2 btn-block">btn-metis-2</button>
          <button class="btn btn-metis-3 btn-block">btn-metis-3</button>
          <button class="btn btn-metis-4 btn-block">btn-metis-4</button>
          <button class="btn btn-metis-5 btn-block">btn-metis-5</button>
          <button class="btn btn-metis-6 btn-block">btn-metis-6</button>
        </div>

<div class="well well-small dark">
          <span>Default</span> <span class="pull-right"><small>20%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-info" style="width: 20%"></div>
          </div>
          <span>Success</span> <span class="pull-right"><small>40%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-success" style="width: 40%"></div>
          </div>
          <span>warning</span> <span class="pull-right"><small>60%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-warning" style="width: 60%"></div>
          </div>
          <span>Danger</span> <span class="pull-right"><small>80%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-danger" style="width: 80%"></div>
          </div>
        </div>
      </div>
    </div>
    <?php include'footer.php';?>