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

... ... @@ -1,0 +1,107 @@
1 +<%
2 +import groovy.sql.Sql
3 +
4 +def sql = Sql.newInstance("jdbc:mysql://localhost/ow2", "ow2","lm2panpo_objectweb", "com.mysql.jdbc.Driver")
5 +
6 +//****************** SELECT strategic member SECTION
7 +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"
8 +
9 +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"
10 +
11 +
12 +//****************** SELECT corporate member SECTION
13 +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"
14 +
15 +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"
16 +
17 +//****************** SELECT individual member SECTION
18 +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"
19 +
20 +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"%>
21 +
22 +
23 +<style type="text/css">.containerAjax {
24 + background: url('http://skins.ow2.org/skins/skinOW2/images/loader.gif') 50% 50% no-repeat #FFF;
25 + border: 1px solid #777777;
26 + border-radius: 0 0 7px 7px;
27 + display: none;
28 + font-size: 0.8em;
29 + padding: 10px 10px 20px 10px;
30 + margin:3px;
31 + box-shadow: 0 0 3px #999
32 +}</style>
33 +<script type="text/javascript">
34 +jQuery.fn.exists = function(){return this.length>0;}
35 +var server="$request.getServerName()";
36 +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();});}
37 +</script>
38 +
39 +
40 +
41 +~~Please see also:~~
42 +- ~~[Member Presentations>http://www.ow2.org/view/Membership_Joining/Members_Presentation]~~
43 +- ~~[Associate Organizations>http://www.ow2.org/view/Membership_Joining/Associate_Organizations]~~
44 +- ~~[Founding and Benefactor Members>http://www.ow2.org/view/About/Founders_Benefactors]~~
45 +
46 +<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>
47 +<p>Please contact Management Office (mo AT ow2.org) if either of the (*) or (#) symbols is attached to your name:
48 +* For all Members, the symbol (\\*) indicates we haven't received your signed membership agreement, your membership is not complete.
49 +* For Strategic and Corporate Members, the symbol (\\#) indicates an issue with regard to the 2014 elections. </p>
50 +
51 +1.1 Strategic Members
52 +<%row = sql.firstRow(strategicMemberCountQuery )%>
53 +
54 +<p>~~Active members:~~ *${row.count}*</p>
55 +
56 +<ul>
57 +<%sql.eachRow(strategicMemberQuery) { member-> %>\\
58 + <li>\\
59 + <%if (member.valid =='n'){%>\\
60 + ${member.name} (\\*)
61 + <%} else {%>\\
62 + *${member.name}*
63 + <%}%>\\
64 + <%if (member.fy2014 == 'n' ) {%>\\
65 + (#)
66 + <%}%>\\
67 + <%if (member.benefactor == 'y' ) {%>\\
68 + *(benefactor member)*
69 + <%}%>\\
70 + <%if (member.web_site != '' ) {%>\\
71 + \\ - Web Site: [${member.web_site}]
72 + <%}%>\\
73 +\\ </li>
74 +<%}%>
75 +</ul>
76 +1.1 Corporate Members
77 +<%row = sql.firstRow(corporateMemberCountQuery )%>
78 +
79 +<p>~~Active Members:~~ *${row.count}*</p>
80 +
81 +<ul>
82 +<%sql.eachRow(corporateMemberQuery) { member-> %>\\
83 + <li>\\
84 + <%if (member.valid =='n'){%>\\
85 + ${member.name} (\\*)
86 + <%} else {%>\\
87 + *${member.name}*
88 + <%}%>\\
89 + <%if (member.fy2014 == 'n' ) {%>\\
90 + (#)
91 + <%}%>\\
92 + <%if (member.benefactor == 'y' ) {%>\\
93 + *(benefactor member)*
94 + <%}%>\\
95 + <%if (member.web_site != '' ) {%>\\
96 + \\ - Web Site: [${member.web_site}]
97 + <%}%>\\
98 +\\ </li>
99 +<%}%>
100 +</ul>
101 +
102 +<h2 class="heading-1-1-1 entry-title">Individual Members</h2>
103 +<%row = sql.firstRow(individualMemberCountQuery )%>
104 +<p>~~Number of registrations:~~ *${row.count}*</p>
105 + <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" />
106 +<div id="Content0" class="containerAjax"><span id="loader"><center>Loading... Please wait.<br /><br /></center></span><div id="Content" style="color:#000"></div>
107 +</div><%sql.close() %>

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