public function __construct()
{
parent::__construct(self::B2DBNAME, self::ID);
parent::_addForeignKeyColumn(self::SCOPE, TBGScopesTable::getTable(), TBGScopesTable::ID);
parent::_addForeignKeyColumn(self::WORKFLOW_ID, TBGWorkflowsTable::getTable(), TBGWorkflowsTable::ID);
parent::_addForeignKeyColumn(self::FROM_STEP_ID, TBGWorkflowStepsTable::getTable(), TBGWorkflowStepsTable::ID);
parent::_addForeignKeyColumn(self::TRANSITION_ID, TBGWorkflowTransitionsTable::getTable(), TBGWorkflowTransitionsTable::ID);
}
public function __construct()
{
parent::__construct(self::B2DBNAME, self::ID);
parent::_addForeignKeyColumn(self::SCOPE, TBGScopesTable::getTable(), TBGScopesTable::ID);
parent::_addVarchar(self::ACTION_TYPE, 100);
parent::_addVarchar(self::TARGET_VALUE, 200);
parent::_addForeignKeyColumn(self::TRANSITION_ID, TBGWorkflowTransitionsTable::getTable(), TBGWorkflowTransitionsTable::ID);
parent::_addForeignKeyColumn(self::WORKFLOW_ID, TBGWorkflowsTable::getTable(), TBGWorkflowsTable::ID);
}
protected function _getByTypeID($type, $id)
{
$crit = $this->getCriteria();
$crit->addWhere(self::SCOPE, TBGContext::getScope()->getID());
$crit->addWhere($type == 'step' ? self::FROM_STEP_ID : self::TRANSITION_ID, $id);
$crit->addJoin(TBGWorkflowTransitionsTable::getTable(), TBGWorkflowTransitionsTable::ID, self::TRANSITION_ID);
$return_array = array();
if ($res = $this->doSelect($crit, false)) {
while ($row = $res->getNextRow()) {
if ($type == 'step') {
$return_array[$row->get(self::TRANSITION_ID)] = TBGContext::factory()->TBGWorkflowTransition($row->get(self::TRANSITION_ID));
} else {
$return_array[$row->get(self::FROM_STEP_ID)] = TBGContext::factory()->TBGWorkflowStep($row->get(self::FROM_STEP_ID));
}
}
}
return $return_array;
}
public function getNumberOfIncomingTransitions()
{
if ($this->_num_incoming_transitions === null && $this->_incoming_transitions !== null) {
$this->_num_incoming_transitions = count($this->_incoming_transitions);
} elseif ($this->_num_incoming_transitions === null) {
$this->_num_incoming_transitions = TBGWorkflowTransitionsTable::getTable()->countByStepID($this->getID());
}
return $this->_num_incoming_transitions;
}
public function runConfigureWorkflowTransition(TBGRequest $request)
{
$this->workflow = null;
$this->transition = null;
try {
$this->workflow = TBGWorkflowsTable::getTable()->selectById((int) $request['workflow_id']);
if ($request->hasParameter('transition_id')) {
$mode = $request['mode'];
$this->transition = TBGWorkflowTransitionsTable::getTable()->selectById((int) $request['transition_id']);
if ($request->isPost()) {
if ($mode == 'edit') {
if (!$this->transition->isInitialTransition()) {
$this->transition->setName($request['transition_name']);
$this->transition->setDescription($request['transition_description']);
if ($request['template']) {
$this->transition->setTemplate($request['template']);
} else {
$this->transition->setTemplate(null);
}
}
try {
$step = TBGWorkflowStepsTable::getTable()->selectById((int) $request['outgoing_step_id']);
$this->transition->setOutgoingStep($step);
} catch (Exception $e) {
}
$this->transition->save();
$transition = $this->transition;
$redirect_transition = true;
} elseif ($mode == 'delete') {
$this->transition->deleteTransition($request['direction']);
return $this->renderJSON('ok');
} elseif ($mode == 'delete_action') {
$this->action = TBGWorkflowTransitionActionsTable::getTable()->selectById((int) $request['action_id']);
$this->action->delete();
return $this->renderJSON(array('message' => $this->getI18n()->__('The action has been deleted')));
} elseif ($mode == 'new_action') {
$action = new TBGWorkflowTransitionAction();
$action->setActionType($request['action_type']);
$action->setTransition($this->transition);
$action->setWorkflow($this->workflow);
$action->setTargetValue('');
$action->save();
return $this->renderJSON(array('content' => $this->getComponentHTML('configuration/workflowtransitionaction', array('action' => $action))));
} elseif ($mode == 'update_action') {
$this->action = TBGWorkflowTransitionActionsTable::getTable()->selectById((int) $request['action_id']);
$this->action->setTargetValue($request['target_value']);
$this->action->save();
$text = $request['target_value'];
switch ($this->action->getActionType()) {
case TBGWorkflowTransitionAction::ACTION_ASSIGN_ISSUE:
if ($this->action->hasTargetValue()) {
$target_details = explode('_', $this->action->getTargetValue());
$text = $target_details[0] == 'user' ? TBGUser::getB2DBTable()->selectById((int) $target_details[1])->getNameWithUsername() : TBGTeam::getB2DBTable()->selectById((int) $target_details[1])->getName();
} else {
$text = $this->getI18n()->__('User specified during transition');
}
break;
case TBGWorkflowTransitionAction::ACTION_SET_RESOLUTION:
$text = $this->action->getTargetValue() ? TBGListTypesTable::getTable()->selectById((int) $this->action->getTargetValue())->getName() : $this->getI18n()->__('Resolution specified by user');
break;
case TBGWorkflowTransitionAction::ACTION_SET_REPRODUCABILITY:
$text = $this->action->getTargetValue() ? TBGListTypesTable::getTable()->selectById((int) $this->action->getTargetValue())->getName() : $this->getI18n()->__('Reproducability specified by user');
break;
case TBGWorkflowTransitionAction::ACTION_SET_STATUS:
$text = $this->action->getTargetValue() ? TBGListTypesTable::getTable()->selectById((int) $this->action->getTargetValue())->getName() : $this->getI18n()->__('Status specified by user');
break;
case TBGWorkflowTransitionAction::ACTION_SET_PRIORITY:
$text = $this->action->getTargetValue() ? TBGListTypesTable::getTable()->selectById((int) $this->action->getTargetValue())->getName() : $this->getI18n()->__('Priority specified by user');
break;
case TBGWorkflowTransitionAction::ACTION_SET_MILESTONE:
$text = $this->action->getTargetValue() ? TBGMilestonesTable::getTable()->selectById((int) $this->action->getTargetValue())->getName() : $this->getI18n()->__('Milestone specified by user');
break;
}
return $this->renderJSON(array('content' => $text));
} elseif ($mode == 'delete_validation_rule') {
$this->rule = TBGWorkflowTransitionValidationRulesTable::getTable()->selectById((int) $request['rule_id']);
$this->rule->delete();
return $this->renderJSON(array('message' => $this->getI18n()->__('The validation rule has been deleted')));
} elseif ($mode == 'new_validation_rule') {
$rule = new TBGWorkflowTransitionValidationRule();
if ($request['postorpre'] == 'post') {
$exists = (bool) $this->transition->hasPostValidationRule($request['rule']);
if (!$exists) {
$rule->setPost();
}
} elseif ($request['postorpre'] == 'pre') {
$exists = (bool) $this->transition->hasPreValidationRule($request['rule']);
if (!$exists) {
$rule->setPre();
}
}
if ($exists) {
$this->getResponse()->setHttpStatus(400);
return $this->renderJSON(array('message' => $this->getI18n()->__('This validation rule already exist')));
}
$rule->setRule($request['rule']);
$rule->setRuleValue('');
$rule->setTransition($this->transition);
$rule->setWorkflow($this->workflow);
$rule->save();
return $this->renderJSON(array('content' => $this->getTemplateHTML('configuration/workflowtransitionvalidationrule', array('rule' => $rule))));
} elseif ($mode == 'update_validation_rule') {
$this->rule = TBGWorkflowTransitionValidationRulesTable::getTable()->selectById((int) $request['rule_id']);
$text = null;
switch ($this->rule->getRule()) {
case TBGWorkflowTransitionValidationRule::RULE_MAX_ASSIGNED_ISSUES:
$this->rule->setRuleValue($request['rule_value']);
$text = $this->rule->getRuleValue() ? $this->rule->getRuleValue() : $this->getI18n()->__('Unlimited');
break;
case TBGWorkflowTransitionValidationRule::RULE_PRIORITY_VALID:
case TBGWorkflowTransitionValidationRule::RULE_REPRODUCABILITY_VALID:
case TBGWorkflowTransitionValidationRule::RULE_RESOLUTION_VALID:
case TBGWorkflowTransitionValidationRule::RULE_STATUS_VALID:
case TBGWorkflowTransitionValidationRule::RULE_TEAM_MEMBERSHIP_VALID:
$this->rule->setRuleValue(join(',', $request['rule_value']));
$text = $this->rule->getRuleValue() ? $this->rule->getRuleValueAsJoinedString() : $this->getI18n()->__('Any valid value');
break;
}
$this->rule->save();
return $this->renderJSON(array('content' => $text));
}
}
} elseif ($request->isPost() && $request->hasParameter('step_id')) {
$step = TBGWorkflowStepsTable::getTable()->selectById((int) $request['step_id']);
/*if ($step->isCore() || $workflow->isCore())
{
throw new InvalidArgumentException("The default workflow cannot be edited");
}*/
if ($request['add_transition_type'] == 'existing' && $request->hasParameter('existing_transition_id')) {
$transition = TBGWorkflowTransitionsTable::getTable()->selectById((int) $request['existing_transition_id']);
$redirect_transition = false;
} else {
if ($request['transition_name'] && $request['outgoing_step_id'] && $request->hasParameter('template')) {
if (($outgoing_step = TBGWorkflowStepsTable::getTable()->selectById((int) $request['outgoing_step_id'])) && $step instanceof TBGWorkflowStep) {
if (array_key_exists($request['template'], TBGWorkflowTransition::getTemplates())) {
$transition = new TBGWorkflowTransition();
$transition->setWorkflow($this->workflow);
$transition->setName($request['transition_name']);
$transition->setDescription($request['transition_description']);
$transition->setOutgoingStep($outgoing_step);
$transition->setTemplate($request['template']);
$transition->save();
$step->addOutgoingTransition($transition);
$redirect_transition = true;
} else {
throw new InvalidArgumentException($this->getI18n()->__('Please select a valid template'));
}
} else {
throw new InvalidArgumentException($this->getI18n()->__('Please select a valid outgoing step'));
}
} else {
throw new InvalidArgumentException($this->getI18n()->__('Please fill in all required fields'));
}
}
$step->addOutgoingTransition($transition);
} else {
throw new InvalidArgumentException('Invalid action');
}
} catch (InvalidArgumentException $e) {
//throw $e;
$this->error = $e->getMessage();
} catch (Exception $e) {
throw $e;
$this->error = $this->getI18n()->__('This workflow / transition does not exist');
}
if (isset($redirect_transition) && $redirect_transition) {
$this->forward(TBGContext::getRouting()->generate('configure_workflow_transition', array('workflow_id' => $this->workflow->getID(), 'transition_id' => $transition->getID())));
} elseif (isset($redirect_transition)) {
$this->forward(TBGContext::getRouting()->generate('configure_workflow_steps', array('workflow_id' => $this->workflow->getID())));
}
}
protected function _upgradeFrom3dot0()
{
// Add new tables
TBGScopeHostnamesTable::getTable()->create();
// Add classpath for existing old tables used for upgrade
TBGContext::addClasspath(THEBUGGENIE_MODULES_PATH . 'installation' . DS . 'classes' . DS . 'upgrade_3.0');
// Upgrade old tables
TBGScopesTable::getTable()->upgrade(TBGScopesTable3dot0::getTable());
TBGIssueFieldsTable::getTable()->upgrade(TBGIssueFieldsTable3dot0::getTable());
// Upgrade all modules
foreach (TBGContext::getModules() as $module) {
if (method_exists($module, 'upgradeFrom3dot0')) {
$module->upgradeFrom3dot0();
}
}
// Start a transaction to preserve the upgrade path
$transaction = B2DB::startTransaction();
// Add votes to feature requests for default issue type scheme
$its = new TBGIssuetypeScheme(1);
foreach (TBGIssuetype::getAll() as $fr) {
if ($fr instanceof TBGIssuetype) {
if (in_array($fr->getKey(), array('featurerequest', 'bugreport', 'enhancement'))) {
$its->setFieldAvailableForIssuetype($fr, 'votes');
}
}
}
$ut = TBGUsersTable::getTable();
$crit = $ut->getCriteria();
$crit->addUpdate(TBGUsersTable::PRIVATE_EMAIL, true);
$ut->doUpdate($crit);
// Add default gravatar setting
TBGSettings::saveSetting(TBGSettings::SETTING_ENABLE_GRAVATARS, 1);
$trans_crit = TBGWorkflowTransitionsTable::getTable()->getCriteria();
$trans_crit->addWhere(TBGWorkflowTransitionsTable::NAME, 'Request more information');
$trans_crit->addWhere(TBGWorkflowTransitionsTable::WORKFLOW_ID, 1);
$trans_row = TBGWorkflowTransitionsTable::getTable()->doSelectOne($trans_crit);
if ($trans_row) {
$transition = new TBGWorkflowTransition($trans_row->get(TBGWorkflowTransitionsTable::ID), $trans_row);
$transition->setTemplate('main/updateissueproperties');
$transition->save();
}
// End transaction and finalize upgrade
$transaction->commitAndEnd();
$this->upgrade_complete = true;
}
public function copy($new_name)
{
$new_workflow = new TBGWorkflow();
$new_workflow->setName($new_name);
$new_workflow->save();
$step_mapper = array();
$transition_mapper = array();
foreach ($this->getSteps() as $key => $step) {
$this->_steps[$key] = $step->copy($new_workflow);
$step_mapper[$key] = $this->_steps[$key]->getID();
}
foreach ($this->getTransitions() as $key => $transition) {
$old_id = $transition->getID();
$this->_transitions[$key] = $transition->copy($new_workflow);
$transition_mapper[$old_id] = $this->_transitions[$key]->getID();
}
TBGWorkflowStepTransitionsTable::getTable()->copyByWorkflowIDs($this->getID(), $new_workflow->getID());
TBGWorkflowStepTransitionsTable::getTable()->reMapStepIDsByWorkflowID($new_workflow->getID(), $step_mapper);
TBGWorkflowTransitionsTable::getTable()->reMapByWorkflowID($new_workflow->getID(), $step_mapper);
TBGWorkflowStepTransitionsTable::getTable()->reMapTransitionIDsByWorkflowID($new_workflow->getID(), $transition_mapper);
$new_initial_transition = $this->getInitialTransition()->copy($new_workflow);
$new_initial_transition->setOutgoingStepID($step_mapper[$this->getInitialTransition()->getOutgoingStep()->getID()]);
$new_initial_transition->save();
$new_workflow->setInitialTransition($new_initial_transition);
$new_workflow->save();
return $new_workflow;
}
protected function _upgradeFrom3dot1()
{
// Add classpath for existing old tables used for upgrade
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'installation' . DS . 'classes' . DS . 'upgrade_3.1');
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'mailing' . DS . 'classes' . DS . 'B2DB');
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'mailing' . DS . 'classes');
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'publish' . DS . 'classes' . DS . 'B2DB');
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'publish' . DS . 'classes');
// Create new tables
TBGDashboardViewsTable::getTable()->create();
TBGOpenIdAccountsTable::getTable()->create();
TBGProjectAssignedUsersTable::getTable()->create();
TBGProjectAssignedTeamsTable::getTable()->create();
TBGEditionAssignedUsersTable::getTable()->create();
TBGEditionAssignedTeamsTable::getTable()->create();
TBGComponentAssignedUsersTable::getTable()->create();
TBGComponentAssignedTeamsTable::getTable()->create();
TBGRolePermissionsTable::getTable()->create();
TBGUserScopesTable::getTable()->create();
// Upgrade existing tables
TBGProjectsTable::getTable()->upgrade(TBGProjectsTable3dot1::getTable());
TBGUsersTable::getTable()->upgrade(TBGUsersTable3dot1::getTable());
TBGIssuesTable::getTable()->upgrade(TBGIssuesTable3dot1::getTable());
TBGIssueTypesTable::getTable()->upgrade(TBGIssueTypesTable3dot1::getTable());
TBGListTypesTable::getTable()->upgrade(TBGListTypesTable3dot1::getTable());
TBGEditionsTable::getTable()->upgrade(TBGEditionsTable3dot1::getTable());
TBGBuildsTable::getTable()->upgrade(TBGBuildsTable3dot1::getTable());
TBGCommentsTable::getTable()->upgrade(TBGCommentsTable3dot1::getTable());
TBGComponentsTable::getTable()->upgrade(TBGComponentsTable3dot1::getTable());
TBGCustomFieldsTable::getTable()->upgrade(TBGCustomFieldsTable3dot1::getTable());
TBGCustomFieldOptionsTable::getTable()->upgrade(TBGCustomFieldOptionsTable3dot1::getTable());
TBGIssueCustomFieldsTable::getTable()->upgrade(TBGIssueCustomFieldsTable3dot1::getTable());
// Create new module tables
TBGIncomingEmailAccountTable::getTable()->create();
// Add new indexes
TBGArticlesTable::getTable()->createIndexes();
TBGCommentsTable::getTable()->createIndexes();
TBGIssueAffectsBuildTable::getTable()->createIndexes();
TBGIssueAffectsComponentTable::getTable()->createIndexes();
TBGIssueAffectsEditionTable::getTable()->createIndexes();
TBGIssueFieldsTable::getTable()->createIndexes();
TBGIssueFilesTable::getTable()->createIndexes();
TBGIssuesTable::getTable()->createIndexes();
TBGIssuetypeSchemesTable::getTable()->createIndexes();
TBGPermissionsTable::getTable()->createIndexes();
TBGProjectsTable::getTable()->createIndexes();
TBGSettingsTable::getTable()->createIndexes();
TBGTeamMembersTable::getTable()->createIndexes();
TBGUserIssuesTable::getTable()->createIndexes();
TBGUsersTable::getTable()->createIndexes();
TBGUserScopesTable::getTable()->createIndexes();
if (TBGContext::getRequest()->getParameter('fix_my_timestamps', false)) {
$this->_fixTimestamps();
}
foreach (TBGScope::getAll() as $scope) {
TBGRole::loadFixtures($scope);
foreach (TBGDatatype::getTypes() as $type => $class) {
TBGContext::setPermission('set_datatype_' . $type, 0, 'core', 0, 0, 0, true, $scope->getID());
}
TBGContext::setPermission('page_confirm_scope_access', 0, 'core', 0, 0, 0, true, $scope->getID());
if (!TBGSettings::get(TBGSettings::SETTING_DEFAULT_WORKFLOW, 'core', $scope->getID())) {
$workflow_id = TBGWorkflowsTable::getTable()->getFirstIdByScope($scope->getID());
if ($workflow_id) {
TBGSettings::saveSetting(TBGSettings::SETTING_DEFAULT_WORKFLOW, $workflow_id, 'core', $scope->getID());
} else {
TBGWorkflow::loadFixtures($scope);
}
}
if (!TBGSettings::get(TBGSettings::SETTING_DEFAULT_WORKFLOWSCHEME, 'core', $scope->getID())) {
$workflow_scheme_id = TBGWorkflowSchemesTable::getTable()->getFirstIdByScope($scope->getID());
if ($workflow_scheme_id) {
TBGSettings::saveSetting(TBGSettings::SETTING_DEFAULT_WORKFLOWSCHEME, $workflow_scheme_id, 'core', $scope->getID());
} else {
TBGWorkflowScheme::loadFixtures($scope);
}
}
if (!TBGSettings::get(TBGSettings::SETTING_DEFAULT_ISSUETYPESCHEME, 'core', $scope->getID())) {
$issuetype_scheme_id = TBGIssuetypeSchemesTable::getTable()->getFirstIdByScope($scope->getID());
if ($issuetype_scheme_id) {
TBGSettings::saveSetting(TBGSettings::SETTING_DEFAULT_ISSUETYPESCHEME, $issuetype_scheme_id, 'core', $scope->getID());
} else {
TBGIssuetypeScheme::loadFixtures($scope);
}
}
TBGSettings::saveSetting(TBGSettings::SETTING_FAVICON_ID, 0, 'core', $scope->getID());
TBGSettings::saveSetting(TBGSettings::SETTING_FAVICON_TYPE, 0, 'core', $scope->getID());
TBGSettings::saveSetting(TBGSettings::SETTING_HEADER_ICON_ID, 0, 'core', $scope->getID());
TBGSettings::saveSetting(TBGSettings::SETTING_HEADER_ICON_TYPE, 0, 'core', $scope->getID());
}
$linkstable = TBGLinksTable::getTable();
$crit = $linkstable->getCriteria();
$crit->addUpdate(TBGLinksTable::URL, 'http://issues.thebuggenie.com');
$crit->addWhere(TBGLinksTable::URL, 'http://thebuggenie.com/thebuggenie');
$crit->addOr(TBGLinksTable::URL, 'http://www.thebuggenie.com/thebuggenie');
$linkstable->doUpdate($crit);
$listtypestable = TBGListTypesTable::getTable();
$crit = $listtypestable->getCriteria();
$crit->addUpdate(TBGListTypesTable::ITEMTYPE, 'role');
$crit->addWhere(TBGListTypesTable::ITEMTYPE, 'projectrole');
$listtypestable->doUpdate($crit);
$crit = $listtypestable->getCriteria();
$crit->addUpdate(TBGListTypesTable::ITEMTYPE, 'priority');
$crit->addWhere(TBGListTypesTable::ITEMTYPE, 'b2_prioritytypes');
$listtypestable->doUpdate($crit);
TBGWorkflowTransitionsTable::getTable()->upgradeFrom3dot1();
TBGSettings::saveSetting(TBGSettings::SETTING_ICONSET, TBGSettings::get(TBGSettings::SETTING_THEME_NAME));
TBGContext::setPermission('readarticle', 0, 'publish', 0, 0, 0, true);
foreach (TBGProject::getAll() as $project) {
TBGDashboardViewsTable::getTable()->setDefaultViews($project->getID(), TBGDashboardViewsTable::TYPE_PROJECT);
if (!$project->getKey()) {
$project->setName($project->getName());
}
}
$this->upgrade_complete = true;
}
