from django.core.management.base import BaseCommand

from api.models import User, Role


class Command(BaseCommand):

    def handle(self, *args, **options):
        user_to_update = [
            "Prof. Lim Weng Marc;marcl@sunway.edu.my;lnLb27R7NE",
            "Prof. Motoki Watabe;motokiw@sunway.edu.my;g7mVqy7qof",
            "Prof. Yuka Fujimoto;yukaf@sunway.edu.my;k0TL2VJE0j",
            "Assoc. Prof. Dr Arsalan Zahid Piprani;arsalanzp@sunway.edu.my;TpjrJxKb5T",
            "Brenda Chung Lihwa;brendac@sunway.edu.my;6kOrhkYQGj",
            "Claudine Shalani Kenel;shalanik@sunway.edu.my;4aGXKKWF1a",
            "Dr Alice Neow Ean Lee;alicen@sunway.edu.my;3QeR9ftyg4",
            "Dr Ellen Trees Bolt;esterb@sunway.edu.my;2Ymk7eX6P0",
            "Dr Fathey Mohammed Abdualrakeb Mohammed;fatheym@sunway.edu.my;wrqSBVAUxG",
            "Dr Ghazala Khan;ghazalak@sunway.edu.my;AzhktkKwkR",
            "Dr Kim Sodam;sodamk@sunway.edu.my;yhE26lBhnb",
            "Dr Kyra Sin Kit Yeng;kyras@sunway.edu.my;sEgLrzY7YN",
            "Dr Marvello Yang;marvelloy@sunway.edu.my;eT9wNbC04z",
            "Dr Mohamed Framjee Dinul Hathy;framjeeh@sunway.edu.my;by3krZzRdG",
            "Dr Vikneswary Manogaran;vikneswaryma@sunway.edu.my;qANiJgXvOm",
            "Dr Zheng Zhangwei;zhangweiz@sunway.edu.my;8RC6PLqnDM",
            "Ezatul Emilia Muhammad Arif;ezatulm@sunway.edu.my;bf7X7ybAYM",
            "Gaithri Gunasagran;gaithrig@sunway.edu.my;UOamftBALV",
            "Hajara Mohamed Saleeth;hajaram@sunway.edu.my;b2gDQBT93y",
            "Prof. Satish Kumar;satishk@sunway.edu.my;1Dcs0jSTnd",
            "Assoc. Prof. Dr Adams Adeiza;adamsa@sunway.edu.my;0elJVZ2dp6",
            "Assoc. Prof. Dr Chang Chee Fei;cfchang@sunway.edu.my;mDptQroMfW",
            "Assoc. Prof. Dr Charles Dickens Pirithiviraj Jebarajakirthy;charlesj@sunway.edu.my;lgLceejOSl",
            "Assoc. Prof. Dr Foo Yee Boon;yeeboonf@sunway.edu.my;MRAcucmCjl",
            "Assoc. Prof. Dr Gan Joo Ee;jooeeg@sunway.edu.my;hUPwtedUmd",
            "Assoc. Prof. Dr Jason Ng Wei Jian;jasonn@sunway.edu.my;L62BLODWHV",
            "Assoc. Prof. Dr Jaspal Singh Joginder Singh;jaspalj@sunway.edu.my;0df0Y733Yi",
            "Assoc. Prof. Dr Jesrina Ann Xavier;jesrinax@sunway.edu.my;LcPDl7roZc",
            "Assoc. Prof. Dr Khor Kuan Siew;kuansiewk@sunway.edu.my;Et2cp9hTxG",
            "Assoc. Prof. Dr Muhammad Saeed;saeedm@sunway.edu.my;xbbVAjOIyR",
            "Assoc. Prof. Dr Priya Sharma Amarjit Singh;priyaas@sunway.edu.my;fZOkcnlerG",
            "Assoc. Prof. Dr Sahar Afshan;sahar@sunway.edu.my;bpelpdv1wj",
            "Assoc. Prof. Dr Shehnaz Tehseen;shehnazt@sunway.edu.my;IuTPCcJQVS",
            "Assoc. Prof. Dr Stephen Thomas Homer;stephenhomer@sunway.edu.my;SVlfg0xouT",
            "Caroline Yap Yu Li;caroliney@sunway.edu.my;2Anoshy1ld",
            "Cirami Mastura Drahaman;ciramid@sunway.edu.my;KlKAhEG97P",
            "Dr Alvin Chan Shian We;alvincsw@sunway.edu.my;7UrYVHFkCZ",
            "Dr Aminath Shaba Ismail;aminathi@sunway.edu.my;WfjGPqJx3x",
            "Dr Amir Raslan Abu Bakar;amirb@sunway.edu.my;FbCnRPzCUq",
            "Dr Anita Premila Paul Dorairaj;anitap@sunway.edu.my;3fG7df7vwi",
            "Dr Anuja Sandeep Chalke;anujac@sunway.edu.my;r7DQ5G1KKE",
            "Dr Bawani Lelchumanan;bawanil@sunway.edu.my;9vtzMdLD1z",
            "Dr Becky Teng Huei-Chun;beckyt@sunway.edu.my;PlDuMTZM3x",
            "Dr Chan Ling Foon;lingfoonc@sunway.edu.my;rYYjorsqvK",
            "Dr Cheah Siew Pong;siewpongc@sunway.edu.my;87cRGjzHAu",
            "Dr Chong Poh Ling;pohlingc@sunway.edu.my;E6X61wCsbW",
            "Dr Chong Soon Meng;smchong@sunway.edu.my;wM3CpNiTVg",
            "Dr Choo Sook Yin;sookyinc@sunway.edu.my;NhQMGlCT2P",
            "Dr Choong Pai Wei;pwchoong@sunway.edu.my;bp9iFgwkLd",
            "Dr Chuah Cindy;cindychuah@sunway.edu.my;OGz2bcjnya",
            "Dr Chuah Lay Lian;laylianc@sunway.edu.my;OjQgTZ8IjI",
            "Dr Chun Minsoo;minsooc@sunway.edu.my;FsZw2bZHiJ",
            "Dr Dalia Abdulkareem Shafiq Al-Obaidi;daliaa@sunway.edu.my;ffcZMtUUdG",
            "Dr Elizabeth Andrews;elizabetha@sunway.edu.my;FmlVykDJcb",
            "Dr Evelyn Toh Bee Hwa;evelyntoh@sunway.edu.my;0eOgegNHur",
            "Dr Gan Chin Chuan;chinchuang@sunway.edu.my;eOwx7fvUv4",
            "Dr Hawariah Dal Nial;hawariahd@sunway.edu.my;si1q6dO0Ep",
            "Dr Henry Lu Qing;henrylq@sunway.edu.my;p35YVNclwb",
            "Dr Ho Wai Kee;waikeeh@sunway.edu.my;vsPp6oF4f0",
            "Dr Hwang Li-Ann;liannh@sunway.edu.my;AB42vWDMrV",
            "Dr Joyce Nga Koe Hwee;joycen@sunway.edu.my;iM3jVkUPVH",
            "Dr Kavitha Sathasivam;kavithasa@sunway.edu.my;nwgRWjvnh1",
            "Dr Kawtar Bahanni;kawtarb@sunway.edu.my;IFIe07e4fy",
            "Dr Kenny Teoh Guan Cheng;kennyt@sunway.edu.my;EU0KYvhqB3",
            "Dr Kimberley Khoo Kim Leng;kimberleyk@sunway.edu.my;5vAp5Klu2T",
            "Dr Koon Vui Yee;vuiyeek@sunway.edu.my;UJCsPxfsOW",
            "Dr Lalitha Shamugam;lalithas@sunway.edu.my;6Eee0O51qN",
            "Dr Leong Ken Yien;kyleong@sunway.edu.my;b5JQvDXEsy",
            "Dr Lianne Lee Mei Quin;liannel@sunway.edu.my;QcaJxUfASG",
            "Dr Liew Yit Wey;yitweyl@sunway.edu.my;Okk5Zdwuaj",
            "Dr Loo Wee Hong;weehongl@sunway.edu.my;vQbV1ZTAzy",
            "Dr Ma Lan;lanm@sunway.edu.my;igEKKRBITz",
            "Dr Ma Yaxin;yaxinm@sunway.edu.my;ZVdlTcVfSj",
            "Dr Manjeet Kaur Harnek Singh;manjeeth@sunway.edu.my;bqUMhafdZa",
            "Dr Marc Arul Weissmann;marcw@sunway.edu.my;meteKWe4pT",
            "Dr Matthew Malcolm Haigh;matthewh@sunway.edu.my;rwpTIqzSQv",
            "Dr Md Khaled Shukran;khaleds@sunway.edu.my;MR2TAlUUZY",
            "Dr Mikkay Wong Ei Leen;mikkayw@sunway.edu.my;lepQ8Vd9Pd",
            "Dr Mohammad Imtiaz Hossain;imtiazh@sunway.edu.my;KyvxDc5Dn3",
            "Dr Muaadh Shaif Mohammed Mukred;muaadhm@sunway.edu.my;0oSTpZDxwq",
            "Dr Mudeer Ahmed Khattak;mudeerk@sunway.edu.my;pf0fMkhD1X",
            "Dr Muhammad Yasir;yasirm@sunway.edu.my;uKBqyKRO7Z",
            "Dr Nampuna Dolok Gultom;nampunag@sunway.edu.my;MVI3kxoE8G",
            "Dr Narishah Mohamed Salleh;narishahm@sunway.edu.my;QUZO1DWZhj",
            "Dr Ng Hee Song;heesongn@sunway.edu.my;BKBOIORBSS",
            "Dr Noman Arshed;nomana@sunway.edu.my;mXtcTvo7B4",
            "Dr Noreen Kanwal;noreenk@sunway.edu.my;nvLGC1zb09",
            "Dr Nur Shazwani Rosli;shazwanir@sunway.edu.my;uP1J07ssR8",
            "Dr Olivia Loh Huey Shee;hueysheel@sunway.edu.my;w30jlq64Pb",
            "Dr Premagowrie Sivanandan;premagowrie@sunway.edu.my;Qk8oDnDsnU",
            "Dr Punitha Sinnappan;punithas@sunway.edu.my;yCnPrVOQZu",
            "Dr Ranjana Tiwari;ranjanat@sunway.edu.my;eaGDctbVBz",
            "Dr Renee Kok Shiau Hui;shkok@sunway.edu.my;SSvgDsZvLz",
            "Dr Sandy Liew Mei Xuan;sandyl@sunway.edu.my;Ei4tea5QI8",
            "Dr Shafinah Begum Abdul Rahim;shafinahr@sunway.edu.my;25PaVqZ7KN",
            "Dr Shun Mya Thwe;myathwes@sunway.edu.my;8Zxj1KMCMr",
            "Dr Siti Munerah Abd Karim;muneraha@sunway.edu.my;3YBSHMgdNY",
            "Dr SK Tasthekur Hossain Kowshik;tasthekurh@sunway.edu.my;CtDRwf12ag",
            "Dr Soon Pei Shan;peishans@sunway.edu.my;gW2yhx79ec",
            "Dr Stella Ong Kim Yoke;stellao@sunway.edu.my;RaXkQ3uz5F",
            "Dr Steven Parker;sparker@sunway.edu.my;gE0yFkCd8U",
            "Dr Suzanne Tan Ser Zian;suzannetan@sunway.edu.my;hDIhRubhyK",
            "Dr Syed Monirul Hossain;syedmonirulh@sunway.edu.my;PxmDxMBHhR",
            "Dr Tamara Joan Duraisingam;tamarajd@sunway.edu.my;4msvzSpbGr",
            "Dr Teow Hui Hui;huihuit@sunway.edu.my;1pJdg8f89y",
            "Dr Thinesh Thambusamy;thineshth@sunway.edu.my;jy6I3pMCaB",
            "Dr Tiamiyu Tosin Ahmed;tosint@sunway.edu.my;o2bkdBZReH",
            "Dr Toh Seong Yuen;seongyuent@sunway.edu.my;KDrzH5YiOR",
            "Dr Woon Chin Ong;chinongw@sunway.edu.my;CKz2wv6349",
            "Evelyn Wong Mei Ling;evelynw@sunway.edu.my;MqWUci9tYe",
            "Indubala Krishnan;indubalak@sunway.edu.my;7sZgAHMsPK",
            "Jason Raj Makalsamy;jasonrajm@sunway.edu.my;1UEilBX99R",
            "Kanchana Chandran;kanchanac@sunway.edu.my;qxN10EWbl1",
            "Kevin Tan Tee Liang;kevint@sunway.edu.my;R8gKW3wCak",
            "Khalilah Kamaruddin;khalilahk@sunway.edu.my;MtioQ81D0I",
            "Muhammad Aidil Zuhair Zakariya;aidilz@sunway.edu.my;njzVkqvtmV",
            "Muhammad Ridza Mohd Azizi;ridzaa@sunway.edu.my;jDgoMHzMrr",
            "N Madhavan Nanairan;madhavann@sunway.edu.my;8RSCVtpGjt",
            "Nadzratun Naim Hammad Azizi;nadzratunh@sunway.edu.my;0wc0BCcbgL",
            "Nasaruddin Zainal;nasaruddinz@sunway.edu.my;XDtJ6uNwFL",
            "Ng Foo Seng;foosengn@sunway.edu.my;JbecYlA9h3",
            "Presana Arikrishna;presanaa@sunway.edu.my;m8TBUWBY0P",
            "Prof. Arshian Sharif;arshians@sunway.edu.my;m0h88fltDG",
            "Prof. Kenneth Anthony Cafferkey;kennethc@sunway.edu.my;k7nhJmhd6e",
            "Prof. Keshab Man Shrestha;keshabs@sunway.edu.my;6TA4wwtJsJ",
            "Prof. Kim Myung Ja;myungjak@sunway.edu.my;EJN5YQV36L",
            "Prof. Koay Kian Yeik;kianyeikk@sunway.edu.my;oQudao8QVi",
            "Prof. Luu Trong Tuan;trongtuanl@sunway.edu.my;cMXdeKWLeY",
            "Prof. Zaheer Anwer;zaheerm@sunway.edu.my;kV3dS5ufjn",
            "Rafferty Hoo Wei Hoong;raffertyh@sunway.edu.my;iO2vgEWDbr",
            "Sapna Kaur Bhandal Jaspal Singh;sapnak@sunway.edu.my;63RNGB0WXL",
            "Sharifah Nur Asmaa' Syed Azman;sharifaha@sunway.edu.my;iJunfWMUuc",
            "Sharon Dharsini Anthony Raju;sharond@sunway.edu.my;5nW8JggsM5",
            "Sophia Loh Soo Fun;sfloh@sunway.edu.my;zbB6OpmSwF",
            "Taqiah Zawani Adnan;taqiaha@sunway.edu.my;ZbzaTAEiuu",
            "Ts. Dr Mohd Misron Omar;misrono@sunway.edu.my;fFH7fBK6wr",
            "Vijayganesh Pullikutthyayanar;vijayganeshp@sunway.edu.my;LUF9cpgF1H",
            "Vivi Norazlina Mohd Sidik;vivim@sunway.edu.my;69D6IYDCfA",
        ]

        role = Role.objects.filter(name="SBS Academics to View SBS Modules Only").first()
        update_count = 0
        create_count = 0
        if role:
            for val in user_to_update:
                name, email, password = val.split(";")
                user = User.objects.filter(email=email).first()
                if user:
                    user.is_only_self = False
                    user.save(update_fields=["is_only_self"])
                    user.role.set([role.id])
                    update_count += 1
                else:
                    new_user = User.objects.create_user(
                        name=name,
                        email=email,
                        password=password,
                        user_type=User.USER_TYPE.get("admin"),
                        status=User.STATUS_TO_CODE.get("active"),
                    )
                    new_user.role.set([role.id])
                    create_count += 1
        print("Update count:"+str(update_count))
        print("Create count:"+str(create_count))

