source: extensions/AMetaData/amd_rb_callback.class.inc.php @ 32863

Last change on this file since 32863 was 16007, checked in by grum, 12 years ago

feature:2637- compatibility with Piwigo 2.4

File size: 7.7 KB
Line 
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 * RBCallBackAMetadata classe => used for the request builder
18 *
19 * -----------------------------------------------------------------------------
20 */
21  global $user;
22
23  if(!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
24  if(!defined('JPEG_METADATA_DIR')) define('JPEG_METADATA_DIR', dirname(__FILE__)."/JpegMetaData/");
25
26  //include_once('')
27  include_once(PHPWG_PLUGINS_PATH.'GrumPluginClasses/classes/GPCRequestBuilder.class.inc.php');
28  include_once(PHPWG_PLUGINS_PATH.'AMetaData/JpegMetaData/Common/Const.class.php');
29  include_once(PHPWG_PLUGINS_PATH.'AMetaData/JpegMetaData/Common/L10n.class.php');
30
31  load_language('plugin.lang', AMD_PATH);
32
33
34  if(isset($user['language']))
35  {
36    L10n::setLanguage($user['language']);
37  }
38
39class RBCallBackAMetaData extends GPCSearchCallback {
40
41  /**
42   * the getImageId returns the name of the image id attribute
43   * return String
44   */
45  static public function getImageId()
46  {
47    return("pait.imageId");
48  }
49
50  /**
51   * the getSelect function must return an attribute list separated with a comma
52   *
53   * "att1, att2, att3, att4"
54   */
55  static public function getSelect($param="")
56  {
57    return(" pait.value AS amdValue, paut.name AS amdName ");
58  }
59
60  /**
61   * the getFrom function must return a tables list separated with a comma
62   *
63   * "table1, (table2 left join table3 on table2.key = table3.key), table4"
64   */
65  static public function getFrom($param="")
66  {
67    global $prefixeTable;
68
69    return($prefixeTable."amd_images_tags pait
70                            LEFT JOIN ".$prefixeTable."amd_used_tags paut
71                            ON pait.numId = paut.numId ");
72  }
73
74  /**
75   * the getWhere function must return a ready to use where clause
76   *
77   * "(att1 = value0 OR att2 = value1) AND att4 LIKE value2 "
78   */
79  static public function getWhere($param="")
80  {
81    switch($param['conditionIf'])
82    {
83      case 'E':
84        $returned="pait.numId = ".$param['metaNumId'];
85        break;
86      case '!E':
87        $returned="pait.numId = ".$param['metaNumId'];
88        break;
89      case '=':
90        $returned="pait.numId = ".$param['metaNumId']." AND ";
91
92        $tmp=array();
93        foreach($param['listValues'] as $key=>$val)
94        {
95          $tmp[]="pait.value = '".$val."'";
96        }
97        $returned.="(".implode(' OR ', $tmp).")";
98        break;
99      case '!=':
100        $returned="pait.numId = ".$param['metaNumId']." AND NOT ";
101
102        $tmp=array();
103        foreach($param['listValues'] as $key=>$val)
104        {
105          $tmp[]="pait.value = '".$val."'";
106        }
107        $returned.="(".implode(' OR ', $tmp).")";
108        break;
109      case '%':
110        $returned="pait.numId = ".$param['metaNumId']." AND ";
111
112        $tmp=array();
113        foreach($param['listValues'] as $key=>$val)
114        {
115          $tmp[]="pait.value LIKE '%".$val."%'";
116        }
117        $returned.="(".implode(' OR ', $tmp).")";
118        break;
119      case '!%':
120        $returned="pait.numId = ".$param['metaNumId']." AND NOT ";
121
122        $tmp=array();
123        foreach($param['listValues'] as $key=>$val)
124        {
125          $tmp[]="pait.value LIKE '%".$val."%'";
126        }
127        $returned.="(".implode(' OR ', $tmp).")";
128        break;
129      case '^%':
130        $returned="pait.numId = ".$param['metaNumId']." AND ";
131
132        $tmp=array();
133        foreach($param['listValues'] as $key=>$val)
134        {
135          $tmp[]="pait.value LIKE '".$val."%'";
136        }
137        $returned.="(".implode(' OR ', $tmp).")";
138        break;
139      case '!^%':
140        $returned="pait.numId = ".$param['metaNumId']." AND NOT ";
141
142        $tmp=array();
143        foreach($param['listValues'] as $key=>$val)
144        {
145          $tmp[]="pait.value LIKE '".$val."%'";
146        }
147        $returned.="(".implode(' OR ', $tmp).")";
148        break;
149      case '$%':
150        $returned="pait.numId = ".$param['metaNumId']." AND ";
151
152        $tmp=array();
153        foreach($param['listValues'] as $key=>$val)
154        {
155          $tmp[]="pait.value LIKE '%".$val."'";
156        }
157        $returned.="(".implode(' OR ', $tmp).")";
158        break;
159      case '!$%':
160        $returned="pait.numId = ".$param['metaNumId']." AND NOT ";
161
162        $tmp=array();
163        foreach($param['listValues'] as $key=>$val)
164        {
165          $tmp[]="pait.value LIKE '%".$val."'";
166        }
167        $returned.="(".implode(' OR ', $tmp).")";
168        break;
169    }
170
171    return($returned);
172  }
173
174  /**
175   * the getJoin function must return a ready to use where allowing to join the
176   * IMAGES table (key : id) with given conditions
177   *
178   * "att3 = pit.id "
179   */
180  static public function getJoin($param="")
181  {
182    return("pit.id = pait.imageId");
183  }
184
185
186  /**
187   * the getFilter function must return a ready to use where clause
188   * this where clause is used to filter the cache when the used tables can
189   * return more than one result
190   *
191   * the filter is equal to the where clause, or is equal to a part of the where
192   * clause
193   *
194   */
195  static public function getFilter($param="")
196  {
197    return("pait.numId = ".$param['metaNumId']);
198  }
199
200
201  /**
202   * this function is called by the request builder, allowing to display plugin
203   * data with a specific format
204   *
205   * @param Array $attributes : array of ('attribute_name' => 'attribute_value')
206   * @return String : HTML formatted value
207   */
208  static public function formatData($attributes)
209  {
210    /* attributes is an array :
211     *    Array(
212     *      'amdValue' => 'value1#sep#value2#...#sep#valueN'
213     *      'amdTagId' => 'tagId1#sep#tagId2#...#sep#tagIdN'
214     *    );
215     */
216    $returned='';
217
218    $values=explode('#sep#', $attributes['amdValue']);
219    $tagIds=explode('#sep#', $attributes['amdName']);
220
221    foreach($tagIds as $key => $val)
222    {
223      if($returned!='') $returned.='<br>';
224
225      $returned.="<span style='font-weight:bold;'>".L10n::get($val)."</span>&nbsp;:&nbsp;".L10n::get($values[$key]);
226    }
227
228    return($returned);
229  }
230
231
232  /**
233   * this function is called by the request builder to make the search page, and
234   * must return the HTML & JS code of the dialogbox used to select criterion
235   *
236   * Notes :
237   *  - the dialogbox is a JS object with a public method 'show'
238   *  - when the method show is called, one parameter is given by the request
239   *    builder ; the parameter is an object defined as this :
240   *      {
241   *        cBuilder: an instance of the criteriaBuilder object used in the page,
242   *        eventOK : a callback function, called when the OK button is pushed
243   *        id:
244   *      }
245   *
246   *
247   *
248   *
249   * @param String $mode : can take 'admin' or 'public' values, allowing to
250   *                       return different interface if needed
251   * @return String : HTML formatted value
252   */
253  static public function getInterfaceContent($mode='admin')
254  {
255    return(AMD_functions::dialogBoxMetadata());
256  }
257
258  /**
259   * this function returns the label displayed in the criterion menu
260   *
261   * @return String : label displayed in the criterions menu
262   */
263  static public function getInterfaceLabel()
264  {
265    return(l10n('g003_add_metadata'));
266  }
267
268  /**
269   * this function returns the name of the dialog box class
270   *
271   * @return String : name of the dialogbox class
272   */
273  static public function getInterfaceDBClass()
274  {
275    return('dialogChooseMetadataBox');
276  }
277
278}
279
280?>
Note: See TracBrowser for help on using the repository browser.