o j)^hmC@sddlZddlmZddlmZddlmZddlZddlm Z ddl m Z ddl m Z mZmZmZmZmZmZmZmZmZmZmZmZmZmZddlmZGd d d eZdS) N) BaseCommand) ContentFile)slugify)BytesIO)settings)CourseCourseEligibility CourseFee FeeDetail HostelFeeSemesterSubjectCareerProspect AdmissionStepDirectAdmission RecruiterWhyJoinCourseHighlight CourseImage Testimonial)Collegec@s8eZdZdZddZddZddZdd Zd d Zd S) CommandzLSeeds the database with courses for Roorkee College of Agricultural Sciencesc sjjdztjjdd}jjd|jWntjy6jj dYdSwt j t j tjdddfd d }d d d dddddddddddddddddddddddd d!d"dd#d$d%d!d&dg}|D]~}t|d'}gd(}|t|d't|} d)| } || d*|} tjj||d'|d+|d,|d-|d.dd/\} } | r| | _| | rшjjd0| jnjjd1| j| || || | |qxdS)2Nz.Starting to seed Agricultural Sciences coursesz'roorkee-college-of-agriculture-sciences)slugzFound college: zJAgricultural Sciences college not found. Please ensure the college exists.zcourses/bannersT)exist_okc sz)t|}|jdkr|d}t|j|d}|WSjjd|WdSt yK}zjj dt |WYd}~dSd}~ww)Nz.jpg)namezFailed to download image from zError downloading image: ) requestsget status_codercontentstdoutwritestyleWARNING ExceptionERRORstr)url field_nameresponsefilename image_contenteselfI/var/www/apihucms/courses/management/commands/seed_agriculture_courses.pysave_image_from_url"s   z+Command.handle..save_image_from_urlzB.Sc. Agriculture Hons.zComprehensive undergraduate program in agricultural sciences with honors, covering crop production, soil science, and sustainable farming practices.aThe B.Sc. Agriculture Honours program is designed to provide comprehensive knowledge and practical skills in agricultural sciences. Students will learn about crop production, soil management, plant breeding, agricultural economics, and sustainable farming practices. The program combines theoretical knowledge with extensive field work, laboratory sessions, and practical training at agricultural farms. Graduates will be equipped to address modern agricultural challenges and contribute to food security and sustainable development.z4 Years (8 Semesters)zAgricultural Sciences)titleshort_descriptionoverviewdurationcategoryz!M.Sc. Agriculture (with Agronomy)zAdvanced postgraduate program specializing in agronomy, focusing on crop science, soil management, and agricultural production systems.a The M.Sc. Agriculture with Agronomy specialization is an advanced postgraduate program that focuses on the science and practice of crop production and soil management. Students will study advanced topics in crop physiology, soil fertility, weed management, precision agriculture, and sustainable farming systems. The program includes extensive research work, field experiments, and thesis preparation. Graduates will be prepared for leadership roles in agricultural research, extension services, and agribusiness management.z2 Years (4 Semesters)z Agricultural Sciences - Agronomyz%M.Sc. Agriculture (with Horticulture)zSpecialized postgraduate program in horticulture, covering fruit and vegetable production, ornamental plants, and horticultural technology.a/The M.Sc. Agriculture with Horticulture specialization provides advanced knowledge in the cultivation of fruits, vegetables, flowers, and ornamental plants. Students will learn about plant breeding, post-harvest technology, greenhouse management, landscape design, and commercial horticulture. The program emphasizes practical training in modern horticultural techniques, biotechnology applications, and sustainable production methods. Graduates will be equipped for careers in horticultural research, commercial production, and agricultural entrepreneurship.z$Agricultural Sciences - Horticulturez(M.Sc. Agriculture (with Plant Pathology)zAdvanced program focusing on plant diseases, their diagnosis, management, and prevention in agricultural and horticultural crops.aKThe M.Sc. Agriculture with Plant Pathology specialization is designed to train students in the identification, diagnosis, and management of plant diseases. The program covers fungal, bacterial, viral, and nematode diseases affecting crops, as well as integrated pest management strategies. Students will gain expertise in disease surveillance, diagnostic techniques, biological control methods, and the development of disease-resistant varieties. The curriculum includes extensive laboratory work, field studies, and research projects focused on sustainable disease management practices.z'Agricultural Sciences - Plant PathologyzB.Sc. Food TechnologyzUndergraduate program in food science and technology, covering food processing, preservation, quality control, and food safety.aiThe B.Sc. Food Technology program provides comprehensive training in food science, processing, and technology. Students will learn about food chemistry, microbiology, nutrition, processing techniques, packaging, and quality assurance. The curriculum covers food preservation methods, product development, food safety regulations, and industrial food production. Practical training includes laboratory work, pilot plant operations, and internships in food industries. Graduates will be prepared for careers in food processing companies, quality control laboratories, research institutions, and food service industries.z3 Years (6 Semesters)Food TechnologyzB.Sc. Nutrition & DieteticszUndergraduate program focusing on human nutrition, dietetics, and nutritional health, preparing students for careers in healthcare and nutrition counseling.aThe B.Sc. Nutrition & Dietetics program is designed to provide comprehensive knowledge of human nutrition, food science, and dietetic practice. Students will study biochemistry, physiology, food composition, nutritional assessment, and therapeutic nutrition. The program covers topics such as community nutrition, sports nutrition, clinical dietetics, and nutrition education. Practical training includes clinical rotations, community health programs, and nutrition counseling sessions. Graduates will be qualified to work as nutritionists, dietitians, health educators, and nutrition consultants in hospitals, healthcare centers, sports facilities, and wellness programs.zNutrition & Dieteticsr2)zagriculture,farming,cropszfood,technology,processingznutrition,health,dietzplants,science,researchzsoil,farming,organiczlaboratory,science,researchz&https://source.unsplash.com/1200x600/?banner_r3r4r5r6)rdefaultszCreated course: zUpdated course: )r r!r"SUCCESSrobjectsrr DoesNotExistr%osmakedirspathjoinr MEDIA_ROOTrhashlenrupdate_or_create banner_imagesaver2_create_course_eligibility_create_course_fees_create_hostel_fees_create_course_highlights)r.argsoptionsagriculture_colleger1 courses_data course_datar banner_themestheme banner_urlrEcoursecreatedr/r-r0handles  /       zCommand.handlecCsd|jvr d}d}d}n*d|jvr0d|jvrd}d}d }nd |jvr)d }d}d }n d }d}d}nd}d}d}tjj||||dddS)z*Create eligibility criteria for the courseM.Sc.z_Bachelor's degree in Agriculture, Life Sciences, or related field from a recognized university.z8Minimum 60% aggregate in graduation (55% for SC/ST/OBC).zOUniversity entrance test or national level examination with personal interview.zB.Sc. Agriculturez]10+2 (Senior Secondary) with Physics, Chemistry, Biology/Mathematics from a recognized board.z?Minimum 50% aggregate in 10+2 with PCM/PCB (45% for SC/ST/OBC).z,ICAR AIEEA (UG) or University entrance test.r7z]10+2 (Senior Secondary) with Physics, Chemistry, Mathematics/Biology from a recognized board.z%JEE Main or University entrance test.zQ10+2 (Senior Secondary) with Physics, Chemistry, Biology from a recognized board.z;Minimum 50% aggregate in 10+2 with PCB (45% for SC/ST/OBC).z!NEET or University entrance test.z010+2 (Senior Secondary) from a recognized board.z2Minimum 50% aggregate in 10+2 (45% for SC/ST/OBC).z.Merit-based admission or entrance examination.)academic_qualification minimum_marks entrance_examrSr9N)r2rr;rD)r.rSrO academic_qualrYrZr/r/r0rGs4     z"Command._create_course_eligibilitycCs^d|jvr d}d}nd|jvrd}d}nd|jvrd}d }nd }d }tjj|||d d dS)z#Create fee structure for the courserVu₹1,80,000 per yearz$6,000 per yearzB.Sc. Agricultureu₹1,50,000 per yearz$5,500 per yearr7u₹1,40,000 per yearz$5,000 per yearu₹1,20,000 per yearz$4,500 per year)domestic internationalr[N)r2r r;rD)r.rSrO domestic_feeinternational_feer/r/r0rHs"    zCommand._create_course_feescCstjj|dddddddS)z*Create hostel fee structure for the courseu ₹80,000u ₹20,000u ₹15,000zHostel fees include accommodation, meals, laundry, and basic amenities. AC rooms are available with additional charges. Security deposit is refundable at the time of leaving the hostel.) fee_per_yearac_room_additionalsecurity_depositnotesr[N)r r;rD)r.rSr/r/r0rIs zCommand._create_hostel_feescCsg}d|jvrddddddddd d d dd d ddg}nNd|jvr:ddddddddddddddddg}n2d|jvrVddddd d!d"dd#d$d%dd&d'd(dg}nd)d*d+dd,d-d.dd/d0d1dd2d3d4dg}|D]}tjj||d5|d6|d7d8d9qn|j|jd:d;S)s     D