| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.33.0 |
| Request #10951 | PEPr Activity Feed | ||
|---|---|---|---|
| Submitted: | 2007-05-06 10:22 UTC | ||
| From: | mj | Assigned: | mj |
| Status: | Wont fix | Package: | pearweb |
| PHP Version: | Irrelevant | OS: | Irrelevant |
| Roadmaps: | (Not assigned) | ||
[2007-05-06 10:22 UTC] mj
(Martin Jansen)
Description:
------------
I'm writing this down here so that I do not forget about it until I find time to implement it later:
We need a PEPr activity feed for individual proposals, which includes
* changes by the proposer
* comments
* votes
* status changes
This way people (including the proposer) being interested in a proposal can easily keep track of the progress.
Comments
[2007-05-06 10:58 UTC] mj
(Martin Jansen)
The attached SQL query captures all activity except for status changes. I should probably add a bit more logic in the last query part to get even more information about the vote into the comment field.
[2007-05-06 11:07 UTC] mj
(Martin Jansen)
Added revision of the SQL query that also includes status changes. This seems to become pretty massive regarding the database.
To-do: Make sure that all tables have a proper index configured and think about caching the result set.
[2007-05-06 11:59 UTC] mj
(Martin Jansen)
Added another revision of the patch, this time including some logic to auto-generate unique IDs for the feed entries.
[2007-05-06 13:30 UTC] mj
(Martin Jansen)
Added another query revision, this time with improved time stamp handling and more logic regarding vote values.
[2008-02-06 22:08 UTC] dufuz
(Helgi Þormar Þorbjörnsson)
Postponing until 1.19.0 unless Martin shows interest again to finish this work and commit it.
[2012-01-25 18:07 UTC] doconnor
(Daniel O'Connor)
-Status: Assigned
+Status: Wont fix
-Roadmap Versions: 1.19.0
+Roadmap Versions: