-- =============================================================================
-- ASA PLATFORM - LOCAL DEVELOPMENT SEED (DEV ONLY)
-- =============================================================================
-- ⚠️  DO NOT IMPORT THIS FILE ON cPanel / PRODUCTION.
--     It contains demo accounts and a known (dev-only) password.
--     It is mounted automatically by docker-compose for local convenience.
-- =============================================================================
-- Dev admin login:
--   Email    : admin@asa.local
--   Password : Local@Dev123
-- Demo provider login (mobile API):
--   Email    : rakoto.electricite@gmail.com
--   Password : Local@Dev123
-- =============================================================================

SET NAMES utf8mb4;

-- Dev admin (and a moderator) for the backoffice
INSERT INTO `users` (`id`, `email`, `password_hash`, `role`, `full_name`, `phone`, `address`, `is_active`)
VALUES
(1, 'admin@asa.local', '$2y$12$Wyvakk4KVodsFnd24smOfe5zkg9z7Igewfb1uB8vc62u7kabgd7Vm', 'ADMIN', 'Administrateur Local (DEV)', '+261 34 00 000 01', 'Antananarivo 101, Madagascar', 1),
(3, 'moderateur@asa.local', '$2y$12$Wyvakk4KVodsFnd24smOfe5zkg9z7Igewfb1uB8vc62u7kabgd7Vm', 'MODERATOR', 'Modérateur Local (DEV)', '+261 34 00 000 03', 'Antananarivo 101, Madagascar', 1)
ON DUPLICATE KEY UPDATE `password_hash` = VALUES(`password_hash`), `role` = VALUES(`role`), `full_name` = VALUES(`full_name`), `is_active` = 1;

-- Demo provider awaiting KYC (shares the dev password)
INSERT INTO `users` (`id`, `email`, `password_hash`, `role`, `full_name`, `phone`, `address`, `is_active`)
VALUES
(4, 'rakoto.electricite@gmail.com', '$2y$12$Wyvakk4KVodsFnd24smOfe5zkg9z7Igewfb1uB8vc62u7kabgd7Vm', 'PROVIDER', 'Rakoto Jean (Plombier & Électricien)', '+261 34 11 222 33', 'Lot IV B 24 Ankadifotsy, Antananarivo', 1)
ON DUPLICATE KEY UPDATE `password_hash` = VALUES(`password_hash`), `role` = VALUES(`role`), `full_name` = VALUES(`full_name`), `is_active` = 1;

INSERT INTO `provider_profiles` (`id`, `user_id`, `category_id`, `bio`, `address`, `id_card_number`, `rate_ariary`, `kyc_status`, `kyc_document_url`, `kyc_notes`)
VALUES
(1, 4, 1, 'Artisan électricien & plombier expérimenté avec 8 ans d\'expérience dans les chantiers et dépannages urgents à Antananarivo.', 'Lot IV B 24 Ankadifotsy, Antananarivo 101', 'CIN-101-203-405-607', 25000, 'PENDING', '/uploads/cin_sample.pdf', 'Dossier complet, en attente de validation cockpit')
ON DUPLICATE KEY UPDATE `user_id` = VALUES(`user_id`), `rate_ariary` = VALUES(`rate_ariary`);

-- Demo interview slots (moderator_id = 3, the dev moderator above)
INSERT INTO `interview_slots` (`id`, `moderator_id`, `start_time`, `end_time`, `is_available`)
VALUES
(1, 3, DATE_ADD(NOW(), INTERVAL 1 DAY), DATE_ADD(DATE_ADD(NOW(), INTERVAL 1 DAY), INTERVAL 45 MINUTE), 1),
(2, 3, DATE_ADD(NOW(), INTERVAL 2 DAY), DATE_ADD(DATE_ADD(NOW(), INTERVAL 2 DAY), INTERVAL 45 MINUTE), 1),
(3, 3, DATE_ADD(NOW(), INTERVAL 3 DAY), DATE_ADD(DATE_ADD(NOW(), INTERVAL 3 DAY), INTERVAL 45 MINUTE), 1),
(4, 3, DATE_ADD(NOW(), INTERVAL 4 DAY), DATE_ADD(DATE_ADD(NOW(), INTERVAL 4 DAY), INTERVAL 45 MINUTE), 1)
ON DUPLICATE KEY UPDATE `moderator_id` = VALUES(`moderator_id`);