acl(); $df = $AppUI->getPref('SHDATEFORMAT'); ?> addQuery('DISTINCT(pp.project_vid),pp.project_group,pp.project_id,pp.project_version,pp.project_vdate,pp.project_vdescription'); $q->addTable('passive_project_versions','pp'); $q->addJoin('user_projects','up','up.project_id = pp.project_id'); $q->addWhere('user_id = '.$AppUI->user_id); $pp = $q->loadList();//print_r($pp); $ar_pv = array(); foreach ($pp as $pv) { $vd = intval( @$pv['project_vdate'] ) ? new CDate( $pv['project_vdate'] ) : null; $ar_pv["g".$pv['project_group']."p".$pv['project_id']."v".$pv['project_version']] = array($vd?$vd->format($AppUI->getPref('SHDATEFORMAT')):"-",$pv['project_vdescription']); } $CR = "\n"; $CT = "\n\t"; $none = true; foreach ($projects as $row) { /*if (! $perms->checkModuleItem('projects', 'view', $row['project_id'])) {//non importa doverli rifiltrare... projects è già filtrato continue; }*/ if ($row["project_active"] < 1) { $none = false; $style = $row['project_current'] != '0'? 'background-color:#CEFFFF' :''; $end_date = intval( @$row["project_finish_date"] ) ? new CDate( $row["project_finish_date"] ) : null; $s = ""; $s .= ''; $s .= $CR . ''; $s .= $CR . ''; $s .= $CR . ''; $s .= $CR . ''; $s .= $CR . ''; if($show_all_projects){ $s .= $CR . ''; } $s .= $CR . ''; echo $s; } } if ($none) { echo $CR . ''; } ?>

_('sort by');?>:
_('Color');?>	_('Project Name');?>	_('Version Date');?>	_('Version Description');?>	_('Finish Date');?>	_('Target Budget');?>	_('Status'); ?>
'; $s .= $CT . '' . sprintf( "%.1f%%", CProject::getPr($row['project_id'] )) . ''; $s .= $CR . '	'; $s .= $CT . '' . htmlspecialchars( $row["project_name"], ENT_QUOTES ) . ''; $s .= $CR . '	' .($row['project_current'] != '0'? $ar_pv[$row['project_current']][0] :'-'). '	'.($row['project_current'] != '0'? $ar_pv[$row['project_current']][1] :'-').'	'. ($end_date ? $end_date->format( $df ) : '-') .'	'; $s .= $CR . $row['project_target_budget']." ".$dPconfig['currency_symbol']; $s .= $CR . '	';$ptypes = dPgetSysVal("ProjectStatus"); $s .= $CT . $row["project_status"] == 0 ? $AppUI->_('Not Defined') : $ptypes[$row["project_status"]]; $s .= $CR . '
' . $AppUI->_( 'No projects available' ) . '