| _('Name');?> |
_('Group');?> |
".$AppUI->_('Start Date')."";
echo "".$AppUI->_('Finish Date')." | ";
$df = $AppUI->getPref('SHDATEFORMAT');
}?>
_('Roles');?> |
|
$row["project_id"]) {
if ($a <> -1) {
?>
';
if ($canEdt) {
$buf .= "_('delete')."\">"
. dPshowImage( './images/icons/stock_delete-16.png', 16, 16, '' )
. "";
}
$buf .= '';
echo "$buf";
?>
|
checkModule('projects', 'view', null, $AppUI->user_groups[intval($row["project_group"])],1))
echo ''.$row["project_name"].'';
else
echo $row["project_name"];
?>
|
|
".($start_date ? $start_date->format( $df ) : '-')."";
echo "".($finish_date ? $finish_date->format( $df ) : '-')." | ";
}
?>
External";
else
echo $row["proles_name"]."
"; ?>
";
}
?>
|
';
if ($canEdt) {
$buf .= "_('delete')."\">"
. dPshowImage( './images/icons/stock_delete-16.png', 16, 16, '' )
. "";
}
$buf .= '';
echo "$buf";
?>
|
addTable('user_projects', 'uprol');
$q->addQuery('DISTINCT(p.project_id), p.project_name, group_name, group_id');
$q->addJoin('projects', 'p', "uprol.project_id = p.project_id");
$q->addJoin('groups', 'g', 'g.group_id = p.project_group');
$q->addWhere('project_active <> 0 ');
$q->addWhere('p.project_group IN ('.implode(',',array_keys($gsc)).')');
if (!is_null($pid)) $q->addWhere('p.project_id NOT IN ('.implode(',',$pid).')');
$q->addOrder('project_name');
$notProjects = $q->loadList();
//print_r($notProjects);
//print_r($gsc);
$sql = "
SELECT proles_id, proles_name
FROM project_roles
WHERE proles_status = 0
";
$rolesName = db_loadHashList( $sql ); //array(roles_id=>roles_name)
}
?>
|