-- sql queries For Group Permissions 
-- 1 -- app_label : Clinic Groups
--إدارة المستخدمين 

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1001 ,"Management","المجموعات","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"view_group","عرض المجموعات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"add_users_to_group","  تعديل مستخدمين المجموعة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"change_permissions","  تعديل الصلاحيات   ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"add_group","إضافة المجموعات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"change_group","تعديل المجموعات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1001,"delete_group","حذف المجموعات ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1002 , "Management","المستخدمين","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1002,"view_user","عرض المستخدمين ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1002,"add_user","إضافة المستخدمين ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1002,"change_user","تعديل المستخدمين ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1002,"reset_password","إعادة ضبط كلمة السر  ");

-- البيانات الرئيسية 
-- 2 -- app_label : Management
INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1003,"Management","العيادات","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"view_clinics","عرض العيادات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"view_branchLocations","عرض مناطق التغطية ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"add_branch","إضافة فرع جديد  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"change_branch","تعديل بيانات فرع ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1003,"delete_branch"," حذف فرع حالي");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1004 ,"Management","التخصصات الطبية","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1004,"view_clinictypes"," عرض التخصصات الطبية");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1004,"view_complainttypes"," عرض شكوي المرضي");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1005 ,"Management"," الجنسيات","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1005,"view_nationalities","عرض الجنسيات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1005,"add_nationality","إضافة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1005,"change_nationality","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1005,"delete_nationality","حذف  ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1006 ,"Management"," المناطق","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1006,"view_locations","عرض المناطق ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1006,"add_location","إضافة منطقة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1006,"change_location","تعديل منطقة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1006,"delete_location","حذف منطقة ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1007 ,"Management"," طرق التعرف","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1007,"view_foundways","عرض طرق التعرف ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1007,"add_foundway","إضافة طريقة تعرف ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1007,"change_foundway","تعديل طريقة تعرف ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1007,"delete_foundway","حذف طريقة تعرف ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1008 ,"Management"," شكوي المرضي","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1008,"view_complaints","عرض   ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1008,"add_complaint","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1008,"change_complaint","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1008,"delete_complaint","حذف  ");

-- الوسائل الإعلامية
INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1009 ,"Management"," البرامج التليفزيونية","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1009,"view_tvPrograms","عرض");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1009,"add_tvPrograms","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1009,"change_tvPrograms","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1009,"delete_tvPrograms","حذف  ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1010 ,"Management","  قنوات التلفزيون","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1010,"view_tvChannels","عرض    ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1010,"add_tvChannels","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1010,"change_tvChannels","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1010,"delete_tvChannels","حذف  ");

-- المعاملات المالية
INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1011 ,"Management","فئات بنود المصروفات","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1011,"view_expenseCategories","عرض ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1011,"add_expenseCategories","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1011,"change_expenseCategories","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1011,"delete_expenseCategories","حذف  ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (1020 ,"Management","أسباب الإلغاء","GE");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1020,"view_cancelreasons","عرض ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1020,"add_cancelreason","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1020,"change_cancelreason","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (1020,"delete_cancelreason","حذف  ");




-- sql queries For Group Permissions 
-- 1 -- app_label : Clinic Groups
-- إدارة المستخدمين 

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2001 ,"Management","مجموعات العيادة","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2001,"view_group","عرض المجموعات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2001,"add_users_to_group","  تعديل مستخدمين المجموعة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2001,"change_permissions","  تعديل الصلاحيات   ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2001,"add_group","إضافة مجموعة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2001,"change_group","تعديل مجموعة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2001,"delete_group","حذف مجموعة ");

-- البيانات الرئيسية 
-- 2 -- app_label : Management
INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2002,"Management","المرضي","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2002,"view_patients","عرض بيانات المرضي ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2002,"add_patient","إضافة مريض جديد ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2002,"change_patient","تعديل بيانات مريض ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2002,"delete_patient","حذف مريض ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2003,"Management","الفروع","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2003,"view_branches","عرض الفروع ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2003,"add_doctors_to_branch"," تعديل أطباء الفرع ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2003,"add_receptions_to_branch"," تعديل موظفين الإستقبال للفرع ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2003,"change_fixedworktimes_branches"," تعديل توقيتات الفروع الثابتة");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2003,"change_temporaryworktimes_branches"," تعديل توقيتات الفروع المتغيرة");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2003,"change_exceptionaldays_branches"," تعديل الأيام الإستثنائية");

-- المعاملات المالية
INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2004 ,"Management"," الخدمات العلاجية ","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2004,"view_medicalservice","عرض بيانات الخدمات العلاجية ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2004,"add_medicalservice","إضافة خدمة علاجية جديدة ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2004,"change_medicalservice","تعديل بيانات خدمة علاجية ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2004,"delete_medicalservice","حذف خدمة علاجية ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2005 ,"Management"," بنود المصروفات","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2005,"view_expenseitem","عرض  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2005,"add_expenseitem","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2005,"change_expenseitem","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2005,"delete_expenseitem","حذف  ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2006 ,"Management","  الأدوية","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2006,"view_drugs","عرض  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2006,"add_drug","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2006,"change_drug","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2006,"delete_drug","حذف  ");


INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2007 ,"Management","  الأشعة","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2007,"view_radiologys","عرض  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2007,"add_radiology","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2007,"change_radiology","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2007,"delete_radiology","حذف  ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2008 ,"Management","  التحاليل","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2008,"view_medicaltests","عرض  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2008,"add_medicaltest","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2008,"change_medicaltest","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2008,"delete_medicaltest","حذف  ");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2009 ,"Management","  الجرعات والتوقيتات ","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2009,"view_timetodos","عرض  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2009,"add_timetodo","إضافة  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2009,"change_timetodo","تعديل  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2009,"delete_timetodo","حذف  ");



INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (3001 ,"CallCenter"," الحجوزات الجديدة","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (3001,"add_lead_visit"," إضافة حجز جديد ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (3001,"lead_visit_inquiry"," الاستعلام عن حجز");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (3001,"confirm_lead_visit"," تأكيد الحجوزات");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (3002 ,"CallCenter"," إدارة الحجوزات الجديدة","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (3002,"assign_slot_lead_visits"," تخصيص توقيتات الحجوزات ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (3002,"review_lead_visits"," مراجعة الحجوزات  ");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (3002,"waiting_visits","الحجوزات المنتظرة");
-- UPDATE `ems_db`.`auth_permission` SET `name` = 'الحجوزات المنتظرة' WHERE (`id` = '303');



INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2501 ,"Reception","المرضي","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2501,"add_patient","اضافة مريض جديد");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2501,"view_patient","  عرض ملف المريض");

INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2502 ,"Reception","المصروفات","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2502,"add_expense","اضافة  مصروفات");


INSERT INTO django_content_type (id, app_label, model,entity_type)VALUES (2503 ,"Reception","الحجوزات الحالية","GC");
INSERT INTO auth_permission (content_type_id, codename, name) VALUES (2503,"view_currentvisits"," عرض الحجوزات الحالية");