ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/admin/gold_rates.php |
<?php include "common/header.php"; ?>
<?php
include 'connection/config.php';
// ---------- CREATE / UPDATE 24K ----------
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['save_rate'])) {
$price_24k = floatval(trim($_POST['price_24k']));
$effective_date = trim($_POST['effective_date']);
if (!empty($price_24k) && !empty($effective_date)) {
try {
// Check if 24K exists
$stmt = $pdo->prepare("SELECT id FROM gold_rates WHERE purity='24KT'");
$stmt->execute();
$existing = $stmt->fetch();
if ($existing) {
// UPDATE 24K
$stmt = $pdo->prepare("UPDATE gold_rates SET price_per_gram=:price, effective_date=:effective_date WHERE id=:id");
$stmt->execute([
'price' => $price_24k,
'effective_date' => $effective_date,
'id' => $existing['id']
]);
$swal_message = 'updated';
} else {
// INSERT 24K
$stmt = $pdo->prepare("INSERT INTO gold_rates (purity, price_per_gram, effective_date) VALUES ('24KT', :price, :effective_date)");
$stmt->execute([
'price' => $price_24k,
'effective_date' => $effective_date
]);
$swal_message = 'added';
}
echo "<script>
localStorage.setItem('swal_message','{$swal_message}');
window.location.href='gold_rates.php';
</script>";
exit;
} catch (PDOException $e) {
echo "<script>
localStorage.setItem('swal_message','error');
window.location.href='gold_rates.php';
</script>";
exit;
}
} else {
echo "<script>
localStorage.setItem('swal_message','empty');
window.location.href='gold_rates.php';
</script>";
exit;
}
}
// ---------- READ 24K ----------
$stmt = $pdo->query("SELECT * FROM gold_rates WHERE purity='24KT' LIMIT 1");
$rate_24k = $stmt->fetch();
// ---------- Karat ratios ----------
$karat_ratios = [
'24KT' => 1,
'22KT' => 22 / 24,
'18KT' => 18 / 24,
'14KT' => 14 / 24,
'9KT' => 9 / 24
];
// Ensure $editRate is defined to avoid undefined variable notice
$editRate = !empty($rate_24k);
?>
<!-- ==================================================== -->
<div class="page-content">
<div class="container-xxl">
<form method="POST" action="">
<div class="row">
<div class="col-xl-12 col-lg-12">
<div class="card">
<div class="card-header">
<h4 class="card-title"><?= $editRate ? "Edit Gold Rate" : "Add Gold Rate" ?></h4>
</div>
<div class="card-body">
<div class="row">
<div class="col-lg-6">
<div class="mb-3">
<label for="price_24k" class="form-label">24K Price per Gram</label>
<input type="number" step="0.01" id="price_24k" name="price_24k" class="form-control"
placeholder="Enter 24K price" value="<?= htmlspecialchars($rate_24k['price_per_gram'] ?? '') ?>" required>
</div>
</div>
<div class="col-lg-6">
<div class="mb-3">
<label for="effective_date" class="form-label">Effective Date</label>
<input type="date" id="effective_date" name="effective_date" class="form-control"
value="<?= htmlspecialchars($rate_24k['effective_date'] ?? date('Y-m-d')) ?>" required>
</div>
</div>
</div>
<div class="row mt-2">
<div class="col-lg-12">
<button type="submit" name="save_rate" class="btn btn-primary">
<?= $editRate ? "Update Rate" : "Save Rate" ?>
</button>
</div>
</div>
</div>
</div>
</div>
</div>
</form>
<div class="row">
<div class="col-xl-12">
<div class="card">
<div class="card-header d-flex justify-content-between align-items-center gap-1">
<h4 class="card-title flex-grow-1">All Gold Rates</h4>
</div>
<div>
<div class="table-responsive">
<table class="table align-middle mb-0 table-hover table-centered">
<thead class="bg-light-subtle">
<tr>
<th>Karat</th>
<th>Price per Gram</th>
<th>Price for 10g</th>
<th>Effective Date</th>
</tr>
</thead>
<tbody>
<?php
if (!empty($rate_24k)) {
foreach ($karat_ratios as $kt => $ratio) {
$price_per_gram = round($rate_24k['price_per_gram'] * $ratio, 2);
$price_10g = round($price_per_gram * 10, 2); // price for 10 grams
$date = $rate_24k['effective_date'];
echo "<tr>
<td>{$kt}</td>
<td>{$price_per_gram}</td>
<td>{$price_10g}</td>
<td>{$date}</td>
</tr>";
}
} else {
echo "<tr><td colspan='4' class='text-center'>No 24K rate found. Please add 24K gold rate.</td></tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include "common/footer.php" ?>
</div>
<!-- SweetAlert -->
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
document.addEventListener("DOMContentLoaded", function() {
const swalMsg = localStorage.getItem("swal_message");
if (swalMsg) {
if (swalMsg === "added") {
Swal.fire("Success!", "Gold rate added successfully!", "success");
} else if (swalMsg === "updated") {
Swal.fire("Success!", "Gold rate updated successfully!", "success");
} else if (swalMsg === "deleted") {
Swal.fire("Deleted!", "Gold rate deleted successfully!", "success");
} else if (swalMsg === "empty") {
Swal.fire("Oops!", "Please fill all fields.", "warning");
} else if (swalMsg === "error") {
Swal.fire("Error!", "Something went wrong.", "error");
}
localStorage.removeItem("swal_message");
}
});
</script>
<!-- Vendor Javascript -->
<script src="assets/js/vendor.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>
........