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: billafed.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;
}

$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);
$procount=1;
$tcount=1;
$sum=0;
$taxtot=0;
$vattaxfive=0;
$vattaxfteen=0;
$vattaxzero=0;
$totdis=0;
$totqty=0;
$gamtot=0;
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=1350,toolbar=0,scrollbars=0,status=0');
        printscreen.document.write(ctrlcontent.innerHTML);
        printscreen.document.close();
        printscreen.focus();
        printscreen.print();
        printscreen.close();
    }
</script>

<BODY>

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

<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:1350px;">

<div class="cleaner h20"></div>
<div id="Div_Print" style="width:1350px;margin:0px;margin-top:0px;padding:0px;border:0px solid #B0B0B0;text-align:center;">
<?php
for($j=1;$j<=$noofpage;$j++)
{
$limit=10;
$start=($j-1)*$limit;
?>
<table width="1350" align="center" cellpadding="5" cellspacing="1" style="font-family:arial;color:#494949;font-size:21px;padding:0px;margin:0px;">

<tr>
<td align="center" colspan="11">
<strong>TAX INVOICE</strong>
</td>
</tr>

<tr>
<td align="left" colspan="3" valign="top">
<span style="font-weight:bold;">M/S. JATINDRA NATH DAS</span><BR>
VILL & P.O. KAMARKUNDU. DIST.<BR>
PHONE NO : 9051746103<BR>
TIN NO : 19731347442<BR>
</td>
<td align="left" colspan="4" valign="top">
<?php print strtoupper($row[adv_name]); ?><BR>
<?php if($row[adv_add]) { print strtoupper($row[adv_add]); ?><BR><?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 TIN NO : <?php print strtoupper($row[adv_tin]); ?><BR><?php }?>
</td>
<td align="left" colspan="2" valign="top">
Date<BR>
Bill No.

</td>
<td align="left" colspan="2" valign="top">
<?php print $row[sdate]; ?><BR>
<?php print $row[or_bill]; ?>

</td>
</tr>

<tr>
<td align="center">Sl. No.</td>
<td align="left">Product Name</td>
<td align="center">MRP</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">Tax</td>
<td align="center">Net Rate</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);
while($row2=mysqli_fetch_array($res2))
{
	if($row2['op_free']=="") 
	{
	 $scdis=0;
     $cdis=0;
     $gam=$row2[pro_rate]*$row2[op_qty];
	 $gamtot+=$row2[pro_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]=="5" || $row2[pro_tax]=="5.0" || $row2[pro_tax]=="5.00" || $row2[pro_tax]=="05")
		{
         $vattaxfive+=$netratewithouttax;
		}
     if($row2[pro_tax]=="14.5" || $row2[pro_tax]=="14.50")
		{
         $vattaxfteen+=$netratewithouttax;
		}
     if($row2[pro_tax]=="0" || $row2[pro_tax]=="0.00" || $row2[pro_tax]=="00.00")
		{
         $vattaxzero+=$netratewithouttax;
		}
	}
?>
<tr>
<td align="center"><?php print $tcount; ?></td>
<td align="left"><?php print strtoupper(stripslashes(stripslashes(stripslashes($row2[pro_name])))) ?></td>
<td align="center"><?php print number_format($row2[pro_mrp],2) ?></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[pro_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 number_format($netrate,2); } ?></td>
</tr>
<?php 
	$procount++;
    $tcount++;
} 
//$resttab=12-$procount;
//for($i=1;$i<=$resttab;$i++)
//{
?>

<?php
//}
?>

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

<tr>
<td align="left"colspan="11" height="200" >&nbsp;

</td>
</tr>

<tr>
<td align="left" colspan="11" height="90">&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"><?php print number_format($sum,2); ?></td>
</tr>

<tr>
<td align="left" colspan="2" valign="top">
Tax Description<BR>
Vat Tax %<BR>
Vat Tax %<BR>
Vat Tax %
</td>
<td align="left" colspan="2" valign="top">
Tax %<BR>
0 %<BR>
5.00 %<BR>
14.50 %<BR>
</td>
<td align="left" colspan="2" 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>
</td>
<td align="left" colspan="2" valign="top">
Tax Amount<BR>
<?php print number_format($vattaxzero*0,2); ?><BR>
<?php print number_format($vattaxfive*(1/20),2); ?><BR>
<?php print number_format($vattaxfteen*(14.5/100),2); ?><BR>
</td>
<td align="left" colspan="2" valign="top">
Gross Amount :<BR>
Total Deduction :<BR>
Total Tax :<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>
<span style="font-size:1.2em;"><?php print number_format(round($sum)); ?></span><BR>
</td>
</tr>

<tr>
<td align="left" colspan="5" height="40" 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" height="40" valign="bottom">
Customer Signature
</td>
<td align="center" colspan="3" height="40" valign="bottom">
For JATINDRA NATH DAS
</td>
</tr>

<?php
}
?>
<tr>
<td align="left" colspan="11" height="20">&nbsp;

</td>
</tr>
</table>
<?php
}
?>
</div>
<?php
$sumc=round($sum);
mysqli_query($con,"update `order`  set `totamount`='$sumc'  where `or_id`='".$_REQUEST['id']."'");
?>
<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>
<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: billafed.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation