[Summary view] [Print] [Text view]

   1  <?php /* $Id: vw_usr.php 137 2008-04-04 16:12:02Z pedroix $ $URL: https://web2project.svn.sourceforge.net/svnroot/web2project/trunk/modules/admin/vw_usr.php $ */
   2  if (!defined('W2P_BASE_DIR')) {
   3      die('You should not access this file directly.');
   4  }
   5  $utypes = w2PgetSysVal('UserType');
   6  ?>
   7  <table cellpadding="2" cellspacing="1" border="0" width="100%" class="tbl">
   8  <tr>
   9      <th>
  10          &nbsp;
  11      </th>
  12      <?php if (w2PgetParam($_REQUEST, 'tab', 0) == 0) { ?>
  13      <th width="125">
  14                 <?php echo $AppUI->_('Login History'); ?>
  15      </th>
  16      <?php } ?>
  17      <th width="150">
  18          <a href="?m=admin&a=index&orderby=user_username" class="hdr"><?php echo $AppUI->_('Login Name'); ?></a>
  19      </th>
  20      <th>
  21          <a href="?m=admin&a=index&orderby=contact_last_name" class="hdr"><?php echo $AppUI->_('Real Name'); ?></a>
  22      </th>
  23      <th>
  24          <a href="?m=admin&a=index&orderby=user_type" class="hdr"><?php echo $AppUI->_('Type'); ?></a>
  25      </th>
  26      <th>
  27          <a href="?m=admin&a=index&orderby=company_name" class="hdr"><?php echo $AppUI->_('Company'); ?></a>
  28      </th>
  29      <th>
  30          <a href="?m=admin&a=index&orderby=dept_name" class="hdr"><?php echo $AppUI->_('Department'); ?></a>
  31      </th>
  32  </tr>
  33  <?php
  34  
  35  $perms = &$AppUI->acl();
  36  foreach ($users as $row) {
  37      if ($perms->isUserPermitted($row['user_id']) != $canLogin) {
  38          continue;
  39      }
  40  ?>
  41  <tr>
  42      <td width="30" align="center" nowrap="nowrap">
  43  <?php if ($canEdit) { ?>
  44          <table cellspacing="0" cellpadding="0" border="0">
  45          <tr>
  46              <td>
  47                  <a href="./index.php?m=admin&a=addedituser&user_id=<?php echo $row['user_id']; ?>" title="<?php echo $AppUI->_('edit'); ?>">
  48                      <?php echo w2PshowImage('icons/stock_edit-16.png', 16, 16, ''); ?>
  49                  </a>
  50              </td>
  51              <td>
  52                  <a href="?m=admin&a=viewuser&user_id=<?php echo $row['user_id']; ?>&tab=1" title="">
  53                      <img src="<?php echo w2PfindImage('obj/lock.gif'); ?>" width="16" height="16" border="0" alt="<?php echo $AppUI->_('edit permissions'); ?>" />
  54                  </a>
  55              </td>
  56              <td>
  57  <?php
  58          $user_display = addslashes($row['contact_first_name'] . ' ' . $row['contact_last_name']);
  59  
  60          $user_display = trim($user_display);
  61          if (empty($user_display))
  62              $user_display = $row['user_username'];
  63  ?>
  64                  <a href="javascript:delMe(<?php echo $row['user_id']; ?>, '<?php echo $user_display; ?>')" title="<?php echo $AppUI->_('delete'); ?>">
  65                      <?php echo w2PshowImage('icons/stock_delete-16.png', 16, 16, ''); ?>
  66                  </a>
  67              </td>
  68          </tr>
  69          </table>
  70  <?php } ?>
  71      </td>
  72      <?php if (w2PgetParam($_REQUEST, 'tab', 0) == 0) { ?>
  73      <td>
  74             <?php
  75          $q = new DBQuery;
  76          $q->addTable('user_access_log', 'ual');
  77          $q->addQuery('user_access_log_id, ( unix_timestamp( now( ) ) - unix_timestamp( date_time_in ) ) / 3600 as         hours, ( unix_timestamp( now( ) ) - unix_timestamp( date_time_last_action ) ) / 3600 as idle, if(isnull(date_time_out) or date_time_out =\'0000-00-00 00:00:00\',\'1\',\'0\') as online');
  78          $q->addWhere('user_id = ' . (int)$row['user_id']);
  79          $q->addOrder('user_access_log_id DESC');
  80          $q->setLimit(1);
  81          $user_logs = $q->loadList();
  82  
  83          if ($user_logs)
  84              foreach ($user_logs as $row_log) {
  85                  if ($row_log['online'] == '1') {
  86                      echo '<span style="color: green">' . $row_log['hours'] . ' ' . $AppUI->_('hrs.') . '( ' . $row_log['idle'] . ' ' . $AppUI->_('hrs.') . ' ' . $AppUI->_('idle') . ') - ' . $AppUI->_('Online');
  87                  } else {
  88                      echo '<span style="color: red">' . $AppUI->_('Offline');
  89                  }
  90              }
  91          else
  92              echo '<span style="color: grey">' . $AppUI->_('Never Visited');
  93          echo '</span>';
  94      } ?>
  95      </td>
  96      <td>
  97          <a href="./index.php?m=admin&a=viewuser&user_id=<?php echo $row['user_id']; ?>"><?php echo $row['user_username']; ?></a>
  98      </td>
  99      <td>
 100          <a href="mailto:<?php echo $row['contact_email']; ?>"><img src="<?php echo w2PfindImage('obj/email.gif'); ?>" width="16" height="16" border="0" alt="email" /></a>
 101  <?php
 102      if ($row['contact_last_name'] || $row['contact_first_name']) {
 103          echo $row['contact_first_name'] . ' ' . $row['contact_last_name'];
 104      } else {
 105          echo '<span style="font-style: italic">unknown</span>';
 106      }
 107  ?>
 108      </td>
 109      <td>
 110          <?php echo $utypes[$row['user_type']]; ?>
 111      </td>
 112      <td>
 113          <a href="./index.php?m=companies&a=view&company_id=<?php echo $row['contact_company']; ?>"><?php echo $row['company_name']; ?></a>
 114      </td>
 115      <td>
 116          <a href="./index.php?m=departments&a=view&dept_id=<?php echo $row['dept_id']; ?>"><?php echo $row['dept_name']; ?></a>
 117      </td>
 118  </tr>
 119  <?php } ?>
 120  
 121  </table>