public static function getProjectTeamAssigned($projectId)
{
$db = Zend_Db_Table::getDefaultAdapter();
$sql = null;
$data = null;
if (ProNav_Auth::isEmployee()) {
$sql = "select u.user_id, u.firstname, u.lastname, c.name AS corporation_name, c.corporation_id\n FROM users u\n INNER JOIN corporations c ON c.corporation_id = u.corporation_id\n INNER JOIN project_users pu ON pu.user_id = u.user_id\n WHERE pu.project_id = ?;";
$data = $db->fetchAll($sql, $projectId);
} else {
/* Only get users from the projects done_for_workgroup (department) */
$sql = "SELECT u.user_id, u.firstname, u.lastname, c.name AS corporation_name, c.corporation_id \n FROM users u\n INNER JOIN corporations c ON u.corporation_id = c.corporation_id \n WHERE user_id IN (\n SELECT wu.user_id FROM workgroup_users wu\n INNER JOIN projects p ON p.done_for_workgroup = wu.workgroup_id\n INNER JOIN (select * from project_users where project_id = ?) pu ON pu.user_id = wu.user_id\n WHERE p.project_id = ?)";
$data = $db->fetchAll($sql, array($projectId, $projectId));
}
$users = array();
if (!$data) {
return $users;
}
foreach ($data as $row) {
$user = new Application_Model_User();
foreach ($row as $key => $value) {
$user->{$key} = $value;
}
$corp = new Application_Model_Corporation();
$corp->name = $user->corporation_name;
$corp->corporation_id = $user->corporation_id;
$user->Corporation = $corp;
$users[] = $user;
}
return $users;
}
private function getUsersForCorp($corporation_id)
{
$users = Application_Model_Corporations::GetUsers($corporation_id);
return ProNav_Utils::getSelectOptions($users, 'user_id', 'LFMI', ProNav_Auth::isEmployee() ? null : ProNav_Auth::getUserID());
}