-- ============================================================================
-- Gmind Institute - Database Seed Data
-- ============================================================================
-- MySQL 8.0+ | InnoDB | utf8mb4_unicode_ci
-- Run this file AFTER schema.sql
-- Generated: 2026-03-04
-- ============================================================================
-- This file inserts comprehensive sample data for ALL tables to make the
-- home page look complete and professional.
-- ============================================================================

USE `advaysin_gmind`;

-- ============================================================================
-- 1. Settings - Site configuration key-value pairs
-- ============================================================================
-- Uses INSERT ... ON DUPLICATE KEY UPDATE so this is idempotent alongside
-- the default settings inserted by schema.sql.

INSERT INTO `settings` (`setting_key`, `setting_value`) VALUES
    ('site_name', 'Gmind Institute'),
    ('site_tagline', 'Excellence in Computer Education'),
    ('site_email', 'info@gmind.in'),
    ('site_phone', '9305640290'),
    ('site_address', '123 Education Street, New Delhi, India'),
    ('stat_total_students', '10000'),
    ('stat_total_courses', '25'),
    ('stat_total_branches', '50'),
    ('stat_years_experience', '15'),
    ('facebook_url', 'https://www.facebook.com/gmindinstitute'),
    ('twitter_url', 'https://twitter.com/gmindinstitute'),
    ('youtube_url', 'https://www.youtube.com/@gmindinstitute'),
    ('instagram_url', 'https://www.instagram.com/gmindinstitute'),
    ('admission_open', 'yes'),
    ('footer_text', '© 2026 Gmind Institute. All Rights Reserved.'),
    ('social_facebook', 'https://www.facebook.com/gmindinstitute'),
    ('social_instagram', 'https://www.instagram.com/gmindinstitute'),
    ('social_youtube', 'https://www.youtube.com/@gmindinstitute'),
    ('social_twitter', 'https://twitter.com/gmindinstitute'),
    ('social_linkedin', 'https://www.linkedin.com/company/gmindinstitute'),
    ('contact_email', 'info@gmind.in'),
    ('maintenance_mode', '0')
ON DUPLICATE KEY UPDATE
    `setting_value` = VALUES(`setting_value`);

-- ============================================================================
-- 2. Users - Admin and Staff accounts
-- ============================================================================
-- Password for both: Admin@123
-- Hash: $2y$10$ (bcrypt, cost 10)

INSERT INTO `users` (`name`, `email`, `password`, `role`, `phone`, `is_active`) VALUES
    ('Admin', 'admin@gmind.in', '$2y$10$pDJ8I1yCCthvyA/GryQN4OcviNmrHaa1nwvUFaROrOkjEGFWTiFAe', 'admin', '9305640290', 1),
    ('Staff User', 'staff@gmind.in', '$2y$10$pDJ8I1yCCthvyA/GryQN4OcviNmrHaa1nwvUFaROrOkjEGFWTiFAe', 'staff', '9305640291', 1)
ON DUPLICATE KEY UPDATE
    `name` = VALUES(`name`),
    `password` = VALUES(`password`),
    `role` = VALUES(`role`),
    `phone` = VALUES(`phone`),
    `is_active` = VALUES(`is_active`);

-- ============================================================================
-- 3. Sliders - Homepage carousel (5 slides)
-- ============================================================================

INSERT INTO `sliders` (`title`, `subtitle`, `image`, `link`, `sort_order`, `active`) VALUES
    ('Shape Your Future with Gmind Institute', 'Government recognised computer education with 100% job placement assistance', 'uploads/sliders/slider-1.jpg', '/courses', 1, 1),
    ('Industry-Ready Computer Courses', 'From basic computing to advanced programming — learn from the best', 'uploads/sliders/slider-2.jpg', '/courses', 2, 1),
    ('Online Exam Portal — Practice Anytime', 'Access our digital exam platform and track your progress in real-time', 'uploads/sliders/slider-3.jpg', '/exam', 3, 1),
    ('Join 10,000+ Successful Alumni', 'Our graduates work at top companies across India and abroad', 'uploads/sliders/slider-4.jpg', '/about', 4, 1),
    ('Admissions Open 2026', 'Enroll now and get early bird discount on selected courses', 'uploads/sliders/slider-5.jpg', '/admission', 5, 1);

-- ============================================================================
-- 4. Announcements - Scrolling news bar (5 items)
-- ============================================================================

INSERT INTO `announcements` (`text`, `link`, `active`) VALUES
    ('New batch for ADCA starting from 15th June 2026 — Register Now!', '/courses/1', 1),
    ('Gmind Institute launches Online Exam Portal — Practice from home', '/exam', 1),
    ('Campus placement drive by TCS on 20th June 2026', '/news', 1),
    ('Summer special discount: 20% off on all diploma courses', '/courses', 1),
    ('New branch opening in Lucknow — Admissions started', '/branches', 1);

-- ============================================================================
-- 5. Courses - Available courses (10 courses)
-- ============================================================================

INSERT INTO `courses` (`name`, `category`, `duration`, `fee`, `description`, `syllabus`, `image`, `is_featured`, `active`) VALUES
    (
        'ADCA (Advanced Diploma in Computer Application)',
        'computer',
        '12 Months',
        25000.00,
        'The ADCA programme is a comprehensive 12-month course designed to equip students with advanced skills in computer applications, office automation, internet technologies, and programming fundamentals. It is ideal for students who want to build a strong foundation for a career in IT and office administration. The course covers everything from basic computer operations to advanced topics like database management and web technologies.',
        'Module 1: Computer Fundamentals & Windows OS\nModule 2: MS Office (Word, Excel, PowerPoint, Access)\nModule 3: Internet & Email Communication\nModule 4: Tally Prime with GST\nModule 5: HTML, CSS & JavaScript Basics\nModule 6: Database Management (MySQL)\nModule 7: Programming Fundamentals (C Language)\nModule 8: Project Work & Internship',
        'uploads/courses/adca.jpg',
        1, 1
    ),
    (
        'DCA (Diploma in Computer Application)',
        'computer',
        '6 Months',
        15000.00,
        'The DCA is a 6-month diploma course that provides essential computer skills for everyday professional use. Students learn office productivity tools, internet skills, and basic accounting software. This course is perfect for those seeking quick employability in office and data entry roles across government and private sectors.',
        'Module 1: Computer Fundamentals & Operating Systems\nModule 2: MS Word & Excel\nModule 3: PowerPoint Presentations\nModule 4: Internet & Email\nModule 5: Tally Basics\nModule 6: Practical Assignments & Exam Preparation',
        'uploads/courses/dca.jpg',
        1, 1
    ),
    (
        'Tally Prime with GST',
        'accounting',
        '3 Months',
        8000.00,
        'Master Tally Prime, the most widely used accounting software in India. This 3-month course covers comprehensive GST compliance, inventory management, payroll, and financial reporting. Ideal for commerce students, accountants, and small business owners who want to streamline their accounting processes.',
        'Module 1: Introduction to Accounting & Tally Prime\nModule 2: Company Creation & Ledger Management\nModule 3: GST Configuration & Returns (GSTR-1, GSTR-3B)\nModule 4: Inventory Management\nModule 5: Payroll & Statutory Compliance\nModule 6: Financial Reports & Audit',
        'uploads/courses/tally-prime.jpg',
        1, 1
    ),
    (
        'Advanced Accounting',
        'accounting',
        '6 Months',
        12000.00,
        'This 6-month Advanced Accounting course goes beyond the basics to cover corporate accounting, taxation, auditing principles, and advanced Tally operations. Students gain practical experience with real-world financial statements and compliance requirements, preparing them for roles in finance and accounting departments.',
        'Module 1: Advanced Accounting Principles\nModule 2: Corporate Accounting & Financial Statements\nModule 3: Direct & Indirect Taxation (Income Tax, GST)\nModule 4: Advanced Tally Prime & Busy Accounting\nModule 5: Auditing & Assurance\nModule 6: Practical Case Studies & Project',
        'uploads/courses/advanced-accounting.jpg',
        1, 1
    ),
    (
        'Python Programming',
        'programming',
        '4 Months',
        10000.00,
        'Learn Python from scratch — one of the most in-demand programming languages in the world. This 4-month course covers Python fundamentals, data structures, object-oriented programming, file handling, and an introduction to libraries like NumPy and Pandas. Perfect for beginners and those looking to enter the software development field.',
        'Module 1: Python Basics & Data Types\nModule 2: Control Flow & Functions\nModule 3: Data Structures (Lists, Dictionaries, Tuples, Sets)\nModule 4: Object-Oriented Programming\nModule 5: File Handling & Exception Handling\nModule 6: Introduction to NumPy, Pandas & Data Analysis\nModule 7: Mini Projects',
        'uploads/courses/python.jpg',
        1, 1
    ),
    (
        'Web Design & Development',
        'programming',
        '6 Months',
        18000.00,
        'A complete 6-month programme covering front-end and back-end web development. Students learn HTML5, CSS3, JavaScript, Bootstrap, PHP, and MySQL to build professional, responsive websites from scratch. The course includes multiple real-world projects and portfolio building to ensure job readiness.',
        'Module 1: HTML5 & Semantic Markup\nModule 2: CSS3, Flexbox & Grid Layout\nModule 3: JavaScript & DOM Manipulation\nModule 4: Bootstrap 5 & Responsive Design\nModule 5: PHP & MySQL (Back-End Development)\nModule 6: WordPress Basics\nModule 7: Live Project & Portfolio Building',
        'uploads/courses/web-design.jpg',
        1, 1
    ),
    (
        'Graphic Design',
        'design',
        '4 Months',
        12000.00,
        'Unlock your creative potential with our 4-month Graphic Design course. Master industry-standard tools like Adobe Photoshop, Illustrator, and CorelDRAW to create stunning logos, brochures, social media graphics, and brand identities. Students build a professional portfolio throughout the course.',
        'Module 1: Design Fundamentals & Colour Theory\nModule 2: Adobe Photoshop (Photo Editing, Compositing)\nModule 3: Adobe Illustrator (Vector Graphics, Logo Design)\nModule 4: CorelDRAW (Print Design, Brochures)\nModule 5: Typography & Layout Design\nModule 6: Portfolio Development & Brand Identity Project',
        'uploads/courses/graphic-design.jpg',
        0, 1
    ),
    (
        'CCC (Course on Computer Concepts)',
        'computer',
        '3 Months',
        5000.00,
        'The CCC is a government-recognised certification course by NIELIT that validates basic computer literacy. This 3-month programme covers computer fundamentals, operating systems, office tools, internet, and digital literacy. It is mandatory for many government job applications and provides a strong foundation for further IT studies.',
        'Module 1: Introduction to Computer Systems\nModule 2: Operating Systems (Windows)\nModule 3: Word Processing (MS Word)\nModule 4: Spreadsheet (MS Excel)\nModule 5: Presentation (MS PowerPoint)\nModule 6: Internet, Email & Digital Literacy\nModule 7: NIELIT Exam Preparation & Mock Tests',
        'uploads/courses/ccc.jpg',
        0, 1
    ),
    (
        'Java Full Stack',
        'programming',
        '8 Months',
        22000.00,
        'Become a full-stack Java developer with this intensive 8-month programme. Cover core Java, JDBC, Servlets, JSP, Spring Boot, Hibernate, REST APIs, and front-end integration with Angular or React. Students work on enterprise-grade projects and are prepared for roles at top IT companies.',
        'Module 1: Core Java (OOP, Collections, Multithreading)\nModule 2: JDBC & Database Connectivity\nModule 3: Web Development (Servlets, JSP)\nModule 4: Spring Framework & Spring Boot\nModule 5: Hibernate & JPA\nModule 6: REST API Development\nModule 7: Front-End Integration (Angular/React Basics)\nModule 8: Capstone Project & Interview Preparation',
        'uploads/courses/java-fullstack.jpg',
        0, 1
    ),
    (
        'Digital Marketing',
        'design',
        '3 Months',
        9000.00,
        'Learn to market products and services online with our 3-month Digital Marketing course. Cover SEO, SEM, social media marketing, Google Ads, Facebook Ads, email marketing, content marketing, and web analytics. Hands-on campaigns and real-world projects ensure you are job-ready from day one.',
        'Module 1: Digital Marketing Fundamentals & Strategy\nModule 2: Search Engine Optimization (SEO)\nModule 3: Google Ads & Search Engine Marketing (SEM)\nModule 4: Social Media Marketing (Facebook, Instagram, LinkedIn)\nModule 5: Email Marketing & Content Marketing\nModule 6: Google Analytics & Web Reporting\nModule 7: Live Campaign Project',
        'uploads/courses/digital-marketing.jpg',
        0, 1
    );

