Consortium Members

Last modified by olivier lizounat on 2012/09/07 10:16

<% 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.fy2012 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.fy2012 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 2012 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.fy2012 == '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.fy2012 == 'n' ) {%>
    (#) <%}%>
    <%if (member.benefactor == 'y' ) {%>
    (benefactor member) <%}%>
    <%if (member.web_site != '' ) {%>

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

  • <%}%>

1.1 Individual Members

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