Salary Market

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);