From d4519a348fb8d4dd4af9704b8b6494b5f2b6260a Mon Sep 17 00:00:00 2001 From: z0rglub Date: Sat, 21 Aug 2004 12:52:43 +0000 Subject: - add files metadata support : use info for database fields - distinction between directories synchronization and metadata synchronization git-svn-id: http://piwigo.org/svn/trunk@486 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/include/functions_metadata.php | 363 +++++++++++++++++++++++++++++++++++ 1 file changed, 363 insertions(+) create mode 100644 admin/include/functions_metadata.php (limited to 'admin/include/functions_metadata.php') diff --git a/admin/include/functions_metadata.php b/admin/include/functions_metadata.php new file mode 100644 index 000000000..9a7d45193 --- /dev/null +++ b/admin/include/functions_metadata.php @@ -0,0 +1,363 @@ + | +// | branch : BSF (Best So Far) | +// +-----------------------------------------------------------------------+ +// | file : $RCSfile$ +// | last update : $Date$ +// | last modifier : $Author$ +// | revision : $Revision$ +// +-----------------------------------------------------------------------+ +// | This program is free software; you can redistribute it and/or modify | +// | it under the terms of the GNU General Public License as published by | +// | the Free Software Foundation | +// | | +// | This program is distributed in the hope that it will be useful, but | +// | WITHOUT ANY WARRANTY; without even the implied warranty of | +// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | +// | General Public License for more details. | +// | | +// | You should have received a copy of the GNU General Public License | +// | along with this program; if not, write to the Free Software | +// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | +// | USA. | +// +-----------------------------------------------------------------------+ + +/** + * returns informations from IPTC metadata, mapping is done at the beginning + * of the function + * + * @param string $filename + * @return array + */ +function get_iptc_data($filename) +{ + global $getimagesize_time; + + $map = array( + 'keywords' => '2#025', + 'date_creation' => '2#055', + 'author' => '2#122', + 'name' => '2#085', + 'comment' => '2#120' + ); + $datefields = array('date_creation', 'date_available'); + + $result = array(); + + // Read IPTC data + $iptc = array(); + + $start = get_moment(); + getimagesize($filename, &$imginfo); + $getimagesize_time+= get_moment() - $start; + + if (is_array($imginfo) and isset($imginfo['APP13'])) + { + $iptc = iptcparse($imginfo['APP13']); + if (is_array($iptc)) + { + $rmap = array_flip($map); + foreach (array_keys($rmap) as $iptc_key) + { + if (isset($iptc[$iptc_key][0]) and $value = $iptc[$iptc_key][0]) + { + // strip leading zeros (weird Kodak Scanner software) + while ($value[0] == chr(0)) + { + $value = substr($value, 1); + } + // remove binary nulls + $value = str_replace(chr(0x00), ' ', $value); + + foreach (array_keys($map, $iptc_key) as $pwg_key) + { + if (in_array($pwg_key, $datefields)) + { + if ( preg_match('/(\d{4})(\d{2})(\d{2})/', $value, $matches)) + { + $value = $matches[1].'-'.$matches[2].'-'.$matches[3]; + } + else + { + continue; + } + } + $result[$pwg_key] = $value; + } + } + } + } + } + return $result; +} + +function update_metadata($files) +{ + global $conf; + +// $conf['use_iptc'] = true; +// $conf['use_exif'] = true; + + $inserts = array(); + + foreach ($files as $id => $file) + { + $insert = array(); + $insert['id'] = $id; + $insert['filesize'] = floor(filesize($file)/1024); + + if ($image_size = @getimagesize($file)) + { + $insert['width'] = $image_size[0]; + $insert['height'] = $image_size[1]; + } + + if ($conf['use_exif']) + { + if ($exif = @read_exif_data($file)) + { + if (isset($exif['DateTime'])) + { + preg_match('/^(\d{4}).(\d{2}).(\d{2})/' + ,$exif['DateTime'] + ,$matches); + $insert['date_creation'] = + "'".$matches[1].'-'.$matches[2].'-'.$matches[3]."'"; + } + } + } + + if ($conf['use_iptc']) + { + $iptc = get_iptc_data($file); + foreach (array_keys($iptc) as $key) + { + $insert[$key] = "'".addslashes($iptc[$key])."'"; + } + } + + $insert['date_metadata_update'] = CURRENT_DATE; + + array_push($inserts, $insert); + } + + if (count($inserts) > 0) + { + $dbfields = array( + 'id','filesize','width','height','name','author','comment' + ,'date_creation','keywords','date_metadata_update' + ); + + // depending on the MySQL version, we use the multi table update or N + // update queries + $query = 'SELECT VERSION() AS version;'; + $row = mysql_fetch_array(mysql_query($query)); + if (version_compare($row['version'],'4.0.4') < 0) + { + // MySQL is prior to version 4.0.4, multi table update feature is not + // available + echo 'MySQL is prior to version 4.0.4, multi table update feature is not available
'; + foreach ($inserts as $insert) + { + $query = ' +UPDATE '.IMAGES_TABLE.' + SET '; + foreach (array_diff(array_keys($insert),array('id')) as $num => $key) + { + if ($num > 1) + { + $query.= ', '; + } + $query.= $key.' = '.$insert[$key]; + } + $query.= ' + WHERE id = '.$insert['id'].' +;'; + // echo '
'.$query.'
'; + mysql_query($query); + } + } + else + { + // creation of the temporary table + $query = ' +DESCRIBE '.IMAGES_TABLE.' +;'; + $result = mysql_query($query); + $columns = array(); + while ($row = mysql_fetch_array($result)) + { + if (in_array($row['Field'], $dbfields)) + { + $column = $row['Field']; + $column.= ' '.$row['Type']; + if (!isset($row['Null']) or $row['Null'] == '') + { + $column.= ' NOT NULL'; + } + if (isset($row['Default'])) + { + $column.= " default '".$row['Default']."'"; + } + array_push($columns, $column); + } + } + $query = ' +CREATE TEMPORARY TABLE '.IMAGE_METADATA_TABLE.' +( +'.implode(",\n", $columns).', +PRIMARY KEY (id) +) +;'; + // echo '
'.$query.'
'; + mysql_query($query); + // inserts all found pictures + $query = ' +INSERT INTO '.IMAGE_METADATA_TABLE.' + ('.implode(',', $dbfields).') + VALUES + '; + foreach ($inserts as $insert_id => $insert) + { + $query.= ' +'; + if ($insert_id > 0) + { + $query.= ','; + } + $query.= '('; + foreach ($dbfields as $field_id => $dbfield) + { + if ($field_id > 0) + { + $query.= ','; + } + + if (!isset($insert[$dbfield]) or $insert[$dbfield] == '') + { + $query.= 'NULL'; + } + else + { + $query.= $insert[$dbfield]; + } + } + $query.=')'; + } + $query.= ' +;'; + // echo '
'.$query.'
'; + mysql_query($query); + // update of images table by joining with temporary table + $query = ' +UPDATE '.IMAGES_TABLE.' AS images, '.IMAGE_METADATA_TABLE.' as metadata + SET '.implode("\n , ", + array_map( + create_function('$s', 'return "images.$s = metadata.$s";') + , array_diff($dbfields, array('id')))).' + WHERE images.id = metadata.id +;'; + echo '
'.$query.'
'; + mysql_query($query); + } + } +} + +/** + * returns an array associating element id (images.id) with its complete + * path in the filesystem + * + * @param int id_uppercat + * @param boolean recursive ? + * @param boolean only newly added files ? + * @return array + */ +function get_filelist($category_id = '', $recursive = false, $only_new = false) +{ + $files = array(); + + $query = ' +SELECT id, dir + FROM '.CATEGORIES_TABLE.' +;'; + $result = mysql_query($query); + $cat_dirs = array(); + while ($row = mysql_fetch_array($result)) + { + $cat_dirs[$row['id']] = $row['dir']; + } + + // filling $uppercats_array : to each category id the uppercats list is + // associated + $uppercats_array = array(); + + $query = ' +SELECT id, uppercats + FROM '.CATEGORIES_TABLE; + if (is_numeric($category_id)) + { + if ($recursive) + { + $query.= ' + WHERE uppercats REGEXP \'(^|,)'.$category_id.'(,|$)\' +'; + } + else + { + $query.= ' + WHERE id = '.$category_id.' +'; + } + } + $query.= ' +;'; + $result = mysql_query($query); + while ($row = mysql_fetch_array($result)) + { + $uppercats_array[$row['id']] = $row['uppercats']; + } + + $query = ' +SELECT galleries_url + FROM '.SITES_TABLE.' + WHERE id = 1 +'; + $row = mysql_fetch_array(mysql_query($query)); + $basedir = $row['galleries_url']; + + // filling $cat_fulldirs + $cat_fulldirs = array(); + foreach ($uppercats_array as $cat_id => $uppercats) + { + $uppercats = str_replace(',', '/', $uppercats); + $cat_fulldirs[$cat_id] = $basedir.preg_replace('/(\d+)/e', + "\$cat_dirs['$1']", + $uppercats); + } + + $query = ' +SELECT id, file, storage_category_id + FROM '.IMAGES_TABLE.' + WHERE storage_category_id IN ('.implode(',' + ,array_keys($uppercats_array)).')'; + if ($only_new) + { + $query.= ' + AND date_metadata_update IS NULL +'; + } + $query.= ' +;'; + $result = mysql_query($query); + while ($row = mysql_fetch_array($result)) + { + $files[$row['id']] + = $cat_fulldirs[$row['storage_category_id']].'/'.$row['file']; + } + + return $files; +} +?> \ No newline at end of file -- cgit v1.2.3