<?php
require_once 'config.php';
requireLogin();

$client_id = intval($_GET['id'] ?? 0);
if (!$client_id) {
    header('Location: clients.php');
    exit;
}

$page_title = 'Edit Client';
$page_description = 'Edit client information';

$success = '';
$error = '';

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    if ($_POST['action'] === 'update_client') {
        $company_name = trim($_POST['company_name'] ?? '');
        $industry = $_POST['industry'] ?? '';
        $contact_person = trim($_POST['contact_person'] ?? '');
        $email = trim($_POST['email'] ?? '');
        $phone = trim($_POST['phone'] ?? '');
        $address = trim($_POST['address'] ?? '');
        $city = trim($_POST['city'] ?? '');
        $country = $_POST['country'] ?? '';
        $postal_code = trim($_POST['postal_code'] ?? '');
        $website = trim($_POST['website'] ?? '');
        $notes = trim($_POST['notes'] ?? '');
        $status = $_POST['status'] ?? 'active';
        
        // Validation
        if (empty($company_name) || empty($contact_person) || empty($email) || empty($phone)) {
            $error = 'All required fields must be filled';
        } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
            $error = 'Invalid email address';
        } else {
            try {
                $pdo = getDBConnection();
                
                $stmt = $pdo->prepare("
                    UPDATE clients 
                    SET company_name = ?, industry = ?, contact_person = ?, email = ?, 
                        phone = ?, address = ?, city = ?, country = ?, postal_code = ?, 
                        website = ?, notes = ?, status = ?, updated_at = NOW()
                    WHERE id = ?
                ");
                
                $stmt->execute([
                    $company_name, $industry, $contact_person, $email, $phone,
                    $address, $city, $country, $postal_code, $website,
                    $notes, $status, $client_id
                ]);
                
                // Handle file uploads
                if (!empty($_FILES['attachments']['name'][0])) {
                    $upload_dir = 'uploads/clients/';
                    if (!file_exists($upload_dir)) {
                        mkdir($upload_dir, 0755, true);
                    }
                    
                    $allowed_types = ['application/pdf', 'image/jpeg', 'image/jpg', 'image/png', 'image/gif'];
                    $max_size = 5 * 1024 * 1024;
                    
                    // Get client code
                    $clientStmt = $pdo->prepare("SELECT client_code FROM clients WHERE id = ?");
                    $clientStmt->execute([$client_id]);
                    $client_code = $clientStmt->fetchColumn();
                    
                    for ($i = 0; $i < count($_FILES['attachments']['name']); $i++) {
                        if ($_FILES['attachments']['error'][$i] === UPLOAD_ERR_OK) {
                            $file_type = $_FILES['attachments']['type'][$i];
                            $file_size = $_FILES['attachments']['size'][$i];
                            
                            if (in_array($file_type, $allowed_types) && $file_size <= $max_size) {
                                $file_name = $_FILES['attachments']['name'][$i];
                                $file_tmp = $_FILES['attachments']['tmp_name'][$i];
                                $extension = pathinfo($file_name, PATHINFO_EXTENSION);
                                $unique_name = $client_code . '_' . time() . '_' . $i . '.' . $extension;
                                $file_path = $upload_dir . $unique_name;
                                
                                if (move_uploaded_file($file_tmp, $file_path)) {
                                    $attachStmt = $pdo->prepare("
                                        INSERT INTO client_attachments 
                                        (client_id, file_name, file_path, file_type, file_size, uploaded_at)
                                        VALUES (?, ?, ?, ?, ?, NOW())
                                    ");
                                    $attachStmt->execute([$client_id, $file_name, $file_path, $file_type, $file_size]);
                                }
                            }
                        }
                    }
                }
                
                logActivity($_SESSION['admin_id'], 'update_client', "Updated client #$client_id", 'client', $client_id);
                
                $success = 'Client updated successfully!';
            } catch (Exception $e) {
                $error = 'An error occurred. Please try again.';
                error_log("Update client error: " . $e->getMessage());
            }
        }
    }
    
    // Handle attachment deletion - SEPARATE ACTION
    if ($_POST['action'] === 'delete_attachment') {
        $attach_id = intval($_POST['attachment_id'] ?? 0);
        if ($attach_id) {
            try {
                $pdo = getDBConnection();
                $stmt = $pdo->prepare("SELECT * FROM client_attachments WHERE id = ? AND client_id = ?");
                $stmt->execute([$attach_id, $client_id]);
                $attach = $stmt->fetch();
                
                if ($attach) {
                    if (file_exists($attach['file_path'])) {
                        unlink($attach['file_path']);
                    }
                    $stmt = $pdo->prepare("DELETE FROM client_attachments WHERE id = ?");
                    $stmt->execute([$attach_id]);
                    $success = 'Attachment deleted successfully!';
                }
            } catch (Exception $e) {
                $error = 'Error deleting attachment.';
            }
        }
    }
}

// Fetch client details
try {
    $pdo = getDBConnection();
    $stmt = $pdo->prepare("SELECT * FROM clients WHERE id = ?");
    $stmt->execute([$client_id]);
    $client = $stmt->fetch();
    
    if (!$client) {
        header('Location: clients.php');
        exit;
    }
    
    // Fetch attachments
    $attachStmt = $pdo->prepare("SELECT * FROM client_attachments WHERE client_id = ?");
    $attachStmt->execute([$client_id]);
    $attachments = $attachStmt->fetchAll();
    
} catch (Exception $e) {
    error_log("Fetch client error: " . $e->getMessage());
    header('Location: clients.php');
    exit;
}

$industries = [
    'Technology', 'Healthcare', 'Finance', 'Retail', 'Manufacturing',
    'Education', 'Real Estate', 'Hospitality', 'Consulting',
    'Marketing', 'Construction', 'Transportation', 'Other'
];

$countries = [
    'India', 'United States', 'United Kingdom', 'Canada', 'Australia',
    'Germany', 'France', 'Japan', 'China', 'Singapore',
    'United Arab Emirates', 'Saudi Arabia', 'Malaysia', 'Thailand', 'Indonesia',
    'Philippines', 'Vietnam', 'South Korea', 'Hong Kong', 'Taiwan',
    'Bangladesh', 'Pakistan', 'Sri Lanka', 'Nepal', 'Bhutan',
    'Afghanistan', 'Maldives', 'Myanmar', 'Cambodia', 'Laos',
    'Other'
];

include 'includes/header.php';
?>

<div class="page-container">
    <div class="page-header">
        <div>
            <h1>Edit Client</h1>
            <p class="page-subtitle">Update client information for <?php echo htmlspecialchars($client['client_code']); ?></p>
        </div>
        <div class="header-actions">
            <a href="client_view.php?id=<?php echo $client_id; ?>" class="btn btn-secondary">
                <span>👁️</span> View Details
            </a>
            <a href="clients.php" class="btn btn-secondary">
                <span>←</span> Back to List
            </a>
        </div>
    </div>

    <?php if ($success): ?>
        <div class="success-message">
            <span class="message-icon">✅</span>
            <?php echo htmlspecialchars($success); ?>
        </div>
    <?php endif; ?>
    
    <?php if ($error): ?>
        <div class="error-message">
            <span class="message-icon">⚠️</span>
            <?php echo htmlspecialchars($error); ?>
        </div>
    <?php endif; ?>

    <!-- EXISTING ATTACHMENTS - OUTSIDE MAIN FORM TO AVOID NESTING -->
    <?php if (!empty($attachments)): ?>
    <div style="background: white; padding: 24px; border-radius: 12px; box-shadow: 0 1px 3px rgba(0,0,0,0.1); margin-bottom: 24px;">
        <h3 style="margin: 0 0 16px 0; font-size: 18px; font-weight: 600;">📎 Existing Documents (<?php echo count($attachments); ?>)</h3>
        <?php foreach ($attachments as $attachment): ?>
        <div style="display: flex; justify-content: space-between; align-items: center; padding: 12px; background: #f9fafb; border-radius: 6px; margin-bottom: 8px; border: 1px solid #e5e7eb;">
            <div>
                <strong><?php echo htmlspecialchars($attachment['file_name']); ?></strong>
                <small style="display:block;color:#6b7280;font-size:12px;">
                    <?php echo number_format($attachment['file_size'] / 1024, 2); ?> KB
                </small>
            </div>
            <!-- SEPARATE FORM - NOT NESTED -->
            <form method="POST" style="display:inline; margin:0;" onsubmit="return confirm('Delete this attachment?');">
                <input type="hidden" name="action" value="delete_attachment">
                <input type="hidden" name="attachment_id" value="<?php echo $attachment['id']; ?>">
                <button type="submit" class="btn btn-secondary" style="padding: 6px 12px; font-size: 12px; background: #fee2e2; color: #991b1b;">
                    🗑️ Delete
                </button>
            </form>
        </div>
        <?php endforeach; ?>
    </div>
    <?php endif; ?>

    <!-- MAIN UPDATE FORM - NO NESTED FORMS INSIDE -->
    <div style="background: white; padding: 32px; border-radius: 12px; box-shadow: 0 1px 3px rgba(0,0,0,0.1);">
        <form method="POST" enctype="multipart/form-data">
            <input type="hidden" name="action" value="update_client">
            
            <div class="form-row">
                <div class="form-group">
                    <label for="company_name">Company Name <span style="color:#dc2626;">*</span></label>
                    <input type="text" id="company_name" name="company_name" required 
                           value="<?php echo htmlspecialchars($client['company_name']); ?>">
                </div>
                
                <div class="form-group">
                    <label for="industry">Industry <span style="color:#dc2626;">*</span></label>
                    <select id="industry" name="industry" required>
                        <option value="">Select Industry</option>
                        <?php foreach ($industries as $ind): ?>
                            <option value="<?php echo $ind; ?>" <?php echo $client['industry'] === $ind ? 'selected' : ''; ?>>
                                <?php echo $ind; ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
            </div>
            
            <div class="form-row">
                <div class="form-group">
                    <label for="contact_person">Contact Person <span style="color:#dc2626;">*</span></label>
                    <input type="text" id="contact_person" name="contact_person" required 
                           value="<?php echo htmlspecialchars($client['contact_person']); ?>">
                </div>
                
                <div class="form-group">
                    <label for="email">Email Address <span style="color:#dc2626;">*</span></label>
                    <input type="email" id="email" name="email" required 
                           value="<?php echo htmlspecialchars($client['email']); ?>">
                </div>
            </div>
            
            <div class="form-row">
                <div class="form-group">
                    <label for="phone">Phone Number (with country code) <span style="color:#dc2626;">*</span></label>
                    <input type="tel" id="phone" name="phone" required 
                           value="<?php echo htmlspecialchars($client['phone']); ?>"
                           placeholder="+91 9876543210 or +1 2025551234">
                    <small style="color:#6b7280;font-size:12px;margin-top:4px;display:block;">Include country code (e.g., +91 for India, +1 for USA)</small>
                </div>
                
                <div class="form-group">
                    <label for="website">Website</label>
                    <input type="url" id="website" name="website" 
                           value="<?php echo htmlspecialchars($client['website'] ?? ''); ?>"
                           placeholder="https://example.com">
                </div>
            </div>
            
            <div class="form-row">
                <div class="form-group" style="grid-column: 1 / -1;">
                    <label for="address">Address</label>
                    <textarea id="address" name="address" placeholder="Full company address"><?php echo htmlspecialchars($client['address'] ?? ''); ?></textarea>
                </div>
            </div>
            
            <div class="form-row">
                <div class="form-group">
                    <label for="city">City</label>
                    <input type="text" id="city" name="city" 
                           value="<?php echo htmlspecialchars($client['city'] ?? ''); ?>"
                           placeholder="Enter city name">
                </div>
                
                <div class="form-group">
                    <label for="country">Country</label>
                    <select id="country" name="country">
                        <option value="">Select Country</option>
                        <?php foreach ($countries as $ctry): ?>
                            <option value="<?php echo $ctry; ?>" <?php echo $client['country'] === $ctry ? 'selected' : ''; ?>>
                                <?php echo $ctry; ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </div>
            </div>
            
            <div class="form-row">
                <div class="form-group">
                    <label for="postal_code">Postal/ZIP Code</label>
                    <input type="text" id="postal_code" name="postal_code" 
                           value="<?php echo htmlspecialchars($client['postal_code'] ?? ''); ?>"
                           placeholder="Postal or ZIP code">
                </div>
                
                <div class="form-group">
                    <label for="status">Status</label>
                    <select id="status" name="status">
                        <option value="active" <?php echo $client['status'] === 'active' ? 'selected' : ''; ?>>Active</option>
                        <option value="inactive" <?php echo $client['status'] === 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                        <option value="suspended" <?php echo $client['status'] === 'suspended' ? 'selected' : ''; ?>>Suspended</option>
                    </select>
                </div>
            </div>
            
            <div class="form-row">
                <div class="form-group" style="grid-column: 1 / -1;">
                    <label for="notes">Notes</label>
                    <textarea id="notes" name="notes" placeholder="Additional client information"><?php echo htmlspecialchars($client['notes'] ?? ''); ?></textarea>
                </div>
            </div>
            
            <!-- NEW FILE UPLOADS - INSIDE MAIN FORM -->
            <div style="margin: 24px 0;">
                <label style="font-weight: 600; color: #374151; margin-bottom: 12px; display: block;">
                    📎 Upload Additional Documents (Optional)
                </label>
                <input type="file" name="attachments[]" multiple accept=".pdf,.jpg,.jpeg,.png,.gif" 
                       style="padding: 12px; border: 2px solid #e5e7eb; border-radius: 8px; width: 100%;">
                <small style="color: #6b7280; display: block; margin-top: 8px;">
                    PDF, JPG, PNG, GIF (Max 5MB per file)
                </small>
            </div>
            
            <div class="form-actions" style="margin-top: 24px;">
                <button type="submit" class="btn btn-primary">
                    <span>💾</span> Update Client
                </button>
            </div>
        </form>
    </div>
</div>

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