set('memberId', String(v || '').toUpperCase())}
error={errors.memberId}
placeholder="e.g. NW-001234 or SIL-000507"
hint="Type the number printed on the plastic card. This becomes the permanent member ID."
/>
F&B discount{Math.round(suggestedPct * 100)}% off (suggested)
YTD F&B saved{fmtNPR(member.spend.discount || 0)}
)}
{/* Step 2 */}
{ setDiscountAmt(v); setDiscountTouched(true); }}
placeholder="0"
hint="Type the actual NPR amount. The tier % is just a suggestion."
/>
{discountTouched && member && (
↳ {mode === 'hall' ? 'Hall bookings (3 × 4 hrs each) are a Wellness-tier benefit.' : 'Spa passes (5 per year) are a Wellness-tier benefit.'} Silver members are not eligible.
);
}
// ═══════════════════════════════════════════════════════════════
// CSV IMPORT (existing members)
// ═══════════════════════════════════════════════════════════════
function parseCSV(text) {
// Simple CSV parser: handles quoted fields with commas.
const rows = []; let cur = []; let field = ''; let inQ = false;
for (let i = 0; i < text.length; i++) {
const c = text[i];
if (inQ) {
if (c === '"' && text[i+1] === '"') { field += '"'; i++; }
else if (c === '"') inQ = false;
else field += c;
} else {
if (c === '"') inQ = true;
else if (c === ',') { cur.push(field); field = ''; }
else if (c === '\n' || c === '\r') {
if (field || cur.length) { cur.push(field); rows.push(cur); cur = []; field = ''; }
if (c === '\r' && text[i+1] === '\n') i++;
} else field += c;
}
}
if (field || cur.length) { cur.push(field); rows.push(cur); }
return rows.filter(r => r.length && r.some(x => x.trim()));
}
function CsvImportModal({ open, onClose, onDone }) {
const [text, setText] = React.useState('');
const [preview, setPreview] = React.useState([]);
const [errors, setErrors] = React.useState([]);
const fileRef = React.useRef(null);
function loadFile(file) {
if (!file) return;
const r = new FileReader();
r.onload = () => { setText(String(r.result || '')); };
r.readAsText(file);
}
React.useEffect(() => {
if (!text) { setPreview([]); setErrors([]); return; }
const rows = parseCSV(text);
if (rows.length < 2) { setPreview([]); setErrors(['Need a header row + at least one data row.']); return; }
const header = rows[0].map(h => h.trim().toLowerCase());
const need = ['name', 'phone', 'type'];
const missing = need.filter(n => !header.includes(n));
if (missing.length) { setErrors([`Missing columns: ${missing.join(', ')}`]); setPreview([]); return; }
const idx = (k) => header.indexOf(k);
const items = rows.slice(1).map((r, i) => {
const row = (k) => (idx(k) >= 0 ? (r[idx(k)] || '').trim() : '');
const type = row('type').toLowerCase() === 'wellness' ? 'wellness' : 'silver';
return {
_line: i + 2,
type,
name: row('name'),
phone: row('phone'),
email: row('email'),
gender: row('gender'),
dob: row('dob'),
anniversary: row('anniversary'),
address: row('address'),
property: ['Biratchowk', 'Damak'].includes(row('property')) ? row('property') : 'Biratchowk',
cardNumber: row('card') || row('cardnumber') || row('card_number') || '',
startDate: row('startdate') || row('start_date') || new Date().toISOString().slice(0, 10),
paymentAmount: Number(row('payment') || row('payment_amount') || 0),
};
});
setPreview(items);
const errs = items.filter(x => !x.name || !x.phone).map(x => `Line ${x._line}: name + phone required`);
setErrors(errs);
}, [text]);
function doImport() {
let ok = 0, fail = 0;
preview.forEach(item => {
try { Store.addMember(item); ok++; } catch (e) { fail++; }
});
onDone(ok, fail);
onClose();
}
if (!open) return null;
return (
}>
Upload a CSV with these columns: name, phone, type, email, gender, dob, anniversary, address, property, cardNumber, startDate, paymentAmount.
Only name, phone, type are required. type must be wellness or silver.
{ const f = e.target.files && e.target.files[0]; e.target.value = ''; if (f) loadFile(f); }} />
)}