
INSERT IGNORE INTO `roles` (`id`, `name`) VALUES (5, 'journal_manager'), (6, 'reader');

INSERT IGNORE INTO `user_roles` (`user_id`, `role_id`) VALUES 
(5, 4),
(5, 5),
(6, 4),
(6, 2),
(7, 4),
(7, 2),
(8, 4),
(8, 3),
(9, 4),
(9, 3),
(10, 4),
(10, 3),
(11, 4),
(11, 3),
(12, 4),
(12, 3),
(13, 4),
(14, 4),
(15, 4),
(16, 4),
(17, 4),
(18, 4),
(19, 4),
(20, 4),
(21, 4),
(21, 6),
(22, 4),
(22, 6),
(23, 4),
(23, 6),
(24, 4),
(24, 6),
(25, 4),
(25, 6);

INSERT INTO `journals` (`id`, `name`, `description`, `issn`, `e_issn`, `publisher`, `created_at`) VALUES
(1, 'Jurnal Konseling Kreatif dan Humanistik', 'Fokus pada inovasi dalam praktik konseling dan psikoterapi humanistik.', '1234-5678', '8765-4321', 'NexusPublisher', NOW()),
(2, 'Jurnal Psikologi Pendidikan Digital', 'Mengkaji aspek psikologis dalam ekosistem pendidikan digital dan edtech.', '1111-2222', '3333-4444', 'NexusPublisher', NOW()),
(3, 'Jurnal Karier dan Pengembangan Diri', 'Riset tentang jenjang karier, SDM, dan asesmen diri.', '5555-6666', '7777-8888', 'NexusPublisher', NOW());

INSERT INTO `submissions` (`id`, `journal_id`, `user_id`, `title`, `abstract`, `status`, `created_at`) VALUES 
(1, 1, 13, 'Pendekatan Art Therapy pada Remaja Introvert', 'Abstrak mengenai efek art therapy...', 'under_review', NOW() - INTERVAL 30 DAY),
(2, 1, 14, 'Teknik Jurnal Visual dalam Konseling Traumatik', 'Studi tentang penggunaan jurnal...', 'accepted', NOW() - INTERVAL 29 DAY),
(3, 1, 15, 'Efektivitas Konseling Peer-to-Peer di Sekolah Menengah', 'Peer counseling kesejahteraan siswa...', 'revision_required', NOW() - INTERVAL 28 DAY),
(4, 1, 16, 'Cognitive Behavioral Therapy via Chatbot', 'Pemanfaatan AI untuk CBT ringan...', 'published', NOW() - INTERVAL 27 DAY),
(5, 1, 17, 'Analisis Miskonsepsi Klien Terhadap Konseling Daring', 'Survei persepsi klien...', 'draft', NOW() - INTERVAL 26 DAY),
(6, 2, 18, 'Dampak Screen Time terhadap Memori Jangka Pendek', 'Penelitian eksperimen...', 'under_review', NOW() - INTERVAL 25 DAY),
(7, 2, 19, 'Gamifikasi dalam E-Learning: Motivasi versus Distraksi', 'Tinjauan literatur gamifikasi...', 'submitted', NOW() - INTERVAL 24 DAY),
(8, 2, 20, 'Kemandirian Belajar di Era Merdeka Belajar', 'Tingkat self-regulated learning...', 'rejected', NOW() - INTERVAL 23 DAY),
(9, 2, 13, 'Fenomena Zoom Fatigue pada Pengajar', 'Dampak psikologis kelas sinkronus...', 'published', NOW() - INTERVAL 22 DAY),
(10, 2, 14, 'Model Pembelajaran Flipped Classroom dengan AI', 'Inklusi AI generatif...', 'under_initial_check', NOW() - INTERVAL 21 DAY),
(11, 3, 15, 'Korelasi Kepribadian MBTI dengan Pemilihan Jenjang Karier', 'Riset empiris mahasiswa...', 'under_review', NOW() - INTERVAL 20 DAY),
(12, 3, 16, 'Quarter Life Crisis dan Burnout Kerja', 'Tinjauan studi kasus...', 'accepted', NOW() - INTERVAL 19 DAY),
(13, 3, 17, 'Pengaruh Gaya Kepemimpinan Transformasional pada Karir bawahan', 'Dampak pimpinan...', 'revision_required', NOW() - INTERVAL 18 DAY),
(14, 3, 18, 'Validasi Work-Life Balance Scale Versi Indonesia', 'Adaptasi instrumen WLBS...', 'under_initial_check', NOW() - INTERVAL 17 DAY),
(15, 3, 19, 'Peran Mentor Terhadap Kepuasan Kerja', 'Studi pada startup tech...', 'draft', NOW() - INTERVAL 16 DAY);

INSERT INTO `ai_review_insights` (`id`, `submission_id`, `status`, `insight_json`, `created_at`) VALUES 
(1, 1, 'completed', '{"rejection_risk_score":19,"editorial_readiness_score":70,"structure_score":88,"methodology_score":80,"novelty_score":59,"citation_score":89,"academic_tone_score":82,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(2, 2, 'completed', '{"rejection_risk_score":27,"editorial_readiness_score":77,"structure_score":90,"methodology_score":87,"novelty_score":65,"citation_score":82,"academic_tone_score":89,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(3, 3, 'completed', '{"rejection_risk_score":27,"editorial_readiness_score":95,"structure_score":74,"methodology_score":77,"novelty_score":73,"citation_score":73,"academic_tone_score":75,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(4, 4, 'completed', '{"rejection_risk_score":36,"editorial_readiness_score":84,"structure_score":80,"methodology_score":89,"novelty_score":77,"citation_score":86,"academic_tone_score":80,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(5, 5, 'completed', '{"rejection_risk_score":19,"editorial_readiness_score":73,"structure_score":74,"methodology_score":82,"novelty_score":81,"citation_score":65,"academic_tone_score":85,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(6, 6, 'completed', '{"rejection_risk_score":25,"editorial_readiness_score":68,"structure_score":76,"methodology_score":86,"novelty_score":69,"citation_score":89,"academic_tone_score":91,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(7, 7, 'completed', '{"rejection_risk_score":36,"editorial_readiness_score":70,"structure_score":86,"methodology_score":71,"novelty_score":61,"citation_score":84,"academic_tone_score":80,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(8, 8, 'completed', '{"rejection_risk_score":20,"editorial_readiness_score":89,"structure_score":84,"methodology_score":84,"novelty_score":51,"citation_score":86,"academic_tone_score":85,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(9, 9, 'completed', '{"rejection_risk_score":39,"editorial_readiness_score":76,"structure_score":88,"methodology_score":62,"novelty_score":75,"citation_score":68,"academic_tone_score":82,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY),
(10, 10, 'completed', '{"rejection_risk_score":36,"editorial_readiness_score":66,"structure_score":89,"methodology_score":70,"novelty_score":60,"citation_score":66,"academic_tone_score":77,"weakness_analysis":"Kurangnya rujukan 5 tahun terakhir pada bab tinjauan pustaka.","improvement_recommendation":"Tambahkan teori terbaru mengenai objek material penelitian."}', NOW() - INTERVAL 10 DAY);

INSERT INTO `editor_assignments` (`submission_id`, `editor_id`, `status`, `created_at`) VALUES 
(1, 7, 'assigned', NOW()),
(2, 7, 'assigned', NOW()),
(3, 6, 'assigned', NOW()),
(4, 6, 'assigned', NOW()),
(6, 7, 'assigned', NOW()),
(7, 6, 'assigned', NOW()),
(8, 7, 'assigned', NOW()),
(9, 6, 'assigned', NOW()),
(10, 7, 'assigned', NOW()),
(11, 7, 'assigned', NOW()),
(12, 6, 'assigned', NOW()),
(13, 6, 'assigned', NOW()),
(14, 7, 'assigned', NOW());

INSERT INTO `reviewer_profiles` (`user_id`, `affiliation`, `bio`) VALUES
(8, 'Universitas Psikologi Indonesia', 'Pakar art therapy.'),
(9, 'Institute of Tech', 'Fokus HCI dan Psikologi Pendidikan.'),
(10, 'Kampus Bimbingan Konseling', 'Konselor tersertifikasi.'),
(11, 'Universitas Mengajar', 'Dosen Pendidikan.'),
(12, 'Tech Edu Center', 'Peneliti E-Learning.');

INSERT INTO `reviewer_badges` (`id`, `name`, `icon`, `description`) VALUES
(1, 'Fast Reviewer', 'fa-bolt', 'Menyelesaikan review kurang dari 7 hari.'),
(2, 'Constructive Reviewer', 'fa-comment-dots', 'Feedback selalu mendetail dan membangun.'),
(3, 'Methodology Expert', 'fa-microscope', 'Sangat teliti dalam metodologi riset.');

INSERT INTO `reviewer_badge_logs` (`user_id`, `badge_id`, `awarded_at`) VALUES
(8, 1, NOW() - INTERVAL 10 DAY), (8, 2, NOW() - INTERVAL 5 DAY), (9, 3, NOW() - INTERVAL 8 DAY);

INSERT INTO `review_assignments` (`id`, `submission_id`, `reviewer_id`, `status`, `created_at`) VALUES 
(1, 1, 8, 'accepted', NOW() - INTERVAL 5 DAY),
(2, 3, 8, 'accepted', NOW() - INTERVAL 5 DAY),
(3, 6, 8, 'accepted', NOW() - INTERVAL 5 DAY),
(4, 11, 8, 'accepted', NOW() - INTERVAL 5 DAY),
(5, 2, 9, 'completed', NOW() - INTERVAL 20 DAY),
(6, 4, 9, 'completed', NOW() - INTERVAL 20 DAY),
(7, 12, 9, 'completed', NOW() - INTERVAL 20 DAY);

INSERT INTO `review_reports` (`assignment_id`, `comments_for_author`, `comments_for_editor`, `methodology_feedback`, `recommendation`, `created_at`) VALUES 
(5, 'Sudah sangat baik', 'Bisa langsung diterbitkan', 'Methodologi kuat', 'accept', NOW() - INTERVAL 15 DAY),
(6, 'Sudah sangat baik', 'Bisa langsung diterbitkan', 'Methodologi kuat', 'accept', NOW() - INTERVAL 15 DAY),
(7, 'Sudah sangat baik', 'Bisa langsung diterbitkan', 'Methodologi kuat', 'accept', NOW() - INTERVAL 15 DAY);

INSERT INTO `issues` (`id`, `journal_id`, `title`, `volume`, `number`, `year`, `is_published`, `published_at`) VALUES
(1, 1, 'Vol 1 No 1 (2025): Konseling Kontemporer', 1, 1, 2025, 1, NOW() - INTERVAL 30 DAY),
(2, 2, 'Vol 1 No 1 (2025): Digital Education', 1, 1, 2025, 1, NOW() - INTERVAL 40 DAY),
(3, 3, 'Vol 1 No 1 (2025): Dinamika Karier', 1, 1, 2025, 0, NULL);

INSERT INTO `published_articles` (`id`, `issue_id`, `submission_id`, `published_at`) VALUES
(1, 1, 4, NOW() - INTERVAL 30 DAY),
(2, 2, 9, NOW() - INTERVAL 40 DAY);

INSERT INTO `article_html_contents` (`article_id`, `html_content`) VALUES
(1, '<h3>1. Pendahuluan</h3><p>Penelitian ini mengeksplorasi penggunaan CBT via Chatbot...</p><h3>2. Metodologi</h3><p>Menggunakan eksperimen kuasi...</p>'), (2, '<h3>1. Latar Belakang</h3><p>Zoom fatigue makin merajalela...</p>');

INSERT INTO `article_references` (`article_id`, `citation_text`, `doi`) VALUES
(1, 'Smith, J. (2020). AI in Counseling. Journal of Tech, 1(1), 1-10.', '10.dummy/123'),
(1, 'Doe, A. (2022). Chatbot Efficacy. EduPsych, 2(2), 20-30.', '10.dummy/456');

INSERT INTO `article_concept_maps` (`article_id`, `map_data_json`) VALUES (1, '{\"nodes\":[\"Chatbot\",\"CBT\",\"Anxiety\"],\"edges\":[[\"Chatbot\",\"CBT\"],[\"CBT\",\"Anxiety\"]]}');

INSERT INTO `article_views` (`article_id`, `viewed_at`, `ip_address`) VALUES (1, NOW() - INTERVAL 3 DAY, '192.168.1.206'),
(1, NOW() - INTERVAL 22 DAY, '192.168.1.122'),
(1, NOW() - INTERVAL 27 DAY, '192.168.1.91'),
(1, NOW() - INTERVAL 6 DAY, '192.168.1.195'),
(1, NOW() - INTERVAL 27 DAY, '192.168.1.213'),
(1, NOW() - INTERVAL 10 DAY, '192.168.1.32'),
(1, NOW() - INTERVAL 2 DAY, '192.168.1.64'),
(1, NOW() - INTERVAL 5 DAY, '192.168.1.99'),
(1, NOW() - INTERVAL 20 DAY, '192.168.1.168'),
(1, NOW() - INTERVAL 22 DAY, '192.168.1.215'),
(1, NOW() - INTERVAL 2 DAY, '192.168.1.84'),
(1, NOW() - INTERVAL 23 DAY, '192.168.1.147'),
(1, NOW() - INTERVAL 25 DAY, '192.168.1.39'),
(1, NOW() - INTERVAL 25 DAY, '192.168.1.207'),
(1, NOW() - INTERVAL 6 DAY, '192.168.1.209'),
(1, NOW() - INTERVAL 28 DAY, '192.168.1.17'),
(1, NOW() - INTERVAL 20 DAY, '192.168.1.146'),
(1, NOW() - INTERVAL 30 DAY, '192.168.1.29'),
(1, NOW() - INTERVAL 2 DAY, '192.168.1.218'),
(1, NOW() - INTERVAL 21 DAY, '192.168.1.11'),
(1, NOW() - INTERVAL 10 DAY, '192.168.1.193'),
(1, NOW() - INTERVAL 21 DAY, '192.168.1.77'),
(1, NOW() - INTERVAL 18 DAY, '192.168.1.61'),
(1, NOW() - INTERVAL 21 DAY, '192.168.1.118'),
(1, NOW() - INTERVAL 2 DAY, '192.168.1.224'),
(1, NOW() - INTERVAL 10 DAY, '192.168.1.89'),
(1, NOW() - INTERVAL 10 DAY, '192.168.1.101'),
(1, NOW() - INTERVAL 18 DAY, '192.168.1.187'),
(1, NOW() - INTERVAL 22 DAY, '192.168.1.127'),
(1, NOW() - INTERVAL 23 DAY, '192.168.1.10'),
(1, NOW() - INTERVAL 12 DAY, '192.168.1.255'),
(1, NOW() - INTERVAL 21 DAY, '192.168.1.119'),
(1, NOW() - INTERVAL 26 DAY, '192.168.1.93'),
(1, NOW() - INTERVAL 22 DAY, '192.168.1.104'),
(1, NOW() - INTERVAL 28 DAY, '192.168.1.203'),
(1, NOW() - INTERVAL 1 DAY, '192.168.1.77'),
(1, NOW() - INTERVAL 16 DAY, '192.168.1.28'),
(1, NOW() - INTERVAL 16 DAY, '192.168.1.56'),
(1, NOW() - INTERVAL 21 DAY, '192.168.1.3'),
(1, NOW() - INTERVAL 11 DAY, '192.168.1.187'),
(1, NOW() - INTERVAL 3 DAY, '192.168.1.44'),
(1, NOW() - INTERVAL 20 DAY, '192.168.1.7'),
(1, NOW() - INTERVAL 23 DAY, '192.168.1.30'),
(1, NOW() - INTERVAL 12 DAY, '192.168.1.33'),
(1, NOW() - INTERVAL 14 DAY, '192.168.1.179'),
(1, NOW() - INTERVAL 7 DAY, '192.168.1.241'),
(1, NOW() - INTERVAL 2 DAY, '192.168.1.222'),
(1, NOW() - INTERVAL 21 DAY, '192.168.1.147'),
(1, NOW() - INTERVAL 18 DAY, '192.168.1.231'),
(1, NOW() - INTERVAL 13 DAY, '192.168.1.45'),
(2, NOW() - INTERVAL 9 DAY, '192.168.1.54'),
(2, NOW() - INTERVAL 14 DAY, '192.168.1.114'),
(2, NOW() - INTERVAL 13 DAY, '192.168.1.75'),
(2, NOW() - INTERVAL 28 DAY, '192.168.1.192'),
(2, NOW() - INTERVAL 7 DAY, '192.168.1.218'),
(2, NOW() - INTERVAL 15 DAY, '192.168.1.151'),
(2, NOW() - INTERVAL 15 DAY, '192.168.1.20'),
(2, NOW() - INTERVAL 13 DAY, '192.168.1.201'),
(2, NOW() - INTERVAL 17 DAY, '192.168.1.40'),
(2, NOW() - INTERVAL 5 DAY, '192.168.1.210'),
(2, NOW() - INTERVAL 17 DAY, '192.168.1.108'),
(2, NOW() - INTERVAL 17 DAY, '192.168.1.45'),
(2, NOW() - INTERVAL 28 DAY, '192.168.1.8'),
(2, NOW() - INTERVAL 18 DAY, '192.168.1.12'),
(2, NOW() - INTERVAL 7 DAY, '192.168.1.72'),
(2, NOW() - INTERVAL 15 DAY, '192.168.1.13'),
(2, NOW() - INTERVAL 29 DAY, '192.168.1.155'),
(2, NOW() - INTERVAL 21 DAY, '192.168.1.86'),
(2, NOW() - INTERVAL 17 DAY, '192.168.1.13'),
(2, NOW() - INTERVAL 9 DAY, '192.168.1.253'),
(2, NOW() - INTERVAL 20 DAY, '192.168.1.120'),
(2, NOW() - INTERVAL 22 DAY, '192.168.1.3'),
(2, NOW() - INTERVAL 29 DAY, '192.168.1.112'),
(2, NOW() - INTERVAL 7 DAY, '192.168.1.156'),
(2, NOW() - INTERVAL 20 DAY, '192.168.1.241'),
(2, NOW() - INTERVAL 20 DAY, '192.168.1.29'),
(2, NOW() - INTERVAL 16 DAY, '192.168.1.156'),
(2, NOW() - INTERVAL 25 DAY, '192.168.1.117'),
(2, NOW() - INTERVAL 2 DAY, '192.168.1.25'),
(2, NOW() - INTERVAL 5 DAY, '192.168.1.63');

INSERT INTO `research_profiles` (`user_id`, `bio`, `institution`, `google_scholar_id`) VALUES
(13, 'Peneliti di bidang psikologi klinis', 'Universitas A', 'GS1234'),
(14, 'Dosen Bimbingan Konseling', 'Universitas B', 'GS5678');

INSERT INTO `communities` (`id`, `name`, `description`, `created_by`) VALUES
(1, 'Forum Konselor Digital', 'Diskusi seputar e-counseling.', 13),
(2, 'EdTech Researchers', 'Kumpulan peneliti pendidikan teknologi.', 14);

INSERT INTO `community_posts` (`id`, `community_id`, `user_id`, `title`, `content`) VALUES
(1, 1, 13, 'Trend AI dalam Konseling 2026', 'Bagaimana menurut rekan-rekan tentang peran AI?'),
(2, 2, 14, 'Gamifikasi kurang efektif?', 'Saya menemukan data anomali pada reset saya.');

