Ghost Exploiter Team Official

/home/ramdevpcb/public_html/admin.ramdevpcb.com/

<?php
require_once 'include/db.php';

$invoiceId = $_POST['invoiceId'];

// Check if the 'print' key exists in the POST request
if (isset($_POST['print'])) {
    // Trigger the browser's print dialog
    echo "<script type='text/javascript'>
        window.print();
    </script>";
}

$result1 = mysqli_query($conn, "SELECT * FROM Invoices i, Orders o WHERE i.OrderID = o.OrderID AND i.InvoiceNumber = '$invoiceId'") or die(mysqli_error($conn));
$row1 = mysqli_fetch_assoc($result1);

$result2 = mysqli_query($conn, "SELECT  * FROM Company c, States s WHERE c.StateID = s.StateID LIMIT 1") or die(mysqli_error($conn));
$row2 = mysqli_fetch_assoc($result2);
?>
<!doctype html>
<html lang="en" dir="ltr">

<head>
	
	<meta charset="UTF-8">
	<meta name='viewport' content='width=device-width, initial-scale=1.0, user-scalable=0'>
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="description" content="Ramdev PCB Admin">
	<meta name="author" content="Ramdev PCB Admin">
	<meta name="keywords" content="Ramdev PCB">
	
	<link rel="shortcut icon" type="image/x-icon" href="assets/images/brand/favicon.ico" />
	
	<title>Invoice Ramdev PCB</title>
	
	<link id="style" href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" />
	
	<link href="assets/css/style.css" rel="stylesheet" />
	<link href="assets/css/dark-style.css" rel="stylesheet" />
	<link href="assets/css/transparent-style.css" rel="stylesheet">
	<link href="assets/css/skin-modes.css" rel="stylesheet" />
	
	<link href="assets/css/icons.css" rel="stylesheet" />
	<link href="assets/css/custom.css" rel="stylesheet" />
	
	<link id="theme" rel="stylesheet" type="text/css" media="all" href="assets/colors/color1.css" />
	<style>
	
	 /*@media print {*/
  /*          @page {*/
  /*              size: A4;*/
  /*              margin: 0mm; */
  /*          }*/
	 /*}*/

/** only for the head of the table. */
		table.table thead th {
			padding: 0;
		}

/** only for the body of the table. */
		table.table tbody td {
			padding: 0;
		}

.table-bordered td,
		.table-bordered th {
			/*border-color: black !important;*/
		}
		
		                 	#watermark
{
 position:absolute;
 bottom:38%;
 left: 38%;
 opacity:0.1;/*
 z-index:99;
 color:#d8d5d5;
     font-size: 900%;
     transform: rotate(-30deg);*/
}
@media print
{    
    .no-print, .no-print *
    {
        display: none !important;
    }
     .row {
    display: flex !important; /* Retain flex layout for print */
  }

.col-md-6,
  .col-md-8,
  .col-md-2, .col-md-4 {
    width: auto !important; /* Reset width for print */
  }
  
  /*html, body {*/
  /*      margin: 0;*/
  /*      padding: 0;*/
  /*      overflow: hidden; */
  /*  }*/
  /*@page {*/
  /*      size: A4; */
  /*      margin: 0mm;*/
  /*  }*/
}

/* Make table look like Tally style */
.invoice-table {
  border-collapse: collapse;
  width: 100%;
  border: none !important; /* Removes outer border */
}

/* Light grey inner borders */
.invoice-table th,
.invoice-table td {
  border: 1px solid #dcdcdc !important;
  color: #000;
}

/* Remove outer border edges */
.invoice-table tr:first-child th {
  border-top: none !important;
}
.invoice-table tr:last-child td {
  border-bottom: none !important;
}
.invoice-table th:first-child,
.invoice-table td:first-child {
  border-left: none !important;
}
.invoice-table th:last-child,
.invoice-table td:last-child {
  border-right: none !important;
}

/* Optional: softer background for header */
.invoice-table thead th {
  background-color: #f9f9f9;
  font-weight: 600;
}

</style>
</head>

