<?php
/**
 * Sales Management Page for Kayal Aqua
 * Record and manage sales transactions
 */

require_once '../config/config.php';
require_once '../includes/functions.php';

// Check permissions
if (!hasPermission('manage_sales') && !hasPermission('add_sales')) {
    redirect('../index.php');
}

$pageTitle = 'Sales Management';
$breadcrumb = [
    ['title' => 'Sales Management']
];

$success = '';
$error = '';
$currentUser = getCurrentUser();

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    try {
        $action = $_POST['action'] ?? '';
        
        switch ($action) {
            case 'add_sale':
                $title = sanitizeInput($_POST['title']);
                $amount = (float)$_POST['amount'];
                $quantity = (float)($_POST['quantity'] ?? 1);
                $unitPrice = $quantity > 0 ? $amount / $quantity : $amount;
                $categoryId = !empty($_POST['category_id']) ? (int)$_POST['category_id'] : null;
                $segmentId = !empty($_POST['segment_id']) ? (int)$_POST['segment_id'] : null;
                $saleDate = $_POST['sale_date'];
                $customerName = sanitizeInput($_POST['customer_name'] ?? '');
                $customerPhone = sanitizeInput($_POST['customer_phone'] ?? '');
                $description = sanitizeInput($_POST['description'] ?? '');
                
                // Validation
                if (empty($title) || $amount <= 0 || empty($saleDate)) {
                    throw new Exception('Title, amount, and sale date are required.');
                }
                
                if ($customerPhone && !isValidPhone($customerPhone)) {
                    throw new Exception('Please enter a valid customer phone number.');
                }
                
                // Generate invoice number
                $invoiceNumber = generateInvoiceNumber();
                
                // Handle receipt image upload
                $receiptImage = null;
                if (isset($_FILES['receipt_image']) && $_FILES['receipt_image']['error'] === UPLOAD_ERR_OK) {
                    try {
                        $receiptImage = handleFileUpload('receipt_image', '../uploads/receipts/');
                    } catch (Exception $e) {
                        // Log error but don't fail the transaction
                        error_log("Receipt upload failed: " . $e->getMessage());
                    }
                }
                
                $saleData = [
                    'title' => $title,
                    'amount' => $amount,
                    'quantity' => $quantity,
                    'unit_price' => $unitPrice,
                    'category_id' => $categoryId,
                    'segment_id' => $segmentId,
                    'sale_date' => $saleDate,
                    'customer_name' => $customerName,
                    'customer_phone' => $customerPhone,
                    'description' => $description,
                    'invoice_number' => $invoiceNumber,
                    'receipt_image' => $receiptImage,
                    'created_by' => $currentUser['id'],
                    'created_at' => date('Y-m-d H:i:s')
                ];
                
                $saleId = insertData('sales', $saleData);
                
                if ($saleId) {
                    logSystemActivity('Add Sale', "Added sale: {$title} - " . formatIndianCurrency($amount));
                    $success = 'Sale recorded successfully! Invoice: ' . $invoiceNumber;
                } else {
                    throw new Exception('Failed to record sale.');
                }
                break;
                
            case 'update_sale':
                $saleId = (int)$_POST['sale_id'];
                $title = sanitizeInput($_POST['title']);
                $amount = (float)$_POST['amount'];
                $quantity = (float)($_POST['quantity'] ?? 1);
                $unitPrice = $quantity > 0 ? $amount / $quantity : $amount;
                $categoryId = !empty($_POST['category_id']) ? (int)$_POST['category_id'] : null;
                $segmentId = !empty($_POST['segment_id']) ? (int)$_POST['segment_id'] : null;
                $saleDate = $_POST['sale_date'];
                $customerName = sanitizeInput($_POST['customer_name'] ?? '');
                $customerPhone = sanitizeInput($_POST['customer_phone'] ?? '');
                $description = sanitizeInput($_POST['description'] ?? '');
                
                // Validation
                if (empty($title) || $amount <= 0 || empty($saleDate)) {
                    throw new Exception('Title, amount, and sale date are required.');
                }
                
                if ($customerPhone && !isValidPhone($customerPhone)) {
                    throw new Exception('Please enter a valid customer phone number.');
                }
                
                // Check if user can edit this sale
                $existingSale = fetchRow("SELECT * FROM sales WHERE id = ?", [$saleId]);
                if (!$existingSale) {
                    throw new Exception('Sale not found.');
                }
                
                if ($currentUser['role'] !== 'admin' && $existingSale['created_by'] != $currentUser['id']) {
                    throw new Exception('You can only edit your own sales records.');
                }
                
                $updateData = [
                    'title' => $title,
                    'amount' => $amount,
                    'quantity' => $quantity,
                    'unit_price' => $unitPrice,
                    'category_id' => $categoryId,
                    'segment_id' => $segmentId,
                    'sale_date' => $saleDate,
                    'customer_name' => $customerName,
                    'customer_phone' => $customerPhone,
                    'description' => $description
                ];
                
                updateData('sales', $updateData, 'id = ?', [$saleId]);
                
                logSystemActivity('Update Sale', "Updated sale ID: {$saleId}");
                $success = 'Sale updated successfully!';
                break;
                
            case 'delete_sale':
                $saleId = (int)$_POST['sale_id'];
                
                // Check if user can delete this sale
                $existingSale = fetchRow("SELECT * FROM sales WHERE id = ?", [$saleId]);
                if (!$existingSale) {
                    throw new Exception('Sale not found.');
                }
                
                if ($currentUser['role'] !== 'admin' && $existingSale['created_by'] != $currentUser['id']) {
                    throw new Exception('You can only delete your own sales records.');
                }
                
                // Delete associated receipt image
                if ($existingSale['receipt_image'] && file_exists('../' . $existingSale['receipt_image'])) {
                    unlink('../' . $existingSale['receipt_image']);
                }
                
                executeQuery("DELETE FROM sales WHERE id = ?", [$saleId]);
                
                logSystemActivity('Delete Sale', "Deleted sale: {$existingSale['title']}");
                $success = 'Sale deleted successfully!';
                break;
        }
    } catch (Exception $e) {
        $error = $e->getMessage();
    }
}

// Get filter parameters
$dateFrom = $_GET['date_from'] ?? date('Y-m-01'); // First day of current month
$dateTo = $_GET['date_to'] ?? date('Y-m-d'); // Today
$segmentFilter = $_GET['segment'] ?? '';
$categoryFilter = $_GET['category'] ?? '';
$search = $_GET['search'] ?? '';

// Build query for sales list
$whereConditions = [];
$params = [];

// Date range filter
if ($dateFrom) {
    $whereConditions[] = "s.sale_date >= ?";
    $params[] = $dateFrom;
}
if ($dateTo) {
    $whereConditions[] = "s.sale_date <= ?";
    $params[] = $dateTo;
}

// Segment filter
if ($segmentFilter) {
    $whereConditions[] = "s.segment_id = ?";
    $params[] = $segmentFilter;
}

// Category filter
if ($categoryFilter) {
    $whereConditions[] = "s.category_id = ?";
    $params[] = $categoryFilter;
}

// Search filter
if ($search) {
    $whereConditions[] = "(s.title LIKE ? OR s.customer_name LIKE ? OR s.invoice_number LIKE ?)";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
}

// User-specific filter for non-admin users
if ($currentUser['role'] !== 'admin' && !hasPermission('manage_sales')) {
    $whereConditions[] = "s.created_by = ?";
    $params[] = $currentUser['id'];
}

$whereClause = !empty($whereConditions) ? 'WHERE ' . implode(' AND ', $whereConditions) : '';

// Get sales with related data
$salesQuery = "
    SELECT s.*, 
           bs.name as segment_name,
           c.name as category_name,
           u.full_name as created_by_name
    FROM sales s
    LEFT JOIN business_segments bs ON s.segment_id = bs.id
    LEFT JOIN categories c ON s.category_id = c.id
    LEFT JOIN users u ON s.created_by = u.id
    {$whereClause}
    ORDER BY s.sale_date DESC, s.created_at DESC
    LIMIT 100
";

$sales = fetchAll($salesQuery, $params);

// Calculate totals for the filtered data
$totalQuery = "
    SELECT 
        COUNT(*) as total_count,
        SUM(amount) as total_amount,
        AVG(amount) as avg_amount,
        SUM(quantity) as total_quantity
    FROM sales s
    {$whereClause}
";
$totals = fetchRow($totalQuery, $params);

// Get data for dropdowns
$businessSegments = getBusinessSegments();
$revenueCategories = getCategories('revenue');

include '../includes/header.php';
?>

