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

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: payouts.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
$heading="Payout";
$listpage="payouts.php";
$table="cashbacks";
$pkey="id";
if(isset($_REQUEST['approve']) && $_REQUEST['approve']=="yes") {
	$d=date("Y-m-d");
	mysqli_query($con,"update `".$table."` set `pystatus`='1' where `retailer`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']=$heading." is approved successfully.";
	header("Location:".$listpage."#".$got);
	exit();
}
include("includes/headermain.php");
?>
<script language="javascript" type="text/javascript">
function del(page,id) {
	var fd=confirm("Are you sure to delete this entry?");
	if(fd==true) {
		location.href=page+"?id="+id+"&delete=yes";
	}	
}
function approve(page,id,got) {
	location.href=page+"?id="+id+"&got="+got+"&approve=yes";
}
function reject(page,id,got) {
	location.href=page+"?id="+id+"&got="+got+"&reject=yes";
}
</script>
<body>



<div class="preloader">
    <div class="lds-ripple">
        <div class="lds-pos"></div>
        <div class="lds-pos"></div>
    </div>
</div>



<div id="main-wrapper">
    <?php include("includes/header.php"); ?>
    <?php include("includes/leftmenu.php"); ?>
    
    
    
    <div class="page-wrapper">
        
        
        
            <div class="page-breadcrumb">
            <div class="row">
                <div class="col-12 d-flex no-block align-items-center">
                    <h4 class="page-title"><?php print $heading; ?>(s)</h4>
                    <div class="ml-auto text-right">
                        
                    </div>
                </div>
            </div>
        </div>
        
        
        
        
        
        
        <div class="container-fluid">
            
            
            
            <div class="row">
                <div class="col-md-12">
                    <div class="card pd-20" style="overflow: auto;">
                        <form action="#" method="post">
                            <div class="form-group col-md-6 floatleft">
                                
                                <input class="form-control" type="text" name="rname" id="rname" value="<?php print $_REQUEST['rname']; ?>" placeholder="By Retailer Name">
                            </div>
                            <div class="cleaner"></div>
                            <div class="form-group col-md-12">
                                <button type="submit" class="btn btn-primary ml-2 mt-2 pr-4 pl-4 floatleft">Search</button>
                                <button type="button" class="btn btn-primary ml-2 mt-2 pr-4 pl-4 floatleft" onClick="showall('<?php print basename(__FILE__); ?>');">Show All</button>
                                <button type="button" class="btn btn-primary ml-2 mt-2 pr-4 pl-4 floatleft" onClick="location.href='exportpayout.php'">Export</button>
                            </div>
                        </form>	
                        <div class="cleaner h20"></div>
                        <?php if($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr']; $_SESSION['msgerr']=""; ?></span><div class="cleaner h10"></div><?php } ?>
                        <?php if($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg']; $_SESSION['msg']=""; ?></span><div class="cleaner h10"></div><?php } ?>
                        <form action="print.php" method="post" name="dform">
                            <table class="table text-center">
                                <thead class="text-uppercase bg-primary">
                                    <tr class="text-white">
                                        <?php /* ?><td class="border-bnd-lf" align="left"><strong>Sl.</strong></td><?php */ ?>
                                        <td class="border-bnd-lf" align="left"><strong>Retailer</strong></td>
                                        <td align="left"><strong>Total Amount</strong></td>
                                        <td align="left"><strong>Paid</strong></td>
                                        <td align="left"><strong>Pending</strong></td>
                                        <td class="border-bnd-rg" align="left"><strong>Option</strong></td>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                    $totam=0;
                                    $paid=0;
                                    $sql="select distinct `retailer`, rt.* from `".$table."` cs, `retailers` rt where cs.retailer=rt.id and cs.status='1' and rt.status='1'";
                                    if(isset($_REQUEST['rname']) && $_REQUEST['rname']!="") {
                                        $sql.=" and rt.name like '%".$_REQUEST['rname']."%'";
                                    }
                                    $sql.=" order by cs.".$pkey."";
                                    //print $sql;
                                    $res=mysqli_query($con,$sql);
                                    if(mysqli_num_rows($res)>=1) {
                                        while($row=mysqli_fetch_assoc($res)) {
                                            $rowatot=mysqli_fetch_assoc(mysqli_query($con,"select sum(cashback) as cbk from `".$table."` where `retailer`='".$row['retailer']."' and `status`='1'"));
                                            $rowapd=mysqli_fetch_assoc(mysqli_query($con,"select sum(cashback) as cbk from `".$table."` where `retailer`='".$row['retailer']."' and `pystatus`='1' and `status`='1'"));
                                            $pending=$rowatot['cbk']-$rowapd['cbk'];
                                            $totam+=$rowatot['cbk'];
                                            $totpaid+=$rowapd['cbk'];
                                    ?>
                                            <tr <?php if($row[$status]=="0") { ?>class="bg-red"<?php } ?> id="go<?php print $flag++; ?>">
                                                <?php /* ?><td align="left"><?php print $flag; ?></td><?php */ ?>
                                                <td align="left"><strong><?php print $row['name']; ?></strong><br>(<?php print $row['mobile']; ?>)</td>
                                                <td align="left"><img src="assets/images/rs.png" height="12" alt="" style="padding-bottom: 2px;">&nbsp;<?php print $rowatot['cbk']; ?></td>
                                                <td align="left"><img src="assets/images/rs.png" height="12" alt="" style="padding-bottom: 2px;">&nbsp;<strong><?php print $rowapd['cbk']; ?></strong></td>
                                                <td align="left"><img src="assets/images/rs.png" height="12" alt="" style="padding-bottom: 2px;">&nbsp;<?php print $pending; ?></td>
                                                <td>
                                                    <?php if($pending>0) { ?>
                                                        <button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" onClick="location.href='paymentdet.php?eid=<?php print base64_encode($row['retailer']); ?>&rname=<?php print $_REQUEST['rname']; ?>&pg=<?php print $_REQUEST['pg']; ?>&flag=<?php print $_REQUEST['flag']; ?>'">Clear Pending</button> <?php /* ?>onCli&rname=<?php print $_REQUEST['rname']; ?>"approve('<?php print $listpage; ?>','<?php print $row['retailer']; ?>','<?php print $flag; ?>');"<?php */ ?>
                                                    <?php } ?> 
                                                </td>
                                            </tr>
                                        <?php } ?>
                                        <tr>
                                            <td colspan="6" align="right">
                                                <strong>Total: <img src="assets/images/rs.png" height="12" alt="" style="padding-bottom: 2px;">&nbsp;<?php print $totam; ?>&nbsp;&nbsp;&nbsp;Paid: <img src="assets/images/rs.png" height="12" alt="" style="padding-bottom: 2px;">&nbsp;<?php print $totpaid; ?>&nbsp;&nbsp;&nbsp;Pending: <img src="assets/images/rs.png" height="12" alt="" style="padding-bottom: 2px;">&nbsp;<?php print ($totam-$totpaid); ?></strong>
                                            </td>
                                        </tr>
                                    <?php } else { ?>
                                        <tr>
                                            <td colspan="7">Sorry, nothing found.</td>
                                        </tr>
                                    <?php } ?>	
                                </tbody>
                            </table>
                        </form>	
                    </div>
                </div>
            </div>    
        </div>
        
        
        
        <?php include("includes/footer.php"); ?>
    </div>
    
    
    
</div>






<script src="assets/libs/jquery/dist/jquery.min.js"></script>

<script src="assets/libs/popper.js/dist/umd/popper.min.js"></script>
<script src="assets/libs/bootstrap/dist/js/bootstrap.min.js"></script>
<script src="assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>
<script src="assets/extra-libs/sparkline/sparkline.js"></script>

<script src="dist/js/waves.js"></script>

<script src="dist/js/sidebarmenu.js"></script>

<script src="dist/js/custom.min.js"></script>



<script src="assets/libs/flot/excanvas.js"></script>
<script src="assets/libs/flot/jquery.flot.js"></script>
<script src="assets/libs/flot/jquery.flot.pie.js"></script>
<script src="assets/libs/flot/jquery.flot.time.js"></script>
<script src="assets/libs/flot/jquery.flot.stack.js"></script>
<script src="assets/libs/flot/jquery.flot.crosshair.js"></script>
<script src="assets/libs/flot.tooltip/js/jquery.flot.tooltip.min.js"></script>
<script src="dist/js/pages/chart/chart-page-init.js"></script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: payouts.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation