Changes for document Consortium Members

From version 98.1
edited by olivier lizounat
on 2014/04/07 16:33
To version 99.1
edited by olivier lizounat
on 2014/04/07 16:35
Change comment: There is no comment for this version
Content changes
<%
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.fy2014 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.fy2014 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"%>
<style type="text/css">.containerAjax {
background: url(’http://skins.ow2.org/skins/skinOW2/images/loader.gif’) 50% 50% no-repeat #FFF;
border: 1px solid #777777;
border-radius: 0 0 7px 7px;
display: none;
font-size: 0.8em;
padding: 10px 10px 20px 10px;
margin:3px;
box-shadow: 0 0 3px #999
}</style>
<script type="text/javascript">
jQuery.fn.exists = function(){return this.length>0;}
var server="$request.getServerName()";
function showAjax(content0,content,thisurl,container,title){J(’#’+content0).toggle({display:’block’},500);J(’#’+content).load(thisurl+container,function(){J(’#’+content0).css({background:’url()’});J(’#loader’).remove();});}
</script>
~~Please see also:~~
- ~~[Member Presentations>http://www.ow2.org/view/Membership_Joining/Members_Presentation]~~
- ~~[Associate Organizations>http://www.ow2.org/view/Membership_Joining/Associate_Organizations]~~
- ~~[Founding and Benefactor Members>http://www.ow2.org/view/About/Founders_Benefactors]~~
<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 2014 elections. </p>
1.1 Strategic Members
<%row = sql.firstRow(strategicMemberCountQuery )%>
<p>~~Active members:~~ *${row.count}*</p>
<ul>
<%sql.eachRow(strategicMemberQuery) { member-> %>\\
<li>\\
<%if (member.valid ==’n’){%>\\
${member.name} (\\*)
<%} else {%>\\
*${member.name}*
<%}%>\\
<%if (member.fy2014 == ’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>~~Active Members:~~ *${row.count}*</p>
<ul>
<%sql.eachRow(corporateMemberQuery) { member-> %>\\
<li>\\
<%if (member.valid ==’n’){%>\\
${member.name} (\\*)
<%} else {%>\\
*${member.name}*
<%}%>\\
<%if (member.fy2014 == ’n’ ) {%>\\
(#)
<%}%>\\
<%if (member.benefactor == ’y’ ) {%>\\
*(benefactor member)*
<%}%>\\
<%if (member.web_site != ’’ ) {%>\\
\\ - Web Site: [${member.web_site}]
<%}%>\\
\\ </li>
<%}%>
</ul>
<h2 class="heading-1-1-1 entry-title">Individual Members</h2>
<%row = sql.firstRow(individualMemberCountQuery )%>
<p>~~Number of registrations:~~ *${row.count}*</p>
<input type="submit" onClick="return showAjax(’Content0’,’Content’,’http://www.ow2.org/view/Membership_Joining/Consortium_Individual_Members’,’ #IM’,’Consortium Individual Members’);" value="click here to see the list" />
<div id="Content0" class="containerAjax"><span id="loader"><center>Loading... Please wait.<br /><br /></center></span><div id="Content" style="color:#000"></div>
</div><%sql.close() %>

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