Untitled

mail@pastecode.io avatar
unknown
sql
2 years ago
24 kB
2
Indexable
Never
-- FULL_SERVICE_2_HY_EKBATAN
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_HY_EKBATAN', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1938, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_EKBATAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_EKBATAN'), false, true, now(), now(), 0);


-- FULL_SERVICE_2_MT_SARDAR
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_MT_SARDAR', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_SARDAR'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_SARDAR'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1938, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_SARDAR'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_SARDAR'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_SARDAR'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_SARDAR'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_SARDAR'), false, true, now(), now(), 0);


-- FULL_SERVICE_2_MT_NARMAK
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_MT_NARMAK', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_NARMAK'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_NARMAK'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1938, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_NARMAK'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_NARMAK'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_NARMAK'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_NARMAK'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_NARMAK'), false, true, now(), now(), 0);


-- FULL_SERVICE_2_MT_HERAVI
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_MT_HERAVI', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_HERAVI'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_HERAVI'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1938, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_HERAVI'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_HERAVI'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_HERAVI'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_HERAVI'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_MT_HERAVI'), false, true, now(), now(), 0);


-- FULL_SERVICE_2_SH_BOOSTAN
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_SH_BOOSTAN', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_BOOSTAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_BOOSTAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1938, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_BOOSTAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_BOOSTAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_BOOSTAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_BOOSTAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_BOOSTAN'), false, true, now(), now(), 0);


-- FULL_SERVICE_2_SH_ARJANTIN
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_SH_ARJANTIN', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_ARJANTIN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_ARJANTIN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1938, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_ARJANTIN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_ARJANTIN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_ARJANTIN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_ARJANTIN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_SH_ARJANTIN'), false, true, now(), now(), 0);


-- FULL_SERVICE_2_HY_SOBHAN
insert into salary.salary_templates (extuid, name, worker_type, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 'FULL_SERVICE_2_HY_SOBHAN', 'FULL_SERVICE', now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'DISCRETE_ITEMS_COUNT',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_SOBHAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1482, null, null, 'WEIGHT_ITEMS_STEP_COUNTS',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_SOBHAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 1938, null, null, 'DISTANCE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_SOBHAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 0.5, null, null, 'CUSTOMER_AVG_REVIEW',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_SOBHAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 17000, null, null, 'MORNING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_SOBHAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 13000, null, null, 'EVENING_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_SOBHAN'), false, true, now(), now(), 0);

insert into salary.salary_template_items (extuid, factor, max_applicable_value, min_applicable_value, salary_item,
                                          salary_template_id, stair, enabled, create_date, last_update_date, version)
values (substring(md5(random()::text), 0, 33)::uuid, 30000, null, null, 'FULL_PETROL_PRICE',
        (select id from salary.salary_templates where name = 'FULL_SERVICE_2_HY_SOBHAN'), false, true, now(), now(), 0);