Changeset 28087 for trunk/include

Timestamp:

Apr 5, 2014, 9:24:27 PM (10 years ago)

Author:

rvelices

Message:

bug 3069: add quick search as filter in batch manager

Location:

trunk/include

Files:

• functions_search.inc.php (modified) (3 diffs)
• ws_functions/pwg.images.php (modified) (16 diffs)

trunk/include/functions_search.inc.php

@@ -1194 +1194 @@
  * @return array
  */
-function get_quick_search_results($q, $super_order_by, $images_where='')
+function get_quick_search_results($q, $options)
 {
   global $conf;
@@ -1255 +1255 @@
   }
 
+  $permissions = !isset($options['permissions']) ? true : $options['permissions'];
+
   $where_clauses = array();
   $where_clauses[]='i.id IN ('. implode(',', $ids) . ')';
-  if (!empty($images_where))
+  if (!empty($options['images_where'))
   {
     $where_clauses[]='('.$images_where.')';
   }
-  $where_clauses[] = get_sql_condition_FandF(
-      array
-        (
-          'forbidden_categories' => 'category_id',
-          'visible_categories' => 'category_id',
-          'visible_images' => 'i.id'
-        ),
-      null,true
-    );
+  if ($permissions)
+  {
+    $where_clauses[] = get_sql_condition_FandF(
+        array
+          (
+            'forbidden_categories' => 'category_id',
+            'visible_categories' => 'category_id',
+            'visible_images' => 'i.id'
+          ),
+        null,true
+      );
+  }
 
   $query = '
-SELECT DISTINCT(id)
-  FROM '.IMAGES_TABLE.' i
-    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
+SELECT DISTINCT(id) FROM '.IMAGES_TABLE.' i';
+  if ($permissions)
+  {
+    $query .= '
+    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id';
+  }
+  $query .= '
   WHERE '.implode("\n AND ", $where_clauses)."\n".
   $conf['order_by'];
@@ -1306 +1315 @@
   else
   {
-    return get_quick_search_results($search['q'], $super_order_by, $images_where);
+    return get_quick_search_results($search['q'], array('super_order_by'=>$super_order_by, 'images_where'=>$images_where) );
   }
 }

trunk/include/ws_functions/pwg.images.php

@@ -295 +295 @@
  *    @option string key
  */
-function ws_images_addComment($params, &$service)
+function ws_images_addComment($params, $service)
 {
   $query = '
@@ -355 +355 @@
  *    @option int comments_per_page
  */
-function ws_images_getInfo($params, &$service)
+function ws_images_getInfo($params, $service)
 {
   global $user, $conf;
@@ -580 +580 @@
  *    @option float rate
  */
-function ws_images_rate($params, &$service)
+function ws_images_rate($params, $service)
 {
   $query = '
@@ -621 +621 @@
  *    @option string order (optional)
  */
-function ws_images_search($params, &$service)
+function ws_images_search($params, $service)
 {
   include_once(PHPWG_ROOT_PATH .'include/functions_search.inc.php');
@@ -639 +639 @@
   $search_result = get_quick_search_results(
     $params['query'],
-    $super_order_by,
-    implode(' AND ', $where_clauses)
+    array(
+      'super_order_by' => $super_order_by,
+      'images_where' => implode(' AND ', $where_clauses)
+    )
     );
 
@@ -705 +707 @@
  *    @option int level
  */
-function ws_images_setPrivacyLevel($params, &$service)
+function ws_images_setPrivacyLevel($params, $service)
 {
   global $conf;
@@ -738 +740 @@
  *    @option int rank
  */
-function ws_images_setRank($params, &$service)
+function ws_images_setRank($params, $service)
 {
   // does the image really exist?
@@ -821 +823 @@
  *    @option int position
  */
-function ws_images_add_chunk($params, &$service)
+function ws_images_add_chunk($params, $service)
 {
   global $conf;
@@ -878 +880 @@
  *    @option string sum
  */
-function ws_images_addFile($params, &$service)
+function ws_images_addFile($params, $service)
 {
   ws_logfile(__FUNCTION__.', input :  '.var_export($params, true));
@@ -971 +973 @@
  *    @option int image_id (optional)
  */
-function ws_images_add($params, &$service)
+function ws_images_add($params, $service)
 {
   global $conf, $user;
@@ -1134 +1136 @@
  *    @option int image_id (optional)
  */
-function ws_images_addSimple($params, &$service)
+function ws_images_addSimple($params, $service)
 {
   global $conf;
@@ -1248 +1250 @@
  *    @option string filename_list (optional)
  */
-function ws_images_exist($params, &$service)
+function ws_images_exist($params, $service)
 {
   ws_logfile(__FUNCTION__.' '.var_export($params, true));
@@ -1321 +1323 @@
  *    @option string file_sum
  */
-function ws_images_checkFiles($params, &$service)
+function ws_images_checkFiles($params, $service)
 {
   ws_logfile(__FUNCTION__.', input :  '.var_export($params, true));
@@ -1393 +1395 @@
  *    @option string multiple_value_mode
  */
-function ws_images_setInfo($params, &$service)
+function ws_images_setInfo($params, $service)
 {
   include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
@@ -1529 +1531 @@
  *    @option string pwg_token
  */
-function ws_images_delete($params, &$service)
+function ws_images_delete($params, $service)
 {
   if (get_pwg_token() != $params['pwg_token'])
@@ -1566 +1568 @@
  * @param mixed[] $params
  */
-function ws_images_checkUpload($params, &$service)
+function ws_images_checkUpload($params, $service)
 {
   include_once(PHPWG_ROOT_PATH.'admin/include/functions_upload.inc.php');