<%@ page import = "java.io.*" %> <%@ page import = "java.lang.*" %> <%@ page import = "java.sql.*" %> <%@ page import = "java.util.*" %> <%@ page import = "javax.naming.*" %> <%@ page import = "javax.sql.*" %> <%@ page import = "yppo.util.*" %> <%@ page contentType="text/html;charset=ISO-8859-7" %> <% //Πληροφορίες οντότητας //1. Μουσείο //2. Μνημείο //3. Αρχαιολογικός Χώρος String ont_id = "3"; %> <% //ορίζουμε σε ποιά γλώσσα θα εμφανιστεί η πληροφορία String lang = request.getParameter("lang")==null?"gr":request.getParameter("lang"); lang="en"; if (!lang.equals("gr") && !lang.equals("en")) { lang = "gr"; } String langSuffix = ""; if (lang.equals("en")) { langSuffix = "_EN"; } String langPrefix = ""; if (lang.equals("en")) { langPrefix = "e"; } if (lang.equals("gr")) { langPrefix = "g"; } //declare database-related and other important objects here Statement stmt = null; ResultSet rset = null; Connection conn = null; Statement glstmt = null; ResultSet glrset = null; String gl_count = ""; DataSource ds = null; InitialContext ic = null; yppo.util myUtil = new yppo.util(); String strSQL = ""; StringBuffer theSQL = new StringBuffer(10000); String leftTableString = ""; String lhmmaid = ""; String lhmma = ""; String editor1 = ""; String editor2 = ""; String editor3 = ""; String titlos = ""; String address = ""; String eidosid = ""; String eidos = ""; String tel = ""; String fax = ""; String oraria = ""; String olokliro = ""; String meiomeno = ""; String ticketgroupid = ""; String uniticketgroupid = ""; String tickets = ""; String unitickets = ""; String ticketcomments = ""; String uniticketcomments = ""; String fotoid = ""; String fotolezanta = ""; String fotocopyright = ""; String fotosize = ""; int mege8os = 0; String unesco = ""; String other_ant_id = ""; String other_ant_titlos = ""; int other_ant_mege8os = 0; String other_ant_href = ""; String other_ont_id = ""; String outer_url = ""; String outer_titlos = ""; String uniti_id = ""; String uniti_titlos = ""; String uniti_ontid = ""; String uniti_href = ""; String glossaryid = ""; String glossaryname = ""; String allglossary = ""; //για το banner πάνω-πάνω String fotobannersrc = ""; //gia to banner me ton titlo prin to paste toy periexomenoy ston pinaka ths selidas String unesco_cnt = ""; String parent_museum_id = ""; String parent_arch_xwros_id = ""; String eidos_title = "Είδος"; String address_title = "Διεύθυνση"; String tel_title = "Τηλέφωνο"; String fax_title = "Φαξ"; String oraria_title = "Ωράρια"; String oraria_w_title = "Χειμερινό: "; String oraria_s_title = "Θερινό: "; String tickets_title = "Εισιτήρια"; String unitickets_title = "Ενιαία Εισιτήρια"; String editors_title = "Author"; String html_title = ""; String titlos_bn = ""; String euroSign = "€"; String thisCateg = request.getParameter("theme_id")==null?"21":request.getParameter("theme_id"); String obj_id = request.getParameter("obj_id"); if (myUtil.isInvalidAnt(obj_id,ont_id,"testing")) { %> <% } try { //retrieve-connection ic = new InitialContext(); ds = (DataSource) ic.lookup("jdbc/OracleDS"); conn = ds.getConnection(); stmt = conn.createStatement(); glstmt = conn.createStatement(); %> <% yppo.content myContent = new yppo.content(conn); //εδώ τραβάμε στο array leftArrays[][] τα links που πρέπει να εμφανιστούν στο αριστερό μέρος //Το array αυτό θα δοθεί ως παράμετρος στη συνάρτηση content.buildLeftTable() String[][] leftArrays = new String[50][3]; for (int i=0;i<50;i++) { leftArrays[i][0] = null; //title leftArrays[i][1] = "0"; //isLeaf leftArrays[i][2] = ""; //theURL } leftArrays = myContent.populateOntothtaLeftArrays(conn,ont_id,obj_id,lang); html_title = myContent.fetchPageTitle(conn,"h352.jsp",lang); leftTableString = myFrame.buildLeftTable(leftArrays,0,"h352.jsp"); %> <% //εδώ τραβάμε τα γενικά στοιχεία theSQL = new StringBuffer(); theSQL.append("SELECT A.NAME1"+langSuffix+", A.MEGE8OS, A.ADDRESS"+langSuffix+", A.TEL, A.FAX, "); theSQL.append(" A.SCHEDULES_ALL"+langSuffix+", A.SCHEDULES_WINTER"+langSuffix+", A.SCHEDULES_SUMMER"+langSuffix+", "); theSQL.append(" A.TICKET_GROUP_ID, A.UNIFORM_TICKET_GROUP_ID, A.TICKET_COMMENTS"+langSuffix+", A.UNIFORM_TICKET_COMMENTS"+langSuffix+",A.unesco "); theSQL.append(" FROM ANT A WHERE A.ANT_ID=" + obj_id); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { titlos = rset.getString(1); } if (rset.getString(2)!=null) { mege8os = rset.getInt(2); } if (rset.getString(3)!=null) { address = rset.getString(3); } if (rset.getString(4)!=null) { tel = rset.getString(4); } if (rset.getString(5)!=null) { fax = rset.getString(5); } if (rset.getString(6)!=null) { oraria = rset.getString(6); } if (oraria.equals("")) { if (rset.getString(7)!=null) { oraria = oraria_w_title + myUtil.nToBr(rset.getString(7),true,0,1); } if (rset.getString(8)!=null) { oraria = oraria + "
" + oraria_s_title + myUtil.nToBr(rset.getString(8),true,0,1); } } if (rset.getString(9)!=null) { ticketgroupid = rset.getString(9); } if (rset.getString(10)!=null) { uniticketgroupid = rset.getString(10); } if (rset.getString(11)!=null) { ticketcomments = rset.getString(11); } if (rset.getString(12)!=null) { uniticketcomments = rset.getString(12); } if (rset.getString(13)!=null) { unesco = rset.getString(13); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% //εδώ τραβάμε τα κανονικά εισιτήρια olokliro=""; meiomeno=""; if (!ticketgroupid.equals("")) { theSQL = new StringBuffer(); theSQL.append("SELECT TP1.TICKET_PRICE, TP2.TICKET_PRICE FROM TICKET_GROUP TG, TICKET_PRICE TP1, TICKET_PRICE TP2 "); theSQL.append("WHERE TG.REDUCED_TICKET_PRICE_ID=TP1.TICKET_PRICE_ID "); theSQL.append("AND TG.FREE_TICKET_PRICE_ID=TP2.TICKET_PRICE_ID "); theSQL.append("AND TG.TICKET_GROUP_ID="+ticketgroupid); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { olokliro = rset.getString(1); } if (rset.getString(2)!=null) { meiomeno = rset.getString(2); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} tickets = ""; if ((!olokliro.equals("")) && (!olokliro.equals("0"))) { tickets = tickets + "Ολόκληρο: " + euroSign + olokliro + ", "; } if ((!meiomeno.equals("")) && (!meiomeno.equals("0"))) { tickets = tickets + "Μειωμένο: " + euroSign + meiomeno + ", "; } if (tickets.length()>0) { tickets = tickets.substring(0,tickets.length()-2); } if (!ticketcomments.equals("")) { if (!tickets.equals("")) { tickets = tickets + "
"; } tickets = tickets + ticketcomments; } //if (tickets.length()>0) { tickets = tickets.substring(0,tickets.length()-4); } } %> <% //εδώ τραβάμε τα ενιαία εισιτήρια olokliro=""; meiomeno=""; if (!uniticketgroupid.equals("")) { theSQL = new StringBuffer(); theSQL.append("SELECT TP1.TICKET_PRICE, TP2.TICKET_PRICE FROM TICKET_GROUP TG, TICKET_PRICE TP1, TICKET_PRICE TP2 "); theSQL.append("WHERE TG.REDUCED_TICKET_PRICE_ID=TP1.TICKET_PRICE_ID "); theSQL.append("AND TG.FREE_TICKET_PRICE_ID=TP2.TICKET_PRICE_ID "); theSQL.append("AND TG.TICKET_GROUP_ID="+uniticketgroupid); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { olokliro = rset.getString(1); } if (rset.getString(2)!=null) { meiomeno = rset.getString(2); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} unitickets = ""; if (!olokliro.equals("")) { unitickets = unitickets + "Ολόκληρο: " + olokliro; } if (!meiomeno.equals("")) { unitickets = unitickets + ", Μειωμένο: " + meiomeno; } if (!uniticketcomments.equals("")) { unitickets = unitickets + "
"+ uniticketcomments; } } %> <% //εδώ τραβάμε το είδος strSQL = "SELECT CV.CVALUE_ID, CV.TITLE"+langSuffix+" FROM CVALUE CV, ANT_VALUE AV WHERE CV.CVALUE_ID=AV.CVALUE_ID AND CV.CATEG_ID=1 AND AV.ANT_ID="+obj_id+" ORDER BY AV.HAS_ORDER"; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { eidosid = rset.getString(1); } if (rset.getString(2)!=null) { eidos = rset.getString(2); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% //εδώ τραβάμε τη περιγραφή theSQL = new StringBuffer(10000); theSQL.append("SELECT LB.LHMMA_BODY,L.EDITOR1"+langSuffix+",L.EDITOR2"+langSuffix+",L.EDITOR3"+langSuffix+",L.LHMMA_ID "); theSQL.append(" FROM LHMMA L, ANT_LHMMA AL, LHMMA_BODY LB "); theSQL.append(" WHERE AL.LHMMA_ID=L.LHMMA_ID "); theSQL.append(" AND L.EIDOS_LHMMATOS_ID=3 "); theSQL.append(" AND L.ON_SITE=1 "); theSQL.append(" AND L.LHMMA_BODY"+langSuffix+"_ID=LB.LHMMA_BODY_ID "); theSQL.append(" AND AL.ANT_ID=" + obj_id); strSQL = theSQL.toString(); rset = stmt.executeQuery(strSQL); if (rset.next()) { lhmma = rset.getString(1); if (lhmma==null) { lhmma=""; } if (rset.getString(2)!=null) { editor1 = rset.getString(2); } if (rset.getString(3)!=null) { editor2 = rset.getString(3); } if (rset.getString(4)!=null) { editor3 = rset.getString(4); } if (rset.getString(5)!=null) { lhmmaid = rset.getString(5); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <%//εδώ ανακτούμε το θέμα του αντικειμένου strSQL = "select min(c.parent_id) from cvalue c, ant a, ant_value av where a.ant_id=av.ant_id and av.cvalue_id=c.cvalue_id and a.ant_id="+obj_id; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) {thisCateg=rset.getString(1); } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% //εδώ τραβάμε τη φωτογραφία για το banner if (mege8os==2) { fotobannersrc = "/Thematikos Katalogos Banners/cat3s"+thisCateg+".swf?titlos="+titlos; } else { strSQL = "SELECT M.MULTIMEDIA_ID FROM MULTIMEDIA M WHERE M.CATEG_MULTIMEDIA_ID=6 AND M.FP_BLOB IS NOT NULL AND M.ON_SITE=1 AND M.ANT_ID="+obj_id; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { fotobannersrc="/java/image?foto_id="+rset.getString(1)+"&size=fp"; } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} if ((fotobannersrc.equals("")) && (!eidosid.equals(""))) { fotobannersrc = "/Thematikos Katalogos Banners/cat3s"+thisCateg+".swf?titlos="+titlos; } else { fotobannersrc = "/0/banner_all.swf?titlos="+myUtil.rQuotes(titlos,false,true); } } %> <% //εδώ τραβάμε τη φωτογραφία strSQL = "SELECT M.MULTIMEDIA_ID, M.LEZANTA"+langSuffix+", M.COPYRIGHT"+langSuffix+", M.COPYRIGHT_CREATOR"+langSuffix+" FROM MULTIMEDIA M WHERE M.M2_BLOB IS NOT NULL AND M.ON_SITE=1 AND M.ANT_ID="+obj_id+" ORDER BY M.MULTIMEDIA_ORDER ASC"; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.next()) { if (rset.getString(1)!=null) { fotoid = rset.getString(1); } if (rset.getString(2)!=null) { fotolezanta = rset.getString(2); } if (rset.getString(3)!=null) { fotocopyright = "© " + rset.getString(3); } if (rset.getString(4)!=null) { fotocopyright = "© " + rset.getString(3) + ", " + "© " + rset.getString(4); } fotosize = "m2"; } //end-if } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} %> <% // εδώ καθορίζουμε τη φωτογραφία που θα εμφανίζεται στο banner strSQL = "select unesco, museum_id, arch_xwros_id from ant where ant_id="+obj_id; rset = stmt.executeQuery(strSQL); if (rset.next()) { if (rset.getString(1)!=null) { unesco_cnt = rset.getString(1); } if (rset.getString(2)!=null) { parent_museum_id = rset.getString(2); } else { parent_museum_id = "0"; } if (rset.getString(3)!=null) { parent_arch_xwros_id = rset.getString(3); } else { parent_arch_xwros_id = "0"; } } //end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} if (!unesco_cnt.equals("0")) { fotobannersrc = "/Banners_pcs/"+obj_id+".jpg"; } %> Ministry of Culture and Sports | <%=titlos%> <%if (unesco_cnt.equals("0")) { strSQL = "SELECT CV.parent_ID,cv.cvalue_id FROM CVALUE CV, ANT_VALUE AV "; strSQL = strSQL + " WHERE CV.CVALUE_ID=AV.CVALUE_ID"; strSQL = strSQL + " AND CV.CATEG_ID=1 and av.has_order=1 and av.ant_id="+obj_id; rset = stmt.executeQuery(strSQL); String categ = ""; if (rset.next()) { if (rset.getString(1)!=null) { categ = rset.getString(1); } else { if (rset.getString(2)!=null) { categ = rset.getString(2); } } } if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} fotobannersrc = "/Banners_pcs/thematikos katalogos/cat3_"+categ+".jpg"; } %> <%=leftTableString%> <% // ---------------------------------------------------------------------- %> <% // ------------------ εδώ αρχίζει το table με την πληροφορία ------------ %> <% //----------------------------- αρχή του paste εδώ ---------------------- %> <% // ---------------------------------------------------------------------- %>
<% //εδώ τραβάμε το γλωσσάρι if (!lhmmaid.equals("")) { strSQL = "SELECT G.ANT_ID, G.NAME1"+langSuffix+" "; strSQL = strSQL + " FROM LHMMA_GLOSSARY LG, ANT G "; strSQL = strSQL + " WHERE LG.GLOSSARY_ID=G.ANT_ID "; strSQL = strSQL + " AND LG.LHMMA_ID="+lhmmaid; strSQL = strSQL + " ORDER BY LG.HAS_ORDER ASC"; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% }//end-if if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} } %> <% //See Also %> <% //εδώ τραβάμε όλες τα σχετικά αντικείμενα του ίδιου κόμβου strSQL = "SELECT A2.ANT_ID, A2.NAME1"+langSuffix+", A2.MEGE8OS, A2.ONTOTHTA_ID "; strSQL = strSQL + " FROM ANT A2, ANT_ANT AA "; strSQL = strSQL + " WHERE A2.ANT_ID=AA.ANT2_ID "; strSQL = strSQL + " AND AA.ANT_ID="+obj_id; strSQL = strSQL + " ORDER BY NLSSORT(A2.NAME1"+langSuffix+",'NLS_SORT=GREEK') ASC "; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% } //end-if %> <% //τέλος See Also %> <% //Πολιτιστικές Εκδηλώσεις String cguide_id = ""; String cguide_onoma = ""; String cguide_thema = ""; String cguide_href = ""; String prevID = ""; strSQL = "SELECT DISTINCT (E.ID), E.TITLE" + langSuffix + ", ET.THEMA_ID "; strSQL = strSQL + " FROM CGUIDE.EKDHLWSEIS E, CGUIDE.EK_THEMA ET, ANT_EVENT AE "; strSQL = strSQL + " WHERE E.ID=ET.ID "; strSQL = strSQL + " AND AE.ANT_ID=" + obj_id; strSQL = strSQL + " AND AE.EVENT_ID=E.ID "; strSQL = strSQL + " AND E.ON_SITE=1 "; strSQL = strSQL + " ORDER BY E.TITLE" + langSuffix + " ASC"; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% } //end-if %> <% //τέλος Πολιτιστικές Εκδηλώσεις %> <% //Εξωτερικά URLS strSQL = "SELECT AU.TITLE"+langSuffix+", U.URL "; strSQL = strSQL + " FROM ANT_URL AU, URL U "; strSQL = strSQL + " WHERE AU.URL_ID=U.URL_ID "; strSQL = strSQL + " AND AU.ANT_ID="+obj_id; rset = stmt.executeQuery(strSQL); if (rset.next()) { %> <% } //end-if %> <% //τέλος Εξωτερικά URLS %>
  <% if (!lhmma.equals("")) { %> <% if (!editor1.equals("")) { %> <% } %> <% if (!editor2.equals("")) { %> <% } %> <% if (!editor3.equals("")) { %> <% } %> <% } %>
