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.91 TB

🔧 Quick Actions

✏️ Editing: billprint.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) {
    
    $hyphen      = '-';
    $conjunction = ' and ';
    $separator   = ', ';
    $negative    = 'negative ';
    $decimal     = ' point ';
    $dictionary  = array(
        0                   => 'zero',
        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                  => 'fourty',
        50                  => 'fifty',
        60                  => 'sixty',
        70                  => 'seventy',
        80                  => 'eighty',
        90                  => 'ninety',
        100                 => 'hundred',
        1000                => 'thousand',
        1000000             => 'million',
        1000000000          => 'billion',
        1000000000000       => 'trillion',
        1000000000000000    => 'quadrillion',
        1000000000000000000 => 'quintillion'
    );
    
    if (!is_numeric($number)) {
        return false;
    }
    
    if (($number >= 0 && (int) $number < 0) || (int) $number < 0 - PHP_INT_MAX) {
        // overflow
        trigger_error(
            'convert_number_to_words only accepts numbers between -' . PHP_INT_MAX . ' and ' . PHP_INT_MAX,
            E_USER_WARNING
        );
        return false;
    }

if ($number < 0) {
        return $negative . convert_number_to_words(abs($number));
    }
    
    $string = $fraction = null;
    
    if (strpos($number, '.') !== false) {
        list($number, $fraction) = explode('.', $number);
    }
    
    switch (true) {
        case $number < 21:
            $string = $dictionary[$number];
            break;
        case $number < 100:
            $tens   = ((int) ($number / 10)) * 10;
            $units  = $number % 10;
            $string = $dictionary[$tens];
            if ($units) {
                $string .= $hyphen . $dictionary[$units];
            }
            break;
        case $number < 1000:
            $hundreds  = $number / 100;
            $remainder = $number % 100;
            $string = $dictionary[$hundreds] . ' ' . $dictionary[100];
            if ($remainder) {
                $string .= $conjunction . convert_number_to_words($remainder);
            }
            break;
        default:
            $baseUnit = pow(1000, floor(log($number, 1000)));
            $numBaseUnits = (int) ($number / $baseUnit);
            $remainder = $number % $baseUnit;
            $string = convert_number_to_words($numBaseUnits) . ' ' . $dictionary[$baseUnit];
            if ($remainder) {
                $string .= $remainder < 100 ? $conjunction : $separator;
                $string .= convert_number_to_words($remainder);
            }
            break;
    }
    
    if (null !== $fraction && is_numeric($fraction)) {
        $string .= $decimal;
        $words = array();
        foreach (str_split((string) $fraction) as $number) {
            $words[] = $dictionary[$number];
        }
        $string .= implode(' ', $words);
    }
    
    return $string;
}
?>
<!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>
 <TITLE>BILLING MANAGEMENT SYSTEM</TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<meta name="Description" content="">
 <meta name="Keywords" content="">
 <meta name="robots" content="index,follow">

 <script type="text/javascript" src="./js/validate.js"></script>
 <link href="./css/style.css" rel="stylesheet" type="text/css" title="default">
<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>

<?php include("includes/header.php"); ?>

<div class="innercontent">
<div style="float:right;font-family:arial;font-size:.8em;">Logged in as <B>Admin</B>&nbsp;&nbsp;&nbsp;</div>
<div class="cleaner h5"></div>
&nbsp;&nbsp;&nbsp;<FONT style="font-size:1em;font-family:calibri;text-transform:uppercase;"><B>View Tax Invoice</B></FONT>
<hr color="#D8E1F5" style="height:10px;">
<div class="cleaner h10"></div>
<div class="deeparea2" style="width:1048px;margin:auto;">

<?php
if($_POST[ch])
{
?>
<div id="Div_Print" style="width:1048px;margin:auto;margin-top:30px;border:0px solid #B0B0B0;text-align:center;">

<?php
$chk=$_POST[ch];
foreach($chk as $val)
{
$sql="select * from `order` a, `customer` c where  a.cusname=c.adv_id and a.or_id='$val'";
$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/9);
$procount=1;
$tcount=1;
$sum=0;
$taxtot=0;
$vattaxzero=0;
$vattaxfive=0;
$vattaxfteen=0;
$vattaxeteen=0;
$vattaxteight=0;
$totdis=0;
$totqty=0;
$gamtot=0;
for($j=1;$j<=$noofpage;$j++)
{
$limit=9;
$start=($j-1)*$limit;
?>
<table width="1048" align="center" cellpadding="1" cellspacing="1" style="font-family:arial;color:#494949;font-size:16px;padding:0px;margin:0px;">

<tr>
<td align="center" colspan="12">
<B>TAX INVOICE</B>
</td>
</tr>

<tr>
<td align="left" colspan="3" valign="top">
<span style="font-weight:bold;">PAUL ENTERPRISE</span><BR>
Vill & P.O. JANGALPARA BAZAR<BR>
Phone No. : 9932527047<BR>
GST No. : 19AJHPP7742G1ZS<BR>
PAN No. : AJHPP7742G
</td>
<td align="left" colspan="4" valign="top">
<?php print strtoupper($row[adv_name]); ?><BR>
<?php /*?><?php if($row[adv_add]) { print strtoupper($row[adv_add]); ?><BR><?php } ?><?php */?>
<?php if($row[adv_pl]) { print strtoupper($row[adv_pl]); ?><BR><?php } ?>
<?php if($row[adv_mobile]) { ?>Retailer Phone No. : <?php print $row[adv_mobile]; ?><BR><?php } ?>
<?php if($row[adv_tin]) { ?>Retailer GST No. : <?php print strtoupper($row[adv_tin]); ?><BR><?php } ?>
<?php if($row['adv_pan']!="" || $row['adv_aadhar']!="") { ?>RETAILER UID : <?php if($row['adv_pan']!="") { ?><?php print strtoupper($row['adv_pan']); ?><?php } if($row['adv_pan']=="" && $row['adv_aadhar']!="") { ?><?php print strtoupper($row['adv_aadhar']); ?><?php } } ?>
</td>
<td align="left" colspan="2" valign="top">
Date<BR>
Bill No.<BR>
Bank Acc<BR>
IFSC<BR>

</td>
<td align="left" colspan="3" valign="top">
<?php print $row[sdate]; ?><BR>
<?php print $row[or_bill]; ?><BR>
07990210000069 (UCO BANK)<BR>
UCBA0000799

</td>
</tr>

<tr>
<td align="center">Sl. No.</td>
<td align="left" colspan="2">Product Name</td>
<td align="center">Qty</td>
<td align="center">Free</td>
<td align="center">Rate</td>
<td align="center">Gross Amt</td>
<td align="center">Sch Disc</td>
<td align="center">CD Disc</td>
<td align="center">GST</td>
<td align="center">Net Rate</td>
<td align="center">Sl. Value</td>
</tr>

<?php
$sql2="select * from `product` p, `orderpro` op where  op.op_ref='$row[or_id]' and op.op_pro=p.pro_id limit $start,$limit";
$res2=mysqli_query($con,$sql2);
$numrow=mysqli_num_rows($res2);
if($j!=$noofpage)
{
$numrow5=8;
}
if($j==$noofpage)
{
$numrow5=$numrow2-($j-1)*8;
}
while($row2=mysqli_fetch_array($res2))
{
	if($row2[op_free]=="") 
	{
	 $scdis=0;
     $cdis=0;
     $gam=$row2[op_rate]*$row2[op_qty];
	 $gamtot+=$row2[op_rate]*$row2[op_qty];
	 //$scdis=$gam*($row2[pro_scdis]/100);
	 if($row2[op_sdis]!="")
	 {
	 $scdis=$gam*($row2[op_sdis]/100);
	 }
	 //$cdis=$gam*($row2[pro_cdis]/100);
	 if($row2[op_cdis]!="")
	 {
	 $cdis=$gam*($row2[op_cdis]/100);
	 }
     $netratewithouttax=$gam-($scdis+$cdis);
	 $tax=$netratewithouttax*($row2[pro_tax]/100);
	 $taxtot+=$netratewithouttax*($row2[pro_tax]/100);
	 $netrate=$gam-($scdis+$cdis)+$tax;
	 $totdis+=$scdis+$cdis;
	 $sum+=$netrate;
	 $totqty+=$row2[op_qty];
	 if($row2[pro_tax]=="0" || $row2[pro_tax]=="0.00" || $row2[pro_tax]=="00.00")
		{
         $vattaxzero+=$netratewithouttax;
		}
	 if($row2[pro_tax]=="5" || $row2[pro_tax]=="5.0" || $row2[pro_tax]=="5.00" || $row2[pro_tax]=="05")
		{
         $vattaxfive+=$netratewithouttax;
		}
     if($row2[pro_tax]=="12" || $row2[pro_tax]=="12.0" || $row2[pro_tax]=="12.00")
		{
         $vattaxfteen+=$netratewithouttax;
		}
	 if($row2[pro_tax]=="18" || $row2[pro_tax]=="18.0" || $row2[pro_tax]=="18.00")
		{
         $vattaxeteen+=$netratewithouttax;
		}
	 if($row2[pro_tax]=="28" || $row2[pro_tax]=="28.0" || $row2[pro_tax]=="28.00")
		{
         $vattaxteight+=$netratewithouttax;
		}
	}
?>
<tr>
<td align="center"><?php print $tcount; ?></td>
<td align="left" colspan="2"><?php print strtoupper(stripslashes(stripslashes(stripslashes($row2[pro_name])))) ?><?php if($row2[pro_hcn]!="") { ?><br>(HSN  <?php print $row2[pro_hcn]; ?>)<?php } ?>&nbsp;&nbsp;Rate: <?php print $row2[op_orate]; ?></td>
<td align="center"><?php if($row2[op_free]=="") { print $row2[op_qty]; } ?></td>
<td align="center"><?php if($row2[op_free]!="") {  print $row2[op_qty]; } ?></td>
<td align="center"><?php if($row2[op_free]=="") { print number_format($row2[op_rate],2); } ?></td>
<td align="center"><?php if($row2[op_free]=="") { print number_format($gam,2); } ?></td>
<td align="center"><?php if($row2[op_free]=="") { print number_format($row2[op_sdis],2)."%"; } ?></td>
<td align="center"><?php if($row2[op_free]=="") { print number_format($row2[op_cdis],2)."%"; } ?></td>
<td align="center"><?php if($row2[op_free]=="") { print number_format($row2[pro_tax],2)."%"; } ?></td>
<td align="center"><?php if($row2[op_free]=="") { print round(($netrate/$row2[op_qty]),2); } ?></td>
<td align="center"><?php if($row2[op_free]=="") { print number_format($netrate,2); } ?></td>
</tr>
<?php 
	$procount++;
    $tcount++;
} 
//if($numrow5<9)
//{
//$resttab=9-$numrow5;
//for($i=1;$i<=$resttab;$i++)
//{
?>
<!--<tr>
<td align="center" colspan="12">&nbsp;

</td>
</tr>-->
<?php
//}
//}
?>

<?php
if($j!=$noofpage)
{
?>
<tr>
<td align="center" colspan="12">&nbsp;</td>
</tr>

</td>
</tr>

<tr>
<td align="left"colspan="12" height="140" >&nbsp;

</td>
</tr>

<?php
}
?>

<?php
if($j==$noofpage)
{
?>

<tr>
<td align="center">&nbsp;</td>
<td align="left">Items : <?php print $tcount-1; ?></td>
<td align="center">&nbsp;</td>
<td align="center"><?php print $totqty; ?></td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center"><?php print number_format($gamtot,2); ?></td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center"><?php print number_format($sum,2); ?></td>
</tr>

<tr>
<td align="left" colspan="2" valign="top">
GST Description<BR>
GST %<BR>
GST %<BR>
GST %<BR>
GST %<BR>
GST %
</td>
<td align="left" valign="top">
GST %<BR>
0 %<BR>
5.00 %<BR>
12.00 %<BR>
18.00 %<BR>
28.00 %<BR>
</td>
<td align="left" colspan="3" valign="top">
Taxable Amount<BR>
<?php print number_format($vattaxzero,2); ?><BR>
<?php print number_format($vattaxfive,2); ?><BR>
<?php print number_format($vattaxfteen,2); ?><BR>
<?php print number_format($vattaxeteen,2); ?><BR>
<?php print number_format($vattaxteight,2); ?><BR>
</td>
<td align="left" valign="top">
CGST<BR>
<?php print number_format(($vattaxzero*0)/2,2); ?><BR>
<?php print number_format(($vattaxfive*(1/20))/2,2); ?><BR>
<?php print number_format(($vattaxfteen*(12/100))/2,2); ?><BR>
<?php print number_format(($vattaxeteen*(18/100))/2,2); ?><BR>
<?php print number_format(($vattaxteight*(28/100))/2,2); ?><BR>
</td>
<td align="left" valign="top">
SGST<BR>
<?php print number_format(($vattaxzero*0)/2,2); ?><BR>
<?php print number_format(($vattaxfive*(1/20))/2,2); ?><BR>
<?php print number_format(($vattaxfteen*(12/100))/2,2); ?><BR>
<?php print number_format(($vattaxeteen*(18/100))/2,2); ?><BR>
<?php print number_format(($vattaxteight*(28/100))/2,2); ?><BR>
</td>
<td align="left" colspan="3" valign="top">
Gross Amount :<BR>
Total Deduction :<BR>
Total GST :<BR>
Total CGST :<BR>
Total SGST :<BR>
Net Amount :
</td>
<td align="right" valign="top">
<?php print number_format($gamtot,2); ?><BR>
<?php print number_format($totdis,2); ?><BR>
<?php print number_format($taxtot,2); ?><BR>
<?php print number_format($taxtot/2,2); ?><BR>
<?php print number_format($taxtot/2,2); ?><BR>
<span style="font-size:1.2em;"><?php print number_format(round($sum)); ?></span><BR>
</td>
</tr>

<tr>
<td align="left" colspan="5" valign="top">

<?php
//$sumarr=explode(".",$sum);
//$str1=convert_number_to_words($sumarr[0]);
//$str2=convert_number_to_words($sumarr[1]);
//print ucwords(strtolower($str1." Rupees and ".$str2." Paise"));
print ucwords(strtolower(convert_number_to_words(round($sum))))." Rupees Only";
?>
</td>
<td align="center" colspan="3" valign="bottom">
Customer Signature
</td>
<td align="center" colspan="4" valign="bottom">
For PAUL ENTERPRISE
</td>
</tr>

<?php
}
?>

</table>
<?php
}
}
?>

</div>
<div class="cleaner h10"></div>
<div style="margin:auto;text-align:center;"><input type="button" value="Print Bill" class='all_button' 
onClick="javascript:PrintDivData('Div_Print');" id="prbill"></div>
<?php
}
?>
<div class="cleaner h20"></div>
</div>
</div>

<?php include("includes/footer.php"); ?>

</div>

</BODY>
</HTML>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: billprint.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation