Advertisement
designbymerovingi

myCRED Manual Adjustments by Admin

Dec 1st, 2014
272
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.91 KB | None | 0 0
  1. /**
  2.  * Show Admins by Manual Adjustment
  3.  * Adds a list of administrators who have manually adjusted users
  4.  * myCRED Balance.
  5.  * @version 1.0
  6.  */
  7. add_action( 'mycred_overview_after', 'mycred_pro_manual_awards_by_admin' );
  8. function mycred_pro_manual_awards_by_admin() {
  9.  
  10.     global $wpdb;
  11.  
  12.     $mycred = mycred();
  13.  
  14.     // Sum up all manual adjustments and group them by admin id
  15.     $results = $wpdb->get_results( "
  16.         SELECT SUM( creds ) as total, ref_id as admin_id
  17.         FROM {$mycred->log_table}
  18.         WHERE ref = 'manual'
  19.         GROUP BY ref_id;" );
  20.  
  21.     if ( ! empty( $results ) ) {
  22.  
  23.         $total = 0;
  24.         foreach ( $results as $group )
  25.             $total = $total + $group->total;
  26.  
  27.         $url = add_query_arg( array( 'page' => 'myCRED', 'ref' => 'manual' ), admin_url( 'admin.php' ) );
  28.  
  29. ?>
  30. <div class="mycred-type clear">
  31.     <div class="module-title"><div class="type-icon"></div>Manual Adjustments<a href="<?php echo $url; ?>"><?php echo $mycred->format_creds( $total ); ?></a></div>
  32.     <div class="overview clear">
  33. <?php
  34.  
  35.         $all = count( $results );
  36.         $count = 0;
  37.         foreach ( $results as $group ) {
  38.  
  39.             $count ++;
  40.             $admin_user = get_userdata( $group->admin_id );
  41.             if ( ! isset( $admin_user->display_name ) )
  42.                 $admin_name = 'n/a';
  43.             else
  44.                 $admin_name = $admin_user->display_name;
  45.  
  46.             $style = 'margin-left: -1px;';
  47.             if ( $count == 1 )
  48.                 $style = '';
  49.  
  50.             if ( $all == 1 )
  51.                 $style .= ' width: 100%;';
  52.             elseif ( $all == 2 )
  53.                 $style .= ' width: 50%;';
  54.             elseif ( $all == 3 )
  55.                 $style .= ' width: 33%;';
  56.             else
  57.                 $style .= ' width: 25%;';
  58.  
  59.             $gain_url = add_query_arg( array( 'ref_id' => $group->admin_id ), $url );
  60.  
  61. ?>
  62.         <div class="section border" style="<?php echo $style; ?>">
  63.             <p><strong style="color:green;"><?php echo $admin_name; ?>:</strong> <a href="<?php echo $gain_url; ?>"><?php echo $mycred->format_creds( $group->total ); ?></a></p>
  64.         </div>
  65. <?php
  66.  
  67.         }
  68.  
  69.     }
  70.  
  71. ?>
  72.     </div>
  73. </div>
  74. <?php
  75.  
  76. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement