Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/crm/backup

Free Space:

9.3 TB

🔧 Quick Actions

✏️ Editing: shops_print.php

<?php  include "../top.php"; 
$sid=$_REQUEST['saleid'];

$getsale=f(q("SELECT * FROM tbl_sales WHERE p_id='$sid'"));
$getcust=f(q("SELECT * FROM tbl_shops WHERE ag_id='$getsale[p_prov_id]'"));
$getcomp=f(q("SELECT * FROM tbl_company WHERE cmp_id='$getsale[p_comp]'"));
$gstrate=round(floatval($getsale['p_gstrate'])/2,1);
$gstamount=round(floatval($getsale['p_gst'])/2,2);

$billdate=date_create($getsale['p_bdate']);
                    $billdate=date_format($billdate,"d-m-y");
?>
<link href="https://fonts.googleapis.com/css?family=Roboto+Mono" rel="stylesheet">
<div style="width:300px;font-family: 'Roboto Mono', monospace;">
<div style="padding-top:0px;padding-left:20px;margin-top: -10px;">
    <div style="width:100%;padding:5px;text-align: center;">
           <h2 style="font-size:20px;font-family: Arial;"> <?php echo $getcomp['cmp_name']?></h2>

</div>
    <div style="width:100%;padding:1px;font-size:12px;text-align: center;margin-top:-20px;">
            <?php echo $getcomp['cmp_address']?> &nbsp;PH :<?php echo $getcomp['cmp_phone']?>

</div>
    <div style="width:100%;padding:5px;font-size:12px;font-weight:500;text-align: center;">
        <div style="width:100%;padding:5px;font-size:14px;font-weight:400;text-align: center;float: left;">

GSTN:<?php echo $getcomp['cmp_GST']?>
        </div>
        
    </div>
    <div style="width:100%;padding:5px;font-size:12px;font-weight:500;text-align: center;">
        <div style="width:45%;padding:5px;font-size:10px;font-weight:600;text-align: left;float: left;">

Bill No:&nbsp;<?php echo $getsale['p_bill']?>
        </div>
        <div style="width:45%;padding:5px;font-size:10px;font-weight:500;text-align: right;float: left;">

Date:<?php echo $billdate?>
        </div>

</div>
</div>
<!-- <div style="padding-top:10px;padding-left:20px;">
    <div style="width:100%;padding-left:5px;font-size: 16px;">
            <strong>Name:</strong> <?php echo $getcust['ag_name']?>

</div>
    <div style="width:100%;padding-left:5px;font-size: 16px;">
            <strong>Address:</strong> <?php echo substr($getcust['ag_address'], 0,17);?>&nbsp;<strong>Ph:</strong> <?php echo $getcust['ag_phone']?>
    </div>
</div> -->

<div style="padding-top:10px;padding-left:20px;">
    <table style="width:290px">
        
<tr style="width:100%;border-top:1px solid #000000;border-bottom: 1px solid #000000;font-size:12px;">
                <td style="width:55%;border-top:1px solid #000000;border-bottom: 1px solid #000000;border-right:1px solid black;text-align:center;">DESCRIPTION</td>
                
                <td style="width:15%;border-top:1px solid #000000;border-bottom: 1px solid #000000;border-right:1px solid black;text-align:center;">QTY</td>
                <td style="width:15%;border-top:1px solid #000000;border-bottom: 1px solid #000000;border-right:1px solid black;text-align:center;">RATE</td>
                <td style="width:15%;border-top:1px solid #000000;border-bottom: 1px solid #000000;text-align:center;">AMOUNT</td>
</tr>

<?php
    $q=mysqli_query($con,"SELECT * FROM tbl_s_details WHERE pd_p_id='$sid'");
    $cnt=0;
    $tot=0;
    while($arrs=mysqli_fetch_array($q)){
        $getprod=f(q("SELECT * FROM tbl_products WHERE prod_id='$arrs[pd_prodid]'"));
         $getunit=f(q("SELECT * FROM tbl_unit WHERE u_id='$arrs[pd_unit]'"));
         $unitid=$getunit['u_name'];
         ?>
            <tr style="width:100%;font-size:11px;">
                <td style="width:55%;text-align:center;border-right:1px solid black;"><?php echo $getprod['prod_name']?></td>
               
                <td style="width:15%;text-align:center;border-right:1px solid black;"><?php echo $arrs['pd_quan']?></td>
                <td style="width:15%;text-align:center;border-right:1px solid black;"><?php echo $arrs['pd_price']?></td>
                <td style="width:15%;text-align:center;"><?php echo round($arrs['pd_total'],2)?></td>
            </tr>   
<?php $cnt=$cnt+1;

$tot=floatval($tot)+floatval($arrs['pd_total']);  }

