Issue of Issues - Githubissues

Outstanding Issues

[x] Issue: county_cases_new_claimed_closed_ego report from materialized view
[x] Issue: county_cases_new_claimed_closed_omni report from materialized view
[ ] Issue: Show currently locked phone number. Add unlock and mark complete button on phone interface. Add new status. Add mark complete phone number feature
[ ] Issue: Replace carriage returns and new lines in notes with a space when downloading CSVs. Also double-quote field notes in case there are quotes in the notes. /n and /r values create messed up CSVs.
[x] Issue: Phone volunteers can't see which organization has claimed a case if they are lds and the claiming organization is also lds. Makes it hard to advocate in their behalf. Maybe make the link click able to reveal the organization? Or maybe just show it?
[ ] Issue: Document phone problems so we're not surprised by them next time
[x] Issue: get user states to work for filters, etc.
[x] Issue: make phone volunteer contact info appear on chat: Does not work on Chrome sometimes
[x] Issue: we definitely have the edge condition where a case is closed, and we need to re-open it and unclaim it. We don't currently have a good way to do that. We might change the "request" feature to allow volunteers to request it be unclaimed instead of just transferred.
[x] Issue: UI goes wacky after adding volunteer hours... or something
[x] Issue: Add web, fb, twitter links in "Other Organizations". Have Dan regularly check those and amplify.
[x] Issue: Ask for a button deleting all whitelisted IPs
[ ] Issue: Advocate Button. This person needs help NOW!
[x] Issue: Make Chat permanently open
[ ] Issue: Record all outgoing text messages and emails. Right now we only record confirmations and not monitored alerts
[x] Issue: All Ian sites won't download.
[ ] Issue: Calldown doesn't load the case sometimes
[x] Issue: Scripts aren't always showing.
[x] Issue: The flag icon (move location, etc.) doesn't work in Phone mode, only works in Work mode.
[ ] Issue: System is putting in the wrong names and phone numbers for phone.
[ ] Issue: worksite_worksites_data, worksite_survivor_tokens, worksite_wwtsp, worksite_work_types_teams, worksite_worksites_merges, worksite_worksites_notes, worksite_wwtsp, phone_outbound are not invalidated when their worksite is invalidated.
[ ] Issue: The reports and pew-pew aren't getting updated nightly like they should.
[x] Issue: user_invitation.token duplicates still being created
[ ] Issue: Duplicate organization_organizations_incidents requests automatically created for each work_type
[x] Issue: erroneously invalidated wwwtsp values, cannot be claimed
[ ] Issue: Closed cases should be removed from phone_outbound/ invalidated
[x] Issue: Biggest frustration for phone volunteers re-loading the map each time. Any possible way to not do that?
[x] Issue: When searching in table view, and selecting the result, it takes you right back to the map. D'oh!
[x] Issue: I entered accidentally entered a case in Fiona and it asked me if it should have been in Ian and I selected yes. After the case saved, though, it was still in Fiona. I had to move over several cases from Fiona to Ian. (I have been dot-watching and there have been a few each day).
[ ] Issue: Add a site-wide banner with a site-banner CMS tag.
[x] Issue: Add auto search for FAQs tagged with faq-phone on the phone chat. Return those as you type to avoid unnecessary messages.
[ ] Issue: Add call status for "asking about text message/ whether they have a case/ confirming"
[ ] Issue: FYI had a callback where the caller had a case already linked to that phone number but the callback prompt did not indicate that as connected even tho they were the same phone number.
[ ] Issue: Add a Phone System-like History button to the Work page. Also Add chat to work, and see what happens.
[ ] Issue: The Request Access is not working
[ ] Issue: Donate button on home page
[x] Issue: Create Issue from Rob Fudge
[x] Issue: No save buttons on mobile
[x] Issue: Outbound call has volunteer's number. Big deal.
[x] Issue: Training area mentioned in 2:11 of the youtube tutorial. Need to add this back.
[x] Issue: everytime I click the button to start taking calls, the same name and case comes up. She has already spoken to 2 people and her number has come up as a call back 4 times for me.
[ ] Issue: Add "updated case" alert
[ ] Leaderboard: Sorting by online status, number of calls, organization.
[ ] Issue: Add Unclaim from the QR Code
[x] Issue: If you unclaim a case, it invalidates the wwwtsp, leaving no valid wwwtsps at all, and suddenly nobody can claim anything at all. The work types all literally disappear. I've known that something was happening, but I couldn't figure it out until now. I think this might also be related to the existing valid work type error.
[ ] Issue: ability to search in the search bar by phone number? i believe that would have been super helpful for a lot of people who "lost track" of the case they were just working on but have the phone number.

[ ] Issue: Exclude invalid cases from count.

SELECT COUNT(id), 'total_cases'
FROM worksite_worksites
WHERE incident_id = 254

UNION ALL

SELECT COUNT(id), 'total_valid_cases'
FROM worksite_worksites
WHERE incident_id = 254
AND invalidated_at IS NULL;
-- We should return total_valid_cases

[ ] Bug: user_users.last_login, last_sign_in_at, current_sign_in_at are all blank.
[ ] Bug: Request access does not work in Samsung Chrome, can't select org to join
[ ] Bug: unclaimed addresses not redacted for VOAD/ situational awareness. I'm pretty sure they should be.
[ ] Bug: The issue was that I was putting in information and after I had put some in the survivor was confirming his phone number and it was different so I fixed it and notice the name was different so I corrected that. I thought that maybe it pulled up somebody that may have lived there. After saving it I notice other things were marked that needed help with that I did not mark and it had a case number that would have gone in about a month ago. The address is at a trailer park and so I believe that when I put in the address (without the lot #) it opened up the other persons case and I ended up overriding it with this new survivor. Is there a way to see the original name and phone number from that case #? X1998
[ ] Bug: I don't really need help, just want to make you aware of some broken links on your site. The google search gives an opportunity to view the history of the organization, which led to a dead link for me. At the bottom of the current about page, there is a bullet at the bottom of links that states "about.ccu_story," where I was also hoping to find history for a report, but it is not linked to anything. Just wanted you to be aware in case this wasn't on your radar!
[ ] Feature: Sort by date of claim and completion.
[ ] Feature: Add ghost_created_by, ghost_updated_by on worksite_worksites_users_time
[ ] Feature: Privacy Features: Sell or don't sell declaration. Do not sell link. Citizen be able to opt out or delete data. Add an affidavit that the person. Access and deletion may be verified. For do not sell, you are not allowed to verify.
[ ] Feature: Text worksite details to volunteers

Database Issues

Bug: organization_organizations_groups does not have an updated_at trigger
Bug: incident_incidents.created_at should be with time zone
Bug: event_events_logs.created_at and .updated_at should be default NOW()
Feature: Add core_flags.invalidated_at for whenever you take a flag away.
Feature: Add location_locations.invalidated_at to completely remove an old location.
Feature: Postgres 11 on Staging
Feature: Implement history tables for any table without invalidated_at

Other Issues

Could not reproduce: Updated https://crisiscleanup.org/s/y6wis03d and got a CORS Missing Allow Origin error. API timeout. https://crisiscleanup.org/s/0apxdagc
Bug: When I open crisiscleanup.org after having closed my browser and restarted my computer, I didn't need to log in again. That seems like a security flaw.
Bug: TS Beta Table view does not load, or even to pretend to load in FF.
Bug: Incident Count in "Other Organizations" always says 1
Bug: We need server-side validation on email invitations. Copying and pasting extra characters like "<" or names does not filter out.
Bug: If unclaimed, and user changes the status to "Open, unassigned", do not claim the case for the organization.
Bug: Changing the org_role as admin does not invalidate the previous role. Each organization should have just one role. This may change in the future, but for now we'll keep it this way.
Bug: Other Organizations: Scroll page, not table.
Bug: Emails for reports are not populating
Bug: Users are able to register for a second organization, even though he they have a current user account.
Bug: 1. Log in as someone else. 2. Log out, then log back in as admin. 3. Click "Work." Bug: "Filters" does not work, FF
Bug: Chrome 85.0.4183.102 64 bit, Windows 10.: Filters doesn't work. New Cases "x" does not work.
Bug: Hovering over a user's name in Chrome does NOT display their name and contact information; just name and an "email" icon.
Bug: Delta-Laura-Marco X2690. Someone attached a photo to it, which was included in the PDF file. However, a. The system did not compress the file, and b. For some reason the system included at least 5 copies of the image on top of itself, turning this work order into a 50MB behemoth, instead of the 45KB file below after I deleted the image. We'll put that on our bug list.
Clear indicator that I'm on phone on every page.
Need a "Dismiss" and "Skip Call": Then tell me that I'll still get the call and need to press 0, and they won't be called.
Bug: https://www.crisiscleanup.org/incident/211/cases/new Table View is not working.
Bug: Add general ticket for Chrome: No loading, and no filters. New users.
Bug: Hurricane Sally color is different in different browser tabs. (See images below)
Bug: @Braden Mars Reed reports that the first three calls successive calls this morning dropped after he pressed 1. The call would say it is connecting, but just never connect. The first successful connection occurred at about 10:30am Central. He also gave us a clue about what might be happening with the Locked Phone Number problem (multiple calls to the same person). We know that you need to close out the phone call in Beta for it to unlock. However, Reed reports that sometimes the number in Beta is NOT the number that he's stuck on, and he needs click through two or three numbers in beta to close out the correct phone number to unlock.
Bug: @Tobi Abiodun Also, whenever he refreshes the page, he would go back to Hurricane Hanna, instead of Sally, even if Sally was the current incident. I'm pretty sure that user.states is not updating the default incident. (#1013)
Bug: I've had several people say that they are getting calls from a 202 number, which I just wrote off until I realized that the AWS caller ID is actually a 202 number. And not our 800 number or even the 601 number. Is there any way we can fix that? And incidentally, all 202 calls are blocked on my phone, so even after it went to VM and I did not press 1 to accept, I was still online. It should have gone offline.
Bug: We started having challenges with the search API yesterday but haven't been able to pin down the issue. For example, we noticed that a search for "Aaron Titus" will return me, but "Aaron Titu" will not. I suspect that issue has the same root cause. I'll put this on our to-do list.
User question: You are the second person to ask about what the calls/ days means. It means "The survivor has called three times in the past two days," and is not an indication of the number of times we have called back. We'll look into clarifying that meaning.
The work order number SOMETIMES populates after the person starts talking OR we have to add their name and part of an address before it is recognized. As I recall, early on, the system USED to indicate the existence of a work order much sooner.
Bug: I am doing callbacks. Caller states they called 1 time. We called them back and created workorder. Now I am calling again. Somehow the number isn't getting deleted after we return the call. It has happened to me 4 times in 2 days, which isn't that much, but I feel like I'm bothering them. Is this what the "4 calls/ 3 days ago" means? Should I bypass a cal if it says that? Moved to: CrisisCleanup/crisiscleanup-3-web#1068
Bug: @Braden Mars I just got a call from Reed. He clicks "Skip Call," and the system immediately sends him another call. He clicks "Skip Call" again, and the system immediately sends him another call. He repeated this four times before the system placed him in an "Offline" state and the calls stopped coming.
Bug: Reed reports another bug with the recent changes. He answered a call. While he was on the call, the center of the screen went blank. E.g. the center of the screen went white, but the top of the screen and the navigation bar still appeared. He completed the phone call, but had to click the Work button in order to enter the case. He clicked the Work button, and then back to the Phone button. When he returned to the phone system, the call did not appear in his most recent call list. Immediately thereafter, the phone system called the same lady again.
Bug: Move Organizations does not work. See image below.
Bug: "Charles Severs" returns result, but "Charles Sever" Does not
Bug: move worksite icon does not work
Bug: Filter, "History," and random buttons are not working for Chrome.
Bug: When an organization is not "Active," users can still log in and do everything. We should design what they see if the organization is not active.
Bug: no new or redeploy alerts since 9/12. In messages?
Feature: Add my Layers for "Layers", and for filters as well. Multi select is OR
Feature: When clicking "Profile," do not require user to click the yellow pencil icon to edit. Just edit the profile directly.
Feature: Title of each CCU page should be different, e.g. "Admin Dashboard: Crisis Cleanup," "Hurricane Sally Work: Crisis Cleanup," "Phone: Crisis Cleanup," Etc.
Feature: Add age of case
Feature: Add Crisis Cleanup client legal release, plus the organizational release on to the printed incident.
Feature: change email, user initiated
Feature: General stats: My organization
Feature: Add filters by date: Created at or updated_at. Slide through the time, and shows where the areas are most damaged.
Feature: Add a "Troubleshooting" section with "Reset User States" button and "Reset Settings and Favorites" in profile. This would allow users to click a button to manually destroy their user_users.states and user_users.preferences for troubleshooting purposes. Include description.
Feature: Add reports events to new table. Once complete, let me know and I will manually reconstruct all of the previous report views from email alerts
Feature: Invite to an affiliate or group organization
Feature: Find case by team/ team lead
Feature: Find team by case
Feature: Add ghost users to team
Feature: Create multi-stake team
Feature: Allow any stake to approve orgs from other deployed stake to the same incident.
Feature: Multi stake command center
Feature: Allow create teams for any affiliated organization
Feature: Hover on case to get case number on the map.
Feature: Turn off reports emails
Feature: Disable features for specific organizations. E.g. Disable the "Claim and Save" button for 2-1-1s.
Feature: Forward https://www.crisiscleanup.org/donate to https://www.paypal.com/paypalme/crisiscleanup
Feature: Make it easier to close out cases on phone.
Feature: 1. Add survivor release to sign. 2. If organization release is not null, add that, plus release for Crisis Cleanup, LLC. Use strings, printCase.homeowner_release_title, printCase.homeowner_release_text, printCase.signature
Feature: Add demo login information in a prominent location on Dev
Feature: Add Request Access modal bug to cases
Feature: /request_access Success Modal: Your request has been sent to {requested_to} at {organization}. Anyone from {organization} may approve the request. Please contact this person directly and encourage them to approve access quickly. Error: variables are not populating. Include screenshot.
Feature: If organization is marked not active, then anyone from that organization who logs in is redirected to the home page with an error, "Your organization is not currently active. If this is an error, please send an email to help@crisiscleanup.org." (info.login_org_inactive)

Images Filter Error:

Try to Move to New Organization Fail: Try to move to new org fail

Time Mismatch: "4 hours ago" should be "Just now." But we're keying off Eastern time instead of UTC. Problems

Random Incident colors, instead of the set color in incident_incidents.color: Sally Color 1 Sally Color 2 Sally Color 3

CrisisCleanup / crisiscleanup-4-web

Issue of Issues #126