Changes for document Consortium Members

From version 31.1

edited by olivier lizounat
on 2011/09/07 14:14

To version 32.1

edited by olivier lizounat
on 2011/09/07 14:21

Change comment: There is no comment for this version

Content changes
<%#set ($mRedir="../../Membership_Joining/Consortium_Members")#if ($xwiki.hasAdminRights())Redirection existante: <a href="$mRedir">$mRedir</a> #else #$response.sendRedirect($mRedir) #end import groovy.sql.Sql def sql = Sql.newInstance("jdbc:mysql://mysql-ldap-02.ow2.org/ow2", "ow2",## voir MembershipJoining/ConsortiumMembers_Backup "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.fy2010 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.fy2010 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"%> <html> <head> <title>OW2 - Consortium Members</title> </head> <body> 1 Consortium Members ~~Please see also:~~ - ~~[Member Presentations>http://www.ow2.org/view/MembershipJoining/MembersPresentation]~~ - ~~[Associate Organizations>http://www.ow2.org/view/MembershipJoining/AssociateOrganizations]~~ - ~~[Founding and Benefactor Members>http://www.ow2.org/view/About/FoundersBenefactors]~~ <p>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.</p> <p>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. </p> 1.1 Strategic Members <%row = sql.firstRow(strategicMemberCountQuery )%> <p>~~Number of registrations:~~ ${row.count}</p> <ul> <%sql.eachRow(strategicMemberQuery) { member-> %>\\ <li>\\ <%if (member.valid ==’n’){%>\\ ${member.name} (\\) <%} else {%>\\ ${member.name}* <%}%>\\ <%if (member.fy2010 == ’n’ ) {%>\\ (#) <%}%>\\ <%if (member.benefactor == ’y’ ) {%>\\ (benefactor member) <%}%>\\ <%if (member.web_site != ’’ ) {%>\\ \\ - Web Site: [${member.web_site}] <%}%>\\ \\ </li> <%}%> </ul> 1.1 Corporate Members <%row = sql.firstRow(corporateMemberCountQuery )%> <p>~~Number of registrations:~~ ${row.count}</p> <ul> <%sql.eachRow(corporateMemberQuery) { member-> %>\\ <li>\\ <%if (member.valid ==’n’){%>\\ ${member.name} (\\) <%} else {%>\\ ${member.name}* <%}%>\\ <%if (member.fy2010 == ’n’ ) {%>\\ (#) <%}%>\\ <%if (member.benefactor == ’y’ ) {%>\\ (benefactor member) <%}%>\\ <%if (member.web_site != ’’ ) {%>\\ \\ - Web Site: [${member.web_site}] <%}%>\\ \\ </li> <%}%> </ul> 1.1 Individual Members <%row = sql.firstRow(individualMemberCountQuery )%> <p>~~Number of registrations:~~ ${row.count}</p> <ul> <%sql.eachRow(individualMemberQuery) { member-> %>\\ <li>\\ <%if (member.valid ==’y’){%>\\ <b>\\ <%}%>\\ ${member.first_name} ${member.last_name}\\ <%if (member.organization_name!=’’ ) { if (member.organization_web_site != ’’ ) {%>\\ \\ - [${member.organization_name}>${member.organization_web_site}] <%}else {%> \\ - ${member.organization_name} <%}%>\\ <%} if ( member.valid == ’y’ ) {%> </b>\\ <%} else {%>\\ (\\*) <%}%>\\ \\ </li> <%}%> </ul> </body> </html>

Content changes

<%#set ($mRedir="../../Membership_Joining/Consortium_Members")#if ($xwiki.hasAdminRights())Redirection existante: <a href="$mRedir">$mRedir</a> #else #$response.sendRedirect($mRedir) #end

import groovy.sql.Sql

def sql = Sql.newInstance("jdbc:mysql://mysql-ldap-02.ow2.org/ow2", "ow2",## voir MembershipJoining/ConsortiumMembers_Backup

"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.fy2010 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.fy2010 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"%>

<html>

<head>

<title>OW2 - Consortium Members</title>

</head>

<body>

1 Consortium Members

~~Please see also:~~

- ~~[Member Presentations>http://www.ow2.org/view/MembershipJoining/MembersPresentation]~~

- ~~[Associate Organizations>http://www.ow2.org/view/MembershipJoining/AssociateOrganizations]~~

- ~~[Founding and Benefactor Members>http://www.ow2.org/view/About/FoundersBenefactors]~~

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.

1.1 Strategic Members

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

~~Number of registrations:~~ *${row.count}*

<ul>

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

<li>\\

<%if (member.valid ==’n’){%>\\

${member.name} (\\*)

<%} else {%>\\

*${member.name}*

<%}%>\\

<%if (member.fy2010 == ’n’ ) {%>\\

(#)

<%}%>\\

<%if (member.benefactor == ’y’ ) {%>\\

*(benefactor member)*

<%}%>\\

<%if (member.web_site != ’’ ) {%>\\

\\ - Web Site: [${member.web_site}]

<%}%>\\

\\ </li>

<%}%>

</ul>

1.1 Corporate Members

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

~~Number of registrations:~~ *${row.count}*

<ul>

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

<li>\\

<%if (member.valid ==’n’){%>\\

${member.name} (\\*)

<%} else {%>\\

*${member.name}*

<%}%>\\

<%if (member.fy2010 == ’n’ ) {%>\\

(#)

<%}%>\\

<%if (member.benefactor == ’y’ ) {%>\\

*(benefactor member)*

<%}%>\\

<%if (member.web_site != ’’ ) {%>\\

\\ - Web Site: [${member.web_site}]

<%}%>\\

\\ </li>

<%}%>

</ul>

1.1 Individual Members

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

~~Number of registrations:~~ *${row.count}*

<ul>

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

<li>\\

<%if (member.valid ==’y’){%>\\

\\

<%}%>\\

${member.first_name} ${member.last_name}\\

<%if (member.organization_name!=’’ ) {

if (member.organization_web_site != ’’ ) {%>\\

\\ - [${member.organization_name}>${member.organization_web_site}]

<%}else {%>

\\ - ${member.organization_name}

<%}%>\\

<%}

if ( member.valid == ’y’ ) {%>

\\

<%} else {%>\\

(\\*)

<%}%>\\

\\ </li>

<%}%>

</ul>

</body>

</html>

Useful Links

Newsletter Subscription

OW2 Newsletters Archive

Top Downloads

For the past seven days
SpagoBI
Bonita
XWiki
eXo Platform
EasyBeans
ASM
JOnAS
Orchestra
JOTM
JASMINe

Join OW2

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

Changes for document Consortium Members

Useful Links

Top Downloads

Join OW2

Project News

Community Events