[Sommaire] [Imprimer]

   1  <?php
   2  include_once  'includes/init.php';
   3  include_once  'includes/site_extras.php';
   4  $PAGE_SIZE = 25;
   5  print_header();
   6  
   7  echo "<h3>" . translate("Activity Log") . "</h3>\n";
   8  
   9  echo "<a title=\"" . translate("Admin") . "\" class=\"nav\" href=\"adminhome.php\">&laquo;&nbsp;" . translate("Admin") . "</a><br /><br />\n";
  10  
  11  echo "<table>\n";
  12  echo "<tr><th class=\"usr\">\n" .
  13    translate("User") . "</th><th class=\"cal\">\n" .
  14    translate("Calendar") . "</th><th class=\"scheduled\">\n" .
  15    translate("Date") . "/" . translate("Time") . "</th><th class=\"dsc\">\n" .
  16    translate("Event") . "</th><th class=\"action\">\n" .
  17    translate("Action") . "\n</th></tr>\n";
  18  $sql = "SELECT webcal_entry_log.cal_login, webcal_entry_log.cal_user_cal, " .
  19    "webcal_entry_log.cal_type, webcal_entry_log.cal_date, " .
  20    "webcal_entry_log.cal_time, webcal_entry.cal_id, " .
  21    "webcal_entry.cal_name, webcal_entry_log.cal_log_id " .
  22    "FROM webcal_entry_log, webcal_entry " .
  23    "WHERE webcal_entry_log.cal_entry_id = webcal_entry.cal_id ";
  24  $startid = getIntValue ( 'startid', true );
  25  if ( ! empty ( $startid ) )
  26    $sql .= "AND webcal_entry_log.cal_log_id <= $startid ";
  27  $sql .= "ORDER BY webcal_entry_log.cal_log_id DESC";
  28  $res = dbi_query ( $sql );
  29  
  30  $nextpage = "";
  31  
  32  if ( $res ) {
  33    $num = 0;
  34    while ( $row = dbi_fetch_row ( $res ) ) {
  35      $num++;
  36      if ( $num > $PAGE_SIZE ) {
  37        $nextpage = $row[7];
  38        break;
  39      } else {
  40      echo "<tr";
  41          if ( $num % 2 ) {
  42              echo " class=\"odd\"";
  43          }
  44      echo "><td>\n" .
  45          $row[0] . "</td><td>\n" .
  46          $row[1] . "</td><td>\n" . 
  47          date_to_str ( $row[3] ) . "&nbsp;" .
  48          display_time ( $row[4] ) . "</td><td>\n" . 
  49          "<a title=\"" .
  50          htmlspecialchars($row[6]) . "\" href=\"view_entry.php?id=$row[5]\">" .
  51          htmlspecialchars($row[6]) . "</a></td><td>\n";
  52        if ( $row[2] == $LOG_CREATE )
  53          etranslate("Event created");
  54        else if ( $row[2] == $LOG_APPROVE )
  55          etranslate("Event approved");
  56        else if ( $row[2] == $LOG_REJECT )
  57          etranslate("Event rejected");
  58        else if ( $row[2] == $LOG_UPDATE )
  59          etranslate("Event updated");
  60        else if ( $row[2] == $LOG_DELETE )
  61          etranslate("Event deleted");
  62        else if ( $row[2] == $LOG_NOTIFICATION )
  63          etranslate("Notification sent");
  64        else if ( $row[2] == $LOG_REMINDER )
  65          etranslate("Reminder sent");
  66        else
  67          echo "???";
  68        echo "\n</td></tr>\n";
  69      }
  70    }
  71    dbi_free_result ( $res );
  72  } else {
  73    echo translate("Database error") . ": " . dbi_error ();
  74  }
  75  ?>
  76  </table><br />
  77  <div class="navigation">
  78  <?php
  79  //go BACK in time
  80  if ( ! empty ( $nextpage ) ) {
  81    echo "<a title=\"" . 
  82        translate("Previous") . "&nbsp;$PAGE_SIZE&nbsp;" . 
  83      translate("Events") . "\" class=\"prev\" href=\"activity_log.php?startid=$nextpage\">" . 
  84        translate("Previous") . "&nbsp;$PAGE_SIZE&nbsp;" . 
  85      translate("Events") . "</a>\n";
  86  }
  87  
  88  if ( ! empty ( $startid ) ) {
  89    $previd = $startid + $PAGE_SIZE;
  90    $res = dbi_query ( "SELECT MAX(cal_log_id) FROM " .
  91      "webcal_entry_log" );
  92    if ( $res ) {
  93      if ( $row = dbi_fetch_row ( $res ) ) {
  94        if ( $row[0] <= $previd ) {
  95          $prevarg = '';
  96        } else {
  97          $prevarg = "?startid=$previd";
  98        }
  99        //go FORWARD in time
 100        echo "<a title=\"" . 
 101        translate("Next") . "&nbsp;$PAGE_SIZE&nbsp;" . 
 102      translate("Events") . "\" class=\"next\" href=\"activity_log.php$prevarg\">" . 
 103        translate("Next") . "&nbsp;$PAGE_SIZE&nbsp;" . 
 104      translate("Events") . "</a><br />\n";
 105      }
 106      dbi_free_result ( $res );
 107    }
 108  }
 109  ?>
 110  </div>
 111  <?php print_trailer(); ?>
 112  </body>
 113  </html>