<body class="app sidebar-mini ltr">
	
	<div class="page">
		<div class="page-main">
			<div class="main-content mt-0">
				<div class="side-app ">
					
					<div class="main-container container-fluid">
						
						<div class="page-header no-print">
							<h1 class="page-title">Tax Invoice</h1>
								<button onClick="window.print()" style="padding: 7px;border-radius: 24px;color: #ffffff;font-weight: bolder;background-color: #ad9407;">Print this page</button>
						        
							<div>
								<ol class="breadcrumb">
									<li class="breadcrumb-item"><a href="javascript:void(0)">Pages</a></li>
									<li class="breadcrumb-item active" aria-current="page">Invoice</li>
								</ol>
							</div>
						</div>
						
						
						<div id="invoice" class="row">
							<div class="col-md-12">
								<div class="card">
								    <center><h1>Tax Invoice </h1></center>
									<div class="card-body">
									    <div id="watermark"><img src="http://www.ramdevpcb.com/assets/imgs/theme/RamdevLogo.jpg" style="width:250px"></div>
										<div class="table-responsive push">
											<table class="table table-bordered mb-0 text-nowrap" style="font-size:12px;">
												<tbody>
												    <tr>
    <td colspan="2" rowspan="7" style="width:50%;padding-left:10px">
        <div style="width:50%;"><img src="http://www.ramdevpcb.com/assets/imgs/theme/RamdevLogo.jpg" class="header-brand-img logo-3" alt="PCB logo" style="float:left;width: 100%; max-width: 190px;padding-top:20px;padding-right: 30px;"></div>
        <div style="width:50%;right:0;padding-top:10px">
            <h6 ><strong><?= $row2['CompanyName'] ?></strong></h6>
																	<?= $row2['CompanyAddress'] ?>
																	<?= $row2['StateName'] ?> - 401 208 &nbsp;<br />
																	<strong>GSTIN/UIN: <?= $row2['CompanyGSTNumber'] ?></strong><br />
																	
																	<strong>State Name : <?= $row2['StateName'] ?>, Code : 27 <br />Contact : <?= $row2['CompanyMobileNumber'] ?><br /></strong>
																	<strong>E-Mail : <?= $row2['CompanyEmail'] ?></strong><br />
																	<strong>www.ramdevpcb.com</strong></div>
																	<hr style="display: block; height: 1px;border: 0; border-top: 1px solid #000000;margin: 0 0; padding: 0;">
																	<div style="clear: left;">
																	    <h6 ><strong>Consignee (Ship to)</strong></h6>
															<?php
															$result3 = mysqli_query($conn, "SELECT ad.StateID,ad.Name,ad.AddressLine1,ad.AddressLine2,ad.PinCode,s.StateName,c.CityName,u.UserGSTNumber FROM AddressDetails ad, States s, Cities c,Users u WHERE ad.UserID=u.UserID and  c.CityID = ad.CityID AND ad.StateID = s.StateID AND ad.AddressID = '{$row1['ShippingAddressID']}'") or die(mysqli_error($conn));
															$rcounts = mysqli_num_rows($result3);
										//echo $rcount;
										if($rcounts==0){
										   $result3 = mysqli_query($conn, "SELECT * FROM AddressDetails ad, States s, Cities c,Users u WHERE ad.UserID=u.UserID and c.CityID = ad.CityID AND ad.StateID = s.StateID AND ad.UserID = '{$row1['UserID']}'") or die(mysqli_error($conn));
										   //echo $row1['UserID'];
										}
															$row3 = mysqli_fetch_assoc($result3);
															$shipstate = $row3['StateID'];
															?>
                                                            <?= $row3['Name'] ?><br />
															<?= $row3['AddressLine1'] ?><br />
															<?= $row3['AddressLine2'] ?><br />
															<?= $row3['CityName'] . '-' . $row3['PinCode'] ?></br>

