function myProjects()
{
$oView = CreateObject('dcl.boView');
$oView->numrows = 5;
$oView->table = 'dcl_projects';
$oView->style = 'report';
$oView->title = STR_PRJ_MYPRJ;
$oView->AddDef('columnhdrs', '', array(STR_CMMN_ID, STR_PRJ_LEAD, STR_PRJ_STATUS, STR_PRJ_NAME));
$oView->AddDef('columns', '', array('projectid', 'reportto.short', 'statuses.name', 'dcl_projects.name'));
$oView->AddDef('filternot', 'statuses.dcl_status_type', '2');
$oView->AddDef('filter', 'dcl_projects.reportto', $GLOBALS['DCLID']);
$oView->AddDef('order', '', array('dcl_projects.name'));
$oTable = CreateObject('dcl.htmlTable');
foreach ($oView->columnhdrs as $sColumn) {
if ($sColumn == STR_PRJ_NAME) {
$oTable->addColumn($sColumn, 'html');
} else {
$oTable->addColumn($sColumn, 'string');
}
}
$oTable->setShowRownum(false);
$oTable->setCaption($oView->title);
$oTable->setWidth('100%');
$oTable->addToolbar(menuLink('', 'menuAction=htmlProjects.show&filterReportto=' . $GLOBALS['DCLID']), STR_CMMN_VIEWALL);
$oDB = new dclDB();
$oDB->LimitQuery($oView->GetSQL(), 0, 5);
$aData = $oDB->FetchAllRows();
for ($i = 0; $i < count($aData); $i++) {
$aData[$i][3] = '<a href="' . menuLink('', 'menuAction=boProjects.viewproject&project=' . $aData[$i][0]) . '">' . $aData[$i][3] . '</a>';
}
$oTable->setData($aData);
if (count($oTable->aData) > 0) {
if ($this->bHasOutput) {
$oTable->setSpacer(true);
} else {
$this->bHasOutput = true;
}
$oTable->render();
}
}
