[4905] | 1 | <?php |
---|
| 2 | /* |
---|
| 3 | * ----------------------------------------------------------------------------- |
---|
| 4 | * Plugin Name: Advanced MetaData |
---|
| 5 | * ----------------------------------------------------------------------------- |
---|
| 6 | * Author : Grum |
---|
| 7 | * email : grum@piwigo.org |
---|
| 8 | * website : http://photos.grum.fr |
---|
| 9 | * PWG user : http://forum.piwigo.org/profile.php?id=3706 |
---|
| 10 | * |
---|
| 11 | * << May the Little SpaceFrog be with you ! >> |
---|
| 12 | * |
---|
| 13 | * ----------------------------------------------------------------------------- |
---|
| 14 | * |
---|
| 15 | * See main.inc.php for release information |
---|
| 16 | * |
---|
| 17 | * PIP classe => manage integration in public interface |
---|
| 18 | * ----------------------------------------------------------------------------- |
---|
| 19 | */ |
---|
| 20 | |
---|
| 21 | if (!defined('PHPWG_ROOT_PATH')) { die('Hacking attempt!'); } |
---|
| 22 | |
---|
| 23 | include_once('amd_root.class.inc.php'); |
---|
| 24 | |
---|
| 25 | class AMD_PIP extends AMD_root |
---|
| 26 | { |
---|
[6722] | 27 | private $pictureProperties=array( |
---|
| 28 | 'id' => 0, |
---|
| 29 | 'analyzed' => 'n' |
---|
| 30 | ); |
---|
[4905] | 31 | function AMD_PIP($prefixeTable, $filelocation) |
---|
| 32 | { |
---|
| 33 | parent::__construct($prefixeTable, $filelocation); |
---|
| 34 | |
---|
[5935] | 35 | $this->loadConfig(); |
---|
| 36 | $this->initEvents(); |
---|
[4905] | 37 | } |
---|
| 38 | |
---|
| 39 | |
---|
| 40 | /* --------------------------------------------------------------------------- |
---|
| 41 | Public classe functions |
---|
| 42 | --------------------------------------------------------------------------- */ |
---|
| 43 | |
---|
| 44 | |
---|
| 45 | /* |
---|
| 46 | initialize events call for the plugin |
---|
| 47 | */ |
---|
[5935] | 48 | public function initEvents() |
---|
[4905] | 49 | { |
---|
[5935] | 50 | parent::initEvents(); |
---|
[4905] | 51 | add_event_handler('loc_begin_picture', array(&$this, 'loadMetadata')); |
---|
[6722] | 52 | add_event_handler('loc_end_page_tail', array(&$this, 'applyJS')); |
---|
[4905] | 53 | } |
---|
| 54 | |
---|
| 55 | /** |
---|
| 56 | * override piwigo's metadata with picture metadata |
---|
| 57 | * |
---|
| 58 | */ |
---|
| 59 | public function loadMetadata() |
---|
| 60 | { |
---|
| 61 | global $conf, $template, $page, $user; |
---|
| 62 | |
---|
| 63 | L10n::setLanguage($user['language']); |
---|
| 64 | |
---|
| 65 | $path=dirname(dirname(dirname(__FILE__))); |
---|
| 66 | $filename=""; |
---|
[6722] | 67 | $this->pictureProperties['id']=$page['image_id']; |
---|
[4905] | 68 | |
---|
[6920] | 69 | $sql="SELECT ti.path, tai.analyzed, ti.has_high FROM ".IMAGES_TABLE." ti |
---|
[5183] | 70 | LEFT JOIN ".$this->tables['images']." tai ON tai.imageId = ti.id |
---|
| 71 | WHERE ti.id=".$page['image_id'].";"; |
---|
[4905] | 72 | $result=pwg_query($sql); |
---|
| 73 | if($result) |
---|
| 74 | { |
---|
[6920] | 75 | $hasHigh=''; |
---|
[5959] | 76 | while($row=pwg_db_fetch_assoc($result)) |
---|
[4905] | 77 | { |
---|
| 78 | $filename=$row['path']; |
---|
[6920] | 79 | $hasHigh=$row['has_high']; |
---|
[6722] | 80 | $this->pictureProperties['analyzed']=$row['analyzed']; |
---|
[4905] | 81 | } |
---|
| 82 | $filename=$path."/".$filename; |
---|
[6920] | 83 | |
---|
| 84 | if($hasHigh==='true' and $this->config['amd_UseMetaFromHD']=='y') |
---|
| 85 | { |
---|
| 86 | $filename=dirname($filename)."/pwg_high/".basename($filename); |
---|
| 87 | } |
---|
[4905] | 88 | } |
---|
| 89 | |
---|
[6920] | 90 | |
---|
| 91 | |
---|
[5183] | 92 | $this->jpegMD->load( |
---|
[4905] | 93 | $filename, |
---|
| 94 | Array( |
---|
[5790] | 95 | 'filter' => AMD_JpegMetaData::TAGFILTER_IMPLEMENTED, |
---|
[4905] | 96 | 'optimizeIptcDateTime' => true, |
---|
| 97 | 'exif' => true, |
---|
| 98 | 'iptc' => true, |
---|
[5790] | 99 | 'xmp' => true, |
---|
| 100 | 'magic' => true, |
---|
[4905] | 101 | ) |
---|
| 102 | ); |
---|
| 103 | |
---|
[6891] | 104 | trigger_action('amd_jpegMD_loaded', $this->jpegMD); |
---|
| 105 | |
---|
[4905] | 106 | $conf['show_exif']=false; |
---|
| 107 | $conf['show_iptc']=false; |
---|
| 108 | |
---|
[6722] | 109 | $picturesTags=$this->jpegMD->getTags(); |
---|
[4905] | 110 | $tagsList=Array(); |
---|
[6722] | 111 | $userDefinedList=array( |
---|
| 112 | 'list' => array(), |
---|
| 113 | 'values' => array(), |
---|
| 114 | ); |
---|
[7700] | 115 | $sql="(SELECT st.tagId, gn.name as gName, ut.numId, ut.name, 'y' AS displayStatus |
---|
[6722] | 116 | FROM ((".$this->tables['selected_tags']." st |
---|
[4909] | 117 | LEFT JOIN ".$this->tables['groups']." gr |
---|
[4905] | 118 | ON gr.groupId = st.groupId) |
---|
[4909] | 119 | LEFT JOIN ".$this->tables['groups_names']." gn |
---|
[6722] | 120 | ON st.groupId = gn.groupId) |
---|
| 121 | LEFT JOIN ".$this->tables['used_tags']." ut |
---|
| 122 | ON ut.tagId = st.tagId |
---|
[4905] | 123 | WHERE gn.lang='".$user['language']."' |
---|
| 124 | AND st.groupId <> -1 |
---|
[7700] | 125 | ORDER BY gr.order, st.order) |
---|
| 126 | |
---|
| 127 | UNION |
---|
| 128 | |
---|
| 129 | (SELECT DISTINCT ut3.tagId, '', pautd.value, '', 'n' |
---|
| 130 | FROM ((".$this->tables['selected_tags']." st2 |
---|
| 131 | LEFT JOIN ".$this->tables['used_tags']." ut2 ON ut2.tagId = st2.tagId) |
---|
| 132 | LEFT JOIN ".$this->tables['user_tags_def']." pautd ON pautd.numId=ut2.numId) |
---|
| 133 | LEFT JOIN ".$this->tables['used_tags']." ut3 ON ut3.numId = pautd.value |
---|
| 134 | WHERE st2.tagId LIKE 'userDefined.%' |
---|
| 135 | AND pautd.type = 'M');"; |
---|
| 136 | |
---|
[4905] | 137 | $result=pwg_query($sql); |
---|
| 138 | if($result) |
---|
| 139 | { |
---|
[5959] | 140 | while($row=pwg_db_fetch_assoc($result)) |
---|
[4905] | 141 | { |
---|
[6722] | 142 | $tagsList[$row['tagId']]=$row; |
---|
| 143 | if(preg_match('/^userDefined\./i', $row['tagId'])) |
---|
| 144 | { |
---|
| 145 | $userDefinedList['list'][]=$row['numId']; |
---|
| 146 | } |
---|
| 147 | else |
---|
| 148 | { |
---|
| 149 | if(array_key_exists($row['tagId'], $picturesTags)) |
---|
| 150 | { |
---|
| 151 | $value=$picturesTags[$row['tagId']]->getLabel(); |
---|
| 152 | |
---|
| 153 | if($value instanceof DateTime) |
---|
| 154 | { |
---|
| 155 | $value=$value->format("Y-m-d H:i:s"); |
---|
| 156 | } |
---|
| 157 | elseif(is_array($value)) |
---|
| 158 | { |
---|
| 159 | /* |
---|
| 160 | * array values are stored in a serialized string |
---|
| 161 | */ |
---|
| 162 | $value=serialize($value); |
---|
| 163 | } |
---|
[6891] | 164 | $userDefinedList['values'][$row['numId']]=AMD_root::prepareValueForDisplay($value, $picturesTags[$row['tagId']]->isTranslatable());; |
---|
[6722] | 165 | } |
---|
| 166 | } |
---|
[4905] | 167 | } |
---|
| 168 | } |
---|
| 169 | |
---|
[6891] | 170 | $metadata=$template->get_template_vars('metadata'); |
---|
[4905] | 171 | $md=null; |
---|
| 172 | $group=null; |
---|
| 173 | |
---|
[6722] | 174 | $userDefinedValues=$this->pictureGetUserDefinedTags($userDefinedList['list'], $userDefinedList['values']); |
---|
[4905] | 175 | |
---|
[6891] | 176 | trigger_action('amd_jpegMD_userDefinedValues_built', |
---|
| 177 | array( |
---|
| 178 | 'picture' => $userDefinedList['values'], |
---|
| 179 | 'user' => $userDefinedValues, |
---|
| 180 | ) |
---|
| 181 | ); |
---|
| 182 | |
---|
[6722] | 183 | foreach($tagsList as $key => $tagProperties) |
---|
[4905] | 184 | { |
---|
[7700] | 185 | $keyExist=array_key_exists($key, $picturesTags) & ($tagProperties['displayStatus']=='y'); |
---|
[6722] | 186 | $userDefined=preg_match('/^userDefined\./i', $key); |
---|
| 187 | |
---|
| 188 | if(($group!=$tagProperties['gName']) and |
---|
| 189 | ( $keyExist or $userDefined) ) |
---|
[4905] | 190 | { |
---|
[6722] | 191 | $group=$tagProperties['gName']; |
---|
| 192 | if(!is_null($md)) |
---|
| 193 | { |
---|
| 194 | $metadata[]=$md; |
---|
| 195 | unset($md); |
---|
| 196 | } |
---|
| 197 | $md=Array( |
---|
| 198 | 'TITLE' => $tagProperties['gName'], |
---|
| 199 | 'lines' => Array() |
---|
| 200 | ); |
---|
| 201 | } |
---|
| 202 | |
---|
| 203 | if($keyExist) |
---|
| 204 | { |
---|
[4905] | 205 | $value=$picturesTags[$key]->getLabel(); |
---|
| 206 | |
---|
| 207 | if($value instanceof DateTime) |
---|
| 208 | { |
---|
| 209 | $value=$value->format("Y-m-d H:i:s"); |
---|
| 210 | } |
---|
| 211 | elseif(is_array($value)) |
---|
| 212 | { |
---|
| 213 | /* |
---|
| 214 | * array values are stored in a serialized string |
---|
| 215 | */ |
---|
| 216 | $value=serialize($value); |
---|
| 217 | } |
---|
[6891] | 218 | |
---|
| 219 | if($value!="") |
---|
| 220 | { |
---|
| 221 | $md['lines'][L10n::get($picturesTags[$key]->getName())]=AMD_root::prepareValueForDisplay($value, $picturesTags[$key]->isTranslatable()); |
---|
| 222 | } |
---|
[4905] | 223 | } |
---|
[6891] | 224 | elseif($userDefined and isset($userDefinedValues[$tagProperties['numId']]) and $userDefinedValues[$tagProperties['numId']]!='') |
---|
[6722] | 225 | { |
---|
| 226 | $md['lines'][$tagProperties['name']]=$userDefinedValues[$tagProperties['numId']]; |
---|
| 227 | } |
---|
[4905] | 228 | } |
---|
| 229 | |
---|
[6891] | 230 | if(!is_null($md) and count($md['lines'])>0) |
---|
[4905] | 231 | { |
---|
| 232 | $metadata[]=$md; |
---|
| 233 | } |
---|
| 234 | |
---|
[6722] | 235 | $template->assign('metadata', $metadata); |
---|
| 236 | } |
---|
[4905] | 237 | |
---|
[6722] | 238 | /** |
---|
| 239 | * used by the 'loc_end_page_tail' event |
---|
| 240 | * |
---|
| 241 | * on each public page viewed, add a script to do an ajax call to the "public.makeStats.doPictureAnalyze" function |
---|
| 242 | */ |
---|
| 243 | public function applyJS() |
---|
| 244 | { |
---|
| 245 | global $template; |
---|
| 246 | |
---|
| 247 | if($this->config['amd_FillDataBaseContinuously']=='y' and |
---|
[5935] | 248 | $this->config['amd_AllPicturesAreAnalyzed']=='n') |
---|
[5183] | 249 | { |
---|
[6722] | 250 | $template->set_filename('applyJS', |
---|
| 251 | dirname($this->getFileLocation()).'/templates/doAnalyze.tpl'); |
---|
| 252 | |
---|
| 253 | $datas=array( |
---|
| 254 | 'urlRequest' => $this->getAdminLink('ajax'), |
---|
| 255 | 'id' => ($this->pictureProperties['analyzed']=='n')?$this->pictureProperties['id']:'0' |
---|
| 256 | ); |
---|
| 257 | |
---|
| 258 | $template->assign('datas', $datas); |
---|
| 259 | $template->append('footer_elements', $template->parse('applyJS', true)); |
---|
[5183] | 260 | } |
---|
[4905] | 261 | } |
---|
| 262 | |
---|
| 263 | } // AMD_PIP class |
---|
| 264 | |
---|
| 265 | |
---|
| 266 | ?> |
---|