[Summary view] [Print] [Text view]

   1  <?php /* $Id: vw_contacts.php 141 2008-04-05 16:41:20Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/departments/vw_contacts.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  
   6  global $dept_id, $dept, $company_id;
   7  ?>
   8  
   9  <table border="0" cellpadding="2" cellspacing="1" width="100%" class="tbl">
  10  <?php
  11  echo '<tr><th>' . $AppUI->_('Name') . '</th><th>' . $AppUI->_('Email') . '</th><th>' . $AppUI->_('Telephone') . '</th></tr>';
  12  
  13  $q = new DBQuery;
  14  $q->addTable('contacts', 'con');
  15  $q->addQuery('contact_id, con.contact_first_name');
  16  $q->addQuery('con.contact_last_name, contact_email, contact_phone');
  17  $q->addWhere('contact_department = ' . (int)$dept_id);
  18  $q->addWhere('(contact_owner = ' . (int)$AppUI->user_id . ' OR contact_private = 0)');
  19  $q->addOrder('contact_first_name');
  20  $contacts = $q->loadHashList('contact_id');
  21  
  22  $s = '';
  23  foreach ($contacts as $contact_id => $contact_data) {
  24      $s .= '<tr><td><a href="./index.php?m=contacts&a=view&contact_id=' . $contact_data['contact_id'] . '">' . $contact_data['contact_first_name'] . ' ' . $contact_data['contact_last_name'] . '</a></td>';
  25      $s .= '<td>' . $contact_data['contact_email'] . '</td>';
  26      $s .= '<td>' . $contact_data['contact_phone'] . '</td></tr>';
  27  }
  28  echo $s;
  29  echo '
  30  <tr><td colspan="3" align="right" valign="top" style="background-color:#ffffff">
  31  <input type="button" class="button" value="' . $AppUI->_('new contact') . '" onclick="javascript:window.location=\'./index.php?m=contacts&a=addedit&company_id=' . $company_id . '&company_name=' . $dept['company_name'] . '&dept_id=' . $dept['dept_id'] . '&dept_name=' . $dept['dept_name'] . '\'">
  32  </td></tr>
  33  </table>';
  34  ?>