ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/common/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/common/calculator.php |
<?php
include 'connection/config.php';
// ---------- READ latest 24K rate ----------
$stmt = $pdo->query("SELECT * FROM gold_rates WHERE purity='24KT' ORDER BY effective_date DESC LIMIT 1");
$rate_24k = $stmt->fetch();
$price_24k = $rate_24k ? floatval($rate_24k['price_per_gram']) : 0;
// ---------- Karat ratios ----------
$karat_ratios = [
'24K' => 1,
'22K' => 22 / 24,
'18K' => 18 / 24,
'14K' => 14 / 24,
'9K' =>9/24
];
// ---------- Calculate rates for each purity ----------
$prices = [];
foreach ($karat_ratios as $karat => $ratio) {
$prices[$karat] = $price_24k * $ratio;
}
?>
<!-- Gold Calculator Modal -->
<div class="modal fade" id="goldCalculatorModal" tabindex="-1" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered modal-lg modal-fullscreen-sm-down">
<div class="modal-content border-0 shadow-lg rounded-4 overflow-hidden">
<div class="modal-body p-0 position-relative d-flex flex-column">
<!-- Close button -->
<button type="button"
class="btn-close position-absolute top-0 end-0 m-3 bg-white rounded-circle shadow-sm"
data-bs-dismiss="modal"
aria-label="Close"></button>
<div class="row g-0 flex-grow-1 h-100 overflow-auto">
<!-- Left side: Calculator Form -->
<div class="col-12 col-md-6 d-flex flex-column form-side">
<div class="flex-grow-1 p-4">
<h3 class="mb-4 fw-bold text-center gold-title">💎 Gold Calculator</h3>
<form id="goldCalcForm" class="gold-form">
<div class="row g-3">
<!-- Gold Purity -->
<div class="col-12 col-sm-6">
<label for="purity" class="form-label fw-semibold">Gold Purity</label>
<select id="purity" class="form-select rounded-3 shadow-sm">
<?php foreach($prices as $karat => $rate): ?>
<option value="<?= $rate*10 ?>" <?= $karat=='24K'?'selected':'' ?>>
<?= $karat ?>
</option>
<?php endforeach; ?>
</select>
</div>
<!-- Gold Rate -->
<div class="col-12 col-sm-6">
<label for="rate" class="form-label fw-semibold">Gold Rate (per 10g ₹)</label>
<input type="number" id="rate" class="form-control rounded-3 shadow-sm"
value="<?= $prices['24K']*10 ?>" min="0">
</div>
<!-- Weight -->
<div class="col-12 col-sm-6">
<label for="weight" class="form-label fw-semibold">Weight (grams)</label>
<input type="number" id="weight" class="form-control rounded-3 shadow-sm" value="10" min="0">
</div>
<!-- Making Charges (%) -->
<div class="col-12 col-sm-6">
<label for="making" class="form-label fw-semibold">Making Charges (%)</label>
<input type="number" id="making" class="form-control rounded-3 shadow-sm" value="2" min="0">
</div>
<!-- Hallmark Charge -->
<div class="col-12 col-sm-6">
<label for="hallmark" class="form-label fw-semibold">Hallmark Charge (per piece ₹)</label>
<input type="number" id="hallmark" class="form-control rounded-3 shadow-sm" value="50" min="0">
</div>
<!-- Quantity -->
<div class="col-12 col-sm-6">
<label for="quantity" class="form-label fw-semibold">Product Quantity</label>
<input type="number" id="quantity" class="form-control rounded-3 shadow-sm" value="1" min="1">
</div>
<!-- Discount -->
<div class="col-12">
<label for="discount" class="form-label fw-semibold">Discount (%)</label>
<input type="number" id="discount" class="form-control rounded-3 shadow-sm" value="2" min="0">
</div>
<!-- GST Checkbox -->
<div class="col-12">
<div class="form-check">
<input type="checkbox" class="form-check-input" id="gst" checked>
<label class="form-check-label fw-semibold ms-lg-1 mt-lg-1" for="gst">Include GST (3%)</label>
</div>
</div>
</div>
<!-- Reset button -->
<div class="p-3">
<button type="reset" id="reset" class="btn w-100 rounded-3 shadow-sm reset">Reset</button>
</div>
</form>
</div>
</div>
<!-- Right side: Result -->
<div class="col-12 col-md-6 d-flex flex-column result-side">
<div class="flex-grow-1 p-4">
<h3 class="mb-4 fw-bold text-white text-center">📊 Calculation Result</h3>
<ul class="list-unstyled fs-6 mb-4 result-list">
<li><span>Total Gold Price:</span> <strong>₹<span id="gold-price">0</span></strong></li>
<li><span>Making Charges:</span> <strong>₹<span id="making-price">0</span></strong></li>
<li><span>GST:</span> <strong>₹<span id="gst-price">0</span></strong></li>
<li><span>Discount:</span> <strong>- ₹<span id="discount-price">0</span></strong></li>
<li><span>Hallmark Charge (Total):</span> <strong>₹<span id="hallmark-price">0</span></strong></li>
<li><span>Price Per Piece:</span> <strong>₹<span id="per-piece-price">0</span></strong></li>
</ul>
</div>
<div class="p-4">
<div class="text-center p-4 final-box rounded-3 shadow-lg">
<h4 class="fw-bold mb-0">Final Price (All Pieces)</h4>
<h2 class="fw-bold gold-gradient mt-2">₹<span id="final-price">0</span></h2>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<style>
.modal-dialog { max-width: 80vw; margin: auto; }
.modal-content { max-height: 90vh; }
.form-side { background: linear-gradient(135deg, #fff, #fdf6f6); }
.result-side { background: linear-gradient(135deg, #800010, #b30b2fff); color: #f1f1f1; }
.gold-title { background: -webkit-linear-gradient(45deg, #800000, #ed5561ff); -webkit-background-clip: text; -webkit-text-fill-color: transparent; }
.final-box { background: #fff; border: 2px solid #800000; box-shadow: 0 0 20px rgba(212,175,55,0.4); }
.gold-gradient { background: -webkit-linear-gradient(45deg, #800000, #ed5561ff); -webkit-background-clip: text; -webkit-text-fill-color: transparent; font-size: 2rem; }
.result-list li { display: flex; justify-content: space-between; padding: 8px 0; border-bottom: 1px dashed rgba(255,255,255,0.3); }
.reset { background: -webkit-linear-gradient(45deg, #800000, #e21f2fff); color:#fff; }
@media (max-width: 768px) {
.modal-dialog { max-width: 100% !important; }
.modal-content { border-radius: 0 !important; height: 100vh !important; }
.form-side, .result-side { min-height: auto; }
}
</style>
<script>
// Truncate a number to 2 decimals without rounding
function truncateTwoDecimals(num) {
return Math.floor(num * 100) / 100;
}
const hallmarkInput = document.getElementById("hallmark");
const quantityInput = document.getElementById("quantity");
const baseHallmark = 50; // per-piece hallmark
// Recalculate and update hallmark input when quantity changes
quantityInput.addEventListener("input", function() {
let quantity = parseInt(this.value) || 1;
hallmarkInput.value = baseHallmark * quantity; // show total hallmark in input
calculateGold();
});
// Reset button restores values
document.getElementById("reset").addEventListener("click", function() {
quantityInput.value = 1;
hallmarkInput.value = baseHallmark;
calculateGold();
});
function calculateGold() {
let ratePer10g = parseFloat(document.getElementById("rate").value);
let weight = parseFloat(document.getElementById("weight").value);
let makingPercent = parseFloat(document.getElementById("making").value) || 0;
let gstChecked = document.getElementById("gst").checked;
let discount = parseFloat(document.getElementById("discount").value) || 0;
let quantity = parseInt(quantityInput.value) || 1;
// Use baseHallmark (per piece) for calculations
let hallmarkPerPiece = baseHallmark;
if (isNaN(weight) || isNaN(ratePer10g)) return;
let ratePerGram = ratePer10g / 10;
let goldPrice = ratePerGram * weight;
let makingPrice = (makingPercent / 100) * goldPrice;
let gstPrice = gstChecked ? 0.03 * (goldPrice + makingPrice) : 0;
let discountPrice = ((goldPrice + makingPrice + gstPrice) * discount) / 100;
let pricePerPiece = goldPrice + makingPrice + gstPrice - discountPrice + hallmarkPerPiece;
let totalHallmark = hallmarkPerPiece * quantity;
let finalPrice = pricePerPiece * quantity;
// Update results
document.getElementById("gold-price").innerText = goldPrice.toFixed(2);
document.getElementById("making-price").innerText = makingPrice.toFixed(2);
document.getElementById("gst-price").innerText = gstPrice.toFixed(2);
document.getElementById("discount-price").innerText = discountPrice.toFixed(2);
document.getElementById("hallmark-price").innerText = totalHallmark.toFixed(2);
document.getElementById("per-piece-price").innerText = pricePerPiece.toFixed(2);
document.getElementById("final-price").innerText = finalPrice.toFixed(2);
}
// Update rate when purity changes
document.getElementById("purity").addEventListener("change", function() {
let truncatedRate = Math.floor(parseFloat(this.value) * 100) / 100;
document.getElementById("rate").value = truncatedRate.toFixed(2);
calculateGold();
});
// Update calculation on any input change
document.querySelectorAll("#goldCalcForm input, #goldCalcForm select").forEach(el => {
el.addEventListener("input", calculateGold);
el.addEventListener("change", calculateGold);
});
// Initial calculation
document.addEventListener("DOMContentLoaded", function() {
hallmarkInput.value = baseHallmark; // initialize input
calculateGold();
});
</script>
........