<?php
/***************************************************************************
- * Copyright (C) 2003-2007 Polytechnique.org *
+ * Copyright (C) 2003-2008 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
$womanField = new RefSField('woman',array('FIND_IN_SET(\'femme\',u.flags)+1'),'','','');
$subscriberField = new RefSField('subscriber',array('!(u.perms IN (\'admin\',\'user\'))+1'),'','','');
$aliveField = new RefSField('alive',array('(u.deces!=0)+1'),'','','');
+ if (Env::v('only_referent') == 'on') {
+ $referentField = new RefSField('only_referent', array('"on"'), 'mentor', 'mt', 'mt.expertise != "" AND mt.uid=u.user_id');
+ } else {
+ $referentField = null;
+ }
- $townField = new RefSField('city',array('ac.city'),'adresses','ac',getadr_join('ac'),false);
- $cityIdField = new RefSField('cityid',array('av.cityid'),'adresses','av',getadr_join('av'));
+ if (!Env::i('cityid')) {
+ $townField = new RefSField('city',array('ac.city'),'adresses','ac',getadr_join('ac'),false);
+ } else {
+ $townField = new RefSField('cityid',array('av.cityid'),'adresses','av',getadr_join('av'));
+ }
$countryField = new RefSField('country',array('ap.country'),'adresses','ap',getadr_join('ap'));
$regionField = new RefSField('region',array('ar.region'),'adresses','ar',getadr_join('ar'));
$mapField = new MapSField('mapid', array('sgcim.map_id'), array('adresses','geoloc_city_in_maps'), array('amp','sgcim'), array(getadr_join('amp'), 'amp.cityid = sgcim.city_id'));
return array(
$nameField, $firstnameField, $nicknameField, $promo1Field,
- $promo2Field, $womanField, $subscriberField, $aliveField,
+ $promo2Field, $womanField, $subscriberField, $aliveField, $referentField,
$townField, $countryField, $regionField, $mapField, $entrepriseField,
$posteField, $secteurField, $cvField, $natField, $binetField,
$groupexField, $sectionField, $schoolField, $diplomaField,
- $freeField, $fonctionField, $cityIdField);
+ $freeField, $fonctionField);
}
// }}}