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; Invoice 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>Invoice Date</h5>
              </header>
              <div id="collapse2" class="body"> 
                <script type="text/javascript">
					function invoice_report_fn() 
					{ 
					window.open("invoicereport.php?fromto="+$('#reservation').val(),"myNewWinsr","width=1030,height=800,toolbar=0,menubar=no,status=no,resizable=yes,location=no,directories=no,scrollbars=yes"); 
					}
					</script>
                <form id="order_date" class="form-horizontal" method="get" action="">
                  <div class="row">
                    <div class="col-md-6">
                      <div class="form-group">
                        <label class="control-label col-lg-4" for="reservation">From - To</label>
                        <div class="col-lg-8">
                          <div class="input-group"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                            <input type="text" name="reservation" id="reservation" class="form-control">
                          </div>
                        </div>
                      </div>
                    </div>
                    <div class="col-md-3">
                      <div class="form-group">
                        <div class="col-md-12"> 
                          <input name="submit" type="submit" value="View" class="btn btn-success">
                          
                          <a href="invoice_report.php" class="btn btn-success">Clear</a>
                        </div>
                      </div>
                    </div>
                    <div class="col-md-3">&nbsp;</div>
                  </div>
                </form>
              </div>
            </div>
                  <div class="box">
                  <header class="dark">
                  <div class="icons"> <i class="fa fa-check"></i> </div>
                  <?php
				  $fromto = $_GET['reservation'];
						  
						  if($fromto != ""){
                
                          $explod = explode("-",$fromto);
              
                          $fromdate=$explod[0];
              
                          $sqldate = strtotime($fromdate);
              
                          $fromdatesql = date("Y-m-d",$sqldate);
              
                          $todate=$explod[1];
              
                          $sqldate1 = strtotime($todate);
              
                          $todatesql = date("Y-m-d",$sqldate1);
						  
						  $sel_order = mysqli_query($link,"select * from shopping_tbl where inv_no!='' and item_status !='Cancelled' and `inv_date` BETWEEN '$fromdatesql' AND '$todatesql' order by id desc");
						  
						  }
						  else
						  {
						  $sel_order = mysqli_query($link,"select * from shopping_tbl where inv_no!='' and item_status !='Cancelled'");    
						  }
				  ?>
                  <h5>Total Ordered Product And Quantity For <?php echo $fromdate; ?> to <?php echo $todate; ?></h5>
                  </header>
                    <div id="collapse4" class="body" style="overflow-x: scroll;">
                    	 <table id="datatable-responsive" class="table table-bordered table-condensed table-hover table-striped">
						  <thead>
							  <tr>
								  <th>S.NO</th>
                                  <th>Invoice No</th>
                                  <th>Invoice Date</th>
                                  <th>Order No</th>
                                  <th>Order Date</th>
                                  <th>Item Name</th>
                                  <th>Price Per Qty</th>
                                  <th>Qty</th>
                                  <th>GST Rate</th>
                                  <th>HSN Code</th>
                                  <th>CGST</th>
                                  <th>SGST</th>
                                  <th>IGST</th>
                                  <th>Gross Amount</th>
                                  <th>Discount</th>
                                  <th>Delivery Charge</th>
                                  <th>Total Bill Amount</th>
                                  <th>Name</th>
                                  <th>Mobile Number</th>
                                  <th>Email Id</th>
                                  <th>Delivery Address</th>
                                  <th>State</th>
                                  <th>Pincode</th>
							  </tr>
						  </thead>   
						  <tbody>
						  <?php 
                          $sno=1;
						  while($rw_order = mysqli_fetch_object($sel_order)){
							    $pid = $rw_order->product_id;
							    list($tax,$hsn_code) = mysqli_fetch_row(mysqli_query($link,"select `tax`,`hsn_code` from product_tbl where product_id='$pid'"));
							    $cust = $rw_order->customer_details;
                                $cus = explode(",",$cust);
                                $name = $cus[0];
                                $mobile = $cus[1];
                                $email = $cus[2]; 
                                $state = $rw_order->state;
                                $price = $rw_order->price;
                                $qty = $rw_order->quantity;
                                $line_total = $price * $qty;
                                $tax_amount1 = round($price - ($price*(100/(100+$tax))),2);
                                $tax_amount = round($line_total - ($line_total*(100/(100+$tax))),2);
                                if($state == "Tamil Nadu"){
                                $cgst = $tax_amount/2;
                                $sgst = $tax_amount/2;
                                $igst = 0;
                                }
                                else
                                {
                                $cgst = 0;
                                $sgst = 0;
                                $igst = $tax_amount;    
                                }
                                $price_withouttax = $price - $tax_amount1;
							?>
                             
                          	<tr>
							<td><?php echo $sno;?></td>
                            <td><?php echo $rw_order->inv_no; ?></td>
                            <td><?php echo $rw_order->inv_date; ?></td>
                            <td><?php echo $rw_order->order_id; ?></td>
                            <td><?php echo $rw_order->order_date; ?></td>
                            <td><?php echo $rw_order->product_name; ?></td>
                            <td><?php echo $price_withouttax; ?></td>
                            <td><?php echo $rw_order->quantity; ?></td>
                            <td><?php echo $tax; ?> %</td>
                            <td><?php echo $hsn_code; ?></td>
                            <td><?php echo $cgst; ?></td>
                            <td><?php echo $sgst; ?></td>
                            <td><?php echo $igst; ?></td>
                            <td><?php echo $line_total; ?></td>
                            <td><?php echo $rw_order->discount; ?></td>
                            <td><?php echo $rw_order->delivery_charge; ?></td>
                            <td><?php echo $rw_order->grand_total; ?></td>
                            <td><?php echo $name; ?></td>
                            <td><?php echo $mobile; ?></td>
                            <td><?php echo $email; ?></td>
                            <td><?php echo $rw_order->delivery_details; ?></td>
                            <td><?php echo $rw_order->state; ?></td>
                            <td><?php echo $rw_order->pincode; ?></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';?>