MAINHACK

Viewing / Editing File: bill.php

<?php
include '../settings/settings.php';

$order=$_REQUEST['id'];

//echo $order;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<title>Bill</title>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<style type="text/css" media="print">
    @page 
    {
        size:  auto;   /* auto is the initial value */
        margin: 0mm;  /* this affects the margin in the printer settings */
    }

html
    {
        background-color: #FFFFFF; 
        margin: 0px;  /* this affects the margin on the html before sending to printer */
		
    }

body
    {
       
    }
	</style>
<style>
  body{font-family: 'Open Sans', sans-serif; font-size:12px;}
  table{ border-collapse:collapse; width:100%;}
  table tr,td,th{ border:1px solid #e7e7e7; padding:6px; text-align:center;}
  div.table{margin:2% 2%;}
  .left-border{border-left: 1px solid #000;}
  table.top tr:nth-child(1) p { margin-top: 0px !important; margin-bottom: 0px !important; text-align:left;}
  table.top tr:nth-child(2){ border-bottom:none;}
  table.top tr:nth-child(3){border-top:none; border-bottom:none;}
  table.top tr:nth-child(4){border-top:none;}
  table.top tr:nth-child(2) td{text-align:left;}
  table.top tr:nth-child(3) td{text-align:left;}
  table.top tr:nth-child(4) td{text-align:left;}
  table.top p{ padding: 0; margin: 0; color: #3c3b3b; font-size: 14px; line-height: 31px; }   
  label{ font-weight:bold;}
  .no{border:none;}
  table.no tr th{ border:none;}
  .heigh{ border-top:none; text-align:center;}
  table.heigh tr:last-child td{ padding-bottom:1em;}
  table.heigh tr {  padding: 0; color: #000; font-size: 16px; }
  table.heigh tr td{  } 
  table.top{border:1px solid #d6d6d6;}
  table.top tr,td{ border:none;}
  table.bottom td{ text-align:left; border:none;}
  table.bottom tr:nth-child(1){ border-bottom:none;}
  table.bottom tr:nth-child(2){ border-bottom:none; border-top:none;}
  table.bottom tr:nth-child(3){ border-top:none;}
  table.bottom tr:nth-child(4) td{ padding-top:5em; padding-bottom:2em;}
  .text-center{ text-align:center !important;}
  .text-right{ text-align:right !important;}
  .print{padding:7px 15px; margin:0 auto; background:rgba(0, 0, 0, 0) -moz-linear-gradient(center top , #cae0b0 0%, #a6cb7a 2%, #6da42b 100%) repeat scroll 0 0; background:#619126; Color:#fff; }
  .no-print{ margin:2em 0;}

@media print
{    
    .no-print, .no-print *
    {
        display: none !important;
    }

table tr,td,th{ border:1px solid #e7e7e7; padding:6px; text-align:center;}
div.table{margin:2% 2%;}
.left-border{border-left: 1px solid #000;}
table.top tr:nth-child(1) p { margin-top: 0px !important; margin-bottom: 0px !important; text-align:left;}
table.top tr:nth-child(2){ border-bottom:none;}
table.top tr:nth-child(3){border-top:none; border-bottom:none;}
table.top tr:nth-child(4){border-top:none;}
table.top tr:nth-child(2) td{text-align:left;}
table.top tr:nth-child(3) td{text-align:left;}
table.top tr:nth-child(4) td{text-align:left;}
table.top p{ padding: 0; margin: 0; color: #3c3b3b; font-size: 16px; line-height: 35px; }   
label{ font-weight:bold;}
.no{border:none;}
table.no tr th{ border:none;}
.heigh{ border-top:none; text-align:center;}
table.heigh tr:last-child td{ padding-bottom:1em;}
table.heigh tr {  padding: 0; color: #000; font-size: 16px; }
table.heigh tr td{  } 
table.top{border:1px solid #d6d6d6;}
table.top tr,td{ border:none;}
table.bottom td{ text-align:left; border:none;}
table.bottom tr:nth-child(1){ border-bottom:none;}
table.bottom tr:nth-child(2){ border-bottom:none; border-top:none;}
table.bottom tr:nth-child(3){ border-top:none;}
table.bottom tr:nth-child(4) td{ padding-top:5em; padding-bottom:2em;}
.text-center{ text-align:center !important;}
.text-right{ text-align:right !important;}

.privacy about{ }
table.top h2{ color: #f00; font-size: 25px;}
table.top h4{ font-size: 20px; color: #000; }
table.top h5{ font-size: 15px; color: #000; padding: 20px 0 0; font-weight: bold; }
h4.pay-dl{ text-align: center; font-size: 18px; font-family: monospace; text-decoration: none !important; line-height: 25px; color: #000;}
h4.pay-no{ text-align: center; font-weight: bold; font-size: 25px; line-height: 35px; padding: 4px 0 10px; color: #212529; }
table.new-table{ border:solid 1px #000;}
table.new-table tr th{ border:solid 1px #000;}
table.new-table tr{ border:none;}
table.new-table tr td.no-left{ border-right:1px solid #000; }
table.new-table h2.text-center{ font-size: 20px; font-weight: bold; color: #3e3e3e; }
thead.color-thead{ background: #e7e7e7; color: #f00; font-size: 16px; padding: 0; }
thead.sl-color{ background: #01b0f1; color: #000; font-size: 14px; padding: 0; }
tr.fast-top{ width:100%; }
tr.fast-top td{ width:25%; }
tr.tab-ship{ width:100%; }
tr.tab-ship td{ width:50%; text-align: left; }
tr.tab-des{ width:100%; }
tr.tab-des td{ width:14.25%; text-align: left; }
tr.tab-det{ width:100%; }
tr.tab-det td{ width:33%; text-align: left; }
input { resize: vertical;  border: none; outline: none; }

}
.privacy about{ }
table.top h2{ color: #f00; font-size: 25px;}
table.top h4{ font-size: 20px; color: #000; }
table.top h5{ font-size: 15px; color: #000; padding: 20px 0 0; font-weight: bold; }
h4.pay-dl{ text-align: center; font-size: 18px; font-family: monospace; text-decoration: none !important; line-height: 25px; color: #000;}
h4.pay-no{ text-align: center; font-weight: bold; font-size: 25px; line-height: 35px; padding: 4px 0 10px; color: #212529; }
table.new-table{ border:solid 1px #000;}
table.new-table tr th{ border:solid 1px #000;}
table.new-table tr{ border:none;}
table.new-table tr td.no-left{ border-right:1px solid #000; }
table.new-table h2.text-center{ font-size: 20px; font-weight: bold; color: #3e3e3e; }
thead.color-thead{ background: #e7e7e7; color: #f00; font-size: 16px; padding: 0; }
thead.sl-color{ background: #01b0f1; color: #000; font-size: 14px; padding: 0; }
tr.fast-top{ width:100%; }
tr.fast-top td{ width:25%; }
tr.tab-ship{ width:100%; }
tr.tab-ship td{ width:50%; text-align: left; }
tr.tab-des{ width:100%; }
tr.tab-des td{  text-align: left; }
thead.sl-color tr th{ width:14.25%; text-align: left; }
thead.sl-color tr th.sl-no-one{width:6%; }
thead.sl-color tr th.sl-no-secend{ width:25%; }
thead.sl-color tr th.sl-no-thre{ width:6%;}
/*tr.tab-des td{ width:14.25%; text-align: left; }*/
tr.tab-det{ width:100%; }
tr.tab-det td{ width:33%; text-align: left; }

.privacy about{ }
table.top h2{ color: #f00; font-size: 25px;}
table.top h4{ font-size: 20px; color: #000; }
table.top h5{ font-size: 15px; color: #000; padding: 20px 0 0; font-weight: bold; }
h4.pay-dl{ text-align: center; font-size: 18px; font-family: monospace; text-decoration: none !important; line-height: 25px; color: #000;}
h4.pay-no{ text-align: center; font-weight: bold; font-size: 25px; line-height: 35px; padding: 4px 0 10px; color: #212529; }
table.new-table{ border:solid 1px #000;}
table.new-table tr th{ border:solid 1px #000;}
table.new-table tr{ border:none;}
table.new-table tr td.no-left{ border-right:1px solid #000; }
table.new-table h2.text-center{ font-size: 20px; font-weight: bold; color: #3e3e3e; }
thead.color-thead{ background: #e7e7e7; color: #f00; font-size: 16px; padding: 0; }
thead.sl-color{ background: #01b0f1; color: #000; font-size: 14px; padding: 0; }
tr.fast-top{ width:100%; }
tr.fast-top td{ width:25%; }
tr.tab-ship{ width:100%; }
tr.tab-ship td{ width:50%; text-align: left; }
tr.tab-des{ width:100%; }
tr.tab-des td{  text-align: left; }
thead.sl-color tr th{ width:14.25%; text-align: left; }
thead.sl-color tr th.sl-no-one{width:6%; }
thead.sl-color tr th.sl-no-secend{ width:25%; }
thead.sl-color tr th.sl-no-thre{ width:6%;}
/*tr.tab-des td{ width:14.25%; text-align: left; }*/
tr.tab-det{ width:100%; }
tr.tab-det td{ width:33%; text-align: left; }

</style>
<link href='//fonts.googleapis.com/css?family=Montserrat+Alternates:400,700' rel='stylesheet' type='text/css'>
<link href='//fonts.googleapis.com/css?family=Open+Sans:400,300,300italic,400italic,600,600italic,700,700italic,800italic' rel='stylesheet' type='text/css'>
<link href='//fonts.googleapis.com/css?family=Racing+Sans+One' rel='stylesheet' type='text/css'>

</head>
<body>
<?php
	$sq="select * from bill where bill_id='".$order."'";// echo $sq;
$r=$con->prepare($sq);
	$r->execute();
	$c=$r->rowCount();
if($c<=0){
	echo "";
}else{
	while($row = $r->fetch(PDO::FETCH_ASSOC)){
    $in_date=date('d-m-Y',strtotime($row['date']));
    $in_time=$row['time'];
$amount=$row['bill_total'];
$tax=$row['tax'];
$extra=$row['extra'];
$total=$row['total'];
$server=$row['server'];
$table=$row['table_no'];
$reason=$row['reason'];
	}
}
//echo $name;

?>
<div class='privacy about' style='padding:0 5em 5em 2em;'>
<div class="table">
<table class="top">
	<tr>
		
	</tr>

<tr>
<td width="50%">
   	<p><b><h2><?=$company_name?></h2></b></p>
			<p><?=$address?></p>
			<p>Website : <?=$website?></p>
			<p>Email Address : <?=$email?></p>
			<p>Contact Number : <?=$phone?></p>
    		<p>GST no :  <?=$gst?></p>			
    		<p>Invoice no :  <?=$order?></p>
    		<p>Invoice date :  <?=$in_date?>,<?=$in_time?></p>    	
     
    </td>

<td>
        <h4 class="pay-no">INVOICE</h4>
    </td>
		<td class="text-right" width="30%"><img src="<?=$company_logo?>" width="45%"><br><h5><?=$company_name?></h5></td>
	</tr>
</table>
<table class="table table-bordered">
	<thead class="color-thead">
      <tr>
        <th colspan="">BILL TO</th>
       
      </tr>
    </thead>
    <tbody id="myTable">
      <tr class="tab-ship">
    <td width="50%">
    <p> Name : <?php echo $name;?></p>
    <p>Email : <?php echo $phn;?></p>
    <p> Contact Number : <?php echo $phn;?></p>
      </td>
     <td style="text-align:right"><p>SERVER# : <?=$server?></p><p>TABLE# : <?=$table?></p></td>
      </tr>

</tbody>
</table>
<table class="table table-bordered">
	<thead class="sl-color">
      <tr>
        <th class="sl-no-one">SL NO</th>
        <th class="sl-no-secend">DESCRIPTION</th>
        <th class="sl-no-thre">QTY</th>
        <th>PRICE</th>  
        <th>TOTAL</th>              
      </tr>
    </thead>
    <tbody id="myTable">
   <?php $count=1;$gst_total=0;$delivery_total=0;$sub_total=0;
$stmt1=$show->readwithdata('menu_bill','bill_id',$order);
$num1=$stmt1->rowCount();
if($num1>0){
	while($row=$stmt1->fetch(PDO::FETCH_ASSOC)){
	//	$total=intval($row['quantity']*$row['price']);
	//	$total1+=$total;
      //  $gst=$row['gst'];
    //    $gst_value=100+$gst;
    //    $amt=100*$total/$gst_value;
    //    $gst_inamt=$total-$amt;
    //    $delivery_charge=$row['delivery_charge'];
    //    $gst_total +=round($gst_inamt,2);
    //    $delivery_total +=$row['delivery_charge'];
    //    $sub_total +=round((($total-$gst)*$row['quantity']),2);
	$line_price=round($row['price']*$row['qty']);
	  ?>     
	 
      <tr class="tab-des">
        <td><?=$count?></td>
        <td><?=$row['menu']?>  (<?=$row['menu_id']?>)</td>
        <td><?=$row['qty']?></td>
        <td><?=$row['price']?></td>
        <td><?=$line_price?></td>
      </tr>
  <?php  ++$count;} } ?>   
      
      <tr class="tab-des">
        <td></td>
        <td></td>
        <td></td>
        <td>SUB TOTAL</td>
        <td><?=$total?></td>        
      </tr> 
     <tr class="tab-des">
      <td><?=$count?></td>
      <td colspan="2"><?=$reason?></td>
        <td>Extra</td>
        <td><?=$extra?></td>        
      </tr>  
       <tr class="tab-des">
        <td colspan="3"></td>
        <td>SGST</td>
        <td><?=$tax/2?></td>        
      </tr>      
     <tr class="tab-des">
        <td colspan="3"></td>
        <td>CGST</td>
        <td><?=$tax/2?></td>        
      </tr>  
      
      <tr class="tab-des">
        <td></td>
        <td></td>
        <td></td>
        <td>TOTAL AMOUNT </td>
        <td><?=$amount?></td>        
      </tr>

</tbody>
</table>

<tbody id="myTable">
      <tr class="tab-det">
        <td>We declare that this invoice shows the actual price of the goods described and that all particulars are true and correct.</td> 
        <td><?=$company_name?></td> 
        <td>Authorized signatory</td> 
      </tr>

</tbody>
</table>

<tr>
		<td colspan="6">Thank you! visit again.</td>
	</tr>

</table>

</div>
</div>

<div class="no-print" align="center">
        <button onclick="myFunction()" class="print">Print this page</button>
        <div>
        
            <script>
            function myFunction() {
                window.print();
            }
            </script>
            
        </div>
    </div>

</body>
</html>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: bill.php

Server Info

System Features

User Info