Reassign Tasks for Inactive Accounts Part 2! #14483
Labels
Eng: Data
Mark when data has been backfilled, or the issue has any data integrity concerns
Feature: generic-queue
Priority: Medium
Blocking issue w/workaround, or "second in" priority for new work.
Product: caseflow-queue
Stakeholder: BVA
Functionality associated with the Board of Veterans' Appeals workflows/feature requests
Team: Echo 🐬
Comments
hschallhorn
added
Eng: Data
## VACOWELLSW4
Whitney Wells (VACOWELLSW4 ) to Jonathan Hager (BVAJHAGER)
css_id = "VACOWELLSW4"
judge_css_id = "BVAJHAGER"
user = User.find_by_css_id(css_id)
judge = User.find_by_css_id(judge_css_id)
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
pp [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [1, 4, 0]
### ama
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
ama_tasks.pluck(:id)
=> [573772]
ama_tasks.each do |task|
ActiveRecord::Base.transaction do
attorney_task, judge_decision_task, judge_assign_task = task.send_back_to_judge_assign!
cancellation_instuctions = "This task has been cancelled due to the reassignment of all tasks previously assigned to #{css_id}."
attorney_task.update_with_instructions(instructions: cancellation_instuctions)
judge_decision_task.update_with_instructions(instructions: cancellation_instuctions)
judge_assign_task.update_with_instructions(instructions: "This task has been assigned due to the reassignment of all tasks previously assigned to #{css_id}.")
end
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
### legacy tasks
legacy_tasks.pluck(:id)
=> [352351, 488409, 552307, 380634]
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0## VACOSIMSR
RASHIDA SIMS (VACOSIMSR) Jennifer White (BVAJWHITE)
css_id = "VACOSIMSR"
judge_css_id = "BVAJWHITE"
user = User.find_by_css_id(css_id)
judge = User.find_by_css_id(judge_css_id)
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
pp [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [4, 9, 0]
### ama
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
ama_tasks.pluck(:id)
=> [765999, 740603, 442316, 560815]
ama_tasks.each do |atty_task|
ActiveRecord::Base.transaction do
judge_assign_task = JudgeAssignTask.create!(appeal: atty_task.appeal, parent: atty_task.appeal.root_task, assigned_to: judge, status: Constants.TASK_STATUSES.on_hold)
atty_task.children.open.each { |child| child.update!(parent: judge_assign_task) }
atty_task.parent.cancel_task_and_child_subtasks
cancellation_instuctions = "This task has been cancelled due to the reassignment of all tasks previously assigned to #{css_id}."
atty_task.update_with_instructions(instructions: cancellation_instuctions)
atty_task.parent.update_with_instructions(instructions: cancellation_instuctions)
judge_assign_task.update_with_instructions(instructions: "This task has been assigned due to the reassignment of all tasks previously assigned to #{css_id}.")
end
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
# need to put the judge_assigns on hold
Tasks.where(id: [957673, 957674, 957675, 957676]).update(status: Constants.TASK_STATUSES.on_hold)
### legacy tasks
legacy_tasks.pluck(:id)
=> [713172, 843013, 447719, 675192, 767472, 767471, 817736, 817737, 907372]
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0 |
vacoramirm2css_id = "vacoramirm2"
judge_css_id = "bvasbush"
user = User.find_by_css_id(css_id)
judge = User.find_by_css_id(judge_css_id)
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
pp [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [3, 11, 0]
### ama
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
ama_tasks.pluck(:id)
=> [873986, 816965, 789737]
ama_tasks.each do |atty_task|
ActiveRecord::Base.transaction do
### create judge_assign_task
judge_assign_task = JudgeAssignTask.create!(appeal: atty_task.appeal, parent: atty_task.appeal.root_task, assigned_to: judge)
### update status to on_hold
judge_assign_task.update(status: Constants.TASK_STATUSES.on_hold)
### handle attorney tasks
atty_task.children.open.each { |child| child.update!(parent: judge_assign_task) }
### handle open parent judge_decision_review tasks
atty_task.parent.cancel_task_and_child_subtasks
cancellation_instuctions = "This task has been cancelled due to the reassignment of all tasks previously assigned to #{css_id}."
atty_task.update_with_instructions(instructions: cancellation_instuctions)
atty_task.parent.update_with_instructions(instructions: cancellation_instuctions)
judge_assign_task.update_with_instructions(instructions: "This task has been assigned due to the reassignment of all tasks previously assigned to #{css_id}.")
end
end
# double check changes
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
### legacy tasks
legacy_tasks.pluck(:id)
=> [836913, 855426, 855428, 753968, 781807, 852272, 988318, 988319, 980538, 781808, 894185]
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0 |
2 tasks
inactive_user = User.find_by(css_id: "VACOdourmm".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
ama_task.count
=> 1
task = ama_tasks.first
task.parent.treee
Appeal 30112 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
JudgeDecisionReviewTask 930427 on_hold BVATCATINO BVATCATINO 2020-06-18 19:40:50 UTC
├── AttorneyTask 930428 completed BVATCATINO VACODOURMM 2020-06-10 20:47:40 UTC
└── AttorneyRewriteTask 963707 on_hold BVATCATINO VACODOURMM 2020-06-18 21:32:11 UTC
├── ExtensionColocatedTask 964076 on_hold VACODOURMM Colocated 2020-06-18 21:32:11 UTC
│ ├── ExtensionColocatedTask 964077 cancelled VACODOURMM BVARSEAY 2020-07-27 13:17:48 UTC
│ └── ExtensionColocatedTask 1048494 on_hold VACOBOOKEK BVAPBROWNING 2020-07-28 11:26:32 UTC
│ └── TimedHoldTask 1050877 in_progress BVAPBROWNING BVAPBROWNING 2020-07-28 11:26:33 UTC
└── HearingClarificationColocatedTask 964078 cancelled VACODOURMM Colocated 2020-07-27 13:16:59 UTC
└── HearingClarificationColocatedTask 964079 cancelled VACODOURMM BVARSEAY 2020-07-27 13:16:59 UTC
# Let's move the colocated task to the judge task. This will ensure the case returns to the judge when the colocated task is completed
Task.find(964076).update!(parent_id: 930427)
task.parent.reload.treee
Appeal 30112 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
JudgeDecisionReviewTask 930427 on_hold BVATCATINO BVATCATINO 2020-06-18 19:40:50 UTC
├── AttorneyTask 930428 completed BVATCATINO VACODOURMM 2020-06-10 20:47:40 UTC
├── AttorneyRewriteTask 963707 on_hold BVATCATINO VACODOURMM 2020-06-18 21:32:11 UTC
│ └── HearingClarificationColocatedTask 964078 cancelled VACODOURMM Colocated 2020-07-27 13:16:59 UTC
│ └── HearingClarificationColocatedTask 964079 cancelled VACODOURMM BVARSEAY 2020-07-27 13:16:59 UTC
└── ExtensionColocatedTask 964076 on_hold VACODOURMM Colocated 2020-09-14 16:06:58 UTC
├── ExtensionColocatedTask 964077 cancelled VACODOURMM BVARSEAY 2020-07-27 13:17:48 UTC
└── ExtensionColocatedTask 1048494 on_hold VACOBOOKEK BVAPBROWNING 2020-07-28 11:26:32 UTC
└── TimedHoldTask 1050877 in_progress BVAPBROWNING BVAPBROWNING 2020-07-28 11:26:33 UTC
# Now let's cancel the AttorneyRewriteTask
Task.find(963707).cancelled!
task.parent.reload.treee
Appeal 30112 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
JudgeDecisionReviewTask 930427 on_hold BVATCATINO BVATCATINO 2020-06-18 19:40:50 UTC
├── AttorneyTask 930428 completed BVATCATINO VACODOURMM 2020-06-10 20:47:40 UTC
├── AttorneyRewriteTask 963707 cancelled BVATCATINO VACODOURMM 2020-09-14 16:07:57 UTC
│ └── HearingClarificationColocatedTask 964078 cancelled VACODOURMM Colocated 2020-07-27 13:16:59 UTC
│ └── HearingClarificationColocatedTask 964079 cancelled VACODOURMM BVARSEAY 2020-07-27 13:16:59 UTC
└── ExtensionColocatedTask 964076 on_hold VACODOURMM Colocated 2020-09-14 16:06:58 UTC
├── ExtensionColocatedTask 964077 cancelled VACODOURMM BVARSEAY 2020-07-27 13:17:48 UTC
└── ExtensionColocatedTask 1048494 on_hold VACOBOOKEK BVAPBROWNING 2020-07-28 11:26:32 UTC
└── TimedHoldTask 1050877 in_progress BVAPBROWNING BVAPBROWNING 2020-07-28 11:26:33 UTC
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_tasks.count
=> 3
judge = User.find_by_css_id("BVATCATINO")
legacy_tasks.update_all(assigned_by_id: judge.id)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
=> #<ActiveRecord::Relation []> |
1 task
inactive_user = User.find_by(css_id: "".upcase)
reassignee = User.find_by(css_id: "".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
ama_tasks.count
=>
legacy_tasks.count
=>
legacy_tasks.update_all(assigned_by_id: reassignee.id)
legacy_cases.count
=>
legacy_cases.each { |case_record| case_record.update_vacols_location!(reassignee.vacols_user.slogid) }inactive_user = User.find_by(css_id: "VACOLEALR1".upcase)
reassignee = User.find_by(css_id: "BVAMELARKIN".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
=> #<ActiveRecord::Relation []>
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_tasks.count
=> 3
legacy_tasks.update_all(assigned_by_id: reassignee.id)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
=> #<ActiveRecord::Relation []>inactive_user = User.find_by(css_id: "VACOLEEC1".upcase)
reassignee = User.find_by(css_id: "BVABWILSON".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
ama_tasks.count
# => 1
task = ama_tasks.first
task.appeal.treee
Appeal 25359 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 380945 on_hold Bva 2019-09-06 13:26:18 UTC
├── TrackVeteranTask 380946 in_progress Vso 2019-09-06 13:26:18 UTC
├── DistributionTask 380947 completed Bva 2020-03-09 13:45:23 UTC
│ └── InformalHearingPresentationTask 380948 completed Vso 2020-01-23 19:23:23 UTC
│ └── InformalHearingPresentationTask 599948 completed VACOWENDET BVAAMONTAGUE 2020-01-23 19:23:23 UTC
├── JudgeAssignTask 744069 completed BVABWILSON 2020-03-10 18:12:28 UTC
└── JudgeDecisionReviewTask 748793 on_hold BVABWILSON 2020-03-10 18:12:28 UTC
└── AttorneyTask 748794 assigned BVABWILSON VACOLEEC1 2020-10-07 20:07:08 UTC
└── OtherColocatedTask 823122 completed VACOLEEC1 Colocated 2020-10-07 20:07:08 UTC
└── OtherColocatedTask 823123 completed VACOLEEC1 VACOBERGER 2020-10-07 20:07:08 UTC
└── TimedHoldTask 1066202 completed VACOBERGER VACOBERGER 2020-09-30 21:30:30 UTC
# Cancel the attorney task, reopen the judge assign task
task.send_back_to_judge_assign!
task.appeal.reload.treee
Appeal 25359 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 380945 on_hold Bva 2019-09-06 13:26:18 UTC
├── TrackVeteranTask 380946 in_progress Vso 2019-09-06 13:26:18 UTC
├── DistributionTask 380947 completed Bva 2020-03-09 13:45:23 UTC
│ └── InformalHearingPresentationTask 380948 completed Vso 2020-01-23 19:23:23 UTC
│ └── InformalHearingPresentationTask 599948 completed VACOWENDET BVAAMONTAGUE 2020-01-23 19:23:23 UTC
├── JudgeAssignTask 744069 completed BVABWILSON 2020-03-10 18:12:28 UTC
├── JudgeDecisionReviewTask 748793 cancelled BVABWILSON 2020-10-19 16:41:15 UTC
│ └── AttorneyTask 748794 cancelled BVABWILSON VACOLEEC1 2020-10-19 16:41:15 UTC
│ └── OtherColocatedTask 823122 completed VACOLEEC1 Colocated 2020-10-07 20:07:08 UTC
│ └── OtherColocatedTask 823123 completed VACOLEEC1 VACOBERGER 2020-10-07 20:07:08 UTC
│ └── TimedHoldTask 1066202 completed VACOBERGER VACOBERGER 2020-09-30 21:30:30 UTC
└── JudgeAssignTask 1203375 assigned BVABWILSON 2020-10-19 16:41:15 UTC
legacy_tasks.count
# => 1
legacy_tasks.update_all(assigned_by_id: reassignee.id)
legacy_cases.count
# => 2
legacy_cases.each { |case_record| case_record.update_vacols_location!(reassignee.vacols_user.slogid) }inactive_user = User.find_by(css_id: "VACONELSOJ".upcase)
reassignee = User.find_by(css_id: "BVADWIGHT".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
ama_tasks.count
=> 1
task = ama_tasks.first
task.appeal.treee
Appeal 55870 (evidence_submission) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 663219 on_hold Bva 2020-02-04 13:16:36 UTC
├── DistributionTask 663221 completed Bva 2020-03-02 13:32:37 UTC
│ └── EvidenceSubmissionWindowTask 663222 completed MailTeam 2020-02-04 16:30:16 UTC
├── JudgeAssignTask 725024 completed BVADWIGHT 2020-03-19 20:37:39 UTC
└── JudgeDecisionReviewTask 769589 on_hold BVADWIGHT 2020-03-19 20:37:39 UTC
└── AttorneyTask 769590 on_hold BVADWIGHT VACONELSOJ 2020-03-23 17:47:17 UTC
└── FoiaColocatedTask 774761 on_hold VACONELSOJ PrivacyTeam 2020-03-23 17:47:17 UTC
└── FoiaTask 774762 on_hold VACONELSOJ PrivacyTeam 2020-09-18 12:41:05 UTC
└── FoiaTask 1155233 assigned BVAJRETAN VACODOUGLN 2020-09-18 12:41:05 UTC
# Cancel the attorney task, reopen the judge assign task
task.send_back_to_judge_assign!
FoiaColocatedTask.find(774761).update!(parent_id: 1203389)
task.appeal.reload.treee
Appeal 55870 (evidence_submission) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 663219 on_hold Bva 2020-02-04 13:16:36 UTC
├── DistributionTask 663221 completed Bva 2020-03-02 13:32:37 UTC
│ └── EvidenceSubmissionWindowTask 663222 completed MailTeam 2020-02-04 16:30:16 UTC
├── JudgeAssignTask 725024 completed BVADWIGHT 2020-03-19 20:37:39 UTC
├── JudgeDecisionReviewTask 769589 cancelled BVADWIGHT 2020-10-19 16:47:59 UTC
│ └── AttorneyTask 769590 cancelled BVADWIGHT VACONELSOJ 2020-10-19 16:47:59 UTC
└── JudgeAssignTask 1203389 on_hold BVADWIGHT 2020-10-19 20:05:57 UTC
└── FoiaColocatedTask 774761 on_hold VACONELSOJ PrivacyTeam 2020-10-19 16:48:19 UTC
└── FoiaTask 774762 on_hold VACONELSOJ PrivacyTeam 2020-09-18 12:41:05 UTC
└── FoiaTask 1155233 assigned BVAJRETAN VACODOUGLN 2020-09-18 12:41:05 UTC
legacy_tasks.count
=> 0
legacy_cases.count
=> 5
legacy_cases.each { |case_record| case_record.update_vacols_location!(reassignee.vacols_user.slogid) }inactive_user = User.find_by(css_id: "VACORAJS".upcase)
reassignee = User.find_by(css_id: "BVADWIGHT".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
ama_tasks.count
=> 0
legacy_tasks.count
=> 1
legacy_tasks.update_all(assigned_by_id: reassignee.id)
legacy_cases.count
=> 4
legacy_cases.each { |case_record| case_record.update_vacols_location!(reassignee.vacols_user.slogid) }inactive_user = User.find_by(css_id: "VACOHENRYC1".upcase)
reassignee = User.find_by(css_id: "bvaRFeinberg".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
ama_tasks.count
=> 0
legacy_tasks.count
=> 2
legacy_tasks.update_all(assigned_by_id: reassignee.id)
legacy_cases.count
=> 0 |
inactive_user = User.find_by(css_id: "VACODAVENB".upcase)
reassignee = User.find_by(css_id: "bvahwalker".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
ama_tasks.count
=> 0
legacy_tasks.count
=> 0
legacy_cases.count
=> 0inactive_user = User.find_by(css_id: "VACOGonzam6".upcase)
reassignee = User.find_by(css_id: "bvankroes".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
ama_tasks.count
=> 0
legacy_tasks.count
=> 5
legacy_tasks.update_all(assigned_by_id: reassignee.id)
legacy_cases.count
=> 0inactive_user = User.find_by(css_id: "VACOmontaj".upcase)
reassignee = User.find_by(css_id: "bvadwhitehd".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 2, 0]
legacy_tasks.update_all(assigned_by_id: reassignee.id)inactive_user = User.find_by(css_id: "VACODANKLZ".upcase)
reassignee = User.find_by(css_id: "bvadwsingle".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 0, 0]inactive_user = User.find_by(css_id: "VACOWILLIW".upcase)
reassignee = User.find_by(css_id: "BVACBENJAMIN".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 0, 0]inactive_user = User.find_by(css_id: "VACOTHOMPK3".upcase)
reassignee = User.find_by(css_id: "BVANDoan".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 3, 1]
legacy_tasks.update_all(assigned_by_id: reassignee.id)
legacy_cases.each { |case_record| case_record.update_vacols_location!(reassignee.vacols_user.slogid) }inactive_user = User.find_by(css_id: "VACOWARREI".upcase)
reassignee = User.find_by(css_id: "VACOMARCUS".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [1, 1, 0]
task = ama_tasks.first
task.appeal.reload.treee
Appeal 37872 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 477962 on_hold Bva 2019-10-21 17:34:03 UTC
├── TrackVeteranTask 477963 in_progress FieldVso 2019-10-21 17:34:03 UTC
├── DistributionTask 477964 completed Bva 2020-03-27 12:47:30 UTC
│ └── InformalHearingPresentationTask 477965 cancelled FieldVso 2020-09-21 16:25:56 UTC
├── JudgeAssignTask 786174 completed VACOMARCUS 2020-03-31 11:43:19 UTC
└── JudgeDecisionReviewTask 792149 on_hold VACOMARCUS 2020-03-31 11:43:19 UTC
└── AttorneyTask 792150 on_hold VACOMARCUS VACOWARREI 2020-04-02 21:15:39 UTC
└── FoiaColocatedTask 803315 on_hold VACOWARREI PrivacyTeam 2020-04-02 21:15:39 UTC
└── FoiaTask 803316 on_hold VACOWARREI PrivacyTeam 2020-09-25 15:00:17 UTC
└── FoiaTask 1168966 assigned BVAJRETAN VACOHODGET 2020-09-25 15:00:17 UTC
# Cancel the attorney task, reopen the judge assign task
parent = task.send_back_to_judge_assign!.last
FoiaColocatedTask.find(803315).update!(parent_id: parent)
parent.on_hold!
task.appeal.reload.treee
Appeal 37872 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 477962 on_hold Bva 2019-10-21 17:34:03 UTC
├── TrackVeteranTask 477963 in_progress FieldVso 2019-10-21 17:34:03 UTC
├── DistributionTask 477964 completed Bva 2020-03-27 12:47:30 UTC
│ └── InformalHearingPresentationTask 477965 cancelled FieldVso 2020-09-21 16:25:56 UTC
├── JudgeAssignTask 786174 completed VACOMARCUS 2020-03-31 11:43:19 UTC
├── JudgeDecisionReviewTask 792149 cancelled VACOMARCUS 2020-10-19 20:04:45 UTC
│ └── AttorneyTask 792150 cancelled VACOMARCUS VACOWARREI 2020-10-19 20:04:45 UTC
└── JudgeAssignTask 1204156 on_hold VACOMARCUS 2020-10-19 20:05:37 UTC
└── FoiaColocatedTask 803315 on_hold VACOWARREI PrivacyTeam 2020-10-19 20:05:17 UTC
└── FoiaTask 803316 on_hold VACOWARREI PrivacyTeam 2020-09-25 15:00:17 UTC
└── FoiaTask 1168966 assigned BVAJRETAN VACOHODGET 2020-09-25 15:00:17 UTC
legacy_tasks.update_all(assigned_by_id: reassignee.id)inactive_user = User.find_by(css_id: "Vacojagadl".upcase)
reassignee = User.find_by(css_id: "vacoTangM".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [6, 0, 6]
legacy_cases.each { |case_record| case_record.update_vacols_location!(reassignee.vacols_user.slogid) }
puts ama_tasks.map(&:appeal).map(&:tree)
Appeal 23184 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 366239 completed Bva 2020-07-17 16:11:06 UTC
├── TrackVeteranTask 366240 completed FieldVso 2020-07-17 16:11:06 UTC
├── DistributionTask 366241 completed Bva 2020-05-26 12:19:38 UTC
│ └── HearingTask 366242 completed Bva 2020-01-28 19:29:40 UTC
│ ├── ScheduleHearingTask 366243 completed Bva 2019-09-17 16:29:17 UTC
│ └── AssignHearingDispositionTask 414637 completed Bva 2020-01-28 19:29:40 UTC
│ ├── TranscriptionTask 542197 completed TranscriptionTeam 2020-01-27 15:24:48 UTC
│ └── EvidenceSubmissionWindowTask 542198 completed MailTeam 2020-01-28 19:29:40 UTC
├── JudgeAssignTask 913568 completed BVAASCIRE 2020-05-27 00:23:53 UTC
├── JudgeDecisionReviewTask 916183 completed BVAASCIRE BVAASCIRE 2020-07-17 14:39:49 UTC
│ └── AttorneyTask 916184 completed BVAASCIRE VACOTOLBEG 2020-06-30 19:57:56 UTC
│ ├── MissingRecordsColocatedTask 937048 completed VACOTOLBEG Colocated 2020-06-22 17:11:37 UTC
│ │ ├── MissingRecordsColocatedTask 937049 cancelled VACOTOLBEG VACOJENKIM12 2020-09-21 16:33:56 UTC
│ │ └── MissingRecordsColocatedTask 958324 completed VACOBOOKEK VACODRAYTM 2020-06-22 17:11:37 UTC
│ └── OtherColocatedTask 937050 completed VACOTOLBEG Colocated 2020-06-22 17:01:08 UTC
│ ├── OtherColocatedTask 937051 cancelled VACOTOLBEG VACOJENKIM12 2020-09-21 16:33:56 UTC
│ └── OtherColocatedTask 958327 completed VACOBOOKEK VACODRAYTM 2020-06-22 17:01:08 UTC
├── StatusInquiryMailTask 963723 on_hold MailTeam 2020-06-18 19:43:30 UTC
│ └── StatusInquiryMailTask 963724 on_hold VACOCHARLS LitigationSupport 2020-06-21 18:39:44 UTC
│ └── StatusInquiryMailTask 968188 assigned BVASGINSKI VACOJAGADL 2020-08-25 16:28:04 UTC
│ └── StatusInquiryMailTask 1015706 completed VACOJAGADL HearingsManagement 2020-08-25 16:28:04 UTC
│ └── StatusInquiryMailTask 1074592 completed VACOCARTER1 VACOWATSOM 2020-08-25 16:28:04 UTC
└── BvaDispatchTask 1019563 completed BvaDispatch 2020-07-17 16:11:06 UTC
└── BvaDispatchTask 1019564 completed BVALRENE 2020-07-17 16:11:05 UTC
Appeal 55460 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 653620 on_hold Bva 2020-01-30 13:10:50 UTC
├── DistributionTask 653621 completed Bva 2020-10-13 17:57:56 UTC
├── StatusInquiryMailTask 1008908 on_hold MailTeam 2020-07-13 12:25:02 UTC
│ └── StatusInquiryMailTask 1008909 on_hold VACOMCWILJ LitigationSupport 2020-07-19 19:22:03 UTC
│ └── StatusInquiryMailTask 1021416 assigned BVASGINSKI VACOJAGADL 2020-07-19 19:22:03 UTC
├── JudgeAssignTask 1194144 cancelled VACOSMARTD1 2020-10-13 18:17:09 UTC
└── JudgeAssignTask 1194224 on_hold VACOSMARTD1 BVAMPETERS 2020-10-19 15:10:01 UTC
└── TimedHoldTask 1203029 in_progress BVAMPETERS BVAMPETERS 2020-10-19 15:10:02 UTC
Appeal 4056 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 191544 on_hold Bva 2019-05-02 14:21:51 UTC
├── TrackVeteranTask 191545 in_progress FieldVso 2019-07-05 19:19:33 UTC
├── DistributionTask 191546 on_hold Bva 2019-07-05 19:19:33 UTC
│ └── HearingTask 191547 on_hold Bva 2019-05-02 14:21:51 UTC
│ └── ScheduleHearingTask 191548 assigned Bva 2019-05-02 14:21:51 UTC
└── StatusInquiryMailTask 981239 on_hold MailTeam 2020-06-26 21:31:57 UTC
└── StatusInquiryMailTask 981240 on_hold BVAKTANNER LitigationSupport 2020-07-19 19:22:03 UTC
└── StatusInquiryMailTask 1021415 assigned BVASGINSKI VACOJAGADL 2020-07-19 19:22:03 UTC
Appeal 19258 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 337407 on_hold Bva 2019-08-19 14:00:40 UTC
├── TrackVeteranTask 337409 in_progress Vso 2019-08-19 14:00:40 UTC
├── DistributionTask 337410 on_hold Bva 2019-08-19 14:00:40 UTC
│ ├── HearingTask 337411 cancelled Bva 2019-08-19 14:00:40 UTC
│ │ ├── ScheduleHearingTask 337412 completed Bva 2020-04-18 13:23:40 UTC
│ │ │ └── HearingAdminActionVerifyAddressTask 350595 cancelled HearingsManagement 2019-08-27 12:40:05 UTC
│ │ └── AssignHearingDispositionTask 837103 cancelled Bva 2020-04-18 13:23:40 UTC
│ └── HearingTask 1032979 on_hold Bva 2020-07-24 13:42:25 UTC
│ └── ScheduleHearingTask 1032980 assigned Bva 2020-07-24 13:42:25 UTC
└── StatusInquiryMailTask 981154 on_hold MailTeam 2020-06-26 20:26:15 UTC
└── StatusInquiryMailTask 981155 on_hold BVAKTANNER LitigationSupport 2020-07-19 19:22:03 UTC
└── StatusInquiryMailTask 1021414 assigned BVASGINSKI VACOJAGADL 2020-07-19 19:22:03 UTC
Appeal 52055 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 612165 on_hold Bva 2020-01-10 14:45:49 UTC
├── DistributionTask 612166 completed Bva 2020-10-14 20:11:50 UTC
├── StatusInquiryMailTask 977821 on_hold MailTeam 2020-06-25 18:17:57 UTC
│ └── StatusInquiryMailTask 977822 on_hold VACOMCWILJ LitigationSupport 2020-07-19 19:22:03 UTC
│ └── StatusInquiryMailTask 1021413 assigned BVASGINSKI VACOJAGADL 2020-07-19 19:22:03 UTC
└── JudgeAssignTask 1196823 assigned BVALBARNARD 2020-10-14 20:11:50 UTC
Appeal 34680 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 450166 completed Bva 2020-01-31 15:23:24 UTC
├── TrackVeteranTask 450167 completed Vso 2020-01-31 15:23:24 UTC
├── DistributionTask 450168 completed Bva 2020-01-17 03:10:27 UTC
│ └── InformalHearingPresentationTask 450169 completed Vso 2020-01-14 16:57:26 UTC
├── JudgeAssignTask 625987 completed BVALHOWELL 2020-01-27 13:22:51 UTC
├── JudgeDecisionReviewTask 641232 completed BVALHOWELL 2020-01-31 13:14:16 UTC
│ └── AttorneyTask 641233 completed BVALHOWELL BVAEREDMAN 2020-01-30 17:44:22 UTC
├── BvaDispatchTask 657493 completed BvaDispatch 2020-01-31 15:23:24 UTC
│ ├── BvaDispatchTask 657494 cancelled VACOYOUNGC2 2020-09-21 16:24:09 UTC
│ └── BvaDispatchTask 657863 completed BVANGRANT BVANGRANT 2020-01-31 15:23:24 UTC
└── ReconsiderationMotionMailTask 685041 on_hold MailTeam 2020-02-12 16:39:23 UTC
└── ReconsiderationMotionMailTask 685042 on_hold VACOTANGM LitigationSupport 2020-02-13 13:35:25 UTC
└── ReconsiderationMotionMailTask 687792 in_progress VACOTANGM VACOJAGADL 2020-07-15 17:33:30 UTC
ama_tasks.each do |task|
task.reassign(
{
assigned_to_type: User.name,
assigned_to_id: reassignee.id,
instructions: "Reassigning as VACOJAGADL is now inactive"
},
task.assigned_by
)
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 23184 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 366239 completed Bva 2020-07-17 16:11:06 UTC
├── TrackVeteranTask 366240 completed FieldVso 2020-07-17 16:11:06 UTC
├── DistributionTask 366241 completed Bva 2020-05-26 12:19:38 UTC
│ └── HearingTask 366242 completed Bva 2020-01-28 19:29:40 UTC
│ ├── ScheduleHearingTask 366243 completed Bva 2019-09-17 16:29:17 UTC
│ └── AssignHearingDispositionTask 414637 completed Bva 2020-01-28 19:29:40 UTC
│ ├── TranscriptionTask 542197 completed TranscriptionTeam 2020-01-27 15:24:48 UTC
│ └── EvidenceSubmissionWindowTask 542198 completed MailTeam 2020-01-28 19:29:40 UTC
├── JudgeAssignTask 913568 completed BVAASCIRE 2020-05-27 00:23:53 UTC
├── JudgeDecisionReviewTask 916183 completed BVAASCIRE BVAASCIRE 2020-07-17 14:39:49 UTC
│ └── AttorneyTask 916184 completed BVAASCIRE VACOTOLBEG 2020-06-30 19:57:56 UTC
│ ├── MissingRecordsColocatedTask 937048 completed VACOTOLBEG Colocated 2020-06-22 17:11:37 UTC
│ │ ├── MissingRecordsColocatedTask 937049 cancelled VACOTOLBEG VACOJENKIM12 2020-09-21 16:33:56 UTC
│ │ └── MissingRecordsColocatedTask 958324 completed VACOBOOKEK VACODRAYTM 2020-06-22 17:11:37 UTC
│ └── OtherColocatedTask 937050 completed VACOTOLBEG Colocated 2020-06-22 17:01:08 UTC
│ ├── OtherColocatedTask 937051 cancelled VACOTOLBEG VACOJENKIM12 2020-09-21 16:33:56 UTC
│ └── OtherColocatedTask 958327 completed VACOBOOKEK VACODRAYTM 2020-06-22 17:01:08 UTC
├── StatusInquiryMailTask 963723 on_hold MailTeam 2020-10-19 20:12:40 UTC
│ └── StatusInquiryMailTask 963724 on_hold VACOCHARLS LitigationSupport 2020-10-19 20:12:53 UTC
│ ├── StatusInquiryMailTask 968188 cancelled BVASGINSKI VACOJAGADL 2020-10-19 20:17:13 UTC
│ │ └── StatusInquiryMailTask 1015706 completed VACOJAGADL HearingsManagement 2020-08-25 16:28:04 UTC
│ │ └── StatusInquiryMailTask 1074592 completed VACOCARTER1 VACOWATSOM 2020-08-25 16:28:04 UTC
│ └── StatusInquiryMailTask 1204196 assigned BVASGINSKI VACOTANGM 2020-10-19 20:17:13 UTC
└── BvaDispatchTask 1019563 completed BvaDispatch 2020-07-17 16:11:06 UTC
└── BvaDispatchTask 1019564 completed BVALRENE 2020-07-17 16:11:05 UTC
Appeal 55460 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 653620 on_hold Bva 2020-01-30 13:10:50 UTC
├── DistributionTask 653621 completed Bva 2020-10-13 17:57:56 UTC
├── StatusInquiryMailTask 1008908 on_hold MailTeam 2020-07-13 12:25:02 UTC
│ └── StatusInquiryMailTask 1008909 on_hold VACOMCWILJ LitigationSupport 2020-07-19 19:22:03 UTC
│ ├── StatusInquiryMailTask 1021416 cancelled BVASGINSKI VACOJAGADL 2020-10-19 20:17:13 UTC
│ └── StatusInquiryMailTask 1204197 assigned BVASGINSKI VACOTANGM 2020-10-19 20:17:13 UTC
├── JudgeAssignTask 1194144 cancelled VACOSMARTD1 2020-10-13 18:17:09 UTC
└── JudgeAssignTask 1194224 on_hold VACOSMARTD1 BVAMPETERS 2020-10-19 15:10:01 UTC
└── TimedHoldTask 1203029 in_progress BVAMPETERS BVAMPETERS 2020-10-19 15:10:02 UTC
Appeal 4056 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 191544 on_hold Bva 2019-05-02 14:21:51 UTC
├── TrackVeteranTask 191545 in_progress FieldVso 2019-07-05 19:19:33 UTC
├── DistributionTask 191546 on_hold Bva 2019-07-05 19:19:33 UTC
│ └── HearingTask 191547 on_hold Bva 2019-05-02 14:21:51 UTC
│ └── ScheduleHearingTask 191548 assigned Bva 2019-05-02 14:21:51 UTC
└── StatusInquiryMailTask 981239 on_hold MailTeam 2020-06-26 21:31:57 UTC
└── StatusInquiryMailTask 981240 on_hold BVAKTANNER LitigationSupport 2020-07-19 19:22:03 UTC
├── StatusInquiryMailTask 1021415 cancelled BVASGINSKI VACOJAGADL 2020-10-19 20:17:13 UTC
└── StatusInquiryMailTask 1204198 assigned BVASGINSKI VACOTANGM 2020-10-19 20:17:13 UTC
Appeal 19258 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 337407 on_hold Bva 2019-08-19 14:00:40 UTC
├── TrackVeteranTask 337409 in_progress Vso 2019-08-19 14:00:40 UTC
├── DistributionTask 337410 on_hold Bva 2019-08-19 14:00:40 UTC
│ ├── HearingTask 337411 cancelled Bva 2019-08-19 14:00:40 UTC
│ │ ├── ScheduleHearingTask 337412 completed Bva 2020-04-18 13:23:40 UTC
│ │ │ └── HearingAdminActionVerifyAddressTask 350595 cancelled HearingsManagement 2019-08-27 12:40:05 UTC
│ │ └── AssignHearingDispositionTask 837103 cancelled Bva 2020-04-18 13:23:40 UTC
│ └── HearingTask 1032979 on_hold Bva 2020-07-24 13:42:25 UTC
│ └── ScheduleHearingTask 1032980 assigned Bva 2020-07-24 13:42:25 UTC
└── StatusInquiryMailTask 981154 on_hold MailTeam 2020-06-26 20:26:15 UTC
└── StatusInquiryMailTask 981155 on_hold BVAKTANNER LitigationSupport 2020-07-19 19:22:03 UTC
├── StatusInquiryMailTask 1021414 cancelled BVASGINSKI VACOJAGADL 2020-10-19 20:17:13 UTC
└── StatusInquiryMailTask 1204199 in_progress BVASGINSKI VACOTANGM 2020-10-20 12:33:20 UTC
Appeal 52055 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 612165 on_hold Bva 2020-01-10 14:45:49 UTC
├── DistributionTask 612166 completed Bva 2020-10-14 20:11:50 UTC
├── StatusInquiryMailTask 977821 on_hold MailTeam 2020-06-25 18:17:57 UTC
│ └── StatusInquiryMailTask 977822 on_hold VACOMCWILJ LitigationSupport 2020-07-19 19:22:03 UTC
│ ├── StatusInquiryMailTask 1021413 cancelled BVASGINSKI VACOJAGADL 2020-10-19 20:17:13 UTC
│ └── StatusInquiryMailTask 1204200 assigned BVASGINSKI VACOTANGM 2020-10-19 20:17:13 UTC
└── JudgeAssignTask 1196823 assigned BVALBARNARD 2020-10-14 20:11:50 UTC
Appeal 34680 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 450166 completed Bva 2020-01-31 15:23:24 UTC
├── TrackVeteranTask 450167 completed Vso 2020-01-31 15:23:24 UTC
├── DistributionTask 450168 completed Bva 2020-01-17 03:10:27 UTC
│ └── InformalHearingPresentationTask 450169 completed Vso 2020-01-14 16:57:26 UTC
├── JudgeAssignTask 625987 completed BVALHOWELL 2020-01-27 13:22:51 UTC
├── JudgeDecisionReviewTask 641232 completed BVALHOWELL 2020-01-31 13:14:16 UTC
│ └── AttorneyTask 641233 completed BVALHOWELL BVAEREDMAN 2020-01-30 17:44:22 UTC
├── BvaDispatchTask 657493 completed BvaDispatch 2020-01-31 15:23:24 UTC
│ ├── BvaDispatchTask 657494 cancelled VACOYOUNGC2 2020-09-21 16:24:09 UTC
│ └── BvaDispatchTask 657863 completed BVANGRANT BVANGRANT 2020-01-31 15:23:24 UTC
└── ReconsiderationMotionMailTask 685041 on_hold MailTeam 2020-02-12 16:39:23 UTC
└── ReconsiderationMotionMailTask 685042 on_hold VACOTANGM LitigationSupport 2020-02-13 13:35:25 UTC
├── ReconsiderationMotionMailTask 687792 cancelled VACOTANGM VACOJAGADL 2020-10-19 20:17:13 UTC
└── ReconsiderationMotionMailTask 1204201 in_progress VACOTANGM VACOTANGM 2020-10-19 20:17:13 UTCinactive_user = User.find_by(css_id: "VACODOURMM".upcase)
reassignee = User.find_by(css_id: "bvatcatino".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 0, 0]inactive_user = User.find_by(css_id: "VACOMCNEAN".upcase)
reassignee = User.find_by(css_id: "bvagrsenyk".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 0, 0]inactive_user = User.find_by(css_id: "VacoPayneA1".upcase)
reassignee = User.find_by(css_id: "bvaajaeger".upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 1, 0]
legacy_tasks.update_all(assigned_by_id: reassignee.id) |
|
inactive_css = "VACOGRAYT"
reassign_css = "VACOCarteR1"
inactive_user = User.find_by(css_id: inactive_css.upcase)
reassignee = User.find_by(css_id: reassign_css.upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 0, 0]
---
inactive_css = "VACOGRAYB"
reassign_css = "VACOCarteR1"
inactive_user = User.find_by(css_id: inactive_css.upcase)
reassignee = User.find_by(css_id: reassign_css.upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 0, 0]
---
inactive_css = "bvabtapia"
reassign_css = "VACOJonesK2" #VLJ·
inactive_user = User.find_by(css_id: inactive_css.upcase)
reassignee = User.find_by(css_id: reassign_css.upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [1, 0, 0]
puts ama_tasks.map(&:appeal).map(&:tree)
┌───────────────────────────────────────────────────────────────────────────┐
Appeal 10349 (direct_review) ────────────────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 261543 │ completed │ │ Bva │ 2020-03-05 13:16:44 UTC │
├── DistributionTask │ 261544 │ completed │ │ Bva │ 2019-12-12 15:26:07 UTC │
│ └── TranslationTask │ 261545 │ completed │ │ Translation │ 2019-12-12 13:57:01 UTC │
│ ├── TranslationTask │ 355143 │ cancelled │ VACOHUGHES2 │ VACOGRAYSS │ 2020-09-21 16:25:40 UTC │
│ └── TranslationTask │ 569859 │ completed │ VACOHUGHES2 │ VACOHUGHES2 │ 2019-12-12 13:57:01 UTC │
│ └── TimedHoldTask │ 470966 │ cancelled │ VACOGRAYSS │ VACOGRAYSS │ 2020-09-21 16:25:40 UTC │
├── AodMotionMailTask │ 353923 │ completed │ │ MailTeam │ 2019-09-11 12:44:37 UTC │
│ └── AodMotionMailTask │ 353924 │ completed │ BVAMJWRIGHT │ AodTeam │ 2019-09-11 12:44:37 UTC │
│ └── AodMotionMailTask │ 363863 │ completed │ BVACYEVANS │ BVACYEVANS │ 2019-09-11 12:44:37 UTC │
├── ReturnedUndeliverableCorrespondenceMailTask │ 557211 │ on_hold │ │ MailTeam │ 2019-12-06 14:05:05 UTC │
│ ├── ReturnedUndeliverableCorrespondenceMailTask │ 557212 │ cancelled │ BVAMJWRIGHT │ VACOGRAYSS │ 2020-09-21 16:27:12 UTC │
│ └── ReturnedUndeliverableCorrespondenceMailTask │ 1009262 │ assigned │ BVAIMBUTLER │ BVABTAPIA │ 2020-07-13 13:16:48 UTC │
├── JudgeAssignTask │ 570347 │ completed │ │ BVAURPOWELL │ 2019-12-20 16:27:05 UTC │
├── JudgeDecisionReviewTask │ 586879 │ completed │ │ BVAURPOWELL │ 2020-03-04 21:37:00 UTC │
│ └── AttorneyTask │ 586884 │ completed │ BVAURPOWELL │ VACOLEARYS │ 2020-01-13 14:55:23 UTC │
└── BvaDispatchTask │ 736105 │ completed │ │ BvaDispatch │ 2020-03-05 13:16:44 UTC │
└── BvaDispatchTask │ 736106 │ completed │ │ VACOPACED2 │ 2020-03-05 13:16:44 UTC │
└───────────────────────────────────────────────────────────────────────────┘
ama_tasks.each do |task|
task.reassign(
{
assigned_to_type: User.name,
assigned_to_id: reassignee.id,
instructions: "Reassigning as BVABTAPIA is now inactive"
},
task.assigned_by
)
end
Appeal.find(10349).treee
┌───────────────────────────────────────────────────────────────────────────┐
Appeal 10349 (direct_review) ────────────────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 261543 │ completed │ │ Bva │ 2020-03-05 13:16:44 UTC │
├── DistributionTask │ 261544 │ completed │ │ Bva │ 2019-12-12 15:26:07 UTC │
│ └── TranslationTask │ 261545 │ completed │ │ Translation │ 2019-12-12 13:57:01 UTC │
│ ├── TranslationTask │ 355143 │ cancelled │ VACOHUGHES2 │ VACOGRAYSS │ 2020-09-21 16:25:40 UTC │
│ └── TranslationTask │ 569859 │ completed │ VACOHUGHES2 │ VACOHUGHES2 │ 2019-12-12 13:57:01 UTC │
│ └── TimedHoldTask │ 470966 │ cancelled │ VACOGRAYSS │ VACOGRAYSS │ 2020-09-21 16:25:40 UTC │
├── AodMotionMailTask │ 353923 │ completed │ │ MailTeam │ 2019-09-11 12:44:37 UTC │
│ └── AodMotionMailTask │ 353924 │ completed │ BVAMJWRIGHT │ AodTeam │ 2019-09-11 12:44:37 UTC │
│ └── AodMotionMailTask │ 363863 │ completed │ BVACYEVANS │ BVACYEVANS │ 2019-09-11 12:44:37 UTC │
├── ReturnedUndeliverableCorrespondenceMailTask │ 557211 │ on_hold │ │ MailTeam │ 2019-12-06 14:05:05 UTC │
│ ├── ReturnedUndeliverableCorrespondenceMailTask │ 557212 │ cancelled │ BVAMJWRIGHT │ VACOGRAYSS │ 2020-09-21 16:27:12 UTC │
│ ├── ReturnedUndeliverableCorrespondenceMailTask │ 1009262 │ cancelled │ BVAIMBUTLER │ BVABTAPIA │ 2020-11-17 14:23:36 UTC │
│ └── ReturnedUndeliverableCorrespondenceMailTask │ 1254655 │ assigned │ BVAIMBUTLER │ VACOJONESK2 │ 2020-11-17 14:23:36 UTC │
├── JudgeAssignTask │ 570347 │ completed │ │ BVAURPOWELL │ 2019-12-20 16:27:05 UTC │
├── JudgeDecisionReviewTask │ 586879 │ completed │ │ BVAURPOWELL │ 2020-03-04 21:37:00 UTC │
│ └── AttorneyTask │ 586884 │ completed │ BVAURPOWELL │ VACOLEARYS │ 2020-01-13 14:55:23 UTC │
└── BvaDispatchTask │ 736105 │ completed │ │ BvaDispatch │ 2020-03-05 13:16:44 UTC │
└── BvaDispatchTask │ 736106 │ completed │ │ VACOPACED2 │ 2020-03-05 13:16:44 UTC │
└───────────────────────────────────────────────────────────────────────────┘
---
inactive_css = "vacomucklp"
reassign_css = "bvajzjones" #VLJ·
inactive_user = User.find_by(css_id: inactive_css.upcase)
reassignee = User.find_by(css_id: reassign_css.upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 2, 0]
legacy_tasks.update_all(assigned_by_id: reassignee.id)
=> 2
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name).count
=> 0
|
inactive_css = "vacomartic9"
reassign_css = "bvatkonya"
inactive_user = User.find_by(css_id: inactive_css.upcase)
reassignee = User.find_by(css_id: reassign_css.upcase)
ama_tasks = Task.open.where(assigned_to: inactive_user)
legacy_tasks = ColocatedTask.open.where(assigned_by: inactive_user, appeal_type: LegacyAppeal.name)
legacy_cases = VACOLS::Case.where(bfcurloc: inactive_user.vacols_user.slogid)
[ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [1, 0, 1]
puts ama_tasks.map(&:appeal).map(&:tree)
┌────────────────────────────────────────────────────────────────────────────┐
Appeal 12336 (direct_review) ────────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 285272 │ on_hold │ │ Bva │ 2019-07-22 14:43:58 UTC │
├── TrackVeteranTask │ 285273 │ in_progress │ │ Vso │ 2019-07-22 14:43:58 UTC │
├── DistributionTask │ 285274 │ completed │ │ Bva │ 2020-03-06 19:35:40 UTC │
│ └── InformalHearingPresentationTask │ 285275 │ completed │ │ Vso │ 2020-03-06 17:26:27 UTC │
│ └── InformalHearingPresentationTask │ 738673 │ completed │ BVACMADDOX │ VACOPLUMEM │ 2020-03-06 17:26:27 UTC │
├── JudgeAssignTask │ 742361 │ completed │ │ BVATKONYA │ 2020-03-11 16:18:36 UTC │
└── JudgeDecisionReviewTask │ 751025 │ on_hold │ │ BVATKONYA │ 2020-03-11 16:18:36 UTC │
└── AttorneyTask │ 751026 │ assigned │ BVATKONYA │ VACOMARTIC9 │ 2020-08-11 17:15:56 UTC │
└── IhpColocatedTask │ 876244 │ completed │ VACOMARTIC9 │ Colocated │ 2020-08-11 17:15:56 UTC │
└── IhpColocatedTask │ 876245 │ completed │ VACOMARTIC9 │ BVAMJKOROMA │ 2020-08-11 17:15:56 UTC │
└── TimedHoldTask │ 879466 │ completed │ BVAMJKOROMA │ BVAMJKOROMA │ 2020-08-09 18:30:31 UTC │
└────────────────────────────────────────────────────────────────────────────┘
task = ama_tasks.first
parent = task.send_back_to_judge_assign!.last
IhpColocatedTask.find(876244).update!(parent_id: parent)
task.appeal.reload.treee
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 12336 (direct_review) ────────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 285272 │ on_hold │ │ Bva │ 2019-07-22 14:43:58 UTC │
├── TrackVeteranTask │ 285273 │ in_progress │ │ Vso │ 2019-07-22 14:43:58 UTC │ ├── DistributionTask │ 285274 │ completed │ │ Bva │ 2020-03-06 19:35:40 UTC │ │ └── InformalHearingPresentationTask │ 285275 │ completed │ │ Vso │ 2020-03-06 17:26:27 UTC │ │ └── InformalHearingPresentationTask │ 738673 │ completed │ BVACMADDOX │ VACOPLUMEM │ 2020-03-06 17:26:27 UTC │ ├── JudgeAssignTask │ 742361 │ completed │ │ BVATKONYA │ 2020-03-11 16:18:36 UTC │
├── JudgeDecisionReviewTask │ 751025 │ cancelled │ │ BVATKONYA │ 2020-11-17 20:39:11 UTC │
│ └── AttorneyTask │ 751026 │ assigned │ BVATKONYA │ VACOMARTIC9 │ 2020-08-11 17:15:56 UTC │
└── JudgeAssignTask │ 1257434 │ assigned │ │ BVATKONYA │ 2020-11-17 20:39:11 UTC │
└── IhpColocatedTask │ 876244 │ completed │ VACOMARTIC9 │ Colocated │ 2020-11-17 20:40:20 UTC │
└── IhpColocatedTask │ 876245 │ completed │ VACOMARTIC9 │ BVAMJKOROMA │ 2020-08-11 17:15:56 UTC │
└── TimedHoldTask │ 879466 │ completed │ BVAMJKOROMA │ BVAMJKOROMA │ 2020-08-09 18:30:31 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
legacy_cases.each { |case_record| case_record.update_vacols_location!(reassignee.vacols_user.slogid) }
AttorneyTask.find(751026).update_column(:status, "cancelled")
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 12336 (direct_review) ────────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 285272 │ on_hold │ │ Bva │ 2019-07-22 14:43:58 UTC │
├── TrackVeteranTask │ 285273 │ in_progress │ │ Vso │ 2019-07-22 14:43:58 UTC │
├── DistributionTask │ 285274 │ completed │ │ Bva │ 2020-03-06 19:35:40 UTC │
│ └── InformalHearingPresentationTask │ 285275 │ completed │ │ Vso │ 2020-03-06 17:26:27 UTC │
│ └── InformalHearingPresentationTask │ 738673 │ completed │ BVACMADDOX │ VACOPLUMEM │ 2020-03-06 17:26:27 UTC │
├── JudgeAssignTask │ 742361 │ completed │ │ BVATKONYA │ 2020-03-11 16:18:36 UTC │
├── JudgeDecisionReviewTask │ 751025 │ cancelled │ │ BVATKONYA │ 2020-11-17 20:39:11 UTC │
│ └── AttorneyTask │ 751026 │ cancelled │ BVATKONYA │ VACOMARTIC9 │ 2020-08-11 17:15:56 UTC │
└── JudgeAssignTask │ 1257434 │ assigned │ │ BVATKONYA │ 2020-11-17 20:39:11 UTC │
└── IhpColocatedTask │ 876244 │ completed │ VACOMARTIC9 │ Colocated │ 2020-11-17 20:40:20 UTC │
└── IhpColocatedTask │ 876245 │ completed │ VACOMARTIC9 │ BVAMJKOROMA │ 2020-08-11 17:15:56 UTC │
└── TimedHoldTask │ 879466 │ completed │ BVAMJKOROMA │ BVAMJKOROMA │ 2020-08-09 18:30:31 UTC │
└─────────────────────────────────────────────────────────────────────────────┘ |
|
|
|
|
my template: INACTIVEUSERc/p row css_id = ""
judge_css_id = ""
# more advanced (just copy and paste from table row): e.g.,
# css_id, separator, judge_css_id = %w[ Vacohighla | bvajwills ]
user = User.find_by_css_id(css_id.upcase)
judge = User.find_by_css_id(judge_css_id.upcase)
pp user.organizations
pp judge.organizations
ama_tasks = Task.open.where(assigned_to: user);
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name);
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid);
pp [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
Task.open.where(assigned_by: user).countamaama_tasks.pluck(:id)
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree);
# HANDLE EACH ONE
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree);legacy taskslegacy_tasks.pluck(:id)
=>
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0legacy caseslegacy_cases.count
=>
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) } |
|
Automating def check_users(*args)
css_id, judge_css_id = args.first, args.last
user = User.find_by_css_id(css_id.upcase)
judge = User.find_by_css_id(judge_css_id.upcase)
ama_tasks = Task.open.where(assigned_to: user);
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name);
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid);
pp user.organizations
pp judge.organizations
pp [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
assigned_by_tasks = Task.open.where(assigned_by: user)
[user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks]
end
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ VACOJANOFR | bvamlkane ]Then, manually fix each using Kat's template above. |
┌───────────────────────────────────────────────────────────────────────────────┐
Appeal 69064 (D 200313-69064 Original) ──────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 840143 │ on_hold │ │ Bva │ 2020-04-20 18:45:56 UTC │
├── TrackVeteranTask │ 840144 │ in_progress │ │ FieldVso │ 2020-04-20 18:45:56 UTC │
├── DistributionTask │ 840145 │ completed │ │ Bva │ 2021-01-05 13:49:53 UTC │
├── JudgeAssignTask │ 1358261 │ completed │ │ BVAMLKANE │ 2021-01-14 21:20:59 UTC │
└── JudgeDecisionReviewTask │ 1388218 │ on_hold │ BVAMLKANE │ BVAMLKANE │ 2021-01-14 21:20:59 UTC │
└── AttorneyTask │ 1388219 │ on_hold │ BVAMLKANE │ VACOJANOFR │ 2021-01-19 20:26:02 UTC │
└── MissingRecordsColocatedTask │ 1398428 │ on_hold │ VACOJANOFR │ Colocated │ 2021-01-19 20:26:02 UTC │
└── MissingRecordsColocatedTask │ 1398429 │ on_hold │ VACOJANOFR │ BVAANJOHNSON │ 2021-02-05 15:05:49 UTC │
└── TimedHoldTask │ 1445623 │ in_progress │ BVAANJOHNSON │ BVAANJOHNSON │ 2021-02-05 15:05:51 UTC │
└───────────────────────────────────────────────────────────────────────────────┘
task = ama_tasks.first
task.send_back_to_judge_assign!
Task.find(1398428).update!(parent_id: 1597349)
task.appeal.reload.treee
┌───────────────────────────────────────────────────────────────────────────────┐
Appeal 69064 (D 200313-69064 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 840143 │ on_hold │ │ Bva │ 2020-04-20 18:45:56 UTC │
├── TrackVeteranTask │ 840144 │ in_progress │ │ FieldVso │ 2020-04-20 18:45:56 UTC │
├── DistributionTask │ 840145 │ completed │ │ Bva │ 2021-01-05 13:49:53 UTC │
├── JudgeAssignTask │ 1358261 │ completed │ │ BVAMLKANE │ 2021-01-14 21:20:59 UTC │
├── JudgeDecisionReviewTask │ 1388218 │ cancelled │ BVAMLKANE │ BVAMLKANE │ 2021-03-29 20:42:31 UTC │
│ └── AttorneyTask │ 1388219 │ cancelled │ BVAMLKANE │ VACOJANOFR │ 2021-03-29 20:42:31 UTC │
└── JudgeAssignTask │ 1597349 │ assigned │ │ BVAMLKANE │ 2021-03-29 20:42:31 UTC │
└── MissingRecordsColocatedTask │ 1398428 │ on_hold │ VACOJANOFR │ Colocated │ 2021-03-29 20:43:51 UTC │
└── MissingRecordsColocatedTask │ 1398429 │ on_hold │ VACOJANOFR │ BVAANJOHNSON │ 2021-02-05 15:05:49 UTC │
└── TimedHoldTask │ 1445623 │ in_progress │ BVAANJOHNSON │ BVAANJOHNSON │ 2021-02-05 15:05:51 UTC │
└───────────────────────────────────────────────────────────────────────────────┘
aby_tasks=Task.open.where(assigned_by: user)
aby_tasks.each{|t| t.update(assigned_by: judge)}
task = ama_tasks.second
┌──────────────────────────────────────────────────────────────────────────┐
Appeal 73140 (D 200306-73140 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 877349 │ on_hold │ │ Bva │ 2020-05-05 21:00:21 UTC │
├── DistributionTask │ 877350 │ completed │ │ Bva │ 2020-12-29 13:05:31 UTC │
├── JudgeAssignTask │ 1345026 │ completed │ │ BVAJTAYLOR │ 2021-01-11 21:24:07 UTC │
└── JudgeDecisionReviewTask │ 1376555 │ on_hold │ BVAJTAYLOR │ BVAJTAYLOR │ 2021-01-11 21:24:07 UTC │
└── AttorneyTask │ 1376556 │ on_hold │ BVAJTAYLOR │ VACOJANOFR │ 2021-01-11 21:46:37 UTC │
└── FoiaColocatedTask │ 1376634 │ on_hold │ VACOJANOFR │ PrivacyTeam │ 2021-01-11 21:46:37 UTC │
└── FoiaTask │ 1376635 │ on_hold │ VACOJANOFR │ PrivacyTeam │ 2021-01-15 19:24:16 UTC │
└── FoiaTask │ 1391178 │ assigned │ BVAJRETAN │ BVATPLOWDEN │ 2021-01-15 19:24:16 UTC │
└──────────────────────────────────────────────────────────────────────────┘
task.send_back_to_judge_assign!
Task.find(1376634).update!(parent_id: 1597373)
task.appeal.reload.treee
┌──────────────────────────────────────────────────────────────────────────┐
Appeal 73140 (D 200306-73140 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 877349 │ on_hold │ │ Bva │ 2020-05-05 21:00:21 UTC │
├── DistributionTask │ 877350 │ completed │ │ Bva │ 2020-12-29 13:05:31 UTC │
├── JudgeAssignTask │ 1345026 │ completed │ │ BVAJTAYLOR │ 2021-01-11 21:24:07 UTC │
├── JudgeDecisionReviewTask │ 1376555 │ cancelled │ BVAJTAYLOR │ BVAJTAYLOR │ 2021-03-29 20:50:28 UTC │
│ └── AttorneyTask │ 1376556 │ cancelled │ BVAJTAYLOR │ VACOJANOFR │ 2021-03-29 20:50:28 UTC │
└── JudgeAssignTask │ 1597373 │ assigned │ │ BVAJTAYLOR │ 2021-03-29 20:50:28 UTC │
└── FoiaColocatedTask │ 1376634 │ on_hold │ BVAMLKANE │ PrivacyTeam │ 2021-03-29 20:51:46 UTC │
└── FoiaTask │ 1376635 │ on_hold │ BVAMLKANE │ PrivacyTeam │ 2021-03-29 20:48:58 UTC │
└── FoiaTask │ 1391178 │ assigned │ BVAJRETAN │ BVATPLOWDEN │ 2021-01-15 19:24:16 UTC │
└──────────────────────────────────────────────────────────────────────────┘user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ BVAAHAMPTON | bvaascire ]
task = ama_tasks.first
task.appeal.reload.treee
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 18775 (E 190808-18775 Original) ─ │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 333415 │ on_hold │ │ Bva │ 2019-08-15 15:53:18 UTC │
├── DistributionTask │ 333416 │ completed │ │ Bva │ 2020-05-06 16:19:07 UTC │
│ └── EvidenceSubmissionWindowTask │ 333417 │ completed │ │ MailTeam │ 2019-11-06 00:30:15 UTC │
├── JudgeAssignTask │ 879185 │ completed │ │ BVAMHAWLEY │ 2020-05-07 19:59:38 UTC │
└── JudgeDecisionReviewTask │ 883954 │ on_hold │ BVAMHAWLEY │ BVAMHAWLEY │ 2020-05-07 19:59:38 UTC │
└── AttorneyTask │ 883955 │ on_hold │ BVAMHAWLEY │ BVAAHAMPTON │ 2020-05-21 20:22:48 UTC │
└── FoiaColocatedTask │ 910522 │ on_hold │ BVAAHAMPTON │ PrivacyTeam │ 2020-05-21 20:22:48 UTC │
└── FoiaTask │ 910523 │ on_hold │ BVAAHAMPTON │ PrivacyTeam │ 2020-10-12 14:08:14 UTC │
├── FoiaTask │ 1192608 │ cancelled │ BVAJRETAN │ VACODOUGLN │ 2020-12-16 19:48:04 UTC │
├── FoiaTask │ 1319616 │ cancelled │ BVAJRETAN │ BVAJRETAN │ 2020-12-16 19:49:40 UTC │
└── FoiaTask │ 1319625 │ in_progress │ BVAJRETAN │ VACODOUGLN │ 2020-12-16 19:49:40 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
task.send_back_to_judge_assign!
Caseflow::Error::InvalidAssigneeStatusOnTaskCreate: MILO HAWLEY is marked as inactive in Caseflow. Please select another user assignee or contact support if you believeyou're getting this message in error.Pulling in : new_task=Task.find(883954).dup
new_task.assigned_by = judge;
new_task.assigned_to=judge;
new_task.status=:assigned
new_task.save!
Task.find(883955).update(parent_id: 1597445)
Task.find(883954).cancelled!
new_task.update(status: :on_hold)
task.update(assigned_by: judge)
task.reload.send_back_to_judge_assign!
Task.find(910522).update!(parent_id: 1597456)
Task.find(1597456).on_hold!
task.appeal.reload.treee
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 18775 (E 190808-18775 Original) ─ │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 333415 │ on_hold │ │ Bva │ 2019-08-15 15:53:18 UTC │
├── DistributionTask │ 333416 │ completed │ │ Bva │ 2020-05-06 16:19:07 UTC │
│ └── EvidenceSubmissionWindowTask │ 333417 │ completed │ │ MailTeam │ 2019-11-06 00:30:15 UTC │
├── JudgeAssignTask │ 879185 │ completed │ │ BVAMHAWLEY │ 2020-05-07 19:59:38 UTC │
├── JudgeDecisionReviewTask │ 883954 │ cancelled │ BVAMHAWLEY │ BVAMHAWLEY │ 2021-03-29 21:16:55 UTC │
├── JudgeDecisionReviewTask │ 1597445 │ cancelled │ BVAASPECTOR │ BVAASPECTOR │ 2021-03-29 21:18:19 UTC │
│ └── AttorneyTask │ 883955 │ cancelled │ BVAASPECTOR │ BVAAHAMPTON │ 2021-03-29 21:18:19 UTC │
└── JudgeAssignTask │ 1597456 │ on_hold │ │ BVAASPECTOR │ 2021-03-29 21:20:07 UTC │
└── FoiaColocatedTask │ 910522 │ on_hold │ BVAAHAMPTON │ PrivacyTeam │ 2021-03-29 21:19:22 UTC │
└── FoiaTask │ 910523 │ on_hold │ BVAAHAMPTON │ PrivacyTeam │ 2020-10-12 14:08:14 UTC │
├── FoiaTask │ 1192608 │ cancelled │ BVAJRETAN │ VACODOUGLN │ 2020-12-16 19:48:04 UTC │
├── FoiaTask │ 1319616 │ cancelled │ BVAJRETAN │ BVAJRETAN │ 2020-12-16 19:49:40 UTC │
└── FoiaTask │ 1319625 │ in_progress │ BVAJRETAN │ VACODOUGLN │ 2020-12-16 19:49:40 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
# Back to fixing BVAAHAMPTON
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ BVAAHAMPTON | bvaascire ]
┌───────────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 1042626 (L 1531434 Post Remand) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
├── RootTask │ 603205 │ assigned │ │ Bva │ 2020-01-06 18:39:00 UTC │
├── ExtensionColocatedTask │ 603211 │ completed │ BVAAHAMPTON │ Colocated │ 2020-06-12 15:22:08 UTC │
│ └── ExtensionColocatedTask │ 603212 │ completed │ BVAAHAMPTON │ BVAPBROWNING │ 2020-06-12 15:22:08 UTC │
│ └── TimedHoldTask │ 719604 │ completed │ BVAPBROWNING │ BVAPBROWNING │ 2020-05-27 18:30:31 UTC │
└── ExtensionColocatedTask │ 990597 │ on_hold │ BVAAHAMPTON │ Colocated │ 2020-07-01 12:59:48 UTC │
└── ExtensionColocatedTask │ 990598 │ on_hold │ BVAAHAMPTON │ BVAANJOHNSON │ 2020-12-08 22:05:34 UTC │
├── TimedHoldTask │ 1051848 │ completed │ BVAANJOHNSON │ BVAANJOHNSON │ 2020-11-25 17:30:31 UTC │
└── TimedHoldTask │ 1296331 │ in_progress │ BVAANJOHNSON │ BVAANJOHNSON │ 2020-12-08 22:05:35 UTC │
└───────────────────────────────────────────────────────────────────────────────┘
legacy_tasks.update_all(assigned_by_id: judge.id)
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ BVAAHAMPTON | bvaascire ]
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 18775 (E 190808-18775 Original) ─ │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 333415 │ on_hold │ │ Bva │ 2019-08-15 15:53:18 UTC │
├── DistributionTask │ 333416 │ completed │ │ Bva │ 2020-05-06 16:19:07 UTC │
│ └── EvidenceSubmissionWindowTask │ 333417 │ completed │ │ MailTeam │ 2019-11-06 00:30:15 UTC │
├── JudgeAssignTask │ 879185 │ completed │ │ BVAMHAWLEY │ 2020-05-07 19:59:38 UTC │
├── JudgeDecisionReviewTask │ 883954 │ cancelled │ BVAMHAWLEY │ BVAMHAWLEY │ 2021-03-29 21:16:55 UTC │
├── JudgeDecisionReviewTask │ 1597445 │ cancelled │ BVAASPECTOR │ BVAASPECTOR │ 2021-03-29 21:18:19 UTC │
│ └── AttorneyTask │ 883955 │ cancelled │ BVAASPECTOR │ BVAAHAMPTON │ 2021-03-29 21:18:19 UTC │
└── JudgeAssignTask │ 1597456 │ on_hold │ │ BVAASPECTOR │ 2021-03-29 21:20:07 UTC │
└── FoiaColocatedTask │ 910522 │ on_hold │ BVAAHAMPTON │ PrivacyTeam │ 2021-03-29 21:19:22 UTC │
└── FoiaTask │ 910523 │ on_hold │ BVAAHAMPTON │ PrivacyTeam │ 2020-10-12 14:08:14 UTC │
├── FoiaTask │ 1192608 │ cancelled │ BVAJRETAN │ VACODOUGLN │ 2020-12-16 19:48:04 UTC │
├── FoiaTask │ 1319616 │ cancelled │ BVAJRETAN │ BVAJRETAN │ 2020-12-16 19:49:40 UTC │
└── FoiaTask │ 1319625 │ in_progress │ BVAJRETAN │ VACODOUGLN │ 2020-12-16 19:49:40 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
assigned_by_tasks.update_all(assigned_by_id: judge.id)
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 18775 (E 190808-18775 Original) ─ │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 333415 │ on_hold │ │ Bva │ 2019-08-15 15:53:18 UTC │
├── DistributionTask │ 333416 │ completed │ │ Bva │ 2020-05-06 16:19:07 UTC │
│ └── EvidenceSubmissionWindowTask │ 333417 │ completed │ │ MailTeam │ 2019-11-06 00:30:15 UTC │
├── JudgeAssignTask │ 879185 │ completed │ │ BVAMHAWLEY │ 2020-05-07 19:59:38 UTC │
├── JudgeDecisionReviewTask │ 883954 │ cancelled │ BVAMHAWLEY │ BVAMHAWLEY │ 2021-03-29 21:16:55 UTC │
├── JudgeDecisionReviewTask │ 1597445 │ cancelled │ BVAASPECTOR │ BVAASPECTOR │ 2021-03-29 21:18:19 UTC │
│ └── AttorneyTask │ 883955 │ cancelled │ BVAASPECTOR │ BVAAHAMPTON │ 2021-03-29 21:18:19 UTC │
└── JudgeAssignTask │ 1597456 │ on_hold │ │ BVAASPECTOR │ 2021-03-29 21:20:07 UTC │
└── FoiaColocatedTask │ 910522 │ on_hold │ BVAASCIRE │ PrivacyTeam │ 2021-03-29 21:19:22 UTC │
└── FoiaTask │ 910523 │ on_hold │ BVAASCIRE │ PrivacyTeam │ 2020-10-12 14:08:14 UTC │
├── FoiaTask │ 1192608 │ cancelled │ BVAJRETAN │ VACODOUGLN │ 2020-12-16 19:48:04 UTC │
├── FoiaTask │ 1319616 │ cancelled │ BVAJRETAN │ BVAJRETAN │ 2020-12-16 19:49:40 UTC │
└── FoiaTask │ 1319625 │ in_progress │ BVAJRETAN │ VACODOUGLN │ 2020-12-16 19:49:40 UTC │
└─────────────────────────────────────────────────────────────────────────────┘user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ BVAMHAWLEY | BVAASPECTOR ]
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 54119 (D 200114-54119 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 634264 │ on_hold │ │ Bva │ 2020-01-22 18:47:40 UTC │
├── DistributionTask │ 634265 │ completed │ │ Bva │ 2020-11-05 13:38:38 UTC │
│ └── TranslationTask │ 634266 │ completed │ │ Translation │ 2020-10-22 13:24:33 UTC │
│ ├── TranslationTask │ 670271 │ cancelled │ VACOBENTOS1 │ VACOKIMA20 │ 2020-10-22 13:24:02 UTC │
│ │ └── TimedHoldTask │ 806106 │ completed │ VACOKIMA20 │ VACOKIMA20 │ 2020-08-02 20:30:31 UTC │
│ └── TranslationTask │ 1210446 │ completed │ VACOBENTOS1 │ VACOBENTOS1 │ 2020-10-22 13:24:33 UTC │
├── JudgeAssignTask │ 1237105 │ completed │ │ BVAMHAWLEY │ 2020-11-05 15:19:29 UTC │
└── JudgeDecisionReviewTask │ 1237380 │ on_hold │ BVAMHAWLEY │ BVAMHAWLEY │ 2020-11-05 15:19:29 UTC │
└── AttorneyTask │ 1237381 │ on_hold │ BVAMHAWLEY │ BVABWILLIAMS │ 2020-12-28 15:50:29 UTC │
└── FoiaColocatedTask │ 1342852 │ on_hold │ BVABWILLIAMS │ PrivacyTeam │ 2020-12-28 15:50:29 UTC │
└── FoiaTask │ 1342853 │ on_hold │ BVABWILLIAMS │ PrivacyTeam │ 2020-12-30 19:03:50 UTC │
└── FoiaTask │ 1350095 │ assigned │ BVAJRETAN │ VACODAVISD8 │ 2020-12-30 19:03:50 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
task = ama_tasks.first
new_task=Task.find(1237380).dup
new_task.assigned_by = judge;
new_task.assigned_to=judge;
new_task.status=:assigned
new_task.save!
Task.find(1237381).update(parent_id: new_task.id)
Task.find(1237380).cancelled!
new_task.on_hold!
Task.find(1237381).update(assigned_by: judge)
task.appeal.reload.treee
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 54119 (D 200114-54119 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 634264 │ on_hold │ │ Bva │ 2020-01-22 18:47:40 UTC │
├── DistributionTask │ 634265 │ completed │ │ Bva │ 2020-11-05 13:38:38 UTC │
│ └── TranslationTask │ 634266 │ completed │ │ Translation │ 2020-10-22 13:24:33 UTC │
│ ├── TranslationTask │ 670271 │ cancelled │ VACOBENTOS1 │ VACOKIMA20 │ 2020-10-22 13:24:02 UTC │
│ │ └── TimedHoldTask │ 806106 │ completed │ VACOKIMA20 │ VACOKIMA20 │ 2020-08-02 20:30:31 UTC │
│ └── TranslationTask │ 1210446 │ completed │ VACOBENTOS1 │ VACOBENTOS1 │ 2020-10-22 13:24:33 UTC │
├── JudgeAssignTask │ 1237105 │ completed │ │ BVAMHAWLEY │ 2020-11-05 15:19:29 UTC │
├── JudgeDecisionReviewTask │ 1237380 │ cancelled │ BVAMHAWLEY │ BVAMHAWLEY │ 2021-03-29 21:32:20 UTC │
└── JudgeDecisionReviewTask │ 1597498 │ on_hold │ BVAASPECTOR │ BVAASPECTOR │ 2021-03-29 21:30:50 UTC │
└── AttorneyTask │ 1237381 │ on_hold │ BVAASPECTOR │ BVABWILLIAMS │ 2021-03-29 21:31:55 UTC │
└── FoiaColocatedTask │ 1342852 │ on_hold │ BVABWILLIAMS │ PrivacyTeam │ 2020-12-28 15:50:29 UTC │
└── FoiaTask │ 1342853 │ on_hold │ BVABWILLIAMS │ PrivacyTeam │ 2020-12-30 19:03:50 UTC │
└── FoiaTask │ 1350095 │ assigned │ BVAJRETAN │ VACODAVISD8 │ 2020-12-30 19:03:50 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ BVAMHAWLEY | BVAASPECTOR ]Nextuser, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Vacoescota | bvajwhite]
legacy_cases.pluck(:bfkey)
=> ["4004504"]
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) }
# Check again:
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Vacoescota | bvajwhite] |
Other Inactive User Needs
u = User.find_by_css_id(...)
[Task.open.where(assigned_by: u).count, Task.open.where(assigned_to: u).count]
=> [0, 0]
u.update(status: :inactive)
u.organizations
=> [] |
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Bvaurpowell | VLJ vacosmartd1 ]
Task.find(1146855).update(assigned_by: judge)
Task.find(1146856).update(assigned_by: judge)
Task.find(1144903).update(assigned_to: judge)
Task.find(1115370).update(assigned_to: judge, assigned_by: judge)
Task.find(1115371).update(assigned_by: judge)
Task.find(1036253).update(assigned_to: judge, assigned_by: judge)
Task.find(1036254).update(assigned_by: judge)
Task.find(1020361).update(assigned_to: judge, assigned_by: judge)
Task.find(1020362).update(assigned_by: judge)
Task.find(1000376).update(assigned_to: judge, assigned_by: judge)
Task.find(1107008).update(assigned_to: judge, assigned_by: judge)
Task.find(1107009).update(assigned_by: judge)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Vacosmithm20 | VLJ bvavmoshi ]
task.id
=> 1020362
Task.find(1057764).update(parent_id: 1600489)
Task.find(1020362).cancelled! # because judge BVAVMOSHI is not an attorney and cannot be assigned the AttoryneyTask
┌──────────────────────────────────────────────────────────────────────────────┐
Appeal 46737 (D 191130-46737 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 561301 │ on_hold │ │ Bva │ 2019-12-09 15:44:46 UTC │
├── TrackVeteranTask │ 561302 │ in_progress │ │ Vso │ 2019-12-09 15:44:46 UTC │
├── DistributionTask │ 561303 │ completed │ │ Bva │ 2020-07-10 21:07:14 UTC │
│ └── InformalHearingPresentationTask │ 561304 │ completed │ │ Vso │ 2020-05-26 18:52:54 UTC │
├── JudgeAssignTask │ 1007155 │ completed │ │ BVAURPOWELL │ 2020-07-17 18:59:45 UTC │
├── JudgeDecisionReviewTask │ 1020361 │ cancelled │ VACOSMARTD1 │ VACOSMARTD1 │ 2021-03-30 18:38:57 UTC │
└── JudgeDecisionReviewTask │ 1600489 │ on_hold │ │ VACOSMARTD1 │ 2021-03-30 18:50:52 UTC │
├── AttorneyTask │ 1020362 │ cancelled │ VACOSMARTD1 │ VACOSMITHM20 │ 2021-03-30 18:50:52 UTC │
└── FoiaColocatedTask │ 1057764 │ on_hold │ BVAVMOSHI │ PrivacyTeam │ 2021-03-30 18:50:23 UTC │
└── FoiaTask │ 1057765 │ on_hold │ BVAVMOSHI │ PrivacyTeam │ 2021-03-30 18:44:33 UTC │
└── FoiaTask │ 1339968 │ assigned │ BVAJRETAN │ BVATPLOWDEN │ 2020-12-24 04:15:50 UTC │
└──────────────────────────────────────────────────────────────────────────────┘user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ vacoduncan | bvamcgraham ]
ama_tasks.each do |atty_task|
ActiveRecord::Base.transaction do
judge_assign_task = JudgeAssignTask.create!(appeal: atty_task.appeal, parent: atty_task.appeal.root_task, assigned_to: judge, status: Constants.TASK_STATUSES.assigned)
atty_task.children.open.each { |child| child.update!(parent: judge_assign_task) }
atty_task.parent.cancel_task_and_child_subtasks
cancellation_instuctions = "This task has been cancelled due to the reassignment of all tasks previously assigned to #{user.css_id}."
atty_task.update_with_instructions(instructions: cancellation_instuctions)
atty_task.parent.update_with_instructions(instructions: cancellation_instuctions)
judge_assign_task.update_with_instructions(instructions: "This task has been assigned due to the reassignment of all tasks previously assigned to #{user.css_id}.")
judge_assign_task.update(status: :on_hold)
end
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Vacosmithr6 | bvactrueba ]
legacy_tasks.pluck(:id)
=> [680746]
legacy_tasks.update_all(assigned_by_id: judge.id)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Vacokuhnt | VLJ bvaMLane ]
legacy_tasks.pluck(:id)
=> [880258]
legacy_tasks.update_all(assigned_by_id: judge.id)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ VACORichaS | VLJ bvaaIshiz ]
legacy_tasks.pluck(:id)
=> [938154, 1437124, 1189305, 1437125]
legacy_tasks.update_all(assigned_by_id: judge.id)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ VACOChrisD | bvamkilcoyn ]
legacy_tasks.pluck(:id)
=> [1076416, 1354036, 1400929, 1400930]
legacy_tasks.update_all(assigned_by_id: judge.id)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ BVAPeluyJ | BVAJBKRAMER ]
legacy_tasks.pluck(:id)
=> [1149448, 1450789, 1450790]
legacy_tasks.update_all(assigned_by_id: judge.id)
ama_tasks.each do |atty_task|
ActiveRecord::Base.transaction do
judge_assign_task = JudgeAssignTask.create!(appeal: atty_task.appeal, parent: atty_task.appeal.root_task, assigned_to: judge, status: Constants.TASK_STATUSES.assigned)
atty_task.children.open.each { |child| child.update!(parent: judge_assign_task) }
atty_task.parent.cancel_task_and_child_subtasks
cancellation_instuctions = "This task has been cancelled due to the reassignment of all tasks previously assigned to #{user.css_id}."
atty_task.update_with_instructions(instructions: cancellation_instuctions)
atty_task.parent.update_with_instructions(instructions: cancellation_instuctions)
judge_assign_task.update_with_instructions(instructions: "This task has been assigned due to the reassignment of all tasks previously assigned to #{user.css_id}.")
judge_assign_task.update(status: :on_hold)
end
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ vacoSpannB | bvatoshay ]
legacy_tasks.pluck(:id)
=> [905740, 1365877, 1365876]
legacy_tasks.update_all(assigned_by_id: judge.id)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ vacopitmad | bvamhyland ]
legacy_tasks.pluck(:id)
=> [1503713, 1153347, 768957, 642068, 1503712, 768958]
legacy_tasks.update_all(assigned_by_id: judge.id)
legacy_cases.pluck(:bfkey)
=> ["4050152", "4073698", "4064765"]
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid)user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Bvajmonroe | bvaRScharnb ]
ama_tasks.pluck :id
=> [836194]
ama_tasks.each do |atty_task|
...
end
Task.find(1600829).assigned!user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Bvadwsingle | bvaRScharnb ]
ama_tasks.pluck :id
=> [1173023, 1156055, 1131920]
ama_tasks.each do |atty_task|
...
end
Task.find(1339945).update_column(:status, :assigned)
Task.find(1206415).update_column(:status, :on_hold)
Task.find(1206414).update_column(:status, :on_hold)
Task.find(1173024).update_column(:status, :on_hold)
Task.find(1156056).update_column(:status, :on_hold)
Task.find(1184996).update_column(:status, :on_hold)
Task.find(1184997).update_column(:status, :on_hold)
Task.find(1339938).update_column(:status, :assigned)
Task.find(1115430).update_column(:status, :on_hold)
Task.find(1115430).update_column(:status, :completed)
Task.find(1131921).update_column(:status, :on_hold)
Task.find(1224061).update_column(:status, :on_hold)
Task.find(1224062).update_column(:status, :assigned)
Task.find(1174378).update_column(:status, :in_progress)
Task.find(540654).update_column(:status, :in_progress) |
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Bvahabeach | bvacaskow ]
legacy_tasks
=> [0, 1, 1]
legacy_tasks.pluck(:id)
=> [728805]
legacy_cases.pluck :bfkey
=> ["4059330"]user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ Vacomclens | bvavclement ]
=> [0, 2, 1]
legacy_tasks.pluck(:id)
=> [957182, 912091]
legacy_cases.pluck :bfkey
=> ["3901103"] |
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ VACOrichae | bvaveleze ]
[1, 1, 1]User has an AMA task. Skipping for now to knock out some of the simpler ones. Now we're talking! user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ VACOHillaC | bvakbconner ]
# [0, 10, 0]
legacy_tasks.pluck(:id)
=> [1283405, 1340790, 1294542, 1469155, 1450589, 1340791, 1470277, 1469154, 1470276, 1294543]
legacy_tasks.update_all(assigned_by_id: judge.id)
=> 10
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ VACOHillaC | bvakbconner ]
# [0, 0, 0] |
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ vacohamilc1 | VLJ bvatoshay ]
# [0, 2, 0]
legacy_tasks.pluck(:id)
=> [1480339, 1480340]
legacy_tasks.update_all(assigned_by_id: judge.id)
=> 2
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0 |
|
VACOrichae | bvaveleze user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[ VACOrichae | bvaveleze ]
=> [1, 0, 2]
ama_tasks.pluck(:id)
=> [1381992]
legacy_cases.pluck(:bfkey)
=> ["4081585", "4103454"] |
Initial tree: Appeal 70149 (D 200313-70149 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 849991 │ on_hold │ │ Bva │ 2020-04-23 17:35:35 UTC │
├── TrackVeteranTask │ 849992 │ in_progress │ │ Vso │ 2020-04-23 17:35:35 UTC │
├── DistributionTask │ 849993 │ completed │ │ Bva │ 2021-01-05 14:41:14 UTC │
│ └── InformalHearingPresentationTask │ 849995 │ completed │ │ Vso │ 2020-05-21 13:33:15 UTC │
├── JudgeAssignTask │ 1358544 │ completed │ │ BVAASPECTOR │ 2021-02-11 17:34:41 UTC │
└── JudgeDecisionReviewTask │ 1463785 │ on_hold │ BVAASPECTOR │ BVAASPECTOR │ 2021-02-11 17:34:42 UTC │
└── AttorneyTask │ 1463786 │ on_hold │ BVAASPECTOR │ VACOHOBBSS │ 2021-03-04 19:45:37 UTC │
└── FoiaColocatedTask │ 1524517 │ on_hold │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
└── FoiaTask │ 1524518 │ assigned │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
judge_assign_task = JudgeAssignTask.create!(appeal: atty_task.appeal, parent: atty_task.appeal.root_task, assigned_to: judge)
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 70149 (D 200313-70149 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 849991 │ on_hold │ │ Bva │ 2020-04-23 17:35:35 UTC │
├── TrackVeteranTask │ 849992 │ in_progress │ │ Vso │ 2020-04-23 17:35:35 UTC │
├── DistributionTask │ 849993 │ completed │ │ Bva │ 2021-01-05 14:41:14 UTC │
│ └── InformalHearingPresentationTask │ 849995 │ completed │ │ Vso │ 2020-05-21 13:33:15 UTC │
├── JudgeAssignTask │ 1358544 │ completed │ │ BVAASPECTOR │ 2021-02-11 17:34:41 UTC │
├── JudgeDecisionReviewTask │ 1463785 │ on_hold │ BVAASPECTOR │ BVAASPECTOR │ 2021-02-11 17:34:42 UTC │
│ └── AttorneyTask │ 1463786 │ on_hold │ BVAASPECTOR │ VACOHOBBSS │ 2021-03-04 19:45:37 UTC │
│ └── FoiaColocatedTask │ 1524517 │ on_hold │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
│ └── FoiaTask │ 1524518 │ assigned │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
└── JudgeAssignTask │ 1664963 │ assigned │ │ BVAKBCONNER │ 2021-04-22 19:57:37 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
judge_assign_task.update(status: Constants.TASK_STATUSES.on_hold)
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 70149 (D 200313-70149 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 849991 │ on_hold │ │ Bva │ 2020-04-23 17:35:35 UTC │
├── TrackVeteranTask │ 849992 │ in_progress │ │ Vso │ 2020-04-23 17:35:35 UTC │
├── DistributionTask │ 849993 │ completed │ │ Bva │ 2021-01-05 14:41:14 UTC │
│ └── InformalHearingPresentationTask │ 849995 │ completed │ │ Vso │ 2020-05-21 13:33:15 UTC │
├── JudgeAssignTask │ 1358544 │ completed │ │ BVAASPECTOR │ 2021-02-11 17:34:41 UTC │
├── JudgeDecisionReviewTask │ 1463785 │ on_hold │ BVAASPECTOR │ BVAASPECTOR │ 2021-02-11 17:34:42 UTC │
│ └── AttorneyTask │ 1463786 │ on_hold │ BVAASPECTOR │ VACOHOBBSS │ 2021-03-04 19:45:37 UTC │
│ └── FoiaColocatedTask │ 1524517 │ on_hold │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
│ └── FoiaTask │ 1524518 │ assigned │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
└── JudgeAssignTask │ 1664963 │ on_hold │ │ BVAKBCONNER │ 2021-04-22 19:57:56 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
atty_task.children.open.each { |child| child.update!(parent: judge_assign_task) }
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 70149 (D 200313-70149 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 849991 │ on_hold │ │ Bva │ 2020-04-23 17:35:35 UTC │
├── TrackVeteranTask │ 849992 │ in_progress │ │ Vso │ 2020-04-23 17:35:35 UTC │
├── DistributionTask │ 849993 │ completed │ │ Bva │ 2021-01-05 14:41:14 UTC │
│ └── InformalHearingPresentationTask │ 849995 │ completed │ │ Vso │ 2020-05-21 13:33:15 UTC │
├── JudgeAssignTask │ 1358544 │ completed │ │ BVAASPECTOR │ 2021-02-11 17:34:41 UTC │
├── JudgeDecisionReviewTask │ 1463785 │ on_hold │ BVAASPECTOR │ BVAASPECTOR │ 2021-02-11 17:34:42 UTC │
│ └── AttorneyTask │ 1463786 │ on_hold │ BVAASPECTOR │ VACOHOBBSS │ 2021-03-04 19:45:37 UTC │
└── JudgeAssignTask │ 1664963 │ on_hold │ │ BVAKBCONNER │ 2021-04-22 19:57:56 UTC │
└── FoiaColocatedTask │ 1524517 │ on_hold │ VACOHOBBSS │ PrivacyTeam │ 2021-04-22 19:58:17 UTC │
└── FoiaTask │ 1524518 │ assigned │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
atty_task.parent.cancel_task_and_child_subtasks
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 70149 (D 200313-70149 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 849991 │ on_hold │ │ Bva │ 2020-04-23 17:35:35 UTC │
├── TrackVeteranTask │ 849992 │ in_progress │ │ Vso │ 2020-04-23 17:35:35 UTC │
├── DistributionTask │ 849993 │ completed │ │ Bva │ 2021-01-05 14:41:14 UTC │
│ └── InformalHearingPresentationTask │ 849995 │ completed │ │ Vso │ 2020-05-21 13:33:15 UTC │
├── JudgeAssignTask │ 1358544 │ completed │ │ BVAASPECTOR │ 2021-02-11 17:34:41 UTC │
├── JudgeDecisionReviewTask │ 1463785 │ cancelled │ BVAASPECTOR │ BVAASPECTOR │ 2021-02-11 17:34:42 UTC │
│ └── AttorneyTask │ 1463786 │ cancelled │ BVAASPECTOR │ VACOHOBBSS │ 2021-03-04 19:45:37 UTC │
└── JudgeAssignTask │ 1664963 │ on_hold │ │ BVAKBCONNER │ 2021-04-22 19:57:56 UTC │
└── FoiaColocatedTask │ 1524517 │ on_hold │ VACOHOBBSS │ PrivacyTeam │ 2021-04-22 19:58:17 UTC │
└── FoiaTask │ 1524518 │ assigned │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
css_id = user.css_id
cancellation_instuctions = "This task has been cancelled due to the reassignment of all tasks previously assigned to #{css_id}."
atty_task.update_with_instructions(instructions: cancellation_instuctions)
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 70149 (D 200313-70149 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 849991 │ on_hold │ │ Bva │ 2020-04-23 17:35:35 UTC │
├── TrackVeteranTask │ 849992 │ in_progress │ │ Vso │ 2020-04-23 17:35:35 UTC │
├── DistributionTask │ 849993 │ completed │ │ Bva │ 2021-01-05 14:41:14 UTC │
│ └── InformalHearingPresentationTask │ 849995 │ completed │ │ Vso │ 2020-05-21 13:33:15 UTC │
├── JudgeAssignTask │ 1358544 │ completed │ │ BVAASPECTOR │ 2021-02-11 17:34:41 UTC │
├── JudgeDecisionReviewTask │ 1463785 │ cancelled │ BVAASPECTOR │ BVAASPECTOR │ 2021-04-22 20:01:20 UTC │
│ └── AttorneyTask │ 1463786 │ cancelled │ BVAASPECTOR │ VACOHOBBSS │ 2021-04-22 20:00:45 UTC │
└── JudgeAssignTask │ 1664963 │ on_hold │ │ BVAKBCONNER │ 2021-04-22 20:01:43 UTC │
└── FoiaColocatedTask │ 1524517 │ on_hold │ VACOHOBBSS │ PrivacyTeam │ 2021-04-22 19:58:17 UTC │
└── FoiaTask │ 1524518 │ assigned │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
└─────────────────────────────────────────────────────────────────────────────┘
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
=> nil
atty_task.appeal.reload.treee
┌─────────────────────────────────────────────────────────────────────────────┐
Appeal 70149 (D 200313-70149 Original) ──── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 849991 │ on_hold │ │ Bva │ 2020-04-23 17:35:35 UTC │
├── TrackVeteranTask │ 849992 │ in_progress │ │ Vso │ 2020-04-23 17:35:35 UTC │
├── DistributionTask │ 849993 │ completed │ │ Bva │ 2021-01-05 14:41:14 UTC │
│ └── InformalHearingPresentationTask │ 849995 │ completed │ │ Vso │ 2020-05-21 13:33:15 UTC │
├── JudgeAssignTask │ 1358544 │ completed │ │ BVAASPECTOR │ 2021-02-11 17:34:41 UTC │
├── JudgeDecisionReviewTask │ 1463785 │ cancelled │ BVAASPECTOR │ BVAASPECTOR │ 2021-04-22 20:01:20 UTC │
│ └── AttorneyTask │ 1463786 │ cancelled │ BVAASPECTOR │ VACOHOBBSS │ 2021-04-22 20:00:45 UTC │
└── JudgeAssignTask │ 1664963 │ on_hold │ │ BVAKBCONNER │ 2021-04-22 20:01:43 UTC │
└── FoiaColocatedTask │ 1524517 │ on_hold │ VACOHOBBSS │ PrivacyTeam │ 2021-04-22 19:58:17 UTC │
└── FoiaTask │ 1524518 │ assigned │ VACOHOBBSS │ PrivacyTeam │ 2021-03-04 19:45:37 UTC │
└─────────────────────────────────────────────────────────────────────────────┘Also had legacy tasks: legacy_tasks.pluck(:id)
=> [1245309, 1346519, 1451451, 1451450, 1451491, 1427762, 1427761]
legacy_tasks.update_all(assigned_by_id: judge.id)
=> 7
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0 |
|
vacoGamacC | bvalhowell user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[vacoGamacC | bvalhowell]
# [2, 0, 0]
# Starting tree
┌────────────────────────────────────────────────────────────────────────────┐
Appeal 46030 (D 191126-46030 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 553794 │ on_hold │ │ Bva │ 2019-12-05 13:40:14 UTC │
├── TrackVeteranTask │ 553795 │ in_progress │ │ PrivateBar │ 2019-12-05 13:40:14 UTC │
├── DistributionTask │ 553796 │ completed │ │ Bva │ 2020-06-29 19:54:57 UTC │
├── JudgeAssignTask │ 987084 │ completed │ │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
└── JudgeDecisionReviewTask │ 1009079 │ on_hold │ BVALHOWELL │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
└── AttorneyTask │ 1009080 │ on_hold │ BVALHOWELL │ VACOGAMACC │ 2020-07-13 17:59:24 UTC │
└── FoiaColocatedTask │ 1010251 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2020-07-13 17:59:24 UTC │
└── FoiaTask │ 1010252 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2020-10-26 00:45:57 UTC │
└── FoiaTask │ 1214849 │ in_progress │ BVAJRETAN │ BVATPLOWDEN │ 2020-11-04 14:51:46 UTC │
└────────────────────────────────────────────────────────────────────────────┘
judge_assign_task = JudgeAssignTask.create!(appeal: atty_task.appeal, parent: atty_task.appeal.root_task, assigned_to: judge)
┌────────────────────────────────────────────────────────────────────────────┐
Appeal 46030 (D 191126-46030 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 553794 │ on_hold │ │ Bva │ 2019-12-05 13:40:14 UTC │
├── TrackVeteranTask │ 553795 │ in_progress │ │ PrivateBar │ 2019-12-05 13:40:14 UTC │
├── DistributionTask │ 553796 │ completed │ │ Bva │ 2020-06-29 19:54:57 UTC │
├── JudgeAssignTask │ 987084 │ completed │ │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
├── JudgeDecisionReviewTask │ 1009079 │ on_hold │ BVALHOWELL │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
│ └── AttorneyTask │ 1009080 │ on_hold │ BVALHOWELL │ VACOGAMACC │ 2020-07-13 17:59:24 UTC │
│ └── FoiaColocatedTask │ 1010251 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2020-07-13 17:59:24 UTC │
│ └── FoiaTask │ 1010252 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2020-10-26 00:45:57 UTC │
│ └── FoiaTask │ 1214849 │ in_progress │ BVAJRETAN │ BVATPLOWDEN │ 2020-11-04 14:51:46 UTC │
└── JudgeAssignTask │ 1665082 │ assigned │ │ BVALHOWELL │ 2021-04-22 20:17:02 UTC │
└────────────────────────────────────────────────────────────────────────────┘
judge_assign_task.update(status: Constants.TASK_STATUSES.on_hold)
atty_task.children.open.each { |child| child.update!(parent: judge_assign_task) }
┌────────────────────────────────────────────────────────────────────────────┐
Appeal 46030 (D 191126-46030 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 553794 │ on_hold │ │ Bva │ 2019-12-05 13:40:14 UTC │
├── TrackVeteranTask │ 553795 │ in_progress │ │ PrivateBar │ 2019-12-05 13:40:14 UTC │
├── DistributionTask │ 553796 │ completed │ │ Bva │ 2020-06-29 19:54:57 UTC │
├── JudgeAssignTask │ 987084 │ completed │ │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
├── JudgeDecisionReviewTask │ 1009079 │ on_hold │ BVALHOWELL │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
│ └── AttorneyTask │ 1009080 │ on_hold │ BVALHOWELL │ VACOGAMACC │ 2020-07-13 17:59:24 UTC │
└── JudgeAssignTask │ 1665082 │ on_hold │ │ BVALHOWELL │ 2021-04-22 20:17:44 UTC │
└── FoiaColocatedTask │ 1010251 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2021-04-22 20:18:00 UTC │
└── FoiaTask │ 1010252 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2020-10-26 00:45:57 UTC │
└── FoiaTask │ 1214849 │ in_progress │ BVAJRETAN │ BVATPLOWDEN │ 2020-11-04 14:51:46 UTC │
└────────────────────────────────────────────────────────────────────────────┘
atty_task.parent.cancel_task_and_child_subtasks
┌────────────────────────────────────────────────────────────────────────────┐
Appeal 46030 (D 191126-46030 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 553794 │ on_hold │ │ Bva │ 2019-12-05 13:40:14 UTC │
├── TrackVeteranTask │ 553795 │ in_progress │ │ PrivateBar │ 2019-12-05 13:40:14 UTC │
├── DistributionTask │ 553796 │ completed │ │ Bva │ 2020-06-29 19:54:57 UTC │
├── JudgeAssignTask │ 987084 │ completed │ │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
├── JudgeDecisionReviewTask │ 1009079 │ cancelled │ BVALHOWELL │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
│ └── AttorneyTask │ 1009080 │ cancelled │ BVALHOWELL │ VACOGAMACC │ 2020-07-13 17:59:24 UTC │
└── JudgeAssignTask │ 1665082 │ on_hold │ │ BVALHOWELL │ 2021-04-22 20:17:44 UTC │
└── FoiaColocatedTask │ 1010251 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2021-04-22 20:18:00 UTC │
└── FoiaTask │ 1010252 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2020-10-26 00:45:57 UTC │
└── FoiaTask │ 1214849 │ in_progress │ BVAJRETAN │ BVATPLOWDEN │ 2020-11-04 14:51:46 UTC │
└────────────────────────────────────────────────────────────────────────────┘
css_id = user.css_id
cancellation_instuctions = "This task has been cancelled due to the reassignment of all tasks previously assigned to #{css_id}."
atty_task.update_with_instructions(instructions: cancellation_instuctions)
atty_task.parent.update_with_instructions(instructions: cancellation_instuctions)
┌────────────────────────────────────────────────────────────────────────────┐
Appeal 46030 (D 191126-46030 Original) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 553794 │ on_hold │ │ Bva │ 2019-12-05 13:40:14 UTC │
├── TrackVeteranTask │ 553795 │ in_progress │ │ PrivateBar │ 2019-12-05 13:40:14 UTC │
├── DistributionTask │ 553796 │ completed │ │ Bva │ 2020-06-29 19:54:57 UTC │
├── JudgeAssignTask │ 987084 │ completed │ │ BVALHOWELL │ 2020-07-13 13:05:51 UTC │
├── JudgeDecisionReviewTask │ 1009079 │ cancelled │ BVALHOWELL │ BVALHOWELL │ 2021-04-22 20:19:22 UTC │
│ └── AttorneyTask │ 1009080 │ cancelled │ BVALHOWELL │ VACOGAMACC │ 2021-04-22 20:19:15 UTC │
└── JudgeAssignTask │ 1665082 │ on_hold │ │ BVALHOWELL │ 2021-04-22 20:20:11 UTC │
└── FoiaColocatedTask │ 1010251 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2021-04-22 20:18:00 UTC │
└── FoiaTask │ 1010252 │ on_hold │ VACOGAMACC │ PrivacyTeam │ 2020-10-26 00:45:57 UTC │
└── FoiaTask │ 1214849 │ in_progress │ BVAJRETAN │ BVATPLOWDEN │ 2020-11-04 14:51:46 UTC │Second one: irb(main):132:0> ama_tasks.pluck(:id)
=> [1151920]
irb(main):133:0> atty_task = ama_tasks.first
=> #<AttorneyTask id: 1009080,...
# ?!
atty_task = Task.find(1151920)
┌───────────────────────────────────────────────────────────────────────────────────┐
Appeal 38854 (H 191016-38854 Original) ───────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 486747 │ on_hold │ │ Bva │ 2019-10-24 17:57:57 UTC │
├── TrackVeteranTask │ 486748 │ in_progress │ │ Vso │ 2019-10-24 17:57:57 UTC │
├── DistributionTask │ 486749 │ completed │ │ Bva │ 2020-09-11 12:46:25 UTC │
│ └── HearingTask │ 486750 │ completed │ │ Bva │ 2020-08-28 20:12:39 UTC │
│ ├── ScheduleHearingTask │ 486751 │ completed │ │ Bva │ 2020-07-14 12:44:01 UTC │
│ ├── AssignHearingDispositionTask │ 1011400 │ completed │ │ Bva │ 2020-08-13 05:04:41 UTC │
│ └── ChangeHearingDispositionTask │ 1089453 │ completed │ │ HearingAdmin │ 2020-08-28 20:12:39 UTC │
│ ├── TranscriptionTask │ 1091220 │ completed │ │ TranscriptionTeam │ 2020-08-28 20:12:39 UTC │
│ └── EvidenceSubmissionWindowTask │ 1091221 │ completed │ │ MailTeam │ 2020-08-18 14:50:00 UTC │
│ └── EvidenceSubmissionWindowTask │ 1093975 │ completed │ BVAIMBUTLER │ BVAWBAKER │ 2020-08-18 14:50:00 UTC │
├── JudgeAssignTask │ 1140873 │ completed │ │ BVALHOWELL │ 2020-09-16 19:33:06 UTC │
└── JudgeDecisionReviewTask │ 1151919 │ on_hold │ BVALHOWELL │ BVALHOWELL │ 2020-09-16 19:33:06 UTC │
└── AttorneyTask │ 1151920 │ on_hold │ BVALHOWELL │ VACOGAMACC │ 2020-09-21 15:50:08 UTC │
└── OtherColocatedTask │ 1159837 │ on_hold │ VACOGAMACC │ Colocated │ 2020-09-21 15:50:08 UTC │
└── OtherColocatedTask │ 1159838 │ on_hold │ VACOGAMACC │ BVALMAIDEN │ 2021-03-23 14:23:00 UTC │
├── TimedHoldTask │ 1165961 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-10-24 12:30:31 UTC │
├── TimedHoldTask │ 1233439 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-12-03 20:30:31 UTC │
├── TimedHoldTask │ 1289255 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2021-02-02 20:30:32 UTC │
├── TimedHoldTask │ 1438067 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2021-03-20 13:30:30 UTC │
└── TimedHoldTask │ 1575431 │ in_progress │ BVALMAIDEN │ BVALMAIDEN │ 2021-03-23 14:23:05 UTC │
└───────────────────────────────────────────────────────────────────────────────────┘
judge_assign_task.update(status: Constants.TASK_STATUSES.on_hold)
atty_task.children.open.each { |child| child.update!(parent: judge_assign_task) }
┌───────────────────────────────────────────────────────────────────────────────────┐
Appeal 38854 (H 191016-38854 Original) ───────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 486747 │ on_hold │ │ Bva │ 2019-10-24 17:57:57 UTC │
├── TrackVeteranTask │ 486748 │ in_progress │ │ Vso │ 2019-10-24 17:57:57 UTC │
├── DistributionTask │ 486749 │ completed │ │ Bva │ 2020-09-11 12:46:25 UTC │
│ └── HearingTask │ 486750 │ completed │ │ Bva │ 2020-08-28 20:12:39 UTC │
│ ├── ScheduleHearingTask │ 486751 │ completed │ │ Bva │ 2020-07-14 12:44:01 UTC │
│ ├── AssignHearingDispositionTask │ 1011400 │ completed │ │ Bva │ 2020-08-13 05:04:41 UTC │
│ └── ChangeHearingDispositionTask │ 1089453 │ completed │ │ HearingAdmin │ 2020-08-28 20:12:39 UTC │
│ ├── TranscriptionTask │ 1091220 │ completed │ │ TranscriptionTeam │ 2020-08-28 20:12:39 UTC │
│ └── EvidenceSubmissionWindowTask │ 1091221 │ completed │ │ MailTeam │ 2020-08-18 14:50:00 UTC │
│ └── EvidenceSubmissionWindowTask │ 1093975 │ completed │ BVAIMBUTLER │ BVAWBAKER │ 2020-08-18 14:50:00 UTC │
├── JudgeAssignTask │ 1140873 │ completed │ │ BVALHOWELL │ 2020-09-16 19:33:06 UTC │
├── JudgeDecisionReviewTask │ 1151919 │ on_hold │ BVALHOWELL │ BVALHOWELL │ 2020-09-16 19:33:06 UTC │
│ └── AttorneyTask │ 1151920 │ on_hold │ BVALHOWELL │ VACOGAMACC │ 2020-09-21 15:50:08 UTC │
└── JudgeAssignTask │ 1665140 │ on_hold │ │ BVALHOWELL │ 2021-04-22 20:32:44 UTC │
└── OtherColocatedTask │ 1159837 │ on_hold │ VACOGAMACC │ Colocated │ 2021-04-22 20:33:15 UTC │
└── OtherColocatedTask │ 1159838 │ on_hold │ VACOGAMACC │ BVALMAIDEN │ 2021-03-23 14:23:00 UTC │
├── TimedHoldTask │ 1165961 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-10-24 12:30:31 UTC │
├── TimedHoldTask │ 1233439 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-12-03 20:30:31 UTC │
├── TimedHoldTask │ 1289255 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2021-02-02 20:30:32 UTC │
├── TimedHoldTask │ 1438067 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2021-03-20 13:30:30 UTC │
└── TimedHoldTask │ 1575431 │ in_progress │ BVALMAIDEN │ BVALMAIDEN │ 2021-03-23 14:23:05 UTC │
└───────────────────────────────────────────────────────────────────────────────────┘
atty_task.parent.cancel_task_and_child_subtasks
┌───────────────────────────────────────────────────────────────────────────────────┐
Appeal 38854 (H 191016-38854 Original) ───────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 486747 │ on_hold │ │ Bva │ 2019-10-24 17:57:57 UTC │
├── TrackVeteranTask │ 486748 │ in_progress │ │ Vso │ 2019-10-24 17:57:57 UTC │
├── DistributionTask │ 486749 │ completed │ │ Bva │ 2020-09-11 12:46:25 UTC │
│ └── HearingTask │ 486750 │ completed │ │ Bva │ 2020-08-28 20:12:39 UTC │
│ ├── ScheduleHearingTask │ 486751 │ completed │ │ Bva │ 2020-07-14 12:44:01 UTC │
│ ├── AssignHearingDispositionTask │ 1011400 │ completed │ │ Bva │ 2020-08-13 05:04:41 UTC │
│ └── ChangeHearingDispositionTask │ 1089453 │ completed │ │ HearingAdmin │ 2020-08-28 20:12:39 UTC │
│ ├── TranscriptionTask │ 1091220 │ completed │ │ TranscriptionTeam │ 2020-08-28 20:12:39 UTC │
│ └── EvidenceSubmissionWindowTask │ 1091221 │ completed │ │ MailTeam │ 2020-08-18 14:50:00 UTC │
│ └── EvidenceSubmissionWindowTask │ 1093975 │ completed │ BVAIMBUTLER │ BVAWBAKER │ 2020-08-18 14:50:00 UTC │
├── JudgeAssignTask │ 1140873 │ completed │ │ BVALHOWELL │ 2020-09-16 19:33:06 UTC │
├── JudgeDecisionReviewTask │ 1151919 │ cancelled │ BVALHOWELL │ BVALHOWELL │ 2020-09-16 19:33:06 UTC │
│ └── AttorneyTask │ 1151920 │ cancelled │ BVALHOWELL │ VACOGAMACC │ 2020-09-21 15:50:08 UTC │
└── JudgeAssignTask │ 1665140 │ on_hold │ │ BVALHOWELL │ 2021-04-22 20:32:44 UTC │
└── OtherColocatedTask │ 1159837 │ on_hold │ VACOGAMACC │ Colocated │ 2021-04-22 20:33:15 UTC │
└── OtherColocatedTask │ 1159838 │ on_hold │ VACOGAMACC │ BVALMAIDEN │ 2021-03-23 14:23:00 UTC │
├── TimedHoldTask │ 1165961 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-10-24 12:30:31 UTC │
├── TimedHoldTask │ 1233439 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-12-03 20:30:31 UTC │
├── TimedHoldTask │ 1289255 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2021-02-02 20:30:32 UTC │
├── TimedHoldTask │ 1438067 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2021-03-20 13:30:30 UTC │
└── TimedHoldTask │ 1575431 │ in_progress │ BVALMAIDEN │ BVALMAIDEN │ 2021-03-23 14:23:05 UTC │
└───────────────────────────────────────────────────────────────────────────────────┘
atty_task.update_with_instructions(instructions: cancellation_instuctions)
atty_task.parent.update_with_instructions(instructions: cancellation_instuctions)
judge_assign_task.update_with_instructions(instructions: "This task has been assigned due to the reassignment of all tasks previously assigned to #{css_id}.")
user, judge, ama_tasks, legacy_tasks, legacy_cases, assigned_by_tasks = check_users *%w[vacoGamacC | bvalhowell]
# [0, 0, 0] |
|
I am closing this to reinforce that new ones go in Part 3 here: #16275 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
OLD TICKET: Do not add to this ticket -- add to Part 3 #16275 instead.
Part 2 of #14164
Inactive User Reassigns
N.B. - ✔️ , 🏁, and DONE are equivalent to each other.
"Nothing to do" is effectively also done, but indicates that there was nothing to reassign.
"NO" indicates that we have not gotten to those rows yet.
bvaJKramerBVAJBKRAMERAsking us to reassign from a VLJ to Case Movement - unclear how.User has since been given a JudgeTeam ThreadOther Inactive User Needs
The text was updated successfully, but these errors were encountered: