[Tickets #9382] calendarical view of photos

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/9382
------------------------------------------------------------------------------
  Ticket             | 9382
  Created By         | michael at bigmichi1.de
  Summary            | calendarical view of photos
  Queue              | Ansel
  Version            | FRAMEWORK_3
  Type               | Enhancement
  State              | New
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


michael at bigmichi1.de (2010-11-10 10:49) wrote:

will it be possible to add a calendarical overview? i think of a view  
like the month view in kronolith where i can see on which days photos  
in my galleries (that i can read) are taken. and then when i click on  
a day with photos i can see these photos like in a virtual gallery

i only have a query at this time but maybe you understand what i mean:
SELECT count(*), DATE_FORMAT(FROM_UNIXTIME(ia.attr_value), "%Y-%m-%d")  
as date from ansel_images i inner join ansel_image_attributes ia on  
(i.image_id = ia.image_id) where ia.attr_name = 'DateTimeOriginal'  
group by DATE_FORMAT(FROM_UNIXTIME(ia.attr_value), "%Y-%m-%d")