[Summary view] [Print] [Text view]

   1  <?php /* $Id: vw_active.php 113 2008-03-21 16:11:42Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/companies/vw_active.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  ##
   7  ##    Companies: View Projects sub-table
   8  ##
   9  global $AppUI, $company_id, $pstatus, $w2Pconfig;
  10  
  11  $sort = w2PgetParam($_GET, 'sort', 'project_name');
  12  if ($sort == 'project_priority') {
  13      $sort .= ' DESC';
  14  }
  15  
  16  $df = $AppUI->getPref('SHDATEFORMAT');
  17  
  18  $q = new DBQuery;
  19  $q->addTable('projects', 'pr');
  20  $q->addQuery('pr.project_id, project_name, project_start_date, project_status, project_target_budget, project_start_date, project_priority, contact_first_name, contact_last_name');
  21  $q->leftJoin('users', 'u', 'u.user_id = pr.project_owner');
  22  $q->leftJoin('contacts', 'con', 'u.user_contact = con.contact_id');
  23  $q->addWhere('pr.project_company = ' . (int)$company_id);
  24  
  25  include_once ($AppUI->getModuleClass('projects'));
  26  $projObj = new CProject();
  27  $projObj->setAllowedSQL($AppUI->user_id, $q, null, 'pr');
  28  
  29  $q->addWhere('pr.project_active = 1');
  30  $q->addOrder($sort);
  31  $s = '';
  32  
  33  if (!($rows = $q->loadList())) {
  34      $s .= $AppUI->_('No data available') . '<br />' . $AppUI->getMsg();
  35  } else {
  36      $s .= '<tr>';
  37      $s .= '<th><a style="color:white" href="index.php?m=companies&a=view&company_id=' . $company_id . '&sort=project_priority">' . $AppUI->_('P') . '</a></th>' .
  38          '<th><a style="color:white" href="index.php?m=companies&a=view&company_id=' . $company_id . '&sort=project_name">' . $AppUI->_('Name') . '</a></th>' . '<th>' . $AppUI->_('Owner') . '</th>' . '<th>' .
  39          $AppUI->_('Started') . '</th>' . '<th>' . $AppUI->_('Status') . '</th>' . '<th>' . $AppUI->_('Budget') . '</th>' . '</tr>';
  40      foreach ($rows as $row) {
  41          $start_date = new CDate($row['project_start_date']);
  42          $s .= '<tr>';
  43          $s .= '<td>';
  44          if ($row['project_priority'] < 0) {
  45              $s .= '<img src="' . w2PfindImage('icons/priority-' . -$row['project_priority'] . '.gif') . '" width=13 height=16>';
  46          } elseif ($row["project_priority"] > 0) {
  47              $s .= '<img src="' . w2PfindImage('icons/priority+' . $row['project_priority'] . '.gif') . '" width=13 height=16>';
  48          }
  49  
  50          $s .= '</td>';
  51          $s .= '<td width="100%">';
  52          $s .= '<a href="?m=projects&a=view&project_id=' . $row['project_id'] . '">' . $row['project_name'] . '</a></td>';
  53          $s .= '<td nowrap="nowrap">' . $row['contact_first_name'] . '&nbsp;' . $row['contact_last_name'] . '</td>';
  54          $s .= '<td nowrap="nowrap">' . $start_date->format($df) . '</td>';
  55          $s .= '<td nowrap="nowrap">' . $AppUI->_($pstatus[$row['project_status']]) . '</td>';
  56          $s .= '<td nowrap="nowrap" align="right">' . $w2Pconfig['currency_symbol'] . $row['project_target_budget'] . '</td>';
  57          $s .= '</tr>';
  58      }
  59  }
  60  echo '<table cellpadding="2" cellspacing="1" border="0" width="100%" class="tbl">' . $s . '</table>';
  61  ?>