Gecko [ www.ilwfwelfarefederation.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
1add-new-item.php	17.03 KB	-rw-r--r--
add-delivery-challan.php	10.46 KB	-rw-r--r--
add-estimate.php	23.75 KB	-rw-r--r--
add-expences-category.php	6.73 KB	-rw-r--r--
add-expences-item.php	10.97 KB	-rw-r--r--
add-expences.php	16.81 KB	-rw-r--r--
add-items.csv	28 B	-rw-r--r--
add-new-item.php	18.64 KB	-rw-r--r--
add-new-party.php	10.54 KB	-rw-r--r--
add-new-return.php	21.23 KB	-rw-r--r--
add-new-sale.php	9.53 KB	-rw-r--r--
add-new-vendor.php	10.08 KB	-rw-r--r--
add-parties.csv	38 B	-rw-r--r--
add-party.csv	28 B	-rw-r--r--
add-payment-due.php	11.23 KB	-rw-r--r--
add-payment-in.php	10.74 KB	-rw-r--r--
add-payment-out.php	8.78 KB	-rw-r--r--
add-purchase-detail.php	34.35 KB	-rw-r--r--
add-purchase-order.php	24.45 KB	-rw-r--r--
add-purchase-return.php	21.25 KB	-rw-r--r--
add-sale-detail.php	35.3 KB	-rw-r--r--
add-sale-order.php	10.22 KB	-rw-r--r--
adminer.php	465.43 KB	-rw-r--r--
ajax_add_item.php	785 B	-rw-r--r--
ajax_get_item.php	1.03 KB	-rw-r--r--
ajax_get_item1.php	284 B	-rw-r--r--
ajax_get_tax.php	872 B	-rw-r--r--
all-expences.php	4.89 KB	-rw-r--r--
all-item.php	33.57 KB	-rw-r--r--
all-parties.php	5.48 KB	-rw-r--r--
all-party.php	21.53 KB	-rw-r--r--
all-purchase-list.php	8.28 KB	-rw-r--r--
all-purchase-order.php	12.82 KB	-rw-r--r--
all-sale-invoice.php	30.85 KB	-rw-r--r--
all-sale-list.php	6.47 KB	-rw-r--r--
all-sale-order.php	15.67 KB	-rw-r--r--
all-transactions.php	7.73 KB	-rw-r--r--
all-vendor.php	20.5 KB	-rw-r--r--
balance-sheet.php	22.25 KB	-rw-r--r--
bank-statement.php	4.89 KB	-rw-r--r--
bank-transaction.php	4.97 KB	-rw-r--r--
bill-wise-profits.php	8.73 KB	-rw-r--r--
cash-flow.php	10.94 KB	-rw-r--r--
cash-transaction.php	4.46 KB	-rw-r--r--
convert-purchase-order-detail....	17.64 KB	-rw-r--r--
dashboard.php	117.9 KB	-rw-r--r--
day-book.php	3.78 KB	-rw-r--r--
day_book.php	7.87 KB	-rw-r--r--
delete_delivery_challan.php	288 B	-rw-r--r--
delete_estimate.php	267 B	-rw-r--r--
delete_expct.php	279 B	-rw-r--r--
delete_expences.php	263 B	-rw-r--r--
delete_expitm.php	277 B	-rw-r--r--
delete_item.php	264 B	-rw-r--r--
delete_party.php	258 B	-rw-r--r--
delete_paymin.php	269 B	-rw-r--r--
delete_paymout.php	274 B	-rw-r--r--
delete_primery_unit.php	265 B	-rw-r--r--
delete_purchase.php	270 B	-rw-r--r--
delete_purchase_order.php	284 B	-rw-r--r--
delete_purchase_return.php	281 B	-rw-r--r--
delete_return.php	260 B	-rw-r--r--
delete_sales.php	266 B	-rw-r--r--
delete_sales_item.php	181 B	-rw-r--r--
delete_secd_unit.php	270 B	-rw-r--r--
delete_taxrate.php	257 B	-rw-r--r--
delete_vendor.php	258 B	-rw-r--r--
delivery-challan.php	11.48 KB	-rw-r--r--
discount-report.php	4.81 KB	-rw-r--r--
edit-delivery-challan.php	22.32 KB	-rw-r--r--
edit-estimate.php	22.26 KB	-rw-r--r--
edit-expences-detail.php	19.06 KB	-rw-r--r--
edit-firm.php	7.62 KB	-rw-r--r--
edit-new-return.php	23.71 KB	-rw-r--r--
edit-payment-out.php	6.23 KB	-rw-r--r--
edit-purchase-detail.php	36.19 KB	-rw-r--r--
edit-purchase-order-detail.php	17.66 KB	-rw-r--r--
edit-purchase-return.php	23.69 KB	-rw-r--r--
edit-purchase-return1.php	10.56 KB	-rw-r--r--
edit-sale-detail.php	21.84 KB	-rw-r--r--
edit-sale-order-detail.php	17.72 KB	-rw-r--r--
edit-sale-order.php	10.39 KB	-rw-r--r--
edit_expct.php	293 B	-rw-r--r--
edit_expitm.php	291 B	-rw-r--r--
edit_item.php	616 B	-rw-r--r--
edit_party.php	284 B	-rw-r--r--
edit_paymtin.php	295 B	-rw-r--r--
edit_paymtout.php	299 B	-rw-r--r--
edit_primery_unit.php	288 B	-rw-r--r--
edit_secd_unit.php	290 B	-rw-r--r--
edit_taxrate.php	284 B	-rw-r--r--
edit_vendor.php	284 B	-rw-r--r--
estimate.php	15.65 KB	-rw-r--r--
expense-category-report.php	4.66 KB	-rw-r--r--
expense-item-report.php	5.04 KB	-rw-r--r--
expense-transaction.php	5.6 KB	-rw-r--r--
fetch_orders.php	1.87 KB	-rw-r--r--
fetch_profit_report.php	2.15 KB	-rw-r--r--
fetch_purchase_data.php	2.74 KB	-rw-r--r--
fetch_transactions.php	5.04 KB	-rw-r--r--
fixed-assets-transaction-summa...	6.73 KB	-rw-r--r--
form-number-27EQ.php	4.87 KB	-rw-r--r--
get_balance.php	631 B	-rw-r--r--
get_conversion_rate.php	570 B	-rw-r--r--
get_due_amt.php	654 B	-rw-r--r--
get_due_amt1.php	1.14 KB	-rw-r--r--
get_gst_price.php	503 B	-rw-r--r--
get_item_expences.php	290 B	-rw-r--r--
get_qty.php	793 B	-rw-r--r--
get_unit_price.php	2.17 KB	-rw-r--r--
get_unit_price1.php	441 B	-rw-r--r--
gst-rate-report.php	5.25 KB	-rw-r--r--
gst-report.php	4.99 KB	-rw-r--r--
home.php	1.58 KB	-rw-r--r--
import-item.php	6.11 KB	-rw-r--r--
import-parties.php	5.88 KB	-rw-r--r--
index.php	19.06 KB	-rw-r--r--
invoice-estimate-detail.php	57.5 KB	-rw-r--r--
invoice-sale-detail.php	30.75 KB	-rw-r--r--
invoice.php	30.14 KB	-rw-r--r--
item-detail.php	4.75 KB	-rw-r--r--
item-report-by-party.php	5.74 KB	-rw-r--r--
item-wise-profit-lose.php	6.4 KB	-rw-r--r--
itemwise-discount.php	5.98 KB	-rw-r--r--
logout.php	128 B	-rw-r--r--
low-stock-summary.php	4.31 KB	-rw-r--r--
manage-stocks.php	5.04 KB	-rw-r--r--
other-assets-transaction-summa...	7.18 KB	-rw-r--r--
parties-report-by-item.php	6.68 KB	-rw-r--r--
party-statement.php	24.88 KB	-rw-r--r--
party-wise-profit-lose.php	5.42 KB	-rw-r--r--
payment-in.php	21.54 KB	-rw-r--r--
payment-out.php	21.76 KB	-rw-r--r--
primery-units.php	7.97 KB	-rw-r--r--
purchase-return.php	13.37 KB	-rw-r--r--
return.php	13.06 KB	-rw-r--r--
sale-or-purchase-report-by-ite...	4.78 KB	-rw-r--r--
sale-order-item.php	5.48 KB	-rw-r--r--
sale-orders.php	5.95 KB	-rw-r--r--
sale-purchase-by-party-group.p...	4.26 KB	-rw-r--r--
sale-purchase-by-party.php	4.98 KB	-rw-r--r--
secondary-units.php	7.95 KB	-rw-r--r--
sidebar.php	13.08 KB	-rw-r--r--
stock-detail.php	6.22 KB	-rw-r--r--
stock-summary-report-by-item-c...	3.04 KB	-rw-r--r--
stock-summary.php	5.27 KB	-rw-r--r--
tax-rate.php	7.05 KB	-rw-r--r--
tcs-receivable.php	4.86 KB	-rw-r--r--
tds-payable.php	5.09 KB	-rw-r--r--
tds-receivable.php	5.1 KB	-rw-r--r--
trial-balance-report.php	25.47 KB	-rw-r--r--
update_items.php	3.13 KB	-rw-r--r--
update_vendor.php	2.36 KB	-rw-r--r--
view-all-party-transaction-det...	5.64 KB	-rw-r--r--
view-balance-details.php	5.93 KB	-rw-r--r--
view-purchase-detail.php	10.26 KB	-rw-r--r--
view-purchase-order-detail.php	8.29 KB	-rw-r--r--
view-sale-detail.php	9.19 KB	-rw-r--r--
view_item.php	485 B	-rw-r--r--
view_party.php	284 B	-rw-r--r--
view_vendor.php	285 B	-rw-r--r--

Code Editor : invoice-sale-detail.php

<?php include("includes/db_config.php"); ?>
<!DOCTYPE html>
<html lang="en" dir="ltr" data-theme="light">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />

<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<?php include("includes/css.php");?>
<style>
.modal-body .form-label {
font-weight: 600;
}

.viewptdt .form-label {
font-weight: 600;
}

.viewptdt label {
margin-top: 10px;
}
</style>
</head>
<?php function getIndianCurrency(float $number)
{
$decimal = round($number - ($no = floor($number)), 2) * 100;
$hundred = null;
$digits_length = 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_length ) {
$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;
}
$Rupees = implode('', array_reverse($str));
$paise = ($decimal > 0) ? "." . ($words[$decimal / 10] . " " . $words[$decimal % 10]) . ' Paise' : '';
return ($Rupees ? $Rupees . 'Rupees ' : '') . $paise;
} ?>

