Projects scalability and Support enhancements

Projects

I've added caching to the tree handling in projects, this should (after initial load) make adding new projects or rescheduling/otherwise editing old ones much faster, also the cost/price cache rebuild code has been optimized a bunch, making saves in complex task trees much faster

The tree cache affects hour reporting as well.

Also added link from hour reporting to task editor (for project managers) that allows quicker rescheduling of tasks

The cache needs some actions to activate (along with latest CVS version of OpenPSA)

  • Create snippetdir /OpenPSA_Cache to the target sitegroup (the same snippetdir is also used by Support module config-cache, owner must be __Nemein.Net User.
  • Create snippet Projects-Treelinearized to said snippetdir
  • edit my.cnf and add/change variable max_allowed_packet to have value of 1G (we won't be spending it all, but we also do not want to go back to tweak this after we have figured that there is something fishy going on with the cache), remember to restart MySQL.

In the works is a lighter user interface for the projects view (search based), which avoids loading the huge amounts of data that the full GANTT view sends, this should make the projects module nicer to use when not in local network with the OpenPSA server

Support

Major enhancement is "new mail" notify, if a ticket has been changed since it has been last loaded to editor ("seen") then it's flagged with an envelope icon, old tickets (untill first edited) will all have this icon since they do not have the seen flag set

Reporting interface now has variables to control the CSV output

Tickets have Email CC support, the email import of CC header is somewhat flaky (doesn't like quoted names for example) at the moment, but will be improved.

Note import (to existing ticket) will also now save the sender email/name (and CC but it's not used for anything yet...) and display that in stead of the username of the account used for import

Trashed tickets are now automatically deleted by the archival routines (if closed more than 30 days ago

Reporting interface will see some enhancements in the near future

In case I've forgotten to mention it earlier there is a cache for support configuration data, which with complex configurations (lots of types,subtypes etc) speed up the support significantly, create snippet /OpenPSA_Cache/Support-Config to activate it

Design by Inventive Design and powered by Midgard CMS.