getPref('SHDATEFORMAT'); $q = new DBQuery; $q->addTable('projects'); $q->addQuery('project_id, project_name, project_start_date, project_finish_date, project_status, project_target_budget, project_start_date, project_priority'); $q->addWhere('projects.project_group = '.$company_id); $q->addWhere('projects.project_active <> 0'); $q->addOrder($sort); $s = ''; if (!($rows = $q->loadList())) { $s .= $AppUI->_( 'No data available' ).'
'.$AppUI->getMsg(); } else { $s .= ''; $s .= ''.$AppUI->_('P').'' .''.$AppUI->_( 'Name' ).'' .''.$AppUI->_( 'Start Date' ).'' .''.$AppUI->_( 'Finish Date' ).'' .''.$AppUI->_( 'Target Budget' ).'' .''.$AppUI->_( 'Status' ).'' .''; foreach ($rows as $row) { $start_date = new CDate( $row['project_start_date'] ); $finish_date = new CDate( $row['project_finish_date'] ); $s .= ''; $s .= ''; if ($row['project_priority'] < 0 ) { $s .= ""; } else if ($row["project_priority"] > 0) { $s .= ""; } $s .= ''; $s .= ''; $s .= ''.$row["project_name"].''; $s .= ''.$start_date->format( $df ).''; $s .= ''.$finish_date->format( $df ).''; $s .= ''.$row["project_target_budget"]." ".$dPconfig["currency_symbol"].''; $s .= ''.$AppUI->_($pstatus[$row["project_status"]]).''; $s .= ''; } } echo '' . $s . ''; ?>