示例#1
0
 public static function getInstance()
 {
     if (self::$instance === null) {
         self::$instance = new self();
     }
     return self::$instance;
 }
 /**
  * @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());
 }
示例#4
0
 /**
  * @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();
 }
示例#5
0
 function init()
 {
     $this->setTable(Gpf_Db_Table_Countries::getInstance());
     parent::init();
 }