|
Server IP : 162.214.80.37 / Your IP : 216.73.216.196 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/skyispatudyog/sym/Users/0-imyrqtmy/shivam/Admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("Includes/db.php");
include("Includes/esti.php");
$bid = $_GET['id'];
@$copy = $_GET['copy'];
$sql = "select * from tbl_invoice where id='$bid'";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
$sql_row = mysqli_fetch_assoc($sql_res);
$gst = ($sql_row['cgst'] + $sql_row['sgst']);
$number = $sql_row['totalval'];
$no = floor($number);
$point = round($number - $no, 2) * 100;
$hundred = null;
$digits_1 = strlen($no);
$i = 0;
$str = array();
$words = array('0' => '', '1' => 'one', '2' => 'two',
'3' => 'three', '4' => 'four', '5' => 'five', '6' => 'six',
'7' => 'seven', '8' => 'eight', '9' => 'nine',
'10' => 'ten', '11' => 'eleven', '12' => 'twelve',
'13' => 'thirteen', '14' => 'fourteen',
'15' => 'fifteen', '16' => 'sixteen', '17' => 'seventeen',
'18' => 'eighteen', '19' =>'nineteen', '20' => 'twenty',
'30' => 'thirty', '40' => 'forty', '50' => 'fifty',
'60' => 'sixty', '70' => 'seventy',
'80' => 'eighty', '90' => 'ninety');
$digits = array('', 'hundred', 'thousand', 'lakh', 'crore');
while ($i < $digits_1) {
$divider = ($i == 2) ? 10 : 100;
$number = floor($no % $divider);
$no = floor($no / $divider);
$i += ($divider == 10) ? 1 : 2;
if ($number) {
$plural = (($counter = count($str)) && $number > 9) ? 's' : null;
$hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
$str [] = ($number < 21) ? $words[$number] .
" " . $digits[$counter] . $plural . " " . $hundred
:
$words[floor($number / 10) * 10]
. " " . $words[$number % 10] . " "
. $digits[$counter] . $plural . " " . $hundred;
} else $str[] = null;
}
$str = array_reverse($str);
$result = implode('', $str);
$points = ($point) ?
"." . $words[$point / 10] . " " .
$words[$point = $point % 10] : '';
$result . "Rupees " . $points . " Paise";
?>
<!doctype html>
<html lang="en">
<head>
<?php include 'Includes/head.php'; ?>
</head>
<style type="text/css" media="print">
@page
{
size: auto; /* auto is the initial value */
margin-left: 0.5in;
margin-right: 0.5in;
margin-top: 0.1in;
margin-bottom: 0;
}
</style>
<body data-sidebar="dark">
<!-- <body data-layout="horizontal" data-topbar="dark"> -->
<!-- Begin page -->
<div id="layout-wrapper">
<?php include 'Includes/header.php'; ?>
<!-- ========== Left Sidebar Start ========== -->
<div class="vertical-menu">
<div data-simplebar class="h-100">
<!--- Sidemenu -->
<?php include 'Includes/sidebar.php'; ?>
<!-- Sidebar -->
</div>
</div>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start right Content here -->
<!-- ============================================================== -->
<div class="main-content">
<div class="page-content">
<div class="container-fluid">
<!-- start page title -->
<div class="row">
<div class="col-12">
<div class="page-title-box d-sm-flex align-items-center justify-content-between">
<h4 class="mb-sm-0 font-size-18"> Invoice View</h4>
</div>
</div>
</div>
<!-- end page title -->
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-body">
<table width="100%">
<tr style="border: 1px solid #000;">
<td colspan="" >G.S.T No. :- 09ADIPG0779P1ZW</td>
<td colspan="5" style="text-align: center;"><?php echo $sql_row['itype']; ?></td>
<td colspan="3" style="text-align: right;"><?php echo $copy; ?></td>
</tr>
<tr style="border: 1px solid #000;">
<td colspan="" style=""><img src="assets/images/sj.jpg" style="height: 80px;"></td>
<td colspan="5" style="text-align: center;">
<span style="font-size: 30px;font-weight: 500;color: red;">SHIVAM JEWELLERS</span><br>
<span>22/145A/9, Moti Lal Nehru Road, Agra</span><br>
<span>Phone No : 9319115657 Email : abc@gmail.com </span>
</td>
<td colspan="3" style="text-align: right;">St.Code : 27</td>
</tr>
<tr style="border: 1px solid #000;">
<td colspan="">
<span style="font-size: 15px;font-weight: 500;">Customer Name : <?php echo $sql_row['name']; ?></span><br>
<span><?php echo $sql_row['cadd']; ?></span><br>
<!-- <span>New Delhi , New Delhi</span><br> -->
<span><?php echo $sql_row['phno']; ?> </span>
</td>
<td colspan="4" style="text-align: right;border-right:1px solid #000 ;">
<span> St.Code : 27</span>
</td>
<td colspan="4">
<span>Date : <?php echo $sql_row['add_date']; ?></span><br>
<span>Invoice No : 15</span><br>
<span>Payment Mode : <?php echo $sql_row['pmode']; ?></span><br>
</td>
</tr>
</table>
<table width="100%">
<tr style="border-bottom: 1px solid #000;border-left: 1px solid #000;">
<th style="border-right: 1px solid #000;" >Sr.No</th>
<th style="border-right: 1px solid #000;" >Item Name & Description</th>
<th class="dn" style="border-right: 1px solid #000;">Qty </th>
<th style="border-right: 1px solid #000;" >HSN </th>
<th style="border-right: 1px solid #000;">PCS</th>
<th style="border-right: 1px solid #000;">Weight</th>
<th style="border-right: 1px solid #000;">Rate P10/gm</th>
<th style="border-right: 1px solid #000;">Amount</th>
</tr>
<?php
$bid = $_GET['id'];
$k = 1;
$sqli = "select * from tbl_item where invid='$bid'";
$sql_resi = mysqli_query($con, $sqli) or die(mysqli_error($con));
while ($sql_rowi = mysqli_fetch_array($sql_resi))
{
?>
<tr style="border-left: 1px solid #000;">
<td style="border-right: 1px solid #000;"><?php echo $k; ?></td>
<td style="border-right: 1px solid #000;" ><?php echo $sql_rowi['product']; ?></td>
<td class="dn" style="border-right: 1px solid #000;" ><?php echo $sql_rowi['qty']; ?></td>
<td style="border-right: 1px solid #000;" ><?php echo $sql_rowi['hsn']; ?></td>
<td style="border-right: 1px solid #000;"><?php echo $sql_rowi['pcs']; ?></td>
<td style="border-right: 1px solid #000;"><?php echo $sql_rowi['weight']; ?></td>
<td style="border-right: 1px solid #000;"><?php echo $sql_rowi['rate']; ?></td>
<td style="border-right: 1px solid #000;"><?php echo $sql_rowi['totalprice']; ?></td>
</tr>
<?php $k++; } ?>
</table>
<table width="100%" id="tbs">
<tr style="border: 1px solid #000;">
<td width="30%"></td>
<td >
<span>CGST 1.5% <span> Total CGST Amount: <?php echo $sql_row['cgst']; ?></span></span><br>
<span>SGST 1.5% <span> Total SGST Amount: <?php echo $sql_row['sgst']; ?></span></span><br>
<span> <span> Total GST Tax: <?php echo $gst; ?></span></span>
</td>
<td colspan="">
<span><span> Total Amount Before Tax: <?php echo $sql_row['subtotalval']; ?></</span></span><br>
<!-- <span><span> Additional Discount: 456</span></span><br> -->
<span> <span> Total Amount After Tax: <?php echo $sql_row['totalval']; ?></</span></span>
</td>
</tr>
<tr style="border: 1px solid #000;">
<td colspan="3" >
<span style="font-size: 15px;font-weight: 500;">Amount In Words : <?php echo $result; ?></span><br>
</td>
</tr>
<tr style="border: 1px solid #000;">
<td width="30%">
<span style="font-size: 15px;font-weight: 500;">Bank Details</span><br>
<span>Bank : Yes Bank Ltd, Kamlanagar, Agar</span><br>
<span>Account : 071163300001461</span><br>
<span>IFSC Code : YESB0000711</span><br>
</td>
<td colspan="">
<br><br>
<span>Customer Signature</span>
</td>
<td colspan="" >
<br><br>
<span>For Shivam Jewellrs</span>
</td>
</tr>
</table>
<table width="100%">
<tr style="border: 1px solid #000;">
<td style="text-align: center;" >
<span style="font-size: 15px;font-weight: 500;">Thank You ! Visit Again</span><br>
</td>
</tr>
</table>
</div>
<div class="d-print-none">
<div class="float-end">
<a href="javascript:window.print()" class="btn btn-success waves-effect waves-light me-1"><i class="fa fa-print"></i></a>
</div>
</div> </div>
</div>
</div><!-- end row -->
<!-- end row -->
<!-- end row -->
<!-- end row -->
</div>
<!-- container-fluid -->
</div>
<!-- End Page-content -->
<footer class="footer">
<?php include 'Includes/footer.php'; ?>
</footer>
</div>
<!-- end main content-->
</div>
<!-- END layout-wrapper -->
<!-- Right Sidebar -->
<!-- /Right-bar -->
<!-- Right bar overlay-->
<div class="rightbar-overlay"></div>
<?php include 'Includes/bscript.php'; ?>
</body>
</html>