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];
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 {
}
}
-use Text::Balanced qw(extract_multiple extract_quotelike);
sub edit_tags :Exported {
my ($self, $r) = @_;
my $photo = $r->objects->[0];
sub add_tags {
my ($photo, $tagstring) = @_;
- for my $tag (map { s/^"|"$//g; $_} extract_multiple(lc $tagstring, [ \&extract_quotelike, qr/([^\s]+)/ ], undef,1)) {
+ for my $tag (Tagtools->separate_tags($tagstring)) {
$photo->add_to_tags({tag => Memories::Tag->find_or_create({name =>$tag}) })
}
}