<?php
/***************************************************************************
- * Copyright (C) 2003-2010 Polytechnique.org *
+ * Copyright (C) 2003-2011 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
const NATIONALITIES = 'nationalities';
const COUNTRIES = 'countries';
const ADMINAREAS = 'adminareas';
+ const SUBADMINAREAS = 'subadminareas';
const LOCALITIES = 'localities';
const COMPANIES = 'companies';
const MEDALS = 'medals';
const ACCOUNTTYPES = 'accounttypes';
+ const SKINS = 'skins';
static private $enumerations = array();
class DE_Nationalities extends DirEnumeration
{
protected $idfield = 'geoloc_countries.iso_3166_1_a2';
- protected $valfield = 'geoloc_countries.nationalityFR';
- protected $valfield2 = 'geoloc_countries.nationality';
+ protected $valfield = 'geoloc_countries.nationality';
+ protected $valfield2 = 'geoloc_countries.nationalityEn';
protected $from = 'geoloc_countries';
protected $join = 'INNER JOIN profiles ON (geoloc_countries.iso_3166_1_a2 IN (profiles.nationality1, profiles.nationality2, profiles.nationality3))';
class DE_Countries extends DirEnumeration
{
protected $idfield = 'geoloc_countries.iso_3166_1_a2';
- protected $valfield = 'geoloc_countries.countryFR';
- protected $valfield2 = 'geoloc_countries.country';
+ protected $valfield = 'geoloc_countries.country';
+ protected $valfield2 = 'geoloc_countries.countryEn';
protected $from = 'geoloc_countries';
protected $ac_join = 'INNER JOIN profile_addresses ON (geoloc_countries.iso_3166_1_a2 = profile_addresses.countryId)';
}
// }}}
+// {{{ class DE_SubAdminAreas
+class DE_SubAdminAreas extends DE_WithSuboption
+{
+ protected $idfield = 'geoloc_subadministrativeareas.id';
+ protected $optfield = 'geoloc_subadministrativeareas.administrativearea';
+ protected $valfield = 'geoloc_subadministrativeareas.name';
+ protected $from = 'geoloc_subadministrativeareas';
+
+ protected $ac_join = 'INNER JOIN profile_addresses ON (profile_addresses.subadministrativeAreaId = geoloc_subadministrativeareas.id)';
+ protected $ac_unique = 'profile_addresses.pid';
+}
+// }}}
+
// {{{ class DE_Localities
class DE_Localities extends DirEnumeration
{
}
// }}}
+// {{{ class DE_Skins
+class DE_Skins extends DirEnumeration
+{
+ public $capabilities = 0x005; // self::HAS_OPTIONS | self::SAVE_IN_SESSION;
+
+ protected $from = 'skins';
+ protected $valfield = 'name';
+ protected $idfield = 'skin_tpl';
+}
+// }}}
+
// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
?>