1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
package FixMyStreet::DB::ResultSet::Contact;
use base 'DBIx::Class::ResultSet';
use strict;
use warnings;
use POSIX qw(strcoll);
sub me { join('.', shift->current_source_alias, shift || q{}) }
=head2 not_deleted
$rs = $rs->not_deleted();
Filter down to not deleted contacts (so active or inactive).
=cut
sub not_deleted {
my $rs = shift;
return $rs->search( { $rs->me('state') => { '!=' => 'deleted' } } );
}
sub active {
my $rs = shift;
$rs->search( { $rs->me('state') => [ 'unconfirmed', 'confirmed' ] } );
}
sub translated {
my $rs = shift;
my $schema = $rs->result_source->schema;
$rs->search(undef, {
'+columns' => { 'msgstr' => 'translations.msgstr' },
join => 'translations',
bind => [ 'category', $schema->lang, 'contact' ],
});
}
sub all_sorted {
my $rs = shift;
my @contacts = $rs->translated->all;
@contacts = sort {
my $a_name = $a->get_extra_metadata('display_name') || $a->get_column('msgstr') || $a->category;
my $b_name = $b->get_extra_metadata('display_name') || $b->get_column('msgstr') || $b->category;
strcoll($a_name, $b_name)
} @contacts;
return @contacts;
}
sub summary_count {
my ( $rs, $restriction ) = @_;
return $rs->search(
$restriction,
{
group_by => ['state'],
select => [ 'state', { count => 'id' } ],
as => [qw/state state_count/]
}
);
}
sub group_lookup {
my $rs = shift;
map {
my $group = $_->get_extra_metadata('group') || '';
$group = join(',', ref $group ? @$group : $group);
$_->category => $group
} $rs->all;
}
1;
|
