{
//DB_DataObject::debugLevel(1);
- if(!empty($q['_join_country_with_person'])){
-// $tn = $this->tableName();
-//// $this->selectAdd();
-// $this->selectAdd(" i18n_translate('c' , Office.country, 'en') as office_id_country_name");
- $this->_extra_col = array('office_country_name');
-// $this->_distinct= 'office_id_country&cols=office_id_country,office_id_country_name';
- //then the query should be _distinct=office_id_country&cols=office_id_country,office_id_country_name
-// $p = DB_DataObject::factory('Person');
-// $p->whereAdd("office_id > 0");
-// $p->selectAdd();
-// $p->selectAdd("DISTINCT(office_id) as office_id");
-// $officeIds = $p->fetchAll('office_id');
-// $this->whereAddIn($tn.'.id', $officeIds, 'INT');
-// $this->selectAdd();
-// $this->selectAdd("DISTINCT({$tn}.country) as country");
-// $this->joinAddCountryWithPerson();
- }
}
function joinAddCountryWithPerson()