<div class="sales-container">
    <!-- Page Header -->
    <div class="page-header mb-4">
        <div class="d-flex justify-content-between align-items-center">
            <div>
                <h1 class="page-title">
                    <i class="fas fa-shopping-cart"></i>
                    Sales Management
                </h1>
                <p class="page-description">
                    Record, track, and manage your fish sales transactions.
                </p>
            </div>
            <div class="page-actions">
                <button class="btn btn-primary" onclick="showAddSaleModal()">
                    <i class="fas fa-plus"></i>
                    <span class="desktop-only">Record Sale</span>
                </button>
            </div>
        </div>
    </div>

    <!-- Success/Error Messages -->
    <?php if ($success): ?>
        <div class="alert alert-success alert-dismissible">
            <i class="fas fa-check-circle"></i>
            <?php echo htmlspecialchars($success); ?>
            <button type="button" class="btn-close" onclick="this.parentElement.remove()">×</button>
        </div>
    <?php endif; ?>

    <?php if ($error): ?>
        <div class="alert alert-danger alert-dismissible">
            <i class="fas fa-exclamation-circle"></i>
            <?php echo htmlspecialchars($error); ?>
            <button type="button" class="btn-close" onclick="this.parentElement.remove()">×</button>
        </div>
    <?php endif; ?>

    <!-- Sales Statistics -->
    <div class="stats-section mb-4">
        <div class="row">
            <div class="col-md-3 mb-3">
                <div class="stat-card">
                    <div class="stat-icon bg-success">
                        <i class="fas fa-chart-line"></i>
                    </div>
                    <div class="stat-content">
                        <div class="stat-value"><?php echo formatIndianCurrency($totals['total_amount'] ?? 0); ?></div>
                        <div class="stat-label">Total Sales</div>
                    </div>
                </div>
            </div>
            <div class="col-md-3 mb-3">
                <div class="stat-card">
                    <div class="stat-icon bg-primary">
                        <i class="fas fa-receipt"></i>
                    </div>
                    <div class="stat-content">
                        <div class="stat-value"><?php echo number_format($totals['total_count'] ?? 0); ?></div>
                        <div class="stat-label">Transactions</div>
                    </div>
                </div>
            </div>
            <div class="col-md-3 mb-3">
                <div class="stat-card">
                    <div class="stat-icon bg-info">
                        <i class="fas fa-calculator"></i>
                    </div>
                    <div class="stat-content">
                        <div class="stat-value"><?php echo formatIndianCurrency($totals['avg_amount'] ?? 0); ?></div>
                        <div class="stat-label">Average Sale</div>
                    </div>
                </div>
            </div>
            <div class="col-md-3 mb-3">
                <div class="stat-card">
                    <div class="stat-icon bg-warning">
                        <i class="fas fa-weight"></i>
                    </div>
                    <div class="stat-content">
                        <div class="stat-value"><?php echo number_format($totals['total_quantity'] ?? 0, 1); ?></div>
                        <div class="stat-label">Total Quantity</div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Filters -->
    <div class="card filters-card mb-4">
        <div class="card-body">
            <form method="GET" class="filters-form">
                <div class="row">
                    <div class="col-md-3 mb-3">
                        <label for="date_from" class="form-label">From Date</label>
                        <input type="date" id="date_from" name="date_from" class="form-control" 
                               value="<?php echo htmlspecialchars($dateFrom); ?>">
                    </div>
                    <div class="col-md-3 mb-3">
                        <label for="date_to" class="form-label">To Date</label>
                        <input type="date" id="date_to" name="date_to" class="form-control" 
                               value="<?php echo htmlspecialchars($dateTo); ?>">
                    </div>
                    <div class="col-md-2 mb-3">
                        <label for="segment" class="form-label">Segment</label>
                        <select id="segment" name="segment" class="form-control">
                            <option value="">All Segments</option>
                            <?php foreach ($businessSegments as $segment): ?>
                                <option value="<?php echo $segment['id']; ?>" 
                                        <?php echo $segmentFilter == $segment['id'] ? 'selected' : ''; ?>>
                                    <?php echo htmlspecialchars($segment['name']); ?>
                                </option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="col-md-2 mb-3">
                        <label for="category" class="form-label">Category</label>
                        <select id="category" name="category" class="form-control">
                            <option value="">All Categories</option>
                            <?php foreach ($revenueCategories as $category): ?>
                                <option value="<?php echo $category['id']; ?>" 
                                        <?php echo $categoryFilter == $category['id'] ? 'selected' : ''; ?>>
                                    <?php echo htmlspecialchars($category['name']); ?>
                                </option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="col-md-2 mb-3">
                        <label for="search" class="form-label">Search</label>
                        <input type="text" id="search" name="search" class="form-control" 
                               placeholder="Title, customer..." value="<?php echo htmlspecialchars($search); ?>">
                    </div>
                </div>
                <div class="filter-actions">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-filter"></i> Apply Filters
                    </button>
                    <a href="sales.php" class="btn btn-outline">
                        <i class="fas fa-times"></i> Clear
                    </a>
                    <button type="button" class="btn btn-success" onclick="exportSales()">
                        <i class="fas fa-download"></i> Export
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Sales List -->
    <div class="card">
        <div class="card-header">
            <h5 class="card-title">
                <i class="fas fa-list"></i>
                Sales Records
            </h5>
            <div class="card-subtitle">
                Showing <?php echo count($sales); ?> of <?php echo $totals['total_count']; ?> sales
            </div>
        </div>
        <div class="card-body">
            <?php if (empty($sales)): ?>
                <div class="empty-state text-center py-5">
                    <i class="fas fa-shopping-cart fa-4x text-muted mb-3"></i>
                    <h5>No Sales Found</h5>
                    <p class="text-muted">
                        <?php if ($search || $segmentFilter || $categoryFilter): ?>
                            Try adjusting your filters or search criteria.
                        <?php else: ?>
                            Start by recording your first sale.
                        <?php endif; ?>
                    </p>
                    <button class="btn btn-primary" onclick="showAddSaleModal()">
                        <i class="fas fa-plus"></i> Record First Sale
                    </button>
                </div>
            <?php else: ?>
                <div class="table-responsive">
                    <table class="table table-hover" id="salesTable">
                        <thead>
                            <tr>
                                <th>Invoice/Details</th>
                                <th>Customer</th>
                                <th class="desktop-only">Category</th>
                                <th>Amount</th>
                                <th class="desktop-only">Quantity</th>
                                <th>Date</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach ($sales as $sale): ?>
                                <tr data-sale-id="<?php echo $sale['id']; ?>">
                                    <td>
                                        <div class="sale-info">
                                            <div class="sale-title"><?php echo htmlspecialchars($sale['title']); ?></div>
                                            <div class="sale-meta">
                                                <span class="invoice-number">
                                                    <i class="fas fa-hashtag"></i>
                                                    <?php echo htmlspecialchars($sale['invoice_number']); ?>
                                                </span>
                                                <?php if ($sale['segment_name']): ?>
                                                    <span class="segment-badge">
                                                        <?php echo htmlspecialchars($sale['segment_name']); ?>
                                                    </span>
                                                <?php endif; ?>
                                            </div>
                                            <div class="mobile-only sale-details-mobile">
                                                <small class="text-muted">
                                                    <?php if ($sale['category_name']): ?>
                                                        <?php echo htmlspecialchars($sale['category_name']); ?> • 
                                                    <?php endif; ?>
                                                    Qty: <?php echo number_format($sale['quantity'], 1); ?>
                                                </small>
                                            </div>
                                        </div>
                                    </td>
                                    <td>
                                        <div class="customer-info">
                                            <?php if ($sale['customer_name']): ?>
                                                <div class="customer-name"><?php echo htmlspecialchars($sale['customer_name']); ?></div>
                                            <?php else: ?>
                                                <div class="text-muted">Walk-in Customer</div>
                                            <?php endif; ?>
                                            <?php if ($sale['customer_phone']): ?>
                                                <div class="customer-phone">
                                                    <i class="fas fa-phone"></i>
                                                    <?php echo htmlspecialchars($sale['customer_phone']); ?>
                                                </div>
                                            <?php endif; ?>
                                        </div>
                                    </td>
                                    <td class="desktop-only">
                                        <?php if ($sale['category_name']): ?>
                                            <span class="badge badge-info">
                                                <?php echo htmlspecialchars($sale['category_name']); ?>
                                            </span>
                                        <?php else: ?>
                                            <span class="text-muted">-</span>
                                        <?php endif; ?>
                                    </td>
                                    <td>
                                        <div class="amount-info">
                                            <div class="sale-amount"><?php echo formatIndianCurrency($sale['amount']); ?></div>
                                            <?php if ($sale['quantity'] > 1): ?>
                                                <small class="unit-price">
                                                    @ <?php echo formatIndianCurrency($sale['unit_price']); ?>
                                                </small>
                                            <?php endif; ?>
                                        </div>
                                    </td>
                                    <td class="desktop-only">
                                        <?php echo number_format($sale['quantity'], 1); ?>
                                    </td>
                                    <td>
                                        <div class="date-info">
                                            <div class="sale-date"><?php echo formatDate($sale['sale_date'], 'd M'); ?></div>
                                            <small class="created-time"><?php echo date('g:i A', strtotime($sale['created_at'])); ?></small>
                                        </div>
                                    </td>
                                    <td>
                                        <div class="action-buttons">
                                            <button class="btn btn-sm btn-outline" 
                                                    onclick="viewSale(<?php echo htmlspecialchars(json_encode($sale)); ?>)"
                                                    title="View Details">
                                                <i class="fas fa-eye"></i>
                                            </button>
                                            <?php if ($currentUser['role'] === 'admin' || $sale['created_by'] == $currentUser['id']): ?>
                                                <button class="btn btn-sm btn-outline" 
                                                        onclick="editSale(<?php echo htmlspecialchars(json_encode($sale)); ?>)"
                                                        title="Edit Sale">
                                                    <i class="fas fa-edit"></i>
                                                </button>
                                                <button class="btn btn-sm btn-outline text-danger" 
                                                        onclick="deleteSale(<?php echo $sale['id']; ?>, '<?php echo htmlspecialchars($sale['title']); ?>')"
                                                        title="Delete Sale">
                                                    <i class="fas fa-trash"></i>
                                                </button>
                                            <?php endif; ?>
                                        </div>
                                    </td>
                                </tr>
                            <?php endforeach; ?>
                        </tbody>
                    </table>
                </div>
            <?php endif; ?>
        </div>
    </div>
</div>

<!-- Add Sale Modal -->
<div class="modal" id="addSaleModal">
    <div class="modal-content modal-lg">
        <div class="modal-header">
            <h3 class="modal-title">Record New Sale</h3>
            <button class="modal-close" onclick="closeModal('addSaleModal')">&times;</button>
        </div>
        <div class="modal-body">
            <form id="addSaleForm" method="POST" enctype="multipart/form-data" data-validate>
                <input type="hidden" name="action" value="add_sale">
                
                <div class="row">
                    <div class="col-md-8">
                        <div class="form-group">
                            <label for="add_title" class="form-label">Product/Service Title <span class="text-danger">*</span></label>
                            <input type="text" id="add_title" name="title" class="form-control" required 
                                   placeholder="e.g., Fresh Pomfret Fish">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="add_sale_date" class="form-label">Sale Date <span class="text-danger">*</span></label>
                            <input type="date" id="add_sale_date" name="sale_date" class="form-control" 
                                   value="<?php echo date('Y-m-d'); ?>" required>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="add_amount" class="form-label">Total Amount <span class="text-danger">*</span></label>
                            <input type="number" id="add_amount" name="amount" class="form-control" 
                                   step="0.01" min="0" required>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="add_quantity" class="form-label">Quantity</label>
                            <input type="number" id="add_quantity" name="quantity" class="form-control" 
                                   step="0.1" min="0" value="1">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="add_unit_price" class="form-label">Unit Price (Auto)</label>
                            <input type="number" id="add_unit_price" class="form-control" 
                                   step="0.01" readonly tabindex="-1">
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="add_segment_id" class="form-label">Business Segment</label>
                            <select id="add_segment_id" name="segment_id" class="form-control">
                                <option value="">Select Segment</option>
                                <?php foreach ($businessSegments as $segment): ?>
                                    <option value="<?php echo $segment['id']; ?>">
                                        <?php echo htmlspecialchars($segment['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="add_category_id" class="form-label">Category</label>
                            <select id="add_category_id" name="category_id" class="form-control">
                                <option value="">Select Category</option>
                                <?php foreach ($revenueCategories as $category): ?>
                                    <option value="<?php echo $category['id']; ?>">
                                        <?php echo htmlspecialchars($category['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="add_customer_name" class="form-label">Customer Name</label>
                            <input type="text" id="add_customer_name" name="customer_name" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="add_customer_phone" class="form-label">Customer Phone</label>
                            <input type="tel" id="add_customer_phone" name="customer_phone" class="form-control" data-validate="phone">
                        </div>
                    </div>
                </div>

                <div class="form-group">
                    <label for="add_description" class="form-label">Description</label>
                    <textarea id="add_description" name="description" class="form-control" rows="3"></textarea>
                </div>

                <div class="form-group">
                    <label for="add_receipt_image" class="form-label">Receipt/Image (Optional)</label>
                    <input type="file" id="add_receipt_image" name="receipt_image" class="form-control" 
                           accept="image/*,.pdf">
                    <small class="text-muted">Max 5MB. Supported formats: JPG, PNG, PDF</small>
                </div>
            </form>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-outline" onclick="closeModal('addSaleModal')">Cancel</button>
            <button type="submit" form="addSaleForm" class="btn btn-primary">
                <i class="fas fa-save"></i> Record Sale
            </button>
        </div>
    </div>
</div>

<!-- Edit Sale Modal -->
<div class="modal" id="editSaleModal">
    <div class="modal-content modal-lg">
        <div class="modal-header">
            <h3 class="modal-title">Edit Sale</h3>
            <button class="modal-close" onclick="closeModal('editSaleModal')">&times;</button>
        </div>
        <div class="modal-body">
            <form id="editSaleForm" method="POST" data-validate>
                <input type="hidden" name="action" value="update_sale">
                <input type="hidden" name="sale_id" id="edit_sale_id">
                
                <div class="row">
                    <div class="col-md-8">
                        <div class="form-group">
                            <label for="edit_title" class="form-label">Product/Service Title <span class="text-danger">*</span></label>
                            <input type="text" id="edit_title" name="title" class="form-control" required>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="edit_sale_date" class="form-label">Sale Date <span class="text-danger">*</span></label>
                            <input type="date" id="edit_sale_date" name="sale_date" class="form-control" required>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="edit_amount" class="form-label">Total Amount <span class="text-danger">*</span></label>
                            <input type="number" id="edit_amount" name="amount" class="form-control" 
                                   step="0.01" min="0" required>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="edit_quantity" class="form-label">Quantity</label>
                            <input type="number" id="edit_quantity" name="quantity" class="form-control" 
                                   step="0.1" min="0">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="edit_unit_price" class="form-label">Unit Price (Auto)</label>
                            <input type="number" id="edit_unit_price" class="form-control" 
                                   step="0.01" readonly tabindex="-1">
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="edit_segment_id" class="form-label">Business Segment</label>
                            <select id="edit_segment_id" name="segment_id" class="form-control">
                                <option value="">Select Segment</option>
                                <?php foreach ($businessSegments as $segment): ?>
                                    <option value="<?php echo $segment['id']; ?>">
                                        <?php echo htmlspecialchars($segment['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="edit_category_id" class="form-label">Category</label>
                            <select id="edit_category_id" name="category_id" class="form-control">
                                <option value="">Select Category</option>
                                <?php foreach ($revenueCategories as $category): ?>
                                    <option value="<?php echo $category['id']; ?>">
                                        <?php echo htmlspecialchars($category['name']); ?>
                                    </option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="edit_customer_name" class="form-label">Customer Name</label>
                            <input type="text" id="edit_customer_name" name="customer_name" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="edit_customer_phone" class="form-label">Customer Phone</label>
                            <input type="tel" id="edit_customer_phone" name="customer_phone" class="form-control" data-validate="phone">
                        </div>
                    </div>
                </div>

                <div class="form-group">
                    <label for="edit_description" class="form-label">Description</label>
                    <textarea id="edit_description" name="description" class="form-control" rows="3"></textarea>
                </div>
            </form>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-outline" onclick="closeModal('editSaleModal')">Cancel</button>
            <button type="submit" form="editSaleForm" class="btn btn-primary">
                <i class="fas fa-save"></i> Update Sale
            </button>
        </div>
    </div>
</div>

<!-- View Sale Modal -->
<div class="modal" id="viewSaleModal">
    <div class="modal-content">
        <div class="modal-header">
            <h3 class="modal-title">Sale Details</h3>
            <button class="modal-close" onclick="closeModal('viewSaleModal')">&times;</button>
        </div>
        <div class="modal-body">
            <div id="saleDetailsContent">
                <!-- Content will be populated by JavaScript -->
            </div>
        </div>
        <div class="modal-footer">
            <button type="button" class="btn btn-outline" onclick="closeModal('viewSaleModal')">Close</button>
        </div>
    </div>
</div>

<script>
// Sales management functions
function showAddSaleModal() {
    document.getElementById('addSaleForm').reset();
    document.getElementById('add_sale_date').value = new Date().toISOString().split('T')[0];
    calculateUnitPrice('add');
    openModal('addSaleModal');
}

function editSale(sale) {
    document.getElementById('edit_sale_id').value = sale.id;
    document.getElementById('edit_title').value = sale.title;
    document.getElementById('edit_amount').value = sale.amount;
    document.getElementById('edit_quantity').value = sale.quantity;
    document.getElementById('edit_sale_date').value = sale.sale_date;
    document.getElementById('edit_segment_id').value = sale.segment_id || '';
    document.getElementById('edit_category_id').value = sale.category_id || '';
    document.getElementById('edit_customer_name').value = sale.customer_name || '';
    document.getElementById('edit_customer_phone').value = sale.customer_phone || '';
    document.getElementById('edit_description').value = sale.description || '';
    
    calculateUnitPrice('edit');
    openModal('editSaleModal');
}

function viewSale(sale) {
    const content = `
        <div class="sale-details">
            <div class="row mb-3">
                <div class="col-6">
                    <strong>Invoice Number:</strong><br>
                    <span class="invoice-badge">${sale.invoice_number}</span>
                </div>
                <div class="col-6">
                    <strong>Sale Date:</strong><br>
                    ${formatDate(sale.sale_date)}
                </div>
            </div>
            
            <div class="row mb-3">
                <div class="col-12">
                    <strong>Product/Service:</strong><br>
                    <span class="sale-title-large">${sale.title}</span>
                </div>
            </div>
            
            <div class="row mb-3">
                <div class="col-4">
                    <strong>Amount:</strong><br>
                    <span class="amount-large">${formatCurrency(sale.amount)}</span>
                </div>
                <div class="col-4">
                    <strong>Quantity:</strong><br>
                    ${sale.quantity}
                </div>
                <div class="col-4">
                    <strong>Unit Price:</strong><br>
                    ${formatCurrency(sale.unit_price)}
                </div>
            </div>
            
            ${sale.customer_name ? `
            <div class="row mb-3">
                <div class="col-6">
                    <strong>Customer:</strong><br>
                    ${sale.customer_name}
                </div>
                <div class="col-6">
                    <strong>Phone:</strong><br>
                    ${sale.customer_phone || '-'}
                </div>
            </div>
            ` : ''}
            
            <div class="row mb-3">
                <div class="col-6">
                    <strong>Segment:</strong><br>
                    ${sale.segment_name || 'Not specified'}
                </div>
                <div class="col-6">
                    <strong>Category:</strong><br>
                    ${sale.category_name || 'Not specified'}
                </div>
            </div>
            
            ${sale.description ? `
            <div class="row mb-3">
                <div class="col-12">
                    <strong>Description:</strong><br>
                    ${sale.description}
                </div>
            </div>
            ` : ''}
            
            <div class="row">
                <div class="col-12">
                    <strong>Created:</strong><br>
                    ${formatDateTime(sale.created_at)} by ${sale.created_by_name}
                </div>
            </div>
        </div>
    `;
    
    document.getElementById('saleDetailsContent').innerHTML = content;
    openModal('viewSaleModal');
}

function deleteSale(saleId, title) {
    if (confirm(`Are you sure you want to delete the sale "${title}"?\n\nThis action cannot be undone.`)) {
        const form = document.createElement('form');
        form.method = 'POST';
        form.style.display = 'none';
        
        const actionInput = document.createElement('input');
        actionInput.type = 'hidden';
        actionInput.name = 'action';
        actionInput.value = 'delete_sale';
        
        const saleIdInput = document.createElement('input');
        saleIdInput.type = 'hidden';
        saleIdInput.name = 'sale_id';
        saleIdInput.value = saleId;
        
        form.appendChild(actionInput);
        form.appendChild(saleIdInput);
        document.body.appendChild(form);
        form.submit();
    }
}

function calculateUnitPrice(prefix) {
    const amountField = document.getElementById(prefix + '_amount');
    const quantityField = document.getElementById(prefix + '_quantity');
    const unitPriceField = document.getElementById(prefix + '_unit_price');
    
    function updateUnitPrice() {
        const amount = parseFloat(amountField.value) || 0;
        const quantity = parseFloat(quantityField.value) || 1;
        const unitPrice = quantity > 0 ? amount / quantity : 0;
        unitPriceField.value = unitPrice.toFixed(2);
    }
    
    amountField.addEventListener('input', updateUnitPrice);
    quantityField.addEventListener('input', updateUnitPrice);
    
    updateUnitPrice();
}

function exportSales() {
    const params = new URLSearchParams(window.location.search);
    params.set('export', 'csv');
    
    window.location.href = 'export_sales.php?' + params.toString();
}

function openModal(modalId) {
    document.getElementById(modalId).classList.add('active');
    document.body.style.overflow = 'hidden';
}

function closeModal(modalId) {
    document.getElementById(modalId).classList.remove('active');
    document.body.style.overflow = '';
}

// Utility functions
function formatDate(dateString) {
    return new Date(dateString).toLocaleDateString('en-IN', {
        year: 'numeric',
        month: 'short',
        day: 'numeric'
    });
}

function formatDateTime(dateString) {
    return new Date(dateString).toLocaleDateString('en-IN', {
        year: 'numeric',
        month: 'short',
        day: 'numeric',
        hour: 'numeric',
        minute: '2-digit'
    });
}

function formatCurrency(amount) {
    return new Intl.NumberFormat('en-IN', {
        style: 'currency',
        currency: 'INR',
        minimumFractionDigits: 2
    }).format(amount);
}

// Initialize unit price calculations for modals
document.addEventListener('DOMContentLoaded', function() {
    calculateUnitPrice('add');
    calculateUnitPrice('edit');
});
</script>

<style>
/* Sales page specific styles */
.sales-container {
    animation: fadeIn 0.6s ease;
}

.sale-info {
    min-width: 0;
}

.sale-title {
    font-weight: 600;
    color: var(--primary-navy);
    margin-bottom: var(--space-xs);
}

.sale-meta {
    display: flex;
    gap: var(--space-sm);
    align-items: center;
    flex-wrap: wrap;
    margin-bottom: var(--space-xs);
}

.invoice-number {
    font-family: monospace;
    font-size: var(--font-size-xs);
    color: var(--gray);
    background: var(--light-gray);
    padding: 2px 6px;
    border-radius: 3px;
}

.segment-badge {
    font-size: var(--font-size-xs);
    background: var(--primary-yellow);
    color: var(--primary-navy);
    padding: 2px 6px;
    border-radius: 3px;
    font-weight: 500;
}

.customer-info {
    min-width: 0;
}

.customer-name {
    font-weight: 500;
    color: var(--primary-navy);
    margin-bottom: var(--space-xs);
}

.customer-phone {
    font-size: var(--font-size-sm);
    color: var(--gray);
    display: flex;
    align-items: center;
    gap: var(--space-xs);
}

.amount-info {
    text-align: right;
}

.sale-amount {
    font-weight: 600;
    color: var(--success);
    font-size: var(--font-size-lg);
}

.unit-price {
    color: var(--gray);
    font-size: var(--font-size-xs);
}

.date-info {
    text-align: center;
}

.sale-date {
    font-weight: 500;
    color: var(--primary-navy);
}

.created-time {
    color: var(--gray);
    font-size: var(--font-size-xs);
}

.filters-form {
    margin: 0;
}

.filter-actions {
    display: flex;
    gap: var(--space-sm);
    flex-wrap: wrap;
    align-items: center;
}

.modal-lg {
    max-width: 800px;
}

.sale-details {
    background: var(--light-gray);
    padding: var(--space-lg);
    border-radius: var(--border-radius);
}

.invoice-badge {
    font-family: monospace;
    background: var(--primary-navy);
    color: var(--white);
    padding: var(--space-sm) var(--space-md);
    border-radius: var(--border-radius);
    font-weight: 600;
}

.sale-title-large {
    font-size: var(--font-size-lg);
    font-weight: 600;
    color: var(--primary-navy);
}

.amount-large {
    font-size: 1.5rem;
    font-weight: 700;
    color: var(--success);
}

@media (max-width: 768px) {
    .filter-actions {
        margin-top: var(--space-md);
    }
    
    .filter-actions .btn {
        flex: 1;
        min-width: 120px;
    }
    
    .amount-info {
        text-align: left;
    }
    
    .date-info {
        text-align: left;
    }
    
    .modal-lg {
        max-width: 95%;
    }
    
    .sale-details {
        padding: var(--space-md);
    }
}
</style>

<?php include '../includes/footer.php'; ?>