/**
  * Get all countries where dial code is not null
  * @param string $language language code
  * @return array
  */
 public function getAllCountries($language = null)
 {
     if (!isset($language)) {
         $language = 'en';
     }
     $query = "  SELECT c.*,ct.value AS country_tr\n                    FROM country AS c\n                        LEFT JOIN country_translate AS ct ON c.code2 = ct.code2 AND ct.language = '" . addslashes($language) . "'\n                    WHERE c.dial_code is not NULL ORDER BY ct.value ASC";
     $resultSet = $this->_dbTable->getAdapter()->fetchAll($query);
     $countries = array();
     foreach ($resultSet as $row) {
         $country = new Application_Model_Country();
         if ($row['country_tr']) {
             $row['name'] = $row['country_tr'];
         }
         $country->setOptions($row);
         $countries[] = $country;
     }
     return $countries;
 }