-- ============================================================================
-- 6. Branches - Institute locations (8 branches)
-- ============================================================================

INSERT INTO `branches` (`name`, `city`, `state`, `address`, `phone`, `map_link`, `image`, `active`) VALUES
    ('Gmind Institute - New Delhi', 'New Delhi', 'Delhi', '123 Education Street, Connaught Place, New Delhi - 110001', '9305640201', 'https://maps.google.com/?q=Connaught+Place+New+Delhi', 'uploads/branches/new-delhi.jpg', 1),
    ('Gmind Institute - Mumbai', 'Mumbai', 'Maharashtra', '45 Tech Hub, Andheri West, Mumbai - 400058', '9305640202', 'https://maps.google.com/?q=Andheri+West+Mumbai', 'uploads/branches/mumbai.jpg', 1),
    ('Gmind Institute - Patna', 'Patna', 'Bihar', '78 Knowledge Lane, Boring Road, Patna - 800001', '9305640203', 'https://maps.google.com/?q=Boring+Road+Patna', 'uploads/branches/patna.jpg', 1),
    ('Gmind Institute - Lucknow', 'Lucknow', 'Uttar Pradesh', '22 Gomti Nagar, Lucknow - 226010', '9305640204', 'https://maps.google.com/?q=Gomti+Nagar+Lucknow', 'uploads/branches/lucknow.jpg', 1),
    ('Gmind Institute - Jaipur', 'Jaipur', 'Rajasthan', '15 Malviya Nagar, Jaipur - 302017', '9305640205', 'https://maps.google.com/?q=Malviya+Nagar+Jaipur', 'uploads/branches/jaipur.jpg', 1),
    ('Gmind Institute - Kolkata', 'Kolkata', 'West Bengal', 'Salt Lake City, Sector V, Kolkata - 700091', '9305640206', 'https://maps.google.com/?q=Salt+Lake+City+Kolkata', 'uploads/branches/kolkata.jpg', 1),
    ('Gmind Institute - Bhopal', 'Bhopal', 'Madhya Pradesh', '33 MP Nagar Zone II, Bhopal - 462011', '9305640207', 'https://maps.google.com/?q=MP+Nagar+Bhopal', 'uploads/branches/bhopal.jpg', 1),
    ('Gmind Institute - Chandigarh', 'Chandigarh', 'Punjab', 'Sector 17-C, Chandigarh - 160017', '9305640208', 'https://maps.google.com/?q=Sector+17+Chandigarh', 'uploads/branches/chandigarh.jpg', 1);

-- ============================================================================
-- 7. Affiliations - Recognised bodies & placement partners (8 items)
-- ============================================================================

INSERT INTO `affiliations` (`name`, `logo`, `website`, `type`, `sort_order`, `active`) VALUES
    -- Affiliations
    ('NIELIT', 'uploads/affiliations/nielit-logo.png', 'https://nielit.gov.in', 'affiliation', 1, 1),
    ('AICTE', 'uploads/affiliations/aicte-logo.png', 'https://aicte-india.org', 'affiliation', 2, 1),
    ('MSME', 'uploads/affiliations/msme-logo.png', 'https://msme.gov.in', 'affiliation', 3, 1),
    ('ISO 9001:2015', 'uploads/affiliations/iso-logo.png', 'https://iso.org', 'affiliation', 4, 1),
    -- Partners
    ('TCS', 'uploads/partners/tcs-logo.png', 'https://tcs.com', 'partner', 1, 1),
    ('Wipro', 'uploads/partners/wipro-logo.png', 'https://wipro.com', 'partner', 2, 1),
    ('Infosys', 'uploads/partners/infosys-logo.png', 'https://infosys.com', 'partner', 3, 1),
    ('HCL Technologies', 'uploads/partners/hcl-logo.png', 'https://hcltech.com', 'partner', 4, 1);

-- ============================================================================
-- 8. Toppers - Top-performing students (6 toppers)
-- ============================================================================
-- course_id references: 1=ADCA, 2=DCA, 3=Tally, 5=Python, 6=Web Design, 9=Java
-- branch_id references: 1=Delhi, 2=Mumbai, 3=Patna, 4=Lucknow, 5=Jaipur, 6=Kolkata

INSERT INTO `toppers` (`name`, `course_id`, `marks`, `grade`, `photo`, `batch_year`, `branch_id`, `sort_order`, `active`) VALUES
    ('Priya Sharma', 1, '96%', 'Distinction', 'uploads/toppers/priya-sharma.jpg', 2024, 1, 1, 1),
    ('Rahul Verma', 2, '94%', 'Distinction', 'uploads/toppers/rahul-verma.jpg', 2024, 2, 2, 1),
    ('Anjali Singh', 5, '92%', 'Distinction', 'uploads/toppers/anjali-singh.jpg', 2024, 3, 3, 1),
    ('Amit Kumar', 6, '89%', 'First Class', 'uploads/toppers/amit-kumar.jpg', 2024, 4, 4, 1),
    ('Sneha Gupta', 3, '87%', 'First Class', 'uploads/toppers/sneha-gupta.jpg', 2024, 5, 5, 1),
    ('Vikram Patel', 9, '85%', 'First Class', 'uploads/toppers/vikram-patel.jpg', 2024, 6, 6, 1);

-- ============================================================================
-- 9. Branch News - News per branch (6 items)
-- ============================================================================
-- branch_id references: 1=Delhi, 2=Mumbai, 3=Patna, 4=Lucknow, 5=Jaipur, 6=Kolkata

INSERT INTO `branch_news` (`branch_id`, `title`, `slug`, `content`, `image`, `published_at`, `active`) VALUES
    (
        1,
        'Gmind New Delhi Hosts National IT Symposium 2026',
        'new-delhi-national-it-symposium-2026',
        '<p>The New Delhi branch of Gmind Institute successfully hosted the National IT Symposium 2026, bringing together industry leaders, educators, and students from across the country. The event featured keynote addresses from top IT executives, hands-on workshops on emerging technologies like AI and cloud computing, and a panel discussion on the future of tech education in India.</p><p>Over 500 students participated in the two-day event, which also included a hackathon where teams competed to build innovative solutions for real-world problems. The winning team developed a smart attendance system using facial recognition technology.</p><p>"Events like these bridge the gap between academic learning and industry expectations," said the branch director during the closing ceremony.</p>',
        'uploads/news/delhi-symposium-2026.jpg',
        '2026-02-15 10:00:00', 1
    ),
    (
        2,
        'Mumbai Branch Students Secure Placements at Top MNCs',
        'mumbai-students-placements-top-mncs',
        '<p>The Mumbai branch has achieved a remarkable placement record this quarter, with 45 students receiving offer letters from leading multinational companies including TCS, Wipro, and Infosys. The placements span roles in software development, data analysis, digital marketing, and accounting.</p><p>The branch attributed this success to its rigorous training methodology, which combines classroom instruction with hands-on project work and soft skills development. "Our placement cell works year-round to connect students with the right opportunities," said the placement coordinator.</p><p>Several students have received packages above the industry average, with the highest offer touching ₹6.5 LPA for a Java Full Stack developer role.</p>',
        'uploads/news/mumbai-placements-2026.jpg',
        '2026-01-20 09:30:00', 1
    ),
    (
        3,
        'Patna Branch Launches Free Digital Literacy Workshop for Women',
        'patna-free-digital-literacy-workshop-women',
        '<p>In a commendable initiative towards women empowerment, the Patna branch of Gmind Institute has launched a free Digital Literacy Workshop exclusively for women. The month-long programme aims to train over 200 women in basic computer skills, internet usage, and online safety.</p><p>The workshop covers essential topics including email communication, online banking, government portal usage, and social media safety. Participants also receive a certificate upon successful completion of the programme.</p><p>"Digital literacy is no longer optional — it is a fundamental skill. Through this initiative, we aim to bridge the gender digital divide in Bihar," said the programme coordinator. The workshop has received overwhelming response with registrations filling up within the first week.</p>',
        'uploads/news/patna-women-workshop-2026.jpg',
        '2026-03-01 08:00:00', 1
    ),
    (
        4,
        'Lucknow Branch Inaugurates New Computer Lab with 100+ Workstations',
        'lucknow-new-computer-lab-inauguration',
        '<p>The Lucknow branch has unveiled a state-of-the-art computer lab equipped with over 100 modern workstations, high-speed fibre internet, and the latest software suites. The lab was inaugurated by the District Magistrate in a ceremony attended by faculty, students, and local dignitaries.</p><p>The new facility will support practical training for courses including ADCA, DCA, Python Programming, and Web Design. Each workstation is configured with dual monitors, enabling students to follow along with instructor demonstrations while working on their own projects simultaneously.</p><p>"This investment reflects our commitment to providing the best learning infrastructure to our students," said the branch manager. The lab will also be available for online exam practice and certification testing.</p>',
        'uploads/news/lucknow-lab-2026.jpg',
        '2026-02-05 11:00:00', 1
    ),
    (
        5,
        'Jaipur Branch Students Win State-Level Programming Competition',
        'jaipur-students-win-programming-competition',
        '<p>Three students from the Jaipur branch of Gmind Institute have won the prestigious Rajasthan State-Level Programming Competition 2026, organised by the Department of Information Technology. The team, comprising students from the Python Programming and Java Full Stack courses, competed against 50 teams from across the state.</p><p>The winning project was an AI-powered crop disease detection system that uses smartphone cameras to identify plant diseases and recommend treatments. The judges praised the project for its practical application and technical sophistication.</p><p>"We are incredibly proud of our students. Their achievement demonstrates that with the right training and mentorship, anything is possible," said the branch director. The team has been invited to present their project at the National IT Conference later this year.</p>',
        'uploads/news/jaipur-competition-2026.jpg',
        '2026-01-10 14:00:00', 1
    ),
    (
        6,
        'Kolkata Branch Partners with Local Businesses for Internship Programme',
        'kolkata-internship-programme-local-businesses',
        '<p>The Kolkata branch has forged partnerships with 15 local businesses and startups to create a robust internship programme for its students. The initiative aims to provide hands-on industry exposure to students enrolled in accounting, programming, and design courses.</p><p>Participating companies span diverse sectors including e-commerce, fintech, healthcare IT, and digital agencies. Students will work on real projects under the mentorship of experienced professionals, gaining invaluable practical experience alongside their academic training.</p><p>"Classroom learning must be complemented with real-world experience. These partnerships ensure our students graduate not just with knowledge, but with proven skills," said the programme head. The first batch of 30 interns will begin their stints in April 2026.</p>',
        'uploads/news/kolkata-internship-2026.jpg',
        '2026-02-20 10:30:00', 1
    );

-- ============================================================================
-- 10. FAQs - Frequently Asked Questions (8 FAQs)
-- ============================================================================

