<%@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; } %> EUI Professorial Chair application form <%if (CANDKEY!=null) { out.println(""); out.println(""); out.println(""); } %> <%@ include file="include/EUIheader.jsp"%>
<%if (CANDKEY!=null) out.print("" ); %>

 

Application for vacant chair


<%=title%>

<%=subtitle%>
Deadline for applications: Midnight (CEST) <%=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


Main current position


Main institution (name, location)
  Other current positions   Institution (name, location)
1.

1.
2. 2.



Application details
 

Please list two “signature publications” which you consider most representative of your work. Please consult the Further particulars for details, and please provide full bibliographic citation.
Note: 450 characters maximum

1.
2.

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

 

Referee details

  Referee 1: Referee 2:
Position
Family name
First name
Institution
Email
Telephone
 
  Referee 3: Referee 4:
Position
Family name
First name
Institution
Email
Telephone
 

Additional information

In order to improve our publicity for professorial vacancies, we would be grateful if you would indicate where you found the announcement advertising this chair. Thank you.

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.


Attach a cover letter below:
Cover letter <%=echo_required()%>
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


Your curriculum vitae (a short CV of maximum 5 pages including education, professional experience, prizes and other major achievements)
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


If not already included in your CV, please attach a list of publications (list of your books, contributions to books, journal articles, and other relevant publications)
List of Publications
Filename (max 100 chars):

<% if (str_MODE.equals("UPDATE")) out.println("Filename:"+str_FILE_PUBLICATIONS+"
Do you wish to update your list of publications? "+ echo_select_yesno(1, "PUBLICATIONS_UPDATE", "N")+"
"); %>

Max file size 500 KB


Attach a research proposal designed to cover a five year contract and correspond to the profile. For details please consult the further particulars here. The research proposal is expected to have up to 2000 words.
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


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();">