%@page language="java"%> <%@page import="java.util.Calendar"%> <%@ include file="FormFunctions-v3.jsp" %> <%@ include file="/CS/Connections/iue1.webcand.jsp" %> <% String submitURL = "/servlet/AppFormSubmitAll"; %> <%@ include file="felyear.jsp" %> <% Class.forName(MM_WEBFORM_DRIVER ); Connection con = null; con = DriverManager.getConnection(MM_WEBFORM_STRING,MM_WEBFORM_USERNAME,MM_WEBFORM_PASSWORD); Statement stmt = con.createStatement(); ResultSet rs; // uncomment this line after the deadline //response.sendRedirect("http://www.eui.eu/About/ApplytotheEUI.aspx"); String realPATH = request.getRealPath("/"); String IPADDRESS = request.getRemoteAddr(); String CANDKEY = ""; String redirect = ""; String title = ""; String subtitle = ""; String deadline = ""; // Check that chaircode is valid and deadline has not expired if (request.getParameter("bypass")!=null) { rs=stmt.executeQuery("select TITLE, SUBTITLE || ' ' SUBTITLE, to_char(deadline,'DD Month YYYY') DEADLINE from CHAIRFORM where CHAIRCODE='" + request.getParameter("chair") + "'"); } else { rs=stmt.executeQuery("select TITLE, SUBTITLE || ' ' SUBTITLE, to_char(deadline,'DD Month YYYY') DEADLINE from CHAIRFORM where CHAIRCODE='" + request.getParameter("chair") + "' and DEADLINE+1+POSTPONE_DEADLINE>=SYSDATE"); } if (rs.next()) { title=rs.getString("TITLE"); subtitle=rs.getString("SUBTITLE"); deadline=rs.getString("DEADLINE"); } else { redirect = "https://apps.eui.eu/Servac/Online/Applications/ChairPostDeadline.jsp"; response.sendRedirect(redirect); } rs.close(); con.close(); String str_CHAIRCODE = "LAW2012-08"; if (request.getParameter("chair")!=null) str_CHAIRCODE = request.getParameter("chair"); CANDKEY = (String)session.getValue("CANDKEY"); // Define the string parameters for the field values String str_YEAR =str_candyear; String str_IP =IPADDRESS; String str_TITLE = ""; String str_SURNAME = ""; String str_FORENAMES = ""; String str_CITIZENOF = ""; String str_AUXCITIZEN = ""; String str_BIRTHDATE_GG = ""; String str_BIRTHDATE_MM = ""; String str_BIRTHDATE_YY = ""; String str_BIRTHPLACE = ""; String str_BIRTHCNTRY = ""; String str_SEX = ""; String str_CIVILSTAT = ""; String str_NUMOFKIDS = ""; String str_LANG1 = ""; String str_LANG2 = ""; String str_LANG3 = ""; String str_LANG4 = ""; String str_LANG5 = ""; String str_LANG6 = ""; String str_LANG1_KNOWLEDGE = ""; String str_LANG2_KNOWLEDGE = ""; String str_LANG3_KNOWLEDGE = ""; String str_LANG4_KNOWLEDGE = ""; String str_LANG5_KNOWLEDGE = ""; String str_LANG6_KNOWLEDGE = ""; String str_ADDRINSTITUTE = ""; String str_ADDRLINE1 = ""; String str_ADDRLINE2 = ""; String str_ADDRLINE3 = ""; String str_ADDRLINE4 = ""; String str_ADDRZIP = ""; String str_ADDRCITY = ""; String str_ADDRCNTRY = ""; String str_EMAIL = ""; String str_CONFIRM_EMAIL = ""; String str_TELEPHONE = ""; String str_FAX = ""; String str_CURPOSITION = ""; String str_CURINSTITUTE = ""; String str_HIGHESTDEGREE = ""; String str_DEGREEDATE_GG = ""; String str_DEGREEDATE_MM = ""; String str_DEGREEDATE_YY = ""; String str_DEGREEINSTITUTE = ""; String str_EXPECTDOCT_TITLE = ""; String str_EXPECTDOCTDATE_GG = ""; String str_EXPECTDOCTDATE_MM = ""; String str_EXPECTDOCTDATE_YY = ""; String str_STARTSTAY_GG = ""; String str_STARTSTAY_MM = ""; String str_STARTSTAY_YY = ""; String str_ENDSTAY_GG = ""; String str_ENDSTAY_MM = ""; String str_ENDSTAY_YY = ""; String str_TITLEPROPOSAL = ""; String str_RES_TYPE_PUB = ""; String str_SUMRESPROPOSAL = ""; String str_RESASREA = ""; String str_EUIPROF = ""; String str_CONTRIBACTIV = ""; String str_REF1POSITION = ""; String str_REF1FORENAMES = ""; String str_REF1SURNAME = ""; String str_REF1INSTITUTE = ""; String str_REF1EMAIL = ""; String str_REF1EMAILOK = ""; String str_REF1TELEPHONE = ""; String str_REF1FAX = ""; String str_REF2POSITION = ""; String str_REF2FORENAMES = ""; String str_REF2SURNAME = ""; String str_REF2INSTITUTE = ""; String str_REF2EMAIL = ""; String str_REF2EMAILOK = ""; String str_REF2TELEPHONE = ""; String str_REF2FAX = ""; String str_OTHERSOURCE = ""; String str_WHEREKNOWUS = ""; String str_WHEREKNOWUS_NOTE = ""; String str_ATEUIBEFORE = ""; String str_FILE_CV = ""; String str_FILE_RESEARCH = ""; String str_FILE_PUBLICATIONS = ""; String str_FILE_COVER_LETTER = ""; String str_ADDITIONAL_REMARKS = ""; String str_ADDITIONALINCOME =""; String str_RESTHEME_RSC=""; String str_CANON_APP=""; int int_NUMOFKIDS = 0; int int_BIRTHDATE_GG = 0; int int_BIRTHDATE_MM = 0; int int_BIRTHDATE_YY = 0; int int_DEGREEDATE_GG = 0; int int_DEGREEDATE_MM = 0; int int_DEGREEDATE_YY = 0; int int_EXPECTDOCTDATE_GG = 0; int int_EXPECTDOCTDATE_MM = 0; int int_EXPECTDOCTDATE_YY = 0; int int_STARTSTAY_GG = 1; int int_STARTSTAY_MM = 9; int int_STARTSTAY_YY = int_candyear; int int_ENDSTAY_GG = 31; int int_ENDSTAY_MM = 8; int int_ENDSTAY_YY = int_candyear + 2; // end field DefinITION the string parameters for the field values String str_MODE = "INSERT"; // Connect to the database and retrieve the data for this candidate if (CANDKEY!= null) { // Class.forName(MM_WEBFORM_DRIVER ); //Connection con = null; // con = DriverManager.getConnection(MM_WEBFORM_STRING,MM_WEBFORM_USERNAME,MM_WEBFORM_PASSWORD); PreparedStatement Statement; String query=""; // select the details for the candidate query = "SELECT YEAR ,IP ,TITLE ,SURNAME ,FORENAMES ,CITIZENOF ,AUXCITIZEN ,TO_CHAR(BIRTHDATE, 'dd') ,to_char(BIRTHDATE, 'MM') , to_char(BIRTHDATE, 'YYYY') ,BIRTHPLACE ,BIRTHCNTRY ,SEX ,CIVILSTAT ,NUMOFKIDS ,'' ,'' ,'' ,'' ,'' , '' ,'' ,'' ,'' ,'' ,'' ,'' ,LANG1 ,LANG1_KNOWLEDGE ,LANG2 ,LANG2_KNOWLEDGE , LANG3 ,LANG3_KNOWLEDGE ,LANG4 ,LANG4_KNOWLEDGE , LANG5 ,LANG5_KNOWLEDGE , ADDRINSTITUTE, ADDRLINE1 ,ADDRLINE2 ,ADDRLINE3 ,ADDRLINE4 ,ADDRZIP ,ADDRCITY ,ADDRCNTRY ,EMAIL ,CONFIRM_EMAIL ,TELEPHONE ,FAX ,CURPOSITION ,CURINSTITUTE ,HIGHESTDEGREE ,TO_CHAR(DEGREEDATE, 'dd') ,TO_CHAR(DEGREEDATE, 'MM') ,TO_CHAR(DEGREEDATE, 'YYYY') ,DEGREEINSTITUTE ,EXPECTDOCT_TITLE ,TO_CHAR(EXPECTDOCTDATE,'dd') , TO_CHAR(EXPECTDOCTDATE, 'MM') ,TO_CHAR(EXPECTDOCTDATE, 'YYYY') ,'' ,'' ,TO_CHAR(STARTSTAY, 'dd') ,TO_CHAR(STARTSTAY, 'MM') ,TO_CHAR(STARTSTAY, 'YYYY') ,TO_CHAR(ENDSTAY, 'dd') ,TO_CHAR(ENDSTAY, 'MM') ,TO_CHAR(ENDSTAY, 'YYYY') ,TITLEPROPOSAL ,RES_TYPE_PUB ,SUMRESPROPOSAL ,RESASREA ,EUIPROF ,CONTRIBACTIV ,REF1POSITION ,REF1FORENAMES ,REF1SURNAME ,REF1INSTITUTE ,REF1EMAIL ,REF1EMAILOK ,REF1TELEPHONE ,REF2POSITION ,REF2FORENAMES ,REF2SURNAME ,REF2INSTITUTE ,REF2EMAIL ,REF2EMAILOK ,REF2TELEPHONE ,OTHERSOURCE ,WHEREKNOWUS ,'', ADDITIONAL_REMARKS ,CV_NAME,RESEARCH_NAME, PUBLICATIONS_NAME ,'','','','','','','','','','','','','','','', '', WHEREKNOWUS_NOTE, CANON_APP FROM saadm.CAN_CHAIR P WHERE and P.CANNUM||'_'||Replace(P.IP, '.','') = ?"; // Exist on Database Statement = con.prepareStatement(query); Statement.setString(1, CANDKEY ); rs = Statement.executeQuery(); if (rs.next()) { str_MODE = "UPDATE"; // get and set the Parameter values from the database str_YEAR = ParseNullString(rs.getString(1)); str_IP = ParseNullString(rs.getString(2)); str_TITLE = ParseNullString(rs.getString(3)); str_SURNAME = ParseNullString(rs.getString(4)); str_FORENAMES = ParseNullString(rs.getString(5)); str_CITIZENOF = ParseNullString(rs.getString(6)); str_AUXCITIZEN = ParseNullString(rs.getString(7)); str_BIRTHDATE_GG = ParseNullString(rs.getString(8)); str_BIRTHDATE_MM = ParseNullString(rs.getString(9)); str_BIRTHDATE_YY = ParseNullString(rs.getString(10)); str_BIRTHPLACE = ParseNullString(rs.getString(11)); str_BIRTHCNTRY = ParseNullString(rs.getString(12)); str_SEX = ParseNullString(rs.getString(13)); str_CIVILSTAT = ParseNullString(rs.getString(14)); int_NUMOFKIDS = rs.getInt(15); str_LANG1 = ParseNullString(rs.getString(28)); str_LANG1_KNOWLEDGE = ParseNullString(rs.getString(29)); str_LANG2 = ParseNullString(rs.getString(30)); str_LANG2_KNOWLEDGE = ParseNullString(rs.getString(31)); str_LANG3 = ParseNullString(rs.getString(32)); str_LANG3_KNOWLEDGE = ParseNullString(rs.getString(33)); str_LANG4 = ParseNullString(rs.getString(34)); str_LANG4_KNOWLEDGE = ParseNullString(rs.getString(35)); str_LANG5 = ParseNullString(rs.getString(36)); str_LANG5_KNOWLEDGE = ParseNullString(rs.getString(37)); str_ADDRINSTITUTE = ParseNullString(rs.getString(38)); str_ADDRLINE1 = ParseNullString(rs.getString(39)); str_ADDRLINE2 = ParseNullString(rs.getString(40)); str_ADDRLINE3 = ParseNullString(rs.getString(41)); str_ADDRLINE4 = ParseNullString(rs.getString(42)); str_ADDRZIP = ParseNullString(rs.getString(43)); str_ADDRCITY = ParseNullString(rs.getString(44)); str_ADDRCNTRY = ParseNullString(rs.getString(45)); str_EMAIL = ParseNullString(rs.getString(46)); str_CONFIRM_EMAIL = ParseNullString(rs.getString(47)); str_TELEPHONE = ParseNullString(rs.getString(48)); str_FAX = ParseNullString(rs.getString(49)); str_CURPOSITION = ParseNullString(rs.getString(50)); str_CURINSTITUTE = ParseNullString(rs.getString(51)); str_HIGHESTDEGREE = ParseNullString(rs.getString(52)); str_DEGREEDATE_GG = ParseNullString(rs.getString(53)); str_DEGREEDATE_MM = ParseNullString(rs.getString(54)); str_DEGREEDATE_YY = ParseNullString(rs.getString(55)); str_DEGREEINSTITUTE = ParseNullString(rs.getString(56)); str_EXPECTDOCT_TITLE = ParseNullString(rs.getString(57)); str_EXPECTDOCTDATE_GG = ParseNullString(rs.getString(58)); str_EXPECTDOCTDATE_MM = ParseNullString(rs.getString(59)); str_EXPECTDOCTDATE_YY = ParseNullString(rs.getString(60)); str_STARTSTAY_GG = ParseNullString(rs.getString(63)); str_STARTSTAY_MM = ParseNullString(rs.getString(64)); str_STARTSTAY_YY = ParseNullString(rs.getString(65)); str_ENDSTAY_GG = ParseNullString(rs.getString(66)); str_ENDSTAY_MM = ParseNullString(rs.getString(67)); str_ENDSTAY_YY = ParseNullString(rs.getString(68)); str_TITLEPROPOSAL = ParseNullString(rs.getString(69)); str_RES_TYPE_PUB = ParseNullString(rs.getString(70)); str_SUMRESPROPOSAL = ParseNullString(rs.getString(71)); str_RESASREA = ParseNullString(rs.getString(72)); str_EUIPROF = ParseNullString(rs.getString(73)); str_CONTRIBACTIV = ParseNullString(rs.getString(74)); str_REF1POSITION = ParseNullString(rs.getString(75)); str_REF1FORENAMES = ParseNullString(rs.getString(76)); str_REF1SURNAME = ParseNullString(rs.getString(77)); str_REF1INSTITUTE = ParseNullString(rs.getString(78)); str_REF1EMAIL = ParseNullString(rs.getString(79)); str_REF1EMAILOK = ParseNullString(rs.getString(80)); str_REF1TELEPHONE = ParseNullString(rs.getString(81)); str_REF2POSITION = ParseNullString(rs.getString(82)); str_REF2FORENAMES = ParseNullString(rs.getString(83)); str_REF2SURNAME = ParseNullString(rs.getString(84)); str_REF2INSTITUTE = ParseNullString(rs.getString(85)); str_REF2EMAIL = ParseNullString(rs.getString(86)); str_REF2EMAILOK = ParseNullString(rs.getString(87)); str_REF2TELEPHONE = ParseNullString(rs.getString(88)); str_OTHERSOURCE = ParseNullString(rs.getString(89)); str_WHEREKNOWUS = ParseNullString(rs.getString(90)); str_ATEUIBEFORE = ParseNullString(rs.getString(91)); str_ADDITIONAL_REMARKS = ParseNullString(rs.getString(92)); str_FILE_CV = ParseNullString(rs.getString(93)); str_FILE_RESEARCH = ParseNullString(rs.getString(94)); str_FILE_PUBLICATIONS = ParseNullString(rs.getString(95)); str_WHEREKNOWUS_NOTE = ParseNullString(rs.getString(112)); str_CANON_APP = ParseNullString(rs.getString(113)); if (str_CANON_APP.equals("Y")) str_CANON_APP="checked"; // put to int values int_BIRTHDATE_GG = Integer.parseInt(str_BIRTHDATE_GG); int_BIRTHDATE_MM = Integer.parseInt(str_BIRTHDATE_MM); int_BIRTHDATE_YY = Integer.parseInt(str_BIRTHDATE_YY); int_DEGREEDATE_GG = convert_stringtoint(str_DEGREEDATE_GG, 1); int_DEGREEDATE_MM = convert_stringtoint(str_DEGREEDATE_MM, 12); int_DEGREEDATE_YY = convert_stringtoint(str_DEGREEDATE_YY, int_candyear-1); int_EXPECTDOCTDATE_GG = convert_stringtoint(str_EXPECTDOCTDATE_GG, 0); int_EXPECTDOCTDATE_MM = convert_stringtoint(str_EXPECTDOCTDATE_MM, 0); int_EXPECTDOCTDATE_YY = convert_stringtoint(str_EXPECTDOCTDATE_YY, 0); int_STARTSTAY_GG = convert_stringtoint(str_STARTSTAY_GG, 31); int_STARTSTAY_MM = convert_stringtoint(str_STARTSTAY_MM, 1); int_STARTSTAY_YY = convert_stringtoint(str_STARTSTAY_YY, int_candyear); int_ENDSTAY_GG = convert_stringtoint(str_ENDSTAY_GG, 30); int_ENDSTAY_MM = convert_stringtoint(str_ENDSTAY_MM, 6); int_ENDSTAY_YY = convert_stringtoint(str_ENDSTAY_YY, 2008); rs.close(); } Statement.close(); con.close(); } // IAS CANDKEY SET? %> <%! String blanknull(String s) { return (s == null) ? "" : s; } %>