<?php
/**
 * Investments and Loans Management Page for Kayal Aqua
 * Manage business investments, loans, and financing
 */

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

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

$pageTitle = 'Investments & Loans';
$breadcrumb = [
    ['title' => 'Investments & Loans']
];

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

// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    try {
        $action = $_POST['action'] ?? '';
        
        switch ($action) {
            case 'add_investment':
                $type = sanitizeInput($_POST['type']);
                $title = sanitizeInput($_POST['title']);
                $amount = (float)$_POST['amount'];
                $interestRate = (float)($_POST['interest_rate'] ?? 0);
                $startDate = $_POST['start_date'];
                $endDate = $_POST['end_date'] ?? null;
                $segmentId = !empty($_POST['segment_id']) ? (int)$_POST['segment_id'] : null;
                $description = sanitizeInput($_POST['description'] ?? '');
                $lender = sanitizeInput($_POST['lender'] ?? '');
                $tenure = (int)($_POST['tenure'] ?? 0);
                
                // Validation
                if (empty($type) || empty($title) || $amount <= 0 || empty($startDate)) {
                    throw new Exception('Type, title, amount, and start date are required.');
                }
                
                if (!in_array($type, ['investment', 'loan'])) {
                    throw new Exception('Invalid investment type.');
                }
                
                if ($interestRate < 0 || $interestRate > 100) {
                    throw new Exception('Interest rate must be between 0 and 100.');
                }
                
                // Calculate EMI for loans
                $emi = 0;
                if ($type === 'loan' && $tenure > 0 && $interestRate > 0) {
                    $emi = calculateEMI($amount, $interestRate, $tenure);
                }
                
                $investmentData = [
                    'type' => $type,
                    'title' => $title,
                    'amount' => $amount,
                    'interest_rate' => $interestRate,
                    'start_date' => $startDate,
                    'end_date' => $endDate,
                    'segment_id' => $segmentId,
                    'description' => $description,
                    'lender' => $lender,
                    'tenure_months' => $tenure,
                    'emi_amount' => $emi,
                    'status' => 'active',
                    'created_by' => $currentUser['id'],
                    'created_at' => date('Y-m-d H:i:s')
                ];
                
                $investmentId = insertData('investments', $investmentData);
                
                if ($investmentId) {
                    logSystemActivity('Add ' . ucfirst($type), "Added {$type}: {$title} - " . formatIndianCurrency($amount));
                    $success = ucfirst($type) . ' recorded successfully!';
                } else {
                    throw new Exception('Failed to record ' . $type . '.');
                }
                break;
                
            case 'update_investment':
                $investmentId = (int)$_POST['investment_id'];
                $type = sanitizeInput($_POST['type']);
                $title = sanitizeInput($_POST['title']);
                $amount = (float)$_POST['amount'];
                $interestRate = (float)($_POST['interest_rate'] ?? 0);
                $startDate = $_POST['start_date'];
                $endDate = $_POST['end_date'] ?? null;
                $segmentId = !empty($_POST['segment_id']) ? (int)$_POST['segment_id'] : null;
                $description = sanitizeInput($_POST['description'] ?? '');
                $lender = sanitizeInput($_POST['lender'] ?? '');
                $tenure = (int)($_POST['tenure'] ?? 0);
                $status = sanitizeInput($_POST['status']);
                
                // Validation
                if (empty($title) || $amount <= 0 || empty($startDate)) {
                    throw new Exception('Title, amount, and start date are required.');
                }
                
                if (!in_array($status, ['active', 'completed', 'cancelled'])) {
                    throw new Exception('Invalid status.');
                }
                
                // Check if user can edit this investment
                $existingInvestment = fetchRow("SELECT * FROM investments WHERE id = ?", [$investmentId]);
                if (!$existingInvestment) {
                    throw new Exception('Investment/Loan not found.');
                }
                
                if ($currentUser['role'] !== 'admin' && $existingInvestment['created_by'] != $currentUser['id']) {
                    throw new Exception('You can only edit your own records.');
                }
                
                // Recalculate EMI if loan parameters changed
                $emi = $existingInvestment['emi_amount'];
                if ($type === 'loan' && $tenure > 0 && $interestRate > 0) {
                    if ($amount != $existingInvestment['amount'] || 
                        $interestRate != $existingInvestment['interest_rate'] || 
                        $tenure != $existingInvestment['tenure_months']) {
                        $emi = calculateEMI($amount, $interestRate, $tenure);
                    }
                }
                
                $updateData = [
                    'title' => $title,
                    'amount' => $amount,
                    'interest_rate' => $interestRate,
                    'start_date' => $startDate,
                    'end_date' => $endDate,
                    'segment_id' => $segmentId,
                    'description' => $description,
                    'lender' => $lender,
                    'tenure_months' => $tenure,
                    'emi_amount' => $emi,
                    'status' => $status
                ];
                
                updateData('investments', $updateData, 'id = ?', [$investmentId]);
                
                logSystemActivity('Update ' . ucfirst($type), "Updated {$type} ID: {$investmentId}");
                $success = ucfirst($type) . ' updated successfully!';
                break;
                
            case 'delete_investment':
                $investmentId = (int)$_POST['investment_id'];
                
                // Check if user can delete this investment
                $existingInvestment = fetchRow("SELECT * FROM investments WHERE id = ?", [$investmentId]);
                if (!$existingInvestment) {
                    throw new Exception('Investment/Loan not found.');
                }
                
                if ($currentUser['role'] !== 'admin' && $existingInvestment['created_by'] != $currentUser['id']) {
                    throw new Exception('You can only delete your own records.');
                }
                
                executeQuery("DELETE FROM investments WHERE id = ?", [$investmentId]);
                
                logSystemActivity('Delete ' . ucfirst($existingInvestment['type']), "Deleted {$existingInvestment['type']}: {$existingInvestment['title']}");
                $success = ucfirst($existingInvestment['type']) . ' deleted successfully!';
                break;
        }
    } catch (Exception $e) {
        $error = $e->getMessage();
    }
}

// Get filter parameters
$typeFilter = $_GET['type'] ?? '';
$statusFilter = $_GET['status'] ?? '';
$segmentFilter = $_GET['segment'] ?? '';
$search = $_GET['search'] ?? '';

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

// Type filter
if ($typeFilter) {
    $whereConditions[] = "i.type = ?";
    $params[] = $typeFilter;
}

// Status filter
if ($statusFilter) {
    $whereConditions[] = "i.status = ?";
    $params[] = $statusFilter;
}

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

// Search filter
if ($search) {
    $whereConditions[] = "(i.title LIKE ? OR i.lender LIKE ? OR i.description LIKE ?)";
    $params[] = "%$search%";
    $params[] = "%$search%";
    $params[] = "%$search%";
}

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

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

// Get investments with related data
$investmentsQuery = "
    SELECT i.*, 
           bs.name as segment_name,
           u.full_name as created_by_name
    FROM investments i
    LEFT JOIN business_segments bs ON i.segment_id = bs.id
    LEFT JOIN users u ON i.created_by = u.id
    {$whereClause}
    ORDER BY i.start_date DESC, i.created_at DESC
";

$investments = fetchAll($investmentsQuery, $params);

// Calculate totals and statistics
$totalInvestments = 0;
$totalLoans = 0;
$totalEMI = 0;
$activeCount = 0;

foreach ($investments as $investment) {
    if ($investment['type'] === 'investment') {
        $totalInvestments += $investment['amount'];
    } else {
        $totalLoans += $investment['amount'];
        if ($investment['status'] === 'active') {
            $totalEMI += $investment['emi_amount'];
        }
    }
    
    if ($investment['status'] === 'active') {
        $activeCount++;
    }
}

// Get data for dropdowns
$businessSegments = getBusinessSegments();

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

<div class="investments-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-piggy-bank"></i>
                    Investments & Loans
                </h1>
                <p class="page-description">
                    Manage your business investments, loans, and financing options.
                </p>
            </div>
            <div class="page-actions">
                <div class="dropdown">
                    <button class="btn btn-primary dropdown-toggle" data-bs-toggle="dropdown">
                        <i class="fas fa-plus"></i>
                        <span class="desktop-only">Add New</span>
                    </button>
                    <ul class="dropdown-menu">
                        <li>
                            <a class="dropdown-item" href="#" onclick="showAddModal('investment')">
                                <i class="fas fa-chart-line"></i> Investment
                            </a>
                        </li>
                        <li>
                            <a class="dropdown-item" href="#" onclick="showAddModal('loan')">
                                <i class="fas fa-hand-holding-usd"></i> Loan
                            </a>
                        </li>
                    </ul>
                </div>
            </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; ?>

    <!-- Investment Statistics -->
    <div class="stats-section mb-4">
        <div class="row">
            <div class="col-lg-3 col-md-6 mb-3">
                <div class="stat-card investment-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($totalInvestments); ?></div>
                        <div class="stat-label">Total Investments</div>
                    </div>
                </div>
            </div>
            <div class="col-lg-3 col-md-6 mb-3">
                <div class="stat-card loan-card">
                    <div class="stat-icon bg-warning">
                        <i class="fas fa-hand-holding-usd"></i>
                    </div>
                    <div class="stat-content">
                        <div class="stat-value"><?php echo formatIndianCurrency($totalLoans); ?></div>
                        <div class="stat-label">Total Loans</div>
                    </div>
                </div>
            </div>
            <div class="col-lg-3 col-md-6 mb-3">
                <div class="stat-card emi-card">
                    <div class="stat-icon bg-danger">
                        <i class="fas fa-calendar-alt"></i>
                    </div>
                    <div class="stat-content">
                        <div class="stat-value"><?php echo formatIndianCurrency($totalEMI); ?></div>
                        <div class="stat-label">Monthly EMI</div>
                    </div>
                </div>
            </div>
            <div class="col-lg-3 col-md-6 mb-3">
                <div class="stat-card active-card">
                    <div class="stat-icon bg-info">
                        <i class="fas fa-check-circle"></i>
                    </div>
                    <div class="stat-content">
                        <div class="stat-value"><?php echo $activeCount; ?></div>
                        <div class="stat-label">Active Records</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="type" class="form-label">Type</label>
                        <select id="type" name="type" class="form-control">
                            <option value="">All Types</option>
                            <option value="investment" <?php echo $typeFilter === 'investment' ? 'selected' : ''; ?>>Investments</option>
                            <option value="loan" <?php echo $typeFilter === 'loan' ? 'selected' : ''; ?>>Loans</option>
                        </select>
                    </div>
                    <div class="col-md-3 mb-3">
                        <label for="status" class="form-label">Status</label>
                        <select id="status" name="status" class="form-control">
                            <option value="">All Status</option>
                            <option value="active" <?php echo $statusFilter === 'active' ? 'selected' : ''; ?>>Active</option>
                            <option value="completed" <?php echo $statusFilter === 'completed' ? 'selected' : ''; ?>>Completed</option>
                            <option value="cancelled" <?php echo $statusFilter === 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                        </select>
                    </div>
                    <div class="col-md-3 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-3 mb-3">
                        <label for="search" class="form-label">Search</label>
                        <input type="text" id="search" name="search" class="form-control" 
                               placeholder="Title, lender..." 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="investments.php" class="btn btn-outline">
                        <i class="fas fa-times"></i> Clear
                    </a>
                    <button type="button" class="btn btn-success" onclick="exportInvestments()">
                        <i class="fas fa-download"></i> Export
                    </button>
                </div>
            </form>
        </div>
    </div>

    <!-- Investments List -->
    <div class="card">
        <div class="card-header">
            <h5 class="card-title">
                <i class="fas fa-list"></i>
                Investment & Loan Records
            </h5>
            <div class="card-subtitle">
                Showing <?php echo count($investments); ?> records
            </div>
        </div>
        <div class="card-body">
            <?php if (empty($investments)): ?>
                <div class="empty-state text-center py-5">
                    <i class="fas fa-piggy-bank fa-4x text-muted mb-3"></i>
                    <h5>No Records Found</h5>
                    <p class="text-muted">
                        <?php if ($search || $typeFilter || $statusFilter || $segmentFilter): ?>
                            Try adjusting your filters or search criteria.
                        <?php else: ?>
                            Start by adding your first investment or loan record.
                        <?php endif; ?>
                    </p>
                    <div class="empty-state-actions">
                        <button class="btn btn-primary" onclick="showAddModal('investment')">
                            <i class="fas fa-chart-line"></i> Add Investment
                        </button>
                        <button class="btn btn-outline" onclick="showAddModal('loan')">
                            <i class="fas fa-hand-holding-usd"></i> Add Loan
                        </button>
                    </div>
                </div>
            <?php else: ?>
                <div class="investments-grid">
                    <?php foreach ($investments as $investment): ?>
                        <div class="investment-card <?php echo $investment['type']; ?>-item" data-investment-id="<?php echo $investment['id']; ?>">
                            <div class="investment-header">
                                <div class="investment-type">
                                    <span class="type-badge <?php echo $investment['type']; ?>-badge">
                                        <i class="fas fa-<?php echo $investment['type'] === 'investment' ? 'chart-line' : 'hand-holding-usd'; ?>"></i>
                                        <?php echo ucfirst($investment['type']); ?>
                                    </span>
                                    <span class="status-badge status-<?php echo $investment['status']; ?>">
                                        <?php echo ucfirst($investment['status']); ?>
                                    </span>
                                </div>
                                <div class="investment-actions">
                                    <div class="dropdown">
                                        <button class="btn btn-sm btn-outline dropdown-toggle" data-bs-toggle="dropdown">
                                            <i class="fas fa-ellipsis-v"></i>
                                        </button>
                                        <ul class="dropdown-menu">
                                            <li>
                                                <a class="dropdown-item" href="#" onclick="viewInvestment(<?php echo htmlspecialchars(json_encode($investment)); ?>)">
                                                    <i class="fas fa-eye"></i> View Details
                                                </a>
                                            </li>
                                            <?php if ($currentUser['role'] === 'admin' || $investment['created_by'] == $currentUser['id']): ?>
                                                <li>
                                                    <a class="dropdown-item" href="#" onclick="editInvestment(<?php echo htmlspecialchars(json_encode($investment)); ?>)">
                                                        <i class="fas fa-edit"></i> Edit
                                                    </a>
                                                </li>
                                                <li><div class="dropdown-divider"></div></li>
                                                <li>
                                                    <a class="dropdown-item text-danger" href="#" onclick="deleteInvestment(<?php echo $investment['id']; ?>, '<?php echo htmlspecialchars($investment['title']); ?>')">
                                                        <i class="fas fa-trash"></i> Delete
                                                    </a>
                                                </li>
                                            <?php endif; ?>
                                        </ul>
                                    </div>
                                </div>
                            </div>
                            
                            <div class="investment-body">
                                <h6 class="investment-title"><?php echo htmlspecialchars($investment['title']); ?></h6>
                                
                                <div class="investment-amount">
                                    <?php echo formatIndianCurrency($investment['amount']); ?>
                                </div>
                                
                                <div class="investment-details">
                                    <div class="detail-row">
                                        <span class="detail-label">
                                            <i class="fas fa-percentage"></i>
                                            Interest Rate:
                                        </span>
                                        <span class="detail-value"><?php echo $investment['interest_rate']; ?>%</span>
                                    </div>
                                    
                                    <?php if ($investment['type'] === 'loan' && $investment['emi_amount'] > 0): ?>
                                        <div class="detail-row">
                                            <span class="detail-label">
                                                <i class="fas fa-calendar-alt"></i>
                                                Monthly EMI:
                                            </span>
                                            <span class="detail-value text-danger">
                                                <?php echo formatIndianCurrency($investment['emi_amount']); ?>
                                            </span>
                                        </div>
                                    <?php endif; ?>
                                    
                                    <div class="detail-row">
                                        <span class="detail-label">
                                            <i class="fas fa-calendar"></i>
                                            Start Date:
                                        </span>
                                        <span class="detail-value"><?php echo formatDate($investment['start_date']); ?></span>
                                    </div>
                                    
                                    <?php if ($investment['end_date']): ?>
                                        <div class="detail-row">
                                            <span class="detail-label">
                                                <i class="fas fa-calendar-check"></i>
                                                End Date:
                                            </span>
                                            <span class="detail-value"><?php echo formatDate($investment['end_date']); ?></span>
                                        </div>
                                    <?php endif; ?>
                                    
                                    <?php if ($investment['lender']): ?>
                                        <div class="detail-row">
                                            <span class="detail-label">
                                                <i class="fas fa-university"></i>
                                                Lender/Bank:
                                            </span>
                                            <span class="detail-value"><?php echo htmlspecialchars($investment['lender']); ?></span>
                                        </div>
                                    <?php endif; ?>
                                    
                                    <?php if ($investment['segment_name']): ?>
                                        <div class="detail-row">
                                            <span class="detail-label">
                                                <i class="fas fa-layer-group"></i>
                                                Segment:
                                            </span>
                                            <span class="detail-value"><?php echo htmlspecialchars($investment['segment_name']); ?></span>
                                        </div>
                                    <?php endif; ?>
                                </div>
                                
                                <?php if ($investment['description']): ?>
                                    <div class="investment-description">
                                        <p><?php echo htmlspecialchars($investment['description']); ?></p>
                                    </div>
                                <?php endif; ?>
                            </div>
                            
                            <div class="investment-footer">
                                <small class="text-muted">
                                    Created by <?php echo htmlspecialchars($investment['created_by_name']); ?>
                                    on <?php echo formatDate($investment['created_at']); ?>
                                </small>
                            </div>
                        </div>
                    <?php endforeach; ?>
                </div>
            <?php endif; ?>
        </div>
    </div>
</div>

<!-- Add/Edit Investment Modal -->
<div class="modal" id="investmentModal">
    <div class="modal-content modal-lg">
        <div class="modal-header">
            <h3 class="modal-title" id="modalTitle">Add Investment</h3>
            <button class="modal-close" onclick="closeModal('investmentModal')">&times;</button>
        </div>
        <div class="modal-body">
            <form id="investmentForm" method="POST" data-validate>
                <input type="hidden" name="action" id="formAction" value="add_investment">
                <input type="hidden" name="investment_id" id="investment_id">
                <input type="hidden" name="type" id="investment_type">
                
                <div class="row">
                    <div class="col-md-8">
                        <div class="form-group">
                            <label for="title" class="form-label">Title/Description <span class="text-danger">*</span></label>
                            <input type="text" id="title" name="title" class="form-control" required>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="amount" class="form-label">Amount <span class="text-danger">*</span></label>
                            <input type="number" id="amount" name="amount" class="form-control" 
                                   step="0.01" min="0" required>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="interest_rate" class="form-label">Interest Rate (%)</label>
                            <input type="number" id="interest_rate" name="interest_rate" class="form-control" 
                                   step="0.01" min="0" max="100" value="0">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="start_date" class="form-label">Start Date <span class="text-danger">*</span></label>
                            <input type="date" id="start_date" name="start_date" class="form-control" 
                                   value="<?php echo date('Y-m-d'); ?>" required>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label for="end_date" class="form-label">End Date</label>
                            <input type="date" id="end_date" name="end_date" class="form-control">
                        </div>
                    </div>
                </div>

                <!-- Loan specific fields -->
                <div id="loanFields" style="display: none;">
                    <div class="row">
                        <div class="col-md-6">
                            <div class="form-group">
                                <label for="tenure" class="form-label">Tenure (Months)</label>
                                <input type="number" id="tenure" name="tenure" class="form-control" 
                                       min="1" max="600">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <label for="emi_display" class="form-label">Calculated EMI</label>
                                <input type="text" id="emi_display" class="form-control" readonly 
                                       placeholder="Will be calculated automatically">
                            </div>
                        </div>
                    </div>
                </div>

                <div class="row">
                    <div class="col-md-6">
                        <div class="form-group">
                            <label for="segment_id" class="form-label">Business Segment</label>
                            <select id="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="lender" class="form-label">Lender/Bank/Source</label>
                            <input type="text" id="lender" name="lender" class="form-control" 
                                   placeholder="e.g., State Bank of India">
                        </div>
                    </div>
                </div>

                <div class="form-group" id="statusGroup" style="display: none;">
                    <label for="status" class="form-label">Status</label>
                    <select id="status" name="status" class="form-control">
                        <option value="active">Active</option>
                        <option value="completed">Completed</option>
                        <option value="cancelled">Cancelled</option>
                    </select>
                </div>

                <div class="form-group">
                    <label for="description" class="form-label">Additional Notes</label>
                    <textarea id="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('investmentModal')">Cancel</button>
            <button type="submit" form="investmentForm" class="btn btn-primary" id="submitBtn">
                <i class="fas fa-save"></i> Save
            </button>
        </div>
    </div>
</div>

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

<script>
// Investment management functions
function showAddModal(type) {
    document.getElementById('investmentForm').reset();
    document.getElementById('formAction').value = 'add_investment';
    document.getElementById('investment_type').value = type;
    document.getElementById('modalTitle').textContent = 'Add ' + (type.charAt(0).toUpperCase() + type.slice(1));
    document.getElementById('submitBtn').innerHTML = '<i class="fas fa-save"></i> Save ' + (type.charAt(0).toUpperCase() + type.slice(1));
    document.getElementById('start_date').value = new Date().toISOString().split('T')[0];
    
    // Show/hide loan specific fields
    const loanFields = document.getElementById('loanFields');
    const statusGroup = document.getElementById('statusGroup');
    
    if (type === 'loan') {
        loanFields.style.display = 'block';
        setupEMICalculation();
    } else {
        loanFields.style.display = 'none';
    }
    
    statusGroup.style.display = 'none';
    openModal('investmentModal');
}

function editInvestment(investment) {
    document.getElementById('formAction').value = 'update_investment';
    document.getElementById('investment_id').value = investment.id;
    document.getElementById('investment_type').value = investment.type;
    document.getElementById('modalTitle').textContent = 'Edit ' + (investment.type.charAt(0).toUpperCase() + investment.type.slice(1));
    document.getElementById('submitBtn').innerHTML = '<i class="fas fa-save"></i> Update ' + (investment.type.charAt(0).toUpperCase() + investment.type.slice(1));
    
    // Populate form fields
    document.getElementById('title').value = investment.title;
    document.getElementById('amount').value = investment.amount;
    document.getElementById('interest_rate').value = investment.interest_rate || 0;
    document.getElementById('start_date').value = investment.start_date;
    document.getElementById('end_date').value = investment.end_date || '';
    document.getElementById('segment_id').value = investment.segment_id || '';
    document.getElementById('lender').value = investment.lender || '';
    document.getElementById('description').value = investment.description || '';
    document.getElementById('status').value = investment.status;
    
    // Show/hide loan specific fields
    const loanFields = document.getElementById('loanFields');
    const statusGroup = document.getElementById('statusGroup');
    
    if (investment.type === 'loan') {
        loanFields.style.display = 'block';
        document.getElementById('tenure').value = investment.tenure_months || '';
        document.getElementById('emi_display').value = investment.emi_amount > 0 ? formatCurrency(investment.emi_amount) : '';
        setupEMICalculation();
    } else {
        loanFields.style.display = 'none';
    }
    
    statusGroup.style.display = 'block';
    openModal('investmentModal');
}

