source: extensions/event_cats/admin/duplication.inc.php @ 4247

<?php

$t = read_ec_conf('reg_display');
if ($t == '0') $reg_display = array('0', '');
else $reg_display = explode(';', $t);

$template->assign('reg_display', $reg_display);
$template->assign('ec_conf', $ec_conf);






// A lot of below code has simply been copied-pasted from file cat_perm.php .
// Many thanks to people who wrote it !

// +-----------------------------------------------------------------------+
// |                          form construction                            |
// +-----------------------------------------------------------------------+

// groups denied are the groups not granted. So we need to find all groups
// minus groups granted to find groups denied.

$groups = array();

$query = '
SELECT id, name
  FROM '.GROUPS_TABLE.'
  ORDER BY name ASC
;';
$groups = simple_hash_from_query($query, 'id', 'name');
$template->assign('all_groups', $groups);

// groups granted to access the category
$query = "
SELECT `arg1`
  FROM ".EVNTCATS_TABLE."
  WHERE `code` IS NULL
    AND `arg1` IS NOT NULL
;";
$group_granted_ids = array_from_query($query, 'arg1');
$group_granted_ids = order_by_name($group_granted_ids, $groups);
$template->assign('group_granted_ids', $group_granted_ids);


// groups denied
$template->assign('group_denied_ids',
    order_by_name(array_diff(array_keys($groups), $group_granted_ids), $groups)
  );

// users...
$users = array();

$query = "
SELECT ".$conf['user_fields']['id']." AS id,
       ".$conf['user_fields']['username']." AS username
  FROM ".USERS_TABLE."
;";
$users = simple_hash_from_query($query, 'id', 'username');
$template->assign('all_users', $users);


$query = "
SELECT `arg2`
  FROM ".EVNTCATS_TABLE."
  WHERE `code` IS NULL
    AND `arg2` IS NOT NULL
;";
$user_granted_direct_ids = array_from_query($query, 'arg2');
$user_granted_direct_ids = order_by_name($user_granted_direct_ids, $users);
$template->assign('user_granted_direct_ids', $user_granted_direct_ids);



$user_granted_indirect_ids = array();
if (count($group_granted_ids) > 0)
{
  $granted_groups = array();

  $query = "
SELECT user_id, group_id
  FROM ".USER_GROUP_TABLE."
  WHERE group_id IN (".implode(',', $group_granted_ids).") 
";
  $result = pwg_query($query);
  while ($row = mysql_fetch_array($result))
  {
    if (!isset($granted_groups[$row['group_id']]))
    {
      $granted_groups[$row['group_id']] = array();
    }
    array_push($granted_groups[$row['group_id']], $row['user_id']);
  }

  $user_granted_by_group_ids = array();

  foreach ($granted_groups as $group_users)
  {
    $user_granted_by_group_ids = array_merge($user_granted_by_group_ids,
                                             $group_users);
  }
  $user_granted_by_group_ids = array_unique($user_granted_by_group_ids);
  
  
  $user_granted_indirect_ids = array_diff($user_granted_by_group_ids,
                                          $user_granted_direct_ids);
  $user_granted_indirect_ids = 
    order_by_name($user_granted_indirect_ids, $users);  
  foreach ($user_granted_indirect_ids as $user_id)
  {
    foreach ($granted_groups as $group_id => $group_users)
    {
      if (in_array($user_id, $group_users))
      {
        $template->append(
          'user_granted_indirects',
          array(
            'USER'=>$users[$user_id],
            'GROUP'=>$groups[$group_id]
            )
          );
        break;
      }
    }
  }
}

$user_denied_ids = array_diff(array_keys($users),
                              $user_granted_indirect_ids,
                              $user_granted_direct_ids);
$user_denied_ids = order_by_name($user_denied_ids, $users);
$template->assign('user_denied_ids', $user_denied_ids);












/* */


?>