<?php

// IMPORTANT: This script ONLY works for "status" batch edits, not for other
// types of batch edits.

// Put the PHID of the user who performed the bad edit here. You can get this
// by running `user.query` from the Conduit web API.
$actor_phid = 'PHID-USER-cvfydnwadpdj7vdon36z';


// Specify the start and end time of the bad edit here. We'll ignore changes
// outside this time range. By default, this is looking at changes in the last
// 24 hours.
$min_date = time() - (24 * 60 * 60);
$max_date = time();


// Specify the bad status that was set with the edit here. This is a key from
// the `maniphest.statuses` config, like "closed" or "invalid".
$bad_status = 'spite';


// Change this to "true" to actually apply changes. With this flag set to
// false, the script will run and show debugging output, but not do anything.
$apply_changes = false;


// --- End of Configuration ------------------------------------------------- //

require_once 'scripts/__init_script__.php';

$table = new ManiphestTask();
$conn_w = $table->establishConnection('w');
foreach (new LiskMigrationIterator($table) as $task) {
  $id = $task->getID();
  echo "Processing task T{$id}.\n";

  $status = $task->getStatus();
  if ($status != $bad_status) {
    echo "This task has status '{$status}', not the bad status; skipping.\n";
    continue;
  }

  $xactions = id(new ManiphestTransactionQuery())
    ->setViewer(PhabricatorUser::getOmnipotentUser())
    ->withObjectPHIDs(array($task->getPHID()))
    ->execute();
  msort($xactions, 'getID');

  // Find the bad edit so we know if and when this task was affected.

  $bad_edit = null;
  foreach ($xactions as $xaction) {
    if ($xaction->getTransactionType() != ManiphestTransaction::TYPE_STATUS) {
      continue;
    }

    if ($xaction->getAuthorPHID() != $actor_phid) {
      continue;
    }

    if ($xaction->getDateCreated() < $min_date) {
      continue;
    }

    if ($xaction->getDateCreated() > $max_date) {
      continue;
    }

    if ($xaction->getNewValue() != $bad_status) {
      continue;
    }

    if ($bad_edit) {
      if ($xaction->getID() > $bad_edit->getID()) {
        continue;
      }
    }

    $bad_edit = $xaction;
  }

  if (!$bad_edit) {
    echo "No matching edit to this task; skipping.\n";
    continue;
  }

  // Find the prior status change so we can figure out what status to revert
  // to.

  $last_good_status = ManiphestTaskStatus::getDefaultStatus();
  foreach ($xactions as $xaction) {
    if ($xaction->getID() == $bad_edit->getID()) {
      break;
    }

    if ($xaction->getTransactionType() != ManiphestTransaction::TYPE_STATUS) {
      continue;
    }

    $last_good_status = $xaction->getNewValue();
  }

  if (!$apply_changes) {
    echo "Would change status to '{$last_good_status}' if apply changes ".
         "flag was set.\n";
    continue;
  }

  echo "Updating task to status '{$last_good_status}'.\n";
  queryfx(
    $conn_w,
    'UPDATE %T SET status = %s WHERE id = %d',
    $table->getTableName(),
    $last_good_status,
    $task->getID());
}