/** * * @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; }