Filter out accounts with duplicate email address

[Son Nguyen]

Version: master
Platform: all
Browsers: all

In order to find users (accounts) whose email address is shared by another user, in 'User search' page, we need to implement a filter check box.

If the searcher has ticked the checkbox, they will see all email addresses for
the users in the search results

The non-unique email address(es) should be marked in the search results

Institution administrators will see users from their institution who have an email
address which is shared by a user outside their institution. However, they will not be
able to see the matching user from outside their institution.

[Son Nguyen (ngson2000)]

https://reviews.mahara.org/2062

[Mahara Bot (dev-mahara)]

Reviewed: https://reviews.mahara.org/2062
Committed: http://gitorious.org/mahara/mahara/commit/cf31e142cc627bb734e117dec50a8cde6a02875c
Submitter: Aaron Wells (<email address hidden>)
Branch: master

commit cf31e142cc627bb734e117dec50a8cde6a02875c
Author: Son Nguyen <email address hidden>
Date: Thu Apr 11 11:00:58 2013 +1200

Add a filter for users with duplicate emails (Bug #1166499)

1. When the option "Filter by duplicate email addresses" is checked,
the result table will list the accounts with duplicate emails.
The primary email and additional emails will be shown in the column
'Emails'
The column 'Emails' is still sortable based on the primary email

2. Also add the column 'Authentication' in search result table

3. Reset offset param when changing the filters

Change-Id: Id59f2de1d9a95c0bb67e8da40eebfeb5a5def60f
Signed-off-by: Son Nguyen <email address hidden>

[Kristina Hoeppner (kris-hoeppner)]

This work was funded by Massey University.

[Robert Lyon (robertl-9)]

i found a bug relating to the commit done for this bug:

I'm got this error:
[WAR] fd (lib/errors.php:749) Failed to get a recordset: mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FALSE' at line 1] in EXECUTE("SELECT COUNT(*) FROM "usr" u WHERE u.id <> 0 AND u.deleted = 0AND FALSE")
Command was: SELECT COUNT(*) FROM "usr" u WHERE u.id <> 0 AND u.deleted = 0AND FALSE

Looks like the line 463 in search/internal/lib.php needs to be

 $where .= ' AND FALSE';

not

$where .= 'AND FALSE';

So I submitted a patch https://reviews.mahara.org/#/c/2281/ to fix it

[Kristina Hoeppner (kris-hoeppner)]

I created bug #1193117 for this.

[Mahara Bot (dev-mahara)]

Reviewed: https://reviews.mahara.org/2281
Committed: http://gitorious.org/mahara/mahara/commit/42cd4731878109969a44a6f195d751da01b19457
Submitter: Son Nguyen (<email address hidden>)
Branch: master

commit 42cd4731878109969a44a6f195d751da01b19457
Author: Robert Lyon <email address hidden>
Date: Thu Jun 20 12:15:30 2013 +1200

Fixing a database call bug in code (Bug #1166499)

Change-Id: I1853c6dc443e39c659a7b07f678139f531288ffd
Signed-off-by: Robert Lyon <email address hidden>