import { useState, useEffect, useRef } from 'react' import { Button } from "/components/ui/button" import { Card, CardContent, CardHeader, CardTitle } from "/components/ui/card" import { Download, Upload } from 'lucide-react' declare global { interface Window { Papa: any } } export default function CSVComparatorFinal() { const [file1, setFile1] = useState<{name: string; data: any[]} | null>(null) const [file2, setFile2] = useState<{name: string; data: Set} | null>(null) const [progress1, setProgress1] = useState(0) const [progress2, setProgress2] = useState(0) const [result, setResult] = useState<{ status: 'idle' | 'loading' | 'success' | 'error' message: string stats?: string }>({ status: 'idle', message: '' }) const [isButtonDisabled, setIsButtonDisabled] = useState(true) const file1Ref = useRef(null) const file2Ref = useRef(null) useEffect(() => { // Load PapaParse from CDN const script = document.createElement('script') script.src = 'https://cdn.jsdelivr.net/npm/papaparse@5.4.1/papaparse.min.js' script.async = true document.body.appendChild(script) return () => { document.body.removeChild(script) } }, []) useEffect(() => { setIsButtonDisabled(!(file1 && file2)) }, [file1, file2]) const parseFile = ( file: File, onComplete: (data: any[]) => void, setProgress: (value: number) => void ) => { if (!window.Papa) { setResult({ status: 'error', message: 'PapaParse non caricato' }) return } // Simulate progress since we can't use workers const progressInterval = setInterval(() => { setProgress(prev => Math.min(prev + 10, 90)) }, 200) window.Papa.parse(file, { header: false, skipEmptyLines: true, transform: (value: string) => value.trim(), complete: (results: { data: any[] }) => { clearInterval(progressInterval) setProgress(100) onComplete(results.data) }, error: (err: Error) => { clearInterval(progressInterval) setResult({ status: 'error', message: `Errore durante il parsing: ${err.message}` }) } }) } const handleFile1Change = (e: React.ChangeEvent) => { const file = e.target.files?.[0] if (!file) { setFile1(null) setProgress1(0) return } setResult({ status: 'idle', message: '' }) setProgress1(0) parseFile( file, (data) => setFile1({ name: file.name, data }), setProgress1 ) } const handleFile2Change = (e: React.ChangeEvent) => { const file = e.target.files?.[0] if (!file) { setFile2(null) setProgress2(0) return } setResult({ status: 'idle', message: '' }) setProgress2(0) parseFile( file, (data) => { const dataSet = new Set() data.forEach(row => row[0] && dataSet.add(row[0])) setFile2({ name: file.name, data: dataSet }) }, setProgress2 ) } const compareAndDownload = () => { if (!file1 || !file2) return setResult({ status: 'loading', message: 'Elaborazione...' }) // Use setTimeout to allow UI to update before heavy computation setTimeout(() => { try { const unique = file1.data.filter(row => typeof row[0] !== 'undefined' && !file2.data.has(row[0]) ) const resultData = unique.map(row => [row[0], row[1] ?? '']) if (resultData.length === 0) { setResult({ status: 'error', message: 'Nessuna riga unica trovata.', stats: `Tot: ${file1.data.length}, Eliminate: ${file2.data.size}` }) return } const csv = window.Papa.unparse(resultData, { quotes: true }) const blob = new Blob([csv], { type: 'text/csv;charset=utf-8' }) const url = URL.createObjectURL(blob) const a = document.createElement('a') a.href = url a.download = 'differenza.csv' a.click() URL.revokeObjectURL(url) setResult({ status: 'success', message: 'Successo!', stats: `Tot: ${file1.data.length}, Eliminate: ${file2.data.size}, Uniche: ${resultData.length}` }) } catch (error) { setResult({ status: 'error', message: 'Errore durante il confronto' }) console.error('Errore:', error) } }, 50) } const getStatusClass = () => { switch (result.status) { case 'success': return 'bg-green-100 border-green-400 text-green-700' case 'error': return 'bg-red-100 border-red-400 text-red-700' case 'loading': return 'bg-blue-100 border-blue-400 text-blue-700' default: return '' } } return (

Strumento Confronto CSV

File Principale

{file1 && ( {file1.name} )}

File da Sottrarre

{file2 && ( {file2.name} )}

{result.status !== 'idle' && (

{result.status === 'loading' && (

)} {result.message}

{result.stats && (

)}

Strumento realizzato da Dynamic-Web Srls

) }