Piwigo Bugtracker

Piwigo bug tracker has moved to Github

This bugtracker is kept to provide history on old issues.


View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000473Piwigometadatapublic2006.07.16 16:522011.02.03 09:22
ReporterGrom 
Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
StatusclosedResolutionduplicate 
Platformi686OSlinuxOS Version2.6.17-1-686
Product Version1.6.0 
Target VersionFixed in Version 
Summary0000473: tri par date_creation de photos prises le meme jour
Descriptionle tri par date_creation ne tient pas compte de l'heure de la prise de vue, les photos semblent alors triées par leur nom de fichier.

TagsNo tags attached.
browserMozilla
Database engine and version5.0.24-nightly-20060705
PHP version4.4.3-dev
Web serverApache/ProXad [May 31 2006 11:09:02]
Attached Filesdiff file icon patch_pwg_1.6.0_creation_hour.diff [^] (695 bytes) 2006.07.16 22:34 [Show Content]
diff file icon functions_metadata.php.diff [^] (410 bytes) 2008.04.14 17:01 [Show Content]

- Relationships
duplicate of 0000270closedplg the photo creation time is missing 
has duplicate 0000561closed ORDER BY date_creation doesn't work 

-  Notes
(0001236)
Grom (reporter)
2006.07.16 22:34

resolution du probleme chez moi, avec les modifications suivantes :
 avec phpmyadmin, type de pwg_images->date_creation mis à datetime
 dans admin/include/functions_metadata.php :
- if (preg_match('/^(\d{4}).(\d{2}).(\d{2})/', $value, $matches))
+ if (preg_match('/^(\d{4}).(\d{2}).(\d{2}).(\d{2}).(\d{2}).(\d{2})/', $value, $matches))
       {
- $exif[$pwg_key] = $matches[1].'-'.$matches[2].'-'.$matches[3];
+ $exif[$pwg_key] = $matches[1].'-'.$matches[2].'-'.$matches[3].'-'.$matches[4].'-'.$matches[5].'-'.$matches[6];

 synchronisation de toute la galerie
(0001478)
chrisaga (developer)
2006.10.18 07:56

OK, mais ça n'est pas la façon dont les métadonnées IPTC sont gérées (2 champs distincts, ce qui permet de ne pas renseigner l'heure quand on ne la connait pas, typiquement support argentique).
Il doit y avoir une raison, et ça vaut le coup de se poser la question avant d'intégrer cette évolution
(0001701)
VDigital (reporter)
2007.01.28 14:58

http://forum.phpwebgallery.net/viewtopic.php?pid=53350#p53350 [^]
et surtout:
http://forum.phpwebgallery.net/viewtopic.php?id=8708 [^]
(0002182)
gouarfig (reporter)
2008.04.14 17:04
edited on: 2008.04.14 17:10

Je propose un petit patch simplissime pour ajouter l'heure lors de la synchro.
Il change a peine le code original, dans le sens ou s'il trouve une heure, il l'utilise, s'il n'en trouve pas, il se repli sur le bout de code original.

Teste avec plusieurs appareils (Canon, Nikon, Panasonic, Casio)

(Patch a partir d'une 1.7.1 - fichier /admin/include/functions_metadata.php)



86c86,90
< if (preg_match('/^(\d{4}).(\d{2}).(\d{2})/', $value, $matches))
---
> if (preg_match('/^(\d{4}):(\d{2}):(\d{2}) (\d{2}):(\d{2}):(\d{2})/', $value, $matches))
> {
> $exif[$pwg_key] = $matches[1].'-'.$matches[2].'-'.$matches[3] . ' ' . $matches[4].':'.$matches[5].':'.$matches[6];
> }
> elseif (preg_match('/^(\d{4}).(\d{2}).(\d{2})/', $value, $matches))

(0002193)
tosca (developer)
2008.04.28 17:28
edited on: 2010.09.01 20:27

I have 2 reasons to ask for the actual time in the creation_date field :
 - provide a chronological order more accurate than the one based on the date only,
 - be able to display the creation time as an additional information (as the pictures aren't created by a camera, there is no EXIF metadata available).


- Issue History
Date Modified Username Field Change
2006.07.16 16:52 Grom New Issue
2006.07.16 16:52 Grom browser => Mozilla
2006.07.16 16:52 Grom MySQL version => 5.0.24-nightly-20060705
2006.07.16 16:52 Grom PHP version => 4.4.3-dev
2006.07.16 16:52 Grom Web server => Apache/ProXad [May 31 2006 11:09:02]
2006.07.16 17:16 chrisaga Relationship added duplicate of 0000270
2006.07.16 22:34 Grom Note Added: 0001236
2006.07.16 22:34 Grom File Added: patch_pwg_1.6.0_creation_hour.diff
2006.10.18 07:49 chrisaga Relationship added has duplicate 0000561
2006.10.18 07:50 chrisaga Severity minor => feature
2006.10.18 07:56 chrisaga Note Added: 0001478
2007.01.28 14:58 VDigital Note Added: 0001701
2008.04.14 17:01 gouarfig File Added: functions_metadata.php.diff
2008.04.14 17:04 gouarfig Note Added: 0002182
2008.04.14 17:10 gouarfig Note Edited: 0002182
2008.04.28 17:28 tosca Note Added: 0002193
2010.09.01 20:27 plg Note Edited: 0002193
2011.02.03 09:22 plg Status new => closed
2011.02.03 09:22 plg Resolution open => duplicate


Copyright © 2000 - 2020 MantisBT Team
Contact
Powered by Mantis Bugtracker