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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
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') => { -not_in => [ 'deleted', 'staff' ] } } );
}
sub not_deleted_admin {
my $rs = shift;
return $rs->search( { $rs->me('state') => { -not_in => [ 'deleted' ] } } );
}
sub active {
my $rs = shift;
$rs->search( { $rs->me('state') => [ 'unconfirmed', 'confirmed' ] } );
}
sub for_new_reports {
my ($rs, $c, $bodies) = @_;
my $params = {
$rs->me('body_id') => [ keys %$bodies ],
};
if ($c->user_exists && $c->user->is_superuser) {
# Everything normal OR any staff states
$params->{$rs->me('state')} = [ 'unconfirmed', 'confirmed', 'staff' ];
} elsif ($c->user_exists && $c->user->from_body) {
# Everything normal OR staff state in the user body
$params->{'-or'} = [
$rs->me('state') => [ 'unconfirmed', 'confirmed' ],
{
$rs->me('body_id') => $c->user->from_body->id,
$rs->me('state') => 'staff',
},
];
} else {
$params->{$rs->me('state')} = [ 'unconfirmed', 'confirmed' ];
}
$rs->search($params, { prefetch => 'body' });
}
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/]
}
);
}
1;
|