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/billingdemobcode

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: bill.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$rowprc=mysqli_fetch_array(mysqli_query($con,"select * from `prc_master` where 1"));
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 $words;
}
$row=mysqli_fetch_array(mysqli_query($con,"select * from `sales_header` where `sl_id`='".$_REQUEST['id']."'"));
$respr=mysqli_query($con,"select * from `sales_item` where `sl_id`='".$row['sl_id']."'");
$numpro=mysqli_num_rows($respr);
$rowms=mysqli_fetch_array($respr);
//$noofpage=ceil($numpro/18);
/*$mon=date("m");
if($mon>=4) {
	$fy=date("y")."-".(date("y")+1);
} else {
	$fy=(date("y")-1)."-".date("y");
}*/
//include("includes/headermain.php"); 
?>
<!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="MVDP,online learning">
<meta name="description" content="MVDP 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="MVDP">
<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="MVDP">
<meta name="generator" content="https://www.mdvp.in">
<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 type="text/javascript">
function PrintDivData(crtlid) {
	//document.getElementById("prbill").style.display='none';
	var ctrlcontent = document.getElementById(crtlid);
	var printscreen = window.open('','','left=0,top=0,width=1048,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="margin:auto;text-align:center;"><input type="button" value="Print Bill" class="btn btn-primary" onClick="javascript:PrintDivData('Div_Print');" id="prbill">&nbsp;&nbsp;<input type="button" value="Cancel" class="btn btn-primary" onClick="location.href='addbill.php'"></div>
	<div style="clear:both;height:20px;"></div>	
	<div id="Div_Print" style="width:1048px;margin:auto;">
		<table width="1020" border="0" cellpadding="0" cellspacing="0">
			
			<tr>
				<td colspan="3" style="padding: 1%;border:1px solid #000000 !important;background:#e3e023;">
					<div style="float:left;width:30%;text-align:left;">
						&nbsp;
						<?php /*?>&nbsp;&nbsp;&nbsp;&nbsp;
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:13px;font-weight:bold;">GSTIN: <?php print $row['gstin']; ?></span><?php */?>
					</div>
					<div style="float:left;width:40%;margin-top:40px;text-align:center;">
						<span style="font-family:century gothic;font-size:45px;color:#803a18;font-weight:bold;">NAME</span>
					</div>
					<div style="float:left;width:30%;text-align:right;">
						&nbsp;
					</div>
				</td>
			</tr>
			<tr>
				<td width="28%" style="padding: 1%;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">Bill No: <?php print $row['sl_unid']; ?></span>
				</td>
				<td width="38%" align="center" style="padding: 1%;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:18px;font-weight:bold;">GST INVOICE</span>
				</td>
				<td width="28%" align="right" style="padding: 1%;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">Date: <?php print dtconvert($row['sl_docdate']); ?></span>
				</td>
			</tr>
		</table>		
		<table width="1020" border="0" cellpadding="0" cellspacing="0">	
			<tr>
				<td colspan="2" align="center" style="padding: 10px;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">Customer Details</span>
				</td>
				<td align="center" style="padding: 10px;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">NAME</span>
				</td>
			</tr>	
			<tr>
				<td width="13%" style="padding: 1%;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Name</span>
				</td>
				<td width="33%" style="padding: 1%;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><?php print $row['cus_name']; ?></span>
				</td>
				<td rowspan="5" width="48%" valign="top" style="padding: 1%;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;background:#b9d3fc;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">Prop: Name</span>
					<div style="clear:both;height:12px;"></div>
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Jangalpara Bazar, Hooghly</span>
					<div style="clear:both;height:12px;"></div>
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Contact Number: 8013210360 / 9434643748</span>
					<div style="clear:both;height:12px;"></div>
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">GSTIN: 19AFJPK4211K1ZD</span>
					<div style="clear:both;height:12px;"></div>
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">PAN: AFJPK4211K</span>
					<div style="clear:both;height:12px;"></div>
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:13px;">Email-ID: ashisboral48@gmail.com</span>
				</td>
			</tr>	
			<tr>
				<td style="padding: 1%;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Address</span>
				</td>
				<td style="padding: 1%;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><?php print $row['cus_add']; ?></span>
				</td>
			</tr>
			<tr>
				<td style="padding: 1%;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Contact No</span>
				</td>
				<td style="padding: 1%;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><?php print $row['cus_phone']; ?></span>
				</td>
			</tr>
			<tr>
				<td style="padding: 1%;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">GSTIN</span>
				</td>
				<td style="padding: 1%;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><?php print $row['cus_gstin']; ?></span>
				</td>
			</tr>
			<tr>
				<td style="padding: 1%;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">PAN</span>
				</td>
				<td style="padding: 1%;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><?php print $row['cus_pan']; ?></span>
				</td>
			</tr>
		</table>	
		<div style="clear:both;height:20px;"></div>	
		<div style="margin:0;padding:0;background:url('assets/images/thakur.png') center no-repeat;">
			<table width="1020" border="0" cellpadding="8" cellspacing="0">	
				<tr style="color: #192c4a;">
					<td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;background:#FFF;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;">
						DESCRIPTION
					</td>
					<td width="12%" align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;background:#FFF;">
						HSN
					</td>
					<td width="12%" align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;background:#FFF;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;">
						RATE
					</td>
					<td width="12%" align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;background:#FFF;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;">
						QTY
					</td>
					<td width="15%" align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;background:#FFF;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;">
						TOTAL<br>AMOUNT
					</td>
				</tr>
				<?php
				$count=1;
				$totalwogst=0;
				$totalgst=0;
				$totalwgst=0;
				$taxfive=0;
				$taxtwelv=0;
				$taxeteen=0;
				$taxteight=0;
				$totval=0;
				$totdsc=0;
				$sqla="select * from `product_master` pr, `sales_item` si where si.sl_id='".$row['sl_id']."' and pr.pro_code=si.pro_code";
				$resa=mysqli_query($con,$sqla);
				$numrow=mysqli_num_rows($resa);
				while($rowa=mysqli_fetch_array($resa)) {
					$totalwogst+=$rowa['sales_valwogst'];
					$totalgst+=$rowa['sales_gstval'];
					$totalwgst+=$rowa['sales_valwgst'];	
					$totval+=$totalwogst;
					$totdsc+=$rowa['discountv'];
					
					$taxthree+=$pvalue;
					$taxfive+=$makingd;
					$gstthree=$pvalue*(3/100);
					$gstfive=$makingd*(5/100);
				?>
					<tr>
						<td height="200" align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;border:1px solid #000000 !important;">
							<?php print stripslashes(stripslashes(stripslashes($rowa['pro_name']))); ?>
						</td>
						<td width="12%" align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
							<?php print $rowa['pro_hsn']; ?>
						</td>
						<td width="12%" align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
							<?php print $rowa['sales_rate']; ?>
						</td>
						<td width="12%" align="left" valign="top" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
							<?php print $rowa['qty']; ?>
						</td>
						<td width="15%" align="right" valign="top" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;border-right:1px solid #000000 !important;border-top:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
							<?php print number_format($totalwogst,2); ?>
						</td>
					</tr>
				<?php 
					$count++;
				}
				$net=round($totalwgst);
				$roundoff=$net-$totalwgst;
				?>
				<tr height="25">
					<td align="right" colspan="10">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;">Total Amount:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php print number_format($net,2); ?></span>
						<div style="clear:both;height:12px;"></div>
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"><?php print convert_number_to_words($net); ?></span>
					</td>
				</tr>	
			</table>
		</div>
		<div style="clear:both;height:20px;"></div>	
		<table width="1022" border="0" cellpadding="3" cellspacing="0">
			<tr>
				<td align="right" style="border-top:0px !important;">
					<?php
					$gstthree=$taxthree*(3/100);
					$gstfive=$taxfive*(5/100);
					?>
					<table width="400" border="1" cellpadding="8" cellspacing="0" style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">
						<tr style="color: #192c4a;">
							<th align="left">Tax Details</th>
							<th align="left">Taxable<br>Value</th>
							<th align="left">Rate</th>
							<th align="left">Tax</th>
						</tr>
						<tr>
							<td>CGST</td>
							<td><?php print number_format($taxfive,2); ?></td>
							<td>2.50%</td>
							<td><?php print number_format($gstfive/2,2); ?></td>
						</tr>
						<tr>
							<td>SGST</td>
							<td><?php print number_format($taxfive,2); ?></td>
							<td>2.50%</td>
							<td><?php print number_format($gstfive/2,2); ?></td>
						</tr>
						<tr>
							<td><strong>Total Tax</strong></td>
							<td colspan="3" align="right"><strong><?php print number_format($totalgst,2); ?></strong></td>
						</tr>
					</table>
				</td>
			</tr>
		</table>	
		<div style="clear:both;height:20px;"></div>	
		<table width="1020" border="0" cellpadding="3" cellspacing="0">
			<tr>
				<td style="padding: 10px;border:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"></span>
				</td>
			</tr>
			<tr>
				<td style="padding: 10px;border-left:1px solid #000000 !important;border-right:1px solid #000000 !important;border-bottom:1px solid #000000 !important;">
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Read / understood and agreed to the above mentioned information and terms and conditions overleaf and verified weight and received product in good condition with packing materials.</span>
					<div style="clear:both;height:20px;"></div>	
					<div style="float:left;width:70%;text-align:left;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Customer Name: <?php print $row['cus_name']; ?></span>
						<div style="clear:both;height:50px;"></div>
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Signature</span>
						<div style="clear:both;height:50px;"></div>
					</div>
					<div style="float:left;width:30%;text-align:center;">
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">For Name</span>
						<div style="clear:both;height:50px;"></div>
						<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Authorised Signature</span>
						<div style="clear:both;height:50px;"></div>
					</div>
				</td>
			</tr>
			<tr>
				<td align="center" style="padding: 10px;border:0px;">
					<div style="clear:both;height:20px;"></div>	
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;"><strong>Certificate:</strong> Certified that particulars given above are true and the amount indicated represent the price actually charged and there is no flow or additional consideration directly or indirectly from the buyer.</span>
				</td>
			</tr>	
		</table>	
		<div style="clear:both;"></div>
	</div>
	<div style="clear:both;height:20px;"></div>
	<div style="margin:auto;text-align:center;"><input type="button" value="Print Bill" class="btn btn-primary" onClick="javascript:PrintDivData('Div_Print');" id="prbill">&nbsp;&nbsp;<input type="button" value="Cancel" class="btn btn-primary" onClick="location.href='addbill.php'"></div>
	<div class="cleaner h20"></div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: bill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation