SVNBrowser/Action/Filter.pm

use strict;
use warnings;

=head1 NAME

SVNBrowser::Action::Filter

=cut

package SVNBrowser::Action::Filter;
use base qw/SVNBrowser::Action Jifty::Action/;

use Data::Dump qw/dump/;

use Jifty::Param::Schema;
use Jifty::Action schema {
        param author =>
                label is 'Developer login',
                render as 'combobox',
                available are defer {
                        my $authors = SVNBrowser::Model::RevisionCollection->new;
                        $authors->column(
                                column => 'author',
                                function => 'distinct',
                        );
                        $authors->unlimit;
                        $authors->order_by({ column => 'author', order => 'ASC' });
                        warn "authors ", $authors->build_select_query;
                        [{
                                display_from => 'author',
                                value_from => 'author',
                                collection => $authors,
                        }];
                };

        param branch =>
                label is 'In branch',
                render as 'combobox',
                available are defer {
                        my $branches = SVNBrowser::Model::BranchCollection->new;
                        $branches->column(
                                column => 'path',
                                function => 'distinct',
                        );
                        $branches->unlimit;
                        $branches->order_by({ column => 'path', order => 'ASC' });
                        warn "branches ", $branches->build_select_query;
                        [{
                                display_from => 'path',
                                value_from => 'path',
                                collection => $branches,
                        }];
                };

        param show_actions =>
                label is 'Show file actions',
                render as 'checkbox';

        param page =>
                label is 'Current page';

        param per_page =>
                label is 'Commits on page',
                render as 'Select',
                available are qw( 10 20 30 50 100 );

        param from_date =>
                label is 'From date',
                render as 'Date';

        param to_date =>
                label is 'To date',
                render as 'Date';

        param search =>
                label is 'Search in messages';

};

sub sticky_on_success { 1; }

=head2 take_action

=cut

sub take_action {
    my $self = shift;
    
        my $revisions = SVNBrowser::Model::RevisionCollection->new();
        $revisions->unlimit();

        if ( my $author = $self->argument_value('author') ) {
                $revisions->limit( column => 'author', value => $author, entry_aggregator => 'AND' );
        }

        if ( my $from_date = $self->argument_value('from_date') ) {
                $revisions->limit( column => 'commit_date', operator => '>=', value => $from_date, entry_aggregator => 'AND' );
        }

        if ( my $to_date = $self->argument_value('to_date') ) {
                $revisions->limit( column => 'commit_date', operator => '>=', value => $to_date, entry_aggregator => 'AND' );
        }

        if ( my $search = $self->argument_value('search') ) {
                $revisions->limit( column => 'message', operator => 'LIKE', value => '%' . $search . '%' );
        }

        if ( my $branch = $self->argument_value('branch') ) {
                my $b = SVNBrowser::Model::Branch->new();
                $b->load_by_cols( path => $branch );

                my $rev_branches = $revisions->join(
                        alias1 => 'main', column1 => 'revision',
                        table2 => 'revision_branches', column2 => 'revision'
                );
                $revisions->limit( alias => $rev_branches, column => 'branch', value => $b->id );
        }

        $revisions->order_by({ column => 'commit_date', order => 'desc' });
        $revisions->set_page_info(
                current_page => $self->argument_value('page'),
                per_page => $self->argument_value('per_page'),
        );

        warn "take_action SQL: ", $revisions->build_select_query;

        $revisions->goto_first_item;

        my $msg = '';
        if (my $nr = $revisions->pager->total_entries) {
                        $msg .= "Found $nr revisions";
        } else {
                        $msg .= "No revisions found";
        }

    $self->result->message($msg);

        $self->result->content( revisions => $revisions );

    return 1;
}


1;

1	dpavlin	5	use strict;
2			use warnings;
3
4			=head1 NAME
5
6			SVNBrowser::Action::Filter
7
8			=cut
9
10			package SVNBrowser::Action::Filter;
11			use base qw/SVNBrowser::Action Jifty::Action/;
12
13			use Data::Dump qw/dump/;
14
15			use Jifty::Param::Schema;
16			use Jifty::Action schema {
17			param author =>
18			label is 'Developer login',
19			render as 'combobox',
20			available are defer {
21			my $authors = SVNBrowser::Model::RevisionCollection->new;
22			$authors->column(
23			column => 'author',
24			function => 'distinct',
25			);
26			$authors->unlimit;
27	dpavlin	27	$authors->order_by({ column => 'author', order => 'ASC' });
28			warn "authors ", $authors->build_select_query;
29	dpavlin	5	[{
30			display_from => 'author',
31			value_from => 'author',
32			collection => $authors,
33			}];
34			};
35
36	dpavlin	26	param branch =>
37			label is 'In branch',
38			render as 'combobox',
39			available are defer {
40			my $branches = SVNBrowser::Model::BranchCollection->new;
41			$branches->column(
42			column => 'path',
43			function => 'distinct',
44			);
45			$branches->unlimit;
46	dpavlin	27	$branches->order_by({ column => 'path', order => 'ASC' });
47			warn "branches ", $branches->build_select_query;
48	dpavlin	26	[{
49			display_from => 'path',
50			value_from => 'path',
51			collection => $branches,
52			}];
53			};
54
55	dpavlin	10	param show_actions =>
56			label is 'Show file actions',
57			render as 'checkbox';
58
59	dpavlin	13	param page =>
60			label is 'Current page';
61
62			param per_page =>
63			label is 'Commits on page',
64			render as 'Select',
65			available are qw( 10 20 30 50 100 );
66
67	dpavlin	14	param from_date =>
68			label is 'From date',
69			render as 'Date';
70
71			param to_date =>
72			label is 'To date',
73			render as 'Date';
74
75	dpavlin	19	param search =>
76			label is 'Search in messages';
77	dpavlin	14
78	dpavlin	5	};
79
80			sub sticky_on_success { 1; }
81
82			=head2 take_action
83
84			=cut
85
86			sub take_action {
87			my $self = shift;
88
89	dpavlin	29	my $revisions = SVNBrowser::Model::RevisionCollection->new();
90			$revisions->unlimit();
91
92			if ( my $author = $self->argument_value('author') ) {
93			$revisions->limit( column => 'author', value => $author, entry_aggregator => 'AND' );
94			}
95
96			if ( my $from_date = $self->argument_value('from_date') ) {
97			$revisions->limit( column => 'commit_date', operator => '>=', value => $from_date, entry_aggregator => 'AND' );
98			}
99
100			if ( my $to_date = $self->argument_value('to_date') ) {
101			$revisions->limit( column => 'commit_date', operator => '>=', value => $to_date, entry_aggregator => 'AND' );
102			}
103
104			if ( my $search = $self->argument_value('search') ) {
105			$revisions->limit( column => 'message', operator => 'LIKE', value => '%' . $search . '%' );
106			}
107
108			if ( my $branch = $self->argument_value('branch') ) {
109			my $b = SVNBrowser::Model::Branch->new();
110			$b->load_by_cols( path => $branch );
111
112			my $rev_branches = $revisions->join(
113			alias1 => 'main', column1 => 'revision',
114			table2 => 'revision_branches', column2 => 'revision'
115			);
116			$revisions->limit( alias => $rev_branches, column => 'branch', value => $b->id );
117			}
118
119			$revisions->order_by({ column => 'commit_date', order => 'desc' });
120			$revisions->set_page_info(
121			current_page => $self->argument_value('page'),
122			per_page => $self->argument_value('per_page'),
123			);
124
125			warn "take_action SQL: ", $revisions->build_select_query;
126
127			$revisions->goto_first_item;
128
129	dpavlin	10	my $msg = '';
130	dpavlin	29	if (my $nr = $revisions->pager->total_entries) {
131			$msg .= "Found $nr revisions";
132			} else {
133			$msg .= "No revisions found";
134			}
135
136			$self->result->message($msg);
137
138			$self->result->content( revisions => $revisions );
139
140	dpavlin	5	return 1;
141			}
142
143
144			1;
145