+ protected $where = 'WHERE FIND_IN_SET(\'admnistrative_area_3\', profile_addresses_components_enum.types)';
+ protected $ac_where = 'profile_addresses_components.type = \'home\' AND FIND_IN_SET(\'admnistrative_area_3\', profile_addresses_components_enum.types)';
+}
+
+class DE_Localities extends DE_AddressesComponents
+{
+ protected $where = 'WHERE FIND_IN_SET(\'locality\', profile_addresses_components_enum.types)';
+ protected $ac_where = 'profile_addresses_components.type = \'home\' AND FIND_IN_SET(\'locality\', profile_addresses_components_enum.types)';
+
+ // {{{ function getAutoComplete
+ public function getAutoComplete($text, $sub_id = null)
+ {
+ if (is_null($sub_id)) {
+ return parent::getAutoComplete($text);
+ } else {
+ $tests = $this->mkTests('pace1.long_name', $text);
+ $where .= '(' . implode(' OR ', $tests) . ')';
+ $query = "SELECT pace1.id AS id, pace1.long_name AS field, COUNT(DISTINCT(pac1.pid)) AS nb
+ FROM profile_addresses_components_enum AS pace1
+ INNER JOIN profile_addresses_components AS pac1 ON (pac1.component_id = pace1.id)
+ INNER JOIN profile_addresses_components AS pac2 ON (pac1.pid = pac2.pid AND pac1.jobid = pac2.jobid AND pac1.id = pac2.id
+ AND pac1.groupid = pac2.groupid AND pac1.type = pac2.type)
+ INNER JOIN profile_addresses_components_enum AS pace2 ON (pac2.component_id = pace2.id AND FIND_IN_SET('country', pace2.types))
+ WHERE pace2.id = {?} AND FIND_IN_SET('locality', pace1.types) AND pac1.type = 'home' AND " . $where . "
+ GROUP BY pace1.long_name
+ ORDER BY nb DESC, field
+ LIMIT " . self::AUTOCOMPLETE_LIMIT;
+ return XDB::fetchAllAssoc($query, $sub_id);
+ }
+ }
+ // }}}
+
+}