Pin Projects

avatar adamld Pro Nov 19. 2007. 8:04 pm #1
Since the Active Projects display on the Dashboard is currently not very useful, it would be great to be able to Pin a project from the actual project page.

Because if you have over 1300 projects, as we do, you have 130 pages of projects to sort through and thus currently we cannot use the Pin Projects feature at all.

Also, if changes are to be made to Active Projects, or the Dashboard at all, can we please take into consideration the following requests:

Annoucements box, with ability to put HTML links, and also choose which Clients receive these notifications (Clients, not user by User).
Modular design, can remove Active Projects box if wanted, to show more Recent Activities.

And finally, if the Active Projects box must remain, it should be broken up logically like Sorted by Date, and instead of Page numbers, 26 Letters of the Alphabet so you can simply list all projects starting with A, D, O etc.

Only then, can Pinning projects become useful for those who have more than a handful of projects (most corporate AC users).
avatar adamld Pro Nov 19. 2007. 8:59 pm #2
I got one of our inhouse developers to help me out until there is an official update, for those who want to make the Active Projects page more useful:

To change how many Active Projcets are displayed on the Dashboard:

Edit /activecollab\application\modules\system\controllers\DashboardController.class.php
Line: 42

$per_page = 10; // change number to anything

This allows the Recent Activities section to come into view (many of our users missed it completely).

Now, it was too much work to change the Page numbers method to an Alphabet method, I'll let the AC team work on that. So I at least changed it to sort by Created_On date instead of Alphabetically, and then made the sort Descending so newest first.

Edit /activecollab/application/modules/system/models/projects/Projects.class.php
Lines: 79-87

instead of ORDER BY name" change it to ORDER BY created_on DESC"

code:

          $rows = db_execute_all("SELECT id FROM $projects_table WHERE type = ? AND status IN (?) ORDER BY created_on DESC", PROJECT_TYPE_NORMAL, $statuses);
        } else {
          $rows = db_execute_all("SELECT id FROM $projects_table WHERE type = ? ORDER BY created_on DESC", PROJECT_TYPE_NORMAL);
        } // if
      } else {
        if($statuses) {
          $rows = db_execute_all("SELECT $projects_table.id FROM $projects_table, $project_users_table WHERE $project_users_table.user_id = ? AND $project_users_table.project_id = $projects_table.id AND $projects_table.type = ? AND $projects_table.status IN (?) ORDER BY $projects_table.created_on DESC", $user->getId(), PROJECT_TYPE_NORMAL, $statuses);
        } else {
          $rows = db_execute_all("SELECT $projects_table.id FROM $projects_table, $project_users_table WHERE $project_users_table.user_id = ? AND $project_users_table.project_id = $projects_table.id AND $projects_table.type = ? ORDER BY $projects_table.created_on DESC", $user->getId(), PROJECT_TYPE_NORMAL);
avatar adamld Pro Nov 19. 2007. 9:01 pm #3
FYI this now means you can create a new Project, and then Pin it, as previously finding a project to Pin from the Active Projects page was needle in haystack scenario.