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 = "9952941814"; $company_emailid = "aramiyarkai369@gmail.com"; $company_url = "https://www.aramiyarkai.com/"; //$company_details = $company_address.", Mobile No: ".$company_mobileno.".<br> Email Id: ".$company_emailid.", ".$company_regno; $company_details = $company_address.", Mobile No: ".$company_mobileno.".<br> Email Id: ".$company_emailid; ?> <!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; } @media print { body * { visibility: hidden; } #print-wrapper * { visibility: visible; } .my-table { width: 100%; height: 100%; table-layout: fixed !important; } } </style> </head> <body> <div class="container" id="print-wrapper"> <div style=""> <center> <img src="<?php echo $company_logo; ?>" class="img-responsive" style="width:200px;"> </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-12 col-md-12"> <table class="my-table" style="width:100%!important;"> <thead> <tr style="width:100%;"> <th style="width:40%;">Billing / Delivery Address</th> <th style="width:30%;"></th> <th style="width:40%;">Invoice Details</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; $district = $rw_details->district; $pincode = $rw_details->pincode; $address = $rw_details->delivery_details; $del_address = $address."<br>".$district.", ".$state.", ".$pincode; ?> <tr style="width:100%;"> <td style="width:40%;"><?php echo $name;?></td> <td style="width:30%;"></td> <td style="width:40%;">Invoice No : <?php echo $rw_details->inv_no;?> &nbsp;</td> </tr> <tr> <td style="width:40%;"><?php echo $del_address; ?></td> <td style="width:30%;"></td> <td style="width:40%;">Invoice Date :<?php echo $dateinvoice = date("d/m/Y", strtotime($rw_details->inv_date)); ?> &nbsp;</td> </tr> <tr> <td style="width:40%;"><?php echo $mobile;?></td> <td style="width:30%;"></td> <td style="width:40%;">Order No : <?php echo $rw_details->order_id;?> &nbsp;</td> </tr> <tr> <td style="width:40%;"><?php echo $email;?></td> <td style="width:30%;"></td> <td style="width:40%;">Order Date :<?php echo $dateinvoice = date("d/m/Y", strtotime($rw_details->order_date)); ?> &nbsp;</td> </tr> <?php /*<tr> <td>Order Status : <?php echo $rw_details->order_status;?></td> </tr>*/ ?> </tbody> </table> </div> </div> </div> <hr> <div class="row"> <div class="col-xs-12 col-md-12"> <table class="table table-bordered my-table"> <thead> <tr> <th style="width:5%;">#</th> <th style="width:45%;">Item</th> <th style="width:20%; text-align:center!important;" align="center">Price</th> <th style="width:10%; text-align:center!important;" 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 style="width:20%; text-align:center;" 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;?> <?php echo $rw_details1->size;?> </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($free == "Active"){ ?> <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" style="width:40%; ">Sub Total</th> <td style="width:60%; padding-left:16%;"><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" style="width:40%; ">Discount</th> <td style="width:60%; padding-left:16%;"><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo $rw_details->discount; ?></td> </tr> <tr> <th scope="row" style="width:40%; ">Delivery</th> <td style="width:60%; padding-left:16%;"><i class="fa fa-<?php echo $default_currency; ?>"></i> <?php echo $rw_details->delivery_charge; ?></td> </tr> <tr> <th scope="row" style="width:40%; ">Grand Total</th> <td style="width:60%; padding-left:16%;"><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>