Разработка серверной части информационной системы для сопровождения процесса выдачи заработной платы

Дипломная работа - Компьютеры, программирование

Другие дипломы по предмету Компьютеры, программирование

ухгалтер');into params (object_id, attr_id, text_value) values (12, 4, 'Бухгалтер');into params (object_id, attr_id, text_value) values (13, 4, 'Менеджер');into params (object_id, attr_id, text_value) values (14, 4, 'Вахтер');into params (object_id, attr_id, text_value) values (15, 4, 'Вахтер');into params (object_id, attr_id, text_value) values (16, 4, 'Вахтер');into params (object_id, attr_id, text_value) values (17, 4, 'Менеджер');into params (object_id, attr_id, text_value) values (18, 4, 'Тестер');into params (object_id, attr_id, text_value) values (19, 4, 'Тестер');into params (object_id, attr_id, text_value) values (21, 4, 'Тестер');

-Worker => Yearsinto params (object_id, attr_id, date_value) values (11, 5, TO_DATE('2007-02-22', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (12, 5, TO_DATE('2002-04-12', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (13, 5, TO_DATE('2005-02-12', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (14, 5, TO_DATE('2010-07-30', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (15, 5, TO_DATE('2009-05-20', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (16, 5, TO_DATE('2004-06-18', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (17, 5, TO_DATE('2007-10-29', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (18, 5, TO_DATE('2001-10-22', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (19, 5, TO_DATE('2002-11-28', 'YYYY-MM-DD'));into params (object_id, attr_id, date_value) values (21, 5, TO_DATE('2003-12-01', 'YYYY-MM-DD'));

-List_of_memb => Salaryinto params (object_id, attr_id, number_value) values (1, 6, 2000);into params (object_id, attr_id, number_value) values (2, 6, 1800);into params (object_id, attr_id, number_value) values (3, 6, 800);into params (object_id, attr_id, number_value) values (4, 6, 2500);into params (object_id, attr_id, number_value) values (5, 6, 2300);

-Work => Taskinto params (object_id, attr_id, text_value) values (11, 7, null);into params (object_id, attr_id, text_value) values (12, 7, null);into params (object_id, attr_id, text_value) values (13, 7, null);into params (object_id, attr_id, text_value) values (14, 7, null);into params (object_id, attr_id, text_value) values (15, 7, null);into params (object_id, attr_id, text_value) values (16, 7, null);into params (object_id, attr_id, text_value) values (17, 7, null);into params (object_id, attr_id, text_value) values (18, 7, 'тестирование офисного прогр. обесп.');into params (object_id, attr_id, text_value) values (19, 7, 'тестирование пользовательского прогр. обесп.');into params (object_id, attr_id, text_value) values (21, 7, 'тестирование системного прогр. обесп.');

-Work => Salaryinto params (object_id, attr_id, number_value) values (11, 8, 2000);into params (object_id, attr_id, number_value) values (12, 8, 2000);into params (object_id, attr_id, number_value) values (13, 8, 1800);into params (object_id, attr_id, number_value) values (14, 8, 800);into params (object_id, attr_id, number_value) values (15, 8, 800);into params (object_id, attr_id, number_value) values (16, 8, 800);into params (object_id, attr_id, number_value) values (17, 8, 2500);into params (object_id, attr_id, number_value) values (18, 8, 2300);into params (object_id, attr_id, number_value) values (19, 8, 2300);into params (object_id, attr_id, number_value) values (21, 8, 2300);

-Work => Kind_of_workinto params (object_id, attr_id, text_value) values (11, 9, 'на предпр.');into params (object_id, attr_id, text_value) values (12, 9, 'на предпр.');into params (object_id, attr_id, text_value) values (13, 9, 'на предпр.');into params (object_id, attr_id, text_value) values (14, 9, 'на предпр.');into params (object_id, attr_id, text_value) values (15, 9, 'на предпр.');into params (object_id, attr_id, text_value) values (16, 9, 'на предпр.');into params (object_id, attr_id, text_value) values (17, 9, 'на предпр.');into params (object_id, attr_id, text_value) values (18, 9, 'на предпр.');into params (object_id, attr_id, text_value) values (19, 9, 'на дому');into params (object_id, attr_id, text_value) values (21, 9, 'на предпр.');

-Work => Kind_of_salaryinto params (object_id, attr_id, text_value) values (11, 10, 'почасовая');into params (object_id, attr_id, text_value) values (12, 10, 'почасовая');into params (object_id, attr_id, text_value) values (13, 10, 'почасовая');into params (object_id, attr_id, text_value) values (14, 10, 'почасовая');into params (object_id, attr_id, text_value) values (15, 10, 'почасовая');into params (object_id, attr_id, text_value) values (16, 10, 'почасовая');into params (object_id, attr_id, text_value) values (17, 10, 'почасовая');into params (object_id, attr_id, text_value) values (18, 10, 'фиксир.');into params (object_id, attr_id, text_value) values (19, 10, 'фиксир.');into params (object_id, attr_id, text_value) values (21, 10, 'фиксир.');

-Contact_info

-Phoneinto params (object_id, attr_id, text_value) values (11, 11, '(0542)736-839');into params (object_id, attr_id, text_value) values (12, 11, '(0542)736-839');into params (object_id, attr_id, text_value) values (13, 11, '(05456)5-36-34');into params (object_id, attr_id, text_value) values (14, 11, '(0542)674-256');into params (object_id, attr_id, text_value) values (15, 11, '(05423)7-36-89');into params (object_id, attr_id, text_value) values (16, 11, '(0542)648-820');into params (object_id, attr_id, text_value) values (17, 11, '(05446)2-49-88');into params (object_id, attr_id, text_value) values (18, 11, '(065)473-68-39');into params (object_id, attr_id, text_value) values (19, 11, '(044)273-61-21');into params (object_id, attr_id, text_value) values (21, 11, '(0542)836-358');

-Addressinto params (object_id, attr_id, text_value) values (11, 12, 'г. Сумы, ул. Ахтырская, 3');into params (object_id, attr_id, text_value) values (12, 12, 'г. Сумы, ул. Кирова, 32');into params (object_id, attr_id, text_value) values (13, 12, 'г. Конотоп, ул. Ленина, 257');into params (object_id, attr_id, text_value) values (14, 12, 'г. Сумы, ул. Октября, 3');into params (object_id, attr_id, text_value) values (15, 12, 'г. Ворожба, ул. Колпака, 34');into params (object_id, attr_id, text_value) values (16, 12, 'г. Сумы, ул. Харьковска, 23');into params (object_id, attr_id, text_value) values (17, 12, 'г. Ахтырка, ул. Шевченка, 2');into params (object_id, attr_id, text_value) values (18, 12, 'г. Харьков, ул. Курская, 18');into params (object_id, attr_id, text_value) values (19, 12, 'г. Киев, ул. О.Вишни, 78');into params (object_id, attr_id, text_value) values (21, 12, 'г. Сумы, ул. Береговая, 104');

-E-mailinto params (object_id, attr_id, text_value) values (11, 13, 'jhsdfjskl@yandex.ru');into params (object_id, attr_id, text_value) values (12, 13, '123mjhj@yandex.ru');into params (object_id, attr_id, text_value) values (13, 13, 'loigerg@mail.ru');into params (object_id, attr_id, text_value) values (14, 13, 'vcmhdl@bk.ru');into params (object_id, attr_id, text_value) values (15, 13, 'oehcpspss@yandex.ru');into params (object_id, attr_id, text_value) values (16, 13, 'juise@yandex.ru');into params (object_id, attr_id, text_value) values (17, 13, 'lidufklasjd@mail.ru');into params (object_id, attr_id, text_value) values (18, 13, 'isdkasd@yandex.ru');into params (object_id, attr_id, text_value) values (19, 13, 'lskdjflskdj@yandex.ru');into params (object_id, attr_id, text_value) values (21, 13, 'kudfkjdkdldd@yandex.ru');

-Otherinto params (object_id, attr_id, text_value) values (11, 14, null);into params (object_id, attr_id, text_value) values (12, 14, null);into params (object_id, attr_id, text_value) values (13, 14, 'ICQ - 456789');into params (object_id, attr_id, text_value) values (14, 14, null);into params (object_id, attr_id, text_value) values (15, 14, null);into params (object_id, attr_id, text_value) values (16, 14, null);into params (object_id, attr_id, text_value) values (17, 14, null);into params (object_id, attr_id, text_value) values (18, 14, null);into params (object_id, attr_id, text_value) values (19, 14, null);into params (object_id, attr_id, text_value) values (21, 14, null);

;

Создание выборок

1. SELECT o.name, p1.text_value , EXTRACT (YEAR FROM SYSDATE) - EXTRACT (YEAR FROM p2.date_value) Stazh

FROM objects o JOIN params p1

ON o.object_id=p1.object_id AND p1.attr_id=4

JOIN params p2

ON o.object_id=p2.object_id AND p2.attr_id=5; -- выводит сотрудников, их специальности и стаж работы (использование функции - EXTRACT)

2. select o.name, p1.text_value, p2.text_value, p3.number_value

from objects o join params p1

on o.object_id=p1.object_id and p1.attr_id=4

join params p2

on p1.object_id=p2.object_id and p2.attr_id=3

join params p3

on p2.object_id=p3.object_id and p3.attr_id=8; -- выводит ФИО, специальность, паспортные данные и заработную плату сотрудников (выборка)

• Назад
• 1
• 2
• 3
• 4
• 5
• 6
• Далее