order by project name in time record
Page: 1
Recent posts in this topic
Pro
ideamarket
on May 26. 2008. 3:31 pm
Hello,
In the "quick add" popup under "Time Record" the project drop down seems to be ordered by project id, how can I change that to order by project name? what file do I have to edit?
In the "quick add" popup under "Time Record" the project drop down seems to be ordered by project id, how can I change that to order by project name? what file do I have to edit?
Staff
Ilija Studen
on May 27. 2008. 3:04 am
Thanks for reporting this - we'll have it covered in v1.1.1. If you want it covered now open ProjectUsers.class.php located in /activecollab/application/modules/system/models/project_users and find following lines:
They are around line 326. Replace them with:
if($statuses === null) {
$rows = db_execute_all("SELECT $project_users_table.*, $projects_table.name AS 'project_name', $projects_table.leader_id AS 'project_leader' FROM $projects_table, $project_users_table WHERE $projects_table.id = $project_users_table.project_id AND $projects_table.type = ? AND $project_users_table.user_id = ?", PROJECT_TYPE_NORMAL, $user->getId());
} else {
$rows = db_execute_all("SELECT $project_users_table.*, $projects_table.name AS 'project_name', $projects_table.leader_id AS 'project_leader' FROM $projects_table, $project_users_table WHERE $projects_table.id = $project_users_table.project_id AND $projects_table.type = ? AND $projects_table.status IN (?) AND $project_users_table.user_id = ?", PROJECT_TYPE_NORMAL, $statuses, $user->getId());
} // ifThey are around line 326. Replace them with:
if($statuses === null) {
$rows = db_execute_all("SELECT $project_users_table.*, $projects_table.name AS 'project_name', $projects_table.leader_id AS 'project_leader' FROM $projects_table, $project_users_table WHERE $projects_table.id = $project_users_table.project_id AND $projects_table.type = ? AND $project_users_table.user_id = ? ORDER BY $projects_table.name", PROJECT_TYPE_NORMAL, $user->getId());
} else {
$rows = db_execute_all("SELECT $project_users_table.*, $projects_table.name AS 'project_name', $projects_table.leader_id AS 'project_leader' FROM $projects_table, $project_users_table WHERE $projects_table.id = $project_users_table.project_id AND $projects_table.type = ? AND $projects_table.status IN (?) AND $project_users_table.user_id = ? ORDER BY $projects_table.name", PROJECT_TYPE_NORMAL, $statuses, $user->getId());
} // if
activeCollab Team Member
