prepare("
SELECT tax_id, cgst_rate, sgst_rate, effective_date
FROM taxes
ORDER BY effective_date DESC
");
$stmt->execute();
$taxes = $stmt->fetchAll();
} catch (PDOException $e) {
$errors[] = "Error fetching tax rates: " . $e->getMessage();
}
// Handle form submission (add or edit)
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
$action = $_POST['action'];
$cgst_rate = trim($_POST['cgst_rate'] ?? '');
$sgst_rate = trim($_POST['sgst_rate'] ?? '');
$effective_date = $_POST['effective_date'] ?? '';
// Validate inputs
if (!is_numeric($cgst_rate) || $cgst_rate < 0) {
$errors[] = "CGST rate must be a non-negative number.";
}
if (!is_numeric($sgst_rate) || $sgst_rate < 0) {
$errors[] = "SGST rate must be a non-negative number.";
}
if (empty($effective_date)) {
$errors[] = "Effective date is required.";
} else {
$effective_date_obj = DateTime::createFromFormat('Y-m-d', $effective_date);
if (!$effective_date_obj || $effective_date_obj->format('Y-m-d') !== $effective_date) {
$errors[] = "Invalid effective date format.";
} elseif ($action === 'add' && $effective_date < date('Y-m-d')) {
$errors[] = "Effective date cannot be in the past for new tax rates.";
}
}
// Check for overlapping effective dates
if (empty($errors)) {
try {
$stmt = $pdo->prepare("
SELECT COUNT(*) FROM taxes
WHERE effective_date = :effective_date
AND tax_id != :tax_id
");
$stmt->execute([
'effective_date' => $effective_date,
'tax_id' => $action === 'edit' ? ($_POST['tax_id'] ?? 0) : 0
]);
if ($stmt->fetchColumn() > 0) {
$errors[] = "A tax rate already exists for this effective date.";
}
} catch (PDOException $e) {
$errors[] = "Error checking effective date: " . $e->getMessage();
}
}
// Perform add or edit
if (empty($errors)) {
try {
if ($action === 'add') {
$stmt = $pdo->prepare("
INSERT INTO taxes (cgst_rate, sgst_rate, effective_date, created_at)
VALUES (:cgst_rate, :sgst_rate, :effective_date, NOW())
");
$stmt->execute([
'cgst_rate' => $cgst_rate,
'sgst_rate' => $sgst_rate,
'effective_date' => $effective_date
]);
$success = "Tax rate added successfully!";
} elseif ($action === 'edit') {
$tax_id = $_POST['tax_id'];
$stmt = $pdo->prepare("
UPDATE taxes
SET cgst_rate = :cgst_rate, sgst_rate = :sgst_rate, effective_date = :effective_date
WHERE tax_id = :tax_id
");
$stmt->execute([
'cgst_rate' => $cgst_rate,
'sgst_rate' => $sgst_rate,
'effective_date' => $effective_date,
'tax_id' => $tax_id
]);
$success = "Tax rate updated successfully!";
}
$cgst_rate = $sgst_rate = $effective_date = '';
$edit_tax_id = null;
} catch (PDOException $e) {
$errors[] = "Error saving tax rate: " . $e->getMessage();
}
}
}
// Handle delete
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['delete_tax_id'])) {
$tax_id = $_POST['delete_tax_id'];
try {
// Check if tax rate is in use (simplified; assumes future effective dates are safe to delete)
$stmt = $pdo->prepare("SELECT effective_date FROM taxes WHERE tax_id = :tax_id");
$stmt->execute(['tax_id' => $tax_id]);
$tax = $stmt->fetch();
if ($tax && $tax['effective_date'] <= date('Y-m-d')) {
$errors[] = "Cannot delete tax rate: It is currently in effect or was in the past.";
} else {
$stmt = $pdo->prepare("DELETE FROM taxes WHERE tax_id = :tax_id");
$stmt->execute(['tax_id' => $tax_id]);
$success = "Tax rate deleted successfully!";
}
} catch (PDOException $e) {
$errors[] = "Error deleting tax rate: " . $e->getMessage();
}
}
// Fetch tax rate for editing
if (isset($_GET['edit'])) {
$edit_tax_id = $_GET['edit'];
try {
$stmt = $pdo->prepare("
SELECT cgst_rate, sgst_rate, effective_date
FROM taxes
WHERE tax_id = :tax_id
");
$stmt->execute(['tax_id' => $edit_tax_id]);
$tax = $stmt->fetch();
if ($tax) {
$cgst_rate = $tax['cgst_rate'];
$sgst_rate = $tax['sgst_rate'];
$effective_date = $tax['effective_date'];
} else {
$errors[] = "Tax rate not found.";
$edit_tax_id = null;
}
} catch (PDOException $e) {
$errors[] = "Error fetching tax rate: " . $e->getMessage();
}
}
?>
All Tax Rates ()
$tax): ?>
CGST Rate: %
SGST Rate: %
Effective Date: