<?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';
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
{