Consortium Members

Last modified by Cedric Thomas on 2011/12/16 11:10

<% import groovy.sql.Sql

def sql = Sql.newInstance("jdbc:mysql://localhost/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, m.fy2011 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, m.fy2011 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 and m.listed='y' 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

Please see also:

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

Please contact Management Office (mo AT ow2.org) if either of the (*) or (#) symbols is attached to your name:

  • For all Members, the symbol (
    *) indicates we haven't received your signed membership agreement, your membership is not complete.
  • For Strategic and Corporate Members, the symbol (
    #) indicates an issue with regard to the 2011 elections.

Strategic Members

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

Active members: ${row.count}

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

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

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

  • <%}%>

Corporate Members

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

Active Members: ${row.count}

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

  • <%if (member.valid =='n'){%>
    ${member.name} (
    *) <%} else {%>
    ${member.name} <%}%>
    <%if (member.fy2011 == 'n' ) {%>
    (#) <%}%>
    <%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

 

Powered by XWiki Hosted by Xsalto Free PageRank Checker Creative Commons 2.0 license Legal Notice