import os
from django.core.management.base import BaseCommand
from courses.models import (
    Course, Semester, Subject, CareerProspect, AdmissionStep, 
    Recruiter, WhyJoin, Testimonial
)

class Command(BaseCommand):
    help = 'Creates comprehensive content for all Allied Sciences courses'

    def handle(self, *args, **options):
        self.stdout.write(self.style.SUCCESS('Starting to create Allied Sciences course content'))
        
        # Get all Allied Sciences courses
        allied_courses = Course.objects.filter(
            slug__in=[
                'bpharm', 'bpharm-le', 'bsc-nursing', 'bsc-microbiology', 
                'dpharm', 'mpharm-pharmaceutics', 'msc-pharmaceutical-chemistry', 
                'msc-microbiology'
            ]
        )
        
        self.stdout.write(self.style.SUCCESS(f'Found {allied_courses.count()} Allied Sciences courses'))
        
        for course in allied_courses:
            self.stdout.write(f'Creating content for: {course.title}')
            
            # Create semesters and subjects
            self._create_semesters_and_subjects(course)
            
            # Create career prospects
            self._create_career_prospects(course)
            
            # Create admission steps
            self._create_admission_steps(course)
            
            # Create recruiters
            self._create_recruiters(course)
            
            # Create why join points
            self._create_why_join(course)
            
            # Create testimonials
            self._create_testimonials(course)
            
        self.stdout.write(self.style.SUCCESS('Successfully created all Allied Sciences course content!'))
    
    def _create_semesters_and_subjects(self, course):
        """Create semesters and subjects for the course"""
        # Clear existing semesters
        course.semesters.all().delete()
        
        if 'B.Pharm' in course.title and 'LE' not in course.title:
            # B.Pharm 4 years (8 semesters)
            semesters_data = [
                {
                    'name': 'Semester 1', 'number': 1,
                    'subjects': [
                        'Human Anatomy and Physiology I', 'Pharmaceutical Inorganic Chemistry',
                        'Pharmaceutics I', 'Pharmaceutical Analysis I', 'Remedial Biology',
                        'Remedial Mathematics', 'Communication Skills', 'Computer Applications in Pharmacy'
                    ]
                },
                {
                    'name': 'Semester 2', 'number': 2,
                    'subjects': [
                        'Human Anatomy and Physiology II', 'Pharmaceutical Organic Chemistry I',
                        'Biochemistry', 'Pathophysiology', 'Environmental Sciences',
                        'Pharmaceutics II', 'Pharmaceutical Analysis II', 'Microbiology'
                    ]
                },
                {
                    'name': 'Semester 3', 'number': 3,
                    'subjects': [
                        'Pharmaceutical Organic Chemistry II', 'Physical Pharmaceutics I',
                        'Pharmaceutical Microbiology', 'Pharmaceutical Engineering',
                        'Pharmacognosy and Phytochemistry I', 'Pharmaceutical Analysis III',
                        'Pharmaceutical Jurisprudence', 'Biopharmaceutics and Pharmacokinetics'
                    ]
                },
                {
                    'name': 'Semester 4', 'number': 4,
                    'subjects': [
                        'Pharmaceutical Organic Chemistry III', 'Medicinal Chemistry I',
                        'Physical Pharmaceutics II', 'Pharmacology I',
                        'Pharmacognosy and Phytochemistry II', 'Pharmaceutical Biotechnology',
                        'Pharmaceutical Marketing', 'Biostatistics and Research Methodology'
                    ]
                },
                {
                    'name': 'Semester 5', 'number': 5,
                    'subjects': [
                        'Medicinal Chemistry II', 'Industrial Pharmacy I',
                        'Pharmacology II', 'Pharmacognosy and Phytochemistry III',
                        'Pharmaceutical Biotechnology', 'Pharmaceutical Quality Assurance',
                        'Clinical Research', 'Pharmaceutical Regulatory Science'
                    ]
                },
                {
                    'name': 'Semester 6', 'number': 6,
                    'subjects': [
                        'Medicinal Chemistry III', 'Industrial Pharmacy II',
                        'Pharmacology III', 'Herbal Drug Technology',
                        'Pharmaceutical Technology', 'Novel Drug Delivery System',
                        'Pharmacovigilance', 'Pharmaceutical Management'
                    ]
                },
                {
                    'name': 'Semester 7', 'number': 7,
                    'subjects': [
                        'Instrumental Methods of Analysis', 'Industrial Pharmacy III',
                        'Pharmacy Practice', 'Pharmaceutical Biotechnology',
                        'Biostatistics and Research Methodology', 'Pharmacoeconomics',
                        'Project Work', 'Seminar'
                    ]
                },
                {
                    'name': 'Semester 8', 'number': 8,
                    'subjects': [
                        'Bioavailability and Bioequivalence', 'Pharmaceutical Technology',
                        'Clinical Pharmacy', 'Pharmaceutical Care',
                        'Hospital and Community Pharmacy', 'Pharmaceutical Validation',
                        'Project Work', 'Industrial Training'
                    ]
                }
            ]
        elif 'B.Pharm LE' in course.title:
            # B.Pharm LE 3 years (6 semesters)
            semesters_data = [
                {
                    'name': 'Semester 3', 'number': 3,
                    'subjects': [
                        'Pharmaceutical Organic Chemistry', 'Physical Pharmaceutics',
                        'Pharmaceutical Microbiology', 'Pharmaceutical Engineering',
                        'Pharmacognosy and Phytochemistry', 'Pharmaceutical Analysis',
                        'Pharmaceutical Jurisprudence', 'Biopharmaceutics and Pharmacokinetics'
                    ]
                },
                {
                    'name': 'Semester 4', 'number': 4,
                    'subjects': [
                        'Medicinal Chemistry', 'Physical Pharmaceutics II',
                        'Pharmacology', 'Pharmacognosy and Phytochemistry II',
                        'Pharmaceutical Biotechnology', 'Pharmaceutical Marketing',
                        'Biostatistics and Research Methodology', 'Clinical Research'
                    ]
                },
                {
                    'name': 'Semester 5', 'number': 5,
                    'subjects': [
                        'Industrial Pharmacy', 'Advanced Pharmacology',
                        'Pharmaceutical Quality Assurance', 'Herbal Drug Technology',
                        'Pharmaceutical Technology', 'Clinical Pharmacy',
                        'Pharmacovigilance', 'Pharmaceutical Management'
                    ]
                },
                {
                    'name': 'Semester 6', 'number': 6,
                    'subjects': [
                        'Novel Drug Delivery System', 'Pharmacy Practice',
                        'Hospital and Community Pharmacy', 'Pharmaceutical Care',
                        'Bioavailability and Bioequivalence', 'Project Work',
                        'Industrial Training', 'Seminar'
                    ]
                }
            ]
        elif 'B.Sc. Nursing' in course.title:
            # B.Sc. Nursing 4 years (8 semesters)
            semesters_data = [
                {
                    'name': 'Semester 1', 'number': 1,
                    'subjects': [
                        'Anatomy', 'Physiology', 'Nutrition and Biochemistry',
                        'Nursing Foundation', 'Psychology', 'Sociology',
                        'English', 'Computer Applications'
                    ]
                },
                {
                    'name': 'Semester 2', 'number': 2,
                    'subjects': [
                        'Microbiology', 'Pathology', 'Pharmacology',
                        'Medical Surgical Nursing I', 'Community Health Nursing I',
                        'Communication and Educational Technology', 'Nursing Research and Statistics',
                        'Environmental Science'
                    ]
                },
                {
                    'name': 'Semester 3', 'number': 3,
                    'subjects': [
                        'Medical Surgical Nursing II', 'Child Health Nursing',
                        'Mental Health Nursing', 'Community Health Nursing II',
                        'Nursing Management', 'Nursing Education',
                        'Health Economics', 'Legal and Ethical Issues in Nursing'
                    ]
                },
                {
                    'name': 'Semester 4', 'number': 4,
                    'subjects': [
                        'Medical Surgical Nursing III', 'Obstetric and Gynecological Nursing',
                        'Pediatric Nursing', 'Psychiatric Nursing',
                        'Community Health Nursing III', 'Nursing Research',
                        'Professional Trends and Adjustment', 'Emergency and Critical Care Nursing'
                    ]
                },
                {
                    'name': 'Semester 5', 'number': 5,
                    'subjects': [
                        'Medical Surgical Nursing IV', 'Midwifery and Obstetrical Nursing',
                        'Child Health Nursing II', 'Mental Health Nursing II',
                        'Community Health Nursing IV', 'Nursing Administration',
                        'Clinical Specialization', 'Research Project'
                    ]
                },
                {
                    'name': 'Semester 6', 'number': 6,
                    'subjects': [
                        'Medical Surgical Nursing V', 'Advanced Obstetrical Nursing',
                        'Advanced Pediatric Nursing', 'Advanced Psychiatric Nursing',
                        'Advanced Community Health Nursing', 'Quality Assurance in Nursing',
                        'Clinical Teaching', 'Dissertation'
                    ]
                },
                {
                    'name': 'Semester 7', 'number': 7,
                    'subjects': [
                        'Nursing Leadership and Management', 'Advanced Clinical Practice',
                        'Health Care Quality and Safety', 'Evidence-Based Practice',
                        'Professional Development', 'Clinical Internship',
                        'Research Methodology', 'Thesis Work'
                    ]
                },
                {
                    'name': 'Semester 8', 'number': 8,
                    'subjects': [
                        'Advanced Nursing Practice', 'Healthcare Policy and Planning',
                        'Nursing Informatics', 'International Nursing',
                        'Professional Ethics', 'Comprehensive Clinical Training',
                        'Thesis Defense', 'Internship Completion'
                    ]
                }
            ]
        elif 'B.Sc. Microbiology' in course.title:
            # B.Sc. Microbiology 3 years (6 semesters)
            semesters_data = [
                {
                    'name': 'Semester 1', 'number': 1,
                    'subjects': [
                        'General Microbiology', 'Cell Biology', 'Biochemistry',
                        'Organic Chemistry', 'Mathematics', 'Physics',
                        'English', 'Environmental Science'
                    ]
                },
                {
                    'name': 'Semester 2', 'number': 2,
                    'subjects': [
                        'Bacteriology', 'Molecular Biology', 'Genetics',
                        'Biostatistics', 'Immunology', 'Microbial Physiology',
                        'Computer Applications', 'Research Methodology'
                    ]
                },
                {
                    'name': 'Semester 3', 'number': 3,
                    'subjects': [
                        'Virology', 'Mycology', 'Parasitology',
                        'Clinical Microbiology', 'Food Microbiology', 'Microbial Genetics',
                        'Biotechnology', 'Bioethics'
                    ]
                },
                {
                    'name': 'Semester 4', 'number': 4,
                    'subjects': [
                        'Medical Microbiology', 'Industrial Microbiology', 'Environmental Microbiology',
                        'Microbial Biotechnology', 'Bioinformatics', 'Quality Control',
                        'Pharmaceutical Microbiology', 'Project Work'
                    ]
                },
                {
                    'name': 'Semester 5', 'number': 5,
                    'subjects': [
                        'Applied Microbiology', 'Microbial Ecology', 'Fermentation Technology',
                        'Enzyme Technology', 'Microbial Pathogenesis', 'Diagnostic Microbiology',
                        'Entrepreneurship', 'Seminar'
                    ]
                },
                {
                    'name': 'Semester 6', 'number': 6,
                    'subjects': [
                        'Advanced Microbiology', 'Microbial Diversity', 'Biotechnology Applications',
                        'Microbial Safety', 'Research Project', 'Industrial Training',
                        'Comprehensive Viva', 'Dissertation'
                    ]
                }
            ]
        elif 'D.Pharm' in course.title:
            # D.Pharm 2 years (4 semesters)
            semesters_data = [
                {
                    'name': 'Semester 1', 'number': 1,
                    'subjects': [
                        'Pharmaceutics I', 'Pharmaceutical Chemistry I', 'Pharmacognosy',
                        'Biochemistry and Clinical Pathology', 'Human Anatomy and Physiology',
                        'Health Education and Community Pharmacy'
                    ]
                },
                {
                    'name': 'Semester 2', 'number': 2,
                    'subjects': [
                        'Pharmaceutics II', 'Pharmaceutical Chemistry II', 'Pharmacology and Toxicology',
                        'Pharmaceutical Jurisprudence', 'Drug Store and Business Management',
                        'Hospital and Clinical Pharmacy'
                    ]
                }
            ]
        elif 'M.Pharm' in course.title:
            # M.Pharm 2 years (4 semesters)
            semesters_data = [
                {
                    'name': 'Semester 1', 'number': 1,
                    'subjects': [
                        'Advanced Pharmaceutics', 'Modern Pharmaceutical Analytical Techniques',
                        'Regulatory Science', 'Research Methodology and Biostatistics',
                        'Pharmacokinetics and Pharmacodynamics', 'Pharmaceutical Technology'
                    ]
                },
                {
                    'name': 'Semester 2', 'number': 2,
                    'subjects': [
                        'Novel Drug Delivery Systems', 'Advanced Biopharmaceutics',
                        'Pharmaceutical Biotechnology', 'Product Development',
                        'Pharmaceutical Quality Assurance', 'Seminar and Assignment'
                    ]
                },
                {
                    'name': 'Semester 3', 'number': 3,
                    'subjects': [
                        'Dissertation', 'Advanced Industrial Pharmacy',
                        'Pharmaceutical Process Validation', 'Advanced Instrumental Analysis',
                        'Pharmaceutical Marketing and Management', 'Literature Review'
                    ]
                },
                {
                    'name': 'Semester 4', 'number': 4,
                    'subjects': [
                        'Dissertation Continuation', 'Pharmaceutical Plant Design',
                        'Advanced Drug Delivery', 'Clinical Research and Pharmacovigilance',
                        'Comprehensive Viva', 'Thesis Defense'
                    ]
                }
            ]
        elif 'M.Sc.' in course.title:
            # M.Sc. 2 years (4 semesters)
            if 'Pharmaceutical Chemistry' in course.title:
                semesters_data = [
                    {
                        'name': 'Semester 1', 'number': 1,
                        'subjects': [
                            'Advanced Organic Chemistry', 'Medicinal Chemistry',
                            'Pharmaceutical Analysis', 'Spectroscopic Methods',
                            'Computer Applications in Chemistry', 'Research Methodology'
                        ]
                    },
                    {
                        'name': 'Semester 2', 'number': 2,
                        'subjects': [
                            'Drug Design and Development', 'Advanced Analytical Chemistry',
                            'Pharmaceutical Biotechnology', 'Quality Control and Assurance',
                            'Pharmacokinetics', 'Seminar and Assignment'
                        ]
                    },
                    {
                        'name': 'Semester 3', 'number': 3,
                        'subjects': [
                            'Dissertation', 'Advanced Instrumental Methods',
                            'Pharmaceutical Chemistry Research', 'Drug Metabolism',
                            'Regulatory Affairs', 'Literature Review'
                        ]
                    },
                    {
                        'name': 'Semester 4', 'number': 4,
                        'subjects': [
                            'Dissertation Continuation', 'Advanced Drug Analysis',
                            'Pharmaceutical Marketing', 'Clinical Chemistry',
                            'Comprehensive Viva', 'Thesis Defense'
                        ]
                    }
                ]
            else:  # M.Sc. Microbiology
                semesters_data = [
                    {
                        'name': 'Semester 1', 'number': 1,
                        'subjects': [
                            'Advanced Microbiology', 'Molecular Biology',
                            'Microbial Genetics', 'Immunology',
                            'Biostatistics', 'Research Methodology'
                        ]
                    },
                    {
                        'name': 'Semester 2', 'number': 2,
                        'subjects': [
                            'Applied Microbiology', 'Biotechnology',
                            'Virology', 'Medical Microbiology',
                            'Environmental Microbiology', 'Seminar and Assignment'
                        ]
                    },
                    {
                        'name': 'Semester 3', 'number': 3,
                        'subjects': [
                            'Dissertation', 'Advanced Biotechnology',
                            'Microbial Ecology', 'Industrial Microbiology',
                            'Bioinformatics', 'Literature Review'
                        ]
                    },
                    {
                        'name': 'Semester 4', 'number': 4,
                        'subjects': [
                            'Dissertation Continuation', 'Fermentation Technology',
                            'Pharmaceutical Microbiology', 'Advanced Diagnostics',
                            'Comprehensive Viva', 'Thesis Defense'
                        ]
                    }
                ]
        
        # Create semesters and subjects
        for sem_data in semesters_data:
            semester = Semester.objects.create(
                course=course,
                name=sem_data['name'],
                number=sem_data['number']
            )
            
            for i, subject_name in enumerate(sem_data['subjects'], 1):
                Subject.objects.create(
                    semester=semester,
                    code=f"{course.slug.upper()[:3]}{sem_data['number']}{i:02d}",
                    name=subject_name,
                    credits=3 if 'Project' not in subject_name and 'Training' not in subject_name else 6,
                    description=f"Comprehensive study of {subject_name.lower()} as part of the {course.title} curriculum."
                )
    
    def _create_career_prospects(self, course):
        """Create career prospects for the course"""
        # Clear existing career prospects
        course.career_prospects.all().delete()
        
        if 'Pharm' in course.title:
            prospects = [
                {
                    'title': 'Community Pharmacist',
                    'description': 'Work in retail pharmacies providing medication dispensing, patient counseling, and healthcare services to the community.',
                    'salary_range': '₹3-8 LPA'
                },
                {
                    'title': 'Hospital Pharmacist',
                    'description': 'Manage hospital pharmacy operations, clinical pharmacy services, and collaborate with healthcare teams.',
                    'salary_range': '₹4-10 LPA'
                },
                {
                    'title': 'Pharmaceutical Research Scientist',
                    'description': 'Conduct research and development of new drugs, formulations, and pharmaceutical technologies.',
                    'salary_range': '₹6-15 LPA'
                },
                {
                    'title': 'Regulatory Affairs Specialist',
                    'description': 'Ensure compliance with pharmaceutical regulations and manage drug approval processes.',
                    'salary_range': '₹5-12 LPA'
                },
                {
                    'title': 'Quality Control Analyst',
                    'description': 'Perform quality testing and analysis of pharmaceutical products to ensure safety and efficacy.',
                    'salary_range': '₹3-8 LPA'
                },
                {
                    'title': 'Medical Representative',
                    'description': 'Promote pharmaceutical products to healthcare professionals and manage client relationships.',
                    'salary_range': '₹3-7 LPA'
                }
            ]
        elif 'Nursing' in course.title:
            prospects = [
                {
                    'title': 'Staff Nurse',
                    'description': 'Provide direct patient care in hospitals, clinics, and healthcare facilities.',
                    'salary_range': '₹3-6 LPA'
                },
                {
                    'title': 'Nurse Manager',
                    'description': 'Supervise nursing staff, manage patient care units, and ensure quality healthcare delivery.',
                    'salary_range': '₹5-10 LPA'
                },
                {
                    'title': 'Clinical Nurse Specialist',
                    'description': 'Provide specialized nursing care in areas like ICU, emergency, pediatrics, or surgery.',
                    'salary_range': '₹4-8 LPA'
                },
                {
                    'title': 'Public Health Nurse',
                    'description': 'Work in community health programs, disease prevention, and health promotion initiatives.',
                    'salary_range': '₹3-7 LPA'
                },
                {
                    'title': 'Nurse Educator',
                    'description': 'Teach nursing students and conduct continuing education programs for healthcare professionals.',
                    'salary_range': '₹4-9 LPA'
                },
                {
                    'title': 'Healthcare Administrator',
                    'description': 'Manage healthcare facilities, nursing departments, and healthcare quality improvement programs.',
                    'salary_range': '₹6-12 LPA'
                }
            ]
        elif 'Microbiology' in course.title:
            prospects = [
                {
                    'title': 'Medical Laboratory Technologist',
                    'description': 'Perform diagnostic tests and analyze samples in clinical laboratories.',
                    'salary_range': '₹3-6 LPA'
                },
                {
                    'title': 'Research Scientist',
                    'description': 'Conduct research in microbiology, biotechnology, and related fields.',
                    'salary_range': '₹4-10 LPA'
                },
                {
                    'title': 'Quality Control Microbiologist',
                    'description': 'Ensure product safety and quality in pharmaceutical, food, and biotechnology industries.',
                    'salary_range': '₹3-8 LPA'
                },
                {
                    'title': 'Biotechnology Specialist',
                    'description': 'Work in biotechnology companies developing new products and processes.',
                    'salary_range': '₹4-9 LPA'
                },
                {
                    'title': 'Environmental Microbiologist',
                    'description': 'Study environmental impact of microorganisms and develop solutions for environmental issues.',
                    'salary_range': '₹3-7 LPA'
                },
                {
                    'title': 'Food Safety Inspector',
                    'description': 'Ensure food safety standards and conduct microbial testing in food industry.',
                    'salary_range': '₹3-6 LPA'
                }
            ]
        
        for prospect in prospects:
            CareerProspect.objects.create(
                course=course,
                title=prospect['title'],
                description=prospect['description'],
                salary_range=prospect['salary_range']
            )
    
    def _create_admission_steps(self, course):
        """Create admission steps for the course"""
        # Clear existing admission steps
        course.admission_steps.all().delete()
        
        steps = [
            {
                'step_number': 1,
                'title': 'Application Submission',
                'description': 'Submit online application form with required documents and application fee.'
            },
            {
                'step_number': 2,
                'title': 'Entrance Examination',
                'description': 'Appear for entrance examination or qualifying test as per course requirements.'
            },
            {
                'step_number': 3,
                'title': 'Merit List & Counseling',
                'description': 'Check merit list and participate in counseling process for seat allocation.'
            },
            {
                'step_number': 4,
                'title': 'Document Verification',
                'description': 'Submit original documents for verification and complete admission formalities.'
            },
            {
                'step_number': 5,
                'title': 'Fee Payment',
                'description': 'Pay admission fees and complete enrollment process to confirm admission.'
            }
        ]
        
        for step in steps:
            AdmissionStep.objects.create(
                course=course,
                step_number=step['step_number'],
                title=step['title'],
                description=step['description']
            )
    
    def _create_recruiters(self, course):
        """Create recruiters for the course"""
        # Clear existing recruiters
        course.recruiters.all().delete()
        
        if 'Pharm' in course.title:
            recruiters = [
                'Sun Pharmaceutical Industries', 'Cipla Limited', 'Dr. Reddy\'s Laboratories',
                'Aurobindo Pharma', 'Lupin Limited', 'Torrent Pharmaceuticals',
                'Cadila Healthcare', 'Glenmark Pharmaceuticals', 'Biocon Limited',
                'Divis Laboratories', 'Apollo Hospitals', 'Fortis Healthcare',
                'Max Healthcare', 'AIIMS', 'Government Hospitals'
            ]
        elif 'Nursing' in course.title:
            recruiters = [
                'Apollo Hospitals', 'Fortis Healthcare', 'Max Healthcare',
                'AIIMS', 'Government Hospitals', 'Manipal Hospitals',
                'Columbia Asia', 'Narayana Health', 'Aster DM Healthcare',
                'Global Hospitals', 'WHO', 'UNICEF',
                'Red Cross Society', 'Ministry of Health', 'State Health Departments'
            ]
        elif 'Microbiology' in course.title:
            recruiters = [
                'Biocon Limited', 'Serum Institute of India', 'Bharat Biotech',
                'Indian Immunologicals', 'Haffkine Institute', 'CSIR Labs',
                'ICMR', 'Government Laboratories', 'Pharmaceutical Companies',
                'Food Processing Industries', 'Water Treatment Plants', 'Environmental Agencies',
                'Biotechnology Companies', 'Research Institutions', 'Quality Control Labs'
            ]
        
        for recruiter_name in recruiters:
            Recruiter.objects.create(
                course=course,
                name=recruiter_name
            )
    
    def _create_why_join(self, course):
        """Create why join points for the course"""
        # Clear existing why join points
        course.why_join.all().delete()
        
        if 'Pharm' in course.title:
            why_join_points = [
                {
                    'title': 'State-of-the-Art Laboratories',
                    'description': 'Modern pharmaceutical laboratories equipped with latest instruments and technology for hands-on learning.'
                },
                {
                    'title': 'Industry Partnerships',
                    'description': 'Strong collaborations with leading pharmaceutical companies for internships and placements.'
                },
                {
                    'title': 'Experienced Faculty',
                    'description': 'Learn from highly qualified faculty with extensive industry and research experience.'
                },
                {
                    'title': 'Clinical Training',
                    'description': 'Comprehensive clinical training in hospitals and community pharmacies for practical exposure.'
                },
                {
                    'title': 'Research Opportunities',
                    'description': 'Opportunities to participate in cutting-edge pharmaceutical research and development projects.'
                }
            ]
        elif 'Nursing' in course.title:
            why_join_points = [
                {
                    'title': 'Clinical Excellence',
                    'description': 'Comprehensive clinical training in multi-specialty hospitals and healthcare facilities.'
                },
                {
                    'title': 'Advanced Simulation Labs',
                    'description': 'State-of-the-art nursing simulation laboratories for skill development and practice.'
                },
                {
                    'title': 'Compassionate Care Focus',
                    'description': 'Emphasis on holistic patient care, ethics, and professional nursing values.'
                },
                {
                    'title': 'Global Opportunities',
                    'description': 'International nursing career opportunities and global healthcare exposure.'
                },
                {
                    'title': 'Community Impact',
                    'description': 'Opportunities to make a meaningful difference in community health and patient care.'
                }
            ]
        elif 'Microbiology' in course.title:
            why_join_points = [
                {
                    'title': 'Advanced Research Facilities',
                    'description': 'Well-equipped microbiology laboratories with modern instruments and biosafety facilities.'
                },
                {
                    'title': 'Diverse Career Paths',
                    'description': 'Multiple career opportunities in healthcare, biotechnology, research, and environmental sectors.'
                },
                {
                    'title': 'Hands-on Experience',
                    'description': 'Extensive practical training in microbial isolation, identification, and characterization techniques.'
                },
                {
                    'title': 'Industry Relevance',
                    'description': 'Curriculum designed to meet current industry needs and emerging biotechnology trends.'
                },
                {
                    'title': 'Research Innovation',
                    'description': 'Opportunities to work on innovative research projects in microbiology and biotechnology.'
                }
            ]
        
        for point in why_join_points:
            WhyJoin.objects.create(
                course=course,
                title=point['title'],
                description=point['description']
            )
    
    def _create_testimonials(self, course):
        """Create testimonials for the course"""
        # Clear existing testimonials
        course.testimonials.all().delete()
        
        if 'Pharm' in course.title:
            testimonials = [
                {
                    'student_name': 'Priya Sharma',
                    'batch': '2022',
                    'testimonial': 'The B.Pharm program at Roorkee College provided me with excellent theoretical knowledge and practical skills. The faculty support and industry exposure helped me secure a position at a leading pharmaceutical company.',
                    'current_position': 'Quality Control Analyst, Cipla Limited'
                },
                {
                    'student_name': 'Rahul Kumar',
                    'batch': '2021',
                    'testimonial': 'The comprehensive curriculum and state-of-the-art laboratories gave me confidence to pursue my career in pharmaceutical research. The college\'s industry connections were invaluable for my placement.',
                    'current_position': 'Research Associate, Dr. Reddy\'s Laboratories'
                }
            ]
        elif 'Nursing' in course.title:
            testimonials = [
                {
                    'student_name': 'Anjali Patel',
                    'batch': '2022',
                    'testimonial': 'The nursing program provided excellent clinical training and prepared me to be a compassionate healthcare professional. The faculty mentorship was exceptional throughout my journey.',
                    'current_position': 'Staff Nurse, Apollo Hospitals'
                },
                {
                    'student_name': 'Deepak Singh',
                    'batch': '2021',
                    'testimonial': 'The comprehensive nursing education and hands-on clinical experience helped me develop strong patient care skills. I am grateful for the excellent training and support from the faculty.',
                    'current_position': 'ICU Nurse, Fortis Healthcare'
                }
            ]
        elif 'Microbiology' in course.title:
            testimonials = [
                {
                    'student_name': 'Meera Joshi',
                    'batch': '2022',
                    'testimonial': 'The microbiology program provided strong foundation in laboratory techniques and research methodology. The practical exposure and faculty guidance helped me excel in my career.',
                    'current_position': 'Microbiologist, Biocon Limited'
                },
                {
                    'student_name': 'Arjun Reddy',
                    'batch': '2021',
                    'testimonial': 'The comprehensive curriculum and research opportunities in microbiology opened up diverse career paths for me. The college\'s focus on practical learning was exceptional.',
                    'current_position': 'Research Scientist, CSIR-IMTECH'
                }
            ]
        
        for testimonial in testimonials:
            Testimonial.objects.create(
                course=course,
                student_name=testimonial['student_name'],
                batch=testimonial['batch'],
                testimonial=testimonial['testimonial'],
                current_position=testimonial['current_position']
            )