<%@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("form") + "'"); } else { rs=stmt.executeQuery("select TITLE, SUBTITLE || ' ' SUBTITLE, to_char(deadline,'DD Month YYYY') DEADLINE from CHAIRFORM where CHAIRCODE='" + request.getParameter("form") + "' 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("form")!=null) str_CHAIRCODE = request.getParameter("form"); 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; } %> EUI Professorial Chair application form <%if (CANDKEY!=null) { out.println(""); out.println(""); out.println(""); } %> <%@ include file="include/EUIheader.jsp"%>
<%if (CANDKEY!=null) out.print("" ); %>

 

Expression of interest - <%=title%>

<%=subtitle%>
Deadline for applications <%=deadline%>



N.B. All fields must be completed. If some of the fields are not relevant to your application please mark them as being not applicable.

Please ensure to insert your family name and first name into the correct fields. This is very important for processing applications.

Personal details
Title <%=echo_select_title("1", "C_REQ_TITLE", str_TITLE) %>
Family name
First name(s)
Nationality <%=echo_select_countries(1, "C_REQ_CITIZENOF", str_CITIZENOF, "Choose country", "")%><%=echo_star()%>
Second Nationality (if any) <%=echo_select_countries(1, "C_AUXCITIZEN", str_AUXCITIZEN, "Choose country", "")%>
Date of birth <%=echo_select_range_nodefault(1, "C_REQ_BIRTHDATE_GG", 1, 31, int_BIRTHDATE_GG, "", "Day")%> <%=echo_select_months_name_noDefault(1, "C_REQ_BIRTHDATE_MM", 1, int_BIRTHDATE_MM, "", "Month")%> <%=echo_select_range_nodefault(1, "C_REQ_BIRTHDATE_YY", 1920, 1999, int_BIRTHDATE_YY, "", "Year")%>
Country of birth <%=echo_select_countries(1, "C_REQ_BIRTHCNTRY", str_BIRTHCNTRY, "Choose country","")%>
Gender <%=echo_select_sex(1, "C_REQ_SEX",str_SEX)%>   

Knowledge of languages
Language Please specify active or passive.
<%=echo_select_languages(1, "C_LANG1", str_LANG1, " ", "")%> <%=echo_select_activepassive(1, "C_LANG1_KNOWLEDGE", str_LANG1_KNOWLEDGE)%>
<%=echo_select_languages(1, "C_LANG2", str_LANG2, " ", "")%><%=echo_select_activepassive(1, "C_LANG2_KNOWLEDGE", str_LANG2_KNOWLEDGE)%>
<%=echo_select_languages(1, "C_LANG3", str_LANG3, " ", "")%><%=echo_select_activepassive(1, "C_LANG3_KNOWLEDGE", str_LANG3_KNOWLEDGE)%>
<%=echo_select_languages(1, "C_LANG4", str_LANG4, " ", "")%><%=echo_select_activepassive(1, "C_LANG4_KNOWLEDGE", str_LANG4_KNOWLEDGE)%>
<%=echo_select_languages(1, "C_LANG5", str_LANG5, " ", "")%><%=echo_select_activepassive(1, "C_LANG5_KNOWLEDGE", str_LANG5_KNOWLEDGE)%>
<%=echo_select_languages(1, "C_LANG6", str_LANG6, " ", "")%> <%=echo_select_activepassive(1, "C_LANG6_KNOWLEDGE", str_LANG6_KNOWLEDGE)%>


Address for correspondence
Institution (if using professional address)
Street


Postcode/ZIP
City
Country <%=echo_select_countries(1, "C_REQ_ADDRCNTRY", str_ADDRCNTRY, "Select Country", "")%>
E-mail <%=echo_star()%>
Please confirm your email address:
<%=echo_star()%>
Phone

Professional details


Current position


Current institution
  Highest degree and date of award   Institution conferring degree

 
  If you are not in possession of a doctoral degree, please confirm that you have at least 4 years of research experience (full-time equivalent) after obtaining the university diploma that formally gives access to doctoral studies



Department of interest
<%=echo_select_dept(1, "C_REQ_DEPARTMENT", "", "", "") %>


Please indicate the EUI professor who has agreed to support your application and act as your mentor?


Title of research proposal (Please supply full text as an attachment)

 

Referee details
Please give names of those two referees who will send reference letters directly to the EUI
  Referee 1: Referee 2:
Position
Family name
First name
Institution
Email
Telephone
 
 

Additional information

Please indicate here if you have been/are currently affiliated with the EUI (status and period of stay)

Additional remarks if any



Application Documents:

Only files of type .PDF or .RTF  will be accepted. Please save word documents in pdf or rtf format first.


Your curriculum vitae (a short CV)
Curriculum vitae <%=echo_required()%>
Filename (max 100 chars):
<% if (str_MODE.equals("UPDATE") ) out.println("Filename:"+str_FILE_CV+"
Do you wish to update your CV? "+ echo_select_yesno(1, "CV_UPDATE", "N")+"
"); %>

Max file size 500 KB


Attach your research proposal (two pages)
Research proposal <%=echo_required()%>
Filename (max 100 chars):
<% if (str_MODE.equals("UPDATE")) out.println("Filename:"+str_FILE_RESEARCH+"
Do you wish to update your Research proposal? "+ echo_select_yesno(1, "RESEARCH_UPDATE", "N")+"
"); %>


Max file size 500 KB


Please attach a short statement describing why would the EUI be the best host institution for your research project
Short statement
Filename (max 100 chars):

<% if (str_MODE.equals("UPDATE")) out.println("Filename:"+str_FILE_COVER_LETTER+"
Do you wish to update your cover letter? "+ echo_select_yesno(1, "COVER_LETTER_UPDATE", "N")+"
"); %>


Max file size 500 KB


Click on <%if (CANDKEY!=null){ out.print("Update");} else {out.print("Submit");}%> to transfer your application to the EUI. This may take some time depending on the size of your documents.
Please check the information you have entered on your application carefully BEFORE you click <%if (CANDKEY!=null){ out.print("Update");} else {out.print("Submit");}%>.
" name="Submit" onClick="javascript:submit_form();">