use socle;
-- initialise by one company with one user (admin) for solution
INSERT INTO company (id, raisonSociale, logo, site, address, parentId,company_type,subscription_type) VALUES 
(1,'HR House International', 'default-avatar.png', 'example.com', 'Tunis, Tunisia', '1','Solution', 'Solution');
-- initialise profils
INSERT INTO company_profile (id, title, profile_code, companyId) VALUES 
(1, 'admin', 'admin solution', 1),
(2, 'RH', 'RH', 1);
-- initialise compagny
INSERT INTO company_users (id, firstName, lastName, email, user_password, phone, avatar, companyId,actif) VALUES 
(1,'Tarek', 'HR Group', 'tarek.aouadi@gmail.com', '$2a$08$eHBsdVKusKPV/mg2KJ1cW.JqnW1EkNo37HIjqh/ma7nw7jzUfKUt6', 333312455, 'default-avatar.png', 1,1),
(2,'Ahlem', 'HR Group', 'ahlem.belgacem@wingedhorses.net', '$2a$08$eHBsdVKusKPV/mg2KJ1cW.JqnW1EkNo37HIjqh/ma7nw7jzUfKUt6', 333312455, 'default-avatar.png', 1,1),
(3,'Yousra', 'HR Group', 'yousra.ziada@groupe-rh.com', '$2a$08$eHBsdVKusKPV/mg2KJ1cW.JqnW1EkNo37HIjqh/ma7nw7jzUfKUt6', 333312455, 'default-avatar.png', 1,1),
(4,'Ibtihel', 'HR Group', 'ibtihel.benhaddej@groupe-rh.com', '$2a$08$eHBsdVKusKPV/mg2KJ1cW.JqnW1EkNo37HIjqh/ma7nw7jzUfKUt6', 333312455, 'default-avatar.png', 1,1);
-- initialise compagny
INSERT INTO company_user_profile (id,usersId, profileId)VALUES 
(1,1, 1),
(2,2, 1),
(3,3, 1),
(4,4, 2);
INSERT INTO company_entities (id,entity_code, title,state, entity_level, parentId, companyId)
VALUES (1,'solution', 'solution', false, '0', '0', 1);
-- insert into languages_company
INSERT INTO company_languages (id, active, defaultLanguage, languagesId, companyId) VALUES 
(1, 'true', 0, '1', 1),
(2, 'true', 1, '2', 1);

INSERT INTO company_solution_menu (id, state, companyId, menuCode) VALUES
(1, '1', 1, 'home'),
(2, '1', 1, 'home_administration'),
(3, '1', 1, 'home_administration_clients'),
(4, '1', 1, 'home_administration_secteurs'),
(5, '1', 1, 'home_administration_subscription'),
(6, '1', 1, 'home_administrationemployees_per_region'),
(7, '1', 1, 'myCompany'),
(8, '1', 1, 'myCompany_informations'),
(9, '1', 1, 'myCompany_users'),
(10, '1', 1, 'myCompany_entities'),
(11, '1', 1, 'myCompany_profiles'),
(12, '1', 1, 'myCompany_configuration'),
(13, '1', 1, 'myCompany_settings'),
(14, '1', 1, 'myCompany_settings_language'),
(15, '1', 1, 'myClients'),
(16, '1', 1, 'myClients_clients'),
(17, '1', 1, 'client_informations'),
(18, '1', 1, 'client_users'),
(19, '1', 1, 'client_entities'),
(20, '1', 1, 'client_profiles'),
(21, '1', 1, 'client_configuration'),
(22, '1', 1, 'myClients_prospection'),
(23, '1', 1, 'administration'),
(24, '1', 1, 'administration_settings'),
(25, '1', 1, 'administration_settings_language'),
(26, '1', 1, 'administration_settings_country'),
(27, '1', 1, 'administration_settings_business-sector'),
(28, '1', 1, 'administration_settings_turnover'),
(29, '1', 1, 'administration_settings_geographic-extent'),
(30, '1', 1, 'administration_settings_company-size'),
(31, '1', 1, 'administration_settings_value-chain'),
(32, '1', 1, 'administration_entities'),
(33, '1', 1, 'administration_subscription'),

-- For rh
(34, '1', 1, 'company_compensation'),
(35, '1', 1,'company_quiz'),
(36, '1', 1,'quiz_market'),
(37, '1', 1,'quiz_current_sector'),
(38, '1', 1,'quiz_selected_sector'),
(39, '1',1, 'home_indicators'),
(40, '1', 1,'home_indicateurs_number_of_employees'),
(41, '1', 1,'home_indicateurs_payroll'),
(42, '1',1, 'home_indicateurs_average_salaries_by_career_path'),
(43, '1',1, 'home_indicateurs_supervision_rate'),
(44, '1',1, 'home_administration_nbCollaborateursGender');
   

-- insert into company_menu_solution_profils
INSERT INTO company_solution_menu_profils (id,state, profileId, menuSolutionCompanyId) VALUES
(1,1, 1, 1),
(2,1, 1, 2),
(3,1, 1, 3),
(4,1, 1, 4),
(5,1, 1, 5),
(6,1, 1, 6),
(7,1, 1, 7),
(8,1, 1, 8),
(9,1, 1, 9),
(10,1, 1, 10),
(11,1, 1, 11),
(12,1, 1, 12),
(13,1, 1, 13),
(14,1, 1, 14),
(15,1, 1, 15),
(16,1, 1, 16),
(17,1, 1, 17),
(18,1, 1, 18),
(19,1, 1, 19),
(20,1, 1, 20),
(21,1, 1, 21),
(22,1, 1, 22),
(23,1, 1, 23),
(24,1, 1, 24),
(25,1, 1, 25),
(26,1, 1, 26),
(27,1, 1, 27),
(28,1, 1, 28),
(29,1, 1, 29),
(30,1, 1, 30),
(31,1, 1, 31),
(32,1, 1, 32),
(33,1, 1, 33);

-- For rh
INSERT INTO company_solution_menu_profils (state, profileId, menuSolutionCompanyId) VALUES
(1, 2, 1),
(1, 2, 34),
(1, 2, 35),
(1, 2, 36),
(1, 2, 37),
(1, 2, 38),
(1, 2, 39),
(1, 2, 40),
(1, 2, 41),
(1, 2, 42),
(1, 2, 43),
(1, 2, 44);