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

Free Space:

1.93 TB

🔧 Quick Actions

✏️ Editing: challan.php

<?php
ob_start();
session_start();
include("includes/logincheck.php");
include("includes/connection.php");
include("includes/functions.php");
$s_id=isset($_REQUEST['s_id'])?$_REQUEST['s_id']:'';	
$action=isset($_REQUEST['action'])?$_REQUEST['action']:'';
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);
}
$sql="select * from `order` a, `customer` c where a.cusname=c.adv_id and a.or_id='".$_REQUEST['id']."'";
$res=mysqli_query($con,$sql);
$row=mysqli_fetch_array($res);
$sql22="select * from `product` p, `orderpro` op where op.op_ref='".$row['or_id']."' and op.op_pro=p.pro_id";
$res22=mysqli_query($con,$sql22);
$numrow2=mysqli_num_rows($res22);
$noofpage=ceil($numrow2/10);
$mon=date("m");
if($mon>=4) {
	$fy=date("y")."-".(date("y")+1);
} else {
	$fy=(date("y")-1)."-".date("y");
}
include("includes/headermain.php");
?>
<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>
<body>
	<div class="wrapper">
		<?php include("includes/header.php"); ?>
		<div class="cleaner h10"></div>
		<div class="innercontent">
			<div style="float:right;font-family:arial;font-size:.8em;">
				Logged in as <strong>Admin</strong>&nbsp;&nbsp;&nbsp;
			</div>
			<div class="cleaner h5"></div> 
			&nbsp;&nbsp;&nbsp;<span style="font-size:1em;font-family:calibri;text-transform:uppercase;"><strong>View Tax Invoice</strong></span>
			<hr color="#D8E1F5" style="height:10px;">
			<div class="cleaner h10"></div>
			<div class="deeparea2" style="width:1048px;margin:auto;">
				
				<div class="cleaner h20"></div>
				<?php 
				for($i=1;$i<=3;$i++) { 
					$procount=1;
					$tcount=1;
					$sum=0;
					$taxtot=0;
					$vattaxzero=0;
					$vattaxfive=0;
					$vattaxfteen=0;
					$vattaxeteen=0;
					$vattaxteight=0;
					$totdis=0;
					$totqty=0;
					$gamtot=0;
				?>
					<div id="Div_Print<?php print $i; ?>" style="width:1048px;margin:auto;margin-top:30px;border:0px solid #B0B0B0;">
						<table width="1048" border="0" cellpadding="3" cellspacing="0">
							<tr>
								<td align="center">
									<div style="float:left;margin-top:10px;width:300px;">
										<?php if($i==1) { ?>
											<div style="float:left;margin:2px 0 0;width:15px;height:10px;border:1px solid black;background:#000;"></div>
											<div style="float:left;font-family:Arial, Helvetica, sans-serif;font-size:16px;">&nbsp;&nbsp;ORIGINAL BUYER'S COPY</div>
										<?php } if($i==2) {  ?>
											<div style="float:left;margin:2px 0 0;width:15px;height:10px;border:1px solid black;background:#000;"></div>
											<div style="float:left;font-family:Arial, Helvetica, sans-serif;font-size:16px;">&nbsp;&nbsp;DUPLICATE FOR TRANSPORT</div>
										<?php } if($i==3) {  ?>
											<div style="float:left;margin:2px 0 0;width:15px;height:10px;border:1px solid black;background:#000;"></div>
											<div style="float:left;font-family:Arial, Helvetica, sans-serif;font-size:16px;">&nbsp;&nbsp;TRIPLICATE FOR SUPPLIERS</div>
										<?php } ?>
									</div>
									<div style="float:left;width:438px;text-align:center;"> <span style="font-family:Arial, Helvetica, sans-serif;font-size:24px;font-weight:bold;text-decoration:underline;">TAX INVOICE</span>
										<div style="clear:both;height:5px;"></div> <span style="font-family:Arial, Helvetica, sans-serif;font-size:34px;font-weight:bold;text-ecoration:underline;">G.K. INDUSTRIES</span>
										<div style="clear:both;height:5px;"></div> <span style="font-family:Arial, Helvetica, sans-serif;font-size:22px;font-weight:bold;text-ecoration:underline;">64 'H' Road, Belgachia</span>
										<div style="clear:both;height:5px;"></div> <span style="font-family:Arial, Helvetica, sans-serif;font-size:22px;font-weight:bold;text-ecoration:underline;">Howrah - 711105 (W.B.)</span>
										<div style="clear:both;height:5px;"></div> <span style="font-family:Arial, Helvetica, sans-serif;font-size:22px;font-weight:bold;text-ecoration:underline;">GSTIN 19BAPPM5099B1Z9</span>
										<div style="clear:both;height:5px;"></div>
									</div>
									<div style="float:left;margin-top:10px;width:300px;text-align:right;"> <span style="font-family:Arial, Helvetica, sans-serif;font-size:18px;font-weight:bold;text-ecoration:underline;">MOB: 9609618711 / 9830783746</span>
										<div style="clear:both;height:5px;"></div> <span style="font-family:Arial, Helvetica, sans-serif;font-size:18px;font-weight:bold;text-ecoration:underline;">EMAIL: arupmalik888@gmail.com</span> </div>
								</td>
							</tr>
							<tr>
								<td align="center">
									<div style="float:left;margin-right:10px;width:293px;padding:10px 0 10px 5px;border:1px solid black;text-align:left;"> <span style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;">DATE: <?php print $row['sdate']; ?></span> </div>
									<div style="float:left;width:411px;padding:10px 0 10px 5px;border:1px solid black;text-align:left;"> <span style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;">BUYER'S GST NO.: <?php print strtoupper($row['adv_tin']); ?></span> </div>
									<div style="float:left;margin-left:10px;width:293px;padding:10px 0 10px 5px;border:1px solid black;text-align:left;"> <span style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;">INVOICE NO.: <?php print $row['or_bill']; ?> / <?php print $fy; ?></span> </div>
								</td>
							</tr>
							<tr>
								<td align="center">
									<div style="float:left;width:507px;padding:20px 0 20px 5px;border:1px solid black;text-align:left;"> <span style="font-family:Arial, Helvetica, sans-serif;font-size:18px;font-weight:bold;">BUYER'S NAME: M/S <?php print strtoupper($row['adv_name']); ?></span>
										<div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">ADDRESS: <?php print strtoupper($row['adv_add']); ?></span> </div>
									<div style="float:left;margin-left:10px;width:507px;padding:20px 0 20px 5px;border:1px solid black;text-align:left;"> <span style="font-family:Arial, Helvetica, sans-serif;font-size:18px;font-weight:bold;">DELIVERY ADDRESS: M/S <?php print strtoupper($row['adv_name']); ?></span>
										<div style="clear:both;height:5px;"></div><span style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"><?php print strtoupper($row['adv_dadd']); ?></span> </div>
								</td>
							</tr>
							<tr>
								<td align="left">
									<table width="1038" border="1" cellpadding="14" cellspacing="0">
										<tr>
											<td width="10%" align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> SL. </td>
											<td align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> DESCRIPTION </td>
											<td width="10%" align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> PCS. </td>
											<td width="10%" align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> KG. </td>
											<td width="15%" align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> RATE </td>
											<td width="18%" align="center" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> AMOUNT </td>
										</tr>
									</table>
									<div style="background:url(./images/GKa.jpg) no-repeat;">
										<div style="width:1034px;border-left:2px solid #565656;border-right:2px solid #565656;">
											<table width="1036" border="0" cellpadding="14" cellspacing="0">
												<?php if($row['lbcharge']=="Yes") { ?>
													<tr>
														<td style="border-right:2px solid #565656;">&nbsp;</td>
														<td align="center" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:16px;">Only Labour Charges</td>
														<td align="center" style="border-right:2px solid #565656;">&nbsp;</td>
														<td style="border-right:2px solid #565656;">&nbsp;</td>
														<td style="border-right:2px solid #565656;">&nbsp;</td>
														<td style="border-right:2px solid #565656;">&nbsp;</td>
													</tr>
												<?php 
												} 
												$count=1;
												$sql2="select * from `product` p, `orderpro` op where op.op_ref='".$row['or_id']."' and op.op_pro=p.pro_id";
												$res2=mysqli_query($con,$sql2);
												$numrow=mysqli_num_rows($res2);
												while($row2=mysqli_fetch_array($res2)) {
													$gam=$row2['op_rate']*$row2['op_qty'];
													$gamtot+=round($row2['op_rate']*$row2['op_qty'],2);
													if($row['or_bill']=="68" || $row['or_bill']=="69" || $row['or_bill']=="71" || $row['or_bill']=="73" || $row['or_bill']=="74" || $row['or_bill']=="75" || $row['or_bill']=="76" || $row['or_bill']=="78") {
														$trate="12";
													} else {
														$trate=$row2['pro_tax'];
													}
													$tax=$gam*($trate/100);
													$taxtot+=$gam*($trate/100);
													$pc="";
													$kg="";
													if($row2['pro_by']=="Pcs.") {
														$pc=$row2['op_qty'];
													}
													if($row2['pro_by']=="Kg.") {
														if($row2['pro_pckg']!="" && $row2['pro_pckg']!=0) {
															$pc=round($row2['op_qty']/$row2['pro_pckg']);
														}
														$kg=$row2['op_qty'];
													}
													$gstr=$trate/2;
												?>
													<tr height="48">
														<td align="center" width="10%" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:18px;">
															<?php print $count; ?>
														</td>
														<td align="center" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:18px;">
															<?php print stripslashes(stripslashes(stripslashes(stripslashes(stripslashes(stripslashes($row2['pro_name'])))))); ?>
																<?php if($row2['pro_hcn']!="") { print "<br>(HSN/SAC: ".$row2['pro_hcn'].")"; } ?>
														</td>
														<td align="center" width="10%" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:18px;">
															<?php if($pc!="" && $pc!=0) { print $pc; } ?>
														</td>
														<td align="center" width="10%" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:18px;">
															<?php print $kg; ?>
														</td>
														<td align="center" width="15%" style="border-right:2px solid #565656;font-family:Arial, Helvetica, sans-serif;font-size:18px;">Rs.
															<?php print $row2['op_rate']; ?>
														</td>
														<td align="right" width="18%" style="font-family:Arial, Helvetica, sans-serif;font-size:18px;">Rs.
															<?php print round($gam,2); ?>
														</td>
													</tr>
												<?php 
													$count++;
												}
												$nettot=round($gamtot,2)+round($taxtot/2,2)+round($taxtot/2,2);
												$gamtotwithdel=round($gamtot,2)+$row['delcharge'];
												$taxtotwithdel=$taxtot+($row['delcharge']*($trate/100));
												$nettotwithdel=round($gamtot,2)+$row['delcharge']+round($taxtot/2,2)+round($taxtot/2,2)+round(($row['delcharge']*($trate/100)),2);
												$rest=9-$numrow;
												for($j=1;$j<=$rest;$j++) { 
												?>
													<tr height="48">
														<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">&nbsp;</td>
													</tr>
												<?php } ?>
											</table>
										</div>
										<table width="1038" border="1" cellpadding="14" cellspacing="0">
											<tr>
												<td align="left" valign="top" rowspan="5"> <img src="images/barcode.gif" width="100%"> </td>
												<td align="left" valign="top"></td>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"> Rs.
													<?php print round($gamtot,2); ?>
												</td>
											</tr>
											<tr>
												<td align="right" width="30%" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">DELIVERY CHARGE</td>
												<td align="right" width="20%" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"> Rs.
													<?php print $row['delcharge']; ?>
												</td>
											</tr>
											<tr>
												<td align="left"><span style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">ADD - CGST @</span><span style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> <?php print $gstr; ?>%</span></td>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"> Rs.
													<?php print round($taxtotwithdel/2,2); ?>
												</td>
											</tr>
											<tr>
												<td align="left"><span style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">ADD - SGST @</span></span><span style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> <?php print $gstr; ?>%</span></td>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"> Rs.
													<?php print round($taxtotwithdel/2,2); ?>
												</td>
											</tr>
											<tr>
												<td align="left" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">ADD - IGST</td>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;">N.A. </td>
											</tr>
											<tr>
												<td align="left" valign="top" rowspan="3" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"> TOTAL IN WORDS:
													<?php print strtoupper(convert_number_to_words(round($nettotwithdel))); ?>
												</td>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;">TOTAL</td>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> Rs.
													<?php print round($nettotwithdel,2); ?>
												</td>
											</tr>
											<tr>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;">ROUND OFF</td>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;">
													<?php print round(round($nettotwithdel)-round($nettotwithdel,2),2); ?>
												</td>
											</tr>
											<tr>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;">TOTAL AMOUNT</td>
												<td align="right" style="font-family:Arial, Helvetica, sans-serif;font-size:20px;font-weight:bold;"> Rs.
													<?php print round($nettotwithdel); ?>
												</td>
											</tr>
											<tr>
												<td align="left" valign="middle" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"> BANK NAME - AXIS BANK
													<div style="clear:both;height:5px;"></div> BRANCH - DASNAGAR
													<div style="clear:both;height:5px;"></div> ACCOUNT NO - 917020076551940
													<div style="clear:both;height:5px;"></div> IFSC - UTIB0002604 </td>
												<td align="center" valign="top" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"> RECEIVER'S SIGN </td>
												<td align="center" valign="top" style="font-family:Arial, Helvetica, sans-serif;font-size:16px;font-weight:bold;"> FOR G.K. INDUSTRIES
													<br>
													<br>
													<br>
													<br> E. & O.E. 
												</td>
											</tr>
										</table>
									</div>
								</td>
							</tr>
						</table>
					</div>
					<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>
					<div class="cleaner h20"></div>
				<?php } ?>
				<?php
				if($row['totamount']=="" || $row['totamount']==0) {
					mysqli_query($con,"update `order` set `given`='0',`totamount`='".$nettotwithdel."'  where `or_id`='".$_REQUEST['id']."'");
				}
				?>
			</div>
		</div>
		<div class="cleaner h20"></div>
		<?php include("includes/footer.php"); ?>
	</div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: challan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation