[Summary view] [Print] [Text view]

   1  <?php /* $Id: vw_archived.php 63 2008-02-29 18:51:13Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/companies/vw_archived.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  ##
   7  ##    Companies: View Archived Projects sub-table
   8  ##
   9  
  10  global $AppUI, $company_id;
  11  
  12  $q = new DBQuery;
  13  $q->addTable('projects', 'pr');
  14  $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');
  15  $q->leftJoin('users', 'u', 'u.user_id = pr.project_owner');
  16  $q->leftJoin('contacts', 'con', 'u.user_contact = con.contact_id');
  17  $q->addWhere('pr.project_company = ' . (int)$company_id);
  18  
  19  include_once ($AppUI->getModuleClass('projects'));
  20  $projObj = new CProject();
  21  $projObj->setAllowedSQL($AppUI->user_id, $q, null, 'pr');
  22  
  23  $q->addWhere('pr.project_active = 0');
  24  $q->addOrder('project_name');
  25  $s = '';
  26  
  27  if (!($rows = $q->loadList())) {
  28      $s .= $AppUI->_('No data available') . '<br />' . $AppUI->getMsg();
  29  } else {
  30      $s .= '<tr>' . '<th>' . $AppUI->_('Name') . '</td>' . '<th>' . $AppUI->_('Owner') . '</td>' . '</tr>';
  31  
  32      foreach ($rows as $row) {
  33          $s .= '<tr><td>';
  34          $s .= '<a href="?m=projects&a=view&project_id=' . $row['project_id'] . '">' . $row['project_name'] . '</a>';
  35          $s .= '<td>' . $row['contact_first_name'] . '&nbsp;' . $row['contact_last_name'] . '</td>';
  36          $s .= '</tr>';
  37      }
  38  }
  39  echo '<table cellpadding="2" cellspacing="1" border="0" width="100%" class="tbl">' . $s . '</table>';
  40  ?>