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: billbkp.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 class="cleaner h20"></div>
	<div id="Div_Print" style="width:1048px;margin:auto;">
		<table width="1020" border="0" cellpadding="0" cellspacing="0">
			
			<tr>
				<td colspan="4" style="padding: 1%;border:1px solid #000000 !important;background:#e3e023;">
					<div style="float:left;width:30%;text-align:left;">
						<img src="assets/images/hmrk.png" height="150" alt="" style="border-radius:20px;">
						<?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;">KRIPA JEWELLERY</span>
					</div>
					<div style="float:left;width:30%;text-align:right;">
						<img src="assets/images/wedding.jpg" height="150" alt="" style="border-radius:20px;">
					</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;">GSTIN: 19AFJPK4211K1ZD</span>
					<div style="clear:both;height:5px;"></div>
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;font-weight:bold;">PAN: AFJPK4211K</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="13%" 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</span>
				</td>
				<td width="13%" 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;"><?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;">Kripa Jewellery</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: Tarapada Karmakar</span>
					<div style="clear:both;height:12px;"></div>
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Vill & Post: Dhubulia, PS - Dhubulia, Nadia (W.B.)</span>
					<div style="clear:both;height:12px;"></div>
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">Contact Number: 9434553226, 9474032512</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>
				</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="9%" 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;">
						HUID
					</td>
					<td width="9%" 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;">
						ORIGINALITY
					</td>
					<td width="9%" 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;">
						WEIGHT<br>(GRAM)
					</td>
					<td width="9%" 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 PER<br>GRAM
					</td>
					<td width="9%" 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;">
						COST OF<br>GOLD
					</td>
					<td width="9%" 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;">
						MAKING<br>CHARGE
					</td>
					<td width="9%" 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;">
						GST ON<br>GOLD
					</td>
					<td width="9%" 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;">
						GST ON<br>MAKING<br>CHARGE
					</td>
					<td width="10%" 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'];	
					$tot=$rowa['gold']+$rowa['making'];
					$totval+=$tot;
					$totdsc+=$rowa['discountv'];
					
					$pvalue=round($rowa['gold'],2);
					$makingd=round($rowa['makingd'],2);
					$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="9%" 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="9%" 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;">
							916
						</td>
						<td width="9%" 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_whgt']; ?>
						</td>
						<td width="9%" 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 number_format(round($rowms['gold']/$rowms['weight']),2); ?>
						</td>
						<td width="9%" 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 number_format($rowa['gold'],2); ?>
						</td>
						<td width="9%" 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 number_format($rowa['making'],2); ?>
						</td>
						<td width="9%" 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 number_format($gstthree,2); ?>
						</td>
						<td width="9%" 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 number_format($gstfive,2); ?>
						</td>
						<td width="10%" 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($tot,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 on Gold</td>
							<td><?php print number_format($taxthree,2); ?></td>
							<td>1.50%</td>
							<td><?php print number_format($gstthree/2,2); ?></td>
						</tr>
						<tr>
							<td>SGST on Gold</td>
							<td><?php print number_format($taxthree,2); ?></td>
							<td>1.50%</td>
							<td><?php print number_format($gstthree/2,2); ?></td>
						</tr>
						<tr>
							<td>CGST on Making Charge</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 on Making Charge</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;">1. Please note that the total value includes metal value, cost of stones, product making charges, Hallmarking charge Rs. 35 per pcs, other charges (if any) and applicable tax as per State and Central Govt Regulations.</span>
					<div style="clear:both;height:20px;"></div>	
					<span style="font-family:Arial, Helvetica, sans-serif;font-size:14px;">2. Product is delivered in the store address mentioned above.</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 Kripa Jewelry</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: billbkp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation