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/xtrakare.in/public_html/webadmin

Free Space:

1.93 TB

🔧 Quick Actions

✏️ Editing: vledger.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
if(isset($_REQUEST['approve']) && $_REQUEST['approve']=="yes") {
	$dt=date("Y-m-d");
	mysqli_query($con,"update `orderpro` set `vpayment`='1', `vpdate`='".$dt."' where `orderline_id`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']="Payment is done successfully.";
	header("Location:vledger.php?vendor=".$_REQUEST['vendor']."#".$got);
	exit();
}
if(isset($_REQUEST['reject']) && $_REQUEST['reject']=="yes") {
	mysqli_query($con,"update `orderpro` set `vpayment`='0', `vpdate`='0000-00-00' where `orderline_id`='".$_REQUEST['id']."'");
	$got="go".$_REQUEST['got'];
	$_SESSION['msg']="Payment is rejected successfully.";
	header("Location:vledger.php?vendor=".$_REQUEST['vendor']."#".$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,vendor,got) {
	location.href=page+"?id="+id+"&vendor="+vendor+"&got="+got+"&approve=yes";
}
function reject(page,id,vendor,got) {
	location.href=page+"?id="+id+"&vendor="+vendor+"&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">Vendor Payment</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">
                                <label for="example-date-input" class="col-form-label">From Date</label>
                                <input class="form-control sphgt" type="date" name="fdate" id="fdate" value="<?php print $_REQUEST['fdate']; ?>">
                            </div>
                            <div class="form-group col-md-4 floatleft">
                                <label for="example-date-input" class="col-form-label">To Date</label>
                                <input class="form-control sphgt" type="date" name="tdate" id="tdate" value="<?php print $_REQUEST['tdate']; ?>">
                            </div>
                            <div class="form-group col-md-4 floatleft">
                                <label for="example-date-input" class="col-form-label">Vendor</label>
                                <select class="form-control sphgt" name="vendor" id="vendor" required>
                                    <option value="">Select Vendor
                                    <?php
                                    $resc=mysqli_query($con,"select * from `retailers` where `status`='1'");
                                    while($rowc=mysqli_fetch_object($resc)) {
                                    ?>
                                        <option value="<?php print $rowc->id; ?>" <?php if($rowc->id==$_REQUEST['vendor']) { ?>selected<?php } ?>><?php print $rowc->name ?>
                                    <?php } ?>
                                </select>
                            </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>
                            </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>Date</strong></td>
                                        <td align="left"><strong>Bill No.</strong></td>
                                        <td align="left" width="20%"><strong>Amount</strong></td>
                                        <td align="left" width="20%"><strong>Payment</strong></td>
                                        <td class="border-bnd-rg" align="left"><strong>Acceptance</strong></td>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                    $totam=0;
                                    $payment=0;
                                    $sql="select * from `orderpro` where `status`!='Order Cancelled' and `vdelivered`='1'";
                                    if(isset($_REQUEST['fdate']) && $_REQUEST['fdate']!="") {
                                        $sql.=" and `orderpro_dt`>='".$_REQUEST['fdate']."'";
                                    }
                                    if(isset($_REQUEST['tdate']) && $_REQUEST['tdate']!="") {
                                        $sql.=" and `orderpro_dt`<='".$_REQUEST['tdate']."'";
                                    }
                                    if(isset($_REQUEST['vendor']) && $_REQUEST['vendor']!="") {
                                        $sql.=" and `vendor`='".$_REQUEST['vendor']."'";
                                    }
                                    $sql.=" order by `orderline_id`";
                                    //print $sql;
                                    $res=mysqli_query($con,$sql);
                                    if(mysqli_num_rows($res)>=1) {
                                        while($row=mysqli_fetch_assoc($res)) {
                                            $totam+=$row['orderpro_val'];
                                            if($row['vpayment']=="1") {
                                                $payment+=$row['orderpro_val'];
                                            }
                                    ?>
                                            <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"><?php print dtconvert($row['orderpro_dt']); ?></td>
                                                <td align="left"><?php print $row['order_id']; ?>/24-25</td>
                                                <td align="left"><?php print $row['orderpro_val']; ?></td>
                                                <td align="left">
                                                    <?php if($row['vpayment']=="1") { ?>
                                                        <button type="button" class="btn btn-primary bg-success mt-2 pr-4 pl-4">Paid</button>
                                                        <br><a href="#" onClick="reject('vledger.php','<?php print $row['orderline_id']; ?>','<?php print $_REQUEST['vendor']; ?>','<?php print $flag; ?>');return false;">Mark as Not Paid</a>
                                                    <?php } else { ?>	
                                                        <button type="button" class="btn btn-primary bg-danger mt-2 pr-4 pl-4">Not Paid</button>
                                                        <br><a href="#" onClick="approve('vledger.php','<?php print $row['orderline_id']; ?>','<?php print $_REQUEST['vendor']; ?>','<?php print $flag; ?>');return false;">Mark as Paid</a>
                                                    <?php } ?>	
                                                </td>
                                                <td align="left">
                                                    <?php if($row['vaccept']=="1") { ?>
                                                        <button type="button" class="btn btn-primary bg-success mt-2 pr-4 pl-4">Accepted</button>
                                                    <?php } else { ?>	
                                                        <button type="button" class="btn btn-primary bg-danger mt-2 pr-4 pl-4">Not Accepted</button>
                                                        <?php /* ?><br><a href="#" onClick="approve('vledger.php','<?php print $row['orderline_id ']; ?>','<?php print $flag; ?>');return false;">Mark as Paid</a><?php */ ?>
                                                    <?php } ?>	
                                                </td>
                                            </tr>
                                        <?php } ?>
                                        <tr>
                                            <td colspan="2">&nbsp;</td>
                                            <td colspan="3" align="left">
                                                <h5>Total Amount: <?php print number_format($totam,2); ?>&nbsp;&nbsp;&nbsp;Total Payment: <?php print number_format($payment,2); ?>&nbsp;&nbsp;&nbsp;Due: <?php print number_format($totam-$payment,2); ?></h5>
                                            </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: vledger.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation