<%@ page language="PL/SQL" %>
<%@ plsql procedure="dodaj_odjazd" %>
<%@ plsql parameter="ID_PRACOWNIK" type="NUMBER" default="NULL"%>
<%@ plsql parameter="IMIE type="VARCHAR2(20)" default="NULL"%>
<%@ plsql parameter="NAZWISKO" type="VARCHAR2(20)" default="NULL"%>
<%@ plsql parameter="MIASTO" type="VARCHAR2(20)" default="NULL"%>
<%@ plsql parameter="ULICA" type="VARCHAR2(20)" default="NULL"%>
<%@ plsql parameter="NR_DOMU" type="NUMBER(6)" default="NULL"%>
<%@ plsql parameter="NR_LOKALU" type="NUMBER(6)" default="NULL"%>
<%@ plsql parameter="WIEK" type="NUMBER(6)" default="NULL"%>
<%@ plsql parameter="NR_TEL" type="NUMBER" default="NULL"%>
<%@ plsql parameter="PENSJA" type="NUMBER" default="NULL"%>

<%!
	ID_MAX NUMBER(10);
    WYJATEK EXCEPTION;
%>
<form action="DODAJ_PRACOWNIKA" method="get">
				<hr>
				<span style="margin-left:20px;">ID_POJAZDU</span>
				<input type="text" name="ID_PRACOWNIK">

                <span style="margin-left:20px;">ID_PRACOWNIK</span>
				<input type="text" name="IMIE">

                <span style="margin-left:20px;">IMIE</span>
				<input type="text" name="NAZWISKO">

                <span style="margin-left:20px;">NAZWISKO</span>
				<input type="text" name="ILOSC_MIEJSC">

                <span style="margin-left:20px;">MIASTO</span>
				<input type="text" name="MIASTO">

                <span style="margin-left:20px;">ULICA</span>
				<input type="text" name="ULICA">

                <span style="margin-left:20px;">NR_DOMU</span>
				<input type="text" name="NR_DOMU">

                <span style="margin-left:20px;">NR_LOKALU</span>
				<input type="text" name="NR_LOKALU">

                <span style="margin-left:20px;">WIEK</span>
				<input type="text" name="WIEK">

                <span style="margin-left:20px;">NR_TEL</span>
				<input type="text" name="NR_TEL">

                <span style="margin-left:20px;">PENSJA</span>
				<input type="text" name="PENSJA">
                <br><br>
				<input type="submit" value="DODAJ">
			</form>


<%
	SELECT MAX(ID_DATA_ODJAZDU) INTO ID_MAX FROM DATA_ODJAZDU;
	IF ID_DATA_ODJAZDU IS NULL OR MIESIAC IS NULL OR DZIEN IS NULL OR GODZINA IS NULL OR MINUTA IS NULL THEN RAISE WYJATEK;
	END IF;
	IF ID_MAX IS NULL THEN
	INSERT INTO DATA_ODJAZDU VALUES(1,UPPER(MIESIAC),UPPER(DZIEN),UPPER(GODZINA),UPPER(MINUTA));
	END IF;
	IF ID_MAX IS NOT NULL THEN
	INSERT INTO DATA_ODJAZDU VALUES(ID_MAX+1,UPPER(MIESIAC),UPPER(DZIEN),UPPER(GODZINA),UPPER(MINUTA));
	END IF;
	dodaj_odjazd();
%>

<% EXCEPTION WHEN WYJATEK THEN %>
	<strong><center>NIE PODANO WYMAGANYCH DANYCH!</center></strong>
	<center><a href="dodaj_odjazd">POWROT</a></center>
<% WHEN OTHERS THEN %>
	<strong><center>WYSTAPIL INNY BLAD!</center></strong>
	<center><a href="dodaj_odjazd">POWROT</a></center>