Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/systemuniq

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: billcgst.php

<?php
ob_start();
session_start();
include("includes/inall.php");
function convert_number_to_words($number) {
	$no = round($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) ? '' : 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] : '';
	//echo $result . "Rupees  " . $points . " Paise";
	$words = "Rupees  " . $result . " Only";
	echo strtoupper($words);
}
$row=mysqli_fetch_array(mysqli_query($con,"select * from `sales_cgsheader` where `sl_id`='".$_REQUEST['id']."'"));
$rowk=mysqli_fetch_array(mysqli_query($con,"select * from `customer_master` where `id`='".$row['cust_id']."'"));
$rowcn=mysqli_fetch_array(mysqli_query($con,"select * from `customer_master` where `id`='".$row['con_id']."'"));
$mon=date("m");
if($mon>=4) {
	$fy=date("y")."-".(date("y")+1);
} else {
	$fy=(date("y")-1)."-".date("y");
}
?>
<!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>Billing System</title>
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name="keywords" content="Billing System,online learning">
<meta name="description" content="Billing System is a PAN India level company which provides a structure based earning opportunity.">
<meta name="language" content="EN">
<meta name="abstract" content="A site for B2B Business">
<meta name="coverage" content="Worldwide"> 
<meta name="Author" content="Billing System">
<meta name="ROBOTS" content="INDEX, FOLLOW">
<meta name="Robots" content="INDEX,ALL">
<meta name="YahooSeeker" content="INDEX, FOLLOW">
<meta name="msnbot" content="INDEX, FOLLOW">
<meta name="googlebot" content="INDEX, FOLLOW">
<meta name="allow-search" content="yes">
<meta name="revisit-after" content="daily">
<meta name="Rating" content="General">
<meta name="page-topic" content="Billing System">
<meta name="generator" content="">
<meta name="document-type" content="Public">
<meta name="document-rating" content="Safe for Kids">
<meta name="document-distribution" content="Global">
<link rel="shortcut icon" href="favicon.png"> 
<script language="javascript" type="text/javascript">
function PrintDivData(crtlid) {
	var ctrlcontent = document.getElementById(crtlid);
	var printscreen = window.open('','','left=0,top=0,width=1350,toolbar=0,scrollbars=0,status=0');
	printscreen.document.write(ctrlcontent.innerHTML);
	printscreen.document.close();
	printscreen.focus();
	printscreen.print();
	printscreen.close();
}
</script>
</head>
<body>
<div style="clear: both;height: 20px;">
	<?php 
	//for($i=1;$i<=3;$i++) { 
		$gamtot=0;
	?>
		<div id="div_print" style="width:1048px;margin:auto;margin-top:30px;border:0px solid #B0B0B0;">
			<table width="1048" border="0" cellpadding="7" cellspacing="0">
				<tr>
					<td align="center" style="background: #FFF;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:25px;font-weight:bold;">TAX INVOICE</span>
						<?php /* ?><div style="float:right;">
							<?php if($i==1) { ?>
								<span style="float:left;font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;&nbsp;ORIGINAL BUYER'S COPY</span>
							<?php } if($i==2) {  ?>
								<span style="float:left;font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;&nbsp;DUPLICATE FOR TRANSPORT</span>
							<?php } if($i==3) {  ?>
								<span style="float:left;font-family:Arial, Helvetica, sans-serif;font-size:12px;">&nbsp;&nbsp;TRIPLICATE FOR SUPPLIERS</span>		
							<?php } ?>
						</div><?php */ ?>	
					</td>	
				</tr>
			</table>
			<?php /* ?><div style="width: 100%;text-align: center;padding-bottom: 10px;"><img src="assets/images/logoa.png" width="50" alt=""></div><?php */ ?>	
			<table width="1048" border="1" cellpadding="7" cellspacing="0">
				<tr>
					<td rowspan="2" width="50%" style="background: #FFF;">
						
						<div style="float: left;">
							<span style="font-family:Arial, Helvetica, sans-serif;font-size:24px;font-weight:bold;text-ecoration:underline;">SK Jewellery</span>
							<div style="clear:both;height:5px;"></div>
							
							<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;text-ecoration:underline;">Z.R. Fancy Market (Opp. Domjur Post Office), Domjur, 2nd Floor</span>
							<div style="clear:both;height:5px;"></div>
							<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;text-ecoration:underline;">Howrah (W.B.) - 711 405</span>
							<div style="clear:both;height:5px;"></div>
							<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;text-ecoration:underline;">MOB +91 9751862144 / 9547124558</span>
							<div style="clear:both;height:5px;"></div>	
							<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;text-ecoration:underline;">EMAIL alisksadik@gmail.com</span>
							<div style="clear:both;height:5px;"></div>	
							<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;text-ecoration:underline;">GSTIN 19CZLPS2716P1ZG</span>
						</div>
					</td>	
					<td style="background: #FFF;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;">DATE</span>	
					</td>
					<td style="background: #FFF;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;"><?php print dtconvert($row['sl_docdate']); ?></span>	
					</td>
				</tr>
				<tr>
					<td style="background: #FFF;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;">INVOICE NO.</span>	
					</td>
					<td style="background: #FFF;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;"><?php print "SK / ".$row['sl_unid']; ?> / <?php print $fy; ?></span>	
					</td>
				</tr>
				<?php /* ?><tr>
					<td style="background: #FFF;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;">PAN</span>	
					</td>
					<td style="background: #FFF;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;"></span>	
					</td>
				</tr><?php */ ?>
				<tr>
					<td colspan="3" valign="top" style="background: #FFF;">
						<div style="clear:both;height:5px;"></div>
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;">BUYER (Bill To): <?php print strtoupper($rowk['name']); ?></span><?php if($rowk['address']) { ?><div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">Address: <?php print strtoupper($rowk['address']); ?></span><?php } if($rowk['state']) { ?><div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">State: <?php print strtoupper($rowcn['state']); ?></span><?php } if($rowk['mobno']) { ?><div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">Contact No.: <?php print strtoupper($rowk['mobno']); ?></span><?php } if($rowk['gstin']) { ?><div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">GSTIN: <?php print strtoupper($rowk['gstin']); ?></span><?php } ?>						
					</td>
				</tr>	
				<tr>
					<td colspan="3" valign="top" style="background: #FFF;">
						<div style="clear:both;height:5px;"></div>
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:17px;font-weight:bold;">CONSIGNEE (SHIP To): <?php print strtoupper($rowcn['name']); ?></span><?php if($rowk['address']) { ?><div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">Address: <?php print strtoupper($rowcn['address']); ?></span><?php } if($rowk['state']) { ?><div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">State: <?php print strtoupper($rowcn['state']); ?></span><?php } if($rowk['mobno']) { ?><div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">Contact No.: <?php print strtoupper($rowcn['mobno']); ?></span><?php } if($rowcn['gstin']) { ?><div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">GSTIN: <?php print strtoupper($rowcn['gstin']); ?></span><?php } ?>	
						<div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">Place of Supply: <?php print strtoupper($row['plc_supply']); ?></span>					
					</td>
				</tr>
			</table>
			<div style="clear:both;height:5px;"></div>
			<table width="1048" border="0" cellpadding="7" cellspacing="0">
				<tr>
					<td width="6%" align="left" style="border:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">
						SL.
					</td>
					<td align="left" style="border-top:2px solid #565656;border-bottom:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">
						DESCRIPTION OF GOODS
					</td>
					<td width="14%" align="left" style="border-top:2px solid #565656;border-bottom:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">
						HSN
					</td>
					<td width="14%" align="left" style="border-top:2px solid #565656;border-bottom:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">
						PER
					</td>
					<td width="14%" align="left" style="border-top:2px solid #565656;border-bottom:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">
						QTY
					</td>
					<td width="14%" align="left" style="border-top:2px solid #565656;border-bottom:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">
						RATE
					</td>
					<td width="14%" align="right" style="border-top:2px solid #565656;border-bottom:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">
						AMOUNT
					</td>
				</tr>
			
				<?php
				$count=1;
				$totqty=0;
				$sqla="select * from `sales_cgsitem` si where si.sl_id='".$row['sl_id']."' order by si.sales_id";
				$resa=mysqli_query($con,$sqla);
				$numrow=mysqli_num_rows($resa);
				while($rowa=mysqli_fetch_array($resa)) {
					$gam=$rowa['sales_rate']*$rowa['sales_qty'];
					$gamtot+=round($rowa['sales_rate']*$rowa['sales_qty'],2);
					//$trate=$rowa['pro_gst'];
					$tax=$gam*(3/100);
					$taxtot+=$gam*(3/100);
					$totqty+=$rowa['sales_qty'];
					//$gstr=$trate/2;
				?>
					<tr>
						<td align="left" style="border-left:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong><?php print $count; ?></strong></td>
						<td align="left" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong><?php print stripslashes($rowa['pro_name']); ?> <?php //if($rowa['pro_hsn']!="") { print "<br>(HSN/SAC: ".$rowa['pro_hsn'].")"; } ?></strong></td>
						<td align="left" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong><?php print $rowa['pro_hsn']; ?></strong></td>
						<td align="left" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong><?php print $rowa['sales_unit']; ?></strong></td>
						<td align="left" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong><?php print $rowa['sales_qty']; ?> <?php print $rowa['sales_unit']; ?></strong></td>
						<td align="left" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong><?php print number_format($rowa['sales_rate'],2); ?></strong></td>
						<td align="right" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong><?php print number_format(round($gam,2),2); ?></strong></td>
					</tr>
				<?php 
					$count++;
				}
				$nettot=round($gamtot,2)+round($taxtot/2,2)+round($taxtot/2,2);
				if($numrow>9) {
					$rowlmt=23;
				} else {
					$rowlmt=23;
				}
				$rest=$rowlmt-$numrow-1;
				?>
				<?php for($j=1;$j<=$rest;$j++) { ?>
					<tr>
						<td align="center" style="border-left:2px solid #565656;border-right:2px solid #565656;">&nbsp;</td>
						<td align="center" style="border-right:2px solid #565656;">&nbsp;</td>
						<td align="center" style="border-right:2px solid #565656;">&nbsp;</td>
						<td align="center" style="border-right:2px solid #565656;">&nbsp;</td>
						<td align="center" style="border-right:2px solid #565656;">&nbsp;</td>
						<td align="center" style="border-right:2px solid #565656;">&nbsp;</td>
						<td align="center" style="border-right:2px solid #565656;">&nbsp;</td>
					</tr>
				<?php } ?>
				<tr>
					<td align="center" style="border-top:2px solid #565656;border-left:2px solid #565656;border-right:2px solid #565656;">&nbsp;</td>
					<td align="center" style="border-top:2px solid #565656;border-right:2px solid #565656;">&nbsp;</td>
					<td align="center" style="border-top:2px solid #565656;border-right:2px solid #565656;">&nbsp;</td>
					<td align="right" style="border-top:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>TOTAL</strong></td>
					<td align="left" style="border-top:2px solid #565656;border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong><?php print $totqty; ?></strong></td>
					<td align="center" style="border-top:2px solid #565656;border-right:2px solid #565656;">&nbsp;</td>
					<td align="center" style="border-top:2px solid #565656;border-right:2px solid #565656;">&nbsp;</td>
				</tr>
			</table>	
			<table width="1048" border="1" cellpadding="7" cellspacing="0">	
				<tr>
					<td align="left" width="50%" valign="top" <?php if($row['sl_igst']!="Yes") { ?>rowspan="5"<?php } else { ?>rowspan="4"<?php } ?> style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">
							
						AMOUNT CHARGEABLE
						<div style="clear:both;height:5px;"></div>
						<?php print strtoupper(convert_number_to_words(round($nettot))); ?>
						<?php /* ?><div style="clear:both;height:30px;"></div>	
						TAX AMOUNT
						<div style="clear:both;height:5px;"></div>
						<?php print strtoupper(convert_number_to_words(round($taxtot))); ?><?php */ ?>
						<div style="clear:both;height:20px;"></div>
						BANK NAME - AXIS BANK
						<div style="clear:both;height:5px;"></div>
						BRANCH - DOMJUR
						<div style="clear:both;height:5px;"></div>
						ACCOUNT NO - 914020020819266
						<div style="clear:both;height:5px;"></div>
						IFSC - UTIB0001077
					</td>
					<td align="left">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">SUB TOTAL</span>
					</td>
					<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">
						<?php print number_format(round($gamtot,2),2); ?>
					</td>
				</tr>
				<?php if($row['sl_igst']!="Yes") { ?>
					<tr>
						<td align="left">
							<span style="font-family:Arial, Helvetica, sans-serif;font: size 15px;px;font-weight:bold;">ADD - CGST @</span><span style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;"> 1.5%</span>
						</td>
						<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">
							<?php print number_format(round($taxtot/2,2),2); ?>
						</td>
					</tr>
					<tr>
						<td align="left">
							<span style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">ADD - SGST @</span></span><span style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;"> 1.5%</span>
						</td>
						<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">
							<?php print number_format(round($taxtot/2,2),2); ?>
						</td>
					</tr>
				<?php } else { ?>	
					<tr>
						<td align="left">
							<span style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">ADD - IGST @</span><span style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;"> 3%</span>
						</td>
						<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">
							<?php print number_format(round($taxtot,2),2); ?>
						</td>
					</tr>
				<?php } ?>
				<?php /* ?><tr>
					<td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">ADD - IGST</td>
					<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">N.A.</td>
				</tr>
				<tr>
					<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">TOTAL</td>
					<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">
						<?php print number_format(round($nettot,2),2); ?>
					</td>
				</tr><?php */ ?>
				<tr>
					<td align="right"  style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">ROUND OFF</td>
					<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">
						<?php print round(floor($nettot)-round($nettot,2),2); ?>
					</td>
				</tr>
				<tr>
					<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">GRAND TOTAL</td>
					<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">
						Rs. <?php print number_format(floor($nettot),2); ?>
					</td>
				</tr>
			</table>
			<div style="clear:both;height:5px;"></div>
			<table width="1048" border="1" cellpadding="7" cellspacing="0">		
				<tr>
					<td align="left" width="50%" valign="middle" style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:normal;">
						<strong>Declaration</strong><br>We declare that this invoice shows the actual price of the goods decribed and that all particulars are true and correct.
						<br><br><br><br>
						Customer's Seal & Signature
					</td>
					
					<td align="center" valign="top" style="font-family:Arial, Helvetica, sans-serif;font-size:15px;font-weight:bold;">
						FOR SK Jewellery<br><br><br><br><br><br>
						Authorised Signatory
					</td>
				</tr>
				
				<tr>
					<td colspan="3" align="center" valign="middle" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">
						SUBJECT TO HOWRAH JURISDICTION
						<br><span style="font-size:13px;">This is a computer generated invoice</span>
					</td>
				</tr>
			</table>		
		</div>	
		<?php /* ?><div class="cleaner h20"></div>
		<div style="margin:auto;text-align:center;">
			<input type="button" value="Print Bill" class='all_button' onClick="javascript:PrintDivData('Div_Print<?php print $i; ?>');" id="prbill">
		</div><?php */ ?>
	<?php //} ?>		
	<div style="clear: both;height: 20px;"></div>
	<div style="width: 100%;text-align: center;">
		<input type="button" value="Print" onClick="PrintDivData('div_print');">
	</div>
	<div style="clear: both;height: 20px;"></div>
</div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: billcgst.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation