<%@ include file="konfigur.jsp"%>
<%@ page contentType="text/html" pageEncoding="utf-8"  import="java.sql.*" %>

<%
	String sedimentacija = request.getParameter("sed");
	String hemoglobin = request.getParameter("hem");
	String eritrociti = request.getParameter("ert");
	String hematokrit = request.getParameter("hmt");
	String trombociti = request.getParameter("trb");
	String leukociti = request.getParameter("leuk");
	String trigliceridi = request.getParameter("trig");
	String holesterol = request.getParameter("hol");
	String labID = request.getParameter("lab");
	String datum = request.getParameter("datum");

	%> <script> alert(<%= labID %>) </script> <%
	String[] dataN = datum.split("/");
	datum = dataN[1] + dataN[0] + dataN[2];

	/*String[] vremeN = vreme.split(":");
	if(Integer.parseInt(vremeN[0]) < 10)
		vremeN[0] = "0" + vremeN[0];
	if(Integer.parseInt(vremeN[1]) < 10)
		vremeN[1] = "0" + vremeN[1];*/




	String idKS = "";
	try {
		String command="";

		Driver Driver = (Driver)Class.forName(baza_DRIVER).newInstance();
		Connection Conn = DriverManager.getConnection(baza_STRING,baza_USERNAME,baza_PASSWORD);
		Statement statement = Conn.createStatement();

		PreparedStatement Statement1=Conn.prepareStatement("select datum from podatok where podatok.id='"+session.getAttribute("id").toString()+"' and podatok.datum=to_date('"+datum+"','DDMMYYYY')");
		ResultSet rs1=Statement1.executeQuery();

		PreparedStatement Statement2=Conn.prepareStatement("select max(k_id) as max from krvnaslika");
		ResultSet rs=Statement2.executeQuery();
		//idKS += rs.getString("max");

		boolean isEmpty=!rs1.next();
		if(isEmpty){

			//String command1 = "insert into podatok(datum,id,ocenka,ks_id,lab_id) values (to_date('"+datum+"','DDMMYYYY'),'"+session.getAttribute("id").toString()+"','0','"+(Integer.parseInt(rs.getString("max"))+1)+"','"+labID+"')";
			String command1 = "insert into podatok(datum,id,ocenka,ks_id,lab_id) values (to_date('"+datum+"','DDMMYYYY'),'"+session.getAttribute("id").toString()+"','0','','"+labID+"')";
			statement.executeUpdate(command1);

		}

		rs1.close();


		if(rs.next()){
			String command2 ="insert into KrvnaSlika(k_id, id, trigliceridi, holesterol, sedimentacija, hemoglobin, eritrociti, hematokrit, trombociti, leukociti, k_ocenka ) values ('"+(Integer.parseInt(rs.getString("max"))+1)+"', '"+labID+"', '"+ trigliceridi +"', '"+ holesterol +"', '"+ sedimentacija +"', '"+ hemoglobin +"', '"+ eritrociti +"', '"+ hematokrit +"', '"+ trombociti +"', '"+ leukociti +"',  '0')";
			statement.executeUpdate(command2);



			String command3 = "UPDATE podatok SET ks_id='"+Integer.parseInt(rs.getString("max"))+1+"' WHERE podatok.datum = to_date('"+datum+"', 'DDMMYYYY') and  podatok.id='"+ session.getAttribute("id").toString() +"';";
			statement.executeUpdate(command3);

			String url = "krvna_slika.jsp?data=" + datum;
			response.sendRedirect(url);
		}
		rs.close();
	}
	catch (Exception e){}

%>