Caseflow: Reassign Tasks for Inactive Accounts
Description
The following users accounts were deactivated in Caseflow, please reassign their tasks to the "Assign Task To" users:
Echo Assignee| Name | CSS ID | Assign Task to | Status
---| -------- | ------------ | ---------------- |---
-| Peak, Margaret | BVAMLPEAK | Kary Charlebois |DONE
-| Sangster, Nadia | bvansangster | VLJ DiLorenzo |DONE
HUNTER| King, Christopher | vacokingc1 | VLJ Fleming (BVACFLEMING) |DONE
-| Wetmore, William IV | vacowetmow | Emily Tamlyn | DONE
-| Woemmel, Timothy | vacowoemmt | VLJ Strommen |DONE
-| Wasung, Pieter | vacowasunp | VLJ Parker |DONE
-| Williams, Antoine | vacowillia5 | VLJ Paul Sorisio |DONE
-| Cuttino-Hawkins, Lieu | vacocuttil | VLJ Hyland |DONE
HUNTER| McDermott, Kristina | vacomcderk | VLJ Donnelly |DONE
HUNTER| Mellott, Melinda | vacomellom | VLJ Kilcoyne |DONE
HUNTER| Harner, Christopher | vacoharnerc1 | Martina Mills |DONE
HUNTER| Capers, Glen | vacocaperg | Martina Mills |DONE
HUNTER| Lherault, Daniel | vacolherad | VLJ Donohue |DONE
HUNTER| Cavallaro, Briana | vacocavalb | VLJ Rein (BVALREIN) | DONE
HUNTER| Kristin Capes | Kristin Capes | VLJ Kramer |DONE
HUNTER| Robert Gyenes | vacogyener | VLJ Jennifer White|DONE
KAT| Christopher Casey | vacocaseyc | VLJ Hwa |DONE
KAT| Steven Grodnitzky | vacogrodns | VLJ Kelly Conner |DONE
KAT| Timothy Hatfield | vacohatfit | VLJ Cindy Bruce |DONE
KAT| Sherry Ross | Sherry Ross | VLJ Cindy Bruce | DONE
KAT| Pamela Werdal | Pamela Werdal | VLJ Howie Schwartz |DONE
KAT| Annie Nguyen | vaconguyea1 | VLJ Kalpana Parakkal |DONE
KAT| Jill Coogan | vacocoogaj | VLJ Lesley Rein |DONE
KAT| Tirza Austin-Jenkins | VACOAustiT | Marvin Koroma |DONE
YOOM| Naomi Ahsan | vacoahsann | VLJ Evan Deichert |DONE
YOOM| Dion Roberts | vacoroberd1 | VLJ Tara Reynolds |DONE
YOOM| Anthony Cirillo | vacocirilA | VLJ Reinhart |DONE
YOOM| Alex Kutrolli | vacokutroa | VLJ Ursula Powell |DONE
YOOM| Solveig Pearson | vacoparsos | VLJ Ursula Powell |DONE
YOOM| Todd Lewellen | VACOLEWELT | BVAGRSENYK |DONE
YOOM| Caitlin Biggins | bvacbiggins | Larkin |DONE
YOOM| Nique Williams | vacowillin2, vacowillin22 | Larkin |DONE
ALEC| Tiffany Blackwood | vacoblackt3 | Hawley |DONE
ALEC| Aftan Bryant | vacobryana | Moshiashwili |DONE
ALEC| Bryan Herdliska | vacoherdlb2 | Graham |DONE
ALEC| Drew Kelly | vacokellyd | Hawley |DONE
ALEC| Kelsi Lane | vacolanek | Larkin |DONE
ALEC| Jordan Magil | vacomagilj | Moshiashwili |DONE
ALEC| Kristen Marrazza | vacomarrak | Larkin |DONE
ALEC| Dan McCormick | vacomccord | Graham |DONE
Specified appeals to reassign:
Assignee| Appeal Link | CSS ID | Assign Task to | Status
---| -------- | ------------ | ---------------- |---
HUNTER| https://appeals.cf.ds.va.gov/queue/appeals/111bf0bc-bc0c-4611-9c84-021e2aa2ffb0 | bvadbrown | VLJ Laura Collins | DONE
HUNTER| https://appeals.cf.ds.va.gov/queue/appeals/af21caa0-8102-4240-8fad-6f06ee3d711d | bvadbrown | VLJ Laura Collins | DONE
Acceptance criteria
- Any current and future tasks (including completed colocated tasks) that could be assigned to the user are reassigned.
Background/context/resources
https://dsva.slack.com/archives/CHX8FMP28/p1587746799440600
Technical notes
https://github.com/department-of-veterans-affairs/appeals-deployment/wiki/Bat-Team#move-an-inactive-users-tasks-reassign-tasks-assigned-to-inactive-users
Relocated here: https://github.com/department-of-veterans-affairs/appeals-deployment/wiki/Bat-Team-Quick-Ref#move-an-inactive-users-tasks-reassign-tasks-assigned-to-inactive-users
araposo-tistatech
All 27 comments
Lets's start chipping away at these!
css_id = "BVAMLPEAK"
user = User.find_by_css_id(css_id)
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"PrivacyActTask"=>1}
new_user = User.find_by(full_name: "Kary Charlebois".upcase)
ama_tasks.each do |task|
task.reassign({
assigned_to_type: User.name,
assigned_to_id: new_user.id
}, user)
end
ama_tasks.map { |t| t.appeal.treee }
LegacyAppeal 123291 (legacy) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
├── RootTask 143568 completed Bva 2019-12-17 19:53:52 UTC
├── OtherColocatedTask 152472 cancelled BVAJMILLER Colocated 2019-07-29 19:24:05 UTC
│ └── OtherColocatedTask 152473 cancelled BVAJMILLER BVAMWALLACE 2019-07-29 19:24:05 UTC
└── PreRoutingFoiaColocatedTask 298685 completed BVAJMILLER Colocated 2019-11-18 20:30:44 UTC
└── PreRoutingFoiaColocatedTask 298686 completed BVAJMILLER BVAMWALLACE 2019-11-18 20:30:44 UTC
└── PrivacyActTask 298689 on_hold BVAMWALLACE PrivacyTeam 2019-11-06 20:49:36 UTC
├── PrivacyActTask 508003 cancelled VACOHODGET BVAJRETAN 2019-11-13 12:26:59 UTC
├── PrivacyActTask 515122 cancelled BVAJRETAN BVAMLPEAK 2020-05-05 17:17:54 UTC
└── PrivacyActTask 876169 assigned BVAMLPEAK VACOCHARLK1 2020-05-05 17:18:59 UTC
hschallhorn
on 5 May 2020
css_id = "bvansangster"
user = User.find_by_css_id(css_id)
new_user = User.where("full_name LIKE ?", "%DiLorenzo%".upcase).first
ama_tasks = Task.open.where(assigned_to: user)
=> #<ActiveRecord::Relation []>
legacy_tasks = Task.open.where(assigned_by: user)
=> #<ActiveRecord::Relation []>
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 4
legacy_cases.each { |case_record| case_record.update_vacols_location!(new_user.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
css_id = "vacowetmow"
user = User.find_by_css_id(css_id)
new_user = User.find_by(full_name: "Emily Tamlyn".upcase)
ama_tasks = Task.open.where(assigned_to: user)
=> #<ActiveRecord::Relation []>
legacy_tasks = Task.open.where(assigned_by: user)
=> #<ActiveRecord::Relation []>
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
=> #<ActiveRecord::Relation []>
css_id = "vacowoemmt"
user = User.find_by_css_id(css_id)
new_user = User.find_by("full_name LIKE ?", "%Strommen%".upcase)
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"AttorneyTask"=>1}
ama_tasks.map(&:appeal).map(&:treee)
Appeal 38009 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 479044 on_hold Bva 2019-10-22 11:25:30 UTC
├── TrackVeteranTask 479045 in_progress FieldVso 2019-10-22 11:25:30 UTC
├── DistributionTask 479046 completed Bva 2019-10-24 16:06:01 UTC
│ └── InformalHearingPresentationTask 479047 cancelled FieldVso 2019-10-22 14:19:51 UTC
├── JudgeAssignTask 486426 completed VACOSTROMG 2019-11-06 13:51:31 UTC
└── JudgeDecisionReviewTask 506142 on_hold VACOSTROMG 2019-11-06 13:51:31 UTC
└── AttorneyTask 506143 on_hold VACOSTROMG VACOWOEMMT 2019-12-17 21:49:36 UTC
└── MissingRecordsColocatedTask 580285 on_hold VACOWOEMMT Colocated 2019-12-17 21:49:36 UTC
├── MissingRecordsColocatedTask 580286 cancelled VACOWOEMMT BVATOWENS 2020-02-27 20:34:50 UTC
│ └── TimedHoldTask 664288 completed BVATOWENS BVATOWENS 2020-02-19 16:30:18 UTC
└── MissingRecordsColocatedTask 720490 on_hold VACOBOOKEK BVALCLANTON 2020-05-02 09:29:42 UTC
├── TimedHoldTask 800576 completed BVALCLANTON BVALCLANTON 2020-04-17 13:30:30 UTC
└── TimedHoldTask 871094 assigned BVALCLANTON BVALCLANTON 2020-05-02 09:29:42 UTC
# Lets reopen the judge assign task and be sure to transfer the children to the assign task
ama_tasks.each do |atty_task|
judge_task = JudgeAssignTask.create!(appeal: atty_task.appeal, parent: atty_task.appeal.root_task, assigned_to: atty_task.parent.assigned_to)
atty_task.children.open.each { |child| child.update!(parent: judge_task) }
atty_task.parent.cancel_task_and_child_subtasks
end
ama_tasks.map(&:appeal).map(&:reload).map(&:treee)
Appeal 38009 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 479044 on_hold Bva 2019-10-22 11:25:30 UTC
├── TrackVeteranTask 479045 in_progress FieldVso 2019-10-22 11:25:30 UTC
├── DistributionTask 479046 completed Bva 2019-10-24 16:06:01 UTC
│ └── InformalHearingPresentationTask 479047 cancelled FieldVso 2019-10-22 14:19:51 UTC
├── JudgeAssignTask 486426 completed VACOSTROMG 2019-11-06 13:51:31 UTC
├── JudgeDecisionReviewTask 506142 cancelled VACOSTROMG 2019-11-06 13:51:31 UTC
│ └── AttorneyTask 506143 cancelled VACOSTROMG VACOWOEMMT 2019-12-17 21:49:36 UTC
└── JudgeAssignTask 876301 assigned VACOSTROMG 2020-05-05 17:45:13 UTC
└── MissingRecordsColocatedTask 580285 on_hold VACOWOEMMT Colocated 2020-05-05 17:45:39 UTC
├── MissingRecordsColocatedTask 580286 cancelled VACOWOEMMT BVATOWENS 2020-02-27 20:34:50 UTC
│ └── TimedHoldTask 664288 completed BVATOWENS BVATOWENS 2020-02-19 16:30:18 UTC
└── MissingRecordsColocatedTask 720490 on_hold VACOBOOKEK BVALCLANTON 2020-05-02 09:29:42 UTC
├── TimedHoldTask 800576 completed BVALCLANTON BVALCLANTON 2020-04-17 13:30:30 UTC
└── TimedHoldTask 871094 assigned BVALCLANTON BVALCLANTON 2020-05-02 09:29:42 UTC
legacy_tasks = Task.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
=> #<ActiveRecord::Relation []>
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
=> #<ActiveRecord::Relation []>
css_id = "vacowasunp"
user = User.find_by_css_id(css_id)
new_judge_last_name = "Parker"
VACOLS::Staff.where(snamel: new_judge_last_name, svlj: "J").count
=> 1
new_judge_css_id = VACOLS::Staff.where(snamel: new_judge_last_name, svlj: "J").first.sdomainid
new_user = User.find_by_css_id(new_judge_css_id)
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"JudgeAssignTask"=>7, "JudgeDecisionReviewTask"=>39, "JudgeQualityReviewTask"=>1}
ama_tasks.each do |task|
task.reassign({
assigned_to_type: User.name,
assigned_to_id: new_user.id
}, user)
end
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.update_all(assigned_by_id: new_user.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
=> #<ActiveRecord::Relation []>
css_id = "vacowillia5"
user = User.find_by_css_id(css_id)
new_judge_name = "Paul Sorisio"
new_user = User.find_by("full_name LIKE ?", "%#{new_judge_name}%".upcase)
ama_tasks = Task.open.where(assigned_to: user)
=> #<ActiveRecord::Relation []>
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.update_all(assigned_by_id: new_user.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
=> #<ActiveRecord::Relation []>
css_id = "vacocuttil"
user = User.find_by_css_id(css_id)
new_judge_last_name = "Hyland"
VACOLS::Staff.where(snamel: new_judge_last_name, svlj: "J").count
=> 1
new_judge_css_id = VACOLS::Staff.where(snamel: new_judge_last_name, svlj: "J").first.sdomainid
new_user = User.find_by_css_id(new_judge_css_id)
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"AttorneyQualityReviewTask"=>1}
ama_tasks.map(&:appeal).map(&:reload).map(&:treee)
Appeal 9449 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 255229 on_hold Bva 2019-06-28 19:30:12 UTC
├── TrackVeteranTask 255230 in_progress Vso 2019-07-05 19:20:11 UTC
├── DistributionTask 255231 completed Bva 2020-01-29 19:12:26 UTC
│ └── InformalHearingPresentationTask 255232 completed Vso 2020-01-29 18:35:56 UTC
│ ├── InformalHearingPresentationTask 626945 cancelled BVACMADDOX VBAINDCROSSA 2020-01-17 18:19:42 UTC
│ └── InformalHearingPresentationTask 627364 completed VBAINDCROSSA VACOCLIFTM1 2020-01-29 18:35:56 UTC
├── JudgeAssignTask 651928 completed BVAMAWILSON 2020-02-03 16:51:47 UTC
├── JudgeDecisionReviewTask 661766 cancelled BVAMHYLAND 2020-02-05 19:39:51 UTC
├── JudgeDecisionReviewTask 669098 cancelled BVAMHYLAND BVAMAWILSON 2020-02-11 13:53:01 UTC
├── JudgeDecisionReviewTask 680128 completed BVAMAWILSON BVACBOSELY 2020-02-18 19:33:12 UTC
│ ├── AttorneyTask 661767 completed BVAMAWILSON VACOCUTTIL 2020-02-04 18:48:25 UTC
│ └── AttorneyRewriteTask 683544 completed BVACBOSELY VACOCUTTIL 2020-02-18 12:03:20 UTC
└── QualityReviewTask 695935 on_hold QualityReview 2020-02-28 19:30:09 UTC
└── QualityReviewTask 723178 on_hold VACOPATRICN VACOPATRICN 2020-03-10 12:59:58 UTC
└── JudgeQualityReviewTask 746865 on_hold VACOPATRICN BVACBOSELY 2020-03-10 13:17:33 UTC
└── AttorneyQualityReviewTask 747029 on_hold BVACBOSELY VACOCUTTIL 2020-03-18 19:35:22 UTC
└── IhpColocatedTask 765174 on_hold VACOCUTTIL Colocated 2020-03-18 19:35:22 UTC
└── IhpColocatedTask 765175 assigned VACOCUTTIL VACOWIGGIG 2020-04-18 17:30:30 UTC
└── TimedHoldTask 805130 completed VACOWIGGIG VACOWIGGIG 2020-04-18 17:30:30 UTC
# Lets update the children to the parent task and cancel the atty task
ama_tasks.each do |atty_task|
atty_task.children.open.each { |child| child.update!(parent: atty_task.parent) }
atty_task.cancel_task_and_child_subtasks
end
ama_tasks.map(&:appeal).map(&:reload).map(&:treee)
Appeal 9449 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 255229 on_hold Bva 2019-06-28 19:30:12 UTC
├── TrackVeteranTask 255230 in_progress Vso 2019-07-05 19:20:11 UTC
├── DistributionTask 255231 completed Bva 2020-01-29 19:12:26 UTC
│ └── InformalHearingPresentationTask 255232 completed Vso 2020-01-29 18:35:56 UTC
│ ├── InformalHearingPresentationTask 626945 cancelled BVACMADDOX VBAINDCROSSA 2020-01-17 18:19:42 UTC
│ └── InformalHearingPresentationTask 627364 completed VBAINDCROSSA VACOCLIFTM1 2020-01-29 18:35:56 UTC
├── JudgeAssignTask 651928 completed BVAMAWILSON 2020-02-03 16:51:47 UTC
├── JudgeDecisionReviewTask 661766 cancelled BVAMHYLAND 2020-02-05 19:39:51 UTC
├── JudgeDecisionReviewTask 669098 cancelled BVAMHYLAND BVAMAWILSON 2020-02-11 13:53:01 UTC
├── JudgeDecisionReviewTask 680128 completed BVAMAWILSON BVACBOSELY 2020-02-18 19:33:12 UTC
│ ├── AttorneyTask 661767 completed BVAMAWILSON VACOCUTTIL 2020-02-04 18:48:25 UTC
│ └── AttorneyRewriteTask 683544 completed BVACBOSELY VACOCUTTIL 2020-02-18 12:03:20 UTC
└── QualityReviewTask 695935 on_hold QualityReview 2020-02-28 19:30:09 UTC
└── QualityReviewTask 723178 on_hold VACOPATRICN VACOPATRICN 2020-03-10 12:59:58 UTC
└── JudgeQualityReviewTask 746865 on_hold VACOPATRICN BVACBOSELY 2020-03-10 13:17:33 UTC
├── AttorneyQualityReviewTask 747029 cancelled BVACBOSELY VACOCUTTIL 2020-03-18 19:35:22 UTC
└── IhpColocatedTask 765174 on_hold VACOCUTTIL Colocated 2020-05-05 18:13:47 UTC
└── IhpColocatedTask 765175 assigned VACOCUTTIL VACOWIGGIG 2020-04-18 17:30:30 UTC
└── TimedHoldTask 805130 completed VACOWIGGIG VACOWIGGIG 2020-04-18 17:30:30 UTC
Task.open.where(assigned_to: user).count
=> 0
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.update_all(assigned_by_id: new_user.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.each { |case_record| case_record.update_vacols_location!(new_user.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
@hschallhorn now that we've opened new tickets, should we close this one out? Also, just a reminder of the following notes from Troy:
- Logs show March 23 there were 421 documents downloaded but user claims on April 21 that not all documents were in Caseflow. Does Caseflow use what is in Caseflow storage at the time the user views the record in Caseflow to report the number of documents or does it make a call to VBMS at the point in time of user action? If the former, then an incorrect number in Caseflow would have nothing to do with VBMS.
- I’ve been told that if a document isn’t viewed within 2 weeks of download, it is removed from Caseflow storage. The date of download (March 23) to the date the user tried to view (April 21) is more than two weeks. Is it possible another user viewed the 309 documents within two weeks of April 21, hence those persisted but the others weren’t viewed and removed from storage after 2 weeks (April 4)? And the user failed to hit the refresh button so the missing documents didn’t refresh into Caseflow storage, hence the lower # of docs?
araposo-tistatech
on 18 May 2020
@araposo-tistatech Wrong ticket? 😄
hschallhorn
on 19 May 2020
🤦♀️
araposo-tistatech
on 19 May 2020
css_id = "vacokingc1"
user = User.find_by_css_id(css_id)
judge = User.find_by_css_id("BVACFLEMING")
ama_tasks = Task.open.where(assigned_to: user)
=> #<ActiveRecord::Relation []>
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.count
=> 2
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
=> #<ActiveRecord::Relation []>
css_id = "vacomcderk"
user = User.find_by_css_id(css_id)
judge = User.where("full_name like ?" , "%Donnelly%".upcase).first
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"AttorneyTask"=>5}
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 29431 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 410619 on_hold Bva 2019-09-16 15:29:09 UTC
├── TrackVeteranTask 410620 in_progress Vso 2019-09-16 15:29:09 UTC
├── DistributionTask 410621 completed Bva 2020-03-12 17:45:01 UTC
│ └── InformalHearingPresentationTask 410622 completed Vso 2020-02-04 15:39:55 UTC
│ └── InformalHearingPresentationTask 623858 completed VACOWENDET BVAAMONTAGUE 2020-02-04 15:39:55 UTC
├── JudgeAssignTask 754386 completed BVAWDONNELLY 2020-03-16 15:37:15 UTC
└── JudgeDecisionReviewTask 758097 on_hold BVAWDONNELLY 2020-03-16 15:37:15 UTC
└── AttorneyTask 758098 assigned BVAWDONNELLY VACOMCDERK 2020-04-23 13:37:09 UTC
└── OtherColocatedTask 780110 completed VACOMCDERK Colocated 2020-04-23 13:37:09 UTC
└── OtherColocatedTask 780111 completed VACOMCDERK VACOWIGGIG 2020-04-23 13:37:09 UTC
Appeal 10526 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 262736 on_hold Bva 2019-07-08 14:17:03 UTC
├── TrackVeteranTask 262737 in_progress Vso 2019-07-08 14:17:03 UTC
├── DistributionTask 262738 completed Bva 2020-03-10 10:00:31 UTC
│ └── InformalHearingPresentationTask 262739 completed Vso 2020-03-10 08:50:12 UTC
│ ├── InformalHearingPresentationTask 737198 cancelled BVACMADDOX VBAINDCROSSA 2020-03-06 17:46:43 UTC
│ └── InformalHearingPresentationTask 741854 completed VBAINDCROSSA VACOCLIFTM1 2020-03-10 08:50:12 UTC
├── JudgeAssignTask 746241 completed BVAWDONNELLY 2020-03-10 10:06:12 UTC
└── JudgeDecisionReviewTask 746254 on_hold BVAWDONNELLY 2020-03-10 10:06:12 UTC
└── AttorneyTask 746255 assigned BVAWDONNELLY VACOMCDERK 2020-04-20 14:19:03 UTC
└── IhpColocatedTask 753909 completed VACOMCDERK Colocated 2020-04-20 14:19:03 UTC
└── IhpColocatedTask 753910 completed VACOMCDERK VACOAUSTIT1 2020-04-20 14:19:03 UTC
└── TimedHoldTask 838000 cancelled VACOAUSTIT1 VACOAUSTIT1 2020-04-20 14:19:03 UTC
Appeal 9245 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 253125 on_hold Bva 2019-06-27 17:45:29 UTC
├── TrackVeteranTask 253126 in_progress Vso 2019-07-05 19:20:10 UTC
├── DistributionTask 253127 completed Bva 2019-11-01 13:24:06 UTC
│ └── InformalHearingPresentationTask 253128 completed Vso 2019-11-01 12:06:28 UTC
│ └── InformalHearingPresentationTask 458973 completed VACOWENDET BVAESCHULTZE 2019-11-01 12:06:28 UTC
├── JudgeAssignTask 499173 completed BVALYASUI 2019-11-05 15:29:33 UTC
└── JudgeDecisionReviewTask 504273 on_hold BVAWDONNELLY 2020-05-19 13:13:32 UTC
└── AttorneyTask 504274 on_hold BVALYASUI VACOMCDERK 2020-03-13 17:56:44 UTC
├── FoiaColocatedTask 507053 completed VACOMCDERK PrivacyTeam 2020-03-03 15:01:05 UTC
│ └── FoiaTask 507054 completed VACOMCDERK PrivacyTeam 2020-03-03 15:01:05 UTC
│ ├── FoiaTask 729138 cancelled BVAJRETAN VACOHODGET 2020-03-03 15:00:09 UTC
│ └── FoiaTask 729156 completed BVAJRETAN BVAJRETAN 2020-03-03 15:01:05 UTC
├── PoaClarificationColocatedTask 756324 on_hold VACOMCDERK Colocated 2020-03-13 17:56:44 UTC
│ └── PoaClarificationColocatedTask 756325 in_progress VACOMCDERK BVALLEWIS 2020-05-18 19:45:31 UTC
│ └── TimedHoldTask 816777 completed BVALLEWIS BVALLEWIS 2020-05-09 18:30:30 UTC
└── OtherColocatedTask 756326 completed VACOMCDERK Colocated 2020-05-18 20:01:50 UTC
└── OtherColocatedTask 756327 completed VACOMCDERK BVALLEWIS 2020-05-18 20:01:50 UTC
└── TimedHoldTask 816748 cancelled BVALLEWIS BVALLEWIS 2020-05-18 20:01:50 UTC
Appeal 21609 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 355136 on_hold Bva 2019-08-27 12:42:48 UTC
├── TrackVeteranTask 355137 in_progress Vso 2019-08-27 12:42:48 UTC
├── DistributionTask 355138 completed Bva 2020-02-10 22:53:10 UTC
│ └── HearingTask 355139 completed Bva 2020-02-10 22:30:16 UTC
│ ├── ScheduleHearingTask 355140 cancelled Bva 2020-02-10 18:30:28 UTC
│ │ └── HearingAdminActionVerifyAddressTask 522563 cancelled HearingsManagement 2019-11-19 04:15:06 UTC
│ └── EvidenceSubmissionWindowTask 678392 completed MailTeam 2020-02-10 22:30:16 UTC
├── JudgeAssignTask 679556 completed BVALYASUI 2020-02-11 16:38:55 UTC
└── JudgeDecisionReviewTask 681259 on_hold BVAWDONNELLY 2020-05-19 13:13:32 UTC
└── AttorneyTask 681260 on_hold BVALYASUI VACOMCDERK 2020-02-18 17:58:24 UTC
└── OtherColocatedTask 695436 on_hold VACOMCDERK Colocated 2020-02-18 17:58:24 UTC
└── OtherColocatedTask 695437 on_hold VACOMCDERK VACOBERGER 2020-05-05 12:48:56 UTC
└── TimedHoldTask 874586 assigned VACOBERGER VACOBERGER 2020-05-05 12:48:56 UTC
Appeal 7945 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 244582 on_hold Bva 2019-06-21 16:49:46 UTC
├── DistributionTask 244583 completed Bva 2019-09-12 15:24:20 UTC
├── TrackVeteranTask 274743 in_progress PrivateBar 2019-07-16 01:07:11 UTC
├── JudgeAssignTask 401000 completed BVAWDONNELLY 2019-09-16 20:17:31 UTC
└── JudgeDecisionReviewTask 412247 on_hold BVAWDONNELLY 2019-09-16 20:17:31 UTC
└── AttorneyTask 412248 on_hold BVAWDONNELLY VACOMCDERK 2019-09-18 13:54:45 UTC
└── FoiaColocatedTask 416575 on_hold VACOMCDERK PrivacyTeam 2019-09-18 13:54:45 UTC
└── FoiaTask 416576 on_hold VACOMCDERK PrivacyTeam 2020-02-26 14:33:32 UTC
└── FoiaTask 714753 assigned BVAJRETAN VACODOUGLN 2020-02-26 14:33:32 UTC
# Let's cancel the ones that have no children
ama_tasks.assigned.each(&:cancelled!)
# Now let's cancel the ones with children
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.each do |task|
task.cancelled!
judge_task = JudgeAssignTask.open.find_by(appeal: task.appeal)
task.children.open.each { |child| child.update!(parent: judge_task) }
judge_task.on_hold!
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 9245 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 253125 on_hold Bva 2019-06-27 17:45:29 UTC
├── TrackVeteranTask 253126 in_progress Vso 2019-07-05 19:20:10 UTC
├── DistributionTask 253127 completed Bva 2019-11-01 13:24:06 UTC
│ └── InformalHearingPresentationTask 253128 completed Vso 2019-11-01 12:06:28 UTC
│ └── InformalHearingPresentationTask 458973 completed VACOWENDET BVAESCHULTZE 2019-11-01 12:06:28 UTC
├── JudgeAssignTask 499173 completed BVALYASUI 2019-11-05 15:29:33 UTC
├── JudgeDecisionReviewTask 504273 cancelled BVAWDONNELLY 2020-05-19 13:22:52 UTC
│ └── AttorneyTask 504274 cancelled BVALYASUI VACOMCDERK 2020-05-19 13:22:52 UTC
│ ├── FoiaColocatedTask 507053 completed VACOMCDERK PrivacyTeam 2020-03-03 15:01:05 UTC
│ │ └── FoiaTask 507054 completed VACOMCDERK PrivacyTeam 2020-03-03 15:01:05 UTC
│ │ ├── FoiaTask 729138 cancelled BVAJRETAN VACOHODGET 2020-03-03 15:00:09 UTC
│ │ └── FoiaTask 729156 completed BVAJRETAN BVAJRETAN 2020-03-03 15:01:05 UTC
│ └── OtherColocatedTask 756326 completed VACOMCDERK Colocated 2020-05-18 20:01:50 UTC
│ └── OtherColocatedTask 756327 completed VACOMCDERK BVALLEWIS 2020-05-18 20:01:50 UTC
│ └── TimedHoldTask 816748 cancelled BVALLEWIS BVALLEWIS 2020-05-18 20:01:50 UTC
└── JudgeAssignTask 902848 on_hold BVAWDONNELLY 2020-05-19 13:23:35 UTC
└── PoaClarificationColocatedTask 756324 on_hold VACOMCDERK Colocated 2020-05-19 13:22:52 UTC
└── PoaClarificationColocatedTask 756325 in_progress VACOMCDERK BVALLEWIS 2020-05-18 19:45:31 UTC
└── TimedHoldTask 816777 completed BVALLEWIS BVALLEWIS 2020-05-09 18:30:30 UTC
Appeal 21609 (hearing) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 355136 on_hold Bva 2019-08-27 12:42:48 UTC
├── TrackVeteranTask 355137 in_progress Vso 2019-08-27 12:42:48 UTC
├── DistributionTask 355138 completed Bva 2020-02-10 22:53:10 UTC
│ └── HearingTask 355139 completed Bva 2020-02-10 22:30:16 UTC
│ ├── ScheduleHearingTask 355140 cancelled Bva 2020-02-10 18:30:28 UTC
│ │ └── HearingAdminActionVerifyAddressTask 522563 cancelled HearingsManagement 2019-11-19 04:15:06 UTC
│ └── EvidenceSubmissionWindowTask 678392 completed MailTeam 2020-02-10 22:30:16 UTC
├── JudgeAssignTask 679556 completed BVALYASUI 2020-02-11 16:38:55 UTC
├── JudgeDecisionReviewTask 681259 cancelled BVAWDONNELLY 2020-05-19 13:22:52 UTC
│ └── AttorneyTask 681260 cancelled BVALYASUI VACOMCDERK 2020-05-19 13:22:52 UTC
└── JudgeAssignTask 902849 on_hold BVAWDONNELLY 2020-05-19 13:23:35 UTC
└── OtherColocatedTask 695436 on_hold VACOMCDERK Colocated 2020-05-19 13:22:52 UTC
└── OtherColocatedTask 695437 on_hold VACOMCDERK VACOBERGER 2020-05-05 12:48:56 UTC
└── TimedHoldTask 874586 assigned VACOBERGER VACOBERGER 2020-05-05 12:48:56 UTC
Appeal 7945 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 244582 on_hold Bva 2019-06-21 16:49:46 UTC
├── DistributionTask 244583 completed Bva 2019-09-12 15:24:20 UTC
├── TrackVeteranTask 274743 in_progress PrivateBar 2019-07-16 01:07:11 UTC
├── JudgeAssignTask 401000 completed BVAWDONNELLY 2019-09-16 20:17:31 UTC
├── JudgeDecisionReviewTask 412247 cancelled BVAWDONNELLY 2020-05-19 13:22:52 UTC
│ └── AttorneyTask 412248 cancelled BVAWDONNELLY VACOMCDERK 2020-05-19 13:22:52 UTC
└── JudgeAssignTask 902850 on_hold BVAWDONNELLY 2020-05-19 13:23:35 UTC
└── FoiaColocatedTask 416575 on_hold VACOMCDERK PrivacyTeam 2020-05-19 13:22:52 UTC
└── FoiaTask 416576 on_hold VACOMCDERK PrivacyTeam 2020-02-26 14:33:32 UTC
└── FoiaTask 714753 assigned BVAJRETAN VACODOUGLN 2020-02-26 14:33:32 UTC
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {"ExtensionColocatedTask"=>3, "FoiaColocatedTask"=>5, "MissingHearingTranscriptsColocatedTask"=>1, "OtherColocatedTask"=>2, "ScheduleHearingColocatedTask"=>10}
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 3
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
css_id = "vacomellom"
user = User.find_by_css_id(css_id)
judge = User.where("full_name like ?" , "%Kilcoyne%".upcase).first
ama_tasks = Task.open.where(assigned_to: user)
=> #<ActiveRecord::Relation []>
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {"FoiaColocatedTask"=>1, "ScheduleHearingColocatedTask"=>1}
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
=> #<ActiveRecord::Relation []>
css_id = "vacoharnerc1"
user = User.find_by_css_id(css_id)
=> nil # 🙄
User.where("full_name like ?" , "%arner%".upcase).pluck(:css_id)
=> [..., "VACOHARNEC1", ...]
css_id = "VACOHARNEC1"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%Martina Mills%".upcase).count
=> 1
judge = User.where("full_name like ?" , "%Martina Mills%".upcase).first
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {}
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {"FoiaColocatedTask"=>1, "ScheduleHearingColocatedTask"=>1}
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 3
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
css_id = "vacocaperg"
user = User.find_by_css_id(css_id)
judge = User.where("full_name like ?" , "%Martina Mills%".upcase).first
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"AttorneyTask"=>2}
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 16850 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 320045 on_hold Bva 2019-08-09 13:09:49 UTC
├── TrackVeteranTask 320046 in_progress Vso 2019-08-09 13:09:49 UTC
├── DistributionTask 320047 completed Bva 2020-03-02 15:41:13 UTC
│ └── InformalHearingPresentationTask 320048 completed Vso 2020-01-09 17:45:04 UTC
│ └── InformalHearingPresentationTask 603816 completed BVACMADDOX BVAMCALLA 2020-01-09 17:45:04 UTC
├── JudgeAssignTask 725817 completed BVADHACHEY 2020-03-04 20:39:01 UTC
└── JudgeDecisionReviewTask 735730 on_hold BVADHACHEY 2020-03-04 20:39:01 UTC
└── AttorneyTask 735731 on_hold BVADHACHEY VACOCAPERG 2020-03-05 13:41:13 UTC
└── IhpColocatedTask 736933 on_hold VACOCAPERG Colocated 2020-03-05 13:41:13 UTC
└── IhpColocatedTask 736934 on_hold VACOCAPERG BVAMJONES 2020-04-20 17:47:38 UTC
├── TimedHoldTask 772517 completed BVAMJONES BVAMJONES 2020-04-20 14:30:30 UTC
└── TimedHoldTask 839704 assigned BVAMJONES BVAMJONES 2020-04-20 17:47:38 UTC
Appeal 13358 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 293154 on_hold Bva 2019-07-25 15:59:14 UTC
├── DistributionTask 293155 completed Bva 2019-12-23 14:53:17 UTC
│ └── TranslationTask 293156 completed Translation 2019-10-31 19:46:05 UTC
│ ├── TranslationTask 401272 cancelled VACOHUGHES2 BVAMCOWAN 2019-10-29 18:02:55 UTC
│ └── TranslationTask 494311 completed BVAMCOWAN VACOHUGHES2 2019-10-31 19:46:05 UTC
├── JudgeAssignTask 588778 completed BVADHACHEY 2019-12-31 12:04:20 UTC
└── JudgeDecisionReviewTask 594647 on_hold BVADHACHEY 2019-12-31 12:04:20 UTC
└── AttorneyTask 594648 on_hold BVADHACHEY VACOCAPERG 2020-01-07 13:29:52 UTC
└── TranslationColocatedTask 604383 on_hold VACOCAPERG Translation 2020-01-07 13:29:52 UTC
└── TranslationTask 604384 on_hold VACOCAPERG Translation 2020-01-28 13:01:34 UTC
└── TranslationTask 645811 on_hold VACOBENTOS1 VACOBENTOS1 2020-03-10 18:48:47 UTC
└── TimedHoldTask 748936 assigned VACOBENTOS1 VACOBENTOS1 2020-03-10 18:48:47 UTC
ama_tasks.each do |task|
task.cancelled!
judge_task = JudgeAssignTask.open.find_by(appeal: task.appeal)
task.children.open.each { |child| child.update!(parent: judge_task) }
judge_task.update!(assigned_to_id: judge.id, status: Task.statuses[:on_hold])
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 16850 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 320045 on_hold Bva 2019-08-09 13:09:49 UTC
├── TrackVeteranTask 320046 in_progress Vso 2019-08-09 13:09:49 UTC
├── DistributionTask 320047 completed Bva 2020-03-02 15:41:13 UTC
│ └── InformalHearingPresentationTask 320048 completed Vso 2020-01-09 17:45:04 UTC
│ └── InformalHearingPresentationTask 603816 completed BVACMADDOX BVAMCALLA 2020-01-09 17:45:04 UTC
├── JudgeAssignTask 725817 completed BVADHACHEY 2020-03-04 20:39:01 UTC
├── JudgeDecisionReviewTask 735730 cancelled BVADHACHEY 2020-05-19 13:35:54 UTC
│ └── AttorneyTask 735731 cancelled BVADHACHEY VACOCAPERG 2020-05-19 13:35:54 UTC
└── JudgeAssignTask 902908 on_hold BVAMMILLS 2020-05-19 13:37:31 UTC
└── IhpColocatedTask 736933 on_hold VACOCAPERG Colocated 2020-05-19 13:35:55 UTC
└── IhpColocatedTask 736934 on_hold VACOCAPERG BVAMJONES 2020-04-20 17:47:38 UTC
├── TimedHoldTask 772517 completed BVAMJONES BVAMJONES 2020-04-20 14:30:30 UTC
└── TimedHoldTask 839704 assigned BVAMJONES BVAMJONES 2020-04-20 17:47:38 UTC
Appeal 13358 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 293154 on_hold Bva 2019-07-25 15:59:14 UTC
├── DistributionTask 293155 completed Bva 2019-12-23 14:53:17 UTC
│ └── TranslationTask 293156 completed Translation 2019-10-31 19:46:05 UTC
│ ├── TranslationTask 401272 cancelled VACOHUGHES2 BVAMCOWAN 2019-10-29 18:02:55 UTC
│ └── TranslationTask 494311 completed BVAMCOWAN VACOHUGHES2 2019-10-31 19:46:05 UTC
├── JudgeAssignTask 588778 completed BVADHACHEY 2019-12-31 12:04:20 UTC
├── JudgeDecisionReviewTask 594647 cancelled BVADHACHEY 2020-05-19 13:35:55 UTC
│ └── AttorneyTask 594648 cancelled BVADHACHEY VACOCAPERG 2020-05-19 13:35:55 UTC
└── JudgeAssignTask 902909 on_hold BVAMMILLS 2020-05-19 13:37:31 UTC
└── TranslationColocatedTask 604383 on_hold VACOCAPERG Translation 2020-05-19 13:35:55 UTC
└── TranslationTask 604384 on_hold VACOCAPERG Translation 2020-01-28 13:01:34 UTC
└── TranslationTask 645811 on_hold VACOBENTOS1 VACOBENTOS1 2020-03-10 18:48:47 UTC
└── TimedHoldTask 748936 assigned VACOBENTOS1 VACOBENTOS1 2020-03-10 18:48:47 UTC
Task.open.where(assigned_to: user).count
=> 0
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {"ExtensionColocatedTask"=>4, "FoiaColocatedTask"=>4, "OtherColocatedTask"=>2, "ScheduleHearingColocatedTask"=>5}
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 0
css_id = "vacolherad"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "% Donohue%".upcase).count
=> 1
judge = User.where("full_name like ?" , "% Donohue%".upcase).first
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"AttorneyTask"=>1}
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 11963 (evidence_submission) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 281720 on_hold Bva 2019-07-18 19:40:59 UTC
├── DistributionTask 281721 completed Bva 2019-10-01 13:19:51 UTC
│ └── EvidenceSubmissionWindowTask 281722 completed MailTeam 2019-07-19 05:30:02 UTC
├── JudgeAssignTask 442382 completed BVAMDONOHUE 2019-10-02 18:23:26 UTC
└── JudgeDecisionReviewTask 447021 on_hold BVAMDONOHUE 2019-10-02 18:23:26 UTC
└── AttorneyTask 447022 on_hold BVAMDONOHUE VACOLHERAD 2019-10-04 18:58:57 UTC
└── FoiaColocatedTask 452850 on_hold VACOLHERAD PrivacyTeam 2019-10-04 18:58:57 UTC
└── FoiaTask 452851 on_hold VACOLHERAD PrivacyTeam 2020-03-01 13:54:32 UTC
└── FoiaTask 724430 assigned BVAJRETAN BVAAMILHOUSE 2020-03-01 13:54:32 UTC
ama_tasks.each do |task|
task.cancelled!
judge_task = JudgeAssignTask.open.find_by(appeal: task.appeal)
task.children.open.each { |child| child.update!(parent: judge_task) }
judge_task.on_hold!
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 11963 (evidence_submission) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 281720 on_hold Bva 2019-07-18 19:40:59 UTC
├── DistributionTask 281721 completed Bva 2019-10-01 13:19:51 UTC
│ └── EvidenceSubmissionWindowTask 281722 completed MailTeam 2019-07-19 05:30:02 UTC
├── JudgeAssignTask 442382 completed BVAMDONOHUE 2019-10-02 18:23:26 UTC
├── JudgeDecisionReviewTask 447021 cancelled BVAMDONOHUE 2020-05-19 13:41:23 UTC
│ └── AttorneyTask 447022 cancelled BVAMDONOHUE VACOLHERAD 2020-05-19 13:41:23 UTC
└── JudgeAssignTask 902925 on_hold BVAMDONOHUE 2020-05-19 13:41:23 UTC
└── FoiaColocatedTask 452850 on_hold VACOLHERAD PrivacyTeam 2020-05-19 13:41:23 UTC
└── FoiaTask 452851 on_hold VACOLHERAD PrivacyTeam 2020-03-01 13:54:32 UTC
└── FoiaTask 724430 assigned BVAJRETAN BVAAMILHOUSE 2020-03-01 13:54:32 UTC
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {"FoiaColocatedTask"=>1, "MissingHearingTranscriptsColocatedTask"=>1, "OtherColocatedTask"=>4, "ScheduleHearingColocatedTask"=>10}
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 1
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
css_id = "vacocavalb"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "% Rein%".upcase).count
=> 8 # Stellar
User.where("full_name like ?" , "% Rein%".upcase).select(&:judge_in_vacols?).count
=> 2 # Wonderful
user.organizations.map(&:judge).map(&:full_name)
=> ["TRACIE WESNER"] # Cool
Saving template here
css_id = ""
user = User.find_by_css_id(css_id)
judge_last_name = ""
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").first
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {}
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
ama_tasks.each do |task|
task.cancelled!
judge_task = JudgeAssignTask.open.find_by(appeal: task.appeal)
task.children.open.each { |child| child.update!(parent: judge_task) }
judge_task.update!(assigned_to_id: judge.id, status: Task.statuses[:on_hold])
end
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {}
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 0
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
user_full_name = "Kristin Capes"
User.where("full_name like ?" , "%#{user_full_name.upcase}%").count
=> 1
user = User.where("full_name like ?" , "%#{user_full_name.upcase}%").first
judge_last_name = "Kramer"
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 9 # delightful
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").select(&:judge_in_vacols?).count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").select(&:judge_in_vacols?).first
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {}
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {}
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 0
css_id = "vacogyener"
user = User.find_by_css_id(css_id)
judge_full_name = "Jennifer White"
User.where("full_name like ?" , "%#{judge_full_name.upcase}%").count
=> 2 # How
User.where("full_name like ?" , "%#{judge_full_name.upcase}%").select(&:judge_in_vacols?).count
=> 1
judge = User.where("full_name like ?" , "%#{judge_full_name.upcase}%").select(&:judge_in_vacols?).first
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"AttorneyTask"=>1}
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 54586 (evidence_submission) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 639021 on_hold Bva 2020-01-24 15:16:28 UTC
├── TrackVeteranTask 639022 in_progress Vso 2020-01-24 15:16:28 UTC
├── DistributionTask 639023 completed Bva 2020-03-10 12:58:34 UTC
│ └── EvidenceSubmissionWindowTask 639024 completed MailTeam 2020-03-10 12:11:52 UTC
├── JudgeAssignTask 746838 completed BVAJWHITE 2020-03-10 13:41:42 UTC
└── JudgeDecisionReviewTask 747134 on_hold BVAJWHITE 2020-03-10 13:41:43 UTC
└── AttorneyTask 747135 assigned BVAJWHITE VACOGYENER 2020-05-14 10:44:32 UTC
└── IhpColocatedTask 773963 completed VACOGYENER Colocated 2020-05-14 10:44:32 UTC
└── IhpColocatedTask 773964 completed VACOGYENER VACODRAYTM 2020-05-14 10:44:32 UTC
├── TimedHoldTask 785157 completed VACODRAYTM VACODRAYTM 2020-05-10 20:30:30 UTC
└── TimedHoldTask 887697 cancelled VACODRAYTM VACODRAYTM 2020-05-14 10:44:33 UTC
ama_tasks.each(&:cancelled!)
puts ama_tasks.map(&:appeal).map(&:reload).map(&:tree)
Appeal 54586 (evidence_submission) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 639021 on_hold Bva 2020-01-24 15:16:28 UTC
├── TrackVeteranTask 639022 in_progress Vso 2020-01-24 15:16:28 UTC
├── DistributionTask 639023 completed Bva 2020-03-10 12:58:34 UTC
│ └── EvidenceSubmissionWindowTask 639024 completed MailTeam 2020-03-10 12:11:52 UTC
├── JudgeAssignTask 746838 completed BVAJWHITE 2020-03-10 13:41:42 UTC
├── JudgeDecisionReviewTask 747134 cancelled BVAJWHITE 2020-05-19 14:58:31 UTC
│ └── AttorneyTask 747135 cancelled BVAJWHITE VACOGYENER 2020-05-19 14:58:31 UTC
│ └── IhpColocatedTask 773963 completed VACOGYENER Colocated 2020-05-14 10:44:32 UTC
│ └── IhpColocatedTask 773964 completed VACOGYENER VACODRAYTM 2020-05-14 10:44:32 UTC
│ ├── TimedHoldTask 785157 completed VACODRAYTM VACODRAYTM 2020-05-10 20:30:30 UTC
│ └── TimedHoldTask 887697 cancelled VACODRAYTM VACODRAYTM 2020-05-14 10:44:33 UTC
└── JudgeAssignTask 903244 assigned BVAJWHITE 2020-05-19 14:58:31 UTC
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {"ScheduleHearingColocatedTask"=>1}
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 0
judge_full_name = "Laura Collins"
User.where(full_name: judge_full_name.upcase).count
=> 1
judge = User.where(full_name: judge_full_name.upcase).first
uuid = "111bf0bc-bc0c-4611-9c84-021e2aa2ffb0"
appeal = Appeal.find_by_uuid(uuid)
appeal.reload.treee
└── RootTask 423442 on_hold Bva 2019-09-20 15:27:07 UTC
├── TrackVeteranTask 423443 in_progress Vso 2019-09-20 15:27:07 UTC
├── DistributionTask 423444 completed Bva 2019-11-20 18:10:18 UTC
│ └── InformalHearingPresentationTask 423445 completed Vso 2019-11-19 11:44:05 UTC
│ └── InformalHearingPresentationTask 528022 completed BVAESCHULTZE BVAESCHULTZE 2019-11-19 11:44:05 UTC
├── JudgeAssignTask 532034 completed BVADBROWN 2019-11-20 18:12:21 UTC
└── JudgeDecisionReviewTask 532042 on_hold BVADBROWN 2019-11-20 18:12:21 UTC
└── AttorneyTask 532043 on_hold BVADBROWN BVAMCARSTEN 2019-12-17 16:42:49 UTC
└── MissingRecordsColocatedTask 579042 on_hold BVAMCARSTEN Colocated 2019-12-17 16:42:49 UTC
└── MissingRecordsColocatedTask 579043 assigned BVAMCARSTEN VACOBERGER 2020-04-01 15:30:14 UTC
├── TimedHoldTask 601981 completed VACOBERGER VACOBERGER 2020-01-13 13:30:18 UTC
├── TimedHoldTask 629551 completed VACOBERGER VACOBERGER 2020-01-26 14:30:16 UTC
└── TimedHoldTask 725825 completed VACOBERGER VACOBERGER 2020-04-01 15:30:14 UTC
Task.find(532042).update!(assigned_to_id: judge.id)
appeal.reload.treee
Appeal 31064 (direct_review) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 423442 on_hold Bva 2019-09-20 15:27:07 UTC
├── TrackVeteranTask 423443 in_progress Vso 2019-09-20 15:27:07 UTC
├── DistributionTask 423444 completed Bva 2019-11-20 18:10:18 UTC
│ └── InformalHearingPresentationTask 423445 completed Vso 2019-11-19 11:44:05 UTC
│ └── InformalHearingPresentationTask 528022 completed BVAESCHULTZE BVAESCHULTZE 2019-11-19 11:44:05 UTC
├── JudgeAssignTask 532034 completed BVADBROWN 2019-11-20 18:12:21 UTC
└── JudgeDecisionReviewTask 532042 on_hold BVALCOLLINS 2020-05-19 15:10:26 UTC
└── AttorneyTask 532043 on_hold BVADBROWN BVAMCARSTEN 2019-12-17 16:42:49 UTC
└── MissingRecordsColocatedTask 579042 on_hold BVAMCARSTEN Colocated 2019-12-17 16:42:49 UTC
└── MissingRecordsColocatedTask 579043 assigned BVAMCARSTEN VACOBERGER 2020-04-01 15:30:14 UTC
├── TimedHoldTask 601981 completed VACOBERGER VACOBERGER 2020-01-13 13:30:18 UTC
├── TimedHoldTask 629551 completed VACOBERGER VACOBERGER 2020-01-26 14:30:16 UTC
└── TimedHoldTask 725825 completed VACOBERGER VACOBERGER 2020-04-01 15:30:14 UTC
judge_full_name = "Laura Collins"
User.where(full_name: judge_full_name.upcase).count
=> 1
judge = User.where(full_name: judge_full_name.upcase).first
uuid = "af21caa0-8102-4240-8fad-6f06ee3d711d"
appeal = Appeal.find_by_uuid(uuid)
appeal.reload.treee
Appeal 11428 (evidence_submission) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 275266 on_hold Bva 2019-07-16 13:22:24 UTC
├── TrackVeteranTask 275267 in_progress Vso 2019-07-16 13:22:24 UTC
├── DistributionTask 275268 completed Bva 2020-01-23 20:14:47 UTC
│ ├── EvidenceSubmissionWindowTask 275269 completed MailTeam 2019-07-17 05:30:03 UTC
│ └── InformalHearingPresentationTask 277179 completed Vso 2019-11-25 16:10:11 UTC
│ └── InformalHearingPresentationTask 476382 completed VACOWENDET BVAESCHULTZE 2019-11-25 16:10:11 UTC
├── JudgeAssignTask 637623 completed BVADBROWN 2020-01-23 20:29:08 UTC
└── JudgeDecisionReviewTask 637697 on_hold BVADBROWN 2020-01-23 20:29:08 UTC
└── AttorneyTask 637698 on_hold BVADBROWN BVAMCARSTEN 2020-01-31 14:50:59 UTC
└── FoiaColocatedTask 657891 on_hold BVAMCARSTEN PrivacyTeam 2020-01-31 14:50:59 UTC
└── FoiaTask 657892 assigned BVAMCARSTEN PrivacyTeam 2020-01-31 14:50:59 UTC
Task.find(637697).update!(assigned_to_id: judge.id)
appeal.reload.treee
Appeal 11428 (evidence_submission) ID STATUS ASGN_BY ASGN_TO UPDATED_AT
└── RootTask 275266 on_hold Bva 2019-07-16 13:22:24 UTC
├── TrackVeteranTask 275267 in_progress Vso 2019-07-16 13:22:24 UTC
├── DistributionTask 275268 completed Bva 2020-01-23 20:14:47 UTC
│ ├── EvidenceSubmissionWindowTask 275269 completed MailTeam 2019-07-17 05:30:03 UTC
│ └── InformalHearingPresentationTask 277179 completed Vso 2019-11-25 16:10:11 UTC
│ └── InformalHearingPresentationTask 476382 completed VACOWENDET BVAESCHULTZE 2019-11-25 16:10:11 UTC
├── JudgeAssignTask 637623 completed BVADBROWN 2020-01-23 20:29:08 UTC
└── JudgeDecisionReviewTask 637697 on_hold BVALCOLLINS 2020-05-19 15:12:03 UTC
└── AttorneyTask 637698 on_hold BVADBROWN BVAMCARSTEN 2020-01-31 14:50:59 UTC
└── FoiaColocatedTask 657891 on_hold BVAMCARSTEN PrivacyTeam 2020-01-31 14:50:59 UTC
└── FoiaTask 657892 assigned BVAMCARSTEN PrivacyTeam 2020-01-31 14:50:59 UTC
For user Larkin, there are multiple users:
User.where("full_name LIKE ?", "%Larkin%".upcase).count
=> 3
# This looks like this is the most reasonable choice:
css_id: "BVAMELARKIN",
roles: ["Reader", "Hearing Prep"],
The other 2 users are a VSO ("VBASPTLARKIJ") and Intake(?) user ("VSCBLARK").
cc: @ajspotts
yoomlam
on 19 May 2020
👀1
@yoomlam requesting the CSS ID for Larkin
araposo-tistatech
on 19 May 2020
👍1
vacoahsann
user = User.find_by_css_id("vacoahsann".upcase)
new_user = User.find_by(full_name: "Evan Deichert".upcase)
ama_tasks = Task.open.where(assigned_to: user)
=> #<ActiveRecord::Relation []>
legacy_tasks = Task.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
=> #<ActiveRecord::Relation []>
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
=> #<ActiveRecord::Relation []>
pp [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 0, 0]
vacoroberd1
user = User.find_by_css_id("vacoroberd1".upcase)
new_user = User.find_by(full_name: "Tara Reynolds".upcase)
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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]
=> [0, 0, 0]
vacocirilA
user = User.find_by_css_id("vacocirilA".upcase)
User.where("full_name LIKE ?", "%Reinhart%".upcase).count
=> 1
new_user = User.find_by(css_id: "BVAJREINHART")
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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]
=> [0, 2, 0]
legacy_tasks.pluck(:id, :type)
=> [[599048, "OtherColocatedTask"], [599049, "OtherColocatedTask"]]
legacy_tasks = OtherColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.pluck(:id, :type)
=> [[599048, "OtherColocatedTask"], [599049, "OtherColocatedTask"]]
legacy_tasks.update_all(assigned_by_id: new_user.id)
=> 2
OtherColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
vacokutroa
user = User.find_by_css_id("vacokutroa".upcase)
new_user = User.find_by(full_name: "Ursula Powell".upcase)
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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]
=> [0, 4, 0]
legacy_tasks.pluck(:id, :type)
=> [[314518, "ScheduleHearingColocatedTask"], [324572, "ScheduleHearingColocatedTask"], [321632, "ScheduleHearingColocatedTask"], [328350, "ScheduleHearingColocatedTask"]]
legacy_tasks2 = ScheduleHearingColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks2.pluck(:id, :type)
=> [[314518, "ScheduleHearingColocatedTask"], [324572, "ScheduleHearingColocatedTask"], [321632, "ScheduleHearingColocatedTask"], [328350, "ScheduleHearingColocatedTask"]]
legacy_tasks2.update_all(assigned_by_id: new_user.id)
=> 4
ScheduleHearingColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
@hschallhorn I have these task types to reassign for legacy appeals: ["FoiaTask", "HearingClarificationColocatedTask", "IhpColocatedTask", "PoaClarificationColocatedTask"].
I didn't see specific examples for how to handle these task types, so should these be handled in a similar manner, i.e., legacy_tasks.update_all(assigned_by_id: new_user.id)?
yoomlam
on 19 May 2020
@yoomlam the CSS ID is BVAMELARKIN
araposo-tistatech
on 19 May 2020
👍1
css_id = "vacocavalb"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "% Rein%".upcase).count
=> 8 # Stellar
User.where("full_name like ?" , "% Rein%".upcase).select(&:judge_in_vacols?).count
=> 2 # Wonderful
user.organizations.map(&:judge).map(&:full_name)
=> ["TRACIE WESNER"] # Cool
@araposo-tistatech Also need a css_id for VLJ Rein to reassign Cavallaro, Briana (vacocavalb) cases
hschallhorn
on 19 May 2020
👍1
@hschallhorn CSS ID is BVALREIN.
araposo-tistatech
on 19 May 2020
css_id = "vacocavalb"
user = User.find_by_css_id(css_id)
judge = User.find_by_css_id("BVALREIN")
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {}
legacy_tasks = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks.group(:type).count
=> {"HearingClarificationColocatedTask"=>2, "ScheduleHearingColocatedTask"=>3}
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_cases = VACOLS::Case.where(bfcurloc: user.vacols_user.slogid)
legacy_cases.count
=> 0
Skipping non-ColocatedTasks convo
vacoparsos
user = User.find_by_css_id("vacoparsos".upcase)
new_user = User.find_by(full_name: "Ursula Powell".upcase)
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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]
=> [0, 28, 0]
pp legacy_tasks.group(:type).count
{"HearingClarificationColocatedTask"=>2,
"FoiaTask"=>8,
"FoiaColocatedTask"=>10,
"ScheduleHearingColocatedTask"=>3,
"OtherColocatedTask"=>3,
"PoaClarificationColocatedTask"=>1,
"IhpColocatedTask"=>1}
legacy_tasks2 = ScheduleHearingColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
legacy_tasks2.update_all(assigned_by_id: new_user.id)
=> 3
ScheduleHearingColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
legacy_tasks2 = OtherColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
idtypes = legacy_tasks2.pluck(:id, :type)
=> [[428914, "OtherColocatedTask"], [674939, "OtherColocatedTask"], [674940, "OtherColocatedTask"]]
legacy_tasks2.update_all(assigned_by_id: new_user.id)
=> 3
OtherColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
OtherColocatedTask.where(id: idtypes.map(&:first)).map(&:assigned_by_id)
=> [1167, 1167, 1167]
legacy_tasks2 = FoiaColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
idtypes = legacy_tasks2.pluck(:id, :type)
=> [[501497, "FoiaColocatedTask"], [429670, "FoiaColocatedTask"], [509802, "FoiaColocatedTask"], [512116, "FoiaColocatedTask"], [623601, "FoiaColocatedTask"], [638545, "FoiaColocatedTask"], [638666, "FoiaColocatedTask"], [674937, "FoiaColocatedTask"], [696345, "FoiaColocatedTask"], [696358, "FoiaColocatedTask"]]
legacy_tasks2.update_all(assigned_by_id: new_user.id)
=> 10
FoiaColocatedTask.where(id: idtypes.map(&:first)).map(&:assigned_by_id)
=> [1167, 1167, 1167, 1167, 1167, 1167, 1167, 1167, 1167, 1167]
# Remaining
legacy_tasks.group(:type).count
{"HearingClarificationColocatedTask"=>2,
"FoiaTask"=>8,
"PoaClarificationColocatedTask"=>1,
"IhpColocatedTask"=>1}
legacy_tasks2 = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
idtypes = legacy_tasks2.pluck(:id, :type)
legacy_tasks2.update_all(assigned_by_id: new_user.id)
ColocatedTask.where(id: idtypes.map(&:first)).map(&:assigned_by_id)
=> [1167, 1167, 1167, 1167]
legacy_tasks.group(:type).count
=> {"FoiaTask"=>8}
# Skipping non-ColocatedTask
VACOLEWELT
user = User.find_by_css_id("VACOLEWELT".upcase)
new_user = User.find_by(css_id: "BVAGRSENYK")
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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]
=> [0, 2, 0]
pp legacy_tasks.group(:type).count
=> {"FoiaColocatedTask"=>1, "FoiaTask"=>1}
legacy_tasks2 = FoiaColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
idtypes = legacy_tasks2.pluck(:id, :type)
=> [[765377, "FoiaColocatedTask"]]
legacy_tasks2.update_all(assigned_by_id: new_user.id)
=> 1
FoiaColocatedTask.where(id: idtypes.map(&:first)).map(&:assigned_by_id)
=> [878]
legacy_tasks.group(:type).count
=> {"FoiaTask"=>1}
bvacbiggins
user = User.find_by_css_id("bvacbiggins".upcase)
User.where("full_name LIKE ?", "%Larkin%".upcase).count
=> 3
new_user = User.find_by(css_id: "BVAMELARKIN")
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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, 3, 1]
ama_tasks.first.appeal.treee
┌────────────────────────────────────────────────────────────────────────────┐
Appeal 1439 (direct_review) ────────────────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 22814 │ on_hold │ │ Bva │ 2019-01-24 20:52:01 UTC │
├── JudgeAssignTask │ 25027 │ on_hold │ │ BVAMELARKIN │ 2019-01-28 21:13:19 UTC │
│ └── AttorneyTask │ 26811 │ assigned │ BVAMELARKIN │ BVACBIGGINS │ 2019-12-30 18:01:24 UTC │
│ ├── PreRoutingTranslationColocatedTask │ 28291 │ completed │ BVACBIGGINS │ Colocated │ 2019-07-19 14:50:35 UTC │
│ │ └── PreRoutingTranslationColocatedTask │ 28292 │ completed │ BVACBIGGINS │ BVAMJKOROMA │ 2019-07-19 14:50:28 UTC │
│ │ ├── Task │ 29182 │ completed │ BVAMJKOROMA │ Translation │ 2019-11-21 20:18:24 UTC │
│ │ │ └── Task │ 31115 │ completed │ VACOHUGHES2 │ VACOHUGHES2 │ 2019-11-21 20:18:24 UTC │
│ │ ├── Task │ 31225 │ completed │ BVAMJKOROMA │ Translation │ 2019-11-21 20:18:24 UTC │
│ │ │ └── Task │ 31231 │ completed │ VACOHUGHES2 │ VACOHUGHES2 │ 2019-11-21 20:18:24 UTC │
│ │ ├── TranslationTask │ 166167 │ completed │ BVAMJKOROMA │ Translation │ 2019-04-09 11:30:37 UTC │
│ │ └── TranslationTask │ 172158 │ completed │ BVAMJKOROMA │ Translation │ 2019-04-17 12:26:01 UTC │
│ ├── IhpColocatedTask │ 195910 │ completed │ BVACBIGGINS │ Colocated │ 2019-07-19 14:55:01 UTC │
│ │ └── IhpColocatedTask │ 195911 │ completed │ BVACBIGGINS │ BVAMJKOROMA │ 2019-07-19 14:55:38 UTC │
│ │ └── TimedHoldTask │ 248133 │ cancelled │ BVAMJKOROMA │ BVAMJKOROMA │ 2019-06-26 19:24:20 UTC │
│ └── IhpColocatedTask │ 258655 │ completed │ BVACBIGGINS │ Colocated │ 2019-12-30 18:01:24 UTC │
│ ├── IhpColocatedTask │ 258656 │ cancelled │ BVACBIGGINS │ BVATHUNTER │ 2019-11-07 15:28:15 UTC │
│ │ └── TimedHoldTask │ 357649 │ completed │ BVATHUNTER │ BVATHUNTER │ 2019-09-06 21:30:15 UTC │
│ └── IhpColocatedTask │ 509356 │ completed │ BVAMJKOROMA │ BVACREWST │ 2019-12-30 18:01:24 UTC │
│ ├── TimedHoldTask │ 527068 │ completed │ BVACREWST │ BVACREWST │ 2019-12-03 18:30:18 UTC │
│ └── TimedHoldTask │ 549669 │ completed │ BVACREWST │ BVACREWST │ 2019-12-18 19:30:19 UTC │
└── TrackVeteranTask │ 126930 │ in_progress │ │ Vso │ 2019-07-05 19:18:48 UTC │
└────────────────────────────────────────────────────────────────────────────┘
ama_tasks.first.id
=> 26811
# If all attorney tasks have no open children, and the judge assign task is assigned to the correct judge,
`ama_tasks.each(&:cancelled!)` can be used rather than the block.
ama_tasks.first.parent.type
=> "JudgeAssignTask"
ama_tasks.first.parent.assigned_to.css_id
=> "BVAMELARKIN"
ama_tasks.first.cancelled!
ama_tasks.first.appeal.reload.treee
┌────────────────────────────────────────────────────────────────────────────┐
Appeal 1439 (direct_review) ────────────────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 22814 │ on_hold │ │ Bva │ 2019-01-24 20:52:01 UTC │
├── JudgeDecisionReviewTask │ 25027 │ cancelled │ │ BVAMELARKIN │ 2020-05-19 18:48:57 UTC │
│ └── AttorneyTask │ 26811 │ cancelled │ BVAMELARKIN │ BVACBIGGINS │ 2020-05-19 18:48:52 UTC │
│ ├── PreRoutingTranslationColocatedTask │ 28291 │ completed │ BVACBIGGINS │ Colocated │ 2019-07-19 14:50:35 UTC │
│ │ └── PreRoutingTranslationColocatedTask │ 28292 │ completed │ BVACBIGGINS │ BVAMJKOROMA │ 2019-07-19 14:50:28 UTC │
│ │ ├── Task │ 29182 │ completed │ BVAMJKOROMA │ Translation │ 2019-11-21 20:18:24 UTC │
│ │ │ └── Task │ 31115 │ completed │ VACOHUGHES2 │ VACOHUGHES2 │ 2019-11-21 20:18:24 UTC │
│ │ ├── Task │ 31225 │ completed │ BVAMJKOROMA │ Translation │ 2019-11-21 20:18:24 UTC │
│ │ │ └── Task │ 31231 │ completed │ VACOHUGHES2 │ VACOHUGHES2 │ 2019-11-21 20:18:24 UTC │
│ │ ├── TranslationTask │ 166167 │ completed │ BVAMJKOROMA │ Translation │ 2019-04-09 11:30:37 UTC │
│ │ └── TranslationTask │ 172158 │ completed │ BVAMJKOROMA │ Translation │ 2019-04-17 12:26:01 UTC │
│ ├── IhpColocatedTask │ 195910 │ completed │ BVACBIGGINS │ Colocated │ 2019-07-19 14:55:01 UTC │
│ │ └── IhpColocatedTask │ 195911 │ completed │ BVACBIGGINS │ BVAMJKOROMA │ 2019-07-19 14:55:38 UTC │
│ │ └── TimedHoldTask │ 248133 │ cancelled │ BVAMJKOROMA │ BVAMJKOROMA │ 2019-06-26 19:24:20 UTC │
│ └── IhpColocatedTask │ 258655 │ completed │ BVACBIGGINS │ Colocated │ 2019-12-30 18:01:24 UTC │
│ ├── IhpColocatedTask │ 258656 │ cancelled │ BVACBIGGINS │ BVATHUNTER │ 2019-11-07 15:28:15 UTC │
│ │ └── TimedHoldTask │ 357649 │ completed │ BVATHUNTER │ BVATHUNTER │ 2019-09-06 21:30:15 UTC │
│ └── IhpColocatedTask │ 509356 │ completed │ BVAMJKOROMA │ BVACREWST │ 2019-12-30 18:01:24 UTC │
│ ├── TimedHoldTask │ 527068 │ completed │ BVACREWST │ BVACREWST │ 2019-12-03 18:30:18 UTC │
│ └── TimedHoldTask │ 549669 │ completed │ BVACREWST │ BVACREWST │ 2019-12-18 19:30:19 UTC │
├── TrackVeteranTask │ 126930 │ in_progress │ │ Vso │ 2019-07-05 19:18:48 UTC │
└── JudgeAssignTask │ 904325 │ assigned │ │ BVAMELARKIN │ 2020-05-19 18:48:57 UTC │
└────────────────────────────────────────────────────────────────────────────┘
legacy_tasks.group(:type).count
=> {"ScheduleHearingColocatedTask"=>3}
legacy_tasks2 = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
idtypes = legacy_tasks2.pluck(:id, :type)
=> [[331270, "ScheduleHearingColocatedTask"], [404795, "ScheduleHearingColocatedTask"], [376471, "ScheduleHearingColocatedTask"]]
legacy_tasks2.update_all(assigned_by_id: new_user.id)
ColocatedTask.where(id: idtypes.map(&:first)).map(&:assigned_by_id)
=> [884, 884, 884]
case_record=legacy_cases.first
new_user.vacols_user.slogid
=> "MELARKIN"
case_record.update_vacols_location!(new_user.vacols_user.slogid)
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
# Double check
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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]
=> [0, 0, 0]
vacowillin2
user = User.find_by_css_id("vacowillin2".upcase)
new_user = User.find_by(css_id: "BVAMELARKIN")
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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]
=> [0, 0, 0]
user.vacols_user.slogid
Traceback (most recent call last):
1: from (irb):72
NoMethodError (undefined method `slogid' for nil:NilClass)
aka acowillin22
user = User.find_by_css_id("vacowillin22".upcase)
user.vacols_user.slogid
=> "VACOWILLIN22"
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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, 8, 3]
ama_tasks = Task.open.where(assigned_to: user)
ama_tasks.group(:type).count
=> {"AttorneyRewriteTask"=>1}
ama_tasks.first.appeal.treee
┌────────────────────────────────────────────────────────────────────────────────────┐
Appeal 10629 (direct_review) ─────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 263578 │ on_hold │ │ Bva │ 2019-07-08 18:08:01 UTC │
├── TrackVeteranTask │ 263579 │ in_progress │ │ FieldVso │ 2019-07-08 18:08:01 UTC │
├── DistributionTask │ 263580 │ completed │ │ Bva │ 2020-01-23 15:37:22 UTC │
│ └── InformalHearingPresentationTask │ 263581 │ cancelled │ │ FieldVso │ 2019-10-22 14:19:42 UTC │
├── JudgeAssignTask │ 636245 │ completed │ │ BVAMELARKIN │ 2020-01-28 13:46:02 UTC │
└── JudgeDecisionReviewTask │ 646071 │ on_hold │ │ BVAMELARKIN │ 2020-02-28 19:58:06 UTC │
├── AttorneyTask │ 646072 │ completed │ BVAMELARKIN │ VACOWILLIN22 │ 2020-02-19 13:06:24 UTC │
└── AttorneyRewriteTask │ 723289 │ on_hold │ BVAMELARKIN │ VACOWILLIN22 │ 2020-03-13 12:00:57 UTC │
└── ScheduleHearingColocatedTask │ 755464 │ assigned │ VACOWILLIN22 │ HearingsManagement │ 2020-03-13 12:00:57 UTC │
└────────────────────────────────────────────────────────────────────────────────────┘
ama_tasks.first.id
=> 723289
ama_tasks.each do |atty_task|
atty_task.children.open.each { |child| child.update!(parent: atty_task.parent) }
atty_task.cancel_task_and_child_subtasks
end
ama_tasks.first.appeal.reload.treee
┌────────────────────────────────────────────────────────────────────────────────────┐
Appeal 10629 (direct_review) ────────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 263578 │ on_hold │ │ Bva │ 2019-07-08 18:08:01 UTC │
├── TrackVeteranTask │ 263579 │ in_progress │ │ FieldVso │ 2019-07-08 18:08:01 UTC │
├── DistributionTask │ 263580 │ completed │ │ Bva │ 2020-01-23 15:37:22 UTC │
│ └── InformalHearingPresentationTask │ 263581 │ cancelled │ │ FieldVso │ 2019-10-22 14:19:42 UTC │
├── JudgeAssignTask │ 636245 │ completed │ │ BVAMELARKIN │ 2020-01-28 13:46:02 UTC │
└── JudgeDecisionReviewTask │ 646071 │ on_hold │ │ BVAMELARKIN │ 2020-02-28 19:58:06 UTC │
├── AttorneyTask │ 646072 │ completed │ BVAMELARKIN │ VACOWILLIN22 │ 2020-02-19 13:06:24 UTC │
├── AttorneyRewriteTask │ 723289 │ cancelled │ BVAMELARKIN │ VACOWILLIN22 │ 2020-03-13 12:00:57 UTC │
└── ScheduleHearingColocatedTask │ 755464 │ assigned │ VACOWILLIN22 │ HearingsManagement │ 2020-05-19 19:18:40 UTC │
└────────────────────────────────────────────────────────────────────────────────────┘
pp legacy_tasks.group(:type).count
=> {"FoiaColocatedTask"=>1, "FoiaTask"=>1, "ScheduleHearingColocatedTask"=>6}
legacy_tasks2 = ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name)
idtypes = legacy_tasks2.pluck(:id, :type)
=> [[537727, "ScheduleHearingColocatedTask"], [752686, "FoiaColocatedTask"], [755471, "ScheduleHearingColocatedTask"], [372667, "ScheduleHearingColocatedTask"], [429792, "ScheduleHearingColocatedTask"], [615628, "ScheduleHearingColocatedTask"], [687528, "ScheduleHearingColocatedTask"]]
legacy_tasks2.update_all(assigned_by_id: new_user.id)
=> 7
ColocatedTask.where(id: idtypes.map(&:first)).map(&:assigned_by_id)
=> [884, 884, 884, 884, 884, 884, 884]
pp legacy_tasks.group(:type).count
=> {"FoiaTask"=>1}
legacy_cases.pluck(:bfkey)
=> ["3483298", "3762939", "3948246"]
new_user.vacols_user.slogid
=> "MELARKIN"
legacy_cases.each { |case_record| case_record.update_vacols_location!(new_user.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
# Double check
ama_tasks = Task.open.where(assigned_to: user)
legacy_tasks = Task.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]
=> [0, 1, 0]
vacocaseyc
css_id = "vacocaseyc"
judge_last_name = "Hwa"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 11
User.where("full_name like ?" , "%#{judge_last_name.upcase}").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}").first
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]
=> [0, 4, 0]
### legacy tasks
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
vacogrodns
css_id = "vacogrodns"
# Kelly Conner
judge_last_name = "Conner"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 8
judge_last_name = "Kelly Conner"
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").first
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, 1, 0]
### ama
ama_task = ama_tasks.first
ama_task.appeal.reload.treee
┌──────────────────────────────────────────────────────────────────────────┐
Appeal 9967 (direct_review) ────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 259631 │ on_hold │ │ Bva │ 2019-07-03 13:18:14 UTC │
├── DistributionTask │ 259632 │ completed │ │ Bva │ 2019-12-19 12:45:26 UTC │
├── JudgeAssignTask │ 584232 │ completed │ │ BVAKBCONNER │ 2019-12-27 16:25:28 UTC │
└── JudgeDecisionReviewTask │ 591914 │ on_hold │ │ BVAKBCONNER │ 2019-12-27 16:25:28 UTC │
└── AttorneyTask │ 591916 │ on_hold │ BVAKBCONNER │ VACOGRODNS │ 2020-03-09 12:01:46 UTC │
├── OtherColocatedTask │ 621507 │ completed │ VACOGRODNS │ Colocated │ 2020-02-19 12:51:14 UTC │
│ └── OtherColocatedTask │ 621508 │ completed │ VACOGRODNS │ VACOMOSSA1 │ 2020-02-19 12:51:14 UTC │
│ └── TimedHoldTask │ 627234 │ completed │ VACOMOSSA1 │ VACOMOSSA1 │ 2020-02-16 18:30:18 UTC │
└── OtherColocatedTask │ 743456 │ on_hold │ VACOGRODNS │ Colocated │ 2020-03-09 12:01:46 UTC │
└── OtherColocatedTask │ 743457 │ assigned │ VACOGRODNS │ BVALMAIDEN │ 2020-05-09 19:30:30 UTC │
├── TimedHoldTask │ 748573 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-04-09 18:30:30 UTC │
└── TimedHoldTask │ 817126 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-05-09 19:30:30 UTC │
└──────────────────────────────────────────────────────────────────────────┘
ama_tasks.each do |task|
task.cancelled!
judge_task = JudgeAssignTask.open.find_by(appeal: task.appeal)
task.children.open.each { |child| child.update!(parent: judge_task) }
judge_task.update!(assigned_to_id: judge.id, status: Task.statuses[:on_hold])
end
ama_task.appeal.reload.treee
┌──────────────────────────────────────────────────────────────────────────┐
Appeal 9967 (direct_review) ────────── │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
└── RootTask │ 259631 │ on_hold │ │ Bva │ 2019-07-03 13:18:14 UTC │
├── DistributionTask │ 259632 │ completed │ │ Bva │ 2019-12-19 12:45:26 UTC │
├── JudgeAssignTask │ 584232 │ completed │ │ BVAKBCONNER │ 2019-12-27 16:25:28 UTC │
├── JudgeDecisionReviewTask │ 591914 │ cancelled │ │ BVAKBCONNER │ 2020-05-19 20:02:55 UTC │
│ └── AttorneyTask │ 591916 │ cancelled │ BVAKBCONNER │ VACOGRODNS │ 2020-05-19 20:02:55 UTC │
│ └── OtherColocatedTask │ 621507 │ completed │ VACOGRODNS │ Colocated │ 2020-02-19 12:51:14 UTC │
│ └── OtherColocatedTask │ 621508 │ completed │ VACOGRODNS │ VACOMOSSA1 │ 2020-02-19 12:51:14 UTC │
│ └── TimedHoldTask │ 627234 │ completed │ VACOMOSSA1 │ VACOMOSSA1 │ 2020-02-16 18:30:18 UTC │
└── JudgeAssignTask │ 904666 │ on_hold │ │ BVAKBCONNER │ 2020-05-19 20:02:55 UTC │
└── OtherColocatedTask │ 743456 │ on_hold │ VACOGRODNS │ Colocated │ 2020-05-19 20:02:55 UTC │
└── OtherColocatedTask │ 743457 │ assigned │ VACOGRODNS │ BVALMAIDEN │ 2020-05-09 19:30:30 UTC │
├── TimedHoldTask │ 748573 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-04-09 18:30:30 UTC │
└── TimedHoldTask │ 817126 │ completed │ BVALMAIDEN │ BVALMAIDEN │ 2020-05-09 19:30:30 UTC │
└──────────────────────────────────────────────────────────────────────────┘
### legacy tasks
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
lomky
on 19 May 2020
vacohatfit
css_id = "vacohatfit"
# VLJ Cindy Bruce
judge_last_name = "Bruce"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 25
judge_last_name = "Cindy Bruce"
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 0
# sigh
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").first
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]
=> [0, 0, 0]
# nothing to fix
Sherry Ross
# Sherry Ross - VACOROSSS1
user_last_name = "Sherry Ross"
# VLJ Cindy Bruce
# Assuming `Cynthia Bruce` - BVACBRUCE
judge_last_name = "CYNTHIA Bruce"
# discover atty
User.where("full_name like ?" , "%#{user_last_name.upcase}%").count
=> 1
user = User.where("full_name like ?" , "%#{user_last_name.upcase}%").first
# discover judge
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").first
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]
=> [0, 0, 1]
### legacy cases
legacy_cases.pluck(:bfkey)
=> ["3434309"]
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
Pamela Werdal
# Pamela Werdal - VACOWERDAP1
user_last_name = "Werdal"
# VLJ Howie Schwartz - Assuming Howard Schwartz - BVAHSCHARTZ
judge_last_name = "Schwartz"
# discover atty
User.where("full_name like ?" , "%#{user_last_name.upcase}%").count
=> 1
user = User.where("full_name like ?" , "%#{user_last_name.upcase}%").first
# discover judge
User.where("full_name like ?" , "%HOWARD #{judge_last_name.upcase}%").count
=> 1
judge = User.where("full_name like ?" , "%HOWARD #{judge_last_name.upcase}%").first
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]
=> [0, 0, 0]
# Nothing to do
vaconguyea1
# vaconguyea1 | VLJ Kalpana Parakkal - BVAKPARAKAL
css_id = "vaconguyea1"
judge_last_name = "Parakkal"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").first
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]
=> [0, 0, 1]
### legacy cases
legacy_cases.pluck(:bfkey)
=> ["3966842"]
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
vacocoogaj
# Jill Coogan - vacocoogaj | VLJ Lesley Rein - BVALREIN
css_id = "vacocoogaj"
judge_last_name = "Rein"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}").first
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]
=> [0, 0, 0]
# Nothing to do
VACOAustiT
# Tirza Austin-Jenkins | VACOAustiT | Marvin Koroma - BVAMJKOROMA
css_id = "VACOAustiT"
judge_last_name = "Marvin Koroma"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").first
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]
=> [0, 0, 0]
# Nothing to do
vacoblackt3
css_id = "vacoblackt3"
judge_last_name = "Hawley"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").first
=> BVAMHAWLEY
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]
=> [0, 0, 0]
# Nothing to do
vacobryana
css_id = "vacobryana"
judge_last_name = "Moshiashwili"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 1
judge = User.where("full_name like ?" , "%#{judge_last_name.upcase}%").first
=> BVAVMOSHI
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]
=> [0, 0, 1]
### legacy cases
legacy_cases.pluck(:bfkey)
=> ["2994547"]
legacy_cases.each { |case_record| case_record.update_vacols_location!(judge.vacols_user.slogid) }
VACOLS::Case.where(bfcurloc: user.vacols_user.slogid).count
=> 0
vacoherdlb2
css_id = "vacoherdlb2"
judge_last_name = "Graham"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 23 👀
VACOLS::Staff.where(snamel: judge_last_name, svlj: "J").count
=> 1
judge_css_id = VACOLS::Staff.where(snamel: judge_last_name, svlj: "J").first.sdomainid
=> BVAMCGRAHAM
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]
=> [0, 0, 0]
# Nothing to do
vacokellyd
css_id = "vacokellyd"
judge_last_name = "Hawley"
user = User.find_by_css_id(css_id)
# judge previously identified as BVAMHAWLEY
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]
=> [0, 0, 0]
# Nothing to do
vacolanek
css_id = "vacolanek"
judge_last_name = "Larkin"
user = User.find_by_css_id(css_id)
User.where("full_name like ?" , "%#{judge_last_name.upcase}%").count
=> 3
VACOLS::Staff.where(snamel: judge_last_name, svlj: "J").count
=> 1
judge_css_id = VACOLS::Staff.where(snamel: judge_last_name, svlj: "J").first.sdomainid
=> BVAMELARKIN
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]
=> [0, 0, 0]
# Nothing to do
vacomagilj
css_id = "vacomagilj"
judge_last_name = "Moshiashwili"
user = User.find_by_css_id(css_id)
# judge previously identified as BVAVMOSHI
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]
=> [0, 1, 0]
### legacy tasks
legacy_tasks.pluck(:id)
=> [539516]
legacy_tasks.update_all(assigned_by_id: judge.id)
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=> 0
vacomarrak
css_id = "vacomarrak"
judge_last_name = "Larkin"
user = User.find_by_css_id(css_id)
# judge previously identified as BVAMELARKIN
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]
=> [0, 0, 0]
# Nothing to do
vacomccord
css_id = "vacomccord"
judge_last_name = "Graham"
user = User.find_by_css_id(css_id)
# judge previously identified as BVAMCGRAHAM
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]
=> [0, 0, 0]
# Nothing to do
ajspotts
on 23 May 2020
@araposo-tistatech Closing this. We can open a new on if we get a new round from the board. However, we may want to hold off on manually reassigning tasks as any more users would be good test cases for testing inactive user features
hschallhorn
on 4 Jun 2020
For Support ticket INC11361382.
Re-assign inactive user tasks:
- VACOWHITEB1 to VLJ bvakmillikan
- VACOKILBRE to VLJ bvaaIshiz
- VACOshahn1 to VLJ bvaaIshiz
VACOWHITEB1
user = User.find_by_css_id("VACOWHITEB1".upcase)
judge = User.find_by_css_id("bvakmillikan".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 [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 3, 0]
legacy_tasks.pluck(:id)
=> [756670, 815111, 815112]
legacy_tasks.map{|t| t.appeal.treee}
# Only ColocatedTasks -- good
legacy_tasks.update_all(assigned_by_id: judge.id)
legacy_tasks.map{|t| t.appeal.reload.treee}
# Looks good
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=>0
VACOKILBRE
user = User.find_by_css_id("VACOKILBRE".upcase)
judge = User.find_by_css_id("bvaaIshiz".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 [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 2, 0]
legacy_tasks.pluck(:id)
=> [802265, 811596]
legacy_tasks.map{|t| t.appeal.treee}
# Hmmm. 1 FoiaTask:
┌────────────────────────────────────────────────────────────────────────┐
LegacyAppeal 1138469 (legacy) │ ID │ STATUS │ ASGN_BY │ ASGN_TO │ UPDATED_AT │
├── RootTask │ 784413 │ assigned │ │ Bva │ 2020-03-26 17:48:30 UTC │
└── FoiaColocatedTask │ 802265 │ on_hold │ VACOKILBRE │ PrivacyTeam │ 2020-04-02 18:01:57 UTC │
└── FoiaTask │ 802266 │ assigned │ VACOKILBRE │ PrivacyTeam │ 2020-04-02 18:01:57 UTC │
└────────────────────────────────────────────────────────────────────────┘
legacy_tasks.update_all(assigned_by_id: judge.id)
legacy_tasks.map{|t| t.appeal.reload.treee}
# Manually update FoiaTask
Task.where(id: 802266).update_all(assigned_by_id: judge.id)
legacy_tasks.map{|t| t.appeal.reload.treee}
# Looks good
ColocatedTask.open.where(assigned_by: user, appeal_type: LegacyAppeal.name).count
=>0
VACOshahn1
user = User.find_by_css_id("VACOshahn1".upcase)
judge = User.find_by_css_id("bvaaIshiz".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 [ama_tasks.count, legacy_tasks.count, legacy_cases.count]
=> [0, 0, 0]
# Nothing to reassign
Was this page helpful?
0 / 5 - 0 ratings
Related issues
araposo-tistatech
·
5Comments
laurjpeterson
·
5Comments
gnakm
·
5Comments
lomky
·
3Comments
lowellrex
·
5Comments