/** * @return Gpf_SqlBuilder_SelectBuilder */ protected function createCountriesSelect() { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add(Gpf_Db_Table_Countries::COUNTRY_CODE, 'code'); $select->select->add(Gpf_Db_Table_Countries::COUNTRY, 'name'); $select->from->add(Gpf_Db_Table_Countries::getName()); $select->where->add(Gpf_Db_Table_Countries::STATUS, '=', Gpf_Db_Country::STATUS_ENABLED); $select->orderBy->add(Gpf_Db_Table_Countries::ORDER); $select->orderBy->add(Gpf_Db_Table_Countries::COUNTRY); return $select; }
protected function buildFrom() { $this->_selectBuilder->from->add(Gpf_Db_Table_Countries::getName()); }
/** * @service country read * @anonym * @return Gpf_Data_RecordSet */ public function loadCountries() { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add(Gpf_Db_Table_Countries::COUNTRY_CODE, 'id'); $select->select->add(Gpf_Db_Table_Countries::COUNTRY, 'name'); $select->from->add(Gpf_Db_Table_Countries::getName()); $select->where->add(Gpf_Db_Table_Countries::ACCOUNTID, '=', Gpf_Application::getInstance()->getAccountId()); $select->where->add(Gpf_Db_Table_Countries::STATUS, '=', Gpf_Db_Country::STATUS_ENABLED); $select->orderBy->add(Gpf_Db_Table_Countries::COUNTRY); return $select->getAllRows(); }