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

🔧 Quick Actions

✏️ Editing: couponsbkp.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
$eid=isset($_REQUEST['eid'])?$_REQUEST['eid']:'';	
$action=isset($_REQUEST['action'])?$_REQUEST['action']:'Add';
$name=isset($_REQUEST['name'])?$_REQUEST['name']:'';
$pg=isset($_REQUEST['pg'])?$_REQUEST['pg']:'';
$flag=isset($_REQUEST['flag'])?$_REQUEST['flag']:'';
$heading="Coupon";
$listpage="coupons.php";
$table="coupons";
$pkey="cid";
$status="status";
$tablea="products";
if(isset($_REQUEST['delete']) && $_REQUEST['delete']=="yes") {
	mysqli_query($con,"delete from `".$table."` where `".$pkey."`='".$_REQUEST['id']."'");
	$_SESSION['msg']="Entry is deleted successfully.";
	header("Location:".$listpage);
	exit();	
}
if(isset($_REQUEST['approve']) && $_REQUEST['approve']=="yes") {
	$d=date("Y-m-d");
	mysqli_query($con,"update `".$table."` set `".$status."`='1' where `".$pkey."`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']=$heading." is approved successfully.";
	header("Location:".$listpage."#".$got);
	exit();
}
if(isset($_REQUEST['reject']) && $_REQUEST['reject']=="yes") {
	mysqli_query($con,"update `".$table."` set `".$status."`='0' where `".$pkey."`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']=$heading." is rejected successfully.";
	header("Location:".$listpage."#".$got);
	exit();
}
if($_GET['pg']) {
	$pg=$_GET['pg'];
} else {
	$pg=1;
}
$upper=25;
$lower=$upper*($pg-1);
$sql="select * from `".$table."` cp, `".$tablea."` pr where cp.proref=pr.id";
if(isset($_REQUEST['code']) && $_REQUEST['code']!="") {
    $sql.=" and cp.code like '%".$_REQUEST['code']."%'";
}
if(isset($_REQUEST['batch']) && $_REQUEST['batch']!="") {
    $sql.=" and pr.batch like '%".$_REQUEST['batch']."%'";
}
if(isset($_REQUEST['fdate']) && $_REQUEST['fdate']!="") {
    $sql.=" and pr.date='".$_REQUEST['fdate']."'";
}
if(isset($_REQUEST['product']) && $_REQUEST['product']!="") {
    $sql.=" and pr.proname like '%".$_REQUEST['product']."%'";
}
if(isset($_REQUEST['amount']) && $_REQUEST['amount']!="") {
    $sql.=" and cp.amount='".$_REQUEST['amount']."'";
}
if(isset($_REQUEST['ustatus']) && $_REQUEST['ustatus']!="") {
    $sql.=" and cp.ustatus='".$_REQUEST['ustatus']."'";
}
$res=mysqli_query($con,$sql);
$num=mysqli_num_rows($res);
$pgno=intval($num/$upper);
if($num%$upper!=0) {
	$pgno=$pgno+1;
}
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";
}
function select(a) {
	var theForm = document.dform;
	for (i=0; i<theForm.elements.length; i++) {
		if (theForm.elements[i].name=='ch[]')
			theForm.elements[i].checked = a;
	}
}
function sortby(val) {
    location.href="coupons.php?srtby="+val;
}
</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">Add <?php print $heading; ?></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="get">
                            <div class="form-group col-md-4 floatleft">
                                
                                <input class="form-control" type="text" name="code" id="code" value="<?php print $_REQUEST['code']; ?>" placeholder="By Code">
                            </div>
                            <div class="form-group col-md-4 floatleft">
                                
                                <input class="form-control" type="text" name="batch" id="batch" value="<?php print $_REQUEST['batch']; ?>" placeholder="By Batch">
                            </div>
                            <div class="form-group col-md-4 floatleft">
                                
                                <input class="form-control" type="date" name="fdate" id="fdate" value="<?php print $_REQUEST['fdate']; ?>" placeholder="By Date">
                            </div>
                            <div class="cleaner"></div>
                            <div class="form-group col-md-6 floatleft">
                                
                                <input class="form-control" type="text" name="product" id="product" value="<?php print $_REQUEST['product']; ?>" placeholder="By Product">
                            </div>
                            <div class="form-group col-md-3 floatleft">
                                
                                <input class="form-control" type="text" name="amount" id="amount" value="<?php print $_REQUEST['amount']; ?>" placeholder="By Amount">
                            </div>
                            <div class="form-group col-md-3 floatleft">
                                
                               <select class="form-control" name="ustatus">
                                    <option value="">Select Status
                                    <option value="1" <?php if($_REQUEST['status']=="1") { ?>selected<?php } ?>>Used
                                    <option value="0" <?php if($_REQUEST['status']=="0") { ?>selected<?php } ?>>Not Used
                                </select>
                            </div>
                            <div class="cleaner"></div>
                            <div class="form-group col-md-12">
                                <button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
                                <button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft" onClick="showall('<?php print basename(__FILE__); ?>');">Show All</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">
                                        <td class="border-bnd-lf" align="left"><strong>Chk</strong></td>
                                        <td align="left"><strong>Batch</strong></td>
                                        <td align="left"><strong>Code</strong></td>
                                        <td align="left"><strong>Cashback</strong></td>
                                        <td align="left"><strong>QR</strong></td>
                                        <td class="border-bnd-rg" align="left"><strong>Used By</strong></td>
                                    </tr>
                                </thead>
                                <tbody>
                                    <tr>
                                        <td colspan="3" align="left">
                                            <select name="srtby" id="srtby" onChange="sortby(this.value);">
                                                <option value="">Sort By
                                                <option value="coupon" <?php if($_REQUEST['srtby']=="coupon") { ?>selected<?php } ?>>Coupon
                                                <option value="amount" <?php if($_REQUEST['srtby']=="amount") { ?>selected<?php } ?>>Amount
                                            </select>
                                        </td>
                                        <td colspan="3" align="right">
                                            <a href="javascript:select(1)">Check All</a> | <a href="javascript:select(0)" >Uncheck All</a>&nbsp;
                                            <button type="submit" class="btn btn-primary ml-2 pr-4 pl-4 floatright">Print</button>
                                        </td>
                                    </tr>
                                    <?php
                                    if($lower==0) {
                                        $flag=0;
                                    } else {
                                        $flag=$lower;
                                    }
                                    $sql="select * from `".$table."` cp, `".$tablea."` pr where cp.proref=pr.id";
                                    if(isset($_REQUEST['code']) && $_REQUEST['code']!="") {
                                        $sql.=" and cp.code like '%".$_REQUEST['code']."%'";
                                    }
                                    if(isset($_REQUEST['batch']) && $_REQUEST['batch']!="") {
                                        $sql.=" and pr.batch like '%".$_REQUEST['batch']."%'";
                                    }
                                    if(isset($_REQUEST['fdate']) && $_REQUEST['fdate']!="") {
                                        $sql.=" and pr.date='".$_REQUEST['fdate']."'";
                                    }
                                    if(isset($_REQUEST['product']) && $_REQUEST['product']!="") {
                                        $sql.=" and pr.proname like '%".$_REQUEST['product']."%'";
                                    }
                                    if(isset($_REQUEST['amount']) && $_REQUEST['amount']!="") {
                                        $sql.=" and cp.amount='".$_REQUEST['amount']."'";
                                    }
                                    if(isset($_REQUEST['ustatus']) && $_REQUEST['ustatus']!="") {
                                        $sql.=" and cp.ustatus='".$_REQUEST['ustatus']."'";
                                    }
                                    if(isset($_REQUEST['srtby']) && $_REQUEST['srtby']!="") {
                                        $sql.=" order by cp.".$_REQUEST['srtby'];
                                    } else {
                                        $sql.=" order by cp.".$pkey;
                                    }
                                    $sql.=" limit ".$lower.",".$upper;
                                    $res=mysqli_query($con,$sql);
                                    if(mysqli_num_rows($res)>=1) {
                                        while($row=mysqli_fetch_assoc($res)) {
                                    ?>
                                            <tr <?php if($row[$status]=="0") { ?>class="bg-red"<?php } ?> id="go<?php print $flag++; ?>">
                                                <td align="left"><?php print $flag; ?><br><input type="checkbox" name="ch[]" value="<?php print $row['cid']; ?>"></td>
                                                <td align="left"><?php print $row['batch']; ?><br>(<?php print $row['proname']; ?>)</td>
                                                <td align="left"><?php print $row['coupon']; ?></td>
                                                <td align="left"><img src="assets/images/rs.png" height="12" alt="" style="padding-bottom: 2px;">&nbsp;<?php print $row['amount']; ?></td>
                                                <td align="left"><img src="https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=<?php print $row['coupon']; ?>" width="150" alt=""></td>
                                                <td align="left">
                                                    <?php if($row['ustatus']=="0") { ?>
                                                        <br><button type="button" class="btn bg-success btn-primary mt-2 pr-4 pl-4 floatleft">Not Used</button>
                                                    <?php } else { ?>	
                                                        <br><button type="button" class="btn bg-danger btn-primary mt-2 pr-4 pl-4 floatleft">Used</button>
                                                    <?php } ?>
                                                    <div class="cleaner h5"></div>
                                                    <?php
                                                    if($row['ustatus']=="1") { 
                                                        $rowus=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `retailers` rt, `cashbacks` cs where rt.id=cs.retailer and cs.coupon='".$row['coupon']."'"));
                                                    ?>    
                                                        <strong>(Used By: <?php print $rowus['name']; ?>)</strong>
                                                    <?php } ?>
                                                </td>    
                                            </tr>
                                    <?php } } else { ?>
                                        <tr>
                                            <td colspan="7">Sorry, nothing found.</td>
                                        </tr>
                                    <?php } ?>	
                                </tbody>
                            </table>
                        </form>	
                        <?php if($num>=1) { ?>
                            <div class="cleaner h20"></div>
                                    
                            <?php include("includes/pagination.php"); ?>
                                
                        <?php } ?>	
                    </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: couponsbkp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation