public function runAddFilter(TBGRequest $request)
{
if ($request['filter_name'] == 'project_id' && count(TBGProject::getAll()) == 0) {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => TBGContext::getI18n()->__('No projects exist so this filter can not be added')));
} elseif (in_array($request['filter_name'], TBGSearchFilter::getValidSearchFilters()) || TBGCustomDatatype::doesKeyExist($request['filter_name'])) {
return $this->renderJSON(array('content' => $this->getComponentHTML('search/filter', array('filter' => $request['filter_name'], 'key' => $request->getParameter('key', 0)))));
} else {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('error' => TBGContext::getI18n()->__('This is not a valid search field')));
}
}
public function runAddFilter(TBGRequest $request)
{
if ($request->getParameter('filter_name') == 'project_id' && count(TBGProject::getAll()) == 0) {
return $this->renderJSON(array('failed' => true, 'error' => TBGContext::getI18n()->__('No projects exist so this filter can not be added')));
} elseif (in_array($request->getParameter('filter_name'), TBGIssuesTable::getValidSearchFilters()) || TBGCustomDatatype::doesKeyExist($request->getParameter('filter_name'))) {
return $this->renderJSON(array('failed' => false, 'content' => $this->getComponentHTML('search/filter', array('filter' => $request->getParameter('filter_name'), 'key' => $request->getParameter('key', 0)))));
} else {
return $this->renderJSON(array('failed' => true, 'error' => TBGContext::getI18n()->__('This is not a valid search field')));
}
}
public function findIssues($filters = array(), $results_per_page = 30, $offset = 0, $groupby = null, $grouporder = null)
{
$crit = $this->getCriteria();
$crit->addWhere(self::DELETED, false);
if (count($filters) > 0) {
$crit->addJoin(TBGIssueCustomFieldsTable::getTable(), TBGIssueCustomFieldsTable::ISSUE_ID, TBGIssuesTable::ID);
foreach ($filters as $filter => $filter_info) {
if (array_key_exists('value', $filter_info) && in_array($filter_info['operator'], array('=', '!=', '<=', '>=', '<', '>'))) {
if ($filter == 'text') {
if ($filter_info['value'] != '') {
$searchterm = strpos($filter_info['value'], '%') !== false ? $filter_info['value'] : "%{$filter_info['value']}%";
if ($filter_info['operator'] == '=') {
$ctn = $crit->returnCriterion(self::TITLE, $searchterm, B2DBCriteria::DB_LIKE);
$ctn->addOr(self::DESCRIPTION, $searchterm, B2DBCriteria::DB_LIKE);
$ctn->addOr(self::REPRODUCTION_STEPS, $searchterm, B2DBCriteria::DB_LIKE);
$ctn->addOr(TBGIssueCustomFieldsTable::OPTION_VALUE, $searchterm, B2DBCriteria::DB_LIKE);
} else {
$ctn = $crit->returnCriterion(self::TITLE, $searchterm, B2DBCriteria::DB_NOT_LIKE);
$ctn->addWhere(self::DESCRIPTION, $searchterm, B2DBCriteria::DB_NOT_LIKE);
$ctn->addWhere(self::REPRODUCTION_STEPS, $searchterm, B2DBCriteria::DB_NOT_LIKE);
$ctn->addOr(TBGIssueCustomFieldsTable::OPTION_VALUE, $searchterm, B2DBCriteria::DB_NOT_LIKE);
}
$crit->addWhere($ctn);
}
} elseif (in_array($filter, self::getValidSearchFilters())) {
$crit->addWhere($this->getB2DBName() . '.' . $filter, $filter_info['value'], $filter_info['operator']);
} elseif (TBGCustomDatatype::doesKeyExist($filter)) {
$customdatatype = TBGCustomDatatype::getByKey($filter);
$ctn = $crit->returnCriterion(TBGIssueCustomFieldsTable::CUSTOMFIELDS_ID, $customdatatype->getID());
$ctn->addWhere(TBGIssueCustomFieldsTable::OPTION_VALUE, $filter_info['value'], $filter_info['operator']);
$crit->addWhere($ctn);
}
} else {
if (in_array($filter, self::getValidSearchFilters())) {
$first_val = array_shift($filter_info);
if ($filter == 'text') {
$filter_info = $first_val;
if ($filter_info['value'] != '') {
$searchterm = strpos($filter_info['value'], '%') !== false ? $filter_info['value'] : "%{$filter_info['value']}%";
if ($filter_info['operator'] == '=') {
$ctn = $crit->returnCriterion(self::TITLE, $searchterm, B2DBCriteria::DB_LIKE);
$ctn->addOr(self::DESCRIPTION, $searchterm, B2DBCriteria::DB_LIKE);
$ctn->addOr(self::REPRODUCTION_STEPS, $searchterm, B2DBCriteria::DB_LIKE);
} else {
$ctn = $crit->returnCriterion(self::TITLE, $searchterm, B2DBCriteria::DB_NOT_LIKE);
$ctn->addWhere(self::DESCRIPTION, $searchterm, B2DBCriteria::DB_NOT_LIKE);
$ctn->addWhere(self::REPRODUCTION_STEPS, $searchterm, B2DBCriteria::DB_NOT_LIKE);
}
$crit->addWhere($ctn);
}
} else {
$ctn = $crit->returnCriterion($this->getB2DBName() . '.' . $filter, $first_val['value'], $first_val['operator']);
if (count($filter_info) > 0) {
foreach ($filter_info as $single_filter) {
if (in_array($single_filter['operator'], array('=', '<=', '>=', '<', '>'))) {
$ctn->addOr($this->getB2DBName() . '.' . $filter, $single_filter['value'], $single_filter['operator']);
} elseif ($single_filter['operator'] == '!=') {
$ctn->addWhere($this->getB2DBName() . '.' . $filter, $single_filter['value'], $single_filter['operator']);
}
}
}
$crit->addWhere($ctn);
}
} elseif (TBGCustomDatatype::doesKeyExist($filter)) {
$customdatatype = TBGCustomDatatype::getByKey($filter);
$first_val = array_shift($filter_info);
$ctn = $crit->returnCriterion(TBGIssueCustomFieldsTable::CUSTOMFIELDS_ID, $customdatatype->getID());
$ctn->addWhere(TBGIssueCustomFieldsTable::OPTION_VALUE, $first_val['value'], $first_val['operator']);
if (count($filter_info) > 0) {
foreach ($filter_info as $single_filter) {
if (in_array($single_filter['operator'], array('=', '!=', '<=', '>=', '<', '>'))) {
$ctn->addOr(TBGIssueCustomFieldsTable::OPTION_VALUE, $single_filter['value'], $single_filter['operator']);
}
}
}
$crit->addWhere($ctn);
}
}
}
}
$crit->addSelectionColumn(self::ID);
$crit->setDistinct();
if ($offset != 0) {
$crit->setOffset($offset);
}
$crit2 = clone $crit;
$count = $this->doCount($crit2);
if ($count > 0) {
if ($results_per_page != 0) {
$crit->setLimit($results_per_page);
}
if ($offset != 0) {
$crit->setOffset($offset);
}
if ($groupby !== null) {
$grouporder = $grouporder !== null ? $grouporder == 'asc' ? B2DBCriteria::SORT_ASC : B2DBCriteria::SORT_DESC : B2DBCriteria::SORT_ASC;
switch ($groupby) {
case 'category':
$crit->addSelectionColumn(TBGListTypesTable::NAME);
$crit->addOrderBy(TBGListTypesTable::NAME, $grouporder);
break;
case 'status':
$crit->addSelectionColumn(self::STATUS);
$crit->addOrderBy(self::STATUS, $grouporder);
break;
case 'milestone':
$crit->addSelectionColumn(self::MILESTONE);
$crit->addSelectionColumn(self::PERCENT_COMPLETE);
$crit->addOrderBy(self::MILESTONE, $grouporder);
$crit->addOrderBy(self::PERCENT_COMPLETE, 'desc');
break;
case 'assignee':
$crit->addSelectionColumn(self::ASSIGNED_TYPE);
$crit->addSelectionColumn(self::ASSIGNED_TO);
$crit->addOrderBy(self::ASSIGNED_TYPE);
$crit->addOrderBy(self::ASSIGNED_TO, $grouporder);
break;
case 'state':
$crit->addSelectionColumn(self::STATE);
$crit->addOrderBy(self::STATE, $grouporder);
break;
case 'severity':
$crit->addSelectionColumn(self::SEVERITY);
$crit->addOrderBy(self::SEVERITY, $grouporder);
break;
case 'user_pain':
$crit->addSelectionColumn(self::USER_PAIN);
$crit->addOrderBy(self::USER_PAIN, $grouporder);
break;
case 'votes':
$crit->addSelectionColumn(self::VOTES_TOTAL);
$crit->addOrderBy(self::VOTES_TOTAL, $grouporder);
break;
case 'resolution':
$crit->addSelectionColumn(self::RESOLUTION);
$crit->addOrderBy(self::RESOLUTION, $grouporder);
break;
case 'priority':
$crit->addSelectionColumn(self::PRIORITY);
$crit->addOrderBy(self::PRIORITY, $grouporder);
break;
case 'issuetype':
$crit->addJoin(TBGIssueTypesTable::getTable(), TBGIssueTypesTable::ID, self::ISSUE_TYPE);
$crit->addSelectionColumn(TBGIssueTypesTable::NAME);
$crit->addOrderBy(TBGIssueTypesTable::NAME, $grouporder);
break;
case 'edition':
$crit->addJoin(TBGIssueAffectsEditionTable::getTable(), TBGIssueAffectsEditionTable::ISSUE, self::ID);
$crit->addJoin(TBGEditionsTable::getTable(), TBGEditionsTable::ID, TBGIssueAffectsEditionTable::EDITION, array(), B2DBCriteria::DB_LEFT_JOIN, TBGIssueAffectsEditionTable::getTable());
$crit->addSelectionColumn(TBGEditionsTable::NAME);
$crit->addOrderBy(TBGEditionsTable::NAME, $grouporder);
break;
case 'build':
$crit->addJoin(TBGIssueAffectsBuildTable::getTable(), TBGIssueAffectsBuildTable::ISSUE, self::ID);
$crit->addJoin(TBGBuildsTable::getTable(), TBGBuildsTable::ID, TBGIssueAffectsBuildTable::BUILD, array(), B2DBCriteria::DB_LEFT_JOIN, TBGIssueAffectsBuildTable::getTable());
$crit->addSelectionColumn(TBGBuildsTable::NAME);
$crit->addOrderBy(TBGBuildsTable::NAME, $grouporder);
break;
case 'component':
$crit->addJoin(TBGIssueAffectsComponentTable::getTable(), TBGIssueAffectsComponentTable::ISSUE, self::ID);
$crit->addJoin(TBGComponentsTable::getTable(), TBGComponentsTable::ID, TBGIssueAffectsComponentTable::COMPONENT, array(), B2DBCriteria::DB_LEFT_JOIN, TBGIssueAffectsComponentTable::getTable());
$crit->addSelectionColumn(TBGComponentsTable::NAME);
$crit->addOrderBy(TBGComponentsTable::NAME, $grouporder);
break;
}
}
$crit->addSelectionColumn(self::LAST_UPDATED);
$crit->addOrderBy(self::LAST_UPDATED, 'asc');
$res = $this->doSelect($crit, 'none');
$ids = array();
while ($row = $res->getNextRow()) {
$ids[] = $row->get(self::ID);
}
$ids = array_reverse($ids);
$crit2 = $this->getCriteria();
$crit2->addWhere(self::ID, $ids, B2DBCriteria::DB_IN);
$crit2->addOrderBy(self::ID, $ids);
$res = $this->doSelect($crit2);
return array($res, $count);
} else {
return array(null, 0);
}
}
/**
*
* @param \b2db\Criteria $crit
* @param array|TBGSearchFilter $filters
* @param \b2db\Criterion $ctn
* @return null
*/
public function addToCriteria($crit, $filters, $ctn = null)
{
$filter_key = $this->getFilterKey();
if (in_array($this['operator'], array('=', '!=', '<=', '>=', '<', '>'))) {
if ($filter_key == 'text') {
if ($this['value'] != '') {
$searchterm = mb_strpos($this['value'], '%') !== false ? $this['value'] : "%{$this['value']}%";
if ($this['operator'] == '=') {
if ($ctn === null) {
$ctn = $crit->returnCriterion(TBGIssuesTable::TITLE, $searchterm, Criteria::DB_LIKE);
}
$ctn->addOr(TBGIssuesTable::DESCRIPTION, $searchterm, Criteria::DB_LIKE);
$ctn->addOr(TBGIssuesTable::REPRODUCTION_STEPS, $searchterm, Criteria::DB_LIKE);
$ctn->addOr(TBGIssueCustomFieldsTable::OPTION_VALUE, $searchterm, Criteria::DB_LIKE);
} else {
if ($ctn === null) {
$ctn = $crit->returnCriterion(TBGIssuesTable::TITLE, $searchterm, Criteria::DB_NOT_LIKE);
}
$ctn->addWhere(TBGIssuesTable::DESCRIPTION, $searchterm, Criteria::DB_NOT_LIKE);
$ctn->addWhere(TBGIssuesTable::REPRODUCTION_STEPS, $searchterm, Criteria::DB_NOT_LIKE);
$ctn->addOr(TBGIssueCustomFieldsTable::OPTION_VALUE, $searchterm, Criteria::DB_NOT_LIKE);
}
return $ctn;
}
} elseif (in_array($filter_key, self::getValidSearchFilters())) {
if ($filter_key == 'subprojects') {
if (TBGContext::isProjectContext()) {
if ($ctn === null) {
$ctn = $crit->returnCriterion(TBGIssuesTable::PROJECT_ID, TBGContext::getCurrentProject()->getID());
}
if ($this->hasValue()) {
foreach ($this->getValues() as $value) {
switch ($value) {
case 'all':
$subprojects = TBGProject::getIncludingAllSubprojectsAsArray(TBGContext::getCurrentProject());
foreach ($subprojects as $subproject) {
if ($subproject->getID() == TBGContext::getCurrentProject()->getID()) {
continue;
}
$ctn->addOr(TBGIssuesTable::PROJECT_ID, $subproject->getID());
}
break;
case 'none':
case '':
break;
default:
$ctn->addOr(TBGIssuesTable::PROJECT_ID, (int) $value);
break;
}
}
}
return $ctn;
}
} elseif (in_array($filter_key, array('build', 'edition', 'component'))) {
switch ($filter_key) {
case 'component':
$tbl = TBGIssueAffectsComponentTable::getTable();
$fk = TBGIssueAffectsComponentTable::ISSUE;
break;
case 'edition':
$tbl = TBGIssueAffectsEditionTable::getTable();
$fk = TBGIssueAffectsEditionTable::ISSUE;
break;
case 'build':
$tbl = TBGIssueAffectsBuildTable::getTable();
$fk = TBGIssueAffectsBuildTable::ISSUE;
break;
}
$crit->addJoin($tbl, $fk, TBGIssuesTable::ID, array(array($tbl->getB2DBAlias() . '.' . $filter_key, $this->getValues())), \b2db\Criteria::DB_INNER_JOIN);
return null;
} else {
if ($filter_key == 'project_id' && in_array('subprojects', $filters)) {
return null;
}
$values = $this->getValues();
$num_values = 0;
if ($filter_key == 'status') {
if ($this->hasValue('open')) {
$c = $crit->returnCriterion(TBGIssuesTable::STATE, TBGIssue::STATE_OPEN);
$num_values++;
}
if ($this->hasValue('closed')) {
$num_values++;
if (isset($c)) {
$c->addWhere(TBGIssuesTable::STATE, TBGIssue::STATE_CLOSED);
} else {
$c = $crit->returnCriterion(TBGIssuesTable::STATE, TBGIssue::STATE_CLOSED);
}
}
if (isset($c)) {
if (count($values) == $num_values) {
return $c;
} else {
$crit->addWhere($c);
}
}
}
$dbname = TBGIssuesTable::getTable()->getB2DBName();
foreach ($values as $value) {
$operator = $this['operator'];
$or = true;
if ($filter_key == 'status' && in_array($value, array('open', 'closed'))) {
continue;
} else {
$field = $dbname . '.' . $filter_key;
if ($operator == '!=' || in_array($filter_key, array('posted', 'last_updated'))) {
$or = false;
}
}
if ($ctn === null) {
$ctn = $crit->returnCriterion($field, $value, urldecode($operator));
} elseif ($or) {
$ctn->addOr($field, $value, urldecode($operator));
} else {
$ctn->addWhere($field, $value, urldecode($operator));
}
}
return $ctn;
}
} elseif (TBGCustomDatatype::doesKeyExist($filter_key)) {
$customdatatype = TBGCustomDatatype::getByKey($filter_key);
if (in_array($this->getFilterType(), TBGCustomDatatype::getInternalChoiceFieldsAsArray())) {
$tbl = clone TBGIssueCustomFieldsTable::getTable();
$crit->addJoin($tbl, TBGIssueCustomFieldsTable::ISSUE_ID, TBGIssuesTable::ID, array(array($tbl->getB2DBAlias() . '.customfields_id', $customdatatype->getID()), array($tbl->getB2DBAlias() . '.customfieldoption_id', $this->getValues())), \b2db\Criteria::DB_INNER_JOIN);
return null;
} else {
foreach ($this->getValues() as $value) {
if ($customdatatype->hasCustomOptions()) {
if ($ctn === null) {
$ctn = $crit->returnCriterion(TBGIssueCustomFieldsTable::CUSTOMFIELDS_ID, $customdatatype->getID());
$ctn->addWhere(TBGIssueCustomFieldsTable::CUSTOMFIELDOPTION_ID, $value, $this['operator']);
} else {
$ctn->addOr(TBGIssueCustomFieldsTable::CUSTOMFIELDOPTION_ID, $value, $this['operator']);
}
} else {
if ($ctn === null) {
$ctn = $crit->returnCriterion(TBGIssueCustomFieldsTable::CUSTOMFIELDS_ID, $customdatatype->getID());
$ctn->addWhere(TBGIssueCustomFieldsTable::OPTION_VALUE, $value, $this['operator']);
} else {
$ctn->addOr(TBGIssueCustomFieldsTable::OPTION_VALUE, $value, $this['operator']);
}
}
}
return $ctn;
}
}
}
}
case 'pain_bug_type':
echo __("Please enter a valid triaged bug type");
break;
case 'pain_likelihood':
echo __("Please enter a valid triaged likelihood");
break;
case 'pain_effect':
echo __("Please enter a valid triaged effect");
break;
default:
echo __("Please triage the reported issue, so the user pain score can be properly calculated");
break;
}
?>
<?php
} elseif (TBGCustomDatatype::doesKeyExist($key)) {
?>
<?php
echo __('Required field "%field_name" is missing or invalid', array('%field_name' => TBGCustomDatatype::getByKey($key)->getDescription()));
?>
<?php
} else {
$event = new TBGEvent('core', 'reportissue.validationerror', $key);
$event->setReturnValue($key);
$event->triggerUntilProcessed();
echo __('A validation error occured: %error', array('%error' => $event->getReturnValue()));
?>
<?php
}
?>
</li>