INSERT INTO `faqs` (`question`, `answer`, `category`, `sort_order`, `show_on_home`, `active`) VALUES
    (
        'What courses does Gmind Institute offer?',
        'Gmind Institute offers a wide range of computer courses including ADCA (Advanced Diploma in Computer Application), DCA (Diploma in Computer Application), Tally Prime with GST, Advanced Accounting, Python Programming, Web Design & Development, Graphic Design, CCC (Course on Computer Concepts), Java Full Stack, and Digital Marketing. We also offer short-term certification courses in specific technologies. All our courses are designed with industry input to ensure maximum employability.',
        'courses', 1, 1, 1
    ),
    (
        'Is Gmind Institute government recognised?',
        'Yes, Gmind Institute is a government-recognised institution. We are affiliated with NIELIT (National Institute of Electronics & Information Technology) and approved by AICTE (All India Council for Technical Education). Our courses are registered under MSME, and we hold ISO 9001:2015 certification for quality management. Certificates issued by Gmind Institute are valid for government and private sector employment across India.',
        'general', 2, 1, 1
    ),
    (
        'What is the admission process?',
        'The admission process at Gmind Institute is simple and straightforward. You can apply online through our website or visit any of our branches in person. The steps are: (1) Fill out the admission form with your personal and educational details, (2) Submit the required documents (ID proof, educational certificates, and passport-size photographs), (3) Pay the course fee (instalment options are available), (4) Receive your enrollment number and batch schedule. Walk-in admissions are also accepted at all branches during working hours.',
        'admission', 3, 1, 1
    ),
    (
        'Do you provide job placement assistance?',
        'Absolutely! Gmind Institute has a dedicated Placement Cell that works tirelessly to connect our students with job opportunities. We have placement partnerships with leading companies including TCS, Wipro, Infosys, and HCL Technologies. Our placement support includes resume building, interview preparation, soft skills training, and direct placement drives. Over 85% of our eligible students receive placement offers within 3 months of course completion.',
        'placement', 4, 1, 1
    ),
    (
        'Can I pay fees in instalments?',
        'Yes, Gmind Institute offers flexible fee payment options. Students can pay course fees in 2-3 instalments depending on the course duration. We also accept payments via UPI, net banking, debit/credit cards, and cash at the branch. For students from economically weaker sections, we offer special scholarships and fee concessions. Please contact your nearest branch for detailed fee structure and instalment plans.',
        'fees', 5, 1, 1
    ),
    (
        'What is the Online Exam Portal?',
        'The Gmind Institute Online Exam Portal is a digital platform that allows students to practice and take exams from anywhere, anytime. The portal features chapter-wise practice tests, full-length mock exams, instant result analysis, and detailed performance reports. It is especially useful for CCC and other certification exam preparation. Students can track their progress over time and identify areas that need improvement. The portal is accessible via both desktop and mobile devices.',
        'exams', 6, 1, 1
    ),
    (
        'How do I get my certificate after course completion?',
        'Upon successful completion of your course and passing the final examination, you will receive a certificate from Gmind Institute. The certificate is typically issued within 15-20 working days after the results are declared. You can collect it from your branch or opt for home delivery. Digital certificates are also available through our online portal. All certificates come with a unique verification code that employers can use to validate authenticity online.',
        'certificates', 7, 0, 1
    ),
    (
        'Are online classes available?',
        'Yes, Gmind Institute offers online classes for select courses through our digital learning platform. Online students get access to live lectures, recorded sessions, study materials, and the Online Exam Portal. The learning experience mirrors our classroom programmes with interactive sessions and real-time doubt resolution. A hybrid mode (online + offline) is also available for students who want the flexibility of both formats. Contact your nearest branch for the list of courses currently available in online mode.',
        'courses', 8, 0, 1
    );

-- ============================================================================
-- 11. Testimonials - Student reviews (6 testimonials)
-- ============================================================================
-- course_id references: 1=ADCA, 2=DCA, 3=Tally, 5=Python, 6=Web Design, 7=Graphic Design
-- branch_id references: 1=Delhi, 3=Patna, 4=Lucknow, 5=Jaipur, 6=Kolkata, 7=Bhopal

INSERT INTO `testimonials` (`name`, `course_id`, `branch_id`, `rating`, `review`, `photo`, `is_approved`) VALUES
    (
        'Rohit Mehta',
        1, 1, 5,
        'Gmind Institute completely transformed my career. The ADCA course gave me in-depth knowledge of computer applications, and the faculty was incredibly supportive. Within two months of completing the course, I landed a job at a reputed IT firm in Delhi. The placement cell really goes above and beyond to help students. I highly recommend Gmind to anyone looking for quality computer education.',
        'uploads/testimonials/rohit-mehta.jpg', 1
    ),
    (
        'Neha Agarwal',
        3, 3, 5,
        'I enrolled in the Tally Prime with GST course at the Patna branch, and it was one of the best decisions I ever made. The practical training approach helped me understand real-world accounting scenarios. I now work as an accountant at a CA firm, and I use everything I learned at Gmind every single day. The course fee was very reasonable compared to the value I received.',
        'uploads/testimonials/neha-agarwal.jpg', 1
    ),
    (
        'Manish Tiwari',
        5, 4, 4,
        'The Python Programming course at Gmind Lucknow was excellent. The instructors explained complex concepts in a simple, easy-to-understand manner. The hands-on projects were particularly valuable — they gave me the confidence to write real code. I just wish the course had a bit more coverage of advanced topics like Django. Overall, a great learning experience!',
        'uploads/testimonials/manish-tiwari.jpg', 1
    ),
    (
        'Pooja Rathore',
        6, 5, 5,
        'I always wanted to become a web developer, and Gmind Institute made it possible. The Web Design & Development course covered everything from HTML to PHP and MySQL. Building live projects during the course gave me a portfolio that impressed my current employer. The Jaipur branch has amazing infrastructure and the labs are well-equipped. Thank you, Gmind!',
        'uploads/testimonials/pooja-rathore.jpg', 1
    ),
    (
        'Saurav Das',
        2, 6, 4,
        'The DCA course at Gmind Kolkata provided me with a solid foundation in computer applications. The teachers were patient and always available for doubt-clearing sessions. I especially liked the exam preparation module which helped me clear the CCC certification on my first attempt. The course content is up-to-date and relevant to current industry needs.',
        'uploads/testimonials/saurav-das.jpg', 1
    ),
    (
        'Kavita Joshi',
        7, 7, 5,
        'As a creative person, the Graphic Design course at Gmind Bhopal was a perfect fit for me. I learned Photoshop, Illustrator, and CorelDRAW from scratch, and by the end of the course, I was designing professional logos and brochures for real clients. The portfolio I built during the course helped me get freelance work immediately. The faculty is talented and genuinely cares about student success.',
        'uploads/testimonials/kavita-joshi.jpg', 1
    );

-- ============================================================================
-- 12. Exams & Exam Questions - Sample exam (1 exam + 10 MCQ questions)
-- ============================================================================
-- course_id 8 = CCC (Course on Computer Concepts)

INSERT INTO `exams` (`title`, `course_id`, `duration_minutes`, `total_marks`, `pass_marks`, `is_published`) VALUES
    ('CCC Practice Exam', 8, 30, 50, 20, 1);

-- Exam Questions (10 MCQs for CCC Practice Exam)
-- exam_id references the auto-incremented ID from the exam above (will be 1)

INSERT INTO `exam_questions` (`exam_id`, `question_text`, `option_a`, `option_b`, `option_c`, `option_d`, `correct_answer`, `marks`, `sort_order`) VALUES
    (
        1,
        'Which of the following is the brain of the computer?',
        'ALU', 'CPU', 'RAM', 'ROM',
        'b', 5, 1
    ),
    (
        1,
        'What does RAM stand for?',
        'Read Access Memory', 'Random Access Memory', 'Rapid Access Module', 'Runtime Allocated Memory',
        'b', 5, 2
    ),
    (
        1,
        'Which operating system is developed by Microsoft?',
        'Linux', 'macOS', 'Windows', 'Ubuntu',
        'c', 5, 3
    ),
    (
        1,
        'What is the full form of HTTP?',
        'HyperText Transfer Protocol', 'High Text Transfer Protocol', 'HyperText Transmission Protocol', 'High Transfer Text Protocol',
        'a', 5, 4
    ),
    (
        1,
        'Which of the following is an input device?',
        'Monitor', 'Printer', 'Keyboard', 'Speaker',
        'c', 5, 5
    ),
    (
        1,
        'What does URL stand for?',
        'Uniform Resource Locator', 'Universal Resource Link', 'Uniform Remote Locator', 'Unified Resource Locator',
        'a', 5, 6
    ),
    (
        1,
        'Which shortcut key is used to copy text in MS Word?',
        'Ctrl+V', 'Ctrl+X', 'Ctrl+C', 'Ctrl+P',
        'c', 5, 7
    ),
    (
        1,
        'What is the file extension of a Microsoft Excel workbook?',
        '.doc', '.ppt', '.xls', '.txt',
        'c', 5, 8
    ),
    (
        1,
        'Which of the following is a web browser?',
        'Microsoft Word', 'Google Chrome', 'Adobe Photoshop', 'Notepad',
        'b', 5, 9
    ),
    (
        1,
        '1 GB (Gigabyte) is equal to how many MB (Megabytes)?',
        '100 MB', '500 MB', '1024 MB', '1000 MB',
        'c', 5, 10
    );

-- ============================================================================
-- End of Seed Data
-- ============================================================================
