source: extensions/AddUsersNotes/main.inc.php @ 32693

<?php
/*
Plugin Name: Add Users Notes
Version: auto
Description: Adds admin notes to users profiles
Plugin URI: http://piwigo.org/ext/extension_view.php?eid=580
Author: ddtddt
Author URI: 
*/

if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

global $prefixeTable;

// +-----------------------------------------------------------------------+
// | Define plugin constants                                               |
// +-----------------------------------------------------------------------+

define('USERNOTES_ID', basename(dirname(__FILE__)));
define('USERNOTES_PATH', PHPWG_PLUGINS_PATH.USERNOTES_ID.'/');

// init the plugin
add_event_handler('init', 'usernotes_init');

/**
 * plugin initialization
 *   - check for upgrades
 *   - load language
 */
function usernotes_init(){
  load_language('plugin.lang', USERNOTES_PATH);
    global $template;
  $template->assign(
    array(
         'USERNOTES_PATH2'=> get_root_url().USERNOTES_PATH,
    )
  );
}

add_event_handler('loc_begin_admin_page', 'usernotes_add_column');
function usernotes_add_column(){
  global $template;
        $template->set_prefilter('user_list', 'usernotes_add_column_prefilter');
}

function usernotes_add_column_prefilter($content){
  // add the "Notes" column in the user table
  $search = '<div class="selection-mode-group-manager" style="right:30px">';
  $replace = '{combine_script id="jquery.usersnotes" load=\'footer\' path="$USERNOTES_PATH2/js/usersnotes.js"}';
  $content = str_replace($search, $replace.$search, $content);
        
        
        
  // add the "Notes" column in the user table
  $search = '      <!-- email adress -->
      <div class="user-header-col user-header-email not-in-selection-mode">
        <span>{\'Email Adress\'|@translate}</span>
      </div>';
  $content = str_replace($search, $search.'<!-- Notes -->
    <div class="user-header-col user-header-notes">
       <span>{\'Notes\'|@translate}</th></span>
    </div>'
        , $content);

  // add the "Notes" 
  $search = '<div class="user-col user-container-registration">';
  $replace = '    <div class="user-col user-container-usernotes">
      <span><!-- usernotes --></span>
    </div>';
  $content = str_replace($search, $replace.$search, $content);

  // add the "Notes" field in user profile form
  $search = '<div class="user-property-group-container">
            <p class="user-property-label">{\'Groups\'|@translate}</p>
            <div class="user-property-select-container user-property-group">
              <select class="user-property-select" data-selectize="groups" placeholder="{\'Select groups or type them\'|translate}" 
                name="group_id[]" multiple style="box-sizing:border-box;"></select>
            </div>
          </div>';
  $replace = '<p class="user-property-label">{\'Notes\'|@translate}</p>
                  <div class="user-property-usernotes">
            <span class="usernotes-title"><!-- usernotes --></span>
                        <span class="edit-usernotes icon-pencil"></span>
          </div>
                  <div class="user-property-usernotes-change">
            <div class="summary-input-container">
              <input class="usernotes-property-input user-property-input-usernotes" value="" placeholder="{\'Notes\'|@translate}" />
            </div>
            <span class="icon-ok edit-usernotes-validate"></span>
            <span class="icon-cancel-circled edit-usernotes-cancel"></span>
          </div>
                  ';
  $content = str_replace($search, $search.$replace, $content);
  
  //css
    $search = '</style>';
  $replace = '
  .user-property-usernotes-change {
    justify-content:center;
    align-items:center;
    display:none;
    margin-bottom:25px;
  }
  
  .user-property-usernotes {
    margin-bottom:34px;
    height:30px;
}

.edit-usernotes-validate {
    display: block;
    margin: auto 5px;
    cursor: pointer;
    background-color: #ffa744;
    color: #3c3c3c;
    font-size: 17px;
    font-weight: 700;
    padding: 7px;
}

.edit-usernotes-validate:hover {
    background-color: #f70;
    color: #000;
    cursor: pointer;
}
.edit-usernotes {
    font-size:1.4em;
    cursor:pointer;
}
.edit-usernotes-cancel {
    cursor:pointer;
    font-size:22px;
    padding-top: 4px;
}
.usernotes-property-input {
    width: 100%;
    box-sizing:border-box;
    font-size:1.1em;
    padding:8px 16px;
    border:none;
}
.edit-usernotes-title {
    font-size:1.4em;
}
.usernotes-property-input.user-property-input-usernotes {
    border: solid 2px #ffa744;
    padding: 9px;
}
                  ';
  $content = str_replace($search, $replace.$search, $content);
    
  return $content;
}

add_event_handler('ws_invoke_allowed', 'usernotes_ws_users_setInfo', EVENT_HANDLER_PRIORITY_NEUTRAL, 3);
function usernotes_ws_users_setInfo($res, $methodName, $params){
  if ($methodName != 'pwg.users.setInfo'){
    return $res;
  }
  if (!isset($_POST['usernotes'])){
    return $res;
  }
  if (count($params['user_id']) == 0){
    return $res;
  }
  
  $updates = array();

  foreach ($params['user_id'] as $user_id){
    $updates[] = array(
      'user_id' => $user_id,
      'usernotes' => $_POST['usernotes'],
    );
  }
  if (count($updates) > 0){
    mass_updates(
      USER_INFOS_TABLE,
      array(
        'primary' => array('user_id'),
        'update'  => array('usernotes')
      ),
      $updates
    );
  }
  return $res;
}

add_event_handler('ws_users_getList', 'usernotes_ws_users_getList', EVENT_HANDLER_PRIORITY_NEUTRAL, 1);
function usernotes_ws_users_getList($users){
  $user_ids = array();
  foreach ($users as $user_id => $user){
    $user_ids[] = $user_id;
  }
  if (count($user_ids) == 0){
    return $users;
  }
  $query = '
    SELECT
      user_id,
      usernotes
    FROM '.USER_INFOS_TABLE.'
      WHERE user_id IN ('.implode(',', $user_ids).')
  ;';
  $result = pwg_query($query);
  while ($row = pwg_db_fetch_assoc($result)){
    $users[$row['user_id']]['usernotes'] = $row['usernotes'];
  }
  return $users;
}

?>