Changeset 4263 for extensions/event_cats/include

Timestamp:

Nov 14, 2009, 12:45:42 AM (14 years ago)

Author:

LucMorizur

Message:

[Event Cats] Continue duplication management

Location:

extensions/event_cats/include

Files:

• ec_conf.inc.php (modified) (2 diffs)
• evntcats_main_funcs.inc.php (modified) (7 diffs)

extensions/event_cats/include/ec_conf.inc.php

@@ -40 +40 @@
     => '10',              // automatically
                           // 
-  'reg_display'           // the way the "register" link is displayed,
-    => '0',               // together with the original $lang value for this
-                          // label
+  'duplic_gen'            // whether Generic accounts allow to be duplicated
+    => '0',               //
+                          // 
+  'duplic_type'           // the kind of account type (Contacts, Friends,
+    => '0',               // Family) allowed to duplicate account
                           // 
   'howto'                 // whether the small aknowledgement message has
@@ -78 +80 @@
 if (!$v) {
   $ec_conf = array_values($ec_conf_default);
-  change_ec_conf('activated', $u);
+  change_ec_conf('activated', $u); // writes in the DB
 }
 // now :

extensions/event_cats/include/evntcats_main_funcs.inc.php

@@ -33 +33 @@
 
 include_once(EVNTCATS_PATH.'include/ec_conf.inc.php');
+
+if (!isset($ec_lists)) {
+  $ec_lists               = array();
+  $ec_lists['add_pages']  = array();
+  $ec_lists['categories'] = array();
+  $ec_lists['user_ids']   = array();
+  $ec_lists['ec_table']   = array();
+}
 
 // +-----------------------------------------------------------------------+
@@ -163 +171 @@
 
 /*
+ * build_ec_addp()
+ * builds $ec_lists['add_pages'].
+ *
+ * @param
+ *   (no parameter)
+ * @return
+ *   (no return value)
+ */
+function build_ec_addp() {
+  global $ec_lists, $ec_ap_ok;
+  if ($ec_ap_ok) {
+    $res = pwg_query("SELECT `id`, `title` FROM `".ADD_PAGES_TABLE."`");
+    while ($r = mysql_fetch_assoc($res)) {
+      $c = (is_in($r['title'], '/user_id=')) ? '/user_id=' : '/group_id=';
+      $a = explode($c ,$r['title']);
+      $ec_lists['add_pages'][$r['id']] = $a[0];
+    }
+  }
+}
+
+/*
  * build_ec_categories($dsp)
  * builds $ec_lists['categories'].
@@ -183 +212 @@
 
 /*
+ * build_ec_userids()
+ * builds $ec_lists['user_ids'].
+ *
+ * @param
+ *   (no parameter)
+ * @return
+ *   (no return value)
+ */
+function build_ec_userids() {
+  global $ec_lists, $conf;
+  $ec_lists['user_ids'] = simple_hash_from_query("
+    SELECT
+      ".$conf['user_fields']['id']." AS id,
+      ".$conf['user_fields']['username']." AS username
+    FROM `".USERS_TABLE."`
+    WHERE id > 2;",
+    'id', 'username'
+  );
+}
+
+/*
  * build_ec_table()
  * builds a table showing the content of the <pwg>_event_cats database table,
@@ -195 +245 @@
 function build_ec_table() {
   global $ec_lists, $ec_ap_ok;
-  
-  $ec_lists['ec_table'] = array();
   
   $q = pwg_query("
@@ -276 +324 @@
   global $ec_ap_ok, $template, $ec_lists, $conf;
   
-  $ec_lists = array();
-
   // Construction of $ec_lists['add_pages'] array var
-  $ec_lists['add_pages'] = array();
-  if ($ec_ap_ok) {
-    $res = pwg_query("SELECT `id`, `title` FROM `".ADD_PAGES_TABLE."`");
-    while ($r = mysql_fetch_assoc($res)) {
-      $c = (is_in($r['title'], '/user_id=')) ? '/user_id=' : '/group_id=';
-      $a = explode($c ,$r['title']);
-      $ec_lists['add_pages'][$r['id']] = $a[0];
-    }
-  }
+  build_ec_addp();
   
   // Construction of $ec_lists['categories'] array var
@@ -293 +331 @@
   
   // Construction of $ec_lists['user_ids'] array var
-  $ec_lists['user_ids'] = array();
-  $q = pwg_query("
-    SELECT
-      ".$conf['user_fields']['id']." AS id,
-      ".$conf['user_fields']['username']." AS username
-    FROM `".USERS_TABLE."`
-    WHERE id > 2
-  ");
-  while ($r = mysql_fetch_assoc($q))
-   $ec_lists['user_ids'][$r['id']] = $r['username'];
+  build_ec_userids();
   
   // Construction of $ec_lists['ec_table'] array var
@@ -308 +337 @@
 }
 
+// +-----------------------------------------------------------------------+
+// | Duplication analysis functions                                        |
+// +-----------------------------------------------------------------------+
+
+/*
+ * build_dup_arrays($append_tpl = false)
+ * builds arrays telling which accounts are allowed to display a duplicate
+ * account link. Returns an array of all the user ids allowed to duplicate.
+ *
+ * @param
+ *   $append_tpl : tells if $template must be appended with built arrays
+ * @return
+ *   (no return value)
+ */
+function build_dup_arrays($append_tpl = false) {
+  global $template, $ec_lists, $conf, $ec_debug;
+  
+  if (count($ec_lists['user_ids']) == 0) build_ec_userids();
+  
+  // A lot of below code has simply been copied from file cat_perm.php .
+  // Many thanks to people who wrote it !
+  
+  $groups = simple_hash_from_query("
+    SELECT `id`, `name`
+      FROM `".GROUPS_TABLE."`
+      ORDER BY `name` ASC;
+    ",
+    'id', 'name'
+  );
+  
+  // groups granted to duplication
+  $group_granted_ids = order_by_name(
+    array_from_query("
+      SELECT `arg2`
+        FROM ".EVNTCATS_TABLE."
+        WHERE `code` IS NULL
+          AND `arg1` = '1'
+          AND `arg2` IS NOT NULL
+      ;",
+      'arg2'
+    ),
+    $groups
+  );
+  
+  // users directly granted to duplication
+  $users_granted_direct_ids = order_by_name(
+    array_from_query("
+      SELECT `arg2`
+        FROM ".EVNTCATS_TABLE."
+        WHERE `code` IS NULL
+          AND `arg1` = '2'
+          AND `arg2` IS NOT NULL
+      ;",
+      'arg2'
+    ),
+    $ec_lists['user_ids']
+  );
+  
+  // Calculate users granted to duplication thanks to belonging to a
+  // certain group (in groups, level (friends, family, contacts),
+  // or user status (generic))
+  $user_granted_ids = array();
+
+  $users_granted_thks_gen_ids = array();
+  if (read_ec_conf('duplic_gen') != '0') {
+    $users_granted_thks_gen_ids = order_by_name(
+      array_diff(
+        array_from_query("
+          SELECT `user_id`
+          FROM `".USER_INFOS_TABLE."`
+          WHERE `status` = 'generic';",
+          'user_id'
+        ),
+        $users_granted_direct_ids
+      ),
+      $ec_lists['user_ids']
+    );
+    foreach ($users_granted_thks_gen_ids as $user_id)
+     $user_granted_ids[$user_id] = l10n('user_status_generic');
+  } global $ec_debug; $ec_debug['1'] = $user_granted_ids;
+
+  $users_granted_thks_types_ids = array();
+  $c = intval(read_ec_conf('duplic_type'));
+  if ($c != 0) {
+    $t = array();
+    if (($c & 1) != 0) $t[] = '1';
+    if (($c & 2) != 0) $t[] = '2';
+    if (($c & 4) != 0) $t[] = '4';
+    if (count($t) > 0) {
+      $types = array(
+        '1' => l10n('Level 1'),
+        '2' => l10n('Level 2'),
+        '4' => l10n('Level 4'),
+      );
+      $user_granted_from_type = array();
+      $result = pwg_query("
+        SELECT `user_id`, `level`
+        FROM `".USER_INFOS_TABLE."`
+        WHERE `level` IN (".implode(',', $t).");
+      ");
+      while ($row = mysql_fetch_array($result)) {
+        if (!isset($user_granted_from_type[$row['level']])) {
+          $user_granted_from_type[$row['level']] = array();
+        }
+        $user_granted_from_type[$row['level']][] = $row['user_id'];
+      }
+      $user_granted_by_type_ids = array();
+      foreach ($user_granted_from_type as $type_users)
+       $user_granted_by_type_ids = array_merge(
+        $user_granted_by_type_ids,
+        $type_users
+       );
+      $users_granted_thks_types_ids = order_by_name(
+        array_diff(
+          array_unique($user_granted_by_type_ids),
+          $users_granted_direct_ids
+        ),
+        $ec_lists['user_ids']
+      );
+      foreach ($users_granted_thks_types_ids as $user_id)
+       foreach ($user_granted_from_type as $type_id => $type_users) {
+        if (in_array($user_id, $type_users)) {
+          $user_granted_ids[$user_id]= $types[$type_id];
+          break;
+        }
+       }
+    }
+  } $ec_debug['2'] = $user_granted_ids;
+
+  $users_granted_thks_groups_ids = array();
+  if (count($group_granted_ids) > 0) {
+    $granted_groups = array();
+
+    $result = pwg_query("
+      SELECT `user_id`, `group_id`
+      FROM `".USER_GROUP_TABLE."`
+      WHERE `group_id` IN (".implode(',', $group_granted_ids).");
+    ");
+    while ($row = mysql_fetch_array($result)) {
+      if (!isset($granted_groups[$row['group_id']])) {
+        $granted_groups[$row['group_id']] = array();
+      }
+      $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
+     );
+    $users_granted_thks_groups_ids = order_by_name(
+      array_diff(
+        array_unique($user_granted_by_group_ids),
+        $users_granted_direct_ids
+      ),
+      $ec_lists['user_ids']
+    );
+    foreach ($users_granted_thks_groups_ids as $user_id)
+     foreach ($granted_groups as $group_id => $group_users)
+      if (in_array($user_id, $group_users)) {
+        $user_granted_ids[$user_id]= $groups[$group_id];
+        break;
+      }
+    
+  } $ec_debug['3'] = $user_granted_ids;
+
+  if ($append_tpl) {
+    $user_denied_ids = order_by_name(
+      array_diff(
+        array_keys($ec_lists['user_ids']),
+        $users_granted_thks_gen_ids,
+        $users_granted_thks_types_ids,
+        $users_granted_thks_groups_ids,
+        $users_granted_direct_ids
+      ),
+      $ec_lists['user_ids']
+    );
+    
+    foreach ($user_granted_ids as $u => $g) $template->append(
+      'user_granted_indirects',
+      array(
+        'USER'  => $ec_lists['user_ids'][$u],
+        'GROUP' => $g
+      )
+    );
+    
+    $ec_debug['4'] = $user_granted_ids;
+    $template->assign('all_groups', $groups);
+    $template->assign('group_granted_ids', $group_granted_ids);
+    $template->assign('group_denied_ids',order_by_name(
+      array_diff(array_keys($groups), $group_granted_ids), $groups
+    ));
+    $template->assign('all_users', $ec_lists['user_ids']);
+    $template->assign('users_granted_direct_ids', $users_granted_direct_ids);
+    $template->assign('user_denied_ids', $user_denied_ids);
+  }
+   $user_granted_ids = array_merge(
+    $user_granted_ids,
+    $users_granted_direct_ids
+   );
+  return $user_granted_ids;
+}
+
+/*
+ * dup_allowed($user_id)
+ * returns true if the user_id is allowed to display a duplicate link
+ *
+ * @param
+ *   $user_id : the user_id
+ * @return
+ *   true if the user_id is allowed to display a duplicate link
+ */
+function dup_allowed($user_id) {
+  return true;
+}
+
 ?>