New: send an email to group members with informations about a category

(needs improvements).


git-svn-id: http://piwigo.org/svn/trunk@1895 68402e56-0260-453c-a942-63ccdbb3a9ee

2 files changed, 116 insertions, 0 deletions

diff --git a/admin/cat_modify.php b/admin/cat_modify.php
index 065983070..95abb8e00 100644
--- a/admin/cat_modify.php
+++ b/admin/cat_modify.php
@@ -30,6 +30,7 @@ if (!defined('PHPWG_ROOT_PATH'))
 }
 
 include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
+include_once(PHPWG_ROOT_PATH.'include/functions_mail.inc.php');
 
 // +-----------------------------------------------------------------------+
 // | Check Access and exit when user status is not ok                      |
@@ -525,6 +526,98 @@ display_select_cat_wrapper(
   'category_option_destination'
   );
 
+// 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
 $template->assign_var_from_handle('ADMIN_CONTENT', 'categories');
diff --git a/template/yoga/admin/cat_modify.tpl b/template/yoga/admin/cat_modify.tpl
index 2961e5820..f28f8ab22 100644
--- a/template/yoga/admin/cat_modify.tpl
+++ b/template/yoga/admin/cat_modify.tpl
@@ -212,4 +212,27 @@
 
 </fieldset>
 
+<fieldset id="emailCatInfo">
+  <legend>{lang:Send an information email to group members}</legend>
+
+  <table>
+    <tr>
+      <td>{lang:Group}</td>
+      <td>
+        <select name="group">
+          <!-- BEGIN group_option -->
+          <option value="{group_option.VALUE}">{group_option.OPTION}</option>
+          <!-- END group_option -->
+        </select>
+      </td>
+    </tr>
+  </table>
+
+  <p>
+    <input class="submit" type="submit" value="{lang:Submit}" name="submitEmail" {TAG_INPUT_ENABLED}/>
+    <input class="submit" type="reset" value="{lang:Reset}" name="reset" />
+  </p>
+
+</fieldset>
+
 </form>