🎩 What? Why?

This PR fixes some bugs with the notifications:

• If a resource is being moderated, the resource is still being sent in the digest notification
• If a comment is being moderated, is still being sent in digest
• If a resource is being deleted by the owner, then that resource is still being visible in the digest notification
• If a resource is being deleted by the owner, then that resource is still being visible in notifications panel
• If a resource belongs to an unpublished component, is being sent

📌 Related Issues

Link your PR to an issue

• Related to #?
• Fixes Empty notifications digest email #12234

Testing

The main idea is to create a simulation on what is happening when an user that follows a space receives a notification email for a resources that has been moderated? That resource should not be sent via email.

1. Go to your rails console and type in Decidim::Notification.delete_all
2. In same console type: Decidim::User.first.update_attribute(:digest_sent_at, nil)
3. On a browser login as admin
4. On another browser login as user
5. Make sure both users are following the space
6. Create a resource ( ex proposal )
7. Add 3 comments as user
8. As user delete a comment
9. As admin moderate a comment
10. One leave untouched
11. Console type: Decidim::Notification.update_all(created_at: 30.hours.ago) - you should have 3 records
12. In terminal type bin/rails decidim:mailers:notifications_digest_daily
13. After a while, see your digest contain all 3 notifications
14. Apply patch
15. In console type: Decidim::User.first.update_attribute(:digest_sent_at, nil)
16. In terminal type bin/rails decidim:mailers:notifications_digest_daily
17. After a while, see your digest contain 1 notification

Scenario 2:

1. On a browser login as admin
2. On another browser login as user
3. Make sure both users are following the space
4. Create a resource ( ex proposal )
5. Add 3 comments as user
6. As admin click "hide from menu"
7. then on the proposal component again click "unpublish"
8. As user the user notifications page
9. See the notification generated in the unpublished space is still visible
10. Apply patch
11. See the notification disappeared

📷 Screenshots

Please add screenshots of the changes you are proposing

♥️ Thank you!