GSTIN/UIN : <?= $row3['UserGSTNumber'] ?><br />
															State Name : <?= $row3['StateName'] ?><br />
																	</div>
																	
																	<hr style="display: block; height: 1px;border: 0; border-top: 1px solid #000000;margin: 1em 0; padding: 0;">
																	<div><h6  > <strong>Buyer (Bill to)</strong></h6>
										<?php
										$result4 = mysqli_query($conn, "SELECT * FROM AddressDetails ad, States s, Cities c,Users u WHERE ad.UserID=u.UserID and c.CityID = ad.CityID AND ad.StateID = s.StateID AND ad.AddressID = '{$row1['BillingAddressID']}'") or die(mysqli_error($conn));
										$rcount = mysqli_num_rows($result4);
										//echo $rcount;
										if($rcount==0){
										   $result4 = mysqli_query($conn, "SELECT * FROM AddressDetails ad, States s, Cities c,Users u WHERE ad.UserID=u.UserID and c.CityID = ad.CityID AND ad.StateID = s.StateID AND ad.UserID = '{$row1['UserID']}'") or die(mysqli_error($conn));
										   //echo $row1['UserID'];
										}
										$row4 = mysqli_fetch_assoc($result4);
										?>
                                        <?= $row3['Name'] ?><br />
										<?= $row4['AddressLine1'] ?><br />
										<?= $row4['AddressLine2'] ?><br />
										<?= $row4['CityName'] . '-' . $row4['PinCode'] ?><br />
										GSTIN/UIN : <?= $row3['UserGSTNumber'] ?><br />
										State Name : <?= $row4['StateName'] ?>, Code : 27<br />
										Place of Supply : <?= $row4['StateName'] ?><br /></div>
																	</td>
    <td style="height: 97px;">
        <strong>Invoice No.</strong><br><?= $invoiceId ?></td>
    <td><strong>Dated</strong><br><?= $row1['InvoiceDate'] ?></td>
  </tr>
  <tr>
    <td><strong>Delivery Note</strong><?= $row1['DeliveryNote'] ?></td>
    <td><strong>Mode/Terms of Payment</strong></td>
  </tr>
  <tr>
    <td><strong>Reference No. & Date</strong><br /><?= ($row1['ReferenceNo'] . ' ' . $row1['ReferenceDate']) ?></td>
    <td><strong>Other References</strong><br /><?= $row1['OtherReferences'] ?></td>
  </tr>
  <tr>
    <td><strong>Buyer's Order No</strong><br /><?= $row1['OrderNumber'] ?></td>
    <td><strong>Dated</strong><br /><?= date('d-M-y', strtotime($row1['OrderDate'])) ?></td>
  </tr>
  <tr>
    <td><strong>Dispatch Doc No.</strong><br /><?= $row1['DispatchDocNumber'] ?></td>
    <td><strong>Delivery Note Date</strong><br /><?= $row1['DeliveryNoteDate'] ?></td>
  </tr>
  <tr>
    
    <td><strong>Dispatched through</strong><?= $row1['DispatchedThrough'] ?></td>
    <td><strong>Destination</strong><?= $row1['CityName'] ?></td>
  </tr>
  <tr>
    <td colspan="2" style="height: 145px;">
        <div><strong>Terms of Delivery<br /></strong></div>
												<div style="white-space: normal!important;"><?= $row2['TermsOfDelivery'] ?><br /></div></td>
  </tr>
												    
										
										</tbody>
										</table>

</div>
									<div class="table-responsive push">
										<table class="table table-bordered mb-0 text-nowrap" style="text-align: center; font-size: 12px;">
											<thead>
												<tr class="">
													<th class="text-center">S.No.</th>
													<?php if($row2['StateID'] == $shipstate){ ?>
													<th class="text-center" style="width:45.35%">Description of Goods</th>
													<?php } else{ ?>
													<th class="text-center" style="width:44.44%">Description of Goods</th>
													<?php } ?>
													<th class="text-end">HSN/SAC</th>
													<th class="text-end">Quantity</th>
													<th class="text-end">Rate</th>
													<th class="text-end">Per</th>
													<th colspan="2" class="text-end">Amount</th>
												</tr>
											</thead>
											<tbody>
												<?php
													$orderId = $row1['OrderID'];
													$result3 = mysqli_query($conn, "SELECT * FROM OrderItems oi, productdetails pd, BrandCategory c, BrandSubCategory sc, BrandModel m, ProductColors pc WHERE oi.ProductID = pd.ProductID AND pd.CategoryID = c.CategoryID AND pd.SubCategoryID = sc.SubCategoryID AND pd.ModelID = m.ModelID AND pc.ColorID = pd.ProductColorID AND oi.OrderID = '$orderId'") or die(mysqli_error($conn));
													$i = 1;
													$totalPrice = 0;
													$totalQuantity = 0;
													$totalGst = 0;
													$grandTotal = 0;
													$roundOff = 0;
													while ($row3 = mysqli_fetch_assoc($result3)) {
														$discounts = mysqli_query($conn, "SELECT * FROM Discounts WHERE DiscountID = {$row3['Discount']}") or die(mysqli_error($conn));
														$disc = mysqli_fetch_assoc($discounts);
														$price = $row3['ProductQuantity'] * ($row3['ProductAmount'] - ($row3['ProductAmount'] * ($disc['DiscountPercent'] / 100)));
														$prices = $row3['ProductQuantity'] * $row3['ProductAmount'];
														$totalPrice += $prices;
														$finalprice += $price;
														$discprice += $prices - $price;
														$totalQuantity += $row3['ProductQuantity'];
														//$totalGst += (($row3['ProductQuantity'] * $price) * ($row3['GSTPercent'] / 100));
														$totalGst += $price * ($row3['GSTPercent'] / 100);
													//	echo $totalGst;
												?>
												<tr>
													<td><?= $i++ ?></td>
													<td>
														<p class="font-w600 mb-1"><?= $row3['ProductNumber'] . ' ' . $row3['Watts'] . ' ' . $row3['Size'] . "MM (" . $row3['SubCategory'] . ' @' . $row3['Driver'] . '+LED' . ")" ?></p>
													</td>
													<td class="text-end"><?= $row3['HSNCode'] ?></td>
													<td class="text-end"><?= $row3['ProductQuantity'] ?> NOS</td>
													<td class="text-end"><?= number_format($row3['ProductAmount'], 2) ?></td>
													<td class="text-end">NOS</td>
													<td class="text-end" colspan="2">₹ <?= number_format($row3['ProductQuantity'] * $row3['ProductAmount']) ?></td>
												</tr>
												
												<?php
												       
														
													}
													$tp =  empty($row1['TransportPrice']) ? '0.00' : $row1['TransportPrice'];
													 $tll = round($finalprice + $totalGst + $tp,0);
													 $bll = $finalprice + $totalGst + $tp;
												        $roundOff = $tll - $bll;
												       // echo $tll;
												        if (str_contains($roundOff, '-')) {
												           $sign = '-';
												           $r = explode("-", $roundOff);
												           $roundOff = $r[1]; 
												        }
												           else{ $sign = '+'; }
												          // echo $roundOff;
												           
												$ct = '15' - $i;
												//echo $ct;
											    for($c=0;$c<=$ct;$c++){
											        if($c==0){
												?>
												<tr style="border-style: hidden;border-right: 1px;border-left: 1px;border-top:1px">
												<?php }else if($c==$ct){    ?>
												<tr style="border-style: hidden;border-right: 1px;border-left: 1px;border-bottom:1px">
												<?php }else{ ?>
												<tr style="border-style: hidden;border-right: 1px;border-left: 1px;">
												<?php } ?>
													<td class="text-center" style="border-top: 0px;border-bottom: 0px;"></td>
													<td style="border-top: 0px;border-bottom: 0px;">
														<div align="right" style="margin-right:10px;"><br /></div>
													</td>
													<td colspan="3" class="text-center" style="border-top: 0px;border-bottom: 0px;"></td>
													<td style="border-top: 0px;border-bottom: 0px;">
														<div style="text-align: center;"></div>
													</td>
													<td colspan="2" style="border-top: 0px;border-bottom: 0px;">
													</td>
												</tr>
											<?php }	?>
											    <tr>
													<td class="text-center"></td>
													<td>
														<div align="right" style="margin-right:10px;"><br /></div>
													</td>
													<td colspan="3" class="text-center"></td>
													<td>
														<div style="text-align: right;">Sub Total<br />Discount</div>
													</td>
													<td colspan="2" class="text-end">
														<?= number_format($totalPrice, 2) ?><br />
														<?= '(-)'. number_format($discprice, 2) ?><br />
													</td>
												</tr>
												
												<?php 
												// echo $shipstate;
												if($row2['StateID'] == $shipstate){ ?>
												<tr>
													<td class="text-center"></td>
													<td>
														<div align="right" style="margin-right:10px;"><br /></div>
													</td>
													<td colspan="3" class="text-center"></td>
													<td>
														<div style="text-align: right;">Total<br/>CGST<br />SGST<br />Shipping Chrgs<br />Round Off</div>
													</td>
													<td colspan="2" class="text-end">
														
														<?= number_format($finalprice, 2) ?><br />
														<?= number_format($totalGst / 2, 2) ?><br />
														<?= number_format($totalGst / 2, 2) ?><br />
														<?= number_format(empty($row1['TransportPrice']) ? '0' : $row1['TransportPrice'], 2) ?><br />
														<?= '('.$sign.')'. number_format($roundOff, 2) ?><br />
													</td>
												</tr>
												<?php } else{ ?>
												<tr>
													<td class="text-center"></td>
													<td>
														<div align="right" style="margin-right:10px;"><br /></div>
													</td>
													<td colspan="3" class="text-center"></td>
													<td>
														<div style="text-align: right;">Total<br/>IGST<br />Shipping Chrgs<br />Round Off</div>
													</td>
													<td colspan="2" class="text-end">
														
														<?= number_format($finalprice, 2) ?><br />
														<?= number_format($totalGst, 2) ?><br />
														<?= number_format(empty($row1['TransportPrice']) ? '0' : $row1['TransportPrice'], 2) ?><br />
														<?= '('.$sign.')'. number_format($roundOff, 2) ?><br />
													</td>
												</tr>
												<?php } ?>
												
												<tr>
													<td class="text-center"></td>
													<td class="text-end">Total</td>
													<td class="text-center"></td>
													<td style="margin-right:10px;" class="text-end"><?= $totalQuantity ?> NOS</td>
													<td class="text-end"></td>
													<td></td>
													
													<?php if($sign == '+'){ 
													//echo number_format($finalprice + $totalGst + $roundOff +  number_format($row1['TransportPrice'],2),2);\
												 	$finalvalue = number_format($finalprice + $totalGst +$roundOff+ number_format(empty($row1['TransportPrice']) ? '0' : $row1['TransportPrice']));
													
													$secondfinalvalue = number_format($finalprice + $totalGst - $roundOff + number_format(empty($row1['TransportPrice']) ? '0' : $row1['TransportPrice']));
													//echo $finalvalue;
													?>
													<td colspan="2" class="text-end">₹ <?= number_format(($finalprice + $totalGst +$roundOff+ number_format(empty($row1['TransportPrice']) ? '0' : $row1['TransportPrice'],2)), 2) ?></td>
													<?php }else{
													    $finalvalue = number_format($finalprice + $totalGst - $roundOff+ number_format(empty($row1['TransportPrice']) ? '0' : $row1['TransportPrice']));
													?>
													<td colspan="2" class="text-end">₹ <?= number_format(($finalprice + $totalGst - $roundOff + number_format(empty($row1['TransportPrice']) ? '0' : $row1['TransportPrice'],2)), 2) ?></td>
													<?php }
													$num =  str_replace( ',', '', $finalvalue );
													?>
												</tr>
												<tr>
												    <?php if($sign == '+'){ 
												        
												    ?>
													<td colspan="8">Amount Chargeable (in words)<br /><strong class="h4">INR <?= numberToWords($num) ?></strong></td>
													<?php }else{
													?>
													<td colspan="8">Amount Chargeable (in words)<br /><strong class="h4">INR <?= numberToWords($num) ?></strong></td>
													<?php } ?>
												</tr>
												<tr>
													<td class="text-center"></td>
													<td>HSN/SAC</td>
													<td class="text-center">Taxable Value</td>
													<?php if($row2['StateID'] == $shipstate){ ?>
													<td class="text-center" colspan="2" class="text-end">Central Tax</td>
													<td class="text-center" colspan="2" class="text-end">State Tax</td>
													<?php }else{ ?>
													<td class="text-center" colspan="2" class="text-end">Integrated Tax</td>
													<?php } ?>
													<td colspan="2">Total </td>
												</tr>
												<tr>
													<td class="text-center"></td>
													<td></td>
													<td class="text-center"></td>
													<?php if($row2['StateID'] == $shipstate){ ?>
													<td>Rate</td>
													<td>Amount</td>
													<td>Rate</td>
													<td>Amount</td>
													<?php }else{ ?>
													<td>Rate</td>
													<td>Amount</td>
													<?php } ?>
													<td colspan="2">Tax Amount</td>
												</tr>
                                                <?php
                                                    // Initialize the variables
                                                    $gstTotal = 0;
                                                    $cgstTotalAmount = 0;
                                                    $sgstTotalAmount = 0;
                                                    $totalProductAmount = 0;
                                                    
                                                    // Get the data from the database
                                                    $result4 = mysqli_query($conn, "SELECT * FROM OrderItems oi, productdetails pd, BrandCategory c, BrandSubCategory sc, BrandModel m, ProductColors pc WHERE oi.ProductID = pd.ProductID AND pd.CategoryID = c.CategoryID AND pd.SubCategoryID = sc.SubCategoryID AND pd.ModelID = m.ModelID AND pc.ColorID = pd.ProductColorID AND oi.OrderID = '$orderId'") or die(mysqli_error($conn));
                                                    
                                                    $data = array();
                                                    
                                                    // Fetch and prepare the data
                                                    while ($row4 = mysqli_fetch_assoc($result4)) {
                                                        $result5 = mysqli_query($conn, "SELECT * FROM Discounts WHERE DiscountID = {$row4['Discount']}");
                                                        $row5 = mysqli_fetch_assoc($result5);
                                                        $totalPrice = $row4['ProductAmount'] * $row4['ProductQuantity'];
                                                        $amount = $totalPrice - ($totalPrice * ($row5['DiscountPercent'] / 100));
                                                        $data[] = array(
                                                            'hsn' => $row4['HSNCode'],
                                                            'gst' => $row4['GSTPercent'],
                                                            'amount' => $amount,
                                                        );
                                                    }
                                                    
                                                    // Step 1: Sort the data by HSN code (ascending order)
                                                    usort($data, function ($a, $b) {
                                                        return $a['hsn'] <=> $b['hsn'];
                                                    });
                                                    
                                                    // Step 2: Consolidate data with the same HSN code
                                                    $d = array();
                                                    foreach ($data as $item) {
                                                        // Check if the item is already in the $d array (by HSN)
                                                        if (isset($d[$item['hsn']])) {
                                                            // If the HSN code exists, accumulate the amount
                                                            $d[$item['hsn']]['amount'] += $item['amount'];
                                                        } else {
                                                            // If it's a new HSN code, add it to the array
                                                            $d[$item['hsn']] = array(
                                                                'hsn' => $item['hsn'],
                                                                'gst' => $item['gst'],
                                                                'amount' => $item['amount'],
                                                            );
                                                        }
                                                    }
                                                    
                                                    // Step 3: Calculate totals and output the table
                                                    foreach ($d as $item) {
                                                        $totalProductAmount += $item['amount'];
                                                        $gstTotal += ($item['amount'] * ($item['gst'] / 100));
                                                    ?>
                                                    <tr>
                                                        <td class="text-center"></td>
                                                        <td><?= $item['hsn'] ?></td>
                                                        <td class="text-center"><?= number_format($item['amount'], 2) ?></td>
                                                        <?php if ($row2['StateID'] == $shipstate) { ?>
                                                            <td><?= ($item['gst'] / 2) ?>%</td>
                                                            <td><?= number_format(($item['amount'] * ($item['gst'] / 100)) / 2, 2) ?></td>
                                                            <td class="text-center"><?= ($item['gst'] / 2) ?>%</td>
                                                            <td><?= number_format(($item['amount'] * ($item['gst'] / 100)) / 2, 2) ?></td>
                                                        <?php } else { ?>
                                                            <td class="text-center"><?= $item['gst'] ?>%</td>
                                                            <td><?= number_format($item['amount'] * ($item['gst'] / 100), 2) ?></td>
                                                        <?php } ?>
                                                        <td colspan="2"><?= number_format($item['amount'] * ($item['gst'] / 100), 2) ?></td>
                                                    </tr>
                                                    <?php
                                                    }
                                                    
                                                    // Final GST Calculation (for totals)
                                                    $finalvalue1 = number_format($gstTotal, 2);
                                                    $num1 = str_replace(',', '', $finalvalue1);
                                                    ?>

