<%= hs_inst %>
<%
rs = st.executeQuery("select caption,content,comment as icon,nvl(art2,'has-background-primary-light'::varchar(255)) as tileclass,tid from sx_repository where art='WELCOME_LINK' and today() between gueltig_seit and gueltig_bis and aktiv=1 order by sort1");
while (rs.next())
{
if(rs.getObject(1) !=null && rs.getObject(2) !=null && rs.getObject(3) !=null && rs.getObject(4) !=null)
{
String welcomeLink=rs.getString(2);
if (mandantenid.toString().equals("default")) {
welcomeLink="/superx/" +welcomeLink;
} else {
//Mandantenlink:
if(welcomeLink.indexOf("?") >-1)
welcomeLink+="&MandantID="+ mandantenid.toString();
else
welcomeLink+="?MandantID="+ mandantenid.toString();
welcomeLink="/superx/"+welcomeLink;
}
%>
<%
}
}
%>
<%
rs = st.executeQuery("select name,class,icon,content,visible,sortnr_initial,tid from sx_portlet where today() between gueltig_von and gueltig_bis and type='HTML' and visible in ('all','post_login') order by sortnr_initial,tid");
while (rs.next())
{
if(rs.getObject(1) !=null && rs.getObject(2) !=null && rs.getObject(3) !=null && rs.getObject(4) !=null)
{
%>
<%
}
}
rs.close();
st.close();
conmm.close();
%>
<%
de.superx.common.SxUser user= (de.superx.common.SxUser) request.getSession().getAttribute("user");
if(user != null)
{
//username=(de.superx.common.SxUser) user.getName();
//System.out.println(user.toString());
username= user.toString();
}
else
{
System.out.println("No user found");
}
%>