/[drupal]/contributions/modules/total_control/total_control_panes.inc
ViewVC logotype

Diff of /contributions/modules/total_control/total_control_panes.inc

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.2, Tue Apr 14 23:38:35 2009 UTC revision 1.3, Fri May 1 08:28:55 2009 UTC
# Line 8  Line 8 
8  function total_control_panels_render_admin_overview($something, $conf) {  function total_control_panels_render_admin_overview($something, $conf) {
9    $item = total_control_panels_content_types_data('admin_overview');    $item = total_control_panels_content_types_data('admin_overview');
10    $types = node_get_types('types');    $types = node_get_types('types');
11    $overview = array();    $overview_cnt = array();
12      $overview_usr = array();
13    
14    // Content Overview    // Content Overview
15    foreach ($types as $type => $object){    foreach ($types as $type => $object){
# Line 29  function total_control_panels_render_adm Line 30  function total_control_panels_render_adm
30        $line =  $total[$type];        $line =  $total[$type];
31        $line .= ($total[$type.'_comments'])? ' with ' . $total[$type.'_comments'] : '' ;        $line .= ($total[$type.'_comments'])? ' with ' . $total[$type.'_comments'] : '' ;
32        $line .= ($total[$type.'_comments_spam'])? ' (' . $total[$type.'_comments_spam'].')' : '' ;        $line .= ($total[$type.'_comments_spam'])? ' (' . $total[$type.'_comments_spam'].')' : '' ;
33        $overview[] = $line;        $overview_cnt[] = $line;
34      } // if type      } // if type
35    } // foreach    } // foreach
36    
# Line 38  function total_control_panels_render_adm Line 39  function total_control_panels_render_adm
39      $user_query = db_query("SELECT count(*) FROM {users}");      $user_query = db_query("SELECT count(*) FROM {users}");
40      $total['users_all'] = format_plural(db_result($user_query), '1 total user', '@count total users');      $total['users_all'] = format_plural(db_result($user_query), '1 total user', '@count total users');
41      $user_active_query = db_query("SELECT count(*) FROM {users} WHERE status = 1 AND login != 0");      $user_active_query = db_query("SELECT count(*) FROM {users} WHERE status = 1 AND login != 0");
42        $total['users_active'] = format_plural(db_result($user_active_query), '1 active', '@count active');
43        $user_block_query = db_query("SELECT count(*) FROM {users} WHERE status = 0");
44        $total['users_block'] = format_plural(db_result($user_block_query), '1 blocked', '@count blocked');
45        $overview_usr[] = $total['users_all'] . ' | ' . $total['users_active'] . ' | ' . $total['users_block'];
46      }
47    
48      // Roles Overview
49      $roles = user_roles(TRUE);
50      $total['users_roles'] = '';
51      foreach ($roles as $rid => $role){
52        if (($conf['roles'][$rid]) && $rid != 2){  // compare against roles option on pane config
53          $user_role_query = db_query("SELECT count(*) FROM {users} u INNER JOIN {users_roles} r on u.uid = r.uid WHERE r.rid = %d", $rid);
54          $total['users_role_'.$rid] .= format_plural(db_result($user_role_query), '1 user', '@count users');
55          $total['users_role_'.$rid] .= ' in role: '.$role;
56          $overview_usr[] = $total['users_role_'.$rid];
57        } // if not auth
58      } // foreach
59    
60      $content = '<strong>'.t('Content').'</strong>';
61      $content .= theme('item_list', $overview_cnt);
62      $content .= '<strong>'.t('Users').'</strong>';
63      $content .= theme('item_list', $overview_usr);
64      return total_control_panels_render($item['title'], $content);
65    }
66    
67    // User Overview
68    function total_control_panels_render_admin_users($something, $conf) {
69      $item = total_control_panels_content_types_data('admin_users');
70      $types = node_get_types('types');
71      $overview = array();
72    
73      // User Overview
74      if ($conf['user'] == 1){  // compare against user option on pane config
75        $user_query = db_query("SELECT count(*) FROM {users}");
76        $total['users_all'] = format_plural(db_result($user_query), '1 total user', '@count total users');
77        $user_active_query = db_query("SELECT count(*) FROM {users} WHERE status = 1 AND login != 0");
78      $total['users_active'] = format_plural(db_result($user_active_query), '1 active user', '@count active users');      $total['users_active'] = format_plural(db_result($user_active_query), '1 active user', '@count active users');
79      $user_block_query = db_query("SELECT count(*) FROM {users} WHERE status = 0");      $user_block_query = db_query("SELECT count(*) FROM {users} WHERE status = 0");
80      $total['users_block'] = format_plural(db_result($user_block_query), '1 blocked user', '@count blocked users');      $total['users_block'] = format_plural(db_result($user_block_query), '1 blocked user', '@count blocked users');
81      $overview[] = $total['users_all'] . ' | ' . $total['users_active'] . ' | ' . $total['users_block'];      $overview[] = $total['users_all'];
82        $overview[] = $total['users_active'];
83        $overview[] = $total['users_block'];
84    }    }
85    
86    // Roles Overview    // Roles Overview
# Line 60  function total_control_panels_render_adm Line 99  function total_control_panels_render_adm
99    return total_control_panels_render($item['title'], $content);    return total_control_panels_render($item['title'], $content);
100  }  }
101    
102    // Content Overview
103    function total_control_panels_render_admin_content($something, $conf) {
104      $item = total_control_panels_content_types_data('admin_content');
105      $types = node_get_types('types');
106      $overview = array();
107    
108      // Content Overview
109      foreach ($types as $type => $object){
110        if ($conf['types'][$type]){  // compare against type option on pane config
111          $type_query = db_query("SELECT count(*) FROM {node} WHERE type = '%s' and status = 1", $type);
112          $total[$type] = format_plural(db_result($type_query), '1 '.$type.' item', '@count '.$type.' items');
113    
114          if ($conf['comments'][$type]){ // compare against comment option on pane config
115            $comment_query = db_query("SELECT count(DISTINCT cid) FROM {comments} c INNER JOIN {node} n ON c.nid = n.nid WHERE n.type = '%s' and c.status = 1 AND n.status = 1", $type);
116            $total[$type.'_comments'] =  format_plural(db_result($comment_query), '1 comment', '@count comments');
117    
118            if ($conf['spam'] == 1){ // compare against comment option on pane config
119              $spam_query = db_query("SELECT count(DISTINCT c.cid) FROM {comments} c INNER JOIN {node} n ON c.nid = n.nid WHERE n.type = '%s' and c.status = 0 AND n.status = 1", $type);
120              $total[$type.'_comments_spam'] = format_plural(db_result($spam_query), '1 spam', '@count spam');
121            } // if spam
122          } // if comment
123    
124          $line =  $total[$type];
125          $line .= ($total[$type.'_comments'])? ' with ' . $total[$type.'_comments'] : '' ;
126          $line .= ($total[$type.'_comments_spam'])? ' (' . $total[$type.'_comments_spam'].')' : '' ;
127          $overview[] = $line;
128        } // if type
129      } // foreach
130    
131      $content = theme('item_list', $overview);
132      return total_control_panels_render($item['title'], $content);
133    }
134    
135  // Create Content  // Create Content
136  function total_control_panels_render_admin_create($something, $conf) {  function total_control_panels_render_admin_create($something, $conf) {
137    $item = total_control_panels_content_types_data('admin_create');    $item = total_control_panels_content_types_data('admin_create');
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.2