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: allduebill-report.php

<?phpinclude "top.php";

$action=$_REQUEST['action'];
    if($action=='search'){
    
        $startdate=$_POST['startdate'];
        $enddate=$_POST['enddate'];
    
        $sql="SELECT * FROM tbl_sales WHERE p_bdate BETWEEN '$startdate' AND '$enddate'";
        //echo $sql;
    
    
    
    
    
    }
?>

        
        
        <div class="page-wrapper">

<div class="container-fluid">
                
                
                
                <div class="row">
                    
                    
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <h2 class="card-title m-b-0">All Due Bill Report <?php if($getsales['ag_name']!=''){ echo "for ".$getsales['ag_name']; } ?> from <?php echo $startdate?> to <?php echo $enddate?></h2>
                                <table id="example" class="table table-striped table-bordered" style="width:100%" border="1">
        <thead>
            <tr>
             <th>Bill No</th>
                <th>Shop Name</th>
                <th>Date</th>
                
               
                <th>Details</th>
                 <th>Net Amount</th>
               <th>Due</th>
                
                
                
                
            </tr>
        </thead>
        <tbody>
             <?php
                    $cq=mysqli_query($con,$sql);
                    while($arrc=mysqli_fetch_array($cq)){
                        $vend=f(q("SELECT * FROM tbl_shops WHERE ag_id='$arrc[p_prov_id]'"));
                        $vend2=f(q("SELECT * FROM tbl_area WHERE u_id='$vend[ag_area]'"));
                       $dueq=f(q("SELECT SUM(sp_amt) as totpay FROM tbl_salespay WHERE sp_sid='$arrc[p_id]'"));
                       $dueamt=floatval($arrc['p_netamt'])-floatval($dueq['totpay']);
                       $str='';
                        
            ?>
            <tr>
                <td><?php echo $arrc['p_bill']?></td>
                <td>Shop Name: <?php echo $vend['ag_name']?><br>
                    Area Name: <?php echo $vend2['u_name']?>
                </td>
                <td><?php echo $arrc['p_bdate']?></td>
                
               
                <td>
                        <?php $prded=mysqli_query($con,"SELECT * FROM tbl_s_details WHERE pd_p_id='$arrc[p_id]'");
                            while($arrdet=mysqli_fetch_array($prded)){ 
                                $getprod=f(q("SELECT * FROM tbl_products WHERE prod_id='$arrdet[pd_prodid]'"));
                                $getunit=f(q("SELECT * FROM tbl_unit WHERE u_id='$arrdet[pd_unit]'"));
                                $unitid=$getunit['u_name'];
                                $str=$str." ".$getprod['prod_name']."(".$arrdet['pd_quan']." ".$unitid." )"."<br>" ;
                        
                        
                        
                        } echo $str;?>
            
            
            
                </td>
                 <td>&#8377;<?php echo $arrc['p_netamt']?>
                     <?php  $totamt=floatval($totamt) + floatval($arrc['p_netamt']); ?>

</td>
                <td>
                        &#8377; <?php echo $dueamt?>
                        <?php  $totdue=floatval($totdue) + floatval($dueamt); ?>
                </td>
               
                
              
            </tr>

<?php } ?>
        <tfoot>
            <tr>
            <th></th>
                <th></th>
                <th></th>
                <th></th>
                <th>Total Amount : &#8377;<?php echo $totamt?></th>
                <th>Total Due : &#8377;<?php echo $totdue?></th>
            </tr>
        </tfoot>
    </table>
                            </div>
                        </div>
                        
                    </div>
                </div>
                
                
                
                
                
                
                
                
                
                
                
                
            </div>
            </div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: allduebill-report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation