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/vkmobiles/admin

Free Space:

10.29 TB

🔧 Quick Actions

✏️ Editing: gst-mapping.php

<?php
session_start();
// Include database connection
include('includes/db.php');

// Check if user is logged in as branch
if (!isset($_SESSION['branch_id'])) {
    header("Location: login.php");
    exit();
}

// Get branch ID from session
$branch_id = $_SESSION['branch_id'];

// Get branch info for display
$branch_sql = "SELECT branch_name, branch_code FROM branches WHERE id = ?";
$branch_stmt = $conn->prepare($branch_sql);
$branch_stmt->bind_param("i", $branch_id);
$branch_stmt->execute();
$branch_result = $branch_stmt->get_result();
$branch_info = $branch_result->fetch_assoc();

// Helper function to calculate base price and GST amount
function calculateInclusiveGst($selling_price, $gst_percentage, $gst_applicable) {
    if (!$gst_applicable || $gst_percentage <= 0) {
        return [
            'base_price' => $selling_price,
            'gst_amount' => 0,
            'selling_price' => $selling_price
        ];
    }
    
    // Calculate base price from inclusive price
    // Formula: base_price = selling_price / (1 + gst_percentage/100)
    $base_price = $selling_price / (1 + ($gst_percentage / 100));
    $gst_amount = $selling_price - $base_price;
    
    return [
        'base_price' => round($base_price, 2),
        'gst_amount' => round($gst_amount, 2),
        'selling_price' => $selling_price
    ];
}

// Handle GST settings update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_gst'])) {
    $product_id = intval($_POST['product_id']);
    $gst_applicable = isset($_POST['gst_applicable']) ? 1 : 0;
    $gst_percentage = floatval($_POST['gst_percentage']);
    
    // Verify the product belongs to the user's branch
    $verify_sql = "SELECT id, selling_price FROM products WHERE id = ? AND branch_id = ?";
    $verify_stmt = $conn->prepare($verify_sql);
    $verify_stmt->bind_param("ii", $product_id, $branch_id);
    $verify_stmt->execute();
    $verify_result = $verify_stmt->get_result();
    
    if ($verify_result->num_rows > 0) {
        $product = $verify_result->fetch_assoc();
        $selling_price = floatval($product['selling_price']);
        
        // Check if GST record exists
        $check_sql = "SELECT id FROM product_gst_settings WHERE product_id = ?";
        $check_stmt = $conn->prepare($check_sql);
        $check_stmt->bind_param("i", $product_id);
        $check_stmt->execute();
        $check_result = $check_stmt->get_result();
        
        if ($check_result->num_rows > 0) {
            // Update existing record
            $update_sql = "UPDATE product_gst_settings 
                          SET gst_applicable = ?, 
                              gst_percentage = ?,
                              updated_at = NOW()
                          WHERE product_id = ?";
            $update_stmt = $conn->prepare($update_sql);
            $update_stmt->bind_param("idi", $gst_applicable, $gst_percentage, $product_id);
        } else {
            // Insert new record
            $update_sql = "INSERT INTO product_gst_settings (product_id, gst_applicable, gst_percentage, created_at, updated_at)
                          VALUES (?, ?, ?, NOW(), NOW())";
            $update_stmt = $conn->prepare($update_sql);
            $update_stmt->bind_param("iid", $product_id, $gst_applicable, $gst_percentage);
        }
        
        if ($update_stmt->execute()) {
            echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                    <i class="fas fa-check-circle me-2"></i>GST settings updated successfully!
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                  </div>';
        } else {
            echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <i class="fas fa-exclamation-triangle me-2"></i>Error updating GST settings: ' . htmlspecialchars($conn->error) . '
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                  </div>';
        }
    } else {
        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                <i class="fas fa-exclamation-triangle me-2"></i>Error: Product not found in your branch!
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
              </div>';
    }
}

// Handle bulk GST update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['bulk_gst_action'])) {
    $action = $_POST['bulk_gst_action'];
    $gst_percentage = floatval($_POST['bulk_gst_percentage']);
    
    if (isset($_POST['product_ids']) && is_array($_POST['product_ids'])) {
        $ids = array_map('intval', $_POST['product_ids']);
        
        // Create placeholders for the IDs
        $placeholders = implode(',', array_fill(0, count($ids), '?'));
        
        // Verify all products belong to the user's branch
        $verify_sql = "SELECT COUNT(*) as total FROM products WHERE id IN ($placeholders) AND branch_id = ?";
        $verify_stmt = $conn->prepare($verify_sql);
        
        // Create array of parameters
        $params = array_merge($ids, [$branch_id]);
        $types = str_repeat('i', count($ids)) . 'i';
        $verify_stmt->bind_param($types, ...$params);
        $verify_stmt->execute();
        $verify_result = $verify_stmt->get_result();
        $valid_count = $verify_result->fetch_assoc()['total'];
        
        if ($valid_count == count($ids)) {
            if ($action === 'apply') {
                // Apply GST to selected products
                foreach ($ids as $product_id) {
                    $check_sql = "SELECT id FROM product_gst_settings WHERE product_id = ?";
                    $check_stmt = $conn->prepare($check_sql);
                    $check_stmt->bind_param("i", $product_id);
                    $check_stmt->execute();
                    $check_result = $check_stmt->get_result();
                    
                    if ($check_result->num_rows > 0) {
                        $sql = "UPDATE product_gst_settings 
                               SET gst_applicable = 1, 
                                   gst_percentage = ?,
                                   updated_at = NOW()
                               WHERE product_id = ?";
                        $update_stmt = $conn->prepare($sql);
                        $update_stmt->bind_param("di", $gst_percentage, $product_id);
                    } else {
                        $sql = "INSERT INTO product_gst_settings (product_id, gst_applicable, gst_percentage, created_at, updated_at)
                               VALUES (?, 1, ?, NOW(), NOW())";
                        $update_stmt = $conn->prepare($sql);
                        $update_stmt->bind_param("id", $product_id, $gst_percentage);
                    }
                    $update_stmt->execute();
                }
                $msg = "GST applied to selected products successfully!";
            } elseif ($action === 'remove') {
                // Remove GST from selected products
                $sql = "UPDATE product_gst_settings 
                       SET gst_applicable = 0, 
                           updated_at = NOW()
                       WHERE product_id IN ($placeholders)";
                $update_stmt = $conn->prepare($sql);
                $update_stmt->bind_param(str_repeat('i', count($ids)), ...$ids);
                $update_stmt->execute();
                $msg = "GST removed from selected products successfully!";
            }
            
            echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                    <i class="fas fa-check-circle me-2"></i>' . htmlspecialchars($msg) . '
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                  </div>';
        } else {
            echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <i class="fas fa-exclamation-triangle me-2"></i>Error: One or more selected products do not belong to your branch!
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                  </div>';
        }
    }
}

// Build filters & search with prepared statements
$where = ["p.branch_id = ?"];
$params = [$branch_id];
$types = "i";

if (!empty($_GET['category'])) {
    $category = intval($_GET['category']);
    $where[] = "p.category_id = ?";
    $params[] = $category;
    $types .= "i";
}
if (!empty($_GET['brand'])) {
    $brand = intval($_GET['brand']);
    $where[] = "p.brand_id = ?";
    $params[] = $brand;
    $types .= "i";
}
if (!empty($_GET['gst_status'])) {
    $gst_status = $_GET['gst_status'];
    if ($gst_status === 'applicable') {
        $where[] = "COALESCE(g.gst_applicable, 0) = 1";
    } elseif ($gst_status === 'not_applicable') {
        $where[] = "COALESCE(g.gst_applicable, 0) = 0";
    }
}
if (!empty($_GET['search'])) {
    $search = '%' . $_GET['search'] . '%';
    $where[] = "(p.product_name LIKE ? OR b.brand_name LIKE ? OR p.model LIKE ? OR p.imei_number_1 LIKE ? OR p.imei_number_2 LIKE ?)";
    $params[] = $search;
    $params[] = $search;
    $params[] = $search;
    $params[] = $search;
    $params[] = $search;
    $types .= "sssss";
}

$where_sql = 'WHERE ' . implode(' AND ', $where);

// Count total products for pagination
$count_sql = "SELECT COUNT(*) as total
              FROM products p
              LEFT JOIN brands b ON p.brand_id = b.id
              LEFT JOIN categories c ON p.category_id = c.id
              LEFT JOIN product_gst_settings g ON p.id = g.product_id
              $where_sql";

$count_stmt = $conn->prepare($count_sql);
if ($count_stmt) {
    $count_stmt->bind_param($types, ...$params);
    $count_stmt->execute();
    $count_result = $count_stmt->get_result();
    $total_products = $count_result ? intval($count_result->fetch_assoc()['total']) : 0;
} else {
    $total_products = 0;
}

// Pagination
$per_page = 10;
$current_page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
$offset = ($current_page - 1) * $per_page;
$total_pages = $per_page > 0 ? ceil($total_products / $per_page) : 1;

// Main query: products with GST settings (without row number in SQL)
$sql = "SELECT p.*, c.category_name, b.brand_name, 
               COALESCE(g.gst_applicable, 0) as gst_applicable,
               COALESCE(g.gst_percentage, 18) as gst_percentage,
               g.updated_at as gst_updated
        FROM products p
        LEFT JOIN categories c ON p.category_id = c.id
        LEFT JOIN brands b ON p.brand_id = b.id
        LEFT JOIN product_gst_settings g ON p.id = g.product_id
        $where_sql
        ORDER BY p.product_name ASC
        LIMIT ?, ?";

// Add pagination parameters
$params[] = $offset;
$types .= "i";
$params[] = $per_page;
$types .= "i";

$stmt = $conn->prepare($sql);
$stmt->bind_param($types, ...$params);
$stmt->execute();
$result = $stmt->get_result();

// Get starting product number for the current page
$start_number = $offset + 1;

// Get GST statistics for this branch
$gst_stats_sql = "SELECT 
                    SUM(CASE WHEN COALESCE(g.gst_applicable, 0) = 1 THEN 1 ELSE 0 END) as gst_applicable,
                    SUM(CASE WHEN COALESCE(g.gst_applicable, 0) = 0 THEN 1 ELSE 0 END) as gst_not_applicable
                 FROM products p
                 LEFT JOIN product_gst_settings g ON p.id = g.product_id
                 WHERE p.branch_id = ?";
$gst_stats_stmt = $conn->prepare($gst_stats_sql);
$gst_stats_stmt->bind_param("i", $branch_id);
$gst_stats_stmt->execute();
$gst_stats_result = $gst_stats_stmt->get_result();
$gst_stats = $gst_stats_result->fetch_assoc();

// Get categories for filter
$cat_sql = "SELECT id, category_name FROM categories ORDER BY category_name";
$cat_res = $conn->query($cat_sql);

// Get brands for this branch only
$brand_sql = "SELECT id, brand_name FROM brands WHERE branch_id = ? ORDER BY brand_name";
$brand_stmt = $conn->prepare($brand_sql);
$brand_stmt->bind_param("i", $branch_id);
$brand_stmt->execute();
$brand_res = $brand_stmt->get_result();

// Debug: Check if there are any products
if ($total_products == 0) {
    // Check if the branch has any products at all
    $debug_sql = "SELECT COUNT(*) as total FROM products WHERE branch_id = ?";
    $debug_stmt = $conn->prepare($debug_sql);
    $debug_stmt->bind_param("i", $branch_id);
    $debug_stmt->execute();
    $debug_result = $debug_stmt->get_result();
    $debug_count = $debug_result->fetch_assoc()['total'];
    
    if ($debug_count > 0) {
        // There are products but filters might be too restrictive
        echo '<div class="alert alert-info alert-dismissible fade show" role="alert">
                <i class="fas fa-info-circle me-2"></i>No products match your current filters. Try clearing the filters to see all products.
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
              </div>';
    }
}
?>

<!doctype html>
<html lang="en">

<?php include('includes/head.php')?>

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>

<div class="main-content">
        <div class="page-content">          
            <div class="container-fluid">

<div class="branch-info">
                    <div class="row align-items-center">
                        <div class="col-md-8">
                            <h4 class="mb-1">
                                <i class="fas fa-store-alt me-2"></i>
                                <?php echo htmlspecialchars($branch_info['branch_name']); ?>
                                <span class="badge bg-primary"><?php echo htmlspecialchars($branch_info['branch_code']); ?></span>
                            </h4>
                            <p class="text-muted mb-0">
                                <i class="fas fa-info-circle me-1"></i>
                                Managing GST mapping for products in your branch
                                <span class="badge bg-info ms-2">Prices shown are inclusive of GST</span>
                            </p>
                        </div>
                        <div class="col-md-4 text-end">
                            <a href="products-manage.php" class="btn btn-primary">
                                <i class="fas fa-arrow-left me-2"></i>Back to Products
                            </a>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-chart-line me-2"></i>Branch GST Mapping Management
                                        <span class="badge bg-primary ms-2"><?php echo intval($total_products); ?> Products</span>
                                    </h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <a href="products-add.php" class="btn btn-outline-success">
                                            <i class="fas fa-plus-circle me-2"></i>Add Products
                                        </a>
                                        <a href="reports-gst.php" class="btn btn-outline-info">
                                            <i class="fas fa-chart-bar me-2"></i>GST Reports
                                        </a>
                                    </div>
                                </div>
                            </div>