<% if (!fotoid.equals("")) { %>
<%=myUtil.rQuotes(fotocopyright,false,true)%>
<%=fotolezanta%>
<% } %> <% if (!lhmma.equals("")) {%>
<%=myUtil.nToBr(lhmma,true,0,2)%>
<% } else { %> The description is not available <% } %>
<%=editors_title%>
<%=editor1%>
<%=editor2%>
<%=editor3%>
 
 
 
Glossary
<% do { glossaryid = ""; glossaryname = ""; if (rset.getString(1)!=null) { glossaryid = rset.getString(1); } if (rset.getString(2)!=null) { glossaryname = rset.getString(2); } if (!allglossary.equals("")) { gl_count = "0"; strSQL = ""; strSQL = "select lb.lhmma_body_id"; strSQL = strSQL + " from ant a, ant_lhmma al, lhmma l, lhmma_body lb"; strSQL = strSQL + " where a.ontothta_id=6 and a.on_site=1"; strSQL = strSQL + " and a.ant_id=al.ant_id"; strSQL = strSQL + " and al.lhmma_id=l.lhmma_id"; strSQL = strSQL + " and l.lhmma_body_en_id=lb.lhmma_body_id and a.ant_id="+glossaryid; glrset = glstmt.executeQuery(strSQL); if (glrset.next()) { if (glrset.getString(1)!=null) { gl_count = "1"; } } if (!gl_count.equals("0")) { %> <%} else { %> <%} } } while (rset.next()); //end-while %>
<%=glossaryname%><%=glossaryname%>
 
 
 
<% do { if (rset.getString(1)!=null) { other_ant_id = rset.getString(1); } if (rset.getString(2)!=null) { other_ant_titlos = rset.getString(2); } if (rset.getString(3)!=null) { other_ant_mege8os = rset.getInt(3); } if (rset.getString(4)!=null) { other_ont_id = rset.getString(4); } if (other_ont_id.equals("1") || other_ont_id.equals("2") || other_ont_id.equals("3")) { other_ant_href = "/h/"+other_ont_id+"/"+langPrefix+"h"+other_ont_id+"51.jsp"; } if (other_ont_id.equals("4")) { other_ant_href = "/h/4/"+langPrefix+"h41.jsp"; } if (other_ont_id.equals("5")) { other_ant_href = "/h/4/"+langPrefix+"h430.jsp"; } if (other_ant_mege8os==2) { other_ant_href = other_ant_href + "?obj_id="+other_ant_id; } else { other_ant_href = other_ant_href + "?obj_id="+other_ant_id; } %> <% } while (rset.next()); %>
  See Also
 
<%=other_ant_titlos%>
 
 
 
<% do { if (!rset.getString(1).equals(prevID)) { if (rset.getString(1)!=null) { cguide_id = rset.getString(1); } if (rset.getString(2)!=null) { cguide_onoma = rset.getString(2); } if (rset.getString(3)!=null) { cguide_thema = rset.getString(3); } if (lang.equals("gr")) { cguide_href = "http://www.cultureguide.gr/events/details_gr.jsp?Event_id="+cguide_id+"&catA="+cguide_thema; } else { cguide_href = "http://www.cultureguide.gr/events/details.jsp?Event_id="+cguide_id+"&catA="+cguide_thema; } prevID = cguide_id; %> <% } %> <% } while (rset.next()); %>
  Πολιτιστικές εκδηλώσεις
 
<%=cguide_onoma%>
 
 
 
<% do { if (rset.getString(1)!=null) { outer_titlos = rset.getString(1); } if (rset.getString(2)!=null) { outer_url = rset.getString(2); } %> <% } while (rset.next()); %>
  Εξωτερικοί Σύνδεσμοι
 
<%=outer_titlos%>
 
 
<% // ---------------------------------------------------------------------- %> <% // -------------- εδώ τελειώνει το table με την πληροφορία -------------- %> <% // -------------------------- τέλος paste εδώ --------------------------- %> <% // ---------------------------------------------------------------------- %> <% } catch (Exception e) { System.out.println(e); } finally { if (rset!=null) try {rset.close(); rset = null; } catch (Exception e) {} if (stmt!=null) try {stmt.close(); stmt = null; } catch (Exception e) {} conn.close(); conn = null; ds = null; } %>