// if($cnt<25){

//     $rest=25-floatval($cnt);
//     //echo $rest;
//     for ($k=0;$k<floatval($rest);$k++){

<?php //}

// }

$rval=round($tot);
$diff=round(floatval($rval)-floatval($tot),2);
$sign='';
//echo "Difference".$diff."<br>";
if(is_float($diff) && $diff<0.01){

if($diff=='0'){
       // $diff=0;
    }else{

$sign="-";
    $diff=substr($diff, 1);
    }

}else{
    $sign="+";

}

// //echo "HELLO";
// if(floatval($diff)>0.49){
//     $sign="+";
//    // $diff=substr($diff, 1);
// }else{
//     $sign="-";
//     $diff=substr($diff, 1);
// }
// echo "Difference".$diff;
// }else{
//     $diff='';
// }

?>
</table>
<table  style="width:280px">
            
            <tr style="width:100%;font-size:12px;">
                <td style="width:55 %;text-align:center;border-right:1px solid black;"></td>
                
                
                <td style="width:30%;text-align:center;border-top:1px solid #000000;border-right:1px solid black;"><b><? if(floatval($getsale['p_disc'])>0){ ?>Sub Total<?}else{?>Net Total<?php } ?></b></td>
                <td style="width:15%;text-align:center;border-top:1px solid #000000;font-size:12px;">&nbsp;<?php echo $getsale['p_subtotal']?></td>
            </tr>
           <?php if(floatval($getsale['p_disc'])>0){ ?> <tr style="width:100%;font-size:12px;">
                <td style="width:55%;text-align:center;border-right:1px solid black;"></td>
                
                
                <td style="width:30%;text-align:center;border-top:1px solid #000000;border-right:1px solid black;"><b>Discount @<?php echo $getsale['p_disc']?>%</b></td>
                <td style="width:15%;text-align:center;border-top:1px solid #000000;font-size:12px;">&nbsp;<?php echo $getsale['p_discamt']?></td>
            </tr>
            <tr style="width:100%;font-size:12px;">
                <td style="width:55%;text-align:center;border-right:1px solid black;"></td>
                
                
                <td style="width:30%;text-align:center;border-top:1px solid #000000;border-right:1px solid black;"><b>Net Total</b></td>
                <td style="width:15%;text-align:center;border-top:1px solid #000000;font-size:12px;">&nbsp;<?php echo $getsale['p_nettotal']?></td>
            </tr>

<?php } ?>
        <tr style="width:100%;font-size:12px;">
                <td style="width:55%;text-align:center;border-right:1px solid black;"></td>
                
                
                <td style="width:30%;text-align:center;border-top:1px solid #000000;border-right:1px solid black;"><b>CGST @<?php echo $gstrate?>%</b></td>
                <td style="width:15%;text-align:center;border-top:1px solid #000000;font-size:12px;">&nbsp;<?php echo $gstamount?></td>
            </tr>
            <tr style="width:100%;font-size:12px;">
                <td style="width:55%;text-align:center;border-right:1px solid black;"></td>
                
                
                <td style="width:30%;text-align:center;border-top:1px solid #000000;border-right:1px solid black;"><b>SGST @<?php echo $gstrate?>%</b></td>
                <td style="width:15%;text-align:center;border-top:1px solid #000000;font-size:12px;">&nbsp;<?php echo $gstamount?></td>
            </tr>

<tr style="width:100%;font-size:12px;">
                <td style="width:55%;text-align:center;border-bottom: 1px solid #000000;border-right:1px solid black;"></td>
                
                
                <td style="width:30%;text-align:center;border-top:1px solid #000000;border-bottom: 1px solid #000000;border-right:1px solid black;"><b>Total</b></td>
                <td style="width:15%;text-align:center;border-top:1px solid #000000;border-bottom: 1px solid #000000;font-weight: bold;"><?php echo $getsale['p_grandtotal']?></td>
            </tr>

</table>

</div>
<div style="padding-top:30px;padding-left:20px;">
    <div style="width:100%;padding-left:5px;font-size: 12px;text-align: center;">
          <?php echo $getcomp['cmp_footernote']?>

</div>           
</div>
</div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: shops_print.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation