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

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewsbills.php

<?php
ob_start();
session_start();
include("includes/inall.php");

$url = basename(__FILE__) . "?" . (isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '');

if (isset($_REQUEST['delete']) && $_REQUEST['delete'] == "yes") {
    mysqli_query($con, "DELETE FROM `sales_sheader` WHERE `sl_id`='" . $_REQUEST['id'] . "'");
    mysqli_query($con, "DELETE FROM `sales_sitem` WHERE `sl_id`='" . $_REQUEST['id'] . "'");
    $_SESSION['msg'] = "Entry is deleted successfully.";
    header("Location:viewsbills.php");
    exit();
}

if (isset($_REQUEST['reject']) && $_REQUEST['reject'] == "yes") {
    mysqli_query($con, "UPDATE `sales_sheader` SET `sl_st`='0' WHERE `sl_id`='" . $_REQUEST['id'] . "'");
    $got = "go" . $_REQUEST['got'];
    $_SESSION['msg'] = "Bill is rejected successfully.";
    header("Location:viewsbills.php#" . $got);
    exit();
}

// Pagination logic
$pg = isset($_GET['pg']) ? intval($_GET['pg']) : 1;
$upper = 25;
$lower = $upper * ($pg - 1);

// Filters
$filter_sql = " WHERE 1 ";
if (!empty($_REQUEST['invdate'])) {
    $invdate = mysqli_real_escape_string($con, $_REQUEST['invdate']);
    $filter_sql .= " AND sl_docdate = '$invdate'";
}
if (!empty($_REQUEST['karigar'])) {
    $karigar = mysqli_real_escape_string($con, $_REQUEST['karigar']);
    $filter_sql .= " AND kr_id = '$karigar'";
}

// Count total rows for pagination
$count_sql = "SELECT COUNT(*) as total FROM `sales_sheader` $filter_sql";
$count_result = mysqli_fetch_assoc(mysqli_query($con, $count_sql));
$num = $count_result['total'];
$pgno = ceil($num / $upper);

// Fetch paginated data
$data_sql = "SELECT * FROM `sales_sheader` $filter_sql ORDER BY sl_id DESC LIMIT $lower, $upper";
$res = mysqli_query($con, $data_sql);

include("includes/headermain.php");
?>
<script language="javascript" type="text/javascript">
function del(id) {
	var fd=confirm("Are you sure to delete this entry?");
	if(fd==true) {
		location.href="viewsbills.php?id="+id+"&delete=yes";
	}	
}
function approve(id,got) {
	location.href="viewsbills.php?id="+id+"&got="+got+"&approve=yes";
}
function reject(id,got) {
	location.href="viewsbills.php?id="+id+"&got="+got+"&reject=yes";
}
</script>
<body>


<div id="preloader">
	<div class="loader"></div>
</div>


<div class="page-container">
	
	<?php include("includes/leftmenu.php"); ?>
	
	
	<div class="main-content">
		
		<?php include("includes/header.php"); ?>
		
	 	<div class="main-content-inner">
			
			<div> 
				<div class="col-lg-12 mt-4">
					<div class="card">
						<div class="card-body">
							<h4 class="header-title">List of Bills</h4>
							<form action="#" method="post">
                                <div class="form-group col-md-6 floatleft">
                                    <label class="col-form-label">Customer</label>
                                    <select class="form-control sphgt" name="karigar" id="karigar">
                                        <option value="">Select</option>
                                        <?php
                                            $resc = mysqli_query($con, "SELECT `id`,`name` FROM `customer_master` WHERE `status`='1'");
                                            while ($rowc = mysqli_fetch_object($resc)) {
                                        ?>
                                            <option value="<?php print $rowc->id; ?>" <?php if ($rowc->id == $_REQUEST['karigar']) print "selected"; ?>>
                                                <?php print $rowc->name; ?>
                                            </option>
                                        <?php } ?>
                                    </select>
                                </div>
								<div class="form-group col-md-6 floatleft">
									<label for="example-text-input" class="col-form-label">Date</label>
									
									<input class="form-control" type="date" name="invdate" id="invdate" value="<?php print $_REQUEST['invdate']; ?>" placeholder="By Invoice Date">
								</div>
                                <div class="form-group col-md-6">
                                    <button type="submit" class="btn btn-primary">Search</button>
									<a href="<?php print basename(__FILE__); ?>" class="btn btn-primary">Show All</a>
                                </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 } ?>
							<table class="table text-center">
								<thead class="text-uppercase bg-primary">
									<tr class="text-white">
										<td align="left">Sl.</td>
										<td align="left">Date</td>
										<td align="left">Bill No.</td>
										<td align="left">Customer</td>
										<td align="left">Amount</td>
										<td align="left">Payment Mode</td>
										<td align="left">Image</td>
										<td align="left">Options</td>
									</tr>
								</thead>
								<tbody>
									<?php
									if($lower==0) {
										$flag=0;
									} else {
										$flag=$lower;
									}
									$filter_sql = " WHERE 1 ";
                                    if (!empty($_REQUEST['invdate'])) {
                                        $invdate = mysqli_real_escape_string($con, $_REQUEST['invdate']);
                                        $filter_sql .= " AND sl_docdate = '$invdate'";
                                    }
                                    if (!empty($_REQUEST['karigar'])) {
                                        $karigar = mysqli_real_escape_string($con, $_REQUEST['karigar']);
                                        $filter_sql .= " AND kr_id = '$karigar'";
                                    }

$data_sql = "SELECT * FROM `sales_sheader` $filter_sql ORDER BY `sl_id` DESC LIMIT $lower, $upper";
                                    $res = mysqli_query($con, $data_sql);
									if(mysqli_num_rows($res)>=1) {
										while($row=mysqli_fetch_assoc($res)) {
											$rowc=mysqli_fetch_array(mysqli_query($con,"select * from `customer_master` where `id`='".$row['kr_id']."'"));
									?>
											<tr <?php if($row['sl_st']=="0") { ?>class="bg-red"<?php } ?> id="go<?php print $flag++; ?>">
												<td align="left"><?php print $flag; ?></td>
												<td align="left"><?php print dtconvert($row['sl_docdate']); ?></td>	
												<td align="left"><?php print $row['sl_unid']; ?></td>
												<td align="left"><?php print $rowc['name']; ?></td>
                                                <td align="left">
                                                    <?php
                                                        if (!empty($row['sl_total']) && $row['sl_total'] != 0) {
                                                            echo $row['sl_total'];
                                                        } else {
                                                            echo $row['gtotal'];
                                                        }
                                                    ?>
                                                </td>

<td align="left"><?php print $row['kr_pay']; ?></td>
                                                <td align="left"><?php if (!empty($row['doc_file'])) { ?><a href="uimages/<?php print $row['doc_file']; ?>" target="_blank">View Image</a><?php } ?></td>

<td align="left">
													<a href="addsbill.php?editid=<?php print $row['sl_id']; ?>&action=Edit">Edit</a><br>
													<?php if($row['sl_st']=="1") { ?>
														<?php /* ?><a href="#" onClick="reject('<?php print $row['sl_id']; ?>','<?php print $flag; ?>');">Reject</a><?php */ ?>
														<br><a href="bill.php?id=<?php print $row['sl_id']; ?>" target="_new">Print Bill</a>
													<?php } else { ?>	
														<br>Rejected
													<?php } ?>
													&nbsp;&nbsp;<a href="#" onClick="del('<?php print $row['sl_id']; ?>');void(0);">Delete</a>
												</td>
											</tr>
									<?php }  } else { ?>
										<tr>
											<td colspan="7">Sorry, nothing found.</</td>
										</tr>
									<?php } ?>	
								</tbody>
							</table>
							<?php if($num>=1) { ?>
								<div class="cleaner h20"></div>
								        
								<?php //include("includes/pagination.php"); ?>
								    
							<?php } ?>
						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewsbills.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation