Changes for page Association Members

From version 1.1

edited by Admin OW2
on 2018/03/08 15:52

Change comment: Imported from XAR

To version 2.1

edited by OW2
on 2021/03/30 14:59

Change comment: There is no comment for this version

Raw
Rendered

Summary

Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

@@ -1,1 +1,1 @@
--xwiki:XWiki.Admin
++xwiki:XWiki.wadmin

Content

@@ -1,104 +1,3 @@
  {{velocity}}
  $response.sendRedirect('Members_Updated')
  {{/velocity}}
--//Please see also: //
--* //[[Member Presentations>>Membership_Joining.Members_Presentation]]//
--* //[[Associate Organizations>>Membership_Joining.Associate_Organizations]]//
--* //[[Founding and Benefactor Members>>About.Founders_Benefactors]]//
--
--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.
--
--For all Members, the symbol {{{(*)}}} indicates we haven't received your signed membership agreement and your membership is therefore incomplete.
--
--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'/}}
--
--== Strategic Members
--
--//Active Members//: **1**
--|**[[Orange>>http://www.orange.com/en/home]]**
--
--== Corporate Members
--
--//Active Members//: **38**
--|[[7bulls.com>>http://www.7bulls.com]] {{{(*)}}}(#)
--|**[[ActiveEon>>http://www.activeeon.com]]**
--|**[[Airbus DS SAS>>https://airbusdefenceandspace.com]]**
--|**[[Alter Way>>http://www.alterway.fr]]**
--|[[AnolisTI>>http://www.anolis.com.br]] {{{(*)}}}(#)
--|[[Beijing University of Aeronautics & Astronautics>>http://www.buaa.edu.cn]] (#)
--|[[BlueMind>>http://bluemind.net]] {{{(*)}}}(#)
--|**[[BonitaSoft>>http://www.bonitasoft.com]]**
--|[[Caixa Economica Federal>>http://www.caixa.gov.br]] {{{(*)}}}(#)
--|**[[CETIC - Centre d’Excellence en Technologies de l’Information et de la Communication>>http://www.cetic.be]]**
--|**[[Charles University Prague>>http://nenya.ms.mff.cuni.cz]]**
--|[[City of Paris>>http://dev.lutece.paris.fr]] {{{(*)}}}
--|**[[CVIC Software Engineering Co. Ltd.>>http://www.cvicse.com]]** (#)
--|[[DanOwa SofiTech (DOST)>>http://www.danowagroup.org]] {{{(*)}}}(#)
--|**[[EdifiXio>>http://www.edifixio.com/]]**
--|**[[Engineering Ingegneria Informatica S.p.A.>>http://www.eng.it]]**
--|**[[Fraunhofer FOKUS>>http://www.fokus.fraunhofer.de/home/]]**
--|[[InfraStack-Labs>>https://www.infrastack-labs.com]] {{{(*)}}}(#)
--|**[[Inria>>http://www.inria.fr]]**
--|**[[Institut Mines-Télécom>>http://www.mines-telecom.fr/]]**
--|**[[Institute of Software, Chinese Academy of Sciences>>http://www.iscas.ac.cn]]**
--|**[[Konsultex Informatica>>http://www.konsultex.com.br]]**
--|[[Ministère de l'Intérieur, de l'Outre-mer et des Collectivités Locales>>http://www.interieur.gouv.fr]] {{{(*)}}}(#)
--|**[[Nanjing University of Aeronautics and Astronautics (NUAA)>>http://www.nuaa.edu.cn]]**
--|[[Nanocloud>>http://www.nanocloud.com]] {{{(*)}}}
--|[[OpenSides>>http://www.opensides.be/]] {{{(*)}}}(#)
--|**[[Peking University>>http://www.sei.pku.edu.cn]]** (#)
--|[[Poochie's>>http://www.poochies.technology]] {{{(*)}}}(#)
--|[[Propus Science>>http://www.propus.science]] {{{(*)}}}(#)
--|[[RocketChat>>https://rocket.chat/]]
--|[[Savoir-faire Linux>>https://savoirfairelinux.com/en]]{{{(*)}}}
--|**[[Talend>>http://www.talend.com]]**
--|**[[Teclib'>>http://teclib.com]]**
--|[[University of Oslo>>http://www.uio.no/english/]] {{{(*)}}}
--|**[[UShareSoft>>http://www.usharesoft.com]]**
--|[[Videolabs>>https://videolabs.io/]] {{{(*)}}}(#)
--|[[WAARP>>http://www.waarp.fr]] {{{(*)}}}
--|[[Wakanda>>http://wakanda.io]] {{{(*)}}}
--|**[[Webmiel>>http://www.webmiel.fr]]**
--|**[[XWiki SAS>>http://www.xwiki.com]]**
--
--
--
--{{groovy}}
--import groovy.sql.Sql
--
--def sql = Sql.newInstance("jdbc:mysql://localhost/ow2", "ow2ro","AnbZ75ebjuXyDGst", "com.mysql.jdbc.Driver")
--
--//****************** 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 lower(m.last_name), lower(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"
--
--
--// Comment this part of IM
--def text1 = ""
--text1=text1+"<h2 class='heading-1-1-1 entry-title'>Individual Members</h2>"
--row = sql.firstRow(individualMemberCountQuery )
--text1=text1+"<i>Number of registrations:</i> <b>${row.count}</b>"
--text1=text1+"<div style='height:500px;overflow:auto'><ul>"
--sql.eachRow(individualMemberQuery) { member->
--text1=text1+"<li>"
--if (member.valid =='n'){
--text1=text1+"${member.first_name} ${member.last_name}"
--}else{
--text1=text1+"<b>${member.first_name} ${member.last_name}</b>"
--}
--text1=text1+"</li>"
--}
--text1=text1+"</ul></div>"
--//*/
--sql.close()
--xcontext.put("result",text1)
--{{/groovy}}
--
--{{velocity}}
--
--{{html clean=false wiki=true}}
--
--$xcontext.result
--{{/velocity}}
--