public function getList($userId)
{
try {
$ass = new Model_SubGroupUserAssign();
$table = $this->_dbTable;
$select = $table->select()->from($table, array('DISTINCT(iAudioCategoryId),vCategoryName'))->where('iSGroupId in ( ' . $ass->getAssignedGroupsIdsString($userId) . ' ) and eStatus = ?', 1)->order('vCategoryName ASC');
return $table->fetchAll($select);
} catch (Exception $e) {
return false;
}
}
public function getList($userId)
{
try {
$ass = new Model_SubGroupUserAssign();
$table = $this->_dbTable;
$select = $table->select()->from($table, array('DISTINCT(iDirectoryId),vFirstname,vLastname,vEmail,vJobTitle,vPhone'))->where('iSGroupId in(' . $ass->getAssignedGroupsIdsString($userId) . ') and eStatus = 1 ')->order('vFirstname ASC');
return $table->fetchAll($select);
} catch (Exception $e) {
return false;
}
}
public function getList($userId)
{
$ass = new Model_SubGroupUserAssign();
return $this->_dbTable->fetchAll('iSGroupId in(' . $ass->getAssignedGroupsIdsString($userId) . ') and eStatus = 1 ', 'vCoursename ASC');
}
