<<JOpen>>


<<JCss


#header {
    display:none!important;
}

#actionsBottom.pageactions {
    display:none!important;
}

p > a {

    color : #ffffff !important;
    background-color : #4D589F;
    font-size : 14px;
    padding : 0.5em 0.6em 0.5em 0.6em;
    margin: 10px 0px;
    border : 1px outset #ffffff;
}

h1 {
    font-size:18px;
    text-transform: uppercase;
    text-align:center;
}

h3 {
    font-size:15px;
    margin: 10px 0 !important;
    text-align:center;
    text-transform: uppercase;
}

.outerTable {
    width:100%;
}

.wikitable td {
    padding: 5px 10px!important;
}

.wikitable {
    margin:20px 0;
    font-size:13px;
    line-height:21px;
}

>>

<<JScript includes='QuestionnaireFunctions/functions'

    var html = [[*
        [{JHtml

        <div id='headerLayout'>
        <center><h1>ERP-LEISTUNGSKATALOG</h1></center>
        <center><h3 style='font-weight: normal'> $text</h3></center>
        <br/>
        <center>
       }]
    *]];


     var html1 = [[*
        [{JHtml

            </center>
        </div>
        }]
    *]];
    var text = "";


    var messageId = jpage.get('messageId');
    var linkId = jpage.get('linkId');

    var tcon = null;
    try {
        var tcon = jrt.exclusiveCon("QuestionnaireFunctions.onGetLinkForward",false);
        tcon.commit();

        var linkQuery = "SELECT * FROM subcategory_link WHERE id_subcategory_link = '" + linkId + "'";
        var linkResult = tcon.prepareStatement(linkQuery).executeQuery();


        var link = null;
        if(linkResult.next()) {
            link = linkResult.getString("link");
        }


        var messageQuery = "SELECT * FROM link_messages WHERE id_link_message = '" + messageId + "'";
        var messageResult = tcon.prepareStatement(messageQuery).executeQuery();

        if(messageResult.next()) {
            text = messageResult.getString("message");
        }

        html = jutil.replace(html, "$text", text);
        jout.println('\\\\');
        jout.println(html);
        jout.println(" [{JLink name='Anmelden' title='ANMELDEN' href='" + link + "'}]");
        jout.println(html1);

    } catch(e) {
        if(tcon != null) {
            tcon.rollback();
        }
        throw "jreturn:" + e;
    } finally {
        if(tcon != null) {
            jrt.release(tcon);
        }
    }





>>

<<JClose>>