Bug #900932

Change-Id: I4b3f6e18fb0ab68a8d9e0e5327d672e373f9a291
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

* changes:
  Get unread message count from user table (bug #854403)
  Add column for unread message counts to the usr table (bug #854403)
  Add functions to create and remove database triggers
  Display a useful error message when PL/pgSQL is not available
  New icon for unread notifications

Also keeps the count in the $USER object up to date whenever the
user deletes or reads a notification.

When new notifications are generated for a live user by another user,
or on cron, the logged-in user's unread count is reloaded from the
database into the session either on hitting the inbox, or whenever
$USER is committed for some other reason.

The code to reload the background fields on commit of the LiveUser
object has been changed to ensure that it still works at upgrade time,
where the 'reload' column doesn't exist in the user table yet, but
*does* exist in the User object.

Change-Id: I9c9a81bf77d0927352902dee0d989d6122757b47
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

The unread message counts are expensive to query in postgres when
notification_internal_activity gets big.  This results in very slow
logins (the first time the query is run).  This patch adds a new
column for each user to store the unread message count.

The counts are updated using a trigger on insert, update and delete
of the notification_internal_activity table.

Change-Id: Ifb24c6892567658584f45825437bb7a8f20cc310
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Change-Id: Id4f87c1fef835a11bc7413df93d60a6fada59a6a
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Change-Id: Ib9a72a9e36bb24da5907720242b23e991bb7bf9a
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Change-Id: I81865ee9c9cd4a47095a1087d452360c7a994008
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

The admin 'manage groups' and user profile pages added users to groups
by changing the group_member table directly rather than using
group_add_user and friends.  It's cleaner to keep this code in one
place, in case we want to make changes to the group_member tables
later.

Change-Id: I687764fb25e8924a3da85da7494cd3fbcad53bc1
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Bug #897631

This is a small modification to allow group_member table to have
a new field called method. Method can be used to indicate how
that user was added to the group.

It can be useful to implement syncro with other systems.

Change-Id: I92cd64e1fcf72927f16b496a5e17fa5da992a329
Signed-off-by: Juan Segarra Montesinos <juan.segarra@si.uji.es>

When a user is an administrator in one institution, and staff in
another, and performs a search with no results, PHP gives an "Invalid
argument supplied for foreach()" warning.

Change-Id: I3706a639fb11e98cb64c8ef14aede371386e86b4
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Currently there's no warning if the PHP GD library has been
compiled without one support for a file type. When a user attempts
to upload an image of an unsupported type, it will fail.

Change-Id: I682a39aeaba2d06494868210b9ef9d8f46f1b136
Signed-off-by: Melissa Draper <melissa@catalyst.net.nz>

* changes:
  Add "shared with" option to shared pages (part of bug #857793)
  Add sorting options to Shared Pages (part of bug #857793)
  Use http_build_query rather than urlencode on Shared pages
  Use view_search function to fetch data for Shared pages
  Add sorting by owner name in view_search

Adds a set of checkboxes to Shared Pages which allows the user to
filter by the various access types.  The default remains unchanged
(pages shared with you, friends, or your groups).  Additional options
are public, logged-in, and institutions, and any combination of these
can be searched.

This allows users to find all public pages on the site, for example.

Change-Id: I7b123f2088756cea04d2685e2e35ef578252991a
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Adds a second drop-down to Shared pages to allow sorting of results by
owner, title, and last modification time.

Change-Id: I760eec99a6d187b72389b017a55bc7fd7a544e05
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

This change does not affect the behaviour of Shared pages, but will
make it easier to add more query parameters later.

Also, by turning off the pieforms 'dieaftersubmit' setting and
modifying the global parameter variables, it's possible to avoid a
second page reload after submitting the form.

Change-Id: Ib0352e627752b9d3c47f9c08bf7b23f25ea0f08f
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

The shared pages query can be simplified to use new parameters in
view_search.  This cuts down on code duplication, but requires a
second query to fetch information about the number of comments on each
view, and the name of the last commenter.

Change-Id: I43e4f752c803daac7546614b830daf2aa79b0adb
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Adds an 'ownername' sort option to view_search, so that results can be
sorted alphabetically by the name of the user, group, or institution
who owns the view.

Change-Id: I78086fb37e3bbc1313a7671f3aa508ed1c0cc93a
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

* changes:
  Compress sitemaps using php's zlib rather than gzip executable
  Serve sitemaps from download.php and use download url in the index
  Remove daily sitemap before writing if it already exists
  Write sitemap xml files to dataroot, not docroot (bug #914490)
  Move check for sitemap configuration setting

Change-Id: I6617bef556346da9261578910535e258ce554c03
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Adds a 'type' parameter to download.php, which, if equal to 'sitemap',
will serve up a sitemap file from dataroot.  The download.php links
are then used in the generation of the sitemap index.

Change-Id: I8b7af1a6820cf32542f3ae1bdfc8940c309939b0
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

If for some reason the sitemap generator is called twice in a day, it
fails the second time while trying to overwrite the previous version.
This can be fixed by removing all sitemaps for the current day before
attempting to regenerate them.

Change-Id: I48c3ff5c99948e4c5ab93007f068f0319dfac2f8
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

The cron process can't write to the docroot, so we'll have to write
sitemaps to dataroot and make them accessible another way.

Change-Id: If3b09f7322f59beed9eba1ac3d6f63c667909dfa
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

When sitemap generation is disabled, we don't need to include all the
relevant libraries and log the message about disabled sitemap
generation.

Change-Id: I1f7e92f58dcb455bbfaab7745ce28e496ee7276b
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

* changes:
  Add navigation for staff to access the user search page
  Add admin report on access lists of user pages (bug #919009)

* changes:
  jquery: New upstream version 1.7.1 (bug #923192)
  jquery: don't hardcode the version number in lib/web.php
  jquery: remove minified copy from core

Although this is currently just for user searches, using the terms
"Site Information" for site staff, and "Institution Information" for
institution staff will allow us to add site/institution statistics
under the same menu.

Change-Id: I40bae94406a1a6f16b428e3821f3be1ec41ae52d
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

Adds a new "User reports" page to the admin section, accessible by
admins, which produces a list of all the pages owned by a given set of
users, and a list of who is on the access list for each page.

The users are selected using the checkboxes on the admin user search
page, and the page is reachable from admin user search using a new
"View reports" button on that page.

The CSV download that previously appeared on the Bulk actions page is
more appropriate on a reports page, so CSV download is also moved from
Bulk actions to User reports.  Email and remoteuser fields are only
displayed to site and institution administrators.

Because some sites will not want to allow staff to see the page access
lists of all users in their institutions, access to this page by staff
is controlled by a new "Staff report access" site setting.

Change-Id: Id02b58416e3dfb28fd39c1170426ddefe6669efe
Signed-off-by: Richard Mansfield <richard.mansfield@catalyst.net.nz>

* changes:
  Fix error when cancelling the edit group form (bug #924644)
  Fix error when creating publicly viewable groups (bug #917383)