Example #1
0
 /**
  * 
  * @param int $managerCsuId
  */
 public function getMembersByManagerCsuId($managerCsuId)
 {
     $select = $this->select()->setIntegrityCheck(false)->from(array('t' => $this->_name), array())->join(array('tm' => 'csuTeamMember'), 'tm.csuTeamID = t.id')->where('t.managercsuid = ?', $managerCsuId)->order('tm.id')->group('tm.csuid');
     $row = $this->fetchAll($select);
     $team = array();
     if (count($row)) {
         foreach ($row as $data) {
             $member = new Model_Core_CSU_TeamMember();
             $member->populate($data->toArray());
             $team[] = $member;
         }
     }
     return $team;
 }
 /**
  * Gets a bunch of CSU team members by name 'like' match. Joins on the csu
  * table.
  * 
  * @param str $name
  * @return array
  */
 public function getCsuTeamMemberByName($name)
 {
     $select = $this->select()->setIntegrityCheck(false)->from(array('tm' => $this->_name))->join(array('c' => 'csu'), 'tm.csuid=c.csuid', array());
     $where = $this->quoteInto("c.realname LIKE ?", $name . '%');
     $select->where($where);
     $rows = $this->fetchAll($select);
     $ret = array();
     if (count($rows) > 0) {
         foreach ($rows as $row) {
             $csuTm = new Model_Core_CSU_TeamMember();
             $csuTm->populate($row);
             $ret[] = $csuTm;
         }
     }
     return $ret;
 }