ORDER BY uploaded DESC
LIMIT 4
});
+__PACKAGE__->set_sql(popular => q{
+SELECT __ESSENTIAL__
+FROM __TABLE__
+ORDER BY hit_count DESC
+LIMIT 4
+});
__PACKAGE__->has_many(comments => "Memories::Comment");
__PACKAGE__->has_a(uploader => "Memories::User");
);
}
+sub approx_rating {
+ my $self = shift;
+ $self->rated or return 0;
+ int($self->rating/$self->rated*10)/10;
+}
+
+sub add_rating :Exported {
+ my ($self, $r) = @_;
+ my $photo = $r->{objects}[0];
+ my $delta = $r->{params}{rating};
+ if ($delta < 0 or $delta > 5) { return; } # Scammer
+ # XXX Race
+ $photo->rating($photo->rating() + $delta);
+ $photo->rated($photo->rated() + 1);
+ $r->output(""); # Only used by ajax
+}
+
sub view :Exported {
my ($self, $r) = @_;
my $photo = $r->{objects}[0];
}
}
sub upload :Exported {}
+sub exif :Exported {}
+sub comment :Exported {}
+sub tagedit :Exported {}
+sub similar :Exported {}
use Class::DBI::Plugin::Pager;
use Class::DBI::Plugin::AbstractCount;
-sub recent :Exported {
- my ($self, $r) = @_;
+sub view_paged_ordered {
+ my ($self, $r, $how) = @_;
my $page = $r->params->{page} || 1;
my $pager = $self->pager(
per_page => Memories->config->{photos_per_page},
page => $page,
syntax => PAGER_SYNTAX,
- order_by => "uploaded desc"
+ order_by => $how
);
$r->objects([$pager->retrieve_all ]);
$r->{template_args}{pager} = $pager;
$r->last_search;
+ $r->template("paged"); # Set the what using the action name
+}
+
+sub recent :Exported {
+ my ($self, $r) = @_;
+ $self->view_paged_ordered($r, "uploaded desc");
+}
+
+sub popular :Exported {
+ my ($self, $r) = @_;
+ $self->view_paged_ordered($r, "hit_count desc");
}
sub add_comment :Exported {