Changeset 4247 for extensions/event_cats/admin/duplication.inc.php

Timestamp:

Nov 10, 2009, 10:20:34 PM (14 years ago)

Author:

LucMorizur

Message:

[Event Cats] Continue duplication management using cat_perm.php and cat_perm.tpl codes

File:

• extensions/event_cats/admin/duplication.inc.php (modified) (1 diff)

extensions/event_cats/admin/duplication.inc.php

@@ -8 +8 @@
 $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);
+
+
+
+
+
+
+
+
+
+
+
+
+/* */
+
+
 ?>