Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/bakery/branch

Free Space:

10.31 TB

🔧 Quick Actions

✏️ Editing: taxes.php

<?php
session_start();
require_once 'config/db_config.php';

// ---- Authentication ----
if (!isset($_SESSION['user_id']) || !isset($_SESSION['role'])) {
    header("Location: login.php");
    exit();
}
$branch_id = $_SESSION['branch_id'] ?? null;
$is_admin  = $_SESSION['role'] === 'admin';

// ---- CSRF Token ----
if (empty($_SESSION['csrf_token'])) {
    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}
$csrf = $_SESSION['csrf_token'];

// ---- Helpers ----
function h(string $v): string { return htmlspecialchars($v, ENT_QUOTES, 'UTF-8'); }

// ---------------------------------------------------------------------
// 1. GST STATUS FOR BRANCH USER - SHOW ALL GST VALUES
// ---------------------------------------------------------------------
$gst_status        = 0;
$current_tax_rate  = null;
$next_tax_rate     = null;
$total_gst_rate    = 0;
$all_tax_rates     = [];

if (!$is_admin && $branch_id) {
    try {
        // Step 1: Try to fetch existing GST status record
        $stmt = $pdo->prepare("SELECT is_active FROM gst_status WHERE branch_id = :branch_id");
        $stmt->execute(['branch_id' => $branch_id]);
        $row = $stmt->fetch(PDO::FETCH_ASSOC);

if ($row !== false && isset($row['is_active'])) {
            $gst_status = (int)$row['is_active'];
            error_log("GST status loaded for branch_id $branch_id: $gst_status");
        } else {
            // Insert default record
            error_log("No gst_status found for branch_id $branch_id. Creating default record.");
            $insert_stmt = $pdo->prepare("
                INSERT INTO gst_status (branch_id, is_active, created_at, updated_at)
                VALUES (:branch_id, 1, NOW(), NOW())
            ");
            $insert_stmt->execute(['branch_id' => $branch_id]);
            $gst_status = 1;
        }

// Step 2: Fetch ALL tax rates for this branch
        $stmt = $pdo->prepare("
    SELECT cgst_rate, sgst_rate, effective_date, description,
           CASE 
               WHEN effective_date > CURDATE() THEN 'future'
               WHEN effective_date = CURDATE() THEN 'current' 
               ELSE 'past'
           END AS status
    FROM taxes
    ORDER BY effective_date DESC
");
$stmt->execute();
$all_tax_rates = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Set current and next rates from the fetched data
        foreach ($all_tax_rates as $rate) {
            if ($rate['status'] === 'current' && !$current_tax_rate) {
                $current_tax_rate = $rate;
                $total_gst_rate = $rate['cgst_rate'] + $rate['sgst_rate'];
            }
            if ($rate['status'] === 'future' && !$next_tax_rate) {
                $next_tax_rate = $rate;
            }
        }

// If no current rate found, use the most recent past rate
        if (!$current_tax_rate && !empty($all_tax_rates)) {
            $current_tax_rate = $all_tax_rates[0];
            $total_gst_rate = $current_tax_rate['cgst_rate'] + $current_tax_rate['sgst_rate'];
        }

} catch (PDOException $e) {
        error_log("GST status error: " . $e->getMessage());
        $gst_status = 0;
    }
}

// ---------------------------------------------------------------------
// 2. ADMIN – LIST OF ALL TAX RATES
// ---------------------------------------------------------------------
$taxes = [];
if ($is_admin) {
    try {
        $stmt = $pdo->prepare("
            SELECT t.tax_id, t.branch_id, t.cgst_rate, t.sgst_rate, t.effective_date,
                   t.description, b.branch_name,
                   CASE
                       WHEN t.effective_date > CURDATE() THEN 'future'
                       WHEN t.effective_date = CURDATE() THEN 'current'
                       ELSE 'past'
                   END AS status
            FROM taxes t
            LEFT JOIN branches b ON t.branch_id = b.branch_id
            ORDER BY t.effective_date DESC, b.branch_name ASC
        ");
        $stmt->execute();
        $taxes = $stmt->fetchAll(PDO::FETCH_ASSOC);
    } catch (PDOException $e) {
        $errors[] = "Error fetching tax rates: " . h($e->getMessage());
        error_log("Tax fetch error: " . $e->getMessage());
    }
}

// ---------------------------------------------------------------------
// 3. ADMIN – ADD / EDIT TAX RATE
// ---------------------------------------------------------------------
$errors   = [];
$success  = '';
$cgst_rate = $sgst_rate = $effective_date = $description = '';
$edit_tax_id = null;
$branch_id_form = '';

if ($is_admin && $_SERVER['REQUEST_METHOD'] === 'POST'
    && isset($_POST['action'], $_POST['csrf']) && $_POST['csrf'] === $csrf) {

$action          = $_POST['action'];
    $cgst_rate       = trim($_POST['cgst_rate'] ?? '');
    $sgst_rate       = trim($_POST['sgst_rate'] ?? '');
    $hsn_code        = trim($_POST['hsn_code'] ?? '');

$effective_date  = $_POST['effective_date'] ?? '';
    $description     = trim($_POST['description'] ?? '');
    $branch_id_form  = $_POST['branch_id'] ?? '';

// ---- Validation ---------------------------------------------------------
    if (!is_numeric($cgst_rate) || $cgst_rate < 0 || $cgst_rate > 100) {
        $errors[] = "CGST rate must be a number between 0 and 100.";
    }
    if (!is_numeric($sgst_rate) || $sgst_rate < 0 || $sgst_rate > 100) {
        $errors[] = "SGST rate must be a number between 0 and 100.";
    }
    if (empty($hsn_code)) {
    $errors[] = "HSN Code is required.";
}
if (strlen($hsn_code) > 20) {
    $errors[] = "HSN Code cannot exceed 20 characters.";
}

if (empty($effective_date)) {
        $errors[] = "Effective date is required.";
    } else {
        $dt = DateTime::createFromFormat('Y-m-d', $effective_date);
        if (!$dt || $dt->format('Y-m-d') !== $effective_date) {
            $errors[] = "Invalid date format. Use YYYY-MM-DD.";
        } elseif ($action === 'add' && $effective_date < date('Y-m-d')) {
            $errors[] = "Effective date cannot be in the past for new tax rates.";
        }
    }
    if (strlen($description) > 255) {
        $errors[] = "Description too long (max 255 characters).";
    }
    if (empty($branch_id_form) || !is_numeric($branch_id_form)) {
        $errors[] = "Select a valid branch.";
    }

// ---- Overlap check -------------------------------------------------------
    if (empty($errors)) {
        try {
            $stmt = $pdo->prepare("
                SELECT COUNT(*) FROM taxes
                WHERE branch_id = :branch_id
                  AND effective_date = :effective_date
                  AND tax_id != :tax_id
            ");
            $stmt->execute([
                'branch_id'      => $branch_id_form,
                '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 date and branch.";
            }
        } catch (PDOException $e) {
            $errors[] = "Date overlap check failed.";
            error_log("Overlap error: " . $e->getMessage());
        }
    }

// ---- Save ---------------------------------------------------------------
    if (empty($errors)) {
        try {
            $pdo->beginTransaction();

if ($action === 'add') {
                $stmt = $pdo->prepare("
                    INSERT INTO taxes
                        (branch_id, hsn_code, cgst_rate, sgst_rate, effective_date, description, created_at)
                    VALUES
                        (:branch_id, :hsn_code, :cgst_rate, :sgst_rate, :effective_date, :description, NOW())
                ");
                $stmt->execute([
                    'branch_id'      => $branch_id_form,
                    'hsn_code' => $hsn_code,
                    'cgst_rate'      => $cgst_rate,
                    'sgst_rate'      => $sgst_rate,
                    'effective_date' => $effective_date,
                    'description'    => $description ?: null
                ]);
                $success = "Tax rate added successfully!";
            } else { // edit
                $tax_id = $_POST['tax_id'];
                $stmt = $pdo->prepare("SELECT COUNT(*) FROM taxes WHERE tax_id = :tax_id");
                $stmt->execute(['tax_id' => $tax_id]);
                if ($stmt->fetchColumn() == 0) {
                    $errors[] = "Tax rate not found.";
                } else {
                    $stmt = $pdo->prepare("
                        UPDATE taxes
                        SET branch_id = :branch_id,
                        hsn_code = :hsn_code,
                            cgst_rate = :cgst_rate,
                            sgst_rate = :sgst_rate,
                            effective_date = :effective_date,
                            description = :description
                        WHERE tax_id = :tax_id
                    ");
                    $stmt->execute([
                        'branch_id'      => $branch_id_form,
                        'hsn_code' => $hsn_code,
                        'cgst_rate'      => $cgst_rate,
                        'sgst_rate'      => $sgst_rate,
                        'effective_date' => $effective_date,
                        'description'    => $description ?: null,
                        'tax_id'         => $tax_id
                    ]);
                    $success = "Tax rate updated successfully!";
                }
            }
            $pdo->commit();
            // Reset form and redirect
            $cgst_rate = $sgst_rate = $effective_date = $description = '';
            $edit_tax_id = null;
            header("Location: taxes.php?success=" . urlencode($success));
            exit();
        } catch (PDOException $e) {
            $pdo->rollBack();
            $errors[] = "Error saving tax rate: " . h($e->getMessage());
            error_log("Save error: " . $e->getMessage());
        }
    }
}

// ---------------------------------------------------------------------
// 4. ADMIN – DELETE TAX RATE
// ---------------------------------------------------------------------
if ($is_admin && $_SERVER['REQUEST_METHOD'] === 'POST'
    && isset($_POST['delete_tax_id'], $_POST['csrf']) && $_POST['csrf'] === $csrf) {

$tax_id = $_POST['delete_tax_id'];
    try {
        $pdo->beginTransaction();
        $stmt = $pdo->prepare("SELECT effective_date FROM taxes WHERE tax_id = :tax_id");
        $stmt->execute(['tax_id' => $tax_id]);
        $tax = $stmt->fetch(PDO::FETCH_ASSOC);

if ($tax && $tax['effective_date'] <= date('Y-m-d')) {
            $errors[] = "Cannot delete a tax rate that is currently active or past.";
        } else {
            $stmt = $pdo->prepare("DELETE FROM taxes WHERE tax_id = :tax_id");
            $stmt->execute(['tax_id' => $tax_id]);
            if ($stmt->rowCount() > 0) {
                $success = "Tax rate deleted successfully!";
                $pdo->commit();
                header("Location: taxes.php?success=" . urlencode($success));
                exit();
            } else {
                $errors[] = "Tax rate not found.";
            }
        }
    } catch (PDOException $e) {
        $pdo->rollBack();
        $errors[] = "Error deleting tax rate: " . h($e->getMessage());
        error_log("Delete error: " . $e->getMessage());
    }
}

// ---------------------------------------------------------------------
// 5. ADMIN – PRE‑FILL EDIT FORM
// ---------------------------------------------------------------------
if ($is_admin && isset($_GET['edit'])) {
    $edit_tax_id = (int)$_GET['edit'];
    try {
        $stmt = $pdo->prepare("
            SELECT branch_id, cgst_rate, sgst_rate, effective_date, description
            FROM taxes WHERE tax_id = :tax_id
        ");
        $stmt->execute(['tax_id' => $edit_tax_id]);
        $tax = $stmt->fetch(PDO::FETCH_ASSOC);
        if ($tax) {
            $branch_id_form = $tax['branch_id'];
            $hsn_code = $tax['hsn_code'];

$cgst_rate      = $tax['cgst_rate'];
            $sgst_rate      = $tax['sgst_rate'];
            $effective_date = $tax['effective_date'];
            $description    = $tax['description'];
        } else {
            $errors[] = "Tax rate not found.";
            $edit_tax_id = null;
        }
    } catch (PDOException $e) {
        $errors[] = "Error fetching tax rate: " . h($e->getMessage());
        error_log("Edit fetch error: " . $e->getMessage());
    }
}

// ---------------------------------------------------------------------
// 6. ADMIN – LIST OF BRANCHES FOR THE FORM
// ---------------------------------------------------------------------
$branches = [];
if ($is_admin) {
    try {
        $stmt = $pdo->prepare("SELECT branch_id, branch_name FROM branches ORDER BY branch_name");
        $stmt->execute();
        $branches = $stmt->fetchAll(PDO::FETCH_ASSOC);
    } catch (PDOException $e) {
        $errors[] = "Error fetching branches: " . h($e->getMessage());
        error_log("Branch fetch error: " . $e->getMessage());
    }
}

// Check for success message from redirect
if (isset($_GET['success'])) {
    $success = urldecode($_GET['success']);
}
?>
<?php include './partials/layouts/layoutTop.php' ?>

<link rel="stylesheet"
      href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.6.0/css/all.min.css"
      crossorigin="anonymous" referrerpolicy="no-referrer" />

/* Card Styles */
.gst-status-card{color:black !important;border-radius:12px;border:none}
.gst-status-card .card-body{padding:30px}
.gst-status-content{display:flex;justify-content:space-between;align-items:center}
.gst-status-text h6{color:#fff;margin-bottom:8px}
.gst-status-text p{color:rgba(255,255,255,.9);margin:0}
.gst-details-card{border-left:4px solid #28a745}
.gst-details-card.disabled{border-left:4px solid #dc3545}
.rate-badge{font-size:1.1rem;font-weight:600;padding:8px 16px}
.tax-detail-item{display:flex;justify-content:space-between;align-items:center;padding:8px 0;border-bottom:1px solid #f0f0f0}
.tax-detail-item:last-child{border-bottom:none}
.tax-detail-label{font-weight:500;color:#666;min-width:120px}
.tax-detail-value{font-weight:600;color:#333}
.status-badge{font-size:.75rem;padding:4px 8px}
.upcoming-tax{background:linear-gradient(135deg,#f093fb 0%,#f5576c 100%);color:#fff}

/* Mobile Responsive */
@media (max-width: 768px) {
    .dashboard-main-body { padding-bottom: 80px; }
    .tax-detail-item { flex-direction: column; align-items: flex-start; }
    .tax-detail-label { min-width: auto; margin-bottom: 4px; }
}

/* Table Styles */
.table-responsive { border-radius: 8px; }
.table th { background-color: #f8f9fa; font-weight: 600; }
</style>

<div class="dashboard-main-body">
    <div class="d-flex flex-wrap align-items-center justify-content-between gap-3 mb-24">
        <h6 class="fw-semibold mb-0">Tax Management</h6>
        <ul class="d-flex align-items-center gap-2">
            <li class="fw-medium">
                <a href="index.php" class="d-flex align-items-center gap-1 hover-text-primary">
                    <i class="fa-solid fa-house"></i> Dashboard
                </a>
            </li>
            <li>-</li>
            <li class="fw-medium">Tax Management</li>
        </ul>
    </div>

<?php if ($success): ?>
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            <i class="fa-solid fa-check-circle me-2"></i>
            <?= h($success); ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        </div>
    <?php endif; ?>
    
    <?php if (!empty($errors)): ?>
        <div class="alert alert-danger alert-dismissible fade show" role="alert">
            <i class="fa-solid fa-exclamation-triangle me-2"></i>
            <strong>Please fix the following errors:</strong>
            <ul class="mb-0 mt-2">
                <?php foreach ($errors as $error): ?>
                    <li><?= h($error); ?></li>
                <?php endforeach; ?>
            </ul>
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        </div>
    <?php endif; ?>

<?php if (!$is_admin && $branch_id): ?>
        
        <div class="card gst-status-card mb-24">
            <div class="card-body">
                <div class="gst-status-content">
                    <div class="gst-status-text">
                        <h6 class="section-title text-lg mb-2">GST Status</h6>
                        <p class="mb-0 text-black">Enable or disable GST for your branch</p>
                    </div>
                    <div class="toggle-container">
                        <label class="toggle-switch">
                            <input type="checkbox" class="gst-toggle"
                                   data-branch-id="<?= h($branch_id); ?>"
                                   data-csrf="<?= h($csrf); ?>"
                                   data-bs-toggle="tooltip"
                                   data-bs-placement="top"
                                   title="<?= $gst_status ? 'GST Enabled – Click to disable' : 'GST Disabled – Click to enable'; ?>"
                                   <?= $gst_status ? 'checked' : ''; ?>>
                            <span class="toggle-slider"></span>
                        </label>
                        <span class="toggle-label <?= $gst_status ? 'enabled' : 'disabled'; ?>">
                            <?= $gst_status ? 'GST Enabled' : 'GST Disabled'; ?>
                        </span>
                    </div>
                </div>
            </div>
        </div>

<div class="card mb-24 <?= $gst_status ? 'gst-details-card' : 'gst-details-card disabled'; ?>">
            <div class="card-body">
                <h6 class="section-title text-lg mb-16">GST Details</h6>
                
                <?php if ($gst_status && !empty($all_tax_rates)): ?>
                    
                    <div class="table-responsive mb-4">
                        <table class="table table-striped table-sm">
                            <thead class="table-light">
                                <tr>
                                    <th>HSN Code</th>
                                    <th>CGST (%)</th>
                                    <th>SGST (%)</th>
                                    <th>Total (%)</th>
                                    <th>Effective Date</th>
                                    <th>Status</th>
                                    <th>Description</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php foreach ($all_tax_rates as $rate): 
                                    $total_rate = $rate['cgst_rate'] + $rate['sgst_rate'];
                                    $status_badge = [
                                        'current' => ['class' => 'bg-success', 'text' => 'Active'],
                                        'future' => ['class' => 'bg-warning', 'text' => 'Upcoming'],
                                        'past' => ['class' => 'bg-secondary', 'text' => 'Past']
                                    ];
                                    $status = $status_badge[$rate['status']] ?? ['class' => 'bg-secondary', 'text' => 'Unknown'];
                                ?>
                                    <tr>
                                        <td><?= h($rate['hsn_code'] ?? '-'); ?></td>

<?php if ($current_tax_rate): ?>
                        <div class="row mt-4 pt-4 border-top">
                            <div class="col-md-8">
                                <h6 class="text-md mb-3 text-success">
                                    <i class="fa-solid fa-circle-check me-2"></i>Current Active Rate
                                </h6>
                                <div class="tax-detail-item">
                                    <span class="tax-detail-label">CGST Rate:</span>
                                    <span class="tax-detail-value"><?= number_format($current_tax_rate['cgst_rate'], 2); ?>%</span>
                                </div>
                                <div class="tax-detail-item">
                                    <span class="tax-detail-label">SGST Rate:</span>
                                    <span class="tax-detail-value"><?= number_format($current_tax_rate['sgst_rate'], 2); ?>%</span>
                                </div>
                                <div class="tax-detail-item">
                                    <span class="tax-detail-label">Total GST Rate:</span>
                                    <span class="tax-detail-value">
                                        <span class="badge bg-primary rate-badge">
                                            <?= number_format($total_gst_rate, 2); ?>%
                                        </span>
                                    </span>
                                </div>
                                <div class="tax-detail-item">
                                    <span class="tax-detail-label">Effective From:</span>
                                    <span class="tax-detail-value"><?= date('d M Y', strtotime($current_tax_rate['effective_date'])); ?></span>
                                </div>
                                <?php if (!empty($current_tax_rate['description'])): ?>
                                    <div class="tax-detail-item">
                                        <span class="tax-detail-label">Description:</span>
                                        <span class="tax-detail-value"><?= h($current_tax_rate['description']); ?></span>
                                    </div>
                                <?php endif; ?>
                            </div>
                            <div class="col-md-4 text-center">
                                <div class="total-gst-display bg-light rounded p-4">
                                    <div class="text-muted mb-2">Current Total GST</div>
                                    <div class="display-4 fw-bold text-primary"><?= number_format($total_gst_rate, 2); ?>%</div>
                                    <div class="text-sm text-muted mt-2">
                                        CGST: <?= number_format($current_tax_rate['cgst_rate'], 2); ?>%<br>
                                        SGST: <?= number_format($current_tax_rate['sgst_rate'], 2); ?>%
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php endif; ?>

<?php elseif ($gst_status): ?>
                    <div class="text-center py-16">
                        <i class="fa-solid fa-circle-info text-3xl text-warning mb-8"></i>
                        <p class="text-muted mb-0">No tax rates configured for your branch.</p>
                        <small class="text-muted">Please contact administrator to set up tax rates.</small>
                    </div>
                <?php else: ?>
                    <div class="text-center py-16">
                        <i class="fa-solid fa-circle-xmark text-3xl text-danger mb-8"></i>
                        <p class="text-muted mb-0">GST is currently disabled for your branch.</p>
                        <small class="text-muted">Enable GST above to view tax details.</small>
                    </div>
                <?php endif; ?>
            </div>
        </div>

<?php if ($gst_status && $next_tax_rate): ?>
            <div class="card upcoming-tax mb-24">
                <div class="card-body">
                    <h6 class="section-title text-lg mb-16 text-white">
                        <i class="fa-solid fa-clock me-2"></i>Upcoming Tax Change
                    </h6>
                    <div class="row">
                        <div class="col-md-8">
                            <div class="tax-detail-item">
                                <span class="tax-detail-label text-white-80">New CGST Rate:</span>
                                <span class="tax-detail-value text-white"><?= number_format($next_tax_rate['cgst_rate'], 2); ?>%</span>
                            </div>
                            <div class="tax-detail-item">
                                <span class="tax-detail-label text-white-80">New SGST Rate:</span>
                                <span class="tax-detail-value text-white"><?= number_format($next_tax_rate['sgst_rate'], 2); ?>%</span>
                            </div>
                            <div class="tax-detail-item">
                                <span class="tax-detail-label text-white-80">New Total GST:</span>
                                <span class="tax-detail-value text-white">
                                    <span class="badge bg-light text-dark rate-badge">
                                        <?= number_format($next_tax_rate['cgst_rate'] + $next_tax_rate['sgst_rate'], 2); ?>%
                                    </span>
                                </span>
                            </div>
                            <div class="tax-detail-item">
                                <span class="tax-detail-label text-white-80">Effective From:</span>
                                <span class="tax-detail-value text-white"><?= date('d M Y', strtotime($next_tax_rate['effective_date'])); ?></span>
                            </div>
                            <?php if (!empty($next_tax_rate['description'])): ?>
                                <div class="tax-detail-item">
                                    <span class="tax-detail-label text-white-80">Description:</span>
                                    <span class="tax-detail-value text-white"><?= h($next_tax_rate['description']); ?></span>
                                </div>
                            <?php endif; ?>
                        </div>
                        <div class="col-md-4 text-center">
                            <div class="upcoming-gst-display">
                                <div class="text-white-80 mb-2">New Total GST</div>
                                <div class="display-4 fw-bold text-white"><?= number_format($next_tax_rate['cgst_rate'] + $next_tax_rate['sgst_rate'], 2); ?>%</div>
                                <div class="text-sm text-white-80 mt-2">
                                    Starts: <?= date('d M Y', strtotime($next_tax_rate['effective_date'])); ?>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        <?php endif; ?>

<?php elseif (!$is_admin): ?>
        <div class="alert alert-warning">
            <i class="fa-solid fa-triangle-exclamation me-2"></i>
            <strong>Warning:</strong> No branch assigned to your account. Please contact administrator.
        </div>
    <?php endif; ?>

<?php if ($is_admin): ?>
        
        <div class="card">
            <div class="card-body p-24">
                <h6 class="section-title text-lg mb-16"><?= $edit_tax_id ? 'Edit Tax Rate' : 'Add New Tax Rate'; ?></h6>

<div class="row gy-4">
                        <div class="col-md-3">
                            <label class="form-label fw-medium">Branch <span class="text-danger">*</span></label>
                            <select class="form-control bg-base" name="branch_id" required>
                                <option value="">Select Branch</option>
                                <?php foreach ($branches as $b): ?>
                                    <option value="<?= h($b['branch_id']); ?>" 
                                        <?= (isset($branch_id_form) && $branch_id_form == $b['branch_id']) ? 'selected' : ''; ?>>
                                        <?= h($b['branch_name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label fw-medium">HSN Code <span class="text-danger">*</span></label>
                            <input type="text" class="form-control bg-base" 
                                   name="hsn_code" 
                                   value="<?= h($hsn_code ?? ''); ?>" 
                                   placeholder="Enter HSN Code" required>
                        </div>

<div class="col-md-2">
                            <label class="form-label fw-medium">CGST Rate (%) <span class="text-danger">*</span></label>
                            <input type="number" step="0.01" min="0" max="100" class="form-control bg-base" 
                                   name="cgst_rate" value="<?= h($cgst_rate); ?>" required
                                   placeholder="0.00">
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-medium">SGST Rate (%) <span class="text-danger">*</span></label>
                            <input type="number" step="0.01" min="0" max="100" class="form-control bg-base" 
                                   name="sgst_rate" value="<?= h($sgst_rate); ?>" required
                                   placeholder="0.00">
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fw-medium">Effective Date <span class="text-danger">*</span></label>
                            <input type="date" class="form-control bg-base" name="effective_date" 
                                   value="<?= h($effective_date); ?>" required
                                   min="<?= $edit_tax_id ? '' : date('Y-m-d'); ?>">
                        </div>
                        <div class="col-md-3">
                            <label class="form-label fw-medium">Description</label>
                            <input type="text" class="form-control bg-base" name="description" 
                                   value="<?= h($description ?? ''); ?>" 
                                   placeholder="Optional description" maxlength="255">
                        </div>
                        <div class="col-12 text-end">
                            <button type="submit" class="btn btn-primary bg-primary-600 hover-bg-primary-700 text-white">
                                <i class="fa-solid fa-save me-2"></i>
                                <?= $edit_tax_id ? 'Update Tax Rate' : 'Add Tax Rate'; ?>
                            </button>
                            <?php if ($edit_tax_id): ?>
                                <a href="taxes.php" class="btn btn-outline-secondary ms-2">
                                    <i class="fa-solid fa-times me-2"></i> Cancel
                                </a>
                            <?php endif; ?>
                        </div>
                    </div>
                </form>
            </div>
        </div>

<div class="card mt-24">
            <div class="card-body p-24">
                <h6 class="section-title text-lg mb-16">All Tax Rates (<?= count($taxes); ?>)</h6>
                <div class="table-responsive scroll-sm">
                    <table class="table ed-table sm-table mb-0" id="taxTable">
                        <thead>
                            <tr>
                                <th>Branch</th>
                                <th>HSN</th>
                                <th>CGST (%)</th>
                                <th>SGST (%)</th>
                                <th>Total GST (%)</th>
                                <th>Effective Date</th>
                                <th>Status</th>
                                <th>Description</th>
                                <th class="text-center">Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php if (empty($taxes)): ?>
                                <tr>
                                    <td colspan="8" class="text-center py-16">
                                        <i class="fa-solid fa-file-lines text-3xl mb-8 text-muted"></i>
                                        <p class="mb-2">No tax rates found</p>
                                        <small class="text-muted">Add your first tax rate using the form above</small>
                                    </td>
                                </tr>
                            <?php else: ?>
                                <?php foreach ($taxes as $t): 
                                    $total_gst = $t['cgst_rate'] + $t['sgst_rate'];
                                    $status_badge = [
                                        'current' => ['class' => 'bg-success', 'text' => 'Current'],
                                        'future' => ['class' => 'bg-warning', 'text' => 'Upcoming'],
                                        'past' => ['class' => 'bg-secondary', 'text' => 'Past']
                                    ];
                                    $status = $status_badge[$t['status']] ?? ['class' => 'bg-secondary', 'text' => 'Unknown'];
                                ?>
                                    <tr>
                                        <td class="fw-medium"><?= h($t['branch_name'] ?? 'Unknown Branch'); ?></td>
                                        <td><?= h($t['hsn_code'] ?? '-'); ?></td>

<td><?= number_format($t['cgst_rate'], 2); ?></td>
                                        <td><?= number_format($t['sgst_rate'], 2); ?></td>
                                        <td class="fw-bold text-primary"><?= number_format($total_gst, 2); ?></td>
                                        <td>
                                            <span class="badge bg-light text-dark">
                                                <?= date('d M Y', strtotime($t['effective_date'])); ?>
                                            </span>
                                        </td>
                                        <td>
                                            <span class="badge <?= $status['class']; ?>">
                                                <?= $status['text']; ?>
                                            </span>
                                        </td>
                                        <td><?= h($t['description'] ?? '-'); ?></td>
                                        <td class="text-center">
                                            <div class="d-flex justify-content-center gap-2">
                                                <a href="taxes.php?edit=<?= h($t['tax_id']); ?>" 
                                                   class="btn btn-sm btn-outline-primary d-flex align-items-center gap-1"
                                                   title="Edit Tax Rate">
                                                    <i class="fa-solid fa-pen-to-square"></i> Edit
                                                </a>
                                                <?php if ($t['status'] === 'future'): ?>
                                                    <form action="taxes.php" method="POST" style="display:inline;" 
                                                          onsubmit="return confirm('Are you sure you want to delete this tax rate?');">
                                                        <input type="hidden" name="delete_tax_id" value="<?= h($t['tax_id']); ?>">
                                                        <input type="hidden" name="csrf" value="<?= h($csrf); ?>">
                                                        <button type="submit" class="btn btn-sm btn-outline-danger d-flex align-items-center gap-1"
                                                                title="Delete Tax Rate">
                                                            <i class="fa-solid fa-trash"></i> Delete
                                                        </button>
                                                    </form>
                                                <?php else: ?>
                                                    <button class="btn btn-sm btn-outline-secondary d-flex align-items-center gap-1" disabled
                                                            title="Cannot delete current or past tax rates">
                                                        <i class="fa-solid fa-trash"></i> Delete
                                                    </button>
                                                <?php endif; ?>
                                            </div>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                            <?php endif; ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    <?php endif; ?>
</div>

// Initialize tooltips
    const tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'));
    tooltipTriggerList.map(el => new bootstrap.Tooltip(el));

// GST toggle AJAX
    document.querySelectorAll(".gst-toggle").forEach(toggle => {
        toggle.addEventListener("change", function(){
            const branchId = this.dataset.branchId;
            const isActive = this.checked ? 1 : 0;
            const csrf     = this.dataset.csrf;
            const label    = this.closest(".toggle-container").querySelector(".toggle-label");
            const tooltip  = bootstrap.Tooltip.getInstance(this);

const formData = new FormData();
            formData.append('branch_id', branchId);
            formData.append('is_active', isActive);
            formData.append('csrf', csrf);

fetch("toggle_gst_status.php", {
                method: "POST",
                headers: {
                    "X-Requested-With": "XMLHttpRequest"
                },
                body: formData
            })
            .then(response => {
                if (!response.ok) {
                    throw new Error('Network response was not ok: ' + response.status);
                }
                return response.json();
            })
            .then(data => {
                if (data.success) {
                    label.textContent = isActive ? "GST Enabled" : "GST Disabled";
                    label.classList.toggle("enabled", isActive);
                    label.classList.toggle("disabled", !isActive);
                    
                    if (tooltip) {
                        tooltip.setContent({
                            '.tooltip-inner': isActive ? 'GST Enabled – Click to disable' : 'GST Disabled – Click to enable'
                        });
                    }
                    
                    showToast(data.message, 'success');
                    
                    // Reload page to update GST details
                    setTimeout(() => {
                        window.location.reload();
                    }, 1500);
                } else {
                    this.checked = !this.checked;
                    showToast(data.message || 'Update failed', 'danger');
                }
            })
            .catch(error => {
                this.checked = !this.checked;
                console.error('Fetch error:', error);
                showToast('Network error. Please try again.', 'danger');
            });
        });
    });

// Form validation
    const taxForm = document.getElementById('taxForm');
    if (taxForm) {
        taxForm.addEventListener('submit', function(e) {
            const cgst = parseFloat(this.querySelector('[name="cgst_rate"]').value);
            const sgst = parseFloat(this.querySelector('[name="sgst_rate"]').value);
            
            if (cgst < 0 || cgst > 100) {
                e.preventDefault();
                showToast('CGST rate must be between 0 and 100%', 'warning');
                return false;
            }
            
            if (sgst < 0 || sgst > 100) {
                e.preventDefault();
                showToast('SGST rate must be between 0 and 100%', 'warning');
                return false;
            }
        });
    }

// Toast helper function
    function showToast(message, type = 'success') {
        // Remove existing toasts
        const existingToasts = document.querySelectorAll('.toast');
        existingToasts.forEach(toast => toast.remove());
        
        let toastContainer = document.getElementById('toast-container');
        if (!toastContainer) {
            toastContainer = document.createElement('div');
            toastContainer.id = 'toast-container';
            toastContainer.className = 'position-fixed top-0 end-0 p-3';
            toastContainer.style.zIndex = '1050';
            document.body.appendChild(toastContainer);
        }
        
        const toast = document.createElement('div');
        toast.className = `toast align-items-center text-white bg-${type} border-0`;
        toast.setAttribute('role', 'alert');
        toast.setAttribute('aria-live', 'assertive');
        toast.setAttribute('aria-atomic', 'true');
        
        toast.innerHTML = `
            <div class="d-flex">
                <div class="toast-body">${message}</div>
                <button type="button" class="btn-close btn-close-white me-2 m-auto" data-bs-dismiss="toast" aria-label="Close"></button>
            </div>
        `;
        
        toastContainer.appendChild(toast);
        const bsToast = new bootstrap.Toast(toast);
        bsToast.show();
        
        // Remove toast after it hides
        toast.addEventListener('hidden.bs.toast', () => {
            toast.remove();
        });
    }

// Show any PHP-generated messages
    <?php if($success): ?>showToast('<?=h($success);?>','success');<?php endif; ?>
    <?php if(!empty($errors)): ?>showToast('<?=h(implode(', ',$errors));?>','danger');<?php endif; ?>
});
</script>

<?php include './partials/layouts/layoutBottom.php' ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: taxes.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation