X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;ds=sidebyside;f=Memories%2FPhoto.pm;h=ce0cd2003a777277b06e5e535389e14c1be033ba;hb=0462f25b10e5adb4eacc0e11f4ced5165784f38f;hp=98444a7bbe0c8a001835c076c610c4a4175cf3a7;hpb=b637f6e61ec3f236de28a3d502f70ce7aacba84e;p=memories.git diff --git a/Memories/Photo.pm b/Memories/Photo.pm index 98444a7..ce0cd20 100644 --- a/Memories/Photo.pm +++ b/Memories/Photo.pm @@ -14,6 +14,12 @@ FROM __TABLE__ 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"); @@ -73,6 +79,23 @@ sub do_upload :Exported { ); } +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]; @@ -93,22 +116,37 @@ sub view :Exported { } } 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 {