function viewInvestment(investment) {
    const content = `
        <div class="investment-details-view">
            <div class="detail-header">
                <div class="detail-type">
                    <span class="type-badge ${investment.type}-badge">
                        <i class="fas fa-${investment.type === 'investment' ? 'chart-line' : 'hand-holding-usd'}"></i>
                        ${investment.type.charAt(0).toUpperCase() + investment.type.slice(1)}
                    </span>
                    <span class="status-badge status-${investment.status}">
                        ${investment.status.charAt(0).toUpperCase() + investment.status.slice(1)}
                    </span>
                </div>
                <div class="detail-title">${investment.title}</div>
                <div class="detail-amount">${formatCurrency(investment.amount)}</div>
            </div>
            
            <div class="detail-body">
                <div class="row">
                    <div class="col-6">
                        <strong>Interest Rate:</strong><br>
                        ${investment.interest_rate}%
                    </div>
                    <div class="col-6">
                        <strong>Start Date:</strong><br>
                        ${formatDate(investment.start_date)}
                    </div>
                </div>
                
                ${investment.end_date ? `
                <div class="row mt-3">
                    <div class="col-6">
                        <strong>End Date:</strong><br>
                        ${formatDate(investment.end_date)}
                    </div>
                    ${investment.tenure_months ? `
                    <div class="col-6">
                        <strong>Tenure:</strong><br>
                        ${investment.tenure_months} months
                    </div>
                    ` : ''}
                </div>
                ` : ''}
                
                ${investment.emi_amount > 0 ? `
                <div class="row mt-3">
                    <div class="col-12">
                        <strong>Monthly EMI:</strong><br>
                        <span class="text-danger h5">${formatCurrency(investment.emi_amount)}</span>
                    </div>
                </div>
                ` : ''}
                
                ${investment.lender ? `
                <div class="row mt-3">
                    <div class="col-12">
                        <strong>Lender/Bank:</strong><br>
                        ${investment.lender}
                    </div>
                </div>
                ` : ''}
                
                ${investment.segment_name ? `
                <div class="row mt-3">
                    <div class="col-12">
                        <strong>Business Segment:</strong><br>
                        ${investment.segment_name}
                    </div>
                </div>
                ` : ''}
                
                ${investment.description ? `
                <div class="row mt-3">
                    <div class="col-12">
                        <strong>Description:</strong><br>
                        ${investment.description}
                    </div>
                </div>
                ` : ''}
                
                <div class="row mt-3">
                    <div class="col-12">
                        <strong>Created:</strong><br>
                        ${formatDateTime(investment.created_at)} by ${investment.created_by_name}
                    </div>
                </div>
            </div>
        </div>
    `;
    
    document.getElementById('investmentDetailsContent').innerHTML = content;
    openModal('viewInvestmentModal');
}

function deleteInvestment(investmentId, title) {
    if (confirm(`Are you sure you want to delete "${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_investment';
        
        const idInput = document.createElement('input');
        idInput.type = 'hidden';
        idInput.name = 'investment_id';
        idInput.value = investmentId;
        
        form.appendChild(actionInput);
        form.appendChild(idInput);
        document.body.appendChild(form);
        form.submit();
    }
}

function setupEMICalculation() {
    const amountField = document.getElementById('amount');
    const interestField = document.getElementById('interest_rate');
    const tenureField = document.getElementById('tenure');
    const emiDisplay = document.getElementById('emi_display');
    
    function calculateEMI() {
        const amount = parseFloat(amountField.value) || 0;
        const rate = parseFloat(interestField.value) || 0;
        const tenure = parseInt(tenureField.value) || 0;
        
        if (amount > 0 && rate > 0 && tenure > 0) {
            const monthlyRate = rate / (12 * 100);
            const emi = (amount * monthlyRate * Math.pow(1 + monthlyRate, tenure)) / (Math.pow(1 + monthlyRate, tenure) - 1);
            emiDisplay.value = formatCurrency(emi);
        } else {
            emiDisplay.value = '';
        }
    }
    
    amountField.addEventListener('input', calculateEMI);
    interestField.addEventListener('input', calculateEMI);
    tenureField.addEventListener('input', calculateEMI);
    
    calculateEMI();
}

function exportInvestments() {
    const params = new URLSearchParams(window.location.search);
    params.set('export', 'csv');
    
    window.location.href = 'export_investments.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);
}
</script>

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

.investments-grid {
    display: grid;
    grid-template-columns: repeat(auto-fill, minmax(350px, 1fr));
    gap: var(--space-lg);
    margin-top: var(--space-lg);
}

.investment-card {
    background: var(--white);
    border-radius: var(--border-radius-lg);
    box-shadow: var(--shadow-sm);
    border-left: 4px solid var(--primary-yellow);
    transition: all 0.3s ease;
    overflow: hidden;
}

.investment-card:hover {
    transform: translateY(-2px);
    box-shadow: var(--shadow-md);
}

.investment-card.loan-item {
    border-left-color: var(--warning);
}

.investment-header {
    padding: var(--space-lg) var(--space-lg) 0;
    display: flex;
    justify-content: space-between;
    align-items: flex-start;
}

.investment-type {
    display: flex;
    flex-direction: column;
    gap: var(--space-sm);
}

.type-badge {
    display: inline-flex;
    align-items: center;
    gap: var(--space-xs);
    padding: var(--space-xs) var(--space-sm);
    border-radius: var(--border-radius);
    font-size: var(--font-size-sm);
    font-weight: 500;
    text-transform: uppercase;
    letter-spacing: 0.5px;
}

.investment-badge {
    background: var(--success);
    color: var(--white);
}

.loan-badge {
    background: var(--warning);
    color: var(--primary-navy);
}

.status-badge {
    padding: 2px var(--space-xs);
    border-radius: var(--border-radius);
    font-size: var(--font-size-xs);
    font-weight: 500;
    text-transform: uppercase;
}

.status-active {
    background: var(--success);
    color: var(--white);
}

.status-completed {
    background: var(--info);
    color: var(--white);
}

.status-cancelled {
    background: var(--danger);
    color: var(--white);
}

.investment-body {
    padding: var(--space-lg);
}

.investment-title {
    color: var(--primary-navy);
    font-weight: 600;
    margin-bottom: var(--space-md);
    font-size: var(--font-size-lg);
}

.investment-amount {
    font-size: 1.5rem;
    font-weight: 700;
    color: var(--primary-navy);
    margin-bottom: var(--space-lg);
}

.investment-details {
    margin-bottom: var(--space-lg);
}

.detail-row {
    display: flex;
    justify-content: space-between;
    align-items: center;
    padding: var(--space-sm) 0;
    border-bottom: 1px solid var(--light-gray);
}

.detail-row:last-child {
    border-bottom: none;
}

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

.detail-value {
    font-weight: 500;
    color: var(--primary-navy);
    font-size: var(--font-size-sm);
}

.investment-description {
    background: var(--light-gray);
    padding: var(--space-md);
    border-radius: var(--border-radius);
    margin-bottom: var(--space-md);
}

.investment-description p {
    margin: 0;
    color: var(--gray);
    font-size: var(--font-size-sm);
}

.investment-footer {
    padding: var(--space-md) var(--space-lg);
    background: var(--light-gray);
    border-top: 1px solid #dee2e6;
}

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

.detail-header {
    text-align: center;
    margin-bottom: var(--space-xl);
    padding-bottom: var(--space-lg);
    border-bottom: 2px solid var(--primary-yellow);
}

.detail-title {
    font-size: var(--font-size-xl);
    font-weight: 600;
    color: var(--primary-navy);
    margin: var(--space-md) 0;
}

.detail-amount {
    font-size: 2rem;
    font-weight: 700;
    color: var(--primary-navy);
}

.detail-body .row {
    margin-bottom: var(--space-md);
}

.detail-body .row:last-child {
    margin-bottom: 0;
}

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

@media (max-width: 768px) {
    .investments-grid {
        grid-template-columns: 1fr;
        gap: var(--space-md);
    }
    
    .investment-card {
        margin-bottom: var(--space-md);
    }
    
    .investment-header {
        flex-direction: column;
        gap: var(--space-md);
    }
    
    .investment-type {
        flex-direction: row;
        flex-wrap: wrap;
    }
    
    .filter-actions {
        margin-top: var(--space-md);
    }
    
    .filter-actions .btn {
        flex: 1;
        min-width: 120px;
    }
    
    .page-actions .dropdown {
        width: 100%;
    }
    
    .page-actions .btn {
        width: 100%;
    }
}

@media (max-width: 576px) {
    .detail-row {
        flex-direction: column;
        align-items: flex-start;
        gap: var(--space-xs);
    }
    
    .detail-label,
    .detail-value {
        width: 100%;
    }
    
    .detail-value {
        font-weight: 600;
    }
}
</style>

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