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: viewdewtbkp.php

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

$table = "khata_dpwt";
$heading = "All Transactions (Deposit & Withdraw)";
$viewpage = "viewdewtch.php";
$addpage = "withdraw.php";

// Handle Deletion
if (isset($_REQUEST['delid'])) {
	$delid = (int)$_REQUEST['delid'];
	mysqli_query($con, "DELETE FROM $table WHERE id = '$delid'");
	$_SESSION['msg'] = "Record deleted successfully.";
	header("Location: $viewpage");
	exit();
}

// Filtering Logic
$where = " WHERE 1=1 ";
$karigar_filter = isset($_REQUEST['karigar']) ? $_REQUEST['karigar'] : '';
$type_filter = isset($_REQUEST['type']) ? $_REQUEST['type'] : '';
$from_date = isset($_REQUEST['from_date']) ? $_REQUEST['from_date'] : '';
$to_date = isset($_REQUEST['to_date']) ? $_REQUEST['to_date'] : '';

if ($karigar_filter != '') $where .= " AND karigar = '$karigar_filter' ";
if ($type_filter != '') $where .= " AND type = '$type_filter' ";
if ($from_date != '' && $to_date != '') $where .= " AND pdate BETWEEN '$from_date' AND '$to_date' ";

$query = "SELECT t.*, k.name as karigar_name 
          FROM $table t 
          LEFT JOIN karigar_master k ON t.karigar = k.id 
          $where 
          ORDER BY t.pdate DESC, t.id DESC";
$result = mysqli_query($con, $query) or die(mysqli_error($con));

include("includes/headermain.php");
?>

.table-ledger thead th {
		background-color: #333;
		color: #fff;
		font-size: 10px;
		text-transform: uppercase;
		white-space: nowrap;
		padding: 10px 5px;
	}

.table-ledger td {
		font-size: 11px;
		vertical-align: middle;
		white-space: nowrap;
		padding: 8px 5px;
	}

/* Type Badges */
	.badge-deposit {
		background-color: #d4edda;
		color: #155724;
		padding: 4px 8px;
		border-radius: 4px;
		font-weight: bold;
	}

.badge-withdraw {
		background-color: #f8d7da;
		color: #721c24;
		padding: 4px 8px;
		border-radius: 4px;
		font-weight: bold;
	}

.filter-section {
		background: #fff;
		padding: 20px;
		border-radius: 8px;
		margin-bottom: 20px;
		border: 1px solid #eee;
	}
</style>

<div class="filter-section card">
						<form method="get" class="row align-items-end">
							<div class="col-md-2">
								<label class="small font-weight-bold">Karigar</label>
								<select name="karigar" class="form-control form-control-sm">
									<option value="">All</option>
									<?php
									$k_res = mysqli_query($con, "SELECT id, name FROM karigar_master WHERE status='1'");
									while ($k = mysqli_fetch_assoc($k_res)) {
										echo "<option value='" . $k['id'] . "' " . ($karigar_filter == $k['id'] ? 'selected' : '') . ">" . $k['name'] . "</option>";
									}
									?>
								</select>
							</div>
							<div class="col-md-2">
								<label class="small font-weight-bold">Type</label>
								<select name="type" class="form-control form-control-sm">
									<option value="">All Types</option>
									<option value="Deposit" <?php if ($type_filter == 'Deposit') echo 'selected'; ?>>Deposit</option>
									<option value="Withdraw" <?php if ($type_filter == 'Withdraw') echo 'selected'; ?>>Withdraw</option>
								</select>
							</div>
							<div class="col-md-2">
								<label class="small font-weight-bold">From</label>
								<input type="date" name="from_date" class="form-control form-control-sm" value="<?php echo $from_date; ?>">
							</div>
							<div class="col-md-2">
								<label class="small font-weight-bold">To</label>
								<input type="date" name="to_date" class="form-control form-control-sm" value="<?php echo $to_date; ?>">
							</div>
							<div class="col-md-4">
								<button type="submit" class="btn btn-sm btn-primary">Filter</button>
								<a href="<?php echo $viewpage; ?>" class="btn btn-sm btn-light">Reset</a>
								<a href="withdraw.php" class="btn btn-sm btn-success">+ Withdraw</a>
								<a href="deposit.php" class="btn btn-sm btn-info">+ Deposit</a>
							</div>
						</form>
					</div>

<div class="card">
						<div class="card-body">
							<h4 class="header-title"><?php echo $heading; ?></h4>
							<div class="table-responsive">
								<table class="table table-bordered table-hover table-ledger text-center">
									<thead>
										<tr>
											<th>Type</th>
											<th>Date</th>
											<th>Karigar</th>
											<th>Design No</th>
											<th>Issue Qty</th>
											<th>Issue Wt</th>
											<th>Rec. Date</th>
											<th>Rec. Qty</th>
											<th>Rec. Wt</th>
											<th>Scrap Wt</th>
											<th>Scrap Ex</th>
											<th>Total Rec</th>
											<th>Bal Metal</th>
											<th>Dust</th>
											<th>Stone</th>
											<th>Loss</th>
											<th>Action</th>
										</tr>
									</thead>
									<tbody>
										<?php while ($row = mysqli_fetch_object($result)) {
											$typeClass = ($row->type == 'Deposit') ? 'badge-deposit' : 'badge-withdraw';
										?>
											<tr>
												<td><span class="<?php echo $typeClass; ?>"><?php echo $row->type; ?></span></td>
												<td><?php echo date('d-m-Y', strtotime($row->pdate)); ?></td>
												<td class="font-weight-bold"><?php echo $row->karigar_name; ?></td>
												<td><?php echo $row->design_no; ?></td>
												<td><?php echo $row->issue_qty . " " . $row->issue_unit; ?></td>
												<td><?php echo number_format($row->issue_weight, 3); ?></td>
												<td><?php echo ($row->receive_pdate != '0000-00-00') ? date('d-m-Y', strtotime($row->receive_pdate)) : '-'; ?></td>
												<td><?php echo $row->receive_qty . " " . $row->receive_unit; ?></td>
												<td><?php echo number_format($row->receive_weight, 3); ?></td>
												<td><?php echo number_format($row->scrap_weight, 3); ?></td>
												<td><?php echo number_format($row->scrap_ex, 3); ?></td>
												<td class="bg-light font-weight-bold"><?php echo number_format($row->total_receive, 3); ?></td>
												<td><?php echo number_format($row->balance_metal, 3); ?></td>
												<td><?php echo number_format($row->dust_loss, 3); ?></td>
												<td><?php echo number_format($row->stone, 3); ?></td>
												<td class="text-danger"><?php echo number_format($row->loss, 3); ?></td>
												<td>
													<a href="<?php echo ($row->type == 'Deposit' ? 'deposit.php' : 'withdraw.php'); ?>?eid=<?php echo $row->id; ?>&action=Update" class="text-primary mr-2"><i class="fa fa-edit"></i></a>
													<a href="<?php echo $viewpage; ?>?delid=<?php echo $row->id; ?>" class="text-danger" onclick="return confirm('Confirm Delete?')"><i class="fa fa-trash"></i></a>
												</td>
											</tr>
										<?php } ?>
									</tbody>
								</table>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
		<?php include("includes/footer.php"); ?>
	</div>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewdewtbkp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation