Vote #63033
未完了"My Calendar" page to show assigned items (patch incl)
0%
説明
I think it would be good to have a "My Calendar" view similar to the project's Calendar (next to Gantt) that shows only the issues assigned to the user. The project Calendar shows info specific to the project, and the My Page Calendar snipped shows all issues in all projects. The new "My Calendar" page serves information not provided any other way.
BTW, I only added the translation to the en.yml file. Didn't know how that should be handled in all the other files.
journals
Here's the rhtml file for implementing the calendar page
--------------------------------------------------------------------------------
Thanks Carl. I'll try to modify the plugin API so that adding a new block for My page can be done without modifying MyController.
--------------------------------------------------------------------------------
Hi Carl,
Thanks for the patch. Have been using it and it works great.
I've made use of Jean-Philippe's improvements to the plugin API in trunk and packaged your patch as a plugin, ready for unzipping under {$Redmine}/vendor/plugins.
I also added the versions of the current user's projects in the calendar.
To be in check with the legal stuff: is the GPL license okay for you? Also okay to publish the plugin somewhere (e.g. redminehacks.org)?
--------------------------------------------------------------------------------
Sorry, didn't notice the comment.
Yes, GPL is ok. Publish the plugin is ok. Just give proper credit for the work.
--------------------------------------------------------------------------------
I've found a bug on my_calendar plugin.
If an user is not involved on any project (e.g. admin), if you click on my_calendar link you get an internal error.
<pre>
Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')))'
at line 1: SELECT `versions`.`id` AS t0_r0, `versions`.`project_id` AS t0_r1, `versions`.`name` AS t0_r2,
`versions`.`description` AS t0_r3, `versions`.`effective_date` AS t0_r4, `versions`.`created_on` AS t0_r5,
`versions`.`updated_on` AS t0_r6, `versions`.`wiki_page_title` AS t0_r7, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3,
`projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`projects_count` AS t1_r6, `projects`.`created_on` AS t1_r7, `projects`.`updated_on` AS t1_r8, `projects`.`identifier` AS t1_r9,
`projects`.`status` AS t1_r10 FROM `versions` LEFT OUTER JOIN `projects` ON `projects`.id =
`versions`.project_id WHERE ((effective_date BETWEEN '2008-07-27' AND '2008-09-06') and (project_id IN ()))
</pre>
That's because @project_id IN ()@ is not a valid SQL statement.
I suppose that Problem is on vendor/plugins/my_calendar/app/controllers/calendar_controller.rb, where retrieve_selected_tracker_ids, for not involved users, does not find anything.
Should be nice that:
* If the user is not involved on any project will be diplayed an empty calendar (or link is not displayed);
* (optional) If the user is admin, all Issues an Versions will be displayed.
By the way it's a useful plugin and i hope it become an official plugin asap.
Regards,
A.Maleci
--------------------------------------------------------------------------------
oops, forget to watch this issue. Just noticed the new comments last week.
Carl, thanks for your positive response. I've published the plugin on "redmine hacks":http://www.redminehacks.org/projects/show/mycalendar . If interested, I can add you to the project.
A first version is downloadable "here":http://www.redminehacks.org/projects/list_files/mycalendar
Andrea, the issue you discovered should be fixed now. Thanks for noticing. About the admin's projects scope to all projects: I think this shouldn't be default because an admin can act as a regular user too (i.e. he can be member of some projects but not all). On the other hand, adding a checkbox which sets the scope to all viewable projects for all users seems more interesting to me. I've added this as feature request # 6 at redmine hacks and will look into it.
--------------------------------------------------------------------------------
This is no longer available at Redmine Hacks: http://www.redminehacks.org/projects/show/mycalendar
Does anyone have a mirror location of the most up-to-date version of the plugin?
--------------------------------------------------------------------------------
Just wondering if this has gotten anywhere... Eric?
--------------------------------------------------------------------------------
+1. Very important feature.
--------------------------------------------------------------------------------