/**
* Returns an array containing the type of children owned by the group
* @param int $groupId
* @return array[string]
* @throws Exception
*/
public function getChildTypes($groupId)
{
try {
$types = array();
if (PDOConnect::exists('SELECT GroupID FROM lkdatasetgroup WHERE GroupID = :groupId', array('groupId' => $groupId))) {
$types[] = 'data sets';
}
if (PDOConnect::exists('SELECT GroupID FROM lkdisplaygroupgroup WHERE GroupID = :groupId', array('groupId' => $groupId))) {
$types[] = 'display groups';
}
if (PDOConnect::exists('SELECT GroupID FROM lkcampaigngroup WHERE GroupID = :groupId', array('groupId' => $groupId))) {
$types[] = 'layouts and campaigns';
}
if (PDOConnect::exists('SELECT GroupID FROM lklayoutmediagroup WHERE GroupID = :groupId', array('groupId' => $groupId))) {
$types[] = 'media on layouts';
}
if (PDOConnect::exists('SELECT GroupID FROM lklayoutregiongroup WHERE GroupID = :groupId', array('groupId' => $groupId))) {
$types[] = 'regions on layouts';
}
if (PDOConnect::exists('SELECT GroupID FROM lkmediagroup WHERE GroupID = :groupId', array('groupId' => $groupId))) {
$types[] = 'media';
}
return $types;
} catch (Exception $e) {
Debug::Error($e->getMessage());
throw $e;
}
}
/**
* Returns an array containing the type of children owned by the user
* @return array[string]
* @throws Exception
*/
public function getChildTypes()
{
if (!isset($this->userId) || $this->userId == 0) {
return $this->SetError(__('Missing userId'));
}
try {
$types = array();
if (PDOConnect::exists('SELECT LayoutID FROM layout WHERE UserID = :userId', array('userId' => $this->userId))) {
$types[] = 'layouts';
}
if (PDOConnect::exists('SELECT MediaID FROM media WHERE UserID = :userId', array('userId' => $this->userId))) {
$types[] = 'media';
}
if (PDOConnect::exists('SELECT EventID FROM schedule WHERE UserID = :userId', array('userId' => $this->userId))) {
$types[] = 'scheduled layouts';
}
if (PDOConnect::exists('SELECT Schedule_DetailID FROM schedule_detail WHERE UserID = :userId', array('userId' => $this->userId))) {
$types[] = 'schedule detail records';
}
if (PDOConnect::exists('SELECT osr_id FROM oauth_server_registry WHERE osr_usa_id_ref = :userId', array('userId' => $this->userId))) {
$types[] = 'applications';
}
return $types;
} catch (Exception $e) {
Debug::Error($e->getMessage());
throw $e;
}
}
