public static function handleBrowseRequest($options = [], $conditions = [], $responseID = null, $responseData = [])
{
// apply status filter
if (empty($_GET['status'])) {
$status = 'open';
} elseif ($_GET['status'] == 'any') {
$status = null;
} elseif (in_array($_GET['status'], AbstractAlert::getFieldOptions('Status', 'values'))) {
$status = $_GET['status'];
} else {
$status = 'open';
}
if ($status) {
$responseData['status'] = $conditions['Status'] = $status;
}
// apply endpoint filter
if (!empty($_GET['endpoint'])) {
if (!($Endpoint = Endpoint::getByHandle($_GET['endpoint']))) {
return static::throwNotFoundError('Endpoint not found');
}
}
if (isset($Endpoint)) {
$conditions['EndpointID'] = $Endpoint->ID;
$responseData['Endpoint'] = $Endpoint;
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
public static function handleBrowseRequest($options = array(), $conditions = array(), $responseID = null, $responseData = array())
{
if ($_REQUEST['q'] != 'all') {
$conditions[] = 'AccountLevel != "Disabled"';
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
public static function handleBrowseRequest($options = [], $conditions = [], $responseID = null, $responseData = [])
{
if (!empty($_GET['ProjectID']) && ctype_digit($_GET['ProjectID']) && ($Project = Project::getByID($_GET['ProjectID']))) {
$conditions['ProjectID'] = $Project->ID;
$responseData['Project'] = $Project;
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
public static function handleBrowseRequest($options = array(), $conditions = array(), $responseID = null, $responseData = array())
{
if (!$GLOBALS['Session']->hasAccountLevel('Staff') || empty($_GET['showall'])) {
$conditions['Status'] = 'Published';
$conditions[] = 'Published IS NULL OR Published <= CURRENT_TIMESTAMP';
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
public static function handleBrowseRequest($options = [], $conditions = [], $responseID = null, $responseData = [])
{
// apply endpoint filter
if (!empty($_REQUEST['endpoint'])) {
if (!($Endpoint = Endpoint::getByHandle($_REQUEST['endpoint']))) {
return static::throwNotFoundError('Endpoint not found');
}
$conditions['EndpointID'] = $Endpoint->ID;
$responseData['Endpoint'] = $Endpoint;
}
// apply method filter
if (!empty($_REQUEST['method'])) {
$conditions['Method'] = $_REQUEST['method'];
}
// apply path filter
if (!empty($_REQUEST['path-substring'])) {
$conditions[] = 'Path LIKE "%' . DB::escape($_REQUEST['path-substring']) . '%"';
}
// apply path filter
if (!empty($_REQUEST['query-substring'])) {
$conditions[] = 'Query LIKE "%' . DB::escape($_REQUEST['query-substring']) . '%"';
}
// apply IP filter
if (!empty($_REQUEST['ip'])) {
if (!filter_var($_REQUEST['ip'], FILTER_VALIDATE_IP)) {
return static::throwError('IP is invalid');
}
$conditions['ClientIP'] = ip2long($_REQUEST['ip']);
}
// apply key filter
if (!empty($_REQUEST['key'])) {
if (!($Key = Key::getByKey($_REQUEST['key']))) {
return static::throwError('key is invalid');
}
$conditions['KeyID'] = $Key->ID;
}
// apply time filter
if (!empty($_REQUEST['time-max']) && ($timeMax = strtotime($_REQUEST['time-max']))) {
$conditions[] = 'Created <= "' . date('Y-m-d H:i:s', $timeMax) . '"';
}
if (!empty($_REQUEST['time-min']) && ($timeMin = strtotime($_REQUEST['time-min']))) {
$conditions[] = 'Created >= "' . date('Y-m-d H:i:s', $timeMin) . '"';
}
// apply type filter
if (!empty($_REQUEST['type'])) {
if ($_REQUEST['type'] == 'ping') {
$conditions['Class'] = PingTransaction::class;
} elseif ($_REQUEST['type'] == 'consumer') {
$conditions['Class'] = Transaction::class;
}
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
public static function handleBrowseRequest($options = array(), $conditions = array(), $responseID = null, $responseData = array())
{
if (!empty($_GET['competency'])) {
if (ctype_digit($_GET['competency'])) {
$Competency = Competency::getByID($_GET['competency']);
} else {
$Competency = Competency::getByCode($_GET['competency']);
}
if (!$Competency) {
return static::throwNotFoundError('Competency not found');
}
$conditions['CompetencyID'] = $Competency->ID;
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
public static function handleBrowseRequest($options = array(), $conditions = array(), $responseID = null, $responseData = array())
{
if (!empty($_GET['skill']) && ctype_digit($_GET['skill'])) {
// TODO: implement this as a lower-level override to the generated browse query so it can be a FROM subquery
try {
$demonstrations = DB::allValues('DemonstrationID', 'SELECT DemonstrationID FROM `%s` WHERE SkillID = %u', [DemonstrationSkill::$tableName, $_GET['skill']]);
} catch (TableNotFoundException $e) {
$demonstrations = [];
}
$conditions[] = 'ID IN (' . implode($demonstrations, ',') . ')';
}
if (!empty($_GET['student']) && ctype_digit($_GET['student'])) {
$conditions['StudentID'] = $_GET['student'];
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
public static function handleBrowseRequest($options = [], $conditions = [], $responseID = null, $responseData = [])
{
// apply tag filter
if (!empty($_REQUEST['tag'])) {
// get tag
if (!($Tag = Tag::getByHandle($_REQUEST['tag']))) {
return static::throwNotFoundError('Tag not found');
}
$conditions[] = 'ID IN (SELECT ContextID FROM tag_items WHERE TagID = ' . $Tag->ID . ' AND ContextClass = "Laddr\\\\Project")';
}
// apply stage filter
if (!empty($_REQUEST['stage'])) {
$conditions['Stage'] = $_REQUEST['stage'];
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
public static function handleBrowseRequest($options = array(), $conditions = array(), $responseID = null, $responseData = array())
{
// apply tag filter
if (!empty($_REQUEST['tag'])) {
// get tag
if (!($Tag = Tag::getByHandle($_REQUEST['tag']))) {
return static::throwNotFoundError('Tag not found');
}
$conditions[] = 'ID IN (SELECT ContextID FROM tag_items WHERE TagID = ' . $Tag->ID . ' AND ContextClass = "Product")';
}
// apply context filter
if (!empty($_REQUEST['ContextClass'])) {
$conditions['ContextClass'] = $_REQUEST['ContextClass'];
}
if (!empty($_REQUEST['ContextID']) && is_numeric($_REQUEST['ContextID'])) {
$conditions['ContextID'] = $_REQUEST['ContextID'];
}
return parent::handleBrowseRequest($options, $conditions, $responseID, $responseData);
}
