-- SpesaMIA — DATI DIMOSTRATIVI (fittizi). Da importare in phpMyAdmin DOPO schema.sql,
-- dentro il database già selezionato. Tutte le righe hanno is_demo = 1 e l'app le etichetta «DEMO».
-- Reimportabile: cancella prima i soli dati demo precedenti.
-- Per rimuoverli quando arrivano i dati reali: esegui il blocco «RIMOZIONE» in fondo al file.

DELETE FROM prices   WHERE is_demo = 1;
DELETE FROM products WHERE is_demo = 1;
DELETE FROM stores   WHERE is_demo = 1;
DELETE FROM chains   WHERE is_demo = 1;
DELETE FROM sources  WHERE is_demo = 1;

INSERT INTO sources (id, name, type, license_note, is_authorized, is_demo) VALUES (900001, 'DEMO — dati dimostrativi', 'manual', 'Dati fittizi di prova', 0, 1);
INSERT INTO chains (id, name, slug, is_demo) VALUES (900001, 'Supermercato DEMO Alfa', 'demo-supermercato-demo-alfa', 1);
INSERT INTO chains (id, name, slug, is_demo) VALUES (900002, 'Supermercato DEMO Beta', 'demo-supermercato-demo-beta', 1);
INSERT INTO chains (id, name, slug, is_demo) VALUES (900003, 'Supermercato DEMO Gamma', 'demo-supermercato-demo-gamma', 1);
INSERT INTO chains (id, name, slug, is_demo) VALUES (900004, 'Supermercato DEMO Delta', 'demo-supermercato-demo-delta', 1);
INSERT INTO stores (id, chain_id, name, address, city, province, lat, lng, is_demo) VALUES (900001, 900001, 'Alfa DEMO — Villafranca centro', 'Via Esempio 1 (indirizzo fittizio)', 'Villafranca Tirrena', 'ME', 38.243, 15.44, 1);
INSERT INTO stores (id, chain_id, name, address, city, province, lat, lng, is_demo) VALUES (900002, 900002, 'Beta DEMO — Villafranca', 'Via Esempio 2 (indirizzo fittizio)', 'Villafranca Tirrena', 'ME', 38.252, 15.435, 1);
INSERT INTO stores (id, chain_id, name, address, city, province, lat, lng, is_demo) VALUES (900003, 900003, 'Gamma DEMO — Messina nord', 'Via Esempio 3 (indirizzo fittizio)', 'Messina', 'ME', 38.265, 15.5, 1);
INSERT INTO stores (id, chain_id, name, address, city, province, lat, lng, is_demo) VALUES (900004, 900004, 'Delta DEMO — Milazzo', 'Via Esempio 4 (indirizzo fittizio)', 'Milazzo', 'ME', 38.22, 15.24, 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900001, '9990000000017', 'Latte intero UHT', 'Demo Latte', '1 l', 'l', 1.0, 'latte intero uht demo latte latte', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900002, '9990000000024', 'Latte intero UHT', 'Prima Demo', '1 l', 'l', 1.0, 'latte intero uht prima demo latte', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900003, '9990000000031', 'Spaghetti n.5', 'Pasta Demo', '500 g', 'kg', 0.5, 'spaghetti n 5 pasta demo pasta spaghetti', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900004, '9990000000048', 'Spaghetti n.5', 'Grano Demo', '1 kg', 'kg', 1.0, 'spaghetti n 5 grano demo pasta spaghetti', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900005, '9990000000055', 'Passata di pomodoro', 'Orto Demo', '700 g', 'kg', 0.7, 'passata di pomodoro orto demo passata pomodoro', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900006, '9990000000062', 'Uova fresche', 'Aia Demo', '6 uova', 'pz', 6.0, 'uova fresche aia demo uova', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900007, '9990000000079', 'Olio extravergine d''oliva', 'Frantoio Demo', '1 l', 'l', 1.0, 'olio extravergine d oliva frantoio demo olio olio evo', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900008, '9990000000086', 'Biscotti frollini', 'Forno Demo', '800 g', 'kg', 0.8, 'biscotti frollini forno demo biscotti', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900009, '9990000000093', 'Acqua minerale naturale', 'Fonte Demo', '6×1,5 l', 'l', 9.0, 'acqua minerale naturale fonte demo acqua', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900010, '9990000000109', 'Caffè macinato', 'Tazza Demo', '250 g', 'kg', 0.25, 'caffe macinato tazza demo caffe caffe', 1);
INSERT INTO products (id, ean, name, brand, size_label, base_unit, base_qty, search_text, is_demo) VALUES (900011, '9990000000116', 'Carta igienica', 'Soffice Demo', '8 rotoli', 'pz', 8.0, 'carta igienica soffice demo carta igienica', 1);
INSERT INTO prices (product_id, store_id, source_id, price, unit_price, is_promo, promo_label, valid_from, valid_to, observed_at, verified_status, is_demo) VALUES
(900001, 900001, 900001, 1.35, 1.35, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900001, 900002, 900001, 1.29, 1.29, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900001, 900003, 900001, 1.19, 1.19, 1, 'Offerta DEMO', DATE_ADD(CURDATE(), INTERVAL -1 DAY), DATE_ADD(CURDATE(), INTERVAL 7 DAY), NOW(), 'verified', 1),
(900001, 900004, 900001, 1.25, 1.25, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900002, 900001, 900001, 1.49, 1.49, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900002, 900002, 900001, 1.45, 1.45, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900002, 900003, 900001, 1.52, 1.52, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900003, 900001, 900001, 0.99, 1.98, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900003, 900002, 900001, 0.89, 1.78, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900003, 900003, 900001, 0.85, 1.7, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900003, 900004, 900001, 0.95, 1.9, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900004, 900001, 900001, 1.79, 1.79, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900004, 900002, 900001, 1.69, 1.69, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900004, 900003, 900001, 1.59, 1.59, 1, 'Offerta DEMO', DATE_ADD(CURDATE(), INTERVAL -1 DAY), DATE_ADD(CURDATE(), INTERVAL 10 DAY), NOW(), 'verified', 1),
(900005, 900001, 900001, 1.09, 1.557, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900005, 900002, 900001, 0.99, 1.414, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900005, 900003, 900001, 0.95, 1.357, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900006, 900001, 900001, 2.59, 0.432, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900006, 900002, 900001, 2.49, 0.415, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900006, 900004, 900001, 2.39, 0.398, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900007, 900001, 900001, 8.99, 8.99, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900007, 900002, 900001, 8.49, 8.49, 1, 'Offerta DEMO', DATE_ADD(CURDATE(), INTERVAL -1 DAY), DATE_ADD(CURDATE(), INTERVAL 5 DAY), NOW(), 'verified', 1),
(900007, 900003, 900001, 8.79, 8.79, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900008, 900001, 900001, 2.49, 3.113, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900008, 900002, 900001, 2.29, 2.862, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900008, 900003, 900001, 2.19, 2.737, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900009, 900001, 900001, 3.29, 0.366, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900009, 900002, 900001, 2.99, 0.332, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900009, 900003, 900001, 2.89, 0.321, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900009, 900004, 900001, 2.79, 0.31, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900010, 900001, 900001, 3.49, 13.96, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900010, 900002, 900001, 3.69, 14.76, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900010, 900003, 900001, 3.19, 12.76, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900011, 900001, 900001, 3.99, 0.499, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900011, 900002, 900001, 3.79, 0.474, 0, NULL, NULL, NULL, NOW(), 'verified', 1),
(900011, 900003, 900001, 3.59, 0.449, 1, 'Offerta DEMO', DATE_ADD(CURDATE(), INTERVAL -1 DAY), DATE_ADD(CURDATE(), INTERVAL 3 DAY), NOW(), 'verified', 1),
(900011, 900004, 900001, 2.99, 0.374, 1, 'Offerta DEMO scaduta', DATE_ADD(CURDATE(), INTERVAL -10 DAY), DATE_ADD(CURDATE(), INTERVAL -2 DAY), NOW(), 'verified', 1);

-- ===== RIMOZIONE (non eseguire ora): cancella solo i dati demo =====
-- DELETE FROM prices WHERE is_demo = 1;
-- DELETE FROM products WHERE is_demo = 1;
-- DELETE FROM stores WHERE is_demo = 1;
-- DELETE FROM chains WHERE is_demo = 1;
-- DELETE FROM sources WHERE is_demo = 1;