ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/tax.php |
<?php include "common/header.php"; ?>
<?php
include 'connection/config.php';
$editMode = isset($_GET['action']) && $_GET['action'] === 'edit_tax';
$tax = [];
if ($editMode) {
$tax_id = $_GET['tax_id'];
$stmt = $pdo->prepare("SELECT * FROM `taxes` WHERE tax_id = ?");
$stmt->execute([$tax_id]);
$tax = $stmt->fetch(PDO::FETCH_ASSOC);
}
?>
<!-- ==================================================== -->
<!-- Start right Content here -->
<!-- ==================================================== -->
<div class="page-content">
<!-- Start Container Fluid -->
<div class="container-xxl">
<form action="function.php" method="POST">
<!-- Hidden Field -->
<?php if (isset($tax['tax_id'])): ?>
<input type="hidden" name="tax_id" value="<?= $tax['tax_id'] ?>">
<?php endif; ?>
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header">
<h4 class="card-title d-flex align-items-center gap-1">
<iconify-icon icon="solar:wallet-bold-duotone" class="text-primary fs-20"></iconify-icon>
Tax Details
</h4>
</div>
<div class="card-body">
<div class="row">
<!-- Tax Name -->
<div class="col-lg-6">
<div class="mb-3">
<label for="tax-name" class="form-label">Tax Name</label>
<input type="text" name="tax_name" class="form-control" placeholder="Enter Tax Name"
value="<?= $editMode ? htmlspecialchars($tax['tax_name']) : '' ?>">
</div>
</div>
<!-- Tax Rate -->
<div class="col-lg-6">
<div class="mb-3">
<label for="tax-rate" class="form-label">Tax Rate (%)</label>
<input type="number" step="0.01" name="tax_rate" class="form-control" placeholder="Enter Tax Rate"
value="<?= $editMode ? htmlspecialchars($tax['tax_rate']) : '' ?>">
</div>
</div>
<!-- Status -->
<div class="col-lg-6">
<div class="mb-3">
<label for="tax-status" class="form-label">Status</label>
<select name="status" class="form-control">
<option value="active" <?= $editMode && $tax['status']=='active' ? 'selected' : '' ?>>Active</option>
<option value="inactive" <?= $editMode && $tax['status']=='inactive' ? 'selected' : '' ?>>Inactive</option>
</select>
</div>
</div>
</div>
<!-- Submit -->
<div class="text-end">
<button type="submit" name="<?= $editMode ? 'update_tax' : 'add_tax' ?>" class="btn btn-success"><?= $editMode ? 'Update' : 'Add' ?></button>
</div>
</div>
</div>
</div>
</div>
</form>
</div>
<!-- End Container Fluid -->
<!-- Start Container Fluid -->
<div class="container-xxl">
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="d-flex card-header justify-content-between align-items-center">
<div>
<h4 class="card-title">All Taxes</h4>
</div>
</div>
<div>
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th>Sl No</th>
<th>Tax Name</th>
<th>Rate (%)</th>
<th>Status</th>
<th>Created At</th>
<th>Updated At</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
include 'connection/config.php';
try {
$stmt = $pdo->prepare("SELECT * FROM taxes ORDER BY tax_id DESC");
$stmt->execute();
$taxes = $stmt->fetchAll(PDO::FETCH_ASSOC);
$i = 0;
foreach ($taxes as $tax) {
$i++;
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo htmlspecialchars($tax['tax_name']); ?></td>
<td><?php echo htmlspecialchars($tax['tax_rate']); ?>%</td>
<td>
<span class="badge bg-<?= $tax['status']=='active' ? 'success' : 'danger' ?>">
<?= ucfirst($tax['status']); ?>
</span>
</td>
<td><?php echo $tax['created_at']; ?></td>
<td><?php echo $tax['updated_at']; ?></td>
<td>
<div class="d-flex gap-2">
<a href="tax.php?tax_id=<?= $tax['tax_id'] ?>&action=edit_tax"
class="btn btn-soft-primary btn-sm">
<iconify-icon icon="solar:pen-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
<a href="function.php?action=delete_tax&tax_id=<?= $tax['tax_id'] ?>&redirect=tax.php"
onclick="return confirm('Are you sure you want to delete this record?')"
class="btn btn-soft-danger btn-sm">
<iconify-icon icon="solar:trash-bin-minimalistic-2-broken" class="align-middle fs-18"></iconify-icon>
</a>
</div>
</td>
</tr>
<?php
}
} catch (PDOException $e) {
echo "<tr><td colspan='7'>Error: " . htmlspecialchars($e->getMessage()) . "</td></tr>";
}
?>
</tbody>
</table>
</div>
<!-- end table-responsive -->
</div>
</div>
</div>
</div>
</div>
<!-- End Container Fluid -->
<!-- ========== Footer Start ========== -->
<?php include "common/footer.php" ?>
<!-- ========== Footer End ========== -->
</div>
<!-- ==================================================== -->
<!-- End Page Content -->
<!-- ==================================================== -->
</div>
<!-- END Wrapper -->
<!-- Vendor Javascript -->
<script src="assets/js/vendor.js"></script>
<!-- App Javascript -->
<script src="assets/js/app.js"></script>
</body>
</html>
........