Skip to Content

Changes for page Association Members

From version 2.1
edited by OW2
on 2021/03/30 14:59
Change comment: There is no comment for this version
To version 1.1
edited by Admin OW2
on 2018/03/08 15:52
Change comment: Imported from XAR

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -xwiki:XWiki.wadmin
1 +xwiki:XWiki.Admin
Content
... ... @@ -1,3 +1,104 @@
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 +