<tr>
<td>
<table style="width:880px;border:solid 1px #fff;padding:0px" cellpading="0" cellspacing="0">
<tbody>
<tr>
<th style="border-bottom: 2px solid #000;">
<h3 class="portlet-title text-center" style="line-height:16px;">Tax Invoice</h3>
</th>
</tr>

<?php $idd=$_GET['id'];
$sql="select * from tbl_ah_items where type ='Sale' And id='".$idd."'"; 
$result = mysqli_query($conn, $sql); 
$res= mysqli_fetch_array($result);
$cid=$res['customer_id'];
$sqlpt=mysqli_query($conn,"SELECT * from ah_party where id='".$cid."'");
$restpy=mysqli_fetch_array($sqlpt); ?>
<tr>
<td style="height:20px;color:#000000;width:80px; padding-left:5px; vertical-align:top;font-size:12px;" colspan="1"><img src="images/logo.jpg" alt="beyondaimindustries.com" style="width:152px;"></td>

<td style="height:16px;background-color:#f8f8f8;line-height:16px;vertical-align:top;color:#000000;width:350px; padding:3px 3px; font-size:17px;" colspan="8"> <strong style="font-size:26px;">BEYOND AIM INDUSTRIES,</strong><br /> #22-7-557/2, Lane beside Clock Tower, Mir Alam Mandi, Hyderabad, Telangana, INDIA<br /><strong>Pin Code :</strong> 500002<br />
<strong>Phone:</strong> +91-9666068266 | +91-9346072844<br />
<strong>Email-Id:</strong> info@beyondaimindustries.com<br />
<strong>Website:</strong> www.beyondaimindustries.com<br /><strong>GSTIN:</strong> 36ACIPM4388F2ZA, <strong>BANK DETAILS : </strong> State Bank Of India, Dabeerpura Branch
</td>
<td class="invoice-col" colspan="2" style="text-align: right;vertical-align: top;background-color: #f8f8f8;padding-right: 0px;font-size:14px;font-weight:bold">
<table border="1" cellpading="0" cellspacing="0" class="table table-bordered" style="margin-bottom:0px">
<tr>
<td style="border:2px solid #000;font-weight:bold;padding:.12rem .75rem">Invoice No. :</td>
<td style="border:2px solid #000;padding:.12rem .75rem"><?= $res['bill_no'];?></td>
</tr>
<tr>
<td style="border:2px solid #000;font-weight:bold;padding:.12rem .75rem">Invoice Date :</td>
<td style="border:2px solid #000;padding:.12rem .75rem">

<?php echo $original_date = $res['bill_date'];

</td>
</tr>
<tr>
<td style="border:2px solid #000;font-weight:bold;padding:.12rem .75rem">Invoice Time :</td>
<td style="border:2px solid #000;padding:.12rem .75rem"><?php  $date=$res['created_date'];  echo $Date = date("h:i:s", strtotime($date));  ?></td>
</tr>
<tr>
<td style="border:2px solid #000;font-weight:bold;padding:.12rem .75rem">Dispatch Through :</td>
<td style="border:2px solid #000;padding:.12rem .75rem"><?= $res['dispatch_through'];?> </td>
</tr>
<tr>
<td style="border:2px solid #000;font-weight:bold;font-size: 18px;padding:.12rem .75rem"><strong>Total Amt. :</strong></td>
<td style="border:2px solid #000;font-size: 18px;padding:.12rem .75rem"><strong>₹ <?php $ttl=$res['total_amt'];
 echo round($ttl); ?>.00</strong></td>
</tr>
</table>

</td>
</tr>

<tr style="border-top:2px solid #000;">
<td style="height:20px;color:#000000;width:80px; padding-left:5px; vertical-align:top;font-size:14px;border-bottom:2px solid #000" colspan="11"><strong>Account Name :</strong> BEYOND AIM INDUSTRIES &nbsp; <strong>Account No. : </strong> 43184234542 &nbsp; <strong>IFSC Code : </strong>SBIN0020413 &nbsp; <strong>UPI No. : </strong> 9666068266 </td>
</tr>
<tr style="border-top:2px solid #000">
<td colspan="11">
<table border="1" cellspacing="0" cellpadding="0" style="width:100%">
<tr>
<td style="height:20px;background-color:#f8f8f8;color:#000000;padding:4px;border-top: 1px solid #000;font-size:13px;border-bottom:2px solid #000;vertical-align:top;width:50%;line-height:17px;" colspan="6">
<strong style="color:#000">BILL TO :</strong>
<address style="margin-bottom:0px">
<strong><?= $restpy['party_name'];?></strong><br>
<?= $restpy['billing_address'];?><br />
<strong>Phone: </strong> +91-<?= $restpy['party_phone_no'];?><br />
<strong>GSTIN: </strong> <?=$restpy['gst_no'];?><br />
<?php if(!empty($restpy['email_id'])){ ?>
<strong> </strong> <br><?php } ?>
</address>

</td>
<?php if(!empty($restpy['shipping_address'])){ ?>
<td style="height:20px;border-left: 2px solid #000;border-bottom: 2px solid #000; background-color:#f8f8f8;color:#000000; padding:4px; font-size:13px;vertical-align:top;width:50%;line-height:17px;" colspan="6">
<strong style="color:#000">SHIP TO :</strong>
<address style="margin-bottom:0px">
<strong><?= $restpy['party_name'];?></strong><br>
<?= $restpy['shipping_address'];?><br />
<strong>Phone: </strong> +91-<?= $restpy['party_phone_no'];?><br />
<strong>GSTIN: </strong> <?=$restpy['gst_no'];?><br />
<?php if(!empty($restpy['email_id'])){ ?>
<strong> </strong> <br><?php } ?>
</address>
</td>
<?php } ?>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td>
<table style="font-size:11px;border:2px solid #000" width="100%" align="center" cellspacing="0" cellpadding="0" border="1">
<tbody>
<tr>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:left;background-color:#eaeaea;line-height:12px;padding-left:3px;font-weight:bold;width:20px;border-left:0px solid #000;border-right:2px solid #000;padding-left:2px;padding-right:2px;border-bottom:1px solid #000;">S. <br/>No.</td>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;font-weight:bold;width:280px;padding-left:2px;padding-right:2px;border-right:2px solid #000;border-bottom:1px solid #000">
Description Of Goods
</td>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;padding-left:2px;padding-right:2px;font-weight:bold;width:150px;border-right:2px solid #000;border-bottom:1px solid #000">
HSN/SAC
</td>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;padding-left:2px;padding-right:2px;font-weight:bold;width:150px;border-right:2px solid #000;border-bottom:1px solid #000">
GST
</td>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;padding-left:2px;padding-right:2px;font-weight:bold;width:150px;border-right:2px solid #000;border-bottom:1px solid #000">
Unit
</td>

<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;padding-left:2px;padding-right:2px;font-weight:bold;width:150px;border-right:2px solid #000;border-bottom:1px solid #000">
Rate <br /><small>(Excl. Of Tax)</small>
 </td>

<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;font-weight:bold;width:40px;padding-left:2px;padding-right:2px;border-right:2px solid #000;border-bottom:1px solid #000">
Per
</td> 
<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;font-weight:bold;width:150px;padding-left:2px;padding-right:2px;border-right:2px solid #000;border-bottom:1px solid #000">
Disc.(%)
</td>

<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;font-weight:bold;width:150px;padding-left:2px;padding-right:2px;border-right:2px solid #000;border-bottom:1px solid #000" colspan="2">
Amount</td> 
<td style="font-family:Arial,Helvetica,sans-serif;font-size:12px;line-height:18px;color:#000000;text-align:center;background-color:#eaeaea;line-height:12px;padding-left:3px;font-weight:bold;padding-left:2px;padding-right:2px;width:150px;border-bottom:1px solid #000" colspan="2">Total Amount
</td>
</tr>
<?php $sid=$res['id']; $i=1;
$sqlsl=mysqli_query($conn,"select ads.*,ait.item_name,ait.item_hsn,ait.sunit,ait.sale_price,ait.conversion_rate from sale_item_details ads join ah_item_details ait on ads.item_name=ait.id where ads.sale_id='".$sid."'");
$summary = [];
$summary1 = [];
$ctax=0;
$stax=0;
$tamt=0;
while($resl= mysqli_fetch_array($sqlsl)){ 
$slid=$resl['unit'];
$slids=$resl['units'];
$sslids=$resl['sunit'];
$tid=$resl['tax_rate'];
$sqlfts=mysqli_fetch_array(mysqli_query($conn,"select * from primery_unit where id='".$slid."'"));
$sqlsslids=mysqli_fetch_array(mysqli_query($conn,"select * from primery_unit where id='".$sslids."'"));
$sqlscs=mysqli_fetch_array(mysqli_query($conn,"select * from secondary_unit where id='".$slids."'"));
$sqlts=mysqli_fetch_array(mysqli_query($conn,"select * from tax_rate where id='".$tid."'"));
if(!empty($sqlts['tax_gst'])){
$tax=$sqlts['tax_gst'];
$uprc=$resl['price_unit'];
$prc =$resl['price_unit'] * $resl['quantity'];

$prrtrc=$resl['quantity'];
$perqqty=$resl['quantity'] / $resl['quantity']; 
$perqqtytotl=$resl['quantity'] / $resl['quantity'];
$rtyuh=$resl['quantity'];

if(!empty($resl['discount'])){
$dis=$resl['discount'];
$dis_pre = ($prc * ($dis / 100));
$dis_price = $prc - $dis_pre;
$tax_rate=filter_var($tax, FILTER_SANITIZE_NUMBER_INT);
$taxtd=$dis_price*$tax_rate/100; 
$txprices=$taxtd/2;
}else{
$dis=0;
}
$tamt += isset($dis_price)?$dis_price:$resl['price_unit'] * $resl['quantity'];
$tax_rate=filter_var($tax, FILTER_SANITIZE_NUMBER_INT);
$totalunit = $resl['conversion_rate']  * $resl['quantity'];
$summary[$sqlfts['short_name']] += $resl['quantity'];
$summary1[$sqlsslids['short_name']] += $totalunit;
$tvelue=$prc*$tax_rate;
$utaxs=$uprc*$tax_rate/100; 
$taxs=$uprc + $utaxs; 
$txprc=$utaxs/2;
$tsg=$tax_rate/2;
$prtaxs=$prc*$tax_rate/100;
$prctax=$prc*$tsg/100;

$ctax += $txprices;
}else{
$dis_pre=0; $taxtd=0; $tax=0; $taxs=0; $tsg=0;
} ?>
<tr style="border-top:2px solid #000;font-weight:bold;height:30px">
	
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;text-transform:uppercase;text-align:center;font-size: 14px;vertical-align:top;padding-left:2px;padding-right:2px;"><?php echo $i; $i++; ?>. </td>
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;text-transform:capitalize;font-size: 14px;vertical-align:top;padding-left:2px;padding-right:10px;"><?= $resl['item_name'];?></td>
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;font-size: 14px;padding-left:2px;padding-right:2px;vertical-align:top;"><?= $resl['item_hsn'];?></td>
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;font-size: 14px;padding-left:2px;padding-right:2px;vertical-align:top;"><?= $sqlts['tax_gst']; ?></td>
 <td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;font-size: 14px;padding-left:2px;padding-right:2px;vertical-align:top;text-align: center;"><?= $resl['quantity']; ?>&nbsp;<?= $sqlfts['short_name'];?></td>

 <td style="vertical-align:top;padding-left:2px;padding-right:2px;border-right:2px solid #000;background:#fff;color:#000000;padding:2px 10px;font-size: 14px;"><?= $resl['price_unit']?></td> 

<td style="border-right:2px solid #000;background:#fff;vertical-align:top;color:#000000;padding:2px 20px;font-size: 14px;padding-left:2px;padding-right:2px;text-align:right"> <?= $perqqty;?> Ctn</td>
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;padding-left:2px;padding-right:2px;vertical-align:top;text-transform:uppercase;vertical-align:top;font-size: 14px;text-align:right;"> <?= $dis_pre;?><br>(<?= $resl['discount'];?>%)</td>
<td style="border-right:2px solid #000; background:#fff;padding-left:2px;padding-right:2px;color:#000000;padding:2px px;text-transform:uppercase;font-size: 18px;vertical-align:top;padding-left:2px;text-align:right;padding-right:2px;" colspan="2"> <?= $prc;?></td>
<td style="border-right:2px solid #000; background:#fff;padding-left:2px;padding-right:2px;color:#000000;padding:2px px;text-transform:uppercase;font-size: 18px;vertical-align:top;padding-left:2px;text-align:right;padding-right:2px;" colspan="2"> <?= isset($dis_price)?$dis_price:'';?></td>
</tr>
<?php } ?>

<tr style="border-top:2px solid #000;font-weight:bold;height:30px">
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;text-transform:uppercase;font-size: 14px;vertical-align:top;padding-left:2px;padding-right:2px;"> </td>
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;text-transform:capitalize;font-weight:bold;font-size: 14px;padding-left:2px;padding-right:2px;text-align:right">CGST&nbsp;@&nbsp;<?= $tsg; ?>%</td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right"></td>

<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;font-size: 14px;font-weight:bold;padding-left:2px;text-align:right;padding-right:2px;"><?= $tsg;?></td>
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;padding-left:2px;padding-right:2px;font-size: 14px;text-align:right;font-weight:bold;" colspan="2">%</td>

<td style="border-right:0px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;font-weight:bold;text-align:right;"><?= number_format($txprices,2);?></td>
</tr>
<tr>
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;text-transform:uppercase;font-size: 14px;vertical-align:top;padding-left:2px;padding-right:2px;"> </td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right;">SGST&nbsp;@&nbsp;<?= $tsg; ?>%</td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right"></td>

<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;font-weight:bold;text-align:right;"><?= $tsg;?></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;font-weight:bold;text-align:right" colspan="2">%</td>

<td style="border-right:0px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;font-weight:bold;text-align:right"><?= number_format($txprices,2);?></td>
</tr>
<tr>
<td style="border-right:2px solid #000;background:#fff;color:#000000;padding:2px 20px;text-transform:uppercase;font-size: 14px;vertical-align:top;padding-left:2px;padding-right:2px;"> </td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;text-transform:capitalize;font-weight:bold;font-size: 14px;text-align:right">Round Off</td>

<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;text-align:right;font-weight:bold;"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;text-align:right;font-weight:bold;"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;text-align:right;font-weight:bold;"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;text-align:right;font-weight:bold;"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;text-align:right;font-weight:bold;"></td>
<td style="border-right:2px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;font-weight:bold;text-align:right" colspan="2"></td>

<td style="border-right:0px solid #000;padding-left:2px;padding-right:2px;background:#fff;color:#000000;padding:2px 2px;font-size: 14px;font-weight:bold;text-align:right"><?php $ttl=$res['total_amt'];
 $rttl= round($ttl); $ttl_amt = $rttl - $ttl; ?></td>
</tr>
<?php $sqlsls=mysqli_query($conn,"select SUM(amount) as ttl from sale_item_details where sale_id='".$sid."'");
$resls= mysqli_fetch_array($sqlsls); 
$sqlds=mysqli_fetch_array(mysqli_query($conn,"select SUM(discount) as disc from sale_item_details where sale_id='".$sid."'"));
$sqlqt=mysqli_fetch_array(mysqli_query($conn,"select SUM(quantity) as qty from sale_item_details where sale_id='".$sid."'"));
$sqlqts=mysqli_fetch_array(mysqli_query($conn,"select SUM(qtys) as qtys from sale_item_details where sale_id='".$sid."'"));
?>
<tr style="border-top:2px solid #000">
<td style="font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:18px;color:#000000;text-align:left;background-color:#fff;line-height:18px;padding-left:3px;font-weight:bold;width:70px;border-right:2px solid #000;" colspan="4">
Invoice Amount In Words</td>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:18px;color:#000000;text-align:left;background-color:#fff;line-height:18px;padding-left:3px;font-weight:bold;width:70px;border-right:2px solid #000;text-align:center"> <?php echo implode(" + ", array_map(fn($q, $s) => "$q $s", $summary, array_keys($summary)));;?></td>

<td style="font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:18px;color:#000000;text-align:right;background-color:#fff;line-height:18px;padding-left:3px;font-weight:bold;width:50px;border-left:1px solid #000;border-right:2px solid #000;" colspan="2">
Sub Total&nbsp;:
</td>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:16px;line-height:18px;color:#000000;text-align:center;background-color:#fff;line-height:18px;padding-left:3px;text-align:right;font-weight:800;width:50px" colspan="3">
₹ <?php $ttl=$res['total_amt'];
 echo number_format($ttl,2); ?>&nbsp;</td>
</tr>
<tr style="border-top:2px solid #000">
<td style="font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:18px;color:#000000;text-align:left;background-color:#fff;line-height:18px;padding-left:3px;font-weight:500;width:70px;text-transform:capitalize" colspan="5"><?=  getIndianCurrency($ttl); ?> Only</td>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:14px;line-height:18px;color:#000000;text-align:right;background-color:#fff;line-height:22px;padding-left:3px;font-weight:bold;border-right:1px solid #000;border-left:1px solid #000;width:70px" colspan="2">
Total :
</td>
<td style="font-family:Arial,Helvetica,sans-serif;font-size:16px;line-height:18px;color:#000000;text-align:center;background-color:#fff;line-height:18px;padding-left:3px;font-weight:800;width:70px;text-align:right;" colspan="3">
₹ <?php $ttl=$res['total_amt'];
 echo number_format($ttl,2); ?>&nbsp;</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr style="background:#fff;width:100%;border:2px solid #000;">
