public function findIssues($filters = array(), $results_per_page = 30, $offset = 0, $groupby = null, $grouporder = null, $sortfields = array(self::LAST_UPDATED => 'asc'))
{
$crit = $this->getCriteria();
$crit->addWhere(self::DELETED, false);
$crit->addWhere(self::SCOPE, framework\Context::getScope()->getID());
if (count($filters) > 0) {
$crit->addJoin(IssueCustomFields::getTable(), IssueCustomFields::ISSUE_ID, Issues::ID);
$crit->addJoin(IssueAffectsComponent::getTable(), IssueAffectsComponent::ISSUE, self::ID);
$crit->addJoin(IssueAffectsEdition::getTable(), IssueAffectsEdition::ISSUE, self::ID);
$crit->addJoin(IssueAffectsBuild::getTable(), IssueAffectsBuild::ISSUE, self::ID);
$filter_keys = array_keys($filters);
foreach ($filters as $filter) {
self::parseFilter($crit, $filter, $filter_keys);
}
}
$crit->addSelectionColumn(self::ID);
$crit->setDistinct();
if ($offset != 0) {
$crit->setOffset($offset);
}
$crit2 = clone $crit;
$count = $this->doCount($crit2);
if ($count > 0) {
$crit3 = $this->getCriteria();
if ($results_per_page != 0) {
$crit->setLimit($results_per_page);
}
if ($offset != 0) {
$crit->setOffset($offset);
}
if ($groupby !== null) {
$grouporder = $grouporder !== null ? $grouporder == 'asc' ? Criteria::SORT_ASC : Criteria::SORT_DESC : Criteria::SORT_ASC;
switch ($groupby) {
case 'category':
$crit->addJoin(ListTypes::getTable(), ListTypes::ID, self::CATEGORY);
$crit->addSelectionColumn(ListTypes::NAME);
$crit->addOrderBy(ListTypes::NAME, $grouporder);
$crit3->addJoin(ListTypes::getTable(), ListTypes::ID, self::CATEGORY);
$crit3->addOrderBy(ListTypes::NAME, $grouporder);
break;
case 'status':
$crit->addJoin(ListTypes::getTable(), ListTypes::ID, self::STATUS);
$crit->addSelectionColumn(self::STATUS);
$crit->addOrderBy(ListTypes::ORDER, Criteria::SORT_DESC);
$crit3->addJoin(ListTypes::getTable(), ListTypes::ID, self::STATUS);
$crit3->addOrderBy(ListTypes::ORDER, Criteria::SORT_DESC);
break;
case 'milestone':
$crit->addSelectionColumn(self::MILESTONE);
$crit->addSelectionColumn(self::PERCENT_COMPLETE);
$crit->addOrderBy(self::MILESTONE, $grouporder);
$crit->addOrderBy(self::PERCENT_COMPLETE, 'desc');
$crit3->addOrderBy(self::MILESTONE, $grouporder);
$crit3->addOrderBy(self::PERCENT_COMPLETE, 'desc');
break;
case 'assignee':
$crit->addSelectionColumn(self::ASSIGNEE_TEAM);
$crit->addSelectionColumn(self::ASSIGNEE_USER);
$crit->addOrderBy(self::ASSIGNEE_TEAM);
$crit->addOrderBy(self::ASSIGNEE_USER, $grouporder);
$crit3->addOrderBy(self::ASSIGNEE_TEAM);
$crit3->addOrderBy(self::ASSIGNEE_USER, $grouporder);
break;
case 'state':
$crit->addSelectionColumn(self::STATE);
$crit->addOrderBy(self::STATE, $grouporder);
$crit3->addOrderBy(self::STATE, $grouporder);
break;
case 'severity':
$crit->addJoin(ListTypes::getTable(), ListTypes::ID, self::SEVERITY);
$crit->addSelectionColumn(self::SEVERITY);
$crit->addOrderBy(ListTypes::ORDER, $grouporder);
$crit3->addJoin(ListTypes::getTable(), ListTypes::ID, self::SEVERITY);
$crit3->addOrderBy(ListTypes::ORDER, $grouporder);
break;
case 'user_pain':
$crit->addSelectionColumn(self::USER_PAIN);
$crit->addOrderBy(self::USER_PAIN, $grouporder);
$crit3->addOrderBy(self::USER_PAIN, $grouporder);
break;
case 'votes':
$crit->addSelectionColumn(self::VOTES_TOTAL);
$crit->addOrderBy(self::VOTES_TOTAL, $grouporder);
$crit3->addOrderBy(self::VOTES_TOTAL, $grouporder);
break;
case 'resolution':
$crit->addJoin(ListTypes::getTable(), ListTypes::ID, self::RESOLUTION);
$crit->addSelectionColumn(self::RESOLUTION);
$crit->addOrderBy(ListTypes::ORDER, $grouporder);
$crit3->addJoin(ListTypes::getTable(), ListTypes::ID, self::RESOLUTION);
$crit3->addOrderBy(ListTypes::ORDER, $grouporder);
break;
case 'priority':
$crit->addJoin(ListTypes::getTable(), ListTypes::ID, self::PRIORITY);
$crit->addSelectionColumn(self::PRIORITY);
$crit->addOrderBy(ListTypes::ORDER, $grouporder);
$crit3->addJoin(ListTypes::getTable(), ListTypes::ID, self::PRIORITY);
$crit3->addOrderBy(ListTypes::ORDER, $grouporder);
break;
case 'issuetype':
$crit->addJoin(IssueTypes::getTable(), IssueTypes::ID, self::ISSUE_TYPE);
$crit->addSelectionColumn(IssueTypes::NAME);
$crit->addOrderBy(IssueTypes::NAME, $grouporder);
$crit3->addJoin(IssueTypes::getTable(), IssueTypes::ID, self::ISSUE_TYPE);
$crit3->addOrderBy(IssueTypes::NAME, $grouporder);
break;
case 'edition':
$crit->addJoin(IssueAffectsEdition::getTable(), IssueAffectsEdition::ISSUE, self::ID);
$crit->addJoin(Editions::getTable(), Editions::ID, IssueAffectsEdition::EDITION, array(), Criteria::DB_LEFT_JOIN, IssueAffectsEdition::getTable());
$crit->addSelectionColumn(Editions::NAME);
$crit->addOrderBy(Editions::NAME, $grouporder);
$crit3->addJoin(IssueAffectsEdition::getTable(), IssueAffectsEdition::ISSUE, self::ID);
$crit3->addJoin(Editions::getTable(), Editions::ID, IssueAffectsEdition::EDITION, array(), Criteria::DB_LEFT_JOIN, IssueAffectsEdition::getTable());
$crit3->addOrderBy(Editions::NAME, $grouporder);
break;
case 'build':
$crit->addJoin(IssueAffectsBuild::getTable(), IssueAffectsBuild::ISSUE, self::ID);
$crit->addJoin(Builds::getTable(), Builds::ID, IssueAffectsBuild::BUILD, array(), Criteria::DB_LEFT_JOIN, IssueAffectsBuild::getTable());
$crit->addSelectionColumn(Builds::NAME);
$crit->addOrderBy(Builds::NAME, $grouporder);
$crit3->addJoin(IssueAffectsBuild::getTable(), IssueAffectsBuild::ISSUE, self::ID);
$crit3->addJoin(Builds::getTable(), Builds::ID, IssueAffectsBuild::BUILD, array(), Criteria::DB_LEFT_JOIN, IssueAffectsBuild::getTable());
$crit3->addOrderBy(Builds::NAME, $grouporder);
break;
case 'component':
$crit->addJoin(IssueAffectsComponent::getTable(), IssueAffectsComponent::ISSUE, self::ID);
$crit->addJoin(Components::getTable(), Components::ID, IssueAffectsComponent::COMPONENT, array(), Criteria::DB_LEFT_JOIN, IssueAffectsComponent::getTable());
$crit->addSelectionColumn(Components::NAME);
$crit->addOrderBy(Components::NAME, $grouporder);
$crit3->addJoin(IssueAffectsComponent::getTable(), IssueAffectsComponent::ISSUE, self::ID);
$crit3->addJoin(Components::getTable(), Components::ID, IssueAffectsComponent::COMPONENT, array(), Criteria::DB_LEFT_JOIN, IssueAffectsComponent::getTable());
$crit3->addOrderBy(Components::NAME, $grouporder);
break;
}
}
foreach ($sortfields as $field => $sortorder) {
$crit->addSelectionColumn($field);
$crit->addOrderBy($field, $sortorder);
}
$res = $this->doSelect($crit, 'none');
$ids = array();
if ($res) {
while ($row = $res->getNextRow()) {
$ids[] = $row->get(self::ID);
}
$ids = array_reverse($ids);
$crit3->addWhere(self::ID, $ids, Criteria::DB_IN);
foreach ($sortfields as $field => $sortorder) {
$crit3->addOrderBy($field, $sortorder);
}
$res = $this->doSelect($crit3);
$rows = $res->getAllRows();
} else {
$rows = array();
}
unset($res);
return array($rows, $count, $ids);
} else {
return array(null, 0, array());
}
}
protected function _saveCustomFieldValues()
{
foreach (CustomDatatype::getAll() as $key => $customdatatype) {
switch ($customdatatype->getType()) {
case CustomDatatype::INPUT_TEXT:
case CustomDatatype::INPUT_TEXTAREA_SMALL:
case CustomDatatype::INPUT_TEXTAREA_MAIN:
case CustomDatatype::DATE_PICKER:
$option_id = $this->getCustomField($key);
tables\IssueCustomFields::getTable()->saveIssueCustomFieldValue($option_id, $customdatatype->getID(), $this->getID());
break;
case CustomDatatype::EDITIONS_CHOICE:
case CustomDatatype::COMPONENTS_CHOICE:
case CustomDatatype::RELEASES_CHOICE:
case CustomDatatype::MILESTONE_CHOICE:
case CustomDatatype::STATUS_CHOICE:
case CustomDatatype::USER_CHOICE:
case CustomDatatype::TEAM_CHOICE:
case CustomDatatype::CLIENT_CHOICE:
$option_object = null;
try {
switch ($customdatatype->getType()) {
case CustomDatatype::EDITIONS_CHOICE:
case CustomDatatype::COMPONENTS_CHOICE:
case CustomDatatype::RELEASES_CHOICE:
case CustomDatatype::MILESTONE_CHOICE:
case CustomDatatype::CLIENT_CHOICE:
case CustomDatatype::STATUS_CHOICE:
case CustomDatatype::USER_CHOICE:
case CustomDatatype::TEAM_CHOICE:
$option_object = $this->getCustomField($key);
break;
}
} catch (\Exception $e) {
}
$option_id = is_object($option_object) ? $option_object->getID() : null;
tables\IssueCustomFields::getTable()->saveIssueCustomFieldOption($option_id, $customdatatype->getID(), $this->getID());
break;
default:
$option_id = $this->getCustomField($key) instanceof \thebuggenie\core\entities\CustomDatatypeOption ? $this->getCustomField($key)->getID() : null;
tables\IssueCustomFields::getTable()->saveIssueCustomFieldOption($option_id, $customdatatype->getID(), $this->getID());
break;
}
}
}
/**
*
* @param \b2db\Criteria $crit
* @param array|\thebuggenie\core\entities\SearchFilter $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']}%";
$issue_no = Issue::extractIssueNoFromNumber($this['value']);
if ($this['operator'] == '=') {
if ($ctn === null) {
$ctn = $crit->returnCriterion(tables\Issues::TITLE, $searchterm, Criteria::DB_LIKE);
}
$ctn->addOr(tables\Issues::DESCRIPTION, $searchterm, Criteria::DB_LIKE);
$ctn->addOr(tables\Issues::REPRODUCTION_STEPS, $searchterm, Criteria::DB_LIKE);
$ctn->addOr(tables\IssueCustomFields::OPTION_VALUE, $searchterm, Criteria::DB_LIKE);
if (is_numeric($issue_no)) {
$ctn->addOr(tables\Issues::ISSUE_NO, $issue_no, Criteria::DB_EQUALS);
}
$ctn->addOr(tables\IssueCustomFields::OPTION_VALUE, $searchterm, Criteria::DB_LIKE);
if (is_numeric($issue_no)) {
$ctn->addOr(tables\Issues::ISSUE_NO, $issue_no, Criteria::DB_EQUALS);
}
// $ctn->addOr(tables\IssueCustomFields::OPTION_VALUE, $searchterm, Criteria::DB_LIKE);
} else {
if ($ctn === null) {
$ctn = $crit->returnCriterion(tables\Issues::TITLE, $searchterm, Criteria::DB_NOT_LIKE);
}
$ctn->addWhere(tables\Issues::DESCRIPTION, $searchterm, Criteria::DB_NOT_LIKE);
$ctn->addWhere(tables\Issues::REPRODUCTION_STEPS, $searchterm, Criteria::DB_NOT_LIKE);
$ctn->addOr(tables\IssueCustomFields::OPTION_VALUE, $searchterm, Criteria::DB_NOT_LIKE);
if (is_numeric($issue_no)) {
$ctn->addWhere(tables\Issues::ISSUE_NO, $issue_no, Criteria::DB_EQUALS);
}
$ctn->addOr(tables\IssueCustomFields::OPTION_VALUE, $searchterm, Criteria::DB_NOT_LIKE);
if (is_numeric($issue_no)) {
$ctn->addWhere(tables\Issues::ISSUE_NO, $issue_no, Criteria::DB_EQUALS);
}
// $ctn->addOr(tables\IssueCustomFields::OPTION_VALUE, $searchterm, Criteria::DB_NOT_LIKE);
}
return $ctn;
}
} elseif (in_array($filter_key, self::getValidSearchFilters())) {
if ($filter_key == 'subprojects') {
if (framework\Context::isProjectContext()) {
if ($ctn === null) {
$ctn = $crit->returnCriterion(tables\Issues::PROJECT_ID, framework\Context::getCurrentProject()->getID());
}
if ($this->hasValue()) {
foreach ($this->getValues() as $value) {
switch ($value) {
case 'all':
$subprojects = Project::getIncludingAllSubprojectsAsArray(framework\Context::getCurrentProject());
foreach ($subprojects as $subproject) {
if ($subproject->getID() == framework\Context::getCurrentProject()->getID()) {
continue;
}
$ctn->addOr(tables\Issues::PROJECT_ID, $subproject->getID());
}
break;
case 'none':
case '':
break;
default:
$ctn->addOr(tables\Issues::PROJECT_ID, (int) $value);
break;
}
}
}
return $ctn;
}
} elseif (in_array($filter_key, array('build', 'edition', 'component'))) {
switch ($filter_key) {
case 'component':
$tbl = tables\IssueAffectsComponent::getTable();
$fk = tables\IssueAffectsComponent::ISSUE;
break;
case 'edition':
$tbl = tables\IssueAffectsEdition::getTable();
$fk = tables\IssueAffectsEdition::ISSUE;
break;
case 'build':
$tbl = tables\IssueAffectsBuild::getTable();
$fk = tables\IssueAffectsBuild::ISSUE;
break;
}
$crit->addJoin($tbl, $fk, tables\Issues::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(tables\Issues::STATE, Issue::STATE_OPEN);
$num_values++;
}
if ($this->hasValue('closed')) {
$num_values++;
if (isset($c)) {
$c->addWhere(tables\Issues::STATE, Issue::STATE_CLOSED);
} else {
$c = $crit->returnCriterion(tables\Issues::STATE, Issue::STATE_CLOSED);
}
}
if (isset($c)) {
if (count($values) == $num_values) {
return $c;
} else {
$crit->addWhere($c);
}
}
}
$dbname = tables\Issues::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 (CustomDatatype::doesKeyExist($filter_key)) {
$customdatatype = CustomDatatype::getByKey($filter_key);
if (in_array($this->getFilterType(), CustomDatatype::getInternalChoiceFieldsAsArray())) {
$tbl = clone tables\IssueCustomFields::getTable();
$crit->addJoin($tbl, tables\IssueCustomFields::ISSUE_ID, tables\Issues::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(tables\IssueCustomFields::CUSTOMFIELDS_ID, $customdatatype->getID());
$ctn->addWhere(tables\IssueCustomFields::CUSTOMFIELDOPTION_ID, $value, $this['operator']);
} else {
$ctn->addOr(tables\IssueCustomFields::CUSTOMFIELDOPTION_ID, $value, $this['operator']);
}
} else {
if ($ctn === null) {
$ctn = $crit->returnCriterion(tables\IssueCustomFields::CUSTOMFIELDS_ID, $customdatatype->getID());
$ctn->addWhere(tables\IssueCustomFields::OPTION_VALUE, $value, $this['operator']);
} else {
$ctn->addOr(tables\IssueCustomFields::OPTION_VALUE, $value, $this['operator']);
}
}
}
return $ctn;
}
}
}
}
protected function updateCustomFields($issue_ids, $to_scope_id)
{
$this->cliEcho("Moving custom fields... ");
$crit = IssueCustomFields::getTable()->getCriteria();
$crit->addWhere('issuecustomfields.issue_id', $issue_ids, Criteria::DB_IN);
$crit->addSelectionColumn('issuecustomfields.customfieldoption_id', 'option_id');
$crit->addSelectionColumn('issuecustomfields.customfields_id', 'customfield_id');
$customfields = [];
$customfieldoptions = [];
if ($res = IssueCustomFields::getTable()->doSelect($crit)) {
while ($row = $res->getNextRow()) {
$customfields[] = $row['customfield_id'];
}
}
$customfields_criteria = CustomFields::getTable()->getCriteria();
$customfields_criteria->addWhere('customfields.scope', $to_scope_id);
$customfields_criteria->indexBy('customfields.key');
$to_scope_customfields = CustomFields::getTable()->select($customfields_criteria);
$customfields_criteria = CustomFields::getTable()->getCriteria();
$customfields_criteria->addWhere('customfields.scope', $this->from_scope);
$customfields_criteria->indexBy('customfields.key');
$from_scope_customfields = CustomFields::getTable()->select($customfields_criteria);
foreach ($from_scope_customfields as $key => $customfield) {
if (!array_key_exists($key, $to_scope_customfields)) {
$new_customfield = clone $customfield;
$new_customfield->setScope($to_scope_id);
$new_customfield->save();
} else {
$new_customfield = $customfield;
}
$customfields[$customfield->getID()] = $new_customfield->getID();
if ($customfield->hasCustomOptions()) {
$custom_options = $new_customfield->getOptions();
foreach ($customfield->getOptions() as $option) {
$found = false;
foreach ($custom_options as $custom_option) {
if ($custom_option->getValue() == $option->getValue()) {
$new_custom_option = $custom_option;
$found = true;
break;
}
}
if (!$found) {
$new_custom_option = clone $option;
$new_custom_option->setCustomdatatype($new_customfield);
$new_custom_option->setScope($to_scope_id);
$new_custom_option->save();
}
$customfieldoptions[$option->getID()] = $new_custom_option->getID();
}
}
}
if (count($customfields)) {
foreach ($customfields as $old_id => $new_id) {
$crit = IssueCustomFields::getTable()->getCriteria();
$crit->addWhere('issuecustomfields.customfields_id', $old_id);
$crit->addUpdate('issuecustomfields.customfields_id', $new_id);
$crit->addUpdate('issuecustomfields.scope', $to_scope_id);
IssueCustomFields::getTable()->doUpdate($crit);
}
}
if (count($customfieldoptions)) {
foreach ($customfieldoptions as $old_id => $new_id) {
$crit = IssueCustomFields::getTable()->getCriteria();
$crit->addWhere('issuecustomfields.customfieldoption_id', $old_id);
$crit->addUpdate('issuecustomfields.customfieldoption_id', $new_id);
$crit->addUpdate('issuecustomfields.scope', $to_scope_id);
IssueCustomFields::getTable()->doUpdate($crit);
}
}
$this->cliEcho(" done\n");
}
