... |
... |
@@ -1,104 +1,3 @@ |
1 |
1 |
{{velocity}} |
2 |
2 |
$response.sendRedirect('Members_Updated') |
3 |
3 |
{{/velocity}} |
4 |
|
-//Please see also: // |
5 |
|
-* //[[Member Presentations>>Membership_Joining.Members_Presentation]]// |
6 |
|
-* //[[Associate Organizations>>Membership_Joining.Associate_Organizations]]// |
7 |
|
-* //[[Founding and Benefactor Members>>About.Founders_Benefactors]]// |
8 |
|
- |
9 |
|
-OW2 is an open non-profit association; below you will find organizations and individuals who have registered online and formally joined the association by signing the OW2 Membership Agreement. |
10 |
|
- |
11 |
|
-For all Members, the symbol {{{(*)}}} indicates we haven't received your signed membership agreement and your membership is therefore incomplete. |
12 |
|
- |
13 |
|
-For Strategic and Corporate Members, the symbol (#) indicates an issue with regard to this year's elections. {{contact emaildestination='management-office@ow2.org' subject='Consortium Members' text='Please contact [[Management Office]].' id='mo' icon='envelope'/}} |
14 |
|
- |
15 |
|
-== Strategic Members |
16 |
|
- |
17 |
|
-//Active Members//: **1** |
18 |
|
-|**[[Orange>>http://www.orange.com/en/home]]** |
19 |
|
- |
20 |
|
-== Corporate Members |
21 |
|
- |
22 |
|
-//Active Members//: **38** |
23 |
|
-|[[7bulls.com>>http://www.7bulls.com]] {{{(*)}}}(#) |
24 |
|
-|**[[ActiveEon>>http://www.activeeon.com]]** |
25 |
|
-|**[[Airbus DS SAS>>https://airbusdefenceandspace.com]]** |
26 |
|
-|**[[Alter Way>>http://www.alterway.fr]]** |
27 |
|
-|[[AnolisTI>>http://www.anolis.com.br]] {{{(*)}}}(#) |
28 |
|
-|[[Beijing University of Aeronautics & Astronautics>>http://www.buaa.edu.cn]] (#) |
29 |
|
-|[[BlueMind>>http://bluemind.net]] {{{(*)}}}(#) |
30 |
|
-|**[[BonitaSoft>>http://www.bonitasoft.com]]** |
31 |
|
-|[[Caixa Economica Federal>>http://www.caixa.gov.br]] {{{(*)}}}(#) |
32 |
|
-|**[[CETIC - Centre d’Excellence en Technologies de l’Information et de la Communication>>http://www.cetic.be]]** |
33 |
|
-|**[[Charles University Prague>>http://nenya.ms.mff.cuni.cz]]** |
34 |
|
-|[[City of Paris>>http://dev.lutece.paris.fr]] {{{(*)}}} |
35 |
|
-|**[[CVIC Software Engineering Co. Ltd.>>http://www.cvicse.com]]** (#) |
36 |
|
-|[[DanOwa SofiTech (DOST)>>http://www.danowagroup.org]] {{{(*)}}}(#) |
37 |
|
-|**[[EdifiXio>>http://www.edifixio.com/]]** |
38 |
|
-|**[[Engineering Ingegneria Informatica S.p.A.>>http://www.eng.it]]** |
39 |
|
-|**[[Fraunhofer FOKUS>>http://www.fokus.fraunhofer.de/home/]]** |
40 |
|
-|[[InfraStack-Labs>>https://www.infrastack-labs.com]] {{{(*)}}}(#) |
41 |
|
-|**[[Inria>>http://www.inria.fr]]** |
42 |
|
-|**[[Institut Mines-Télécom>>http://www.mines-telecom.fr/]]** |
43 |
|
-|**[[Institute of Software, Chinese Academy of Sciences>>http://www.iscas.ac.cn]]** |
44 |
|
-|**[[Konsultex Informatica>>http://www.konsultex.com.br]]** |
45 |
|
-|[[Ministère de l'Intérieur, de l'Outre-mer et des Collectivités Locales>>http://www.interieur.gouv.fr]] {{{(*)}}}(#) |
46 |
|
-|**[[Nanjing University of Aeronautics and Astronautics (NUAA)>>http://www.nuaa.edu.cn]]** |
47 |
|
-|[[Nanocloud>>http://www.nanocloud.com]] {{{(*)}}} |
48 |
|
-|[[OpenSides>>http://www.opensides.be/]] {{{(*)}}}(#) |
49 |
|
-|**[[Peking University>>http://www.sei.pku.edu.cn]]** (#) |
50 |
|
-|[[Poochie's>>http://www.poochies.technology]] {{{(*)}}}(#) |
51 |
|
-|[[Propus Science>>http://www.propus.science]] {{{(*)}}}(#) |
52 |
|
-|[[RocketChat>>https://rocket.chat/]] |
53 |
|
-|[[Savoir-faire Linux>>https://savoirfairelinux.com/en]]{{{(*)}}} |
54 |
|
-|**[[Talend>>http://www.talend.com]]** |
55 |
|
-|**[[Teclib'>>http://teclib.com]]** |
56 |
|
-|[[University of Oslo>>http://www.uio.no/english/]] {{{(*)}}} |
57 |
|
-|**[[UShareSoft>>http://www.usharesoft.com]]** |
58 |
|
-|[[Videolabs>>https://videolabs.io/]] {{{(*)}}}(#) |
59 |
|
-|[[WAARP>>http://www.waarp.fr]] {{{(*)}}} |
60 |
|
-|[[Wakanda>>http://wakanda.io]] {{{(*)}}} |
61 |
|
-|**[[Webmiel>>http://www.webmiel.fr]]** |
62 |
|
-|**[[XWiki SAS>>http://www.xwiki.com]]** |
63 |
|
- |
64 |
|
- |
65 |
|
- |
66 |
|
-{{groovy}} |
67 |
|
-import groovy.sql.Sql |
68 |
|
- |
69 |
|
-def sql = Sql.newInstance("jdbc:mysql://localhost/ow2", "ow2ro","AnbZ75ebjuXyDGst", "com.mysql.jdbc.Driver") |
70 |
|
- |
71 |
|
-//****************** SELECT individual member SECTION |
72 |
|
-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 lower(m.last_name), lower(m.first_name), m.date" |
73 |
|
- |
74 |
|
-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" |
75 |
|
- |
76 |
|
- |
77 |
|
-// Comment this part of IM |
78 |
|
-def text1 = "" |
79 |
|
-text1=text1+"<h2 class='heading-1-1-1 entry-title'>Individual Members</h2>" |
80 |
|
-row = sql.firstRow(individualMemberCountQuery ) |
81 |
|
-text1=text1+"<i>Number of registrations:</i> <b>${row.count}</b>" |
82 |
|
-text1=text1+"<div style='height:500px;overflow:auto'><ul>" |
83 |
|
-sql.eachRow(individualMemberQuery) { member-> |
84 |
|
-text1=text1+"<li>" |
85 |
|
-if (member.valid =='n'){ |
86 |
|
-text1=text1+"${member.first_name} ${member.last_name}" |
87 |
|
-}else{ |
88 |
|
-text1=text1+"<b>${member.first_name} ${member.last_name}</b>" |
89 |
|
-} |
90 |
|
-text1=text1+"</li>" |
91 |
|
-} |
92 |
|
-text1=text1+"</ul></div>" |
93 |
|
-//*/ |
94 |
|
-sql.close() |
95 |
|
-xcontext.put("result",text1) |
96 |
|
-{{/groovy}} |
97 |
|
- |
98 |
|
-{{velocity}} |
99 |
|
- |
100 |
|
-{{html clean=false wiki=true}} |
101 |
|
- |
102 |
|
-$xcontext.result |
103 |
|
-{{/velocity}} |
104 |
|
- |