<div class="card-body">
                                
                                <div class="row mb-3 g-2">
                                    <div class="col-md-3">
                                        <div class="input-group">
                                            <input type="text" class="form-control" id="searchInput" placeholder="Search branch products..." value="<?php echo isset($_GET['search']) ? htmlspecialchars($_GET['search']) : ''; ?>">
                                            <button class="btn btn-outline-secondary" type="button" id="searchButton"><i class="fas fa-search"></i></button>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="categoryFilter">
                                            <option value="">All Categories</option>
                                            <?php
                                            while ($c = $cat_res->fetch_assoc()) {
                                                $sel = (isset($_GET['category']) && $_GET['category'] == $c['id']) ? 'selected' : '';
                                                echo '<option value="'. $c['id'] .'" '. $sel .'>'. htmlspecialchars($c['category_name']) .'</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="brandFilter">
                                            <option value="">All Brands</option>
                                            <?php
                                            while ($b = $brand_res->fetch_assoc()) {
                                                $sel = (isset($_GET['brand']) && $_GET['brand'] == $b['id']) ? 'selected' : '';
                                                echo '<option value="'. $b['id'] .'" '. $sel .'>'. htmlspecialchars($b['brand_name']) .'</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="gstStatusFilter">
                                            <option value="">All GST Status</option>
                                            <option value="applicable" <?php echo (isset($_GET['gst_status']) && $_GET['gst_status']=='applicable')?'selected':''; ?>>GST Applicable</option>
                                            <option value="not_applicable" <?php echo (isset($_GET['gst_status']) && $_GET['gst_status']=='not_applicable')?'selected':''; ?>>GST Not Applicable</option>
                                        </select>
                                    </div>
                                    <div class="col-md-1">
                                        <button class="btn btn-outline-danger w-100" id="clearFiltersBtn">
                                            <i class="fas fa-times me-1"></i>Clear
                                        </button>
                                    </div>
                                </div>

<div class="row mb-3">
                                    <div class="col-12">
                                        <div class="d-flex flex-wrap gap-3 align-items-center">
                                            <div class="stat-box bg-primary text-white rounded p-2 px-3">
                                                <small class="opacity-75">Branch Products</small>
                                                <div class="fw-bold"><?php echo number_format($total_products); ?></div>
                                            </div>
                                            <div class="stat-box bg-success text-white rounded p-2 px-3">
                                                <small class="opacity-75">With GST</small>
                                                <div class="fw-bold"><?php echo number_format($gst_stats['gst_applicable'] ?? 0); ?></div>
                                            </div>
                                            <div class="stat-box bg-secondary text-white rounded p-2 px-3">
                                                <small class="opacity-75">Without GST</small>
                                                <div class="fw-bold"><?php echo number_format($gst_stats['gst_not_applicable'] ?? 0); ?></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mb-3">
                                    <div class="col-12">
                                        <div class="d-flex gap-2 align-items-center flex-wrap">
                                            <select class="form-select" id="bulkGstAction" style="width:auto;">
                                                <option value="">Bulk GST Actions</option>
                                                <option value="apply">Apply GST</option>
                                                <option value="remove">Remove GST</option>
                                            </select>
                                            <input type="number" class="form-control" id="bulkGstPercentage" placeholder="GST %" value="18" min="0" max="100" step="0.1" style="width:120px;">
                                            <button class="btn btn-outline-primary" id="applyBulkGstAction">Apply</button>
                                            <div class="ms-auto">
                                                <span id="selectedCount" class="badge bg-primary">0 products selected</span>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <form id="bulkGstForm" method="POST" action="">
                                    <table class="table table-bordered table-hover table-striped mb-0" id="gstMappingTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th style="width:48px;">
                                                    <div class="form-check">
                                                        <input class="form-check-input" type="checkbox" id="selectAll">
                                                    </div>
                                                </th>
                                                <th style="width:100px">Product #</th>
                                                <th>Product Name</th>
                                                <th style="width:140px">Category</th>
                                                <th style="width:140px">Brand</th>
                                                <th style="width:120px">Model</th>
                                                <th style="width:180px">Price (Incl. GST)</th>
                                                <th style="width:150px">GST Applicable</th>
                                                <th style="width:150px">GST Percentage</th>
                                                <th style="width:120px">Last Updated</th>
                                                <th style="width:100px">Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $counter = $start_number;
                                            if ($result && $result->num_rows > 0) {
                                                while ($product = $result->fetch_assoc()) {
                                                    $selling_price = floatval($product['selling_price']);
                                                    $gst_applicable = intval($product['gst_applicable']);
                                                    $gst_percentage = floatval($product['gst_percentage']);
                                                    $global_id = $product['id'];
                                                    
                                                    // Calculate base price and GST amount
                                                    $price_calc = calculateInclusiveGst($selling_price, $gst_percentage, $gst_applicable);
                                                    $base_price = $price_calc['base_price'];
                                                    $gst_amount = $price_calc['gst_amount'];
                                                    $display_price = $price_calc['selling_price'];
                                                    
                                                    // Branch-specific product number
                                                    $branch_product_number = $counter;
                                                    ?>
                                                    <tr>
                                                        <td>
                                                            <div class="form-check">
                                                                <input class="form-check-input product-checkbox" type="checkbox" name="product_ids[]" value="<?php echo $global_id; ?>">
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div>
                                                                <span class="product-id fw-bold text-primary">#<?php echo $branch_product_number; ?></span>
                                                                <br>
                                                                <small class="global-id text-muted">ID: <?php echo $global_id; ?></small>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <div class="d-flex align-items-center">
                                                                <div class="flex-shrink-0">
                                                                    <div class="avatar-xs bg-light rounded">
                                                                        <i class="fas fa-box font-size-13 text-primary"></i>
                                                                    </div>
                                                                </div>
                                                                <div class="flex-grow-1 ms-2">
                                                                    <h6 class="mb-0"><?php echo htmlspecialchars($product['product_name']); ?></h6>
                                                                    <small class="text-muted">Stock: <?php echo intval($product['stock_quantity']); ?> units</small>
                                                                    <?php if ($product['stock_quantity'] <= $product['min_stock'] && $product['stock_quantity'] > 0): ?>
                                                                        <br><small class="text-warning"><i class="fas fa-exclamation-triangle"></i> Low Stock</small>
                                                                    <?php elseif ($product['stock_quantity'] == 0): ?>
                                                                        <br><small class="text-danger"><i class="fas fa-times-circle"></i> Out of Stock</small>
                                                                    <?php endif; ?>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-info"><?php echo htmlspecialchars($product['category_name'] ?: 'No Category'); ?></span>
                                                        </td>
                                                        <td>
                                                            <?php if (!empty($product['brand_name'])): ?>
                                                                <?php echo htmlspecialchars($product['brand_name']); ?>
                                                            <?php else: ?>
                                                                <span class="text-muted">No Brand</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo htmlspecialchars($product['model']); ?></td>
                                                        <td>
                                                            <div class="text-nowrap">
                                                                <strong class="text-primary">₹<?php echo number_format($display_price, 2); ?></strong>
                                                                <?php if ($gst_applicable): ?>
                                                                    <br>
                                                                    <small class="text-muted">Base: ₹<?php echo number_format($base_price, 2); ?></small>
                                                                    <br>
                                                                    <small class="text-success">+GST: ₹<?php echo number_format($gst_amount, 2); ?></small>
                                                                    <div class="mt-1">
                                                                        <small class="badge bg-light text-dark">
                                                                            <i class="fas fa-info-circle me-1"></i>Inclusive of <?php echo $gst_percentage; ?>% GST
                                                                        </small>
                                                                    </div>
                                                                <?php else: ?>
                                                                    <br>
                                                                    <small class="text-muted">No GST applied</small>
                                                                <?php endif; ?>
                                                            </div>
                                                        </td>
                                                        <td>
                                                            <form method="POST" class="gst-toggle-form">
                                                                <input type="hidden" name="product_id" value="<?php echo $global_id; ?>">
                                                                <input type="hidden" name="gst_percentage" value="<?php echo $gst_percentage; ?>">
                                                                <div class="form-check form-switch">
                                                                    <input class="form-check-input gst-toggle" type="checkbox" name="gst_applicable" 
                                                                           <?php echo $gst_applicable ? 'checked' : ''; ?> 
                                                                           onchange="this.form.submit()">
                                                                    <label class="form-check-label">
                                                                        <?php echo $gst_applicable ? 
                                                                            '<span class="badge bg-success">Applicable</span>' : 
                                                                            '<span class="badge bg-secondary">Not Applicable</span>'; ?>
                                                                    </label>
                                                                </div>
                                                                <input type="hidden" name="update_gst" value="1">
                                                            </form>
                                                        </td>
                                                        <td>
                                                            <form method="POST" class="gst-percentage-form">
                                                                <input type="hidden" name="product_id" value="<?php echo $global_id; ?>">
                                                                <input type="hidden" name="gst_applicable" value="<?php echo $gst_applicable ? '1' : '0'; ?>">
                                                                <div class="input-group input-group-sm">
                                                                    <input type="number" class="form-control form-control-sm gst-percentage" 
                                                                           name="gst_percentage" value="<?php echo $gst_percentage; ?>" 
                                                                           min="0" max="100" step="0.1" style="width:80px;">
                                                                    <span class="input-group-text">%</span>
                                                                    <button type="submit" class="btn btn-outline-primary btn-sm" name="update_gst" value="1">
                                                                        <i class="fas fa-save"></i>
                                                                    </button>
                                                                </div>
                                                            </form>
                                                        </td>
                                                        <td>
                                                            <?php if (!empty($product['gst_updated'])): ?>
                                                                <small class="text-muted"><?php echo date('M j, Y', strtotime($product['gst_updated'])); ?></small>
                                                            <?php else: ?>
                                                                <small class="text-muted">Never</small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group btn-group-sm" role="group">
                                                                <a href="products-edit.php?id=<?php echo $global_id; ?>" class="btn btn-outline-primary" title="Edit Product">
                                                                    <i class="fas fa-edit"></i>
                                                                </a>
                                                                <a href="products-manage.php?view=<?php echo $global_id; ?>" class="btn btn-outline-info" title="View Details">
                                                                    <i class="fas fa-eye"></i>
                                                                </a>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php
                                                $counter++;
                                                } // end while
                                            } else {
                                                echo '<tr><td colspan="11" class="text-center py-5">
                                                        <i class="fas fa-inbox display-4 text-muted"></i>
                                                        <h5 class="mt-2">No Products Found</h5>
                                                        <p class="text-muted">No products found in your branch. Add products to manage GST mapping.</p>
                                                        <a href="products-add.php" class="btn btn-primary mt-3"><i class="fas fa-plus-circle me-2"></i>Add Products</a>
                                                        </td></tr>';
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                    </form>
                                </div>

<?php if ($total_pages > 1): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <nav>
                                            <ul class="pagination justify-content-center">
                                                <li class="page-item <?php echo ($current_page == 1) ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="<?php echo build_page_url($current_page - 1); ?>">Previous</a>
                                                </li>
                                                <?php
                                                $start = max(1, $current_page - 3);
                                                $end = min($total_pages, $current_page + 3);
                                                for ($i = $start; $i <= $end; $i++):
                                                ?>
                                                    <li class="page-item <?php echo ($i == $current_page) ? 'active' : ''; ?>">
                                                        <a class="page-link" href="<?php echo build_page_url($i); ?>"><?php echo $i; ?></a>
                                                    </li>
                                                <?php endfor; ?>
                                                <li class="page-item <?php echo ($current_page == $total_pages) ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="<?php echo build_page_url($current_page + 1); ?>">Next</a>
                                                </li>
                                            </ul>
                                        </nav>
                                    </div>
                                </div>
                                <?php endif; ?>

</div> 
                        </div> 
                    </div>
                </div>

</div> 
        </div>

<?php include('includes/footer.php')?>
    </div> 
</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

// Select all toggle
    if (selectAll) {
        selectAll.addEventListener('change', function() {
            document.querySelectorAll('.product-checkbox').forEach(cb => cb.checked = this.checked);
            updateSelectedCount();
        });
    }

// Update selected count
    function updateSelectedCount() {
        const selected = document.querySelectorAll('.product-checkbox:checked').length;
        selectedCount.textContent = selected + ' products selected';
    }
    document.querySelectorAll('.product-checkbox').forEach(cb => cb.addEventListener('change', updateSelectedCount));

// Apply bulk GST action
    if (applyBulkGstAction) {
        applyBulkGstAction.addEventListener('click', function() {
            const action = bulkGstAction.value;
            const percentage = parseFloat(bulkGstPercentage.value);
            const checked = Array.from(document.querySelectorAll('.product-checkbox:checked')).map(i => i.value);
            
            if (!action) { 
                alert('Please select a bulk GST action.'); 
                return; 
            }
            if (checked.length === 0) { 
                alert('Please select at least one product.'); 
                return; 
            }
            if (action === 'apply' && (isNaN(percentage) || percentage < 0 || percentage > 100)) {
                alert('Please enter a valid GST percentage (0-100).'); 
                return; 
            }

// Show confirmation with explanation about inclusive pricing
            if (action === 'apply') {
                const confirmMsg = `Apply ${percentage}% GST to ${checked.length} product(s)?\n\nNote: The product selling price will remain the same (inclusive of GST).\nThe GST amount will be calculated from the inclusive price.`;
                if (!confirm(confirmMsg)) return;
            } else if (action === 'remove') {
                const confirmMsg = `Remove GST from ${checked.length} product(s)?\n\nNote: The product selling price will remain the same.\nGST will be removed from the inclusive price.`;
                if (!confirm(confirmMsg)) return;
            }

// Create and submit form
            const form = document.createElement('form');
            form.method = 'POST';
            form.action = '';

checked.forEach(id => {
                const input = document.createElement('input');
                input.type = 'hidden';
                input.name = 'product_ids[]';
                input.value = id;
                form.appendChild(input);
            });
            
            const actionInput = document.createElement('input');
            actionInput.type = 'hidden';
            actionInput.name = 'bulk_gst_action';
            actionInput.value = action;
            form.appendChild(actionInput);

if (action === 'apply') {
                const percentageInput = document.createElement('input');
                percentageInput.type = 'hidden';
                percentageInput.name = 'bulk_gst_percentage';
                percentageInput.value = percentage;
                form.appendChild(percentageInput);
            }

document.body.appendChild(form);
            form.submit();
        });
    }

// Auto-submit GST toggle forms
    document.querySelectorAll('.gst-toggle').forEach(toggle => {
        toggle.addEventListener('change', function() {
            // Update the corresponding percentage form's applicable value
            const row = this.closest('tr');
            const percentageForm = row.querySelector('.gst-percentage-form');
            const applicableInput = percentageForm.querySelector('input[name="gst_applicable"]');
            applicableInput.value = this.checked ? '1' : '0';
            
            // Show confirmation for GST change
            const productName = row.querySelector('h6').textContent;
            const sellingPrice = row.querySelector('.text-primary').textContent;
            const action = this.checked ? 'apply' : 'remove';
            
            if (action === 'apply') {
                const msg = `Apply GST to "${productName}"?\n\nSelling Price: ${sellingPrice} (will remain inclusive of GST)\nThe GST amount will be calculated from this inclusive price.`;
                if (!confirm(msg)) {
                    this.checked = !this.checked;
                    return;
                }
            } else {
                const msg = `Remove GST from "${productName}"?\n\nSelling Price: ${sellingPrice} (will remain the same)\nGST will be removed from the inclusive price.`;
                if (!confirm(msg)) {
                    this.checked = !this.checked;
                    return;
                }
            }
            
            this.form.submit();
        });
    });

// Validate GST percentage changes
    document.querySelectorAll('.gst-percentage').forEach(input => {
        input.addEventListener('change', function() {
            const row = this.closest('tr');
            const productName = row.querySelector('h6').textContent;
            const sellingPrice = row.querySelector('.text-primary').textContent;
            const newPercentage = parseFloat(this.value);
            
            if (newPercentage < 0 || newPercentage > 100) {
                alert('GST percentage must be between 0 and 100.');
                return;
            }
            
            const msg = `Update GST to ${newPercentage}% for "${productName}"?\n\nSelling Price: ${sellingPrice} (will remain inclusive of GST)\nThe GST amount will be recalculated from this inclusive price.`;
            if (!confirm(msg)) {
                this.value = this.defaultValue;
                return;
            }
        });
    });

// Filters functionality
    function applyFilters() {
        const params = new URLSearchParams();
        if (searchInput && searchInput.value.trim()) params.set('search', searchInput.value.trim());
        if (categoryFilter && categoryFilter.value) params.set('category', categoryFilter.value);
        if (brandFilter && brandFilter.value) params.set('brand', brandFilter.value);
        if (gstStatusFilter && gstStatusFilter.value) params.set('gst_status', gstStatusFilter.value);
        params.set('page', 1);
        window.location.href = 'gst-mapping.php?' + params.toString();
    }

// Clear all filters
    if (clearFiltersBtn) {
        clearFiltersBtn.addEventListener('click', function() {
            window.location.href = 'gst-mapping.php';
        });
    }

if (searchButton) searchButton.addEventListener('click', applyFilters);
    if (searchInput) searchInput.addEventListener('keypress', function(e){ if (e.key === 'Enter') applyFilters(); });
    if (categoryFilter) categoryFilter.addEventListener('change', applyFilters);
    if (brandFilter) brandFilter.addEventListener('change', applyFilters);
    if (gstStatusFilter) gstStatusFilter.addEventListener('change', applyFilters);

// Initialize selected count
    updateSelectedCount();
});

// Helper function for pagination
function build_page_url(page) {
    const params = new URLSearchParams(window.location.search);
    if (page && page > 0) params.set('page', page);
    else params.delete('page');
    return 'gst-mapping.php?' + params.toString();
}
</script>

</body>
</html>

<?php
// Helper function used in PHP for building page links
function build_page_url($page) {
    $params = $_GET;
    $params['page'] = max(1, intval($page));
    return 'gst-mapping.php?' . http_build_query($params);
}

// Close DB connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: gst-mapping.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation