@extends('layouts.app')

@section('title', 'Импорт соглашений')

@section('content')
<style>
.upload-area {
    border: 3px dashed #ccc;
    border-radius: 10px;
    padding: 40px 20px;
    text-align: center;
    margin: 20px 0;
    transition: all 0.3s;
    background-color: #fafafa;
    cursor: pointer;
}
.upload-area:hover, .upload-area.dragover {
    border-color: #28a745;
    background-color: #f0fff0;
}
.hidden { display: none; }
.status-message {
    padding: 10px;
    margin: 10px 0;
    border-radius: 5px;
    text-align: center;
}
.status-success { background-color: #d4edda; color: #155724; border: 1px solid #c3e6cb; }
.status-error { background-color: #f8d7da; color: #721c24; border: 1px solid #f5c6cb; }
.status-info { background-color: #d1ecf1; color: #0c5460; border: 1px solid #bee5eb; }
.preview-section { margin-top: 30px; }
.actions { margin-top: 20px; text-align: center; }
.btn { padding: 10px 20px; border: none; border-radius: 5px; cursor: pointer; font-size: 16px; margin: 5px; }
.btn-success { background-color: #28a745; color: white; }
.btn-danger { background-color: #dc3545; color: white; }
.btn-secondary { background-color: #6c757d; color: white; }
.table-responsive { overflow-x: auto; margin: 20px 0; max-height: 500px; overflow-y: auto; }
.data-table { width: 100%; border-collapse: collapse; }
.data-table th, .data-table td { padding: 8px 12px; border: 1px solid #ddd; text-align: left; font-size: 14px; }
.data-table th { background-color: #f2f2f2; font-weight: bold; position: sticky; top: 0; }
</style>

<h1>Импорт соглашений из Excel/CSV</h1>

<div class="alert alert-info">
    <strong>📌 Инструкция:</strong>
    <ul class="mb-0 mt-2">
        <li>Поддерживаемые форматы: <strong>.xls, .xlsx, .csv</strong></li>
        <li><strong>Обязательные поля:</strong> account_number (№ счета), agreement_type (тип), agreement_date (дата), total_amount (сумма)</li>
        <li><strong>Типы соглашений:</strong> deferment (отсрочка), installment (рассрочка), settlement (мировое), restructuring (реструктуризация)</li>
        <li><strong>Статусы:</strong> draft (черновик), active (активно), completed (выполнено), breached (нарушено)</li>
        <li><strong>Для банкротов:</strong> соглашения могут требовать особого оформления</li>
    </ul>
</div>

<div class="card mb-4">
    <div class="card-header bg-light">
        <h5 class="mb-0">Пример CSV файла</h5>
    </div>
    <div class="card-body">
        <pre style="background: #f8f9fa; padding: 10px; border-radius: 5px; font-size: 12px; overflow-x: auto;">
account_number;agreement_type;agreement_number;agreement_date;total_amount;initial_payment;start_date;end_date;status;responsible_person
100001;installment;С-001;2024-01-15;50000;10000;2024-02-01;2024-12-31;active;Иванов И.И.
100002;deferment;С-002;2024-02-20;30000;0;2024-03-01;2024-06-30;active;Петров П.П.
100003;settlement;С-003;2024-03-10;100000;50000;2024-04-01;2024-09-30;completed;Сидоров С.С.
        </pre>
    </div>
</div>

<div id="uploadSection">
    <div class="upload-area" id="uploadArea">
        <h3>Перетащите файл Excel/CSV сюда</h3>
        <p>или нажмите для выбора файла</p>
        <input type="file" id="fileInput" accept=".xls,.xlsx,.csv" class="hidden">
        <button class="btn btn-success" onclick="document.getElementById('fileInput').click()">Выбрать файл</button>
    </div>
    <div id="fileInfo" class="hidden"></div>
    <div class="actions">
        <button id="processBtn" class="btn btn-success" disabled onclick="processFile()">Обработать файл</button>
    </div>
</div>

<div id="previewSection" class="preview-section hidden">
    <h2>Предпросмотр данных</h2>
    <div id="previewTableContainer"></div>
    <div class="actions">
        <form method="POST" action="{{ route('agreements.import.process') }}" id="importForm">
            @csrf
            <input type="hidden" name="import_data" id="importData">
            <button type="submit" class="btn btn-success">Подтвердить импорт</button>
            <button type="button" class="btn btn-danger" onclick="cancelImport()">Отменить</button>
        </form>
    </div>
</div>
<div id="statusMessage" class="status-message hidden"></div>

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script>
let currentFile = null;
let importData = [];

const uploadArea = document.getElementById('uploadArea');
const fileInput = document.getElementById('fileInput');
const processBtn = document.getElementById('processBtn');
const uploadSection = document.getElementById('uploadSection');
const previewSection = document.getElementById('previewSection');
const previewTableContainer = document.getElementById('previewTableContainer');
const statusMessage = document.getElementById('statusMessage');
const importDataField = document.getElementById('importData');

uploadArea.addEventListener('dragover', (e) => { e.preventDefault(); uploadArea.classList.add('dragover'); });
uploadArea.addEventListener('dragleave', () => { uploadArea.classList.remove('dragover'); });
uploadArea.addEventListener('drop', (e) => {
    e.preventDefault();
    uploadArea.classList.remove('dragover');
    if (e.dataTransfer.files.length > 0) handleFileSelection(e.dataTransfer.files[0]);
});
fileInput.addEventListener('change', (e) => {
    if (e.target.files.length > 0) handleFileSelection(e.target.files[0]);
});

function handleFileSelection(file) {
    if (!file.name.endsWith('.xls') && !file.name.endsWith('.xlsx') && !file.name.endsWith('.csv')) {
        showStatus('Ошибка: выберите файл Excel или CSV', 'error');
        return;
    }
    currentFile = file;
    document.getElementById('fileInfo').innerHTML = `<strong>Выбран файл:</strong> ${file.name}`;
    document.getElementById('fileInfo').classList.remove('hidden');
    processBtn.disabled = false;
    showStatus('Файл загружен', 'info');
}

function cleanText(text) {
    if (!text) return '';
    if (text.charCodeAt(0) === 0xFEFF) text = text.slice(1);
    return text.toString().trim();
}

function parseCSV(text) {
    const lines = text.split(/\r\n|\n/);
    if (lines.length === 0) return [];
    const delimiter = lines[0].indexOf(';') !== -1 ? ';' : ',';
    
    function parseLine(line) {
        const result = [];
        let inQuotes = false;
        let current = '';
        for (let i = 0; i < line.length; i++) {
            if (line[i] === '"') { inQuotes = !inQuotes; }
            else if (line[i] === delimiter && !inQuotes) {
                result.push(cleanText(current));
                current = '';
            } else { current += line[i]; }
        }
        result.push(cleanText(current));
        return result;
    }
    
    const headers = parseLine(lines[0]).map(h => h.toLowerCase());
    const data = [];
    for (let i = 1; i < lines.length; i++) {
        if (!lines[i].trim()) continue;
        const values = parseLine(lines[i]);
        const row = {};
        headers.forEach((h, idx) => { row[h] = values[idx] || ''; });
        data.push(row);
    }
    return data;
}

function processFile() {
    if (!currentFile) return;
    showStatus('Обработка...', 'info');
    const reader = new FileReader();
    reader.onload = function(e) {
        try {
            let jsonData = [];
            if (currentFile.name.endsWith('.csv')) {
                jsonData = parseCSV(e.target.result);
            } else {
                const data = new Uint8Array(e.target.result);
                const workbook = XLSX.read(data, { type: 'array' });
                const sheet = workbook.Sheets[workbook.SheetNames[0]];
                jsonData = XLSX.utils.sheet_to_json(sheet);
            }
            
            importData = jsonData.map(row => ({
                account_number: cleanText(row.account_number || row['№ лицевого счета'] || row['счет'] || ''),
                agreement_type: cleanText(row.agreement_type || row['тип соглашения'] || 'installment'),
                agreement_number: cleanText(row.agreement_number || row['номер соглашения'] || ''),
                agreement_date: cleanText(row.agreement_date || row['дата соглашения'] || new Date().toISOString().split('T')[0]),
                total_amount: parseFloat(cleanText(row.total_amount || row['сумма'] || 0)),
                initial_payment: parseFloat(cleanText(row.initial_payment || row['первоначальный взнос'] || 0)),
                start_date: cleanText(row.start_date || row['дата начала'] || ''),
                end_date: cleanText(row.end_date || row['дата окончания'] || ''),
                terms_description: cleanText(row.terms_description || row['условия'] || ''),
                status: cleanText(row.status || row['статус'] || 'active'),
                responsible_person: cleanText(row.responsible_person || row['ответственный'] || ''),
                contact_phone: cleanText(row.contact_phone || row['телефон'] || ''),
                contact_email: cleanText(row.contact_email || row['email'] || ''),
                comments: cleanText(row.comments || row['комментарии'] || '')
            })).filter(item => item.account_number && item.agreement_date && item.total_amount > 0);
            
            if (importData.length === 0) throw new Error('Нет данных');
            
            let html = '<table class="data-table"><thead><tr><th>№ счета</th><th>Тип</th><th>Дата</th><th>Сумма</th><th>Статус</th></tr></thead><tbody>';
            importData.forEach(item => {
                html += `<tr>
                    <td>${escapeHtml(item.account_number)}</td>
                    <td>${item.agreement_type == 'deferment' ? 'Отсрочка' : (item.agreement_type == 'installment' ? 'Рассрочка' : (item.agreement_type == 'settlement' ? 'Мировое' : 'Реструктуризация'))}</td>
                    <td>${escapeHtml(item.agreement_date)}</td>
                    <td class="text-end">${item.total_amount.toFixed(2)} ₽</td>
                    <td>${item.status == 'active' ? 'Активно' : (item.status == 'completed' ? 'Выполнено' : (item.status == 'breached' ? 'Нарушено' : 'Черновик'))}</td>
                </tr>`;
            });
            html += '</tbody></table><p>Всего: ' + importData.length + '</p>';
            
            previewTableContainer.innerHTML = html;
            uploadSection.classList.add('hidden');
            previewSection.classList.remove('hidden');
            importDataField.value = JSON.stringify(importData);
            showStatus('Готово к импорту', 'success');
        } catch(e) { showStatus('Ошибка: ' + e.message, 'error'); }
    };
    currentFile.name.endsWith('.csv') ? reader.readAsText(currentFile, 'UTF-8') : reader.readAsArrayBuffer(currentFile);
}

function cancelImport() { location.reload(); }
function showStatus(msg, type) {
    statusMessage.textContent = msg;
    statusMessage.className = 'status-message status-' + type;
    statusMessage.classList.remove('hidden');
}
function escapeHtml(text) { if (!text) return ''; return String(text).replace(/[&<>]/g, function(m) { return m === '&' ? '&amp;' : (m === '<' ? '&lt;' : (m === '>' ? '&gt;' : m)); }); }
</script>
@endsection