<td style="color:#000000;vertical-align:top;width:40%;font-family:Arial,Helvetica,sans-serif;font-size:13px;padding:1px 2px 1px 5px" colspan="4">
<b> GST Information</b>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <strong style="text-align:right">E & O.E.</strong><br />
<table style="font-size:11px;text-align:center;border:2px solid #000" width="100%" align="center">
<tbody>
<tr style="font-weight:600">
<th style="font-weight:bold;background-color:#eaeaea;width:20px;border-right:2px solid #000;border-bottom:1px solid #000;">CGST(%)</th>
<th style="font-weight:bold;background-color:#eaeaea;width:20px;border-right:2px solid #000;border-bottom:1px solid #000;">Taxable Value</th>
<th style="font-weight:bold;background-color:#eaeaea;width:20px;border-right:0px solid #000;border-bottom:1px solid #000;">Tax Value</th>
</tr>
<tr style="border-top:2px solid #000;font-weight:bold;">
<td style="border-right:2px solid #000;background:#fff;height:20px;color:#000000;padding:2px 20px;text-transform:capitalize;font-size: 12px;"><?= $tsg;?>%</td>
<td style="border-right:2px solid #000;background:#fff;height:20px;color:#000000;padding:2px 20px;text-transform:capitalize;font-size: 12px;"><?= number_format($tamt,2);?></td>
<td style="border-right:0px solid #000;background:#fff;height:20px;color:#000000;padding:2px 20px;text-transform:capitalize;font-size: 12px;"><?= number_format($ctax,2);?></td>
</tr>
</tbody>
</table>
<table style="font-size:11px;text-align:center;border:2px solid #000;margin-top:10px;" width="100%" align="center">
<tbody>
<tr style="">
<th style="font-weight:bold;background-color:#eaeaea;width:20px;border-right:2px solid #000;border-bottom:1px solid #000;">SGST(%)</th>
<th style="font-weight:bold;background-color:#eaeaea;width:20px;border-right:2px solid #000;border-bottom:1px solid #000;">Taxable Value</th>
<th style="font-weight:bold;background-color:#eaeaea;width:20px;border-right:0px solid #000;border-bottom:1px solid #000;">Tax Value</th>
</tr>
<tr style="border-top:2px solid #000;font-weight:bold;">
<td style="border-right:2px solid #000;background:#fff;height:20px;color:#000000;padding:2px 20px;text-transform:capitalize;font-size: 12px;"><?= $tsg;?>%</td>
<td style="border-right:2px solid #000;background:#fff;height:20px;color:#000000;padding:2px 20px;text-transform:capitalize;font-size: 12px;"><?= number_format($tamt,2);?></td>
<td style="border-right:0px solid #000;background:#fff;height:20px;color:#000000;padding:2px 20px;text-transform:capitalize;font-size: 12px;"><?= number_format($ctax,2);?></td>
</tr>
</tbody>
</table>
</td>

<p class="text-justify" style="margin-top:0px;margin-bottom:0px;">
<u><b>Declaration :</b></u> We declare that this invoice shows the actual price of the goods described are and that all particulars are true and correct(Jurisdiction Hyderabad). In case you need any assistance please do not hesitate to call our customer service on
<a href="tel:09666068266" style="color:#000;font-size:12px;text-decoration:none; font-weight:600">+91-9666068266</a> at 10:00 am to 10:00 pm on all days or email us at
<a href="mailto:info@beyondaimindustries.com" style="color:#000;font-size:12px;text-decoration:none; font-weight:800" target="_blank">info@<span class="il">beyondaimindustries</span>.com
</a> All calls to our customer support number will be recorded for internal training and quality purposes.
</p>
<p style="text-align:right;margin-top: 1px;margin-bottom: 1px;"><strong>For BEYOND AIM INDUSTRIES</strong><br /><br /><br /><strong>Authorized Signatory</strong></p>
</td>
</tr>

</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<button type="button" class="btn btn-md" style="height: 42px; padding: 5px 25px; float:left;border-radius:5px; color: white; background-color: green;margin:2px 10px; border: 0px;" onclick="PrintDiv();">Print</button>
</div>
</div>
</div>
</div>
</div>

</div>
</div>
<?php include("includes/footer.php");?>
</div>
</div>
<?php include("includes/js.php");?>
<script type="text/javascript">
function PrintDiv() {
var divToPrint = document.getElementById('divToPrint');
var newWin = window.open('', 'Print-Window');
newWin.document.open();
newWin.document.write('<html><body onload="window.print()">' + divToPrint.innerHTML + '</body></html>');
newWin.document.close();
setTimeout(function() {
newWin.close();
}, 10);
}
</script>
</body>

</html>

${this.title}

Code Editor : invoice-sale-detail.php