Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from django.utils import timezone
- from duriancourse.models import Course, CourseBundle, Student, BundleStudent
- from durianuser.models import DurianUser
- from hr.models import Company, CompanyDepartment, CompanyUser, CourseEnroll, CourseBundleEnroll, TestTicketEnroll
- from simulations.models import PretestExamPackage, TestTicket
- company = Company.objects.get(slug="kawasumi")
- course_dict = {
- "33": Course.objects.get(id=33),
- "4": CourseBundle.objects.get(id=4)
- }
- package = PretestExamPackage.objects.get(id=3)
- dept_dict = {}
- for dept in ["A6A", "A6M", "A7", "A9", "W-K", "QC-K", "QC-N", "TS-K", "TS-N", "A3B", "W-N", "PUR-K", "PUR-N", "GA-K", "IT", "QA", "PE-K", "FIN", "GA-N", "LG"]:
- company_dept = CompanyDepartment.objects.create(company=company, name=dept)
- dept_dict[dept] = company_dept
-
- data_list = [{'code': 'k0860',
- 'employee_name': 'Ms. Kassarin Sriklang',
- 'dept': 'A6A',
- 'position': 'AF',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0653',
- 'employee_name': 'Mrs. Bang-On Sonnam',
- 'dept': 'A6A',
- 'position': 'AGL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0046',
- 'employee_name': 'Ms. Chuanpit Duangchakam',
- 'dept': 'A6A',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0047',
- 'employee_name': 'Ms. Kannika Hongkamkaew',
- 'dept': 'A6A',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0626',
- 'employee_name': 'Mrs. Rungarun Dankratok',
- 'dept': 'A6A',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0465',
- 'employee_name': 'Mrs. Chiraporn Wansirisuk',
- 'dept': 'A6M',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0167',
- 'employee_name': 'Mrs. Preeyanut Hongthong',
- 'dept': 'A7',
- 'position': 'A1',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0360',
- 'employee_name': 'Mrs. Pinchanat Ritphumraphee',
- 'dept': 'A7',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0134',
- 'employee_name': 'Mr. Montree Garhan',
- 'dept': 'A9',
- 'position': 'A1',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0169',
- 'employee_name': 'Mrs. Nantana Chainarong',
- 'dept': 'A9',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0466',
- 'employee_name': 'Ms. Phatcha Thongpoe',
- 'dept': 'W-K',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0441',
- 'employee_name': 'Mrs. Supawadee Tubyai',
- 'dept': 'QC-K',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1066',
- 'employee_name': 'Mrs. Noknoi Yiamchanthuek',
- 'dept': 'QC-K',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0064',
- 'employee_name': 'Mrs. Puntip Munglayklang',
- 'dept': 'QC-K',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0519',
- 'employee_name': 'Mrs. Arporn Boonmaung',
- 'dept': 'QC-N',
- 'position': 'A1',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0602',
- 'employee_name': 'Mrs. Somporn Wongsiri',
- 'dept': 'QC-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0873',
- 'employee_name': 'Mrs. Onuma Kongnuy',
- 'dept': 'QC-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1002',
- 'employee_name': 'Ms. Pattha Kaewnaphan',
- 'dept': 'QC-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1919',
- 'employee_name': 'Mr. Phanroeng Anchaisree',
- 'dept': 'QC-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a2163',
- 'employee_name': 'Ms. Waraporn Sai-deang',
- 'dept': 'QC-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a2166',
- 'employee_name': 'Ms. Nuanhong Rangubpai',
- 'dept': 'QC-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0975',
- 'employee_name': 'Ms. Chayanis Kongkachaeun',
- 'dept': 'QC-N',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1019',
- 'employee_name': 'Mrs. Weerawan Kulabud',
- 'dept': 'QC-N',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1293',
- 'employee_name': 'Ms. Pranee Anchaisee',
- 'dept': 'QC-N',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0755',
- 'employee_name': 'Ms. Jenjira Kamolvisit',
- 'dept': 'TS-K',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0779',
- 'employee_name': 'Ms. Jidapha Thongsit',
- 'dept': 'TS-K',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1654',
- 'employee_name': 'Mrs. Wimol Hongsibsong',
- 'dept': 'TS-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0347',
- 'employee_name': 'Ms. Patcharin Chantavee',
- 'dept': 'A3B',
- 'position': 'A1',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1478',
- 'employee_name': 'Ms. Nittaya Gladpom',
- 'dept': 'A3B',
- 'position': 'A1',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0695',
- 'employee_name': 'Mrs. Kuttaleeya Wongjantaramanee',
- 'dept': 'A3B',
- 'position': 'A1',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1868',
- 'employee_name': 'Mr. Suranai Ongsopha',
- 'dept': 'A3B',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1322',
- 'employee_name': 'Mr. Manop Pakwitee',
- 'dept': 'A3B',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0488',
- 'employee_name': 'Mrs. Benjawan Prawjangjit',
- 'dept': 'A3B',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1757',
- 'employee_name': 'Mrs. Suda Suntronsanit',
- 'dept': 'A3B',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0641',
- 'employee_name': 'Mrs. Rampaiporn Kongsomkaew',
- 'dept': 'A3B',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0826',
- 'employee_name': 'Mrs. Wasana Tapaengpan',
- 'dept': 'A3B',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a0681',
- 'employee_name': 'Mrs. Wanlapa Prasret',
- 'dept': 'A3B',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1164',
- 'employee_name': 'Mrs. Prapaipan Sornsa',
- 'dept': 'A3B',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1880',
- 'employee_name': 'Mrs. Nampueng Thongkam',
- 'dept': 'A3B',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1609',
- 'employee_name': 'Mrs. Choosri Tamsamak',
- 'dept': 'A3B',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1264',
- 'employee_name': 'Ms. Sirirat Rakthong',
- 'dept': 'A3B',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1679',
- 'employee_name': 'Mr. Weerayut Hunphoo',
- 'dept': 'A3B',
- 'position': 'M3',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1004',
- 'employee_name': 'Mrs. Oumjit Chaidech',
- 'dept': 'W-N',
- 'position': 'GL',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0573',
- 'employee_name': 'Ms. Supaporn Tiabtaw',
- 'dept': 'PUR-K',
- 'position': 'A1',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0838',
- 'employee_name': 'Ms. Natthawan Thinkoksoong',
- 'dept': 'PUR-K',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0558',
- 'employee_name': 'Ms. Nalinee Outaisiriyard',
- 'dept': 'PUR-K',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a2182',
- 'employee_name': 'Ms. Aonuma Aunthapanya',
- 'dept': 'PUR-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a2185',
- 'employee_name': 'Ms. Ramrada Kunthianpradit',
- 'dept': 'PUR-N',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a2177',
- 'employee_name': 'Ms. Orawan Panyosri',
- 'dept': 'PUR-N',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0672',
- 'employee_name': 'Ms. Narumon Uttamung',
- 'dept': 'GA-K',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0837',
- 'employee_name': 'Ms. Vorrarak Jitnuphong',
- 'dept': 'GA-K',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0777',
- 'employee_name': 'Mr. Patarapon Tantiwong',
- 'dept': 'IT',
- 'position': 'A2',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'a1053',
- 'employee_name': 'Ms. Yupin Narongmee',
- 'dept': 'QA',
- 'position': 'F',
- 'course': 'c_33',
- 'pretest': None},
- {'code': 'k0236',
- 'employee_name': 'Ms. Sukanya Chaiyaruk',
- 'dept': 'A6A',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0274',
- 'employee_name': 'Ms. Ratchasrima Chathipa',
- 'dept': 'A7',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0778',
- 'employee_name': 'Ms. Wanida Sakharet',
- 'dept': 'A7',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0799',
- 'employee_name': 'Mr. Thanaphot Ruenpakrab',
- 'dept': 'A7',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0272',
- 'employee_name': 'Ms. Kedchayawan Singhputtaraksa',
- 'dept': 'A7',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0231',
- 'employee_name': 'Mr. Chaiphad Chalomklang',
- 'dept': 'A9',
- 'position': 'M1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0257',
- 'employee_name': 'Mrs. Naphasawan Aramsri',
- 'dept': 'PE-K',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0389',
- 'employee_name': 'Mr. Nattapon Luepongpattana',
- 'dept': 'PE-K',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0486',
- 'employee_name': 'Mr. Phatchanasith Supanklang',
- 'dept': 'PE-K',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a1184',
- 'employee_name': 'Mrs. Nutnicha Onma',
- 'dept': 'W-K',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0756',
- 'employee_name': 'Ms. Prakaikaew Yodbunok',
- 'dept': 'W-K',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0798',
- 'employee_name': 'Mr. Khomkrit Sankhumkaew',
- 'dept': 'W-K',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a0871',
- 'employee_name': 'Mrs. Pranee Kowphattanakit',
- 'dept': 'QC-K',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0822',
- 'employee_name': 'Ms. Suwarak Chinjoho',
- 'dept': 'QC-K',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0823',
- 'employee_name': 'Ms. Rungruedee Saejoho',
- 'dept': 'QC-K',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a0320',
- 'employee_name': 'Mrs. Renu Palasak',
- 'dept': 'QC-K',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a0708',
- 'employee_name': 'Mrs. Wilavun Panachan',
- 'dept': 'QC-K',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0733',
- 'employee_name': 'Ms. Pornchanida Chinjantuek',
- 'dept': 'TS-K',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a1133',
- 'employee_name': 'Ms. Tippanom Tinno',
- 'dept': 'TS-N',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0684',
- 'employee_name': 'Mrs. Sirisuda Kraisorn',
- 'dept': 'PUR-K',
- 'position': 'M2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0797',
- 'employee_name': 'Ms. Arisa Ludckonburi',
- 'dept': 'FIN',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a1704',
- 'employee_name': 'Ms. Ratchanee Chanyingyong',
- 'dept': 'FIN',
- 'position': 'M1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a2131',
- 'employee_name': 'Ms. Kannika Kobthong',
- 'dept': 'FIN',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a1298',
- 'employee_name': 'Mr. Pattanapong Hukhan',
- 'dept': 'FIN',
- 'position': 'E2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a1682',
- 'employee_name': 'Ms. Rossarin Sukem',
- 'dept': 'FIN',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a0444',
- 'employee_name': 'Mrs. Chanya Nongnuch',
- 'dept': 'GA-K',
- 'position': 'M2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'k0683',
- 'employee_name': 'Ms. Chudapa Srikaew',
- 'dept': 'GA-K',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a0281',
- 'employee_name': 'Mrs. Phimwalan Khuanpan',
- 'dept': 'GA-N',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a2119',
- 'employee_name': 'Ms. Chabaprai Dowvadung',
- 'dept': 'GA-N',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a2151',
- 'employee_name': 'Ms. Soawalak Subkha',
- 'dept': 'IT',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a2015',
- 'employee_name': 'Mr. Nuttakit Jaiboon',
- 'dept': 'IT',
- 'position': 'M2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a2181',
- 'employee_name': 'Ms. Tanaporn Arunsri',
- 'dept': 'LG',
- 'position': 'A2',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a2146',
- 'employee_name': 'Ms. Ms.Siriporn Noiwong',
- 'dept': 'LG',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a2106',
- 'employee_name': 'Ms. Anussara Timkhiew',
- 'dept': 'QA',
- 'position': 'A1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a1217',
- 'employee_name': 'Mrs. Suwanna Jamwong',
- 'dept': 'QA',
- 'position': 'M1',
- 'course': 'b_4',
- 'pretest': 3},
- {'code': 'a1213',
- 'employee_name': 'Mrs. Umaporn Jaisamak',
- 'dept': 'QA',
- 'position': 'M3',
- 'course': 'b_4',
- 'pretest': 3}]
- user_list = []
- now = timezone.now()
- for data in data_list:
- code = data["code"]
- username = "kawasumi" + code
- password = DurianUser.generate_test_password()
- user_list.append({"username": username, "password": password})
- user = DurianUser.objects.create_user(username=username, password=password, full_name=data["employee_name"], is_from_gen_bulk=True)
- company_user = CompanyUser.objects.create(user=user, company=company, department=dept_dict[data["dept"]], position=data["position"], activate_date=now, employee_code=code.upper())
- course, course_id = data["course"].split("_")
- if course == "c":
- course = course_dict[course_id]
- student = Student.objects.create(user=user, course=course, semester=course.current_semester, reset_left=course.reset_quota, bandwidth_limit=course.bandwidth_limit, full_name=data["employee_name"])
- student.activate(is_generate=True, is_from_gen_bulk=True)
- course_enroll = CourseEnroll.objects.create(company_user=company_user, student=student, course=course, enroll_datetime=now)
- else:
- course = course_dict[course_id]
- student = BundleStudent.objects.create(user=user, course_bundle=course, full_name=data["employee_name"])
- student.activate(is_generate=True, is_from_gen_bulk=True)
- course_enroll = CourseBundleEnroll.objects.create(company_user=company_user, student=student, course_bundle=course, enroll_datetime=now)
- package_id = data["pretest"]
- if package_id:
- testticket = TestTicket.objects.create(user=user, package=package, full_name=data["employee_name"])
- testticket.activate()
- test_ticket_enroll = TestTicketEnroll.objects.create(company_user=company_user, test_ticket=testticket, enroll_datetime=now)
-
- print user_list
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement