o
    !^h1t                     @   sT   d dl mZ d dlmZmZmZmZmZmZm	Z	m
Z
mZ d dlZG dd deZdS )    )BaseCommand)	CourseSemesterSubjectCareerProspectAdmissionStepDirectAdmission	RecruiterWhyJoinTestimonialNc                   @   sX   e Zd ZdZdd Zdd Zdd Zdd	 Zd
d Zdd Z	dd Z
dd Zdd ZdS )Commandz=Create comprehensive content for Agriculture Sciences coursesc                 O   s   | j | jd g d}tjj|d}|D ]>}| j d|j d | | | 	| | 
| | | | | | | | | | j | jd|j  q| j | jd d S )Nz6Starting to create Agriculture Sciences course content)B.Sc. Agriculture Hons.z!M.Sc. Agriculture (with Agronomy)z%M.Sc. Agriculture (with Horticulture)z(M.Sc. Agriculture (with Plant Pathology)B.Sc. Food TechnologyB.Sc. Nutrition & Dietetics)	title__inzProcessing z...zCompleted content for zBSuccessfully created content for all Agriculture Sciences courses!)stdoutwritestyleSUCCESSr   objectsfiltertitle_create_semesters_and_subjects_create_career_prospects_create_admission_steps_create_direct_admission_create_recruiters_create_why_join_create_testimonials)selfargsoptionsagriculture_course_titlescoursescourse r%   K/var/www/apihucms/courses/management/commands/create_agriculture_content.pyhandle   s   	






zCommand.handlec              	   C   s   d|j v rd}n
d|j v rd}nd}td|d D ]2}tjj||dd| id	\}}| ||}|D ]}tjj||d |d
 |d |d dd q3qdS )z5Create semester structure and subjects for the courseM.Sc.   zB.Sc. Agriculture         namez	Semester )r$   numberdefaultscodecreditsdescription)r0   r1   r2   )semesterr-   r/   N)r   ranger   r   get_or_create_get_subjects_for_semesterr   )r   r$   semester_countsem_numr3   createdsubjectssubject_datar%   r%   r&   r   6   s.   


z&Command._create_semesters_and_subjectsc                 C   s  |j dkrdddddddd	d
dddd	ddddddddddddgddd	dddddddddd	dddddd dd!d"dd#dgd$d%d	d&dd'd(d	d)dd*d+dd,dd-d.dd/dd0d1dd2dgd3d4d	d5dd6d7d	d8dd9d:dd;dd<d=dd>dd?d@ddAdgdB}tdCdDD ]M}dE| dF| dGd	dHddI| dF| dJd	dKddL| dF| dMddNddO| dF| dPddQd|dRk rdS| ndTdF| dUd	dVdg||< qn)|j dWkrwdXdYd	dZdd[d\d	d]dd^d_dd`ddadbddcddddeddfdgdgdhd	diddjdkd	dlddmdnddoddpdqddrddsdtddudgdv}tddwD ]O}dx| dy| dGd	dzdd{| dy| dJd	d|dd}| dy| dMdd~dd| dy| dPddd|dk redS| ndTdy| dUd	ddg||< q%n|j dkrddd	ddddd	ddddddddddddddddddgddd	ddddd	dddddddddddddddddgdv}tddwD ]O}d| d| dGd	ddd| d| dJd	ddd| d| dMdddd| d| dPddd|dk rdS| ndTd| dUd	ddg||< qnd|j v rddd	ddddd	ddddd	ddddddddddddgddd	ddddd	ddddd	ddddddddddddgddd	ddddddddddddddddddddddgdddddddd	dddddddgdB}ntdddd	ddddd	ddddddddddddddddddgi}td|d D ]J}d| dd| dGd	ddd| dd| dJd	ddd| d| dMdddd| d| dPddddS| d| dUdddg||< q||g S )z9Get subjects for a specific semester based on course typer   zIntroduction to AgricultureAGR101   z,Basic concepts and principles of agriculture)r-   r0   r1   r2   zAgricultural BotanyAGR102r)   z)Plant morphology, anatomy, and physiologyzAgricultural ChemistryAGR103z*Chemical principles applied to agriculturezMathematics and StatisticsAGR104z$Mathematical and statistical methodszEnglish and CommunicationAGR105   z$Communication skills for agriculturezSoil ScienceAGR201z*Soil formation, properties, and managementzAgricultural MeteorologyAGR202z"Weather and climate in agriculturezPlant BreedingAGR203z(Principles and methods of plant breedingzAgricultural MicrobiologyAGR204zMicroorganisms in agriculturezAgricultural EconomicsAGR205z"Economic principles in agriculturezCrop ProductionAGR301z+Principles and practices of crop productionHorticultureAGR302zFruit and vegetable productionzPlant PathologyAGR303z#Plant diseases and their management
EntomologyAGR304zInsect pests and their controlzAgricultural EngineeringAGR305zFarm machinery and structuresAgronomyAGR401z$Field crop production and managementzAnimal HusbandryAGR402z#Livestock production and managementzFood TechnologyAGR403z Food processing and preservationzAgricultural MarketingAGR404z"Marketing of agricultural productszFarm ManagementAGR405zFarm planning and management)r,   rB   r=   r)      	   zAdvanced Crop Science AGR01z!Advanced concepts in crop sciencezSpecialized Agriculture 02z"Specialized agricultural practiceszResearch Methods 03z!Agricultural research methodologyzField Work 04zPractical field experiencer*   zProject Work zFinal Project05zResearch project workr   zFood ChemistryFT101z+Chemical composition and properties of foodzFood MicrobiologyFT102zMicroorganisms in food systemszMathematics for Food TechnologyFT103z)Mathematical applications in food sciencezPhysics for Food TechnologyFT104z&Physical principles in food processingzCommunication SkillsFT105zTechnical communication skillszFood ProcessingFT201z)Principles and methods of food processingzFood PreservationFT202zFood preservation techniqueszNutrition and DieteticsFT203zNutritional aspects of foodzFood PackagingFT204z$Food packaging materials and methodszStatistics for Food ScienceFT205z$Statistical analysis in food science)r,   rB      zAdvanced Food Technology FTz!Advanced food technology conceptszFood Quality Control z Quality control in food industryzFood Safety zFood safety and regulationszIndustry Training z Industrial training and exposurer+   z Research and development projectr   zHuman PhysiologyND101z Human body systems and functionsBiochemistryND102z&Chemical processes in living organismszFood ScienceND103zScientific study of foodND104ND105zEffective communication skillszNutrition ScienceND201zPrinciples of human nutrition	DieteticsND202z'Diet planning and therapeutic nutritionzFood CompositionND203z Nutritional composition of foodszCommunity NutritionND204zNutrition in community settingszResearch MethodologyND205zResearch methods in nutritionzClinical Nutrition NDzClinical aspects of nutritionzTherapeutic Dietetics zTherapeutic diet planningzNutrition Counseling z"Counseling techniques in nutritionzClinical Training zPractical clinical experiencezResearch project in nutritionr(   zAdvanced Research MethodsMSC101zAdvanced research methodologyzStatistical AnalysisMSC102zAdvanced statistical methodszSpecialization Core 1MSC103z$Core concepts in specialization areazLiterature ReviewMSC104zComprehensive literature reviewz	Seminar 1MSC105z%Seminar presentations and discussionszSpecialization Core 2MSC201z Advanced specialization conceptszLaboratory TechniquesMSC202zAdvanced laboratory methodszField StudiesMSC203z"Field research and data collectionzElective CourseMSC204zSpecialized elective subjectz	Seminar 2MSC205zResearch progress presentationszAdvanced SpecializationMSC301z%Expert-level specialization knowledgezResearch Project 1MSC302zIndependent research projectzData AnalysisMSC303z!Advanced data analysis techniqueszScientific WritingMSC304z"Scientific writing and publicationzComprehensive ExaminationMSC305zComprehensive examinationzThesis ResearchMSC401
   zMaster's thesis researchzThesis WritingMSC402zThesis preparation and writingzThesis DefenseMSC403zThesis defense and presentationr,   zFoundation Course 1GEN101zBasic concepts and principleszFoundation Course 2GEN102zCore subject fundamentalsGEN103zEffective communicationzMathematics/StatisticsGEN104zQuantitative methodszIntroduction to ComputersGEN105zBasic computer skillszAdvanced Course AGENzAdvanced specialized knowledgeBzApplied advanced conceptszPractical Course zHands-on practical experiencez	Elective zSpecialized electivezApplied project work)r   r4   get)r   r$   semester_numsubjects_by_semesterir%   r%   r&   r6   V   s   
&
	(	(	
z"Command._get_subjects_for_semesterc                 C   s  dddddddddd	d
dddddddddddddgddddddddddddddddddddd d!d"dgd#d$d%dd&d'ddd(d)d*dd+d,ddd-d.ddd/d0ddgd1}|j |v rk||j  }n~d2|j v rd3|j v rd4d5d6dd7d8d9ddd:d;dd<d=d6dd>d?d@dg}nXdA|j v rdBdCdDddEdFd
ddGdHdIddJdKdddLdMdNdg}n7dOdPdQdd7dRdSddTdUdVddWdXdYddZd[d9dg}nd\d]d^dd_d`daddbdcd6ddddedNddfdgd9dg}|D ]}tjj||dh |di |dj dkdl qdmS )nz&Create career prospects for the courseAgricultural Officerz9Government and private sector agricultural advisory rolesu   ₹4-12 LPA)r   r2   salary_rangezFarm Managerz8Managing large-scale farming operations and agribusinessu   ₹5-15 LPAzAgricultural Researcherz4Research in agricultural institutes and universitiesu   ₹6-18 LPAzAgribusiness Managerz0Managing agricultural supply chain and marketingu   ₹8-20 LPAzAgricultural Consultantz4Providing expert advice to farmers and organizationsu   ₹6-16 LPAzExtension Officerz+Agricultural extension and farmer educationu   ₹4-10 LPAFood Technologistz8Product development and quality control in food industryzQuality Control Managerz*Ensuring food safety and quality standardszFood Safety Officerz0Regulatory compliance and food safety managementu   ₹5-14 LPAzR&D Specialistz*Research and development in food companiesu   ₹7-18 LPAzProduction Managerz#Managing food processing operationszFood Consultantz(Technical consulting for food businessesu   ₹6-15 LPAzClinical Dietitianz*Nutrition therapy in hospitals and clinicsu   ₹3-10 LPAzSports Nutritionistz0Nutrition planning for athletes and sports teamszCommunity Nutritionistz Public health nutrition programsu
   ₹3-9 LPAzNutrition Consultantz%Private practice nutrition counselingzFood Service Managerz$Managing institutional food serviceszWellness Coachz%Health and wellness coaching services)r   r   r   r(   rO   zSenior Agronomistz%Advanced crop management and researchu   ₹8-25 LPAResearch Scientistz1Agricultural research in institutes and companiesu   ₹10-30 LPAz$Expert consulting in crop productionu   ₹12-35 LPAzProfessor/Lecturerz!Teaching in agricultural collegeszProduct Managerz.Agricultural product development and marketingu   ₹15-40 LPArI   zHorticulture Specialistz(Expert in fruit and vegetable productionu   ₹8-22 LPAzLandscape DesignerzGarden and landscape planningzGreenhouse Managerz&Managing protected cultivation systemsu   ₹10-25 LPAzPost-Harvest Specialistz&Post-harvest technology and managementzAgricultural Entrepreneurz"Starting horticultural enterprisesVariablezPlant Pathologistz'Disease diagnosis and management expertu   ₹8-24 LPAz&Plant disease research and developmentu   ₹10-28 LPAzRegulatory Affairs Specialistz,Pesticide and disease management regulationsu   ₹12-30 LPAzTechnical Managerz+Technical support in agrochemical companiesu   ₹15-35 LPAzUniversity Professorz%Teaching and research in universitieszIndustry Professionalz&Specialized roles in relevant industryu   ₹4-15 LPAManagerz%Management positions in organizationsu   ₹6-20 LPA
ConsultantzExpert consulting servicesEntrepreneurzStarting own ventureszSenior SpecialistzExpert roles in specializationr   r2   r   )r2   r   r$   r   r/   N)r   r   r   r5   )r   r$   career_prospects_data	prospectsprospect_datar%   r%   r&   r      sx   






	





	



















	




	



z Command._create_career_prospectsc                 C   s   dddddddddd	d
dddddddddddddddddddddddddg	}|D ]}t jj||d |d |d d d! q1d"S )#z%Create admission steps for the courser,   zCheck Eligibilityz7Verify academic qualifications and eligibility criteria)stepr   r2   rB   zOnline Applicationz+Fill and submit the online application formr=   zDocument Submissionz*Upload required documents and certificatesr)   zApplication Feez"Pay the application processing feerU   zEntrance Testz,Appear for entrance examination or interviewr+   z
Merit Listz%Check merit list and admission statusrg   zAdmission Confirmationz Confirm admission by paying feesr*   zDocument Verificationz+Physical verification of original documentsrV   Orientationz(Attend orientation and induction programr   r   r2   r   r2   )r$   orderr/   N)r   r   r5   )r   r$   steps	step_datar%   r%   r&   r   :  s&   








zCommand._create_admission_stepsc                 C   s   t jj|dddd dS )z#Create direct admission informationTzDirect admission process based on academic performance and eligibility criteria. Contact admissions office for direct admission guidance.)is_availabler2   )r$   r/   N)r   r   r5   )r   r$   r%   r%   r&   r   S  s   
z Command._create_direct_admissionc                 C   s>   g d}t |tdt|}|D ]}tjj||i d qdS )z Create recruiters for the course)ITC LimitedzNestle IndiazHindustan UnileverzBritannia IndustrieszParle ProductszAmul (GCMMF)zMother DairyzPepsiCo IndiazCoca-Cola IndiazDabur IndiazMahindra AgribusinesszUPL LimitedzBayer CropSciencezSyngenta Indiaz
BASF IndiazTata ChemicalszCoromandel InternationalzGodrej AgrovetzRallis IndiazDhanuka AgritechIFFCOzKrishak Bharati CooperativezNational Seeds CorporationzState Farm CorporationzAgricultural Development BankzZydus WellnesszMarico LimitedzEmami Agrotech   r$   r-   r/   N)randomsampleminlenr	   r   r5   )r   r$   agriculture_recruitersselected_recruitersrecruiter_namer%   r%   r&   r   ^  s   
zCommand._create_recruitersc              
   C   sp   ddddddddddd	dd
dddddddddddg}|D ]}t jj||d d|d id q$dS )z%Create why join points for the coursezExpert FacultyzDLearn from experienced faculty with industry and research backgroundr   zModern Laboratoriesz5State-of-the-art laboratories and research facilitieszField Trainingz<Extensive hands-on experience in farms and research stationszIndustry Partnershipsz8Strong connections with agricultural and food industrieszResearch Opportunitiesz>Opportunities to participate in cutting-edge research projectszCareer Supportz<Dedicated placement cell with excellent industry connectionszPractical Learningz:Emphasis on practical training and real-world applicationszInnovation Focusz:Encouraging innovation and entrepreneurship in agriculturer   r2   r   N)r
   r   r5   )r   r$   common_points
point_datar%   r%   r&   r   u  s"   zCommand._create_why_joinc              	   C   s   dddd|j  ddddd	d
|j  dddddd|j  dddddd|j  ddg}|D ]}tjj||d |d |d |d dd q0dS )z"Create testimonials for the coursezRavi Sharmar   zDepartment of AgriculturezThe z program provided me with comprehensive knowledge and practical skills. The field training and research opportunities helped me build a strong foundation in agriculture.)r-   positioncompanycontentzPriya Patelr   r   z-Excellent faculty and modern facilities. The za program prepared me well for the challenges in the food industry. Highly recommend this program.z
Amit Kumarr   zICAR Research Institutez&The research-oriented approach of the zo program helped me develop critical thinking and problem-solving skills. The practical training was invaluable.zSneha SinghNutritionistzApollo Hospitalsz program provided excellent theoretical knowledge combined with practical experience. The clinical training prepared me for my career in healthcare.r-   r   r   r   )r   r   r   r   N)r   r   r   r5   )r   r$   testimonialstestimonial_datar%   r%   r&   r     s>   zCommand._create_testimonialsN)__name__
__module____qualname__helpr'   r   r6   r   r   r   r   r   r   r%   r%   r%   r&   r      s    +  Mr   )django.core.management.baser   courses.modelsr   r   r   r   r   r   r	   r
   r   r   r   r%   r%   r%   r&   <module>   s    ,