halohalo

<?php session_start(); include "dbc.php"; $free = "disable"; $default_currency = "inr"; $company_name = "Aram Iyarkai"; $company_logo = "images/logo1.png"; $company_address = "5/129 A Type 65th Street, Sidco Nagar,Villivakkam, Chennai 600 049."; $company_mobileno = "9600836644"; $company_emailid = "aramiyarkai369@gmail.com"; $company_url = "https://aramiyarkai.com/"; $company_details = $company_address.", Mobile No: ".$company_mobileno.".<br> Email Id: ".$company_emailid.", ".$company_regno; ?> <!doctype html> <html lang="en"> <head> <title><?php echo $company_name; ?></title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"> <meta name="description" content="<?php echo $company_name; ?> Invoice"> <meta name="author" content="<?php echo $company_name; ?> Invoice"> <link rel="shortcut icon" href="images/faviicon.ico"> <link rel="stylesheet" href="css/bootstrap.min.css" type="text/css" media='screen,print'> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css"> <link href='css/font-awesome.min.css' rel='stylesheet' type='text/css' /> <style> .fa-aud:before { content: "AU$"; } .col-md-6{ padding:0px; } .table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th, .table>thead>tr>td, .table>thead>tr>th{ padding: 2px; } </style> </head> <body> <div class="container"> <div style=""> <center> <img src="<?php echo $company_logo; ?>" class="img-responsive" style="width:100px;"> </center> <center><?php echo $company_details; ?></center> <center><?php echo $company_url; ?></center> </div> <hr> <div class="row"> <div class="col-xs-12 col-md-12"> <div class="col-xs-6 col-md-6"> <table class="table table-bordered"> <thead> <tr> <th>Billing / Delivery Address</th> </tr> </thead> <tbody> <?php $ggetorder_id = $_GET['order_id']; $sel_order = mysqli_query($link,"select * from shopping_tbl where order_id='$ggetorder_id'"); $rw_details = mysqli_fetch_object($sel_order); $product_id = $rw_details->product_id; $order_id = $rw_details->order_id; $cust = $rw_details->customer_details; $cus = explode(",",$cust); $name = $cus[0]; $mobile = $cus[1]; $email = $cus[2]; $state = $rw_details->state; ?> <tr> <td><?php echo $name;?></td> </tr> <tr> <td><?php echo $rw_details->delivery_details; ?></td> </tr> <tr> <td><?php echo $mobile;?></td> </tr> <tr> <td><?php echo $email;?></td> </tr> </tbody> </table> </div> <div class="col-xs-6 col-md-6"> <table class="table table-bordered"> <thead> <tr> <th>Invoice Details</th> </tr> </thead> <tbody> <tr> <td>Invoice No : <?php echo $rw_details->inv_no;?></td> </tr> <tr> <td>Invoice Date :<?php echo $dateinvoice = date("d/m/Y", strtotime($rw_details->inv_date)); ?></td> </tr> <tr> <td>Order No : <?php echo $rw_details->order_id;?></td> </tr> <tr> <td>Order Date :<?php echo $dateinvoice = date("d/m/Y", strtotime($rw_details->order_date)); ?></td> </tr> <?php /*<tr> <td>Order Status : <?php echo $rw_details->order_status;?></td> </tr>*/ ?> </tbody> </table> </div> </div> </div> <div class="row"> <div class="col-xs-12 col-md-12"> <table class="table table-bordered"> <thead> <tr> <th>#</th> <th>Item</th> <th align="center" style="text-align:center;">Price</th> <th align="center" style="text-align:center;">Quantity</th> <?php if($state == "Tamil Nadu"){ ?> <th align="center" style="text-align:center;">CGST</th> <th align="center" style="text-align:center;">SGST</th> <?php } else { ?> <th align="center" style="text-align:center;">IGST</th> <?php } ?> <th align="center" style="text-align:center;">Total</th> </tr> </thead> <tbody> <?php $sel_order1 = mysqli_query($link,"select * from shopping_tbl where order_id='$ggetorder_id' and item_status!='Cancelled'"); $sno=1; while($rw_details1 = mysqli_fetch_object($sel_order1)){ $proid = $rw_details1->product_id; $price = $rw_details1->price; $qty = $rw_details1->quantity; $line_total = $price * $qty; $sel_product = mysqli_query($link,"select * from product_tbl where product_id='$proid'"); $rw_product = mysqli_fetch_object($sel_product); //$mrp = $rw_product->mrp_price; $tax = $rw_product->tax; $tax_amount1 = round($price - ($price*(100/(100+$tax))),2); $tax_amount = round($line_total - ($line_total*(100/(100+$tax))),2); $cgst = $tax_amount/2; $sgst = $tax_amount/2; $price_withouttax = $price - $tax_amount1; //$other_tax = $rw_product->other_tax; //$tax_amount = round(($price * $tax)/(100+$tax),2); //$tax_amount = (($price * $tax) / 100); //$tax_amount = $price / (1 + ($tax / 100)); $tax_array[] = $tax_amount; $sub_total[] = $price_withouttax * $qty; //$other_taxamount = round(((($price * 65) / 100) * $other_tax)/100,2); //$other_taxamount = $price / (1 + ($other_tax / 100)); //$tax1_array[] = $other_taxamount; //$act_price = $price - $tax_amount - $other_taxamount; //$savings = ($mrp - $price)*$qty; //$savings_array[] = $savings; ?> <tr> <th scope="row"><?php echo $sno;?></th> <td><?php echo $rw_details1->product_name;?> / <?php echo $rw_details1->product_name_en;?></td> <td align="center"><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo $price_withouttax;?></td> <td align="center"><?php echo $rw_details1->quantity;?></td> <?php if($state == "Tamil Nadu"){ ?> <td align="center"><?php echo $cgst;?></td> <td align="center"><?php echo $sgst;?></td> <?php } else { ?> <td align="center"><?php echo $tax_amount;?></td> <?php } ?> <td align="center"><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo $rw_details1->line_total;?></td> </tr> <?php $sno++;} ?> <?php if($rw_details->sno > 21 && $rw_details->sno < 46){ ?> <tr> <td colspan="4" align="center">Free Items</td> </tr> <tr> <td><?php echo $sno;?></td> <td>சர்க்கரை - 1Kg / Brown Sugar - 1Kg</td> <td align="center"><i class="fa fa-<?php echo $default_currency; ?>"></i> 0</td> <td align="center">1.00</td> <td align="center"><i class="fa fa-<?php echo $default_currency; ?>"></i> 0.00</td> </tr> <?php } ?> </tbody> </table> </div> </div> <div class="row"> <div class="col-xs-4 col-md-4"> <?php /*<table class="table table-bordered"> <tbody> <tr> <th scope="row">Vat Tax</th> <td><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo array_sum($tax_array); ?></td> </tr> <tr> <th scope="row">Excise Duty</th> <td><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo array_sum($tax1_array); ?></td> </tr> </tbody> </table>*/ ?> </div> <div class="col-xs-4 col-md-4"> </div> <div class="col-xs-4 col-md-4"> <table class="table table-bordered"> <tbody> <tr> <th scope="row">Sub Total</th> <td><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo array_sum($sub_total); ?></td> </tr> <tr> <th scope="row">GST</th> <td><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo array_sum($tax_array); ?></td> </tr> <tr> <th scope="row">Discount</th> <td><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo $rw_details->discount; ?></td> </tr> <tr> <th scope="row">Delivery</th> <td><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo $rw_details->delivery_charge; ?></td> </tr> <tr> <th scope="row">Grand Total</th> <td><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo $rw_details->grand_total; ?></td> </tr> </tbody> </table> </div> <div class="col-xs-12 col-md-12"> <center> <h3>Thank you for your support!</h3> </center> </div> </div> <br><br> <center id="printarea"> <a href="dashboard.php" class="btn btn-success"><i class="fa fa-check"> </i> Proceed</a> <button name="print" type="button" value="Print" id="printButton" onClick="printpage()" class="btn btn-danger" > <i class="fa fa-print"> </i> Print Invoice</button> </center> <br><br> <script type="text/javascript"> function printpage() { document.getElementById('printarea').style.visibility="hidden"; window.print(); document.getElementById('printarea').style.visibility="visible"; } </script> </div> <script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/bootstrap.min.js"></script> </body> </html>