<tr>
													<td class="text-center"></td>
													<td>Total</td>
													<td class="text-center"><?= number_format($totalProductAmount, 2) ?></td>
													<td></td>
													<?php if($row2['StateID'] == $shipstate){ ?>
													<td><?= number_format($gstTotal / 2, 2) ?></td>
													<td class="text-end"></td>
													<td><?= number_format($gstTotal / 2, 2) ?></td>
													<?php } else{ ?>
													<td><?= number_format($gstTotal, 2) ?></td>
													<?php } ?>
													<td colspan="2"><?= number_format($gstTotal, 2) ?></td>
												</tr>
												<tr>
													<td colspan="8">Tax Amount (in words) : <strong class="h4">INR <?= numberToWords($num1) ?></strong></td>
												</tr>
											</tbody>
										</table>
										<div class="row mt-4" style="margin-right:0px;margin-left:0px;place-content: center;width:100%">
											<div class="row col-md-12" style="font-size:12px">
												<div class="col-md-2">Company's PAN:</div>
												<div class="col-md-8"><strong>DJWPP0580E</strong></div>
											</div>
											<div class="row col-md-12 mb-4" style="font-size:12px">
												<div class="col-md-6">
													<div><u>Declaration</u></div>
													<div>We declare that this invoice shows the actual price of the goods described and that all <br>particulars are true and correct.</div>
												</div>
												<div class="col-md-6" style="font-size:12px">
													<label style="margin-left:10px;">Company's Bank Details</label>
													<table class="table col-sm-12 table-borderless table-responsive text-nowrap">
														<tbody>
															<tr>
																<td>Bank Name</td>
																<td>&nbsp;<strong>Bank of Baroda</strong></td>
															</tr>
															<tr>
																<td>A/c No.</td>
																<td>&nbsp;<strong>25230200001252</strong></td>
															</tr>
															<tr>
																<td>Branch & IFSC Code</td>
																<td>&nbsp;<strong>VASAI-EAST & BARB0VASEAS</strong></td>
															</tr>
														</tbody>
													</table>
												</div>
											</div>
										</div>
										<table class="table table-bordered text-nowrap" style="font-size:12px">
											<tr>
												<td style="width:50%">Customer's Seal and Signature</td>
												<td class="text-end" style="padding-right:2px;">for RAMDEV LED <br>
												<img src="<?= $row2['Signature'] ?>"style="width: 103px;">
													<div class="text-muted text-end">Authorized Signatory</div>
												</td>
											</tr>
										</table>
										<div class="text-center">This is Computer Generated Invoice</div>
									</div>
								</div>
							</div>
						</div>
						
					</div>
					
				</div>
				
			</div>
		</div>
		
	</div>
	
	<?php include('include/footer.php'); ?>
	
	</div>
	
		
	
