Consortium Members


<% import groovy.sql.Sql

def sql = Sql.newInstance("jdbc:mysql://mysql-ldap-02.ow2.org/ow2", "ow2", "lm2panpo_objectweb", "com.mysql.jdbc.Driver")

//**************** SELECT strategic member SECTION def strategicMemberQuery ="SELECT m.name, m.description, u.login, m.logo, m.web_site, m.benefactor, m.public_profile, m.valid FROM ow2_legal_entity_member m, t_user u WHERE u.user_id = m.user_id and m.membership = 'strategic' and m.cancelled='n' ORDER BY m.name"

def strategicMemberCountQuery ="SELECT count(*) count FROM ow2_legal_entity_member m, t_user u WHERE u.user_id = m.user_id and m.membership = 'strategic' and m.cancelled='n' ORDER BY m.name"

//**************** SELECT corporate member SECTION def corporateMemberQuery = "SELECT m.name, m.description, u.login, m.logo, m.web_site, m.benefactor, m.public_profile, m.valid FROM ow2_legal_entity_member m, t_user u WHERE u.user_id = m.user_id and m.membership = 'corporate' and m.cancelled='n' ORDER BY m.name"

def corporateMemberCountQuery = "SELECT count(*) count FROM ow2_legal_entity_member m, t_user u WHERE u.user_id = m.user_id and m.membership = 'corporate' and m.cancelled='n' ORDER BY m.name"

//**************** SELECT individual member SECTION def individualMemberQuery = "SELECT m.first_name, m.last_name, u.login, m.organization_name, m.organization_web_site, m.benefactor, m.valid, m.public_profile FROM ow2_individual_member m, t_user u WHERE u.user_id = m.user_id ORDER BY m.last_name, m.first_name, m.date"

def individualMemberCountQuery = "SELECT count(*) count FROM ow2_individual_member m, t_user u WHERE u.user_id = m.user_id ORDER BY m.last_name, m.first_name, m.date"%>

OW2 - Consortium Members

Consortium Members

OW2 is an open consortium, you will find below organizations and individuals, who have formally joined the consortium by signing the OW2 Membership Agreement.

Note: (
*) membership not up-to-date, missing information, please contact Management Office (mo AT ow2.org).

Strategic Members

<%row = sql.firstRow(strategicMemberCountQuery )%>

Number of registrations: ${row.count}

    <%sql.eachRow(strategicMemberQuery) { member-> %>

  • <%if (member.valid =='n'){%>
    ${member.name} (
    *) <%} else {%>
    ${member.name} <%}%>
    <%if (member.benefactor == 'y' ) {%>
    (benefactor member) <%}%>
    <%if (member.web_site != '' ) {%>

    - Web Site: web_site}? <%}%>

  • <%}%>

Corporate Members

<%row = sql.firstRow(corporateMemberCountQuery )%>

Number of registrations: ${row.count}

    <%sql.eachRow(corporateMemberQuery) { member-> %>

  • <%if (member.valid =='n'){%>
    ${member.name} (
    *) <%} else {%>
    ${member.name} <%}%>
    <%if (member.benefactor == 'y' ) {%>
    (benefactor member) <%}%>
    <%if (member.web_site != '' ) {%>

    - Web Site: web_site}? <%}%>

  • <%}%>

Individual Members

<%row = sql.firstRow(individualMemberCountQuery )%>

Number of registrations: ${row.count}

    <%sql.eachRow(individualMemberQuery) { member-> %>

  • <%if (member.valid =='y'){%>

    <%}%>
    ${member.first_name} ${member.last_name}
    <%if (member.organization_name!='' ) { if (member.organization_web_site != '' ) {%>

    - ${member.organization_name}? <%}else {%>
    - ${member.organization_name} <%}%>
    <%} if ( member.valid == 'y' ) {%>

    <%} else {%>
    (
    *) <%}%>

  • <%}%>

Join OW2

Join

industry leaders, academics and individuals and help shape the future of middleware

 


This wiki is licensed under a Creative Commons 2.0 license
XWiki Enterprise 6.4.4 - Documentation
Powered by XWiki Hosted by Xsalto Free PageRank Checker Creative Commons 2.0 license Legal Notice