home *** CD-ROM | disk | FTP | other *** search
/ Chip 2004 April / CMCD0404.ISO / Software / Freeware / Programare / dotproject / modules / companies / vw_active.php < prev    next >
Encoding:
PHP Script  |  2003-09-09  |  1.6 KB  |  46 lines
  1. <?php /* COMPANIES $Id: vw_active.php,v 1.15 2003/09/09 07:57:00 gregorerhardt Exp $ */
  2. ##
  3. ##    Companies: View Projects sub-table
  4. ##
  5. GLOBAL $AppUI, $company_id, $pstatus, $dPconfig;
  6.  
  7. $df = $AppUI->getPref('SHDATEFORMAT');
  8.  
  9. $sql = "
  10. SELECT project_id, project_name, project_start_date, project_status, project_target_budget,
  11.     project_start_date,
  12.     users.user_first_name, users.user_last_name
  13. FROM projects
  14. LEFT JOIN users ON users.user_id = projects.project_owner
  15. WHERE project_company = $company_id
  16.     AND project_active <> 0
  17. ORDER BY project_name
  18. ";
  19.  
  20. $s = '';
  21.  
  22. if (!($rows = db_loadList( $sql, NULL ))) {
  23.     $s .= $AppUI->_( 'No data available' ).'<br />'.$AppUI->getMsg();
  24. } else {
  25.     $s .= '<tr>';
  26.     $s .= '<th>'.$AppUI->_( 'Name' ).'</th>'
  27.         .'<th>'.$AppUI->_( 'Owner' ).'</th>'
  28.         .'<th>'.$AppUI->_( 'Started' ).'</th>'
  29.         .'<th>'.$AppUI->_( 'Status' ).'</th>'
  30.         .'<th>'.$AppUI->_( 'Budget' ).'</th>'
  31.         .'</tr>';
  32.     foreach ($rows as $row) {
  33.         $start_date = new CDate( $row['project_start_date'] );
  34.         $s .= '<tr>';
  35.         $s .= '<td width="100%">';
  36.         $s .= '<a href="?m=projects&a=view&project_id='.$row["project_id"].'">'.$row["project_name"].'</a></td>';
  37.         $s .= '<td nowrap="nowrap">'.$row["user_first_name"].' '.$row["user_last_name"].'</td>';
  38.         $s .= '<td nowrap="nowrap">'.$start_date->format( $df ).'</td>';
  39.         $s .= '<td nowrap="nowrap">'.$AppUI->_($pstatus[$row["project_status"]]).'</td>';
  40.         $s .= '<td nowrap="nowrap" align="right">'.$dPconfig["currency_symbol"].$row["project_target_budget"].'</td>';
  41.         $s .= '</tr>';
  42.     }
  43. }
  44. echo '<table cellpadding="2" cellspacing="1" border="0" width="100%" class="tbl">' . $s . '</table>';
  45. ?>
  46.