<script>
    document.getElementById('generateButton').addEventListener('click', function() {
      // Choose the element that your invoice is rendered in.
      const element = document.getElementById('invoice');
      // Choose the element and save the PDF for your user.
      html2pdf().set({
        html2canvas: { scale: 2 },
        filename: 'invoice.pdf',
        jsPDF: { format: 'a3', orientation: 'portrait' }
      }).from(element).output("save").then(function(pdf) {
        // Create a download button
        const downloadButton = document.createElement('a');
        downloadButton.href = pdf.output('bloburl');
        downloadButton.download = 'invoice.pdf';
        downloadButton.innerText = 'Download Invoice';
        document.body.appendChild(downloadButton);
        // Print the generated PDF
        pdf.autoPrint();
      });
    });
  </script>

<a href="#top" id="back-to-top"><i class="fa fa-angle-up"></i></a>
	
	<script src="assets/js/jquery.min.js"></script>
	
	<script src="assets/plugins/bootstrap/js/popper.min.js"></script>
	<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
	
	<script src="assets/js/jquery.sparkline.min.js"></script>
	
	<script src="assets/js/circle-progress.min.js"></script>
	
	<script src="assets/plugins/input-mask/jquery.mask.min.js"></script>
	
	<script src="assets/plugins/sidemenu/sidemenu.js"></script>
	
	<script src="assets/plugins/sidebar/sidebar.js"></script>
	
	<script src="assets/plugins/p-scroll/perfect-scrollbar.js"></script>
	<script src="assets/plugins/p-scroll/pscroll.js"></script>
	<script src="assets/plugins/p-scroll/pscroll-1.js"></script>
	
	<script src="assets/js/themeColors.js"></script>
	
	<script src="assets/js/sticky.js"></script>
	
	<script src="assets/js/custom.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.10.1/html2pdf.bundle.js"></script>

</body>

</html>

Nama File / Folder	Size	Action
.well-known	--	NONE
Data_	--	NONE
assets	--	NONE
cgi-bin	--	NONE
include	--	NONE
uploads	--	NONE
.htaccess	0.274KB	Hapus Edit Rename
8Products.php	15.674KB	Hapus Edit Rename
MonthlyProducts.php	15.686KB	Hapus Edit Rename
add-brand.php	27.782KB	Hapus Edit Rename
add-vendor.php	42.001KB	Hapus Edit Rename
b-bclients1.php	9.329KB	Hapus Edit Rename
category.php	13.583KB	Hapus Edit Rename
color.php	11.327KB	Hapus Edit Rename
company.php	14.712KB	Hapus Edit Rename
delete_product_pdf.php	0.618KB	Hapus Edit Rename
discount-b2b.php	9.862KB	Hapus Edit Rename
discount-b2c.php	8.333KB	Hapus Edit Rename
discount-list.php	10.272KB	Hapus Edit Rename
generate-invoice-server.php	3.183KB	Hapus Edit Rename
invoice-list.php	10.6KB	Hapus Edit Rename
invoice22222.php	31.864KB	Hapus Edit Rename
invoicenew1.php	17.683KB	Hapus Edit Rename
offline-order-add.php	2.254KB	Hapus Edit Rename
offline-order-delete.php	0.338KB	Hapus Edit Rename
offline-order-server.php	1.695KB	Hapus Edit Rename
offline-order.php	30.544KB	Hapus Edit Rename
order-details.php	14.237KB	Hapus Edit Rename
order-item-details.php	7.875KB	Hapus Edit Rename
paidd.png	27.518KB	Hapus Edit Rename
product-list.php	8.904KB	Hapus Edit Rename
productreport.php	28.885KB	Hapus Edit Rename
save_image_order.php	1.284KB	Hapus Edit Rename
sms.js	2.603KB	Hapus Edit Rename
stockreport.php	24.525KB	Hapus Edit Rename
subcategory.php	13.671KB	Hapus Edit Rename
update-order-status.php	2.562KB	Hapus Edit Rename
update-user-role.php	0.306KB	Hapus Edit Rename
vijayinvoice.php	17.683KB	Hapus Edit Rename