Changeset 1895 for trunk/admin/cat_modify.php

Timestamp:

Mar 12, 2007, 1:04:25 AM (17 years ago)

Author:

plg

Message:

New: send an email to group members with informations about a category
(needs improvements).

File:

• trunk/admin/cat_modify.php (modified) (2 diffs)

trunk/admin/cat_modify.php

@@ -31 +31 @@
 
 include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
+include_once(PHPWG_ROOT_PATH.'include/functions_mail.inc.php');
 
 // +-----------------------------------------------------------------------+
@@ -526 +527 @@
   );
 
+// info by email to an access granted group of category informations
+if (isset($_POST['submitEmail']))
+{
+  $query = '
+SELECT
+    user_id,
+    '.$conf['user_fields']['email'].' AS email
+  FROM '.USER_GROUP_TABLE.'
+    INNER JOIN '.USERS_TABLE.' ON '.$conf['user_fields']['id'].' = user_id
+  WHERE '.$conf['user_fields']['email'].' IS NOT NULL
+    AND group_id = '.$_POST['group'].'
+;';
+  $result = pwg_query($query);
+
+  while ($row = mysql_fetch_array($result))
+  {
+    pwg_mail(
+      $row['email'],
+      array(
+        'content' => get_absolute_root_url().make_index_url(
+          array(
+            'category' => array(
+              'id' => $category['id'],
+              'name' => $category['name'],
+              'permalink' => $category['permalink'],
+              )
+            )
+          ),
+        'subject' => $category['name']
+        )
+      );
+  }
+
+  $query = '
+SELECT
+    name
+  FROM '.GROUPS_TABLE.'
+  WHERE id = '.$_POST['group'].'
+;';
+  list($group_name) = mysql_fetch_row(pwg_query($query));
+  
+  array_push(
+    $page['infos'],
+    sprintf(
+      l10n('An information email was sent to group "%s"'),
+      $group_name
+      )
+    );
+}
+
+if ('private' == $category['status'])
+{
+  $query = '
+SELECT
+    group_id
+  FROM '.GROUP_ACCESS_TABLE.'
+  WHERE cat_id = '.$category['id'].'
+;';
+}
+else
+{
+  $query = '
+SELECT
+    id AS group_id
+  FROM '.GROUPS_TABLE.'
+;';
+}
+$group_ids = array_from_query($query, 'group_id');
+
+if (count($group_ids) > 0)
+{
+  $query = '
+SELECT
+    id,
+    name
+  FROM '.GROUPS_TABLE.'
+  WHERE id IN ('.implode(',', $group_ids).')
+  ORDER BY name ASC
+;';
+  $result = pwg_query($query);
+
+  while ($row = mysql_fetch_array($result))
+  {
+    $template->assign_block_vars(
+      'group_option',
+      array(
+        'VALUE' => $row['id'],
+        'OPTION' => $row['name'],
+        )
+      );
+  }
+}
 
 //----------------------------------------------------------- sending html code