zentaomax.php 487 B

1234567891011121314151617
  1. <?php
  2. public function getOutsideCompanies()
  3. {
  4. $companys = $this->dao->select('id, name')->from(TABLE_COMPANY)->where('id')->ne(1)->fetchPairs();
  5. return arrayUnion(array('' => ''), $companys);
  6. }
  7. public function getCompanyUserPairs()
  8. {
  9. $pairs = $this->dao->select("t1.account, CONCAT_WS('/', t2.name, t1.realname)")->from(TABLE_USER)->alias('t1')
  10. ->leftJoin(TABLE_COMPANY)->alias('t2')
  11. ->on('t1.company = t2.id')
  12. ->fetchPairs();
  13. return $pairs;
  14. }