public function do_execute()
{
$scopes = TBGScope::getAll();
$this->cliEcho("The ID for the default scope has an asterisk next to it\n\n");
$this->cliEcho("ID", 'white', 'bold');
$this->cliEcho(" - hostname(s)\n", 'white', 'bold');
foreach ($scopes as $scope_id => $scope) {
$this->cliEcho($scope_id, 'white', 'bold');
if ($scope->isDefault()) {
$this->cliEcho('*', 'white', 'bold');
$this->cliEcho(" - all unspecified hostnames\n");
} else {
$this->cliEcho(" - " . join(', ', $scope->getHostnames()) . "\n");
}
}
$this->cliEcho("\n");
}
public function runScopes(TBGRequest $request)
{
if ($request->isMethod(TBGRequest::POST)) {
$hostname = $request->getParameter('hostname');
$scopename = $request->getParameter('name');
if (!$hostname || TBGScopesTable::getTable()->getByHostname($hostname) instanceof TBGScope) {
$this->scope_hostname_error = true;
} elseif (!$scopename) {
$this->scope_name_error = true;
} else {
$scope = new TBGScope();
$scope->addHostname($hostname);
$scope->setName($scopename);
$scope->setEnabled();
$scope->save();
$this->forward(TBGContext::getRouting()->generate('configure_scopes'));
}
}
$this->scope_deleted = TBGContext::getMessageAndClear('scope_deleted');
$this->scopes = TBGScope::getAll();
}
public function runScopes(TBGRequest $request)
{
if ($request->isPost()) {
$hostname = $request['hostname'];
$hostname = str_replace(array('http://', 'https://'), array('', ''), $hostname);
$scopename = $request['name'];
if (!$hostname || TBGScopesTable::getTable()->getByHostname($hostname) instanceof TBGScope) {
$this->scope_hostname_error = true;
} elseif (!$scopename) {
$this->scope_name_error = true;
} else {
$scope = new TBGScope();
$scope->addHostname($hostname);
$scope->setName($scopename);
$scope->setEnabled();
$scope->save();
$this->forward(TBGContext::getRouting()->generate('configure_scopes'));
}
}
$this->scope_deleted = TBGContext::getMessageAndClear('scope_deleted');
$this->scopes = TBGScope::getAll();
}
private function _fixTimestamps()
{
// Unlimited execution time
set_time_limit(0);
foreach (TBGScope::getAll() as $scope) {
TBGContext::setScope($scope);
// The first job is to work out the offsets that need applying
$offsets = array('system', 'users');
$offsets['users'] = array();
$offsets['system'] = (int) TBGSettings::getGMToffset() * 3600;
$settingstable = TBGSettingsTable::getTable();
$crit = $settingstable->getCriteria();
$crit->addWhere(TBGSettingsTable::NAME, 'timezone');
$crit->addWhere(TBGSettingsTable::MODULE, 'core');
$crit->addWhere(TBGSettingsTable::UID, 0, \b2db\Criteria::DB_NOT_EQUALS);
$crit->addWhere(TBGSettingsTable::VALUE, 0, \b2db\Criteria::DB_NOT_EQUALS);
$crit->addWhere(TBGSettingsTable::VALUE, 'sys', \b2db\Criteria::DB_NOT_EQUALS);
$crit->addWhere(TBGSettingsTable::SCOPE, $scope->getID());
$res = $settingstable->doSelect($crit);
if ($res instanceof \b2db\Resultset) {
while ($user = $res->getNextRow()) {
$offsets['users']['uid_' . $user->get(TBGSettingsTable::UID)] = (int) $user->get(TBGSettingsTable::VALUE) * 3600;
}
}
// Now go through every thing which requires updating
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'publish' . DS . 'classes' . DS . 'B2DB');
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'publish' . DS . 'classes');
// ARTICLE HISTORY
$this->_fixUserDependentTimezone($offsets, TBGArticleHistoryTable::getTable(), TBGArticleHistoryTable::AUTHOR, TBGArticleHistoryTable::DATE, $scope);
// ARTICLES
$this->_fixUserDependentTimezone($offsets, TBGArticlesTable::getTable(), TBGArticlesTable::AUTHOR, TBGArticlesTable::DATE, $scope);
// BUILDS
$this->_fixNonUserDependentTimezone($offsets, TBGBuildsTable::getTable(), TBGBuildsTable::RELEASE_DATE, $scope, TBGBuildsTable::RELEASED);
// COMMENTS
$this->_fixUserDependentTimezone($offsets, TBGCommentsTable::getTable(), array('a' => TBGCommentsTable::POSTED_BY, 'b' => TBGCommentsTable::UPDATED_BY), array('a' => TBGCommentsTable::POSTED, 'b' => TBGCommentsTable::UPDATED), $scope);
// EDITIONS
$this->_fixNonUserDependentTimezone($offsets, TBGEditionsTable::getTable(), TBGEditionsTable::RELEASE_DATE, $scope, TBGEditionsTable::RELEASED);
// ISSUES
// This is a bit more complex so do this manually - we have to poke around with the issue log
$table = TBGIssuesTable::getTable();
$crit = $table->getCriteria();
$crit->addWhere(TBGIssuesTable::SCOPE, $scope->getID());
$crit->addWhere(TBGIssuesTable::DELETED, false);
$res = $table->doSelect($crit);
if ($res) {
while ($row = $res->getNextRow()) {
$crit = TBGLogTable::getTable()->getCriteria();
$crit->addSelectionColumn(TBGLogTable::UID);
$crit->addWhere(TBGLogTable::CHANGE_TYPE, TBGLogTable::LOG_ISSUE_ASSIGNED);
$crit->addWhere(TBGLogTable::TARGET, $row->get(TBGIssuesTable::ID));
$crit->addWhere(TBGLogTable::TARGET_TYPE, TBGLogTable::TYPE_ISSUE);
$crit->addOrderBy(TBGLogTable::TIME, b2db\Criteria::SORT_DESC);
$crit->addOrderBy(TBGLogTable::ID, b2db\Criteria::SORT_DESC);
if ($row2 = TBGLogTable::getTable()->doSelectOne($crit)) {
$assigned_by = $row2->get(TBGLogTable::UID);
}
$crit = TBGLogTable::getTable()->getCriteria();
$crit->addSelectionColumn(TBGLogTable::UID);
$crit->addWhere(TBGLogTable::TARGET, $row->get(TBGIssuesTable::ID));
$crit->addWhere(TBGLogTable::TARGET_TYPE, TBGLogTable::TYPE_ISSUE);
$crit->addOrderBy(TBGLogTable::TIME, b2db\Criteria::SORT_DESC);
$crit->addOrderBy(TBGLogTable::ID, b2db\Criteria::SORT_DESC);
if ($row2 = TBGLogTable::getTable()->doSelectOne($crit)) {
$updated_by = $row2->get(TBGLogTable::UID);
}
unset($crit);
unset($row2);
if (array_key_exists('uid_' . $row->get(TBGIssuesTable::POSTED_BY), $offsets['users'])) {
$offset = $offsets['users']['uid_' . $row->get(TBGIssuesTable::POSTED_BY)];
} else {
$offset = $offsets['system'];
}
if (isset($updated_by) && array_key_exists('uid_' . $updated_by, $offsets['users'])) {
$offset2 = $offsets['users']['uid_' . $updated_by];
} elseif (isset($updated_by)) {
$offset2 = $offsets['system'];
}
if (isset($assigned_by) && array_key_exists('uid_' . $assigned_by, $offsets['users'])) {
$offset3 = $offsets['users']['uid_' . $assigned_by];
} elseif (isset($assigned_by)) {
$offset3 = $offsets['system'];
}
$crit2 = $table->getCriteria();
$crit2->addUpdate(TBGIssuesTable::POSTED, (int) $row->get(TBGIssuesTable::POSTED) + $offset);
if (isset($offset2)) {
$crit2->addUpdate(TBGIssuesTable::LAST_UPDATED, (int) $row->get(TBGIssuesTable::LAST_UPDATED) + $offset2);
unset($offset2);
}
if (isset($offset3)) {
$crit2->addUpdate(TBGIssuesTable::BEING_WORKED_ON_BY_USER_SINCE, (int) $row->get(TBGIssuesTable::BEING_WORKED_ON_BY_USER_SINCE) + $offset3);
unset($offset3);
}
$crit2->addWhere(TBGIssuesTable::ID, $row->get(TBGIssuesTable::ID));
$table->doUpdate($crit2);
}
}
// LOG
$this->_fixUserDependentTimezone($offsets, TBGLogTable::getTable(), TBGLogTable::UID, TBGLogTable::TIME, $scope);
// MILESTONES
// The conditions are a bit different here so do it manually
$table = TBGMilestonesTable::getTable();
$crit = $table->getCriteria();
$crit->addWhere(TBGMilestonesTable::SCOPE, $scope->getID());
$res = $table->doSelect($crit);
if ($res) {
while ($row = $res->getNextRow()) {
$offset = $offsets['system'];
$crit2 = $table->getCriteria();
$added = 0;
if ($row->get(TBGMilestonesTable::REACHED) > 0) {
$crit2->addUpdate(TBGMilestonesTable::REACHED, (int) $row->get(TBGMilestonesTable::REACHED) + $offset);
$added = 1;
}
if ($row->get(TBGMilestonesTable::SCHEDULED) > 0) {
$crit2->addUpdate(TBGMilestonesTable::SCHEDULED, (int) $row->get(TBGMilestonesTable::SCHEDULED) + $offset);
$added = 1;
}
if ($row->get(TBGMilestonesTable::STARTING) > 0) {
$crit2->addUpdate(TBGMilestonesTable::STARTING, (int) $row->get(TBGMilestonesTable::STARTING) + $offset);
$added = 1;
}
// Only do something if at least one call to addUpdate is done
if ($added == 1) {
$crit2->addWhere(TBGMilestonesTable::ID, $row->get(TBGMilestonesTable::ID));
$table->doUpdate($crit2);
}
}
}
// PROJECTS
$this->_fixNonUserDependentTimezone($offsets, TBGProjectsTable::getTable(), TBGProjectsTable::RELEASE_DATE, $scope, TBGProjectsTable::RELEASED);
// VCS INTEGRATION
// check if module is loaded
$modules = TBGModulesTable::getTable()->getModulesForScope($scope->getID());
if ($modules['vcs_integration'] == true) {
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'vcs_integration' . DS . 'classes' . DS . 'B2DB');
TBGContext::addAutoloaderClassPath(THEBUGGENIE_MODULES_PATH . 'vcs_integration' . DS . 'classes');
$this->_fixUserDependentTimezone($offsets, TBGVCSIntegrationTable::getTable(), TBGVCSIntegrationTable::AUTHOR, TBGVCSIntegrationTable::DATE, $scope);
}
}
}
public function componentUserscopes()
{
$this->scopes = TBGScope::getAll();
}