[Summary view] [Print] [Text view]

   1  <?php /* $Id: vw_companies.php 113 2008-03-21 16:11:42Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/companies/vw_companies.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  global $search_string;
   7  global $owner_filter_id;
   8  global $currentTabId;
   9  global $currentTabName;
  10  global $tabbed;
  11  global $type_filter;
  12  global $orderby;
  13  global $orderdir;
  14  
  15  // load the company types

  16  
  17  $types = w2PgetSysVal('CompanyType');
  18  // get any records denied from viewing

  19  
  20  $obj = new CCompany();
  21  $allowedCompanies = $obj->getAllowedRecords($AppUI->user_id, 'company_id, company_name');
  22  
  23  $company_type_filter = $currentTabId;
  24  //Not Defined

  25  $companiesType = true;
  26  if ($currentTabName == 'All Companies') {
  27      $companiesType = false;
  28  }
  29  if ($currentTabName == 'Not Applicable') {
  30      $company_type_filter = 0;
  31  }
  32  
  33  // retrieve list of records

  34  $q = new DBQuery;
  35  $q->addTable('companies', 'c');
  36  $q->addQuery('c.company_id, c.company_name, c.company_type, c.company_description, count(distinct p.project_id) as countp, count(distinct p2.project_id) as inactive, con.contact_first_name, con.contact_last_name');
  37  $q->addJoin('projects', 'p', 'c.company_id = p.project_company AND p.project_active = 1');
  38  $q->addJoin('users', 'u', 'c.company_owner = u.user_id', 'inner');
  39  $q->addJoin('contacts', 'con', 'u.user_contact = con.contact_id', 'inner');
  40  $q->addJoin('projects', 'p2', 'c.company_id = p2.project_company AND p2.project_active = 0');
  41  if (count($allowedCompanies) > 0) {
  42      $q->addWhere('c.company_id IN (' . implode(',', array_keys($allowedCompanies)) . ')');
  43  } else {
  44      $q->addWhere('0=1');
  45  }
  46  if ($companiesType) {
  47      $q->addWhere('c.company_type = ' . (int)$company_type_filter);
  48  }
  49  if ($search_string != '') {
  50      $q->addWhere('c.company_name LIKE "%'.$search_string.'%"');
  51  }
  52  if ($owner_filter_id > 0) {
  53      $q->addWhere('c.company_owner = '.$owner_filter_id);
  54  }
  55  $q->addGroup('c.company_id');
  56  $q->addOrder($orderby . ' ' . $orderdir);
  57  $rows = $q->loadList();
  58  ?>
  59  <table width="100%" border="0" cellpadding="2" cellspacing="1" class="tbl">
  60  <tr>
  61      <th nowrap="nowrap">
  62          <a href="?m=companies&orderby=company_name" class="hdr"><?php echo $AppUI->_('Company Name'); ?></a>
  63      </th>
  64      <th nowrap="nowrap">
  65          <a href="?m=companies&orderby=countp" class="hdr"><?php echo $AppUI->_('Active Projects'); ?></a>
  66      </th>
  67      <th nowrap="nowrap">
  68          <a href="?m=companies&orderby=inactive" class="hdr"><?php echo $AppUI->_('Archived Projects'); ?></a>
  69      </th>
  70      <th nowrap="nowrap">
  71          <a href="?m=companies&orderby=company_type" class="hdr"><?php echo $AppUI->_('Type'); ?></a>
  72      </th>
  73  </tr>
  74  <?php
  75  $s = '';
  76  $none = true;
  77  foreach ($rows as $row) {
  78      $none = false;
  79      $s .= '<tr>';
  80      $s .= '<td>' . (trim($row['company_description']) ? w2PtoolTip($row['company_name'], $row['company_description']) : '') . '<a href="./index.php?m=companies&a=view&company_id=' . $row['company_id'] . '" >' . $row['company_name'] . '</a>' . (trim($row['company_description']) ? w2PendTip() : '') . '</td>';
  81      $s .= '<td width="125" align="right" nowrap="nowrap">' . $row['countp'] . '</td>';
  82      $s .= '<td width="125" align="right" nowrap="nowrap">' . $row['inactive'] . '</td>';
  83      $s .= '<td align="left" nowrap="nowrap">' . $AppUI->_($types[$row['company_type']]) . '</td>';
  84      $s .= '</tr>';
  85  }
  86  echo $s;
  87  if ($none) {
  88      echo '<tr><td colspan="5">' . $AppUI->_('No companies available') . '</td></tr>';
  89  }
  90  ?>
  91  </table>