Changeset 1890

Timestamp:

Mar 11, 2007, 3:48:17 PM (17 years ago)

Author:

plg

Message:

New: history can be filtered on a user.

Location:

trunk

Files:

• admin/history.php (modified) (7 diffs)
• template/yoga/admin/history.tpl (modified) (1 diff)

trunk/admin/history.php

@@ -99 +99 @@
 
   $search['fields']['types'] = $_POST['types'];
+
+  $search['fields']['user'] = $_POST['user'];
   
   // echo '<pre>'; print_r($search); echo '</pre>';
@@ -169 +171 @@
 
   $page['search'] = unserialize($serialized_rules);
+
+  if (isset($_GET['user_id']))
+  {
+    if (!is_numeric($_GET['user_id']))
+    {
+      die('user_id GET parameter must be an integer value');
+    }
+
+    $page['search']['fields']['user'] = $_GET['user_id'];
+    
+    $query ='
+INSERT INTO '.SEARCH_TABLE.'
+  (rules)
+  VALUES
+  (\''.serialize($page['search']).'\')
+;';
+    pwg_query($query);
+
+    $search_id = mysql_insert_id();
+    
+    redirect(
+      PHPWG_ROOT_PATH.'admin.php?page=history&search_id='.$search_id
+      );
+  }
 
   // echo '<pre>'; print_r($page['search']); echo '</pre>';
@@ -218 +244 @@
     }
   }
+
+  if (isset($page['search']['fields']['user'])
+      and $page['search']['fields']['user'] != -1)
+  {
+    array_push(
+      $clauses,
+      'user_id = '.$page['search']['fields']['user']
+      );
+  }
   
   $clauses = prepend_append_array_items($clauses, '(', ')');
@@ -378 +413 @@
       continue;
     }
+
+    $user_string = '';
+    if (isset($username_of[$line['user_id']]))
+    {
+      $user_string.= $username_of[$line['user_id']];
+    }
+    else
+    {
+      $user_string.= $line['user_id'];
+    }
+    $user_string.= '&nbsp;<a href="';
+    $user_string.= PHPWG_ROOT_PATH.'admin.php?page=history';
+    $user_string.= '&amp;search_id='.$page['search_id'];
+    $user_string.= '&amp;user_id='.$line['user_id'];
+    $user_string.= '">+</a>';
     
     $template->assign_block_vars(
@@ -384 +434 @@
         'DATE'      => $line['date'],
         'TIME'      => $line['time'],
-        'USER'      => isset($username_of[$line['user_id']])
-          ? $username_of[$line['user_id']]
-          : $line['user_id']
-        ,
+        'USER'      => $user_string,
         'IP'        => $line['IP'],
         'IMAGE'     => isset($line['image_id'])
@@ -480 +527 @@
 
   $form['types'] = $page['search']['fields']['types'];
+
+  if (isset($page['search']['fields']['user']))
+  {
+    $form['user'] = $page['search']['fields']['user'];
+  }
+  else
+  {
+    $form['user'] = null;
+  }
 }
 else
@@ -523 +579 @@
     );
 }
+
+$template->assign_block_vars(
+  'user_option',
+  array(
+    'VALUE'=> -1,
+    'CONTENT' => '------------',
+    'SELECTED' => ''
+    )
+  );
+
+$query = '
+SELECT
+    '.$conf['user_fields']['id'].' AS id,
+    '.$conf['user_fields']['username'].' AS username
+  FROM '.USERS_TABLE.'
+  ORDER BY username ASC
+;';
+$result = pwg_query($query);
+
+while ($row = mysql_fetch_array($result))
+{
+  $selected = '';
+
+  if ($row['id'] == $form['user'])
+  {
+    $selected = 'selected="selected"';
+  }
+  
+  $template->assign_block_vars(
+    'user_option',
+    array(
+      'VALUE' => $row['id'],
+      'CONTENT' => $row['username'],
+      'SELECTED' => $selected,
+      )
+    );
+}
   
 // +-----------------------------------------------------------------------+

trunk/template/yoga/admin/history.tpl

@@ -62 +62 @@
   </label>
 
+  <label>
+    {lang:User}
+    <select name="user">
+      <!-- BEGIN user_option -->
+      <option value="{user_option.VALUE}" {user_option.SELECTED}>
+        {user_option.CONTENT}
+      </option>
+      <!-- END user_option -->
+    </select>
+  </label>
+
   <input class="submit" type="submit" name="submit" value="{lang:submit}" />
 </fieldset>